| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPContract Accounts Receivable and Payable |
| 1 | TE011 | Code for Tax Code Determination | 4 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 2 | TE012 | Tax Changes in External System | 5 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| TOPContract Billing |
| 3 | DBERCHV | Consumption History | 5 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 4 | DBERCHZ | Individual Line Items | 20 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 5 | DBERCHZ1 | Individual line items | 20 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 6 | DBERCHZ5 | Individual line items (unimportant rows) | 20 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 7 | EBASL | Operation Type for Lighting Unit | 4 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 8 | EBURNH | Burning Hour Calendar for Lighting Unit | 3 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 9 | EBURNHMT | Type of Burning Hour Maintenance | 2 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 10 | EDSCH | Discount Historical Data | 4 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 11 | EKDI | Rate Facts | 7 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 12 | EPRESCLH | History of Price Adjustment Clause | 4 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 13 | ERCHP | Analysis periods for dynamic period control | 4 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 14 | ERCHV_GEN_PROT | Structure Log of Consumption History | 8 | AB | From Date of Selection for ERCHV Structure | nvarchar | 8 | 0 | | |
| 15 | ERCHZ_SHORT | Billing Document Individual Lines Extract | 19 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 16 | ERTFND | Rate Determination | 6 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 17 | ETFND | Rate Determ. | 5 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 18 | ETTAF | Rate Cat.Facts | 6 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 19 | ETTIF | Instln Facts | 6 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 20 | ETTIFB | Installation Facts (Reference Values) | 5 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 21 | ETTIFN | Installation Facts (Normal) | 5 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| TOPCustomer Service |
| 22 | EDISCOBJH | Disconn.Doc.: Disc.Period | 7 | AB | Date from which a disconnection is valid | nvarchar | 8 | 0 | | |
| 23 | EDISCREMOV | Disconnection Document: Device Removal Periods | 10 | AB | Date from which a disconnection is valid | nvarchar | 8 | 0 | | |
| TOPDevice installation |
| 24 | EADZ | Multiple-Installation Billing Data: Register | 4 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 25 | EASTI | Register Relationships | 5 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 26 | EASTL | Billing data: Installation Structure at Device Level | 5 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 27 | EASTS | Billing data: Installation Structure at Reg. Level | 5 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 28 | ETDZ | Technical Data for Installed Register | 5 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 29 | EZUG | Device Allocations for Device (Non-Metering Devices) | 6 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 30 | EZUZ | Device Allocations for Register (Metering Devices) | 6 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| TOPDevice Management |
| 31 | EDEVGR_CD | Change Document for Dev. Group: Table with Device Data | 5 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 32 | EGERE | Draw and Sampling Number of a Device | 3 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 33 | EGERH | Historical Data of ISU Device Master Record | 4 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 34 | EGERR | Device data: Info record for point of delivery - historical | 4 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 35 | TE271E | Sample Lot - Canadian Sampling Inspection | 3 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| TOPEnergy Data Management |
| 36 | EEDMUISETTLUNIT | Allocation of Point of Delivery to Settlement Unit | 5 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| TOPIntegration Customer Relationship Management |
| 37 | ECRM_REPL_HD | Header Data for IS-U Sales Replication Error Handling | 9 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 38 | EVER_CRMQ | ISU Contract CRM-Entry Queue | 6 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| TOPIntercompany Data Exchange |
| 39 | ECOMCONTROLSP | Communication Control Based on Service Providers | 3 | AB | Date | nvarchar | 8 | 0 | | |
| 40 | EGRIDH | Allocation of Distributor to Grid | 4 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 41 | EGRIDRATEDET | Rate Determination for Grid | 7 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| TOPInvoicing |
| 42 | DBERDL | Print Document Line Items | 40 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 43 | DBERDZ | DB Table: Individ. Lines - Print Document | 46 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| TOPMaster Data |
| 44 | EANLH | Install.Time Slice | 4 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 45 | EBP_ADDR_SERVICE | Search Index for Business Partner Service Addresses | 5 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 46 | EKONG | Franchise Contributions by Customer/Utility Co. | 4 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 47 | EKONH | Max. Prices/Quantities | 4 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 48 | EVERH | IS-U Contract History | 5 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| TOPMeter Reading |
| 49 | DBTAB_TEMPPC | database table for temporary Periodic consumption | 11 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 50 | EABLQDCONV | Conversion History for Quantity Det. During Meter Reading | 3 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 51 | EABLQDCONVDEL | Conversion History for QD During (Deleted) Meter Reading | 3 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 52 | EASTE | Register-related Period Consumption | 3 | AB | Start date for consumption period | nvarchar | 8 | 0 | | |
| TOPSAP Utilities |
| 53 | ECONCARDH | Business Partner - Concession Card: Time Slice | 5 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 54 | ELPASS | Allocation of Load Profiles to any BOR Objects | 6 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 55 | EUFASS | Allocation of Usage Factor to any BOR Objects | 6 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 56 | EUFASS_HIST | Table of Usage Factor Applied to a Load Profile (History) | 5 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| TOPStatistics |
| 57 | EMDSTTSANL | Notes for Future Changes to Stock Statistics | 2 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 58 | EMDSTTSCON | Notes for Future Changes to Stock Statistics | 2 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 59 | EMDSTTSOP | Notes for Future Changes to Stock Statistics | 2 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 60 | EMDSTTSOPL | Notes for Future Changes to Stock Statistics | 2 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 61 | EMDSTTSREL | Notes for Future Changes to Stock Statistics | 2 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| TOPWaste Management |
| 62 | EEWA_GUARANTORH | Guarantor Contract History | 4 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 63 | EEWA_PROP | Allocation of Cleaning Objects to Property | 5 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 64 | EEWA_ROB | Cleaning Object | 4 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 65 | EWAELOCEO | Allocation Table: Waste Disp. Object to Container Location | 4 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 66 | EWAELOCSD | Allocation Table: Container Loc.Data <-> Sales Document Item | 5 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 67 | EWAELOCSD_INT | EWAELOCSD Dummy Table With Key Fields as CHAR | 6 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 68 | EWAELOCSD_NEW | Allocation Table: Container Loc.Data <-> Sales Document Item | 6 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 69 | EWAELOC_DIFFC | Allocation Table: Notes for Container Location | 4 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 70 | EWAOBJH | Service Frequency -> Services (History for EWAOBJ) | 5 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 71 | EWAOBJH_AAT_HIST | History and Valution of WBCs for Service Freq. Service | 7 | AB | Start of Period | nvarchar | 8 | 0 | | |
| 72 | EWAOBJH_DATES | Appendix table of changed data for service frequency | 5 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 73 | EWAPROPSD | Allocation Table: Property <-> Sales Document Item | 5 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 74 | EWA_CCOC_ASS_EQ | CO Assignment and Vehicle | 6 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 75 | EWA_CCOC_ASS_IUP | Assign CO Data for WD Item and SD Item | 5 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 76 | EWA_CCOC_ASS_IWP | Assign CO Data WD Item and Waste/Waste Disposal Facility | 5 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 77 | EWA_CCOC_ASS_RE | Allocate CO and Container (Rent) | 7 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 78 | EWA_CCOC_ASS_RS | Assign CO Data to Resources | 7 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 79 | EWA_CCOC_ASS_WP | CO Assignment to Waste Disposal Facility | 5 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 80 | EWA_CCOC_ASS_WPC | Allocation of CO Data for Weighing Transaction (Waste) | 5 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 81 | EWA_FAKTOR | Factors for Billing of Waste Management Services | 3 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
| 82 | EWA_VBS | Table Supplement for Premise with Historical Data | 4 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | |
