| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPContract Billing |
1 | EMDUSDIFDAYGRP | Day Group of TOU Interface | 3 | SEASON | Season type | nvarchar | 10 | 0 | | |
2 | EMDUSDIFDAYGRPT | Text for Day Group of TOU Interface | 3 | SEASON | Season type | nvarchar | 10 | 0 | | |
3 | EMDUSDIFTIMETAB | TOU Formulas of TOU Interface | 3 | SEASON | Season type | nvarchar | 10 | 0 | | |
4 | EMDUSDIFTIMETABT | Text Table for TOU Periods | 3 | SEASON | Season type | nvarchar | 10 | 0 | | |
5 | EMDUSDIFTOUTAB | TOU Periods of TOU Interface | 3 | SEASON | Season type | nvarchar | 10 | 0 | | |
6 | EMDUSDIFTOUTABT | Text for TOU Period | 3 | SEASON | Season type | nvarchar | 10 | 0 | | |
7 | EMDUSDRQITEM | Subrequest for Request | 25 | SEASON | Season type | nvarchar | 10 | 0 | | |
TOPElectronic Data Interchange |
8 | PRICAT_K003 | PRICAT: Catalog item basic data | 25 | SEASON | Season Category | nvarchar | 4 | 0 | | |
9 | PRICAT_K003_PRO | Indication of Data to be Adopted from PRICAT_K003 | 23 | SEASON | Indicator for copying catalog data | nvarchar | 1 | 0 | | |
TOPEnergy Data Management |
10 | EEDMSYNPROFCODE | Synthetic Profile: Internal Code for Individual Levels | 4 | SEASON | Season type | nvarchar | 10 | 0 | | |
11 | ERTPCOMPCODE | Internal Code for Individual Levels of RTP Component | 4 | SEASON | Season type | nvarchar | 10 | 0 | | |
12 | ERTPFCOMPDATA | Data for Flexible RTP Components | 4 | SEASON | Season type | nvarchar | 10 | 0 | | |
13 | ESEASON | Season Definitions | 2 | SEASON | Season type | nvarchar | 10 | 0 | | |
14 | ESEASONBLOCKDEF | Season Group Definition | 4 | SEASON | Season type | nvarchar | 10 | 0 | | |
15 | ESEASONPER | Season Periods | 2 | SEASON | Season type | nvarchar | 10 | 0 | | |
16 | ESEASONT | Season Definitions (Text) | 2 | SEASON | Season type | nvarchar | 10 | 0 | | |
TOPMaster Data |
17 | JGTEUWV | IS-M: Retailer | 13 | SEASON | Season Indicator | nvarchar | 2 | 0 | | |
18 | TJGPOS01 | IS-M: POS Season Indicators | 2 | SEASON | Season Indicator | nvarchar | 2 | 0 | | |
19 | TJGPOS01T | IS-M: POS Season Indicators (Texts) | 3 | SEASON | Season Indicator | nvarchar | 2 | 0 | | |
TOPSAP Utilities |
20 | TECONTYP | Concession Type | 7 | SEASON | Season specification for an operand | nvarchar | 10 | 0 | | |