VTBFINKO - Transaction Condition

Transaction Condition information is stored in SAP table VTBFINKO.
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 VTBFINKO

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
BUKRS	Company Code	X	BUKRS	CHAR	8	T001
RGATT	Class	X	TI_RGATT	CHAR	26
RFHA	Financial Transaction	X	TB_RFHA	CHAR	26	VTBFHA
RFHAZU	Transaction Activity	X	TB_RFHAZU	NUMC	10
RKONDGR	Direction of Transaction	X	TB_RKONDGR	NUMC	2
RKOND	Condition	X	TB_KOND	NUMC	8
DGUEL_KP	Condition Item Effective From	X	DGUEL_KP	DATS	16
NSTUFE	Level number of condition item for recurring payments	X	NSTUFE	NUMC	4
.INCLUDE				FTRS_VTBFINKO	0
CRUSER	Entered By		TB_CRUSER	CHAR	24
DCRDAT	Entered On		TB_DCRDAT	DATS	16
TCRTIM	Entry Time		TB_CRTIM	CHAR	12
UPUSER	Last Changed By		TB_UPUSER	CHAR	24
DUPDAT	Changed On		TB_DUPDAT	DATS	16
TUPTIM	Time Changed		TB_TUPTIM	TIMS	12
SALTKOND	Unit for supplementary condition items		TB_SALKOND	NUMC	8
SZINSANP	Cross-referenced condition grp for interest rate adjustment		SZINSANP	NUMC	8
JNULLKON	Condition Form		JNULLKON	CHAR	2
SKOART	Condition Type (Smallest Subdivision of Condition Records)		SKOART	NUMC	8	TZK01
SSIGN	Direction of Flow		TB_SSIGN	CHAR	2
SBKKLAS	Classification of Flows and Conditions		TB_SBKKLAS	CHAR	2
SBKTYP	Category of Flows and Conditions		TB_SBKTYP	CHAR	4	AT08
PKOND	Percentage rate for condition items		PKOND	DEC	6
BKOND	Condition Item Currency Amount		BKOND	CURR	7
SWHRKOND	Currency of Condition Item		SWHRKOND	CUKY	10	TCURC
SBASIS	Calculation Base Indicator		SBASIS	CHAR	8	*
BBASIS	Calculation Base Amount		TFM_BBASIS2	CURR	7
SZBMETH	Interest Calculation Method		SZBMETH	CHAR	2
SKALIDWT	Interest Calendar		TFMSKALIDWT	CHAR	4
SINCL	Inclusive indicator for beginning and end of a period		VVSINCL	NUMC	2
SZSREF	Reference Interest Rate		SZSREF	CHAR	20	T056R
SFORMREF	Formula Reference		TB_XFORMBE	CHAR	8	*
SVARNAME	Variable Name		TB_VARNAME	CHAR	8
AMMRHY	Frequency in months		AMMRHY	NUMC	6
ATTRHY	Frequency in Days		ATTRHY	NUMC	6
DVALUT	Calculation Date		DVALUT	DATS	16
SVULT	Month-End Indicator for Calculation Date		VVSBULT	CHAR	2
SVWERK	Working Day Shift for Calculation Day		TB_SVWERK	NUMC	2
SVMETH	Method for determining the next value date		TB_SVMETH	NUMC	2
AVGSTAGE	Number of Days for Relative Calculation of Value Date		TB_AVGSTAG	INT4	4
DFAELL	Due date		DFAELL	DATS	16
SFULT	Month-End Indicator for Due Date		SFULT	CHAR	2
SFWERK	Working Day Shift for Due Date		TB_SFWERK	NUMC	2
SFMETH	Method for determining the next due date		TB_SFMETH	NUMC	2
AFGSTAGE	Number of days for rel. determination of due date		TB_AFGSTAG	INT4	4
SDWERK	Working Day Shift for Payment Date		TB_SDWERK	NUMC	2
DZFEST	Interest rate fixing date		TB_DZFEST	DATS	16
AZGSTAGE	No. of Days for Relative Determinatn of Interest Fixing		TB_AZGSTAG	INT4	4
DZSREF	Reference Interest Rate Fixing Date		TB_ZSREF	DATS	16
SKALID	Factory calendar		SKALID	CHAR	4	TFACD
SKALID2	Factory calendar		SKALID	CHAR	4	TFACD
RANTYP	Contract Type		RANTYP	CHAR	2
SHERKUNFT	Display Area of Flow or Condition		TB_SHERK	CHAR	8
SRHYTHM	Frequency Indicator		TB_SRHYTHM	NUMC	2
SBERFIMA	Calculation category for cash flow calculator		SBEWFIMA	CHAR	8	AT40
SZWERK	Shift to Working Day for Interest Fixing Date		VVSZWERK	NUMC	2
RHANDPL	Exchange		VVRHANDPL	CHAR	20	*
SKURSART	Rate/Price Type - Treasury Instruments		TI_KURSART	CHAR	4
SFVMETH	Update Method for Calculation Date/Due Date		TB_SFVMETH	NUMC	4
SERBTERM	FiMa indicator: Date and frequency inheritance for condition		TFMERBTERM	CHAR	2
SFRANZ	Shift Due Date		TFMSFRANZ	NUMC	2
SEXCLGUEL	Exclusive indicator for start date of condition position		TFMSEXCLKP	NUMC	2
JSOFVERR	Indicator for Immediate Settlement (Financial Mathematics)		TFMSOFVERR	CHAR	2
JEXPOZINS	Type of Compound Interest Calculation		TFM_SINTCOMP	CHAR	2
SKALID3	Factory calendar		SKALID	CHAR	4	TFACD
PPAYMENT	Payment Rate		TFM_PPAYMENT	DEC	6
SZEITANT	Indicator for Pro Rata Temporis Calculations		VVSZEITANT	NUMC	2
PKOND1STPER	Interest Rate for the First Period		TFM_PKOND1STPER	DEC	6
SREFDISC	Referenced Condition Group Discounting		SREFDISC	NUMC	8
SDISCOUNT	Discounting Category		TFM_SDISCOUNT	NUMC	2
BROUNDUNIT	Rounding Unit		TFMPRUNIT	DEC	7
SROUND	Rounding Category		TFM_SROUND	CHAR	2
AMMRHYZV	Interest Settlement Frequency for Exponential Interest Calc.		TFM_AMMRHYZV	NUMC	4
FACILITYLINE	Line of Credit		TB_CREDIT_LINE	CHAR	6	*
BGUEL_KP	Condition Item Effective from Amount		BGUEL_KP	CURR	9
SULTGUEL	Month-end indicator for start date of condition position		TFMSULT_KP	CHAR	2
BBASISUNIT	Base Unit for Rounding		TFM_BBASISUNIT	CURR	9
RKONDREF	Reference Condition Type		TB_KONDREF	NUMC	8
STTLM_FREQ	COMS: Settlement Frequency		FTR_COMS_SETTLE_FREQUENCY	INT1	1
STTLM_FREQ_UNIT	COMS: Settlement Frequency Unit		FTR_COMS_SETTFRQ_UNIT	CHAR	2
PAYDAT_OFFS_UNIT	COMS: Determination Logic of Payment Date Offset		FTR_COMS_UNIT_PAYDATOFF	CHAR	2
COMMON_PRICING	Indicates Whether Common Pricing Is Used for Average Pricing		FTR_COMS_AVG_COMMON_PRICING	CHAR	2
FIXING_DATE_RULE	COMS: Fixing Date Rule for COMS		FTR_COMS_FIX_DAT_RULE	CHAR	2
WEEKDAY_NUMBER	COMS: Frequency of Occurrence of Weekday in Period		FTR_COMS_OCCURE_OF_WD	INT1	1
WEEKDAY	COMS: Day of Week for Price Fixing		FTR_COMS_FIX_WEEKDAY	CHAR	2
AVERAGE_FREQ	COMS: Frequency for Average		FTR_COMS_AVERAG_FREQ	INT2	2
QUAN	Quantity		FTR_QUAN	QUAN	7
UNIT_OF_MEASURE	Unit of Measure for the Commodity		TPM_CTY_UOM	UNIT	6	*
QUAN_RELATED_TO	Quantity Related To		FTR_COMS_QUAN_VAL_PER	CHAR	2
REFERENCE	Reference		FTR_REFERENCE	CHAR	120
FX_TRANSLATION	Defines when quotation crcy is converted into payment crcy		FTR_CURRENCY_CONV_POINT_IN_TIM	CHAR	2
EXCH_RATE_TYPE	Exchange Rate Type		KURST_CURR	CHAR	8	*
CPCC_FLAG	COMS: Indicator for Consideration of Payment Crcy Calendar		FTR_COMS_CPCC_FLAG	CHAR	2
JPROZR	Percentage Calculation		TB_JPROZR	CHAR	2
SFINCL	Inclusive Indicator for Due Date		VVSFINCL	NUMC	2
JBMONAT	Indicator for calculating amount per month		JBMONAT	CHAR	2
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
SKALID4	Factory calendar		SKALID	CHAR	4	TFACD
SKALID5	Factory calendar		SKALID	CHAR	4	TFACD
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 Factor		TFM_SROUNDFACTOR	CHAR	2
ROUNDDECBASEFACTOR	Number of Rounding Decimal Places for a Factor		TFM_ROUNDDECFACTOR	INT1	1
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
ADGSTAGE	Number of Days for Relative Payment Date Calculation		TFM_ADGSTAGE	INT4	4
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
SAVGWEIGHT	Weighting Category of Interest Rate		TFM_SWEIGHT	CHAR	2
SFACTORRESET	Event for Resetting Factor Calculation		TFM_SFACTORRESET	CHAR	2
JUGRENZ	Use Lower Limit of Amount		TFM_JUGRENZ	CHAR	2
JOGRENZ	Use Upper Limit of Amount		TFM_JOGRENZ	CHAR	2
INDEX_INTERPOLATE	Index Interpolation Method		TFM_INDEX_INTERPOLATE	CHAR	8
PRICEINDEX_APPLY	Price Index Application Method		TFM_PRICEINDEX_APPLY	CHAR	8
INDEX_BASE_VALUE	Index Base Value		TFM_INDEX_BASEVALUE	D34R	16
INDEX_BASE_DATE	Index Base Date		TFM_INDEX_BASEDATE	DATS	16
INDEX_FIX_DATE_HIGH	Index Fixing Date		TFM_INDEX_FIXDATEHIGH	DATS	16
INDEX_FIX_DATE_LOW	Index Fixing Date		TFM_INDEX_FIXDATELOW	DATS	16
INDEX_ADJ_DATE_RELATION	Reference Date for Index Adjustment Date		TFM_INDEX_RELDATE	NUMC	2
PRICEINDEX_RKONDREF	Reference Condition Type		TB_KONDREF	NUMC	8
SROUNDDAYFRACTION	Day Fraction Rounding Category		TFM_SROUNDDAYFRACTION	CHAR	2
ROUNDDECDAYFRACTION	Number of Rounding Decimals for Day Fraction		TFM_ROUNDDECDAYFRACTION	INT1	1
PRICEINDEX_COMPOUND_FREQUENCY	Compounding Frequency of Price Index Factors		TFM_PRICEINDEX_COMPOUNDFREQ	NUMC	6
INDEX_FIX_DATE_DATESHIFT	Working Day Shift for Calculation Day		TB_SVWERK	NUMC	2
INDEX_FIX_DATE_SHIFTDAYS	Number of Days for Relative Calculation of Value Date		TB_AVGSTAG	INT4	4