PATCH C-TMS P043: Difference between revisions

From Calidus HUB
VisualWikitext
(Created page with "<div class="noprint"> {{#vardefine:ClientName|<br />}} {{#vardefine:System|''CALIDUS'' TMS}} {{#vardefine:Doc_Title|Release Notes}} {{#vardefine:Version|1.0}} {{#vardefine:Date|1...")
 
No edit summary
Line 202: Line 202:
|}
|}
-->
-->
{| border="1" width="100%"
| ACC_CTRL.fmx || 2.56 || Access control maintenance || 00349335
|- bgcolor="silver"
!Module Name !! Version No !! Description !! Log Number
|-
|-
|  ||  ||  ||  
| ADM.sql || 5.12 || Administrator package containing various DB utils || 00349335
|-
| AT_CNT_CHARGE_CONDITIONS_TRACTOR_340479.sql || 1.1 || AT Script || 00340479
|-
| AT_CNT_CHARGE_CONDITIONS_TRLRTYPE_340479.sql || 1.1 || AT Script || 00340479
|-
| AT_CNT_CHARGE_MIN_MAX_340479.sql || 1.1 || AT Script || 00340479
|-
| AT_CNT_CHARGE_PARAM_340479.sql || 1.1 || AT Script || 00340479
|-
| AT_CNT_CHARGE_TYPE_340479.sql || 1.1 || AT Script || 00340479
|-
| AT_CNT_CONDITION_340479.sql || 1.1 || AT Script || 00340479
|-
| AT_CNT_CONDITION_VALUE_340479..sql || 1.1 || AT Script || 00340479
|-
| AT_CNT_CONTRACT_INDEX_340479.sql || 1.1 || AT Script || 00340479
|-
| AT_CNT_CUST_LOC_GROUP_340479.sql || 1.1 || AT Script || 00340479
|-
| AT_CNT_DEL_TYPE_340479.sql || 1.1 || AT Script || 00340479
|-
| AT_CNT_DEL_TYPE_CONV_340479.sql || 1.1 || AT Script || 00340479
|-
| AT_CNT_DEL_TYPE_CUST_EXCL_340479.sql || 1.1 || AT Script || 00340479
|-
| AT_CNT_DEL_TYPE_USE_340479.sql || 1.1 || AT Script || 00340479
|-
| AT_CNT_RHA_CONFIG_340479.sql || 1.1 || AT Script || 00340479
|-
| AT_CNT_RHA_INDEX_340479.sql || 1.1 || AT Script || 00340479
|-
| AT_CNT_SERVICE_CHARGES_340479.sql || 1.1 || AT Script || 00340479
|-
| AT_CNT_SERVICE_CONTRACTS_340479.sql || 1.1 || AT Script || 00340479
|-
| AT_CNT_SERVICE_LEVEL_340479.sql || 1.1 || AT Script || 00340479
|-
| AT_CNT_STD_JOURNEY_340479.sql || 1.1 || AT Script || 00340479
|-
| AT_CNT_TIER_NAME_340479.sql || 1.1 || AT Script || 00340479
|-
| AT_GEO_LOCATION_00322441.sql || 1.1 || AT Script || 00322441
|-
| AT_IMP_FIELD_340479.sql || 1.1 || AT Script || 00340479
|-
| AT_IMP_FIELD_SOURCE_340479.sql || 1.1 || AT Script || 00340479
|-
| AT_IMP_FORMULA_340479.sql || 1.1 || AT Script || 00340479
|-
| AT_IMP_HIST_DETAIL_340479.sql || 1.1 || AT Script || 00340479
|-
| AT_IMP_HIST_HEADER_340479.sql || 1.1 || AT Script || 00340479
|-
| AT_IMP_IMPORT_TYPE_340479.sql || 1.1 || AT Script || 00340479
|-
| AT_IMP_IMPORT_TYPE_REC_TYPE_340479.sql || 1.1 || AT Script || 00340479
|-
| AT_IMP_LOAD_AUDIT_340479.sql || 1.1 || AT Script || 00340479
|-
| AT_IMP_ORDERS_340479.sql || 1.1 || AT Script || 00340479
|-
| AT_IMP_RECORD_FORMAT_340479.sql || 1.1 || AT Script || 00340479
|-
| AT_INT_XML_ORD_HEADER_00368493.sql || 1.1 || AT Script || 00368493
|-
| AT_ORD_TYRE_INSPECTIONS_00350912.sql || 1.1 || AT Script || 00350912
|-
| AT_ORG_CUSTOMER_00322441.sql || 1.1 || AT Script || 00322441
|-
| AT_ORG_CUSTOMER_00368493.sql || 1.1 || AT Script || 00368493
|-
| AT_RES_VEHICLE_AXLE_00350912.sql || 1.1 || AT Script || 00350912
|-
| AT_RES_VEHICLE_CONFIG_AXLE_00367465.sql || 1.1 || AT Script || 00367465
|-
| AT_RES_VEHICLE_TYRE_00350912.sql || 1.1 || AT Script || 00350912
|-
| AT_RTE_ROUTE_00322438.sql || 1.1 || AT Script || 00322438
|-
| AT_RTE_ROUTE_00323035.sql || 1.1 || AT Script || 00323035
|-
| AT_SCH_ORD_ITEMS_00350912.sql || 1.1 || AT Script || 00350912
|-
| AT_TOMTOM_ETA_EVENTS_374083.sql || 1.1 || AT Script || 00374083
|-
| AT_TRM_CARRIER_COST_374083.sql || 1.1 || AT Script || 00374083
|-
| AT_WMS_PRODUCT_XREF_00351008.sql || 1.1 || AT Script || 00351008
|-
| BDM.fmx || 2.106 || Business Data Form || 00326413
|-
| BDM.fmx || 2.108 || Business Data Form || 00349283
|-
| CARRIER_RULES.fmx || 1.16 || Carrier Rules Maintenance Screen || 00318182
|-
| CONTRACT.fmx || 2.75 || Contracts Form || 02128610
|-
| CONTRACT.fmx || 2.76 || Contracts Form || 00340479
|-
| CONTRACT.fmx || 2.77 || Contracts Form || 00349874
|-
| CT_GEO_DELIVERY_ROUTE_PRIORITY.sql || 1.3 || CT Script || 00326413
|-
| CT_GEO_LOCATION_WINDOW_00322441.sql || 1.1 || CT Script || 00322441
|-
| CT_GEO_ROUTE_DTLS.sql || 1.3 || CT Script || 00326413
|-
| CT_PAR_API_STAGING_ROUTE.sql || 1.2 || CT Script || 00326413
|-
| CT_PAR_JSON_IN_ROUTE.sql || 1.3 || CT Script || 00326413
|-
| CT_PAR_KEYS_ROUTE.sql || 1.3 || CT Script || 00326413
|-
| CT_SEQ_GEO_LOCATION_WINDOW_00322441.sql || 1.1 || CT Script || 00322441
|-
| CT_SEQ_GEO_ROUTE_DTLS.sql || 1.2 || CT Script || 00326413
|-
| CT_SEQ_TT_DRIVE_02156578.sql || 1.1 || CT Script || 00345445
|-
| CT_SEQ_TT_WORK_02156578.sql || 1.1 || CT Script || 00345445
|-
| CT_TOM_DRIVE_02156578.sql || 1.1 || CT Script || 00345445
|-
| CT_TOM_WORK_02156578.sql || 1.1 || CT Script || 00345445
|-
| CUST_COST.fmx || 2.140 || Customer Maintenance form || 00318182
|-
| CUST_COST.fmx || 2.141 || Customer Maintenance form || 00322441
|-
| DATA_ADM_FUNCTION_322353.sql || 1.1 || Data Script || 02128610
|-
| DATA_ADM_LOG_PROG_NAME_02111893.sql || 1.2 || Data Script || 02111893
|-
| DATA_ADM_LOG_PROG_NAME_349283.sql || 1.1 || Data Script || 00349283
|-
| DATA_ADM_SYSTEM_PARAM_00322438.sql || 1.1 || Data Script || 00322438
|-
| DATA_ADM_SYSTEM_PARAM_00323035.sql || 1.2 || Data Script || 00323035
|-
| DATA_ADM_SYSTEM_PARAM_00330994.sql || 1.1 || Data Script || 00330994
|-
| DATA_ADM_SYSTEM_PARAM_00351271.sql || 1.1 || Data Script || 00351271
|-
| DATA_ADM_SYSTEM_PARAM_00357019.sql || 1.1 || Data Script || 00357019
|-
| DATA_ADM_SYSTEM_PARAM_00365766.sql || 1.1 || Data Script || 00365766
|-
| DATA_ADM_SYSTEM_PARAM_00368493.sql || 1.1 || Data Script || 00368493
|-
| DATA_ADM_SYSTEM_PARAM_00371509.sql || 1.1 || Data Script || 00371509
|-
| DATA_ADM_SYSTEM_PARAM_02111893.sql || 1.3 || Data Script || 02111893
|-
| DATA_ADM_SYSTEM_PARAM_02124442.sql || 1.1 || Data Script || 00328694
|-
| DATA_ADM_SYSTEM_PARAM_02128190.sql || 1.1 || Data Script || 02128190
|-
| DATA_ADM_SYSTEM_PARAM_02139434.sql || 1.1 || Data Script || 02139434
|-
| DATA_ADM_SYSTEM_PARAM_02156578.sql || 1.1 || Data Script || 00345445
|-
| DATA_ADM_SYSTEM_PARAM_02165959.sql || 1.1 || Data Script || 02165959
|-
| DATA_ADM_SYSTEM_PARAM_02231368.sql || 1.1 || Data Script || 02231368
|-
| DATA_ADM_SYSTEM_PARAM_315981.sql || 1.1 || Data Script || 00315981
|-
| DATA_ADM_SYSTEM_PARAM_318182.sql || 1.1 || Data Script || 00318182
|-
| DATA_ADM_SYSTEM_PARAM_320489.sql || 1.2 || Data Script || 00320489
|-
| DATA_ADM_SYSTEM_PARAM_327516.sql || 1.1 || Data Script || 00327516
|-
| DATA_ADM_SYSTEM_PARAM_328687.sql || 1.1 || Data Script || 00328687
|-
| DATA_ADM_SYSTEM_PARAM_344993.sql || 1.1 || Data Script || 00344993
|-
| DATA_ADM_SYSTEM_PARAM_349335.sql || 1.1 || Data Script || 00349335
|-
| DATA_ADM_SYSTEM_PARAM_CONFIG_327516.sql || 1.1 || Data Script || 00327516
|-
| DATA_ADM_USER_PARAM_002118515.sql || 5.1 || Data Script || 00333266
|-
| DATA_ADM_USER_PARAM_TYPE_002118515.sql || 5.1 || Data Script || 00333266
|-
| DATA_ADM_USER_PARAM_TYPE_00349334.sql || 1.1 || Data Script || 00349334
|-
| DATA_EDI_FLOW_TYPES_00344579.sql || 1.1 || Data Script || 00344579
|-
| DATA_GEO_LOC_TYPE_346821.sql || 1.1 || Data Script || 00346821
|-
| DATA_MSG_EVENT_TYPE_00323035.sql || 1.1 || Data Script || 00323035
|-
| DATA_REP_REPORT_00368493.sql || 1.1 || Data Script || 00368493
|-
| DATA_REP_REPORT_PARAM_00368493.sql || 1.1 || Data Script || 00368493
|-
| DP_ASKGEO.sql || 1.3 || AskGEO Interface || 00374777
|-
| DP_CARRIER_API.sql || 5.10 || Database Package || 02165959
|-
| DP_CARRIER_API.sql || 5.11 || Carrier API Database Package || 00353959
|-
| DP_CTMS_IMPORT.sql || 5.11 || API Import Database Package || 00332893
|-
| DP_CTMS_IMPORT.sql || 5.12 || API Import Database Package || 00335523
|-
| DP_CTMS_IMPORT.sql || 5.15 || API Import Database Package || 00322441
|-
| DP_CTMS_IMPORT.sql || 5.16 || API Import Database Package || 00355355
|-
| DP_CTMS_IMPORT.sql || 5.17 || API Import Database Package || 00355519
|-
| DP_CTMS_IMPORT.sql || 5.18 || API Import Database Package || 00365766
|-
| DP_CTMS_IMPORT.sql || 5.20 || API Import Database Package || 00368621
|-
| DP_CTMS_IMPORT.sql || 5.7 || Database Package || 00320472
|-
| DP_CTMS_IMPORT.sql || 5.8 || API Import Database Package || 00322438
|-
| DP_CTMS_IMPORT.sql || 5.9 || API Import Database Package || 00332122
|-
| DP_CUST_SERV.sql || 1.39 || Customer Service Package || 00315981
|-
| DP_CUST_SERV.sql || 1.41 || Customer Service Package || 00333266
|-
| DP_CUST_SERV.sql || 1.42 || Customer Service Package || 00338487
|-
| DP_CUST_SERV.sql || 1.45 || Customer Service Package || 00340142
|-
| DP_CUST_SERV.sql || 1.46 || Customer Service Package || 00342094
|-
| DP_CUST_SERV.sql || 1.47 || Customer Service Package || 00344993
|-
| DP_CUST_SERV.sql || 1.48 || Customer Service Package || 00346821
|-
| DP_CUST_SERV.sql || 1.49 || Customer Service Package || 00349334
|-
| DP_CUST_SERV.sql || 1.50 || Customer Service Package || 00355544
|-
| DP_CUST_SERV.sql || 1.51 || Customer Service Package || 00355562
|-
| DP_CUST_SERV.sql || 1.52 || Customer Service Package || 00360149
|-
| DP_CUST_SERV.sql || 1.53 || Customer Service Package || 00356212
|-
| DP_CUST_SERV.sql || 1.54 || Customer Service Package || 00365146
|-
| DP_CUST_SERV.sql || 1.55 || Customer Service Package || 00366764
|-
| DP_EPOD_WEB_SERVICE.sql || 1.151 || EPOD Web Service || 00325648
|-
| DP_EPOD_WEB_SERVICE.sql || 1.152 || EPOD Web Service || 00325803
|-
| DP_EPOD_WEB_SERVICE.sql || 1.153 || EPOD Web Service || 00328694
|-
| DP_EPOD_WEB_SERVICE.sql || 1.156 || EPOD Web Service || 00328687
|-
| DP_EPOD_WEB_SERVICE.sql || 1.157 || EPOD Web Service || 00336332
|-
| DP_EPOD_WEB_SERVICE.sql || 1.158 || EPOD Web Service || 00340343
|-
| DP_EPOD_WEB_SERVICE.sql || 1.159 || EPOD Web Service || 00340339
|-
| DP_EPOD_WEB_SERVICE.sql || 1.160 || EPOD Web Service || 00341214
|-
| DP_EPOD_WEB_SERVICE.sql || 1.161 || EPOD Web Service || 00345010
|-
| DP_EPOD_WEB_SERVICE.sql || 1.162 || EPOD Web Service || 00345445
|-
| DP_EPOD_WEB_SERVICE.sql || 1.163 || EPOD Web Service || 00349336
|-
| DP_EPOD_WEB_SERVICE.sql || 1.164 || EPOD Web Service || 00350925
|-
| DP_EPOD_WEB_SERVICE.sql || 1.165 || EPOD Web Service || 00355573
|-
| DP_EPOD_WEB_SERVICE.sql || 1.166 || EPOD Web Service || 00356803
|-
| DP_EPOD_WEB_SERVICE.sql || 1.167 || EPOD Web Service || 00364252
|-
| DP_EPOD_WEB_SERVICE.sql || 1.168 || EPOD Web Service || 00365467
|-
| DP_EPOD_WEB_SERVICE.sql || 1.169 || EPOD Web Service || 00365797
|-
| DP_EPOD_WEB_SERVICE.sql || 1.170 || EPOD Web Service || 00366524
|-
| DP_EPOD_WEB_SERVICE.sql || 1.171 || EPOD Web Service || 00366787
|-
| DP_EPOD_WEB_SERVICE.sql || 1.172 || EPOD Web Service || 00366861
|-
| DP_EPOD_WEB_SERVICE.sql || 1.173 || EPOD Web Service || 00371961
|-
| DP_EPOD_WEB_SERVICE.sql || 1.174 || EPOD Web Service || 00371509
|-
| DP_EPOD_WEB_SERVICE.sql || 1.175 || EPOD Web Service || 00373035
|-
| DP_EPOD_WEB_SERVICE.sql || 1.176 || EPOD Web Service || 00372373
|-
| DP_EPOD_WEB_SERVICE.sql || 1.177 || EPOD Web Service || 00372699
|-
| DP_EXPORT_EVENTS.sql || 5.11 || API Export Events Database Package || 02135828
|-
| DP_EXPORT_EVENTS.sql || 5.12 || API Export Events Database Package || 00326046
|-
| DP_EXPORT_EVENTS.sql || 5.13 || API Export Events Database Package || 00332107
|-
| DP_EXPORT_EVENTS.sql || 5.15 || API Export Events Database Package || 00339287
|-
| DP_EXPORT_EVENTS.sql || 5.17 || API Export Events Database Package || 00314793
|-
| DP_EXPORT_EVENTS.sql || 5.18 || API Export Events Database Package || 00325239
|-
| DP_EXPORT_EVENTS.sql || 5.20 || API Export Events Database Package || 00340340
|-
| DP_EXPORT_EVENTS.sql || 5.21 || API Export Events Database Package || 00345032
|-
| DP_EXPORT_EVENTS.sql || 5.22 || API Export Events Database Package || 02231368
|-
| DP_FORD_EDI_IN.sql || 5.1 || Database Package || 00344579
|-
| DP_FORD_EDI_IN.sql || 5.2 || Database Package || 02227349
|-
| DP_IMP_2.sql || 1.81 || Import Package || 00318182
|-
| DP_INT_TMS_WMS_IN_STUB.sql || 1.23 || Inbound WMS/TMS Interface Package || 00318182
|-
| DP_INT_XML_CFX.sql || 1.7 || CFX Interface Database Package || 02232219
|-
| DP_INT_XML_MIC2.sql || 1.35 || CTMS to MIC Interface || 02111893
|-
| DP_INT_XML_MIC2.sql || 1.36 || CTMS to MIC Interface || 02243017
|-
| DP_LFE_POD.sql || 5.6 || LFE POD Database Package || 02224778
|-
| DP_NOKIA_LOC_PLAT.sql || 1.37 || Nokia Location Platform Interface || 00345445
|-
| DP_PAR_API.sql || 5.8 || Database Package || 00345445
|-
| DP_PAR_API.sql || 5.9 || Database Package || 02231368
|-
| DP_PAR_API_STP.sql || 5.1 || Database Package || 00323035
|-
| DP_PULSE.sql || 1.51 || Pulse Interface Package || 00318182
|-
| DP_RDT_AUTO.sql || 5.47 || Client specific RDT funtions || 02139434
|-
| DP_RDT_FAST_UNLOAD.sql || 5.48 || RF Unload Package || 01935522
|-
| DP_REPORTS.sql || 5.72 || Reports package || 00327382
|-
| DP_REPORTS.sql || 5.73 || Reports package || 00368493
|-
| DP_SCHEDULING_ENGINE.sql || 5.179 || Scheduling Package || 00326413
|-
| DP_SCHEDULING_ENGINE.sql || 5.180 || Scheduling Package || 00323035
|-
| DP_SCHEDULING_ENGINE.sql || 5.181 || Scheduling Package || 00357019
|-
| DP_TOMTOM.sql || 1.38 || TomTom Package || 00330994
|-
| DP_TOMTOM.sql || 1.39 || TomTom Package || 00345445
|-
| DP_TOMTOM.sql || 1.40 || TomTom Package || 02231368
|-
| DP_TRM_CHANGE_SCHEDULE.sql || 5.1 || Database Package || 00345445
|-
| DP_TRM_CHANGE_SCHEDULE.sql || 5.2 || Database Package || 00350325
|-
| DP_WEB_SERVICE_ORD.sql || 1.30 || Web Service Package || 00318182
|-
| DP_XML_EPOD.sql || 1.4 || XML Database Package || 00335523
|-
| DP_XML_EPOD.sql || 1.5 || XML Database Package || 00325239
|-
| EDI_MAINT.fmx || 10.17 || EDI Maintenance Screen || 00357019
|-
| EXECUTION.fmx || 1.108 || Execution screen || 00318182
|-
| IMP.sql || 5.215 || CSV Imports Package || 00318182
|-
| IMP.sql || 5.216 || CSV Imports Package || 00345853
|-
| IMP.sql || 5.217 || CSV Imports Package || 00350912
|-
| IMPORTS_MAINT.fmx || 1.25 || Import Maintenance Form || 00318182
|-
| INT_ERR.fmx || 1.111 || Interface Errors || 00344579
|-
| INT_ERR_ORD.fmx || 2.10 || Interface error correction || 00318182
|-
| INT_XML_IN.sql || 5.238 || Order Import Package || 00345814
|-
| INT_XML_OUT2.sql || 5.326 || Outbound XML Package || 00344924
|-
| INT_XML_OUT2.sql || 5.327 || Outbound XML Package || 00366230
|-
| INT_XML_OUT2.sql || 5.328 || Outbound XML Package || 00368176
|-
| LOCATION.fmx || 2.202 || Location Maintenance || 00279440
|-
| LOCATION.fmx || 2.203 || Location Maintenance || 00326413
|-
| LOCATION.fmx || 2.204 || Location Maintenance || 00320489
|-
| MSG_MAINT.fmx || 2.33 || Message Maintenance screen || 00318182
|-
| MSG_PROCESSING.sql || 5.75 || Message Processing package || 00330994
|-
| NETWORK.fmx || 1.18 || Network Maintenance || 00318182
|-
| OMS.sql || 5.252 || Order package || 00318182
|-
| OMS.sql || 5.253 || Order package || 02132813
|-
| OMS.sql || 5.254 || Order package || 02137857
|-
| OMS.sql || 5.255 || Order package || 02222075
|-
| OMS.sql || 5.257 || Order package || 02263060
|-
| OMS.sql || 5.329 || Order package || 00368184
|-
| OMS.sql || 5.330 || Order package || 00364162
|-
| ORD_ENTRY_TARGET.fmx || 2.30 || Order Entry Target || 00318182
|-
| ORDERS.fmx || 2.453 || Order Screen || 00320489
|-
| ORDERS_WIDE.fmx || 1.49 || Orders Screen || 00320489
|-
| ORDTEMPL.fmx || 2.51 || Order template || 00318182
|-
| ORS.fmx || 1.37 || Oracle Reporting suite || 00327382
|-
| PLANNING.fmx || 1.128 || Planning Screen || 00327516
|-
| PLANNING.fmx || 1.129 || Planning Screen || 02231368
|-
| PLANNING.fmx || 1.130 || Planning Screen || 00323035
|-
| PLANNING.fmx || 1.131 || Planning Screen || 00357019
|-
| PLANNING.fmx || 1.132 || Planning Screen || 00368493
|-
| RES_PERSON_UID.sql || 5.8 || Trigger || 00357019
|-
| RES_TRACTOR_UID.sql || 5.9 || Trigger || 00357019
|-
| ROUTES_MAINT.fmx || 2.51 || Fixed Routes Maintenance || 00322438
|-
| ROUTES_MAINT.fmx || 2.52 || Fixed Routes Maintenance || 00323035
|-
| SCHED_RULES.fmx || 1.35 || Scheduling Screen || 00318182
|-
| STAP_LOAD_SHEET.rep || 1.1 || Report || 00368493
|-
| T_SCH_ORD_AUDIT.sql || 5.20 || Trigger for SCH_ORD_AUDIT || 00371961
|-
| TI_SCH_ORD_STATUS.sql || 1.25 || Trigger on SCH_ORD for status change || 00350325
|-
| TI_SCH_TRIP_AUDIT.sql || 5.7 || Trigger || 02129675
|-
| TRG_ACC_ADHOC_SERVICES_BIU.sql || 1.1 || Trigger || 02147681
|-
| TRG_ACC_BULK_PACK_CHGS_BIU.sql || 1.1 || Trigger || 02147681
|-
| TRG_ACC_BULK_PACKAGING_BIU.sql || 1.1 || Trigger || 02147681
|-
| TRG_CNT_CHARGE_CONDITIONS_TRACTOR_BIU.sql || 1.1 || Trigger || 00340479
|-
| TRG_CNT_CHARGE_CONDITIONS_TRLRTYPE_BIU.sql || 1.1 || Trigger || 00340479
|-
| TRG_CNT_CHARGE_MIN_MAX_IUD.sql || 1.2 || Trigger || 00340479
|-
| TRG_CNT_CHARGE_PARAM_BIU.sql || 1.1 || Trigger || 00340479
|-
| TRG_CNT_CHARGE_TYPE_BIU.sql || 1.1 || Trigger || 00340479
|-
| TRG_CNT_CONDITION_BIU.sql || 1.1 || Trigger || 00340479
|-
| TRG_CNT_CONDITION_VALUE_BIU.sql || 1.1 || Trigger || 00340479
|-
| TRG_CNT_CONTRACT_INDEX_BIU.sql || 1.1 || Trigger || 00340479
|-
| TRG_CNT_CUST_LOC_GROUP_BIU.sql || 1.1 || Trigger || 00340479
|-
| TRG_CNT_DEL_TYPE_BIU.sql || 1.1 || Trigger || 00340479
|-
| TRG_CNT_DEL_TYPE_CONV_BIU.sql || 1.1 || Trigger || 00340479
|-
| TRG_CNT_DEL_TYPE_CUST_EXCL_BIU.sql || 1.1 || Trigger || 00340479
|-
| TRG_CNT_DEL_TYPE_USE_BIU.sql || 1.1 || Trigger || 00340479
|-
| TRG_CNT_RHA_CONFIG_BIU.sql || 1.1 || Trigger || 00340479
|-
| TRG_CNT_RHA_INDEX_BIU.sql || 1.1 || Trigger || 00340479
|-
| TRG_CNT_SERVICE_CHARGES_BIU.sql || 1.1 || Trigger || 00340479
|-
| TRG_CNT_SERVICE_CONTRACTS_BIU.sql || 1.1 || Trigger || 00340479
|-
| TRG_CNT_SERVICE_LEVEL_BIU.sql || 1.1 || Trigger || 00340479
|-
| TRG_CNT_STD_JOURNEY_BIU.sql || 1.1 || Trigger || 00340479
|-
| TRG_CNT_TIER_NAME_BIU.sql || 1.1 || Trigger || 00340479
|-
| TRG_GEO_LOC_WIN_BIU.sql || 1.1 || Trigger || 00322441
|-
| TRG_GEO_LOCATION_UID.sql || 5.3 || Trigger || 00323035
|-
| TRG_GEO_ROUTE_DTLS.sql || 1.2 || Trigger || 00326413
|-
| TRG_IMP_FIELD_BIU.sql || 1.1 || Trigger || 00340479
|-
| TRG_IMP_FIELD_SOURCE_BIU.sql || 1.1 || Trigger || 00340479
|-
| TRG_IMP_FORMULA_BIU.sql || 1.1 || Trigger || 00340479
|-
| TRG_IMP_HIST_DETAIL_BIU.sql || 1.1 || Trigger || 00340479
|-
| TRG_IMP_HIST_HEADER_BIU.sql || 1.1 || Trigger || 00340479
|-
| TRG_IMP_IMPORT_TYPE_BIU.sql || 1.1 || Trigger || 00340479
|-
| TRG_IMP_IMPORT_TYPE_REC_TYPE_BIU.sql || 1.1 || Trigger || 00340479
|-
| TRG_IMP_LOAD_AUDIT_BIU.sql || 1.1 || Trigger || 00340479
|-
| TRG_IMP_ORDERS_BIU.sql || 1.1 || Trigger || 00340479
|-
| TRG_IMP_RECORD_FORMAT_BIU.sql || 1.1 || Trigger || 00340479
|-
| TRG_SCH_ORD_AUDIT_LOCS.sql || 1.2 || Trigger || 00325803
|-
| TRG_SCH_ORD_CURRENT_DEPOT.sql || 5.4 || Trigger || 00323035
|-
| TRG_SCH_ORD_REFERENCE_RUN.sql || 5.1 || Trigger || 00323035
|-
| TRG_SCH_ORD_SERVICES_BIUDR.sql || 5.4 || Trigger for SCH_ORD_SERVICES || 00368184
|-
| TRG_SCH_ORD_TRACKING_BI.sql || 1.2 || Trigger || 00298173
|-
| TRG_SHA_LOTS.sql || 5.9 || Trigger || 02140871
|-
| TRG_STS_STATUS_CHANGES.sql || 1.1 || Trigger || 02231368
|-
| TRG_STS_STATUS_CHANGES.sql || 1.2 || Trigger || 00350325
|-
| TRG_TRIP_COST.sql || 1.4 || Trigger || 02234525
|-
| TRG_TT_EVENTS_STORE.sql || 1.4 || Trigger || 00325803
|-
| TRG_TT_EVENTS_STORE.sql || 1.5 || Trigger || 00345445
|-
| TRG_TT_EVENTS_STORE.sql || 1.6 || Trigger || 02231368
|-
| TRIP_OVERVIEW.fmx || 1.66 || Trip Waterfall || 02231368
|-
| TRIP_OVERVIEW.fmx || 1.67 || Trip Waterfall || 00350325
|-
| TRIP_OVERVIEW.fmx || 1.68 || Trip Waterfall || 00351271
|-
| TRIP_OVERVIEW.fmx || 1.69 || Trip Waterfall || 00357019
|-
| TRIP_OVERVIEW.fmx || 1.70 || Trip Waterfall || 00365766
|-
| TRIP_OVERVIEW.fmx || 1.71 || Trip Waterfall || 00366538
|-
| TRIP_OVERVIEW.sql || 5.8 || Trip Waterfall || 00350325
|-
| TRIP_SHEET_DUN_DETAIL.rep || 5.28 || Driver Trip Sheet || 02166754
|-
| TRM.sql || 5.211 || Trip manipulation package || 02128190
|-
| TRM.sql || 5.212 || Trip manipulation package || 00323078
|-
| TRM.sql || 5.213 || Trip manipulation package || 00345445
|-
| TRM.sql || 5.214 || Trip manipulation package || 00342485
|-
| TRM.sql || 5.215 || Trip manipulation package || 02231368
|-
| TRM.sql || 5.216 || Trip manipulation package || 00350325
|-
| TRM.sql || 5.217 || Trip manipulation package || 00365766
|-
| TRM.sql || 5.219 || Trip manipulation package || 02254409
|-
| UTL_FILE.sql || 5.4 || UTL_FILE package || 02243017
|-
| V_CTL_CUSTGROUP.sql || 5.1 || View || 00315981
|-
| V_CTL_CUSTGROUP.sql || 5.2 || View || 00346821
|-
| V_CTL_CUSTLOC.sql || 5.4 || View || 00333266
|-
| V_CTL_CUSTLOC.sql || 5.6 || View || 00355544
|-
| V_DRIVER_LIST.sql || 5.2 || View || 00315981
|-
| V_DRIVER_LIST.sql || 5.4 || View || 00364940
|-
| V_GEO_CONTACT.sql || 1.1 || View || 00338487
|-
| V_ORD_ORDER_HEADER.sql || 1.13 || View || 00315981
|-
| V_ORD_ORDER_HEADER.sql || 1.14 || View || 00333266
|-
| V_ORD_ORDER_HEADER.sql || 1.15 || View || 00355544
|-
| V_ORD_ORDER_STATUS.sql || 1.4 || View || 00355544
|-
| V_PRODUCT_CTL.sql || 1.2 || View || 00315981
|-
| V_PRODUCT_CTL.sql || 1.3 || View || 00333266
|-
| V_PRODUCT_CTL.sql || 1.5 || View || 00355544
|-
| V_RES_VEHICLE_CUST_LOC.sql || 1.2 || View || 00349334
|-
| V_TRIP_OVERVIEW.sql || 1.17 || Trip View || 02231368
|-
| V_TRIP_OVERVIEW.sql || 1.19 || Trip View || 00374968
|-
| V_VEHICLE_DETAILS.sql || 5.2 || View || 00315981
|-
| V_VEHICLE_DETAILS.sql || 5.3 || View || 00366764
|-
| V_VEHICLE_DETAILS.sql || 5.4 || View || 00367653
|-
| WAREHOUSE.fmx || 2.11 || Warehouse Screen || 02147681
|-
 
 
|}
|}


