| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | DFKKEPRT | Log for Inconsistent FI-CA Documents | 42 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | | |
TOPCollectionsDisbursements |
2 | VVKKCFREC | Cash Receipts to be Transferred to Claims System | 25 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | | |
TOPContract Accounts Receivable and Payable |
3 | DFKKCIBW | FICA: Extraction of Cleared Items | 13 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | | |
4 | DFKKCRCL | Table for Checks To Be Clarified | 19 | AUGRD | Exception Reasons for Cashed Checks | nvarchar | 1 | 0 | | |
5 | DFKKFWTRIG | Trigger Table for Inverse Postings | 10 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | | |
6 | DFKKIPBW_ITEM | Installment Plan Items for Business Warehouse | 19 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | | |
7 | DFKKIPBW_ORIG | Installment Plan Original Items for Business Warehouse | 22 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | | |
8 | DFKKMOP | Items in contract account document | 63 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | | |
9 | DFKKMOPW | Items in contract account document | 19 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | | |
10 | DFKKOP | Items in contract account document | 63 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | | |
11 | DFKKOPCOLL | Collection: Log of Receivables Submitted | 26 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | | |
12 | DFKKOPW | Items in contract account document | 19 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | | |
13 | DFKKOP_REP | Open Items from FPO4 | 67 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | | |
14 | DFKKRAP | Clearing/Reversal History (Line Item Level) < 4.62 | 8 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | | |
15 | DFKKRAPT | Clearing/Reversal History (Line Item Level) | 8 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | | |
16 | DFKKREP07 | Tax Report Data (Clearing Time) | 40 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | | |
17 | DFKKREV07 | Report on Tax on Sales/Purchases (clearing time) | 36 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | | |
18 | DFKKRK | Returns lot: Header data | 20 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | | |
19 | DFKKTHP | Transfer Records for Billing on Behalf of 3rd Party | 8 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | | |
20 | DFKKWOHTMP | Temporary Write-Off History | 12 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | | |
21 | DFKKZK | Payment lot: Header data | 18 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | | |
22 | DFKKZP | Payment lot: Data for payment | 28 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | | |
23 | FKK042ZA | Work table for country payment methods (data in TFK042ZA) | 5 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | | |
24 | TFK001A | Clearing Reasons | 1 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | | |
25 | TFK001AT | Clearing reasons (text table) | 2 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | | |
26 | TFK042ZA | Payment Program: Additional Specifications for Payt Methods | 6 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | | |
27 | TFK056C | Clearing reasons for which no interest calc. takes place | 2 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | | |
TOPInvoicing |
28 | DEABPS | Customer change table: Logical view of BB amounts | 56 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | | |
29 | EABPS_CORR | Sub Budget Billing Plan for Correspondence Print | 40 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | | |
TOPMedia Sales and Distribution |
30 | /NAM/TJFCAPAYMT | Contract Account Payments | 6 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | | |