| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | CLIENT | 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 | TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |
| 7 | PROCESS | Triggering Transaction for Agency FI | char | 1 | 0 | | | | Allow NULL? |
| 8 | AGENCY | Business Partner Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 9 | AGENCYCONTR | Reference Specifications from Contract | nvarchar | 20 | 0 | | | | Allow NULL? |
| 10 | VGPART2 | Business Partner Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 11 | VTRE2 | Additional Reference Information | nvarchar | 20 | 0 | | | | Allow NULL? |
| 12 | AUGBL | Clearing Document or Printed Document | nvarchar | 12 | 0 | | | | Allow NULL? |
| 13 | WAERS | Transaction Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 14 | BETRW | Amount in Transaction Currency with +/- Sign | decimal | 13 | 2 | | | | |
| 15 | BLART | Document Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | XBLNR | Reference document number | nvarchar | 16 | 0 | | | | Allow NULL? |
| 17 | CRNAME | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 18 | STATE_AGFI | Status of Transfer to Agency FI | char | 1 | 0 | | | | Allow NULL? |
