| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPContract Billing |
1 | ETTIF | Instln Facts | 54 | BEH_TYPE | Container category | nvarchar | 18 | 0 | | |
2 | ETTIFB | Installation Facts (Reference Values) | 47 | BEH_TYPE | Container category | nvarchar | 18 | 0 | | |
TOPWaste Management |
3 | EWACONFPRED | Implicit Confirmation Mode | 3 | BEH_TYPE | Container category | nvarchar | 18 | 0 | | |
4 | EWADEVSERV | Service Order for Container Delivery | 5 | BEH_TYPE | Container category | nvarchar | 18 | 0 | | |
5 | EWAOBJ | Header Data for Service Frequency | 15 | BEH_TYPE | Container category | nvarchar | 18 | 0 | | |
6 | EWA_BILL_RELEVNT | Valuation of Fields Relevant for Billing in Waste Bill.Cat. | 5 | BEH_TYPE | Container category | nvarchar | 18 | 0 | | |
7 | EWA_CCOC_ASS_RE | Allocate CO and Container (Rent) | 5 | BEH_TYPE | Container category | nvarchar | 18 | 0 | | |
8 | EWA_ORDER_OBJECT | Item Table for Waste Disposal Order | 5 | BEH_TYPE | Container category | nvarchar | 18 | 0 | | |
9 | TEWABEHGRP | Allocation of Container Categories to Group Types | 3 | BEH_TYPE | Container category | nvarchar | 18 | 0 | | |
10 | TEWABEHGRPRCI | Allocation of Container Categories to Group Types | 3 | BEH_TYPE | Container category | nvarchar | 18 | 0 | | |
11 | TEWABEHWASTE | Permitted Container Categories for Waste Fraction | 3 | BEH_TYPE | Container category | nvarchar | 18 | 0 | | |
12 | TEWACONTCATCHAIN | Activation of Container Chain for Container Types | 2 | BEH_TYPE | Container category | nvarchar | 18 | 0 | | |
13 | TEWACONTTIM | Minimum Time Frame for Delivery/Removal Order | 2 | BEH_TYPE | Container category | nvarchar | 18 | 0 | | |
14 | TEWAFLEETCONT | Container categories for vehicle type | 3 | BEH_TYPE | Container category | nvarchar | 18 | 0 | | |
15 | TEWAFRACTIONBEH | Alln. of Container Cats. & Bulk Densities to Waste Fraction | 3 | BEH_TYPE | Container category | nvarchar | 18 | 0 | | |
16 | TEWAGUARANTORAAT | Allocation of Waste Billing Categories to Guarantor Contract | 4 | BEH_TYPE | Container category | nvarchar | 18 | 0 | | |