| 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 | CLOS_TYP | Consolidation Frequency | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | CLOS_YEAR | Year of the closing period | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | CLOS_NR | Number of Balancing Period | nvarchar | 3 | 0 | | | | Allow NULL? |
| 7 | CLOS_NRADD | Addition to Balancing Period Number | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | TURNOVER_CLASS | Turnover Class | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | CURR | Account Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 10 | START_DATE | Start date of period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | END_DATE | End Date of Period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | END_DATE_I | End Date of Interest Calculation | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | DATE_VALUE | Value date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | DATE_POST | Posting date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | DEBITS_INT | Amount Debit Interest | decimal | 17 | 2 | | | | |
| 16 | CREDIT_INT | Amount Credit Interest | decimal | 17 | 2 | | | | |
| 17 | OVERDR_INT | Amount Overdraft Interest | decimal | 17 | 2 | | | | |
| 18 | SUPPLY_INT | Loan Committment Interest Amount | decimal | 17 | 2 | | | | |
| 19 | CREDIT_INT_NEG | Amount Negative Credit Interest | decimal | 17 | 2 | | | | |
| 20 | DEBIT_INT_NEG | Amount Negative Debit Interest | decimal | 17 | 2 | | | | |
| 21 | ADVANC_INT | Amount of Interest Penalty | decimal | 17 | 2 | | | | |
| 22 | BONUS_INT | Bonus Amount | decimal | 17 | 2 | | | | |
| 23 | ITEM_FEE | Amount Item Charge | decimal | 17 | 2 | | | | |
| 24 | FORW_COST | Amount Dispatch Expenses | decimal | 17 | 2 | | | | |
| 25 | ACCONT_FEE | Amount Account Maintenance Charge | decimal | 17 | 2 | | | | |
| 26 | PERIOD_FEE | Amount Periodic Charge | decimal | 17 | 2 | | | | |
| 27 | CSTMR_AMT | Amount from Customer | decimal | 17 | 2 | | | | |
| 28 | BALANCE | Balance | decimal | 23 | 2 | | | | |
| 29 | WHTAX_AMT | Tax | decimal | 17 | 2 | | | | |
| 30 | LCUR | Local Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 31 | WHTAX_LAMT | Tax in Local Currency | decimal | 17 | 2 | | | | |
| 32 | INTRATE_AV | Average Interest Rate for Credit Interest | decimal | 10 | 7 | | | | |
| 33 | XCONDEXCHANG | Exchange Conditions During Account Balancing | char | 1 | 0 | | | | Allow NULL? |
| 34 | XACCLO | Flag: Balancing on Reference Account | char | 1 | 0 | | | | Allow NULL? |
| 35 | PROGN | Name of the Program/Report on an Application Process | nvarchar | 40 | 0 | | | | Allow NULL? |
| 36 | PROGDATE | Run Date of Program | nvarchar | 8 | 0 | | | | Allow NULL? |
| 37 | PROGNO | Sequential Number of the Program Run | nvarchar | 3 | 0 | | | | Allow NULL? |
| 38 | JOBNO | Number of jobs | smallint | 5 | 0 | | | | |
| 39 | CLOS_DATE | Balancing date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 40 | CLOS_TIME | Completion Time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 41 | NCUR | Reporting Account Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 42 | NBALANCE | Balance Share in Reporting Currency | decimal | 23 | 2 | | | | |
| 43 | XNOPOST | Flag: Balancing not Posted | char | 1 | 0 | | | | Allow NULL? |
| 44 | CSTMR_AMT1 | Amount from Customer | decimal | 17 | 2 | | | | |
| 45 | CSTMR_AMT2 | Amount from Customer | decimal | 17 | 2 | | | | |
| 46 | CSTMR_AMT3 | Amount from Customer | decimal | 17 | 2 | | | | |
