| 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 | CODMD_UUID | Correspondence Object Deal's main data UUID | varbinary | 16 | 0 | RAW | | No | | FTR_CODMDID | |
| 3 | COMPANYCODE | CO: Company code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FTR_CO_BUKRS | Allow NULL? |
| 4 | DEAL_NUMBER | Position-Generating Financial Transaction | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | * | FTI_POSRFHA | Allow NULL? |
| 5 | SE_DEAL_NUMBER | Securities/Futures Transaction | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | * | FTI_SE_RFHA | Allow NULL? |
| 6 | SIDE | Direction of Transaction | char | 1 | 0 | NUMC | (N'0') | Yes | | TB_RKONDGR | Allow NULL? |
| 7 | REFERENCE_NO | Reference number (unit no.) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KL_NR | Allow NULL? |
| 8 | REFERENCE_TYPE | Reference Category (Unit Category) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | KL_TYP | Allow NULL? |
| 9 | OBJECTNUMBER | Object number | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | J_OBJNR | Allow NULL? |
| 10 | CREATE_USER | Entered by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | TB_CRUSER | Allow NULL? |
| 11 | CREATE_DATE | Entered On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_DCRDAT | Allow NULL? |
| 12 | CREATE_TIME | Entry Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TB_TCRTIM | Allow NULL? |
| 13 | UPDATE_USER | Last Changed by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | TB_UPUSER | Allow NULL? |
| 14 | UPDATE_DATE | Changed on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_DUPDAT | Allow NULL? |
| 15 | UPDATE_TIME | Time changed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TB_TUPTIM | Allow NULL? |
| 16 | CONTRACT_TYPE | Contract Type | char | 1 | 0 | CHAR | (N' ') | Yes | | RANTYP | Allow NULL? |
| 17 | PRODUCT_CAT | Product Category | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | SANLF | Allow NULL? |
| 18 | PRODUCT_TYPE | Product Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | VVSART | Allow NULL? |
| 19 | TRANSACTION_CAT | Transaction Category | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | TB_SFGTYP | Allow NULL? |
| 20 | ACTIVITY_CAT | Transaction Activity Category | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | TB_SFGZUTY | Allow NULL? |
| 21 | TRANSACTION_TYPE | Financial Transaction Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | TB_SFHAART | Allow NULL? |
| 22 | START_TERM | Start of Term | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FTI_DBLFZ_DEAL | Allow NULL? |
| 23 | END_TERM | End of Term | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FTI_DELFZ_DEAL | Allow NULL? |
| 24 | ROLLOVER_TERM | Rollover Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FTI_ROLLOVER_DEAL | Allow NULL? |
| 25 | START_INCLUSIVE | Calculation Period: Start Inclusive vs. End Inclusive | char | 1 | 0 | CHAR | (N' ') | Yes | | FTI_SINCLBE | Allow NULL? |
| 26 | END_INCLUSIVE | End of Term Inclusive Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_SINCLE | Allow NULL? |
| 27 | NOTICE_DATE | OTC Notice Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_NOTICE_DATE | Allow NULL? |
| 28 | LIMIT_DATE | Limit date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_LIMITDA | Allow NULL? |
| 29 | CONTRACT_DATE | Contract Conclusion Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_DVTRAB | Allow NULL? |
| 30 | CONTRACT_TIME | Time of contract conclusion | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TB_TVTRAB | Allow NULL? |
| 31 | TRADER | Trader | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | RDEALER | Allow NULL? |
| 32 | COUNTERPARTY | Counterparty | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | TB_KONTRH | Allow NULL? |
| 33 | CONTACT_PERSON | Contact Person | nvarchar | 19 | 0 | CHAR | (N' ') | Yes | | TB_GSPPART | Allow NULL? |
| 34 | GUARANTOR | Guarantor of Financial Transaction | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | TB_RGARANT_NEW | Allow NULL? |
| 35 | EXTERNAL_REFNCE | External Reference | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | TB_NORDEXT | Allow NULL? |
| 36 | PORTFOLIO | Portfolio | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | RPORTB | Allow NULL? |
| 37 | FINANCE_PROJECT | Finance Project | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | | TB_TFPROJ | Allow NULL? |
| 38 | MASTER_AGREEMENT | Master Agreement | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | TB_RMAID | Allow NULL? |
| 39 | ASSIGNMENT | Assignment | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | TB_ZUOND | Allow NULL? |
| 40 | INTERNAL_REFNCE | Internal Reference | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | TB_REFER | Allow NULL? |
| 41 | CHARACTERISTICS | Characteristics | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | TB_MERKM | Allow NULL? |
| 42 | VALUATION_CLASS | General Valuation Class | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | * | TPM_COM_VAL_CLASS | Allow NULL? |
| 43 | FACILITY_DEALNO | Transaction Number of Facility | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | * | TB_FACILITYNR | Allow NULL? |
| 44 | FACILITY_CCODE | Company Code of Facility | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | TB_FACILITYBUKRS | Allow NULL? |
| 45 | DEAL_ACTIVE | Active Status of Transaction or Activity | char | 1 | 0 | NUMC | (N'0') | Yes | | TB_SAKTIV | Allow NULL? |
| 46 | RELEASE_STATUS | Transaction Release: Release Status | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_FRGZUST | Allow NULL? |
| 47 | REVERSAL_REASON | Reason for Reversal | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | SSTOGRD | Allow NULL? |
| 48 | CONFIRM_STATUS | Confirmation Status | char | 1 | 0 | NUMC | (N'0') | Yes | | TB_CONF | Allow NULL? |
| 49 | CONFIRM_DATE | Confirmation Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_DCONF | Allow NULL? |
| 50 | CONFIRM_USER | Confirmation Executed By (User Responsible) | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | TB_UCONF | Allow NULL? |
| 51 | CNTRCONFIRM | Counterconfirmation | char | 1 | 0 | NUMC | (N'0') | Yes | | TB_RECONF | Allow NULL? |
| 52 | CNTRCONFIRM_DATE | Counterconfirmation Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_DREDAT | Allow NULL? |
| 53 | CNTRCONFIRM_USER | Counterconfirmation Executed by (User Responsible) | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | TB_URENAM | Allow NULL? |
| 54 | CURRENCY | Currency of Transaction | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | FTI_WGSCHFT | Allow NULL? |
| 55 | CURRENCY_RCV | Currency of Incoming Side of Transaction | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | FTI_WGSCHF2 | Allow NULL? |
| 56 | CURRENCY_PAY | Currency of Outgoing Side of Transaction | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | FTI_WGSCHF1 | Allow NULL? |
| 57 | NOM_AMOUNT | Nominal Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | FTI_NOMAMT | |
| 58 | NOM_AMOUNT_RCV | Nominal Amount: Incoming Side of Transaction | decimal | 13 | 2 | CURR | ((0)) | Yes | | FTI_BGSCHF2 | |
| 59 | NOM_AMOUNT_PAY | Nominal Amount: Outgoing Side of Transaction | decimal | 13 | 2 | CURR | ((0)) | Yes | | FTI_BGSCHF1 | |
| 60 | UNITS | Units | decimal | 22 | 6 | DEC | ((0)) | Yes | | FTI_POSITIONS_UNITS | |
| 61 | LEAD_CURRENCY | Leading Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | FTI_LWAERS | Allow NULL? |
| 62 | FOLL_CURRENCY | Following Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | FTI_FWAERS | Allow NULL? |
| 63 | RATE | Rate of Forex Transaction | decimal | 13 | 9 | DEC | ((0)) | Yes | | TB_KKURS | |
| 64 | SPOTRATE | Spot Rate | decimal | 13 | 9 | DEC | ((0)) | Yes | | TB_KKASSA | |
| 65 | SWAPRATE | Swap Rate | decimal | 13 | 9 | DEC | ((0)) | Yes | | TB_KSWAP | |
| 66 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | RLDEPO | Allow NULL? |
| 67 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | * | VVRANLW | Allow NULL? |
| 68 | POSITION_ACCOUNT | Futures Account for Listed Options and Futures | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | TPM_POS_ACCOUNT_FUT | Allow NULL? |
| 69 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | TRCO_COMM_ID | Allow NULL? |
| 70 | QUANTITY_TRADED | Commodity Quantity to Be Delivered | decimal | 25 | 5 | QUAN | ((0)) | Yes | | FTI_CTY_QUAN_DELVRD | |
| 71 | COMMODITY_UOM | Unit of Measure for the Commodity | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | TPM_CTY_UOM | Allow NULL? |
| 72 | CONTRACT_PRICE | Commodity Contract Price | decimal | 13 | 5 | DEC | ((0)) | Yes | | FTI_CTY_PRICE | |
| 73 | CTY_SPOT_PRICE | Commodity spot price | decimal | 13 | 5 | DEC | ((0)) | Yes | | FTI_CTY_SPOT_PRC | |
| 74 | CONT_BACK | Commodity Contango / Backwardation | decimal | 13 | 5 | DEC | ((0)) | Yes | | FTR_CONBACK | |
| 75 | EFF_INT | Effective Interest Rate | decimal | 10 | 7 | DEC | ((0)) | Yes | | TB_PYIELD | |
| 76 | EFF_INT_METHOD | Effective Interest Method (Financial Mathematics) | char | 1 | 0 | NUMC | (N'0') | Yes | | SEFFMETH | Allow NULL? |
| 77 | INT_CAT | Interest Category | char | 1 | 0 | CHAR | (N' ') | Yes | | FTI_INTTYPE | Allow NULL? |
| 78 | INT_CURRENT | Nominal Interest Rate | decimal | 10 | 7 | DEC | ((0)) | Yes | | FTI_NOMINALZINS | |
| 79 | INT_REF | Reference Interest Rate | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FTI_INTREF | Allow NULL? |
| 80 | INT_FORMULA | String for Interest Formula | nvarchar | 132 | 0 | CHAR | (N' ') | Yes | | FTI_XINTFORMULA | Allow NULL? |
| 81 | INT_STATUS | Interest Fixing Status | char | 1 | 0 | CHAR | (N' ') | Yes | | FTI_INTSTATUS | Allow NULL? |
| 82 | INT_NEXT_FIX | Next Interest Rate Adjustment Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FTI_NEXT_FIXDATE | Allow NULL? |
| 83 | INT_NEXT_DUE | Next Interest Due Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FTI_NEXT_DUEDATE | Allow NULL? |
| 84 | INT_AMOUNT | Interest Amount | decimal | 21 | 2 | CURR | ((0)) | Yes | | FTI_INTAMOUNT | |
| 85 | INT_CURRENCY | Payment Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | TB_WZBETR | Allow NULL? |
| 86 | INT_CAT_IN | Interest Category of Incoming Side | char | 1 | 0 | CHAR | (N' ') | Yes | | FTI_INTTYPE_IN | Allow NULL? |
| 87 | INT_CURRENT_IN | Nominal Interest Rate of Incoming Side | decimal | 10 | 7 | DEC | ((0)) | Yes | | FTI_NOMINALZINS_IN | |
| 88 | INT_REF_IN | Reference Interest Rate Incoming Side | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FTI_INTREF_IN | Allow NULL? |
| 89 | INT_FORMULA_IN | String for Interest Formula of Incoming Side | nvarchar | 132 | 0 | CHAR | (N' ') | Yes | | FTI_XINTFORMULA_IN | Allow NULL? |
| 90 | INT_STATUS_IN | Interest Fixing Status: Incoming Side | char | 1 | 0 | CHAR | (N' ') | Yes | | FTI_INTSTATUS_IN | Allow NULL? |
| 91 | INT_NEXT_FIX_IN | Next Interest Rate Adjustment Date of Incoming Side | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FTI_NEXT_FIXDATE_IN | Allow NULL? |
| 92 | INT_NEXT_DUE_IN | Next Interest Due Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FTI_NEXT_DUEDATE | Allow NULL? |
| 93 | INT_AMOUNT_IN | Interest Amount of Incoming Side | decimal | 21 | 2 | CURR | ((0)) | Yes | | FTI_INTAMOUNT_IN | |
| 94 | INT_CURRENCY_IN | Payment Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | TB_WZBETR | Allow NULL? |
| 95 | INT_CAT_OUT | Interest Category of Outgoing Side | char | 1 | 0 | CHAR | (N' ') | Yes | | FTI_INTTYPE_OUT | Allow NULL? |
| 96 | INT_CURRENT_OUT | Nominal Interest Rate of Outgoing Side | decimal | 10 | 7 | DEC | ((0)) | Yes | | FTI_NOMINALZINS_OUT | |
| 97 | INT_REF_OUT | Reference Interest Rate of Outgoing Side | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FTI_INTREF_OUT | Allow NULL? |
| 98 | INT_FORMULA_OUT | String for Interest Formula of Outgoing Side | nvarchar | 132 | 0 | CHAR | (N' ') | Yes | | FTI_XINTFORMULA_OUT | Allow NULL? |
| 99 | INT_STATUS_OUT | Interest Fixing Status: Outgoing Side | char | 1 | 0 | CHAR | (N' ') | Yes | | FTI_INTSTATUS_OUT | Allow NULL? |
| 100 | INT_NEXT_FIX_OUT | Next Interest Rate Adjustment Date of Outgoing Side | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FTI_NEXT_FIXDATE_OUT | Allow NULL? |
| 101 | INT_NEXT_DUE_OUT | Next Interest Due Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FTI_NEXT_DUEDATE | Allow NULL? |
| 102 | INT_AMOUNT_OUT | Interest Amount of Outgoing Side | decimal | 21 | 2 | CURR | ((0)) | Yes | | FTI_INTAMOUNT_OUT | |
| 103 | INT_CURRENCY_OUT | Payment Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | TB_WZBETR | Allow NULL? |
| 104 | PUT_CALL | Put/Call Indicator | char | 1 | 0 | NUMC | (N'0') | Yes | | FTI_SPUTCAL | Allow NULL? |
| 105 | EXPIRATION_DATE | Exercise Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FTI_DMATUR | Allow NULL? |
| 106 | STRIKE_CURRENCY | Strike Currency of Option/Future | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | FTI_OFWAERS | Allow NULL? |
| 107 | STRIKE_AMOUNT | Option Strike Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | FTI_OSTRIKE | |
| 108 | STRIKE_PRICE | Strike Price (Upper Limit for Cap, Lower Limit for Floor) | decimal | 10 | 7 | DEC | ((0)) | Yes | | FTI_STRIKE_PRICE | |
| 109 | EXERCISE_TYPE | Exercise Type (American or European) | char | 1 | 0 | NUMC | (N'0') | Yes | | SOPTAUS | Allow NULL? |
| 110 | SETTLEMENT_TYPE | Settlement indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | TI_SETTLFL | Allow NULL? |
| 111 | OPTION_CATEGORY | Original option category (on closing) | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | TV_OPTTYP | Allow NULL? |
| 112 | DIR_STRIKEAMOUNT | Direction of Strike Amount | char | 1 | 0 | CHAR | (N' ') | Yes | | FTI_OSSIGN | Allow NULL? |
| 113 | BARRIER_CATEGORY | Category of Knock-In/Knock-Out Level | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | TI_SLEVELT | Allow NULL? |
| 114 | LEAD_CURR_UL | Leading Currency of Underlying Transaction | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | FTI_LWAERS_UL | Allow NULL? |
| 115 | FOLLOW_CURR_UL | Following Currency of Underlying Transaction | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | FTI_FWAERS_UL | Allow NULL? |
| 116 | BARRIER | Barrier as forex rate for exotic options | decimal | 13 | 9 | DEC | ((0)) | Yes | | TX_KWKURB1 | |
| 117 | BARRIER2 | Barrier 2 as forex rate for exotic options | decimal | 13 | 9 | DEC | ((0)) | Yes | | TX_KWKURB2 | |
| 118 | PREMIUM_AMT_PYC | Option Premium in Payment Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | FTI_PREMIUM_PYC | |
| 119 | PREMIUM_DATE | Premium Payment Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FTI_PREMIUM_DATE | Allow NULL? |
| 120 | POSITION_CCY | Position Currency (Currency of Position Amount) | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | SBWHR | Allow NULL? |
| 121 | LOCAL_CCY | Local Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | TB_SHWHR | Allow NULL? |
| 122 | NUMBER_TRADED | Traded Number of Units for Unit-Quoted Securities/Futures | decimal | 15 | 5 | DEC | ((0)) | Yes | | FTI_NUMBER_TRADED | |
| 123 | NOM_AMT_TRADED | Traded Nominal Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | FTI_NOMAMT_TRADED | |
| 124 | NOMORGAMT_TRADED | Traded Original Nominal Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | FTI_NOMORGAMT_TRADED | |
| 125 | PRICE_TRADED | Traded Price of Security (Mixed Representation) | decimal | 15 | 6 | DEC | ((0)) | Yes | | FTI_PRICE_TRADED | |
| 126 | PRICE_CCYUNT | Currency Unit of the Rate | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | TB_RUNIT | Allow NULL? |
| 127 | PRICE_CCYUNT_PRC | Quotation Currency Unit / Percent (Mixed Representation) | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | FTI_QUOT_UNIT_PRCT | Allow NULL? |
| 128 | QUOTATION | Quotation type for option, future, security etc. | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_NOTTYPE | Allow NULL? |
| 129 | QUOTATION_CCY | Quotation Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | FTI_QUOT_CCY | Allow NULL? |
| 130 | FX_RATE_TO_LC | Local currency rate | decimal | 9 | 5 | DEC | ((0)) | Yes | | TB_KHWKURS | |
| 131 | HOUSEBNK_IN | Short Key for Own House Bank: Incoming Side | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | FTI_HBANK_IN | Allow NULL? |
| 132 | HOUSEBNKACCT_IN | Short Key for House Bank Account: Incoming Side | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | FTI_HBACCT_IN | Allow NULL? |
| 133 | PAYER_PAYEE_IN | Payer/Payee of Incoming Side | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FTI_PAYERPAYEE_IN | Allow NULL? |
| 134 | PARTNERBNK_IN | Partner Bank Details of Incoming Side | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | FTI_PBANK_IN | Allow NULL? |
| 135 | HOUSEBNK_OUT | Short Key for Own House Bank: Outgoing Side | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | FTI_HBANK_OUT | Allow NULL? |
| 136 | HOUSEBNKACCT_OUT | Short Key for House Bank Account: Outgoing Side | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | FTI_HBACCT_OUT | Allow NULL? |
| 137 | PAYER_PAYEE_OUT | Payer/Payee of Outgoing Side | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FTI_PAYERPAYEE_OUT | Allow NULL? |
| 138 | PARTNERBNK_OUT | Partner Bank Details of Outgoing Side | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | FTI_PBANK_OUT | Allow NULL? |
| 139 | QUOTATION_NAME | Quotation Name | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | FTI_QUOTNAME | Allow NULL? |
| 140 | QUOTATION_SOURCE | Quotation Source | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | TCR_CTY_QUOTSRC | Allow NULL? |
| 141 | QUOTATION_TYPE | Commodity Quotation Type | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | TCR_CTY_QUOTTYPE | Allow NULL? |
| 142 | SPREAD | Commodity Spread | decimal | 13 | 5 | DEC | ((0)) | Yes | | FTR_COMSPREAD | |
| 143 | COMMODITY_ID1 | Commodity ID Outgoing | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | FTI_COMM_ID_OUT | Allow NULL? |
| 144 | QUANTITY_IN | Incoming Commodity Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | FTI_QUAN_IN | |
| 145 | UOM_IN | Unit of Measure for Incoming Commodity | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | FTI_UOM_IN | Allow NULL? |
| 146 | CTY_PRICE_IN | Incoming Comodity Price | decimal | 13 | 5 | DEC | ((0)) | Yes | | FTI_CTY_PRICE_IN | |
| 147 | QUOT_NAME_IN | Incoming Quotation Name | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | FTI_QUOTNAME_IN | Allow NULL? |
| 148 | QUOT_SOURC_IN | Incoming Quotation Source | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | FTI_QUOTSOURCE_IN | Allow NULL? |
| 149 | QUOT_TYPE_IN | Incoming Quotation Type | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | FTI_QUOTTYPE_IN | Allow NULL? |
| 150 | CTY_SPREAD_IN | Spread Incoming Side | decimal | 10 | 7 | DEC | ((0)) | Yes | | FTI_SPREAD_IN | |
| 151 | COMMODITY_ID2 | Commodity ID Incoming | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | FTI_COMM_ID_IN | Allow NULL? |
| 152 | QUANTITY_OUT | Outgoing Commodity Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | FTI_QUAN_OUT | |
| 153 | UOM_OUT | Unit of Measure for Outgoing Commodity | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | FTI_UOM_OUT | Allow NULL? |
| 154 | CTY_PRICE_OUT | Outgoing Commodity Price | decimal | 13 | 5 | DEC | ((0)) | Yes | | FTI_CTY_PRICE_OUT | |
| 155 | QUOT_NAME_OUT | Outgoing Quotation Name | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | FTI_QUOTNAME_OUT | Allow NULL? |
| 156 | QUOT_SOURC_OUT | Outgoing Quotation Source | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | FTI_QUOTSOURCE_OUT | Allow NULL? |
| 157 | QUOT_TYPE_OUT | Outgoing Quotation Type | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | FTI_QUOTTYPE_OUT | Allow NULL? |
| 158 | CTY_SPREAD_OUT | Spread Outgoing Side | decimal | 10 | 7 | DEC | ((0)) | Yes | | FTI_SPREAD_OUT | |
| 159 | COMMODITY_ID_UL | Underlying Commodity ID | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | FTI_CTY_ID_UL | Allow NULL? |
| 160 | QUANTITY_UL | Underlying Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | FTI_QUAN_UL | |
| 161 | UOM_UL | Underlying Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | FTI_UOM_UL | Allow NULL? |
| 162 | DIV_PCTC_OTC | Percentage of Dividend agreed for Payment in OTC Instruments | decimal | 7 | 4 | DEC | ((0)) | Yes | | TB_DIV_PCTC_OTC | |
| 163 | FIXING_DATE | Fixing date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_DFIX | Allow NULL? |
| 164 | LEGAL_BASIS | Legal Basis | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | FTR_THRESHOLD_SCHEME | Allow NULL? |
| 165 | TRADE_ID | External Trade ID | nvarchar | 52 | 0 | CHAR | (N' ') | Yes | | FTR_TARO_TRADE_ID | Allow NULL? |
| 166 | PRE_TRADE_ID | Interim Trade ID | nvarchar | 52 | 0 | CHAR | (N' ') | Yes | | FTR_TARO_PRE_TRADE_ID | Allow NULL? |
