1 |
.INCLUDE |
|
|
|
|
0 |
0 |
Primary Key for CMS_OMS_PRT_LNK |
|
2 |
PRT_LNK_GUID |
|
CMS_DTE_OMS_PRT_LNK_GUID |
SYSUUID |
RAW |
16 |
0 |
Part Link GUID |
|
3 |
.INCLUDE |
|
|
|
|
0 |
0 |
Primary Key for CMS_MOVABLES |
|
4 |
MOV_GUID |
|
CMS_DTE_MOV_GUID |
SYSUUID |
RAW |
16 |
0 |
GUID for CMS_MOVABLES |
|
5 |
.INCLUDE |
|
|
|
|
0 |
0 |
Semantic Key |
|
6 |
MOV_CATEGORY |
|
CMS_DTE_OMS_OBJ_CAT |
CMS_OBJ_CAT |
CHAR |
6 |
0 |
Object Category |
TCMS_MOV_TYP |
7 |
MOV_TYP |
|
CMS_DTE_MOV_TYP |
CMS_MOV_TYP |
CHAR |
6 |
0 |
Movable types |
TCMS_MOV_TYP |
8 |
MOV_ID |
|
CMS_DTE_MOV_ID |
CMS_MOV_ID |
CHAR |
40 |
0 |
Identification Number |
|
9 |
.INCLUDE |
|
|
|
|
0 |
0 |
Part Type - Data |
|
10 |
PRT_CATEGORY |
|
CMS_DTE_OMS_OBJ_CAT |
CMS_OBJ_CAT |
CHAR |
6 |
0 |
Object Category |
* |
11 |
PRT_TYP |
|
CMS_DTE_OBJ_PRT_TYP |
CMS_MOV_TYP |
CHAR |
6 |
0 |
Object Part Type |
* |
12 |
.INCLUDE |
|
|
|
|
0 |
0 |
Common Movable data |
|
13 |
MOV_DESC |
|
CMS_DTE_MOV_DESC |
CMS_MOV_DESC |
CHAR |
30 |
0 |
Description of the object |
|
14 |
MOV_IDT_ACC |
|
CMS_DTE_MOV_IDT_ACC |
CMS_MOV_IDT_ACC |
CHAR |
1 |
0 |
Identification accessories |
|
15 |
.INCLUDE |
|
|
|
|
0 |
0 |
Object Specific Features for Description |
|
16 |
MOV_MODEL_NAM |
|
CMS_DTE_MOV_MODEL_NAM |
CMS_MOV_MODEL_NAM |
CHAR |
30 |
0 |
Technical Category/Category term/Description |
|
17 |
MOV_MANUFACTURER |
|
CMS_DTE_MOV_MANUFACTURER |
CMS_MOV_MANUFACTURER |
CHAR |
30 |
0 |
Object Manufacturer Builder |
|
18 |
MOV_MANU_DAT |
|
CMS_DTE_MOV_MANU_DAT |
CMS_MOV_MANU_DAT |
DATS |
8 |
0 |
Date of the Manufacture/Purchase |
|
19 |
ADDR_ID |
|
CMS_DTE_MOV_LOCATION |
AD_ADDRNUM |
CHAR |
10 |
0 |
Location / Address |
* |
20 |
MOV_LOC_DESC |
|
CMS_DTE_MOV_LOC_DESC |
CMS_ATT_ID_TYP |
CHAR |
6 |
0 |
Location Description |
TCMS_ATT_ID_TY |
21 |
MOV_LOC_DE_RMRK |
|
CMS_DTE_MOV_LOC_DESC_RMRK |
CMS_MOV_LOC_DESC_RMRK |
CHAR |
30 |
0 |
Remark Field for Location Description |
|
22 |
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 |
23 |
MOV_DESC_COL_MAT |
|
CMS_DTE_OMS_DESC_IDENT_COL_MAT |
CMS_OMS_DESC_COL_MAT |
CHAR |
30 |
0 |
Bank's Own Identifcation |
|
24 |
MOV_DOP |
|
CMS_DTE_MOV_DOP |
CMS_MOV_DOP |
DATS |
8 |
0 |
Date of Purchase |
|
25 |
MOV_IDENT |
|
CMS_DTE_MOV_IDENT |
CMS_MOV_IDENT |
CHAR |
2 |
0 |
Commercial usage |
|
26 |
MOV_UOB |
|
CMS_DTE_MOV_UOB |
CMS_ATT_ID_TYP |
CHAR |
6 |
0 |
Use of the object |
TCMS_ATT_ID_TY |
27 |
MOV_MANU_CNTRY |
|
CMS_DTE_MOV_MANU_CNTRY |
LAND1 |
CHAR |
3 |
0 |
Manufacturing Country |
T005 |
28 |
MOV_TYPE_FEAT |
|
CMS_DTE_MOV_TYPE_FEAT |
CMS_MOV_TYPE_FEAT |
CHAR |
6 |
0 |
Classification |
TCMS_OMS_FEAT |
29 |
.INCLUDE |
|
|
|
|
0 |
0 |
Common OMS data |
|
30 |
EXT_ITM_NO |
|
CMS_DTE_OMS_EXT_ITM_NO |
CMS_OMS_ID |
CHAR |
40 |
0 |
Ext. Item no / Number for identification of the objects |
|
31 |
EXT_REFERENCE |
|
CMS_DTE_OMS_REF_ID |
CMS_OMS_REFID |
CHAR |
32 |
0 |
Reference number for the legacy system |
|
32 |
.INCLUDE |
|
|
|
|
0 |
0 |
Template Information |
|
33 |
IS_TEMPLATE |
|
CMS_DTE_MOV_FLG_TEMPLATE |
CMS_MOV_FLG |
CHAR |
1 |
0 |
Type to be used as template |
|
34 |
TEMPLATE_ID |
|
CMS_DTE_MOV_TEMPLATE_ID |
SYSUUID |
RAW |
16 |
0 |
Template ID |
|
35 |
.INCLUDE |
|
|
|
|
0 |
0 |
Object Part Link Data |
|
36 |
OBJ_PRT_ID |
|
CMS_DTE_OMS_PRT_LNK_PART_ID |
CMS_OMS_PRT_ID |
NUMC |
4 |
0 |
Object Part Link - Part ID |
|
37 |
PRT_OBJSYSID |
|
CMS_DTE_OBJ_SYSID |
CMS_SYS |
CHAR |
6 |
0 |
Object System Reference ID |
|
38 |
.INCLUDE |
|
|
|
|
0 |
0 |
MAPI : GET : Asset details |
|
39 |
CATEGORY |
|
CMS_DTE_OMS_OBJ_CAT |
CMS_OBJ_CAT |
CHAR |
6 |
0 |
Object Category |
* |
40 |
CATEGORY_NAME |
|
CMS_DTE_OMS_CAT_NAME |
CMS_OMS_CAT_NAME |
CHAR |
40 |
0 |
Object Category Name |
|
41 |
TYPE |
|
CMS_DTE_MOV_TYP |
CMS_MOV_TYP |
CHAR |
6 |
0 |
Movable types |
* |
42 |
TYPE_NAME |
|
CMS_DTE_MOV_TYP_NAME |
CMS_MOV_NAME |
CHAR |
40 |
0 |
Name in a specified language |
|
43 |
IDENTIFICATION |
|
CMS_DTE_MOV_ID |
CMS_MOV_ID |
CHAR |
40 |
0 |
Identification Number |
|
44 |
MOV_DESCRIPTION |
|
CMS_DTE_MOV_DESC |
CMS_MOV_DESC |
CHAR |
30 |
0 |
Description of the object |
|
45 |
.INCLUDE |
|
|
|
|
0 |
0 |
Structure with Asset Details for Table CMS_AST |
|
46 |
.INCLUDE |
|
|
|
|
0 |
0 |
Basic Asset data |
|
47 |
DESCRIPTION |
|
CMS_DTE_AST_DESC |
CMS_DSC |
CHAR |
30 |
0 |
Description |
|
48 |
OBJECT_REF_ID |
|
CMS_DTE_OBJ_REFID |
CMS_OBJ_REFID |
CHAR |
40 |
0 |
Reference ID for the object |
|
49 |
OBJECT_TYP |
|
CMS_DTE_OBJ_TYP |
CMS_OBJ_TYP |
CHAR |
32 |
0 |
Not used |
|
50 |
COUNTRY_KEY |
|
CMS_DTE_AST_COUNTRY_KEY |
LAND1 |
CHAR |
3 |
0 |
Identification Key for Country |
* |
51 |
RISK_CODE |
|
CMS_DTE_RISK_CODE |
CMS_RISK_CODE |
CHAR |
6 |
0 |
Risk Code |
* |
52 |
SFTY_IND |
|
CMS_DTE_IND_SFTY_DISC |
CMS_IND_SFTY |
CHAR |
2 |
0 |
Indicates if the Asset has a Default Safety Discount |
|
53 |
SFTY_DSCNT |
|
CMS_DTE_SAFETY_DSCNT |
CMS_SFTY_PCT |
DEC |
10 |
6 |
Percentage of Safety Discount |
|
54 |
SFTY_AMOUNT |
|
CMS_DTE_SAFETY_AMT |
CMS_AMOUNT |
CURR |
17 |
2 |
Amount of Safety Discount |
|
55 |
SFTY_AMT_CURR |
|
CMS_DTE_SAFETY_AMT_CURR |
WAERS |
CUKY |
5 |
0 |
Currency of the Safety Discount Amount |
TCURC |
56 |
OBJSYSID |
|
CMS_DTE_OBJ_SYSID |
CMS_SYS |
CHAR |
6 |
0 |
Object System Reference ID |
|
57 |
.INCLUDE |
|
|
|
|
0 |
0 |
Valuation data |
|
58 |
VALUATION_TYP |
|
CMS_DTE_IND_VALN_TYP |
CMS_VALN_TYP |
CHAR |
2 |
0 |
Type of Valuation Check performed on Collateral Object |
|
59 |
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 |
|
60 |
PERIOD_VALN_FREQ |
|
CMS_DTE_AST_VALN_FREQ_PERIOD |
CMS_AST_VALN_FREQ_PERIOD |
NUMC |
4 |
0 |
Revaluation Period for an Asset |
|
61 |
PAST_VALUED_DATE |
|
CMS_DTE_VALN_DATE |
CMS_DATE |
DATS |
8 |
0 |
Last Date on which the Asset was Valued |
|
62 |
START_DATE |
|
CMS_DTE_START_DATE |
CMS_DATE |
DATS |
8 |
0 |
Date on which the First Valuation is Performed on the Asset |
|
63 |
END_DATE |
|
CMS_DTE_END_DATE |
CMS_DATE |
DATS |
8 |
0 |
Date on which the Last Valuation is Performed on the Asset |
|
64 |
.INCLUDE |
|
|
|
|
0 |
0 |
Lending rate data |
|
65 |
LENDING_RATE_IND |
|
CMS_DTE_IND_LND_RTE |
CMS_IND_LRTE |
CHAR |
2 |
0 |
Indicator to specify if Asset has a Default Lending Rate |
|
66 |
.INCLUDE |
|
|
|
|
0 |
0 |
Lending rates structure |
|
67 |
LENDING_RATE1 |
|
CMS_DTE_LRTE_PCT1 |
CMS_PCT |
DEC |
10 |
6 |
Lending Rate 1 |
|
68 |
LENDING_RATE2 |
|
CMS_DTE_LRTE_PCT2 |
CMS_PCT |
DEC |
10 |
6 |
Lending Rate 2 |
|
69 |
LENDING_RATE3 |
|
CMS_DTE_LRTE_PCT3 |
CMS_PCT |
DEC |
10 |
6 |
Lending Rate 3 |
|
70 |
LENDING_RATE4 |
|
CMS_DTE_LRTE_PCT4 |
CMS_PCT |
DEC |
10 |
6 |
Lending Rate 4 |
|
71 |
LENDING_RATE5 |
|
CMS_DTE_LRTE_PCT5 |
CMS_PCT |
DEC |
10 |
6 |
Lending Rate 5 |
|
72 |
.INCLUDE |
|
|
|
|
0 |
0 |
Liquidation rights data |
|
73 |
LIQD_TYP |
|
CMS_DTE_LIQD_TYP |
CMS_TYP |
CHAR |
6 |
0 |
Liquidation Type |
|
74 |
LIQD_REASON |
|
CMS_DTE_ATT_ID_TY_AST004 |
CMS_ATT_ID_TYP |
CHAR |
6 |
0 |
Liquidation Reason |
TCMS_ATT_ID_TY |
75 |
LIQD_DATE |
|
CMS_DTE_LIQD_DATE |
CMS_DATE |
DATS |
8 |
0 |
Date on which the Collateral was Liquidated |
|
76 |
LIQD_AMT |
|
CMS_DTE_LIQD_VALUE |
CMS_AMOUNT |
CURR |
17 |
2 |
Returns from the Liquidation of Collateral |
|
77 |
LIQD_CURR |
|
CMS_DTE_LIQD_CURR |
WAERS |
CUKY |
5 |
0 |
Currency of Liquidation Value |
TCURC |
78 |
EXP_PRCD_AMNT |
|
CMS_DTE_LIQ_EXP_PRCD_AMOUNT |
CMS_AMOUNT |
CURR |
17 |
2 |
Expected Proceed Amount |
|
79 |
EXP_PRCD_CURR |
|
CMS_DTE_LIQ_EXP_PRCD_CURR |
WAERS |
CUKY |
5 |
0 |
Currency: Expected Proceed |
TCURC |
80 |
EXP_ACC_DATE |
|
CMS_DTE_LIQ_EXP_ACCRUAL_DATE |
CMS_DATE |
DATS |
8 |
0 |
Expected accrual date |
|
81 |
.INCLUDE |
|
|
|
|
0 |
0 |
Account for liquidation proceeds |
|
82 |
ACC_NUMBER_LIQ |
|
CMS_DTE_LIQ_ACC_NUMBER |
BANKN35 |
CHAR |
35 |
0 |
Account number for liquidation proceeds |
|
83 |
BANK_CNTRY_LIQ |
|
CMS_DTE_LIQ_BNK_CTRY_KY |
LAND1 |
CHAR |
3 |
0 |
Bank country key |
T005 |
84 |
BANK_KEY_LIQ |
|
CMS_DTE_LIQ_BNK_KEY |
BANKK |
CHAR |
15 |
0 |
Bank Key |
|
85 |
BANK_CTRLKEY_LIQ |
|
BKONT |
BKONT |
CHAR |
2 |
0 |
Bank Control Key |
|
86 |
.INCLUDE |
|
|
|
|
0 |
0 |
Verfication Data |
|
87 |
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 |
|
88 |
PERIOD_VERF_FREQ |
|
CMS_DTE_AST_VERF_FREQ_PERIOD |
CMS_AST_VERF_FREQ_PERIOD |
NUMC |
4 |
0 |
Statement Period for an Asset |
|
89 |
LAST_VERF_DATE |
|
CMS_DTE_AST_VERF_DATE |
CMS_DATE |
DATS |
8 |
0 |
Last Verification Date |
|
90 |
.INCLUDE |
|
|
|
|
0 |
0 |
AST PKy and Type and Parent GUID |
|
91 |
AST_GUID |
|
CMS_DTE_AST_GUID |
SYSUUID |
RAW |
16 |
0 |
GUID for Table CMS_AST |
|
92 |
AST_TYP |
|
CMS_DTE_AST_TYP |
CMS_AST_TYP |
CHAR |
6 |
0 |
Asset Type |
* |
93 |
PARENT_GUID |
|
CMS_DTE_SAS_PAR_GUID |
SYSUUID |
RAW |
16 |
0 |
Asset Guid as a parent GUID for a sub-asset |
|
94 |
.INCLUDE |
|
|
|
|
0 |
0 |
Structure for Asset values |
|
95 |
NOM_VALUE |
|
CMS_DTE_AST_NOMINAL_VALUE |
CMS_AMOUNT |
CURR |
17 |
2 |
Nominal Value of the Asset |
|
96 |
NOM_VALUE_CURR |
|
CMS_DTE_AST_NOMINAL_VALUE_CURR |
WAERS |
CUKY |
5 |
0 |
Currency of Nominal value |
TCURC |
97 |
AST_VALUE |
|
CMS_DTE_AST_VALUE |
CMS_AMOUNT |
CURR |
17 |
2 |
Final Asset Value |
|
98 |
AST_VALUE_CURR |
|
CMS_DTE_AST_VALUE_CURR |
WAERS |
CUKY |
5 |
0 |
Currency of the Final Asset Value |
TCURC |
99 |
QUANTITY |
|
CMS_DTE_QTY |
CMS_QTY |
QUAN |
13 |
3 |
Quantity |
|
100 |
UNIT_OF_MEASURE |
|
CMS_DTE_UNIT |
MEINS |
UNIT |
3 |
0 |
Unit of Measure of Quantity |
T006 |
101 |
REC_AT |
|
CMS_DTE_REC_AT |
TZNTSTMPS |
DEC |
15 |
0 |
Asset Value Recording Timestamp |
|
102 |
.INCLUDE |
|
|
|
|
0 |
0 |
Purchase price data |
|
103 |
PUR_PRICE |
|
CMS_DTE_AST_PURCHASE_PRICE |
CMS_AMOUNT |
CURR |
17 |
2 |
Purchase Price of the Asset |
|
104 |
PUR_PRICE_CURR |
|
CMS_DTE_AST_PUR_PRICE_CURR |
WAERS |
CUKY |
5 |
0 |
Currency of Purchase Price |
TCURC |
105 |
PUR_DATE |
|
CMS_DTE_AST_PUR_PRICE_DATE |
CMS_DATE |
DATS |
8 |
0 |
Date of Purchase |
|
106 |
.INCLUDE |
|
|
|
|
0 |
0 |
Administrative organization unit |
|
107 |
ADMIN_ORG_UNIT |
|
CMS_DTE_ADMINORG |
TEXT12 |
CHAR |
12 |
0 |
Administration Organizational Unit |
|
108 |
.INCLUDE |
|
|
|
|
0 |
0 |
Bank area |
|
109 |
BANKAREA |
|
CMS_DTE_BANKAREA |
CMS_BANKAREA |
CHAR |
4 |
0 |
Bank Area in Collateral Management |
* |
110 |
.INCLUDE |
|
|
|
|
0 |
0 |
Organization unit structure |
|
111 |
ORG_UNIT1 |
|
CMS_DTE_ORG_UNIT1 |
CMS_ORG_UNIT |
CHAR |
10 |
0 |
Organizational Unit 1 |
* |
112 |
ORG_UNIT2 |
|
CMS_DTE_ORG_UNIT2 |
CMS_ORG_UNIT |
CHAR |
10 |
0 |
Organizational Unit 2 |
* |
113 |
ORG_UNIT3 |
|
CMS_DTE_ORG_UNIT3 |
CMS_ORG_UNIT |
CHAR |
10 |
0 |
Organizational Unit 3 |
* |
114 |
ORG_UNIT4 |
|
CMS_DTE_ORG_UNIT4 |
CMS_ORG_UNIT |
CHAR |
10 |
0 |
Organizational Unit 4 |
* |
115 |
ORG_UNIT5 |
|
CMS_DTE_ORG_UNIT5 |
CMS_ORG_UNIT |
CHAR |
10 |
0 |
Organizational Unit 5 |
* |
116 |
.INCLUDE |
|
|
|
|
0 |
0 |
Inventory Specific details |
|
117 |
IDEN_ACC |
|
CMS_DTE_INV_IDEN_ACC |
CMS_SEC_FLG |
CHAR |
1 |
0 |
Identification land accessories |
|
118 |
BILL_NO |
|
CMS_DTE_INV_BILL_NO |
CMS_INV_BILL_NO |
CHAR |
20 |
0 |
Bill number of the inventory |
|
119 |
UNIT_PRICE |
|
CMS_DTE_INV_UNIT_PRICE |
CMS_AMOUNT |
CURR |
17 |
2 |
Unit Price |
|
120 |
UNIT_PRICE_CURR |
|
CMS_DTE_INV_UNIT_CURR |
WAERS |
CUKY |
5 |
0 |
Currency for unit price |
TCURC |
121 |
TYPE_STK_EXCH |
|
CMS_DTE_INV_TYPE_STK_EXCH |
CMS_ATT_ID_TYP |
CHAR |
6 |
0 |
Type of stock exchange |
TCMS_ATT_ID_TY |
122 |
STK_EXCH_ID |
|
CMS_DTE_INV_STK_EXCH_ID |
CMS_ATT_ID_TYP |
CHAR |
6 |
0 |
Place of stock exchange |
TCMS_ATT_ID_TY |
123 |
RATE_FIX_DAT |
|
CMS_DTE_INV_RATE_FIX_DAT |
DATUM |
DATS |
8 |
0 |
Date of previous quotation |
|
124 |
DET_PRICE |
|
CMS_DTE_INV_DET_PRICE |
CMS_AMOUNT |
CURR |
17 |
2 |
Determined price |
|
125 |
DET_CURR |
|
CMS_DTE_INV_DET_CURR |
WAERS |
CUKY |
5 |
0 |
Currency for determined price |
TCURC |
126 |
STOCK_QUANTITY |
|
CMS_DTE_INV_QTY |
CMS_QTY |
QUAN |
13 |
3 |
Quantity of inventory |
|
127 |
STOCK_UOM |
|
CMS_DTE_UNIT |
MEINS |
UNIT |
3 |
0 |
Unit of Measure of Quantity |
T006 |
128 |
.INCLUDE |
|
|
|
|
0 |
0 |
Stucture to record history of changes in all application tab |
|
129 |
CREATED_BY |
|
CMS_DTE_USER |
CMS_USER |
CHAR |
12 |
0 |
Login ID of the User who created the Record |
|
130 |
CREATED_AT |
|
CMS_DTE_CREATED_AT |
TZNTSTMPS |
DEC |
15 |
0 |
Creation Timestamp |
|
131 |
CHANGED_BY |
|
CMS_DTE_LAST_CHNG_USER |
CMS_USER |
CHAR |
12 |
0 |
Last Changed By |
|
132 |
CHANGED_AT |
|
CMS_DTE_CHANGED_AT |
TZNTSTMPS |
DEC |
15 |
0 |
Change Timestamp |
|
133 |
SOURCEOFENTRY |
|
CMS_DTE_SOURCE_OF_ENTRY |
CMS_SOURCE |
CHAR |
32 |
0 |
Source of Entry |
|