| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | HBKID | Short Key for a House Bank | nvarchar | 5 | 0 | | | | Allow NULL? |
| 4 | HKTID | ID for account details | nvarchar | 5 | 0 | | | | Allow NULL? |
| 5 | AZNUM | Statement number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 6 | SNUMMC | Consecutive number of C-record in BK01 tape | nvarchar | 2 | 0 | | | | Allow NULL? |
| 7 | BANK | Bank data | nvarchar | 12 | 0 | | | | Allow NULL? |
| 8 | KTONR | Account | nvarchar | 24 | 0 | | | | Allow NULL? |
| 9 | SATZL_1 | Record length | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | SATZA_2 | Record type | char | 1 | 0 | | | | Allow NULL? |
| 11 | BANKL_3 | Bank number of dispatching credit institute | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | BANKL_4 | Bank number of dispatching credit institute | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | KONTOBV_5 | Bank procedure account number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 14 | LEER13_6 | Empty | nvarchar | 13 | 0 | | | | Allow NULL? |
| 15 | TEXTSCHL_7A | Text key part 1: Indicator for transaction | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | TEXTSCHL_7B | Text key part 2: Indicator for transaction | nvarchar | 3 | 0 | | | | Allow NULL? |
| 17 | LEER_8 | Empty | char | 1 | 0 | | | | Allow NULL? |
| 18 | BETRAG_9 | Amount align right without comma | nvarchar | 11 | 0 | | | | Allow NULL? |
| 19 | BANKLMIETER_10 | Bank number of first paying credit institute (tenant) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 20 | KONTOMIETER_11 | Clearing account number of sold-to party (tenant) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 21 | LEER_12 | Empty | nvarchar | 11 | 0 | | | | Allow NULL? |
| 22 | LEER_13 | Empty | nvarchar | 3 | 0 | | | | Allow NULL? |
| 23 | NAME_EMP_14A | Name of recipient (apartment company) | nvarchar | 27 | 0 | | | | Allow NULL? |
| 24 | LEER_14B | Empty 8 characters | nvarchar | 8 | 0 | | | | Allow NULL? |
| 25 | NAME_AG_15 | Sold-to party (tenant) | nvarchar | 27 | 0 | | | | Allow NULL? |
| 26 | VWZWECK_16 | Purpose | nvarchar | 27 | 0 | | | | Allow NULL? |
| 27 | LEER_17 | Empty | nvarchar | 3 | 0 | | | | Allow NULL? |
| 28 | ANZERWEIT | Number of file extensions (00-15) in table RFVIBK01V | nvarchar | 2 | 0 | | | | Allow NULL? |
