1
MANDT
MANDT
MANDT
CLNT
3
0
Client
T000
2
.INCLUDE
0
0
Structure for Object GUID
3
OBJ_GUID
CMS_RE_DTE_OBJ_GUID
SYSUUID
RAW
16
0
GUID for Real Estate Object
4
.INCLUDE
0
0
Structure for Semantic key for Objects in RE Add-On
5
OBJECT_ID
CMS_RE_DTE_OBJECT_ID
CMS_RE_OBJECT_ID
CHAR
20
0
Object ID
6
.INCLUDE
0
0
Structure for Object Header
7
OBJECT_TYPE
CMS_RE_DTE_OBJ_TYP
CMS_RE_TYP
CHAR
6
0
Real Estate Object Type ID
TCMS_RE_TYP
8
ADDR_ID
CMS_RE_DTE_ADDR_ID
AD_ADDRNUM
CHAR
10
0
Address ID
*
9
OBJECT_DESC
CMS_RE_DTE_OBJ_DESC
CMS_RE_DESC
CHAR
30
0
Description of the Real Estate Object
10
OBJ_PARENT_ID
CMS_RE_DTE_OBJ_GUID
SYSUUID
RAW
16
0
GUID for Real Estate Object
11
OBJ_OLD_REF_NO
CMS_RE_DTE_OBJ_REF_NO
CMS_RE_REFID
CHAR
32
0
External reference Number of an External System
12
FIX_FITTING_TYP
CMS_RE_DTE_FIX_FIT_TYP
CMS_RE_FIX_FIT_TYP
CHAR
6
0
Fixtures and Fittings Type ID
13
.INCLUDE
0
0
Structure for Object Unit Of Measure
14
OBJECT_AREA_UOM
CMS_RE_DTE_AREA_UOM
MEINS
UNIT
3
0
Unit of Measure for Area
*
15
OBJECT_VOL_UOM
CMS_RE_DTE_VOL_UOM
MEINS
UNIT
3
0
Unit of Measure for Volume of Real Estate
*
16
.INCLUDE
0
0
Structure for Object Currency
17
OBJECT_CURR
CMS_RE_DTE_OBJ_CURR
WAERS
CUKY
5
0
Object Currency
TCURC
18
.INCLUDE
0
0
Structure for Location description details
19
MACRO_LOC_TYPE
CMS_RE_DTE_ATT_ID_TY_REO002
CMS_ATT_ID_TYP
CHAR
6
0
Macro Location
TCMS_ATT_ID_TY
20
MICRO_LOC_TYPE
CMS_RE_DTE_ATT_ID_TY_REO003
CMS_ATT_ID_TYP
CHAR
6
0
Micro Location
TCMS_ATT_ID_TY
21
TRAN_CONN_TYPE
CMS_RE_DTE_ATT_ID_TY_REO004
CMS_ATT_ID_TYP
CHAR
6
0
Transport Connection
TCMS_ATT_ID_TY
22
ENVIRON_STATUS
CMS_RE_DTE_ATT_ID_TY_REO005
CMS_ATT_ID_TYP
CHAR
6
0
Enviromental Status
TCMS_ATT_ID_TY
23
FLOOD_ZONE_FLG
CMS_RE_DTE_FLOOD_ZONE
CMS_RE_FLG
CHAR
1
0
Indicator for Flood Zone
24
EARTHQUAKE_FLG
CMS_RE_DTE_EARTHQUAKE
CMS_RE_FLG
CHAR
1
0
Indicator : Eathquake Zone
25
ARCT_CONV_FLG
CMS_RE_DTE_ARCT_CONV
CMS_RE_FLG
CHAR
1
0
Indicator for Architectural Conservation Area
26
HIST_SITE_FLG
CMS_RE_DTE_HIST_SITE
CMS_RE_FLG
CHAR
1
0
Indicator for Historical Site
27
IS_VAL_IMP_FACS
CMS_RE_DTE_VAL_IMP_FLG
CMS_RE_FLG
CHAR
1
0
Indicates existence of Factors Impairing Real Estate Value
28
VALUE_IMP_DESC
CMS_RE_DTE_VAL_IMP_DESC
CMS_RE_DESC
CHAR
30
0
Description of the value imparing factor
29
.INCLUDE
0
0
30
.INCLUDE
0
0
Administrative organization unit
31
ADMIN_ORG_UNIT
CMS_DTE_ADMINORG
TEXT12
CHAR
12
0
Administration Organizational Unit
32
.INCLUDE
0
0
Bank area
33
BANKAREA
CMS_DTE_BANKAREA
CMS_BANKAREA
CHAR
4
0
Bank Area in Collateral Management
*
34
.INCLUDE
0
0
Structure for history
35
CREATED_BY
CMS_RE_DTE_CR_BY
CMS_RE_USER
CHAR
12
0
Real Estate Add-On User
36
CREATED_DATE
CMS_RE_DTE_CR_ON
CMS_RE_DATE
DATS
8
0
Created On
37
CREATED_TIME
CMS_RE_DTE_CR_AT
CMS_RE_TIME
TIMS
6
0
Created At
38
ENTRY_SRC
CMS_RE_DTE_SRC_INIT
CMS_RE_SOURCE
CHAR
32
0
Sorce of Initial entry
39
LAST_CHG_BY
CMS_RE_DTE_CHG_BY
CMS_RE_USER
CHAR
12
0
Last Changed By
40
LAST_CHG_DATE
CMS_RE_DTE_CHG_ON
CMS_RE_DATE
DATS
8
0
Last Changed On
41
LAST_CHG_TIME
CMS_RE_DTE_CHG_AT
CMS_RE_TIME
TIMS
6
0
Last Changed At
42
PROCESSING_SRC
CMS_RE_DTE_PRC_SRC
CMS_RE_SOURCE
CHAR
32
0
Processing Source
43
.INCLUDE
0
0
RE DB Asset Details - not used
44
.INCLUDE
0
0
Basic Asset data
45
RISK_CODE
CMS_RE_DTE_RISK_CODE
CMS_RISK_CODE
CHAR
6
0
Risk Code
*
46
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
47
SFTY_DSCNT
CMS_RE_DTE_SAFETY_DSCNT
CMS_SFTY_PCT
DEC
10
6
Safety discount
48
SFTY_AMOUNT
CMS_RE_DTE_SAFETY_AMT
CMS_AMOUNT
CURR
17
2
Safety discount as an amount
49
SFTY_AMT_CURR
CMS_RE_DTE_SAFETY_AMT_CURR
WAERS
CUKY
5
0
Currency of the Safety discount amount
TCURC
50
.INCLUDE
0
0
Valuation data
51
VALUATION_TYP
CMS_RE_DTE_IND_VALN_TYP
CMS_VALN_TYP
CHAR
2
0
Type of Check conducted on the object
52
UNIT_VALN_FREQ
CMS_RE_DTE_IND_FREQUENCY
CMS_RE_IND_FREQUENCY
CHAR
2
0
Indicator : Valuation Period
53
PERIOD_VALN_FREQ
CMS_RE_DTE_VALN_FREQ_PERIOD
CMS_RE_VALN_FREQ_PERIOD
NUMC
4
0
Period of revaluation for a real estate
54
PAST_VALUED_DATE
CMS_RE_DTE_VALN_DATE
CMS_DATE
DATS
8
0
Most Recent Date on which the Real Estate was last Valued
55
START_DATE
CMS_RE_DTE_START_DATE
CMS_DATE
DATS
8
0
Revaluation Start date
56
END_DATE
CMS_RE_DTE_END_DATE
CMS_DATE
DATS
8
0
End date for Revaluation of the Real Estate
57
.INCLUDE
0
0
Lending rate data
58
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
59
.INCLUDE
0
0
Lending rates
60
LENDING_RATE1
CMS_RE_DTE_LRTE_PCT1
CMS_PCT
DEC
10
6
Lending rate 1
61
LENDING_RATE2
CMS_RE_DTE_LRTE_PCT2
CMS_PCT
DEC
10
6
Lending rate 2
62
LENDING_RATE3
CMS_RE_DTE_LRTE_PCT3
CMS_PCT
DEC
10
6
Lending rate 3
63
LENDING_RATE4
CMS_RE_DTE_LRTE_PCT4
CMS_PCT
DEC
10
6
Lending rate 4
64
LENDING_RATE5
CMS_RE_DTE_LRTE_PCT5
CMS_PCT
DEC
10
6
Lending rate 5
65
.INCLUDE
0
0
Liquidation rights data
66
LIQD_TYP
CMS_RE_DTE_LIQD_TYP
CMS_TYP
CHAR
6
0
Liquidation type
67
LIQD_REASON
CMS_DTE_ATT_ID_TY_AST004
CMS_ATT_ID_TYP
CHAR
6
0
Liquidation Reason
TCMS_ATT_ID_TY
68
LIQD_DATE
CMS_RE_DTE_LIQD_DATE
CMS_DATE
DATS
8
0
Date of Liquidation of Collateral
69
LIQD_AMT
CMS_RE_DTE_LIQD_VALUE
CMS_AMOUNT
CURR
17
2
Proceeds obtained from liquidation of the collateral
70
LIQD_CURR
CMS_RE_DTE_LIQD_CURR
WAERS
CUKY
5
0
Currency of Liquidation value
TCURC
71
.INCLUDE
0
0
Verfication Data
72
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
73
PERIOD_VERF_FREQ
CMS_DTE_AST_VERF_FREQ_PERIOD
CMS_AST_VERF_FREQ_PERIOD
NUMC
4
0
Statement Period for an Asset
74
LAST_VERF_DATE
CMS_DTE_AST_VERF_DATE
CMS_DATE
DATS
8
0
Last Verification Date
75
.INCLUDE
0
0
Organization unit structure: RE
76
ORG_UNIT1
CMS_RE_DTE_ORG_UNIT1
CMS_RE_ORG_UNIT
CHAR
10
0
organization unit 1: Assets
*
77
ORG_UNIT2
CMS_RE_DTE_ORG_UNIT2
CMS_RE_ORG_UNIT
CHAR
10
0
organization unit 2: Assets
*
78
ORG_UNIT3
CMS_RE_DTE_ORG_UNIT3
CMS_RE_ORG_UNIT
CHAR
10
0
organization unit 3: Assets
*
79
ORG_UNIT4
CMS_RE_DTE_ORG_UNIT4
CMS_RE_ORG_UNIT
CHAR
10
0
organization unit 4: Assets
*
80
ORG_UNIT5
CMS_RE_DTE_ORG_UNIT5
CMS_RE_ORG_UNIT
CHAR
10
0
organization unit 5: Assets
*
81
.INCLUDE
0
0