| 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 | | |
