| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | OS_GUID | Globally Unique Identifier | varbinary | 16 | 0 | | | | |
| 3 | COMPANY_CODE | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | PRQ_KEYNO | Key Number for Payment Request | nvarchar | 10 | 0 | | | | Allow NULL? |
| 5 | PAYMENT_AWKEY | Payment Reference Key | nvarchar | 20 | 0 | | | | Allow NULL? |
| 6 | BUSTRANSID | Identifier of the Distributor Business Transaction | varbinary | 16 | 0 | | | | |
| 7 | VALUATION_AREA | Valuation Area | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | ITEM_NUMBER | Accounting Document Line Item Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 9 | FLOW_NUMBER | Number of a Distributor Flow | int | 10 | 0 | | | | Allow NULL? |
| 10 | BELNR | Accounting Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 11 | BUZEI | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | | | Allow NULL? |
| 12 | POSTING_YEAR | Fiscal Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | PAYMENT_CURR | Payment Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 14 | PAYMENT_AMT | Payment Amount | decimal | 21 | 2 | | | | |
| 15 | PAYMENT_DATE | Payment Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | SPAYRQ | Generate payment request | char | 1 | 0 | | | | Allow NULL? |
| 17 | SPRSNG | Individual payment required | char | 1 | 0 | | | | Allow NULL? |
| 18 | SCSPAY | Same direction necessary for joint payment? | char | 1 | 0 | | | | Allow NULL? |
| 19 | SIGN | Direction of flow | char | 1 | 0 | | | | Allow NULL? |
| 20 | SPRGRD | Determine grouping definition | char | 1 | 0 | | | | Allow NULL? |
| 21 | PAYGR | Grouping Field for Automatic Payments | nvarchar | 20 | 0 | | | | Allow NULL? |
| 22 | HOUSE_BANK | Short key for own house bank | nvarchar | 5 | 0 | | | | Allow NULL? |
| 23 | HOUSE_BANK_ACC | Short key for house bank account | nvarchar | 5 | 0 | | | | Allow NULL? |
| 24 | RPZAHL | Payer/payee | nvarchar | 10 | 0 | | | | Allow NULL? |
| 25 | RPBANK | Partner bank details | nvarchar | 4 | 0 | | | | Allow NULL? |
| 26 | ZWELS | List of the Payment Methods to be Considered | nvarchar | 10 | 0 | | | | Allow NULL? |
| 27 | RPCODE | Repetitive Code | nvarchar | 20 | 0 | | | | Allow NULL? |
| 28 | RP_TEXT | Reference Text for Repetitive Code | nvarchar | 50 | 0 | | | | Allow NULL? |
| 29 | KUNNR | Customer Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 30 | GL_ACCOUNT | General Ledger Account | nvarchar | 10 | 0 | | | | Allow NULL? |
| 31 | CLEARING_ACC | G/L Account for Bank Clearing Account | nvarchar | 10 | 0 | | | | Allow NULL? |
| 32 | FI_REV_REASON | Reason for Reversal | nvarchar | 2 | 0 | | | | Allow NULL? |
| 33 | TR_REV_REASON | Reason for Reversal | nvarchar | 2 | 0 | | | | Allow NULL? |
| 34 | REVERSAL_DATE | Posting Date in the Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 35 | PAYMENT_STATE | Status of Payment Request | char | 1 | 0 | | | | Allow NULL? |
| 36 | RELEASE_STATE | Release Status for Payment Requests | char | 1 | 0 | | | | Allow NULL? |
| 37 | SGTXT | Item Text | nvarchar | 50 | 0 | | | | Allow NULL? |
| 38 | SWIFT_TEXT | Swift Text | nvarchar | 140 | 0 | | | | Allow NULL? |
| 39 | URGENT | Indicator: Extremely Urgent Payment | char | 1 | 0 | | | | Allow NULL? |
| 40 | DTAMS | Indicator for Data Medium Exchange | char | 1 | 0 | | | | Allow NULL? |
| 41 | DTAWS | Instruction key for data medium exchange | nvarchar | 2 | 0 | | | | Allow NULL? |
| 42 | DTWS1 | Instruction key 1 | nvarchar | 2 | 0 | | | | Allow NULL? |
| 43 | DTWS2 | Instruction key 2 | nvarchar | 2 | 0 | | | | Allow NULL? |
| 44 | DTWS3 | Instruction key 3 | nvarchar | 2 | 0 | | | | Allow NULL? |
| 45 | DTWS4 | Instruction key 4 | nvarchar | 2 | 0 | | | | Allow NULL? |
| 46 | SUB_FLOW_NUMBER | Number of a Distributor Flow | int | 10 | 0 | | | | Allow NULL? |
| 47 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | | | Allow NULL? |
| 48 | CLASS_OID | Globally Unique Identifier | varbinary | 16 | 0 | | | | |
| 49 | POSITION_OID | Object Identity in Database Format | nvarchar | 32 | 0 | | | | Allow NULL? |
| 50 | CREATE_NAME | Entered by | nvarchar | 12 | 0 | | | | Allow NULL? |
| 51 | CREATE_DATE | First Entered on | nvarchar | 8 | 0 | | | | Allow NULL? |
| 52 | CREATE_TIME | Time of Initial Entry | nvarchar | 6 | 0 | | | | Allow NULL? |
| 53 | CREATE_TCODE | Transaction Code | nvarchar | 20 | 0 | | | | Allow NULL? |
| 54 | CHANGE_NAME | Employee ID | nvarchar | 12 | 0 | | | | Allow NULL? |
| 55 | CHANGE_DATE | Last Edited on | nvarchar | 8 | 0 | | | | Allow NULL? |
| 56 | CHANGE_TIME | Last Edited at | nvarchar | 6 | 0 | | | | Allow NULL? |
| 57 | CHANGE_TCODE | Transaction Code | nvarchar | 20 | 0 | | | | Allow NULL? |
| 58 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | | | Allow NULL? |
