1
.INCLUDE
0
0
Primary key for Part accessory
2
PRT_ACS_GUID
CMS_RE_DTE_PRT_ACS_GUID
SYSUUID
RAW
16
0
GUID for part accessory
3
.INCLUDE
0
0
Link structure for Object parts
4
OBJ_PRT_GUID
CMS_RE_DTE_OBJ_PRT_GUID
SYSUUID
RAW
16
0
GUID for Object part
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 Accessory Type
8
ACS_TYPE
CMS_RE_DTE_ATT_ID_TY_REO010
CMS_ATT_ID_TYP
CHAR
6
0
Accessory Type
TCMS_ATT_ID_TY
9
NO_OF_ACS
CMS_RE_DTE_NO_OF_ACS
CMS_RE_UNITS
INT4
10
0
No of Accessory Units
10
ACS_VALUE
CMS_RE_DTE_ACS_VALUE
CMS_RE_AMOUNT
CURR
17
2
Value of the Accessory
11
ACS_VALUE_CURR
CMS_RE_DTE_ACS_VALUE_CURR
WAERS
CUKY
5
0
Currency for Value of the accessory
TCURC
12
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
13
ACS_DESC
CMS_RE_DTE_CST_DESC
CMS_RE_DESC
CHAR
30
0
Description of the cost
14
ACS_ID
CMS_RE_DTE_ACS_ID
CMS_ACS_ID
NUMC
4
0
Sequence Number of Accessory or Special Equipment
15
.INCLUDE
0
0
Structure for history
16
CREATED_BY
CMS_RE_DTE_CR_BY
CMS_RE_USER
CHAR
12
0
Real Estate Add-On User
17
CREATED_DATE
CMS_RE_DTE_CR_ON
CMS_RE_DATE
DATS
8
0
Created On
18
CREATED_TIME
CMS_RE_DTE_CR_AT
CMS_RE_TIME
TIMS
6
0
Created At
19
ENTRY_SRC
CMS_RE_DTE_SRC_INIT
CMS_RE_SOURCE
CHAR
32
0
Sorce of Initial entry
20
LAST_CHG_BY
CMS_RE_DTE_CHG_BY
CMS_RE_USER
CHAR
12
0
Last Changed By
21
LAST_CHG_DATE
CMS_RE_DTE_CHG_ON
CMS_RE_DATE
DATS
8
0
Last Changed On
22
LAST_CHG_TIME
CMS_RE_DTE_CHG_AT
CMS_RE_TIME
TIMS
6
0
Last Changed At
23
PROCESSING_SRC
CMS_RE_DTE_PRC_SRC
CMS_RE_SOURCE
CHAR
32
0
Processing Source
24
.INCLUDE
0
0
25
MARK
CMS_RE_DTE_ROW_SELECTED
CMS_RE_FLG
CHAR
1
0
Flag for row selected in the screen
26
.INCLUDE
0
0
Structure with Asset Details
27
.INCLUDE
0
0
Basic Asset data
28
RISK_CODE
CMS_RE_DTE_RISK_CODE
CMS_RISK_CODE
CHAR
6
0
Risk Code
*
29
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
30
SFTY_DSCNT
CMS_RE_DTE_SAFETY_DSCNT
CMS_SFTY_PCT
DEC
10
6
Safety discount
31
SFTY_AMOUNT
CMS_RE_DTE_SAFETY_AMT
CMS_AMOUNT
CURR
17
2
Safety discount as an amount
32
SFTY_AMT_CURR
CMS_RE_DTE_SAFETY_AMT_CURR
WAERS
CUKY
5
0
Currency of the Safety discount amount
TCURC
33
.INCLUDE
0
0
Valuation data
34
VALUATION_TYP
CMS_RE_DTE_IND_VALN_TYP
CMS_VALN_TYP
CHAR
2
0
Type of Check conducted on the object
35
UNIT_VALN_FREQ
CMS_RE_DTE_IND_FREQUENCY
CMS_RE_IND_FREQUENCY
CHAR
2
0
Indicator : Valuation Period
36
PERIOD_VALN_FREQ
CMS_RE_DTE_VALN_FREQ_PERIOD
CMS_RE_VALN_FREQ_PERIOD
NUMC
4
0
Period of revaluation for a real estate
37
PAST_VALUED_DATE
CMS_RE_DTE_VALN_DATE
CMS_DATE
DATS
8
0
Most Recent Date on which the Real Estate was last Valued
38
START_DATE
CMS_RE_DTE_START_DATE
CMS_DATE
DATS
8
0
Revaluation Start date
39
END_DATE
CMS_RE_DTE_END_DATE
CMS_DATE
DATS
8
0
End date for Revaluation of the Real Estate
40
.INCLUDE
0
0
Lending rate data
41
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
42
.INCLUDE
0
0
Lending rates
43
LENDING_RATE1
CMS_RE_DTE_LRTE_PCT1
CMS_PCT
DEC
10
6
Lending rate 1
44
LENDING_RATE2
CMS_RE_DTE_LRTE_PCT2
CMS_PCT
DEC
10
6
Lending rate 2
45
LENDING_RATE3
CMS_RE_DTE_LRTE_PCT3
CMS_PCT
DEC
10
6
Lending rate 3
46
LENDING_RATE4
CMS_RE_DTE_LRTE_PCT4
CMS_PCT
DEC
10
6
Lending rate 4
47
LENDING_RATE5
CMS_RE_DTE_LRTE_PCT5
CMS_PCT
DEC
10
6
Lending rate 5
48
.INCLUDE
0
0
Account for liquidation proceeds
49
ACC_NUMBER_LIQ
CMS_DTE_LIQ_ACC_NUMBER
BANKN35
CHAR
35
0
Account number for liquidation proceeds
50
BANK_CNTRY_LIQ
CMS_DTE_LIQ_BNK_CTRY_KY
LAND1
CHAR
3
0
Bank country key
T005
51
BANK_KEY_LIQ
CMS_DTE_LIQ_BNK_KEY
BANKK
CHAR
15
0
Bank Key
52
BANK_CTRLKEY_LIQ
BKONT
BKONT
CHAR
2
0
Bank Control Key
53
.INCLUDE
0
0
Verfication Data
54
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
55
PERIOD_VERF_FREQ
CMS_DTE_AST_VERF_FREQ_PERIOD
CMS_AST_VERF_FREQ_PERIOD
NUMC
4
0
Statement Period for an Asset
56
LAST_VERF_DATE
CMS_DTE_AST_VERF_DATE
CMS_DATE
DATS
8
0
Last Verification Date
57
.INCLUDE
0
0
Liquidation Data
58
LIQD_TYP
CMS_DTE_LIQD_TYP
CMS_TYP
CHAR
6
0
Liquidation Type
59
LIQD_REASON
CMS_DTE_ATT_ID_TY_AST004
CMS_ATT_ID_TYP
CHAR
6
0
Liquidation Reason
TCMS_ATT_ID_TY
60
LIQD_DATE
CMS_DTE_LIQD_DATE
CMS_DATE
DATS
8
0
Date on which the Collateral was Liquidated
61
LIQD_AMT
CMS_DTE_LIQD_VALUE
CMS_AMOUNT
CURR
17
2
Returns from the Liquidation of Collateral
62
LIQD_CURR
CMS_DTE_LIQD_CURR
WAERS
CUKY
5
0
Currency of Liquidation Value
TCURC
63
EXP_PRCD_AMNT
CMS_DTE_LIQ_EXP_PRCD_AMOUNT
CMS_AMOUNT
CURR
17
2
Expected Proceed Amount
64
EXP_PRCD_CURR
CMS_DTE_LIQ_EXP_PRCD_CURR
WAERS
CUKY
5
0
Currency: Expected Proceed
TCURC
65
EXP_ACC_DATE
CMS_DTE_LIQ_EXP_ACCRUAL_DATE
CMS_DATE
DATS
8
0
Expected accrual date