| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | VKONT | Contract Account Number | nvarchar | 12 | 0 | CHAR | (N' ') | No | * | VKONT_KK | Allow NULL? |
| 3 | GPART | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | GPART_KK | Allow NULL? |
| 4 | LAUFI | Additional Identification Characteristic | nvarchar | 6 | 0 | CHAR | (N' ') | No | | LAUFI_KK | Allow NULL? |
| 5 | LAUFD | Date ID | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | LAUFD_KK | Allow NULL? |
| 6 | MAZAE | Counter for several dunning notices to a business partner | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | MAZAE_KK | Allow NULL? |
| 7 | VTREF | Reference Specifications from Contract | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | VTREF_KK | Allow NULL? |
| 8 | OPBUK | Company Code Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | OPBUK_KK | Allow NULL? |
| 9 | STATUS | Insurance Dunning: Telephone Collections: Status | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | STATE_VK | Allow NULL? |
| 10 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 11 | MSALM | Dunning Balance | decimal | 13 | 2 | CURR | ((0)) | Yes | | MSALM_KK | |
| 12 | MDRKD | Execution Date of Dunning Notice | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | MDRKD_KK | Allow NULL? |
| 13 | XCALL1 | Indicator: Call Made | char | 1 | 0 | CHAR | (N' ') | Yes | | XCALL_VK | Allow NULL? |
| 14 | XCALL2 | Indicator: Call Made | char | 1 | 0 | CHAR | (N' ') | Yes | | XCALL_VK | Allow NULL? |
| 15 | XCALL3 | Indicator: Call Made | char | 1 | 0 | CHAR | (N' ') | Yes | | XCALL_VK | Allow NULL? |
| 16 | XPAYM | Promise to pay kept | char | 1 | 0 | CHAR | (N' ') | Yes | | XPAYM_VK | Allow NULL? |
| 17 | STATE | CFC: Status of an application table entry | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | CFC_ITEM_STATE | CFC_STATE | Allow NULL? |
| 18 | LOCK_USER | Name of the person to last change the status of the object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | CFC_UNAME | Allow NULL? |
| 19 | LOCK_LIMIT | CFC: Lock period of a lock entry | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CFC_LOCK_LIMIT | Allow NULL? |
| 20 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | CFC_IT_WORKSTATE | CFC_WORKSTATE | Allow NULL? |
| 21 | RESUBMIT_DATE | Date on which Resubmission Occurs | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CFC_RESUBMIT_DATE | Allow NULL? |
| 22 | WF_COUNT | Number of active workflows with this clarification case | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | CFC_WORKFLOW_COUNTER | |
