TCORT_CODMD - Deal: Main Data

Deal: Main Data information is stored in SAP table TCORT_CODMD.
It is part of development package FTR_CORRESPONDENCE in software component FIN-FSCM-TRM-TM. This development package consists of objects that can be grouped under "Treasury Correspondence (Confirmations & Matching)".

Fields for table TCORT_CODMD

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
CODMD_UUID	Correspondence Object Deal's main data UUID	X	FTR_CODMDID	RAW	16
.INCLUDE				TCORS_CODMD_INCL	0
COMPANYCODE	CO: Company Code		FTR_CO_BUKRS	CHAR	8
DEAL_NUMBER	Position-Generating Financial Transaction		FTI_POSRFHA	CHAR	26
SE_DEAL_NUMBER	Securities/Futures Transaction		FTI_SE_RFHA	CHAR	26
SIDE	Direction of Transaction		TB_RKONDGR	NUMC	2
REFERENCE_NO	Reference Number (Unit No.)		KL_NR	CHAR	20	*
REFERENCE_TYPE	Reference Category (Unit Category)		KL_TYP	CHAR	6	*
OBJECTNUMBER	Object number		J_OBJNR	CHAR	44	*
CREATE_USER	Entered By		TB_CRUSER	CHAR	24
CREATE_DATE	Entered On		TB_DCRDAT	DATS	16
CREATE_TIME	Entry Time		TB_TCRTIM	TIMS	12
UPDATE_USER	Last Changed By		TB_UPUSER	CHAR	24
UPDATE_DATE	Changed On		TB_DUPDAT	DATS	16
UPDATE_TIME	Time Changed		TB_TUPTIM	TIMS	12
CONTRACT_TYPE	Contract Type		RANTYP	CHAR	2
PRODUCT_CAT	Product Category		SANLF	NUMC	6	*
PRODUCT_TYPE	Product Type		VVSART	CHAR	6
TRANSACTION_CAT	Transaction Category		TB_SFGTYP	NUMC	6	*
ACTIVITY_CAT	Transaction Activity Category		TB_SFGZUTY	NUMC	4
TRANSACTION_TYPE	Financial Transaction Type		TB_SFHAART	CHAR	6
START_TERM	Start of Term		FTI_DBLFZ_DEAL	DATS	16
END_TERM	End of Term		FTI_DELFZ_DEAL	DATS	16
ROLLOVER_TERM	Rollover Date		FTI_ROLLOVER_DEAL	DATS	16
START_INCLUSIVE	Calculation Period: Start Inclusive vs. End Inclusive		FTI_SINCLBE	CHAR	2
END_INCLUSIVE	End of Term Inclusive Indicator		TB_SINCLE	CHAR	2
NOTICE_DATE	OTC Notice Date		TB_NOTICE_DATE	DATS	16
PERIOD_OF_NOTICE	Period of Notice		TB_AKUEND	NUMC	6
PERIOD_OF_NOTICE_UNIT	Unit of Period of Notice		TB_SKUEND	NUMC	2
LIMIT_DATE	Limit Date		TB_LIMITDA	DATS	16
CONTRACT_DATE	Contract Conclusion Date		TB_DVTRAB	DATS	16
CONTRACT_TIME	Time of Contract Conclusion		TB_TVTRAB	TIMS	12
TRADER	Trader		RDEALER	CHAR	24	*
COUNTERPARTY	Counterparty		TB_KONTRH	CHAR	20
CONTACT_PERSON	Contact Person		TB_GSPPART	CHAR	38
GUARANTOR	Guarantor of Financial Transaction		TB_RGARANT_NEW	CHAR	20
EXTERNAL_REFNCE	External Reference		TB_NORDEXT	CHAR	32
PORTFOLIO	Portfolio		RPORTB	CHAR	20	*
FINANCE_PROJECT	Finance Project		TB_TFPROJ	CHAR	26
MASTER_AGREEMENT	Master Agreement		TB_RMAID	CHAR	20
ASSIGNMENT	Assignment		TB_ZUOND	CHAR	36
INTERNAL_REFNCE	Internal Reference		TB_REFER	CHAR	32
CHARACTERISTICS	Characteristics		TB_MERKM	CHAR	50
VALUATION_CLASS	General Valuation Class		TPM_COM_VAL_CLASS	NUMC	8	*
FACILITY_DEALNO	Transaction Number of Facility		TB_FACILITYNR	CHAR	26
FACILITY_CCODE	Company Code of Facility		TB_FACILITYBUKRS	CHAR	8
DEAL_ACTIVE	Active Status of Transaction or Activity		TB_SAKTIV	NUMC	2
RELEASE_STATUS	Transaction Release: Release Status		TB_FRGZUST	CHAR	2
REVERSAL_REASON	Reason for Reversal		SSTOGRD	CHAR	4	*
CONFIRM_STATUS	Confirmation Status		TB_CONF	NUMC	2
CONFIRM_DATE	Confirmation Date		TB_DCONF	DATS	16
CONFIRM_USER	Confirmation Executed By (User Responsible)		TB_UCONF	CHAR	24
CNTRCONFIRM	Counterconfirmation		TB_RECONF	NUMC	2
CNTRCONFIRM_DATE	Counterconfirmation Date		TB_DREDAT	DATS	16
CNTRCONFIRM_USER	Counterconfirmation Executed by (User Responsible)		TB_URENAM	CHAR	24
CURRENCY	Currency of Transaction		FTI_WGSCHFT	CUKY	10	*
CURRENCY_RCV	Currency of Incoming Side of Transaction		FTI_WGSCHF2	CUKY	10	*
CURRENCY_PAY	Currency of Outgoing Side of Transaction		FTI_WGSCHF1	CUKY	10	*
NOM_AMOUNT	Nominal Amount		FTI_NOMAMT	CURR	7
NOM_AMOUNT_RCV	Nominal Amount: Incoming Side of Transaction		FTI_BGSCHF2	CURR	7
NOM_AMOUNT_PAY	Nominal Amount: Outgoing Side of Transaction		FTI_BGSCHF1	CURR	7
UNITS	Units		FTI_POSITIONS_UNITS	DEC	12
LEAD_CURRENCY	Leading Currency		FTI_LWAERS	CUKY	10	*
FOLL_CURRENCY	Following Currency		FTI_FWAERS	CUKY	10	*
RATE	Rate of Foreign Exchange Transaction		TB_KKURS	DEC	7
SPOTRATE	Spot Rate		TB_KKASSA	DEC	7
SWAPRATE	Swap Rate		TB_KSWAP	DEC	7
SECURITY_ACCOUNT	Securities Account		RLDEPO	CHAR	20
SECURITY_ID	Security Class ID Number		VVRANLW	CHAR	26
POSITION_ACCOUNT	Futures Account for Listed Options and Futures		TPM_POS_ACCOUNT_FUT	CHAR	20
COMMODITY_ID	Commodity ID (obsolete)		TRCO_COMM_ID	CHAR	36
QUANTITY_TRADED	Commodity Quantity to Be Delivered		FTI_CTY_QUAN_DELVRD	QUAN	13
COMMODITY_UOM	Unit of Measure for the Commodity		TPM_CTY_UOM	UNIT	6	*
CONTRACT_PRICE	Commodity Contract Price		FTI_CTY_PRICE	DEC	7
CTY_SPOT_PRICE	Commodity spot price		FTI_CTY_SPOT_PRC	DEC	7
CONT_BACK	Commodity Contango / Backwardation		FTR_CONBACK	DEC	7
EFF_INT	Effective Interest Rate		TB_PYIELD	DEC	6
EFF_INT_METHOD	Effective Interest Method (Financial Mathematics)		SEFFMETH	NUMC	2
INT_CAT	Interest Category		FTI_INTTYPE	CHAR	2
INT_CURRENT	Nominal Interest Rate		FTI_NOMINALZINS	DEC	6
INT_REF	Reference Interest Rate		FTI_INTREF	CHAR	20	*
INT_FORMULA	String for Interest Formula		FTI_XINTFORMULA	CHAR	264
INT_STATUS	Interest Fixing Status		FTI_INTSTATUS	CHAR	2
INT_NEXT_FIX	Next Interest Rate Adjustment Date		FTI_NEXT_FIXDATE	DATS	16
INT_NEXT_DUE	Next Interest Due Date		FTI_NEXT_DUEDATE	DATS	16
INT_AMOUNT	Interest Amount		FTI_INTAMOUNT	CURR	11
INT_CURRENCY	Payment Currency		TB_WZBETR	CUKY	10	*
INT_CAT_IN	Interest Category of Incoming Side		FTI_INTTYPE_IN	CHAR	2
INT_CURRENT_IN	Nominal Interest Rate of Incoming Side		FTI_NOMINALZINS_IN	DEC	6
INT_REF_IN	Reference Interest Rate Incoming Side		FTI_INTREF_IN	CHAR	20	*
INT_FORMULA_IN	String for Interest Formula of Incoming Side		FTI_XINTFORMULA_IN	CHAR	264
INT_STATUS_IN	Interest Fixing Status: Incoming Side		FTI_INTSTATUS_IN	CHAR	2
INT_NEXT_FIX_IN	Next Interest Rate Adjustment Date of Incoming Side		FTI_NEXT_FIXDATE_IN	DATS	16
INT_NEXT_DUE_IN	Next Interest Due Date		FTI_NEXT_DUEDATE	DATS	16
INT_AMOUNT_IN	Interest Amount of Incoming Side		FTI_INTAMOUNT_IN	CURR	11
INT_CURRENCY_IN	Payment Currency		TB_WZBETR	CUKY	10	*
INT_CAT_OUT	Interest Category of Outgoing Side		FTI_INTTYPE_OUT	CHAR	2
INT_CURRENT_OUT	Nominal Interest Rate of Outgoing Side		FTI_NOMINALZINS_OUT	DEC	6
INT_REF_OUT	Reference Interest Rate of Outgoing Side		FTI_INTREF_OUT	CHAR	20	*
INT_FORMULA_OUT	String for Interest Formula of Outgoing Side		FTI_XINTFORMULA_OUT	CHAR	264
INT_STATUS_OUT	Interest Fixing Status: Outgoing Side		FTI_INTSTATUS_OUT	CHAR	2
INT_NEXT_FIX_OUT	Next Interest Rate Adjustment Date of Outgoing Side		FTI_NEXT_FIXDATE_OUT	DATS	16
INT_NEXT_DUE_OUT	Next Interest Due Date		FTI_NEXT_DUEDATE	DATS	16
INT_AMOUNT_OUT	Interest Amount of Outgoing Side		FTI_INTAMOUNT_OUT	CURR	11
INT_CURRENCY_OUT	Payment Currency		TB_WZBETR	CUKY	10	*
PUT_CALL	Put/Call Indicator		FTI_SPUTCAL	NUMC	2
EXPIRATION_DATE	Expiration Date (or End of Exercise Period)		FTI_DMATUR	DATS	16
EXPIRATION_LOCATION	Expiry Location		FTR_EXPIRY_LOCATION	CHAR	8	*
EXPIRATION_TIME	Expiry Time		FTR_EXPIRY_TIME	NUMC	8
STRIKE_CURRENCY	Strike Currency of Option/Future		FTI_OFWAERS	CUKY	10	*
STRIKE_AMOUNT	Option Strike Amount		FTI_OSTRIKE	CURR	7
STRIKE_PRICE	Strike Price (Upper Limit for Cap, Lower Limit for Floor)		FTI_STRIKE_PRICE	DEC	6
EXERCISE_TYPE	Exercise Type (American or European)		SOPTAUS	NUMC	2
SETTLEMENT_TYPE	Settlement Indicator		TI_SETTLFL	CHAR	2
OPTION_CATEGORY	Original Option Category (on Closing)		TV_OPTTYP	NUMC	6	*
DIR_STRIKEAMOUNT	Direction of Strike Amount		FTI_OSSIGN	CHAR	2
BARRIER_CATEGORY	Category of Knock-In/Knock-Out Level		TI_SLEVELT	NUMC	4
LEAD_CURR_UL	Leading Currency of Underlying Transaction		FTI_LWAERS_UL	CUKY	10	*
FOLLOW_CURR_UL	Following Currency of Underlying Transaction		FTI_FWAERS_UL	CUKY	10	*
BARRIER	Barrier as Forex Rate for Exotic Options		TX_KWKURB1	DEC	7
BARRIER2	Barrier 2 as Forex Rate for Exotic Options		TX_KWKURB2	DEC	7
PREMIUM_AMT_PYC	Option Premium in Payment Currency		FTI_PREMIUM_PYC	CURR	7
PREMIUM_DATE	Premium Payment Date		FTI_PREMIUM_DATE	DATS	16
POSITION_CCY	Position Currency (Currency of Position Amount)		SBWHR	CUKY	10	*
LOCAL_CCY	Local Currency		TB_SHWHR	CUKY	10	*
NUMBER_TRADED	Traded Number of Units for Unit-Quoted Securities/Futures		FTI_NUMBER_TRADED	DEC	8
NOM_AMT_TRADED	Traded Nominal Amount		FTI_NOMAMT_TRADED	CURR	7
NOMORGAMT_TRADED	Traded Original Nominal Amount		FTI_NOMORGAMT_TRADED	CURR	7
PRICE_TRADED	Traded Price of Security (Mixed Representation)		FTI_PRICE_TRADED	DEC	8
PRICE_CCYUNT	Currency Unit of the Rate		TB_RUNIT	CHAR	10	*
PRICE_CCYUNT_PRC	Quotation Currency Unit / Percent (Mixed Representation)		FTI_QUOT_UNIT_PRCT	CHAR	10
QUOTATION	Quotation type for option, future, security etc.		TB_NOTTYPE	CHAR	2
QUOTATION_CCY	Quotation Currency		FTI_QUOT_CCY	CUKY	10	*
FX_RATE_TO_LC	Local Currency Rate		TB_KHWKURS	DEC	5
HOUSEBNK_IN	Short Key for Own House Bank: Incoming Side		FTI_HBANK_IN	CHAR	10	*
HOUSEBNKACCT_IN	Short Key for House Bank Account: Incoming Side		FTI_HBACCT_IN	CHAR	10	*
PAYER_PAYEE_IN	Payer/Payee of Incoming Side		FTI_PAYERPAYEE_IN	CHAR	20
PARTNERBNK_IN	Partner Bank Details of Incoming Side		FTI_PBANK_IN	CHAR	8
HOUSEBNK_OUT	Short Key for Own House Bank: Outgoing Side		FTI_HBANK_OUT	CHAR	10	*
HOUSEBNKACCT_OUT	Short Key for House Bank Account: Outgoing Side		FTI_HBACCT_OUT	CHAR	10	*
PAYER_PAYEE_OUT	Payer/Payee of Outgoing Side		FTI_PAYERPAYEE_OUT	CHAR	20
PARTNERBNK_OUT	Partner Bank Details of Outgoing Side		FTI_PBANK_OUT	CHAR	8
QUOTATION_NAME	Quotation Name		FTI_QUOTNAME	CHAR	36
QUOTATION_SOURCE	Quotation Source		TCR_CTY_QUOTSRC	CHAR	4	*
QUOTATION_TYPE	Commodity Quotation Type		TCR_CTY_QUOTTYPE	CHAR	10	*
SPREAD	Commodity Spread		FTR_COMSPREAD	DEC	7
COMMODITY_ID1	Commodity ID Outgoing		FTI_COMM_ID_OUT	CHAR	36
QUANTITY_IN	Incoming Commodity Quantity		FTI_QUAN_IN	QUAN	7
UOM_IN	Unit of Measure for Incoming Commodity		FTI_UOM_IN	UNIT	6	*
CTY_PRICE_IN	Incoming Comodity Price		FTI_CTY_PRICE_IN	DEC	7
QUOT_NAME_IN	Incoming Quotation Name		FTI_QUOTNAME_IN	CHAR	36
QUOT_SOURC_IN	Incoming Quotation Source		FTI_QUOTSOURCE_IN	CHAR	4	*
QUOT_TYPE_IN	Incoming Quotation Type		FTI_QUOTTYPE_IN	CHAR	10	*
CTY_SPREAD_IN	Spread Incoming Side		FTI_SPREAD_IN	DEC	6
COMMODITY_ID2	Commodity ID Incoming		FTI_COMM_ID_IN	CHAR	36
QUANTITY_OUT	Outgoing Commodity Quantity		FTI_QUAN_OUT	QUAN	7
UOM_OUT	Unit of Measure for Outgoing Commodity		FTI_UOM_OUT	UNIT	6	*
CTY_PRICE_OUT	Outgoing Commodity Price		FTI_CTY_PRICE_OUT	DEC	7
QUOT_NAME_OUT	Outgoing Quotation Name		FTI_QUOTNAME_OUT	CHAR	36
QUOT_SOURC_OUT	Outgoing Quotation Source		FTI_QUOTSOURCE_OUT	CHAR	4	*
QUOT_TYPE_OUT	Outgoing Quotation Type		FTI_QUOTTYPE_OUT	CHAR	10	*
CTY_SPREAD_OUT	Spread Outgoing Side		FTI_SPREAD_OUT	DEC	6
COMMODITY_ID_UL	Underlying Commodity ID		FTI_CTY_ID_UL	CHAR	36
QUANTITY_UL	Underlying Quantity		FTI_QUAN_UL	QUAN	7
UOM_UL	Underlying Unit of Measure		FTI_UOM_UL	UNIT	6	*
DIV_PCTC_OTC	Percentage of Dividend agreed for Payment in OTC Instruments		TB_DIV_PCTC_OTC	DEC	4
FIXING_DATE	Fixing Date		TB_DFIX	DATS	16
FIXING_REF_ID	Fixing Reference ID		FTR_FIXING_REF_ID	CHAR	60	*
LEGAL_BASIS	Legal Basis		FTR_THRESHOLD_SCHEME	NUMC	4
TRADE_ID	External Trade ID		FTR_TARO_TRADE_ID	CHAR	104
PRE_TRADE_ID	Interim Trade ID		FTR_TARO_PRE_TRADE_ID	CHAR	104
DCSID	Derivative Contract Specification ID		TBA_DCSID	CHAR	40
MIC	Market Identifier Code		TBA_MIC	CHAR	8
PRICE_TYPE	Type of Price Quotation		TBA_PRICETYPE	CHAR	4
TIME_TO_MATURITY	Time to Maturity		TBA_TENOR	CHAR	20
TIMING	Timing/Periodicity of Commodity Forward Indexes		TBA_TIMING	NUMC	4
AVG_PERIOD_START	Averaging Period Start Date		CMM_AP_START	DATS	16
AVG_PERIOD_END	Averaging Period End Date		CMM_AP_END	DATS	16