| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPContract Accounts Receivable and Payable |
1 | DFKKAVP | Payment Advice: Items | 7 | INKPS | Collection Item | nvarchar | 3 | 0 | | |
2 | DFKKCOLFILE_P_W | Subm. of Receivable for Collection: Item Buffer | 5 | INKPS | Collection Item | nvarchar | 3 | 0 | | |
3 | DFKKCOLI_LOG | Collection Agency Information File: Communication Log | 4 | INKPS | Collection Item | nvarchar | 3 | 0 | | |
4 | DFKKCOLL | Admin. Data for Sumbission of Receivables for Coll. Agency | 3 | INKPS | Collection Item | nvarchar | 3 | 0 | | |
5 | DFKKCOLLEXTH | External Information for Collection Items (History) | 3 | INKPS | Collection Item | nvarchar | 3 | 0 | | |
6 | DFKKCOLLH | Management Data for Submission to Coll. Agency (History) | 3 | INKPS | Collection Item | nvarchar | 3 | 0 | | |
7 | DFKKCOLLP_IP_W | Buffer: Collection Agency Info File (Item for Payments) | 13 | INKPS | Collection Item | nvarchar | 3 | 0 | | |
8 | DFKKCOLLP_IR_W | Buffer: Collection Agency Info File (Item for Callback) | 12 | INKPS | Collection Item | nvarchar | 3 | 0 | | |
9 | DFKKCOL_LOG | Collections Agency File: Settlement Log (Payments) | 3 | INKPS | Collection Item | nvarchar | 3 | 0 | | |
10 | DFKKMOP | Items in contract account document | 104 | INKPS | Collection Item | nvarchar | 3 | 0 | | |
11 | DFKKOP | Items in contract account document | 104 | INKPS | Collection Item | nvarchar | 3 | 0 | | |
12 | DFKKOPBW | OI Extraction | 20 | INKPS | Collection Item | nvarchar | 3 | 0 | | |
13 | DFKKOPCOLL | Collection: Log of Receivables Submitted | 5 | INKPS | Collection Item | nvarchar | 3 | 0 | | |
14 | DFKKOP_REP | Open Items from FPO4 | 109 | INKPS | Collection Item | nvarchar | 3 | 0 | | |
TOPInvoicing |
15 | DEABPS | Customer change table: Logical view of BB amounts | 95 | INKPS | Collection Item | nvarchar | 3 | 0 | | |