TRDT_FLOW - Persistent distributor flows

Persistent distributor flows information is stored in SAP table TRDT_FLOW.
It is part of development package FTR_DISTRIBUTOR in software component FIN-FSCM-TRM-TM. This development package consists of objects that can be grouped under "CFM-TM: Distributor".

Fields for table TRDT_FLOW

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
BUSTRANS_OS_GUID	Object Identity in Database Format	X	TPM_DB_OS_GUID	CHAR	64	TRDT_TRDBUSTRANS
FLOW_NUMBER	Number of a Distributor Flow	X	TPM_TRDFLOWNR	INT4	4
DIS_FLOWTYPE	Update Type		TPM_DIS_FLOWTYPE	CHAR	16	TRDC_DFLOWTYPE
ALLOC_NMBR	Assignment number		DZUONR	CHAR	36
COMPANY_CODE	Company Code		BUKRS	CHAR	8	T001
VALUATION_AREA	Treasury Valuation Area		TPM_VAL_AREA	CHAR	6
PRODUCT_TYPE	Product Type		VVSART	CHAR	6	TZPA
TRANSACTION_TYPE	Financial Transaction Type		TB_SFHAART	CHAR	6	AT10
COM_VAL_CLASS	General Valuation Class		TPM_COM_VAL_CLASS	NUMC	8	TRGC_COM_VALCL
VALUATION_CLASS	Valuation Class		TPM_VAL_CLASS	NUMC	8	TRGC_VAL_CLASS
SECURITY_ID	Security Class ID Number		VVRANLW	CHAR	26	VWPANLA
SECURITY_ACCOUNT	Securities Account		RLDEPO	CHAR	20	TWD01
ACCOUNT_GROUP	Securities Account Group		TPM_SEC_ACCT_GRP	CHAR	20	TRGT_SECACCGRP
PORTFOLIO	Portfolio		RPORTB	CHAR	20	TWPOB
TRADER	Trader		RDEALER	CHAR	24	TZDEA
LOANS_CONTRACT	Contract Number		RANL	CHAR	26	VDARL
DEAL_NUMBER	Financial Transaction		TB_RFHA	CHAR	26	VTBFHA
POSITION_ACCOUNT	Futures Account for Listed Options and Futures		TPM_POS_ACCOUNT_FUT	CHAR	20
LOT_ID	Identifier of the Lot		TPM_LOT_ID	RAW	16
FLAG_LONG_SHORT	Indicates whether it is a long or a short position		TPM_FLAG_LONG_SHORT	CHAR	2
FUND	Fund		FM_FUND	CHAR	20
GRANT_NBR	Grant		GM_GRANT_NBR	CHAR	40
EXTERNAL_ACCOUNT	External Account		TPM_EXT_ACCOUNT	CHAR	20
DIFF_CURRENCY	Currency as Differentiation Term		TPM_DIFF_CURRENCY	CUKY	10
UNITS	Units		TPM_UNITS	DEC	12
NOMINAL_CURR	Nominal Currency		TPM_NOMINAL_CURR	CUKY	10
NOMINAL_AMT	Nominal Amount		TPM_NOMINAL_AMT	CURR	11
NOMINAL_ORG_AMT	Original Nominal Amount in Position Currency		TPM_NOMINAL_ORG_AMT	CURR	11
POSITION_CURR	Position Currency		TPM_POSITION_CURR	CUKY	10
POSITION_AMT	Amount (Position Currency)		TPM_POSITION_AMT	CURR	11
POSAMT_IDX_CLEAN	Amount in Position Currency Index-Clean		TPM_POSITION_AMT_IDX_CLEAN	CURR	11
QUANT_CAT	Position Change Category: Quantity		TPM_QTY_PM_CAT	CHAR	8
ACTIVE_PASSIVE	Indicator: Assets/Liabilities Position		TPM_ACTIVE_PASSIVE	CHAR	2
LOCAL_CURR	Local Currency		TPM_LOCAL_CURR	CUKY	10
LOCAL_AMT	Amount (Local Currency)		TPM_LOCAL_AMT	CURR	11
VALUATION_CURR	Valuation Currency		TPM_VALUATION_CURR	CUKY	10
VALUATION_AMT	Amount in Valuation Currency		TPM_VALUATION_AMT	CURR	11
TRL_POS_MAN_CAT	Position Change Category		TPM_AMT_PM_CAT	CHAR	8
FIXED_AA_REF	Account Assignment Reference of Position Management		TPM_AA_REF	CHAR	24	TRACC_AA_REF
SOURCETARGET_FLG	Indicator: Source or Target of a Flow		TPM_SOURCE_TARGET_FLG	CHAR	2
TRANSFER_GROUP	Group of Flows from a Source or Target		TPM_TRANSFER_GROUP	NUMC	8
LOT_CREATION	Lot Creation Category		TPM_LOT_CREATION	NUMC	2
AMOUNT_FACTOR	Value Coefficient		TPM_AMOUNT_FACTOR	FLTP	8
PAYMENT_CURR	Payment Currency		TPM_PAYMENT_CURR	CUKY	10
PAYMENT_AMT	Payment Amount		TPM_PAYMENT_AMT	CURR	11
SIGN	Direction of Flow		TB_SSIGN	CHAR	2
HOUSE_BANK	Short Key for Own House Bank		TB_RHABKI	CHAR	10
HOUSE_BANK_ACC	Short Key for House Bank Account		TB_RHKTID	CHAR	10
PAYMENT_DATE	Payment Date		TPM_PAYMENT_DATE	DATS	16
DUE_DATE	Due Date		TPM_DUE_DATE	DATS	16
RPBANK	Partner Bank Details		TB_RPBANK	CHAR	8
RPZAHL	Payer/Payee		TB_RPZAHL_NEW	CHAR	20	BUT000
SZART	Payment Transaction		TB_SZART	CHAR	2
UZAWE	Payment method supplement		UZAWE	CHAR	4	T042F
SPAYRQ	Payment request allowed		TB_SPAYRQ	CHAR	2
SPRSNG	Individual payment required		TB_SPRSNG	CHAR	2
SPRGRD	Determine Grouping Definition		TB_SPRGRD	CHAR	2
SCSPAY	Same Direction Necessary for Joint Payment?		TB_SCSPAY	CHAR	2
PAYGR	Grouping Field for Automatic Payments		PAYGR	CHAR	40
CALCULATION_DATE	Calculation Date		DVALUT	DATS	16
CALC_DATE_INCL	Inclusive indicator for beginning and end of a period		VVSINCL	NUMC	2
COUPON_DATE	Date of the Next Coupon		TPM_COUPON_DATE	DATS	16
COUPON_SIGN	Coupon ID for Interest and Accrued Interest Calculation		TPM_COUPON_SIGN	CHAR	2
CALC_BEGIN	Start of Calculation Period		DBERVON	DATS	16
CALC_END	End of Calculation Period		DBERBIS	DATS	16
EFF_INT_RATE_U	For Calculation of Amortization Amts (SAC) for Used EffInR		TPM_TRL_EFF_INT_RATE_USED	DEC	6
SCHED_EFF_RATE	Key for Redemption Schedule that Explains Effect. Int. Rate		RDPT_SCHEDULE_KEY_EFF_RATE	INT4	4
EFF_INT_RATE_N	Valid Effective Interest Rate for the Next Amortization		TPM_TRL_EFF_INT_RATE_NEW	DEC	6
SCHED_FIX	Key for Fixed Redemption Schedule		RDPT_SCHEDULE_KEY_FIX	INT4	4
LANDL	Supplying Country/Region		LANDL	CHAR	6
LZBKZ	State Central Bank Indicator		LZBKZ	CHAR	6
RPCODE	Repetitive Code		RPCODE	CHAR	40
RP_TEXT	Reference Text for Repetitive Code		RPCODE_TEXT	CHAR	100
RFHAZU	Transaction Activity		TB_RFHAZU	NUMC	10
NORDEXT	External Reference		TB_NORDEXT	CHAR	32
SFGZUSTT	Transaction Activity Category		TB_SFGZUTY	NUMC	4
SKHWFIX	Indicator for Translation into Local Currency		TB_SKHWFIX	CHAR	2
TRANSL_DATE	Translation date		WWERT_D	DATS	16
RKONDGR	Direction of Transaction		TB_RKONDGR	NUMC	2
COUNTERPARTY	Business Partner Number		TB_KUNNR_NEW	CHAR	20
SNOTDELIVERED	Security not delivered		FTR_NOT_DEL_FLG	CHAR	2
CLEARING_STATUS	Clearing Status (TREA)		TPM_TREA_CLEARING_STATUS	NUMC	2
CLEARING_DATE	Actual Clearing Date		TPM_TREA_CLEARING_DATE_ACT	DATS	16
MNDID	Unique Reference to Mandate for each Payee		SEPA_MNDID	CHAR	70
PRESENTATION_ID	Presentation Item		FTR_PERSENT_ID	CHAR	20
HEDGED_ITEM_ID	Identification Number of Hedged Item		THM_HEDGE_ID	NUMC	20
EXPOSURE_ITEM_ID	Exposure Item ID		TOE_EXPOSURE_ITEM_ID	CHAR	26
EXPOSURE_SUBITEM_ID	Exposure Subitem ID		TOE_EXPOSURE_SUBITEM_ID	CHAR	26
SVULT	Month-End Indicator for Value Date		VVSVULT	CHAR	2
SROUNDFACTOR	Rounding Category of a Factor		TFM_SROUNDFACTOR	CHAR	2
ROUNDDECFACTOR	Number of Rounding Decimal Places for a Factor		TFM_ROUNDDECFACTOR	INT1	1
JEXPOINTFACTOR	Exponential Interest Calculation with Factor		TFM_JEXPOINTFACTOR	CHAR	2
SROUNDBASEFACTOR	Rounding Category of a Base Factor		TFM_SROUNDBASEFACTOR	CHAR	2
ROUNDDECBASEFACTOR	Number of Rounding Decimal Places for a Base Factor		TFM_ROUNDDECBASEFACTOR	INT1	1
FLOWFACTOR	Flow Factor		TFM_FLOWFACTOR	D34R	16
BASEFACTOR	Base Factor		TFM_BASEFACTOR	D34R	16
SROUNDRATEFACTOR	Rounding Category of Interest Factor		TFM_SROUNDRATEFACTOR	CHAR	2
ROUNDDECRATEFACTOR	Number of Rounding Decimal Places for Interest Factor		TFM_ROUNDDECRATEFACTOR	INT1	1
AAVGDAYS	No. of Days for Interest Calc. with Average Interest Rate		TFM_AAVGDAYS	INT4	4
PAVGINTEREST	Average Interest Rate		TFM_PAVGINTEREST	DEC	8
SSEQUENCE	Processing Sequence of Conditions		TFM_SEQUENCE	NUMC	4
SSTCKKZ	Accrued interest method		SSTCKKZ	CHAR	2
SFLAT	Indicator 'Traded flat',i.e.no accrued interest calculation		VVSFLAT	CHAR	2
FX_FIXING_DATE	Fixing Date		TB_DFIX	DATS	16
WBS_ELEMENT	Work Breakdown Structure Element (WBS Element)		PS_PSP_PNR	NUMC	16
COST_CENTER	Cost Center		KOSTL	CHAR	20
PROFIT_CENTER	Profit Center		PRCTR	CHAR	20
FUNCTIONAL_AREA	Functional Area		FKBER	CHAR	32
.INCLUDE				CMMS_HACC_COMMODITY	0
.INCLUDE				CMMS_HACC_DCS	0
DCSID	Derivative Contract Specification ID		TBA_DCSID	CHAR	40
.INCLUDE				CMMS_HACC_QUANTITY	0
QUANTITY	Quantity		FTR_QUAN	QUAN	7
UNIT_OF_MEASURE	Unit of Measure for the Commodity		TPM_CTY_UOM	UNIT	6