| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPContract Billing |
1 | DBERCHV | Consumption History | 11 | MASSBILL | Unit of measurement for billing | nvarchar | 3 | 0 | | |
2 | DBERCHZ | Individual Line Items | 32 | MASSBILL | Unit of measurement for billing | nvarchar | 3 | 0 | | |
3 | DBERCHZ1 | Individual line items | 26 | MASSBILL | Unit of measurement for billing | nvarchar | 3 | 0 | | |
4 | DBERCHZ5 | Individual line items (unimportant rows) | 26 | MASSBILL | Unit of measurement for billing | nvarchar | 3 | 0 | | |
5 | ERCHZ_SHORT | Billing Document Individual Lines Extract | 21 | MASSBILL | Unit of measurement for billing | nvarchar | 3 | 0 | | |
TOPDevice installation |
6 | ETDZ | Technical Data for Installed Register | 36 | MASSBILL | Unit of measurement for billing | nvarchar | 3 | 0 | | |
TOPDevice Management |
7 | EZWG | Register Group | 36 | MASSBILL | Unit of measurement for billing | nvarchar | 3 | 0 | | |
TOPInvoicing |
8 | DBERDZ | DB Table: Individ. Lines - Print Document | 58 | MASSBILL | Unit of measurement for billing | nvarchar | 3 | 0 | | |
TOPMeter Reading |
9 | DBTAB_TEMPPC | database table for temporary Periodic consumption | 10 | MASSBILL | Unit of measurement for billing | nvarchar | 3 | 0 | | |
10 | EABL | MR Document | 13 | MASSBILL | Unit of measurement for billing | nvarchar | 3 | 0 | | |
11 | EABLDEL | Deleted Meter Reading Document | 13 | MASSBILL | Unit of measurement for billing | nvarchar | 3 | 0 | | |
TOPSAP Utilities |
12 | EABLC | Temporary Meter Reading Document in AMI Environment | 13 | MASSBILL | Unit of measurement for billing | nvarchar | 3 | 0 | | |
TOPStatistics |
13 | S440 | IS-U rate statistics | 16 | MASSBILL | Unit of measurement for billing | nvarchar | 3 | 0 | | |
14 | S440E | S440: Structure Information | 9 | MASSBILL | Unit of measurement for billing | nvarchar | 3 | 0 | | |
15 | S441 | IS-U Industry Statistics | 18 | MASSBILL | Unit of measurement for billing | nvarchar | 3 | 0 | | |
16 | S441E | S441: Structure Information | 11 | MASSBILL | Unit of measurement for billing | nvarchar | 3 | 0 | | |
17 | TE776 | UIS: Alloc. of Billing Unit of Meas. -> Stat. Unit of Meas. | 3 | MASSBILL | Unit of measurement for billing | nvarchar | 3 | 0 | | |