Revision as of 12:32, 13 January 2023




Aptean Logo.png










Release Notes

CALIDUS TMS

12th December 2023 - 1.0
Reference: P043











































SUMMARY INTRODUCTION

INTRODUCTION

The main aim of this document is to provide CALIDUS TMS users with the level of detail required to accurately test all software included in the patch. The document also contains set-up and configuration details to enable the user to configure the system correctly for the new functionality to work.


GLOSSARY OF TERMS

Term Meaning
C-TMS Transport Management System
C-WMS Warehouse Management System
CR Change Request
C-WCS Warehouse Control System
C-ePOD Electronic Proof of Delivery
C-MCS Mobile Control System
C-TTM Track and Trace Management
EDI Electronic Data Interchange
TID Testing Issue Development, or Log


TESTING PROCESS

TIDs AND RESOLUTION

If there are any areas of the functionality that are not acceptable or do not meet the requirement specified in the Change Request then these should be expressed by raising a TID.


FINAL 'END TO END' TESTING

Prior to release to a production database, a full 'End to End' test is required on the test system by all sites using the database. Once this is signed off, a release date can be arranged.


AUTHORISATION

Authorisation from nominated release personnel only will be required when requesting a release to a production environment


CHANGE REQUESTS

Customer Ref:

OBS Log Number: Reporter:
Summary of Call
Detail of Fix
Set-up and Configuration No set-up/configuration required

