| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | PO_ID | Payment Order GUID | varbinary | 16 | 0 | RAW | | No | | BKK_DTE_PXPO_ID | |
| 3 | BKKRS | Bank Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TBKK01 | BKK_BKKRS | Allow NULL? |
| 4 | PAORN | Payment order number | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | | BKK_PAORN | Allow NULL? |
| 5 | POST_DATE | Posting date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BKK_PSTDAT | Allow NULL? |
| 6 | AMOUNT | Amount in Transaction Currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | BKK_TAMNT | |
| 7 | CURRENCY | Transaction Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | BKK_TCUR | Allow NULL? |
| 8 | XCREDIT | Transaction Type Initiates a Credit | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_INPMNT | Allow NULL? |
| 9 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BKK_ACEXT | Allow NULL? |
| 10 | BANK_COUNTRY | Bank country key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | BANKS | Allow NULL? |
| 11 | BANKKEY | Bank number | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | BANKL | Allow NULL? |
| 12 | IBAN | International Bank Account Number | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BKK_ACIBAN | Allow NULL? |
| 13 | COLL_PO_REF | Collective Payment Order Reference Number | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | BKK_OPD_DTE_COL_PO_REF_NO | Allow NULL? |
| 14 | RCP_ITEM_COUNT | Number of RCPs | int | 10 | 0 | INT4 | ((0)) | Yes | | BKK_DTE_PXPO_NUM_RCP | Allow NULL? |
| 15 | CREATE_TMSTMP | Timestamp of Record Creation | decimal | 15 | 0 | DEC | ((0)) | Yes | | BKK_DTE_PXPO_TMSTMP_CREATE | |
| 16 | FORWARD_TECHNOLOGY | Possible Forwarding Technologies for Payment Orders | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | BKK_DTE_PXPO_TECH | Allow NULL? |
| 17 | SYS_TO | Target System For Receiving Payment Orders and Payment Items | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BKK_DTE_PXPO_SYSTEM_TO | Allow NULL? |
| 18 | RECONC_SYSTEM | Originating System for Payment Orders and Payment Items | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BKK_DTE_PXPO_SYSTEM_FROM | Allow NULL? |
| 19 | RECONC_APPL | Originating Application for Payment Orders and Payment Items | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | BKK_DTE_PXPO_APPLICATION_FROM | Allow NULL? |
| 20 | RECONC_NO | Reconciliation Number | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | BKK_DTE_PXPO_RECONC_NO | Allow NULL? |
| 21 | RI_BKKRS | Bank Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BKK_BKKRS | Allow NULL? |
| 22 | RI_PAORN | Payment order number | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | | BKK_PAORN | Allow NULL? |
| 23 | RI_POSNO | Position in Item | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | BKK_POSNO | Allow NULL? |
