1 |
OBJ_PRT_ID |
|
CMS_DTE_OMS_PRT_LNK_PART_ID |
CMS_OMS_PRT_ID |
NUMC |
4 |
0 |
Object Part Link - Part ID |
|
2 |
PRT_OBJSYSID |
|
CMS_DTE_OBJ_SYSID |
CMS_SYS |
CHAR |
6 |
0 |
Object System Reference ID |
|
3 |
PRT_TYP |
|
CMS_DTE_OBJ_PRT_TYP |
CMS_MOV_TYP |
CHAR |
6 |
0 |
Object Part Type |
* |
4 |
MOV_DESC |
|
CMS_DTE_MOV_DESC |
CMS_MOV_DESC |
CHAR |
30 |
0 |
Description of the object |
|
5 |
MOV_IDT_ACC |
|
CMS_DTE_MOV_IDT_ACC |
CMS_MOV_IDT_ACC |
CHAR |
1 |
0 |
Identification accessories |
|
6 |
MOV_MODEL_NAM |
|
CMS_DTE_MOV_MODEL_NAM |
CMS_MOV_MODEL_NAM |
CHAR |
30 |
0 |
Technical Category/Category term/Description |
|
7 |
MOV_MANUFACTURER |
|
CMS_DTE_MOV_MANUFACTURER |
CMS_MOV_MANUFACTURER |
CHAR |
30 |
0 |
Object Manufacturer Builder |
|
8 |
MOV_MANU_DAT |
|
CMS_DTE_MOV_MANU_DAT |
CMS_MOV_MANU_DAT |
DATS |
8 |
0 |
Date of the Manufacture/Purchase |
|
9 |
ADDR_ID |
|
CMS_DTE_MOV_LOCATION |
AD_ADDRNUM |
CHAR |
10 |
0 |
Location / Address |
* |
10 |
MOV_LOC_DESC |
|
CMS_DTE_MOV_LOC_DESC |
CMS_ATT_ID_TYP |
CHAR |
6 |
0 |
Location Description |
|
11 |
MOV_LOC_DE_RMRK |
|
CMS_DTE_MOV_LOC_DESC_RMRK |
CMS_MOV_LOC_DESC_RMRK |
CHAR |
30 |
0 |
Remark Field for Location Description |
|
12 |
MOV_IDEN_TYP |
|
CMS_DTE_MOV_TYPE_IDENT |
CMS_ATT_ID_TYP |
CHAR |
6 |
0 |
Type of identification / Marking of the collateral material |
|
13 |
MOV_DESC_COL_MAT |
|
CMS_DTE_OMS_DESC_IDENT_COL_MAT |
CMS_OMS_DESC_COL_MAT |
CHAR |
30 |
0 |
Bank's Own Identifcation |
|
14 |
MOV_DOP |
|
CMS_DTE_MOV_DOP |
CMS_MOV_DOP |
DATS |
8 |
0 |
Date of Purchase |
|
15 |
MOV_IDENT |
|
CMS_DTE_MOV_IDENT |
CMS_MOV_IDENT |
CHAR |
2 |
0 |
Commercial usage |
|
16 |
MOV_UOB |
|
CMS_DTE_MOV_UOB |
CMS_ATT_ID_TYP |
CHAR |
6 |
0 |
Use of the object |
|
17 |
MOV_MANU_CNTRY |
|
CMS_DTE_MOV_MANU_CNTRY |
LAND1 |
CHAR |
3 |
0 |
Manufacturing Country |
* |
18 |
MOV_TYPE_FEAT |
|
CMS_DTE_MOV_TYPE_FEAT |
CMS_MOV_TYPE_FEAT |
CHAR |
6 |
0 |
Classification |
* |
19 |
EXT_ITM_NO |
|
CMS_DTE_OMS_EXT_ITM_NO |
CMS_OMS_ID |
CHAR |
40 |
0 |
Ext. Item no / Number for identification of the objects |
|
20 |
EXT_REFERENCE |
|
CMS_DTE_OMS_REF_ID |
CMS_OMS_REFID |
CHAR |
32 |
0 |
Reference number for the legacy system |
|
21 |
IS_TEMPLATE |
|
CMS_DTE_MOV_FLG_TEMPLATE |
CMS_MOV_FLG |
CHAR |
1 |
0 |
Type to be used as template |
|
22 |
TEMPLATE_ID |
|
CMS_DTE_MOV_TEMPLATE_ID |
SYSUUID |
RAW |
16 |
0 |
Template ID |
|
23 |
IDEN_ACC |
|
CMS_DTE_INV_IDEN_ACC |
CMS_SEC_FLG |
CHAR |
1 |
0 |
Identification land accessories |
|
24 |
BILL_NO |
|
CMS_DTE_INV_BILL_NO |
CMS_INV_BILL_NO |
CHAR |
20 |
0 |
Bill number of the inventory |
|
25 |
UNIT_PRICE |
|
CMS_DTE_INV_UNIT_PRICE |
CMS_AMOUNT |
CURR |
17 |
2 |
Unit Price |
|
26 |
UNIT_PRICE_CURR |
|
CMS_DTE_INV_UNIT_CURR |
WAERS |
CUKY |
5 |
0 |
Currency for unit price |
* |
27 |
TYPE_STK_EXCH |
|
CMS_DTE_INV_TYPE_STK_EXCH |
CMS_ATT_ID_TYP |
CHAR |
6 |
0 |
Type of stock exchange |
|
28 |
STK_EXCH_ID |
|
CMS_DTE_INV_STK_EXCH_ID |
CMS_ATT_ID_TYP |
CHAR |
6 |
0 |
Place of stock exchange |
|
29 |
RATE_FIX_DAT |
|
CMS_DTE_INV_RATE_FIX_DAT |
DATUM |
DATS |
8 |
0 |
Date of previous quotation |
|
30 |
DET_PRICE |
|
CMS_DTE_INV_DET_PRICE |
CMS_AMOUNT |
CURR |
17 |
2 |
Determined price |
|
31 |
DET_CURR |
|
CMS_DTE_INV_DET_CURR |
WAERS |
CUKY |
5 |
0 |
Currency for determined price |
* |
32 |
STOCK_QUANTITY |
|
CMS_DTE_INV_QTY |
CMS_QTY |
QUAN |
13 |
3 |
Quantity of inventory |
|
33 |
STOCK_UOM |
|
CMS_DTE_UNIT |
MEINS |
UNIT |
3 |
0 |
Unit of Measure of Quantity |
* |
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 |
* |
41 |
VALUATION_TYP |
|
CMS_DTE_IND_VALN_TYP |
CMS_VALN_TYP |
CHAR |
2 |
0 |
Type of Valuation Check performed on Collateral Object |
|
42 |
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 |
|
43 |
PERIOD_VALN_FREQ |
|
CMS_DTE_AST_VALN_FREQ_PERIOD |
CMS_AST_VALN_FREQ_PERIOD |
NUMC |
4 |
0 |
Revaluation Period for an Asset |
|
44 |
PAST_VALUED_DATE |
|
CMS_DTE_VALN_DATE |
CMS_DATE |
DATS |
8 |
0 |
Last Date on which the Asset was Valued |
|
45 |
START_DATE |
|
CMS_DTE_START_DATE |
CMS_DATE |
DATS |
8 |
0 |
Date on which the First Valuation is Performed on the Asset |
|
46 |
END_DATE |
|
CMS_DTE_END_DATE |
CMS_DATE |
DATS |
8 |
0 |
Date on which the Last Valuation is Performed on the Asset |
|
47 |
LENDING_RATE_IND |
|
CMS_DTE_IND_LND_RTE |
CMS_IND_LRTE |
CHAR |
2 |
0 |
Indicator to specify if Asset has a Default Lending Rate |
|
48 |
LENDING_RATE1 |
|
CMS_DTE_LRTE_PCT1 |
CMS_PCT |
DEC |
10 |
6 |
Lending Rate 1 |
|
49 |
LENDING_RATE2 |
|
CMS_DTE_LRTE_PCT2 |
CMS_PCT |
DEC |
10 |
6 |
Lending Rate 2 |
|
50 |
LENDING_RATE3 |
|
CMS_DTE_LRTE_PCT3 |
CMS_PCT |
DEC |
10 |
6 |
Lending Rate 3 |
|
51 |
LENDING_RATE4 |
|
CMS_DTE_LRTE_PCT4 |
CMS_PCT |
DEC |
10 |
6 |
Lending Rate 4 |
|
52 |
LENDING_RATE5 |
|
CMS_DTE_LRTE_PCT5 |
CMS_PCT |
DEC |
10 |
6 |
Lending Rate 5 |
|
53 |
LIQD_TYP |
|
CMS_DTE_LIQD_TYP |
CMS_TYP |
CHAR |
6 |
0 |
Liquidation Type |
|
54 |
LIQD_REASON |
|
CMS_DTE_ATT_ID_TY_AST004 |
CMS_ATT_ID_TYP |
CHAR |
6 |
0 |
Liquidation Reason |
|
55 |
LIQD_DATE |
|
CMS_DTE_LIQD_DATE |
CMS_DATE |
DATS |
8 |
0 |
Date on which the Collateral was Liquidated |
|
56 |
LIQD_AMT |
|
CMS_DTE_LIQD_VALUE |
CMS_AMOUNT |
CURR |
17 |
2 |
Returns from the Liquidation of Collateral |
|
57 |
LIQD_CURR |
|
CMS_DTE_LIQD_CURR |
WAERS |
CUKY |
5 |
0 |
Currency of Liquidation Value |
* |
58 |
ACC_NUMBER_LIQ |
|
CMS_DTE_LIQ_ACC_NUMBER |
BANKN35 |
CHAR |
35 |
0 |
Account number for liquidation proceeds |
|
59 |
BANK_CNTRY_LIQ |
|
CMS_DTE_LIQ_BNK_CTRY_KY |
LAND1 |
CHAR |
3 |
0 |
Bank country key |
* |
60 |
BANK_KEY_LIQ |
|
CMS_DTE_LIQ_BNK_KEY |
BANKK |
CHAR |
15 |
0 |
Bank Key |
|
61 |
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 |
|
62 |
PERIOD_VERF_FREQ |
|
CMS_DTE_AST_VERF_FREQ_PERIOD |
CMS_AST_VERF_FREQ_PERIOD |
NUMC |
4 |
0 |
Statement Period for an Asset |
|
63 |
LAST_VERF_DATE |
|
CMS_DTE_AST_VERF_DATE |
CMS_DATE |
DATS |
8 |
0 |
Last Verification Date |
|
64 |
NOM_VALUE |
|
CMS_DTE_AST_NOMINAL_VALUE |
CMS_AMOUNT |
CURR |
17 |
2 |
Nominal Value of the Asset |
|
65 |
NOM_VALUE_CURR |
|
CMS_DTE_AST_NOMINAL_VALUE_CURR |
WAERS |
CUKY |
5 |
0 |
Currency of Nominal value |
* |
66 |
AST_VALUE |
|
CMS_DTE_AST_VALUE |
CMS_AMOUNT |
CURR |
17 |
2 |
Final Asset Value |
|
67 |
AST_VALUE_CURR |
|
CMS_DTE_AST_VALUE_CURR |
WAERS |
CUKY |
5 |
0 |
Currency of the Final Asset Value |
* |
68 |
QUANTITY |
|
CMS_DTE_QTY |
CMS_QTY |
QUAN |
13 |
3 |
Quantity |
|
69 |
UNIT_OF_MEASURE |
|
CMS_DTE_UNIT |
MEINS |
UNIT |
3 |
0 |
Unit of Measure of Quantity |
* |
70 |
REC_AT |
|
CMS_DTE_REC_AT |
TZNTSTMPS |
DEC |
15 |
0 |
Asset Value Recording Timestamp |
|