| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAccounting - General |
1 | TFC_INST_ITEM | Administration of a Job (Report/Transaction or Workflow) | 17 | DAY_TYPE | Type of Day (Calendar Day or Working Day) | nvarchar | 1 | 0 | | |
2 | TFC_TEMPL_ITEM | Administration of a Job (Report/Transaction or Workflow) | 17 | DAY_TYPE | Type of Day (Calendar Day or Working Day) | nvarchar | 1 | 0 | | |
TOPMaster Data |
3 | EWATSPCMPNTSF | Service Frequency | 9 | DAY_TYPE | Type of Daily Service (Single/Periodic) | nvarchar | 1 | 0 | | |
TOPWaste Management |
4 | EWAOBJH | Service Frequency -> Services (History for EWAOBJ) | 35 | DAY_TYPE | Type of Daily Service (Single/Periodic) | nvarchar | 1 | 0 | | |
5 | EWA_BILL_RELEVNT | Valuation of Fields Relevant for Billing in Waste Bill.Cat. | 18 | DAY_TYPE | Type of Daily Service (Single/Periodic) | nvarchar | 1 | 0 | | |
6 | TEWASERVGRPTMPL | Default Values for Service Grouping | 7 | DAY_TYPE | Type of Daily Service (Single/Periodic) | nvarchar | 1 | 0 | | |
7 | TEWASERVICETMPL | Default Values for Service Type for Service Product | 7 | DAY_TYPE | Type of Daily Service (Single/Periodic) | nvarchar | 1 | 0 | | |