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)".
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 |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | |
CODULCO_UUID | Correspondence object deal's underlying: Condition UUID | X | FTR_CODULCOID | RAW | 16 | |
CODMD_UUID | Correspondence Object Deal's main data UUID | FTR_CODMDID | RAW | 16 | ||
CODUL_UUID | Correspondence object deal's underlying data UUID | FTR_CODULID | RAW | 16 | ||
.INCLUDE | TCORS_CODULCO_INCL | 0 | ||||
COMPANYCODE | Company Code | BUKRS | CHAR | 8 | ||
DEAL_NUMBER | Position-Generating Financial Transaction | FTI_POSRFHA | CHAR | 26 | ||
UL_NUMBER | Number of Underlying Transaction | FTI_RFHA_UL | CHAR | 26 | * | |
COND_NUMBER | Condition | TB_KOND | NUMC | 8 | ||
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 | Condition Item Effective From | DGUEL_KP | DATS | 16 | ||
EFF_FROM_EXCL | Exclusive indicator for start date of condition position | TFMSEXCLKP | NUMC | 2 | ||
DIRECTION | Direction of Transaction | TB_RKONDGR | 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 | Percentage rate for condition items | PKOND | 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 Determination Date | TFMZRELDAT | 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 | ||
SINGLE_DATES | Level number of condition item for recurring payments | NSTUFE | NUMC | 4 | ||
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 | * |