| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | FANR | Payment Form Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 3 | OPBEL | Number of Contract Accts Rec. & Payable Doc. | nvarchar | 12 | 0 | | | | Allow NULL? |
| 4 | OPUPW | Repetition Item in Contract Account Document | nvarchar | 3 | 0 | | | | Allow NULL? |
| 5 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | OPUPZ | Subitem for a Partial Clearing in Document | nvarchar | 3 | 0 | | | | Allow NULL? |
| 7 | ABTYP | Origin Area of a Payment Form | nvarchar | 2 | 0 | | | | Allow NULL? |
| 8 | VKTYP | Contract Account Category | nvarchar | 2 | 0 | | | | Allow NULL? |
| 9 | FAART | Invoicing Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | GPART | Business Partner Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 11 | VKONT | Contract Account Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 12 | OPBUK | Company Code for Automatic Payment Transactions | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | VTREF | Reference Specifications from Contract | nvarchar | 20 | 0 | | | | Allow NULL? |
| 14 | LAUFD | Date on Which the Program Is to Be Run | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | LAUFI | Additional Identification Characteristic | nvarchar | 6 | 0 | | | | Allow NULL? |
| 16 | SLART | Selection Category | char | 1 | 0 | | | | Allow NULL? |
| 17 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 18 | BETRW | Amount in Transaction Currency with +/- Sign | decimal | 13 | 2 | | | | |
| 19 | RFZAS | External key payment form | nvarchar | 30 | 0 | | | | Allow NULL? |
| 20 | XCOLLBILL | Indicator: Invoice is a Collective Invoice | char | 1 | 0 | | | | Allow NULL? |
| 21 | XSIMU | Mass act: Simulation run | char | 1 | 0 | | | | Allow NULL? |