| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPContract Billing |
1 | DBERCHZ | Individual Line Items | 62 | TARIFTYP | Rate category | nvarchar | 10 | 0 | | |
2 | DBERCHZ1 | Individual line items | 32 | TARIFTYP | Rate category | nvarchar | 10 | 0 | | |
3 | DBERCHZ5 | Individual line items (unimportant rows) | 32 | TARIFTYP | Rate category | nvarchar | 10 | 0 | | |
4 | EASIMRATECAT | Alternative Rate Categories for Simulation | 2 | TARIFTYP | Rate category | nvarchar | 10 | 0 | | |
5 | EASIMRCATAPPL | Alternative Rate Categs- for Simulation for an Application | 2 | TARIFTYP | Rate category | nvarchar | 10 | 0 | | |
6 | EASIMRCATRTYPE | Consumption Transfer for Alternative Rate Categories in Sim. | 2 | TARIFTYP | Rate category | nvarchar | 10 | 0 | | |
7 | EPPMDEBT | Table for Debts Adjustment Using Prepayment Meter | 25 | TARIFTYP | Rate category | nvarchar | 10 | 0 | | |
8 | EPPM_QS08 | Changes to Meter Rate Data | 10 | TARIFTYP | Rate category | nvarchar | 10 | 0 | | |
9 | ERCHZ_SHORT | Billing Document Individual Lines Extract | 27 | TARIFTYP | Rate category | nvarchar | 10 | 0 | | |
10 | ERTFND | Rate Determination | 3 | TARIFTYP | Rate category | nvarchar | 10 | 0 | | |
11 | ETFND | Rate Determ. | 3 | TARIFTYP | Rate category | nvarchar | 10 | 0 | | |
12 | ETTA | General Rate Category (Header Data) | 2 | TARIFTYP | Rate category | nvarchar | 10 | 0 | | |
13 | ETTAF | Rate Cat.Facts | 2 | TARIFTYP | Rate category | nvarchar | 10 | 0 | | |
14 | ETTAT | Rate Cat.(Texts) | 3 | TARIFTYP | Rate category | nvarchar | 10 | 0 | | |
15 | ETTA_DEMO_PERM | Reference: Cust.-Defined Permissibility of Rate Categories | 2 | TARIFTYP | Rate category | nvarchar | 10 | 0 | | |
16 | KJCCSJ3DBI01 | Rate Categories for Reestimation | 2 | TARIFTYP | Rate category | nvarchar | 10 | 0 | | |
17 | TEOPOU | Use of Outline Contract Operands | 2 | TARIFTYP | Rate category | nvarchar | 10 | 0 | | |
TOPIntercompany Data Exchange |
18 | EDRGPODGRASSIGN | Allocation Criteria for PoD to PoD Group (Default) | 4 | TARIFTYP | Rate category | nvarchar | 10 | 0 | | |
19 | EGRIDRATEDET | Rate Determination for Grid | 8 | TARIFTYP | Rate Category of Grid Installation | nvarchar | 10 | 0 | | |
20 | EGRIDSUPPDIST | Combination Table of Rate Determination for Grid/Supply | 2 | TARIFTYP | Rate Category of Supply Installation | nvarchar | 10 | 0 | | |
TOPInternet Self-Services |
21 | UCESPRODCHANGE | UCES: Permitted Rate Category Change | 2 | TARIFTYP | Rate category | nvarchar | 10 | 0 | | |
22 | UCESPRODTEXT | UCES: Text for Rate Category | 3 | TARIFTYP | Rate category | nvarchar | 10 | 0 | | |
TOPInvoicing |
23 | DBERDZ | DB Table: Individ. Lines - Print Document | 88 | TARIFTYP | Rate category | nvarchar | 10 | 0 | | |
TOPMaster Data |
24 | EANLH | Install.Time Slice | 5 | TARIFTYP | Rate category | nvarchar | 10 | 0 | | |
TOPMeter Reading |
25 | TE630 | Control of Meter Reading Proc. | 6 | TARIFTYP | Rate category | nvarchar | 10 | 0 | | |
TOPStatistics |
26 | S440 | IS-U rate statistics | 10 | TARIFTYP | Rate category | nvarchar | 10 | 0 | | |
27 | S440E | S440: Structure Information | 5 | TARIFTYP | Rate category | nvarchar | 10 | 0 | | |
28 | S441 | IS-U Industry Statistics | 14 | TARIFTYP | Rate category | nvarchar | 10 | 0 | | |
29 | S441E | S441: Structure Information | 9 | TARIFTYP | Rate category | nvarchar | 10 | 0 | | |