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 Part ID
6
PART_ID
CMS_RE_DTE_PART_ID
CMS_RE_PRT_ID
NUMC
10
0
Part ID for the Object
7
.INCLUDE
0
0
Structure for Basic Part Details
8
BLD_PART_TYPE
CMS_RE_DTE_ATT_ID_TY_REO006
CMS_ATT_ID_TYP
CHAR
6
0
Building Part Type
TCMS_ATT_ID_TY
9
PART_COND
CMS_RE_DTE_ATT_ID_TY_REO001
CMS_ATT_ID_TYP
CHAR
6
0
Object condition
TCMS_ATT_ID_TY
10
MAIN_USAGE
CMS_RE_DTE_USG_TYP
CMS_RE_TYP
CHAR
6
0
Usage Type
TCMS_RE_U_TYP
11
ADD_USAGE_1
CMS_RE_DTE_ADD1_USG_TYP
CMS_RE_TYP
CHAR
6
0
Additional Usage 1
TCMS_RE_U_TYP
12
ADD_USAGE_2
CMS_RE_DTE_ADD2_USG_TYP
CMS_RE_TYP
CHAR
6
0
Additional Usage 2
TCMS_RE_U_TYP
13
BLD_METHOD_ROOF
CMS_RE_DTE_ATT_ID_TY_REO007
CMS_ATT_ID_TYP
CHAR
6
0
Building method - Roof
TCMS_ATT_ID_TY
14
BLD_METHOD_BODY
CMS_RE_DTE_ATT_ID_TY_REO008
CMS_ATT_ID_TYP
CHAR
6
0
Building method - Body
TCMS_ATT_ID_TY
15
BLD_METD_CELLAR
CMS_RE_DTE_ATT_ID_TY_REO009
CMS_ATT_ID_TYP
CHAR
6
0
Building method - Cellar
TCMS_ATT_ID_TY
16
UTILIZATION
CMS_RE_DTE_PRT_UTILIZATION
CMS_RE_UTIL
CHAR
6
0
Utilization of the Object
17
PART_DESC
CMS_RE_DTE_SPC_DESC
CMS_RE_DESC
CHAR
30
0
Description of Building Part
18
COMM_USAGE_PCT
CMS_RE_DTE_COM_USE_PCT
CMS_RE_PCT
DEC
10
6
Commercial Usage as a Percentage of Total Usage
19
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
20
REF_OBJ_PRT_GUID
CMS_RE_DTE_REF_OBJ_PRT_GUID
SYSUUID
RAW
16
0
Reference Object Part GUID
21
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
22
.INCLUDE
0
0
Structure for Part Size Details
23
USEFUL_AREA
CMS_RE_DTE_AREA_USEFUL
CMS_RE_SIZE
QUAN
13
3
Usable Area
24
USBL_AREA_UOM
CMS_RE_DTE_USBL_AREA_UOM
MEINS
UNIT
3
0
Unit of Measure for Usable Area
*
25
USEFUL_AREA_REN
CMS_RE_DTE_AREA_USEFUL_REN
CMS_RE_SIZE
QUAN
13
3
Rented Usable Area
26
USBL_AR_REN_UOM
CMS_RE_DTE_USBL_AREA_REN_UOM
MEINS
UNIT
3
0
Unit of Measure for Usable Rented Area
*
27
USEFUL_VOL
CMS_RE_DTE_VOL_USEFUL
CMS_RE_SIZE
QUAN
13
3
Usable Volume of Real Estate Building Parts
28
USBL_VOL_UOM
CMS_RE_DTE_USBL_VOL_UOM
MEINS
UNIT
3
0
Unit of Measure for Usable Volume of Real Estate
*
29
USEFUL_VOL_REN
CMS_RE_DTE_VOL_USEFUL_REN
CMS_RE_SIZE
QUAN
13
3
Usable Volume of the Rented Portions of Real Estate
30
USBL_VL_REN_UOM
CMS_RE_DTE_USBL_VOL_REN_UOM
MEINS
UNIT
3
0
Unit of measure for usable volume of Rented Parts
*
31
RESIDENTIAL_AREA
CMS_RE_DTE_AREA_RESIDENTIAL
CMS_RE_SIZE
QUAN
13
3
Residential Area
32
RES_AR_UOM
CMS_RE_DTE_RES_AREA_UOM
MEINS
UNIT
3
0
Unit of Measure for Residential Area
*
33
SECONDARY_AREA
CMS_RE_DTE_AREA_SECONDARY
CMS_RE_SIZE
QUAN
13
3
Secondary Area
34
SEC_AREA_UOM
CMS_RE_DTE_SEC_AREA_UOM
MEINS
UNIT
3
0
Unit of Measure for Secondary Area
*
35
OTHER_AREA
CMS_RE_DTE_AREA_OTHER
CMS_RE_SIZE
QUAN
13
3
Other Area
36
OTH_AREA_UOM
CMS_RE_DTE_OTH_AREA_UOM
MEINS
UNIT
3
0
Unit of Measure for Other Area
*
37
.INCLUDE
0
0
Structure for Part Unit Details
38
NO_PRT_UNIT
CMS_RE_DTE_NO_PRT_UNIT
CMS_RE_UNITS
INT4
10
0
Number of building part units
39
NO_PRT_UNIT_REN
CMS_RE_DTE_NO_PRT_UNIT_REN
CMS_RE_UNITS
INT4
10
0
Number of building part units rented
40
.INCLUDE
0
0
Structure for dates
41
CONS_START_DATE
CMS_RE_DTE_OBJ_CONS_ST_DATE
CMS_RE_DATE
DATS
8
0
Start Date of Construction
42
PERMSN_APPL_DATE
CMS_RE_DTE_OBJ_PMSN_APPL_DATE
CMS_RE_DATE
DATS
8
0
Building Permssion applied date
43
PERMSN_OBTD_DATE
CMS_RE_DTE_OBJ_PMSN_OBTD_DATE
CMS_RE_DATE
DATS
8
0
Building Permssion obtained date
44
OCCY_DATE
CMS_RE_DTE_OBJ_OCCY_DATE
CMS_RE_DATE
DATS
8
0
Occupancy Date
45
COMP_DATE
CMS_RE_DTE_OBJ_COMP_DATE
CMS_RE_DATE
DATS
8
0
Completion Date
46
FINAL_INSP_DATE
CMS_RE_DTE_OBJ_FINAL_INSP_DATE
CMS_RE_DATE
DATS
8
0
Date of Final Inspection
47
.INCLUDE
0
0
48
.INCLUDE
0
0
Structure for Part Rent Details
49
RENT_AMT_PLANNED
CMS_RE_DTE_RENT_AMOUNT
CMS_RE_AMOUNT
CURR
17
2
Planned Rent Amount
50
RENT_AMT_ACTUAL
CMS_RE_DTE_RENT_AMOUNT_ACT
CMS_RE_AMOUNT
CURR
17
2
Actual Rent Amount
51
RENT_PLAN_CURR
CMS_RE_DTE_RENT_PLANNED_CURR
WAERS
CUKY
5
0
Planned Rent Currency
TCURC
52
RENT_ACT_CURR
CMS_RE_DTE_RENT_ACTUAL_CURR
WAERS
CUKY
5
0
Actual Rent Currency
TCURC
53
BASE_PERIOD
CMS_RE_DTE_BASE_PERIOD
CMS_RE_BASE_PERIOD
CHAR
1
0
Base period for the rent
54
BASE_MEASURE
CMS_RE_DTE_BASE_MEAS
CMS_RE_BASE_MEAS
CHAR
1
0
Base Measure
55
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
56
RES_RENT_IND
CMS_RE_DTE_RES_IND
CMS_RE_RENT_FLG
CHAR
1
0
Indicator for Net or Gross Rent
57
COMP_RENT_RES
CMS_RE_DTE_RENT_LEVEL
CMS_RE_AMOUNT
CURR
17
2
Comparative Rent (Residential)
58
COM_REN_RES_CURR
CMS_RE_DTE_COMP_RENT_RES_CURR
WAERS
CUKY
5
0
Comparative Rent Currency - Residential
TCURC
59
.INCLUDE
0
0
Structure for Land Area & UOM
60
LAND_AREA
CMS_RE_DTE_LAND_AREA
CMS_RE_SIZE
QUAN
13
3
Land Area of the Real Estate
61
LAND_AREA_UOM
CMS_RE_DTE_LAND_AREA_UOM
MEINS
UNIT
3
0
Unit of Measure of Land Area
T006
62
LAND_AREA_REN
CMS_RE_DTE_LAND_AREA_REN
CMS_RE_SIZE
QUAN
13
3
Land Area of the Real Estate which is Rented
63
LAND_AR_REN_UOM
CMS_RE_DTE_LAND_AREA_REN_UOM
MEINS
UNIT
3
0
Land area unit of measure(rented)
*
64
.INCLUDE
0
0
Structure for General Details
65
NO_OF_UNITS
CMS_RE_DTE_NO_UNIT
CMS_RE_UNITS
INT4
10
0
No of units in real estate object
66
NO_OF_FLOORS
CMS_RE_DTE_NO_FLOOR
CMS_RE_UNITS
INT4
10
0
Number of Floors
67
NO_GARAGES
CMS_RE_DTE_NO_GAR
CMS_RE_UNITS
INT4
10
0
No of Garages in Real Estate Object
68
NO_GARAGES_REN
CMS_RE_DTE_NO_GAR_REN
CMS_RE_UNITS
INT4
10
0
No of Garages Rented in Real Estate Object
69
NO_PARK_UNIT
CMS_RE_DTE_NO_PARK_UNIT
CMS_RE_UNITS
INT4
10
0
Number of Parking Units
70
NO_PARK_UNIT_REN
CMS_RE_DTE_NO_PARK_UNIT_REN
CMS_RE_UNITS
INT4
10
0
Number of Parking Units Rented
71
NO_PARK_UG
CMS_RE_DTE_NO_PARK_UNIT_UG
CMS_RE_UNITS
INT4
10
0
Number of Underground Parking Units
72
NO_PARK_UG_REN
CMS_RE_DTE_NO_PARK_UNIT_UG_REN
CMS_RE_UNITS
INT4
10
0
Number of Rented Underground Parking Units
73
.INCLUDE
0
0
Structure for Residential Details
74
NO_CUR_UNITS
CMS_RE_DTE_NO_CUR_UNIT
CMS_RE_UNITS
INT4
10
0
No of current units in real estate object
75
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
76
NO_OLD_UNITS
CMS_RE_DTE_NO_OLD_UNIT
CMS_RE_UNITS
INT4
10
0
No of old units in real estate object
77
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
78
NO_NEW_UNITS
CMS_RE_DTE_NO_NEW_UNIT
CMS_RE_UNITS
INT4
10
0
No of new units in real estate object
79
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
80
.INCLUDE
0
0
Structure for Number of Units in Office
81
NO_ACCESS_STR
CMS_RE_DTE_NO_ACCESS_STR
CMS_RE_UNITS
INT4
10
0
No of Access Structures
82
.INCLUDE
0
0
Structure for Number of Sales level in Commericial Building
83
NO_SALE_LEVEL
CMS_RE_DTE_NO_SALE_LEVEL
CMS_RE_UNITS
INT4
10
0
No of Sale levels in commercial building
84
.INCLUDE
0
0
Structure for Number of Rooms in the hotel/clinic
85
NO_OF_ROOMS
CMS_RE_DTE_NO_ROOMS
CMS_RE_UNITS
INT4
10
0
No of rooms in the hotel/clinic
86
.INCLUDE
0
0
Structure for Number of rooms in the clinic/nursing home
87
NO_OF_BEDS
CMS_RE_DTE_NO_BEDS
CMS_RE_UNITS
INT4
10
0
No of beds in the clinic/nursing home
88
.INCLUDE
0
0
89
.INCLUDE
0
0
Structure for Commericial Details
90
COMM_ENV_DESC
CMS_RE_DTE_COMM_ENV_DESC
CMS_RE_DESC
CHAR
30
0
Description of the commercial environment
91
ACCESS_STR_DESC
CMS_RE_DTE_ACCESS_STR_DESC
CMS_RE_DESC
CHAR
30
0
Description of the Access Structures
92
BLD_SECTION_DESC
CMS_RE_DTE_ATT_ID_TY_REO015
CMS_ATT_ID_TYP
CHAR
6
0
Building Section
TCMS_ATT_ID_TY
93
.INCLUDE
0
0
94
.INCLUDE
0
0
Structure for Hotel Details
95
PRICE_CATEGORY
CMS_RE_DTE_ATT_ID_TY_REO013
CMS_ATT_ID_TYP
CHAR
6
0
Price Category
TCMS_ATT_ID_TY
96
AVG_PRICE
CMS_RE_DTE_AVG_PRICE
CMS_RE_AMOUNT
CURR
17
2
Average Price per Day
97
AVG_PRICE_CURR
CMS_RE_DTE_AVG_PRICE_CURR
WAERS
CUKY
5
0
Average Price Currency
TCURC
98
.INCLUDE
0
0
99
.INCLUDE
0
0
Structure for Other Details in RE Object
100
OCCUPANCY_PCT
CMS_RE_DTE_OCCY_PCT
CMS_RE_PCT
DEC
10
6
Occupancy specified in Percentage Terms
101
TURNOVER_AMT
CMS_RE_DTE_TURNOVER_AMOUNT
CMS_RE_AMOUNT
CURR
17
2
Total Amount of Turnover
102
TURNOVER_CURR
CMS_RE_DTE_TURNOVER_CURR
WAERS
CUKY
5
0
Currency
TCURC
103
RENTAL_AGMT_TYP
CMS_RE_DTE_ATT_ID_TY_REO014
CMS_ATT_ID_TYP
CHAR
6
0
Rental Agreement Type
TCMS_ATT_ID_TY
104
.INCLUDE
0
0
Insurance details
105
INSURANCE_TYPE
CMS_RE_DTE_ATT_ID_TY_REO011
CMS_ATT_ID_TYP
CHAR
6
0
Insurance Type
TCMS_ATT_ID_TY
106
INSURANCE_AMT
CMS_RE_DTE_INSURANCE_AMOUNT
CMS_RE_AMOUNT
CURR
17
2
Insurance Amount
107
INSURANCE_CURR
CMS_RE_DTE_INSURANCE_CURR
WAERS
CUKY
5
0
Insurance Currency
TCURC
108
INS_VALIDITY
CMS_RE_DTE_INS_VALID_TILL
CMS_RE_DATE
DATS
8
0
Date until which the Insurance Stands Valid
109
.INCLUDE
0
0
Other Costs
110
RATIONING_COST
CMS_RE_DTE_RAT_COST_AMT
CMS_RE_AMOUNT
CURR
17
2
Residential Rationing Cost
111
RTN_CST_PCT
CMS_RE_DTE_RAN_COST_PCT
CMS_RE_PCT
DEC
10
6
Percentage of Residential Rationing Cost
112
EXT_LAYOUT_COST
CMS_RE_DTE_EXT_LAYOUT_COST
CMS_RE_AMOUNT
CURR
17
2
External Layout Cost
113
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
114
RTN_CST_CURR
CMS_RE_DTE_RTN_CST_CURR
WAERS
CUKY
5
0
Rationing cost currency
*
115
EXT_RTN_CST_CURR
CMS_RE_DTE_EXT_LAYOUT_CST_CURR
WAERS
CUKY
5
0
External Layout cost currency
*
116
RTN_CST_COM
CMS_RE_DTE_RAT_COST_AMT_COM
CMS_RE_AMOUNT
CURR
17
2
Commercial Rationing Cost
117
RTN_CST_COM_CURR
CMS_RE_DTE_RTN_CST_CURR_COM
WAERS
CUKY
5
0
Rationing cost currency
*
118
RTN_CST_COM_PCT
CMS_RE_DTE_RAN_COST_PCT_COM
CMS_RE_PCT
DEC
10
6
Percentage of Commercial Rationing Cost
119
.INCLUDE
0
0
Other rents
120
GROSS_COLD_RENT
CMS_RE_DTE_YRLY_GROSS_COLD_REN
CMS_RE_AMOUNT
CURR
17
2
Gross Cold Rent
121
GROSS_RENT_CURR
CMS_RE_DTE_GROSS_RENT_CURR
WAERS
CUKY
5
0
Gross Cold Rent Currency
TCURC
122
NET_COLD_RENT
CMS_RE_DTE_YRLY_NET_COLD_REN
CMS_RE_AMOUNT
CURR
17
2
Net Cold Rent
123
NET_RENT_CURR
CMS_RE_DTE_NET_RENT_CURR
WAERS
CUKY
5
0
Net Cold Rent Currency
TCURC
124
.INCLUDE
0
0
Structure for history
125
CREATED_BY
CMS_RE_DTE_CR_BY
CMS_RE_USER
CHAR
12
0
Real Estate Add-On User
126
CREATED_DATE
CMS_RE_DTE_CR_ON
CMS_RE_DATE
DATS
8
0
Created On
127
CREATED_TIME
CMS_RE_DTE_CR_AT
CMS_RE_TIME
TIMS
6
0
Created At
128
ENTRY_SRC
CMS_RE_DTE_SRC_INIT
CMS_RE_SOURCE
CHAR
32
0
Sorce of Initial entry
129
LAST_CHG_BY
CMS_RE_DTE_CHG_BY
CMS_RE_USER
CHAR
12
0
Last Changed By
130
LAST_CHG_DATE
CMS_RE_DTE_CHG_ON
CMS_RE_DATE
DATS
8
0
Last Changed On
131
LAST_CHG_TIME
CMS_RE_DTE_CHG_AT
CMS_RE_TIME
TIMS
6
0
Last Changed At
132
PROCESSING_SRC
CMS_RE_DTE_PRC_SRC
CMS_RE_SOURCE
CHAR
32
0
Processing Source
133
.INCLUDE
0
0
134
.INCLUDE
0
0
Building Construction Progress
135
LAST_REPORT_DATE
CMS_RE_DTE_LAST_CONST_REP_DATE
CMS_RE_DATE
DATS
8
0
Date of Last Constuction Report
136
BLD_PROGRESS_AMT
CMS_RE_DTE_AMT_BLD_PROGRESS
CMS_RE_AMOUNT
CURR
17
2
Amount Disbursed for Construction based on Building Progress
137
BLD_AMT_CURR
CMS_RE_DTE_BLD_PROGRESS_CURR
WAERS
CUKY
5
0
Building Progress Amount Curreny
*
138
PCT_COMPLETED
CMS_RE_DTE_DEGREE_COMPLETE
CMS_RE_PCT
DEC
10
6
Degree of Completion of Construction
139
.INCLUDE
0
0
Valuation Bases(Com)
140
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
141
INT_RATE_COM
CMS_RE_DTE_VAL_INT_RATE_COM
CMS_RE_PCT
DEC
10
6
Interest rate (Com)
142
.INCLUDE
0
0
Valuation Bases
143
NO_OF_YEARS
CMS_RE_DTE_VALUATION_NO_YEARS
CMS_RE_INT1
INT1
3
0
No. of Years since Real Estate was last Valued
144
INT_RATE
CMS_RE_DTE_VALUATION_INT_RATE
CMS_RE_PCT
DEC
10
6
Interest rate used in Valuation of Residential Real Estate
145
.INCLUDE
0
0
Structure for Part Rent Details
146
RENT_PLANNED_COM
CMS_RE_DTE_RENT_AMOUNT
CMS_RE_AMOUNT
CURR
17
2
Planned Rent Amount
147
RENT_ACTUAL_COM
CMS_RE_DTE_RENT_AMOUNT_ACT
CMS_RE_AMOUNT
CURR
17
2
Actual Rent Amount
148
PLAN_CURR_COM
CMS_RE_DTE_RENT_PLANNED_CURR
WAERS
CUKY
5
0
Planned Rent Currency
TCURC
149
ACT_CURR_COM
CMS_RE_DTE_RENT_ACTUAL_CURR
WAERS
CUKY
5
0
Actual Rent Currency
TCURC
150
BASE_PERIOD_COM
CMS_RE_DTE_BASE_PERIOD
CMS_RE_BASE_PERIOD
CHAR
1
0
Base period for the rent
151
BASE_MEAS_COM
CMS_RE_DTE_BASE_MEAS
CMS_RE_BASE_MEAS
CHAR
1
0
Base Measure
152
COM_RENT_IND
CMS_RE_DTE_COM_IND
CMS_RE_RENT_FLG
CHAR
1
0
Indicator for Rent Type
153
COMP_RENT_COM
CMS_RE_DTE_RENT_LEVEL_COM
CMS_RE_AMOUNT
CURR
17
2
Comparative Rent (Commercial)
154
COMP_REN_COM_CUR
CMS_RE_DTE_COMP_RENT_COM_CURR
WAERS
CUKY
5
0
Comparative Rent Currency (Commercial)
TCURC
155
.INCLUDE
0
0
Rental Summary
156
RES_AREA_REN
CMS_RE_DTE_RES_AREA_REN
CMS_RE_SIZE
QUAN
13
3
Total Residential Area rented
157
RES_AREA_UOM
CMS_RE_DTE_RES_AREA_REN_UOM
MEINS
UNIT
3
0
Unit of Measure for Rented Residential Area
*
158
COM_AREA_REN
CMS_RE_DTE_COM_AREA_REN
CMS_RE_SIZE
QUAN
13
3
Total Commercial Area Rented
159
COM_AREA_UOM
CMS_RE_DTE_COM_AREA_REN_UOM
MEINS
UNIT
3
0
Unit of Measure for Rented Commercial Area
*
160
RES_VOL_REN
CMS_RE_DTE_RES_VOL_REN
CMS_RE_SIZE
QUAN
13
3
Total Residential Volume Rented
161
RES_VOL_UOM
CMS_RE_DTE_RES_VOL_REN_UOM
MEINS
UNIT
3
0
Unit of Measure for Total Rented Residential Volume
*
162
COM_VOL_REN
CMS_RE_DTE_COM_VOL_REN
CMS_RE_SIZE
QUAN
13
3
Total Volume Rented for Commercial Use
163
COM_VOL_UOM
CMS_RE_DTE_COM_VOL_REN_UOM
MEINS
UNIT
3
0
Unit of Measure for Volume Rented for Commercial Use
*
164
RENTAL_INC_RES
CMS_RE_DTE_RENTAL_INC_RES
CMS_RE_AMOUNT
CURR
17
2
Total rental income - residential
165
INC_RES_CURR
CMS_RE_DTE_REN_INC_RES_CURRR
WAERS
CUKY
5
0
Currency for Residential Rental Income
*
166
RENTAL_INC_COM
CMS_RE_DTE_RENTAL_INC_COM
CMS_RE_AMOUNT
CURR
17
2
Total rental income - commercial
167
INC_COM_CURR
CMS_RE_DTE_REN_INC_COM_CURRR
WAERS
CUKY
5
0
Currency for Commercial Rental Income
*
168
RENTAL_INC_TOTAL
CMS_RE_DTE_RENTAL_INC_TOTAL
CMS_RE_AMOUNT
CURR
17
2
Total rental income
169
INC_TOTAL_CURR
CMS_RE_DTE_REN_INC_TOTAL_CURRR
WAERS
CUKY
5
0
Currency for Total Rental Income
*
170
INC_TOTAL_ENT
CMS_RE_DTE_ENTERED_VAL_AMOUNT
CMS_RE_AMOUNT
CURR
17
2
Entered Value
171
INC_ENT_CURR
CMS_RE_DTE_ENTERED_VAL_CURR
WAERS
CUKY
5
0
Entered value Currency
*
172
REN_VAL_DATE
CMS_RE_DTE_VAL_DATE
CMS_RE_DATE
DATS
8
0
Date on which Real Estate Valuation was Performed
173
NET_RES_INC
CMS_RE_DTE_NET_RENTAL_INC_RES
CMS_RE_AMOUNT
CURR
17
2
Net rental income - residential
174
NET_RES_INC_CURR
CMS_RE_DTE_NET_INC_RES_CURR
WAERS
CUKY
5
0
Currency for Residential Rental Income -Net
*
175
NET_COM_INC
CMS_RE_DTE_NET_RENTAL_INC_COM
CMS_RE_AMOUNT
CURR
17
2
Net rental income - commercial
176
NET_COM_INC_CURR
CMS_RE_DTE_NET_INC_COM_CURR
WAERS
CUKY
5
0
Currency for Commercial Rental Income -Net
*
177
NET_TOT_INC
CMS_RE_DTE_NET_RENT_INC_TOTAL
CMS_RE_AMOUNT
CURR
17
2
Net rental income
178
NET_TOT_INC_CURR
CMS_RE_DTE_NET_INC_TOTAL_CURR
WAERS
CUKY
5
0
Currency for Total Rental Income
*
179
REV_TOT_RES
CMS_RE_DTE_TOTAL_REVENUE_RES
CMS_RE_AMOUNT
CURR
17
2
Total revenue - residential
180
REV_TOT_RES_CURR
CMS_RE_DTE_TOTAL_REV_RES_CURR
WAERS
CUKY
5
0
Currency for Total Residential revenue
*
181
REV_TOT_COM
CMS_RE_DTE_TOTAL_REVENUE_COM
CMS_RE_AMOUNT
CURR
17
2
Total revenue - commercial
182
REV_TOT_COM_CURR
CMS_RE_DTE_TOTAL_REV_COM_CURR
WAERS
CUKY
5
0
Currency for Total commercial revenue
*
183
REVTOT_CALC
CMS_RE_DTE_TOTAL_REVENUE
CMS_RE_AMOUNT
CURR
17
2
Total revenue
184
REVTOT_CALC_CURR
CMS_RE_DTE_TOTAL_REV_CURR
WAERS
CUKY
5
0
Currency for Total revenue
*
185
REVTOT_ENT
CMS_RE_DTE_ENTERED_VAL_AMOUNT
CMS_RE_AMOUNT
CURR
17
2
Entered Value
186
REVTOT_ENT_CURR
CMS_RE_DTE_ENTERED_VAL_CURR
WAERS
CUKY
5
0
Entered value Currency
*
187
REVCALC_DATE
CMS_RE_DTE_VAL_DATE
CMS_RE_DATE
DATS
8
0
Date on which Real Estate Valuation was Performed
188
.INCLUDE
0
0
Object Land Value
189
LAND_VALUE
CMS_RE_DTE_LAND_VAL
CMS_RE_AMOUNT
CURR
17
2
Land Value
190
LAND_VALUE_CURR
CMS_RE_DTE_LAND_VAL_CURR
WAERS
CUKY
5
0
Land Value Currency
*
191
LAND_VALUE_ENT
CMS_RE_DTE_ENTERED_VAL_AMOUNT
CMS_RE_AMOUNT
CURR
17
2
Entered Value
192
VAL_ENT_CURR
CMS_RE_DTE_ENTERED_VAL_CURR
WAERS
CUKY
5
0
Entered value Currency
*
193
LAND_VAL_DATE
CMS_RE_DTE_VAL_DATE
CMS_RE_DATE
DATS
8
0
Date on which Real Estate Valuation was Performed
194
.INCLUDE
0
0
Structure for Land Rent details
195
PLAN_RENT_LAND
CMS_RE_DTE_RENT_AMOUNT
CMS_RE_AMOUNT
CURR
17
2
Planned Rent Amount
196
ACTUAL_RENT_LAND
CMS_RE_DTE_RENT_AMOUNT_ACT
CMS_RE_AMOUNT
CURR
17
2
Actual Rent Amount
197
PLAN_RENT_CURR
CMS_RE_DTE_RENT_PLANNED_CURR
WAERS
CUKY
5
0
Planned Rent Currency
TCURC
198
ACTUAL_RENT_CURR
CMS_RE_DTE_RENT_ACTUAL_CURR
WAERS
CUKY
5
0
Actual Rent Currency
*
199
BASE_PERIOD_LAND
CMS_RE_DTE_BASE_PERIOD
CMS_RE_BASE_PERIOD
CHAR
1
0
Base period for the rent
200
BASE_MEAS_LAND
CMS_RE_DTE_BASE_MEAS
CMS_RE_BASE_MEAS
CHAR
1
0
Base Measure
201
.INCLUDE
0
0
Depriciation
202
DEPR
CMS_RE_DTE_DEPR
CMS_RE_PCT
DEC
10
6
Depriciation
203
.INCLUDE
0
0
Object Building Value
204
BLD_VALUE_CALC
CMS_RE_DTE_BLD_VAL
CMS_RE_AMOUNT
CURR
17
2
Building Value
205
CALC_VALUE_CURR
CMS_RE_DTE_BLD_VAL_CURR
WAERS
CUKY
5
0
Building Value Currency
*
206
BLD_VALUE_ENT
CMS_RE_DTE_ENTERED_VAL_AMOUNT
CMS_RE_AMOUNT
CURR
17
2
Entered Value
207
ENT_VALUE_CURR
CMS_RE_DTE_ENTERED_VAL_CURR
WAERS
CUKY
5
0
Entered value Currency
*
208
BLD_VAL_DATE
CMS_RE_DTE_VAL_DATE
CMS_RE_DATE
DATS
8
0
Date on which Real Estate Valuation was Performed
209
.INCLUDE
0
0
Land Costs
210
LAND_COST
CMS_RE_DTE_LAND_COST
CMS_RE_AMOUNT
CURR
17
2
Land Cost Amount
211
LAND_COST_CURR
CMS_RE_DTE_LAND_COST_CURR
WAERS
CUKY
5
0
Land Cost Currency
*
212
DEV_COST
CMS_RE_DTE_DEV_COST
CMS_RE_AMOUNT
CURR
17
2
Development Cost Amount
213
DEV_COST_CURR
CMS_RE_DTE_DEV_COST_CURR
WAERS
CUKY
5
0
Dev Cost Currency
*
214
LAND_CST_BASE
CMS_RE_DTE_BASE_MEAS_LAND
CMS_RE_BASE_MEAS_LAND
CHAR
1
0
Base measure of Land
215
DEV_CST_BASE
CMS_RE_DTE_BASE_MEAS_LAND
CMS_RE_BASE_MEAS_LAND
CHAR
1
0
Base measure of Land
216
ADD_LAND_CST
CMS_RE_DTE_ADD_LAND_COST
CMS_RE_AMOUNT
CURR
17
2
Additional Land Cost Amount
217
ADD_CST_CURR
CMS_RE_DTE_ADD_LAND_COST_CURR
WAERS
CUKY
5
0
Additional Land Cost Currency
*
218
ADD_CST_BASE
CMS_RE_DTE_BASE_MEAS_LAND
CMS_RE_BASE_MEAS_LAND
CHAR
1
0
Base measure of Land
219
.INCLUDE
0
0
Construction Costs for Buildings
220
CONST_COST
CMS_RE_DTE_CONS_COST
CMS_RE_AMOUNT
CURR
17
2
Construction Cost
221
CONST_COST_CURR
CMS_RE_DTE_CONS_COST_CURR
WAERS
CUKY
5
0
Construction cost currency
*
222
BASE_MEAS
CMS_RE_DTE_BASE_MEAS
CMS_RE_BASE_MEAS
CHAR
1
0
Base Measure
223
.INCLUDE
0
0
Cost Depreciation Value
224
CST_DEP_CAL
CMS_RE_DTE_CST_DEP_VAL
CMS_RE_AMOUNT
CURR
17
2
Object Value Calculated using Cost Depreciation Method
225
CST_DEP_CAL_CURR
CMS_RE_DTE_CST_DEP_VAL_CURR
WAERS
CUKY
5
0
Object Value Currency - Cost Depreciation Method
*
226
CST_DEP_ENT
CMS_RE_DTE_ENTERED_VAL_AMOUNT
CMS_RE_AMOUNT
CURR
17
2
Entered Value
227
CST_DEP_ENT_CURR
CMS_RE_DTE_ENTERED_VAL_CURR
WAERS
CUKY
5
0
Entered value Currency
*
228
CST_DEP_DATE
CMS_RE_DTE_VAL_DATE
CMS_RE_DATE
DATS
8
0
Date on which Real Estate Valuation was Performed
229
.INCLUDE
0
0
Yearly Gross Profit for Commercial Real Estate
230
GRS_PROFIT
CMS_RE_DTE_GRS_PROFIT
CMS_RE_AMOUNT
CURR
17
2
Yearly Gross Profit
231
GRS_PROFIT_CURR
CMS_RE_DTE_GRS_PROFIT_CURR
WAERS
CUKY
5
0
Yearly Gross Profit Currency
*
232
.INCLUDE
0
0
Structure with Asset Details
233
.INCLUDE
0
0
Basic Asset data
234
RISK_CODE
CMS_RE_DTE_RISK_CODE
CMS_RISK_CODE
CHAR
6
0
Risk Code
TCMS_RISKCODE
235
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
236
SFTY_DSCNT
CMS_RE_DTE_SAFETY_DSCNT
CMS_SFTY_PCT
DEC
10
6
Safety discount
237
SFTY_AMOUNT
CMS_RE_DTE_SAFETY_AMT
CMS_AMOUNT
CURR
17
2
Safety discount as an amount
238
SFTY_AMT_CURR
CMS_RE_DTE_SAFETY_AMT_CURR
WAERS
CUKY
5
0
Currency of the Safety discount amount
TCURC
239
.INCLUDE
0
0
Valuation data
240
VALUATION_TYP
CMS_RE_DTE_IND_VALN_TYP
CMS_VALN_TYP
CHAR
2
0
Type of Check conducted on the object
241
UNIT_VALN_FREQ
CMS_RE_DTE_IND_FREQUENCY
CMS_RE_IND_FREQUENCY
CHAR
2
0
Indicator : Valuation Period
242
PERIOD_VALN_FREQ
CMS_RE_DTE_VALN_FREQ_PERIOD
CMS_RE_VALN_FREQ_PERIOD
NUMC
4
0
Period of revaluation for a real estate
243
PAST_VALUED_DATE
CMS_RE_DTE_VALN_DATE
CMS_DATE
DATS
8
0
Most Recent Date on which the Real Estate was last Valued
244
START_DATE
CMS_RE_DTE_START_DATE
CMS_DATE
DATS
8
0
Revaluation Start date
245
END_DATE
CMS_RE_DTE_END_DATE
CMS_DATE
DATS
8
0
End date for Revaluation of the Real Estate
246
.INCLUDE
0
0
Lending rate data
247
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
248
.INCLUDE
0
0
Lending rates
249
LENDING_RATE1
CMS_RE_DTE_LRTE_PCT1
CMS_PCT
DEC
10
6
Lending rate 1
250
LENDING_RATE2
CMS_RE_DTE_LRTE_PCT2
CMS_PCT
DEC
10
6
Lending rate 2
251
LENDING_RATE3
CMS_RE_DTE_LRTE_PCT3
CMS_PCT
DEC
10
6
Lending rate 3
252
LENDING_RATE4
CMS_RE_DTE_LRTE_PCT4
CMS_PCT
DEC
10
6
Lending rate 4
253
LENDING_RATE5
CMS_RE_DTE_LRTE_PCT5
CMS_PCT
DEC
10
6
Lending rate 5
254
.INCLUDE
0
0
Account for liquidation proceeds
255
ACC_NUMBER_LIQ
CMS_DTE_LIQ_ACC_NUMBER
BANKN35
CHAR
35
0
Account number for liquidation proceeds
256
BANK_CNTRY_LIQ
CMS_DTE_LIQ_BNK_CTRY_KY
LAND1
CHAR
3
0
Bank country key
T005
257
BANK_KEY_LIQ
CMS_DTE_LIQ_BNK_KEY
BANKK
CHAR
15
0
Bank Key
258
BANK_CTRLKEY_LIQ
BKONT
BKONT
CHAR
2
0
Bank Control Key
259
.INCLUDE
0
0
Verfication Data
260
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
261
PERIOD_VERF_FREQ
CMS_DTE_AST_VERF_FREQ_PERIOD
CMS_AST_VERF_FREQ_PERIOD
NUMC
4
0
Statement Period for an Asset
262
LAST_VERF_DATE
CMS_DTE_AST_VERF_DATE
CMS_DATE
DATS
8
0
Last Verification Date
263
.INCLUDE
0
0
Liquidation Data
264
LIQD_TYP
CMS_DTE_LIQD_TYP
CMS_TYP
CHAR
6
0
Liquidation Type
265
LIQD_REASON
CMS_DTE_ATT_ID_TY_AST004
CMS_ATT_ID_TYP
CHAR
6
0
Liquidation Reason
TCMS_ATT_ID_TY
266
LIQD_DATE
CMS_DTE_LIQD_DATE
CMS_DATE
DATS
8
0
Date on which the Collateral was Liquidated
267
LIQD_AMT
CMS_DTE_LIQD_VALUE
CMS_AMOUNT
CURR
17
2
Returns from the Liquidation of Collateral
268
LIQD_CURR
CMS_DTE_LIQD_CURR
WAERS
CUKY
5
0
Currency of Liquidation Value
TCURC
269
EXP_PRCD_AMNT
CMS_DTE_LIQ_EXP_PRCD_AMOUNT
CMS_AMOUNT
CURR
17
2
Expected Proceed Amount
270
EXP_PRCD_CURR
CMS_DTE_LIQ_EXP_PRCD_CURR
WAERS
CUKY
5
0
Currency: Expected Proceed
TCURC
271
EXP_ACC_DATE
CMS_DTE_LIQ_EXP_ACCRUAL_DATE
CMS_DATE
DATS
8
0
Expected accrual date
272
.INCLUDE
0
0
AST PKy and Type and Parent GUID
273
AST_GUID
CMS_DTE_AST_GUID
SYSUUID
RAW
16
0
GUID for Table CMS_AST
274
AST_TYP
CMS_DTE_AST_TYP
CMS_AST_TYP
CHAR
6
0
Asset Type
*
275
PARENT_GUID
CMS_DTE_SAS_PAR_GUID
SYSUUID
RAW
16
0
Asset Guid as a parent GUID for a sub-asset
276
.INCLUDE
0
0
Structure for Asset values
277
.INCLUDE
0
0
Structure for Asset values
278
NOM_VALUE
CMS_DTE_AST_NOMINAL_VALUE
CMS_AMOUNT
CURR
17
2
Nominal Value of the Asset
279
NOM_VALUE_CURR
CMS_DTE_AST_NOMINAL_VALUE_CURR
WAERS
CUKY
5
0
Currency of Nominal value
TCURC
280
AST_VALUE
CMS_DTE_AST_VALUE
CMS_AMOUNT
CURR
17
2
Final Asset Value
281
AST_VALUE_CURR
CMS_DTE_AST_VALUE_CURR
WAERS
CUKY
5
0
Currency of the Final Asset Value
TCURC
282
QUANTITY
CMS_DTE_QTY
CMS_QTY
QUAN
13
3
Quantity
283
UNIT_OF_MEASURE
CMS_DTE_UNIT
MEINS
UNIT
3
0
Unit of Measure of Quantity
T006
284
REC_AT
CMS_DTE_REC_AT
TZNTSTMPS
DEC
15
0
Asset Value Recording Timestamp
285
.INCLUDE
0
0
Purchase price data
286
PUR_PRICE
CMS_DTE_AST_PURCHASE_PRICE
CMS_AMOUNT
CURR
17
2
Purchase Price of the Asset
287
PUR_PRICE_CURR
CMS_DTE_AST_PUR_PRICE_CURR
WAERS
CUKY
5
0
Currency of Purchase Price
TCURC
288
PUR_DATE
CMS_DTE_AST_PUR_PRICE_DATE
CMS_DATE
DATS
8
0
Date of Purchase
289
.INCLUDE
0
0
Bank name
290
BANK_NAME
BANKA
TEXT60
CHAR
60
0
Name of bank
291
.INCLUDE
0
0
Organization unit structure
292
ORG_UNIT1
CMS_DTE_ORG_UNIT1
CMS_ORG_UNIT
CHAR
10
0
Organizational Unit 1
*
293
ORG_UNIT2
CMS_DTE_ORG_UNIT2
CMS_ORG_UNIT
CHAR
10
0
Organizational Unit 2
*
294
ORG_UNIT3
CMS_DTE_ORG_UNIT3
CMS_ORG_UNIT
CHAR
10
0
Organizational Unit 3
*
295
ORG_UNIT4
CMS_DTE_ORG_UNIT4
CMS_ORG_UNIT
CHAR
10
0
Organizational Unit 4
*
296
ORG_UNIT5
CMS_DTE_ORG_UNIT5
CMS_ORG_UNIT
CHAR
10
0
Organizational Unit 5
*
297
.INCLUDE
0
0
Structure for Variable object field names
298
NOM_VALUE_SCR
CMS_DTE_SCREEN_FLD_NAME
CMS_FLD_TEXT
CHAR
15
0
Name of the Asset Screen field
299
AST_VALUE_SCR
CMS_DTE_SCREEN_FLD_NAME
CMS_FLD_TEXT
CHAR
15
0
Name of the Asset Screen field
300
OBJECT_REF_ID_SCR
CMS_DTE_SCREEN_FLD_NAME
CMS_FLD_TEXT
CHAR
15
0
Name of the Asset Screen field