TCORT_CODFL - Deal: Flows

Deal: Flows information is stored in SAP table TCORT_CODFL.
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_CODFL

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
CODFL_UUID	Correspondence object: Deal flows UUID	X	FTR_CODFLID	RAW	16
CODMD_UUID	Correspondence Object Deal's main data UUID		FTR_CODMDID	RAW	16
.INCLUDE				TCORS_CODFL_INCL	0
COMPANYCODE	Company Code		BUKRS	CHAR	8
DEAL_NUMBER	Position-Generating Financial Transaction		FTI_POSRFHA	CHAR	26
FLOW_NO	Transaction Flow		TB_RFHAZB	NUMC	8
FLOWTYPE	Flow Type		TB_SFHAZBA	CHAR	8	TZB0A
FLOWCLASS	Classification of Flows and Conditions		TB_SBKKLAS	CHAR	2
FLOWCATEGORY	Category of Flows and Conditions		TB_SBKTYP	CHAR	4	*
FLOW_DIRECTION	Direction of Flow		TB_SSIGN	CHAR	2
DIRECTION_TRANS	Direction of Transaction		TB_RKONDGR	NUMC	2
HOUSEBANK	Short Key for Own House Bank		TB_RHABKI	CHAR	10	*
HOUSEBANK_ACC	Short Key for House Bank Account		TB_RHKTID	CHAR	10	*
PAYER_PAYEE	Payer/Payee		TB_RPZAHL_NEW	CHAR	20
PBANK	Partner Bank Details		TB_RPBANK	CHAR	8
PAYMT_TRANS	Payment Transaction		TB_SZART	CHAR	2
PAYMT_METH	Payment Method		DZLSCH	CHAR	2	*
PAYMT_METH_SUPP	Payment method supplement		UZAWE	CHAR	4	*
PAYMENT_DATE	Payment or Delivery Date		TB_DZTERM	DATS	16
PAYMENT_AMOUNT	Payment Amount in Payment Currency		TB_BZBETR	CURR	7
PAYMENT_CURR	Payment Currency		TB_WZBETR	CUKY	10	*
POSTING_STATE	Posting Status of Flow		TB_SBEWEBE	CHAR	2
BLOCK_REASON	Reason Why Flow Is Blocked for Posting		TB_SSPRGRD	NUMC	2
FLG_RELEASED	Release Given for Flow to Be Posted?		TB_SBFREI	CHAR	2
FLG_REVERSAL	Flow Reversal in Treasury		TB_SBWGSTO	CHAR	2
LOC_AMOUNT	Payment Amount in Local Currency		TB_HWBETR	CURR	7
LOC_CURR	Local Currency		FTI_LOCCURR	CUKY	10	*
LOC_RATE	Local Currency Rate		TB_KHWKURS	DEC	5
DUEDATE	Due Date		TB_DFAELL	DATS	16
SEC_ACCT	Securities Account		RLDEPO	CHAR	20
SECPRICE_UNIT	Security Price Without Currency Ref. with Unit Quotation		TB_BUPRC	DEC	8
SECPRICE_PERC	Security Price for Percentage Quotation		TB_BPPRC	DEC	8
CURR_POSITION	Currency of Position Amount		TB_WBBETR	CUKY	10	*
CHNG_AMT_POS	Amount that Changes the Position		TB_BBBETR	CURR	7
CURRUNIT_RATE	Currency Unit of the Rate		TB_RUNIT	CHAR	10	*
POS_VALUEDATE	Position Value Date		TB_DBESTAND	DATS	16
ACCRINT_METHOD	Accrued interest method		SSTCKKZ	CHAR	2
ACCRINT_DAYMETH	Accrued interest: Daily method		SSTCKTG	CHAR	2
FLG_FLAT_IND	Indicator 'Traded flat',i.e.no accrued interest calculation		VVSFLAT	CHAR	2
FLG_COUP_ID	Coupon ID for interest and accrued interest calculation		VVSCOUPON	CHAR	2
COUP_DATE	Coupon date of next delivered coupon		VVDCOUPON	DATS	16
INDEX_VALUE	Index Value (Independent of Basis)		TIDX_INDEX_VALUE_NO_RATIO	DEC	10
CTY_QUANTITY	Quantity		FTR_QUAN	QUAN	7
CTY_UOM	Unit of Measure for the Commodity		TPM_CTY_UOM	UNIT	6	*
CTY_PRICE_SETTL	Commodity Spot Price		FTR_COMSPOT	DEC	7
STATUS_INTADJ	Status of Interest Rate Adjustment		TB_IRA_REGISTRATION_STATE	CHAR	4
REP_CODE	Repetitive Code		RPCODE	CHAR	40
REFTEXT_REPCODE	Reference Text for Repetitive Code		RPCODE_TEXT	CHAR	100
HEDGE_ID	Identification for Hedging Relationship		TPM_HEDGE_ID	CHAR	20
CALC_DATE	Calculation Date		DVALUT	DATS	16
INCL_VAL	Inclusive indicator for value date		VVSVINCL	NUMC	2
MTHEND_VAL	Month-End Indicator for Value Date		VVSVULT	CHAR	2
NO_UNITS	Traded Number of Units for Unit-Quoted Securities/Futures		FTI_NUMBER_TRADED	DEC	8
UNIT_CURR	Price Currency		TB_WPRICE	CUKY	10	*
OPTION_PREMIUM	Currency Option Premium with Price in Points		TI_PRKUR	DEC	7
OPTION_PREMIUM_PERCENTAGE	Price as Percentage Quotation		TB_PWKURS	DEC	6
ASS_NO	Assignment number		DZUONR	CHAR	36
COMMODITY_ID	Commodity ID (obsolete)		TRCO_COMM_ID	CHAR	36
QUOTATION_NAME	Quotation Name		FTI_QUOTNAME	CHAR	36
QUOTATION_SOURC	Quotation Source		TCR_CTY_QUOTSRC	CHAR	4	*
QUOTATION_TYPE	Commodity Quotation Type		TCR_CTY_QUOTTYPE	CHAR	10	*
SPREAD	Commodity Spread		FTR_COMSPREAD	DEC	7
DIV_PCTC_OTC	Percentage of Dividend agreed for Payment in OTC Instruments		TB_DIV_PCTC_OTC	DEC	4
ORIGIN	Display Area of Flow or Condition		TB_SHERK	CHAR	8
LOWER_LIMIT	Lower Limit for Amount		TFMBUGRENZ	CURR	12
UPPER_LIMIT	Upper Limit for Amt		TFMBOGRENZ	CURR	12
SCALED_COND_TYPE	Type of Scaled Calculation		TFMSSTAFF	NUMC	2
LOGIC_NUMBER	Condition Group		FTR_COND_GRP	NUMC	8
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
AVERAGE_NUMBER_DAYS	No. of Days for Interest Calc. with Average Interest Rate		TFM_AAVGDAYS	INT4	4
AVERAGE_INTEREST_RATE	Average Interest Rate		TFM_PAVGINTEREST	DEC	8
AVERAGE_ROUND_CATEGORY	Rounding Category of Average Interest Rate		TFM_SROUNDAVGINTEREST	CHAR	2
AVERAGE_ROUND_DECIMALS	Number of Rounding Decimal Places for Average Interest Rate		TFM_ROUNDDECAVGINTEREST	INT1	1
AVERAGE_WEIGHT	Weighting of Interest Rate		TFM_AWEIGHT	INT4	4
AVERAGE_WEIGHT_SUM	Cumulative Weighting of Interest Rate		TFM_AWEIGHTSUM	INT4	4