| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | FILE_NAME | File Name Prefix | nvarchar | 12 | 0 | | | | Allow NULL? |
| 3 | RUN_NO | Sequential Number of a File | nvarchar | 5 | 0 | | | | Allow NULL? |
| 4 | RUN_NO_ADD | Second Sequential Number in EFT Administration | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | ITEM_NO | Sequential Number (5-Figure) | nvarchar | 5 | 0 | | | | Allow NULL? |
| 6 | BANKS | Bank country key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 7 | BANKL | Bank Keys | nvarchar | 15 | 0 | | | | Allow NULL? |
| 8 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | | | | Allow NULL? |
| 9 | ACIBAN | International Bank Account Number | nvarchar | 35 | 0 | | | | Allow NULL? |
| 10 | NAME | Account holder name | nvarchar | 70 | 0 | | | | Allow NULL? |
| 11 | REFNO_CR | Reference Number of Creation | nvarchar | 20 | 0 | | | | Allow NULL? |
| 12 | REFNO_PAYM | Reference Number from Payment Transactions | nvarchar | 20 | 0 | | | | Allow NULL? |
| 13 | REFNO_PN | Daybook number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 14 | DATE_CR | Creation Date of the Data Medium | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | DATE_VALUE | Value date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | DATE_POST | Posting date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | TCUR | Transaction Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 18 | NTCUR | Reporting Transaction Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 19 | T_AMOUNT | Amount in Transaction Currency | decimal | 17 | 2 | | | | |
| 20 | NT_AMOUNT | Amount in Reporting Transaction Currency | decimal | 17 | 2 | | | | |
| 21 | T_CHARGE | Charge in Transaction Currency | decimal | 17 | 2 | | | | |
| 22 | NT_CHARGE | Charge in Reporting Transaction Currency | decimal | 17 | 2 | | | | |
| 23 | MEDIUM | Medium | nvarchar | 4 | 0 | | | | Allow NULL? |
| 24 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 25 | S_TRNSTYPE | Source Transaction Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 26 | RETURNK | Return Reason | nvarchar | 4 | 0 | | | | Allow NULL? |
| 27 | ITEMCNT | Number of Processed Items | nvarchar | 5 | 0 | | | | Allow NULL? |
| 28 | COUNTRY | Country | nvarchar | 3 | 0 | | | | Allow NULL? |
| 29 | X_ACTCHK_E | Indicator: Error in Check Digits for Account | char | 1 | 0 | | | | Allow NULL? |
| 30 | CHEQUE_NO | Check Number (External) | nvarchar | 20 | 0 | | | | Allow NULL? |
| 31 | REF_BANKS | Reference Country Key of Bank | nvarchar | 3 | 0 | | | | Allow NULL? |
| 32 | REF_BANKL | Reference Bank Key | nvarchar | 15 | 0 | | | | Allow NULL? |
| 33 | REF_ACEXT | Reference Account Number | nvarchar | 35 | 0 | | | | Allow NULL? |
| 34 | REF_IBAN | Reference IBAN | nvarchar | 35 | 0 | | | | Allow NULL? |
| 35 | REF_NAME | Reference Name of Account Holder | nvarchar | 70 | 0 | | | | Allow NULL? |
| 36 | ITEMTYPE | Type of Payment Item | nvarchar | 2 | 0 | | | | Allow NULL? |
| 37 | XCRED | Indicator: Credit | char | 1 | 0 | | | | Allow NULL? |
