| 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 | * | MANDT | Allow NULL? |
| 2 | BKKRS | Bank Area | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | BKK_BKKRS | Allow NULL? |
| 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | BKK_ACCNT | Allow NULL? |
| 4 | CLOS_TYP | Consolidation Frequency | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | BKK_CLSTYP | Allow NULL? |
| 5 | CLOS_YEAR | Year of the closing period | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | BKK_CLYEAR | Allow NULL? |
| 6 | CLOS_NR | Number of Balancing Period | nvarchar | 3 | 0 | NUMC | (N'000') | No | | BKK_CLNR | Allow NULL? |
| 7 | CLOS_NRADD | Addition to Balancing Period Number | nvarchar | 3 | 0 | NUMC | (N'000') | No | | BKK_CLNRAD | Allow NULL? |
| 8 | POSTCATG_I | Posting Category for Balancing Postings | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | BKK_POSTCG | Allow NULL? |
| 9 | POSTCATADD | Consecutive Number per Posting Type | nvarchar | 3 | 0 | NUMC | (N'000') | No | | BKK_POADD | Allow NULL? |
| 10 | BANKS | Bank country key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | BANKS | Allow NULL? |
| 11 | BANKL | Bank Keys | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | BANKK | Allow NULL? |
| 12 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BKK_ACEXT | Allow NULL? |
| 13 | DATE_VALUE | Value date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BKK_VALDAT | Allow NULL? |
| 14 | DATE_POST | Posting date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BKK_PSTDAT | Allow NULL? |
| 15 | WAERS | Account Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | BKK_ACUR | Allow NULL? |
| 16 | AMOUNT | Amount in Account Currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | BKK_AAMNT | |
| 17 | LCUR | Local Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | BKK_LCUR | Allow NULL? |
| 18 | L_AMOUNT | Amount in Local Currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | BKK_LAMNT | |
| 19 | NCUR | Reporting Account Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | BKK_NACUR | Allow NULL? |
| 20 | N_AMOUNT | Amount in Information Account Currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | BKK_NAAMNT | |
| 21 | PAYM_NOTE | Purpose | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | BKK_PAYNTE | Allow NULL? |
| 22 | STATTODEL | Status for Acct. Closure | char | 1 | 0 | NUMC | (N'0') | Yes | | BKK_DELST | Allow NULL? |
| 23 | REFACCT | Reference Account: Internal Control | char | 1 | 0 | NUMC | (N'0') | Yes | | BKK_REFACCT | Allow NULL? |
| 24 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BKK_TTYPE | Allow NULL? |
| 25 | MEDIUM | Medium | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BKK_MEDIUM | Allow NULL? |
