| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBilling in Contract Accounts Receivable and Payable |
1 | DFKKBIBILLACC_HH | Billing Account Historical Header | 6 | BILLRATECAT | Billing Rate Category | nvarchar | 10 | 0 | | |
2 | TFK8010 | Billing Rate Determination | 2 | BILLRATECAT | Billing Rate Category | nvarchar | 10 | 0 | | |
3 | TFK8020 | Billing Rate Categories | 2 | BILLRATECAT | Billing Rate Category | nvarchar | 10 | 0 | | |
4 | TFK8020T | Text Table for TFK8020 | 3 | BILLRATECAT | Billing Rate Category | nvarchar | 10 | 0 | | |
5 | TFK8020_BILLPROC | Log Table for Billing Procedure | 3 | BILLRATECAT | Billing Rate Category | nvarchar | 10 | 0 | | |
6 | TFK8031 | Alloc. of Billing Period Types to Billing Account Item Types | 2 | BILLRATECAT | Billing Rate Category | nvarchar | 10 | 0 | | |
7 | TFK8031_BILLPROC | Log Table for Billing Procedure | 3 | BILLRATECAT | Billing Rate Category | nvarchar | 10 | 0 | | |
8 | TFK8037 | Derivation Table for Billing Rate | 3 | BILLRATECAT | Billing Rate Category | nvarchar | 10 | 0 | | |
9 | TFK8905 | Test Data: Alloc. of Billing Data for Billing Acct Item Type | 3 | BILLRATECAT | Billing Rate Category | nvarchar | 10 | 0 | | |
10 | TFK8910 | CRM Adjustment: Billing Acct Header Data Mapping by Product | 4 | BILLRATECAT | Billing Rate Category | nvarchar | 10 | 0 | | |
11 | TFK8911 | CRM Adjustment: Billing Acct Hdr Data Mapping by Product Grp | 4 | BILLRATECAT | Billing Rate Category | nvarchar | 10 | 0 | | |
TOPInvoicing in Contract Accounts Receivable and Payable |
12 | DFKKINVBILL_I | Billing Document Items | 65 | BILLRATECAT | Billing Rate Category | nvarchar | 10 | 0 | | |