| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNVTDMS_05_EABL | MR Documents for TDMS IS-U | 3 | ABLBELNR | CHAR 20 ALPHA for TDMS | nvarchar | 20 | 0 | | |
TOPArchiving |
2 | EABLARCHIVE | Index for archivable meter reading results | 2 | ABLBELNR | Internal ID for meter reading document | nvarchar | 20 | 0 | | |
TOPContract Billing |
3 | DBERCHV | Consumption History | 24 | ABLBELNR | Internal ID for meter reading document | nvarchar | 20 | 0 | | |
4 | DBERCHZ | Individual Line Items | 139 | ABLBELNR | Internal ID for meter reading document | nvarchar | 20 | 0 | | |
5 | DBERCHZ2 | Individual line items (device data) | 18 | ABLBELNR | Internal ID for meter reading document | nvarchar | 20 | 0 | | |
6 | DBERCHZ6 | Document line items (device data, unimportant rows) | 18 | ABLBELNR | Internal ID for meter reading document | nvarchar | 20 | 0 | | |
7 | ERCHZ_SHORT | Billing Document Individual Lines Extract | 49 | ABLBELNR | Internal ID for meter reading document | nvarchar | 20 | 0 | | |
TOPIntercompany Data Exchange |
8 | EMRDETAIL | IDE: detailed information on MR results (ISU_USAGE_DATA) | 4 | ABLBELNR | Internal ID for meter reading document | nvarchar | 20 | 0 | | |
TOPInvoicing |
9 | DBERDZ | DB Table: Individ. Lines - Print Document | 165 | ABLBELNR | Internal ID for meter reading document | nvarchar | 20 | 0 | | |
TOPMeter Reading |
10 | EABL | MR Document | 2 | ABLBELNR | Internal ID for meter reading document | nvarchar | 20 | 0 | | |
11 | EABLDEL | Deleted Meter Reading Document | 2 | ABLBELNR | Internal ID for meter reading document | nvarchar | 20 | 0 | | |
12 | EABLG | MR Reasons in MR Document | 2 | ABLBELNR | Internal ID for meter reading document | nvarchar | 20 | 0 | | |
13 | EABLGDEL | Meter Reading Reasons of Deleted Meter Reading Document | 2 | ABLBELNR | Internal ID for meter reading document | nvarchar | 20 | 0 | | |
14 | EABLQDCONV | Conversion History for Quantity Det. During Meter Reading | 2 | ABLBELNR | Internal ID for meter reading document | nvarchar | 20 | 0 | | |
15 | EABLQDCONVDEL | Conversion History for QD During (Deleted) Meter Reading | 2 | ABLBELNR | Internal ID for meter reading document | nvarchar | 20 | 0 | | |
16 | EBIAS | Table for Calculation of BIAS Factor | 2 | ABLBELNR | Internal ID for meter reading document | nvarchar | 20 | 0 | | |
TOPSAP Utilities |
17 | EABLC | Temporary Meter Reading Document in AMI Environment | 2 | ABLBELNR | Internal ID for meter reading document | nvarchar | 20 | 0 | | |
18 | EABLGC | Temporary MR Reason of MR Document in AMI Environment | 2 | ABLBELNR | Internal ID for meter reading document | nvarchar | 20 | 0 | | |