VTBFHAPO_UNFIXED - Non-Fixed Financial Transaction Flows

Non-Fixed Financial Transaction Flows information is stored in SAP table VTBFHAPO_UNFIXED.
It is part of development package FTA in software component FIN-FSCM-TRM-TM. This development package consists of objects that can be grouped under "R/3 appl. development for Treasury money,forex,forward gen".

Fields for table VTBFHAPO_UNFIXED

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
BUKRS	Company Code	X	BUKRS	CHAR	8
RFHA	Financial Transaction	X	TB_RFHA	CHAR	26
RFHAZU	Transaction Activity	X	TB_RFHAZU	NUMC	10
DCRDAT	Entered On	X	TB_CRDAT	DATS	16
TCRTIM	Entry Time	X	TB_TCRTIM	TIMS	12
RFHAZB	Transaction Flow	X	TB_RFHAZB	NUMC	8
.INCLUDE				FTRS_VTBFHAPO	0
CRUSER	Entered By		TB_CRUSER	CHAR	24
UPUSER	Last Changed By		TB_UPUSER	CHAR	24
DUPDAT	Changed On		TB_DUPDAT	DATS	16
TUPTIM	Time Changed		TB_TUPTIM	TIMS	12
RANTYP	Contract Type		RANTYP	CHAR	2
SFHAZBA	Flow Type		TB_SFHAZBA	CHAR	8	TZB0A
SBKKLAS	Classification of Flows and Conditions		TB_SBKKLAS	CHAR	2
SBKTYP	Category of Flows and Conditions		TB_SBKTYP	CHAR	4	AT07
SBERFIMA	Calculation category for cash flow calculator		SBEWFIMA	CHAR	8	AT40
SSIGN	Direction of Flow		TB_SSIGN	CHAR	2
SHERKUNFT	Display Area of Flow or Condition		TB_SHERK	CHAR	8
SABVERF	Procedure for Generating Derived Flows		TB_SABVERF	CHAR	10	AT22
RKONDGR	Direction of Transaction		TB_RKONDGR	NUMC	2
RKOND	Condition		TB_KOND	NUMC	8
DGUEL_KP	Condition Item Effective From		DGUEL_KP	DATS	16
NSTUFE	Level number of condition item for recurring payments		NSTUFE	NUMC	4
SKOART	Condition Type (Smallest Subdivision of Condition Records)		SKOART	NUMC	8	TZK01
RREFKONT	Obsolete: Accnt Assignment Ref. in Fin. Assets Management		RREFKONT_OBSOLETE	CHAR	16	T037S
SBZVABW	Alternative Payment Details Stated in Flow		TB_SBZVABW	CHAR	2
RAHABKI	Short Key for Own House Bank		TB_RHABKI	CHAR	10	T012
RAHKTID	Short Key for House Bank Account		TB_RHKTID	CHAR	10	T012K
RPZAHL	Payer/Payee		TB_RPZAHL_NEW	CHAR	20
RPBANK	Partner Bank Details		TB_RPBANK	CHAR	8
SZART	Payment Transaction		TB_SZART	CHAR	2
UZAWE	Payment method supplement		UZAWE	CHAR	4	T042F
SPAYRQ	Generate Payment Request		TB_SPAYRQK	CHAR	2
SPRSNG	Individual Payment		TB_SPRSNGK	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
SBEWEBE	Posting Status of Flow		TB_SBEWEBE	CHAR	2
SSPRGRD	Reason Why Flow Is Blocked for Posting		TB_SSPRGRD	NUMC	2
SBFREI	Release Given for Flow to Be Posted?		TB_SBFREI	CHAR	2
SSTORNOBWG	Flow Reversal in Treasury		TB_SBWGSTO	CHAR	2
PRKEY	Key Number for Payment Request		PRQ_KEYNO	CHAR	20	*
BELNR	Document Number of an Accounting Document		BELNR_D	CHAR	20
BELNR2	Second Journal Entry No. for Currency Swaps		TB_BELNR2	CHAR	20
GJAHR	Fiscal Year		GJAHR	NUMC	8
DBUCHUNG	Posting Date in the Document		BUDAT	DATS	16
DFAELL	Due Date		TB_DFAELL	DATS	16
DZTERM	Payment or Delivery Date		TB_DZTERM	DATS	16
BZBETR	Payment Amount in Payment Currency		TB_BZBETR	CURR	7
WZBETR	Payment Currency		TB_WZBETR	CUKY	10	TCURC
BHWBETR	Payment Amount in Local Currency		TB_HWBETR	CURR	7
KHWKURS	Local Currency Rate		TB_KHWKURS	DEC	5
ASTUECK	No. of Units for Financial Instruments		TB_ASTUECK	DEC	8
BPRICE	Price per Unit		TB_BPRICE	CURR	7
WPRICE	Price Currency		TB_WPRICE	CUKY	10	TCURC
BHWPREIS	Price in Local Currency		TB_HWPREIS	CURR	7
BINDEX	Value of a Point		TB_BINDEX	CURR	7
VVBASIS	Price in Points		TB_VVBASIS	DEC	6
PWKURS	Price as Percentage Quotation		TB_PWKURS	DEC	6
PRKKURS	Currency Option Premium with Price in Points		TI_PRKUR	DEC	7
BNWHR	Nominal Amount		TB_BNWHR	CURR	7
RHANDPL	Exchange		VVRHANDPL	CHAR	20	TWH01
SKURSART	Rate/Price Type - Treasury Instruments		TI_KURSART	CHAR	4	TW56
DBERVON	Start of Calculation Period		DBERVON	DATS	16
DBERBIS	End of Calculation Period		DBERBIS	DATS	16
ATAGE	Number of Days		VVATAGE	NUMC	12
ABASTAGE	Number of base days in a calculation period		ABASTAGE	NUMC	12
PKOND	Percentage rate for condition items		PKOND	DEC	6
DPKOND	Fixing Date of Percentage Rate from Condition		VVDPKOND	DATS	16
DZFEST	Interest rate fixing date		TB_DZFEST	DATS	16
SZBMETH	Interest Calculation Method		SZBMETH	CHAR	2
SKALIDWT	Interest Calendar		TFMSKALIDWT	CHAR	4
BBASIS	Calculation Base Amount		BBASIS	CURR	7
WBASIS	Currency of Calculation Basis		TB_WBASIS	CUKY	10	TCURC
JEXPOZINS	Type of Compound Interest Calculation		TFM_SINTCOMP	CHAR	2
SINCL	Inclusive indicator for beginning and end of a period		VVSINCL	NUMC	2
SINCLBIS	Inclusive Indicator for the End of a Calculation Period		VVSINCLBIS	NUMC	2
SULTBIS	Month-End Indicator for the End of a Calculation Period		VVSULTBIS	CHAR	2
SEXCLVON	Exclusive Indicator for the Start of a Calculation Period		VVSEXCLVON	NUMC	2
SULTVON	Month-End Indicator for Start of a Calculation Period		VVSULTVON	CHAR	2
SAEND	Change Indicator for FiMa Flow Records		TFM_SAEND	NUMC	2
DVALUT	Calculation Date		DVALUT	DATS	16
SVINCL	Inclusive indicator for value date		VVSVINCL	NUMC	2
SVULT	Month-End Indicator for Value Date		VVSVULT	CHAR	2
JSOFVERR	Indicator for Immediate Settlement (Financial Mathematics)		TFMSOFVERR	CHAR	2
DVERRECH	Settlement date		VVDVERRECH	DATS	16
SINCLVERR	Inclusive Indicator for Clearing Date		VVSINCLVER	NUMC	2
SULTVERR	Month-End Indicator for Clearing Date		VVSULTVERR	CHAR	2
SSTORNOMAN	Manual Reversal of Flows Posted in FI		TB_SBWGSTM	CHAR	2
SSTORNOART	Type of Manual Reversal of Flows Posted in FI		TB_SSTOART	CHAR	4	AT90
SBWGARTREF	Referenced Flow Type		TB_SBWGREF	CHAR	8	TZB0A
SKHWFIX	Indicator for Translation into Local Currency		TB_SKHWFIX	CHAR	2
RLDEPO	Securities Account		RLDEPO	CHAR	20
RANL	Security Class ID Number		VVRANLW	CHAR	26
RTRBELNR	Internal Document Number of Derivatives Document		TPM_DEDOC_RDOCNRINT	CHAR	30
BUPRC	Security Price Without Currency Ref. with Unit Quotation		TB_BUPRC	DEC	8
BPPRC	Security Price for Percentage Quotation		TB_BPPRC	DEC	8
WBBETR	Currency of Position Amount		TB_WBBETR	CUKY	10	*
BBBETR	Amount that Changes the Position		TB_BBBETR	CURR	7
WEBETR	Price Currency		TB_WEBETR	CUKY	10	*
BEBETR	Market Value in Quotation Currency		TB_BEBETR	CURR	7
SRUNIT	Currency Unit of the Rate		TB_RUNIT	CHAR	10	TZUNI
KZWKURS	Payment Currency Rate		TB_KZWKURS	DEC	5
KBWKURS	Position Currency Rate		TB_KBWKURS	DEC	5
WSBETR	Currency Key for Currency Conversion: Source Currency		TB_WFROM	CUKY	10	*
DBESTAND	Position Value Date		TB_DBESTAND	DATS	16
SSTCKKZ	Accrued interest method		SSTCKKZ	CHAR	2
SSTCKTG	Accrued interest: Daily method		SSTCKTG	CHAR	2
SFLAT	Indicator 'Traded flat',i.e.no accrued interest calculation		VVSFLAT	CHAR	2
SCOUPON	Coupon ID for interest and accrued interest calculation		VVSCOUPON	CHAR	2
DCOUPON	Coupon date of next delivered coupon		VVDCOUPON	DATS	16
AWKEY	Reference Key		AWKEY	CHAR	40
INDEX_VALUE	Index Value (Independent of Basis)		TIDX_INDEX_VALUE_NO_RATIO	DEC	10
SBASIS	Calculation Base Indicator		SBASIS	CHAR	8	*
REGI_STATE	Status of Interest Rate Adjustment		TB_IRA_REGISTRATION_STATE	CHAR	4
RPCODE	Repetitive Code		RPCODE	CHAR	40
RP_TEXT	Reference Text for Repetitive Code		RPCODE_TEXT	CHAR	100
HEDGE_ID	Identification for Hedging Relationship		TPM_HEDGE_ID	CHAR	20
DBPERIOD	Period start		VVDBPERIOD	DATS	16
SPAEXCL	Exclusive Indicator for Start Date of a Period		TFMSPAEXCL	NUMC	2
SPAULT	Month-End Indicator for Start Date of a Period		TFMSPAULT	CHAR	2
DEPERIOD	Period End		VVDEPERIOD	DATS	16
SPEINCL	Inclusive Indicator for End Date of a Period		TFMSPEINCL	NUMC	2
SPEULT	Month-End Indicator for End of a Period		TFMSPEULT	CHAR	2
AMMRHY	Frequency in months		AMMRHY	NUMC	6
PPAYMENT	Payment Rate		TFM_PPAYMENT	DEC	6
AMMRHYZV	Interest Settlement Frequency for Exponential Interest Calc.		TFM_AMMRHYZV	NUMC	4
LZBKZ	State Central Bank Indicator		LZBKZ	CHAR	6	T015L
LANDL	Supplying Country/Region		LANDL	CHAR	6	T005
BDIRTY	Dirty Price		TB_BDIRTY	CURR	7
BAMOUNTCOMP	Amount to be Capitalized		TB_AMOUNTCOMP	CURR	7
NOMINAL_ORG_AMT	Original Nominal Amount		TB_BNWHR_ORG	CURR	7
NOM_FACTOR	Factor		RDPT_FACTOR_VAL	DEC	7
RLDEPO2	Securities Account		VRLDEPO	CHAR	20	*
INDEX_PRICE	Indicator: Security Price Including Price Index Value		TB_INDEX_PRICE	CHAR	2
FLOWUUID	Transaction Flow UUID		TB_FLOWUUID	RAW	16
FLAGBYTE1	Indicator for Financial Transaction Flow (See Documentation)		TB_FLAGBYTE1	RAW	1
QUANTITY	Quantity		FTR_QUAN	QUAN	7
UNIT_OF_MEASURE	Unit of Measure for the Commodity		TPM_CTY_UOM	UNIT	6	*
CONTRACT_PRICE	Commodity Price		FTR_COMPRICE	DEC	7
SPOT_PRICE	Commodity Spot Price		FTR_COMSPOT	DEC	7
CONTANGO_BACKWRD	Commodity Contango / Backwardation		FTR_CONBACK	DEC	7
BPRC_SPOT1	Current Spot Rate in Percentage		TB_BPPRC_SPOT1	DEC	8
BPRC_SPOT2	Spot Rate at Maturity in Percentage		TB_BPPRC_SPOT_MAT	DEC	8
COST_FWD	Forward Rate Cost		TB_COSTFWD	DEC	8
INTEREST_FWD	Forward Rate Interest		TB_INTERESTFWD	DEC	8
REF_FLOWUUID	Flow Reference (UUID)		TB_REFFLOWUUID	RAW	16
RGATT	Class		TI_RGATT	CHAR	26
COMMODITY_ID	Commodity ID (obsolete)		TRCO_COMM_ID	CHAR	36
QUOTATION_NAME	Quotation Name		CPET_QUOTNAME	CHAR	36
QUOTATION_SOURCE	Quotation Source		TCR_CTY_QUOTSRC	CHAR	4	TRCOCC_QUOTSRC
QUOTATION_TYPE	Commodity Quotation Type		TCR_CTY_QUOTTYPE	CHAR	10	TRCOCC_QUOTTYPE
SPREAD	Commodity Spread		FTR_COMSPREAD	DEC	7
PRICE_CURR_UNIT	Currency Unit of the Rate		TB_RUNIT	CHAR	10	TZUNI
PRICE_UOM	Unit of Measure for the Commodity		TPM_CTY_UOM	UNIT	6	*
DIV_PCTC_OTC	Percentage of Dividend agreed for Payment in OTC Instruments		TB_DIV_PCTC_OTC	DEC	4
TAINTED	Manipulated Cash Flow		TB_TAINTED_CASHFLOW	CHAR	2
CLEARED	Clearing at Flow Level		FTR_FLOW_CLEARED	CHAR	2
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
EXCH_RATE_TYPE	Exchange Rate Type		KURST_CURR	CHAR	8	*
PRICE_PAYM_CURR	Commodity Price in Payment Currency		FTR_COMPRICE_PAYMENT_CURR	DEC	7
SPREAD_PAYM_CURR	Commodity Spread in Payment Currency		FTR_COMSPREAD_PAYMENT_CURR	DEC	7
FX_TRANSLATION	Defines when quotation crcy is converted into payment crcy		FTR_CURRENCY_CONV_POINT_IN_TIM	CHAR	2
MNDID	Unique Reference to Mandate for each Payee		SEPA_MNDID	CHAR	70
BUGRENZ	Lower Limit for Amount		TFMBUGRENZ	CURR	12
BOGRENZ	Upper Limit for Amt		TFMBOGRENZ	CURR	12
SSTAFF	Type of Scaled Calculation		TFMSSTAFF	NUMC	2
LOGIC_RKOND	Condition Group		FTR_COND_GRP	NUMC	8
RKONDREF	Condition		TB_KOND	NUMC	8
DGUEL_KPREF	Condition Item Effective From		DGUEL_KP	DATS	16
.INCLUDE				TLCS_LC_PRESENTATION	0
PRESENT_DATE	Presentation Date		FTR_PRE_DATE	DATS	16
INTEREST_PAID_BY	Identify whether applicant or beneficiary pays interest		FTR_INTEREST_PAY_BY	CHAR	2
SHIPMENT_DATE	Shipment Date		FTR_SHIP_DATE	DATS	16
STATUS	Status		FTR_STATUS	CHAR	4
PRESENT_ID	Presentation Item		FTR_PERSENT_ID	CHAR	20
SSTOGRD	Reason for Reversal		SSTOGRD	CHAR	4	*
PRESENT_AMOUNT	Presentation Amount		FTR_PRESENT_AMT	CURR	7
PRESENT_BANK	Presentation Bank		FTR_PRESENT_BANK	CHAR	20	*
PRESENT_DISCREPANCY	Discrepancy		FTR_DISCREPANCY	CHAR	2
PRESENT_DECREASE_AMOUNT	Presentation Decreased Amount		FTR_PRESENT_DEC_AMT	CURR	7
PRESENT_REA_CRE_LINE	Amount of Released Credit Line		FTR_PRESENT_REA_AMT	CURR	7
PRESENT_PAY_AMT	Payment Amount in Payment Currency		TB_BZBETR	CURR	7
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
FLOWFACTOR	Flow Factor		TFM_FLOWFACTOR	D34R	16
BASEFACTOR	Base Factor		TFM_BASEFACTOR	D34R	16
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
SKBWFIX	Indicator for translation into position currency		TB_SKBWFIX	CHAR	2
GROUPING_TERM	Grouping Term for Derived Flows		TB_DERIV_FLOW_GROUPING	CHAR	32
SSEQUENCE	Processing Sequence of Conditions		TFM_SEQUENCE	NUMC	4
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
STGBASIS	Base Days Method		VVSTGBASIS	CHAR	2
JAVGCAP	Use Upper Limit of Average Interest Rate		TFM_JAVGCAP	CHAR	2
PAVGCAP	Upper Limit of Average Interest Rate		TFM_PAVGCAP	DEC	8
JAVGFLOOR	Use Lower Limit of Average Interest Rate		TFM_JAVGFLOOR	CHAR	2
PAVGFLOOR	Lower Limit of Average Interest Rate		TFM_PAVGFLOOR	DEC	8
PAVGSPREAD	Average Interest Rate Spread		TFM_PAVGSPREAD	DEC	8
SROUNDAVGINTEREST	Rounding Category of Average Interest Rate		TFM_SROUNDAVGINTEREST	CHAR	2
ROUNDDECAVGINTEREST	Number of Rounding Decimal Places for Average Interest Rate		TFM_ROUNDDECAVGINTEREST	INT1	1
AAVGWEIGHT	Weighting of Interest Rate		TFM_AWEIGHT	INT4	4
AAVGWEIGHTSUM	Cumulative Weighting of Interest Rate		TFM_AWEIGHTSUM	INT4	4
FX_FIXING_DATE	Fixing Date		TB_DFIX	DATS	16
FX_REGI_STATE	Status of Rate Fixing		FTR_FIXING_REF_REGI_STATE	CHAR	4
FX_READ_DATE	Date of the Exchange Rate Read		FTR_FIXING_REF_READ_DATE	DATS	16
PRICEINDEX_FIX_DATE_LOW	Index Fixing Date		TFM_INDEX_FIXDATELOW	DATS	16
PRICEINDEX_READ_DATE_LOW	Index Read Date		TFM_INDEX_READDATE	DATS	16
PRICEINDEX_FIX_DATE_HIGH	Index Fixing Date		TFM_INDEX_FIXDATEHIGH	DATS	16
PRICEINDEX_READ_DATE_HIGH	Index Read Date		TFM_INDEX_READDATE	DATS	16
PRICEINDEX_REGI_STATE	Status of Rate Fixing		FTR_FIXING_REF_REGI_STATE	CHAR	4
BBBETR_IDXCLEAN	Amount Index-Clean that Changes the Position		TB_BBBETR_IDXCLEAN	CURR	7
.INCLUDE				TBAS_OTC_QUANTITY_CONVERSION	0
TRADED_QUANTITY	OTC Quantity Conversion		TBA_TRADED_OTC_QUANTITY	QUAN	7
TRADED_QUANTITY_UOM	OTC Quantity Conversion UoM		TBA_TRADED_QUANTITY_UOM	UNIT	6	*
CONV_FACTOR_TRADED_QTY	Quantity Conversion Factor of Priced OTC Transaction		TBA_CONV_FACTOR_TRADED_QTY	DEC	12
CONV_FACTOR_TRADED_QTY_UOM	Quantity Conversion Factor of Priced OTC Transaction UoM		TBA_CONV_FACTOR_TRADED_QTY_UOM	UNIT	6	*
CONV_FACTOR_PRICED_QTY	Quantity Conversion Factor for OTC Transaction		TBA_CONV_FACTOR_PRICED_QTY	DEC	12
CONV_FACTOR_PRICED_QTY_UOM	Quantity Conversion Factor for OTC Transaction UoM		TBA_CONV_FACTOR_PRICED_QTY_UOM	UNIT	6	*
.INCLU--AP				IDCFM_USHA_FTRS_VTBFHAPO	0
.INCLUDE				IDCFM_USHA_STR_FTRS_VTBFHAPO	0
IDCFM_USHA_TYPE	Haircut Rate Type		IDCFM_USHA_DEL_TYPE	CHAR	2
IDCFM_USHA_PERC	Percentage Value		IDCFM_USHA_DEL_PERC	DEC	6
IDCFM_USHA_TOTA	Enter Haircut Amount in PC		IDCFM_USHA_DEL_TOTA	CURR	7
IDCFM_USHA_CURR	Currency of Haircut Amount		IDCFM_USHA_DEL_CURR	CUKY	10	*
IDCFM_USHA_FORM	European Formula Calculation		IDCFM_USHA_DEL_FORM	CHAR	2