| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TIVXCESCDMSR | Define the measurements that affect the rent | 2 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
2 | TIVXCITCADMSR | Define the editable measurements | 3 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
3 | TIVYCMETER2COST | Meter and Cost Element Mapping table | 4 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
4 | VIXCITCADMSR | Temporary measurement data | 6 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
5 | VIYCMETERCOSTS | Meter Based Costs | 15 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
TOPBalanced Scorecard |
6 | UMB_BC_SM103 | Strategy Map: Measure Assignment | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
7 | UMB_MC100 | Scorecard: Measure Value Fields | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
8 | UMB_MC101 | Scorecard: Characteristics for the Value Fields of a Measure | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
9 | UMB_MC102 | Scorecard: Graphics | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
10 | UMB_MC103 | Scorecard: Assignment of Columns to Graphics | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
11 | UMB_MC105 | Scorecard: Graphics: Texts | 4 | MEAS | Measure | nvarchar | 18 | 0 | | |
12 | UMB_MC106 | Scorecard: BW Variables for the Value Fields of a Measure | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
13 | UMB_MC107 | Scorecard: BW Variables for the Value Fields of a Measure | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
14 | UMB_MC108 | Scorecard: Graphic - Setting in XML Format | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
15 | UMB_MC109 | Scorecard: Graphic - Setting in XML Format | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
16 | UMB_SC103 | Scorecard: Measure Assignment | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
17 | UMB_SC160 | Scorecard: Measure Assignment (Time-Dependent) | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
18 | UMB_SC161 | Scorecard: Measure Score, A&C, DBS, Doc Id | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
19 | UMB_SC162 | Objective: Measure Assignment (Time-Dependent) | 4 | MEAS | Measure | nvarchar | 18 | 0 | | |
20 | UMB_SC163 | Scorecard: Assignment of Formula Argument to Value Fields | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
21 | UMB_SC164 | Scorecard: Formula to Calculate the Status of a Measure | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
22 | UMB_SC165 | Scorecard: Assignment of Formula Value to Measure Status | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
23 | UMB_SC166 | Scorecard: Measures: BIC Selections | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
24 | UMB_SC167 | Scorecard: Measures: BPS Link | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
25 | UMB_SC168 | Scorecard: Measures: Assigned BW Queries | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
TOPBasic Data |
26 | TIVBDMEAS | Measurement Type | 2 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
27 | TIVBDMEASAO | Measurement Type: Settings per Arch. Object Type | 2 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
28 | TIVBDMEASAOFU | Measurement Types: Settings per Arch. Object Type and Funct. | 2 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
29 | TIVBDMEASMETER | Characteristic per Measurement Type | 2 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
30 | TIVBDMEASRELSTRC | Measurement Structure for Measurement Type | 3 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
31 | TIVBDMEASRO | Measurement Type: Settings per Usage Type | 2 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
32 | TIVBDMEASROTYPE | Measurement Type: Settings per Rental Object Type | 2 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
33 | TIVBDMEAST | Measurement Type - Texts | 3 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
34 | VIBDMEAS | Measurement | 3 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
35 | VIBDOBJRELPART | Object Relationship A/U Object <-> A/U Object: Percent | 5 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
36 | VIBDPLANOBJ | Plan Pooled Space | 7 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
37 | VIBDPLANOCC | Planned Occupancy of Usage Objects | 7 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
TOPCorporate Performance Monitor |
38 | UMK_BU100 | Total Float | 1 | MEAS | Measure | nvarchar | 18 | 0 | | |
39 | UMK_MB100 | Key Figures: Header Table | 1 | MEAS | Measure | nvarchar | 18 | 0 | | |
40 | UMK_MB100T | Measures: Texts | 2 | MEAS | Measure | nvarchar | 18 | 0 | | |
41 | UMK_MB110 | Industry Assignment | 1 | MEAS | Measure | nvarchar | 18 | 0 | | |
42 | UMK_MB120 | Benchmark Data Source <-> Measure | 1 | MEAS | Measure | nvarchar | 18 | 0 | | |
43 | UMK_MB130 | Measure Mapping & Sourcing: InfoProvider Key Figure | 1 | MEAS | Measure | nvarchar | 18 | 0 | | |
44 | UMK_MB140 | URL Assignment | 1 | MEAS | Measure | nvarchar | 18 | 0 | | |
45 | UMK_MB140T | Text Table for URL Assignment | 2 | MEAS | Measure | nvarchar | 18 | 0 | | |
46 | UMK_MB150 | Company <-> Provider Measure | 1 | MEAS | Customer Measure | nvarchar | 18 | 0 | | |
47 | UMK_MB160 | Source for Measure | 1 | MEAS | Measure | nvarchar | 18 | 0 | | |
48 | UMK_MB200 | Measure Formula | 1 | MEAS | Measure | nvarchar | 18 | 0 | | |
49 | UMR_EX100 | RMS: Measure Deviations for Risks | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
50 | UMR_EX110 | RMS: Measure Targets | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
51 | UMR_EX120 | RMS: Measure Status & Risk Status | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
52 | UMR_RF100 | RMS: Measure-Risk Value Fields | 4 | MEAS | Measure | nvarchar | 18 | 0 | | |
53 | UMR_RF101 | RMS: Measure-Risk Value Fields Selection Criteria | 4 | MEAS | Measure | nvarchar | 18 | 0 | | |
54 | UMR_RF102 | RMS: Measure-Risk Value Fields BW Variable | 4 | MEAS | Measure | nvarchar | 18 | 0 | | |
55 | UMR_RF103 | RMS: Measure-Risk Value Fields BW Variables | 4 | MEAS | Measure | nvarchar | 18 | 0 | | |
56 | UMR_RI030 | Risk: Measure Assignment | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
57 | UMR_RI114 | RMS: Measure Selection and Attributes | 4 | MEAS | Measure | nvarchar | 18 | 0 | | |
58 | UMR_RI115 | RMS: Measure Formula Argument Assignment | 4 | MEAS | Measure | nvarchar | 18 | 0 | | |
59 | UMR_RI116 | RMS: Measure Weight Data Selection - NOT USED | 4 | MEAS | Measure | nvarchar | 18 | 0 | | |
60 | UMR_RI117 | RMS: Measure Weight Data Selection - Selections - NOT USED | 4 | MEAS | Measure | nvarchar | 18 | 0 | | |
61 | UMR_RI118 | RMS: Measure-Risk Value Fields Read Only Flag | 4 | MEAS | Measure | nvarchar | 18 | 0 | | |
62 | UMR_RI128 | RMS: Measure Deviations for Risks | 4 | MEAS | Measure | nvarchar | 18 | 0 | | |
63 | UMR_RI129 | RMS: Risk Status for Measure | 4 | MEAS | Measure | nvarchar | 18 | 0 | | |
64 | UMV_TR120 | Value Driver Tree: Graphics | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
65 | UMV_TR121 | Value Driver Tree: Assignment of Value Fields to Graphics | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
66 | UMV_TR123 | Value Driver Tree: Graphics : Texts | 4 | MEAS | Measure | nvarchar | 18 | 0 | | |
67 | UMV_TR124 | Value Driver Tree: Graphic - Settings in XML Format | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
68 | UMV_TR127 | Value Driver Tree: Graphic - Settings in XML Format | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
69 | UMV_TR210 | Value Driver Tree: Used Measures | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
70 | UMV_TR212 | Value Driver Tree: Value Fields or Measure | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
71 | UMV_TR213 | Value Driver Tree: Selections for the Value Fields | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
72 | UMV_TR214 | Value Driver Tree: BIC Selections for Measures | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
73 | UMV_TR215 | Value Driver Tree: BW Queries and Workbooks for Measures | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
74 | UMV_TR216 | Value Driver Tree: BW Variables for Value Fields | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
75 | UMV_TR217 | Value Driver Tree: BW Variables for Value Fields | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
76 | UMV_TR218 | Value Driver Tree: Assignment of BPS Functions to Measures | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
77 | UMV_TR219 | Value Driver Tree - Measures: BPS Measure | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
78 | UMV_TR225 | Value Driver Tree: Assignment of web Reports to Measures | 4 | MEAS | Measure | nvarchar | 18 | 0 | | |
79 | UMV_TR226 | Value Driver Tree: Assignment of URLs to Measures | 4 | MEAS | Measure | nvarchar | 18 | 0 | | |
80 | UMV_TR227 | Value Driver Tree: Responsible Persons for Measures | 4 | MEAS | Measure | nvarchar | 18 | 0 | | |
81 | UMV_TR230 | Value Driver Tree: Assign Value Fields to Formula Arguments | 3 | MEAS | Measure | nvarchar | 18 | 0 | | |
82 | UMV_TR231 | Value Driver Tree: Status, Assessments and Comments | 4 | MEAS | Measure | nvarchar | 18 | 0 | | |
TOPDFPS Authorized Infrastructure |
83 | /ISDFPS/CREIPLY | Assignment of Architectural Object Type to Planning Level | 4 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
TOPFlexible Real Estate Management |
84 | TIVSCSCKATTR | OBSOLETE: Service Charge Key Attributes | 6 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
85 | VISCS_MEAS | OBSOLETE: Measurement Amount (Replaced by VISCSMEAS) | 5 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
86 | VIXCSCCHTPSHAR | Distribution for External Heating Expenses Settlement | 7 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
TOPInformation System |
87 | TIVISPFCONDREL | Report Profile for Conditions: Properties | 10 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
88 | TIVISPFMEASREL | Report Profile for Measurements: Properties | 4 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
TOPInput Tax Treatment |
89 | TIVITOPTMETH | Method for Option Rate Determination | 4 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
90 | VIITORCOBJ | Option Rate Determination: Result of Calculation Object | 5 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
TOPLocalization |
91 | VIXCJPSCCOSTSEXT | Costs per Object - Legacy Data Transfer | 25 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
TOPManagement Cockpit |
92 | UMM_FR102 | Frames: Key Figures | 11 | MEAS | Measure | nvarchar | 18 | 0 | | |
TOPMigration |
93 | TIVMISETMEAS | Conversion of Area Type and Apportionment Unit to Meas.Type | 4 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
TOPOffer and Rental Request |
94 | TIVORRRTYPEMTC | Usage Types for RE Search Request Type | 5 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
95 | VIOROO | Offered Object | 19 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
TOPReal Estate Contract |
96 | TIVCNMEASCN | Measurement: Settings per Contract Type | 2 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
97 | VICNMEASCN | Contract Measurement | 4 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
TOPReal Estate Controlling |
98 | TIVEXCOMEASKYF | Assignment of Measurement to Statistical Key Figure | 6 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
TOPReal Estate Management |
99 | VIAK26 | Master Settlement Unit: Participating Settlement Units | 35 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
TOPRent Adjustment |
100 | TIVAJMEASAT | Measurement: Settings per Adjustment Rule | 2 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
TOPSales-Based Rent and Settlement |
101 | VISRTMRP | Reporting Rule | 11 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
TOPService Charge Settlement |
102 | TIVSCAJSCKATTR | Attributes of Adjustment of SCS Advance Pmnt per SC Key | 3 | MEAS | Measurement Type for Consideration of Average Costs | nvarchar | 4 | 0 | | |
103 | TIVSCMEAS2COND | Assignment of Measurement Type to Condition Type | 2 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
104 | TIVSCSCKEY | Service Charge Keys | 9 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
105 | TIVSCSUDEFAULT | Defaults for Creating SU per SC Key | 4 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
106 | VISCEXBASERATE | Basic Components for External Settlement per SU | 5 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
107 | VISCSHAREOUT | Split settlement factors for settlement variant | 5 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
108 | VISCSUREL | Master Settlement Unit: Participating Settlement Units | 16 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
109 | VISCS_MSU_REST | Distribution of Master SU to Remaining Objects | 10 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
110 | VISCS_MSU_SU | Distribution of Master SU to Participating SUs | 11 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
111 | VISCS_RO_CN | Costs and Measurement Amounts for REC + RO (Lease-Out View) | 10 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
112 | VISCS_SU_RO | Sum of All Costs and Measurement Amounts for a Rental Object | 10 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |
113 | VISCS_SU_SUM | Sum of All Costs and Measurement Amounts for Settlment Unit | 9 | MEAS | Measurement Type | nvarchar | 4 | 0 | | |