| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | CNVTDMS_05_EANL | Installations TDMS for ISU | 3 | ANLAGE | BELNR for CNVTDMS_05_* | nvarchar | 10 | 0 | | |
| 2 | ECRM_MIOMR_TMP | Temporary MR Data | 6 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| TOPArchiving |
| 3 | EABLARC | Internal index f. analyzing archivable meter reading results | 2 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| TOPContract Billing |
| 4 | BREBI_BILLP_T003 | Error Log Table | 2 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 5 | BREBI_BILMS_T003 | Error Log Table only for Master Installation | 2 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 6 | EBASL | Operation Type for Lighting Unit | 2 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 7 | EBISIM | Temporary selection data for billing mass simulation | 3 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 8 | EMDUSDRQHEAD | Table of MDUS Request Data | 7 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 9 | EPREI | Mstr Pricing Table for All Prices | 32 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 10 | ESOHZG | Special Agreemts for Heating Installtn | 2 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 11 | ETTIF | Instln Facts | 2 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 12 | ETTIFB | Installation Facts (Reference Values) | 2 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 13 | ETTIFN | Installation Facts (Normal) | 2 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 14 | INSTCAUSE | Error Causes for Extracts from Backlog Sets | 5 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 15 | INSTEVAL | Temp. Table for Evaluation of Billing Execution | 2 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 16 | INSTSET | Table of Error Extracts | 5 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 17 | ISU_INSTA | Extracted incorrect installations for backlog processing | 6 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| TOPCustomer Service |
| 18 | EDISCOBJ | Disc. Doc.: Disconn. Object | 5 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 19 | EDISCREMOV | Disconnection Document: Device Removal Periods | 3 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 20 | EINIDATCRI | Initial Data Creation Doc.: Premise - Installation Data | 5 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| TOPDevice installation |
| 21 | EASTL | Billing data: Installation Structure at Device Level | 2 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 22 | EASTS | Billing data: Installation Structure at Reg. Level | 2 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| TOPEnergy Data Management |
| 23 | EEDMSETTLIN | Load Shapes Per Settlement Run | 11 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 24 | EEDMSETTLUF | Usage Factors per Settlement Run | 11 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 25 | ERTPEXDAY_TO_INS | Allocation of Exception Agreement for Installation | 2 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 26 | ERTPIFACEINST | Activation of RTP Components for Individual Installations | 2 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 27 | ERTPIFACEINSTPAR | Allocation of Parameters to RTP Interface for Indiv. Insts | 2 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| TOPIntegration Customer Relationship Management |
| 28 | ECRM_REPL_HD | Header Data for IS-U Sales Replication Error Handling | 10 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 29 | EVER_CRMQ | ISU Contract CRM-Entry Queue | 5 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| TOPInvoicing |
| 30 | DBEOSB | IS-U On-Site Billing | 2 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| TOPMarketing |
| 31 | EMKT_ESTM_CONS | Marketing: Extrapolated Consumption for Each Contract | 23 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 32 | EMKT_ESTM_CONS_I | Marketing: Trigger for Consumption Extraction (Insert) | 3 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 33 | EMKT_ESTM_CONS_P | Marketing: Extrapolation Index for Mass Activity | 29 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 34 | EMKT_ESTM_CONS_U | Marketing: Trigger for Consumption Extraction (Update) | 3 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| TOPMaster Data |
| 35 | EANL | Installation | 2 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 36 | EANLH | Install.Time Slice | 2 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 37 | EPROPH | Allocation of Inst. to Ownership | 2 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 38 | EVER | IS-U Cont. | 79 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 39 | EVERH | IS-U Contract History | 6 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 40 | EVST | Alloc. of ARCR to Ref. Val. | 2 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| TOPMeter Reading |
| 41 | EABLG | MR Reasons in MR Document | 3 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 42 | EABLGDEL | Meter Reading Reasons of Deleted Meter Reading Document | 3 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 43 | EIKE | Index for Removed Device -> Removal Not Yet Entered | 5 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 44 | ETRG | Billing Order | 2 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| TOPMove-InOut |
| 45 | EAUSV | Move-out Doc. Contract Level | 4 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 46 | ECAMIOPRCI | IS-U: Parked Document: Contracts and Installations | 3 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 47 | ECAMIOPRMR | IS-U: Parked Document: MR Results and Period Consumption | 5 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 48 | EEINV | Move-in Doc. for Cont. | 4 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| TOPPoint of delivery |
| 49 | EUIINSTLN | Allocation of Installation to PoD | 3 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| TOPSAP Utilities |
| 50 | EABLGC | Temporary MR Reason of MR Document in AMI Environment | 3 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| TOPStatistics |
| 51 | EMDSTTSANL | Notes for Future Changes to Stock Statistics | 3 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 52 | EMDSTTSOP | Notes for Future Changes to Stock Statistics | 3 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 53 | EMDSTTSOPL | Notes for Future Changes to Stock Statistics | 3 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| TOPWaste Management |
| 54 | EWAOBJ | Header Data for Service Frequency | 5 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
| 55 | EWAOBJH_AAT_HIST | History and Valution of WBCs for Service Freq. Service | 10 | ANLAGE | Installation | nvarchar | 10 | 0 | | |
