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