| 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 | DOCNO_AI | Item number in current accounts | nvarchar | 12 | 0 | | | | Allow NULL? |
| 4 | POSNO | Position in Item | nvarchar | 3 | 0 | | | | Allow NULL? |
| 5 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | | | Allow NULL? |
| 6 | BUPA_NO | Business Partner Account Holder | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | DATE_VALUE | Value date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | DATE_POST | Posting date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | TCUR | Transaction Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 10 | T_AMOUNT | Amount in Transaction Currency | decimal | 17 | 2 | | | | |
| 11 | ACUR | Account Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 12 | A_AMOUNT | Amount in Account Currency | decimal | 17 | 2 | | | | |
| 13 | MEDIUM | Medium | nvarchar | 4 | 0 | | | | Allow NULL? |
| 14 | PAYMETHOD | Payment Method | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 16 | BUTXT | Posting Text | nvarchar | 50 | 0 | | | | Allow NULL? |
| 17 | STATUS | Status of Info Items | char | 1 | 0 | | | | Allow NULL? |
| 18 | PROCESS | Processes in BCA | nvarchar | 4 | 0 | | | | Allow NULL? |
| 19 | REF_BANKS | Reference Country Key of Bank | nvarchar | 3 | 0 | | | | Allow NULL? |
| 20 | REF_BANKL | Reference Bank Key | nvarchar | 15 | 0 | | | | Allow NULL? |
| 21 | REF_ACEXT | Reference Account Number | nvarchar | 35 | 0 | | | | Allow NULL? |
| 22 | REF_IBAN | Reference IBAN | nvarchar | 35 | 0 | | | | Allow NULL? |
| 23 | REF_NAME | Reference Name of Account Holder | nvarchar | 70 | 0 | | | | Allow NULL? |
| 24 | CRUSR | User who created the object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 25 | CRDAT | Date on which the object was created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | | | Allow NULL? |
| 27 | CHUSR | Last user to change object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 28 | CHDAT | Date on which the object was last changed | nvarchar | 8 | 0 | | | | Allow NULL? |
| 29 | CHTIM | Time at Which Object was Last Changed | nvarchar | 6 | 0 | | | | Allow NULL? |
| 30 | RLUSR | User who released object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 31 | RLDAT | Date on which object was released | nvarchar | 8 | 0 | | | | Allow NULL? |
| 32 | RLTIM | Time at Which Object Was Released | nvarchar | 6 | 0 | | | | Allow NULL? |
