| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | IGUID | Unique Identification | nvarchar | 32 | 0 | | | | Allow NULL? |
| 3 | HIGUID | Unique ID (Header) | nvarchar | 32 | 0 | | | | Allow NULL? |
| 4 | WLHID | Worklist ID | nvarchar | 12 | 0 | | | | Allow NULL? |
| 5 | GPART | Business Partner Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 6 | VKONT | Contract Account Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 7 | VTREF | Reference Specifications from Contract | nvarchar | 20 | 0 | | | | Allow NULL? |
| 8 | SUBAP | Subapplication in Contract Accounts Receivable and Payable | char | 1 | 0 | | | | Allow NULL? |
| 9 | OPBEL | Number of Contract Accts Rec. & Payable Doc. | nvarchar | 12 | 0 | | | | Allow NULL? |
| 10 | OPUPW | Repetition Item in Contract Account Document | nvarchar | 3 | 0 | | | | Allow NULL? |
| 11 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | OPUPZ | Subitem for a Partial Clearing in Document | nvarchar | 3 | 0 | | | | Allow NULL? |
| 13 | WAERS | Transaction Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 14 | BETRW | Amount in Transaction Currency with +/- Sign | decimal | 13 | 2 | | | | |
| 15 | PRIOY | Processing Priority | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | DUEDT | Due By | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | ACTON | Action During Clarification | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | XREF1 | Reference | nvarchar | 32 | 0 | | | | Allow NULL? |
| 19 | XREF2 | Second Reference | nvarchar | 32 | 0 | | | | Allow NULL? |
| 20 | XREF3 | Third Reference | nvarchar | 32 | 0 | | | | Allow NULL? |
| 21 | STATE | CFC: Status of an application table entry | nvarchar | 2 | 0 | | | | Allow NULL? |
| 22 | LOCK_USER | Name of the person to last change the status of the object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 23 | LOCK_LIMIT | CFC: Lock period of a lock entry | nvarchar | 8 | 0 | | | | Allow NULL? |
| 24 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | | | | Allow NULL? |
| 25 | RESUBMIT_DATE | Date on which Resubmission Occurs | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | WF_COUNT | Number of active workflows with this clarification case | tinyint | 3 | 0 | | | | |
