MANDT |
✔ |
Client |
MANDT |
CLNT |
3 |
T000 |
SPC_GUID |
✔ |
GUID for Spaces in Real Estate |
CMS_RE_DTE_SPC_GUID |
RAW |
16 |
|
OBJ_GUID |
|
GUID for Real Estate Object |
CMS_RE_DTE_OBJ_GUID |
RAW |
16 |
CMS_RE_OBJ |
SPACE_TYPE |
|
Building Part Type ID |
CMS_RE_DTE_SPC_TYP |
CHAR |
6 |
TCMS_RE_SP_TYP |
SPACE_COND |
|
Condition ID |
CMS_RE_DTE_OBJ_COND |
CHAR |
6 |
TCMS_RE_COND |
USAGE_TYPE |
|
Usage Type |
CMS_RE_DTE_USG_TYP |
CHAR |
6 |
TCMS_RE_U_TYP |
BLD_STR_TYPE |
|
Real Estate Building Structure ID |
CMS_RE_DTE_BLD_STR_TYP |
CHAR |
6 |
TCMS_RE_STR |
SPACE_DESC |
|
Description of Building Part |
CMS_RE_DTE_SPC_DESC |
CHAR |
30 |
|
NO_UNITS |
|
No of units in real estate object |
CMS_RE_DTE_NO_UNIT |
INT4 |
10 |
|
NO_PARK_UNITS |
|
Number of Parking Units |
CMS_RE_DTE_NO_PARK_UNIT |
INT4 |
10 |
|
NO_GARAGES |
|
No of Garages in Real Estate Object |
CMS_RE_DTE_NO_GAR |
INT4 |
10 |
|
AREA |
|
Total Area of the Real Estate Object |
CMS_RE_DTE_AREA |
QUAN |
13 |
|
AREA_UOM |
|
Unit of Measure for Area |
CMS_RE_DTE_AREA_UOM |
UNIT |
3 |
* |
VOLUME |
|
Volume of Real Estate Object |
CMS_RE_DTE_VOL |
QUAN |
13 |
|
VOLUME_UOM |
|
Unit of Measure for Volume of Real Estate |
CMS_RE_DTE_VOL_UOM |
UNIT |
3 |
* |
AREA_VALUE |
|
Area in the Real Estate which has Collateral Value |
CMS_RE_DTE_AREA_VAL |
QUAN |
13 |
|
AREA_VALUE_UOM |
|
Unit of Measure for Area |
CMS_RE_DTE_AREA_UOM |
UNIT |
3 |
* |
VOLUME_VAL |
|
Volume of Real Estate which has Collateral Value |
CMS_RE_DTE_VOLUME_VAL |
QUAN |
13 |
|
VOLUME_VALUE_UOM |
|
Unit of Measure for Volume of Real Estate |
CMS_RE_DTE_VOL_UOM |
UNIT |
3 |
* |
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 |
|