| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| Contract Billing | ||||||||||
| 1 | DBERCHZ | Individual Line Items | 72 | TEMP_AREA | Temperature area | nvarchar | 8 | 0 | ||
| 2 | DBERCHZ1 | Individual line items | 38 | TEMP_AREA | Temperature area | nvarchar | 8 | 0 | ||
| 3 | DBERCHZ5 | Individual line items (unimportant rows) | 38 | TEMP_AREA | Temperature area | nvarchar | 8 | 0 | ||
| 4 | TE307 | Temperature Areas | 2 | TEMP_AREA | Temperature area | nvarchar | 8 | 0 | ||
| 5 | TE307T | Temperature Area (Texts) | 3 | TEMP_AREA | Temperature area | nvarchar | 8 | 0 | ||
| 6 | TE447 | Measured Gas Temperature (Monthly Values) | 2 | TEMP_AREA | Temperature area | nvarchar | 8 | 0 | ||
| 7 | TE448 | Daily Gas Temperatures | 2 | TEMP_AREA | Temperature area | nvarchar | 8 | 0 | ||
| 8 | TE929 | Fixed Vol.Correct. Factors | 4 | TEMP_AREA | Temperature area | nvarchar | 8 | 0 | ||
| Device installation | ||||||||||
| 9 | ETDZ | Technical Data for Installed Register | 23 | TEMP_AREA | Temperature area | nvarchar | 8 | 0 | ||
| Invoicing | ||||||||||
| 10 | DBERDZ | DB Table: Individ. Lines - Print Document | 98 | TEMP_AREA | Temperature area | nvarchar | 8 | 0 | ||
| Master Data | ||||||||||
| 11 | EANLH | Install.Time Slice | 12 | TEMP_AREA | Temperature area | nvarchar | 8 | 0 | ||
| Meter Reading | ||||||||||
| 12 | EBIAS | Table for Calculation of BIAS Factor | 6 | TEMP_AREA | Temperature area | nvarchar | 8 | 0 | ||
| 13 | TE107 | Degree Days | 3 | TEMP_AREA | Temperature area | nvarchar | 8 | 0 | ||
| 14 | TE403 | Table for Average Degree Day Coefficients | 2 | TEMP_AREA | Temperature area | nvarchar | 8 | 0 | ||
| Regional structure | ||||||||||
| 15 | ADRSTRTISU | IS-U Applic. Data for Street | 10 | TEMP_AREA | Temperature area | nvarchar | 8 | 0 | ||