| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | ITEMSTATUS | Status of Payment Item | nvarchar | 2 | 0 | | | | Allow NULL? |
| 3 | BKKRS | Bank Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | | | | Allow NULL? |
| 5 | DOCNO | Item number in current accounts | nvarchar | 12 | 0 | | | | Allow NULL? |
| 6 | POSNO | Position in Item | nvarchar | 3 | 0 | | | | Allow NULL? |
| 7 | ITEMTYPE | Type of Payment Item | nvarchar | 2 | 0 | | | | Allow NULL? |
| 8 | PROCESS | Processes in BCA | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | DATE_POST | Posting date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | XERR_SYST | Indicator, error Customizing/master data? | char | 1 | 0 | | | | Allow NULL? |
| 12 | XERR_ENQUE | Indicator, error in blocking account balance? | char | 1 | 0 | | | | Allow NULL? |
| 13 | XERR_CHQUE | Indicator, error in position management check? | char | 1 | 0 | | | | Allow NULL? |
| 14 | XERR_VALUE | Indicator, error in value date check? | char | 1 | 0 | | | | Allow NULL? |
| 15 | XERR_LIMIT | Indicator, error in limit check? | char | 1 | 0 | | | | Allow NULL? |
| 16 | XERR_ACLCK | Indicator, error in account check? | char | 1 | 0 | | | | Allow NULL? |
| 17 | XERR_BPLCK | Indicator, error in business partner check? | char | 1 | 0 | | | | Allow NULL? |
| 18 | XERR_CUREX | Indicator, error due to block/currency changeover? | char | 1 | 0 | | | | Allow NULL? |
| 19 | XERR_PSTFU | Indicator - Posting Date is in the Future | char | 1 | 0 | | | | Allow NULL? |
| 20 | XERR_MANDATE | Error in Mandate Lock Check | char | 1 | 0 | | | | Allow NULL? |
| 21 | XERR_PRENOTE | Error in Prenote Check | char | 1 | 0 | | | | Allow NULL? |
| 22 | XERR_EXTD_MND | Indicator - Error in Extended Mandate Checks | char | 1 | 0 | | | | Allow NULL? |
| 23 | TAX_YEAR | Tax-year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 24 | AMOUNT_ID | Amount identifier code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 25 | CONTRIB_ID | Contribution identifier | nvarchar | 2 | 0 | | | | Allow NULL? |
| 26 | IRS_DCODE | Retirement plan distribution code | char | 1 | 0 | | | | Allow NULL? |
| 27 | IRS_SCODE | Retirement plan distribution sub-code | char | 1 | 0 | | | | Allow NULL? |
| 28 | WH_AMOUNT_TOTAL | Total fed withholding amount for IRA distribution payment | decimal | 17 | 2 | | | | |
| 29 | XMEMO_ITEM | Items are memo items | char | 1 | 0 | | | | Allow NULL? |
