| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | EPRODDET | IS-U: Product Determination for Owner Move-in | 3 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
TOPContract Billing |
2 | DBERCHZ | Individual Line Items | 15 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
3 | DBERCHZ1 | Individual line items | 14 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
4 | DBERCHZ5 | Individual line items (unimportant rows) | 14 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
5 | EDSC | Disc.Header Data | 11 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
6 | EPREI | Mstr Pricing Table for All Prices | 7 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
7 | ERCHZ_SHORT | Billing Document Individual Lines Extract | 14 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
8 | ESCH | Billing Schema (Header Data) | 4 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
9 | ETRF | Rate (Head. Data) | 4 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
10 | ETTA | General Rate Category (Header Data) | 4 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
11 | TE069 | Rate Types | 4 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
12 | TE125 | Alloc. Data for Gas | 2 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
13 | TE341 | MsdPress. | 2 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
14 | TE493 | Cal. Val. Proced. | 14 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
15 | TE669 | Gas Proced. | 10 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
16 | TE685 | Vol. Corr. Fac. Proc. | 26 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
17 | TE695 | Gas Press. Levs | 2 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
18 | TE695T | Gas Press. Levs (Texts) | 3 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
19 | TE929 | Fixed Vol.Correct. Factors | 2 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
TOPIntercompany Data Exchange |
20 | ECERTIF | Deregulation: certification | 5 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
TOPInvoicing |
21 | DBERDZ | DB Table: Individ. Lines - Print Document | 41 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
22 | TE211 | BB: Rounding Parameter | 2 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
23 | TE557 | Minimum Charge/Amount Limit for BB | 2 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
24 | TE558 | Amount/Process Limits for Pay.Scheme Adjustment in Invoicing | 2 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
25 | TE560 | Percentage Limits for Manual Payment Scheme Changes | 2 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
TOPMaster Data |
26 | EAKLASSE | IS-U Billing Classes | 2 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
27 | EAKLASSET | IS-U Billing Classes (Texts) | 3 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
28 | EANLH | Install.Time Slice | 10 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
29 | EKONG | Franchise Contributions by Customer/Utility Co. | 7 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
30 | TE241 | Franchise Tax Groups | 3 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
TOPMeter Reading |
31 | EBIAS | Table for Calculation of BIAS Factor | 12 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
TOPMove-InOut |
32 | TE490AV | Move-Out Control: Contract Level | 4 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
33 | TE490EV | Move-In Control: Contract Level | 4 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
TOPRegional structure |
34 | ADRCITYMRU | MRUs for City | 5 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
35 | ADRSTRTMRU | MRUs for Street | 10 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
TOPStatistics |
36 | S440 | IS-U rate statistics | 9 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
37 | S440E | S440: Structure Information | 4 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
38 | S441 | IS-U Industry Statistics | 13 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |
39 | S441E | S441: Structure Information | 8 | AKLASSE | Billing class | nvarchar | 4 | 0 | | |