1 |
.INCLUDE |
|
|
|
|
0 |
0 |
Movable Details - Vehicles, Devices & Aircraft |
|
2 |
MANDT |
|
MANDT |
MANDT |
CLNT |
3 |
0 |
Client |
T000 |
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 |
Common Movable data |
|
10 |
MOV_DESC |
|
CMS_DTE_MOV_DESC |
CMS_MOV_DESC |
CHAR |
30 |
0 |
Description of the object |
|
11 |
MOV_IDT_ACC |
|
CMS_DTE_MOV_IDT_ACC |
CMS_MOV_IDT_ACC |
CHAR |
1 |
0 |
Identification accessories |
|
12 |
.INCLUDE |
|
|
|
|
0 |
0 |
Object Specific Features for Description |
|
13 |
MOV_MODEL_NAM |
|
CMS_DTE_MOV_MODEL_NAM |
CMS_MOV_MODEL_NAM |
CHAR |
30 |
0 |
Technical Category/Category term/Description |
|
14 |
MOV_MANUFACTURER |
|
CMS_DTE_MOV_MANUFACTURER |
CMS_MOV_MANUFACTURER |
CHAR |
30 |
0 |
Object Manufacturer Builder |
|
15 |
MOV_MANU_DAT |
|
CMS_DTE_MOV_MANU_DAT |
CMS_MOV_MANU_DAT |
DATS |
8 |
0 |
Date of the Manufacture/Purchase |
|
16 |
ADDR_ID |
|
CMS_DTE_MOV_LOCATION |
AD_ADDRNUM |
CHAR |
10 |
0 |
Location / Address |
* |
17 |
MOV_LOC_DESC |
|
CMS_DTE_MOV_LOC_DESC |
CMS_ATT_ID_TYP |
CHAR |
6 |
0 |
Location Description |
TCMS_ATT_ID_TY |
18 |
MOV_LOC_DE_RMRK |
|
CMS_DTE_MOV_LOC_DESC_RMRK |
CMS_MOV_LOC_DESC_RMRK |
CHAR |
30 |
0 |
Remark Field for Location Description |
|
19 |
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 |
20 |
MOV_DESC_COL_MAT |
|
CMS_DTE_OMS_DESC_IDENT_COL_MAT |
CMS_OMS_DESC_COL_MAT |
CHAR |
30 |
0 |
Bank's Own Identifcation |
|
21 |
MOV_DOP |
|
CMS_DTE_MOV_DOP |
CMS_MOV_DOP |
DATS |
8 |
0 |
Date of Purchase |
|
22 |
MOV_IDENT |
|
CMS_DTE_MOV_IDENT |
CMS_MOV_IDENT |
CHAR |
2 |
0 |
Commercial usage |
|
23 |
MOV_UOB |
|
CMS_DTE_MOV_UOB |
CMS_ATT_ID_TYP |
CHAR |
6 |
0 |
Use of the object |
TCMS_ATT_ID_TY |
24 |
MOV_MANU_CNTRY |
|
CMS_DTE_MOV_MANU_CNTRY |
LAND1 |
CHAR |
3 |
0 |
Manufacturing Country |
T005 |
25 |
MOV_TYPE_FEAT |
|
CMS_DTE_MOV_TYPE_FEAT |
CMS_MOV_TYPE_FEAT |
CHAR |
6 |
0 |
Classification |
TCMS_OMS_FEAT |
26 |
.INCLUDE |
|
|
|
|
0 |
0 |
Common OMS data |
|
27 |
EXT_ITM_NO |
|
CMS_DTE_OMS_EXT_ITM_NO |
CMS_OMS_ID |
CHAR |
40 |
0 |
Ext. Item no / Number for identification of the objects |
|
28 |
EXT_REFERENCE |
|
CMS_DTE_OMS_REF_ID |
CMS_OMS_REFID |
CHAR |
32 |
0 |
Reference number for the legacy system |
|
29 |
.INCLUDE |
|
|
|
|
0 |
0 |
Template Information |
|
30 |
IS_TEMPLATE |
|
CMS_DTE_MOV_FLG_TEMPLATE |
CMS_MOV_FLG |
CHAR |
1 |
0 |
Type to be used as template |
|
31 |
TEMPLATE_ID |
|
CMS_DTE_MOV_TEMPLATE_ID |
SYSUUID |
RAW |
16 |
0 |
Template ID |
|
32 |
.INCLUDE |
|
|
|
|
0 |
0 |
Devices Data |
|
33 |
.INCLUDE |
|
|
|
|
0 |
0 |
Devices data |
|
34 |
DEV_COUNTRY_KEY |
|
CMS_DTE_MOV_COUNTRY_KEY |
LAND1 |
CHAR |
3 |
0 |
Country Key |
T005 |
35 |
DEV_MAC_NO |
|
CMS_DTE_MOV_MACHINE_NO |
CMS_MOV_ID |
CHAR |
40 |
0 |
External Item Number - Machine number |
|
36 |
.INCLUDE |
|
|
|
|
0 |
0 |
Aircraft data |
|
37 |
.INCLUDE |
|
|
|
|
0 |
0 |
Aircraft data |
|
38 |
ACR_DELVDAT |
|
CMS_DTE_MOV_DELVDAT |
CMS_MOV_DELVDAT |
DATS |
8 |
0 |
Delivery Date |
|
39 |
ACR_REG |
|
CMS_DTE_MOV_REG |
CMS_MOV_REG |
CHAR |
1 |
0 |
Registered |
|
40 |
ACR_REGC |
|
CMS_DTE_MOV_REGC |
LAND1 |
CHAR |
3 |
0 |
Registration Country |
T005 |
41 |
ACR_REGM |
|
CMS_DTE_MOV_REGM |
CMS_MOV_REGM |
CHAR |
6 |
0 |
Registration Mark |
|
42 |
ACR_RC |
|
CMS_DTE_MOV_RC |
CMS_MOV_RC |
CHAR |
30 |
0 |
Registration Comments |
|
43 |
ACR_EMAN |
|
CMS_DTE_MOV_EMAN |
CMS_MOV_EMAN |
CHAR |
30 |
0 |
Engine Manufacturer |
|
44 |
ACR_EMOD |
|
CMS_DTE_MOV_EMOD |
CMS_MOV_EMOD |
CHAR |
12 |
0 |
Engine Model |
|
45 |
ACR_EPOOL |
|
CMS_DTE_MOV_EPOOL |
CMS_MOV_EPOOL |
CHAR |
10 |
0 |
Engine pooling |
|
46 |
ACR_EPRMK |
|
CMS_DTE_MOV_EPRMK |
CMS_MOV_EPRMK |
CHAR |
30 |
0 |
Engine pooling remarks |
|
47 |
ACR_NOE |
|
CMS_DTE_MOV_NOE |
CMS_MOV_NOE |
INT4 |
10 |
0 |
Number of Engines |
|
48 |
ACR_NAME |
|
CMS_DTE_MOV_OM |
CMS_MOV_OM |
CHAR |
30 |
0 |
Object name |
|
49 |
ACR_MTOW |
|
CMS_DTE_MOV_MTOW |
CMS_MOV_MTOW |
QUAN |
13 |
3 |
Maximum take-off weight |
|
50 |
ACR_MTOW_UNT |
|
CMS_DTE_MOV_MTOW_UNT |
MEINS |
UNIT |
3 |
0 |
Maximum take off weight (Unit) |
T006 |
51 |
ACR_NOB |
|
CMS_DTE_MOV_NOB |
CMS_MOV_NOB |
INT1 |
3 |
0 |
Number of objects |
|
52 |
ACR_MSNNO |
|
CMS_DTE_MOV_MSNNO |
CMS_MOV_MSNNO |
CHAR |
10 |
0 |
MSN Number |
|
53 |
.INCLUDE |
|
|
|
|
0 |
0 |
Rating |
|
54 |
ACR_RATCLS |
|
CMS_DTE_MOV_RATCLS |
CMS_ATT_ID_TYP |
CHAR |
6 |
0 |
Rating Class |
TCMS_ATT_ID_TY |
55 |
ACR_RATD |
|
CMS_DTE_MOV_RATD |
CMS_MOV_RATD |
DATS |
8 |
0 |
Rating Date |
|
56 |
.INCLUDE |
|
|
|
|
0 |
0 |
Vehicles data |
|
57 |
.INCLUDE |
|
|
|
|
0 |
0 |
Vehicles data |
|
58 |
PERM_WGHT |
|
CMS_DTE_MOV_PERM_WGHT |
CMS_PERM_WGHT |
QUAN |
13 |
3 |
Maximum Permissible Weight |
|
59 |
PERM_WGHT_UNT |
|
CMS_DTE_MOV_PERM_WGHT_UNT |
MEINS |
UNIT |
3 |
0 |
Unit of the quantity |
T006 |
60 |
PLACE_LIC |
|
CMS_DTE_MOV_PLACE_LIC |
CMS_PLACE_LIC |
CHAR |
30 |
0 |
Place of Registration |
|
61 |
VEH_REG_NO |
|
CMS_DTE_MOV_REG_NO |
CMS_REG_NO |
CHAR |
30 |
0 |
Vehicle registration mark |
|
62 |
OFF_IDENT |
|
CMS_DTE_MOV_OFF_IDENT |
CMS_VEH_OFF_IDENT |
CHAR |
30 |
0 |
Identification of the registration certificate |
|
63 |
CHAIS_NO |
|
CMS_DTE_MOV_CHASIS_NO |
CMS_MOV_DESC |
CHAR |
30 |
0 |
Chassis Number |
|
64 |
.INCLUDE |
|
|
|
|
0 |
0 |
Inventory Specific details |
|
65 |
IDEN_ACC |
|
CMS_DTE_INV_IDEN_ACC |
CMS_SEC_FLG |
CHAR |
1 |
0 |
Identification land accessories |
|
66 |
BILL_NO |
|
CMS_DTE_INV_BILL_NO |
CMS_INV_BILL_NO |
CHAR |
20 |
0 |
Bill number of the inventory |
|
67 |
UNIT_PRICE |
|
CMS_DTE_INV_UNIT_PRICE |
CMS_AMOUNT |
CURR |
17 |
2 |
Unit Price |
|
68 |
UNIT_PRICE_CURR |
|
CMS_DTE_INV_UNIT_CURR |
WAERS |
CUKY |
5 |
0 |
Currency for unit price |
TCURC |
69 |
TYPE_STK_EXCH |
|
CMS_DTE_INV_TYPE_STK_EXCH |
CMS_ATT_ID_TYP |
CHAR |
6 |
0 |
Type of stock exchange |
TCMS_ATT_ID_TY |
70 |
STK_EXCH_ID |
|
CMS_DTE_INV_STK_EXCH_ID |
CMS_ATT_ID_TYP |
CHAR |
6 |
0 |
Place of stock exchange |
TCMS_ATT_ID_TY |
71 |
RATE_FIX_DAT |
|
CMS_DTE_INV_RATE_FIX_DAT |
DATUM |
DATS |
8 |
0 |
Date of previous quotation |
|
72 |
DET_PRICE |
|
CMS_DTE_INV_DET_PRICE |
CMS_AMOUNT |
CURR |
17 |
2 |
Determined price |
|
73 |
DET_CURR |
|
CMS_DTE_INV_DET_CURR |
WAERS |
CUKY |
5 |
0 |
Currency for determined price |
TCURC |
74 |
STOCK_QUANTITY |
|
CMS_DTE_INV_QTY |
CMS_QTY |
QUAN |
13 |
3 |
Quantity of inventory |
|
75 |
STOCK_UOM |
|
CMS_DTE_UNIT |
MEINS |
UNIT |
3 |
0 |
Unit of Measure of Quantity |
T006 |
76 |
.INCLUDE |
|
|
|
|
0 |
0 |
Administrative organization unit |
|
77 |
ADMIN_ORG_UNIT |
|
CMS_DTE_ADMINORG |
TEXT12 |
CHAR |
12 |
0 |
Administration Organizational Unit |
|
78 |
.INCLUDE |
|
|
|
|
0 |
0 |
Bank area |
|
79 |
BANKAREA |
|
CMS_DTE_BANKAREA |
CMS_BANKAREA |
CHAR |
4 |
0 |
Bank Area in Collateral Management |
* |
80 |
.INCLUDE |
|
|
|
|
0 |
0 |
Stucture to record history of changes in all application tab |
|
81 |
CREATED_BY |
|
CMS_DTE_USER |
CMS_USER |
CHAR |
12 |
0 |
Login ID of the User who created the Record |
|
82 |
CREATED_AT |
|
CMS_DTE_CREATED_AT |
TZNTSTMPS |
DEC |
15 |
0 |
Creation Timestamp |
|
83 |
CHANGED_BY |
|
CMS_DTE_LAST_CHNG_USER |
CMS_USER |
CHAR |
12 |
0 |
Last Changed By |
|
84 |
CHANGED_AT |
|
CMS_DTE_CHANGED_AT |
TZNTSTMPS |
DEC |
15 |
0 |
Change Timestamp |
|
85 |
SOURCEOFENTRY |
|
CMS_DTE_SOURCE_OF_ENTRY |
CMS_SOURCE |
CHAR |
32 |
0 |
Source of Entry |
|
86 |
.INCLUDE |
|
|
|
|
0 |
0 |
Structures for generating change document update programs |
|
87 |
KZ |
|
CDCHNGIND |
CDCHNGIND |
CHAR |
1 |
0 |
Change type (U, I, E, D) |
|