| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| Contract Billing | ||||||||||
| 1 | DBERCHZ | Individual Line Items | 159 | KONZVER | Franchise contract | nvarchar | 10 | 0 | ||
| 2 | DBERCHZ1 | Individual line items | 90 | KONZVER | Franchise contract | nvarchar | 10 | 0 | ||
| 3 | DBERCHZ5 | Individual line items (unimportant rows) | 90 | KONZVER | Franchise contract | nvarchar | 10 | 0 | ||
| 4 | ERCH | Billing Doc. Data | 28 | KONZVER | Franchise contract | nvarchar | 10 | 0 | ||
| 5 | ERCHZ_SHORT | Billing Document Individual Lines Extract | 42 | KONZVER | Franchise contract | nvarchar | 10 | 0 | ||
| 6 | ERCH_SHORT | Header Data for Billing Document - Extract | 18 | KONZVER | Franchise contract | nvarchar | 10 | 0 | ||
| Invoicing | ||||||||||
| 7 | DBERDZ | DB Table: Individ. Lines - Print Document | 185 | KONZVER | Franchise contract | nvarchar | 10 | 0 | ||
| Master Data | ||||||||||
| 8 | EANLH | Install.Time Slice | 13 | KONZVER | Franchise contract | nvarchar | 10 | 0 | ||
| 9 | EKON | Franchise Contract MasterData | 2 | KONZVER | Franchise contract | nvarchar | 10 | 0 | ||
| 10 | EKONG | Franchise Contributions by Customer/Utility Co. | 2 | KONZVER | Franchise contract | nvarchar | 10 | 0 | ||
| 11 | EKONH | Max. Prices/Quantities | 2 | KONZVER | Franchise contract | nvarchar | 10 | 0 | ||
| Regional structure | ||||||||||
| 12 | ADRCITYKON | Franch. Contracts for City | 6 | KONZVER | Franchise contract | nvarchar | 10 | 0 | ||
| 13 | ADRSTRTKON | Franchise Contracts for Street | 11 | KONZVER | Franchise contract | nvarchar | 10 | 0 | ||