| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | ECRM_MIOMR_TMP | Temporary MR Data | 3 | ABLESGR | Meter reading reason | nvarchar | 2 | 0 | | |
TOPContract Billing |
2 | DBERCHV | Consumption History | 14 | ABLESGR | Meter reading reason | nvarchar | 2 | 0 | | |
3 | DBERCHZ | Individual Line Items | 56 | ABLESGR | Meter reading reason | nvarchar | 2 | 0 | | |
4 | DBERCHZ2 | Individual line items (device data) | 9 | ABLESGR | Meter reading reason | nvarchar | 2 | 0 | | |
5 | DBERCHZ6 | Document line items (device data, unimportant rows) | 9 | ABLESGR | Meter reading reason | nvarchar | 2 | 0 | | |
6 | EMRACC | JBP: Shift Meter Reading Dates per Meter Reading Reason | 3 | ABLESGR | Meter reading reason | nvarchar | 2 | 0 | | |
7 | EMRCLASS | Allocate Action Meter Reading + Technical Operations Group | 2 | ABLESGR | Meter reading reason | nvarchar | 2 | 0 | | |
8 | EMRSHIFT | Test BIN DAI !!!!!!!!!!!!!!!!!!! | 6 | ABLESGR | Meter reading reason | nvarchar | 2 | 0 | | |
9 | ERCHZ_SHORT | Billing Document Individual Lines Extract | 48 | ABLESGR | Meter reading reason | nvarchar | 2 | 0 | | |
TOPInvoicing |
10 | DBERDZ | DB Table: Individ. Lines - Print Document | 82 | ABLESGR | Meter reading reason | nvarchar | 2 | 0 | | |
11 | TE639 | Control Parameters for Express Transaction BB Change | 7 | ABLESGR | Meter reading reason (limited to single entry) | nvarchar | 2 | 0 | | |
TOPMeter Reading |
12 | EABLG | MR Reasons in MR Document | 4 | ABLESGR | Meter reading reason | nvarchar | 2 | 0 | | |
13 | EABLGDEL | Meter Reading Reasons of Deleted Meter Reading Document | 4 | ABLESGR | Meter reading reason | nvarchar | 2 | 0 | | |
14 | EIKE | Index for Removed Device -> Removal Not Yet Entered | 12 | ABLESGR | Meter reading reason | nvarchar | 2 | 0 | | |
15 | TE455 | Parameters for Change to MR Result (CRM Integration) | 2 | ABLESGR | Meter reading reason | nvarchar | 2 | 0 | | |
16 | TE609 | MR Reasons (Values) | 1 | ABLESGR | Meter reading reason | nvarchar | 2 | 0 | | |
17 | TE609T | MR Reasons (Texts) | 2 | ABLESGR | Meter reading reason | nvarchar | 2 | 0 | | |
18 | TE610 | Priority of MR Reasons for Interval Validation | 2 | ABLESGR | Meter reading reason | nvarchar | 2 | 0 | | |
19 | TE611 | Interpolation of MR Reasons | 2 | ABLESGR | Meter reading reason | nvarchar | 2 | 0 | | |
20 | TE613 | Priority of Meter Reading Reasons When Times Are the Same | 2 | ABLESGR | Meter reading reason | nvarchar | 2 | 0 | | |
21 | TE630 | Control of Meter Reading Proc. | 3 | ABLESGR | Meter reading reason | nvarchar | 2 | 0 | | |
22 | TE935 | Automatic Meter Reading Monitoring | 3 | ABLESGR | Meter reading reason | nvarchar | 2 | 0 | | |
TOPPortioning and scheduling |
23 | TE418 | Schedule Records: MR Units | 16 | ABLESGR | Meter reading reason | nvarchar | 2 | 0 | | |
24 | TE425 | Meter Reading Dates for Meter Reading Units | 6 | ABLESGR | Meter reading reason | nvarchar | 2 | 0 | | |
TOPSAP Utilities |
25 | EABLGC | Temporary MR Reason of MR Document in AMI Environment | 4 | ABLESGR | Meter reading reason | nvarchar | 2 | 0 | | |