| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBalanced Scorecard |
| 1 | UMB_MC101 | Scorecard: Characteristics for the Value Fields of a Measure | 29 | HIDATE | Hierarchy: Key date | nvarchar | 8 | 0 | | |
| 2 | UMB_MC107 | Scorecard: BW Variables for the Value Fields of a Measure | 27 | HIDATE | Hierarchy: Key date | nvarchar | 8 | 0 | | |
| 3 | UMB_SC102 | Scorecard: Value Definition of the CPM Variable | 20 | HIDATE | Hierarchy: Key date | nvarchar | 8 | 0 | | |
| 4 | UMB_SC194 | Scorecard: Characteristics for BW Key Figs of an Initiative | 27 | HIDATE | Hierarchy: Key date | nvarchar | 8 | 0 | | |
| 5 | UMB_SC196 | Scorecard: BW Variables for Value Fields of an Initiative | 27 | HIDATE | Hierarchy: Key date | nvarchar | 8 | 0 | | |
| TOPCorporate Performance Monitor |
| 6 | UMR_RF101 | RMS: Measure-Risk Value Fields Selection Criteria | 32 | HIDATE | Hierarchy: Key date | nvarchar | 8 | 0 | | |
| 7 | UMR_RF103 | RMS: Measure-Risk Value Fields BW Variables | 30 | HIDATE | Hierarchy: Key date | nvarchar | 8 | 0 | | |
| 8 | UMR_RI117 | RMS: Measure Weight Data Selection - Selections - NOT USED | 29 | HIDATE | Hierarchy: Key date | nvarchar | 8 | 0 | | |
| 9 | UMV_TR102 | Value Driver Tree: Selections of the CPM Variables | 20 | HIDATE | Hierarchy: Key date | nvarchar | 8 | 0 | | |
| 10 | UMV_TR104 | Value Driver Tree: Value Combinations of Runtime Variables | 20 | HIDATE | Hierarchy: Key date | nvarchar | 8 | 0 | | |
| 11 | UMV_TR108 | Value Driver Tree: Versions of Value Fields for Simulation | 20 | HIDATE | Hierarchy: Key date | nvarchar | 8 | 0 | | |
| 12 | UMV_TR113 | Obsolete: Value Driver Tree: Selections for the Value Fields | 29 | HIDATE | Hierarchy: Key date | nvarchar | 8 | 0 | | |
| 13 | UMV_TR117 | Obsolete: Value Driver Tree: BW Variables for Value Fields | 25 | HIDATE | Hierarchy: Key date | nvarchar | 8 | 0 | | |
| 14 | UMV_TR213 | Value Driver Tree: Selections for the Value Fields | 29 | HIDATE | Hierarchy: Key date | nvarchar | 8 | 0 | | |
| 15 | UMV_TR217 | Value Driver Tree: BW Variables for Value Fields | 25 | HIDATE | Hierarchy: Key date | nvarchar | 8 | 0 | | |
| TOPManagement Cockpit |
| 16 | UMM_BU100 | Obsolete: Selections for Buffer of Transaction Data | 20 | HIDATE | Hierarchy: Key date | nvarchar | 8 | 0 | | |
| 17 | UMM_BU103 | Obsolete: Selections for Buffer of Transaction Data | 13 | HIDATE | Hierarchy: Key date | nvarchar | 8 | 0 | | |
| 18 | UMM_BU106 | Selections for Buffer of Transaction Data | 13 | HIDATE | Hierarchy: Key date | nvarchar | 8 | 0 | | |
| 19 | UMM_CO102 | Cockpits: Assignment of Variables with Selection Conditions | 25 | HIDATE | Hierarchy: Key date | nvarchar | 8 | 0 | | |
| 20 | UMM_FR101 | Frames: Dimensions | 27 | HIDATE | Hierarchy: Key date | nvarchar | 8 | 0 | | |
| 21 | UMM_FR115 | Frame: Replacement of BW Variables | 26 | HIDATE | Hierarchy: Key date | nvarchar | 8 | 0 | | |
| 22 | UMM_LG100 | Selections for Log of Transaction Data Buffer | 19 | HIDATE | Hierarchy: Key date | nvarchar | 8 | 0 | | |
| 23 | UMM_ST101 | Selections for Status of the Frames in the Cockpits | 22 | HIDATE | Hierarchy: Key date | nvarchar | 8 | 0 | | |
| 24 | UMM_VA103 | Variables: Proposed Selections | 19 | HIDATE | Hierarchy: Key date | nvarchar | 8 | 0 | | |
