| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | CNVTDMS_05_LOGI | Logical Device Numbers TDMS for ISU | 3 | LOGIKNR | NUMC18 for TDMS | nvarchar | 18 | 0 | | |
| TOPContract Billing |
| 2 | DBERCHZ2 | Individual line items (device data) | 19 | LOGIKNR | Logical device number | nvarchar | 18 | 0 | | |
| 3 | DBERCHZ6 | Document line items (device data, unimportant rows) | 19 | LOGIKNR | Logical device number | nvarchar | 18 | 0 | | |
| 4 | ERCHZ_SHORT | Billing Document Individual Lines Extract | 50 | LOGIKNR | Logical device number | nvarchar | 18 | 0 | | |
| 5 | ETTIF | Instln Facts | 26 | LOGIKNR | Logical device number | nvarchar | 18 | 0 | | |
| 6 | ETTIFB | Installation Facts (Reference Values) | 19 | LOGIKNR | Logical device number | nvarchar | 18 | 0 | | |
| TOPCustomer Service |
| 7 | EDISCOBJ | Disc. Doc.: Disconn. Object | 6 | LOGIKNR | Logical device number | nvarchar | 18 | 0 | | |
| 8 | EDISCREMOV | Disconnection Document: Device Removal Periods | 8 | LOGIKNR | Logical device number | nvarchar | 18 | 0 | | |
| TOPDevice installation |
| 9 | EASTL | Billing data: Installation Structure at Device Level | 3 | LOGIKNR | Logical device number | nvarchar | 18 | 0 | | |
| 10 | EZUG | Device Allocations for Device (Non-Metering Devices) | 2 | LOGIKNR | Logical device number | nvarchar | 18 | 0 | | |
| TOPDevice Management |
| 11 | EGERH | Historical Data of ISU Device Master Record | 6 | LOGIKNR | Logical device number | nvarchar | 18 | 0 | | |
| 12 | EGERR | Device data: Info record for point of delivery - historical | 5 | LOGIKNR | Logical device number | nvarchar | 18 | 0 | | |
| TOPMaster Data |
| 13 | EVST | Alloc. of ARCR to Ref. Val. | 6 | LOGIKNR | Logical device number | nvarchar | 18 | 0 | | |
| TOPMeter Reading |
| 14 | ELWEG | Street Route | 2 | LOGIKNR | Logical device number | nvarchar | 18 | 0 | | |
| TOPPoint of delivery |
| 15 | EUILNR | Allocation of Logical Device to PoD | 3 | LOGIKNR | Logical device number | nvarchar | 18 | 0 | | |
| TOPWaste Management |
| 16 | EWAELOCSD | Allocation Table: Container Loc.Data <-> Sales Document Item | 12 | LOGIKNR | Logical device number | nvarchar | 18 | 0 | | |
| 17 | EWAELOCSD_INT | EWAELOCSD Dummy Table With Key Fields as CHAR | 14 | LOGIKNR | Logical device number | nvarchar | 18 | 0 | | |
| 18 | EWAELOCSD_NEW | Allocation Table: Container Loc.Data <-> Sales Document Item | 19 | LOGIKNR | Logical device number | nvarchar | 18 | 0 | | |
| 19 | EWAOBJ | Header Data for Service Frequency | 17 | LOGIKNR | Logical device number | nvarchar | 18 | 0 | | |
| 20 | EWATDEVLOC | Provisional Container/Container Location Allocation | 24 | LOGIKNR | Logical device number | nvarchar | 18 | 0 | | |
