| MANDT |
✔ |
Client |
MANDT |
CLNT |
3 |
* |
| PRT_ACS_GUID |
✔ |
GUID for part accessory |
CMS_RE_DTE_PRT_ACS_GUID |
RAW |
16 |
|
| OBJ_PRT_GUID |
|
GUID for Object part |
CMS_RE_DTE_OBJ_PRT_GUID |
RAW |
16 |
|
| PART_ID |
|
Part ID for the Object |
CMS_RE_DTE_PART_ID |
NUMC |
10 |
|
| ACS_TYPE |
|
Accessory Type |
CMS_RE_DTE_ATT_ID_TY_REO010 |
CHAR |
6 |
TCMS_ATT_ID_TY |
| NO_OF_ACS |
|
No of Accessory Units |
CMS_RE_DTE_NO_OF_ACS |
INT4 |
10 |
|
| ACS_VALUE |
|
Value of the Accessory |
CMS_RE_DTE_ACS_VALUE |
CURR |
17 |
|
| ACS_VALUE_CURR |
|
Currency for Value of the accessory |
CMS_RE_DTE_ACS_VALUE_CURR |
CUKY |
5 |
TCURC |
| IS_SUB_AST_CREA |
|
Indicates whether a Sub-asset is created for Building Part |
CMS_RE_DTE_CREATE_SUB_AST_FLG |
CHAR |
1 |
|
| ACS_DESC |
|
Description of the cost |
CMS_RE_DTE_CST_DESC |
CHAR |
30 |
|
| ACS_ID |
|
Sequence Number of Accessory or Special Equipment |
CMS_RE_DTE_ACS_ID |
NUMC |
4 |
|
| RISK_CODE |
|
Risk Code |
CMS_RE_DTE_RISK_CODE |
CHAR |
6 |
TCMS_RISKCODE |
| 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 |
|
| 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 |
|