| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | BKKRS | Bank Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | COND | Condition ID | nvarchar | 10 | 0 | | | | Allow NULL? |
| 5 | VALIDFROM | Valid from | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | VALIDTO | Valid to (Condition Header) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | CONDCATG | Bank Condition Category | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | CONDDIF | 1st Conditions Type Differentiation | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | CONDDIF_V1 | Condition Differentiation Value | nvarchar | 10 | 0 | | | | Allow NULL? |
| 10 | CONDDIF_2 | 2nd Condition Type Differentiation | nvarchar | 3 | 0 | | | | Allow NULL? |
| 11 | CONDDIF_V2 | Condition Differentiation Value | nvarchar | 10 | 0 | | | | Allow NULL? |
| 12 | CURR | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 13 | INTMET | Interest calculation method | char | 1 | 0 | | | | Allow NULL? |
| 14 | STGMETH | Daily Method | char | 1 | 0 | | | | Allow NULL? |
| 15 | STGBASIS | Base Days Method | char | 1 | 0 | | | | Allow NULL? |
| 16 | CALCTYP | Scaled/Interval Calculation | char | 1 | 0 | | | | Allow NULL? |
| 17 | FLGFROMTO | Indicator from-to | char | 1 | 0 | | | | Allow NULL? |
| 18 | FLGADDDEBI | Overdraft Interest in Addition to Debit Interest | char | 1 | 0 | | | | Allow NULL? |
| 19 | CONDTIME | Period for Condition | nvarchar | 4 | 0 | | | | Allow NULL? |
| 20 | CONDTIME_U | Time Unit for Conditions | char | 1 | 0 | | | | Allow NULL? |
| 21 | TIMEPROPCALC | Pro Rata Method | char | 1 | 0 | | | | Allow NULL? |
| 22 | FREECOUNT | Number of Free Items | nvarchar | 7 | 0 | | | | Allow NULL? |
| 23 | EXEMPTLIM | Allowance | decimal | 17 | 2 | | | | |
| 24 | FLGLOCKED | Block Indicator | char | 1 | 0 | | | | Allow NULL? |
| 25 | SORTF | Sort string | nvarchar | 10 | 0 | | | | Allow NULL? |
| 26 | USEDTILL | Date till when Condition was Used | nvarchar | 8 | 0 | | | | Allow NULL? |
| 27 | XSURCHARGE | Flag: Markup Condition | char | 1 | 0 | | | | Allow NULL? |
| 28 | SROUND | Rounding Category | char | 1 | 0 | | | | Allow NULL? |
| 29 | PRUNIT | Rounding Unit | decimal | 13 | 7 | | | | |
| 30 | ADINTMET | Calculation Method of Interest Penalty | char | 1 | 0 | | | | Allow NULL? |
| 31 | XZEROLIM | Zero Is Minimum/Maximum | char | 1 | 0 | | | | Allow NULL? |
| 32 | CRUSER | Created by | nvarchar | 12 | 0 | | | | Allow NULL? |
| 33 | CRDATE | Creation Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 34 | CRTIME | Creation Time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 35 | CHGUSER | Last changed by | nvarchar | 12 | 0 | | | | Allow NULL? |
| 36 | CHGDATE | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 37 | CHGTIME | Time Changed | nvarchar | 6 | 0 | | | | Allow NULL? |
| 38 | RELUSER | Released By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 39 | RELDATE | Release date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 40 | RELTIME | Release Time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 41 | X_DUEDATE | Indicator: SFP Condition based on Due Date | char | 1 | 0 | | | | Allow NULL? |
| 42 | X_VD_DUEDATE | Calculate Value Date Based on Due Date | char | 1 | 0 | | | | Allow NULL? |
