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 |