Customer Ref:

OBS Log Number: Reporter:
Summary of Call
Detail of Fix
Set-up and Configuration No set-up/configuration required


SUPPORT INCIDENTS

Customer Ref:

OBS Log Number: Reporter:
Summary of Call
Detail of Fix
Set-up and Configuration No set-up/configuration required


TID CHANGES

OBS Log Number:

Cust Ref: Reporter:
Summary of Call
Detail of Fix
Set-up and Configuration


PRODUCT DEVELOPMENT

OBS Log Number:

Reporter:
Summary of Call
Detail of Fix
Set-up and Configuration No set-up/configuration required


MODULES DELIVERED

| ACC_CTRL.fmx || 2.56 || Access control maintenance || 00349335 |- | ADM.sql || 5.12 || Administrator package containing various DB utils || 00349335 |- | AT_CNT_CHARGE_CONDITIONS_TRACTOR_340479.sql || 1.1 || AT Script || 00340479 |- | AT_CNT_CHARGE_CONDITIONS_TRLRTYPE_340479.sql || 1.1 || AT Script || 00340479 |- | AT_CNT_CHARGE_MIN_MAX_340479.sql || 1.1 || AT Script || 00340479 |- | AT_CNT_CHARGE_PARAM_340479.sql || 1.1 || AT Script || 00340479 |- | AT_CNT_CHARGE_TYPE_340479.sql || 1.1 || AT Script || 00340479 |- | AT_CNT_CONDITION_340479.sql || 1.1 || AT Script || 00340479 |- | AT_CNT_CONDITION_VALUE_340479..sql || 1.1 || AT Script || 00340479 |- | AT_CNT_CONTRACT_INDEX_340479.sql || 1.1 || AT Script || 00340479 |- | AT_CNT_CUST_LOC_GROUP_340479.sql || 1.1 || AT Script || 00340479 |- | AT_CNT_DEL_TYPE_340479.sql || 1.1 || AT Script || 00340479 |- | AT_CNT_DEL_TYPE_CONV_340479.sql || 1.1 || AT Script || 00340479 |- | AT_CNT_DEL_TYPE_CUST_EXCL_340479.sql || 1.1 || AT Script || 00340479 |- | AT_CNT_DEL_TYPE_USE_340479.sql || 1.1 || AT Script || 00340479 |- | AT_CNT_RHA_CONFIG_340479.sql || 1.1 || AT Script || 00340479 |- | AT_CNT_RHA_INDEX_340479.sql || 1.1 || AT Script || 00340479 |- | AT_CNT_SERVICE_CHARGES_340479.sql || 1.1 || AT Script || 00340479 |- | AT_CNT_SERVICE_CONTRACTS_340479.sql || 1.1 || AT Script || 00340479 |- | AT_CNT_SERVICE_LEVEL_340479.sql || 1.1 || AT Script || 00340479 |- | AT_CNT_STD_JOURNEY_340479.sql || 1.1 || AT Script || 00340479 |- | AT_CNT_TIER_NAME_340479.sql || 1.1 || AT Script || 00340479 |- | AT_GEO_LOCATION_00322441.sql || 1.1 || AT Script || 00322441 |- | AT_IMP_FIELD_340479.sql || 1.1 || AT Script || 00340479 |- | AT_IMP_FIELD_SOURCE_340479.sql || 1.1 || AT Script || 00340479 |- | AT_IMP_FORMULA_340479.sql || 1.1 || AT Script || 00340479 |- | AT_IMP_HIST_DETAIL_340479.sql || 1.1 || AT Script || 00340479 |- | AT_IMP_HIST_HEADER_340479.sql || 1.1 || AT Script || 00340479 |- | AT_IMP_IMPORT_TYPE_340479.sql || 1.1 || AT Script || 00340479 |- | AT_IMP_IMPORT_TYPE_REC_TYPE_340479.sql || 1.1 || AT Script || 00340479 |- | AT_IMP_LOAD_AUDIT_340479.sql || 1.1 || AT Script || 00340479 |- | AT_IMP_ORDERS_340479.sql || 1.1 || AT Script || 00340479 |- | AT_IMP_RECORD_FORMAT_340479.sql || 1.1 || AT Script || 00340479 |- | AT_INT_XML_ORD_HEADER_00368493.sql || 1.1 || AT Script || 00368493 |- | AT_ORD_TYRE_INSPECTIONS_00350912.sql || 1.1 || AT Script || 00350912 |- | AT_ORG_CUSTOMER_00322441.sql || 1.1 || AT Script || 00322441 |- | AT_ORG_CUSTOMER_00368493.sql || 1.1 || AT Script || 00368493 |- | AT_RES_VEHICLE_AXLE_00350912.sql || 1.1 || AT Script || 00350912 |- | AT_RES_VEHICLE_CONFIG_AXLE_00367465.sql || 1.1 || AT Script || 00367465 |- | AT_RES_VEHICLE_TYRE_00350912.sql || 1.1 || AT Script || 00350912 |- | AT_RTE_ROUTE_00322438.sql || 1.1 || AT Script || 00322438 |- | AT_RTE_ROUTE_00323035.sql || 1.1 || AT Script || 00323035 |- | AT_SCH_ORD_ITEMS_00350912.sql || 1.1 || AT Script || 00350912 |- | AT_TOMTOM_ETA_EVENTS_374083.sql || 1.1 || AT Script || 00374083 |- | AT_TRM_CARRIER_COST_374083.sql || 1.1 || AT Script || 00374083 |- | AT_WMS_PRODUCT_XREF_00351008.sql || 1.1 || AT Script || 00351008 |- | BDM.fmx || 2.106 || Business Data Form || 00326413 |- | BDM.fmx || 2.108 || Business Data Form || 00349283 |- | CARRIER_RULES.fmx || 1.16 || Carrier Rules Maintenance Screen || 00318182 |- | CONTRACT.fmx || 2.75 || Contracts Form || 02128610 |- | CONTRACT.fmx || 2.76 || Contracts Form || 00340479 |- | CONTRACT.fmx || 2.77 || Contracts Form || 00349874 |- | CT_GEO_DELIVERY_ROUTE_PRIORITY.sql || 1.3 || CT Script || 00326413 |- | CT_GEO_LOCATION_WINDOW_00322441.sql || 1.1 || CT Script || 00322441 |- | CT_GEO_ROUTE_DTLS.sql || 1.3 || CT Script || 00326413 |- | CT_PAR_API_STAGING_ROUTE.sql || 1.2 || CT Script || 00326413 |- | CT_PAR_JSON_IN_ROUTE.sql || 1.3 || CT Script || 00326413 |- | CT_PAR_KEYS_ROUTE.sql || 1.3 || CT Script || 00326413 |- | CT_SEQ_GEO_LOCATION_WINDOW_00322441.sql || 1.1 || CT Script || 00322441 |- | CT_SEQ_GEO_ROUTE_DTLS.sql || 1.2 || CT Script || 00326413 |- | CT_SEQ_TT_DRIVE_02156578.sql || 1.1 || CT Script || 00345445 |- | CT_SEQ_TT_WORK_02156578.sql || 1.1 || CT Script || 00345445 |- | CT_TOM_DRIVE_02156578.sql || 1.1 || CT Script || 00345445 |- | CT_TOM_WORK_02156578.sql || 1.1 || CT Script || 00345445 |- | CUST_COST.fmx || 2.140 || Customer Maintenance form || 00318182 |- | CUST_COST.fmx || 2.141 || Customer Maintenance form || 00322441 |- | DATA_ADM_FUNCTION_322353.sql || 1.1 || Data Script || 02128610 |- | DATA_ADM_LOG_PROG_NAME_02111893.sql || 1.2 || Data Script || 02111893 |- | DATA_ADM_LOG_PROG_NAME_349283.sql || 1.1 || Data Script || 00349283 |- | DATA_ADM_SYSTEM_PARAM_00322438.sql || 1.1 || Data Script || 00322438 |- | DATA_ADM_SYSTEM_PARAM_00323035.sql || 1.2 || Data Script || 00323035 |- | DATA_ADM_SYSTEM_PARAM_00330994.sql || 1.1 || Data Script || 00330994 |- | DATA_ADM_SYSTEM_PARAM_00351271.sql || 1.1 || Data Script || 00351271 |- | DATA_ADM_SYSTEM_PARAM_00357019.sql || 1.1 || Data Script || 00357019 |- | DATA_ADM_SYSTEM_PARAM_00365766.sql || 1.1 || Data Script || 00365766 |- | DATA_ADM_SYSTEM_PARAM_00368493.sql || 1.1 || Data Script || 00368493 |- | DATA_ADM_SYSTEM_PARAM_00371509.sql || 1.1 || Data Script || 00371509 |- | DATA_ADM_SYSTEM_PARAM_02111893.sql || 1.3 || Data Script || 02111893 |- | DATA_ADM_SYSTEM_PARAM_02124442.sql || 1.1 || Data Script || 00328694 |- | DATA_ADM_SYSTEM_PARAM_02128190.sql || 1.1 || Data Script || 02128190 |- | DATA_ADM_SYSTEM_PARAM_02139434.sql || 1.1 || Data Script || 02139434 |- | DATA_ADM_SYSTEM_PARAM_02156578.sql || 1.1 || Data Script || 00345445 |- | DATA_ADM_SYSTEM_PARAM_02165959.sql || 1.1 || Data Script || 02165959 |- | DATA_ADM_SYSTEM_PARAM_02231368.sql || 1.1 || Data Script || 02231368 |- | DATA_ADM_SYSTEM_PARAM_315981.sql || 1.1 || Data Script || 00315981 |- | DATA_ADM_SYSTEM_PARAM_318182.sql || 1.1 || Data Script || 00318182 |- | DATA_ADM_SYSTEM_PARAM_320489.sql || 1.2 || Data Script || 00320489 |- | DATA_ADM_SYSTEM_PARAM_327516.sql || 1.1 || Data Script || 00327516 |- | DATA_ADM_SYSTEM_PARAM_328687.sql || 1.1 || Data Script || 00328687 |- | DATA_ADM_SYSTEM_PARAM_344993.sql || 1.1 || Data Script || 00344993 |- | DATA_ADM_SYSTEM_PARAM_349335.sql || 1.1 || Data Script || 00349335 |- | DATA_ADM_SYSTEM_PARAM_CONFIG_327516.sql || 1.1 || Data Script || 00327516 |- | DATA_ADM_USER_PARAM_002118515.sql || 5.1 || Data Script || 00333266 |- | DATA_ADM_USER_PARAM_TYPE_002118515.sql || 5.1 || Data Script || 00333266 |- | DATA_ADM_USER_PARAM_TYPE_00349334.sql || 1.1 || Data Script || 00349334 |- | DATA_EDI_FLOW_TYPES_00344579.sql || 1.1 || Data Script || 00344579 |- | DATA_GEO_LOC_TYPE_346821.sql || 1.1 || Data Script || 00346821 |- | DATA_MSG_EVENT_TYPE_00323035.sql || 1.1 || Data Script || 00323035 |- | DATA_REP_REPORT_00368493.sql || 1.1 || Data Script || 00368493 |- | DATA_REP_REPORT_PARAM_00368493.sql || 1.1 || Data Script || 00368493 |- | DP_ASKGEO.sql || 1.3 || AskGEO Interface || 00374777 |- | DP_CARRIER_API.sql || 5.10 || Database Package || 02165959 |- | DP_CARRIER_API.sql || 5.11 || Carrier API Database Package || 00353959 |- | DP_CTMS_IMPORT.sql || 5.11 || API Import Database Package || 00332893 |- | DP_CTMS_IMPORT.sql || 5.12 || API Import Database Package || 00335523 |- | DP_CTMS_IMPORT.sql || 5.15 || API Import Database Package || 00322441 |- | DP_CTMS_IMPORT.sql || 5.16 || API Import Database Package || 00355355 |- | DP_CTMS_IMPORT.sql || 5.17 || API Import Database Package || 00355519 |- | DP_CTMS_IMPORT.sql || 5.18 || API Import Database Package || 00365766 |- | DP_CTMS_IMPORT.sql || 5.20 || API Import Database Package || 00368621 |- | DP_CTMS_IMPORT.sql || 5.7 || Database Package || 00320472 |- | DP_CTMS_IMPORT.sql || 5.8 || API Import Database Package || 00322438 |- | DP_CTMS_IMPORT.sql || 5.9 || API Import Database Package || 00332122 |- | DP_CUST_SERV.sql || 1.39 || Customer Service Package || 00315981 |- | DP_CUST_SERV.sql || 1.41 || Customer Service Package || 00333266 |- | DP_CUST_SERV.sql || 1.42 || Customer Service Package || 00338487 |- | DP_CUST_SERV.sql || 1.45 || Customer Service Package || 00340142 |- | DP_CUST_SERV.sql || 1.46 || Customer Service Package || 00342094 |- | DP_CUST_SERV.sql || 1.47 || Customer Service Package || 00344993 |- | DP_CUST_SERV.sql || 1.48 || Customer Service Package || 00346821 |- | DP_CUST_SERV.sql || 1.49 || Customer Service Package || 00349334 |- | DP_CUST_SERV.sql || 1.50 || Customer Service Package || 00355544 |- | DP_CUST_SERV.sql || 1.51 || Customer Service Package || 00355562 |- | DP_CUST_SERV.sql || 1.52 || Customer Service Package || 00360149 |- | DP_CUST_SERV.sql || 1.53 || Customer Service Package || 00356212 |- | DP_CUST_SERV.sql || 1.54 || Customer Service Package || 00365146 |- | DP_CUST_SERV.sql || 1.55 || Customer Service Package || 00366764 |- | DP_EPOD_WEB_SERVICE.sql || 1.151 || EPOD Web Service || 00325648 |- | DP_EPOD_WEB_SERVICE.sql || 1.152 || EPOD Web Service || 00325803 |- | DP_EPOD_WEB_SERVICE.sql || 1.153 || EPOD Web Service || 00328694 |- | DP_EPOD_WEB_SERVICE.sql || 1.156 || EPOD Web Service || 00328687 |- | DP_EPOD_WEB_SERVICE.sql || 1.157 || EPOD Web Service || 00336332 |- | DP_EPOD_WEB_SERVICE.sql || 1.158 || EPOD Web Service || 00340343 |- | DP_EPOD_WEB_SERVICE.sql || 1.159 || EPOD Web Service || 00340339 |- | DP_EPOD_WEB_SERVICE.sql || 1.160 || EPOD Web Service || 00341214 |- | DP_EPOD_WEB_SERVICE.sql || 1.161 || EPOD Web Service || 00345010 |- | DP_EPOD_WEB_SERVICE.sql || 1.162 || EPOD Web Service || 00345445 |- | DP_EPOD_WEB_SERVICE.sql || 1.163 || EPOD Web Service || 00349336 |- | DP_EPOD_WEB_SERVICE.sql || 1.164 || EPOD Web Service || 00350925 |- | DP_EPOD_WEB_SERVICE.sql || 1.165 || EPOD Web Service || 00355573 |- | DP_EPOD_WEB_SERVICE.sql || 1.166 || EPOD Web Service || 00356803 |- | DP_EPOD_WEB_SERVICE.sql || 1.167 || EPOD Web Service || 00364252 |- | DP_EPOD_WEB_SERVICE.sql || 1.168 || EPOD Web Service || 00365467 |- | DP_EPOD_WEB_SERVICE.sql || 1.169 || EPOD Web Service || 00365797 |- | DP_EPOD_WEB_SERVICE.sql || 1.170 || EPOD Web Service || 00366524 |- | DP_EPOD_WEB_SERVICE.sql || 1.171 || EPOD Web Service || 00366787 |- | DP_EPOD_WEB_SERVICE.sql || 1.172 || EPOD Web Service || 00366861 |- | DP_EPOD_WEB_SERVICE.sql || 1.173 || EPOD Web Service || 00371961 |- | DP_EPOD_WEB_SERVICE.sql || 1.174 || EPOD Web Service || 00371509 |- | DP_EPOD_WEB_SERVICE.sql || 1.175 || EPOD Web Service || 00373035 |- | DP_EPOD_WEB_SERVICE.sql || 1.176 || EPOD Web Service || 00372373 |- | DP_EPOD_WEB_SERVICE.sql || 1.177 || EPOD Web Service || 00372699 |- | DP_EXPORT_EVENTS.sql || 5.11 || API Export Events Database Package || 02135828 |- | DP_EXPORT_EVENTS.sql || 5.12 || API Export Events Database Package || 00326046 |- | DP_EXPORT_EVENTS.sql || 5.13 || API Export Events Database Package || 00332107 |- | DP_EXPORT_EVENTS.sql || 5.15 || API Export Events Database Package || 00339287 |- | DP_EXPORT_EVENTS.sql || 5.17 || API Export Events Database Package || 00314793 |- | DP_EXPORT_EVENTS.sql || 5.18 || API Export Events Database Package || 00325239 |- | DP_EXPORT_EVENTS.sql || 5.20 || API Export Events Database Package || 00340340 |- | DP_EXPORT_EVENTS.sql || 5.21 || API Export Events Database Package || 00345032 |- | DP_EXPORT_EVENTS.sql || 5.22 || API Export Events Database Package || 02231368 |- | DP_FORD_EDI_IN.sql || 5.1 || Database Package || 00344579 |- | DP_FORD_EDI_IN.sql || 5.2 || Database Package || 02227349 |- | DP_IMP_2.sql || 1.81 || Import Package || 00318182 |- | DP_INT_TMS_WMS_IN_STUB.sql || 1.23 || Inbound WMS/TMS Interface Package || 00318182 |- | DP_INT_XML_CFX.sql || 1.7 || CFX Interface Database Package || 02232219 |- | DP_INT_XML_MIC2.sql || 1.35 || CTMS to MIC Interface || 02111893 |- | DP_INT_XML_MIC2.sql || 1.36 || CTMS to MIC Interface || 02243017 |- | DP_LFE_POD.sql || 5.6 || LFE POD Database Package || 02224778 |- | DP_NOKIA_LOC_PLAT.sql || 1.37 || Nokia Location Platform Interface || 00345445 |- | DP_PAR_API.sql || 5.8 || Database Package || 00345445 |- | DP_PAR_API.sql || 5.9 || Database Package || 02231368 |- | DP_PAR_API_STP.sql || 5.1 || Database Package || 00323035 |- | DP_PULSE.sql || 1.51 || Pulse Interface Package || 00318182 |- | DP_RDT_AUTO.sql || 5.47 || Client specific RDT funtions || 02139434 |- | DP_RDT_FAST_UNLOAD.sql || 5.48 || RF Unload Package || 01935522 |- | DP_REPORTS.sql || 5.72 || Reports package || 00327382 |- | DP_REPORTS.sql || 5.73 || Reports package || 00368493 |- | DP_SCHEDULING_ENGINE.sql || 5.179 || Scheduling Package || 00326413 |- | DP_SCHEDULING_ENGINE.sql || 5.180 || Scheduling Package || 00323035 |- | DP_SCHEDULING_ENGINE.sql || 5.181 || Scheduling Package || 00357019 |- | DP_TOMTOM.sql || 1.38 || TomTom Package || 00330994 |- | DP_TOMTOM.sql || 1.39 || TomTom Package || 00345445 |- | DP_TOMTOM.sql || 1.40 || TomTom Package || 02231368 |- | DP_TRM_CHANGE_SCHEDULE.sql || 5.1 || Database Package || 00345445 |- | DP_TRM_CHANGE_SCHEDULE.sql || 5.2 || Database Package || 00350325 |- | DP_WEB_SERVICE_ORD.sql || 1.30 || Web Service Package || 00318182 |- | DP_XML_EPOD.sql || 1.4 || XML Database Package || 00335523 |- | DP_XML_EPOD.sql || 1.5 || XML Database Package || 00325239 |- | EDI_MAINT.fmx || 10.17 || EDI Maintenance Screen || 00357019 |- | EXECUTION.fmx || 1.108 || Execution screen || 00318182 |- | IMP.sql || 5.215 || CSV Imports Package || 00318182 |- | IMP.sql || 5.216 || CSV Imports Package || 00345853 |- | IMP.sql || 5.217 || CSV Imports Package || 00350912 |- | IMPORTS_MAINT.fmx || 1.25 || Import Maintenance Form || 00318182 |- | INT_ERR.fmx || 1.111 || Interface Errors || 00344579 |- | INT_ERR_ORD.fmx || 2.10 || Interface error correction || 00318182 |- | INT_XML_IN.sql || 5.238 || Order Import Package || 00345814 |- | INT_XML_OUT2.sql || 5.326 || Outbound XML Package || 00344924 |- | INT_XML_OUT2.sql || 5.327 || Outbound XML Package || 00366230 |- | INT_XML_OUT2.sql || 5.328 || Outbound XML Package || 00368176 |- | LOCATION.fmx || 2.202 || Location Maintenance || 00279440 |- | LOCATION.fmx || 2.203 || Location Maintenance || 00326413 |- | LOCATION.fmx || 2.204 || Location Maintenance || 00320489 |- | MSG_MAINT.fmx || 2.33 || Message Maintenance screen || 00318182 |- | MSG_PROCESSING.sql || 5.75 || Message Processing package || 00330994 |- | NETWORK.fmx || 1.18 || Network Maintenance || 00318182 |- | OMS.sql || 5.252 || Order package || 00318182 |- | OMS.sql || 5.253 || Order package || 02132813 |- | OMS.sql || 5.254 || Order package || 02137857 |- | OMS.sql || 5.255 || Order package || 02222075 |- | OMS.sql || 5.257 || Order package || 02263060 |- | OMS.sql || 5.329 || Order package || 00368184 |- | OMS.sql || 5.330 || Order package || 00364162 |- | ORD_ENTRY_TARGET.fmx || 2.30 || Order Entry Target || 00318182 |- | ORDERS.fmx || 2.453 || Order Screen || 00320489 |- | ORDERS_WIDE.fmx || 1.49 || Orders Screen || 00320489 |- | ORDTEMPL.fmx || 2.51 || Order template || 00318182 |- | ORS.fmx || 1.37 || Oracle Reporting suite || 00327382 |- | PLANNING.fmx || 1.128 || Planning Screen || 00327516 |- | PLANNING.fmx || 1.129 || Planning Screen || 02231368 |- | PLANNING.fmx || 1.130 || Planning Screen || 00323035 |- | PLANNING.fmx || 1.131 || Planning Screen || 00357019 |- | PLANNING.fmx || 1.132 || Planning Screen || 00368493 |- | RES_PERSON_UID.sql || 5.8 || Trigger || 00357019 |- | RES_TRACTOR_UID.sql || 5.9 || Trigger || 00357019 |- | ROUTES_MAINT.fmx || 2.51 || Fixed Routes Maintenance || 00322438 |- | ROUTES_MAINT.fmx || 2.52 || Fixed Routes Maintenance || 00323035 |- | SCHED_RULES.fmx || 1.35 || Scheduling Screen || 00318182 |- | STAP_LOAD_SHEET.rep || 1.1 || Report || 00368493 |- | T_SCH_ORD_AUDIT.sql || 5.20 || Trigger for SCH_ORD_AUDIT || 00371961 |- | TI_SCH_ORD_STATUS.sql || 1.25 || Trigger on SCH_ORD for status change || 00350325 |- | TI_SCH_TRIP_AUDIT.sql || 5.7 || Trigger || 02129675 |- | TRG_ACC_ADHOC_SERVICES_BIU.sql || 1.1 || Trigger || 02147681 |- | TRG_ACC_BULK_PACK_CHGS_BIU.sql || 1.1 || Trigger || 02147681 |- | TRG_ACC_BULK_PACKAGING_BIU.sql || 1.1 || Trigger || 02147681 |- | TRG_CNT_CHARGE_CONDITIONS_TRACTOR_BIU.sql || 1.1 || Trigger || 00340479 |- | TRG_CNT_CHARGE_CONDITIONS_TRLRTYPE_BIU.sql || 1.1 || Trigger || 00340479 |- | TRG_CNT_CHARGE_MIN_MAX_IUD.sql || 1.2 || Trigger || 00340479 |- | TRG_CNT_CHARGE_PARAM_BIU.sql || 1.1 || Trigger || 00340479 |- | TRG_CNT_CHARGE_TYPE_BIU.sql || 1.1 || Trigger || 00340479 |- | TRG_CNT_CONDITION_BIU.sql || 1.1 || Trigger || 00340479 |- | TRG_CNT_CONDITION_VALUE_BIU.sql || 1.1 || Trigger || 00340479 |- | TRG_CNT_CONTRACT_INDEX_BIU.sql || 1.1 || Trigger || 00340479 |- | TRG_CNT_CUST_LOC_GROUP_BIU.sql || 1.1 || Trigger || 00340479 |- | TRG_CNT_DEL_TYPE_BIU.sql || 1.1 || Trigger || 00340479 |- | TRG_CNT_DEL_TYPE_CONV_BIU.sql || 1.1 || Trigger || 00340479 |- | TRG_CNT_DEL_TYPE_CUST_EXCL_BIU.sql || 1.1 || Trigger || 00340479 |- | TRG_CNT_DEL_TYPE_USE_BIU.sql || 1.1 || Trigger || 00340479 |- | TRG_CNT_RHA_CONFIG_BIU.sql || 1.1 || Trigger || 00340479 |- | TRG_CNT_RHA_INDEX_BIU.sql || 1.1 || Trigger || 00340479 |- | TRG_CNT_SERVICE_CHARGES_BIU.sql || 1.1 || Trigger || 00340479 |- | TRG_CNT_SERVICE_CONTRACTS_BIU.sql || 1.1 || Trigger || 00340479 |- | TRG_CNT_SERVICE_LEVEL_BIU.sql || 1.1 || Trigger || 00340479 |- | TRG_CNT_STD_JOURNEY_BIU.sql || 1.1 || Trigger || 00340479 |- | TRG_CNT_TIER_NAME_BIU.sql || 1.1 || Trigger || 00340479 |- | TRG_GEO_LOC_WIN_BIU.sql || 1.1 || Trigger || 00322441 |- | TRG_GEO_LOCATION_UID.sql || 5.3 || Trigger || 00323035 |- | TRG_GEO_ROUTE_DTLS.sql || 1.2 || Trigger || 00326413 |- | TRG_IMP_FIELD_BIU.sql || 1.1 || Trigger || 00340479 |- | TRG_IMP_FIELD_SOURCE_BIU.sql || 1.1 || Trigger || 00340479 |- | TRG_IMP_FORMULA_BIU.sql || 1.1 || Trigger || 00340479 |- | TRG_IMP_HIST_DETAIL_BIU.sql || 1.1 || Trigger || 00340479 |- | TRG_IMP_HIST_HEADER_BIU.sql || 1.1 || Trigger || 00340479 |- | TRG_IMP_IMPORT_TYPE_BIU.sql || 1.1 || Trigger || 00340479 |- | TRG_IMP_IMPORT_TYPE_REC_TYPE_BIU.sql || 1.1 || Trigger || 00340479 |- | TRG_IMP_LOAD_AUDIT_BIU.sql || 1.1 || Trigger || 00340479 |- | TRG_IMP_ORDERS_BIU.sql || 1.1 || Trigger || 00340479 |- | TRG_IMP_RECORD_FORMAT_BIU.sql || 1.1 || Trigger || 00340479 |- | TRG_SCH_ORD_AUDIT_LOCS.sql || 1.2 || Trigger || 00325803 |- | TRG_SCH_ORD_CURRENT_DEPOT.sql || 5.4 || Trigger || 00323035 |- | TRG_SCH_ORD_REFERENCE_RUN.sql || 5.1 || Trigger || 00323035 |- | TRG_SCH_ORD_SERVICES_BIUDR.sql || 5.4 || Trigger for SCH_ORD_SERVICES || 00368184 |- | TRG_SCH_ORD_TRACKING_BI.sql || 1.2 || Trigger || 00298173 |- | TRG_SHA_LOTS.sql || 5.9 || Trigger || 02140871 |- | TRG_STS_STATUS_CHANGES.sql || 1.1 || Trigger || 02231368 |- | TRG_STS_STATUS_CHANGES.sql || 1.2 || Trigger || 00350325 |- | TRG_TRIP_COST.sql || 1.4 || Trigger || 02234525 |- | TRG_TT_EVENTS_STORE.sql || 1.4 || Trigger || 00325803 |- | TRG_TT_EVENTS_STORE.sql || 1.5 || Trigger || 00345445 |- | TRG_TT_EVENTS_STORE.sql || 1.6 || Trigger || 02231368 |- | TRIP_OVERVIEW.fmx || 1.66 || Trip Waterfall || 02231368 |- | TRIP_OVERVIEW.fmx || 1.67 || Trip Waterfall || 00350325 |- | TRIP_OVERVIEW.fmx || 1.68 || Trip Waterfall || 00351271 |- | TRIP_OVERVIEW.fmx || 1.69 || Trip Waterfall || 00357019 |- | TRIP_OVERVIEW.fmx || 1.70 || Trip Waterfall || 00365766 |- | TRIP_OVERVIEW.fmx || 1.71 || Trip Waterfall || 00366538 |- | TRIP_OVERVIEW.sql || 5.8 || Trip Waterfall || 00350325 |- | TRIP_SHEET_DUN_DETAIL.rep || 5.28 || Driver Trip Sheet || 02166754 |- | TRM.sql || 5.211 || Trip manipulation package || 02128190 |- | TRM.sql || 5.212 || Trip manipulation package || 00323078 |- | TRM.sql || 5.213 || Trip manipulation package || 00345445 |- | TRM.sql || 5.214 || Trip manipulation package || 00342485 |- | TRM.sql || 5.215 || Trip manipulation package || 02231368 |- | TRM.sql || 5.216 || Trip manipulation package || 00350325 |- | TRM.sql || 5.217 || Trip manipulation package || 00365766 |- | TRM.sql || 5.219 || Trip manipulation package || 02254409 |- | UTL_FILE.sql || 5.4 || UTL_FILE package || 02243017 |- | V_CTL_CUSTGROUP.sql || 5.1 || View || 00315981 |- | V_CTL_CUSTGROUP.sql || 5.2 || View || 00346821 |- | V_CTL_CUSTLOC.sql || 5.4 || View || 00333266 |- | V_CTL_CUSTLOC.sql || 5.6 || View || 00355544 |- | V_DRIVER_LIST.sql || 5.2 || View || 00315981 |- | V_DRIVER_LIST.sql || 5.4 || View || 00364940 |- | V_GEO_CONTACT.sql || 1.1 || View || 00338487 |- | V_ORD_ORDER_HEADER.sql || 1.13 || View || 00315981 |- | V_ORD_ORDER_HEADER.sql || 1.14 || View || 00333266 |- | V_ORD_ORDER_HEADER.sql || 1.15 || View || 00355544 |- | V_ORD_ORDER_STATUS.sql || 1.4 || View || 00355544 |- | V_PRODUCT_CTL.sql || 1.2 || View || 00315981 |- | V_PRODUCT_CTL.sql || 1.3 || View || 00333266 |- | V_PRODUCT_CTL.sql || 1.5 || View || 00355544 |- | V_RES_VEHICLE_CUST_LOC.sql || 1.2 || View || 00349334 |- | V_TRIP_OVERVIEW.sql || 1.17 || Trip View || 02231368 |- | V_TRIP_OVERVIEW.sql || 1.19 || Trip View || 00374968 |- | V_VEHICLE_DETAILS.sql || 5.2 || View || 00315981 |- | V_VEHICLE_DETAILS.sql || 5.3 || View || 00366764 |- | V_VEHICLE_DETAILS.sql || 5.4 || View || 00367653 |- | WAREHOUSE.fmx || 2.11 || Warehouse Screen || 02147681 |-


|}


ADDITIONAL CHANGES

WCS

A WCS change is required for the following logs:

  • Log

OR

There are no WCS changes required.

EPOD/T2A

An ePOD/T2A change is required for the following logs:

  • Log

OR

There are no ePOD/T2A changes required.

MCS

An MCS change is required for the following logs:

  • Log

OR

There are no MCS changes required.

PORTAL/TTM

A Portal change is required for the following logs:

  • Log

OR

There are no Portal changes required.

EDI

An EDI change is required for the following logs:

  • Log

OR

There are no EDI changes required.


Retrieved from ‘https://calidusassist.adcservices.apteancloud.com/calidus-assist/OBS/index.php?title=PATCH_C-TMS_P043&oldid=10405’