| MANDT |
✔ |
Client |
MANDT |
CLNT |
3 |
T000 |
| OBJ_GUID |
✔ |
GUID for Real Estate Object |
CMS_RE_DTE_OBJ_GUID |
RAW |
16 |
|
| OBJECT_ID |
|
Object ID |
CMS_RE_DTE_OBJECT_ID |
CHAR |
20 |
|
| OBJECT_TYPE |
|
Real Estate Object Type ID |
CMS_RE_DTE_OBJ_TYP |
CHAR |
6 |
TCMS_RE_TYP |
| ADDR_ID |
|
Address ID |
CMS_RE_DTE_ADDR_ID |
CHAR |
10 |
* |
| OBJECT_DESC |
|
Description of the Real Estate Object |
CMS_RE_DTE_OBJ_DESC |
CHAR |
30 |
|
| OBJ_PARENT_ID |
|
GUID for Real Estate Object |
CMS_RE_DTE_OBJ_GUID |
RAW |
16 |
|
| OBJ_OLD_REF_NO |
|
External reference Number of an External System |
CMS_RE_DTE_OBJ_REF_NO |
CHAR |
32 |
|
| FIX_FITTING_TYP |
|
Fixtures and Fittings Type ID |
CMS_RE_DTE_FIX_FIT_TYP |
CHAR |
6 |
|
| OBJECT_AREA_UOM |
|
Unit of Measure for Area |
CMS_RE_DTE_AREA_UOM |
UNIT |
3 |
* |
| OBJECT_VOL_UOM |
|
Unit of Measure for Volume of Real Estate |
CMS_RE_DTE_VOL_UOM |
UNIT |
3 |
* |
| OBJECT_CURR |
|
Object Currency |
CMS_RE_DTE_OBJ_CURR |
CUKY |
5 |
TCURC |
| MACRO_LOC_TYPE |
|
Macro Location |
CMS_RE_DTE_ATT_ID_TY_REO002 |
CHAR |
6 |
TCMS_ATT_ID_TY |
| MICRO_LOC_TYPE |
|
Micro Location |
CMS_RE_DTE_ATT_ID_TY_REO003 |
CHAR |
6 |
TCMS_ATT_ID_TY |
| TRAN_CONN_TYPE |
|
Transport Connection |
CMS_RE_DTE_ATT_ID_TY_REO004 |
CHAR |
6 |
TCMS_ATT_ID_TY |
| ENVIRON_STATUS |
|
Enviromental Status |
CMS_RE_DTE_ATT_ID_TY_REO005 |
CHAR |
6 |
TCMS_ATT_ID_TY |
| FLOOD_ZONE_FLG |
|
Indicator for Flood Zone |
CMS_RE_DTE_FLOOD_ZONE |
CHAR |
1 |
|
| EARTHQUAKE_FLG |
|
Indicator : Eathquake Zone |
CMS_RE_DTE_EARTHQUAKE |
CHAR |
1 |
|
| ARCT_CONV_FLG |
|
Indicator for Architectural Conservation Area |
CMS_RE_DTE_ARCT_CONV |
CHAR |
1 |
|
| HIST_SITE_FLG |
|
Indicator for Historical Site |
CMS_RE_DTE_HIST_SITE |
CHAR |
1 |
|
| IS_VAL_IMP_FACS |
|
Indicates existence of Factors Impairing Real Estate Value |
CMS_RE_DTE_VAL_IMP_FLG |
CHAR |
1 |
|
| VALUE_IMP_DESC |
|
Description of the value imparing factor |
CMS_RE_DTE_VAL_IMP_DESC |
CHAR |
30 |
|
| ADMIN_ORG_UNIT |
|
Administration Organizational Unit |
CMS_DTE_ADMINORG |
CHAR |
12 |
|
| BANKAREA |
|
Bank Area in Collateral Management |
CMS_DTE_BANKAREA |
CHAR |
4 |
* |
| 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 |
|
| RISK_CODE |
|
Risk Code |
CMS_RE_DTE_RISK_CODE |
CHAR |
6 |
* |
| SFTY_IND |
|
Indicates that the asset has a default sfty discount or not |
CMS_RE_DTE_IND_SFTY_DISC |
CHAR |
2 |
|
| SFTY_DSCNT |
|
Safety discount |
CMS_RE_DTE_SAFETY_DSCNT |
DEC |
10 |
|
| SFTY_AMOUNT |
|
Safety discount as an amount |
CMS_RE_DTE_SAFETY_AMT |
CURR |
17 |
|
| SFTY_AMT_CURR |
|
Currency of the Safety discount amount |
CMS_RE_DTE_SAFETY_AMT_CURR |
CUKY |
5 |
TCURC |
| VALUATION_TYP |
|
Type of Check conducted on the object |
CMS_RE_DTE_IND_VALN_TYP |
CHAR |
2 |
|
| UNIT_VALN_FREQ |
|
Indicator : Valuation Period |
CMS_RE_DTE_IND_FREQUENCY |
CHAR |
2 |
|
| PERIOD_VALN_FREQ |
|
Period of revaluation for a real estate |
CMS_RE_DTE_VALN_FREQ_PERIOD |
NUMC |
4 |
|
| PAST_VALUED_DATE |
|
Most Recent Date on which the Real Estate was last Valued |
CMS_RE_DTE_VALN_DATE |
DATS |
8 |
|
| START_DATE |
|
Revaluation Start date |
CMS_RE_DTE_START_DATE |
DATS |
8 |
|
| END_DATE |
|
End date for Revaluation of the Real Estate |
CMS_RE_DTE_END_DATE |
DATS |
8 |
|
| LENDING_RATE_IND |
|
Indicates that the asset has a default lending rate or not |
CMS_RE_DTE_IND_LND_RTE |
CHAR |
2 |
|
| LENDING_RATE1 |
|
Lending rate 1 |
CMS_RE_DTE_LRTE_PCT1 |
DEC |
10 |
|
| LENDING_RATE2 |
|
Lending rate 2 |
CMS_RE_DTE_LRTE_PCT2 |
DEC |
10 |
|
| LENDING_RATE3 |
|
Lending rate 3 |
CMS_RE_DTE_LRTE_PCT3 |
DEC |
10 |
|
| LENDING_RATE4 |
|
Lending rate 4 |
CMS_RE_DTE_LRTE_PCT4 |
DEC |
10 |
|
| LENDING_RATE5 |
|
Lending rate 5 |
CMS_RE_DTE_LRTE_PCT5 |
DEC |
10 |
|
| LIQD_TYP |
|
Liquidation type |
CMS_RE_DTE_LIQD_TYP |
CHAR |
6 |
|
| LIQD_REASON |
|
Liquidation Reason |
CMS_DTE_ATT_ID_TY_AST004 |
CHAR |
6 |
TCMS_ATT_ID_TY |
| LIQD_DATE |
|
Date of Liquidation of Collateral |
CMS_RE_DTE_LIQD_DATE |
DATS |
8 |
|
| LIQD_AMT |
|
Proceeds obtained from liquidation of the collateral |
CMS_RE_DTE_LIQD_VALUE |
CURR |
17 |
|
| LIQD_CURR |
|
Currency of Liquidation value |
CMS_RE_DTE_LIQD_CURR |
CUKY |
5 |
TCURC |
| UNIT_VERF_FREQ |
|
Indicator: Units of time for verification of an asset |
CMS_DTE_IND_AST_VERF_FREQ_UNIT |
CHAR |
2 |
|
| PERIOD_VERF_FREQ |
|
Statement Period for an Asset |
CMS_DTE_AST_VERF_FREQ_PERIOD |
NUMC |
4 |
|
| LAST_VERF_DATE |
|
Last Verification Date |
CMS_DTE_AST_VERF_DATE |
DATS |
8 |
|
| ORG_UNIT1 |
|
organization unit 1: Assets |
CMS_RE_DTE_ORG_UNIT1 |
CHAR |
10 |
* |
| ORG_UNIT2 |
|
organization unit 2: Assets |
CMS_RE_DTE_ORG_UNIT2 |
CHAR |
10 |
* |
| ORG_UNIT3 |
|
organization unit 3: Assets |
CMS_RE_DTE_ORG_UNIT3 |
CHAR |
10 |
* |
| ORG_UNIT4 |
|
organization unit 4: Assets |
CMS_RE_DTE_ORG_UNIT4 |
CHAR |
10 |
* |
| ORG_UNIT5 |
|
organization unit 5: Assets |
CMS_RE_DTE_ORG_UNIT5 |
CHAR |
10 |
* |