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 | * |