| MANDT |
Client |
CLNT |
3 |
0 |
T000
|
MANDT
|
|
| BUKRS |
Company Code |
CHAR |
4 |
0 |
T001
|
BUKRS
|
|
| RFHA |
Financial Transaction |
CHAR |
13 |
0 |
VTBFHA
|
TB_RFHA
|
|
| RFHAZU |
Transaction Activity |
NUMC |
5 |
0 |
|
TB_RFHAZU
|
|
| DCRDAT |
Entered On |
DATS |
8 |
0 |
|
TB_CRDAT
|
|
| TCRTIM |
Entry Time |
TIMS |
6 |
0 |
|
TB_TCRTIM
|
|
| RFHAZB |
Transaction Flow |
NUMC |
4 |
0 |
|
TB_RFHAZB
|
|
| CRUSER |
Entered By |
CHAR |
12 |
0 |
|
TB_CRUSER
|
|
| UPUSER |
Last Changed By |
CHAR |
12 |
0 |
|
TB_UPUSER
|
|
| DUPDAT |
Changed On |
DATS |
8 |
0 |
|
TB_DUPDAT
|
|
| TUPTIM |
Time Changed |
TIMS |
6 |
0 |
|
TB_TUPTIM
|
|
| RANTYP |
Contract Type |
CHAR |
1 |
0 |
|
RANTYP
|
| 1 |
Loans |
| 2 |
Securities |
| 3 |
Lease-Out - Real Estate |
| 4 |
Foreign Exchange |
| 5 |
Money Market |
| 6 |
Derivatives |
| 7 |
Open Item Transactions |
| 8 |
Administration Contract - Real Estate |
| 9 |
General Contract - Real Estate |
| A |
Internal use only |
| B |
Bank Accounts |
| E |
Exposures |
| T |
Trade Finance |
| V |
Contract Management - Consumer Products |
| X |
External Accounts |
| Y |
Reserved for Customer Enhancements |
| Z |
Reserved for Customer Enhancements |
|
| SFHAZBA |
Flow Type |
CHAR |
4 |
0 |
*
|
TB_SFHAZBA
|
|
| SBKKLAS |
Classification of Flows and Conditions |
CHAR |
1 |
0 |
|
TB_SBKKLAS
|
|
| SBKTYP |
Category of Flows and Conditions |
CHAR |
2 |
0 |
*
|
TB_SBKTYP
|
|
| SBERFIMA |
Calculation category for cash flow calculator |
CHAR |
4 |
0 |
*
|
SBEWFIMA
|
|
| SSIGN |
Direction of Flow |
CHAR |
1 |
0 |
|
TB_SSIGN
|
|
| SHERKUNFT |
Display Area of Flow or Condition |
CHAR |
4 |
0 |
|
TB_SHERK
|
|
| SABVERF |
Procedure for Generating Derived Flows |
CHAR |
5 |
0 |
*
|
TB_SABVERF
|
|
| RKONDGR |
Direction of Transaction |
NUMC |
1 |
0 |
|
TB_RKONDGR
|
|
| RKOND |
Condition |
NUMC |
4 |
0 |
|
TB_KOND
|
|
| DGUEL_KP |
Condition Item Effective From |
DATS |
8 |
0 |
|
DGUEL_KP
|
|
| NSTUFE |
Level number of condition item for recurring payments |
NUMC |
2 |
0 |
|
NSTUFE
|
|
| SKOART |
Condition Type (Smallest Subdivision of Condition Records) |
NUMC |
4 |
0 |
*
|
SKOART
|
|
| RREFKONT |
Obsolete: Accnt Assignment Ref. in Fin. Assets Management |
CHAR |
8 |
0 |
*
|
RREFKONT_OBSOLETE
|
|
| SBZVABW |
Alternative Payment Details Stated in Flow |
CHAR |
1 |
0 |
|
TB_SBZVABW
|
|
| RAHABKI |
Short Key for Own House Bank |
CHAR |
5 |
0 |
*
|
TB_RHABKI
|
|
| RAHKTID |
Short Key for House Bank Account |
CHAR |
5 |
0 |
*
|
TB_RHKTID
|
|
| RPZAHL |
Payer/Payee |
CHAR |
10 |
0 |
|
TB_RPZAHL_NEW
|
|
| RPBANK |
Partner Bank Details |
CHAR |
4 |
0 |
|
TB_RPBANK
|
|
| SZART |
Payment Transaction |
CHAR |
1 |
0 |
|
TB_SZART
|
|
| ZLSCH |
Payment Method |
CHAR |
1 |
0 |
*
|
DZLSCH
|
|
| UZAWE |
Payment method supplement |
CHAR |
2 |
0 |
*
|
UZAWE
|
|
| SPAYRQ |
Generate Payment Request |
CHAR |
1 |
0 |
|
TB_SPAYRQK
|
|
| SPRSNG |
Individual Payment |
CHAR |
1 |
0 |
|
TB_SPRSNGK
|
|
| SPRGRD |
Determine Grouping Definition |
CHAR |
1 |
0 |
|
TB_SPRGRD
|
|
| SCSPAY |
Same Direction Necessary for Joint Payment? |
CHAR |
1 |
0 |
|
TB_SCSPAY
|
|
| ZWELS |
List of Respected Payment Methods |
CHAR |
10 |
0 |
|
DZWELS
|
|
| PAYGR |
Grouping Field for Automatic Payments |
CHAR |
20 |
0 |
|
PAYGR
|
|
| SBEWEBE |
Posting Status of Flow |
CHAR |
1 |
0 |
|
TB_SBEWEBE
|
|
| SSPRGRD |
Reason Why Flow Is Blocked for Posting |
NUMC |
1 |
0 |
|
TB_SSPRGRD
|
|
| SBFREI |
Release Given for Flow to Be Posted? |
CHAR |
1 |
0 |
|
TB_SBFREI
|
|
| SSTORNOBWG |
Flow Reversal in Treasury |
CHAR |
1 |
0 |
|
TB_SBWGSTO
|
|
| PRKEY |
Key Number for Payment Request |
CHAR |
10 |
0 |
*
|
PRQ_KEYNO
|
|
| BELNR |
Document Number of an Accounting Document |
CHAR |
10 |
0 |
|
BELNR_D
|
|
| BELNR2 |
Second Journal Entry No. for Currency Swaps |
CHAR |
10 |
0 |
|
TB_BELNR2
|
|
| GJAHR |
Fiscal Year |
NUMC |
4 |
0 |
|
GJAHR
|
|
| DBUCHUNG |
Posting Date in the Document |
DATS |
8 |
0 |
|
BUDAT
|
|
| DFAELL |
Due Date |
DATS |
8 |
0 |
|
TB_DFAELL
|
|
| DZTERM |
Payment or Delivery Date |
DATS |
8 |
0 |
|
TB_DZTERM
|
|
| BZBETR |
Payment Amount in Payment Currency |
CURR |
13 |
2 |
|
TB_BZBETR
|
|
| WZBETR |
Payment Currency |
CUKY |
5 |
0 |
TCURC
|
TB_WZBETR
|
|
| BHWBETR |
Payment Amount in Local Currency |
CURR |
13 |
2 |
|
TB_HWBETR
|
|
| KHWKURS |
Local Currency Rate |
DEC |
9 |
5 |
|
TB_KHWKURS
|
|
| ASTUECK |
No. of Units for Financial Instruments |
DEC |
15 |
5 |
|
TB_ASTUECK
|
|
| BPRICE |
Price per Unit |
CURR |
13 |
2 |
|
TB_BPRICE
|
|
| WPRICE |
Price Currency |
CUKY |
5 |
0 |
*
|
TB_WPRICE
|
|
| BHWPREIS |
Price in Local Currency |
CURR |
13 |
2 |
|
TB_HWPREIS
|
|
| BINDEX |
Value of a Point |
CURR |
13 |
2 |
|
TB_BINDEX
|
|
| VVBASIS |
Price in Points |
DEC |
11 |
6 |
|
TB_VVBASIS
|
|
| PWKURS |
Price as Percentage Quotation |
DEC |
10 |
7 |
|
TB_PWKURS
|
|
| PRKKURS |
Currency Option Premium with Price in Points |
DEC |
13 |
9 |
|
TI_PRKUR
|
|
| BNWHR |
Nominal Amount |
CURR |
13 |
2 |
|
TB_BNWHR
|
|
| RHANDPL |
Exchange |
CHAR |
10 |
0 |
*
|
VVRHANDPL
|
|
| SKURSART |
Rate/Price Type - Treasury Instruments |
CHAR |
2 |
0 |
|
TI_KURSART
|
|
| DBERVON |
Start of Calculation Period |
DATS |
8 |
0 |
|
DBERVON
|
|
| DBERBIS |
End of Calculation Period |
DATS |
8 |
0 |
|
DBERBIS
|
|
| ATAGE |
Number of Days |
NUMC |
6 |
0 |
|
VVATAGE
|
|
| ABASTAGE |
Number of base days in a calculation period |
NUMC |
6 |
0 |
|
ABASTAGE
|
|
| PKOND |
Percentage rate for condition items |
DEC |
10 |
7 |
|
PKOND
|
|
| DPKOND |
Fixing Date of Percentage Rate from Condition |
DATS |
8 |
0 |
|
VVDPKOND
|
|
| DZFEST |
Interest rate fixing date |
DATS |
8 |
0 |
|
TB_DZFEST
|
|
| SZBMETH |
Interest Calculation Method |
CHAR |
1 |
0 |
|
SZBMETH
|
| 0 |
Not Specified |
| 1 |
360E/360 |
| 2 |
act/360 |
| 3 |
act/365 |
| 4 |
act/366 |
| 5 |
act/actP (ICMA) |
| 6 |
act/actY (ISDA) |
| 7 |
360/360 |
| 8 |
30.42E/360 |
| 9 |
*365.25/360 |
| A |
actW/252 |
| B |
360E/365 |
| C |
365/365 |
| D |
365/360 |
| E |
act/364 |
| F |
360/360 (ISDA) |
| G |
act/actE (AFB) |
| H |
360/365 (ISDA) |
| I |
360E/actY |
| J |
m+act/360 |
| K |
m+30/360 |
| L |
360/360 (German) |
| M |
act/365P |
| N |
act/365L |
| P |
1/1 |
| Q |
act/actEP (AFB) |
| R |
act/365.25 |
| S |
act/365Y |
| T |
act/act[M] |
| U |
actW/actW[M] |
|
| SKALIDWT |
Interest Calendar |
CHAR |
2 |
0 |
|
TFMSKALIDWT
|
|
| BBASIS |
Calculation Base Amount |
CURR |
13 |
2 |
|
BBASIS
|
|
| WBASIS |
Currency of Calculation Basis |
CUKY |
5 |
0 |
TCURC
|
TB_WBASIS
|
|
| JEXPOZINS |
Type of Compound Interest Calculation |
CHAR |
1 |
0 |
|
TFM_SINTCOMP
|
|
Linear Interest Calculation |
| L |
Linear Compound Interest Calculation |
| X |
Exponential Interest Calculation |
|
| SINCL |
Inclusive indicator for beginning and end of a period |
NUMC |
1 |
0 |
|
VVSINCL
|
| 0 |
Start date inclusive/end date exclusive |
| 1 |
Start date exclusive/end date inclusive |
|
| SINCLBIS |
Inclusive Indicator for the End of a Calculation Period |
NUMC |
1 |
0 |
|
VVSINCLBIS
|
|
| SULTBIS |
Month-End Indicator for the End of a Calculation Period |
CHAR |
1 |
0 |
|
VVSULTBIS
|
|
| SEXCLVON |
Exclusive Indicator for the Start of a Calculation Period |
NUMC |
1 |
0 |
|
VVSEXCLVON
|
|
| SULTVON |
Month-End Indicator for Start of a Calculation Period |
CHAR |
1 |
0 |
|
VVSULTVON
|
|
| SAEND |
Change Indicator for FiMa Flow Records |
NUMC |
1 |
0 |
|
TFM_SAEND
|
| 0 |
Can be Changed |
| 1 |
Cannot be Changed |
| 2 |
Due Date and Payment Date Cannot be Changed |
| 3 |
Application Part of Flow Record Cannot be Changed |
| 9 |
To Be Deleted |
|
| DVALUT |
Calculation Date |
DATS |
8 |
0 |
|
DVALUT
|
|
| SVINCL |
Inclusive indicator for value date |
NUMC |
1 |
0 |
|
VVSVINCL
|
|
| SVULT |
Month-End Indicator for Value Date |
CHAR |
1 |
0 |
|
VVSVULT
|
|
| JSOFVERR |
Indicator for Immediate Settlement (Financial Mathematics) |
CHAR |
1 |
0 |
|
TFMSOFVERR
|
|
Settlement According to Condition |
| E |
Clearing on Calculation Date (Interest Calc. Capital Only) |
| P |
Settlement at End of Period |
| Q |
Settlement at Start of Period |
| R |
Settlement on Due Date (Calendar Day) |
| S |
Settlement on Payment Day (Calendar Day) |
| X |
Immediate Settlement |
| Y |
Settlement on Due Date |
| Z |
Settlement on Calculation Date |
|
| DVERRECH |
Settlement date |
DATS |
8 |
0 |
|
VVDVERRECH
|
|
| SINCLVERR |
Inclusive Indicator for Clearing Date |
NUMC |
1 |
0 |
|
VVSINCLVER
|
|
| SULTVERR |
Month-End Indicator for Clearing Date |
CHAR |
1 |
0 |
|
VVSULTVERR
|
|
| SSTORNOMAN |
Manual Reversal of Flows Posted in FI |
CHAR |
1 |
0 |
|
TB_SBWGSTM
|
|
| SSTORNOART |
Type of Manual Reversal of Flows Posted in FI |
CHAR |
2 |
0 |
*
|
TB_SSTOART
|
|
| SBWGARTREF |
Referenced Flow Type |
CHAR |
4 |
0 |
*
|
TB_SBWGREF
|
|
| SKHWFIX |
Indicator for Translation into Local Currency |
CHAR |
1 |
0 |
|
TB_SKHWFIX
|
|
| ZUONR |
Assignment number |
CHAR |
18 |
0 |
|
DZUONR
|
|
| RLDEPO |
Securities Account |
CHAR |
10 |
0 |
|
RLDEPO
|
|
| RANL |
Security Class ID Number |
CHAR |
13 |
0 |
|
VVRANLW
|
|
| RTRBELNR |
Internal Document Number of Derivatives Document |
CHAR |
15 |
0 |
|
TPM_DEDOC_RDOCNRINT
|
|
| BUPRC |
Security Price Without Currency Ref. with Unit Quotation |
DEC |
15 |
6 |
|
TB_BUPRC
|
|
| BPPRC |
Security Price for Percentage Quotation |
DEC |
15 |
6 |
|
TB_BPPRC
|
|
| WBBETR |
Currency of Position Amount |
CUKY |
5 |
0 |
*
|
TB_WBBETR
|
|
| BBBETR |
Amount that Changes the Position |
CURR |
13 |
2 |
|
TB_BBBETR
|
|
| WEBETR |
Price Currency |
CUKY |
5 |
0 |
*
|
TB_WEBETR
|
|
| BEBETR |
Market Value in Quotation Currency |
CURR |
13 |
2 |
|
TB_BEBETR
|
|
| SRUNIT |
Currency Unit of the Rate |
CHAR |
5 |
0 |
*
|
TB_RUNIT
|
|
| KZWKURS |
Payment Currency Rate |
DEC |
9 |
5 |
|
TB_KZWKURS
|
|
| KBWKURS |
Position Currency Rate |
DEC |
9 |
5 |
|
TB_KBWKURS
|
|
| WSBETR |
Currency Key for Currency Conversion: Source Currency |
CUKY |
5 |
0 |
*
|
TB_WFROM
|
|
| DBESTAND |
Position Value Date |
DATS |
8 |
0 |
|
TB_DBESTAND
|
|
| SSTCKKZ |
Accrued interest method |
CHAR |
1 |
0 |
|
SSTCKKZ
|
|
Accrued int. determined automat. acc. to coupon cutting day |
| 0 |
No coupon delivery |
| F |
Traded flat, accrued interest included in price |
| M |
Minus accrued interest |
| O |
No accrued interest, next coupon only partial right |
| P |
Plus accrued interest |
|
| SSTCKTG |
Accrued interest: Daily method |
CHAR |
1 |
0 |
|
SSTCKTG
|
|
| SFLAT |
Indicator 'Traded flat',i.e.no accrued interest calculation |
CHAR |
1 |
0 |
|
VVSFLAT
|
|
| SCOUPON |
Coupon ID for interest and accrued interest calculation |
CHAR |
1 |
0 |
|
VVSCOUPON
|
| 0 |
Next coupon will not be delivered (minus accrued interest) |
| 1 |
Next coupon will be delivered (plus accrued interest) |
| 2 |
Partial right on next coupon, no accrued interest calc. |
| 8 |
Coupon information from coupon date |
| 9 |
No coupon delivery |
|
| DCOUPON |
Coupon date of next delivered coupon |
DATS |
8 |
0 |
|
VVDCOUPON
|
|
| AWKEY |
Reference Key |
CHAR |
20 |
0 |
|
AWKEY
|
|
| INDEX_VALUE |
Index Value (Independent of Basis) |
DEC |
18 |
12 |
|
TIDX_INDEX_VALUE_NO_RATIO
|
|
| SBASIS |
Calculation Base Indicator |
CHAR |
4 |
0 |
*
|
SBASIS
|
|
| REGI_STATE |
Status of Interest Rate Adjustment |
CHAR |
2 |
0 |
|
TB_IRA_REGISTRATION_STATE
|
|
| RPCODE |
Repetitive Code |
CHAR |
20 |
0 |
|
RPCODE
|
|
| RP_TEXT |
Reference Text for Repetitive Code |
CHAR |
50 |
0 |
|
RPCODE_TEXT
|
|
| HEDGE_ID |
Identification for Hedging Relationship |
CHAR |
10 |
0 |
|
TPM_HEDGE_ID
|
|
| DBPERIOD |
Period start |
DATS |
8 |
0 |
|
VVDBPERIOD
|
|
| SPAEXCL |
Exclusive Indicator for Start Date of a Period |
NUMC |
1 |
0 |
|
TFMSPAEXCL
|
|
| SPAULT |
Month-End Indicator for Start Date of a Period |
CHAR |
1 |
0 |
|
TFMSPAULT
|
|
| DEPERIOD |
Period End |
DATS |
8 |
0 |
|
VVDEPERIOD
|
|
| SPEINCL |
Inclusive Indicator for End Date of a Period |
NUMC |
1 |
0 |
|
TFMSPEINCL
|
|
| SPEULT |
Month-End Indicator for End of a Period |
CHAR |
1 |
0 |
|
TFMSPEULT
|
|
| AMMRHY |
Frequency in months |
NUMC |
3 |
0 |
|
AMMRHY
|
|
| PPAYMENT |
Payment Rate |
DEC |
11 |
7 |
|
TFM_PPAYMENT
|
|
| AMMRHYZV |
Interest Settlement Frequency for Exponential Interest Calc. |
NUMC |
2 |
0 |
|
TFM_AMMRHYZV
|
| 00 |
Annual Interest Settlement |
| 01 |
Monthly Interest Settlement |
| 03 |
Quarterly Interest Settlement |
| 06 |
Interest Settlement Every Six Months |
| 52 |
Weekly Interest Settlement |
| 96 |
Daily Interest Settlement (252) |
| 97 |
Daily Interest Settlement (360) |
| 98 |
Daily Interest Settlement (365) |
| 99 |
Continuous Interest Settlement |
|
| LZBKZ |
State Central Bank Indicator |
CHAR |
3 |
0 |
T015L
|
LZBKZ
|
|
| LANDL |
Supplying Country/Region |
CHAR |
3 |
0 |
T005
|
LANDL
|
|
| BDIRTY |
Dirty Price |
CURR |
13 |
2 |
|
TB_BDIRTY
|
|
| BAMOUNTCOMP |
Amount to be Capitalized |
CURR |
13 |
2 |
|
TB_AMOUNTCOMP
|
|
| NOMINAL_ORG_AMT |
Original Nominal Amount |
CURR |
13 |
2 |
|
TB_BNWHR_ORG
|
|
| NOM_FACTOR |
Factor |
DEC |
12 |
9 |
|
RDPT_FACTOR_VAL
|
|
| RLDEPO2 |
Securities Account |
CHAR |
10 |
0 |
*
|
VRLDEPO
|
|
| INDEX_PRICE |
Indicator: Security Price Including Price Index Value |
CHAR |
1 |
0 |
|
TB_INDEX_PRICE
|
|
| FLOWUUID |
Transaction Flow UUID |
RAW |
16 |
0 |
|
TB_FLOWUUID
|
|
| FLAGBYTE1 |
Indicator for Financial Transaction Flow (See Documentation) |
RAW |
1 |
0 |
|
TB_FLAGBYTE1
|
|
| QUANTITY |
Quantity |
QUAN |
13 |
3 |
|
FTR_QUAN
|
|
| UNIT_OF_MEASURE |
Unit of Measure for the Commodity |
UNIT |
3 |
0 |
*
|
TPM_CTY_UOM
|
|
| CONTRACT_PRICE |
Commodity Price |
DEC |
13 |
5 |
|
FTR_COMPRICE
|
|
| SPOT_PRICE |
Commodity Spot Price |
DEC |
13 |
5 |
|
FTR_COMSPOT
|
|
| CONTANGO_BACKWRD |
Commodity Contango / Backwardation |
DEC |
13 |
5 |
|
FTR_CONBACK
|
|
| BPRC_SPOT1 |
Current Spot Rate in Percentage |
DEC |
15 |
6 |
|
TB_BPPRC_SPOT1
|
|
| BPRC_SPOT2 |
Spot Rate at Maturity in Percentage |
DEC |
15 |
6 |
|
TB_BPPRC_SPOT_MAT
|
|
| COST_FWD |
Forward Rate Cost |
DEC |
15 |
6 |
|
TB_COSTFWD
|
|
| INTEREST_FWD |
Forward Rate Interest |
DEC |
15 |
6 |
|
TB_INTERESTFWD
|
|
| REF_FLOWUUID |
Flow Reference (UUID) |
RAW |
16 |
0 |
|
TB_REFFLOWUUID
|
|
| RGATT |
Class |
CHAR |
13 |
0 |
|
TI_RGATT
|
|
| COMMODITY_ID |
Commodity ID (obsolete) |
CHAR |
18 |
0 |
|
TRCO_COMM_ID
|
|
| QUOTATION_NAME |
Quotation Name |
CHAR |
18 |
0 |
|
CPET_QUOTNAME
|
|
| QUOTATION_SOURCE |
Quotation Source |
CHAR |
2 |
0 |
TRCOCC_QUOTSRC
|
TCR_CTY_QUOTSRC
|
|
| QUOTATION_TYPE |
Commodity Quotation Type |
CHAR |
5 |
0 |
TRCOCC_QUOTTYPE
|
TCR_CTY_QUOTTYPE
|
|
| SPREAD |
Commodity Spread |
DEC |
13 |
5 |
|
FTR_COMSPREAD
|
|
| PRICE_CURR_UNIT |
Currency Unit of the Rate |
CHAR |
5 |
0 |
TZUNI
|
TB_RUNIT
|
|
| PRICE_UOM |
Unit of Measure for the Commodity |
UNIT |
3 |
0 |
*
|
TPM_CTY_UOM
|
|
| DIV_PCTC_OTC |
Percentage of Dividend agreed for Payment in OTC Instruments |
DEC |
7 |
4 |
|
TB_DIV_PCTC_OTC
|
|
| TAINTED |
Manipulated Cash Flow |
CHAR |
1 |
0 |
|
TB_TAINTED_CASHFLOW
|
|
Regular Cash Flow |
| X |
Manipulated Cash Flow |
|
| CLEARED |
Clearing at Flow Level |
CHAR |
1 |
0 |
|
FTR_FLOW_CLEARED
|
|
Flow is not cleared |
| X |
Flow is cleared |
|
| DCSID |
Derivative Contract Specification ID |
CHAR |
20 |
0 |
|
TBA_DCSID
|
|
| MIC |
Market Identifier Code |
CHAR |
4 |
0 |
|
TBA_MIC
|
|
| PRICE_TYPE |
Type of Price Quotation |
CHAR |
2 |
0 |
|
TBA_PRICETYPE
|
|
| TIME_TO_MATURITY |
Time to Maturity |
CHAR |
10 |
0 |
|
TBA_TENOR
|
|
| TIMING |
Timing/Periodicity of Commodity Forward Indexes |
NUMC |
2 |
0 |
|
TBA_TIMING
|
| 10 |
Daily |
| 20 |
Weekly |
| 30 |
Monthly |
| 40 |
Quarterly |
| 50 |
Half Yearly |
| 60 |
Yearly |
|
| EXCH_RATE_TYPE |
Exchange Rate Type |
CHAR |
4 |
0 |
*
|
KURST_CURR
|
|
| PRICE_PAYM_CURR |
Commodity Price in Payment Currency |
DEC |
13 |
5 |
|
FTR_COMPRICE_PAYMENT_CURR
|
|
| SPREAD_PAYM_CURR |
Commodity Spread in Payment Currency |
DEC |
13 |
5 |
|
FTR_COMSPREAD_PAYMENT_CURR
|
|
| FX_TRANSLATION |
Defines when quotation crcy is converted into payment crcy |
CHAR |
1 |
0 |
|
FTR_CURRENCY_CONV_POINT_IN_TIM
|
| 1 |
Convert at End of Fixing Period |
| 2 |
Convert per Fixing Date |
|
| MNDID |
Unique Reference to Mandate for each Payee |
CHAR |
35 |
0 |
|
SEPA_MNDID
|
|
| BUGRENZ |
Lower Limit for Amount |
CURR |
23 |
2 |
|
TFMBUGRENZ
|
|
| BOGRENZ |
Upper Limit for Amt |
CURR |
23 |
2 |
|
TFMBOGRENZ
|
|
| SSTAFF |
Type of Scaled Calculation |
NUMC |
1 |
0 |
|
TFMSSTAFF
|
| 0 |
No incremental/interval calculation |
| 1 |
Incremental calculation |
| 2 |
Interval calculation |
|
| LOGIC_RKOND |
Condition Group |
NUMC |
4 |
0 |
|
FTR_COND_GRP
|
|
| RKONDREF |
Condition |
NUMC |
4 |
0 |
|
TB_KOND
|
|
| DGUEL_KPREF |
Condition Item Effective From |
DATS |
8 |
0 |
|
DGUEL_KP
|
|
| PRESENT_DATE |
Presentation Date |
DATS |
8 |
0 |
|
FTR_PRE_DATE
|
|
| INTEREST_PAID_BY |
Identify whether applicant or beneficiary pays interest |
CHAR |
1 |
0 |
|
FTR_INTEREST_PAY_BY
|
|
| SHIPMENT_DATE |
Shipment Date |
DATS |
8 |
0 |
|
FTR_SHIP_DATE
|
|
| STATUS |
Status |
CHAR |
2 |
0 |
|
FTR_STATUS
|
|
| PRESENT_ID |
Presentation Item |
CHAR |
10 |
0 |
|
FTR_PERSENT_ID
|
|
| SSTOGRD |
Reason for Reversal |
CHAR |
2 |
0 |
*
|
SSTOGRD
|
|
| PRESENT_AMOUNT |
Presentation Amount |
CURR |
13 |
2 |
|
FTR_PRESENT_AMT
|
|
| PRESENT_BANK |
Presentation Bank |
CHAR |
10 |
0 |
*
|
FTR_PRESENT_BANK
|
|
| PRESENT_DISCREPANCY |
Discrepancy |
CHAR |
1 |
0 |
|
FTR_DISCREPANCY
|
|
| PRESENT_DECREASE_AMOUNT |
Presentation Decreased Amount |
CURR |
13 |
2 |
|
FTR_PRESENT_DEC_AMT
|
|
| PRESENT_REA_CRE_LINE |
Amount of Released Credit Line |
CURR |
13 |
2 |
|
FTR_PRESENT_REA_AMT
|
|
| PRESENT_PAY_AMT |
Payment Amount in Payment Currency |
CURR |
13 |
2 |
|
TB_BZBETR
|
|
| SROUNDFACTOR |
Rounding Category of a Factor |
CHAR |
1 |
0 |
|
TFM_SROUNDFACTOR
|
|
| ROUNDDECFACTOR |
Number of Rounding Decimal Places for a Factor |
INT1 |
3 |
0 |
|
TFM_ROUNDDECFACTOR
|
|
| JEXPOINTFACTOR |
Exponential Interest Calculation with Factor |
CHAR |
1 |
0 |
|
TFM_JEXPOINTFACTOR
|
|
| FLOWFACTOR |
Flow Factor |
D34R |
34 |
0 |
|
TFM_FLOWFACTOR
|
|
| BASEFACTOR |
Base Factor |
D34R |
34 |
0 |
|
TFM_BASEFACTOR
|
|
| SROUNDBASEFACTOR |
Rounding Category of a Base Factor |
CHAR |
1 |
0 |
|
TFM_SROUNDBASEFACTOR
|
|
| ROUNDDECBASEFACTOR |
Number of Rounding Decimal Places for a Base Factor |
INT1 |
3 |
0 |
|
TFM_ROUNDDECBASEFACTOR
|
|
| SKBWFIX |
Indicator for translation into position currency |
CHAR |
1 |
0 |
|
TB_SKBWFIX
|
|
| GROUPING_TERM |
Grouping Term for Derived Flows |
CHAR |
16 |
0 |
|
TB_DERIV_FLOW_GROUPING
|
|
| SSEQUENCE |
Processing Sequence of Conditions |
NUMC |
2 |
0 |
|
TFM_SEQUENCE
|
|
| SROUNDRATEFACTOR |
Rounding Category of Interest Factor |
CHAR |
1 |
0 |
|
TFM_SROUNDRATEFACTOR
|
|
| ROUNDDECRATEFACTOR |
Number of Rounding Decimal Places for Interest Factor |
INT1 |
3 |
0 |
|
TFM_ROUNDDECRATEFACTOR
|
|
| AAVGDAYS |
No. of Days for Interest Calc. with Average Interest Rate |
INT4 |
10 |
0 |
|
TFM_AAVGDAYS
|
|
| PAVGINTEREST |
Average Interest Rate |
DEC |
15 |
10 |
|
TFM_PAVGINTEREST
|
|
| STGBASIS |
Base Days Method |
CHAR |
1 |
0 |
|
VVSTGBASIS
|
| 1 |
0 |
| 2 |
360 |
| 3 |
365 |
| 4 |
366 |
| 5 |
actP |
| 6 |
actY |
| 7 |
252 |
| 8 |
364 |
| 9 |
actE |
| A |
365P |
| B |
365L |
| C |
actEP |
| D |
1 |
| E |
365.25 |
| F |
365Y |
| G |
act[M] |
| H |
actW[M] |
|
| JAVGCAP |
Use Upper Limit of Average Interest Rate |
CHAR |
1 |
0 |
|
TFM_JAVGCAP
|
|
| PAVGCAP |
Upper Limit of Average Interest Rate |
DEC |
15 |
10 |
|
TFM_PAVGCAP
|
|
| JAVGFLOOR |
Use Lower Limit of Average Interest Rate |
CHAR |
1 |
0 |
|
TFM_JAVGFLOOR
|
|
| PAVGFLOOR |
Lower Limit of Average Interest Rate |
DEC |
15 |
10 |
|
TFM_PAVGFLOOR
|
|
| PAVGSPREAD |
Average Interest Rate Spread |
DEC |
15 |
10 |
|
TFM_PAVGSPREAD
|
|
| SROUNDAVGINTEREST |
Rounding Category of Average Interest Rate |
CHAR |
1 |
0 |
|
TFM_SROUNDAVGINTEREST
|
|
| ROUNDDECAVGINTEREST |
Number of Rounding Decimal Places for Average Interest Rate |
INT1 |
3 |
0 |
|
TFM_ROUNDDECAVGINTEREST
|
|
| AAVGWEIGHT |
Weighting of Interest Rate |
INT4 |
10 |
0 |
|
TFM_AWEIGHT
|
|
| AAVGWEIGHTSUM |
Cumulative Weighting of Interest Rate |
INT4 |
10 |
0 |
|
TFM_AWEIGHTSUM
|
|
| FX_FIXING_DATE |
Fixing Date |
DATS |
8 |
0 |
|
TB_DFIX
|
|
| FX_REGI_STATE |
Status of Rate Fixing |
CHAR |
2 |
0 |
|
FTR_FIXING_REF_REGI_STATE
|
|
| FX_READ_DATE |
Date of the Exchange Rate Read |
DATS |
8 |
0 |
|
FTR_FIXING_REF_READ_DATE
|
|
| PRICEINDEX_FIX_DATE_LOW |
Index Fixing Date |
DATS |
8 |
0 |
|
TFM_INDEX_FIXDATELOW
|
|
| PRICEINDEX_READ_DATE_LOW |
Index Read Date |
DATS |
8 |
0 |
|
TFM_INDEX_READDATE
|
|
| PRICEINDEX_FIX_DATE_HIGH |
Index Fixing Date |
DATS |
8 |
0 |
|
TFM_INDEX_FIXDATEHIGH
|
|
| PRICEINDEX_READ_DATE_HIGH |
Index Read Date |
DATS |
8 |
0 |
|
TFM_INDEX_READDATE
|
|
| PRICEINDEX_REGI_STATE |
Status of Rate Fixing |
CHAR |
2 |
0 |
|
FTR_FIXING_REF_REGI_STATE
|
|
| BBBETR_IDXCLEAN |
Amount Index-Clean that Changes the Position |
CURR |
13 |
2 |
|
TB_BBBETR_IDXCLEAN
|
|
| TRADED_QUANTITY |
OTC Quantity Conversion |
QUAN |
13 |
3 |
|
TBA_TRADED_OTC_QUANTITY
|
|
| TRADED_QUANTITY_UOM |
OTC Quantity Conversion UoM |
UNIT |
3 |
0 |
*
|
TBA_TRADED_QUANTITY_UOM
|
|
| CONV_FACTOR_TRADED_QTY |
Quantity Conversion Factor of Priced OTC Transaction |
DEC |
22 |
8 |
|
TBA_CONV_FACTOR_TRADED_QTY
|
|
| CONV_FACTOR_TRADED_QTY_UOM |
Quantity Conversion Factor of Priced OTC Transaction UoM |
UNIT |
3 |
0 |
*
|
TBA_CONV_FACTOR_TRADED_QTY_UOM
|
|
| CONV_FACTOR_PRICED_QTY |
Quantity Conversion Factor for OTC Transaction |
DEC |
22 |
8 |
|
TBA_CONV_FACTOR_PRICED_QTY
|
|
| CONV_FACTOR_PRICED_QTY_UOM |
Quantity Conversion Factor for OTC Transaction UoM |
UNIT |
3 |
0 |
*
|
TBA_CONV_FACTOR_PRICED_QTY_UOM
|
|
| BKOND |
Condition item currency amount |
CURR |
17 |
2 |
|
TFM_BKOND
|
|
| IB_SCHEDULE_VERSION |
Version Number |
INT8 |
19 |
0 |
|
TRBA_VERSION_NUMBER
|
|
| IDCFM_USHA_TYPE |
Haircut Rate Type |
CHAR |
1 |
0 |
|
IDCFM_USHA_DEL_TYPE
|
|
| IDCFM_USHA_PERC |
Percentage Value |
DEC |
10 |
7 |
|
IDCFM_USHA_DEL_PERC
|
|
| IDCFM_USHA_TOTA |
Enter Haircut Amount in PC |
CURR |
13 |
2 |
|
IDCFM_USHA_DEL_TOTA
|
|
| IDCFM_USHA_CURR |
Currency of Haircut Amount |
CUKY |
5 |
0 |
*
|
IDCFM_USHA_DEL_CURR
|
|
| IDCFM_USHA_FORM |
European Formula Calculation |
CHAR |
1 |
0 |
|
IDCFM_USHA_DEL_FORM
|
|
| XMERK |
Checkbox |
CHAR |
1 |
0 |
|
XFELD
|
|
| XAEND |
Indicator for manual change to amount |
CHAR |
1 |
0 |
|
TB_XAEND
|
|
| XBEWART |
Name of Flow Type |
CHAR |
30 |
0 |
|
XBEWART
|
|
| XZBETR |
Payment amount |
CHAR |
18 |
0 |
|
TB_XZBETR
|
|
| XHWBETR |
Payment amount in local currency |
CHAR |
18 |
0 |
|
TB_XHWBETR
|
|
| XZTERM |
Payment or Delivery Date |
CHAR |
10 |
0 |
|
TB_XZTERM
|
|
| XVALUT |
Calculation date |
CHAR |
10 |
0 |
|
TB_XVALUT
|
|
| XBERVON |
Date of 'Calculation from' |
CHAR |
10 |
0 |
|
TB_XBERVON
|
|
| XSEXCLVON |
Inclusive Indicator for Start of Calculation Period |
CHAR |
1 |
0 |
|
TB_SINCLV
|
|
| XBERBIS |
'Calculation to' date |
CHAR |
10 |
0 |
|
TB_XBERBIS
|
|
| XSINCLBIS |
Inclusive indicator for end of calculation period |
CHAR |
1 |
0 |
|
TB_SINCLB
|
|
| XSVINCL |
End of Term Inclusive Indicator |
CHAR |
1 |
0 |
|
TB_SINCLE
|
|
| XBASIS |
Calculation Base for Conditions |
CHAR |
18 |
0 |
|
TB_XBASIS
|
|
| XKALIDWT |
Name of interest rate calendar |
CHAR |
60 |
0 |
|
TB_XKALIDWT
|
|
| SHWKAKT |
Current rate in local currency |
CHAR |
1 |
0 |
|
TB_SHWKAKT
|
|
| SHWKFIX |
Rate in Local Currency Fixed |
CHAR |
1 |
0 |
|
TB_SHWKFIX
|
|
| SHWBFIX |
Amount in Local Currency Fixed |
CHAR |
1 |
0 |
|
TB_SHWBFIX
|
|
| NINDEX |
Row Index of Internal Tables |
INT4 |
10 |
0 |
|
SYTABIX
|
|
| ZINSREART |
Type of Interest Calculation |
NUMC |
1 |
0 |
|
TFMSINTCALC
|
| 0 |
Linear Interest Calculation |
| 1 |
Exponential Interest Calculation |
| 2 |
Percentage Calculation |
| 3 |
Percentage Calculation per Day |
| 4 |
Exponential Interest Calculation with Factor |
| 5 |
Compound Interest Calculation |
| 6 |
Average Compound Interest Calculation |
| 7 |
Average Linear Interest Calculation |
|
| XNWHR |
Amount as Text Field |
CHAR |
18 |
0 |
|
TM_XBETRAG
|
|
| XSEXCL |
Exclusive Indicator for Calculation Date |
CHAR |
1 |
0 |
|
TB_NOMSEXCL
|
|
| XSVULT |
Month-End Indicator for the Calculation Date |
CHAR |
1 |
0 |
|
TB_NOMSVULT
|
|
| XDIRTY |
Dirty Price as Text Field |
CHAR |
18 |
0 |
|
TM_XDIRTY
|
|