TCORT_CODULCO - Deal : Underlying's Conditions

Deal : Underlying's Conditions information is stored in SAP table TCORT_CODULCO.
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_CODULCO

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6
CODULCO_UUIDCorrespondence object deal's underlying: Condition UUIDXFTR_CODULCOIDRAW16
CODMD_UUIDCorrespondence Object Deal's main data UUIDFTR_CODMDIDRAW16
CODUL_UUIDCorrespondence object deal's underlying data UUIDFTR_CODULIDRAW16
.INCLUDETCORS_CODULCO_INCL0
COMPANYCODECompany CodeBUKRSCHAR8
DEAL_NUMBERPosition-Generating Financial TransactionFTI_POSRFHACHAR26
UL_NUMBERNumber of Underlying TransactionFTI_RFHA_ULCHAR26*
COND_NUMBERConditionTB_KONDNUMC8
TYPECondition Type (Smallest Subdivision of Condition Records)SKOARTNUMC8*
CLASSClassification of Flows and ConditionsTB_SBKKLASCHAR2
CATEGORYCategory of Flows and ConditionsTB_SBKTYPCHAR4*
EFF_FROMCondition Item Effective FromDGUEL_KPDATS16
EFF_FROM_EXCLExclusive indicator for start date of condition positionTFMSEXCLKPNUMC2
DIRECTIONDirection of TransactionTB_RKONDGRNUMC2
CREATE_USEREntered ByTB_CRUSERCHAR24
CREATE_DATEEntered OnTB_DCRDATDATS16
CREATE_TIMEEntry TimeTB_CRTIMCHAR12
UPDATE_USERLast Changed ByTB_UPUSERCHAR24
UPDATE_DATEChanged OnTB_DUPDATDATS16
UPDATE_TIMETime ChangedTB_TUPTIMTIMS12
FIX_PERC_RATEPercentage rate for condition itemsPKONDDEC6
FIX_PAYMENT_RATEPayment RateTFM_PPAYMENTDEC6
FIX_BASISCalculation Base AmountTFM_BBASIS2CURR7
VAR_INT_REFReference Interest RateSZSREFCHAR20*
VAR_SPREADPercentage rate for condition itemsPKONDDEC6
VAR_FORMULAFormula ReferenceTB_XFORMBECHAR8*
VAR_FORMULA_NAMEVariable NameTB_VARNAMECHAR8
VAR_1ST_PER_RATEInterest Rate for the First PeriodTFM_PKOND1STPERDEC6
CALC_METHODInterest Calculation MethodSZBMETHCHAR2
CALC_METHOD_CALInterest CalendarTFMSKALIDWTCHAR4
CALC_TYPEType of Interest CalculationTFMSINTCALCNUMC2
CALC_EXP_FREQInterest Settlement Frequency for Exponential Interest Calc.TFM_AMMRHYZVNUMC4
CALC_IMM_SETTLEIndicator for Immediate Settlement (Financial Mathematics)TFMSOFVERRCHAR2
AMOUNTCondition Item Currency AmountBKONDCURR7
AMOUNT_CURRENCYCurrency of Condition ItemSWHRKONDCUKY10*
AMOUNT_TEMP_CALCIndicator for Pro Rata Temporis CalculationsVVSZEITANTNUMC2
CALCDATCalculation DateDVALUTDATS16
CALCDAT_INCLInclusive indicator for beginning and end of a periodVVSINCLNUMC2
CALCDAT_MONTHENDMonth-End Indicator for Calculation DateVVSBULTCHAR2
CALCDAT_WKDAYSFTWorking Day Shift for Calculation DayTB_SVWERKNUMC2
CALCDAT_SFTDAYSNumber of Days for Relative Calculation of Value DateTB_AVGSTAGINT44
CALCDAT_SFTDIRDirection of Daily ShiftFTI_SFTDIRCHAR2
CALCDAT_PERRULEMethod for determining the next value dateTB_SVMETHNUMC2
CALCDAT_ADJRULERule for Date Update for Interest Rate AdjustmentTFMSRHYZAPNUMC2
DUEDATDue dateDFAELLDATS16
DUEDAT_MONTHENDMonth-End Indicator for Due DateSFULTCHAR2
DUEDAT_SFTENDShift Due DateTFMSFRANZNUMC2
DUEDAT_WKDAYSFTWorking Day Shift for Due DateTB_SFWERKNUMC2
DUEDAT_SFTDAYSNumber of days for rel. determination of due dateTB_AFGSTAGINT44
DUEDAT_SFTDIRDirection of Daily ShiftFTI_SFTDIRCHAR2
DUEDAT_DUERULEMethod for determining the next due dateTB_SFMETHNUMC2
DUEDAT_FIXRULERule for Date UpdateTFMSRHYNUMC2
DUEDAT_FIXREFDATReference Date for Interest Rate Determination DateTFMZRELDATNUMC2
FREQUENCYCycleTFMARHYNUMC6
FREQUENCY_UNITUnit for FrequencyTFMURHYNUMC2
CALENDAR1Factory calendarSKALIDCHAR4
CALENDAR2Factory calendarSKALIDCHAR4
CALENDAR3Factory calendarSKALIDCHAR4
ROUNDRounding CategoryTFM_SROUNDCHAR2
ROUND_UNITRounding UnitTFMPRUNITDEC7
SINGLE_DATESLevel number of condition item for recurring paymentsNSTUFENUMC4
DISCOUNTDiscounting CategoryTFM_SDISCOUNTNUMC2
VARNAMEVariable NameTB_VARNAMECHAR8
ALT_INT_RATEPercentage rate for condition itemsPKONDDEC6
ALT_INT_REFReference Interest RateSZSREFCHAR20*
Privacy Policy