| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPContract Billing |
1 | DBERCHZ | Individual Line Items | 66 | GEWKEY | Weighting key | nvarchar | 8 | 0 | | |
2 | DBERCHZ1 | Individual line items | 36 | GEWKEY | Weighting key | nvarchar | 8 | 0 | | |
3 | DBERCHZ5 | Individual line items (unimportant rows) | 36 | GEWKEY | Weighting key | nvarchar | 8 | 0 | | |
4 | ERCHZ_SHORT | Billing Document Individual Lines Extract | 30 | GEWKEY | Weighting key | nvarchar | 8 | 0 | | |
5 | TE221 | Operands | 16 | GEWKEY | Weighting key for proration of operands | nvarchar | 8 | 0 | | |
6 | TE493 | Cal. Val. Proced. | 5 | GEWKEY | Weighting key | nvarchar | 8 | 0 | | |
7 | TE669 | Gas Proced. | 11 | GEWKEY | Weighting key | nvarchar | 8 | 0 | | |
8 | TE685 | Vol. Corr. Fac. Proc. | 4 | GEWKEY | Weighting key | nvarchar | 8 | 0 | | |
TOPDevice installation |
9 | ETDZ | Technical Data for Installed Register | 37 | GEWKEY | Weighting key | nvarchar | 8 | 0 | | |
TOPDevice Management |
10 | EZWG | Register Group | 37 | GEWKEY | Weighting key | nvarchar | 8 | 0 | | |
TOPInvoicing |
11 | DBERDZ | DB Table: Individ. Lines - Print Document | 92 | GEWKEY | Weighting key | nvarchar | 8 | 0 | | |
TOPMeter Reading |
12 | ISU_AUNIT_MDATA | Unit Test: Table for Master Data | 5 | GEWKEY | Weighting key for proration of operands | nvarchar | 8 | 0 | | |
13 | TE107 | Degree Days | 2 | GEWKEY | Weighting key | nvarchar | 8 | 0 | | |
14 | TE109 | Weighting Shares | 2 | GEWKEY | Weighting key | nvarchar | 8 | 0 | | |
15 | TE266 | User-Defined Weighting Keys | 2 | GEWKEY | Weighting key | nvarchar | 8 | 0 | | |
16 | TE266T | User-Defined Weighting Keys (Texts) | 3 | GEWKEY | Weighting key | nvarchar | 8 | 0 | | |
17 | TE415 | Energy Feeding per Period | 2 | GEWKEY | Weighting key | nvarchar | 8 | 0 | | |
18 | TE569 | Average Monthly Energy Feeding | 2 | GEWKEY | Weighting key | nvarchar | 8 | 0 | | |