| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPCCMS Database Monitors for Oracle |
1 | DBABARL | Data Backup - Data Recovery | 4 | JOB_NR | Unique Job Number in a Task | nvarchar | 10 | 0 | | |
2 | DBABD | Information About the Data Files (Oracle) | 4 | JOB_NR | Unique Job Number in a Task | nvarchar | 10 | 0 | | |
3 | DBABL | Information About Archive Log Files (Oracle) | 4 | JOB_NR | Unique Job Number in a Task | nvarchar | 10 | 0 | | |
4 | DBADFL | Details About Reorganization and Memory Modifications | 4 | JOB_NR | Unique Job Number in a Task | nvarchar | 10 | 0 | | |
5 | DBAEXTL | Memory Space Changes | 4 | JOB_NR | Unique Job Number in a Task | nvarchar | 10 | 0 | | |
6 | DBAML | Job / Job Step Utility View | 4 | JOB_NR | Unique Job Number in a Task | nvarchar | 10 | 0 | | |
7 | DBAOBJL | Object Status | 4 | JOB_NR | Unique Job Number in a Task | nvarchar | 10 | 0 | | |
8 | DBAOPTL | DB Optimization - Table Statistics | 4 | JOB_NR | Unique Job Number in a Task | nvarchar | 10 | 0 | | |
9 | DBAPHAL | Object Status | 4 | JOB_NR | Unique Job Number in a Task | nvarchar | 10 | 0 | | |
10 | DBARCL | Sub-operations | 4 | JOB_NR | Unique Job Number in a Task | nvarchar | 10 | 0 | | |
11 | DBAREOL | Reorganization | 4 | JOB_NR | Unique Job Number in a Task | nvarchar | 10 | 0 | | |
12 | DBASPAL | Memory Allocation | 4 | JOB_NR | Unique Job Number in a Task | nvarchar | 10 | 0 | | |
13 | DBATL | Central Task / Job Information | 4 | JOB_NR | Unique Job Number in a Task | nvarchar | 10 | 0 | | |
TOPContract Billing |
14 | EPPMDEBT | Table for Debts Adjustment Using Prepayment Meter | 22 | JOB_NR | Document Number | nvarchar | 8 | 0 | | |
15 | EPPM_QS03 | Request for Automated Meter Reading | 9 | JOB_NR | Document Number | nvarchar | 8 | 0 | | |
16 | EPPM_QS06 | Request for quotation | 9 | JOB_NR | Document Number | nvarchar | 8 | 0 | | |
17 | EPPM_QS07 | Supplier Complaint | 11 | JOB_NR | Document Number | nvarchar | 8 | 0 | | |
18 | EPPM_QS08 | Changes to Meter Rate Data | 23 | JOB_NR | Document Number | nvarchar | 8 | 0 | | |
19 | EPPM_QS09 | Reason for Meter Removal | 8 | JOB_NR | Document Number | nvarchar | 8 | 0 | | |