| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPContract Billing |
1 | DBERCHZ | Individual Line Items | 75 | ZUORDDAT | Meter reading allocation date | nvarchar | 8 | 0 | | |
2 | DBERCHZ2 | Individual line items (device data) | 16 | ZUORDDAT | Meter reading allocation date | nvarchar | 8 | 0 | | |
3 | DBERCHZ6 | Document line items (device data, unimportant rows) | 16 | ZUORDDAT | Meter reading allocation date | nvarchar | 8 | 0 | | |
TOPInvoicing |
4 | DBERDZ | DB Table: Individ. Lines - Print Document | 101 | ZUORDDAT | Meter reading allocation date | nvarchar | 8 | 0 | | |
TOPMeter Reading |
5 | EABL | MR Document | 28 | ZUORDDAT | Meter reading allocation date | nvarchar | 8 | 0 | | |
6 | EABLDEL | Deleted Meter Reading Document | 28 | ZUORDDAT | Meter reading allocation date | nvarchar | 8 | 0 | | |
7 | ETRG | Billing Order | 22 | ZUORDDAT | Allocation date for billing | nvarchar | 8 | 0 | | |
TOPPortioning and scheduling |
8 | TE417 | Sched. Recs: Portions | 5 | ZUORDDAT | Allocation date for billing | nvarchar | 8 | 0 | | |
9 | TE418 | Schedule Records: MR Units | 13 | ZUORDDAT | Meter reading allocation date | nvarchar | 8 | 0 | | |
10 | TE420 | Sch. Mast. Data: Portion | 8 | ZUORDDAT | Allocation date for billing | nvarchar | 8 | 0 | | |
11 | TE424 | Portion: Definition of Dates | 6 | ZUORDDAT | Meter reading allocation date | nvarchar | 8 | 0 | | |
12 | TE425 | Meter Reading Dates for Meter Reading Units | 5 | ZUORDDAT | Meter reading allocation date | nvarchar | 8 | 0 | | |
TOPSAP Utilities |
13 | EABLC | Temporary Meter Reading Document in AMI Environment | 28 | ZUORDDAT | Meter reading allocation date | nvarchar | 8 | 0 | | |