| 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 | BALOBJCATG | Object category for balancing | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | CLOS_TYP | Consolidation Frequency | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | CLOS_YEAR | Year of the closing period | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | CLOS_NR | Number of Balancing Period | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | CLOS_NRADD | Addition to Balancing Period Number | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | TURNOVER_CLASS | Turnover Class | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | CONDCATG | Bank Condition Category | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | NUMB | Sequence number | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | POSTCATG_I | Posting Category for Balancing Postings | nvarchar | 2 | 0 | | | | Allow NULL? |
| 13 | CALCFROM | Date of 'Calculation from' | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | ULTIFROM | Month-End Indicator for Start of a Calculation Period | char | 1 | 0 | | | | Allow NULL? |
| 15 | BASE_CURR | Currency of Base Amount | nvarchar | 5 | 0 | | | | Allow NULL? |
| 16 | BASE | Calculation Base Amount | decimal | 17 | 2 | | | | |
| 17 | CALCTO | 'Calculation to' date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 18 | ULTITO | Month-End Indicator for the End of a Calculation Period | char | 1 | 0 | | | | Allow NULL? |
| 19 | DAYS_NUMB | Number of Days | int | 10 | 0 | | | | Allow NULL? |
| 20 | DAYS_BASE | Number of base days in a calculation period | nvarchar | 6 | 0 | | | | Allow NULL? |
| 21 | RATE | Percentage rate for condition items | decimal | 10 | 7 | | | | |
| 22 | CURR | Currency of Current Account | nvarchar | 5 | 0 | | | | Allow NULL? |
| 23 | AMOUNT | Amount with 5 Decimal Points | decimal | 17 | 5 | | | | |
| 24 | NCUR | Reporting Account Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 25 | NAMOUNT | Amount with 5 Decimal Points | decimal | 17 | 5 | | | | |
| 26 | ITEMCOUNT | Settled Items | decimal | 8 | 0 | | | | |
| 27 | ITEMCNT_O | Actual Items | decimal | 8 | 0 | | | | |
| 28 | FEES_BASE | Amount | decimal | 17 | 2 | | | | |
| 29 | DEVIDER | Divisor for Charges | decimal | 4 | 0 | | | | |
| 30 | POOL_METH | Interest Compensation Method | nvarchar | 4 | 0 | | | | Allow NULL? |
