SAP ABAP Table CMS_STR_COR_MOV_REQ (OMS:Movables general)
Hierarchy
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   FS-CMS (Application Component) Collateral Management System
     CMS_COR (Package) Correspondence serivce for CMS
Basic Data
Table Category INTTAB    Structure 
Structure CMS_STR_COR_MOV_REQ   Table Relationship Diagram
Short Description OMS:Movables general    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 WA_MOV_GEN DFKKCOH   STRU 0   0    
2 MANDT MANDT MANDT CLNT 3   0   Client  
3 COTYP COTYP_KK COTYP_KK CHAR 4   0   Correspondence Type  
4 COKEY COKEY_KK COKEY_KK CHAR 36   0   Correspondence key  
5 UNAME SYUNAME SYCHAR12 CHAR 12   0   User Name  
6 CDATE COCDT_KK SYDATS DATS 8   0   Created On  
7 CTIME COCTM_KK SYTIME TIMS 6   0   Time of Creation (to the Second)  
8 GPART CREC_GP_KK BU_PARTNER CHAR 10   0   Correspondence Recipient  
9 GPART_GUID CREC_GP_GUID_KK SYSUUID_C CHAR 32   0   Correspondence Recipient (GUID)  
10 GPART_ADR_KIND CORR_ADR_KIND_KK BU_ADRKIND CHAR 10   0   Address Type Of Correspondence Recipient  
11 ORG_GPART CREC_ORG_GP_KK BU_PARTNER CHAR 10   0   Original Correspondence Recipient  
12 ORG_GPART_GUID CREC_ORG_GP_GUID_KK SYSUUID_C CHAR 32   0   Original Correspondence Recipient (GUID)  
13 ADD_GPART CREC_GP_ADD_KK BU_PARTNER CHAR 10   0   Additional Business Partner for Correspondence Recipient  
14 ADD_GPART_GUID CREC_GP_ADD_GUID_KK SYSUUID_C CHAR 32   0   Addit. Business Partner for Correspondence Recipient GUID  
15 ADD_GPART_CAT CREC_GP_ADD_CAT_KK CORR_CREC_ADD_CAT_KK CHAR 1   0   Type of Additional Correspondence Recipient  
16 VKONT CORR_VKONT_KK CORR_VKONT_KK CHAR 12   0   Contract Account Number  
17 VTREF CORR_VTREF_KK CORR_VTREF_KK CHAR 20   0   Reference Specifications from Contract  
18 ADR_VALID_ON CREC_AD_VALID_ON_KK TZNTSTMPS DEC 15   0   Address of Correspondence Recipient Valid On  
19 ADRNR CREC_AD_KK AD_ADDRNUM CHAR 10   0   Address Number of Correspondence Recipient  
20 ADR_GUID CREC_AD_GUID_KK SYSUUID_C CHAR 32   0   Address GUID of Correspondence Recipient  
21 ADRNR_INDEP_COMM CREC_AD_INDEP_COMM_KK AD_ADDRNUM CHAR 10   0   Address Number for Address-Independent Communication  
22 AGPART CSEN_GP_KK BU_PARTNER CHAR 10   0   Sending Business Partner  
23 AGPART_GUID CSEN_GP_GUID_KK SYSUUID_C CHAR 32   0   Sender (GUID)  
24 AGPART_ADR_KIND CORR_ADR_KIND_KK BU_ADRKIND CHAR 10   0   Address Type Of Correspondence Recipient  
25 AADRNR CSEN_AD_KK AD_ADDRNUM CHAR 10   0   Address Number of Correspondence Sender  
26 AADR_GUID CSEN_AD_GUID_KK SYSUUID_C CHAR 32   0   Address GUID of Correspondence Sender  
27 FORMKEY FORMKEY FORMKEY CHAR 30   0   Application form  
28 FORMKEY_RDI FORMKEY FORMKEY CHAR 30   0   Application form  
29 ENTID1 ENTID_KK ENTID_KK CHAR 4   0   Correspondence data  
30 DATA1 CDATA_KK CDATA_KK CHAR 32   0   Correspondence Data Field  
31 ENTID2 ENTID_KK ENTID_KK CHAR 4   0   Correspondence data  
32 DATA2 CDATA_KK CDATA_KK CHAR 32   0   Correspondence Data Field  
33 ENTID3 ENTID_KK ENTID_KK CHAR 4   0   Correspondence data  
34 DATA3 CDATA_KK CDATA_KK CHAR 32   0   Correspondence Data Field  
35 ENTID4 ENTID_KK ENTID_KK CHAR 4   0   Correspondence data  
36 DATA4 CDATA_KK CDATA_KK CHAR 32   0   Correspondence Data Field  
37 CSORT CSORT_KK CORR_TXT50 CHAR 50   0   Correspondence Sort Field  
38 XCODT XCODT_KK XFELD CHAR 1   0   Data Part Is Used  
39 XCODT_CLUST XCODT_CLUST_KK XFELD CHAR 1   0   Cluster Data Part is Used  
40 LAUFD CORR_LAUFD_KK DATUM DATS 8   0   Date ID for Creation Run  
41 LAUFI CORR_LAUFI_KK CORR_LAUFI_KK CHAR 6   0   Additional ID Characteristic for Creation Run  
42 XTEST XTEST_KK XFELD CHAR 1   0   Correspondence is Result of Test  
43 COPRI COPRI_KK SYDATS DATS 8   0   Print Date  
44 COIDT COIDT_KK SYDATS DATS 8   0   Date of Issue  
45 COITM COITM_KK SYTIME TIMS 6   0   Issue Time to the Second  
46 SPRAS SPRAS SPRAS LANG 1   0   Language Key  
47 SALWA CORR_BLWAE_KK WAERS CUKY 5   0   Transaction Currency  
48 SALBE CORR_BETRH_KK WRTV7 CURR 13   2   Amount in Local Currency with +/- Signs  
49 SENDCONTROL SENDCONTROL ESENDCONTROL CHAR 4   0   Dispatch Control  
50 PERSNUMBER AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number  
51 APERSNUMBER AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number  
52 BUKRS CORR_BUKRS CORR_BUKRS CHAR 4   0   Company Code in Correspondence  
53 CORR_ROLE CORR_ROLE_KK CORR_ROLE_KK CHAR 4   0   Correspondence Roles  
54 COPRI_LAUFD COPRI_LAUFD_KK DATUM DATS 8   0   Date ID for Print Run  
55 COPRI_LAUFI COPRI_LAUFID_KK COPRI_LAUFID_KK CHAR 6   0   ID Characteristic for Run  
56 PROCESS_ID_ CORR_PROCESS_ID_KK   CHAR 36   0   Business Process ID  
57 NO_DOCPARTS CORR_NO_DOCPARTS_KK   NUMC 4   0   Number of Document Parts  
58 DOCPART_ROLE CORR_DOCPART_ROLE_KK CORR_DOCPART_ROLE_KK CHAR 1   0   Document Part Role  
59 XTRIAL XTRIAL_KK XFELD CHAR 1   0   Correspondence Request is Test  
60 XREPRINT XREPRINT_KK XFELD CHAR 1   0   Recreate Correspondence  
61 .INCLUDE       0   0    
62 SUBAP CORR_SUBAP_KK CORR_SUBAP_KK CHAR 1   0   Subapplication Indicator in Correspondence  
63 XDELETE X_CORR_DELETE_KK XFELD CHAR 1   0   Correspondence Is Logically Deleted  
64 PRINT_MODE PRINT_MODE_KK BU_PRINT_MODE CHAR 1   0   Business Partner Print Format  
65 X_NO_ARC X_NO_ARC_KK XFELD CHAR 1   0   SAP ArchiveLink Object ID Part Is Not Used  
66 X_DOCPART_LIST X_DOCPART_LIST_KK XFELD CHAR 1   0   Document Part List Is Used  
67 .INCLU--AP       0   0   CMS appends for DFKKCOH  
68 .INCLU-CMS       0   0   CMS include for DFKKCOH  
69 OBJECT_IDCMS CMS_DTE_OBJECT_ID SYSUUID RAW 16   0   Object Identification Number  
70 FLG_ORIGINALCMS CMS_DTE_FLG_ORIG CMS_FLG CHAR 1   0   Flag to indicate if the document is original or duplicate  
71 SENDCONTROLCMS SENDCONTROL ESENDCONTROL CHAR 4   0   Dispatch Control  
72 .INCLU--AP       0   0   Loans Append for DFKKCOH  
73 .INCLU-FVD       0   0   Loans Include for DFKKCOH  
74 PRODUCTTYPEFVD VVSART VVSART CHAR 3   0   Product Type  
75 BP_ROLEFVD BU_PARTNERROLE BU_ROLE CHAR 6   0   BP Role  
76 BP_ROLETYPEFVD BP_ROLE BP_ROLE CHAR 4   0   Business Partner Role Type  
77 SOBJECTFVD VVKEYOBJ VVKEY CHAR 10   0   Internal key for object  
78 CORR_ACTIVITYFVD KORRVORF KORRVORF NUMC 4   0   Correspondence activity  
79 REFERENCEDATEFVD TB_CORR_REFERENCE_DATE DATUM DATS 8   0   Reference Date for Creating Correspondence  
80 WA_RECEIVER CMS_STR_BPID   STRU 0   0    
81 BU_PARTNERID CMS_DTE_BPID CMS_BPID CHAR 32   0   Business Partner Identification Number  
82 BP_DESCRIPTION CMS_DTE_BP_ADDR_DESC CMS_BP_ADDR_DESC CHAR 60   0   Address description of Business Partner  
83 WA_SENDER P1028   STRU 0   0    
84 .INCLUDE       0   0   Key Structure for Infotype Structures PNNNN  
85 MANDT MANDT MANDT CLNT 3   0   Client  
86 PLVAR PLVAR PLVAR CHAR 2   0   Plan Version  
87 OTYPE OTYPE OTYPE CHAR 2   0   Object Type  
88 OBJID OBJEKTID NUM08 NUMC 8   0   Object ID  
89 INFTY INFOTYP INFOTYP CHAR 4   0   Infotype  
90 SUBTY SUBTYP SUBTYP CHAR 4   0   Subtype  
91 ISTAT ISTAT_D ISTAT CHAR 1   0   Planning Status  
92 PRIOX PRIOX CHAR2 CHAR 2   0   Priority  
93 BEGDA BEGDATUM DATUM DATS 8   0   Start Date  
94 ENDDA ENDDATUM DATUM DATS 8   0   End Date  
95 VARYF VARYF CHAR10 CHAR 10   0   Variation Field for File PLOG  
96 SEQNR SEQNR NUM03 NUMC 3   0   Number of Infotype Record With Same Key  
97 .INCLUDE       0   0   Infotype Administration Data  
98 AEDTM AEDTM DATUM DATS 8   0   Changed on  
99 UNAME USRNAME CHAR12 CHAR 12   0   User Name  
100 REASN REASN CHAR2 CHAR 2   0   Reason  
101 HISTO HISTO CHAR1 CHAR 1   0   Historical Record Flag  
102 ITXNR ITXNR NUM08 NUMC 8   0   Text Module for Infotype  
103 .INCLUDE       0   0   Infotype 1028 Fields  
104 CNAME CNAME TEXT25 CHAR 25   0   Address Supplement (c/o)  
105 STRAS PD_STRAS TEXT30 CHAR 30   0   House Number and Street  
106 ORT01 KORT TEXT40 CHAR 40   0   City  
107 PSTLZ PD_PSTLZ PSTLZ CHAR 10   0   Postal Code  
108 LAND1 KLAND LAND1 CHAR 3   0   Country  
109 TELNR TELENR CHAR25 CHAR 25   0   Telephone Number  
110 FAXNR FAXNR CHAR25 CHAR 25   0   Fax Number  
111 ENTKM ENTKM DEC3 DEC 3   0   Distance in Kilometers  
112 BUILD BUILD BUILD CHAR 8   0   Building  
113 ROOM1 ROOM1 CHAR8 CHAR 8   0   Physical Room Number  
114 ADRNR ADRNR ADRNR CHAR 10   0   Address  
115 REGIO REGIO REGIO CHAR 3   0   Region (State, Province, County)  
116 STRS2 STRAS_GP TEXT35 CHAR 35   0   House number and street  
117 HAUSN HAUSN_BAS CHAR6 CHAR 6   0   House number  
118 .INCLUDE       0   0    
119 WA_MOV_ADDR CMS_STR_MOV_ADDR_MAP_GET_MLT   STRU 0   0    
120 .INCLUDE       0   0   Primary Key for CMS_MOVABLES  
121 MOV_GUID CMS_DTE_MOV_GUID SYSUUID RAW 16   0   GUID for CMS_MOVABLES  
122 .INCLUDE       0   0   Semantic Key  
123 MOV_CATEGORY CMS_DTE_OMS_OBJ_CAT CMS_OBJ_CAT CHAR 6   0   Object Category  
124 MOV_TYP CMS_DTE_MOV_TYP CMS_MOV_TYP CHAR 6   0   Movable types  
125 MOV_ID CMS_DTE_MOV_ID CMS_MOV_ID CHAR 40   0   Identification Number  
126 .INCLUDE       0   0   Address details  
127 .INCLUDE       0   0   Address return structure  
128 .INCLUDE       0   0   Address selection parameter  
129 ADDRNUMBER AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number  
130 ADDRHANDLE AD_HANDLE TEXT140 CHAR 140   0   Handle for Creating Addresses/Persons (Bus. Addr. Services)  
131 NATION AD_NATION AD_NATION CHAR 1   0   Version ID for International Addresses  
132 DATE AD_DATE DATUM DATS 8   0   Date referred to  
133 .INCLUDE       0   0   Address transfer structure  
134 DATE_FROM AD_DATE_FR DATUM DATS 8   0   Valid-from date - in current Release only 00010101 possible  
135 DATE_TO AD_DATE_TO DATUM DATS 8   0   Valid-to date in current Release only 99991231 possible  
136 .INCLUDE       0   0   Include structure with name attributes of the ADRC address  
137 TITLE AD_TITLE AD_TITLE CHAR 4   0   Form-of-Address Key  
138 NAME1 AD_NAME1 TEXT40 CHAR 40   0   Name 1  
139 NAME2 AD_NAME2 TEXT40 CHAR 40   0   Name 2  
140 NAME3 AD_NAME3 TEXT40 CHAR 40   0   Name 3  
141 NAME4 AD_NAME4 TEXT40 CHAR 40   0   Name 4  
142 NAME_TXT AD_NAMETXT TEXT50 CHAR 50   0   Converted name field (with form of address)  
143 .INCLUDE       0   0   Include structure with ADRC attributes without name fields  
144 NAME_CO AD_NAME_CO TEXT40 CHAR 40   0   c/o name  
145 CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
146 CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
147 CITY_CODE AD_CITYNUM CITY_CODE CHAR 12   0   City code for city/street file  
148 CITYP_CODE AD_CITYPNM CITYP_CODE CHAR 8   0   District code for City and Street file  
149 HOME_CITY AD_CITY3 TEXT40 CHAR 40   0   City (different from postal city)  
150 CITYH_CODE AD_CITYHNM CITY_CODE CHAR 12   0   Different city for city/street file  
151 CHCKSTATUS AD_CHECKST AD_CHECKST CHAR 1   0   City file test status  
152 REGIOGROUP REGIOGROUP REGIOGROUP CHAR 8   0   Regional structure grouping  
153 POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
154 POST_CODE2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
155 POST_CODE3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
156 PCODE1_EXT AD_PST1XT CHAR10 CHAR 10   0   (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code  
157 PCODE2_EXT AD_PST2XT CHAR10 CHAR 10   0   (Not Supported) PO Box Postal Code Extension  
158 PCODE3_EXT AD_PST3XT CHAR10 CHAR 10   0   (Not Supported) Major Customer Postal Code Extension  
159 PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
160 DONT_USE_P AD_NO_USEP AD_NO_USE CHAR 4   0   PO Box Address Undeliverable Flag  
161 PO_BOX_NUM AD_POBXNUM XFELD CHAR 1   0   Flag: PO Box without number  
162 PO_BOX_LOC AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
163 CITY_CODE2 AD_CIT2NUM CITY_CODE CHAR 12   0   City PO box code (City file)  
164 PO_BOX_REG AD_POBXREG REGIO CHAR 3   0   Region for PO Box (Country, State, Province, ...)  
165 PO_BOX_CTY AD_POBXCTY LAND1 CHAR 3   0   PO box country  
166 POSTALAREA AD_PSTLAR TEXT15 CHAR 15   0   (Not Supported) Post Delivery District  
167 TRANSPZONE LZONE ZONE CHAR 10   0   Transportation zone to or from which the goods are delivered  
168 STREET AD_STREET TEXT60 CHAR 60   0   Street  
169 DONT_USE_S AD_NO_USES AD_NO_USE CHAR 4   0   Street Address Undeliverable Flag  
170 STREETCODE AD_STRNUM STRT_CODE CHAR 12   0   Street Number for City/Street File  
171 STREETABBR AD_STRABBR STRTYPEAB CHAR 2   0   (Not Supported) Abbreviation of Street Name  
172 HOUSE_NUM1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
173 HOUSE_NUM2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
174 HOUSE_NUM3 AD_HSNM3 TEXT10 CHAR 10   0   (Not supported) House Number Range  
175 STR_SUPPL1 AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
176 STR_SUPPL2 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
177 STR_SUPPL3 AD_STRSPP3 TEXT40 CHAR 40   0   Street 4  
178 LOCATION AD_LCTN TEXT40 CHAR 40   0   Street 5  
179 BUILDING AD_BLDNG TEXT20 CHAR 20   0   Building (Number or Code)  
180 FLOOR AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
181 ROOMNUMBER AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
182 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key  
183 LANGU SPRAS SPRAS LANG 1   0   Language Key  
184 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County)  
185 SORT1 AD_SORT1UL TEXT20 CHAR 20   0   Search Term 1  
186 SORT2 AD_SORT2UL TEXT20 CHAR 20   0   Search Term 2  
187 SORT_PHN AD_SRTPHN CHAR20 CHAR 20   0   (Not Supported) Phonetic Search Sort Field  
188 ADDRORIGIN AD_ORIGINA AD_ORIGIN CHAR 4   0   (Not Supported) Address Data Source (Key)  
189 EXTENSION1 AD_EXTENS1 TEXT40 CHAR 40   0   Extension (only for data conversion) (e.g. data line)  
190 EXTENSION2 AD_EXTENS2 TEXT40 CHAR 40   0   Extension (only for data conversion) (e.g. telebox)  
191 TIME_ZONE AD_TZONE TZNZONE CHAR 6   0   Address time zone  
192 TAXJURCODE AD_TXJCD AD_TXJCD CHAR 15   0   Tax Jurisdiction  
193 ADDRESS_ID AD_ADDR_ID AD_ADDR_ID CHAR 10   0   (Not supported) Physical address ID  
194 REMARK AD_REMARK1 TEXT50 CHAR 50   0   Address notes  
195 LANGU_CREA AD_LANGUCR SPRAS LANG 1   0   Address record creation original language  
196 PO_BOX_LOBBY AD_PO_BOX_LBY TEXT40 CHAR 40   0   PO Box Lobby  
197 DELI_SERV_TYPE AD_DELIVERY_SERVICE_TYPE AD_DELIVERY_SERVICE_TYPE CHAR 4   0   Type of Delivery Service  
198 DELI_SERV_NUMBER AD_DELIVERY_SERVICE_NUMBER CHAR10 CHAR 10   0   Number of Delivery Service  
199 COUNTY_CODE AD_CNTYNUM CNTY_CODE CHAR 8   0   County code for county  
200 COUNTY AD_COUNTY TEXT40 CHAR 40   0   County  
201 TOWNSHIP_CODE AD_TWSHPNUM TWSHP_CODE CHAR 8   0   Township code for Township  
202 TOWNSHIP AD_TOWNSHIP TEXT40 CHAR 40   0   Township  
203 DEFLT_COMM AD_COMM AD_COMM CHAR 3   0   Communication Method (Key) (Business Address Services)  
204 TEL_NUMBER AD_TLNMBR1 CHAR30 CHAR 30   0   First telephone no.: dialling code+number  
205 TEL_EXTENS AD_TLXTNS1 CHAR10 CHAR 10   0   First Telephone No.: Extension  
206 FAX_NUMBER AD_FXNMBR1 CHAR30 CHAR 30   0   First fax no.: dialling code+number  
207 FAX_EXTENS AD_FXXTNS1 CHAR10 CHAR 10   0   First fax no.: extension  
208 ADDR_GROUP AD_GROUP AD_GROUP CHAR 4   0   Address Group (Key) (Business Address Services)  
209 WA_MOV_OTH CMS_STR_OTH_OBJ_MAP_GET_MLT   STRU 0   0    
210 .INCLUDE       0   0   Primary Key for CMS_MOVABLES  
211 MOV_GUID CMS_DTE_MOV_GUID SYSUUID RAW 16   0   GUID for CMS_MOVABLES  
212 .INCLUDE       0   0   Semantic Key  
213 MOV_CATEGORY CMS_DTE_OMS_OBJ_CAT CMS_OBJ_CAT CHAR 6   0   Object Category  
214 MOV_TYP CMS_DTE_MOV_TYP CMS_MOV_TYP CHAR 6   0   Movable types  
215 MOV_ID CMS_DTE_MOV_ID CMS_MOV_ID CHAR 40   0   Identification Number  
216 MOV_CAT_NAME CMS_DTE_OMS_CAT_NAME CMS_OMS_CAT_NAME CHAR 40   0   Object Category Name  
217 MOV_TYP_NAME CMS_DTE_MOV_TYP_NAME CMS_MOV_NAME CHAR 40   0   Name in a specified language  
218 .INCLUDE       0   0   Common Movable data  
219 MOV_DESC CMS_DTE_MOV_DESC CMS_MOV_DESC CHAR 30   0   Description of the object  
220 MOV_IDT_ACC CMS_DTE_MOV_IDT_ACC CMS_MOV_IDT_ACC CHAR 1   0   Identification accessories  
221 .INCLUDE       0   0   Object Specific Features for Description  
222 MOV_MODEL_NAM CMS_DTE_MOV_MODEL_NAM CMS_MOV_MODEL_NAM CHAR 30   0   Technical Category/Category term/Description  
223 MOV_MANUFACTURER CMS_DTE_MOV_MANUFACTURER CMS_MOV_MANUFACTURER CHAR 30   0   Object Manufacturer Builder  
224 MOV_MANU_DAT CMS_DTE_MOV_MANU_DAT CMS_MOV_MANU_DAT DATS 8   0   Date of the Manufacture/Purchase  
225 ADDR_ID CMS_DTE_MOV_LOCATION AD_ADDRNUM CHAR 10   0   Location / Address  
226 MOV_LOC_DESC CMS_DTE_MOV_LOC_DESC CMS_ATT_ID_TYP CHAR 6   0   Location Description  
227 MOV_LOC_DE_RMRK CMS_DTE_MOV_LOC_DESC_RMRK CMS_MOV_LOC_DESC_RMRK CHAR 30   0   Remark Field for Location Description  
228 MOV_IDEN_TYP CMS_DTE_MOV_TYPE_IDENT CMS_ATT_ID_TYP CHAR 6   0   Type of identification / Marking of the collateral material  
229 MOV_DESC_COL_MAT CMS_DTE_OMS_DESC_IDENT_COL_MAT CMS_OMS_DESC_COL_MAT CHAR 30   0   Bank's Own Identifcation  
230 MOV_DOP CMS_DTE_MOV_DOP CMS_MOV_DOP DATS 8   0   Date of Purchase  
231 MOV_IDENT CMS_DTE_MOV_IDENT CMS_MOV_IDENT CHAR 2   0   Commercial usage  
232 MOV_UOB CMS_DTE_MOV_UOB CMS_ATT_ID_TYP CHAR 6   0   Use of the object  
233 MOV_MANU_CNTRY CMS_DTE_MOV_MANU_CNTRY LAND1 CHAR 3   0   Manufacturing Country  
234 MOV_TYPE_FEAT CMS_DTE_MOV_TYPE_FEAT CMS_MOV_TYPE_FEAT CHAR 6   0   Classification  
235 .INCLUDE       0   0   Common OMS data  
236 EXT_ITM_NO CMS_DTE_OMS_EXT_ITM_NO CMS_OMS_ID CHAR 40   0   Ext. Item no / Number for identification of the objects  
237 EXT_REFERENCE CMS_DTE_OMS_REF_ID CMS_OMS_REFID CHAR 32   0   Reference number for the legacy system  
238 .INCLUDE       0   0   Template Information  
239 IS_TEMPLATE CMS_DTE_MOV_FLG_TEMPLATE CMS_MOV_FLG CHAR 1   0   Type to be used as template  
240 TEMPLATE_ID CMS_DTE_MOV_TEMPLATE_ID SYSUUID RAW 16   0   Template ID  
241 .INCLUDE       0   0   MAPI : GET : Asset details  
242 CATEGORY CMS_DTE_OMS_OBJ_CAT CMS_OBJ_CAT CHAR 6   0   Object Category  
243 CATEGORY_NAME CMS_DTE_OMS_CAT_NAME CMS_OMS_CAT_NAME CHAR 40   0   Object Category Name  
244 TYPE CMS_DTE_MOV_TYP CMS_MOV_TYP CHAR 6   0   Movable types  
245 TYPE_NAME CMS_DTE_MOV_TYP_NAME CMS_MOV_NAME CHAR 40   0   Name in a specified language  
246 IDENTIFICATION CMS_DTE_MOV_ID CMS_MOV_ID CHAR 40   0   Identification Number  
247 MOV_DESCRIPTION CMS_DTE_MOV_DESC CMS_MOV_DESC CHAR 30   0   Description of the object  
248 .INCLUDE       0   0   Structure with Asset Details for Table CMS_AST  
249 .INCLUDE       0   0   Basic Asset data  
250 DESCRIPTION CMS_DTE_AST_DESC CMS_DSC CHAR 30   0   Description  
251 OBJECT_REF_ID CMS_DTE_OBJ_REFID CMS_OBJ_REFID CHAR 40   0   Reference ID for the object  
252 OBJECT_TYP CMS_DTE_OBJ_TYP CMS_OBJ_TYP CHAR 32   0   Not used  
253 COUNTRY_KEY CMS_DTE_AST_COUNTRY_KEY LAND1 CHAR 3   0   Identification Key for Country  
254 RISK_CODE CMS_DTE_RISK_CODE CMS_RISK_CODE CHAR 6   0   Risk Code  
255 SFTY_IND CMS_DTE_IND_SFTY_DISC CMS_IND_SFTY CHAR 2   0   Indicates if the Asset has a Default Safety Discount  
256 SFTY_DSCNT CMS_DTE_SAFETY_DSCNT CMS_SFTY_PCT DEC 10   6   Percentage of Safety Discount  
257 SFTY_AMOUNT CMS_DTE_SAFETY_AMT CMS_AMOUNT CURR 17   2   Amount of Safety Discount  
258 SFTY_AMT_CURR CMS_DTE_SAFETY_AMT_CURR WAERS CUKY 5   0   Currency of the Safety Discount Amount  
259 OBJSYSID CMS_DTE_OBJ_SYSID CMS_SYS CHAR 6   0   Object System Reference ID  
260 .INCLUDE       0   0   Valuation data  
261 VALUATION_TYP CMS_DTE_IND_VALN_TYP CMS_VALN_TYP CHAR 2   0   Type of Valuation Check performed on Collateral Object  
262 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  
263 PERIOD_VALN_FREQ CMS_DTE_AST_VALN_FREQ_PERIOD CMS_AST_VALN_FREQ_PERIOD NUMC 4   0   Revaluation Period for an Asset  
264 PAST_VALUED_DATE CMS_DTE_VALN_DATE CMS_DATE DATS 8   0   Last Date on which the Asset was Valued  
265 START_DATE CMS_DTE_START_DATE CMS_DATE DATS 8   0   Date on which the First Valuation is Performed on the Asset  
266 END_DATE CMS_DTE_END_DATE CMS_DATE DATS 8   0   Date on which the Last Valuation is Performed on the Asset  
267 .INCLUDE       0   0   Lending rate data  
268 LENDING_RATE_IND CMS_DTE_IND_LND_RTE CMS_IND_LRTE CHAR 2   0   Indicator to specify if Asset has a Default Lending Rate  
269 .INCLUDE       0   0   Lending rates structure  
270 LENDING_RATE1 CMS_DTE_LRTE_PCT1 CMS_PCT DEC 10   6   Lending Rate 1  
271 LENDING_RATE2 CMS_DTE_LRTE_PCT2 CMS_PCT DEC 10   6   Lending Rate 2  
272 LENDING_RATE3 CMS_DTE_LRTE_PCT3 CMS_PCT DEC 10   6   Lending Rate 3  
273 LENDING_RATE4 CMS_DTE_LRTE_PCT4 CMS_PCT DEC 10   6   Lending Rate 4  
274 LENDING_RATE5 CMS_DTE_LRTE_PCT5 CMS_PCT DEC 10   6   Lending Rate 5  
275 .INCLUDE       0   0   Liquidation rights data  
276 LIQD_TYP CMS_DTE_LIQD_TYP CMS_TYP CHAR 6   0   Liquidation Type  
277 LIQD_REASON CMS_DTE_ATT_ID_TY_AST004 CMS_ATT_ID_TYP CHAR 6   0   Liquidation Reason  
278 LIQD_DATE CMS_DTE_LIQD_DATE CMS_DATE DATS 8   0   Date on which the Collateral was Liquidated  
279 LIQD_AMT CMS_DTE_LIQD_VALUE CMS_AMOUNT CURR 17   2   Returns from the Liquidation of Collateral  
280 LIQD_CURR CMS_DTE_LIQD_CURR WAERS CUKY 5   0   Currency of Liquidation Value  
281 EXP_PRCD_AMNT CMS_DTE_LIQ_EXP_PRCD_AMOUNT CMS_AMOUNT CURR 17   2   Expected Proceed Amount  
282 EXP_PRCD_CURR CMS_DTE_LIQ_EXP_PRCD_CURR WAERS CUKY 5   0   Currency: Expected Proceed  
283 EXP_ACC_DATE CMS_DTE_LIQ_EXP_ACCRUAL_DATE CMS_DATE DATS 8   0   Expected accrual date  
284 .INCLUDE       0   0   Account for liquidation proceeds  
285 ACC_NUMBER_LIQ CMS_DTE_LIQ_ACC_NUMBER BANKN35 CHAR 35   0   Account number for liquidation proceeds  
286 BANK_CNTRY_LIQ CMS_DTE_LIQ_BNK_CTRY_KY LAND1 CHAR 3   0   Bank country key  
287 BANK_KEY_LIQ CMS_DTE_LIQ_BNK_KEY BANKK CHAR 15   0   Bank Key  
288 BANK_CTRLKEY_LIQ BKONT BKONT CHAR 2   0   Bank Control Key  
289 .INCLUDE       0   0   Verfication Data  
290 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  
291 PERIOD_VERF_FREQ CMS_DTE_AST_VERF_FREQ_PERIOD CMS_AST_VERF_FREQ_PERIOD NUMC 4   0   Statement Period for an Asset  
292 LAST_VERF_DATE CMS_DTE_AST_VERF_DATE CMS_DATE DATS 8   0   Last Verification Date  
293 .INCLUDE       0   0   AST PKy and Type and Parent GUID  
294 AST_GUID CMS_DTE_AST_GUID SYSUUID RAW 16   0   GUID for Table CMS_AST  
295 AST_TYP CMS_DTE_AST_TYP CMS_AST_TYP CHAR 6   0   Asset Type  
296 PARENT_GUID CMS_DTE_SAS_PAR_GUID SYSUUID RAW 16   0   Asset Guid as a parent GUID for a sub-asset  
297 .INCLUDE       0   0   Structure for Asset values  
298 NOM_VALUE CMS_DTE_AST_NOMINAL_VALUE CMS_AMOUNT CURR 17   2   Nominal Value of the Asset  
299 NOM_VALUE_CURR CMS_DTE_AST_NOMINAL_VALUE_CURR WAERS CUKY 5   0   Currency of Nominal value  
300 AST_VALUE CMS_DTE_AST_VALUE CMS_AMOUNT CURR 17   2   Final Asset Value  
301 AST_VALUE_CURR CMS_DTE_AST_VALUE_CURR WAERS CUKY 5   0   Currency of the Final Asset Value  
302 QUANTITY CMS_DTE_QTY CMS_QTY QUAN 13   3   Quantity  
303 UNIT_OF_MEASURE CMS_DTE_UNIT MEINS UNIT 3   0   Unit of Measure of Quantity  
304 REC_AT CMS_DTE_REC_AT TZNTSTMPS DEC 15   0   Asset Value Recording Timestamp  
305 .INCLUDE       0   0   Purchase price data  
306 PUR_PRICE CMS_DTE_AST_PURCHASE_PRICE CMS_AMOUNT CURR 17   2   Purchase Price of the Asset  
307 PUR_PRICE_CURR CMS_DTE_AST_PUR_PRICE_CURR WAERS CUKY 5   0   Currency of Purchase Price  
308 PUR_DATE CMS_DTE_AST_PUR_PRICE_DATE CMS_DATE DATS 8   0   Date of Purchase  
309 .INCLUDE       0   0   Administrative organization unit  
310 ADMIN_ORG_UNIT CMS_DTE_ADMINORG TEXT12 CHAR 12   0   Administration Organizational Unit  
311 .INCLUDE       0   0   Bank area  
312 BANKAREA CMS_DTE_BANKAREA CMS_BANKAREA CHAR 4   0   Bank Area in Collateral Management  
313 .INCLUDE       0   0   Organization unit structure  
314 ORG_UNIT1 CMS_DTE_ORG_UNIT1 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 1  
315 ORG_UNIT2 CMS_DTE_ORG_UNIT2 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 2  
316 ORG_UNIT3 CMS_DTE_ORG_UNIT3 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 3  
317 ORG_UNIT4 CMS_DTE_ORG_UNIT4 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 4  
318 ORG_UNIT5 CMS_DTE_ORG_UNIT5 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 5  
319 .INCLUDE       0   0   Inventory Specific details  
320 IDEN_ACC CMS_DTE_INV_IDEN_ACC CMS_SEC_FLG CHAR 1   0   Identification land accessories  
321 BILL_NO CMS_DTE_INV_BILL_NO CMS_INV_BILL_NO CHAR 20   0   Bill number of the inventory  
322 UNIT_PRICE CMS_DTE_INV_UNIT_PRICE CMS_AMOUNT CURR 17   2   Unit Price  
323 UNIT_PRICE_CURR CMS_DTE_INV_UNIT_CURR WAERS CUKY 5   0   Currency for unit price  
324 TYPE_STK_EXCH CMS_DTE_INV_TYPE_STK_EXCH CMS_ATT_ID_TYP CHAR 6   0   Type of stock exchange  
325 STK_EXCH_ID CMS_DTE_INV_STK_EXCH_ID CMS_ATT_ID_TYP CHAR 6   0   Place of stock exchange  
326 RATE_FIX_DAT CMS_DTE_INV_RATE_FIX_DAT DATUM DATS 8   0   Date of previous quotation  
327 DET_PRICE CMS_DTE_INV_DET_PRICE CMS_AMOUNT CURR 17   2   Determined price  
328 DET_CURR CMS_DTE_INV_DET_CURR WAERS CUKY 5   0   Currency for determined price  
329 STOCK_QUANTITY CMS_DTE_INV_QTY CMS_QTY QUAN 13   3   Quantity of inventory  
330 STOCK_UOM CMS_DTE_UNIT MEINS UNIT 3   0   Unit of Measure of Quantity  
331 .INCLUDE       0   0   Stucture to record history of changes in all application tab  
332 CREATED_BY CMS_DTE_USER CMS_USER CHAR 12   0   Login ID of the User who created the Record  
333 CREATED_AT CMS_DTE_CREATED_AT TZNTSTMPS DEC 15   0   Creation Timestamp  
334 CHANGED_BY CMS_DTE_LAST_CHNG_USER CMS_USER CHAR 12   0   Last Changed By  
335 CHANGED_AT CMS_DTE_CHANGED_AT TZNTSTMPS DEC 15   0   Change Timestamp  
336 SOURCEOFENTRY CMS_DTE_SOURCE_OF_ENTRY CMS_SOURCE CHAR 32   0   Source of Entry  
337 WA_MOV_INV CMS_STR_INV_MAP_GET_MLT   STRU 0   0    
338 .INCLUDE       0   0   Primary Key for CMS_MOVABLES  
339 MOV_GUID CMS_DTE_MOV_GUID SYSUUID RAW 16   0   GUID for CMS_MOVABLES  
340 .INCLUDE       0   0   Semantic Key  
341 MOV_CATEGORY CMS_DTE_OMS_OBJ_CAT CMS_OBJ_CAT CHAR 6   0   Object Category  
342 MOV_TYP CMS_DTE_MOV_TYP CMS_MOV_TYP CHAR 6   0   Movable types  
343 MOV_ID CMS_DTE_MOV_ID CMS_MOV_ID CHAR 40   0   Identification Number  
344 MOV_CAT_NAME CMS_DTE_OMS_CAT_NAME CMS_OMS_CAT_NAME CHAR 40   0   Object Category Name  
345 MOV_TYP_NAME CMS_DTE_MOV_TYP_NAME CMS_MOV_NAME CHAR 40   0   Name in a specified language  
346 .INCLUDE       0   0   Common Movable data  
347 MOV_DESC CMS_DTE_MOV_DESC CMS_MOV_DESC CHAR 30   0   Description of the object  
348 MOV_IDT_ACC CMS_DTE_MOV_IDT_ACC CMS_MOV_IDT_ACC CHAR 1   0   Identification accessories  
349 .INCLUDE       0   0   Object Specific Features for Description  
350 MOV_MODEL_NAM CMS_DTE_MOV_MODEL_NAM CMS_MOV_MODEL_NAM CHAR 30   0   Technical Category/Category term/Description  
351 MOV_MANUFACTURER CMS_DTE_MOV_MANUFACTURER CMS_MOV_MANUFACTURER CHAR 30   0   Object Manufacturer Builder  
352 MOV_MANU_DAT CMS_DTE_MOV_MANU_DAT CMS_MOV_MANU_DAT DATS 8   0   Date of the Manufacture/Purchase  
353 ADDR_ID CMS_DTE_MOV_LOCATION AD_ADDRNUM CHAR 10   0   Location / Address  
354 MOV_LOC_DESC CMS_DTE_MOV_LOC_DESC CMS_ATT_ID_TYP CHAR 6   0   Location Description  
355 MOV_LOC_DE_RMRK CMS_DTE_MOV_LOC_DESC_RMRK CMS_MOV_LOC_DESC_RMRK CHAR 30   0   Remark Field for Location Description  
356 MOV_IDEN_TYP CMS_DTE_MOV_TYPE_IDENT CMS_ATT_ID_TYP CHAR 6   0   Type of identification / Marking of the collateral material  
357 MOV_DESC_COL_MAT CMS_DTE_OMS_DESC_IDENT_COL_MAT CMS_OMS_DESC_COL_MAT CHAR 30   0   Bank's Own Identifcation  
358 MOV_DOP CMS_DTE_MOV_DOP CMS_MOV_DOP DATS 8   0   Date of Purchase  
359 MOV_IDENT CMS_DTE_MOV_IDENT CMS_MOV_IDENT CHAR 2   0   Commercial usage  
360 MOV_UOB CMS_DTE_MOV_UOB CMS_ATT_ID_TYP CHAR 6   0   Use of the object  
361 MOV_MANU_CNTRY CMS_DTE_MOV_MANU_CNTRY LAND1 CHAR 3   0   Manufacturing Country  
362 MOV_TYPE_FEAT CMS_DTE_MOV_TYPE_FEAT CMS_MOV_TYPE_FEAT CHAR 6   0   Classification  
363 .INCLUDE       0   0   Common OMS data  
364 EXT_ITM_NO CMS_DTE_OMS_EXT_ITM_NO CMS_OMS_ID CHAR 40   0   Ext. Item no / Number for identification of the objects  
365 EXT_REFERENCE CMS_DTE_OMS_REF_ID CMS_OMS_REFID CHAR 32   0   Reference number for the legacy system  
366 .INCLUDE       0   0   Template Information  
367 IS_TEMPLATE CMS_DTE_MOV_FLG_TEMPLATE CMS_MOV_FLG CHAR 1   0   Type to be used as template  
368 TEMPLATE_ID CMS_DTE_MOV_TEMPLATE_ID SYSUUID RAW 16   0   Template ID  
369 .INCLUDE       0   0   MAPI : GET : Asset details  
370 CATEGORY CMS_DTE_OMS_OBJ_CAT CMS_OBJ_CAT CHAR 6   0   Object Category  
371 CATEGORY_NAME CMS_DTE_OMS_CAT_NAME CMS_OMS_CAT_NAME CHAR 40   0   Object Category Name  
372 TYPE CMS_DTE_MOV_TYP CMS_MOV_TYP CHAR 6   0   Movable types  
373 TYPE_NAME CMS_DTE_MOV_TYP_NAME CMS_MOV_NAME CHAR 40   0   Name in a specified language  
374 IDENTIFICATION CMS_DTE_MOV_ID CMS_MOV_ID CHAR 40   0   Identification Number  
375 MOV_DESCRIPTION CMS_DTE_MOV_DESC CMS_MOV_DESC CHAR 30   0   Description of the object  
376 .INCLUDE       0   0   Structure with Asset Details for Table CMS_AST  
377 .INCLUDE       0   0   Basic Asset data  
378 DESCRIPTION CMS_DTE_AST_DESC CMS_DSC CHAR 30   0   Description  
379 OBJECT_REF_ID CMS_DTE_OBJ_REFID CMS_OBJ_REFID CHAR 40   0   Reference ID for the object  
380 OBJECT_TYP CMS_DTE_OBJ_TYP CMS_OBJ_TYP CHAR 32   0   Not used  
381 COUNTRY_KEY CMS_DTE_AST_COUNTRY_KEY LAND1 CHAR 3   0   Identification Key for Country  
382 RISK_CODE CMS_DTE_RISK_CODE CMS_RISK_CODE CHAR 6   0   Risk Code  
383 SFTY_IND CMS_DTE_IND_SFTY_DISC CMS_IND_SFTY CHAR 2   0   Indicates if the Asset has a Default Safety Discount  
384 SFTY_DSCNT CMS_DTE_SAFETY_DSCNT CMS_SFTY_PCT DEC 10   6   Percentage of Safety Discount  
385 SFTY_AMOUNT CMS_DTE_SAFETY_AMT CMS_AMOUNT CURR 17   2   Amount of Safety Discount  
386 SFTY_AMT_CURR CMS_DTE_SAFETY_AMT_CURR WAERS CUKY 5   0   Currency of the Safety Discount Amount  
387 OBJSYSID CMS_DTE_OBJ_SYSID CMS_SYS CHAR 6   0   Object System Reference ID  
388 .INCLUDE       0   0   Valuation data  
389 VALUATION_TYP CMS_DTE_IND_VALN_TYP CMS_VALN_TYP CHAR 2   0   Type of Valuation Check performed on Collateral Object  
390 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  
391 PERIOD_VALN_FREQ CMS_DTE_AST_VALN_FREQ_PERIOD CMS_AST_VALN_FREQ_PERIOD NUMC 4   0   Revaluation Period for an Asset  
392 PAST_VALUED_DATE CMS_DTE_VALN_DATE CMS_DATE DATS 8   0   Last Date on which the Asset was Valued  
393 START_DATE CMS_DTE_START_DATE CMS_DATE DATS 8   0   Date on which the First Valuation is Performed on the Asset  
394 END_DATE CMS_DTE_END_DATE CMS_DATE DATS 8   0   Date on which the Last Valuation is Performed on the Asset  
395 .INCLUDE       0   0   Lending rate data  
396 LENDING_RATE_IND CMS_DTE_IND_LND_RTE CMS_IND_LRTE CHAR 2   0   Indicator to specify if Asset has a Default Lending Rate  
397 .INCLUDE       0   0   Lending rates structure  
398 LENDING_RATE1 CMS_DTE_LRTE_PCT1 CMS_PCT DEC 10   6   Lending Rate 1  
399 LENDING_RATE2 CMS_DTE_LRTE_PCT2 CMS_PCT DEC 10   6   Lending Rate 2  
400 LENDING_RATE3 CMS_DTE_LRTE_PCT3 CMS_PCT DEC 10   6   Lending Rate 3  
401 LENDING_RATE4 CMS_DTE_LRTE_PCT4 CMS_PCT DEC 10   6   Lending Rate 4  
402 LENDING_RATE5 CMS_DTE_LRTE_PCT5 CMS_PCT DEC 10   6   Lending Rate 5  
403 .INCLUDE       0   0   Liquidation rights data  
404 LIQD_TYP CMS_DTE_LIQD_TYP CMS_TYP CHAR 6   0   Liquidation Type  
405 LIQD_REASON CMS_DTE_ATT_ID_TY_AST004 CMS_ATT_ID_TYP CHAR 6   0   Liquidation Reason  
406 LIQD_DATE CMS_DTE_LIQD_DATE CMS_DATE DATS 8   0   Date on which the Collateral was Liquidated  
407 LIQD_AMT CMS_DTE_LIQD_VALUE CMS_AMOUNT CURR 17   2   Returns from the Liquidation of Collateral  
408 LIQD_CURR CMS_DTE_LIQD_CURR WAERS CUKY 5   0   Currency of Liquidation Value  
409 EXP_PRCD_AMNT CMS_DTE_LIQ_EXP_PRCD_AMOUNT CMS_AMOUNT CURR 17   2   Expected Proceed Amount  
410 EXP_PRCD_CURR CMS_DTE_LIQ_EXP_PRCD_CURR WAERS CUKY 5   0   Currency: Expected Proceed  
411 EXP_ACC_DATE CMS_DTE_LIQ_EXP_ACCRUAL_DATE CMS_DATE DATS 8   0   Expected accrual date  
412 .INCLUDE       0   0   Account for liquidation proceeds  
413 ACC_NUMBER_LIQ CMS_DTE_LIQ_ACC_NUMBER BANKN35 CHAR 35   0   Account number for liquidation proceeds  
414 BANK_CNTRY_LIQ CMS_DTE_LIQ_BNK_CTRY_KY LAND1 CHAR 3   0   Bank country key  
415 BANK_KEY_LIQ CMS_DTE_LIQ_BNK_KEY BANKK CHAR 15   0   Bank Key  
416 BANK_CTRLKEY_LIQ BKONT BKONT CHAR 2   0   Bank Control Key  
417 .INCLUDE       0   0   Verfication Data  
418 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  
419 PERIOD_VERF_FREQ CMS_DTE_AST_VERF_FREQ_PERIOD CMS_AST_VERF_FREQ_PERIOD NUMC 4   0   Statement Period for an Asset  
420 LAST_VERF_DATE CMS_DTE_AST_VERF_DATE CMS_DATE DATS 8   0   Last Verification Date  
421 .INCLUDE       0   0   AST PKy and Type and Parent GUID  
422 AST_GUID CMS_DTE_AST_GUID SYSUUID RAW 16   0   GUID for Table CMS_AST  
423 AST_TYP CMS_DTE_AST_TYP CMS_AST_TYP CHAR 6   0   Asset Type  
424 PARENT_GUID CMS_DTE_SAS_PAR_GUID SYSUUID RAW 16   0   Asset Guid as a parent GUID for a sub-asset  
425 .INCLUDE       0   0   Structure for Asset values  
426 NOM_VALUE CMS_DTE_AST_NOMINAL_VALUE CMS_AMOUNT CURR 17   2   Nominal Value of the Asset  
427 NOM_VALUE_CURR CMS_DTE_AST_NOMINAL_VALUE_CURR WAERS CUKY 5   0   Currency of Nominal value  
428 AST_VALUE CMS_DTE_AST_VALUE CMS_AMOUNT CURR 17   2   Final Asset Value  
429 AST_VALUE_CURR CMS_DTE_AST_VALUE_CURR WAERS CUKY 5   0   Currency of the Final Asset Value  
430 QUANTITY CMS_DTE_QTY CMS_QTY QUAN 13   3   Quantity  
431 UNIT_OF_MEASURE CMS_DTE_UNIT MEINS UNIT 3   0   Unit of Measure of Quantity  
432 REC_AT CMS_DTE_REC_AT TZNTSTMPS DEC 15   0   Asset Value Recording Timestamp  
433 .INCLUDE       0   0   Purchase price data  
434 PUR_PRICE CMS_DTE_AST_PURCHASE_PRICE CMS_AMOUNT CURR 17   2   Purchase Price of the Asset  
435 PUR_PRICE_CURR CMS_DTE_AST_PUR_PRICE_CURR WAERS CUKY 5   0   Currency of Purchase Price  
436 PUR_DATE CMS_DTE_AST_PUR_PRICE_DATE CMS_DATE DATS 8   0   Date of Purchase  
437 .INCLUDE       0   0   Administrative organization unit  
438 ADMIN_ORG_UNIT CMS_DTE_ADMINORG TEXT12 CHAR 12   0   Administration Organizational Unit  
439 .INCLUDE       0   0   Bank area  
440 BANKAREA CMS_DTE_BANKAREA CMS_BANKAREA CHAR 4   0   Bank Area in Collateral Management  
441 .INCLUDE       0   0   Organization unit structure  
442 ORG_UNIT1 CMS_DTE_ORG_UNIT1 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 1  
443 ORG_UNIT2 CMS_DTE_ORG_UNIT2 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 2  
444 ORG_UNIT3 CMS_DTE_ORG_UNIT3 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 3  
445 ORG_UNIT4 CMS_DTE_ORG_UNIT4 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 4  
446 ORG_UNIT5 CMS_DTE_ORG_UNIT5 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 5  
447 .INCLUDE       0   0   Inventory Specific details  
448 IDEN_ACC CMS_DTE_INV_IDEN_ACC CMS_SEC_FLG CHAR 1   0   Identification land accessories  
449 BILL_NO CMS_DTE_INV_BILL_NO CMS_INV_BILL_NO CHAR 20   0   Bill number of the inventory  
450 UNIT_PRICE CMS_DTE_INV_UNIT_PRICE CMS_AMOUNT CURR 17   2   Unit Price  
451 UNIT_PRICE_CURR CMS_DTE_INV_UNIT_CURR WAERS CUKY 5   0   Currency for unit price  
452 TYPE_STK_EXCH CMS_DTE_INV_TYPE_STK_EXCH CMS_ATT_ID_TYP CHAR 6   0   Type of stock exchange  
453 STK_EXCH_ID CMS_DTE_INV_STK_EXCH_ID CMS_ATT_ID_TYP CHAR 6   0   Place of stock exchange  
454 RATE_FIX_DAT CMS_DTE_INV_RATE_FIX_DAT DATUM DATS 8   0   Date of previous quotation  
455 DET_PRICE CMS_DTE_INV_DET_PRICE CMS_AMOUNT CURR 17   2   Determined price  
456 DET_CURR CMS_DTE_INV_DET_CURR WAERS CUKY 5   0   Currency for determined price  
457 STOCK_QUANTITY CMS_DTE_INV_QTY CMS_QTY QUAN 13   3   Quantity of inventory  
458 STOCK_UOM CMS_DTE_UNIT MEINS UNIT 3   0   Unit of Measure of Quantity  
459 .INCLUDE       0   0   Stucture to record history of changes in all application tab  
460 CREATED_BY CMS_DTE_USER CMS_USER CHAR 12   0   Login ID of the User who created the Record  
461 CREATED_AT CMS_DTE_CREATED_AT TZNTSTMPS DEC 15   0   Creation Timestamp  
462 CHANGED_BY CMS_DTE_LAST_CHNG_USER CMS_USER CHAR 12   0   Last Changed By  
463 CHANGED_AT CMS_DTE_CHANGED_AT TZNTSTMPS DEC 15   0   Change Timestamp  
464 SOURCEOFENTRY CMS_DTE_SOURCE_OF_ENTRY CMS_SOURCE CHAR 32   0   Source of Entry  
465 WA_MOV_SHP CMS_STR_SHP_MAP_GET_MLT   STRU 0   0    
466 .INCLUDE       0   0   Primary key for Ship  
467 SHP_GUID OS_GUID SYSUUID RAW 16   0   Globally Unique Identifier  
468 .INCLUDE       0   0   Asset Guid - Link key to Ship  
469 AST_GUID CMS_DTE_AST_GUID SYSUUID RAW 16   0   GUID for Table CMS_AST  
470 .INCLUDE       0   0   Identification of Ship  
471 SHP_TYPE CMS_DTE_SHP_TYP CMS_SHP_TYP CHAR 6   0   Ship Type  
472 NAME CMS_DTE_SHP_NAME CMS_SHP_NAME CHAR 40   0   Ship name  
473 CHARTER_NAME CMS_DTE_SHP_CH_NAME CMS_SHP_NAME CHAR 40   0   Charter Name used to Lease the Ship  
474 CALL_SIGN CMS_DTE_SHP_CALL_SIGN CMS_SHP_NUMBER CHAR 20   0   IMO Number  
475 SHP_CLASS CMS_DTE_SHP_CLASS CMS_SHP_CLASS CHAR 2   0   Specifies whether the Ship is Sea Ship or Inland Ship  
476 REG_NUMBER CMS_DTE_SHP_REG_NUM CMS_SHP_NUMBER CHAR 20   0   Registration Number  
477 REG_DATE CMS_DTE_SHP_REG_DATE CMS_SHP_DATE DATS 8   0   Registration date  
478 REG_PLACE CMS_DTE_SHP_REG_PLACE CMS_SHP_NAME CHAR 40   0   Registration place  
479 REG_COUNTRY CMS_DTE_SHP_REG_COUNTRY LAND1 CHAR 3   0   Registration country  
480 EXTN_REF_ID CMS_DTE_SHP_OBJ_REFID CMS_SHP_NAME CHAR 40   0   External reference ID for the Ship  
481 FLEET_NAME CMS_DTE_SHP_FLEET_NAME CMS_SHP_NAME CHAR 40   0   Fleet Name  
482 SHIP_ID CMS_DTE_SHP_ID CMS_SHP_ID CHAR 40   0   Ship ID  
483 .INCLUDE       0   0   General Description of Ship  
484 ISM_VALID_FROM CMS_DTE_SHP_ISM_FROM CMS_SHP_DATE DATS 8   0   Date from which ISM Certificate Stands Valid  
485 ISM_VALID_TO CMS_DTE_SHP_ISM_TO CMS_SHP_DATE DATS 8   0   Date until which ISM Certificate Stands Valid  
486 RATING_DATE CMS_DTE_SHP_RATE_DATE CMS_SHP_DATE DATS 8   0   Rating date  
487 RATING_CLS CMS_DTE_SHP_RATING_CLS CMS_SHP_RATING_CLS CHAR 20   0   Rating Class  
488 CLASSIFICATION CMS_DTE_SHP_CLASSIFICATION CMS_SHP_NAME CHAR 40   0   Classification of a Ship  
489 CLASSIFI_COMPANY CMS_DTE_SHP_ATT_ID_TY_SHP002 CMS_ATT_ID_TYP CHAR 6   0   Classification Company  
490 COMMENTS CMS_DTE_SHP_COMMENTS CMS_SHP_NAME CHAR 40   0   Description  
491 .INCLUDE       0   0   Purchase Details of Ship  
492 PURCH_PRICE CMS_DTE_SHP_PUR_PRI CMS_SHP_AMOUNT CURR 17   2   Purchase Price  
493 PURCH_CURR CMS_DTE_SHP_PUR_CURR WAERS CUKY 5   0   Currency for purchase price  
494 PURCH_PRICE_DATE CMS_DTE_SHP_PUR_DATE CMS_SHP_DATE DATS 8   0   Purchase date  
495 .INCLUDE       0   0   Construction Details of Ship  
496 CONS_COUNTRY CMS_DTE_SHP_CONS_COUNTRY LAND1 CHAR 3   0   Country where the Ship was Built  
497 CONS_PRICE CMS_DTE_SHP_CONS_PRICE CMS_SHP_AMOUNT CURR 17   2   Cost incurred in Building the Ship  
498 CONS_CURR CMS_DTE_SHP_CONS_CURR WAERS CUKY 5   0   Currency for construction price  
499 DELIVERY_DATE CMS_DTE_SHP_DELIVERY_DATE CMS_SHP_DATE DATS 8   0   Date of Delivery of the ship  
500 DOCK CMS_DTE_SHP_DOCK CMS_SHP_NAME CHAR 40   0   Shipyard where the Ship was Built  
501 .INCLUDE       0   0   Size Details of Ship  
502 LENGTH CMS_DTE_SHP_LENGTH CMS_SHP_SIZE QUAN 13   3   Ship length  
503 LENGTH_UOM CMS_DTE_SHP_LENGTH_UOM MEINS UNIT 3   0   Unit of measure for the ship length  
504 BREADTH CMS_DTE_SHP_BREADTH CMS_SHP_SIZE QUAN 13   3   Ship Beam  
505 BREADTH_UOM CMS_DTE_SHP_BREADTH_UOM MEINS UNIT 3   0   Unit of measure for the breadth  
506 DEPTH CMS_DTE_SHP_DEPTH CMS_SHP_SIZE QUAN 13   3   Ship Draught  
507 DEPTH_UOM CMS_DTE_SHP_DEPTH_UOM MEINS UNIT 3   0   Unit of measure for the depth  
508 VOLUME CMS_DTE_SHP_VOLUME CMS_SHP_SIZE QUAN 13   3   Volume of Ship  
509 VOLUME_UOM CMS_DTE_SHP_VOLUME_UOM MEINS UNIT 3   0   Unit of Measure for the Ship Volume  
510 DWT CMS_DTE_SHP_DWT CMS_SHP_SIZE QUAN 13   3   Weight of the Ship excluding the weight of Cargo  
511 DWT_UOM CMS_DTE_SHP_DWT_UOM MEINS UNIT 3   0   Unit of measure for the dead weight tonnage  
512 GROSST CMS_DTE_SHP_GROSST CMS_SHP_SIZE QUAN 13   3   Volume of the Interiors of a Ship  
513 GROSST_UOM CMS_DTE_SHP_GROSST_UOM MEINS UNIT 3   0   Unit of measure for the gross tonnage  
514 TRACK_LENGTH CMS_DTE_SHP_TRK_LEN CMS_SHP_SIZE QUAN 13   3   Length of the Track in a Ship  
515 TRACK_LENGTH_UOM CMS_DTE_SHP_TRK_LEN_UOM MEINS UNIT 3   0   Unit of Measure for the Track Length in a Ship  
516 NUM_REF_CONT CMS_DTE_SHP_NO_REF_CONT CMS_SHP_INT DEC 10   0   Number of refrigerated containers  
517 NUM_CONT_CAP CMS_DTE_SHP_CONT_CAP CMS_SHP_INT DEC 10   0   Container Capacity  
518 NUM_CABIN_ROOM CMS_DTE_SHP_CAB_ROOM CMS_SHP_INT DEC 10   0   Number of Cabin Rooms  
519 NUM_VEH_PARK CMS_DTE_SHP_NO_PARK CMS_SHP_INT DEC 10   0   Number of Parking Units in the Vehicle Parking Bay  
520 NUM_OF_PAX CMS_DTE_SHP_NO_PAX CMS_SHP_INT DEC 10   0   Passenger Capacity of the Ship  
521 ISOVR_CONTAINER CMS_DTE_SHP_OVERSIZE_CONTAINER CMS_SHP_FLG CHAR 1   0   Indicator for Oversize Container Transportable in the Ship  
522 .INCLUDE       0   0   Technical Details of Ship  
523 HULL_TYP CMS_DTE_SHP_ATT_ID_TY_SHP001 CMS_ATT_ID_TYP CHAR 6   0   Hull Type  
524 MANUFR_MACHINE CMS_DTE_SHP_MANUFR_MACHINE CMS_SHP_NAME CHAR 40   0   Manufacturer of the Machine  
525 MACHINE_TYP CMS_DTE_SHP_MAC_TYP CMS_SHP_NAME CHAR 40   0   Name of the Engine Model  
526 NUM_MACHINES CMS_DTE_SHP_NO_MACHINES CMS_SHP_INT DEC 10   0   Number of Main Machines Fitted in the Ship  
527 CRANE_EQUIP CMS_DTE_SHP_CRANE_EQUIP CMS_SHP_NAME CHAR 40   0   Crane Equipment fitted in the Ship  
528 POWER CMS_DTE_SHP_POWER CMS_SHP_SIZE QUAN 13   3   Engine power  
529 POWER_UOM CMS_DTE_SHP_POWER_UOM MEINS UNIT 3   0   Unit of measure for the horse power  
530 SPEED CMS_DTE_SHP_SPEED CMS_SHP_SIZE QUAN 13   3   Speed  
531 SPEED_UOM CMS_DTE_SHP_SPEED_UOM MEINS UNIT 3   0   Unit of measure for the speed  
532 FUEL_CONSUM CMS_DTE_SHP_FUEL_CONSUM CMS_SHP_SIZE QUAN 13   3   Fuel Consumption  
533 FUEL_CONSUM_UOM CMS_DTE_SHP_FUEL_CONSUM_UOM MEINS UNIT 3   0   Unit of measure for the fuel consumption  
534 .INCLUDE       0   0   Insurance Details of Ship  
535 INSUR_PREMIUM CMS_DTE_SHP_INSUR_PREMIUM CMS_SHP_AMOUNT CURR 17   2   Insurance Premium  
536 INSUR_PRE_CURR CMS_DTE_SHP_INSUR_PREMIUM_CURR WAERS CUKY 5   0   Currency for insurance premium  
537 INSUR_TYPE CMS_DTE_SHP_ATT_ID_TY_SHP003 CMS_ATT_ID_TYP CHAR 6   0   Insurance Type  
538 ANNUAL_DEP CMS_DTE_SHP_ANNUAL_DEP CMS_SHP_PCT DEC 10   6   Annual depreciation in percentage  
539 INSUR_VALID_TILL CMS_DTE_SHP_INSUR_VALID_TILL CMS_SHP_DATE DATS 8   0   Date of Expiry of the Insurance Policy  
540 POLICY_AMOUNT CMS_DTE_SHP_POLICY_AMOUNT CMS_SHP_AMOUNT CURR 17   2   Insurance Policy Amount  
541 POLICY_CURR CMS_DTE_SHP_POLICY_CURR WAERS CUKY 5   0   Insurance Policy Amount Currency  
542 REQD_INSUR_COVER CMS_DTE_SHP_REQD_INSUR_COVER CMS_SHP_AMOUNT CURR 17   2   Required Amount of Insurance Cover  
543 REQD_INSUR_CURR CMS_DTE_SHP_REQD_INSUR_CURR WAERS CUKY 5   0   Required Insurance Cover Currency  
544 INSURER CMS_DTE_SHP_ATT_ID_TY_SHP004 CMS_ATT_ID_TYP CHAR 6   0   Insurer  
545 CONTACT_FIRM CMS_DTE_SHP_CONTACT_FIRM CMS_SHP_NAME CHAR 40   0   Contact Firm  
546 CONTACT_PERSON CMS_DTE_SHP_CONTACT_PERSON CMS_SHP_NAME CHAR 40   0   Contact Person  
547 .INCLUDE       0   0   MAPI : GET : Asset details  
548 CATEGORY CMS_DTE_OMS_OBJ_CAT CMS_OBJ_CAT CHAR 6   0   Object Category  
549 CATEGORY_NAME CMS_DTE_OMS_CAT_NAME CMS_OMS_CAT_NAME CHAR 40   0   Object Category Name  
550 TYPE CMS_DTE_MOV_TYP CMS_MOV_TYP CHAR 6   0   Movable types  
551 TYPE_NAME CMS_DTE_MOV_TYP_NAME CMS_MOV_NAME CHAR 40   0   Name in a specified language  
552 IDENTIFICATION CMS_DTE_MOV_ID CMS_MOV_ID CHAR 40   0   Identification Number  
553 MOV_DESCRIPTION CMS_DTE_MOV_DESC CMS_MOV_DESC CHAR 30   0   Description of the object  
554 .INCLUDE       0   0   Structure with Asset Details for Table CMS_AST  
555 .INCLUDE       0   0   Basic Asset data  
556 DESCRIPTION CMS_DTE_AST_DESC CMS_DSC CHAR 30   0   Description  
557 OBJECT_REF_ID CMS_DTE_OBJ_REFID CMS_OBJ_REFID CHAR 40   0   Reference ID for the object  
558 OBJECT_TYP CMS_DTE_OBJ_TYP CMS_OBJ_TYP CHAR 32   0   Not used  
559 COUNTRY_KEY CMS_DTE_AST_COUNTRY_KEY LAND1 CHAR 3   0   Identification Key for Country  
560 RISK_CODE CMS_DTE_RISK_CODE CMS_RISK_CODE CHAR 6   0   Risk Code  
561 SFTY_IND CMS_DTE_IND_SFTY_DISC CMS_IND_SFTY CHAR 2   0   Indicates if the Asset has a Default Safety Discount  
562 SFTY_DSCNT CMS_DTE_SAFETY_DSCNT CMS_SFTY_PCT DEC 10   6   Percentage of Safety Discount  
563 SFTY_AMOUNT CMS_DTE_SAFETY_AMT CMS_AMOUNT CURR 17   2   Amount of Safety Discount  
564 SFTY_AMT_CURR CMS_DTE_SAFETY_AMT_CURR WAERS CUKY 5   0   Currency of the Safety Discount Amount  
565 OBJSYSID CMS_DTE_OBJ_SYSID CMS_SYS CHAR 6   0   Object System Reference ID  
566 .INCLUDE       0   0   Valuation data  
567 VALUATION_TYP CMS_DTE_IND_VALN_TYP CMS_VALN_TYP CHAR 2   0   Type of Valuation Check performed on Collateral Object  
568 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  
569 PERIOD_VALN_FREQ CMS_DTE_AST_VALN_FREQ_PERIOD CMS_AST_VALN_FREQ_PERIOD NUMC 4   0   Revaluation Period for an Asset  
570 PAST_VALUED_DATE CMS_DTE_VALN_DATE CMS_DATE DATS 8   0   Last Date on which the Asset was Valued  
571 START_DATE CMS_DTE_START_DATE CMS_DATE DATS 8   0   Date on which the First Valuation is Performed on the Asset  
572 END_DATE CMS_DTE_END_DATE CMS_DATE DATS 8   0   Date on which the Last Valuation is Performed on the Asset  
573 .INCLUDE       0   0   Lending rate data  
574 LENDING_RATE_IND CMS_DTE_IND_LND_RTE CMS_IND_LRTE CHAR 2   0   Indicator to specify if Asset has a Default Lending Rate  
575 .INCLUDE       0   0   Lending rates structure  
576 LENDING_RATE1 CMS_DTE_LRTE_PCT1 CMS_PCT DEC 10   6   Lending Rate 1  
577 LENDING_RATE2 CMS_DTE_LRTE_PCT2 CMS_PCT DEC 10   6   Lending Rate 2  
578 LENDING_RATE3 CMS_DTE_LRTE_PCT3 CMS_PCT DEC 10   6   Lending Rate 3  
579 LENDING_RATE4 CMS_DTE_LRTE_PCT4 CMS_PCT DEC 10   6   Lending Rate 4  
580 LENDING_RATE5 CMS_DTE_LRTE_PCT5 CMS_PCT DEC 10   6   Lending Rate 5  
581 .INCLUDE       0   0   Liquidation rights data  
582 LIQD_TYP CMS_DTE_LIQD_TYP CMS_TYP CHAR 6   0   Liquidation Type  
583 LIQD_REASON CMS_DTE_ATT_ID_TY_AST004 CMS_ATT_ID_TYP CHAR 6   0   Liquidation Reason  
584 LIQD_DATE CMS_DTE_LIQD_DATE CMS_DATE DATS 8   0   Date on which the Collateral was Liquidated  
585 LIQD_AMT CMS_DTE_LIQD_VALUE CMS_AMOUNT CURR 17   2   Returns from the Liquidation of Collateral  
586 LIQD_CURR CMS_DTE_LIQD_CURR WAERS CUKY 5   0   Currency of Liquidation Value  
587 EXP_PRCD_AMNT CMS_DTE_LIQ_EXP_PRCD_AMOUNT CMS_AMOUNT CURR 17   2   Expected Proceed Amount  
588 EXP_PRCD_CURR CMS_DTE_LIQ_EXP_PRCD_CURR WAERS CUKY 5   0   Currency: Expected Proceed  
589 EXP_ACC_DATE CMS_DTE_LIQ_EXP_ACCRUAL_DATE CMS_DATE DATS 8   0   Expected accrual date  
590 .INCLUDE       0   0   Account for liquidation proceeds  
591 ACC_NUMBER_LIQ CMS_DTE_LIQ_ACC_NUMBER BANKN35 CHAR 35   0   Account number for liquidation proceeds  
592 BANK_CNTRY_LIQ CMS_DTE_LIQ_BNK_CTRY_KY LAND1 CHAR 3   0   Bank country key  
593 BANK_KEY_LIQ CMS_DTE_LIQ_BNK_KEY BANKK CHAR 15   0   Bank Key  
594 BANK_CTRLKEY_LIQ BKONT BKONT CHAR 2   0   Bank Control Key  
595 .INCLUDE       0   0   Verfication Data  
596 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  
597 PERIOD_VERF_FREQ CMS_DTE_AST_VERF_FREQ_PERIOD CMS_AST_VERF_FREQ_PERIOD NUMC 4   0   Statement Period for an Asset  
598 LAST_VERF_DATE CMS_DTE_AST_VERF_DATE CMS_DATE DATS 8   0   Last Verification Date  
599 .INCLUDE       0   0   Structure for Asset values  
600 NOM_VALUE CMS_DTE_AST_NOMINAL_VALUE CMS_AMOUNT CURR 17   2   Nominal Value of the Asset  
601 NOM_VALUE_CURR CMS_DTE_AST_NOMINAL_VALUE_CURR WAERS CUKY 5   0   Currency of Nominal value  
602 AST_VALUE CMS_DTE_AST_VALUE CMS_AMOUNT CURR 17   2   Final Asset Value  
603 AST_VALUE_CURR CMS_DTE_AST_VALUE_CURR WAERS CUKY 5   0   Currency of the Final Asset Value  
604 QUANTITY CMS_DTE_QTY CMS_QTY QUAN 13   3   Quantity  
605 UNIT_OF_MEASURE CMS_DTE_UNIT MEINS UNIT 3   0   Unit of Measure of Quantity  
606 REC_AT CMS_DTE_REC_AT TZNTSTMPS DEC 15   0   Asset Value Recording Timestamp  
607 .INCLUDE       0   0   Purchase price data  
608 PUR_PRICE CMS_DTE_AST_PURCHASE_PRICE CMS_AMOUNT CURR 17   2   Purchase Price of the Asset  
609 PUR_PRICE_CURR CMS_DTE_AST_PUR_PRICE_CURR WAERS CUKY 5   0   Currency of Purchase Price  
610 PUR_DATE CMS_DTE_AST_PUR_PRICE_DATE CMS_DATE DATS 8   0   Date of Purchase  
611 .INCLUDE       0   0   Administrative organization unit  
612 ADMIN_ORG_UNIT CMS_DTE_ADMINORG TEXT12 CHAR 12   0   Administration Organizational Unit  
613 .INCLUDE       0   0   Bank area  
614 BANKAREA CMS_DTE_BANKAREA CMS_BANKAREA CHAR 4   0   Bank Area in Collateral Management  
615 .INCLUDE       0   0   Organization unit structure  
616 ORG_UNIT1 CMS_DTE_ORG_UNIT1 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 1  
617 ORG_UNIT2 CMS_DTE_ORG_UNIT2 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 2  
618 ORG_UNIT3 CMS_DTE_ORG_UNIT3 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 3  
619 ORG_UNIT4 CMS_DTE_ORG_UNIT4 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 4  
620 ORG_UNIT5 CMS_DTE_ORG_UNIT5 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 5  
621 .INCLUDE       0   0   Stucture to record history of changes in all application tab  
622 CREATED_BY CMS_DTE_USER CMS_USER CHAR 12   0   Login ID of the User who created the Record  
623 CREATED_AT CMS_DTE_CREATED_AT TZNTSTMPS DEC 15   0   Creation Timestamp  
624 CHANGED_BY CMS_DTE_LAST_CHNG_USER CMS_USER CHAR 12   0   Last Changed By  
625 CHANGED_AT CMS_DTE_CHANGED_AT TZNTSTMPS DEC 15   0   Change Timestamp  
626 SOURCEOFENTRY CMS_DTE_SOURCE_OF_ENTRY CMS_SOURCE CHAR 32   0   Source of Entry  
627 WA_MOV_BDL CMS_STR_BDL_MAP_GET_MLT   STRU 0   0    
628 .INCLUDE       0   0   Primary Key for CMS_MOVABLES  
629 MOV_GUID CMS_DTE_MOV_GUID SYSUUID RAW 16   0   GUID for CMS_MOVABLES  
630 .INCLUDE       0   0   Semantic Key  
631 MOV_CATEGORY CMS_DTE_OMS_OBJ_CAT CMS_OBJ_CAT CHAR 6   0   Object Category  
632 MOV_TYP CMS_DTE_MOV_TYP CMS_MOV_TYP CHAR 6   0   Movable types  
633 MOV_ID CMS_DTE_MOV_ID CMS_MOV_ID CHAR 40   0   Identification Number  
634 MOV_CAT_NAME CMS_DTE_OMS_CAT_NAME CMS_OMS_CAT_NAME CHAR 40   0   Object Category Name  
635 MOV_TYP_NAME CMS_DTE_MOV_TYP_NAME CMS_MOV_NAME CHAR 40   0   Name in a specified language  
636 .INCLUDE       0   0   Common Movable data  
637 MOV_DESC CMS_DTE_MOV_DESC CMS_MOV_DESC CHAR 30   0   Description of the object  
638 MOV_IDT_ACC CMS_DTE_MOV_IDT_ACC CMS_MOV_IDT_ACC CHAR 1   0   Identification accessories  
639 .INCLUDE       0   0   Object Specific Features for Description  
640 MOV_MODEL_NAM CMS_DTE_MOV_MODEL_NAM CMS_MOV_MODEL_NAM CHAR 30   0   Technical Category/Category term/Description  
641 MOV_MANUFACTURER CMS_DTE_MOV_MANUFACTURER CMS_MOV_MANUFACTURER CHAR 30   0   Object Manufacturer Builder  
642 MOV_MANU_DAT CMS_DTE_MOV_MANU_DAT CMS_MOV_MANU_DAT DATS 8   0   Date of the Manufacture/Purchase  
643 ADDR_ID CMS_DTE_MOV_LOCATION AD_ADDRNUM CHAR 10   0   Location / Address  
644 MOV_LOC_DESC CMS_DTE_MOV_LOC_DESC CMS_ATT_ID_TYP CHAR 6   0   Location Description  
645 MOV_LOC_DE_RMRK CMS_DTE_MOV_LOC_DESC_RMRK CMS_MOV_LOC_DESC_RMRK CHAR 30   0   Remark Field for Location Description  
646 MOV_IDEN_TYP CMS_DTE_MOV_TYPE_IDENT CMS_ATT_ID_TYP CHAR 6   0   Type of identification / Marking of the collateral material  
647 MOV_DESC_COL_MAT CMS_DTE_OMS_DESC_IDENT_COL_MAT CMS_OMS_DESC_COL_MAT CHAR 30   0   Bank's Own Identifcation  
648 MOV_DOP CMS_DTE_MOV_DOP CMS_MOV_DOP DATS 8   0   Date of Purchase  
649 MOV_IDENT CMS_DTE_MOV_IDENT CMS_MOV_IDENT CHAR 2   0   Commercial usage  
650 MOV_UOB CMS_DTE_MOV_UOB CMS_ATT_ID_TYP CHAR 6   0   Use of the object  
651 MOV_MANU_CNTRY CMS_DTE_MOV_MANU_CNTRY LAND1 CHAR 3   0   Manufacturing Country  
652 MOV_TYPE_FEAT CMS_DTE_MOV_TYPE_FEAT CMS_MOV_TYPE_FEAT CHAR 6   0   Classification  
653 .INCLUDE       0   0   Common OMS data  
654 EXT_ITM_NO CMS_DTE_OMS_EXT_ITM_NO CMS_OMS_ID CHAR 40   0   Ext. Item no / Number for identification of the objects  
655 EXT_REFERENCE CMS_DTE_OMS_REF_ID CMS_OMS_REFID CHAR 32   0   Reference number for the legacy system  
656 .INCLUDE       0   0   Template Information  
657 IS_TEMPLATE CMS_DTE_MOV_FLG_TEMPLATE CMS_MOV_FLG CHAR 1   0   Type to be used as template  
658 TEMPLATE_ID CMS_DTE_MOV_TEMPLATE_ID SYSUUID RAW 16   0   Template ID  
659 .INCLUDE       0   0   MAPI : GET : Asset details  
660 CATEGORY CMS_DTE_OMS_OBJ_CAT CMS_OBJ_CAT CHAR 6   0   Object Category  
661 CATEGORY_NAME CMS_DTE_OMS_CAT_NAME CMS_OMS_CAT_NAME CHAR 40   0   Object Category Name  
662 TYPE CMS_DTE_MOV_TYP CMS_MOV_TYP CHAR 6   0   Movable types  
663 TYPE_NAME CMS_DTE_MOV_TYP_NAME CMS_MOV_NAME CHAR 40   0   Name in a specified language  
664 IDENTIFICATION CMS_DTE_MOV_ID CMS_MOV_ID CHAR 40   0   Identification Number  
665 MOV_DESCRIPTION CMS_DTE_MOV_DESC CMS_MOV_DESC CHAR 30   0   Description of the object  
666 .INCLUDE       0   0   Structure with Asset Details for Table CMS_AST  
667 .INCLUDE       0   0   Basic Asset data  
668 DESCRIPTION CMS_DTE_AST_DESC CMS_DSC CHAR 30   0   Description  
669 OBJECT_REF_ID CMS_DTE_OBJ_REFID CMS_OBJ_REFID CHAR 40   0   Reference ID for the object  
670 OBJECT_TYP CMS_DTE_OBJ_TYP CMS_OBJ_TYP CHAR 32   0   Not used  
671 COUNTRY_KEY CMS_DTE_AST_COUNTRY_KEY LAND1 CHAR 3   0   Identification Key for Country  
672 RISK_CODE CMS_DTE_RISK_CODE CMS_RISK_CODE CHAR 6   0   Risk Code  
673 SFTY_IND CMS_DTE_IND_SFTY_DISC CMS_IND_SFTY CHAR 2   0   Indicates if the Asset has a Default Safety Discount  
674 SFTY_DSCNT CMS_DTE_SAFETY_DSCNT CMS_SFTY_PCT DEC 10   6   Percentage of Safety Discount  
675 SFTY_AMOUNT CMS_DTE_SAFETY_AMT CMS_AMOUNT CURR 17   2   Amount of Safety Discount  
676 SFTY_AMT_CURR CMS_DTE_SAFETY_AMT_CURR WAERS CUKY 5   0   Currency of the Safety Discount Amount  
677 OBJSYSID CMS_DTE_OBJ_SYSID CMS_SYS CHAR 6   0   Object System Reference ID  
678 .INCLUDE       0   0   Valuation data  
679 VALUATION_TYP CMS_DTE_IND_VALN_TYP CMS_VALN_TYP CHAR 2   0   Type of Valuation Check performed on Collateral Object  
680 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  
681 PERIOD_VALN_FREQ CMS_DTE_AST_VALN_FREQ_PERIOD CMS_AST_VALN_FREQ_PERIOD NUMC 4   0   Revaluation Period for an Asset  
682 PAST_VALUED_DATE CMS_DTE_VALN_DATE CMS_DATE DATS 8   0   Last Date on which the Asset was Valued  
683 START_DATE CMS_DTE_START_DATE CMS_DATE DATS 8   0   Date on which the First Valuation is Performed on the Asset  
684 END_DATE CMS_DTE_END_DATE CMS_DATE DATS 8   0   Date on which the Last Valuation is Performed on the Asset  
685 .INCLUDE       0   0   Lending rate data  
686 LENDING_RATE_IND CMS_DTE_IND_LND_RTE CMS_IND_LRTE CHAR 2   0   Indicator to specify if Asset has a Default Lending Rate  
687 .INCLUDE       0   0   Lending rates structure  
688 LENDING_RATE1 CMS_DTE_LRTE_PCT1 CMS_PCT DEC 10   6   Lending Rate 1  
689 LENDING_RATE2 CMS_DTE_LRTE_PCT2 CMS_PCT DEC 10   6   Lending Rate 2  
690 LENDING_RATE3 CMS_DTE_LRTE_PCT3 CMS_PCT DEC 10   6   Lending Rate 3  
691 LENDING_RATE4 CMS_DTE_LRTE_PCT4 CMS_PCT DEC 10   6   Lending Rate 4  
692 LENDING_RATE5 CMS_DTE_LRTE_PCT5 CMS_PCT DEC 10   6   Lending Rate 5  
693 .INCLUDE       0   0   Liquidation rights data  
694 LIQD_TYP CMS_DTE_LIQD_TYP CMS_TYP CHAR 6   0   Liquidation Type  
695 LIQD_REASON CMS_DTE_ATT_ID_TY_AST004 CMS_ATT_ID_TYP CHAR 6   0   Liquidation Reason  
696 LIQD_DATE CMS_DTE_LIQD_DATE CMS_DATE DATS 8   0   Date on which the Collateral was Liquidated  
697 LIQD_AMT CMS_DTE_LIQD_VALUE CMS_AMOUNT CURR 17   2   Returns from the Liquidation of Collateral  
698 LIQD_CURR CMS_DTE_LIQD_CURR WAERS CUKY 5   0   Currency of Liquidation Value  
699 EXP_PRCD_AMNT CMS_DTE_LIQ_EXP_PRCD_AMOUNT CMS_AMOUNT CURR 17   2   Expected Proceed Amount  
700 EXP_PRCD_CURR CMS_DTE_LIQ_EXP_PRCD_CURR WAERS CUKY 5   0   Currency: Expected Proceed  
701 EXP_ACC_DATE CMS_DTE_LIQ_EXP_ACCRUAL_DATE CMS_DATE DATS 8   0   Expected accrual date  
702 .INCLUDE       0   0   Account for liquidation proceeds  
703 ACC_NUMBER_LIQ CMS_DTE_LIQ_ACC_NUMBER BANKN35 CHAR 35   0   Account number for liquidation proceeds  
704 BANK_CNTRY_LIQ CMS_DTE_LIQ_BNK_CTRY_KY LAND1 CHAR 3   0   Bank country key  
705 BANK_KEY_LIQ CMS_DTE_LIQ_BNK_KEY BANKK CHAR 15   0   Bank Key  
706 BANK_CTRLKEY_LIQ BKONT BKONT CHAR 2   0   Bank Control Key  
707 .INCLUDE       0   0   Verfication Data  
708 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  
709 PERIOD_VERF_FREQ CMS_DTE_AST_VERF_FREQ_PERIOD CMS_AST_VERF_FREQ_PERIOD NUMC 4   0   Statement Period for an Asset  
710 LAST_VERF_DATE CMS_DTE_AST_VERF_DATE CMS_DATE DATS 8   0   Last Verification Date  
711 .INCLUDE       0   0   AST PKy and Type and Parent GUID  
712 AST_GUID CMS_DTE_AST_GUID SYSUUID RAW 16   0   GUID for Table CMS_AST  
713 AST_TYP CMS_DTE_AST_TYP CMS_AST_TYP CHAR 6   0   Asset Type  
714 PARENT_GUID CMS_DTE_SAS_PAR_GUID SYSUUID RAW 16   0   Asset Guid as a parent GUID for a sub-asset  
715 .INCLUDE       0   0   Structure for Asset values  
716 NOM_VALUE CMS_DTE_AST_NOMINAL_VALUE CMS_AMOUNT CURR 17   2   Nominal Value of the Asset  
717 NOM_VALUE_CURR CMS_DTE_AST_NOMINAL_VALUE_CURR WAERS CUKY 5   0   Currency of Nominal value  
718 AST_VALUE CMS_DTE_AST_VALUE CMS_AMOUNT CURR 17   2   Final Asset Value  
719 AST_VALUE_CURR CMS_DTE_AST_VALUE_CURR WAERS CUKY 5   0   Currency of the Final Asset Value  
720 QUANTITY CMS_DTE_QTY CMS_QTY QUAN 13   3   Quantity  
721 UNIT_OF_MEASURE CMS_DTE_UNIT MEINS UNIT 3   0   Unit of Measure of Quantity  
722 REC_AT CMS_DTE_REC_AT TZNTSTMPS DEC 15   0   Asset Value Recording Timestamp  
723 .INCLUDE       0   0   Purchase price data  
724 PUR_PRICE CMS_DTE_AST_PURCHASE_PRICE CMS_AMOUNT CURR 17   2   Purchase Price of the Asset  
725 PUR_PRICE_CURR CMS_DTE_AST_PUR_PRICE_CURR WAERS CUKY 5   0   Currency of Purchase Price  
726 PUR_DATE CMS_DTE_AST_PUR_PRICE_DATE CMS_DATE DATS 8   0   Date of Purchase  
727 .INCLUDE       0   0   Administrative organization unit  
728 ADMIN_ORG_UNIT CMS_DTE_ADMINORG TEXT12 CHAR 12   0   Administration Organizational Unit  
729 .INCLUDE       0   0   Bank area  
730 BANKAREA CMS_DTE_BANKAREA CMS_BANKAREA CHAR 4   0   Bank Area in Collateral Management  
731 .INCLUDE       0   0   Organization unit structure  
732 ORG_UNIT1 CMS_DTE_ORG_UNIT1 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 1  
733 ORG_UNIT2 CMS_DTE_ORG_UNIT2 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 2  
734 ORG_UNIT3 CMS_DTE_ORG_UNIT3 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 3  
735 ORG_UNIT4 CMS_DTE_ORG_UNIT4 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 4  
736 ORG_UNIT5 CMS_DTE_ORG_UNIT5 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 5  
737 .INCLUDE       0   0   Inventory Specific details  
738 IDEN_ACC CMS_DTE_INV_IDEN_ACC CMS_SEC_FLG CHAR 1   0   Identification land accessories  
739 BILL_NO CMS_DTE_INV_BILL_NO CMS_INV_BILL_NO CHAR 20   0   Bill number of the inventory  
740 UNIT_PRICE CMS_DTE_INV_UNIT_PRICE CMS_AMOUNT CURR 17   2   Unit Price  
741 UNIT_PRICE_CURR CMS_DTE_INV_UNIT_CURR WAERS CUKY 5   0   Currency for unit price  
742 TYPE_STK_EXCH CMS_DTE_INV_TYPE_STK_EXCH CMS_ATT_ID_TYP CHAR 6   0   Type of stock exchange  
743 STK_EXCH_ID CMS_DTE_INV_STK_EXCH_ID CMS_ATT_ID_TYP CHAR 6   0   Place of stock exchange  
744 RATE_FIX_DAT CMS_DTE_INV_RATE_FIX_DAT DATUM DATS 8   0   Date of previous quotation  
745 DET_PRICE CMS_DTE_INV_DET_PRICE CMS_AMOUNT CURR 17   2   Determined price  
746 DET_CURR CMS_DTE_INV_DET_CURR WAERS CUKY 5   0   Currency for determined price  
747 STOCK_QUANTITY CMS_DTE_INV_QTY CMS_QTY QUAN 13   3   Quantity of inventory  
748 STOCK_UOM CMS_DTE_UNIT MEINS UNIT 3   0   Unit of Measure of Quantity  
749 .INCLUDE       0   0   Stucture to record history of changes in all application tab  
750 CREATED_BY CMS_DTE_USER CMS_USER CHAR 12   0   Login ID of the User who created the Record  
751 CREATED_AT CMS_DTE_CREATED_AT TZNTSTMPS DEC 15   0   Creation Timestamp  
752 CHANGED_BY CMS_DTE_LAST_CHNG_USER CMS_USER CHAR 12   0   Last Changed By  
753 CHANGED_AT CMS_DTE_CHANGED_AT TZNTSTMPS DEC 15   0   Change Timestamp  
754 SOURCEOFENTRY CMS_DTE_SOURCE_OF_ENTRY CMS_SOURCE CHAR 32   0   Source of Entry  
755 WA_MOV_DEV CMS_STR_DEV_MAP_GET_MLT   STRU 0   0    
756 .INCLUDE       0   0   Primary Key for CMS_MOVABLES  
757 MOV_GUID CMS_DTE_MOV_GUID SYSUUID RAW 16   0   GUID for CMS_MOVABLES  
758 .INCLUDE       0   0   Semantic Key  
759 MOV_CATEGORY CMS_DTE_OMS_OBJ_CAT CMS_OBJ_CAT CHAR 6   0   Object Category  
760 MOV_TYP CMS_DTE_MOV_TYP CMS_MOV_TYP CHAR 6   0   Movable types  
761 MOV_ID CMS_DTE_MOV_ID CMS_MOV_ID CHAR 40   0   Identification Number  
762 MOV_CAT_NAME CMS_DTE_OMS_CAT_NAME CMS_OMS_CAT_NAME CHAR 40   0   Object Category Name  
763 MOV_TYP_NAME CMS_DTE_MOV_TYP_NAME CMS_MOV_NAME CHAR 40   0   Name in a specified language  
764 .INCLUDE       0   0   Common Movable data  
765 MOV_DESC CMS_DTE_MOV_DESC CMS_MOV_DESC CHAR 30   0   Description of the object  
766 MOV_IDT_ACC CMS_DTE_MOV_IDT_ACC CMS_MOV_IDT_ACC CHAR 1   0   Identification accessories  
767 .INCLUDE       0   0   Object Specific Features for Description  
768 MOV_MODEL_NAM CMS_DTE_MOV_MODEL_NAM CMS_MOV_MODEL_NAM CHAR 30   0   Technical Category/Category term/Description  
769 MOV_MANUFACTURER CMS_DTE_MOV_MANUFACTURER CMS_MOV_MANUFACTURER CHAR 30   0   Object Manufacturer Builder  
770 MOV_MANU_DAT CMS_DTE_MOV_MANU_DAT CMS_MOV_MANU_DAT DATS 8   0   Date of the Manufacture/Purchase  
771 ADDR_ID CMS_DTE_MOV_LOCATION AD_ADDRNUM CHAR 10   0   Location / Address  
772 MOV_LOC_DESC CMS_DTE_MOV_LOC_DESC CMS_ATT_ID_TYP CHAR 6   0   Location Description  
773 MOV_LOC_DE_RMRK CMS_DTE_MOV_LOC_DESC_RMRK CMS_MOV_LOC_DESC_RMRK CHAR 30   0   Remark Field for Location Description  
774 MOV_IDEN_TYP CMS_DTE_MOV_TYPE_IDENT CMS_ATT_ID_TYP CHAR 6   0   Type of identification / Marking of the collateral material  
775 MOV_DESC_COL_MAT CMS_DTE_OMS_DESC_IDENT_COL_MAT CMS_OMS_DESC_COL_MAT CHAR 30   0   Bank's Own Identifcation  
776 MOV_DOP CMS_DTE_MOV_DOP CMS_MOV_DOP DATS 8   0   Date of Purchase  
777 MOV_IDENT CMS_DTE_MOV_IDENT CMS_MOV_IDENT CHAR 2   0   Commercial usage  
778 MOV_UOB CMS_DTE_MOV_UOB CMS_ATT_ID_TYP CHAR 6   0   Use of the object  
779 MOV_MANU_CNTRY CMS_DTE_MOV_MANU_CNTRY LAND1 CHAR 3   0   Manufacturing Country  
780 MOV_TYPE_FEAT CMS_DTE_MOV_TYPE_FEAT CMS_MOV_TYPE_FEAT CHAR 6   0   Classification  
781 .INCLUDE       0   0   Common OMS data  
782 EXT_ITM_NO CMS_DTE_OMS_EXT_ITM_NO CMS_OMS_ID CHAR 40   0   Ext. Item no / Number for identification of the objects  
783 EXT_REFERENCE CMS_DTE_OMS_REF_ID CMS_OMS_REFID CHAR 32   0   Reference number for the legacy system  
784 .INCLUDE       0   0   Template Information  
785 IS_TEMPLATE CMS_DTE_MOV_FLG_TEMPLATE CMS_MOV_FLG CHAR 1   0   Type to be used as template  
786 TEMPLATE_ID CMS_DTE_MOV_TEMPLATE_ID SYSUUID RAW 16   0   Template ID  
787 .INCLUDE       0   0   Devices Data  
788 .INCLUDE       0   0   Devices data  
789 DEV_COUNTRY_KEY CMS_DTE_MOV_COUNTRY_KEY LAND1 CHAR 3   0   Country Key  
790 DEV_MAC_NO CMS_DTE_MOV_MACHINE_NO CMS_MOV_ID CHAR 40   0   External Item Number - Machine number  
791 .INCLUDE       0   0   MAPI : GET : Asset details  
792 CATEGORY CMS_DTE_OMS_OBJ_CAT CMS_OBJ_CAT CHAR 6   0   Object Category  
793 CATEGORY_NAME CMS_DTE_OMS_CAT_NAME CMS_OMS_CAT_NAME CHAR 40   0   Object Category Name  
794 TYPE CMS_DTE_MOV_TYP CMS_MOV_TYP CHAR 6   0   Movable types  
795 TYPE_NAME CMS_DTE_MOV_TYP_NAME CMS_MOV_NAME CHAR 40   0   Name in a specified language  
796 IDENTIFICATION CMS_DTE_MOV_ID CMS_MOV_ID CHAR 40   0   Identification Number  
797 MOV_DESCRIPTION CMS_DTE_MOV_DESC CMS_MOV_DESC CHAR 30   0   Description of the object  
798 .INCLUDE       0   0   Structure with Asset Details for Table CMS_AST  
799 .INCLUDE       0   0   Basic Asset data  
800 DESCRIPTION CMS_DTE_AST_DESC CMS_DSC CHAR 30   0   Description  
801 OBJECT_REF_ID CMS_DTE_OBJ_REFID CMS_OBJ_REFID CHAR 40   0   Reference ID for the object  
802 OBJECT_TYP CMS_DTE_OBJ_TYP CMS_OBJ_TYP CHAR 32   0   Not used  
803 COUNTRY_KEY CMS_DTE_AST_COUNTRY_KEY LAND1 CHAR 3   0   Identification Key for Country  
804 RISK_CODE CMS_DTE_RISK_CODE CMS_RISK_CODE CHAR 6   0   Risk Code  
805 SFTY_IND CMS_DTE_IND_SFTY_DISC CMS_IND_SFTY CHAR 2   0   Indicates if the Asset has a Default Safety Discount  
806 SFTY_DSCNT CMS_DTE_SAFETY_DSCNT CMS_SFTY_PCT DEC 10   6   Percentage of Safety Discount  
807 SFTY_AMOUNT CMS_DTE_SAFETY_AMT CMS_AMOUNT CURR 17   2   Amount of Safety Discount  
808 SFTY_AMT_CURR CMS_DTE_SAFETY_AMT_CURR WAERS CUKY 5   0   Currency of the Safety Discount Amount  
809 OBJSYSID CMS_DTE_OBJ_SYSID CMS_SYS CHAR 6   0   Object System Reference ID  
810 .INCLUDE       0   0   Valuation data  
811 VALUATION_TYP CMS_DTE_IND_VALN_TYP CMS_VALN_TYP CHAR 2   0   Type of Valuation Check performed on Collateral Object  
812 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  
813 PERIOD_VALN_FREQ CMS_DTE_AST_VALN_FREQ_PERIOD CMS_AST_VALN_FREQ_PERIOD NUMC 4   0   Revaluation Period for an Asset  
814 PAST_VALUED_DATE CMS_DTE_VALN_DATE CMS_DATE DATS 8   0   Last Date on which the Asset was Valued  
815 START_DATE CMS_DTE_START_DATE CMS_DATE DATS 8   0   Date on which the First Valuation is Performed on the Asset  
816 END_DATE CMS_DTE_END_DATE CMS_DATE DATS 8   0   Date on which the Last Valuation is Performed on the Asset  
817 .INCLUDE       0   0   Lending rate data  
818 LENDING_RATE_IND CMS_DTE_IND_LND_RTE CMS_IND_LRTE CHAR 2   0   Indicator to specify if Asset has a Default Lending Rate  
819 .INCLUDE       0   0   Lending rates structure  
820 LENDING_RATE1 CMS_DTE_LRTE_PCT1 CMS_PCT DEC 10   6   Lending Rate 1  
821 LENDING_RATE2 CMS_DTE_LRTE_PCT2 CMS_PCT DEC 10   6   Lending Rate 2  
822 LENDING_RATE3 CMS_DTE_LRTE_PCT3 CMS_PCT DEC 10   6   Lending Rate 3  
823 LENDING_RATE4 CMS_DTE_LRTE_PCT4 CMS_PCT DEC 10   6   Lending Rate 4  
824 LENDING_RATE5 CMS_DTE_LRTE_PCT5 CMS_PCT DEC 10   6   Lending Rate 5  
825 .INCLUDE       0   0   Liquidation rights data  
826 LIQD_TYP CMS_DTE_LIQD_TYP CMS_TYP CHAR 6   0   Liquidation Type  
827 LIQD_REASON CMS_DTE_ATT_ID_TY_AST004 CMS_ATT_ID_TYP CHAR 6   0   Liquidation Reason  
828 LIQD_DATE CMS_DTE_LIQD_DATE CMS_DATE DATS 8   0   Date on which the Collateral was Liquidated  
829 LIQD_AMT CMS_DTE_LIQD_VALUE CMS_AMOUNT CURR 17   2   Returns from the Liquidation of Collateral  
830 LIQD_CURR CMS_DTE_LIQD_CURR WAERS CUKY 5   0   Currency of Liquidation Value  
831 EXP_PRCD_AMNT CMS_DTE_LIQ_EXP_PRCD_AMOUNT CMS_AMOUNT CURR 17   2   Expected Proceed Amount  
832 EXP_PRCD_CURR CMS_DTE_LIQ_EXP_PRCD_CURR WAERS CUKY 5   0   Currency: Expected Proceed  
833 EXP_ACC_DATE CMS_DTE_LIQ_EXP_ACCRUAL_DATE CMS_DATE DATS 8   0   Expected accrual date  
834 .INCLUDE       0   0   Account for liquidation proceeds  
835 ACC_NUMBER_LIQ CMS_DTE_LIQ_ACC_NUMBER BANKN35 CHAR 35   0   Account number for liquidation proceeds  
836 BANK_CNTRY_LIQ CMS_DTE_LIQ_BNK_CTRY_KY LAND1 CHAR 3   0   Bank country key  
837 BANK_KEY_LIQ CMS_DTE_LIQ_BNK_KEY BANKK CHAR 15   0   Bank Key  
838 BANK_CTRLKEY_LIQ BKONT BKONT CHAR 2   0   Bank Control Key  
839 .INCLUDE       0   0   Verfication Data  
840 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  
841 PERIOD_VERF_FREQ CMS_DTE_AST_VERF_FREQ_PERIOD CMS_AST_VERF_FREQ_PERIOD NUMC 4   0   Statement Period for an Asset  
842 LAST_VERF_DATE CMS_DTE_AST_VERF_DATE CMS_DATE DATS 8   0   Last Verification Date  
843 .INCLUDE       0   0   AST PKy and Type and Parent GUID  
844 AST_GUID CMS_DTE_AST_GUID SYSUUID RAW 16   0   GUID for Table CMS_AST  
845 AST_TYP CMS_DTE_AST_TYP CMS_AST_TYP CHAR 6   0   Asset Type  
846 PARENT_GUID CMS_DTE_SAS_PAR_GUID SYSUUID RAW 16   0   Asset Guid as a parent GUID for a sub-asset  
847 .INCLUDE       0   0   Structure for Asset values  
848 NOM_VALUE CMS_DTE_AST_NOMINAL_VALUE CMS_AMOUNT CURR 17   2   Nominal Value of the Asset  
849 NOM_VALUE_CURR CMS_DTE_AST_NOMINAL_VALUE_CURR WAERS CUKY 5   0   Currency of Nominal value  
850 AST_VALUE CMS_DTE_AST_VALUE CMS_AMOUNT CURR 17   2   Final Asset Value  
851 AST_VALUE_CURR CMS_DTE_AST_VALUE_CURR WAERS CUKY 5   0   Currency of the Final Asset Value  
852 QUANTITY CMS_DTE_QTY CMS_QTY QUAN 13   3   Quantity  
853 UNIT_OF_MEASURE CMS_DTE_UNIT MEINS UNIT 3   0   Unit of Measure of Quantity  
854 REC_AT CMS_DTE_REC_AT TZNTSTMPS DEC 15   0   Asset Value Recording Timestamp  
855 .INCLUDE       0   0   Purchase price data  
856 PUR_PRICE CMS_DTE_AST_PURCHASE_PRICE CMS_AMOUNT CURR 17   2   Purchase Price of the Asset  
857 PUR_PRICE_CURR CMS_DTE_AST_PUR_PRICE_CURR WAERS CUKY 5   0   Currency of Purchase Price  
858 PUR_DATE CMS_DTE_AST_PUR_PRICE_DATE CMS_DATE DATS 8   0   Date of Purchase  
859 .INCLUDE       0   0   Administrative organization unit  
860 ADMIN_ORG_UNIT CMS_DTE_ADMINORG TEXT12 CHAR 12   0   Administration Organizational Unit  
861 .INCLUDE       0   0   Bank area  
862 BANKAREA CMS_DTE_BANKAREA CMS_BANKAREA CHAR 4   0   Bank Area in Collateral Management  
863 .INCLUDE       0   0   Organization unit structure  
864 ORG_UNIT1 CMS_DTE_ORG_UNIT1 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 1  
865 ORG_UNIT2 CMS_DTE_ORG_UNIT2 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 2  
866 ORG_UNIT3 CMS_DTE_ORG_UNIT3 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 3  
867 ORG_UNIT4 CMS_DTE_ORG_UNIT4 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 4  
868 ORG_UNIT5 CMS_DTE_ORG_UNIT5 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 5  
869 .INCLUDE       0   0   Inventory Specific details  
870 IDEN_ACC CMS_DTE_INV_IDEN_ACC CMS_SEC_FLG CHAR 1   0   Identification land accessories  
871 BILL_NO CMS_DTE_INV_BILL_NO CMS_INV_BILL_NO CHAR 20   0   Bill number of the inventory  
872 UNIT_PRICE CMS_DTE_INV_UNIT_PRICE CMS_AMOUNT CURR 17   2   Unit Price  
873 UNIT_PRICE_CURR CMS_DTE_INV_UNIT_CURR WAERS CUKY 5   0   Currency for unit price  
874 TYPE_STK_EXCH CMS_DTE_INV_TYPE_STK_EXCH CMS_ATT_ID_TYP CHAR 6   0   Type of stock exchange  
875 STK_EXCH_ID CMS_DTE_INV_STK_EXCH_ID CMS_ATT_ID_TYP CHAR 6   0   Place of stock exchange  
876 RATE_FIX_DAT CMS_DTE_INV_RATE_FIX_DAT DATUM DATS 8   0   Date of previous quotation  
877 DET_PRICE CMS_DTE_INV_DET_PRICE CMS_AMOUNT CURR 17   2   Determined price  
878 DET_CURR CMS_DTE_INV_DET_CURR WAERS CUKY 5   0   Currency for determined price  
879 STOCK_QUANTITY CMS_DTE_INV_QTY CMS_QTY QUAN 13   3   Quantity of inventory  
880 STOCK_UOM CMS_DTE_UNIT MEINS UNIT 3   0   Unit of Measure of Quantity  
881 .INCLUDE       0   0   Stucture to record history of changes in all application tab  
882 CREATED_BY CMS_DTE_USER CMS_USER CHAR 12   0   Login ID of the User who created the Record  
883 CREATED_AT CMS_DTE_CREATED_AT TZNTSTMPS DEC 15   0   Creation Timestamp  
884 CHANGED_BY CMS_DTE_LAST_CHNG_USER CMS_USER CHAR 12   0   Last Changed By  
885 CHANGED_AT CMS_DTE_CHANGED_AT TZNTSTMPS DEC 15   0   Change Timestamp  
886 SOURCEOFENTRY CMS_DTE_SOURCE_OF_ENTRY CMS_SOURCE CHAR 32   0   Source of Entry  
887 WA_MOV_VEH CMS_STR_VEH_MAP_GET_MLT   STRU 0   0    
888 .INCLUDE       0   0   Primary Key for CMS_MOVABLES  
889 MOV_GUID CMS_DTE_MOV_GUID SYSUUID RAW 16   0   GUID for CMS_MOVABLES  
890 .INCLUDE       0   0   Semantic Key  
891 MOV_CATEGORY CMS_DTE_OMS_OBJ_CAT CMS_OBJ_CAT CHAR 6   0   Object Category  
892 MOV_TYP CMS_DTE_MOV_TYP CMS_MOV_TYP CHAR 6   0   Movable types  
893 MOV_ID CMS_DTE_MOV_ID CMS_MOV_ID CHAR 40   0   Identification Number  
894 MOV_CAT_NAME CMS_DTE_OMS_CAT_NAME CMS_OMS_CAT_NAME CHAR 40   0   Object Category Name  
895 MOV_TYP_NAME CMS_DTE_MOV_TYP_NAME CMS_MOV_NAME CHAR 40   0   Name in a specified language  
896 .INCLUDE       0   0   Common Movable data  
897 MOV_DESC CMS_DTE_MOV_DESC CMS_MOV_DESC CHAR 30   0   Description of the object  
898 MOV_IDT_ACC CMS_DTE_MOV_IDT_ACC CMS_MOV_IDT_ACC CHAR 1   0   Identification accessories  
899 .INCLUDE       0   0   Object Specific Features for Description  
900 MOV_MODEL_NAM CMS_DTE_MOV_MODEL_NAM CMS_MOV_MODEL_NAM CHAR 30   0   Technical Category/Category term/Description  
901 MOV_MANUFACTURER CMS_DTE_MOV_MANUFACTURER CMS_MOV_MANUFACTURER CHAR 30   0   Object Manufacturer Builder  
902 MOV_MANU_DAT CMS_DTE_MOV_MANU_DAT CMS_MOV_MANU_DAT DATS 8   0   Date of the Manufacture/Purchase  
903 ADDR_ID CMS_DTE_MOV_LOCATION AD_ADDRNUM CHAR 10   0   Location / Address  
904 MOV_LOC_DESC CMS_DTE_MOV_LOC_DESC CMS_ATT_ID_TYP CHAR 6   0   Location Description  
905 MOV_LOC_DE_RMRK CMS_DTE_MOV_LOC_DESC_RMRK CMS_MOV_LOC_DESC_RMRK CHAR 30   0   Remark Field for Location Description  
906 MOV_IDEN_TYP CMS_DTE_MOV_TYPE_IDENT CMS_ATT_ID_TYP CHAR 6   0   Type of identification / Marking of the collateral material  
907 MOV_DESC_COL_MAT CMS_DTE_OMS_DESC_IDENT_COL_MAT CMS_OMS_DESC_COL_MAT CHAR 30   0   Bank's Own Identifcation  
908 MOV_DOP CMS_DTE_MOV_DOP CMS_MOV_DOP DATS 8   0   Date of Purchase  
909 MOV_IDENT CMS_DTE_MOV_IDENT CMS_MOV_IDENT CHAR 2   0   Commercial usage  
910 MOV_UOB CMS_DTE_MOV_UOB CMS_ATT_ID_TYP CHAR 6   0   Use of the object  
911 MOV_MANU_CNTRY CMS_DTE_MOV_MANU_CNTRY LAND1 CHAR 3   0   Manufacturing Country  
912 MOV_TYPE_FEAT CMS_DTE_MOV_TYPE_FEAT CMS_MOV_TYPE_FEAT CHAR 6   0   Classification  
913 .INCLUDE       0   0   Common OMS data  
914 EXT_ITM_NO CMS_DTE_OMS_EXT_ITM_NO CMS_OMS_ID CHAR 40   0   Ext. Item no / Number for identification of the objects  
915 EXT_REFERENCE CMS_DTE_OMS_REF_ID CMS_OMS_REFID CHAR 32   0   Reference number for the legacy system  
916 .INCLUDE       0   0   Template Information  
917 IS_TEMPLATE CMS_DTE_MOV_FLG_TEMPLATE CMS_MOV_FLG CHAR 1   0   Type to be used as template  
918 TEMPLATE_ID CMS_DTE_MOV_TEMPLATE_ID SYSUUID RAW 16   0   Template ID  
919 .INCLUDE       0   0   Vehicles data  
920 .INCLUDE       0   0   Vehicles data  
921 PERM_WGHT CMS_DTE_MOV_PERM_WGHT CMS_PERM_WGHT QUAN 13   3   Maximum Permissible Weight  
922 PERM_WGHT_UNT CMS_DTE_MOV_PERM_WGHT_UNT MEINS UNIT 3   0   Unit of the quantity  
923 PLACE_LIC CMS_DTE_MOV_PLACE_LIC CMS_PLACE_LIC CHAR 30   0   Place of Registration  
924 VEH_REG_NO CMS_DTE_MOV_REG_NO CMS_REG_NO CHAR 30   0   Vehicle registration mark  
925 OFF_IDENT CMS_DTE_MOV_OFF_IDENT CMS_VEH_OFF_IDENT CHAR 30   0   Identification of the registration certificate  
926 CHAIS_NO CMS_DTE_MOV_CHASIS_NO CMS_MOV_DESC CHAR 30   0   Chassis Number  
927 .INCLUDE       0   0   MAPI : GET : Asset details  
928 CATEGORY CMS_DTE_OMS_OBJ_CAT CMS_OBJ_CAT CHAR 6   0   Object Category  
929 CATEGORY_NAME CMS_DTE_OMS_CAT_NAME CMS_OMS_CAT_NAME CHAR 40   0   Object Category Name  
930 TYPE CMS_DTE_MOV_TYP CMS_MOV_TYP CHAR 6   0   Movable types  
931 TYPE_NAME CMS_DTE_MOV_TYP_NAME CMS_MOV_NAME CHAR 40   0   Name in a specified language  
932 IDENTIFICATION CMS_DTE_MOV_ID CMS_MOV_ID CHAR 40   0   Identification Number  
933 MOV_DESCRIPTION CMS_DTE_MOV_DESC CMS_MOV_DESC CHAR 30   0   Description of the object  
934 .INCLUDE       0   0   Structure with Asset Details for Table CMS_AST  
935 .INCLUDE       0   0   Basic Asset data  
936 DESCRIPTION CMS_DTE_AST_DESC CMS_DSC CHAR 30   0   Description  
937 OBJECT_REF_ID CMS_DTE_OBJ_REFID CMS_OBJ_REFID CHAR 40   0   Reference ID for the object  
938 OBJECT_TYP CMS_DTE_OBJ_TYP CMS_OBJ_TYP CHAR 32   0   Not used  
939 COUNTRY_KEY CMS_DTE_AST_COUNTRY_KEY LAND1 CHAR 3   0   Identification Key for Country  
940 RISK_CODE CMS_DTE_RISK_CODE CMS_RISK_CODE CHAR 6   0   Risk Code  
941 SFTY_IND CMS_DTE_IND_SFTY_DISC CMS_IND_SFTY CHAR 2   0   Indicates if the Asset has a Default Safety Discount  
942 SFTY_DSCNT CMS_DTE_SAFETY_DSCNT CMS_SFTY_PCT DEC 10   6   Percentage of Safety Discount  
943 SFTY_AMOUNT CMS_DTE_SAFETY_AMT CMS_AMOUNT CURR 17   2   Amount of Safety Discount  
944 SFTY_AMT_CURR CMS_DTE_SAFETY_AMT_CURR WAERS CUKY 5   0   Currency of the Safety Discount Amount  
945 OBJSYSID CMS_DTE_OBJ_SYSID CMS_SYS CHAR 6   0   Object System Reference ID  
946 .INCLUDE       0   0   Valuation data  
947 VALUATION_TYP CMS_DTE_IND_VALN_TYP CMS_VALN_TYP CHAR 2   0   Type of Valuation Check performed on Collateral Object  
948 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  
949 PERIOD_VALN_FREQ CMS_DTE_AST_VALN_FREQ_PERIOD CMS_AST_VALN_FREQ_PERIOD NUMC 4   0   Revaluation Period for an Asset  
950 PAST_VALUED_DATE CMS_DTE_VALN_DATE CMS_DATE DATS 8   0   Last Date on which the Asset was Valued  
951 START_DATE CMS_DTE_START_DATE CMS_DATE DATS 8   0   Date on which the First Valuation is Performed on the Asset  
952 END_DATE CMS_DTE_END_DATE CMS_DATE DATS 8   0   Date on which the Last Valuation is Performed on the Asset  
953 .INCLUDE       0   0   Lending rate data  
954 LENDING_RATE_IND CMS_DTE_IND_LND_RTE CMS_IND_LRTE CHAR 2   0   Indicator to specify if Asset has a Default Lending Rate  
955 .INCLUDE       0   0   Lending rates structure  
956 LENDING_RATE1 CMS_DTE_LRTE_PCT1 CMS_PCT DEC 10   6   Lending Rate 1  
957 LENDING_RATE2 CMS_DTE_LRTE_PCT2 CMS_PCT DEC 10   6   Lending Rate 2  
958 LENDING_RATE3 CMS_DTE_LRTE_PCT3 CMS_PCT DEC 10   6   Lending Rate 3  
959 LENDING_RATE4 CMS_DTE_LRTE_PCT4 CMS_PCT DEC 10   6   Lending Rate 4  
960 LENDING_RATE5 CMS_DTE_LRTE_PCT5 CMS_PCT DEC 10   6   Lending Rate 5  
961 .INCLUDE       0   0   Liquidation rights data  
962 LIQD_TYP CMS_DTE_LIQD_TYP CMS_TYP CHAR 6   0   Liquidation Type  
963 LIQD_REASON CMS_DTE_ATT_ID_TY_AST004 CMS_ATT_ID_TYP CHAR 6   0   Liquidation Reason  
964 LIQD_DATE CMS_DTE_LIQD_DATE CMS_DATE DATS 8   0   Date on which the Collateral was Liquidated  
965 LIQD_AMT CMS_DTE_LIQD_VALUE CMS_AMOUNT CURR 17   2   Returns from the Liquidation of Collateral  
966 LIQD_CURR CMS_DTE_LIQD_CURR WAERS CUKY 5   0   Currency of Liquidation Value  
967 EXP_PRCD_AMNT CMS_DTE_LIQ_EXP_PRCD_AMOUNT CMS_AMOUNT CURR 17   2   Expected Proceed Amount  
968 EXP_PRCD_CURR CMS_DTE_LIQ_EXP_PRCD_CURR WAERS CUKY 5   0   Currency: Expected Proceed  
969 EXP_ACC_DATE CMS_DTE_LIQ_EXP_ACCRUAL_DATE CMS_DATE DATS 8   0   Expected accrual date  
970 .INCLUDE       0   0   Account for liquidation proceeds  
971 ACC_NUMBER_LIQ CMS_DTE_LIQ_ACC_NUMBER BANKN35 CHAR 35   0   Account number for liquidation proceeds  
972 BANK_CNTRY_LIQ CMS_DTE_LIQ_BNK_CTRY_KY LAND1 CHAR 3   0   Bank country key  
973 BANK_KEY_LIQ CMS_DTE_LIQ_BNK_KEY BANKK CHAR 15   0   Bank Key  
974 BANK_CTRLKEY_LIQ BKONT BKONT CHAR 2   0   Bank Control Key  
975 .INCLUDE       0   0   Verfication Data  
976 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  
977 PERIOD_VERF_FREQ CMS_DTE_AST_VERF_FREQ_PERIOD CMS_AST_VERF_FREQ_PERIOD NUMC 4   0   Statement Period for an Asset  
978 LAST_VERF_DATE CMS_DTE_AST_VERF_DATE CMS_DATE DATS 8   0   Last Verification Date  
979 .INCLUDE       0   0   AST PKy and Type and Parent GUID  
980 AST_GUID CMS_DTE_AST_GUID SYSUUID RAW 16   0   GUID for Table CMS_AST  
981 AST_TYP CMS_DTE_AST_TYP CMS_AST_TYP CHAR 6   0   Asset Type  
982 PARENT_GUID CMS_DTE_SAS_PAR_GUID SYSUUID RAW 16   0   Asset Guid as a parent GUID for a sub-asset  
983 .INCLUDE       0   0   Structure for Asset values  
984 NOM_VALUE CMS_DTE_AST_NOMINAL_VALUE CMS_AMOUNT CURR 17   2   Nominal Value of the Asset  
985 NOM_VALUE_CURR CMS_DTE_AST_NOMINAL_VALUE_CURR WAERS CUKY 5   0   Currency of Nominal value  
986 AST_VALUE CMS_DTE_AST_VALUE CMS_AMOUNT CURR 17   2   Final Asset Value  
987 AST_VALUE_CURR CMS_DTE_AST_VALUE_CURR WAERS CUKY 5   0   Currency of the Final Asset Value  
988 QUANTITY CMS_DTE_QTY CMS_QTY QUAN 13   3   Quantity  
989 UNIT_OF_MEASURE CMS_DTE_UNIT MEINS UNIT 3   0   Unit of Measure of Quantity  
990 REC_AT CMS_DTE_REC_AT TZNTSTMPS DEC 15   0   Asset Value Recording Timestamp  
991 .INCLUDE       0   0   Purchase price data  
992 PUR_PRICE CMS_DTE_AST_PURCHASE_PRICE CMS_AMOUNT CURR 17   2   Purchase Price of the Asset  
993 PUR_PRICE_CURR CMS_DTE_AST_PUR_PRICE_CURR WAERS CUKY 5   0   Currency of Purchase Price  
994 PUR_DATE CMS_DTE_AST_PUR_PRICE_DATE CMS_DATE DATS 8   0   Date of Purchase  
995 .INCLUDE       0   0   Administrative organization unit  
996 ADMIN_ORG_UNIT CMS_DTE_ADMINORG TEXT12 CHAR 12   0   Administration Organizational Unit  
997 .INCLUDE       0   0   Bank area  
998 BANKAREA CMS_DTE_BANKAREA CMS_BANKAREA CHAR 4   0   Bank Area in Collateral Management  
999 .INCLUDE       0   0   Organization unit structure  
1000 ORG_UNIT1 CMS_DTE_ORG_UNIT1 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 1  
1001 ORG_UNIT2 CMS_DTE_ORG_UNIT2 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 2  
1002 ORG_UNIT3 CMS_DTE_ORG_UNIT3 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 3  
1003 ORG_UNIT4 CMS_DTE_ORG_UNIT4 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 4  
1004 ORG_UNIT5 CMS_DTE_ORG_UNIT5 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 5  
1005 .INCLUDE       0   0   Inventory Specific details  
1006 IDEN_ACC CMS_DTE_INV_IDEN_ACC CMS_SEC_FLG CHAR 1   0   Identification land accessories  
1007 BILL_NO CMS_DTE_INV_BILL_NO CMS_INV_BILL_NO CHAR 20   0   Bill number of the inventory  
1008 UNIT_PRICE CMS_DTE_INV_UNIT_PRICE CMS_AMOUNT CURR 17   2   Unit Price  
1009 UNIT_PRICE_CURR CMS_DTE_INV_UNIT_CURR WAERS CUKY 5   0   Currency for unit price  
1010 TYPE_STK_EXCH CMS_DTE_INV_TYPE_STK_EXCH CMS_ATT_ID_TYP CHAR 6   0   Type of stock exchange  
1011 STK_EXCH_ID CMS_DTE_INV_STK_EXCH_ID CMS_ATT_ID_TYP CHAR 6   0   Place of stock exchange  
1012 RATE_FIX_DAT CMS_DTE_INV_RATE_FIX_DAT DATUM DATS 8   0   Date of previous quotation  
1013 DET_PRICE CMS_DTE_INV_DET_PRICE CMS_AMOUNT CURR 17   2   Determined price  
1014 DET_CURR CMS_DTE_INV_DET_CURR WAERS CUKY 5   0   Currency for determined price  
1015 STOCK_QUANTITY CMS_DTE_INV_QTY CMS_QTY QUAN 13   3   Quantity of inventory  
1016 STOCK_UOM CMS_DTE_UNIT MEINS UNIT 3   0   Unit of Measure of Quantity  
1017 .INCLUDE       0   0   Stucture to record history of changes in all application tab  
1018 CREATED_BY CMS_DTE_USER CMS_USER CHAR 12   0   Login ID of the User who created the Record  
1019 CREATED_AT CMS_DTE_CREATED_AT TZNTSTMPS DEC 15   0   Creation Timestamp  
1020 CHANGED_BY CMS_DTE_LAST_CHNG_USER CMS_USER CHAR 12   0   Last Changed By  
1021 CHANGED_AT CMS_DTE_CHANGED_AT TZNTSTMPS DEC 15   0   Change Timestamp  
1022 SOURCEOFENTRY CMS_DTE_SOURCE_OF_ENTRY CMS_SOURCE CHAR 32   0   Source of Entry  
1023 WA_MOV_ACR CMS_STR_ACR_MAP_GET_MLT   STRU 0   0    
1024 .INCLUDE       0   0   Primary Key for CMS_MOVABLES  
1025 MOV_GUID CMS_DTE_MOV_GUID SYSUUID RAW 16   0   GUID for CMS_MOVABLES  
1026 .INCLUDE       0   0   Semantic Key  
1027 MOV_CATEGORY CMS_DTE_OMS_OBJ_CAT CMS_OBJ_CAT CHAR 6   0   Object Category  
1028 MOV_TYP CMS_DTE_MOV_TYP CMS_MOV_TYP CHAR 6   0   Movable types  
1029 MOV_ID CMS_DTE_MOV_ID CMS_MOV_ID CHAR 40   0   Identification Number  
1030 MOV_CAT_NAME CMS_DTE_OMS_CAT_NAME CMS_OMS_CAT_NAME CHAR 40   0   Object Category Name  
1031 MOV_TYP_NAME CMS_DTE_MOV_TYP_NAME CMS_MOV_NAME CHAR 40   0   Name in a specified language  
1032 .INCLUDE       0   0   Common Movable data  
1033 MOV_DESC CMS_DTE_MOV_DESC CMS_MOV_DESC CHAR 30   0   Description of the object  
1034 MOV_IDT_ACC CMS_DTE_MOV_IDT_ACC CMS_MOV_IDT_ACC CHAR 1   0   Identification accessories  
1035 .INCLUDE       0   0   Object Specific Features for Description  
1036 MOV_MODEL_NAM CMS_DTE_MOV_MODEL_NAM CMS_MOV_MODEL_NAM CHAR 30   0   Technical Category/Category term/Description  
1037 MOV_MANUFACTURER CMS_DTE_MOV_MANUFACTURER CMS_MOV_MANUFACTURER CHAR 30   0   Object Manufacturer Builder  
1038 MOV_MANU_DAT CMS_DTE_MOV_MANU_DAT CMS_MOV_MANU_DAT DATS 8   0   Date of the Manufacture/Purchase  
1039 ADDR_ID CMS_DTE_MOV_LOCATION AD_ADDRNUM CHAR 10   0   Location / Address  
1040 MOV_LOC_DESC CMS_DTE_MOV_LOC_DESC CMS_ATT_ID_TYP CHAR 6   0   Location Description  
1041 MOV_LOC_DE_RMRK CMS_DTE_MOV_LOC_DESC_RMRK CMS_MOV_LOC_DESC_RMRK CHAR 30   0   Remark Field for Location Description  
1042 MOV_IDEN_TYP CMS_DTE_MOV_TYPE_IDENT CMS_ATT_ID_TYP CHAR 6   0   Type of identification / Marking of the collateral material  
1043 MOV_DESC_COL_MAT CMS_DTE_OMS_DESC_IDENT_COL_MAT CMS_OMS_DESC_COL_MAT CHAR 30   0   Bank's Own Identifcation  
1044 MOV_DOP CMS_DTE_MOV_DOP CMS_MOV_DOP DATS 8   0   Date of Purchase  
1045 MOV_IDENT CMS_DTE_MOV_IDENT CMS_MOV_IDENT CHAR 2   0   Commercial usage  
1046 MOV_UOB CMS_DTE_MOV_UOB CMS_ATT_ID_TYP CHAR 6   0   Use of the object  
1047 MOV_MANU_CNTRY CMS_DTE_MOV_MANU_CNTRY LAND1 CHAR 3   0   Manufacturing Country  
1048 MOV_TYPE_FEAT CMS_DTE_MOV_TYPE_FEAT CMS_MOV_TYPE_FEAT CHAR 6   0   Classification  
1049 .INCLUDE       0   0   Common OMS data  
1050 EXT_ITM_NO CMS_DTE_OMS_EXT_ITM_NO CMS_OMS_ID CHAR 40   0   Ext. Item no / Number for identification of the objects  
1051 EXT_REFERENCE CMS_DTE_OMS_REF_ID CMS_OMS_REFID CHAR 32   0   Reference number for the legacy system  
1052 .INCLUDE       0   0   Template Information  
1053 IS_TEMPLATE CMS_DTE_MOV_FLG_TEMPLATE CMS_MOV_FLG CHAR 1   0   Type to be used as template  
1054 TEMPLATE_ID CMS_DTE_MOV_TEMPLATE_ID SYSUUID RAW 16   0   Template ID  
1055 .INCLUDE       0   0   Aircraft data  
1056 .INCLUDE       0   0   Aircraft data  
1057 ACR_DELVDAT CMS_DTE_MOV_DELVDAT CMS_MOV_DELVDAT DATS 8   0   Delivery Date  
1058 ACR_REG CMS_DTE_MOV_REG CMS_MOV_REG CHAR 1   0   Registered  
1059 ACR_REGC CMS_DTE_MOV_REGC LAND1 CHAR 3   0   Registration Country  
1060 ACR_REGM CMS_DTE_MOV_REGM CMS_MOV_REGM CHAR 6   0   Registration Mark  
1061 ACR_RC CMS_DTE_MOV_RC CMS_MOV_RC CHAR 30   0   Registration Comments  
1062 ACR_EMAN CMS_DTE_MOV_EMAN CMS_MOV_EMAN CHAR 30   0   Engine Manufacturer  
1063 ACR_EMOD CMS_DTE_MOV_EMOD CMS_MOV_EMOD CHAR 12   0   Engine Model  
1064 ACR_EPOOL CMS_DTE_MOV_EPOOL CMS_MOV_EPOOL CHAR 10   0   Engine pooling  
1065 ACR_EPRMK CMS_DTE_MOV_EPRMK CMS_MOV_EPRMK CHAR 30   0   Engine pooling remarks  
1066 ACR_NOE CMS_DTE_MOV_NOE CMS_MOV_NOE INT4 10   0   Number of Engines  
1067 ACR_NAME CMS_DTE_MOV_OM CMS_MOV_OM CHAR 30   0   Object name  
1068 ACR_MTOW CMS_DTE_MOV_MTOW CMS_MOV_MTOW QUAN 13   3   Maximum take-off weight  
1069 ACR_MTOW_UNT CMS_DTE_MOV_MTOW_UNT MEINS UNIT 3   0   Maximum take off weight (Unit)  
1070 ACR_NOB CMS_DTE_MOV_NOB CMS_MOV_NOB INT1 3   0   Number of objects  
1071 ACR_MSNNO CMS_DTE_MOV_MSNNO CMS_MOV_MSNNO CHAR 10   0   MSN Number  
1072 .INCLUDE       0   0   Rating  
1073 ACR_RATCLS CMS_DTE_MOV_RATCLS CMS_ATT_ID_TYP CHAR 6   0   Rating Class  
1074 ACR_RATD CMS_DTE_MOV_RATD CMS_MOV_RATD DATS 8   0   Rating Date  
1075 .INCLUDE       0   0   MAPI : GET : Asset details  
1076 CATEGORY CMS_DTE_OMS_OBJ_CAT CMS_OBJ_CAT CHAR 6   0   Object Category  
1077 CATEGORY_NAME CMS_DTE_OMS_CAT_NAME CMS_OMS_CAT_NAME CHAR 40   0   Object Category Name  
1078 TYPE CMS_DTE_MOV_TYP CMS_MOV_TYP CHAR 6   0   Movable types  
1079 TYPE_NAME CMS_DTE_MOV_TYP_NAME CMS_MOV_NAME CHAR 40   0   Name in a specified language  
1080 IDENTIFICATION CMS_DTE_MOV_ID CMS_MOV_ID CHAR 40   0   Identification Number  
1081 MOV_DESCRIPTION CMS_DTE_MOV_DESC CMS_MOV_DESC CHAR 30   0   Description of the object  
1082 .INCLUDE       0   0   Structure with Asset Details for Table CMS_AST  
1083 .INCLUDE       0   0   Basic Asset data  
1084 DESCRIPTION CMS_DTE_AST_DESC CMS_DSC CHAR 30   0   Description  
1085 OBJECT_REF_ID CMS_DTE_OBJ_REFID CMS_OBJ_REFID CHAR 40   0   Reference ID for the object  
1086 OBJECT_TYP CMS_DTE_OBJ_TYP CMS_OBJ_TYP CHAR 32   0   Not used  
1087 COUNTRY_KEY CMS_DTE_AST_COUNTRY_KEY LAND1 CHAR 3   0   Identification Key for Country  
1088 RISK_CODE CMS_DTE_RISK_CODE CMS_RISK_CODE CHAR 6   0   Risk Code  
1089 SFTY_IND CMS_DTE_IND_SFTY_DISC CMS_IND_SFTY CHAR 2   0   Indicates if the Asset has a Default Safety Discount  
1090 SFTY_DSCNT CMS_DTE_SAFETY_DSCNT CMS_SFTY_PCT DEC 10   6   Percentage of Safety Discount  
1091 SFTY_AMOUNT CMS_DTE_SAFETY_AMT CMS_AMOUNT CURR 17   2   Amount of Safety Discount  
1092 SFTY_AMT_CURR CMS_DTE_SAFETY_AMT_CURR WAERS CUKY 5   0   Currency of the Safety Discount Amount  
1093 OBJSYSID CMS_DTE_OBJ_SYSID CMS_SYS CHAR 6   0   Object System Reference ID  
1094 .INCLUDE       0   0   Valuation data  
1095 VALUATION_TYP CMS_DTE_IND_VALN_TYP CMS_VALN_TYP CHAR 2   0   Type of Valuation Check performed on Collateral Object  
1096 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  
1097 PERIOD_VALN_FREQ CMS_DTE_AST_VALN_FREQ_PERIOD CMS_AST_VALN_FREQ_PERIOD NUMC 4   0   Revaluation Period for an Asset  
1098 PAST_VALUED_DATE CMS_DTE_VALN_DATE CMS_DATE DATS 8   0   Last Date on which the Asset was Valued  
1099 START_DATE CMS_DTE_START_DATE CMS_DATE DATS 8   0   Date on which the First Valuation is Performed on the Asset  
1100 END_DATE CMS_DTE_END_DATE CMS_DATE DATS 8   0   Date on which the Last Valuation is Performed on the Asset  
1101 .INCLUDE       0   0   Lending rate data  
1102 LENDING_RATE_IND CMS_DTE_IND_LND_RTE CMS_IND_LRTE CHAR 2   0   Indicator to specify if Asset has a Default Lending Rate  
1103 .INCLUDE       0   0   Lending rates structure  
1104 LENDING_RATE1 CMS_DTE_LRTE_PCT1 CMS_PCT DEC 10   6   Lending Rate 1  
1105 LENDING_RATE2 CMS_DTE_LRTE_PCT2 CMS_PCT DEC 10   6   Lending Rate 2  
1106 LENDING_RATE3 CMS_DTE_LRTE_PCT3 CMS_PCT DEC 10   6   Lending Rate 3  
1107 LENDING_RATE4 CMS_DTE_LRTE_PCT4 CMS_PCT DEC 10   6   Lending Rate 4  
1108 LENDING_RATE5 CMS_DTE_LRTE_PCT5 CMS_PCT DEC 10   6   Lending Rate 5  
1109 .INCLUDE       0   0   Liquidation rights data  
1110 LIQD_TYP CMS_DTE_LIQD_TYP CMS_TYP CHAR 6   0   Liquidation Type  
1111 LIQD_REASON CMS_DTE_ATT_ID_TY_AST004 CMS_ATT_ID_TYP CHAR 6   0   Liquidation Reason  
1112 LIQD_DATE CMS_DTE_LIQD_DATE CMS_DATE DATS 8   0   Date on which the Collateral was Liquidated  
1113 LIQD_AMT CMS_DTE_LIQD_VALUE CMS_AMOUNT CURR 17   2   Returns from the Liquidation of Collateral  
1114 LIQD_CURR CMS_DTE_LIQD_CURR WAERS CUKY 5   0   Currency of Liquidation Value  
1115 EXP_PRCD_AMNT CMS_DTE_LIQ_EXP_PRCD_AMOUNT CMS_AMOUNT CURR 17   2   Expected Proceed Amount  
1116 EXP_PRCD_CURR CMS_DTE_LIQ_EXP_PRCD_CURR WAERS CUKY 5   0   Currency: Expected Proceed  
1117 EXP_ACC_DATE CMS_DTE_LIQ_EXP_ACCRUAL_DATE CMS_DATE DATS 8   0   Expected accrual date  
1118 .INCLUDE       0   0   Account for liquidation proceeds  
1119 ACC_NUMBER_LIQ CMS_DTE_LIQ_ACC_NUMBER BANKN35 CHAR 35   0   Account number for liquidation proceeds  
1120 BANK_CNTRY_LIQ CMS_DTE_LIQ_BNK_CTRY_KY LAND1 CHAR 3   0   Bank country key  
1121 BANK_KEY_LIQ CMS_DTE_LIQ_BNK_KEY BANKK CHAR 15   0   Bank Key  
1122 BANK_CTRLKEY_LIQ BKONT BKONT CHAR 2   0   Bank Control Key  
1123 .INCLUDE       0   0   Verfication Data  
1124 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  
1125 PERIOD_VERF_FREQ CMS_DTE_AST_VERF_FREQ_PERIOD CMS_AST_VERF_FREQ_PERIOD NUMC 4   0   Statement Period for an Asset  
1126 LAST_VERF_DATE CMS_DTE_AST_VERF_DATE CMS_DATE DATS 8   0   Last Verification Date  
1127 .INCLUDE       0   0   AST PKy and Type and Parent GUID  
1128 AST_GUID CMS_DTE_AST_GUID SYSUUID RAW 16   0   GUID for Table CMS_AST  
1129 AST_TYP CMS_DTE_AST_TYP CMS_AST_TYP CHAR 6   0   Asset Type  
1130 PARENT_GUID CMS_DTE_SAS_PAR_GUID SYSUUID RAW 16   0   Asset Guid as a parent GUID for a sub-asset  
1131 .INCLUDE       0   0   Structure for Asset values  
1132 NOM_VALUE CMS_DTE_AST_NOMINAL_VALUE CMS_AMOUNT CURR 17   2   Nominal Value of the Asset  
1133 NOM_VALUE_CURR CMS_DTE_AST_NOMINAL_VALUE_CURR WAERS CUKY 5   0   Currency of Nominal value  
1134 AST_VALUE CMS_DTE_AST_VALUE CMS_AMOUNT CURR 17   2   Final Asset Value  
1135 AST_VALUE_CURR CMS_DTE_AST_VALUE_CURR WAERS CUKY 5   0   Currency of the Final Asset Value  
1136 QUANTITY CMS_DTE_QTY CMS_QTY QUAN 13   3   Quantity  
1137 UNIT_OF_MEASURE CMS_DTE_UNIT MEINS UNIT 3   0   Unit of Measure of Quantity  
1138 REC_AT CMS_DTE_REC_AT TZNTSTMPS DEC 15   0   Asset Value Recording Timestamp  
1139 .INCLUDE       0   0   Purchase price data  
1140 PUR_PRICE CMS_DTE_AST_PURCHASE_PRICE CMS_AMOUNT CURR 17   2   Purchase Price of the Asset  
1141 PUR_PRICE_CURR CMS_DTE_AST_PUR_PRICE_CURR WAERS CUKY 5   0   Currency of Purchase Price  
1142 PUR_DATE CMS_DTE_AST_PUR_PRICE_DATE CMS_DATE DATS 8   0   Date of Purchase  
1143 .INCLUDE       0   0   Administrative organization unit  
1144 ADMIN_ORG_UNIT CMS_DTE_ADMINORG TEXT12 CHAR 12   0   Administration Organizational Unit  
1145 .INCLUDE       0   0   Bank area  
1146 BANKAREA CMS_DTE_BANKAREA CMS_BANKAREA CHAR 4   0   Bank Area in Collateral Management  
1147 .INCLUDE       0   0   Organization unit structure  
1148 ORG_UNIT1 CMS_DTE_ORG_UNIT1 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 1  
1149 ORG_UNIT2 CMS_DTE_ORG_UNIT2 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 2  
1150 ORG_UNIT3 CMS_DTE_ORG_UNIT3 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 3  
1151 ORG_UNIT4 CMS_DTE_ORG_UNIT4 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 4  
1152 ORG_UNIT5 CMS_DTE_ORG_UNIT5 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 5  
1153 .INCLUDE       0   0   Inventory Specific details  
1154 IDEN_ACC CMS_DTE_INV_IDEN_ACC CMS_SEC_FLG CHAR 1   0   Identification land accessories  
1155 BILL_NO CMS_DTE_INV_BILL_NO CMS_INV_BILL_NO CHAR 20   0   Bill number of the inventory  
1156 UNIT_PRICE CMS_DTE_INV_UNIT_PRICE CMS_AMOUNT CURR 17   2   Unit Price  
1157 UNIT_PRICE_CURR CMS_DTE_INV_UNIT_CURR WAERS CUKY 5   0   Currency for unit price  
1158 TYPE_STK_EXCH CMS_DTE_INV_TYPE_STK_EXCH CMS_ATT_ID_TYP CHAR 6   0   Type of stock exchange  
1159 STK_EXCH_ID CMS_DTE_INV_STK_EXCH_ID CMS_ATT_ID_TYP CHAR 6   0   Place of stock exchange  
1160 RATE_FIX_DAT CMS_DTE_INV_RATE_FIX_DAT DATUM DATS 8   0   Date of previous quotation  
1161 DET_PRICE CMS_DTE_INV_DET_PRICE CMS_AMOUNT CURR 17   2   Determined price  
1162 DET_CURR CMS_DTE_INV_DET_CURR WAERS CUKY 5   0   Currency for determined price  
1163 STOCK_QUANTITY CMS_DTE_INV_QTY CMS_QTY QUAN 13   3   Quantity of inventory  
1164 STOCK_UOM CMS_DTE_UNIT MEINS UNIT 3   0   Unit of Measure of Quantity  
1165 .INCLUDE       0   0   Stucture to record history of changes in all application tab  
1166 CREATED_BY CMS_DTE_USER CMS_USER CHAR 12   0   Login ID of the User who created the Record  
1167 CREATED_AT CMS_DTE_CREATED_AT TZNTSTMPS DEC 15   0   Creation Timestamp  
1168 CHANGED_BY CMS_DTE_LAST_CHNG_USER CMS_USER CHAR 12   0   Last Changed By  
1169 CHANGED_AT CMS_DTE_CHANGED_AT TZNTSTMPS DEC 15   0   Change Timestamp  
1170 SOURCEOFENTRY CMS_DTE_SOURCE_OF_ENTRY CMS_SOURCE CHAR 32   0   Source of Entry  
1171 T_MOV_USR_ST CMS_TAB_COR_MOV_USR_STAT   TTYP 0   0    
1172 T_MOV_SYS_ST CMS_TAB_COR_MOV_SYS_STAT   TTYP 0   0    
1173 T_MOV_NOTES CMS_TAB_COR_MOV_NOTES   TTYP 0   0    
1174 T_MOV_INSDOC CMS_TAB_COR_MOV_INS_DOC   TTYP 0   0    
1175 T_MOV_INS_BP CMS_TAB_COR_MOV_INS_BP   TTYP 0   0    
1176 T_MOV_INS CMS_TAB_COR_MOV_INS   TTYP 0   0    
1177 T_MOV_PRT CMS_TAB_COR_MOV_PRT   TTYP 0   0    
1178 T_MOV_VAL CMS_TAB_COR_MOV_VAL   TTYP 0   0    
1179 T_MOV_DOC CMS_TAB_COR_MOV_DOC   TTYP 0   0    
1180 T_MOV_BP CMS_TAB_COR_MOV_BP   TTYP 0   0    
History
Last changed by/on SAP  20130529 
SAP Release Created in 500