| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBalanced Scorecard |
1 | UMB_SC107 | Scorecard: BIC Selections | 7 | ISVAR | Indicator for Variable | nvarchar | 1 | 0 | | |
2 | UMB_SC108 | Scorecard: Perspectives : BIC Selections | 8 | ISVAR | Indicator for Variable | nvarchar | 1 | 0 | | |
3 | UMB_SC121 | Scorecard: Strategy: BIC Selection | 8 | ISVAR | Indicator for Variable | nvarchar | 1 | 0 | | |
4 | UMB_SC152 | Scorecard: Objective: BIC Selections | 8 | ISVAR | Indicator for Variable | nvarchar | 1 | 0 | | |
5 | UMB_SC166 | Scorecard: Measures: BIC Selections | 8 | ISVAR | Indicator for Variable | nvarchar | 1 | 0 | | |
6 | UMB_SC190 | Scorecard: Initiatives: BIC Selections | 8 | ISVAR | Indicator for Variable | nvarchar | 1 | 0 | | |
TOPCorporate Performance Monitor |
7 | UMV_TR114 | Obsolete:Value Driver Tree: BIC Selections for Value Drivers | 8 | ISVAR | Indicator for Variable | nvarchar | 1 | 0 | | |
8 | UMV_TR214 | Value Driver Tree: BIC Selections for Measures | 8 | ISVAR | Indicator for Variable | nvarchar | 1 | 0 | | |
TOPManagement Cockpit |
9 | UMM_FR118 | Frame: BIC Selections | 7 | ISVAR | Indicator for Variable | nvarchar | 1 | 0 | | |
TOPPromotion |
10 | WMFH | Markdown Planning - header data | 9 | ISVAR | ID for data variant | nvarchar | 10 | 0 | | |