SAP ABAP Table CMS_STR_COR_MOV_REQ (OMS:Movables general)
Hierarchy
☛
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
⤷
FS-CMS (Application Component) Collateral Management System
⤷
CMS_COR (Package) Correspondence serivce for CMS

⤷

⤷

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