| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | OPBEL | Number of Contract Accts Rec. & Payable Doc. | nvarchar | 12 | 0 | | | | Allow NULL? |
| 3 | OPUPW | Repetition Item in Contract Account Document | nvarchar | 3 | 0 | | | | Allow NULL? |
| 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | OPUPZ | Subitem for a Partial Clearing in Document | nvarchar | 3 | 0 | | | | Allow NULL? |
| 6 | RECORDMODE | BW Delta Procedure: Update Mode | char | 1 | 0 | | | | Allow NULL? |
| 7 | ABWBL | Number of the substitute FI-CA document | nvarchar | 12 | 0 | | | | Allow NULL? |
| 8 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | GSBER | Business Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | SPART | Division | nvarchar | 2 | 0 | | | | Allow NULL? |
| 11 | GPART | Business Partner Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 12 | VKONT | Contract Account Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 13 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | | | Allow NULL? |
| 14 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | BETRW | Amount in Transaction Currency with +/- Sign | decimal | 13 | 2 | | | | |
| 18 | WAERS | Transaction Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 19 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | | | |
| 20 | HWAER | Local Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 21 | AUGDT | Clearing date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 22 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | | | | Allow NULL? |