| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SOMO/JOBMON01 | Job schedule template | 38 | PERIODICITY | | int | 10 | 0 | | |
TOPBalanced Scorecard |
2 | UMB_MC100 | Scorecard: Measure Value Fields | 14 | PERIODICITY | Value Fields - Periodization | nvarchar | 4 | 0 | | |
3 | UMB_MC106 | Scorecard: BW Variables for the Value Fields of a Measure | 6 | PERIODICITY | Technical Name of Periodization | nvarchar | 4 | 0 | | |
4 | UMB_SC100 | Scorecard: Header Table | 19 | PERIODICITY | Periodization of an Application | nvarchar | 4 | 0 | | |
5 | UMB_SC103 | Scorecard: Measure Assignment | 12 | PERIODICITY | Periodization of Element | nvarchar | 4 | 0 | | |
6 | UMB_SC104 | Scorecard: Strategy Assignment | 11 | PERIODICITY | Periodization of Element | nvarchar | 4 | 0 | | |
7 | UMB_SC105 | Scorecard: Objective Assignment | 11 | PERIODICITY | Periodization of Element | nvarchar | 4 | 0 | | |
8 | UMB_SC112 | Scorecard: Perspective Assignment | 11 | PERIODICITY | Periodization of Element | nvarchar | 4 | 0 | | |
9 | UMB_SC180 | Scorecard: Initiatives | 30 | PERIODICITY | Periodization of Element | nvarchar | 4 | 0 | | |
10 | UMB_SC193 | Scorecard: BW Key Figure Values of an Initiative | 9 | PERIODICITY | Value Fields - Periodization | nvarchar | 4 | 0 | | |
11 | UMB_SC195 | Scorecard: BW Variables for Value Fields of an Initiative | 6 | PERIODICITY | Technical Name of Periodization | nvarchar | 4 | 0 | | |
TOPClaims Management |
12 | ICLITEM | Claim Item | 72 | PERIODICITY | Time Periods | nvarchar | 2 | 0 | | |
13 | ICSITEM | Claim Item | 72 | PERIODICITY | Time Periods | nvarchar | 2 | 0 | | |
TOPCorporate Performance Monitor |
14 | UMC_RU100 | Periodization | 2 | PERIODICITY | Technical Name of Periodization | nvarchar | 4 | 0 | | |
15 | UMC_RU100T | Periodization: Texts | 2 | PERIODICITY | Technical Name of Periodization | nvarchar | 4 | 0 | | |
16 | UMC_RU101 | Periodization: Subintervals | 2 | PERIODICITY | Technical Name of Periodization | nvarchar | 4 | 0 | | |
17 | UMC_RU101T | Periodization: Subintervals - Texts | 2 | PERIODICITY | Technical Name of Periodization | nvarchar | 4 | 0 | | |
18 | UMR_RF100 | RMS: Measure-Risk Value Fields | 16 | PERIODICITY | Value Fields - Periodization | nvarchar | 4 | 0 | | |
19 | UMR_RF102 | RMS: Measure-Risk Value Fields BW Variable | 9 | PERIODICITY | Technical Name of Periodization | nvarchar | 4 | 0 | | |
20 | UMR_RI110 | RMS: Assignment of Target Systems | 8 | PERIODICITY | Periodization of Element | nvarchar | 4 | 0 | | |
21 | UMR_RI116 | RMS: Measure Weight Data Selection - NOT USED | 12 | PERIODICITY | Value Fields - Periodization | nvarchar | 4 | 0 | | |
22 | UMV_TR100 | Value Driver Tree: Header Table | 9 | PERIODICITY | Periodization of an Application | nvarchar | 4 | 0 | | |
23 | UMV_TR112 | Obsolete: Value Driver Tree: Value Fields of a Value Driver | 12 | PERIODICITY | Value Fields - Periodization | nvarchar | 4 | 0 | | |
24 | UMV_TR116 | Obsolete: Value Driver Tree: BW Variables for Value Fields | 6 | PERIODICITY | Technical Name of Periodization | nvarchar | 4 | 0 | | |
25 | UMV_TR212 | Value Driver Tree: Value Fields or Measure | 12 | PERIODICITY | Value Fields - Periodization | nvarchar | 4 | 0 | | |
26 | UMV_TR216 | Value Driver Tree: BW Variables for Value Fields | 6 | PERIODICITY | Technical Name of Periodization | nvarchar | 4 | 0 | | |
TOPManagement Cockpit |
27 | UMM_CO100 | Cockpits: Header Table | 13 | PERIODICITY | Periodization of an Application | nvarchar | 4 | 0 | | |
28 | UMM_FR110 | Frames:Graphics Assignment | 13 | PERIODICITY | Periodization | nvarchar | 4 | 0 | | |
29 | UMM_FR114 | Frame: BW Variables | 4 | PERIODICITY | Technical Name of Periodization | nvarchar | 4 | 0 | | |
TOPOffice Suite Program |
30 | /OSP/T_RAUI_MT | OSP Mendocino Timepoints Table | 7 | PERIODICITY | Frequency | smallint | 5 | 0 | | |
31 | /OSP/T_RAUI_SCH | OSP Report Scheduling Table | 9 | PERIODICITY | Frequency | smallint | 5 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
32 | DFMCA_BRF510 | BRF: Parameters for Creating Tax Obligation | 15 | PERIODICITY | BRF: Expression | nvarchar | 20 | 0 | | |
TOPService Data Download |
33 | /SOMO/JOSCHEDLT | Job Schedule Local Template | 52 | PERIODICITY | | int | 10 | 0 | | |