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
Valuation Bases(Com)
135
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
136
INT_RATE_COM
CMS_RE_DTE_VAL_INT_RATE_COM
CMS_RE_PCT
DEC
10
6
Interest rate (Com)
137
.INCLUDE
0
0
Valuation Bases
138
NO_OF_YEARS
CMS_RE_DTE_VALUATION_NO_YEARS
CMS_RE_INT1
INT1
3
0
No. of Years since Real Estate was last Valued
139
INT_RATE
CMS_RE_DTE_VALUATION_INT_RATE
CMS_RE_PCT
DEC
10
6
Interest rate used in Valuation of Residential Real Estate
140
.INCLUDE
0
0
Structure for Part Rent Details
141
RENT_PLANNED_COM
CMS_RE_DTE_RENT_AMOUNT
CMS_RE_AMOUNT
CURR
17
2
Planned Rent Amount
142
RENT_ACTUAL_COM
CMS_RE_DTE_RENT_AMOUNT_ACT
CMS_RE_AMOUNT
CURR
17
2
Actual Rent Amount
143
PLAN_CURR_COM
CMS_RE_DTE_RENT_PLANNED_CURR
WAERS
CUKY
5
0
Planned Rent Currency
TCURC
144
ACT_CURR_COM
CMS_RE_DTE_RENT_ACTUAL_CURR
WAERS
CUKY
5
0
Actual Rent Currency
TCURC
145
BASE_PERIOD_COM
CMS_RE_DTE_BASE_PERIOD
CMS_RE_BASE_PERIOD
CHAR
1
0
Base period for the rent
146
BASE_MEAS_COM
CMS_RE_DTE_BASE_MEAS
CMS_RE_BASE_MEAS
CHAR
1
0
Base Measure
147
COM_RENT_IND
CMS_RE_DTE_COM_IND
CMS_RE_RENT_FLG
CHAR
1
0
Indicator for Rent Type
148
COMP_RENT_COM
CMS_RE_DTE_RENT_LEVEL_COM
CMS_RE_AMOUNT
CURR
17
2
Comparative Rent (Commercial)
149
COMP_REN_COM_CUR
CMS_RE_DTE_COMP_RENT_COM_CURR
WAERS
CUKY
5
0
Comparative Rent Currency (Commercial)
TCURC
150
.INCLUDE
0
0
Building Construction Progress
151
LAST_REPORT_DATE
CMS_RE_DTE_LAST_CONST_REP_DATE
CMS_RE_DATE
DATS
8
0
Date of Last Constuction Report
152
BLD_PROGRESS_AMT
CMS_RE_DTE_AMT_BLD_PROGRESS
CMS_RE_AMOUNT
CURR
17
2
Amount Disbursed for Construction based on Building Progress
153
BLD_AMT_CURR
CMS_RE_DTE_BLD_PROGRESS_CURR
WAERS
CUKY
5
0
Building Progress Amount Curreny
*
154
PCT_COMPLETED
CMS_RE_DTE_DEGREE_COMPLETE
CMS_RE_PCT
DEC
10
6
Degree of Completion of Construction
155
.INCLUDE
0
0
Structure for Land Rent details
156
PLAN_RENT_LAND
CMS_RE_DTE_RENT_AMOUNT
CMS_RE_AMOUNT
CURR
17
2
Planned Rent Amount
157
ACTUAL_RENT_LAND
CMS_RE_DTE_RENT_AMOUNT_ACT
CMS_RE_AMOUNT
CURR
17
2
Actual Rent Amount
158
PLAN_RENT_CURR
CMS_RE_DTE_RENT_PLANNED_CURR
WAERS
CUKY
5
0
Planned Rent Currency
TCURC
159
ACTUAL_RENT_CURR
CMS_RE_DTE_RENT_ACTUAL_CURR
WAERS
CUKY
5
0
Actual Rent Currency
*
160
BASE_PERIOD_LAND
CMS_RE_DTE_BASE_PERIOD
CMS_RE_BASE_PERIOD
CHAR
1
0
Base period for the rent
161
BASE_MEAS_LAND
CMS_RE_DTE_BASE_MEAS
CMS_RE_BASE_MEAS
CHAR
1
0
Base Measure
162
.INCLUDE
0
0
Depriciation
163
DEPR
CMS_RE_DTE_DEPR
CMS_RE_PCT
DEC
10
6
Depriciation
164
.INCLUDE
0
0
Land Costs
165
LAND_COST
CMS_RE_DTE_LAND_COST
CMS_RE_AMOUNT
CURR
17
2
Land Cost Amount
166
LAND_COST_CURR
CMS_RE_DTE_LAND_COST_CURR
WAERS
CUKY
5
0
Land Cost Currency
*
167
DEV_COST
CMS_RE_DTE_DEV_COST
CMS_RE_AMOUNT
CURR
17
2
Development Cost Amount
168
DEV_COST_CURR
CMS_RE_DTE_DEV_COST_CURR
WAERS
CUKY
5
0
Dev Cost Currency
*
169
LAND_CST_BASE
CMS_RE_DTE_BASE_MEAS_LAND
CMS_RE_BASE_MEAS_LAND
CHAR
1
0
Base measure of Land
170
DEV_CST_BASE
CMS_RE_DTE_BASE_MEAS_LAND
CMS_RE_BASE_MEAS_LAND
CHAR
1
0
Base measure of Land
171
ADD_LAND_CST
CMS_RE_DTE_ADD_LAND_COST
CMS_RE_AMOUNT
CURR
17
2
Additional Land Cost Amount
172
ADD_CST_CURR
CMS_RE_DTE_ADD_LAND_COST_CURR
WAERS
CUKY
5
0
Additional Land Cost Currency
*
173
ADD_CST_BASE
CMS_RE_DTE_BASE_MEAS_LAND
CMS_RE_BASE_MEAS_LAND
CHAR
1
0
Base measure of Land
174
.INCLUDE
0
0
Construction Costs for Buildings
175
CONST_COST
CMS_RE_DTE_CONS_COST
CMS_RE_AMOUNT
CURR
17
2
Construction Cost
176
CONST_COST_CURR
CMS_RE_DTE_CONS_COST_CURR
WAERS
CUKY
5
0
Construction cost currency
*
177
BASE_MEAS
CMS_RE_DTE_BASE_MEAS
CMS_RE_BASE_MEAS
CHAR
1
0
Base Measure
178
.INCLUDE
0
0
Yearly Gross Profit for Commercial Real Estate
179
GRS_PROFIT
CMS_RE_DTE_GRS_PROFIT
CMS_RE_AMOUNT
CURR
17
2
Yearly Gross Profit
180
GRS_PROFIT_CURR
CMS_RE_DTE_GRS_PROFIT_CURR
WAERS
CUKY
5
0
Yearly Gross Profit Currency
*
181
.INCLUDE
0
0
AST PKy and Type and Parent GUID
182
AST_GUID
CMS_DTE_AST_GUID
SYSUUID
RAW
16
0
GUID for Table CMS_AST
183
AST_TYP
CMS_DTE_AST_TYP
CMS_AST_TYP
CHAR
6
0
Asset Type
*
184
PARENT_GUID
CMS_DTE_SAS_PAR_GUID
SYSUUID
RAW
16
0
Asset Guid as a parent GUID for a sub-asset
185
.INCLUDE
0
0
Structure with Asset Details
186
.INCLUDE
0
0
Basic Asset data
187
RISK_CODE
CMS_RE_DTE_RISK_CODE
CMS_RISK_CODE
CHAR
6
0
Risk Code
TCMS_RISKCODE
188
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
189
SFTY_DSCNT
CMS_RE_DTE_SAFETY_DSCNT
CMS_SFTY_PCT
DEC
10
6
Safety discount
190
SFTY_AMOUNT
CMS_RE_DTE_SAFETY_AMT
CMS_AMOUNT
CURR
17
2
Safety discount as an amount
191
SFTY_AMT_CURR
CMS_RE_DTE_SAFETY_AMT_CURR
WAERS
CUKY
5
0
Currency of the Safety discount amount
TCURC
192
.INCLUDE
0
0
Valuation data
193
VALUATION_TYP
CMS_RE_DTE_IND_VALN_TYP
CMS_VALN_TYP
CHAR
2
0
Type of Check conducted on the object
194
UNIT_VALN_FREQ
CMS_RE_DTE_IND_FREQUENCY
CMS_RE_IND_FREQUENCY
CHAR
2
0
Indicator : Valuation Period
195
PERIOD_VALN_FREQ
CMS_RE_DTE_VALN_FREQ_PERIOD
CMS_RE_VALN_FREQ_PERIOD
NUMC
4
0
Period of revaluation for a real estate
196
PAST_VALUED_DATE
CMS_RE_DTE_VALN_DATE
CMS_DATE
DATS
8
0
Most Recent Date on which the Real Estate was last Valued
197
START_DATE
CMS_RE_DTE_START_DATE
CMS_DATE
DATS
8
0
Revaluation Start date
198
END_DATE
CMS_RE_DTE_END_DATE
CMS_DATE
DATS
8
0
End date for Revaluation of the Real Estate
199
.INCLUDE
0
0
Lending rate data
200
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
201
.INCLUDE
0
0
Lending rates
202
LENDING_RATE1
CMS_RE_DTE_LRTE_PCT1
CMS_PCT
DEC
10
6
Lending rate 1
203
LENDING_RATE2
CMS_RE_DTE_LRTE_PCT2
CMS_PCT
DEC
10
6
Lending rate 2
204
LENDING_RATE3
CMS_RE_DTE_LRTE_PCT3
CMS_PCT
DEC
10
6
Lending rate 3
205
LENDING_RATE4
CMS_RE_DTE_LRTE_PCT4
CMS_PCT
DEC
10
6
Lending rate 4
206
LENDING_RATE5
CMS_RE_DTE_LRTE_PCT5
CMS_PCT
DEC
10
6
Lending rate 5
207
.INCLUDE
0
0
Account for liquidation proceeds
208
ACC_NUMBER_LIQ
CMS_DTE_LIQ_ACC_NUMBER
BANKN35
CHAR
35
0
Account number for liquidation proceeds
209
BANK_CNTRY_LIQ
CMS_DTE_LIQ_BNK_CTRY_KY
LAND1
CHAR
3
0
Bank country key
T005
210
BANK_KEY_LIQ
CMS_DTE_LIQ_BNK_KEY
BANKK
CHAR
15
0
Bank Key
211
BANK_CTRLKEY_LIQ
BKONT
BKONT
CHAR
2
0
Bank Control Key
212
.INCLUDE
0
0
Verfication Data
213
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
214
PERIOD_VERF_FREQ
CMS_DTE_AST_VERF_FREQ_PERIOD
CMS_AST_VERF_FREQ_PERIOD
NUMC
4
0
Statement Period for an Asset
215
LAST_VERF_DATE
CMS_DTE_AST_VERF_DATE
CMS_DATE
DATS
8
0
Last Verification Date
216
.INCLUDE
0
0
Liquidation Data
217
LIQD_TYP
CMS_DTE_LIQD_TYP
CMS_TYP
CHAR
6
0
Liquidation Type
218
LIQD_REASON
CMS_DTE_ATT_ID_TY_AST004
CMS_ATT_ID_TYP
CHAR
6
0
Liquidation Reason
TCMS_ATT_ID_TY
219
LIQD_DATE
CMS_DTE_LIQD_DATE
CMS_DATE
DATS
8
0
Date on which the Collateral was Liquidated
220
LIQD_AMT
CMS_DTE_LIQD_VALUE
CMS_AMOUNT
CURR
17
2
Returns from the Liquidation of Collateral
221
LIQD_CURR
CMS_DTE_LIQD_CURR
WAERS
CUKY
5
0
Currency of Liquidation Value
TCURC
222
EXP_PRCD_AMNT
CMS_DTE_LIQ_EXP_PRCD_AMOUNT
CMS_AMOUNT
CURR
17
2
Expected Proceed Amount
223
EXP_PRCD_CURR
CMS_DTE_LIQ_EXP_PRCD_CURR
WAERS
CUKY
5
0
Currency: Expected Proceed
TCURC
224
EXP_ACC_DATE
CMS_DTE_LIQ_EXP_ACCRUAL_DATE
CMS_DATE
DATS
8
0
Expected accrual date
225
.INCLUDE
0
0
Structure for Asset values
226
.INCLUDE
0
0
Structure for Asset values
227
NOM_VALUE
CMS_DTE_AST_NOMINAL_VALUE
CMS_AMOUNT
CURR
17
2
Nominal Value of the Asset
228
NOM_VALUE_CURR
CMS_DTE_AST_NOMINAL_VALUE_CURR
WAERS
CUKY
5
0
Currency of Nominal value
TCURC
229
AST_VALUE
CMS_DTE_AST_VALUE
CMS_AMOUNT
CURR
17
2
Final Asset Value
230
AST_VALUE_CURR
CMS_DTE_AST_VALUE_CURR
WAERS
CUKY
5
0
Currency of the Final Asset Value
TCURC
231
QUANTITY
CMS_DTE_QTY
CMS_QTY
QUAN
13
3
Quantity
232
UNIT_OF_MEASURE
CMS_DTE_UNIT
MEINS
UNIT
3
0
Unit of Measure of Quantity
T006
233
REC_AT
CMS_DTE_REC_AT
TZNTSTMPS
DEC
15
0
Asset Value Recording Timestamp
234
.INCLUDE
0
0
Purchase price data
235
PUR_PRICE
CMS_DTE_AST_PURCHASE_PRICE
CMS_AMOUNT
CURR
17
2
Purchase Price of the Asset
236
PUR_PRICE_CURR
CMS_DTE_AST_PUR_PRICE_CURR
WAERS
CUKY
5
0
Currency of Purchase Price
TCURC
237
PUR_DATE
CMS_DTE_AST_PUR_PRICE_DATE
CMS_DATE
DATS
8
0
Date of Purchase
238
.INCLUDE
0
0
Organization unit structure
239
ORG_UNIT1
CMS_DTE_ORG_UNIT1
CMS_ORG_UNIT
CHAR
10
0
Organizational Unit 1
*
240
ORG_UNIT2
CMS_DTE_ORG_UNIT2
CMS_ORG_UNIT
CHAR
10
0
Organizational Unit 2
*
241
ORG_UNIT3
CMS_DTE_ORG_UNIT3
CMS_ORG_UNIT
CHAR
10
0
Organizational Unit 3
*
242
ORG_UNIT4
CMS_DTE_ORG_UNIT4
CMS_ORG_UNIT
CHAR
10
0
Organizational Unit 4
*
243
ORG_UNIT5
CMS_DTE_ORG_UNIT5
CMS_ORG_UNIT
CHAR
10
0
Organizational Unit 5
*