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