| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBilling in Contract Accounts Receivable and Payable |
1 | DFKKBIBILLTASK | Billing Order | 11 | BILLTYPE | Billing Type | nvarchar | 3 | 0 | | |
2 | TFK8008A | Transaction Determination for Billing Rate Item | 4 | BILLTYPE | Billing Type | nvarchar | 3 | 0 | | |
3 | TFK8021 | Billing Type | 2 | BILLTYPE | Billing Type | nvarchar | 3 | 0 | | |
4 | TFK8021T | Text Table for TFK8021 | 3 | BILLTYPE | Billing Type | nvarchar | 3 | 0 | | |
5 | TFK8022 | Billing Process | 3 | BILLTYPE | Billing Type | nvarchar | 3 | 0 | | |
6 | TFK8028 | Billing Procedure | 8 | BILLTYPE | Billing Type | nvarchar | 3 | 0 | | |
TOPContract Billing |
7 | DBERCHZ4 | Individual line items (rarely used fields) | 31 | BILLTYPE | Waste Billing Category | nvarchar | 6 | 0 | | |
8 | DBERCHZ8 | Document line items (rarely used fields, unimportant) | 31 | BILLTYPE | Waste Billing Category | nvarchar | 6 | 0 | | |
TOPInvoicing in Contract Accounts Receivable and Payable |
9 | DFKKINVBILL_H | Billing Document Header | 43 | BILLTYPE | Billing Type | nvarchar | 3 | 0 | | |
TOPWaste Management |
10 | EWAOBJH_AAT | Waste Billing Categories for Service Frequency Service | 4 | BILLTYPE | Waste Billing Category | nvarchar | 6 | 0 | | |
11 | EWAOBJH_AAT_HIST | History and Valution of WBCs for Service Freq. Service | 4 | BILLTYPE | Waste Billing Category | nvarchar | 6 | 0 | | |
12 | EWA_BILL_RELEVNT | Valuation of Fields Relevant for Billing in Waste Bill.Cat. | 2 | BILLTYPE | Waste Billing Category | nvarchar | 6 | 0 | | |
13 | TESERVICETYPEAAT | Waste billing categories for service type | 3 | BILLTYPE | Waste Billing Category | nvarchar | 6 | 0 | | |
14 | TEWABILLTYPE | IS-W: Waste Billing Category | 2 | BILLTYPE | Waste Billing Category | nvarchar | 6 | 0 | | |
15 | TEWABILLTYPET | IS-W: Texts for Waste Billing Category | 2 | BILLTYPE | Waste Billing Category | nvarchar | 6 | 0 | | |
16 | TEWABILLTYPEZ | IS-W: Field Allocation for Waste Billing Category | 2 | BILLTYPE | Waste Billing Category | nvarchar | 6 | 0 | | |
17 | TEWAGUARANTORAAT | Allocation of Waste Billing Categories to Guarantor Contract | 5 | BILLTYPE | Waste Billing Category | nvarchar | 6 | 0 | | |