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