| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPContract Billing |
1 | EASIMRCATRTYPE | Consumption Transfer for Alternative Rate Categories in Sim. | 4 | TARIFART | Rate Type | nvarchar | 8 | 0 | | |
2 | ERTFND | Rate Determination | 2 | TARIFART | Rate Type | nvarchar | 8 | 0 | | |
3 | ETFND | Rate Determ. | 2 | TARIFART | Rate Type | nvarchar | 8 | 0 | | |
4 | ETTAF | Rate Cat.Facts | 7 | TARIFART | Rate Type | nvarchar | 8 | 0 | | |
5 | ETTIF | Instln Facts | 14 | TARIFART | Rate Type | nvarchar | 8 | 0 | | |
6 | ETTIFB | Installation Facts (Reference Values) | 7 | TARIFART | Rate Type | nvarchar | 8 | 0 | | |
7 | ETTIFN | Installation Facts (Normal) | 14 | TARIFART | Rate Type | nvarchar | 8 | 0 | | |
8 | KJCCSJ3DBI02 | Rate Types WITHOUT Reestimation | 2 | TARIFART | Rate Type | nvarchar | 8 | 0 | | |
9 | TE069 | Rate Types | 2 | TARIFART | Rate Type | nvarchar | 8 | 0 | | |
10 | TE069T | Rate Types (Texts) | 3 | TARIFART | Rate Type | nvarchar | 8 | 0 | | |
TOPDevice installation |
11 | EASTL | Billing data: Installation Structure at Device Level | 8 | TARIFART | Rate Type | nvarchar | 8 | 0 | | |
12 | EASTS | Billing data: Installation Structure at Reg. Level | 8 | TARIFART | Rate Type | nvarchar | 8 | 0 | | |
TOPIntercompany Data Exchange |
13 | EGRIDRATEDET | Rate Determination for Grid | 9 | TARIFART | Rate Type of Grid Installation | nvarchar | 8 | 0 | | |
14 | EGRIDSUPPDIST | Combination Table of Rate Determination for Grid/Supply | 3 | TARIFART | Rate Type of Supply Installation | nvarchar | 8 | 0 | | |
TOPWaste Management |
15 | EWAOBJH_AAT_HIST | History and Valution of WBCs for Service Freq. Service | 19 | TARIFART | Rate Type | nvarchar | 8 | 0 | | |
16 | TEWABILLTYPE | IS-W: Waste Billing Category | 3 | TARIFART | Rate Type | nvarchar | 8 | 0 | | |