1
.INCLUDE
0
0
Primary key for Object part
2
OBJ_PRT_GUID
CMS_RE_DTE_OBJ_PRT_GUID
SYSUUID
RAW
16
0
GUID for Object part
3
.INCLUDE
0
0
Link structure for the real estate object
4
OBJ_GUID
CMS_RE_DTE_OBJ_GUID
SYSUUID
RAW
16
0
GUID for Real Estate Object
CMS_RE_OBJ
5
.INCLUDE
0
0
Structure for Semantic key for Objects in RE Add-On
6
OBJECT_ID
CMS_RE_DTE_OBJECT_ID
CMS_RE_OBJECT_ID
CHAR
20
0
Object ID
7
OBJECT_TYPE
CMS_RE_DTE_OBJ_TYP
CMS_RE_TYP
CHAR
6
0
Real Estate Object Type ID
*
8
.INCLUDE
0
0
Structure for Part ID
9
PART_ID
CMS_RE_DTE_PART_ID
CMS_RE_PRT_ID
NUMC
10
0
Part ID for the Object
10
.INCLUDE
0
0
Structure for Basic Part Details
11
BLD_PART_TYPE
CMS_RE_DTE_ATT_ID_TY_REO006
CMS_ATT_ID_TYP
CHAR
6
0
Building Part Type
TCMS_ATT_ID_TY
12
PART_COND
CMS_RE_DTE_ATT_ID_TY_REO001
CMS_ATT_ID_TYP
CHAR
6
0
Object condition
TCMS_ATT_ID_TY
13
MAIN_USAGE
CMS_RE_DTE_USG_TYP
CMS_RE_TYP
CHAR
6
0
Usage Type
TCMS_RE_U_TYP
14
ADD_USAGE_1
CMS_RE_DTE_ADD1_USG_TYP
CMS_RE_TYP
CHAR
6
0
Additional Usage 1
TCMS_RE_U_TYP
15
ADD_USAGE_2
CMS_RE_DTE_ADD2_USG_TYP
CMS_RE_TYP
CHAR
6
0
Additional Usage 2
TCMS_RE_U_TYP
16
BLD_METHOD_ROOF
CMS_RE_DTE_ATT_ID_TY_REO007
CMS_ATT_ID_TYP
CHAR
6
0
Building method - Roof
TCMS_ATT_ID_TY
17
BLD_METHOD_BODY
CMS_RE_DTE_ATT_ID_TY_REO008
CMS_ATT_ID_TYP
CHAR
6
0
Building method - Body
TCMS_ATT_ID_TY
18
BLD_METD_CELLAR
CMS_RE_DTE_ATT_ID_TY_REO009
CMS_ATT_ID_TYP
CHAR
6
0
Building method - Cellar
TCMS_ATT_ID_TY
19
UTILIZATION
CMS_RE_DTE_PRT_UTILIZATION
CMS_RE_UTIL
CHAR
6
0
Utilization of the Object
20
PART_DESC
CMS_RE_DTE_SPC_DESC
CMS_RE_DESC
CHAR
30
0
Description of Building Part
21
COMM_USAGE_PCT
CMS_RE_DTE_COM_USE_PCT
CMS_RE_PCT
DEC
10
6
Commercial Usage as a Percentage of Total Usage
22
OTHER_USG_FLG
CMS_RE_DTE_OTH_USE_FLG
CMS_RE_OTH_USG_FLG
CHAR
1
0
Indicates if Usages in addition to Main Usage are Possible
23
REF_OBJ_PRT_GUID
CMS_RE_DTE_REF_OBJ_PRT_GUID
SYSUUID
RAW
16
0
Reference Object Part GUID
24
IS_SUB_AST_CREA
CMS_RE_DTE_CREATE_SUB_AST_FLG
CMS_RE_FLG
CHAR
1
0
Indicates whether a Sub-asset is created for Building Part
25
.INCLUDE
0
0
Structure for Part Size Details
26
USEFUL_AREA
CMS_RE_DTE_AREA_USEFUL
CMS_RE_SIZE
QUAN
13
3
Usable Area
27
USBL_AREA_UOM
CMS_RE_DTE_USBL_AREA_UOM
MEINS
UNIT
3
0
Unit of Measure for Usable Area
*
28
USEFUL_AREA_REN
CMS_RE_DTE_AREA_USEFUL_REN
CMS_RE_SIZE
QUAN
13
3
Rented Usable Area
29
USBL_AR_REN_UOM
CMS_RE_DTE_USBL_AREA_REN_UOM
MEINS
UNIT
3
0
Unit of Measure for Usable Rented Area
*
30
USEFUL_VOL
CMS_RE_DTE_VOL_USEFUL
CMS_RE_SIZE
QUAN
13
3
Usable Volume of Real Estate Building Parts
31
USBL_VOL_UOM
CMS_RE_DTE_USBL_VOL_UOM
MEINS
UNIT
3
0
Unit of Measure for Usable Volume of Real Estate
*
32
USEFUL_VOL_REN
CMS_RE_DTE_VOL_USEFUL_REN
CMS_RE_SIZE
QUAN
13
3
Usable Volume of the Rented Portions of Real Estate
33
USBL_VL_REN_UOM
CMS_RE_DTE_USBL_VOL_REN_UOM
MEINS
UNIT
3
0
Unit of measure for usable volume of Rented Parts
*
34
RESIDENTIAL_AREA
CMS_RE_DTE_AREA_RESIDENTIAL
CMS_RE_SIZE
QUAN
13
3
Residential Area
35
RES_AR_UOM
CMS_RE_DTE_RES_AREA_UOM
MEINS
UNIT
3
0
Unit of Measure for Residential Area
*
36
SECONDARY_AREA
CMS_RE_DTE_AREA_SECONDARY
CMS_RE_SIZE
QUAN
13
3
Secondary Area
37
SEC_AREA_UOM
CMS_RE_DTE_SEC_AREA_UOM
MEINS
UNIT
3
0
Unit of Measure for Secondary Area
*
38
OTHER_AREA
CMS_RE_DTE_AREA_OTHER
CMS_RE_SIZE
QUAN
13
3
Other Area
39
OTH_AREA_UOM
CMS_RE_DTE_OTH_AREA_UOM
MEINS
UNIT
3
0
Unit of Measure for Other Area
*
40
.INCLUDE
0
0
Structure for Part Unit Details
41
NO_PRT_UNIT
CMS_RE_DTE_NO_PRT_UNIT
CMS_RE_UNITS
INT4
10
0
Number of building part units
42
NO_PRT_UNIT_REN
CMS_RE_DTE_NO_PRT_UNIT_REN
CMS_RE_UNITS
INT4
10
0
Number of building part units rented
43
.INCLUDE
0
0
Structure for dates
44
CONS_START_DATE
CMS_RE_DTE_OBJ_CONS_ST_DATE
CMS_RE_DATE
DATS
8
0
Start Date of Construction
45
PERMSN_APPL_DATE
CMS_RE_DTE_OBJ_PMSN_APPL_DATE
CMS_RE_DATE
DATS
8
0
Building Permssion applied date
46
PERMSN_OBTD_DATE
CMS_RE_DTE_OBJ_PMSN_OBTD_DATE
CMS_RE_DATE
DATS
8
0
Building Permssion obtained date
47
OCCY_DATE
CMS_RE_DTE_OBJ_OCCY_DATE
CMS_RE_DATE
DATS
8
0
Occupancy Date
48
COMP_DATE
CMS_RE_DTE_OBJ_COMP_DATE
CMS_RE_DATE
DATS
8
0
Completion Date
49
FINAL_INSP_DATE
CMS_RE_DTE_OBJ_FINAL_INSP_DATE
CMS_RE_DATE
DATS
8
0
Date of Final Inspection
50
.INCLUDE
0
0
51
.INCLUDE
0
0
Structure for Part Rent Details
52
RENT_AMT_PLANNED
CMS_RE_DTE_RENT_AMOUNT
CMS_RE_AMOUNT
CURR
17
2
Planned Rent Amount
53
RENT_AMT_ACTUAL
CMS_RE_DTE_RENT_AMOUNT_ACT
CMS_RE_AMOUNT
CURR
17
2
Actual Rent Amount
54
RENT_PLAN_CURR
CMS_RE_DTE_RENT_PLANNED_CURR
WAERS
CUKY
5
0
Planned Rent Currency
TCURC
55
RENT_ACT_CURR
CMS_RE_DTE_RENT_ACTUAL_CURR
WAERS
CUKY
5
0
Actual Rent Currency
TCURC
56
BASE_PERIOD
CMS_RE_DTE_BASE_PERIOD
CMS_RE_BASE_PERIOD
CHAR
1
0
Base period for the rent
57
BASE_MEASURE
CMS_RE_DTE_BASE_MEAS
CMS_RE_BASE_MEAS
CHAR
1
0
Base Measure
58
VACANT_POSN_PCT
CMS_RE_DTE_VACANT_POS_PCT
CMS_RE_PCT
DEC
10
6
Ratio of Real Estate not rented to Total Real Estate Value
59
RES_RENT_IND
CMS_RE_DTE_RES_IND
CMS_RE_RENT_FLG
CHAR
1
0
Indicator for Net or Gross Rent
60
COMP_RENT_RES
CMS_RE_DTE_RENT_LEVEL
CMS_RE_AMOUNT
CURR
17
2
Comparative Rent (Residential)
61
COM_REN_RES_CURR
CMS_RE_DTE_COMP_RENT_RES_CURR
WAERS
CUKY
5
0
Comparative Rent Currency - Residential
TCURC
62
.INCLUDE
0
0
Structure for Land Area & UOM
63
LAND_AREA
CMS_RE_DTE_LAND_AREA
CMS_RE_SIZE
QUAN
13
3
Land Area of the Real Estate
64
LAND_AREA_UOM
CMS_RE_DTE_LAND_AREA_UOM
MEINS
UNIT
3
0
Unit of Measure of Land Area
T006
65
LAND_AREA_REN
CMS_RE_DTE_LAND_AREA_REN
CMS_RE_SIZE
QUAN
13
3
Land Area of the Real Estate which is Rented
66
LAND_AR_REN_UOM
CMS_RE_DTE_LAND_AREA_REN_UOM
MEINS
UNIT
3
0
Land area unit of measure(rented)
*
67
.INCLUDE
0
0
Structure for General Details
68
NO_OF_UNITS
CMS_RE_DTE_NO_UNIT
CMS_RE_UNITS
INT4
10
0
No of units in real estate object
69
NO_OF_FLOORS
CMS_RE_DTE_NO_FLOOR
CMS_RE_UNITS
INT4
10
0
Number of Floors
70
NO_GARAGES
CMS_RE_DTE_NO_GAR
CMS_RE_UNITS
INT4
10
0
No of Garages in Real Estate Object
71
NO_GARAGES_REN
CMS_RE_DTE_NO_GAR_REN
CMS_RE_UNITS
INT4
10
0
No of Garages Rented in Real Estate Object
72
NO_PARK_UNIT
CMS_RE_DTE_NO_PARK_UNIT
CMS_RE_UNITS
INT4
10
0
Number of Parking Units
73
NO_PARK_UNIT_REN
CMS_RE_DTE_NO_PARK_UNIT_REN
CMS_RE_UNITS
INT4
10
0
Number of Parking Units Rented
74
NO_PARK_UG
CMS_RE_DTE_NO_PARK_UNIT_UG
CMS_RE_UNITS
INT4
10
0
Number of Underground Parking Units
75
NO_PARK_UG_REN
CMS_RE_DTE_NO_PARK_UNIT_UG_REN
CMS_RE_UNITS
INT4
10
0
Number of Rented Underground Parking Units
76
.INCLUDE
0
0
Structure for Residential Details
77
NO_CUR_UNITS
CMS_RE_DTE_NO_CUR_UNIT
CMS_RE_UNITS
INT4
10
0
No of current units in real estate object
78
NO_CUR_UNITS_REN
CMS_RE_DTE_NO_CUR_UNIT_REN
CMS_RE_UNITS
INT4
10
0
No of Current Units Rented in Real Estate Object
79
NO_OLD_UNITS
CMS_RE_DTE_NO_OLD_UNIT
CMS_RE_UNITS
INT4
10
0
No of old units in real estate object
80
NO_OLD_UNITS_REN
CMS_RE_DTE_NO_OLD_UNIT_REN
CMS_RE_UNITS
INT4
10
0
No of Old Units Rented in Real Estate Object
81
NO_NEW_UNITS
CMS_RE_DTE_NO_NEW_UNIT
CMS_RE_UNITS
INT4
10
0
No of new units in real estate object
82
NO_NEW_UNITS_REN
CMS_RE_DTE_NO_NEW_UNIT_REN
CMS_RE_UNITS
INT4
10
0
No of New units Rented in Real Estate Object
83
.INCLUDE
0
0
Structure for Number of Units in Office
84
NO_ACCESS_STR
CMS_RE_DTE_NO_ACCESS_STR
CMS_RE_UNITS
INT4
10
0
No of Access Structures
85
.INCLUDE
0
0
Structure for Number of Sales level in Commericial Building
86
NO_SALE_LEVEL
CMS_RE_DTE_NO_SALE_LEVEL
CMS_RE_UNITS
INT4
10
0
No of Sale levels in commercial building
87
.INCLUDE
0
0
Structure for Number of Rooms in the hotel/clinic
88
NO_OF_ROOMS
CMS_RE_DTE_NO_ROOMS
CMS_RE_UNITS
INT4
10
0
No of rooms in the hotel/clinic
89
.INCLUDE
0
0
Structure for Number of rooms in the clinic/nursing home
90
NO_OF_BEDS
CMS_RE_DTE_NO_BEDS
CMS_RE_UNITS
INT4
10
0
No of beds in the clinic/nursing home
91
.INCLUDE
0
0
92
.INCLUDE
0
0
Structure for Commericial Details
93
COMM_ENV_DESC
CMS_RE_DTE_COMM_ENV_DESC
CMS_RE_DESC
CHAR
30
0
Description of the commercial environment
94
ACCESS_STR_DESC
CMS_RE_DTE_ACCESS_STR_DESC
CMS_RE_DESC
CHAR
30
0
Description of the Access Structures
95
BLD_SECTION_DESC
CMS_RE_DTE_ATT_ID_TY_REO015
CMS_ATT_ID_TYP
CHAR
6
0
Building Section
TCMS_ATT_ID_TY
96
.INCLUDE
0
0
97
.INCLUDE
0
0
Structure for Hotel Details
98
PRICE_CATEGORY
CMS_RE_DTE_ATT_ID_TY_REO013
CMS_ATT_ID_TYP
CHAR
6
0
Price Category
TCMS_ATT_ID_TY
99
AVG_PRICE
CMS_RE_DTE_AVG_PRICE
CMS_RE_AMOUNT
CURR
17
2
Average Price per Day
100
AVG_PRICE_CURR
CMS_RE_DTE_AVG_PRICE_CURR
WAERS
CUKY
5
0
Average Price Currency
TCURC
101
.INCLUDE
0
0
102
.INCLUDE
0
0
Structure for Other Details in RE Object
103
OCCUPANCY_PCT
CMS_RE_DTE_OCCY_PCT
CMS_RE_PCT
DEC
10
6
Occupancy specified in Percentage Terms
104
TURNOVER_AMT
CMS_RE_DTE_TURNOVER_AMOUNT
CMS_RE_AMOUNT
CURR
17
2
Total Amount of Turnover
105
TURNOVER_CURR
CMS_RE_DTE_TURNOVER_CURR
WAERS
CUKY
5
0
Currency
TCURC
106
RENTAL_AGMT_TYP
CMS_RE_DTE_ATT_ID_TY_REO014
CMS_ATT_ID_TYP
CHAR
6
0
Rental Agreement Type
TCMS_ATT_ID_TY
107
.INCLUDE
0
0
Insurance details
108
INSURANCE_TYPE
CMS_RE_DTE_ATT_ID_TY_REO011
CMS_ATT_ID_TYP
CHAR
6
0
Insurance Type
TCMS_ATT_ID_TY
109
INSURANCE_AMT
CMS_RE_DTE_INSURANCE_AMOUNT
CMS_RE_AMOUNT
CURR
17
2
Insurance Amount
110
INSURANCE_CURR
CMS_RE_DTE_INSURANCE_CURR
WAERS
CUKY
5
0
Insurance Currency
TCURC
111
INS_VALIDITY
CMS_RE_DTE_INS_VALID_TILL
CMS_RE_DATE
DATS
8
0
Date until which the Insurance Stands Valid
112
.INCLUDE
0
0
Other Costs
113
RATIONING_COST
CMS_RE_DTE_RAT_COST_AMT
CMS_RE_AMOUNT
CURR
17
2
Residential Rationing Cost
114
RTN_CST_PCT
CMS_RE_DTE_RAN_COST_PCT
CMS_RE_PCT
DEC
10
6
Percentage of Residential Rationing Cost
115
EXT_LAYOUT_COST
CMS_RE_DTE_EXT_LAYOUT_COST
CMS_RE_AMOUNT
CURR
17
2
External Layout Cost
116
EXT_LAY_CST_PCT
CMS_RE_DTE_EXT_LAYOUT_COST_PCT
CMS_RE_PCT
DEC
10
6
External Layout Cost as Percentage of Total Cost
117
RTN_CST_CURR
CMS_RE_DTE_RTN_CST_CURR
WAERS
CUKY
5
0
Rationing cost currency
*
118
EXT_RTN_CST_CURR
CMS_RE_DTE_EXT_LAYOUT_CST_CURR
WAERS
CUKY
5
0
External Layout cost currency
*
119
RTN_CST_COM
CMS_RE_DTE_RAT_COST_AMT_COM
CMS_RE_AMOUNT
CURR
17
2
Commercial Rationing Cost
120
RTN_CST_COM_CURR
CMS_RE_DTE_RTN_CST_CURR_COM
WAERS
CUKY
5
0
Rationing cost currency
*
121
RTN_CST_COM_PCT
CMS_RE_DTE_RAN_COST_PCT_COM
CMS_RE_PCT
DEC
10
6
Percentage of Commercial Rationing Cost
122
.INCLUDE
0
0
Other rents
123
GROSS_COLD_RENT
CMS_RE_DTE_YRLY_GROSS_COLD_REN
CMS_RE_AMOUNT
CURR
17
2
Gross Cold Rent
124
GROSS_RENT_CURR
CMS_RE_DTE_GROSS_RENT_CURR
WAERS
CUKY
5
0
Gross Cold Rent Currency
TCURC
125
NET_COLD_RENT
CMS_RE_DTE_YRLY_NET_COLD_REN
CMS_RE_AMOUNT
CURR
17
2
Net Cold Rent
126
NET_RENT_CURR
CMS_RE_DTE_NET_RENT_CURR
WAERS
CUKY
5
0
Net Cold Rent Currency
TCURC
127
.INCLUDE
0
0
Structure for history
128
CREATED_BY
CMS_RE_DTE_CR_BY
CMS_RE_USER
CHAR
12
0
Real Estate Add-On User
129
CREATED_DATE
CMS_RE_DTE_CR_ON
CMS_RE_DATE
DATS
8
0
Created On
130
CREATED_TIME
CMS_RE_DTE_CR_AT
CMS_RE_TIME
TIMS
6
0
Created At
131
ENTRY_SRC
CMS_RE_DTE_SRC_INIT
CMS_RE_SOURCE
CHAR
32
0
Sorce of Initial entry
132
LAST_CHG_BY
CMS_RE_DTE_CHG_BY
CMS_RE_USER
CHAR
12
0
Last Changed By
133
LAST_CHG_DATE
CMS_RE_DTE_CHG_ON
CMS_RE_DATE
DATS
8
0
Last Changed On
134
LAST_CHG_TIME
CMS_RE_DTE_CHG_AT
CMS_RE_TIME
TIMS
6
0
Last Changed At
135
PROCESSING_SRC
CMS_RE_DTE_PRC_SRC
CMS_RE_SOURCE
CHAR
32
0
Processing Source
136
.INCLUDE
0
0
137
.INCLUDE
0
0
Valuation Bases(Com)
138
NO_OF_YEARS_COM
CMS_RE_DTE_VAL_NO_YEARS_COM
CMS_RE_INT1
INT1
3
0
No of years since Last Valuation of Commercial Real Estate
139
INT_RATE_COM
CMS_RE_DTE_VAL_INT_RATE_COM
CMS_RE_PCT
DEC
10
6
Interest rate (Com)
140
.INCLUDE
0
0
Valuation Bases
141
NO_OF_YEARS
CMS_RE_DTE_VALUATION_NO_YEARS
CMS_RE_INT1
INT1
3
0
No. of Years since Real Estate was last Valued
142
INT_RATE
CMS_RE_DTE_VALUATION_INT_RATE
CMS_RE_PCT
DEC
10
6
Interest rate used in Valuation of Residential Real Estate
143
.INCLUDE
0
0
Structure for Part Rent Details
144
RENT_PLANNED_COM
CMS_RE_DTE_RENT_AMOUNT
CMS_RE_AMOUNT
CURR
17
2
Planned Rent Amount
145
RENT_ACTUAL_COM
CMS_RE_DTE_RENT_AMOUNT_ACT
CMS_RE_AMOUNT
CURR
17
2
Actual Rent Amount
146
PLAN_CURR_COM
CMS_RE_DTE_RENT_PLANNED_CURR
WAERS
CUKY
5
0
Planned Rent Currency
TCURC
147
ACT_CURR_COM
CMS_RE_DTE_RENT_ACTUAL_CURR
WAERS
CUKY
5
0
Actual Rent Currency
TCURC
148
BASE_PERIOD_COM
CMS_RE_DTE_BASE_PERIOD
CMS_RE_BASE_PERIOD
CHAR
1
0
Base period for the rent
149
BASE_MEAS_COM
CMS_RE_DTE_BASE_MEAS
CMS_RE_BASE_MEAS
CHAR
1
0
Base Measure
150
COM_RENT_IND
CMS_RE_DTE_COM_IND
CMS_RE_RENT_FLG
CHAR
1
0
Indicator for Rent Type
151
COMP_RENT_COM
CMS_RE_DTE_RENT_LEVEL_COM
CMS_RE_AMOUNT
CURR
17
2
Comparative Rent (Commercial)
152
COMP_REN_COM_CUR
CMS_RE_DTE_COMP_RENT_COM_CURR
WAERS
CUKY
5
0
Comparative Rent Currency (Commercial)
TCURC
153
.INCLUDE
0
0
Building Construction Progress
154
LAST_REPORT_DATE
CMS_RE_DTE_LAST_CONST_REP_DATE
CMS_RE_DATE
DATS
8
0
Date of Last Constuction Report
155
BLD_PROGRESS_AMT
CMS_RE_DTE_AMT_BLD_PROGRESS
CMS_RE_AMOUNT
CURR
17
2
Amount Disbursed for Construction based on Building Progress
156
BLD_AMT_CURR
CMS_RE_DTE_BLD_PROGRESS_CURR
WAERS
CUKY
5
0
Building Progress Amount Curreny
*
157
PCT_COMPLETED
CMS_RE_DTE_DEGREE_COMPLETE
CMS_RE_PCT
DEC
10
6
Degree of Completion of Construction
158
.INCLUDE
0
0
Structure for Land Rent details
159
PLAN_RENT_LAND
CMS_RE_DTE_RENT_AMOUNT
CMS_RE_AMOUNT
CURR
17
2
Planned Rent Amount
160
ACTUAL_RENT_LAND
CMS_RE_DTE_RENT_AMOUNT_ACT
CMS_RE_AMOUNT
CURR
17
2
Actual Rent Amount
161
PLAN_RENT_CURR
CMS_RE_DTE_RENT_PLANNED_CURR
WAERS
CUKY
5
0
Planned Rent Currency
TCURC
162
ACTUAL_RENT_CURR
CMS_RE_DTE_RENT_ACTUAL_CURR
WAERS
CUKY
5
0
Actual Rent Currency
*
163
BASE_PERIOD_LAND
CMS_RE_DTE_BASE_PERIOD
CMS_RE_BASE_PERIOD
CHAR
1
0
Base period for the rent
164
BASE_MEAS_LAND
CMS_RE_DTE_BASE_MEAS
CMS_RE_BASE_MEAS
CHAR
1
0
Base Measure
165
.INCLUDE
0
0
Depriciation
166
DEPR
CMS_RE_DTE_DEPR
CMS_RE_PCT
DEC
10
6
Depriciation
167
.INCLUDE
0
0
Land Costs
168
LAND_COST
CMS_RE_DTE_LAND_COST
CMS_RE_AMOUNT
CURR
17
2
Land Cost Amount
169
LAND_COST_CURR
CMS_RE_DTE_LAND_COST_CURR
WAERS
CUKY
5
0
Land Cost Currency
*
170
DEV_COST
CMS_RE_DTE_DEV_COST
CMS_RE_AMOUNT
CURR
17
2
Development Cost Amount
171
DEV_COST_CURR
CMS_RE_DTE_DEV_COST_CURR
WAERS
CUKY
5
0
Dev Cost Currency
*
172
LAND_CST_BASE
CMS_RE_DTE_BASE_MEAS_LAND
CMS_RE_BASE_MEAS_LAND
CHAR
1
0
Base measure of Land
173
DEV_CST_BASE
CMS_RE_DTE_BASE_MEAS_LAND
CMS_RE_BASE_MEAS_LAND
CHAR
1
0
Base measure of Land
174
ADD_LAND_CST
CMS_RE_DTE_ADD_LAND_COST
CMS_RE_AMOUNT
CURR
17
2
Additional Land Cost Amount
175
ADD_CST_CURR
CMS_RE_DTE_ADD_LAND_COST_CURR
WAERS
CUKY
5
0
Additional Land Cost Currency
*
176
ADD_CST_BASE
CMS_RE_DTE_BASE_MEAS_LAND
CMS_RE_BASE_MEAS_LAND
CHAR
1
0
Base measure of Land
177
.INCLUDE
0
0
Construction Costs for Buildings
178
CONST_COST
CMS_RE_DTE_CONS_COST
CMS_RE_AMOUNT
CURR
17
2
Construction Cost
179
CONST_COST_CURR
CMS_RE_DTE_CONS_COST_CURR
WAERS
CUKY
5
0
Construction cost currency
*
180
BASE_MEAS
CMS_RE_DTE_BASE_MEAS
CMS_RE_BASE_MEAS
CHAR
1
0
Base Measure
181
.INCLUDE
0
0
Yearly Gross Profit for Commercial Real Estate
182
GRS_PROFIT
CMS_RE_DTE_GRS_PROFIT
CMS_RE_AMOUNT
CURR
17
2
Yearly Gross Profit
183
GRS_PROFIT_CURR
CMS_RE_DTE_GRS_PROFIT_CURR
WAERS
CUKY
5
0
Yearly Gross Profit Currency
*
184
.INCLUDE
0
0
AST PKy and Type and Parent GUID
185
AST_GUID
CMS_DTE_AST_GUID
SYSUUID
RAW
16
0
GUID for Table CMS_AST
186
AST_TYP
CMS_DTE_AST_TYP
CMS_AST_TYP
CHAR
6
0
Asset Type
*
187
PARENT_GUID
CMS_DTE_SAS_PAR_GUID
SYSUUID
RAW
16
0
Asset Guid as a parent GUID for a sub-asset
188
.INCLUDE
0
0
Structure with Asset Details
189
.INCLUDE
0
0
Basic Asset data
190
RISK_CODE
CMS_RE_DTE_RISK_CODE
CMS_RISK_CODE
CHAR
6
0
Risk Code
*
191
SFTY_IND
CMS_RE_DTE_IND_SFTY_DISC
CMS_IND_SFTY
CHAR
2
0
Indicates that the asset has a default sfty discount or not
192
SFTY_DSCNT
CMS_RE_DTE_SAFETY_DSCNT
CMS_SFTY_PCT
DEC
10
6
Safety discount
193
SFTY_AMOUNT
CMS_RE_DTE_SAFETY_AMT
CMS_AMOUNT
CURR
17
2
Safety discount as an amount
194
SFTY_AMT_CURR
CMS_RE_DTE_SAFETY_AMT_CURR
WAERS
CUKY
5
0
Currency of the Safety discount amount
TCURC
195
.INCLUDE
0
0
Valuation data
196
VALUATION_TYP
CMS_RE_DTE_IND_VALN_TYP
CMS_VALN_TYP
CHAR
2
0
Type of Check conducted on the object
197
UNIT_VALN_FREQ
CMS_RE_DTE_IND_FREQUENCY
CMS_RE_IND_FREQUENCY
CHAR
2
0
Indicator : Valuation Period
198
PERIOD_VALN_FREQ
CMS_RE_DTE_VALN_FREQ_PERIOD
CMS_RE_VALN_FREQ_PERIOD
NUMC
4
0
Period of revaluation for a real estate
199
PAST_VALUED_DATE
CMS_RE_DTE_VALN_DATE
CMS_DATE
DATS
8
0
Most Recent Date on which the Real Estate was last Valued
200
START_DATE
CMS_RE_DTE_START_DATE
CMS_DATE
DATS
8
0
Revaluation Start date
201
END_DATE
CMS_RE_DTE_END_DATE
CMS_DATE
DATS
8
0
End date for Revaluation of the Real Estate
202
.INCLUDE
0
0
Lending rate data
203
LENDING_RATE_IND
CMS_RE_DTE_IND_LND_RTE
CMS_IND_LRTE
CHAR
2
0
Indicates that the asset has a default lending rate or not
204
.INCLUDE
0
0
Lending rates
205
LENDING_RATE1
CMS_RE_DTE_LRTE_PCT1
CMS_PCT
DEC
10
6
Lending rate 1
206
LENDING_RATE2
CMS_RE_DTE_LRTE_PCT2
CMS_PCT
DEC
10
6
Lending rate 2
207
LENDING_RATE3
CMS_RE_DTE_LRTE_PCT3
CMS_PCT
DEC
10
6
Lending rate 3
208
LENDING_RATE4
CMS_RE_DTE_LRTE_PCT4
CMS_PCT
DEC
10
6
Lending rate 4
209
LENDING_RATE5
CMS_RE_DTE_LRTE_PCT5
CMS_PCT
DEC
10
6
Lending rate 5
210
.INCLUDE
0
0
Account for liquidation proceeds
211
ACC_NUMBER_LIQ
CMS_DTE_LIQ_ACC_NUMBER
BANKN35
CHAR
35
0
Account number for liquidation proceeds
212
BANK_CNTRY_LIQ
CMS_DTE_LIQ_BNK_CTRY_KY
LAND1
CHAR
3
0
Bank country key
T005
213
BANK_KEY_LIQ
CMS_DTE_LIQ_BNK_KEY
BANKK
CHAR
15
0
Bank Key
214
BANK_CTRLKEY_LIQ
BKONT
BKONT
CHAR
2
0
Bank Control Key
215
.INCLUDE
0
0
Verfication Data
216
UNIT_VERF_FREQ
CMS_DTE_IND_AST_VERF_FREQ_UNIT
CMS_IND_AST_VERF_FREQ_UNIT
CHAR
2
0
Indicator: Units of time for verification of an asset
217
PERIOD_VERF_FREQ
CMS_DTE_AST_VERF_FREQ_PERIOD
CMS_AST_VERF_FREQ_PERIOD
NUMC
4
0
Statement Period for an Asset
218
LAST_VERF_DATE
CMS_DTE_AST_VERF_DATE
CMS_DATE
DATS
8
0
Last Verification Date
219
.INCLUDE
0
0
Liquidation Data
220
LIQD_TYP
CMS_DTE_LIQD_TYP
CMS_TYP
CHAR
6
0
Liquidation Type
221
LIQD_REASON
CMS_DTE_ATT_ID_TY_AST004
CMS_ATT_ID_TYP
CHAR
6
0
Liquidation Reason
TCMS_ATT_ID_TY
222
LIQD_DATE
CMS_DTE_LIQD_DATE
CMS_DATE
DATS
8
0
Date on which the Collateral was Liquidated
223
LIQD_AMT
CMS_DTE_LIQD_VALUE
CMS_AMOUNT
CURR
17
2
Returns from the Liquidation of Collateral
224
LIQD_CURR
CMS_DTE_LIQD_CURR
WAERS
CUKY
5
0
Currency of Liquidation Value
TCURC
225
EXP_PRCD_AMNT
CMS_DTE_LIQ_EXP_PRCD_AMOUNT
CMS_AMOUNT
CURR
17
2
Expected Proceed Amount
226
EXP_PRCD_CURR
CMS_DTE_LIQ_EXP_PRCD_CURR
WAERS
CUKY
5
0
Currency: Expected Proceed
TCURC
227
EXP_ACC_DATE
CMS_DTE_LIQ_EXP_ACCRUAL_DATE
CMS_DATE
DATS
8
0
Expected accrual date
228
.INCLUDE
0
0
Structure for Asset values
229
.INCLUDE
0
0
Structure for Asset values
230
NOM_VALUE
CMS_DTE_AST_NOMINAL_VALUE
CMS_AMOUNT
CURR
17
2
Nominal Value of the Asset
231
NOM_VALUE_CURR
CMS_DTE_AST_NOMINAL_VALUE_CURR
WAERS
CUKY
5
0
Currency of Nominal value
TCURC
232
AST_VALUE
CMS_DTE_AST_VALUE
CMS_AMOUNT
CURR
17
2
Final Asset Value
233
AST_VALUE_CURR
CMS_DTE_AST_VALUE_CURR
WAERS
CUKY
5
0
Currency of the Final Asset Value
TCURC
234
QUANTITY
CMS_DTE_QTY
CMS_QTY
QUAN
13
3
Quantity
235
UNIT_OF_MEASURE
CMS_DTE_UNIT
MEINS
UNIT
3
0
Unit of Measure of Quantity
T006
236
REC_AT
CMS_DTE_REC_AT
TZNTSTMPS
DEC
15
0
Asset Value Recording Timestamp
237
.INCLUDE
0
0
Purchase price data
238
PUR_PRICE
CMS_DTE_AST_PURCHASE_PRICE
CMS_AMOUNT
CURR
17
2
Purchase Price of the Asset
239
PUR_PRICE_CURR
CMS_DTE_AST_PUR_PRICE_CURR
WAERS
CUKY
5
0
Currency of Purchase Price
TCURC
240
PUR_DATE
CMS_DTE_AST_PUR_PRICE_DATE
CMS_DATE
DATS
8
0
Date of Purchase
241
.INCLUDE
0
0
Organization unit structure
242
ORG_UNIT1
CMS_DTE_ORG_UNIT1
CMS_ORG_UNIT
CHAR
10
0
Organizational Unit 1
*
243
ORG_UNIT2
CMS_DTE_ORG_UNIT2
CMS_ORG_UNIT
CHAR
10
0
Organizational Unit 2
*
244
ORG_UNIT3
CMS_DTE_ORG_UNIT3
CMS_ORG_UNIT
CHAR
10
0
Organizational Unit 3
*
245
ORG_UNIT4
CMS_DTE_ORG_UNIT4
CMS_ORG_UNIT
CHAR
10
0
Organizational Unit 4
*
246
ORG_UNIT5
CMS_DTE_ORG_UNIT5
CMS_ORG_UNIT
CHAR
10
0
Organizational Unit 5
*