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
Structure with Asset Details
25
.INCLUDE
0
0
Basic Asset data
26
RISK_CODE
CMS_RE_DTE_RISK_CODE
CMS_RISK_CODE
CHAR
6
0
Risk Code
TCMS_RISKCODE
27
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
28
SFTY_DSCNT
CMS_RE_DTE_SAFETY_DSCNT
CMS_SFTY_PCT
DEC
10
6
Safety discount
29
SFTY_AMOUNT
CMS_RE_DTE_SAFETY_AMT
CMS_AMOUNT
CURR
17
2
Safety discount as an amount
30
SFTY_AMT_CURR
CMS_RE_DTE_SAFETY_AMT_CURR
WAERS
CUKY
5
0
Currency of the Safety discount amount
TCURC
31
.INCLUDE
0
0
Valuation data
32
VALUATION_TYP
CMS_RE_DTE_IND_VALN_TYP
CMS_VALN_TYP
CHAR
2
0
Type of Check conducted on the object
33
UNIT_VALN_FREQ
CMS_RE_DTE_IND_FREQUENCY
CMS_RE_IND_FREQUENCY
CHAR
2
0
Indicator : Valuation Period
34
PERIOD_VALN_FREQ
CMS_RE_DTE_VALN_FREQ_PERIOD
CMS_RE_VALN_FREQ_PERIOD
NUMC
4
0
Period of revaluation for a real estate
35
PAST_VALUED_DATE
CMS_RE_DTE_VALN_DATE
CMS_DATE
DATS
8
0
Most Recent Date on which the Real Estate was last Valued
36
START_DATE
CMS_RE_DTE_START_DATE
CMS_DATE
DATS
8
0
Revaluation Start date
37
END_DATE
CMS_RE_DTE_END_DATE
CMS_DATE
DATS
8
0
End date for Revaluation of the Real Estate
38
.INCLUDE
0
0
Lending rate data
39
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
40
.INCLUDE
0
0
Lending rates
41
LENDING_RATE1
CMS_RE_DTE_LRTE_PCT1
CMS_PCT
DEC
10
6
Lending rate 1
42
LENDING_RATE2
CMS_RE_DTE_LRTE_PCT2
CMS_PCT
DEC
10
6
Lending rate 2
43
LENDING_RATE3
CMS_RE_DTE_LRTE_PCT3
CMS_PCT
DEC
10
6
Lending rate 3
44
LENDING_RATE4
CMS_RE_DTE_LRTE_PCT4
CMS_PCT
DEC
10
6
Lending rate 4
45
LENDING_RATE5
CMS_RE_DTE_LRTE_PCT5
CMS_PCT
DEC
10
6
Lending rate 5
46
.INCLUDE
0
0
Account for liquidation proceeds
47
ACC_NUMBER_LIQ
CMS_DTE_LIQ_ACC_NUMBER
BANKN35
CHAR
35
0
Account number for liquidation proceeds
48
BANK_CNTRY_LIQ
CMS_DTE_LIQ_BNK_CTRY_KY
LAND1
CHAR
3
0
Bank country key
T005
49
BANK_KEY_LIQ
CMS_DTE_LIQ_BNK_KEY
BANKK
CHAR
15
0
Bank Key
50
BANK_CTRLKEY_LIQ
BKONT
BKONT
CHAR
2
0
Bank Control Key
51
.INCLUDE
0
0
Verfication Data
52
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
53
PERIOD_VERF_FREQ
CMS_DTE_AST_VERF_FREQ_PERIOD
CMS_AST_VERF_FREQ_PERIOD
NUMC
4
0
Statement Period for an Asset
54
LAST_VERF_DATE
CMS_DTE_AST_VERF_DATE
CMS_DATE
DATS
8
0
Last Verification Date
55
.INCLUDE
0
0
Liquidation Data
56
LIQD_TYP
CMS_DTE_LIQD_TYP
CMS_TYP
CHAR
6
0
Liquidation Type
57
LIQD_REASON
CMS_DTE_ATT_ID_TY_AST004
CMS_ATT_ID_TYP
CHAR
6
0
Liquidation Reason
TCMS_ATT_ID_TY
58
LIQD_DATE
CMS_DTE_LIQD_DATE
CMS_DATE
DATS
8
0
Date on which the Collateral was Liquidated
59
LIQD_AMT
CMS_DTE_LIQD_VALUE
CMS_AMOUNT
CURR
17
2
Returns from the Liquidation of Collateral
60
LIQD_CURR
CMS_DTE_LIQD_CURR
WAERS
CUKY
5
0
Currency of Liquidation Value
TCURC
61
EXP_PRCD_AMNT
CMS_DTE_LIQ_EXP_PRCD_AMOUNT
CMS_AMOUNT
CURR
17
2
Expected Proceed Amount
62
EXP_PRCD_CURR
CMS_DTE_LIQ_EXP_PRCD_CURR
WAERS
CUKY
5
0
Currency: Expected Proceed
TCURC
63
EXP_ACC_DATE
CMS_DTE_LIQ_EXP_ACCRUAL_DATE
CMS_DATE
DATS
8
0
Expected accrual date
64
.INCLUDE
0
0
AST PKy and Type and Parent GUID
65
AST_GUID
CMS_DTE_AST_GUID
SYSUUID
RAW
16
0
GUID for Table CMS_AST
66
AST_TYP
CMS_DTE_AST_TYP
CMS_AST_TYP
CHAR
6
0
Asset Type
*
67
PARENT_GUID
CMS_DTE_SAS_PAR_GUID
SYSUUID
RAW
16
0
Asset Guid as a parent GUID for a sub-asset