| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNVTDMS_05_SETD | Settlemant Documents TDMS for ISU | 3 | SETTLDOC | BEDID for CNVTDMS_05_* | nvarchar | 12 | 0 | | |
TOPEnergy Data Management |
2 | EEDMSETTLDOC | Settlement Document (Header) | 2 | SETTLDOC | Settlement Document | nvarchar | 12 | 0 | | |
3 | EEDMSETTLDOCALER | Settlement Document (Alerts) | 3 | SETTLDOC | Settlement Document | nvarchar | 12 | 0 | | |
4 | EEDMSETTLDOCERR | Settlement Document (Errors) | 3 | SETTLDOC | Settlement Document | nvarchar | 12 | 0 | | |
5 | EEDMSETTLDOCLINE | Settlement Document (Lines) | 3 | SETTLDOC | Settlement Document | nvarchar | 12 | 0 | | |
6 | EEDMSETTLDOCPARV | Settlement Document (Persistent Value Parameters) | 3 | SETTLDOC | Settlement Document | nvarchar | 12 | 0 | | |
7 | EEDMSETTLDOCRUN | Settlement Document (Run) | 2 | SETTLDOC | Settlement Document | nvarchar | 12 | 0 | | |
8 | EEDMSETTLDOCSNDP | Settlement Document (Sent Profiles) | 3 | SETTLDOC | Settlement Document | nvarchar | 12 | 0 | | |
9 | EEDMSETTLDOCUNIT | Settlement Document (Settlement Units Accounted for) | 2 | SETTLDOC | Settlement Document | nvarchar | 12 | 0 | | |
10 | EEDMSETTLDOCUPDP | Settlement Document (Updated Profiles) | 3 | SETTLDOC | Settlement Document | nvarchar | 12 | 0 | | |
11 | EEDMSETTLIN | Load Shapes Per Settlement Run | 2 | SETTLDOC | Settlement Document | nvarchar | 12 | 0 | | |
12 | EEDMSETTLUF | Usage Factors per Settlement Run | 2 | SETTLDOC | Settlement Document | nvarchar | 12 | 0 | | |