| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | DFKKCFKWL | KWL: KPI Cockpit Worklist | 24 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | | |
2 | DFKKPICLARIF | Clarification Work List for Penalty and Interest | 19 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | | |
TOPBusiness Partner |
3 | DFKKBPCL_CLAR | Business Partner Duplicates: Clarification Cases | 7 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | | |
TOPCollectionsDisbursements |
4 | IBROSTMCF | Clarif. Cases from Broker Report | 33 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | | |
5 | VVKKBILLCLAR | FS-CD: Clarification Cases Premium Rec. for Auto Clearing | 11 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | | |
6 | VVKKCFCLH | Clearing: Notes to Clerk for Clearing | 6 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | | |
7 | VVKKCFCSTEL | Insurance Dunning: Telephone Collections | 20 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | | |
8 | VVKKREPCL | Money Laundering Clarification Worklist | 25 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | | |
9 | VVSCULCFC | Customer-Initiated Payment Clearing | 14 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | | |
TOPContract Accounts Receivable and Payable |
10 | CFC_ACTIONLOG | Action Log of Status and Processing Status Changes | 8 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | | |
11 | CFC_IT_WORKSTATE | Clarification Case Processing Status | 3 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | | |
12 | CFC_WORKSTATE_T | Clarification Case Processing State (Texts) | 4 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | | |
13 | DFKCRPO | Clarification Worklist Credit | 22 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | | |
14 | DFKKCFCSLOCKS | FI-CA Locks | 21 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | | |
15 | DFKKCFCVS | Clarification Cases from Payment Transfer - Ext. Pymt Coll. | 19 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | | |
16 | DFKKCFDUNTEL | Telephone List for Dunning | 31 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | | |
17 | DFKKCFNR | Clarification Cases from NOC Returns Lot | 21 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | | |
18 | DFKKCFPAYRUN | Clarif. Worklist: Payment Program (Obsolete) | 26 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | | |
19 | DFKKCFPAYRUN2 | Calrification Worklist: Payment Program (New Version) | 24 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | | |
20 | DFKKCFRLS | Clarification Cases: Returns Lots | 25 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | | |
21 | DFKKCFZST | Clarification Cases from Payment Lot | 20 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | | |
22 | DFKKCRCL | Table for Checks To Be Clarified | 29 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | | |
23 | DFKKCRESCHC | Clarification Cases for Manual Escheatment Process | 15 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | | |
24 | DFKKMACFCSMK | FICA Dunning - Blocked Accounts | 12 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | | |
25 | DFKKORDERAPPROVE | Requests to be Approved | 17 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | | |
26 | FKKBSTER | Acct Statement Transfer: Incorrect Data | 18 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | | |
TOPInvoicing in Contract Accounts Receivable and Payable |
27 | DFKKINV_CFC | Clarification Case Invoicing | 39 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
28 | DFMCAALOT | Write-Off of Documents with Approval | 14 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | | |
29 | DFMCADLOT | Document Resubmission | 13 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | | |
30 | DFMCAILOT | PSCD: Approval List Installment Plans | 39 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | | |
31 | DFMCA_CRPA | Approval List for Document Changes | 20 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | | |