| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | CODCO_UUID | Correspondence Object: Deal Conditions UUID | varbinary | 16 | 0 | | | | |
| 3 | CODMD_UUID | Correspondence Object Deal's main data UUID | varbinary | 16 | 0 | | | | |
| 4 | COMPANYCODE | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | DEAL_NUMBER | Position-Generating Financial Transaction | nvarchar | 13 | 0 | | | | Allow NULL? |
| 6 | COND_NUMBER | Condition | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | EFF_FROM | Condition Item Valid From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | DIRECTION | Direction of Transaction | char | 1 | 0 | | | | Allow NULL? |
| 9 | SINGLE_DATES | Level number of condition item for recurring payments | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | TYPE | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | CLASS | Classification of flows and conditions | char | 1 | 0 | | | | Allow NULL? |
| 12 | CATEGORY | Category of Flows and Conditions | nvarchar | 2 | 0 | | | | Allow NULL? |
| 13 | EFF_FROM_EXCL | Exclusive indicator for start date of condition position | char | 1 | 0 | | | | Allow NULL? |
| 14 | CREATE_USER | Entered by | nvarchar | 12 | 0 | | | | Allow NULL? |
| 15 | CREATE_DATE | Entered On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | CREATE_TIME | Entry Time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 17 | UPDATE_USER | Last Changed by | nvarchar | 12 | 0 | | | | Allow NULL? |
| 18 | UPDATE_DATE | Changed on | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | UPDATE_TIME | Time changed | nvarchar | 6 | 0 | | | | Allow NULL? |
| 20 | ZERO_CONDITION | Condition Form | char | 1 | 0 | | | | Allow NULL? |
| 21 | FIX_PERC_RATE | Percentage rate for condition items | decimal | 10 | 7 | | | | |
| 22 | FIX_PAYMENT_RATE | Payment Rate | decimal | 11 | 7 | | | | |
| 23 | FIX_BASIS | Calculation Base Amount | decimal | 13 | 2 | | | | |
| 24 | VAR_INT_REF | Reference Interest Rate | nvarchar | 10 | 0 | | | | Allow NULL? |
| 25 | VAR_SPREAD | Spread for Reference Interest Rate (Variable Interest) | decimal | 10 | 7 | | | | |
| 26 | VAR_FORMULA | Formula Reference | nvarchar | 4 | 0 | | | | Allow NULL? |
| 27 | VAR_FORMULA_NAME | Variable Name | nvarchar | 4 | 0 | | | | Allow NULL? |
| 28 | VAR_1ST_PER_RATE | Interest Rate for the First Period | decimal | 10 | 7 | | | | |
| 29 | CALC_METHOD | Interest Calculation Method | char | 1 | 0 | | | | Allow NULL? |
| 30 | CALC_METHOD_CAL | Interest Calendar | nvarchar | 2 | 0 | | | | Allow NULL? |
| 31 | CALC_TYPE | Type of interest calculation | char | 1 | 0 | | | | Allow NULL? |
| 32 | CALC_EXP_FREQ | Interest Settlement Frequency for Exponential Interest Calc. | nvarchar | 2 | 0 | | | | Allow NULL? |
| 33 | CALC_IMM_SETTLE | Indicator for Immediate Settlement (Financial Mathematics) | char | 1 | 0 | | | | Allow NULL? |
| 34 | AMOUNT | Condition item currency amount | decimal | 13 | 2 | | | | |
| 35 | AMOUNT_CURRENCY | Currency of Condition Item | nvarchar | 5 | 0 | | | | Allow NULL? |
| 36 | AMOUNT_TEMP_CALC | Indicator for Pro Rata Temporis Calculations | char | 1 | 0 | | | | Allow NULL? |
| 37 | CALCDAT | Calculation Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 38 | CALCDAT_INCL | Inclusive indicator for beginning and end of a period | char | 1 | 0 | | | | Allow NULL? |
| 39 | CALCDAT_MONTHEND | Month-end indicator for calculation date | char | 1 | 0 | | | | Allow NULL? |
| 40 | CALCDAT_WKDAYSFT | Working Day Shift for Calculation Day | char | 1 | 0 | | | | Allow NULL? |
| 41 | CALCDAT_SFTDAYS | Number of Days for Relative Calculation of Value Date | int | 10 | 0 | | | | Allow NULL? |
| 42 | CALCDAT_SFTDIR | Direction of Daily Shift | char | 1 | 0 | | | | Allow NULL? |
| 43 | CALCDAT_PERRULE | Method for determining the next value date | char | 1 | 0 | | | | Allow NULL? |
| 44 | CALCDAT_ADJRULE | Rule for Date Update for Interest Rate Adjustment | char | 1 | 0 | | | | Allow NULL? |
| 45 | DUEDAT | Due date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 46 | DUEDAT_MONTHEND | Month-End Indicator for Due Date | char | 1 | 0 | | | | Allow NULL? |
| 47 | DUEDAT_SFTEND | Shift Due Date | char | 1 | 0 | | | | Allow NULL? |
| 48 | DUEDAT_WKDAYSFT | Working Day Shift for Due Date | char | 1 | 0 | | | | Allow NULL? |
| 49 | DUEDAT_SFTDAYS | Number of days for rel. determination of due date | int | 10 | 0 | | | | Allow NULL? |
| 50 | DUEDAT_SFTDIR | Direction of Daily Shift | char | 1 | 0 | | | | Allow NULL? |
| 51 | DUEDAT_DUERULE | Method for determining the next due date | char | 1 | 0 | | | | Allow NULL? |
| 52 | DUEDAT_FIXRULE | Rule for Date Update | char | 1 | 0 | | | | Allow NULL? |
| 53 | DUEDAT_FIXREFDAT | Reference Date for Interest Rate Fixing Date | char | 1 | 0 | | | | Allow NULL? |
| 54 | FREQUENCY | Cycle | nvarchar | 3 | 0 | | | | Allow NULL? |
| 55 | FREQUENCY_UNIT | Unit for Frequency | char | 1 | 0 | | | | Allow NULL? |
| 56 | CALENDAR1 | Factory calendar | nvarchar | 2 | 0 | | | | Allow NULL? |
| 57 | CALENDAR2 | Factory calendar | nvarchar | 2 | 0 | | | | Allow NULL? |
| 58 | CALENDAR3 | Factory calendar | nvarchar | 2 | 0 | | | | Allow NULL? |
| 59 | ROUND | Rounding Category | char | 1 | 0 | | | | Allow NULL? |
| 60 | ROUND_UNIT | Rounding Unit | decimal | 13 | 7 | | | | |
| 61 | DISCOUNT | Discounting Category | char | 1 | 0 | | | | Allow NULL? |
| 62 | VARNAME | Variable Name | nvarchar | 4 | 0 | | | | Allow NULL? |
| 63 | ALT_INT_RATE | Percentage rate for condition items | decimal | 10 | 7 | | | | |
| 64 | ALT_INT_REF | Reference Interest Rate | nvarchar | 10 | 0 | | | | Allow NULL? |
| 65 | STTLM_FREQ | COMS: Settlement Frequency | tinyint | 3 | 0 | | | | |
| 66 | STTLM_FREQ_UNIT | COMS: Settlement Frequency Unit | char | 1 | 0 | | | | Allow NULL? |
| 67 | PAYDAT_OFFS_UNIT | COMS: Unit for Payment Date Offset | char | 1 | 0 | | | | Allow NULL? |
| 68 | COMMON_PRICING | Indicates Whether Common Pricing Is Used for Average Pricing | char | 1 | 0 | | | | Allow NULL? |
| 69 | FIXING_DATE_RULE | COMS: Fixing Date Rule for COMS | char | 1 | 0 | | | | Allow NULL? |
| 70 | WEEKDAY_NUMBER | COMS: Frequency of Occurrence of Weekday in Period | tinyint | 3 | 0 | | | | |
| 71 | WEEKDAY | COMS: Day of Week for Price Fixing | char | 1 | 0 | | | | Allow NULL? |
| 72 | AVERAGE_FREQ | COMS: Frequency for Average | smallint | 5 | 0 | | | | |
| 73 | QUAN | Quantity | decimal | 13 | 3 | | | | |
| 74 | UNIT_OF_MEASURE | Unit of Measure for the Commodity | nvarchar | 3 | 0 | | | | Allow NULL? |
| 75 | QUAN_RELATED_TO | Quantity Related To | char | 1 | 0 | | | | Allow NULL? |
