TCORT_CODCO - Deal: Conditions

Deal: Conditions information is stored in SAP table TCORT_CODCO.
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_CODCO

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
CODCO_UUID	Correspondence Object: Deal Conditions UUID	X	FTR_CODCOID	RAW	16
CODMD_UUID	Correspondence Object Deal's main data UUID		FTR_CODMDID	RAW	16
.INCLUDE				TCORS_CODCO_INCL	0
COMPANYCODE	Company Code		BUKRS	CHAR	8
DEAL_NUMBER	Position-Generating Financial Transaction		FTI_POSRFHA	CHAR	26
COND_NUMBER	Condition		TB_KOND	NUMC	8
EFF_FROM	Condition Item Effective From		DGUEL_KP	DATS	16
DIRECTION	Direction of Transaction		TB_RKONDGR	NUMC	2
SINGLE_DATES	Level number of condition item for recurring payments		NSTUFE	NUMC	4
TYPE	Condition Type (Smallest Subdivision of Condition Records)		SKOART	NUMC	8	*
CLASS	Classification of Flows and Conditions		TB_SBKKLAS	CHAR	2
CATEGORY	Category of Flows and Conditions		TB_SBKTYP	CHAR	4	*
EFF_FROM_EXCL	Exclusive indicator for start date of condition position		TFMSEXCLKP	NUMC	2
CREATE_USER	Entered By		TB_CRUSER	CHAR	24
CREATE_DATE	Entered On		TB_DCRDAT	DATS	16
CREATE_TIME	Entry Time		TB_CRTIM	CHAR	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
FIX_PERC_RATE	Percentage rate for condition items		PKOND	DEC	6
FIX_PAYMENT_RATE	Payment Rate		TFM_PPAYMENT	DEC	6
FIX_BASIS	Calculation Base Amount		TFM_BBASIS2	CURR	7
VAR_INT_REF	Reference Interest Rate		SZSREF	CHAR	20	*
VAR_SPREAD	Spread for Reference Interest Rate (Variable Interest)		FTI_VAR_OFFSET	DEC	6
VAR_FORMULA	Formula Reference		TB_XFORMBE	CHAR	8	*
VAR_FORMULA_NAME	Variable Name		TB_VARNAME	CHAR	8
VAR_1ST_PER_RATE	Interest Rate for the First Period		TFM_PKOND1STPER	DEC	6
CALC_METHOD	Interest Calculation Method		SZBMETH	CHAR	2
CALC_METHOD_CAL	Interest Calendar		TFMSKALIDWT	CHAR	4
CALC_TYPE	Type of Interest Calculation		TFMSINTCALC	NUMC	2
CALC_EXP_FREQ	Interest Settlement Frequency for Exponential Interest Calc.		TFM_AMMRHYZV	NUMC	4
CALC_IMM_SETTLE	Indicator for Immediate Settlement (Financial Mathematics)		TFMSOFVERR	CHAR	2
AMOUNT	Condition Item Currency Amount		BKOND	CURR	7
AMOUNT_CURRENCY	Currency of Condition Item		SWHRKOND	CUKY	10	*
AMOUNT_TEMP_CALC	Indicator for Pro Rata Temporis Calculations		VVSZEITANT	NUMC	2
CALCDAT	Calculation Date		DVALUT	DATS	16
CALCDAT_INCL	Inclusive indicator for beginning and end of a period		VVSINCL	NUMC	2
CALCDAT_MONTHEND	Month-End Indicator for Calculation Date		VVSBULT	CHAR	2
CALCDAT_WKDAYSFT	Working Day Shift for Calculation Day		TB_SVWERK	NUMC	2
CALCDAT_SFTDAYS	Number of Days for Relative Calculation of Value Date		TB_AVGSTAG	INT4	4
CALCDAT_SFTDIR	Direction of Daily Shift		FTI_SFTDIR	CHAR	2
CALCDAT_PERRULE	Method for determining the next value date		TB_SVMETH	NUMC	2
CALCDAT_ADJRULE	Rule for Date Update for Interest Rate Adjustment		TFMSRHYZAP	NUMC	2
DUEDAT	Due date		DFAELL	DATS	16
DUEDAT_MONTHEND	Month-End Indicator for Due Date		SFULT	CHAR	2
DUEDAT_SFTEND	Shift Due Date		TFMSFRANZ	NUMC	2
DUEDAT_WKDAYSFT	Working Day Shift for Due Date		TB_SFWERK	NUMC	2
DUEDAT_SFTDAYS	Number of days for rel. determination of due date		TB_AFGSTAG	INT4	4
DUEDAT_SFTDIR	Direction of Daily Shift		FTI_SFTDIR	CHAR	2
DUEDAT_DUERULE	Method for determining the next due date		TB_SFMETH	NUMC	2
DUEDAT_FIXRULE	Rule for Date Update		TFMSRHY	NUMC	2
DUEDAT_FIXREFDAT	Reference Date for Interest Rate Fixing Date		FTI_ZRELDAT	NUMC	2
FREQUENCY	Cycle		TFMARHY	NUMC	6
FREQUENCY_UNIT	Unit for Frequency		TFMURHY	NUMC	2
CALENDAR1	Factory calendar		SKALID	CHAR	4
CALENDAR2	Factory calendar		SKALID	CHAR	4
CALENDAR3	Factory calendar		SKALID	CHAR	4
ROUND	Rounding Category		TFM_SROUND	CHAR	2
ROUND_UNIT	Rounding Unit		TFMPRUNIT	DEC	7
DISCOUNT	Discounting Category		TFM_SDISCOUNT	NUMC	2
VARNAME	Variable Name		TB_VARNAME	CHAR	8
ALT_INT_RATE	Percentage rate for condition items		PKOND	DEC	6
ALT_INT_REF	Reference Interest Rate		SZSREF	CHAR	20	*
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
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
CONDITION_SEQUENCE	Processing Sequence of Conditions		TFM_SEQUENCE	NUMC	4
RATE_FIXING_LOCKOUT_PERIOD	Duration of Lockout Period in Working Days		TFMATLOCKOUT	NUMC	4
AVERAGE_USE_CAP	Use Upper Limit of Average Interest Rate		TFM_JAVGCAP	CHAR	2
AVERAGE_CAP	Upper Limit of Average Interest Rate		TFM_PAVGCAP	DEC	8
AVERAGE_USE_FLOOR	Use Lower Limit of Average Interest Rate		TFM_JAVGFLOOR	CHAR	2
AVERAGE_FLOOR	Lower Limit of Average Interest Rate		TFM_PAVGFLOOR	DEC	8
AVERAGE_SPREAD	Average Interest Rate Spread		TFM_PAVGSPREAD	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 Category of Interest Rate		TFM_SWEIGHT	CHAR	2
ROUND_FACTOR_CATEGORY	Rounding Category of a Factor		TFM_SROUNDFACTOR	CHAR	2
ROUND_FACTOR_DECIMALS	Number of Rounding Decimal Places for a Factor		TFM_ROUNDDECFACTOR	INT1	1
ROUND_RATE_FACTOR_CATEGORY	Rounding Category of Interest Factor		TFM_SROUNDRATEFACTOR	CHAR	2
ROUND_RATE_FACTOR_DECIMALS	Number of Rounding Decimal Places for Interest Factor		TFM_ROUNDDECRATEFACTOR	INT1	1
ROUND_BASE_FACTOR_CATEGORY	Rounding Category of a Base Factor		TFM_SROUNDBASEFACTOR	CHAR	2
ROUND_BASE_FACTOR_DECIMALS	Number of Rounding Decimal Places for a Base Factor		TFM_ROUNDDECBASEFACTOR	INT1	1
FACTOR_RESET	Event for Resetting Factor Calculation		TFM_SFACTORRESET	CHAR	2
PAY_DATE_WKDAY_SHIFT	Working Day Shift for Payment Date		TB_SDWERK	NUMC	2