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