| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNVTDMS_05_EVER | Contracts TDMS for ISU | 3 | VERTRAG | BELNR for CNVTDMS_05_* | nvarchar | 10 | 0 | | |
2 | ECRM_MIOMR_TMP | Temporary MR Data | 2 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
3 | ETOUEXCEPTRESPAR | Archiving Index TOU Exception Response | 4 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
TOPArchiving |
4 | ERCHARC | Index for Archivable Billing Documents | 5 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
TOPContract Billing |
5 | EOUTL_ASSIGN | Assigne Contracts to Outline Agreement | 3 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
6 | EPPMHEADER | Header Table for Prepayment Meter | 3 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
7 | ERCH | Billing Doc. Data | 7 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
8 | ERCH_RIVA | Header Data for Billing Document Extract (RIVA) | 6 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
9 | ERCH_SHORT | Header Data for Billing Document - Extract | 7 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
TOPIntegration Customer Relationship Management |
10 | ECRM_REPL_HD | Header Data for IS-U Sales Replication Error Handling | 3 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
11 | EVER_CRMQ | ISU Contract CRM-Entry Queue | 4 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
12 | EVER_CRMQ_PLANED | ISU Contract CRM-Entry Queue | 4 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
13 | EVER_PC_CONTR | Table of Contracts for Mass Rate Change | 3 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
14 | EVER_PC_CONTRPAR | Mast.Data Generator: Attribute Table for Mass Product Change | 2 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
TOPIntercompany Data Exchange |
15 | ECROSSREFNO | Reference Number for IDoc | 9 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
16 | ESERVICE | Point of delivery service | 2 | VERTRAG | Point of delivery ID (as in contract) | nvarchar | 10 | 0 | | |
TOPInvoicing |
17 | DBEOSB | IS-U On-Site Billing | 5 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
18 | DBERDL | Print Document Line Items | 11 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
19 | DBERDLB | Reference of a Print Doc. Line Item to a Bill.Doc. Line Item | 9 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
20 | DBERDZ | DB Table: Individ. Lines - Print Document | 22 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
21 | DEABP | Table: Customer Change Header Data for BB Amounts | 3 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
22 | EABP | Budget Billing Plan | 3 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
23 | EABPJVL_CORR | Correspondence Print: Bud. Bill. Plan Header and YAP Info. | 5 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
24 | EITR | Temporary Selection Data for IS-U Invoicing | 10 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
25 | EJVL | Yearly Advance Payment | 3 | VERTRAG | Reference Specifications from Contract | nvarchar | 20 | 0 | | |
26 | ERDTS | Additional Charges and Taxes of a Print Document | 8 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
27 | ERDZ_SHORT | Internal Table for Individual Print Doc.Lines -Extract Data | 14 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
28 | TEPYPM | Contract history for generating payment schedule | 2 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
29 | TEPYPM_TEMPLATE | Templates for contract history, payment plan generation | 2 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
TOPMarketing |
30 | EMKT_ESTM_CONS | Marketing: Extrapolated Consumption for Each Contract | 2 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
31 | EMKT_ESTM_CONS_I | Marketing: Trigger for Consumption Extraction (Insert) | 2 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
32 | EMKT_ESTM_CONS_P | Marketing: Extrapolation Index for Mass Activity | 2 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
33 | EMKT_ESTM_CONS_U | Marketing: Trigger for Consumption Extraction (Update) | 2 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
TOPMaster Data |
34 | ELACCZ | Loyalty Account Line Item | 15 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
35 | EVER | IS-U Cont. | 2 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
36 | EVERH | IS-U Contract History | 2 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
TOPMove-InOut |
37 | EAUSV | Move-out Doc. Contract Level | 3 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
38 | ECAMIOPRCI | IS-U: Parked Document: Contracts and Installations | 9 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
39 | EEINV | Move-in Doc. for Cont. | 3 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
TOPSAP Utilities |
40 | ECONCPOST | Posting Details for Concession | 5 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
41 | EVER_AUDIT | IS-U Audit Flags for Contracts | 2 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
TOPStatistics |
42 | EMDSTTSCON | Notes for Future Changes to Stock Statistics | 3 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
TOPWaste Management |
43 | EWAOBJH_AAT | Waste Billing Categories for Service Frequency Service | 5 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
44 | EWAOBJH_AAT_HIST | History and Valution of WBCs for Service Freq. Service | 5 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
45 | EWA_WA_WEIGHOFFL | Offline Weighing | 16 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
46 | EWA_WA_WEIGHPROC | Weighing Transaction | 64 | VERTRAG | Contract | nvarchar | 10 | 0 | | |
47 | ISU2A_INDEX_GG | Index Table for Document Numbers for Guarantor Contract | 2 | VERTRAG | Contract | nvarchar | 10 | 0 | | |