| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPContract Billing |
| 1 | DBERCHV | Consumption History | 23 | TWAERS | Transaction Currency | nvarchar | 5 | 0 | | |
| 2 | DBERCHZ | Individual Line Items | 36 | TWAERS | Transaction Currency | nvarchar | 5 | 0 | | |
| 3 | DBERCHZ3 | Individual line items (amount and price data) | 7 | TWAERS | Transaction Currency | nvarchar | 5 | 0 | | |
| 4 | DBERCHZ7 | Document line items (amount/price data, unimportant rows) | 7 | TWAERS | Transaction Currency | nvarchar | 5 | 0 | | |
| 5 | EDSCH | Discount Historical Data | 2 | TWAERS | Transaction Currency | nvarchar | 5 | 0 | | |
| 6 | EDSCHINDEXA | Discount: Historical Data - Index A for F4 Help | 2 | TWAERS | Transaction Currency | nvarchar | 5 | 0 | | |
| 7 | EPPMDEBT | Table for Debts Adjustment Using Prepayment Meter | 13 | TWAERS | Transaction Currency | nvarchar | 5 | 0 | | |
| 8 | EPPMRR | Repayment Amounts Saved in Meter | 12 | TWAERS | Transaction Currency | nvarchar | 5 | 0 | | |
| 9 | EPPM_QS08 | Changes to Meter Rate Data | 22 | TWAERS | Transaction Currency | nvarchar | 5 | 0 | | |
| 10 | EPREIH | History Table for All Prices | 2 | TWAERS | Transaction Currency | nvarchar | 5 | 0 | | |
| 11 | ERCHZ_SHORT | Billing Document Individual Lines Extract | 56 | TWAERS | Transaction Currency | nvarchar | 5 | 0 | | |
| TOPInvoicing |
| 12 | DBERDL | Print Document Line Items | 23 | TWAERS | Transaction Currency | nvarchar | 5 | 0 | | |
| 13 | DBERDZ | DB Table: Individ. Lines - Print Document | 62 | TWAERS | Transaction Currency | nvarchar | 5 | 0 | | |
| 14 | ERDTS | Additional Charges and Taxes of a Print Document | 13 | TWAERS | Transaction Currency | nvarchar | 5 | 0 | | |
| 15 | ERDZ_SHORT | Internal Table for Individual Print Doc.Lines -Extract Data | 20 | TWAERS | Transaction Currency | nvarchar | 5 | 0 | | |
| TOPMaster Data |
| 16 | EKONG | Franchise Contributions by Customer/Utility Co. | 3 | TWAERS | Transaction Currency | nvarchar | 5 | 0 | | |
| 17 | EKONH | Max. Prices/Quantities | 3 | TWAERS | Transaction Currency | nvarchar | 5 | 0 | | |
| TOPStatistics |
| 18 | S440 | IS-U rate statistics | 17 | TWAERS | Transaction Currency | nvarchar | 5 | 0 | | |
| 19 | S440E | S440: Structure Information | 10 | TWAERS | Transaction Currency | nvarchar | 5 | 0 | | |
| 20 | S441 | IS-U Industry Statistics | 19 | TWAERS | Transaction Currency | nvarchar | 5 | 0 | | |
| 21 | S441E | S441: Structure Information | 12 | TWAERS | Transaction Currency | nvarchar | 5 | 0 | | |
| TOPValue Adjustment |
| 22 | /IBS/CRB_KTOFI | RBD Account Determination for RBD Flow Types | 5 | TWAERS | RBD. Transaction Currency | nvarchar | 5 | 0 | | |
| 23 | /IBS/TRB_UI | RBD: RBD Record Data Table (Actual) | 28 | TWAERS | RBD. Transaction Currency | nvarchar | 5 | 0 | | |
| 24 | /IBS/TRB_UP | RBD RBD Record Data Table (PLANNED) | 13 | TWAERS | RBD. Transaction Currency | nvarchar | 5 | 0 | | |
