| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | CONDAREA | Condition Area | nvarchar | 4 | 0 | CHAR | (N' ') | No | TBKK80 | BKK_CONDAR | Allow NULL? |
| 3 | COND | Condition ID | nvarchar | 10 | 0 | CHAR | (N' ') | No | | BKK_CON | Allow NULL? |
| 4 | VALIDFROM | Valid from | nvarchar | 8 | 0 | CHAR | (N' ') | No | | BKK_VALFRO | Allow NULL? |
| 5 | CONDCATG | Bank Condition Category | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TBKK81 | BKK_CONCAT | Allow NULL? |
| 6 | CONDDIF | 1st Conditions Type Differentiation | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TBKK82 | BKK_CONDIF | Allow NULL? |
| 7 | CONDDIF_V1 | Condition Differentiation Value | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BKK_CONVAL | Allow NULL? |
| 8 | CONDDIF_2 | 2nd Condition Type Differentiation | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TBKK82 | BKK_COND_2 | Allow NULL? |
| 9 | CONDDIF_V2 | Condition Differentiation Value | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BKK_CONVAL | Allow NULL? |
| 10 | CURR | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 11 | INTMET | Interest calculation method | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_INTMET | Allow NULL? |
| 12 | STGMETH | Daily Method | char | 1 | 0 | NUMC | (N'0') | Yes | | VVSTGMETH | Allow NULL? |
| 13 | STGBASIS | Base Days Method | char | 1 | 0 | CHAR | (N' ') | Yes | | VVSTGBASIS | Allow NULL? |
| 14 | CALCTYP | Scaled/Interval Calculation | char | 1 | 0 | NUMC | (N'0') | Yes | | BKK_CALCTY | Allow NULL? |
| 15 | FLGFROMTO | Indicator from-to | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_FROMTO | Allow NULL? |
| 16 | FLGADDDEBI | Overdraft Interest in Addition to Debit Interest | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_ADDDEB | Allow NULL? |
| 17 | CONDTIME | Period for Condition | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | BKK_CONTIM | Allow NULL? |
| 18 | CONDTIME_U | Time Unit for Conditions | char | 1 | 0 | NUMC | (N'0') | Yes | | BKK_CONTUN | Allow NULL? |
| 19 | TIMEPROPCALC | Pro Rata Method | char | 1 | 0 | NUMC | (N'0') | Yes | | BKK_TIMEPROCALC | Allow NULL? |
| 20 | FREECOUNT | Number of Free Items | nvarchar | 7 | 0 | NUMC | (N'0000000') | Yes | | BKK_FREECT | Allow NULL? |
| 21 | EXEMPTLIM | Allowance | decimal | 17 | 2 | CURR | ((0)) | Yes | | BKK_EXLIM | |
| 22 | FLGLOCKED | Block Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_FLGLOC | Allow NULL? |
| 23 | SORTF | Sort string | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BKK_SORTF | Allow NULL? |
| 24 | USEDTILL | Date till when Condition was Used | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BKK_USED | Allow NULL? |
| 25 | XSURCHARGE | Flag: Markup Condition | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_SURCHG | Allow NULL? |
| 26 | SROUND | Rounding Category | char | 1 | 0 | CHAR | (N' ') | Yes | | TFM_SROUND | Allow NULL? |
| 27 | PRUNIT | Rounding Unit | decimal | 13 | 7 | DEC | ((0)) | Yes | | TFMPRUNIT | |
| 28 | ADINTMET | Calculation Method of Interest Penalty | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_ADINTMET | Allow NULL? |
| 29 | XZEROLIM | Zero Is Minimum/Maximum | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XZEROLIM | Allow NULL? |
| 30 | CRUSER | Created by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | BKK_CRUSER | Allow NULL? |
| 31 | CRDATE | Creation Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BKK_CRDATE | Allow NULL? |
| 32 | CRTIME | Creation Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | BKK_CRTIME | Allow NULL? |
| 33 | CHGUSER | Last changed by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | BKK_CHUSER | Allow NULL? |
| 34 | CHGDATE | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BKK_CHDATE | Allow NULL? |
| 35 | CHGTIME | Time Changed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | BKK_CHTIME | Allow NULL? |
| 36 | RELUSER | Released By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | BKK_RLUSER | Allow NULL? |
| 37 | RELDATE | Release date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BKK_RLDATE | Allow NULL? |
| 38 | RELTIME | Release Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | BKK_RLTIME | Allow NULL? |
| 39 | X_DUEDATE | Indicator: SFP Condition based on Due Date | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_DTE_FLG_COND_SFP_DUEDATE | Allow NULL? |
| 40 | X_VD_DUEDATE | Calculate Value Date Based on Due Date | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_DTE_FLG_COND_VD_DUEDATE | Allow NULL? |
