FTBAST_IB_SCHED

Schedule for Installment Bond | #masterdata | Component: Transaction Manager
Column Name Description
CLIENT Client
DB_KEY Globally Unique Identifier
START_VERSION Version Number
Column Name Description
💲 Currency of the Redemption Schedule (SCHEDULE_CURRENCY):
CURRENT_FACE Current Face
FACE_VALUE_CHANGE Face Value Change
PRINCIPAL_PAYMENT Principal Payment
💲 Currency of Condition Item (SWHRKOND):
BKOND Condition Item Currency Amount
BBASIS Calculation Base Amount
BKONDQM Currency amount per area unit
BMWST Value-added tax amount included
A_AMTMIN Minimum Amount to Be Capitalized
A_AMTMAX Maximum Amount to Be Capitalized
BAUDAMNT Amount
BBASISUNIT Base Unit for Rounding
Column Name Description
Column Name Description
VALID_FROM Entry effective from
DATECAL Field of type DATS
DATEF Field of type DATS
DALLGEM General date
DPKOND Fixing Date of Percentage Rate from Condition
DZSREF Date fixing for benchmark interest rate in cash flow
Column Name Description
SEXCL Exclusive Indicator for the Start of a Calculation Period Show values
SULT Month-End Indicator for Start of a Calculation Period Show values
FACTOR_STATUS Status of Factor Show values
SZSREFVZ +/- sign / reference interest rate operator Show values
SZAWS Payment form (at start of period, mid-period, at period end) Show values
JNULLKON Condition Form Show values
JBMONAT Indicator for calculating amount per month Show values
SINCLCAL Inclusive indicator for beginning and end of a period Show values
SULTCAL Month-End Indicator for the End of a Calculation Period Show values
SINCLF Inclusive indicator for beginning and end of a period Show values
SULTF Month-End Indicator for the End of a Calculation Period Show values
SFKALRI Calculation of periods with flexible valid-to date? Show values
SZBMETH Interest Calculation Method Show values
JSOFVERR Immediate settlement Show values
SVWERK Shift calculation date to working day Show values
SVMETH Method for determining the next value date Show values
SFWERK Shift due date to working day Show values
SFMETH Method for determining the next due date Show values
SZKALRI Calendar direction for interest rate fixing Show values
SZWERK Shift to Working Day for Interest Fixing Date Show values
SRUNDVORF Rounding of interim results for prepayments Show values
SFVMETH Update Method for Calculation Date/Due Date Show values
SDWERK Working Day Shift for Payment Date Show values
SBERECH Grace Period Interest Method Show values
JPROZR Percentage Calculation Show values
SZEITANT Indicator for Pro Rata Temporis Calculations Show values
SFANT Indicator for due date-related FiMa calculations Show values
SFRANZ Shift Due Date Show values
SBASFIX Indicator for fixing calculation base Show values
AVGSTAGEVZ +/- sign for number of working days for value date Show values
AFGSTAGEVZ +/- sign for number of working days for due date Show values
JEXPOZINS Type of Compound Interest Calculation Show values
XCROSS Gross amount indicator Show values
AMMRHYZV Interest Settlement Frequency for Exponential Interest Calc. Show values
SROUNDFACTOR Rounding Category of a Factor Show values
JEXPOINTFACTOR Exponential Interest Calculation with Factor Show values
SROUNDBASEFACTOR Rounding Category of a Base Factor Show values
SROUNDRATEFACTOR Rounding Category of Interest Factor Show values
JAVGCAP Use Upper Limit of Average Interest Rate Show values
JAVGFLOOR Use Lower Limit of Average Interest Rate Show values
SROUNDAVGINTEREST Rounding Category of Average Interest Rate Show values
SAVGWEIGHT Weighting Category of Interest Rate Show values
SFACTORRESET Event for Resetting Factor Calculation Show values
SSCHMETH Calculation Method for Auto Debit Amount Show values
A_PAYDAY Model Calculation: Day of Installment Payment (1-31) Show values
IND_IOAGP Indicator for IOA/GP condition item Show values
SROUND Rounding Category (Round up, Round Down or Number Rounding) Show values
Column Name Description Domain name
END_VERSION Version Number TRBA_VERSION_NUMBER
SECURITY_ID Security Class ID Number WP_RANL
HASH_KEY Hash Key
FACTOR Redemption Factor
SSTATI Status of data record STATI
AMMRHY Frequency in months NUMC03
ATTRHY Frequency in Days NUMC03
RDIVNR Dividend coupon number NUM03
BVTYP Partner bank type BVTYP
RKONT Quota number RKONT
AVGSTAGE Number of working days for value date NUMC2
AFGSTAGE Number of working days to due date NUMC2
SALTKOND Bracket condition for alternative conditions SKONDGRP
SZINSANP Cross-referenced condition grp for interest rate adjustment SKONDGRP
AZGSTAGE Number of working days for interest fixing NUMC2
SKALID3 Calendar ID 3 (valid in connection with calendar ID 1) WFCID
SKALID4 Calendar ID 4 (valid in connection with calendar ID 1) WFCID
SKALID5 Calendar ID 5 (valid in connection with calendar ID 1) WFCID
JGESUCHT Int. indicator for alternative calculations CHAR1
KURS1 Exchange rate KURSF
KBKOND Condition amount independent of currency VVKWKURS2
TXJCD Tax Jurisdiction TXJCD
KOSTL Cost center of internal contract KOSTL
GFZLSCH Payment method for credit memos ZLSCH
SKALIDWT Interest Calendar WFCID
PPAYMENT Payment Rate TFM_PPAYMENT
PKOND2 Percentage Rate for Condition Items DECV5_10
FACTOR_TYPE Factor Type TB_FACTYPE
ROUNDDECFACTOR Number of Rounding Decimal Places for a Factor TFM_ROUNDDECIMALS
ROUNDDECBASEFACTOR Number of Rounding Decimal Places for a Base Factor TFM_ROUNDDECIMALS
ROUNDDECRATEFACTOR Number of Rounding Decimal Places for Interest Factor TFM_ROUNDDECIMALS
PAVGCAP Upper Limit of Average Interest Rate DECV5_10
PAVGFLOOR Lower Limit of Average Interest Rate DECV5_10
PAVGSPREAD Average Interest Rate Spread DECV5_10
ROUNDDECAVGINTEREST Number of Rounding Decimal Places for Average Interest Rate TFM_ROUNDDECIMALS
ADGSTAGE Number of Days for Relative Payment Date Calculation
MNDID Unique Reference to Mandate for each Payee ID035
RBO Business Operation Number (Loans) RBO
STECH_COND Indicator for Technical Program Condition
RCO Bus. Operation No. (Installment Plan Change: Consumer Loan) RBO
GPDAYS Tolerance Days for Grace Period NUM2
DISBRATE Disbursement Rate TD_DISBRATE_CMLCHN
PKOND Percentage rate for condition items DECV3_7
PFLUCT Fluctuation margin DECV3_7
BROUNDUNIT Rounding Unit for Amounts TFMSRUNIT
SFORMREF Formula Reference T_FORMBE
SVARNAME Variable Name T_XFELD04
COND_TYPE Condition Type (Smallest Subdivision of Condition Records) SKOART
LEVEL_NUMBER Level number of condition item for recurring payments NUMC2
ATTR_HASH_KEY Hash Key
Master Data Relations Join Conditions
Tax on sales/purchases code
  • ?
  • ?
  • Tax on sales/purchases code
  • FTBAST_IB_SCHED.[column in domain "MANDT"] == T007A.MANDT
  • FTBAST_IB_SCHED.[column in domain "KALSM_D"] == T007A.KALSM
  • FTBAST_IB_SCHED.MWSKZ == T007A.MWSKZ
