1 |
.INCLUDE |
|
|
|
|
0 |
0 |
Primary Key for CMS_MOVABLES |
|
2 |
MOV_GUID |
|
CMS_DTE_MOV_GUID |
SYSUUID |
RAW |
16 |
0 |
GUID for CMS_MOVABLES |
|
3 |
.INCLUDE |
|
|
|
|
0 |
0 |
Semantic Key |
|
4 |
MOV_CATEGORY |
|
CMS_DTE_OMS_OBJ_CAT |
CMS_OBJ_CAT |
CHAR |
6 |
0 |
Object Category |
TCMS_MOV_TYP |
5 |
MOV_TYP |
|
CMS_DTE_MOV_TYP |
CMS_MOV_TYP |
CHAR |
6 |
0 |
Movable types |
TCMS_MOV_TYP |
6 |
MOV_ID |
|
CMS_DTE_MOV_ID |
CMS_MOV_ID |
CHAR |
40 |
0 |
Identification Number |
|
7 |
.INCLUDE |
|
|
|
|
0 |
0 |
Common Movable data |
|
8 |
MOV_DESC |
|
CMS_DTE_MOV_DESC |
CMS_MOV_DESC |
CHAR |
30 |
0 |
Description of the object |
|
9 |
MOV_IDT_ACC |
|
CMS_DTE_MOV_IDT_ACC |
CMS_MOV_IDT_ACC |
CHAR |
1 |
0 |
Identification accessories |
|
10 |
.INCLUDE |
|
|
|
|
0 |
0 |
Object Specific Features for Description |
|
11 |
MOV_MODEL_NAM |
|
CMS_DTE_MOV_MODEL_NAM |
CMS_MOV_MODEL_NAM |
CHAR |
30 |
0 |
Technical Category/Category term/Description |
|
12 |
MOV_MANUFACTURER |
|
CMS_DTE_MOV_MANUFACTURER |
CMS_MOV_MANUFACTURER |
CHAR |
30 |
0 |
Object Manufacturer Builder |
|
13 |
MOV_MANU_DAT |
|
CMS_DTE_MOV_MANU_DAT |
CMS_MOV_MANU_DAT |
DATS |
8 |
0 |
Date of the Manufacture/Purchase |
|
14 |
ADDR_ID |
|
CMS_DTE_MOV_LOCATION |
AD_ADDRNUM |
CHAR |
10 |
0 |
Location / Address |
* |
15 |
MOV_LOC_DESC |
|
CMS_DTE_MOV_LOC_DESC |
CMS_ATT_ID_TYP |
CHAR |
6 |
0 |
Location Description |
TCMS_ATT_ID_TY |
16 |
MOV_LOC_DE_RMRK |
|
CMS_DTE_MOV_LOC_DESC_RMRK |
CMS_MOV_LOC_DESC_RMRK |
CHAR |
30 |
0 |
Remark Field for Location Description |
|
17 |
MOV_IDEN_TYP |
|
CMS_DTE_MOV_TYPE_IDENT |
CMS_ATT_ID_TYP |
CHAR |
6 |
0 |
Type of identification / Marking of the collateral material |
TCMS_ATT_ID_TY |
18 |
MOV_DESC_COL_MAT |
|
CMS_DTE_OMS_DESC_IDENT_COL_MAT |
CMS_OMS_DESC_COL_MAT |
CHAR |
30 |
0 |
Bank's Own Identifcation |
|
19 |
MOV_DOP |
|
CMS_DTE_MOV_DOP |
CMS_MOV_DOP |
DATS |
8 |
0 |
Date of Purchase |
|
20 |
MOV_IDENT |
|
CMS_DTE_MOV_IDENT |
CMS_MOV_IDENT |
CHAR |
2 |
0 |
Commercial usage |
|
21 |
MOV_UOB |
|
CMS_DTE_MOV_UOB |
CMS_ATT_ID_TYP |
CHAR |
6 |
0 |
Use of the object |
TCMS_ATT_ID_TY |
22 |
MOV_MANU_CNTRY |
|
CMS_DTE_MOV_MANU_CNTRY |
LAND1 |
CHAR |
3 |
0 |
Manufacturing Country |
T005 |
23 |
MOV_TYPE_FEAT |
|
CMS_DTE_MOV_TYPE_FEAT |
CMS_MOV_TYPE_FEAT |
CHAR |
6 |
0 |
Classification |
TCMS_OMS_FEAT |
24 |
.INCLUDE |
|
|
|
|
0 |
0 |
Common OMS data |
|
25 |
EXT_ITM_NO |
|
CMS_DTE_OMS_EXT_ITM_NO |
CMS_OMS_ID |
CHAR |
40 |
0 |
Ext. Item no / Number for identification of the objects |
|
26 |
EXT_REFERENCE |
|
CMS_DTE_OMS_REF_ID |
CMS_OMS_REFID |
CHAR |
32 |
0 |
Reference number for the legacy system |
|
27 |
.INCLUDE |
|
|
|
|
0 |
0 |
Template Information |
|
28 |
IS_TEMPLATE |
|
CMS_DTE_MOV_FLG_TEMPLATE |
CMS_MOV_FLG |
CHAR |
1 |
0 |
Type to be used as template |
|
29 |
TEMPLATE_ID |
|
CMS_DTE_MOV_TEMPLATE_ID |
SYSUUID |
RAW |
16 |
0 |
Template ID |
|
30 |
.INCLUDE |
|
|
|
|
0 |
0 |
Structure with Asset Details for Table CMS_AST |
|
31 |
.INCLUDE |
|
|
|
|
0 |
0 |
Basic Asset data |
|
32 |
DESCRIPTION |
|
CMS_DTE_AST_DESC |
CMS_DSC |
CHAR |
30 |
0 |
Description |
|
33 |
OBJECT_REF_ID |
|
CMS_DTE_OBJ_REFID |
CMS_OBJ_REFID |
CHAR |
40 |
0 |
Reference ID for the object |
|
34 |
OBJECT_TYP |
|
CMS_DTE_OBJ_TYP |
CMS_OBJ_TYP |
CHAR |
32 |
0 |
Not used |
|
35 |
COUNTRY_KEY |
|
CMS_DTE_AST_COUNTRY_KEY |
LAND1 |
CHAR |
3 |
0 |
Identification Key for Country |
* |
36 |
RISK_CODE |
|
CMS_DTE_RISK_CODE |
CMS_RISK_CODE |
CHAR |
6 |
0 |
Risk Code |
* |
37 |
SFTY_IND |
|
CMS_DTE_IND_SFTY_DISC |
CMS_IND_SFTY |
CHAR |
2 |
0 |
Indicates if the Asset has a Default Safety Discount |
|
38 |
SFTY_DSCNT |
|
CMS_DTE_SAFETY_DSCNT |
CMS_SFTY_PCT |
DEC |
10 |
6 |
Percentage of Safety Discount |
|
39 |
SFTY_AMOUNT |
|
CMS_DTE_SAFETY_AMT |
CMS_AMOUNT |
CURR |
17 |
2 |
Amount of Safety Discount |
|
40 |
SFTY_AMT_CURR |
|
CMS_DTE_SAFETY_AMT_CURR |
WAERS |
CUKY |
5 |
0 |
Currency of the Safety Discount Amount |
TCURC |
41 |
OBJSYSID |
|
CMS_DTE_OBJ_SYSID |
CMS_SYS |
CHAR |
6 |
0 |
Object System Reference ID |
|
42 |
.INCLUDE |
|
|
|
|
0 |
0 |
Valuation data |
|
43 |
VALUATION_TYP |
|
CMS_DTE_IND_VALN_TYP |
CMS_VALN_TYP |
CHAR |
2 |
0 |
Type of Valuation Check performed on Collateral Object |
|
44 |
UNIT_VALN_FREQ |
|
CMS_DTE_IND_AST_VALN_FREQ_UNIT |
CMS_IND_AST_VALN_FREQ_UNIT |
CHAR |
2 |
0 |
Indicator: Units of time for revaluation of an asset |
|
45 |
PERIOD_VALN_FREQ |
|
CMS_DTE_AST_VALN_FREQ_PERIOD |
CMS_AST_VALN_FREQ_PERIOD |
NUMC |
4 |
0 |
Revaluation Period for an Asset |
|
46 |
PAST_VALUED_DATE |
|
CMS_DTE_VALN_DATE |
CMS_DATE |
DATS |
8 |
0 |
Last Date on which the Asset was Valued |
|
47 |
START_DATE |
|
CMS_DTE_START_DATE |
CMS_DATE |
DATS |
8 |
0 |
Date on which the First Valuation is Performed on the Asset |
|
48 |
END_DATE |
|
CMS_DTE_END_DATE |
CMS_DATE |
DATS |
8 |
0 |
Date on which the Last Valuation is Performed on the Asset |
|
49 |
.INCLUDE |
|
|
|
|
0 |
0 |
Lending rate data |
|
50 |
LENDING_RATE_IND |
|
CMS_DTE_IND_LND_RTE |
CMS_IND_LRTE |
CHAR |
2 |
0 |
Indicator to specify if Asset has a Default Lending Rate |
|
51 |
.INCLUDE |
|
|
|
|
0 |
0 |
Lending rates structure |
|
52 |
LENDING_RATE1 |
|
CMS_DTE_LRTE_PCT1 |
CMS_PCT |
DEC |
10 |
6 |
Lending Rate 1 |
|
53 |
LENDING_RATE2 |
|
CMS_DTE_LRTE_PCT2 |
CMS_PCT |
DEC |
10 |
6 |
Lending Rate 2 |
|
54 |
LENDING_RATE3 |
|
CMS_DTE_LRTE_PCT3 |
CMS_PCT |
DEC |
10 |
6 |
Lending Rate 3 |
|
55 |
LENDING_RATE4 |
|
CMS_DTE_LRTE_PCT4 |
CMS_PCT |
DEC |
10 |
6 |
Lending Rate 4 |
|
56 |
LENDING_RATE5 |
|
CMS_DTE_LRTE_PCT5 |
CMS_PCT |
DEC |
10 |
6 |
Lending Rate 5 |
|
57 |
.INCLUDE |
|
|
|
|
0 |
0 |
Liquidation rights 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 |
|
66 |
.INCLUDE |
|
|
|
|
0 |
0 |
Account for liquidation proceeds |
|
67 |
ACC_NUMBER_LIQ |
|
CMS_DTE_LIQ_ACC_NUMBER |
BANKN35 |
CHAR |
35 |
0 |
Account number for liquidation proceeds |
|
68 |
BANK_CNTRY_LIQ |
|
CMS_DTE_LIQ_BNK_CTRY_KY |
LAND1 |
CHAR |
3 |
0 |
Bank country key |
T005 |
69 |
BANK_KEY_LIQ |
|
CMS_DTE_LIQ_BNK_KEY |
BANKK |
CHAR |
15 |
0 |
Bank Key |
|
70 |
BANK_CTRLKEY_LIQ |
|
BKONT |
BKONT |
CHAR |
2 |
0 |
Bank Control Key |
|
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 |
AST PKy and Type and Parent GUID |
|
76 |
AST_GUID |
|
CMS_DTE_AST_GUID |
SYSUUID |
RAW |
16 |
0 |
GUID for Table CMS_AST |
|
77 |
AST_TYP |
|
CMS_DTE_AST_TYP |
CMS_AST_TYP |
CHAR |
6 |
0 |
Asset Type |
* |
78 |
PARENT_GUID |
|
CMS_DTE_SAS_PAR_GUID |
SYSUUID |
RAW |
16 |
0 |
Asset Guid as a parent GUID for a sub-asset |
|
79 |
.INCLUDE |
|
|
|
|
0 |
0 |
Structure for Asset values |
|
80 |
NOM_VALUE |
|
CMS_DTE_AST_NOMINAL_VALUE |
CMS_AMOUNT |
CURR |
17 |
2 |
Nominal Value of the Asset |
|
81 |
NOM_VALUE_CURR |
|
CMS_DTE_AST_NOMINAL_VALUE_CURR |
WAERS |
CUKY |
5 |
0 |
Currency of Nominal value |
TCURC |
82 |
AST_VALUE |
|
CMS_DTE_AST_VALUE |
CMS_AMOUNT |
CURR |
17 |
2 |
Final Asset Value |
|
83 |
AST_VALUE_CURR |
|
CMS_DTE_AST_VALUE_CURR |
WAERS |
CUKY |
5 |
0 |
Currency of the Final Asset Value |
TCURC |
84 |
QUANTITY |
|
CMS_DTE_QTY |
CMS_QTY |
QUAN |
13 |
3 |
Quantity |
|
85 |
UNIT_OF_MEASURE |
|
CMS_DTE_UNIT |
MEINS |
UNIT |
3 |
0 |
Unit of Measure of Quantity |
T006 |
86 |
REC_AT |
|
CMS_DTE_REC_AT |
TZNTSTMPS |
DEC |
15 |
0 |
Asset Value Recording Timestamp |
|
87 |
.INCLUDE |
|
|
|
|
0 |
0 |
Purchase price data |
|
88 |
PUR_PRICE |
|
CMS_DTE_AST_PURCHASE_PRICE |
CMS_AMOUNT |
CURR |
17 |
2 |
Purchase Price of the Asset |
|
89 |
PUR_PRICE_CURR |
|
CMS_DTE_AST_PUR_PRICE_CURR |
WAERS |
CUKY |
5 |
0 |
Currency of Purchase Price |
TCURC |
90 |
PUR_DATE |
|
CMS_DTE_AST_PUR_PRICE_DATE |
CMS_DATE |
DATS |
8 |
0 |
Date of Purchase |
|
91 |
.INCLUDE |
|
|
|
|
0 |
0 |
Administrative organization unit |
|
92 |
ADMIN_ORG_UNIT |
|
CMS_DTE_ADMINORG |
TEXT12 |
CHAR |
12 |
0 |
Administration Organizational Unit |
|
93 |
.INCLUDE |
|
|
|
|
0 |
0 |
Bank area |
|
94 |
BANKAREA |
|
CMS_DTE_BANKAREA |
CMS_BANKAREA |
CHAR |
4 |
0 |
Bank Area in Collateral Management |
* |
95 |
.INCLUDE |
|
|
|
|
0 |
0 |
Organization unit structure |
|
96 |
ORG_UNIT1 |
|
CMS_DTE_ORG_UNIT1 |
CMS_ORG_UNIT |
CHAR |
10 |
0 |
Organizational Unit 1 |
* |
97 |
ORG_UNIT2 |
|
CMS_DTE_ORG_UNIT2 |
CMS_ORG_UNIT |
CHAR |
10 |
0 |
Organizational Unit 2 |
* |
98 |
ORG_UNIT3 |
|
CMS_DTE_ORG_UNIT3 |
CMS_ORG_UNIT |
CHAR |
10 |
0 |
Organizational Unit 3 |
* |
99 |
ORG_UNIT4 |
|
CMS_DTE_ORG_UNIT4 |
CMS_ORG_UNIT |
CHAR |
10 |
0 |
Organizational Unit 4 |
* |
100 |
ORG_UNIT5 |
|
CMS_DTE_ORG_UNIT5 |
CMS_ORG_UNIT |
CHAR |
10 |
0 |
Organizational Unit 5 |
* |