| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | CASENR | Clarification Case | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | CASE_GUID | GUID of Clarification Case | varbinary | 16 | 0 | | | | |
| 4 | RUNID | Internal Job Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 5 | INTNR | Number of Job Interval | int | 10 | 0 | | | | Allow NULL? |
| 6 | LOGSYS | Logical system | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | BPGUID | GUID of Transaction/Process | varbinary | 16 | 0 | | | | |
| 8 | BPCODE | Business Process Code | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | CTYPE | Case Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | STATUS | Processing Status of Clarification Case | char | 1 | 0 | | | | Allow NULL? |
| 11 | CCAT | Clarification Case Category | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | PRIO | Clarification Case Priority | char | 1 | 0 | | | | Allow NULL? |
| 13 | PRIOORIG | Origin of Priority | char | 1 | 0 | | | | Allow NULL? |
| 14 | BRGRU | Authorization Group | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | MAINOBJTYPE | Object Type of Primary Business Object of Clarification Case | nvarchar | 10 | 0 | | | | Allow NULL? |
| 16 | MAINOBJKEY | Object key | nvarchar | 70 | 0 | | | | Allow NULL? |
| 17 | ORIG_DATE | Original Date of Clarification Case | nvarchar | 8 | 0 | | | | Allow NULL? |
| 18 | ORIG_TIME | Creation Time of Clarification Case | nvarchar | 6 | 0 | | | | Allow NULL? |
| 19 | CURRPROC | Processor for Clarification Case | nvarchar | 12 | 0 | | | | Allow NULL? |
| 20 | REACODE | Reason for Forwarding | nvarchar | 4 | 0 | | | | Allow NULL? |
| 21 | CANCODE | Reversal Reason | nvarchar | 4 | 0 | | | | Allow NULL? |
| 22 | PREVPROC | Previous Processor | nvarchar | 12 | 0 | | | | Allow NULL? |
| 23 | DUE_DATE | Case Due Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 24 | DUE_TIME | Due Time of Clarification Case | nvarchar | 6 | 0 | | | | Allow NULL? |
| 25 | XNOTE | Note entered | char | 1 | 0 | | | | Allow NULL? |
| 26 | CASETXT | Clarification Case Text | nvarchar | 60 | 0 | | | | Allow NULL? |
| 27 | FWM | Method for Forwarding Clarification Cases | nvarchar | 4 | 0 | | | | Allow NULL? |
| 28 | CREATED_DATE | Date on which the record was created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 29 | CREATED_TIME | Creation Time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 30 | CREATED_BY | Created by | nvarchar | 12 | 0 | | | | Allow NULL? |
| 31 | CHANGED_DATE | Changed on | nvarchar | 8 | 0 | | | | Allow NULL? |
| 32 | CHANGED_TIME | Last changed at | nvarchar | 6 | 0 | | | | Allow NULL? |
| 33 | CHANGED_BY | Changed by | nvarchar | 12 | 0 | | | | Allow NULL? |
