| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPWaste Management |
1 | EWA_CCOC_ASS_EQ | CO Assignment and Vehicle | 14 | COSERVICETYPE | Category of Activity Type for Service Product Sub-Item | nvarchar | 10 | 0 | | |
2 | EWA_CCOC_ASS_IUP | Assign CO Data for WD Item and SD Item | 13 | COSERVICETYPE | Category of Activity Type for Service Product Sub-Item | nvarchar | 10 | 0 | | |
3 | EWA_CCOC_ASS_IWP | Assign CO Data WD Item and Waste/Waste Disposal Facility | 13 | COSERVICETYPE | Category of Activity Type for Service Product Sub-Item | nvarchar | 10 | 0 | | |
4 | EWA_CCOC_ASS_RE | Allocate CO and Container (Rent) | 15 | COSERVICETYPE | Category of Activity Type for Service Product Sub-Item | nvarchar | 10 | 0 | | |
5 | EWA_CCOC_ASS_RS | Assign CO Data to Resources | 15 | COSERVICETYPE | Category of Activity Type for Service Product Sub-Item | nvarchar | 10 | 0 | | |
6 | EWA_CCOC_ASS_WP | CO Assignment to Waste Disposal Facility | 13 | COSERVICETYPE | Category of Activity Type for Service Product Sub-Item | nvarchar | 10 | 0 | | |
7 | EWA_CCOC_ASS_WPC | Allocation of CO Data for Weighing Transaction (Waste) | 13 | COSERVICETYPE | Category of Activity Type for Service Product Sub-Item | nvarchar | 10 | 0 | | |
8 | EWA_CCOC_SERVTPT | Text Table for EWA_CCOC_SERVTYP | 2 | COSERVICETYPE | Category of Activity Type for Service Product Sub-Item | nvarchar | 10 | 0 | | |
9 | EWA_CCOC_SERVTYP | CO Activity Types | 2 | COSERVICETYPE | Category of Activity Type for Service Product Sub-Item | nvarchar | 10 | 0 | | |
10 | EWA_CCOC_WP_COST | Allocation of Material/WD Facility to CO Service Type | 5 | COSERVICETYPE | Category of Activity Type for Service Product Sub-Item | nvarchar | 10 | 0 | | |
11 | TEWASERVICEUPOS | Subitems for Service Types / Service Products | 8 | COSERVICETYPE | Category of Activity Type for Service Product Sub-Item | nvarchar | 10 | 0 | | |