| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | BUKRS | Allow NULL? |
| 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | CHAR | (N' ') | No | * | TB_RFHA | Allow NULL? |
| 4 | RFHAZU | Transaction activity | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | TB_RFHAZU | Allow NULL? |
| 5 | DCRDAT | Entered On | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | TB_CRDAT | Allow NULL? |
| 6 | TCRTIM | Entry Time | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | TB_TCRTIM | Allow NULL? |
| 7 | RFHAZB | Transaction flow | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | TB_RFHAZB | Allow NULL? |
| 8 | CRUSER | Entered by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | TB_CRUSER | Allow NULL? |
| 9 | UPUSER | Last Changed by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | TB_UPUSER | Allow NULL? |
| 10 | DUPDAT | Changed on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_DUPDAT | Allow NULL? |
| 11 | TUPTIM | Time changed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TB_TUPTIM | Allow NULL? |
| 12 | RANTYP | Contract Type | char | 1 | 0 | CHAR | (N' ') | Yes | | RANTYP | Allow NULL? |
| 13 | SFHAZBA | Flow Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TZB0A | TB_SFHAZBA | Allow NULL? |
| 14 | SBKKLAS | Classification of flows and conditions | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_SBKKLAS | Allow NULL? |
| 15 | SBKTYP | Category of Flows and Conditions | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | AT07 | TB_SBKTYP | Allow NULL? |
| 16 | SBERFIMA | Calculation category for cash flow calculator | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | AT40 | SBEWFIMA | Allow NULL? |
| 17 | SSIGN | Direction of flow | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_SSIGN | Allow NULL? |
| 18 | SHERKUNFT | Display Area of Flow or Condition | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | TB_SHERK | Allow NULL? |
| 19 | SABVERF | Procedure to Generate Derived Flows | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | AT22 | TB_SABVERF | Allow NULL? |
| 20 | RKONDGR | Direction of Transaction | char | 1 | 0 | NUMC | (N'0') | Yes | | TB_RKONDGR | Allow NULL? |
| 21 | RKOND | Condition | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | TB_KOND | Allow NULL? |
| 22 | DGUEL_KP | Condition Item Valid From | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DGUEL_KP | Allow NULL? |
| 23 | NSTUFE | Level number of condition item for recurring payments | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | NSTUFE | Allow NULL? |
| 24 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | TZK01 | SKOART | Allow NULL? |
| 25 | RREFKONT | Obsolete: Accnt Assignment Ref. in Fin. Assets Management | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | T037S | RREFKONT_OBSOLETE | Allow NULL? |
| 26 | SBZVABW | Alternative payment details stated in flow | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_SBZVABW | Allow NULL? |
| 27 | RAHABKI | Short key for own house bank | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | T012 | TB_RHABKI | Allow NULL? |
| 28 | RAHKTID | Short key for house bank account | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | T012K | TB_RHKTID | Allow NULL? |
| 29 | RPZAHL | Payer/payee | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | TB_RPZAHL_NEW | Allow NULL? |
| 30 | RPBANK | Partner bank details | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | TB_RPBANK | Allow NULL? |
| 31 | SZART | Payment transaction | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_SZART | Allow NULL? |
| 32 | ZLSCH | Payment Method | char | 1 | 0 | CHAR | (N' ') | Yes | T042Z | DZLSCH | Allow NULL? |
| 33 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T042F | UZAWE | Allow NULL? |
| 34 | SPAYRQ | Generate payment request | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_SPAYRQK | Allow NULL? |
| 35 | SPRSNG | Individual payment | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_SPRSNGK | Allow NULL? |
| 36 | SPRGRD | Determine grouping definition | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_SPRGRD | Allow NULL? |
| 37 | SCSPAY | Same direction necessary for joint payment? | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_SCSPAY | Allow NULL? |
| 38 | ZWELS | List of the Payment Methods to be Considered | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | DZWELS | Allow NULL? |
| 39 | PAYGR | Grouping Field for Automatic Payments | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | PAYGR | Allow NULL? |
| 40 | SBEWEBE | Posting Status of Flow | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_SBEWEBE | Allow NULL? |
| 41 | SSPRGRD | Reason Why Flow Is Blocked for Posting | char | 1 | 0 | NUMC | (N'0') | Yes | | TB_SSPRGRD | Allow NULL? |
| 42 | SBFREI | Release Given for Flow to Be Posted? | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_SBFREI | Allow NULL? |
| 43 | SSTORNOBWG | Flow reversal in Treasury | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_SBWGSTO | Allow NULL? |
| 44 | PRKEY | Key Number for Payment Request | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | PRQ_KEYNO | Allow NULL? |
| 45 | BELNR | Accounting Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BELNR_D | Allow NULL? |
| 46 | BELNR2 | Doc. no. of a second accounting doc. for currency swap | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | TB_BELNR2 | Allow NULL? |
| 47 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | GJAHR | Allow NULL? |
| 48 | DBUCHUNG | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT | Allow NULL? |
| 49 | DFAELL | Due date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_DFAELL | Allow NULL? |
| 50 | DZTERM | Payment or Delivery Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_DZTERM | Allow NULL? |
| 51 | BZBETR | Payment amount in payment currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | TB_BZBETR | |
| 52 | WZBETR | Payment Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | TB_WZBETR | Allow NULL? |
| 53 | BHWBETR | Payment Amount in Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | TB_HWBETR | |
| 54 | KHWKURS | Local currency rate | decimal | 9 | 5 | DEC | ((0)) | Yes | | TB_KHWKURS | |
| 55 | ASTUECK | No. of Units for Financial Instruments | decimal | 15 | 5 | DEC | ((0)) | Yes | | TB_ASTUECK | |
| 56 | BPRICE | Price per unit | decimal | 13 | 2 | CURR | ((0)) | Yes | | TB_BPRICE | |
| 57 | WPRICE | Price currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | TB_WPRICE | Allow NULL? |
| 58 | BHWPREIS | Price in local currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | TB_HWPREIS | |
| 59 | BINDEX | Value of a point | decimal | 13 | 2 | CURR | ((0)) | Yes | | TB_BINDEX | |
| 60 | VVBASIS | Price in points | decimal | 11 | 6 | DEC | ((0)) | Yes | | TB_VVBASIS | |
| 61 | PWKURS | Price as percentage quotation | decimal | 10 | 7 | DEC | ((0)) | Yes | | TB_PWKURS | |
| 62 | PRKKURS | Currency option premium with price in points | decimal | 13 | 9 | DEC | ((0)) | Yes | | TI_PRKUR | |
| 63 | BNWHR | Nominal amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | TB_BNWHR | |
| 64 | RHANDPL | Exchange | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TWH01 | VVRHANDPL | Allow NULL? |
| 65 | SKURSART | Rate/Price Type - Treasury Instruments | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TW56 | TI_KURSART | Allow NULL? |
| 66 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DBERVON | Allow NULL? |
| 67 | DBERBIS | End of Calculation Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DBERBIS | Allow NULL? |
| 68 | ATAGE | Number of days | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | VVATAGE | Allow NULL? |
| 69 | ABASTAGE | Number of base days in a calculation period | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | ABASTAGE | Allow NULL? |
| 70 | PKOND | Percentage rate for condition items | decimal | 10 | 7 | DEC | ((0)) | Yes | | PKOND | |
| 71 | DPKOND | Determination date for percentage rate of condition items | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDPKOND | Allow NULL? |
| 72 | DZFEST | Interest rate fixing date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_DZFEST | Allow NULL? |
| 73 | SZBMETH | Interest Calculation Method | char | 1 | 0 | CHAR | (N' ') | Yes | | SZBMETH | Allow NULL? |
| 74 | SKALIDWT | Interest Calendar | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | TFMSKALIDWT | Allow NULL? |
| 75 | BBASIS | Calculation base amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | BBASIS | |
| 76 | WBASIS | Currency of calculation basis | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | TB_WBASIS | Allow NULL? |
| 77 | JEXPOZINS | Exponential Interest Calculation | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_JZINSRE | Allow NULL? |
| 78 | SINCL | Inclusive indicator for beginning and end of a period | char | 1 | 0 | NUMC | (N'0') | Yes | | VVSINCL | Allow NULL? |
| 79 | SINCLBIS | Inclusive Indicator for the End of a Calculation Period | char | 1 | 0 | NUMC | (N'0') | Yes | | VVSINCLBIS | Allow NULL? |
| 80 | SULTBIS | Month-End Indicator for the End of a Calculation Period | char | 1 | 0 | CHAR | (N' ') | Yes | | VVSULTBIS | Allow NULL? |
| 81 | SEXCLVON | Exclusive Indicator for the Start of a Calculation Period | char | 1 | 0 | NUMC | (N'0') | Yes | | VVSEXCLVON | Allow NULL? |
| 82 | SULTVON | Month-End Indicator for Start of a Calculation Period | char | 1 | 0 | CHAR | (N' ') | Yes | | VVSULTVON | Allow NULL? |
| 83 | SAEND | Change Indicator for FiMa Flow Records | char | 1 | 0 | NUMC | (N'0') | Yes | | TFM_SAEND | Allow NULL? |
| 84 | DVALUT | Calculation Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DVALUT | Allow NULL? |
| 85 | SVINCL | Inclusive indicator for value date | char | 1 | 0 | NUMC | (N'0') | Yes | | VVSVINCL | Allow NULL? |
| 86 | SVULT | Month-End Indicator for Value Date | char | 1 | 0 | CHAR | (N' ') | Yes | | VVSVULT | Allow NULL? |
| 87 | JSOFVERR | Indicator for Immediate Settlement (Financial Mathematics) | char | 1 | 0 | CHAR | (N' ') | Yes | | TFMSOFVERR | Allow NULL? |
| 88 | DVERRECH | Settlement date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDVERRECH | Allow NULL? |
| 89 | SINCLVERR | Inclusive Indicator for Clearing Date | char | 1 | 0 | NUMC | (N'0') | Yes | | VVSINCLVER | Allow NULL? |
| 90 | SULTVERR | Month-End Indicator for Clearing Date | char | 1 | 0 | CHAR | (N' ') | Yes | | VVSULTVERR | Allow NULL? |
| 91 | SSTORNOMAN | Manual reversal of flows posted in FI | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_SBWGSTM | Allow NULL? |
| 92 | SSTORNOART | Type of manual reversal of flows posted in FI | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | AT90 | TB_SSTOART | Allow NULL? |
| 93 | SBWGARTREF | Referenced flow type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TZB0A | TB_SBWGREF | Allow NULL? |
| 94 | SKHWFIX | Indicator for translation into local currency | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_SKHWFIX | Allow NULL? |
| 95 | ZUONR | Assignment Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | DZUONR | Allow NULL? |
| 96 | RLDEPO | Securities Account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | RLDEPO | Allow NULL? |
| 97 | RANL | Security ID Number | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | * | VVRANLW | Allow NULL? |
| 98 | RTRBELNR | Internal document number of derivatives document | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | TPM_DEDOC_RDOCNRINT | Allow NULL? |
| 99 | BUPRC | Security Price Without Currency Ref. with Unit Quotation | decimal | 15 | 6 | DEC | ((0)) | Yes | | TB_BUPRC | |
| 100 | BPPRC | Security Price for Percentage Quotation | decimal | 15 | 6 | DEC | ((0)) | Yes | | TB_BPPRC | |
| 101 | WBBETR | Currency of Position Amount | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | TB_WBBETR | Allow NULL? |
| 102 | BBBETR | Amount that Changes the Position | decimal | 13 | 2 | CURR | ((0)) | Yes | | TB_BBBETR | |
| 103 | WEBETR | Price currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | TB_WEBETR | Allow NULL? |
| 104 | BEBETR | Market Value in Quotation Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | TB_BEBETR | |
| 105 | SRUNIT | Currency Unit of the Rate | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | TZUNI | TB_RUNIT | Allow NULL? |
| 106 | KZWKURS | Payment currency rate | decimal | 9 | 5 | DEC | ((0)) | Yes | | TB_KZWKURS | |
| 107 | KBWKURS | Position currency rate | decimal | 9 | 5 | DEC | ((0)) | Yes | | TB_KBWKURS | |
| 108 | WSBETR | Currency Key for Currency Conversion: Source Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | TB_WFROM | Allow NULL? |
| 109 | DBESTAND | Position Value Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_DBESTAND | Allow NULL? |
| 110 | SSTCKKZ | Accrued interest method | char | 1 | 0 | CHAR | (N' ') | Yes | | SSTCKKZ | Allow NULL? |
| 111 | SSTCKTG | Accrued interest: Daily method | char | 1 | 0 | CHAR | (N' ') | Yes | | SSTCKTG | Allow NULL? |
| 112 | SFLAT | Indicator 'Traded flat',i.e.no accrued interest calculation | char | 1 | 0 | CHAR | (N' ') | Yes | | VVSFLAT | Allow NULL? |
| 113 | SCOUPON | Coupon ID for interest and accrued interest calculation | char | 1 | 0 | CHAR | (N' ') | Yes | | VVSCOUPON | Allow NULL? |
| 114 | DCOUPON | Coupon date of next delivered coupon | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDCOUPON | Allow NULL? |
| 115 | AWKEY | Reference Key | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | AWKEY | Allow NULL? |
| 116 | INDEX_VALUE | Index Value (Independent of Basis) | decimal | 18 | 12 | DEC | ((0)) | Yes | | TIDX_INDEX_VALUE_NO_RATIO | |
| 117 | SBASIS | Calculation base indicator | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | SBASIS | Allow NULL? |
| 118 | REGI_STATE | Status of Interest Rate Adjustment | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | TB_IRA_REGISTRATION_STATE | Allow NULL? |
| 119 | RPCODE | Repetitive Code | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | RPCODE | Allow NULL? |
| 120 | RP_TEXT | Reference Text for Repetitive Code | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | RPCODE_TEXT | Allow NULL? |
| 121 | HEDGE_ID | Identification for Hedging Relationship | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | TPM_HEDGE_ID | Allow NULL? |
| 122 | DBPERIOD | Period start | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDBPERIOD | Allow NULL? |
| 123 | SPAEXCL | Exclusive Indicator for Start Date of a Period | char | 1 | 0 | NUMC | (N'0') | Yes | | TFMSPAEXCL | Allow NULL? |
| 124 | SPAULT | Month-End Indicator for Start Date of a Period | char | 1 | 0 | CHAR | (N' ') | Yes | | TFMSPAULT | Allow NULL? |
| 125 | DEPERIOD | Period End | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDEPERIOD | Allow NULL? |
| 126 | SPEINCL | Inclusive Indicator for End Date of a Period | char | 1 | 0 | NUMC | (N'0') | Yes | | TFMSPEINCL | Allow NULL? |
| 127 | SPEULT | Month-End Indicator for End of a Period | char | 1 | 0 | CHAR | (N' ') | Yes | | TFMSPEULT | Allow NULL? |
| 128 | AMMRHY | Frequency in months | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | AMMRHY | Allow NULL? |
| 129 | PPAYMENT | Payment Rate | decimal | 11 | 7 | DEC | ((0)) | Yes | | TFM_PPAYMENT | |
| 130 | AMMRHYZV | Interest Settlement Frequency for Exponential Interest Calc. | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | TFM_AMMRHYZV | Allow NULL? |
| 131 | LZBKZ | State Central Bank Indicator | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T015L | LZBKZ | Allow NULL? |
| 132 | LANDL | Supplying Country | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | LANDL | Allow NULL? |
| 133 | BDIRTY | Dirty Price | decimal | 13 | 2 | CURR | ((0)) | Yes | | TB_BDIRTY | |
| 134 | BAMOUNTCOMP | Amount to be Capitalized | decimal | 13 | 2 | CURR | ((0)) | Yes | | TB_AMOUNTCOMP | |
| 135 | NOMINAL_ORG_AMT | Orignal Nominal Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | TB_BNWHR_ORG | |
| 136 | NOM_FACTOR | Factor | decimal | 12 | 9 | DEC | ((0)) | Yes | | RDPT_FACTOR_VAL | |
| 137 | RLDEPO2 | Securities Account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | VRLDEPO | Allow NULL? |
| 138 | INDEX_PRICE | Indicator: Security Price Including Price Index Value | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_INDEX_PRICE | Allow NULL? |
| 139 | FLOWUUID | Transaction Flow UUID | varbinary | 16 | 0 | RAW | | Yes | | TB_FLOWUUID | |
| 140 | FLAGBYTE1 | Indicator for Financial Transaction Flow (See Documentation) | varbinary | 1 | 0 | RAW | | Yes | | TB_FLAGBYTE1 | |
| 141 | QUANTITY | Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | FTR_QUAN | |
| 142 | UNIT_OF_MEASURE | Unit of Measure for the Commodity | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | TPM_CTY_UOM | Allow NULL? |
| 143 | CONTRACT_PRICE | Commodity Price | decimal | 13 | 5 | DEC | ((0)) | Yes | | FTR_COMPRICE | |
| 144 | SPOT_PRICE | Commodity Spot Price | decimal | 13 | 5 | DEC | ((0)) | Yes | | FTR_COMSPOT | |
| 145 | CONTANGO_BACKWRD | Commodity Contango / Backwardation | decimal | 13 | 5 | DEC | ((0)) | Yes | | FTR_CONBACK | |
| 146 | BPRC_SPOT1 | Current Spot Rate in Percentage | decimal | 15 | 6 | DEC | ((0)) | Yes | | TB_BPPRC_SPOT1 | |
| 147 | BPRC_SPOT2 | Spot Rate at Maturity in Percentage | decimal | 15 | 6 | DEC | ((0)) | Yes | | TB_BPPRC_SPOT_MAT | |
| 148 | COST_FWD | Forward Rate Cost | decimal | 15 | 6 | DEC | ((0)) | Yes | | TB_COSTFWD | |
| 149 | INTEREST_FWD | Forward Rate Interest | decimal | 15 | 6 | DEC | ((0)) | Yes | | TB_INTERESTFWD | |
| 150 | REF_FLOWUUID | Flow Reference (UUID) | varbinary | 16 | 0 | RAW | | Yes | | TB_REFFLOWUUID | |
| 151 | RGATT | Class | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | | TI_RGATT | Allow NULL? |
| 152 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | TRCO_COMM_ID | Allow NULL? |
| 153 | QUOTATION_NAME | Quotation Name | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | CPET_QUOTNAME | Allow NULL? |
| 154 | QUOTATION_SOURCE | Quotation Source | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TRCOCC_QUOTSRC | TCR_CTY_QUOTSRC | Allow NULL? |
| 155 | QUOTATION_TYPE | Commodity Quotation Type | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | TRCOCC_QUOTTYPE | TCR_CTY_QUOTTYPE | Allow NULL? |
| 156 | SPREAD | Commodity Spread | decimal | 13 | 5 | DEC | ((0)) | Yes | | FTR_COMSPREAD | |
| 157 | PRICE_CURR_UNIT | Currency Unit of the Rate | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | TZUNI | TB_RUNIT | Allow NULL? |
| 158 | PRICE_UOM | Unit of Measure for the Commodity | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | TPM_CTY_UOM | Allow NULL? |
| 159 | DIV_PCTC_OTC | Percentage of Dividend agreed for Payment in OTC Instruments | decimal | 7 | 4 | DEC | ((0)) | Yes | | TB_DIV_PCTC_OTC | |
| 160 | TAINTED | Manipulated Cash Flow | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_TAINTED_CASHFLOW | Allow NULL? |
| 161 | CLEARED | Clearing at Flow Level | char | 1 | 0 | CHAR | (N' ') | Yes | | FTR_FLOW_CLEARED | Allow NULL? |
| 162 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | TBA_DCSID | Allow NULL? |
| 163 | MIC | Market Identifier Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | TBA_MIC | Allow NULL? |
| 164 | PRICE_TYPE | Type of Price Quotation | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | TBA_PRICETYPE | Allow NULL? |
| 165 | TIME_TO_MATURITY | Time to Maturity | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | TBA_TENOR | Allow NULL? |
| 166 | TIMING | Timing/Periodicity of Commodity Forward Indexes | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | TBA_TIMING | Allow NULL? |
| 167 | EXCH_RATE_TYPE | Exchange Rate Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | KURST_CURR | Allow NULL? |
| 168 | PRICE_PAYM_CURR | Commodity Price in Payment Currency | decimal | 13 | 5 | DEC | ((0)) | Yes | | FTR_COMPRICE_PAYMENT_CURR | |
| 169 | SPREAD_PAYM_CURR | Commodity Spread in Payment Currency | decimal | 13 | 5 | DEC | ((0)) | Yes | | FTR_COMSPREAD_PAYMENT_CURR | |
| 170 | FX_TRANSLATION | Defines when quotation crcy is converted into payment crcy | char | 1 | 0 | CHAR | (N' ') | Yes | | FTR_CURRENCY_CONV_POINT_IN_TIM | Allow NULL? |
| 171 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | SEPA_MNDID | Allow NULL? |
| 172 | IDCFM_USHA_TYPE | Haircut Rate Type | char | 1 | 0 | CHAR | (N' ') | Yes | | IDCFM_USHA_DEL_TYPE | Allow NULL? |
| 173 | IDCFM_USHA_PERC | Percentage Value | decimal | 10 | 7 | DEC | ((0)) | Yes | | IDCFM_USHA_DEL_PERC | |
| 174 | IDCFM_USHA_TOTA | Enter Haircut Amount in PC | decimal | 13 | 2 | CURR | ((0)) | Yes | | IDCFM_USHA_DEL_TOTA | |
| 175 | IDCFM_USHA_CURR | Currency of Haircut Amount | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | IDCFM_USHA_DEL_CURR | Allow NULL? |
| 176 | IDCFM_USHA_FORM | European Formula Calculation | char | 1 | 0 | CHAR | (N' ') | Yes | | IDCFM_USHA_DEL_FORM | Allow NULL? |
| 177 | BUSTRANSID | Identifier of the Distributor Business Transaction | varbinary | 16 | 0 | RAW | | Yes | | TPM_BUSTRANSID | |
| 178 | MIGR_ERP07 | Flow Status Regarding Migration to ERP 2007 | char | 1 | 0 | CHAR | (N' ') | Yes | | TPM_MIGR_ERP07 | Allow NULL? |