Calculation base reference
  • ?
  • Calculation base reference
  • FTBAST_IB_SCHED.[column in domain "RANTYP"] == TZFB.RANTYP
  • FTBAST_IB_SCHED.SBASIS == TZFB.SBASIS
Posting Control Key
  • ?
  • Posting Control Key
  • FTBAST_IB_SCHED.[column in domain "RANTYP"] == TZB09.RANTYP
  • FTBAST_IB_SCHED.SBUST == TZB09.SBUST
Factory calendar FTBAST_IB_SCHED.SKALID == TFACD.IDENT
Calendar ID 2 (valid in connection with calendar ID 1) FTBAST_IB_SCHED.SKALID2 == TFACD.IDENT
Detailed description/Reason key
  • Condition Type (Smallest Subdivision of Condition Records)
  • Detailed identification for condition items
  • ?
  • Client
  • FTBAST_IB_SCHED.COND_TYPE == TZK07.SKOART
  • FTBAST_IB_SCHED.SKOPO == TZK07.SKOPO
  • FTBAST_IB_SCHED.[column in domain "RANTYP"] == TZK07.RANTYP
  • FTBAST_IB_SCHED.CLIENT == TZK07.MANDT
Currency of Condition Item
  • FTBAST_IB_SCHED.CLIENT == TCURC.MANDT
  • FTBAST_IB_SCHED.SWHRKOND == TCURC.WAERS
Generate incoming payment immediately
  • Generate Incoming Payment Immediately
  • ?
  • ?
  • FTBAST_IB_SCHED.SZEGEN == TD21.SZEGEN
  • FTBAST_IB_SCHED.[column in domain "MANDT"] == TD21.MANDT
  • FTBAST_IB_SCHED.[column in domain "RANTYP"] == TD21.RANTYP
Payment form to-the-day
  • ?
  • Payment form with adjustment days
  • FTBAST_IB_SCHED.[column in domain "MANDT"] == TDZW.MANDT
  • FTBAST_IB_SCHED.SZWKEY == TDZW.SZWKEY
Other Relations | to Master Data Relations ↑ Join Conditions
Reference Interest Rate
  • FTBAST_IB_SCHED.CLIENT == T056R.MANDT
  • FTBAST_IB_SCHED.SZSREF == T056R.REFERENZ