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
⤷ 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 |