| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBasic Functions |
| 1 | EMMAC_CCAT_HDR | Clarification Case Categories | 13 | TIMTYP | Time Type for Due Date Calculation | nvarchar | 1 | 0 | | |
| 2 | EMMAC_CCAT_PRI | Extended Case Determination and Priority | 5 | TIMTYP | Time Type for Due Date Calculation | nvarchar | 1 | 0 | | |
| TOPContract Billing |
| 3 | DBERCHR | Discnt for Bill.Line Item | 14 | TIMTYP | Time category (days or months) | nvarchar | 1 | 0 | | |
| 4 | DBERCHV | Consumption History | 8 | TIMTYP | Time category (days or months) | nvarchar | 1 | 0 | | |
| 5 | DBERCHZ | Individual Line Items | 48 | TIMTYP | Time category (days or months) | nvarchar | 1 | 0 | | |
| 6 | DBERCHZ1 | Individual line items | 29 | TIMTYP | Time category (days or months) | nvarchar | 1 | 0 | | |
| 7 | DBERCHZ5 | Individual line items (unimportant rows) | 29 | TIMTYP | Time category (days or months) | nvarchar | 1 | 0 | | |
| 8 | EDSC | Disc.Header Data | 10 | TIMTYP | Time category (days or months) | nvarchar | 1 | 0 | | |
| 9 | EPREI | Mstr Pricing Table for All Prices | 9 | TIMTYP | Time category (days or months) | nvarchar | 1 | 0 | | |
| 10 | ERCHZ_SHORT | Billing Document Individual Lines Extract | 24 | TIMTYP | Time category (days or months) | nvarchar | 1 | 0 | | |
| 11 | ETTIF | Instln Facts | 48 | TIMTYP | Time category (days or months) | nvarchar | 1 | 0 | | |
| 12 | ETTIFB | Installation Facts (Reference Values) | 41 | TIMTYP | Time category (days or months) | nvarchar | 1 | 0 | | |
| TOPInvoicing |
| 13 | DBERDR | DB Table: Discount Lines - Print Document | 14 | TIMTYP | Time category (days or months) | nvarchar | 1 | 0 | | |
| 14 | DBERDZ | DB Table: Individ. Lines - Print Document | 74 | TIMTYP | Time category (days or months) | nvarchar | 1 | 0 | | |
