| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SDF/SQLTIMST | SQL Monitor History: Timestamps - Mapping to time frame | 3 | TIMEFROM | Start time of data collection | nvarchar | 6 | 0 | | |
2 | DBERCHE | Condition Data | 6 | TIMEFROM | Start Time | nvarchar | 6 | 0 | | |
3 | ECONDI | IS-U: Conditions | 6 | TIMEFROM | Start Time | nvarchar | 6 | 0 | | |
4 | ETOUEXCEPTION | TOU Exception | 4 | TIMEFROM | TOU Exception From-Time | nvarchar | 6 | 0 | | |
TOPClaims Management |
5 | ICLPROCURE | Claim Item Groupings | 16 | TIMEFROM | Start Time of Claim Item Group | nvarchar | 6 | 0 | | |
6 | ICSPROCURE | Claim Item Groupings | 16 | TIMEFROM | Start Time of Claim Item Group | nvarchar | 6 | 0 | | |
TOPCommodity Pricing Engine |
7 | CPEC_PERIODDET | CPE Term - Period Determination Rule | 15 | TIMEFROM | CPE Term - Start Time for Fixed Period | nvarchar | 6 | 0 | | |
8 | CPED_PERIODDTIN | CPE Term - Changed Input Data for Period Determination | 13 | TIMEFROM | CPE Term - Start Time for Fixed Period | nvarchar | 6 | 0 | | |
TOPContract Billing |
9 | DBERCHZ4 | Individual line items (rarely used fields) | 40 | TIMEFROM | Start Time | nvarchar | 6 | 0 | | |
10 | DBERCHZ8 | Document line items (rarely used fields, unimportant) | 40 | TIMEFROM | Start Time | nvarchar | 6 | 0 | | |
11 | EMDUSDRQEXCL | Exception Days for Subrequest | 6 | TIMEFROM | Start Time | nvarchar | 6 | 0 | | |
12 | EMDUSDRQITEM | Subrequest for Request | 7 | TIMEFROM | Start Time | nvarchar | 6 | 0 | | |
TOPEnergy Data Management |
13 | EEDMIMPORTLOG_DB | EDM Import Log: Database Table | 6 | TIMEFROM | From-Time for Profile Values | nvarchar | 6 | 0 | | |
14 | EEDMPROSEND | Recording of Sent Profiles | 4 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
15 | EEDMSETTLDOC | Settlement Document (Header) | 4 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
16 | EEDMSETTLDOCSNDP | Settlement Document (Sent Profiles) | 9 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
17 | EEDMSETTLDOCUPDP | Settlement Document (Updated Profiles) | 11 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
18 | EEDMSETTLIN | Load Shapes Per Settlement Run | 10 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
19 | EEDMSETTLPARAMP | Settlement Paramter: Definition of Reference Profiles | 6 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
20 | EEDMSETTLUF | Usage Factors per Settlement Run | 10 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
21 | EEDMSETTLUNIT | Settlement Unit (Header Data) | 4 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
22 | EEDMSETTLUNITGEN | Settlement Unit: Generated Form | 4 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
23 | EEDMSETTLUNITH | Settlement Unit (Historical Data) | 4 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
24 | EEDMSYNPROFALLOC | Synthetic Profile: Allocation of Profiles | 7 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
25 | EFORMULAHIER | IS-U EDM Hierarchy Levels of Formula Instance (DB Table) | 8 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
26 | EFORMULAINSTPMI | ISU EDM Input Parameters for Formula Instance (DB Table) | 8 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
27 | EFORMULATRIGKMP | ISU EDM Compressed Trigger File for Formula Inst. (DB Table) | 4 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
28 | EFORMULATRIGTMP | ISU EDM Temporary Trigger File for Formula Inst. (DB Table) | 5 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
29 | EPROFASS | Allocation of Profiles | 8 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
30 | EPROFHEAD | Profile Header Data | 17 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
31 | EPROFHEAD_TMP | Header Data of Temporary Profile | 17 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
32 | EPROFVALSTAT | Profile Value Status | 7 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
33 | EPROFVALSTATHIST | History of Profile Value Status | 8 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
34 | EPROFVALSTAT_TMP | Status of Temporary Profile Values | 7 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
35 | EPROFVERSHEAD | Header Data for Profile Version | 5 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
36 | EPROFVERSSTAT | Status of Profile Version of Version | 7 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
37 | ERTPIFACECOMPHIS | Components for RTP Interface (Historical Part) | 5 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
38 | ERTPIFACEINP | Allocation of Input Parameters for RTP Interface | 7 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
39 | ERTPIFACEINST | Activation of RTP Components for Individual Installations | 8 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
40 | ERTPIFACEINSTPAR | Allocation of Parameters to RTP Interface for Indiv. Insts | 10 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
41 | ESERVPROVHIST | Service Provider (Historical Data) | 4 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
42 | ESERVPROVSERVICE | Non-Billable Services (Service Types) for Service Provider | 7 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
43 | ESOURCEH | Source of Object (Historical Data) | 6 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
TOPFlexible Real Estate Management |
44 | TIVCARECUR | Recurrence Rule | 7 | TIMEFROM | Start of Appointment (Time) | nvarchar | 6 | 0 | | |
45 | VICARECUR | Deadline Regulation | 7 | TIMEFROM | Start of Appointment (Time) | nvarchar | 6 | 0 | | |
TOPIntercompany Data Exchange |
46 | EDEREGSPAGREE | Service Provider Agreements | 4 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
47 | TINV_INV_LOGHD | Log Table - HEAD - for Bill Receipt Processing | 6 | TIMEFROM | Time | nvarchar | 6 | 0 | | |
TOPOLAP Technology |
48 | RSDDSTATEXTRACT | Extractor BW statistics: Time of last delta load | 3 | TIMEFROM | UTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun) | decimal | 21 | 7 | | |
TOPPlanning |
49 | RN1SCHED_APPOINT | IS-H*MED Appointment Table | 5 | TIMEFROM | Time for VB Control | nvarchar | 6 | 0 | | |
50 | RN1SCHED_AVAILAB | IS-H*MED Planning Authority Table | 3 | TIMEFROM | Time for VB Control | nvarchar | 6 | 0 | | |
51 | RN1SCHED_FOCAREA | IS-H*MED: Time Areas for Planning Grid (Do not Use!!!) | 2 | TIMEFROM | Time for VB Control | nvarchar | 6 | 0 | | |
52 | RN1SCHED_PATT_AS | IS-H*MED: Resource-Planning Grid Pattern Assignment (No Use) | 3 | TIMEFROM | Time for VB Control | nvarchar | 6 | 0 | | |
53 | RN1SCHED_SPECTIM | IS-H*MED Special Time Table | 4 | TIMEFROM | Time for VB Control | nvarchar | 6 | 0 | | |
TOPPoint of delivery |
54 | EUIGRID | Allocation of PoD to Grid | 6 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
55 | EUIINSTLN | Allocation of Installation to PoD | 7 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
56 | EUILNR | Allocation of Logical Device to PoD | 7 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
57 | EUILZW | Allocation of Logical Register to PoD | 7 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
58 | EUITRANS | Transformation of Internal/External Point of Delivery No. | 6 | TIMEFROM | From-time | nvarchar | 6 | 0 | | |
TOPTime Zones |
59 | TTZDF | Summer time rules (fixed annual dates) | 5 | TIMEFROM | Start of Daylight Saving Time (Time) | nvarchar | 6 | 0 | | |
60 | TTZDV | Summer time rules (variable dates) | 7 | TIMEFROM | Start of Daylight Saving Time (Time) | nvarchar | 6 | 0 | | |
TOPWithout Description |
61 | RSTCMASTERLOAD | Master data: Time of Last Load | 4 | TIMEFROM | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |