| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPContract Billing |
1 | DBERCHZ4 | Individual line items (rarely used fields) | 35 | ORDER_LAUFNR | Sequence Number for Waste Disposal Order Item | nvarchar | 4 | 0 | | |
2 | DBERCHZ8 | Document line items (rarely used fields, unimportant) | 35 | ORDER_LAUFNR | Sequence Number for Waste Disposal Order Item | nvarchar | 4 | 0 | | |
TOPWaste Management |
3 | EWA_ORDER_BULKY | Bulk Waste Objects for Item in Waste Disposal Order | 3 | ORDER_LAUFNR | Sequence Number for Waste Disposal Order Item | nvarchar | 4 | 0 | | |
4 | EWA_ORDER_OBJECT | Item Table for Waste Disposal Order | 3 | ORDER_LAUFNR | Sequence Number for Waste Disposal Order Item | nvarchar | 4 | 0 | | |
5 | EWA_ORDER_OBJ_CO | Item Table in Waste Disposal Order (CO Data) | 3 | ORDER_LAUFNR | Sequence Number for Waste Disposal Order Item | nvarchar | 4 | 0 | | |
6 | EWA_ORDER_OBJ_CP | Item Table in Waste Disposal Order (CO-PA Data) | 3 | ORDER_LAUFNR | Sequence Number for Waste Disposal Order Item | nvarchar | 4 | 0 | | |
7 | EWA_ORDER_OBJ_SD | SD Contracts for Waste Disposal Order Item | 3 | ORDER_LAUFNR | Sequence Number for Waste Disposal Order Item | nvarchar | 4 | 0 | | |
8 | EWA_ORDER_RESOBJ | Resource Table for Waste Disposal Order | 3 | ORDER_LAUFNR | Sequence Number of Resource Master (Vehicle and Employees) | nvarchar | 4 | 0 | | |