SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

Home | ERP 6.0  | TCORT_CODMD
JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Financials :: Financial Supply Chain Management :: Treasury and Risk Management :: Transaction Manager
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TCORT_CODMD1661Deal: Main DataTransaction Manager
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, CODMD_UUID, COMPANYCODE, DEAL_NUMBER, SE_DEAL_NUMBER, SIDE, REFERENCE_NO, REFERENCE_TYPE, OBJECTNUMBER, CREATE_USER, CREATE_DATE, CREATE_TIME, UPDATE_USER, UPDATE_DATE, UPDATE_TIME, CONTRACT_TYPE, PRODUCT_CAT, PRODUCT_TYPE, TRANSACTION_CAT, ACTIVITY_CAT, TRANSACTION_TYPE, START_TERM, END_TERM, ROLLOVER_TERM, START_INCLUSIVE, END_INCLUSIVE, NOTICE_DATE, LIMIT_DATE, CONTRACT_DATE, CONTRACT_TIME, TRADER, COUNTERPARTY, CONTACT_PERSON, GUARANTOR, EXTERNAL_REFNCE, PORTFOLIO, FINANCE_PROJECT, MASTER_AGREEMENT, ASSIGNMENT, INTERNAL_REFNCE, CHARACTERISTICS, VALUATION_CLASS, FACILITY_DEALNO, FACILITY_CCODE, DEAL_ACTIVE, RELEASE_STATUS, REVERSAL_REASON, CONFIRM_STATUS, CONFIRM_DATE, CONFIRM_USER, CNTRCONFIRM, CNTRCONFIRM_DATE, CNTRCONFIRM_USER, CURRENCY, CURRENCY_RCV, CURRENCY_PAY, NOM_AMOUNT, NOM_AMOUNT_RCV, NOM_AMOUNT_PAY, UNITS, LEAD_CURRENCY, FOLL_CURRENCY, RATE, SPOTRATE, SWAPRATE, SECURITY_ACCOUNT, SECURITY_ID, POSITION_ACCOUNT, COMMODITY_ID, QUANTITY_TRADED, COMMODITY_UOM, CONTRACT_PRICE, CTY_SPOT_PRICE, CONT_BACK, EFF_INT, EFF_INT_METHOD, INT_CAT, INT_CURRENT, INT_REF, INT_FORMULA, INT_STATUS, INT_NEXT_FIX, INT_NEXT_DUE, INT_AMOUNT, INT_CURRENCY, INT_CAT_IN, INT_CURRENT_IN, INT_REF_IN, INT_FORMULA_IN, INT_STATUS_IN, INT_NEXT_FIX_IN, INT_NEXT_DUE_IN, INT_AMOUNT_IN, INT_CURRENCY_IN, INT_CAT_OUT, INT_CURRENT_OUT, INT_REF_OUT, INT_FORMULA_OUT, INT_STATUS_OUT, INT_NEXT_FIX_OUT, INT_NEXT_DUE_OUT, INT_AMOUNT_OUT, INT_CURRENCY_OUT, PUT_CALL, EXPIRATION_DATE, STRIKE_CURRENCY, STRIKE_AMOUNT, STRIKE_PRICE, EXERCISE_TYPE, SETTLEMENT_TYPE, OPTION_CATEGORY, DIR_STRIKEAMOUNT, BARRIER_CATEGORY, LEAD_CURR_UL, FOLLOW_CURR_UL, BARRIER, BARRIER2, PREMIUM_AMT_PYC, PREMIUM_DATE, POSITION_CCY, LOCAL_CCY, NUMBER_TRADED, NOM_AMT_TRADED, NOMORGAMT_TRADED, PRICE_TRADED, PRICE_CCYUNT, PRICE_CCYUNT_PRC, QUOTATION, QUOTATION_CCY, FX_RATE_TO_LC, HOUSEBNK_IN, HOUSEBNKACCT_IN, PAYER_PAYEE_IN, PARTNERBNK_IN, HOUSEBNK_OUT, HOUSEBNKACCT_OUT, PAYER_PAYEE_OUT, PARTNERBNK_OUT, QUOTATION_NAME, QUOTATION_SOURCE, QUOTATION_TYPE, SPREAD, COMMODITY_ID1, QUANTITY_IN, UOM_IN, CTY_PRICE_IN, QUOT_NAME_IN, QUOT_SOURC_IN, QUOT_TYPE_IN, CTY_SPREAD_IN, COMMODITY_ID2, QUANTITY_OUT, UOM_OUT, CTY_PRICE_OUT, QUOT_NAME_OUT, QUOT_SOURC_OUT, QUOT_TYPE_OUT, CTY_SPREAD_OUT, COMMODITY_ID_UL, QUANTITY_UL, UOM_UL, DIV_PCTC_OTC, FIXING_DATE, LEGAL_BASIS, TRADE_ID, PRE_TRADE_ID FROM TCORT_CODMD
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2CODMD_UUIDCorrespondence Object Deal's main data UUIDvarbinary160RAWNoFTR_CODMDID
3COMPANYCODECO: Company codenvarchar40CHAR(N' ')Yes*FTR_CO_BUKRS Allow NULL? 
4DEAL_NUMBERPosition-Generating Financial Transactionnvarchar130CHAR(N' ')Yes*FTI_POSRFHA Allow NULL? 
5SE_DEAL_NUMBERSecurities/Futures Transactionnvarchar130CHAR(N' ')Yes*FTI_SE_RFHA Allow NULL? 
6SIDEDirection of Transactionchar10NUMC(N'0')YesTB_RKONDGR Allow NULL? 
7REFERENCE_NOReference number (unit no.)nvarchar100CHAR(N' ')Yes*KL_NR Allow NULL? 
8REFERENCE_TYPEReference Category (Unit Category)nvarchar30CHAR(N' ')Yes*KL_TYP Allow NULL? 
9OBJECTNUMBERObject numbernvarchar220CHAR(N' ')Yes*J_OBJNR Allow NULL? 
10CREATE_USEREntered bynvarchar120CHAR(N' ')YesTB_CRUSER Allow NULL? 
11CREATE_DATEEntered Onnvarchar80DATS(N'00000000')YesTB_DCRDAT Allow NULL? 
12CREATE_TIMEEntry Timenvarchar60TIMS(N'000000')YesTB_TCRTIM Allow NULL? 
13UPDATE_USERLast Changed bynvarchar120CHAR(N' ')YesTB_UPUSER Allow NULL? 
14UPDATE_DATEChanged onnvarchar80DATS(N'00000000')YesTB_DUPDAT Allow NULL? 
15UPDATE_TIMETime changednvarchar60TIMS(N'000000')YesTB_TUPTIM Allow NULL? 
16CONTRACT_TYPEContract Typechar10CHAR(N' ')YesRANTYP Allow NULL? 
17PRODUCT_CATProduct Categorynvarchar30NUMC(N'000')Yes*SANLF Allow NULL? 
18PRODUCT_TYPEProduct Typenvarchar30CHAR(N' ')Yes*VVSART Allow NULL? 
19TRANSACTION_CATTransaction Categorynvarchar30NUMC(N'000')Yes*TB_SFGTYP Allow NULL? 
20ACTIVITY_CATTransaction Activity Categorynvarchar20NUMC(N'00')Yes*TB_SFGZUTY Allow NULL? 
21TRANSACTION_TYPEFinancial Transaction Typenvarchar30CHAR(N' ')Yes*TB_SFHAART Allow NULL? 
22START_TERMStart of Termnvarchar80DATS(N'00000000')YesFTI_DBLFZ_DEAL Allow NULL? 
23END_TERMEnd of Termnvarchar80DATS(N'00000000')YesFTI_DELFZ_DEAL Allow NULL? 
24ROLLOVER_TERMRollover Datenvarchar80DATS(N'00000000')YesFTI_ROLLOVER_DEAL Allow NULL? 
25START_INCLUSIVECalculation Period: Start Inclusive vs. End Inclusivechar10CHAR(N' ')YesFTI_SINCLBE Allow NULL? 
26END_INCLUSIVEEnd of Term Inclusive Indicatorchar10CHAR(N' ')YesTB_SINCLE Allow NULL? 
27NOTICE_DATEOTC Notice Datenvarchar80DATS(N'00000000')YesTB_NOTICE_DATE Allow NULL? 
28LIMIT_DATELimit datenvarchar80DATS(N'00000000')YesTB_LIMITDA Allow NULL? 
29CONTRACT_DATEContract Conclusion Datenvarchar80DATS(N'00000000')YesTB_DVTRAB Allow NULL? 
30CONTRACT_TIMETime of contract conclusionnvarchar60TIMS(N'000000')YesTB_TVTRAB Allow NULL? 
31TRADERTradernvarchar120CHAR(N' ')Yes*RDEALER Allow NULL? 
32COUNTERPARTYCounterpartynvarchar100CHAR(N' ')Yes*TB_KONTRH Allow NULL? 
33CONTACT_PERSONContact Personnvarchar190CHAR(N' ')YesTB_GSPPART Allow NULL? 
34GUARANTORGuarantor of Financial Transactionnvarchar100CHAR(N' ')Yes*TB_RGARANT_NEW Allow NULL? 
35EXTERNAL_REFNCEExternal Referencenvarchar160CHAR(N' ')YesTB_NORDEXT Allow NULL? 
36PORTFOLIOPortfolionvarchar100CHAR(N' ')Yes*RPORTB Allow NULL? 
37FINANCE_PROJECTFinance Projectnvarchar130CHAR(N' ')YesTB_TFPROJ Allow NULL? 
38MASTER_AGREEMENTMaster Agreementnvarchar100CHAR(N' ')Yes*TB_RMAID Allow NULL? 
39ASSIGNMENTAssignmentnvarchar180CHAR(N' ')YesTB_ZUOND Allow NULL? 
40INTERNAL_REFNCEInternal Referencenvarchar160CHAR(N' ')YesTB_REFER Allow NULL? 
41CHARACTERISTICSCharacteristicsnvarchar250CHAR(N' ')YesTB_MERKM Allow NULL? 
42VALUATION_CLASSGeneral Valuation Classnvarchar40NUMC(N'0000')Yes*TPM_COM_VAL_CLASS Allow NULL? 
43FACILITY_DEALNOTransaction Number of Facilitynvarchar130CHAR(N' ')Yes*TB_FACILITYNR Allow NULL? 
44FACILITY_CCODECompany Code of Facilitynvarchar40CHAR(N' ')Yes*TB_FACILITYBUKRS Allow NULL? 
45DEAL_ACTIVEActive Status of Transaction or Activitychar10NUMC(N'0')YesTB_SAKTIV Allow NULL? 
46RELEASE_STATUSTransaction Release: Release Statuschar10CHAR(N' ')YesTB_FRGZUST Allow NULL? 
47REVERSAL_REASONReason for Reversalnvarchar20CHAR(N' ')Yes*SSTOGRD Allow NULL? 
48CONFIRM_STATUSConfirmation Statuschar10NUMC(N'0')YesTB_CONF Allow NULL? 
49CONFIRM_DATEConfirmation Datenvarchar80DATS(N'00000000')YesTB_DCONF Allow NULL? 
50CONFIRM_USERConfirmation Executed By (User Responsible)nvarchar120CHAR(N' ')YesTB_UCONF Allow NULL? 
51CNTRCONFIRMCounterconfirmationchar10NUMC(N'0')YesTB_RECONF Allow NULL? 
52CNTRCONFIRM_DATECounterconfirmation Datenvarchar80DATS(N'00000000')YesTB_DREDAT Allow NULL? 
53CNTRCONFIRM_USERCounterconfirmation Executed by (User Responsible)nvarchar120CHAR(N' ')YesTB_URENAM Allow NULL? 
54CURRENCYCurrency of Transactionnvarchar50CUKY(N' ')Yes*FTI_WGSCHFT Allow NULL? 
55CURRENCY_RCVCurrency of Incoming Side of Transactionnvarchar50CUKY(N' ')Yes*FTI_WGSCHF2 Allow NULL? 
56CURRENCY_PAYCurrency of Outgoing Side of Transactionnvarchar50CUKY(N' ')Yes*FTI_WGSCHF1 Allow NULL? 
57NOM_AMOUNTNominal Amountdecimal132CURR((0))YesFTI_NOMAMT
58NOM_AMOUNT_RCVNominal Amount: Incoming Side of Transactiondecimal132CURR((0))YesFTI_BGSCHF2
59NOM_AMOUNT_PAYNominal Amount: Outgoing Side of Transactiondecimal132CURR((0))YesFTI_BGSCHF1
60UNITSUnitsdecimal226DEC((0))YesFTI_POSITIONS_UNITS
61LEAD_CURRENCYLeading Currencynvarchar50CUKY(N' ')Yes*FTI_LWAERS Allow NULL? 
62FOLL_CURRENCYFollowing Currencynvarchar50CUKY(N' ')Yes*FTI_FWAERS Allow NULL? 
63RATERate of Forex Transactiondecimal139DEC((0))YesTB_KKURS
64SPOTRATESpot Ratedecimal139DEC((0))YesTB_KKASSA
65SWAPRATESwap Ratedecimal139DEC((0))YesTB_KSWAP
66SECURITY_ACCOUNTSecurities Accountnvarchar100CHAR(N' ')Yes*RLDEPO Allow NULL? 
67SECURITY_IDSecurity ID Numbernvarchar130CHAR(N' ')Yes*VVRANLW Allow NULL? 
68POSITION_ACCOUNTFutures Account for Listed Options and Futuresnvarchar100CHAR(N' ')Yes*TPM_POS_ACCOUNT_FUT Allow NULL? 
69COMMODITY_IDCommodity IDnvarchar180CHAR(N' ')YesTRCO_COMM_ID Allow NULL? 
70QUANTITY_TRADEDCommodity Quantity to Be Delivereddecimal255QUAN((0))YesFTI_CTY_QUAN_DELVRD
71COMMODITY_UOMUnit of Measure for the Commoditynvarchar30UNIT(N' ')Yes*TPM_CTY_UOM Allow NULL? 
72CONTRACT_PRICECommodity Contract Pricedecimal135DEC((0))YesFTI_CTY_PRICE
73CTY_SPOT_PRICECommodity spot pricedecimal135DEC((0))YesFTI_CTY_SPOT_PRC
74CONT_BACKCommodity Contango / Backwardationdecimal135DEC((0))YesFTR_CONBACK
75EFF_INTEffective Interest Ratedecimal107DEC((0))YesTB_PYIELD
76EFF_INT_METHODEffective Interest Method (Financial Mathematics)char10NUMC(N'0')YesSEFFMETH Allow NULL? 
77INT_CATInterest Categorychar10CHAR(N' ')YesFTI_INTTYPE Allow NULL? 
78INT_CURRENTNominal Interest Ratedecimal107DEC((0))YesFTI_NOMINALZINS
79INT_REFReference Interest Ratenvarchar100CHAR(N' ')Yes*FTI_INTREF Allow NULL? 
80INT_FORMULAString for Interest Formulanvarchar1320CHAR(N' ')YesFTI_XINTFORMULA Allow NULL? 
81INT_STATUSInterest Fixing Statuschar10CHAR(N' ')YesFTI_INTSTATUS Allow NULL? 
82INT_NEXT_FIXNext Interest Rate Adjustment Datenvarchar80DATS(N'00000000')YesFTI_NEXT_FIXDATE Allow NULL? 
83INT_NEXT_DUENext Interest Due Datenvarchar80DATS(N'00000000')YesFTI_NEXT_DUEDATE Allow NULL? 
84INT_AMOUNTInterest Amountdecimal212CURR((0))YesFTI_INTAMOUNT
85INT_CURRENCYPayment Currencynvarchar50CUKY(N' ')Yes*TB_WZBETR Allow NULL? 
86INT_CAT_INInterest Category of Incoming Sidechar10CHAR(N' ')YesFTI_INTTYPE_IN Allow NULL? 
87INT_CURRENT_INNominal Interest Rate of Incoming Sidedecimal107DEC((0))YesFTI_NOMINALZINS_IN
88INT_REF_INReference Interest Rate Incoming Sidenvarchar100CHAR(N' ')Yes*FTI_INTREF_IN Allow NULL? 
89INT_FORMULA_INString for Interest Formula of Incoming Sidenvarchar1320CHAR(N' ')YesFTI_XINTFORMULA_IN Allow NULL? 
90INT_STATUS_INInterest Fixing Status: Incoming Sidechar10CHAR(N' ')YesFTI_INTSTATUS_IN Allow NULL? 
91INT_NEXT_FIX_INNext Interest Rate Adjustment Date of Incoming Sidenvarchar80DATS(N'00000000')YesFTI_NEXT_FIXDATE_IN Allow NULL? 
92INT_NEXT_DUE_INNext Interest Due Datenvarchar80DATS(N'00000000')YesFTI_NEXT_DUEDATE Allow NULL? 
93INT_AMOUNT_INInterest Amount of Incoming Sidedecimal212CURR((0))YesFTI_INTAMOUNT_IN
94INT_CURRENCY_INPayment Currencynvarchar50CUKY(N' ')Yes*TB_WZBETR Allow NULL? 
95INT_CAT_OUTInterest Category of Outgoing Sidechar10CHAR(N' ')YesFTI_INTTYPE_OUT Allow NULL? 
96INT_CURRENT_OUTNominal Interest Rate of Outgoing Sidedecimal107DEC((0))YesFTI_NOMINALZINS_OUT
97INT_REF_OUTReference Interest Rate of Outgoing Sidenvarchar100CHAR(N' ')Yes*FTI_INTREF_OUT Allow NULL? 
98INT_FORMULA_OUTString for Interest Formula of Outgoing Sidenvarchar1320CHAR(N' ')YesFTI_XINTFORMULA_OUT Allow NULL? 
99INT_STATUS_OUTInterest Fixing Status: Outgoing Sidechar10CHAR(N' ')YesFTI_INTSTATUS_OUT Allow NULL? 
100INT_NEXT_FIX_OUTNext Interest Rate Adjustment Date of Outgoing Sidenvarchar80DATS(N'00000000')YesFTI_NEXT_FIXDATE_OUT Allow NULL? 
101INT_NEXT_DUE_OUTNext Interest Due Datenvarchar80DATS(N'00000000')YesFTI_NEXT_DUEDATE Allow NULL? 
102INT_AMOUNT_OUTInterest Amount of Outgoing Sidedecimal212CURR((0))YesFTI_INTAMOUNT_OUT
103INT_CURRENCY_OUTPayment Currencynvarchar50CUKY(N' ')Yes*TB_WZBETR Allow NULL? 
104PUT_CALLPut/Call Indicatorchar10NUMC(N'0')YesFTI_SPUTCAL Allow NULL? 
105EXPIRATION_DATEExercise Datenvarchar80DATS(N'00000000')YesFTI_DMATUR Allow NULL? 
106STRIKE_CURRENCYStrike Currency of Option/Futurenvarchar50CUKY(N' ')Yes*FTI_OFWAERS Allow NULL? 
107STRIKE_AMOUNTOption Strike Amountdecimal132CURR((0))YesFTI_OSTRIKE
108STRIKE_PRICEStrike Price (Upper Limit for Cap, Lower Limit for Floor)decimal107DEC((0))YesFTI_STRIKE_PRICE
109EXERCISE_TYPEExercise Type (American or European)char10NUMC(N'0')YesSOPTAUS Allow NULL? 
110SETTLEMENT_TYPESettlement indicatorchar10CHAR(N' ')YesTI_SETTLFL Allow NULL? 
111OPTION_CATEGORYOriginal option category (on closing)nvarchar30NUMC(N'000')Yes*TV_OPTTYP Allow NULL? 
112DIR_STRIKEAMOUNTDirection of Strike Amountchar10CHAR(N' ')YesFTI_OSSIGN Allow NULL? 
113BARRIER_CATEGORYCategory of Knock-In/Knock-Out Levelnvarchar20NUMC(N'00')YesTI_SLEVELT Allow NULL? 
114LEAD_CURR_ULLeading Currency of Underlying Transactionnvarchar50CUKY(N' ')Yes*FTI_LWAERS_UL Allow NULL? 
115FOLLOW_CURR_ULFollowing Currency of Underlying Transactionnvarchar50CUKY(N' ')Yes*FTI_FWAERS_UL Allow NULL? 
116BARRIERBarrier as forex rate for exotic optionsdecimal139DEC((0))YesTX_KWKURB1
117BARRIER2Barrier 2 as forex rate for exotic optionsdecimal139DEC((0))YesTX_KWKURB2
118PREMIUM_AMT_PYCOption Premium in Payment Currencydecimal132CURR((0))YesFTI_PREMIUM_PYC
119PREMIUM_DATEPremium Payment Datenvarchar80DATS(N'00000000')YesFTI_PREMIUM_DATE Allow NULL? 
120POSITION_CCYPosition Currency (Currency of Position Amount)nvarchar50CUKY(N' ')Yes*SBWHR Allow NULL? 
121LOCAL_CCYLocal Currencynvarchar50CUKY(N' ')Yes*TB_SHWHR Allow NULL? 
122NUMBER_TRADEDTraded Number of Units for Unit-Quoted Securities/Futuresdecimal155DEC((0))YesFTI_NUMBER_TRADED
123NOM_AMT_TRADEDTraded Nominal Amountdecimal132CURR((0))YesFTI_NOMAMT_TRADED
124NOMORGAMT_TRADEDTraded Original Nominal Amountdecimal132CURR((0))YesFTI_NOMORGAMT_TRADED
125PRICE_TRADEDTraded Price of Security (Mixed Representation)decimal156DEC((0))YesFTI_PRICE_TRADED
126PRICE_CCYUNTCurrency Unit of the Ratenvarchar50CHAR(N' ')Yes*TB_RUNIT Allow NULL? 
127PRICE_CCYUNT_PRCQuotation Currency Unit / Percent (Mixed Representation)nvarchar50CHAR(N' ')YesFTI_QUOT_UNIT_PRCT Allow NULL? 
128QUOTATIONQuotation type for option, future, security etc.char10CHAR(N' ')YesTB_NOTTYPE Allow NULL? 
129QUOTATION_CCYQuotation Currencynvarchar50CUKY(N' ')Yes*FTI_QUOT_CCY Allow NULL? 
130FX_RATE_TO_LCLocal currency ratedecimal95DEC((0))YesTB_KHWKURS
131HOUSEBNK_INShort Key for Own House Bank: Incoming Sidenvarchar50CHAR(N' ')Yes*FTI_HBANK_IN Allow NULL? 
132HOUSEBNKACCT_INShort Key for House Bank Account: Incoming Sidenvarchar50CHAR(N' ')Yes*FTI_HBACCT_IN Allow NULL? 
133PAYER_PAYEE_INPayer/Payee of Incoming Sidenvarchar100CHAR(N' ')Yes*FTI_PAYERPAYEE_IN Allow NULL? 
134PARTNERBNK_INPartner Bank Details of Incoming Sidenvarchar40CHAR(N' ')YesFTI_PBANK_IN Allow NULL? 
135HOUSEBNK_OUTShort Key for Own House Bank: Outgoing Sidenvarchar50CHAR(N' ')Yes*FTI_HBANK_OUT Allow NULL? 
136HOUSEBNKACCT_OUTShort Key for House Bank Account: Outgoing Sidenvarchar50CHAR(N' ')Yes*FTI_HBACCT_OUT Allow NULL? 
137PAYER_PAYEE_OUTPayer/Payee of Outgoing Sidenvarchar100CHAR(N' ')Yes*FTI_PAYERPAYEE_OUT Allow NULL? 
138PARTNERBNK_OUTPartner Bank Details of Outgoing Sidenvarchar40CHAR(N' ')YesFTI_PBANK_OUT Allow NULL? 
139QUOTATION_NAMEQuotation Namenvarchar180CHAR(N' ')YesFTI_QUOTNAME Allow NULL? 
140QUOTATION_SOURCEQuotation Sourcenvarchar20CHAR(N' ')Yes*TCR_CTY_QUOTSRC Allow NULL? 
141QUOTATION_TYPECommodity Quotation Typenvarchar50CHAR(N' ')Yes*TCR_CTY_QUOTTYPE Allow NULL? 
142SPREADCommodity Spreaddecimal135DEC((0))YesFTR_COMSPREAD
143COMMODITY_ID1Commodity ID Outgoingnvarchar180CHAR(N' ')YesFTI_COMM_ID_OUT Allow NULL? 
144QUANTITY_INIncoming Commodity Quantitydecimal133QUAN((0))YesFTI_QUAN_IN
145UOM_INUnit of Measure for Incoming Commoditynvarchar30UNIT(N' ')Yes*FTI_UOM_IN Allow NULL? 
146CTY_PRICE_INIncoming Comodity Pricedecimal135DEC((0))YesFTI_CTY_PRICE_IN
147QUOT_NAME_INIncoming Quotation Namenvarchar180CHAR(N' ')YesFTI_QUOTNAME_IN Allow NULL? 
148QUOT_SOURC_INIncoming Quotation Sourcenvarchar20CHAR(N' ')Yes*FTI_QUOTSOURCE_IN Allow NULL? 
149QUOT_TYPE_INIncoming Quotation Typenvarchar50CHAR(N' ')Yes*FTI_QUOTTYPE_IN Allow NULL? 
150CTY_SPREAD_INSpread Incoming Sidedecimal107DEC((0))YesFTI_SPREAD_IN
151COMMODITY_ID2Commodity ID Incomingnvarchar180CHAR(N' ')YesFTI_COMM_ID_IN Allow NULL? 
152QUANTITY_OUTOutgoing Commodity Quantitydecimal133QUAN((0))YesFTI_QUAN_OUT
153UOM_OUTUnit of Measure for Outgoing Commoditynvarchar30UNIT(N' ')Yes*FTI_UOM_OUT Allow NULL? 
154CTY_PRICE_OUTOutgoing Commodity Pricedecimal135DEC((0))YesFTI_CTY_PRICE_OUT
155QUOT_NAME_OUTOutgoing Quotation Namenvarchar180CHAR(N' ')YesFTI_QUOTNAME_OUT Allow NULL? 
156QUOT_SOURC_OUTOutgoing Quotation Sourcenvarchar20CHAR(N' ')Yes*FTI_QUOTSOURCE_OUT Allow NULL? 
157QUOT_TYPE_OUTOutgoing Quotation Typenvarchar50CHAR(N' ')Yes*FTI_QUOTTYPE_OUT Allow NULL? 
158CTY_SPREAD_OUTSpread Outgoing Sidedecimal107DEC((0))YesFTI_SPREAD_OUT
159COMMODITY_ID_ULUnderlying Commodity IDnvarchar180CHAR(N' ')YesFTI_CTY_ID_UL Allow NULL? 
160QUANTITY_ULUnderlying Quantitydecimal133QUAN((0))YesFTI_QUAN_UL
161UOM_ULUnderlying Unit of Measurenvarchar30UNIT(N' ')Yes*FTI_UOM_UL Allow NULL? 
162DIV_PCTC_OTCPercentage of Dividend agreed for Payment in OTC Instrumentsdecimal74DEC((0))YesTB_DIV_PCTC_OTC
163FIXING_DATEFixing datenvarchar80DATS(N'00000000')YesTB_DFIX Allow NULL? 
164LEGAL_BASISLegal Basisnvarchar20NUMC(N'00')Yes*FTR_THRESHOLD_SCHEME Allow NULL? 
165TRADE_IDExternal Trade IDnvarchar520CHAR(N' ')YesFTR_TARO_TRADE_ID Allow NULL? 
166PRE_TRADE_IDInterim Trade IDnvarchar520CHAR(N' ')YesFTR_TARO_PRE_TRADE_ID Allow NULL? 
NamePrimaryUniqueTypeColumns
TCORT_CODMD~0YesYesCLUSTEREDCODMD_UUID, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy