| 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 | PAORN | Payment order number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 4 | POSNO | Item in Payment Order | nvarchar | 5 | 0 | | | | Allow NULL? |
| 5 | BKKRS_ITEM | Bank Area Items in Payment Order | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | BANKS | Bank country key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | BANKL | Bank Keys | nvarchar | 15 | 0 | | | | Allow NULL? |
| 9 | SWIFT | SWIFT/BIC for International Payments | nvarchar | 11 | 0 | | | | Allow NULL? |
| 10 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | | | | Allow NULL? |
| 11 | BKS | Bank Control Key | nvarchar | 2 | 0 | | | | Allow NULL? |
| 12 | ACNUM_IBAN | International Bank Account Number | nvarchar | 35 | 0 | | | | Allow NULL? |
| 13 | BUPA_NO | Business Partner Account Holder | nvarchar | 10 | 0 | | | | Allow NULL? |
| 14 | BUPA_NAME | Account holder name | nvarchar | 70 | 0 | | | | Allow NULL? |
| 15 | X_ACTCHK_E | Indicator: Error in Check Digits for Account | char | 1 | 0 | | | | Allow NULL? |
| 16 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 17 | MEDIUM | Medium | nvarchar | 4 | 0 | | | | Allow NULL? |
| 18 | PAYMETHOD | Payment Method | nvarchar | 4 | 0 | | | | Allow NULL? |
| 19 | BUTXT | Posting Text | nvarchar | 50 | 0 | | | | Allow NULL? |
| 20 | DATE_VALUE | Value date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 21 | XVALDATSET | Indicator: Value Date was Specified | char | 1 | 0 | | | | Allow NULL? |
| 22 | TCUR | Transaction Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 23 | T_AMOUNT | Amount in Transaction Currency | decimal | 17 | 2 | | | | |
| 24 | T_CHARGE | Charge in Transaction Currency | decimal | 17 | 2 | | | | |
| 25 | NACUR | Reporting Account Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 26 | NA_AMOUNT | Amount in Information Account Currency | decimal | 17 | 2 | | | | |
| 27 | NA_CHARGE | Charge in Reporting Currency | decimal | 17 | 2 | | | | |
| 28 | ACUR | Account Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 29 | A_AMOUNT | Amount in Account Currency | decimal | 17 | 2 | | | | |
| 30 | A_CHARGE | Charge in Account Currency | decimal | 17 | 2 | | | | |
| 31 | EXCHNGRATE | Exchange Rate | decimal | 9 | 5 | | | | |
| 32 | CHEQUE_TYP | Means of Payment Position Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 33 | CHEQUE_NO | Check Number (External) | nvarchar | 20 | 0 | | | | Allow NULL? |
| 34 | XCHK_CHQUE | Indicator: Check for the Check (Cheque) Switched Off? | char | 1 | 0 | | | | Allow NULL? |
| 35 | XCHK_VALUE | Indicator, value date check exluded? | char | 1 | 0 | | | | Allow NULL? |
| 36 | XCHK_LIMIT | Indicator, limit check excluded? | char | 1 | 0 | | | | Allow NULL? |
| 37 | XCHK_ACLCK | Indicator, account block check excluded? | char | 1 | 0 | | | | Allow NULL? |
| 38 | XCHK_BPLCK | Indicator, business partner check excluded? | char | 1 | 0 | | | | Allow NULL? |
| 39 | XCHK_MANDATE | Exclude Mandate Check | char | 1 | 0 | | | | Allow NULL? |
| 40 | XCHK_PRENOTE | Exclude Prenote Check | char | 1 | 0 | | | | Allow NULL? |
| 41 | XCHK_EXTD_MND | Indicator: Extended Mandate Check Excluded? | char | 1 | 0 | | | | Allow NULL? |
| 42 | PUBLIC_CONT_L1 | Public Field Length 35 | nvarchar | 35 | 0 | | | | Allow NULL? |
| 43 | PUBLIC_CONT_L2 | Public Field Length 35 | nvarchar | 35 | 0 | | | | Allow NULL? |
| 44 | PUBLIC_CONT_L3 | Public Field Length 35 | nvarchar | 35 | 0 | | | | Allow NULL? |
| 45 | PUBLIC_CONT_L4 | Public Field Length 35 | nvarchar | 35 | 0 | | | | Allow NULL? |
| 46 | PUBLIC_CONT_S1 | Public Field Length 20 | nvarchar | 20 | 0 | | | | Allow NULL? |
| 47 | PUBLIC_CONT_S2 | Public Field Length 20 | nvarchar | 20 | 0 | | | | Allow NULL? |
| 48 | MANDATE_ID | Mandate Reference | nvarchar | 35 | 0 | | | | Allow NULL? |
| 49 | UCI | Creditor Identification | nvarchar | 35 | 0 | | | | Allow NULL? |
| 50 | PRENOTE_REF_NO | Prenote Reference ID | nvarchar | 40 | 0 | | | | Allow NULL? |
| 51 | PO_MGUID | SEPA Mandate: GUID of Mandate | varbinary | 16 | 0 | | | | |
| 52 | PO_MVERS | Version of Mandate used for Enrichment | nvarchar | 4 | 0 | | | | Allow NULL? |
| 53 | RECONC_SYSTEM | Identification of Supplying System | nvarchar | 10 | 0 | | | | Allow NULL? |
| 54 | RECONC_APPL | Reconciliation - Supplying Application ID | nvarchar | 5 | 0 | | | | Allow NULL? |
| 55 | RECONC_NO | Reconciliation Unit - Additional ID | nvarchar | 15 | 0 | | | | Allow NULL? |
| 56 | TAX_YEAR | Tax-year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 57 | AMOUNT_ID | Amount identifier code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 58 | CONTRIB_ID | Contribution identifier | nvarchar | 2 | 0 | | | | Allow NULL? |
| 59 | IRS_DCODE | Retirement plan distribution code | char | 1 | 0 | | | | Allow NULL? |
| 60 | IRS_SCODE | Retirement plan distribution sub-code | char | 1 | 0 | | | | Allow NULL? |
| 61 | WH_AMOUNT_TOTAL | Total fed withholding amount for IRA distribution payment | decimal | 17 | 2 | | | | |
| 62 | XMEMO_ITEM | Items are memo items | char | 1 | 0 | | | | Allow NULL? |
| 63 | REBOOK | Payment Items Were Transfer Posted | char | 1 | 0 | | | | Allow NULL? |
| 64 | AI_POST | Posting Decision: Interest Penalty | char | 1 | 0 | | | | Allow NULL? |
| 65 | REF_ACEXT | Reference Account Number | nvarchar | 35 | 0 | | | | Allow NULL? |
| 66 | REF_IBAN | Reference IBAN | nvarchar | 35 | 0 | | | | Allow NULL? |
| 67 | REF_NAME | Reference Name of Account Holder | nvarchar | 70 | 0 | | | | Allow NULL? |
| 68 | REF_BANKS | Reference Country Key of Bank | nvarchar | 3 | 0 | | | | Allow NULL? |
| 69 | REF_BANKL | Reference Bank Key | nvarchar | 15 | 0 | | | | Allow NULL? |
| 70 | REF_SWIFT | Reference SWIFT Code | nvarchar | 11 | 0 | | | | Allow NULL? |
