| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPContract Accounts Receivable and Payable |
1 | DFKKCOLFILE_H_W | Subm. of Receivable for Collection: Header Data Buffer | 4 | INKGP | Collection Agency | nvarchar | 10 | 0 | | |
2 | DFKKCOLFILE_P_W | Subm. of Receivable for Collection: Item Buffer | 6 | INKGP | Collection Agency | nvarchar | 10 | 0 | | |
3 | DFKKCOLFILE_T_W | Subm. of Receivable for Collection: Trailer Data Buffer | 4 | INKGP | Collection Agency | nvarchar | 10 | 0 | | |
4 | DFKKCOLL | Admin. Data for Sumbission of Receivables for Coll. Agency | 4 | INKGP | Collection Agency | nvarchar | 10 | 0 | | |
5 | DFKKCOLLEXTH | External Information for Collection Items (History) | 5 | INKGP | Collection Agency | nvarchar | 10 | 0 | | |
6 | DFKKCOLLH | Management Data for Submission to Coll. Agency (History) | 5 | INKGP | Collection Agency | nvarchar | 10 | 0 | | |
7 | DFKKCOLLH_I_W | Buffer: Collection Agency Information File (Header Data) | 6 | INKGP | Collection Agency | nvarchar | 10 | 0 | | |
8 | DFKKCOLLITEM | Collection Units | 2 | INKGP | Collection Agency | nvarchar | 10 | 0 | | |
9 | DFKKCOLLITEMHIER | Current Hierarchy of Collection Units | 2 | INKGP | Collection Agency | nvarchar | 10 | 0 | | |
10 | DFKKCOLLPAYM | Collection Payments | 2 | INKGP | Collection Agency | nvarchar | 10 | 0 | | |
11 | DFKKCOLLPAYMLINK | Assignment of Collection Payments to Collection Units | 2 | INKGP | Collection Agency | nvarchar | 10 | 0 | | |
12 | DFKKOPCOLL | Collection: Log of Receivables Submitted | 4 | INKGP | Collection Agency | nvarchar | 10 | 0 | | |
13 | TFK050B | Collection Agencies | 2 | INKGP | Collection Agency | nvarchar | 10 | 0 | | |