| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPContract Billing |
1 | EJBP | Customizing Standard / Japan Billing Period | 2 | SPARTYP | Division category | nvarchar | 2 | 0 | | |
2 | TE431 | Price Classes | 3 | SPARTYP | Division category | nvarchar | 2 | 0 | | |
TOPDevice installation |
3 | ETDZ | Technical Data for Installed Register | 7 | SPARTYP | Division category | nvarchar | 2 | 0 | | |
4 | TE261 | Control of Settlement Indicator for Register | 2 | SPARTYP | Division category | nvarchar | 2 | 0 | | |
5 | TE404 | Permissible Reg. Relationships per Div. Cat. | 2 | SPARTYP | Division category for device management | nvarchar | 2 | 0 | | |
TOPDevice Management |
6 | EEAG | Input/Output Group | 12 | SPARTYP | Division category for device management | nvarchar | 2 | 0 | | |
7 | EZWG | Register Group | 6 | SPARTYP | Division category for device management | nvarchar | 2 | 0 | | |
8 | TE055 | Function Classes | 3 | SPARTYP | Division category | nvarchar | 2 | 0 | | |
9 | TE065 | Register Identif. | 2 | SPARTYP | Division category | nvarchar | 2 | 0 | | |
10 | TE065T | Register IDs (text) | 3 | SPARTYP | Division category | nvarchar | 2 | 0 | | |
11 | TE068 | Permissibility of Register Codes for Each Division Category | 2 | SPARTYP | Division category | nvarchar | 2 | 0 | | |
12 | TE237 | Constr.Cls | 4 | SPARTYP | Division category | nvarchar | 2 | 0 | | |
13 | TE263 | Permiss. Combinations of Basic Dev. Cats per Division Cat. | 2 | SPARTYP | Division category for device management | nvarchar | 2 | 0 | | |
14 | TE270EZWG_DIM | Units of Measurement for Register Categories of Reg. Group | 2 | SPARTYP | Division category for device management | nvarchar | 2 | 0 | | |
15 | TE525 | Search Term for Register Grp | 2 | SPARTYP | Division category | nvarchar | 2 | 0 | | |
16 | TE525T | Register Group Search Term (Text) | 3 | SPARTYP | Division category | nvarchar | 2 | 0 | | |
17 | TE527 | Search Term for I/O Grp | 2 | SPARTYP | Division category | nvarchar | 2 | 0 | | |
18 | TE527T | Search Term: I/O Group (Text) | 3 | SPARTYP | Division category | nvarchar | 2 | 0 | | |
19 | TE593 | Types of Device Group | 4 | SPARTYP | Division category for device management | nvarchar | 2 | 0 | | |
20 | TE683 | Periodic Repl. Variants | 12 | SPARTYP | Division category for device management | nvarchar | 2 | 0 | | |
21 | TEKEMAKZ | Seal Indicator (B/NL) | 2 | SPARTYP | Division category | nvarchar | 2 | 0 | | |
22 | TEKENNZIFF | Register Codes | 2 | SPARTYP | Division category for device management | nvarchar | 2 | 0 | | |
TOPEnergy Data Management |
23 | EDIVDIM | Permitted Dimensions for Division Cat. and Profile Val. Cat. | 2 | SPARTYP | Division category for device management | nvarchar | 2 | 0 | | |
24 | EEDMSETTLDOCVARH | Variants for Header Info of Settlement Document | 4 | SPARTYP | Division category | nvarchar | 2 | 0 | | |
25 | EEDMSETTLUNIT | Settlement Unit (Header Data) | 7 | SPARTYP | Division category | nvarchar | 2 | 0 | | |
TOPIntegration Customer Relationship Management |
26 | EDIVDIM_PRP | Permitted Dimensions for Division Category | 2 | SPARTYP | Division category | nvarchar | 2 | 0 | | |
TOPIntercompany Data Exchange |
27 | EDEREGSWITCHPROC | Deregulation Switch for Process Control | 2 | SPARTYP | Division category | nvarchar | 2 | 0 | | |
28 | EGRID | Grid in the Utilities Industry | 4 | SPARTYP | Division category | nvarchar | 2 | 0 | | |
29 | EGRIDLT | Grid Level Types | 3 | SPARTYP | Division category | nvarchar | 2 | 0 | | |
30 | EIDESWTDOC | Switch Document Header | 31 | SPARTYP | Division category | nvarchar | 2 | 0 | | |
31 | EIDESWTDOCTMP | Temporary Switch Document Header Data | 25 | SPARTYP | Division category | nvarchar | 2 | 0 | | |
32 | EIDESWTVIEWTASKS | Workflow for Each Switch View | 3 | SPARTYP | Division category | nvarchar | 2 | 0 | | |
TOPMeter Reading |
33 | ISU_AUNIT_MDATA | Unit Test: Table for Master Data | 3 | SPARTYP | Division category | nvarchar | 2 | 0 | | |
34 | TE415 | Energy Feeding per Period | 3 | SPARTYP | Division category | nvarchar | 2 | 0 | | |
35 | TE569 | Average Monthly Energy Feeding | 3 | SPARTYP | Division category | nvarchar | 2 | 0 | | |
TOPPoint of delivery |
36 | EUISTRUTYPE | PoD Structure Category | 10 | SPARTYP | Division category | nvarchar | 2 | 0 | | |
TOPRegional structure |
37 | ADRCITYMRU | MRUs for City | 4 | SPARTYP | Division category | nvarchar | 2 | 0 | | |
38 | ADRSTRTMRU | MRUs for Street | 9 | SPARTYP | Division category | nvarchar | 2 | 0 | | |
TOPSAP Utilities |
39 | TESPT | Alloc. of Div. Cat. to Div. | 3 | SPARTYP | Division category | nvarchar | 2 | 0 | | |