| MANDT |
✔ |
Client |
MANDT |
CLNT |
3 |
* |
| OBJ_PRT_GUID |
✔ |
GUID for Object part |
CMS_RE_DTE_OBJ_PRT_GUID |
RAW |
16 |
|
| OBJ_GUID |
|
GUID for Real Estate Object |
CMS_RE_DTE_OBJ_GUID |
RAW |
16 |
CMS_RE_OBJ |
| PART_ID |
|
Part ID for the Object |
CMS_RE_DTE_PART_ID |
NUMC |
10 |
|
| BLD_PART_TYPE |
|
Building Part Type |
CMS_RE_DTE_ATT_ID_TY_REO006 |
CHAR |
6 |
TCMS_ATT_ID_TY |
| PART_COND |
|
Object condition |
CMS_RE_DTE_ATT_ID_TY_REO001 |
CHAR |
6 |
TCMS_ATT_ID_TY |
| MAIN_USAGE |
|
Usage Type |
CMS_RE_DTE_USG_TYP |
CHAR |
6 |
TCMS_RE_U_TYP |
| ADD_USAGE_1 |
|
Additional Usage 1 |
CMS_RE_DTE_ADD1_USG_TYP |
CHAR |
6 |
TCMS_RE_U_TYP |
| ADD_USAGE_2 |
|
Additional Usage 2 |
CMS_RE_DTE_ADD2_USG_TYP |
CHAR |
6 |
TCMS_RE_U_TYP |
| BLD_METHOD_ROOF |
|
Building method - Roof |
CMS_RE_DTE_ATT_ID_TY_REO007 |
CHAR |
6 |
TCMS_ATT_ID_TY |
| BLD_METHOD_BODY |
|
Building method - Body |
CMS_RE_DTE_ATT_ID_TY_REO008 |
CHAR |
6 |
TCMS_ATT_ID_TY |
| BLD_METD_CELLAR |
|
Building method - Cellar |
CMS_RE_DTE_ATT_ID_TY_REO009 |
CHAR |
6 |
TCMS_ATT_ID_TY |
| UTILIZATION |
|
Utilization of the Object |
CMS_RE_DTE_PRT_UTILIZATION |
CHAR |
6 |
|
| PART_DESC |
|
Description of Building Part |
CMS_RE_DTE_SPC_DESC |
CHAR |
30 |
|
| COMM_USAGE_PCT |
|
Commercial Usage as a Percentage of Total Usage |
CMS_RE_DTE_COM_USE_PCT |
DEC |
10 |
|
| OTHER_USG_FLG |
|
Indicates if Usages in addition to Main Usage are Possible |
CMS_RE_DTE_OTH_USE_FLG |
CHAR |
1 |
|
| REF_OBJ_PRT_GUID |
|
Reference Object Part GUID |
CMS_RE_DTE_REF_OBJ_PRT_GUID |
RAW |
16 |
|
| IS_SUB_AST_CREA |
|
Indicates whether a Sub-asset is created for Building Part |
CMS_RE_DTE_CREATE_SUB_AST_FLG |
CHAR |
1 |
|
| USEFUL_AREA |
|
Usable Area |
CMS_RE_DTE_AREA_USEFUL |
QUAN |
13 |
|
| USBL_AREA_UOM |
|
Unit of Measure for Usable Area |
CMS_RE_DTE_USBL_AREA_UOM |
UNIT |
3 |
* |
| USEFUL_AREA_REN |
|
Rented Usable Area |
CMS_RE_DTE_AREA_USEFUL_REN |
QUAN |
13 |
|
| USBL_AR_REN_UOM |
|
Unit of Measure for Usable Rented Area |
CMS_RE_DTE_USBL_AREA_REN_UOM |
UNIT |
3 |
* |
| USEFUL_VOL |
|
Usable Volume of Real Estate Building Parts |
CMS_RE_DTE_VOL_USEFUL |
QUAN |
13 |
|
| USBL_VOL_UOM |
|
Unit of Measure for Usable Volume of Real Estate |
CMS_RE_DTE_USBL_VOL_UOM |
UNIT |
3 |
* |
| USEFUL_VOL_REN |
|
Usable Volume of the Rented Portions of Real Estate |
CMS_RE_DTE_VOL_USEFUL_REN |
QUAN |
13 |
|
| USBL_VL_REN_UOM |
|
Unit of measure for usable volume of Rented Parts |
CMS_RE_DTE_USBL_VOL_REN_UOM |
UNIT |
3 |
* |
| RESIDENTIAL_AREA |
|
Residential Area |
CMS_RE_DTE_AREA_RESIDENTIAL |
QUAN |
13 |
|
| RES_AR_UOM |
|
Unit of Measure for Residential Area |
CMS_RE_DTE_RES_AREA_UOM |
UNIT |
3 |
* |
| SECONDARY_AREA |
|
Secondary Area |
CMS_RE_DTE_AREA_SECONDARY |
QUAN |
13 |
|
| SEC_AREA_UOM |
|
Unit of Measure for Secondary Area |
CMS_RE_DTE_SEC_AREA_UOM |
UNIT |
3 |
* |
| OTHER_AREA |
|
Other Area |
CMS_RE_DTE_AREA_OTHER |
QUAN |
13 |
|
| OTH_AREA_UOM |
|
Unit of Measure for Other Area |
CMS_RE_DTE_OTH_AREA_UOM |
UNIT |
3 |
* |
| NO_PRT_UNIT |
|
Number of building part units |
CMS_RE_DTE_NO_PRT_UNIT |
INT4 |
10 |
|
| NO_PRT_UNIT_REN |
|
Number of building part units rented |
CMS_RE_DTE_NO_PRT_UNIT_REN |
INT4 |
10 |
|
| CONS_START_DATE |
|
Start Date of Construction |
CMS_RE_DTE_OBJ_CONS_ST_DATE |
DATS |
8 |
|
| PERMSN_APPL_DATE |
|
Building Permssion applied date |
CMS_RE_DTE_OBJ_PMSN_APPL_DATE |
DATS |
8 |
|
| PERMSN_OBTD_DATE |
|
Building Permssion obtained date |
CMS_RE_DTE_OBJ_PMSN_OBTD_DATE |
DATS |
8 |
|
| OCCY_DATE |
|
Occupancy Date |
CMS_RE_DTE_OBJ_OCCY_DATE |
DATS |
8 |
|
| COMP_DATE |
|
Completion Date |
CMS_RE_DTE_OBJ_COMP_DATE |
DATS |
8 |
|
| FINAL_INSP_DATE |
|
Date of Final Inspection |
CMS_RE_DTE_OBJ_FINAL_INSP_DATE |
DATS |
8 |
|
| RENT_AMT_PLANNED |
|
Planned Rent Amount |
CMS_RE_DTE_RENT_AMOUNT |
CURR |
17 |
|
| RENT_AMT_ACTUAL |
|
Actual Rent Amount |
CMS_RE_DTE_RENT_AMOUNT_ACT |
CURR |
17 |
|
| RENT_PLAN_CURR |
|
Planned Rent Currency |
CMS_RE_DTE_RENT_PLANNED_CURR |
CUKY |
5 |
TCURC |
| RENT_ACT_CURR |
|
Actual Rent Currency |
CMS_RE_DTE_RENT_ACTUAL_CURR |
CUKY |
5 |
TCURC |
| BASE_PERIOD |
|
Base period for the rent |
CMS_RE_DTE_BASE_PERIOD |
CHAR |
1 |
|
| BASE_MEASURE |
|
Base Measure |
CMS_RE_DTE_BASE_MEAS |
CHAR |
1 |
|
| VACANT_POSN_PCT |
|
Ratio of Real Estate not rented to Total Real Estate Value |
CMS_RE_DTE_VACANT_POS_PCT |
DEC |
10 |
|
| RES_RENT_IND |
|
Indicator for Net or Gross Rent |
CMS_RE_DTE_RES_IND |
CHAR |
1 |
|
| COMP_RENT_RES |
|
Comparative Rent (Residential) |
CMS_RE_DTE_RENT_LEVEL |
CURR |
17 |
|
| COM_REN_RES_CURR |
|
Comparative Rent Currency - Residential |
CMS_RE_DTE_COMP_RENT_RES_CURR |
CUKY |
5 |
TCURC |
| LAND_AREA |
|
Land Area of the Real Estate |
CMS_RE_DTE_LAND_AREA |
QUAN |
13 |
|
| LAND_AREA_UOM |
|
Unit of Measure of Land Area |
CMS_RE_DTE_LAND_AREA_UOM |
UNIT |
3 |
T006 |
| LAND_AREA_REN |
|
Land Area of the Real Estate which is Rented |
CMS_RE_DTE_LAND_AREA_REN |
QUAN |
13 |
|
| LAND_AR_REN_UOM |
|
Land area unit of measure(rented) |
CMS_RE_DTE_LAND_AREA_REN_UOM |
UNIT |
3 |
* |
| NO_OF_UNITS |
|
No of units in real estate object |
CMS_RE_DTE_NO_UNIT |
INT4 |
10 |
|
| NO_OF_FLOORS |
|
Number of Floors |
CMS_RE_DTE_NO_FLOOR |
INT4 |
10 |
|
| NO_GARAGES |
|
No of Garages in Real Estate Object |
CMS_RE_DTE_NO_GAR |
INT4 |
10 |
|
| NO_GARAGES_REN |
|
No of Garages Rented in Real Estate Object |
CMS_RE_DTE_NO_GAR_REN |
INT4 |
10 |
|
| NO_PARK_UNIT |
|
Number of Parking Units |
CMS_RE_DTE_NO_PARK_UNIT |
INT4 |
10 |
|
| NO_PARK_UNIT_REN |
|
Number of Parking Units Rented |
CMS_RE_DTE_NO_PARK_UNIT_REN |
INT4 |
10 |
|
| NO_PARK_UG |
|
Number of Underground Parking Units |
CMS_RE_DTE_NO_PARK_UNIT_UG |
INT4 |
10 |
|
| NO_PARK_UG_REN |
|
Number of Rented Underground Parking Units |
CMS_RE_DTE_NO_PARK_UNIT_UG_REN |
INT4 |
10 |
|
| NO_CUR_UNITS |
|
No of current units in real estate object |
CMS_RE_DTE_NO_CUR_UNIT |
INT4 |
10 |
|
| NO_CUR_UNITS_REN |
|
No of Current Units Rented in Real Estate Object |
CMS_RE_DTE_NO_CUR_UNIT_REN |
INT4 |
10 |
|
| NO_OLD_UNITS |
|
No of old units in real estate object |
CMS_RE_DTE_NO_OLD_UNIT |
INT4 |
10 |
|
| NO_OLD_UNITS_REN |
|
No of Old Units Rented in Real Estate Object |
CMS_RE_DTE_NO_OLD_UNIT_REN |
INT4 |
10 |
|
| NO_NEW_UNITS |
|
No of new units in real estate object |
CMS_RE_DTE_NO_NEW_UNIT |
INT4 |
10 |
|
| NO_NEW_UNITS_REN |
|
No of New units Rented in Real Estate Object |
CMS_RE_DTE_NO_NEW_UNIT_REN |
INT4 |
10 |
|
| NO_ACCESS_STR |
|
No of Access Structures |
CMS_RE_DTE_NO_ACCESS_STR |
INT4 |
10 |
|
| NO_SALE_LEVEL |
|
No of Sale levels in commercial building |
CMS_RE_DTE_NO_SALE_LEVEL |
INT4 |
10 |
|
| NO_OF_ROOMS |
|
No of rooms in the hotel/clinic |
CMS_RE_DTE_NO_ROOMS |
INT4 |
10 |
|
| NO_OF_BEDS |
|
No of beds in the clinic/nursing home |
CMS_RE_DTE_NO_BEDS |
INT4 |
10 |
|
| COMM_ENV_DESC |
|
Description of the commercial environment |
CMS_RE_DTE_COMM_ENV_DESC |
CHAR |
30 |
|
| ACCESS_STR_DESC |
|
Description of the Access Structures |
CMS_RE_DTE_ACCESS_STR_DESC |
CHAR |
30 |
|
| BLD_SECTION_DESC |
|
Building Section |
CMS_RE_DTE_ATT_ID_TY_REO015 |
CHAR |
6 |
TCMS_ATT_ID_TY |
| PRICE_CATEGORY |
|
Price Category |
CMS_RE_DTE_ATT_ID_TY_REO013 |
CHAR |
6 |
TCMS_ATT_ID_TY |
| AVG_PRICE |
|
Average Price per Day |
CMS_RE_DTE_AVG_PRICE |
CURR |
17 |
|
| AVG_PRICE_CURR |
|
Average Price Currency |
CMS_RE_DTE_AVG_PRICE_CURR |
CUKY |
5 |
TCURC |
| OCCUPANCY_PCT |
|
Occupancy specified in Percentage Terms |
CMS_RE_DTE_OCCY_PCT |
DEC |
10 |
|
| TURNOVER_AMT |
|
Total Amount of Turnover |
CMS_RE_DTE_TURNOVER_AMOUNT |
CURR |
17 |
|
| TURNOVER_CURR |
|
Currency |
CMS_RE_DTE_TURNOVER_CURR |
CUKY |
5 |
TCURC |
| RENTAL_AGMT_TYP |
|
Rental Agreement Type |
CMS_RE_DTE_ATT_ID_TY_REO014 |
CHAR |
6 |
TCMS_ATT_ID_TY |
| LAST_REPORT_DATE |
|
Date of Last Constuction Report |
CMS_RE_DTE_LAST_CONST_REP_DATE |
DATS |
8 |
|
| BLD_PROGRESS_AMT |
|
Amount Disbursed for Construction based on Building Progress |
CMS_RE_DTE_AMT_BLD_PROGRESS |
CURR |
17 |
|
| BLD_AMT_CURR |
|
Building Progress Amount Curreny |
CMS_RE_DTE_BLD_PROGRESS_CURR |
CUKY |
5 |
* |
| PCT_COMPLETED |
|
Degree of Completion of Construction |
CMS_RE_DTE_DEGREE_COMPLETE |
DEC |
10 |
|
| INSURANCE_TYPE |
|
Insurance Type |
CMS_RE_DTE_ATT_ID_TY_REO011 |
CHAR |
6 |
TCMS_ATT_ID_TY |
| INSURANCE_AMT |
|
Insurance Amount |
CMS_RE_DTE_INSURANCE_AMOUNT |
CURR |
17 |
|
| INSURANCE_CURR |
|
Insurance Currency |
CMS_RE_DTE_INSURANCE_CURR |
CUKY |
5 |
TCURC |
| INS_VALIDITY |
|
Date until which the Insurance Stands Valid |
CMS_RE_DTE_INS_VALID_TILL |
DATS |
8 |
|
| RATIONING_COST |
|
Residential Rationing Cost |
CMS_RE_DTE_RAT_COST_AMT |
CURR |
17 |
|
| RTN_CST_PCT |
|
Percentage of Residential Rationing Cost |
CMS_RE_DTE_RAN_COST_PCT |
DEC |
10 |
|
| EXT_LAYOUT_COST |
|
External Layout Cost |
CMS_RE_DTE_EXT_LAYOUT_COST |
CURR |
17 |
|
| EXT_LAY_CST_PCT |
|
External Layout Cost as Percentage of Total Cost |
CMS_RE_DTE_EXT_LAYOUT_COST_PCT |
DEC |
10 |
|
| RTN_CST_CURR |
|
Rationing cost currency |
CMS_RE_DTE_RTN_CST_CURR |
CUKY |
5 |
* |
| EXT_RTN_CST_CURR |
|
External Layout cost currency |
CMS_RE_DTE_EXT_LAYOUT_CST_CURR |
CUKY |
5 |
* |
| RTN_CST_COM |
|
Commercial Rationing Cost |
CMS_RE_DTE_RAT_COST_AMT_COM |
CURR |
17 |
|
| RTN_CST_COM_CURR |
|
Rationing cost currency |
CMS_RE_DTE_RTN_CST_CURR_COM |
CUKY |
5 |
* |
| RTN_CST_COM_PCT |
|
Percentage of Commercial Rationing Cost |
CMS_RE_DTE_RAN_COST_PCT_COM |
DEC |
10 |
|
| GROSS_COLD_RENT |
|
Gross Cold Rent |
CMS_RE_DTE_YRLY_GROSS_COLD_REN |
CURR |
17 |
|
| GROSS_RENT_CURR |
|
Gross Cold Rent Currency |
CMS_RE_DTE_GROSS_RENT_CURR |
CUKY |
5 |
TCURC |
| NET_COLD_RENT |
|
Net Cold Rent |
CMS_RE_DTE_YRLY_NET_COLD_REN |
CURR |
17 |
|
| NET_RENT_CURR |
|
Net Cold Rent Currency |
CMS_RE_DTE_NET_RENT_CURR |
CUKY |
5 |
TCURC |
| CREATED_BY |
|
Real Estate Add-On User |
CMS_RE_DTE_CR_BY |
CHAR |
12 |
|
| CREATED_DATE |
|
Created On |
CMS_RE_DTE_CR_ON |
DATS |
8 |
|
| CREATED_TIME |
|
Created At |
CMS_RE_DTE_CR_AT |
TIMS |
6 |
|
| ENTRY_SRC |
|
Sorce of Initial entry |
CMS_RE_DTE_SRC_INIT |
CHAR |
32 |
|
| LAST_CHG_BY |
|
Last Changed By |
CMS_RE_DTE_CHG_BY |
CHAR |
12 |
|
| LAST_CHG_DATE |
|
Last Changed On |
CMS_RE_DTE_CHG_ON |
DATS |
8 |
|
| LAST_CHG_TIME |
|
Last Changed At |
CMS_RE_DTE_CHG_AT |
TIMS |
6 |
|
| PROCESSING_SRC |
|
Processing Source |
CMS_RE_DTE_PRC_SRC |
CHAR |
32 |
|
| NO_OF_YEARS_COM |
|
No of years since Last Valuation of Commercial Real Estate |
CMS_RE_DTE_VAL_NO_YEARS_COM |
INT1 |
3 |
|
| INT_RATE_COM |
|
Interest rate (Com) |
CMS_RE_DTE_VAL_INT_RATE_COM |
DEC |
10 |
|
| NO_OF_YEARS |
|
No. of Years since Real Estate was last Valued |
CMS_RE_DTE_VALUATION_NO_YEARS |
INT1 |
3 |
|
| INT_RATE |
|
Interest rate used in Valuation of Residential Real Estate |
CMS_RE_DTE_VALUATION_INT_RATE |
DEC |
10 |
|
| RENT_PLANNED_COM |
|
Planned Rent Amount |
CMS_RE_DTE_RENT_AMOUNT |
CURR |
17 |
|
| RENT_ACTUAL_COM |
|
Actual Rent Amount |
CMS_RE_DTE_RENT_AMOUNT_ACT |
CURR |
17 |
|
| PLAN_CURR_COM |
|
Planned Rent Currency |
CMS_RE_DTE_RENT_PLANNED_CURR |
CUKY |
5 |
TCURC |
| ACT_CURR_COM |
|
Actual Rent Currency |
CMS_RE_DTE_RENT_ACTUAL_CURR |
CUKY |
5 |
TCURC |
| BASE_PERIOD_COM |
|
Base period for the rent |
CMS_RE_DTE_BASE_PERIOD |
CHAR |
1 |
|
| BASE_MEAS_COM |
|
Base Measure |
CMS_RE_DTE_BASE_MEAS |
CHAR |
1 |
|
| COM_RENT_IND |
|
Indicator for Rent Type |
CMS_RE_DTE_COM_IND |
CHAR |
1 |
|
| COMP_RENT_COM |
|
Comparative Rent (Commercial) |
CMS_RE_DTE_RENT_LEVEL_COM |
CURR |
17 |
|
| COMP_REN_COM_CUR |
|
Comparative Rent Currency (Commercial) |
CMS_RE_DTE_COMP_RENT_COM_CURR |
CUKY |
5 |
TCURC |
| PLAN_RENT_LAND |
|
Planned Rent Amount |
CMS_RE_DTE_RENT_AMOUNT |
CURR |
17 |
|
| ACTUAL_RENT_LAND |
|
Actual Rent Amount |
CMS_RE_DTE_RENT_AMOUNT_ACT |
CURR |
17 |
|
| PLAN_RENT_CURR |
|
Planned Rent Currency |
CMS_RE_DTE_RENT_PLANNED_CURR |
CUKY |
5 |
TCURC |
| ACTUAL_RENT_CURR |
|
Actual Rent Currency |
CMS_RE_DTE_RENT_ACTUAL_CURR |
CUKY |
5 |
* |
| BASE_PERIOD_LAND |
|
Base period for the rent |
CMS_RE_DTE_BASE_PERIOD |
CHAR |
1 |
|
| BASE_MEAS_LAND |
|
Base Measure |
CMS_RE_DTE_BASE_MEAS |
CHAR |
1 |
|
| DEPR |
|
Depriciation |
CMS_RE_DTE_DEPR |
DEC |
10 |
|
| LAND_COST |
|
Land Cost Amount |
CMS_RE_DTE_LAND_COST |
CURR |
17 |
|
| LAND_COST_CURR |
|
Land Cost Currency |
CMS_RE_DTE_LAND_COST_CURR |
CUKY |
5 |
* |
| DEV_COST |
|
Development Cost Amount |
CMS_RE_DTE_DEV_COST |
CURR |
17 |
|
| DEV_COST_CURR |
|
Dev Cost Currency |
CMS_RE_DTE_DEV_COST_CURR |
CUKY |
5 |
* |
| LAND_CST_BASE |
|
Base measure of Land |
CMS_RE_DTE_BASE_MEAS_LAND |
CHAR |
1 |
|
| DEV_CST_BASE |
|
Base measure of Land |
CMS_RE_DTE_BASE_MEAS_LAND |
CHAR |
1 |
|
| ADD_LAND_CST |
|
Additional Land Cost Amount |
CMS_RE_DTE_ADD_LAND_COST |
CURR |
17 |
|
| ADD_CST_CURR |
|
Additional Land Cost Currency |
CMS_RE_DTE_ADD_LAND_COST_CURR |
CUKY |
5 |
* |
| ADD_CST_BASE |
|
Base measure of Land |
CMS_RE_DTE_BASE_MEAS_LAND |
CHAR |
1 |
|
| CONST_COST |
|
Construction Cost |
CMS_RE_DTE_CONS_COST |
CURR |
17 |
|
| CONST_COST_CURR |
|
Construction cost currency |
CMS_RE_DTE_CONS_COST_CURR |
CUKY |
5 |
* |
| BASE_MEAS |
|
Base Measure |
CMS_RE_DTE_BASE_MEAS |
CHAR |
1 |
|
| GRS_PROFIT |
|
Yearly Gross Profit |
CMS_RE_DTE_GRS_PROFIT |
CURR |
17 |
|
| GRS_PROFIT_CURR |
|
Yearly Gross Profit Currency |
CMS_RE_DTE_GRS_PROFIT_CURR |
CUKY |
5 |
* |