PATCH C-TMS P042

From Calidus HUB
Revision as of 09:11, 15 July 2022 by StylesC (talk | contribs)




Aptean Logo.png







{{{Client}}}

Release Notes

CALIDUS TMS

14th July 2022 - 1.0
Reference: P042











































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

Log Number: 00233816

Summary of Call Oracle testing
Detail of Fix "System parameter DEFAULT_ORACLE_DIRECTORY can be set to 'TMS_DIR' to activate the new functionality for 19c databases.

UTL_FILE has been modified to create a new directory for 19c changes in databases.

​Able to generate both FTP and receive mail for EXPORTS, REPORTS and ORS in individual screens and EDI maintenance screen.

Oracle system directories will need to be created for the database."

Set-up and Configuration


New Parameters
Parameter Name Config Level Setting Value Result
DEFAULT_ORACLE_DIRECTORY SYSTEM TMP_DIR The database will use system directories for file handling in 19c databases.
DEFAULT_ORACLE_DIRECTORY SYSTEM NONE The standard file handling will apply.



MODULES DELIVERED

Module Name Version No Description Log Number
AT_ACC_SERVICES_00278514.sql 1.1 Data Script 00278514
AT_CNT_DEL_TYPE_239646_440451.sql 1.1 Data Script 00239646
AT_CNT_SERVICE_LEVEL_00308136.sql 1.1 Data Script 00308136
AT_EPOD_WEB_SERVICE_AUDIT_00266101.sql 1.1 Data Script 00266101
AT_GEO_LOCATION_01909696.sql 1.1 Data Script 01909696
AT_GEO_LOCATION_239646_440451.sql 1.1 Data Script 00239646
AT_INT_ORD_XML_DETAILS_0026610 1.1 Data Script 00266101
AT_INT_XML_ORD_HEADER_00266101 1.1 Data Script 00266101
AT_ORD_TYRE_INSPECTION_287638.sql 1.1 Data Script 00287638
AT_ORG_CUSTOMER_00273451.sql 1.1 Data Script 00273451
AT_ORS_SQL_260441.sql 1.1 Data Script 00260441
AT_PAR_API_STAGING_00266101.sq 1.1 Data Script 00266101
AT_RES_CARRIER_01966393.sql 1.1 Data Script 00287229
AT_RES_TRACTOR_239646_440451.sql 1.1 Data Script 00239646
AT_RES_TRAILER_239646_440451.sql 1.2 Data Script 00239646
AT_RES_TRAILER_TYPE_01966393.s 1.1 Data Script 00287229
AT_RES_TRAILER_TYPE_296022.sql 1.1 Data Script 00296022
AT_RES_VEHICLE_TYRE_310663.sql 1.1 Data Script 00310663
AT_SCH_ORD_239646_440451.sql 1.1 Data Script 00239646
AT_SCH_ORD_ITEMS_00266101.sql 1.2 Data Script 00266101
AT_SCH_ORD_ITEMS_239646_440451.sql 1.2 Data Script 00239646
AT_SCH_ORD_ITEMS_265284.sql 1.1 Data Script 00265284
AT_SCH_ORD_ITEMS_294874.sql 1.1 Data Script 00294874
AT_SCH_ORD_TRACKING_01899265.sql 1.1 Data Script 01899265
AT_SCH_ORD_VEHICLE_287638.sql 1.1 Data Script 00287638
AT_SCH_TRIP_00266101.sql 1.1 Data Script 00266101
AT_SCH_TRIP_02108659.sql 1.1 Data Script 02108659
AT_TOMTOM_ETA_EVENTS_00530148.sql 1.1 Data Script 00530148
AT_TOMTOM_STOP_EVENTS_00530148.sql 1.1 Data Script 00530148
AT_WMS_PRODUCT_XREF_00278514.sql 1.1 Data Script 00278514
AT_WMS_PRODUCT_XREF_239646_440451.sql 1.1 Data Script 00239646
AT_WMS_PRODUCT_XREF_265284.sql 1.1 Data Script 00256955
AT_WMS_PRODUCT_XREF_265284.sql 1.1 Data Script 00265284
AT_WMS_PRODUCT_XREF_278514.sql 1.1 Data Script 00256955
BDM.fmx 2.103 Business Data Form 00244856
BDM.fmx 2.104 Business Data Form 00308136
CNT.sql 5.54 Contracts package 00287229
CT_API_LABEL_RESPONSE_01899265.sql 1.1 Data Script 01899265
CT_AUDIT_SEQ_CAR_API_01899265.sql 1.1 Data Script 01899265
CT_INT_XML_CUST_ADDRESS.sql 1.1 Data Script 00266101
CT_ORD_TYPE_INSPECTION_239646_440451.sql 1.2 Data Script 00239646
CT_PAR_API_STAGING_00266101.sql 5.1 Data Script 00266101
CT_PAR_CALL_API_00266101.sql 1.1 Data Script 00266101
CT_PAR_CUST_API_00266101.sql 1.1 Data Script 00266101
CT_PAR_JSON_IN.sql 1.2 Data Script 02124442
CT_PAR_JSON_IN_00266101.sql 1.1 Data Script 00266101
CT_PAR_KEYS_00266101.sql 1.1 Data Script 00266101
CT_PAR_TRIP_API.sql 1.2 Data Script 02124442
CT_RES_VEHICLE_AXLE_239646_440451.sql 1.2 Data Script 00239646
CT_RES_VEHICLE_CONFIG_239646_440451.sql 1.1 Data Script 00239646
CT_RES_VEHICLE_CONFIG_AXLE_239646_440451.sql 1.1 Data Script 00239646
CT_RES_VEHICLE_CUST_LOC_239646_440451.sql 1.3 Data Script 00239646
CT_RES_VEHICLE_TYRE_239646_440451.sql 1.2 Data Script 00239646
CT_SCH_ORD_VEHICLE_265284.sql 1.1 Data Script 00265284
CT_SEQ_API_FILE_IN.sql 1.1 Data Script 00266101
CT_SEQ_ETA_EVENT.sql 1.1 Data Script 00530144
CT_SEQ_ORD_TYRE_INSPECTION_239646.sql 1.1 Data Script 00239646
CT_SEQ_PAR_JSON_IN_00266101.sql 1.1 Data Script 00266101
CT_SEQ_RES_VEHICLE_AXLE_239646.sql 1.1 Data Script 00239646
CT_SEQ_RES_VEHICLE_CONFIG_239646.sql 1.1 Data Script 00239646
CT_SEQ_STOP_EVENT.sql 1.1 Data Script 00530144
CT_SFTP_UNKNOWN_HOSTS_01988611.sql 1.1 Data Script 01988611
CT_TOMTOM_ETA_EVENTS.sql 1.1 Data Script 00530144
CT_TOMTOM_STOP_EVENTS.sql 1.1 Data Script 00530144
CT_TOMTOM_VEHICLES.sql 1.1 Data Script 00530144
CT_TRM_CARRIER_COST.sql 1.1 Data Script 00287229
CT_VEHICLE_SEQ.sql 1.1 Data Script 00530144
DATA_1_IMP_IMPORT_TYPE_256955.sql 1.2 Data Script 00256955
DATA_1_MSG_EVENT_TYPE_02108654.sql 1.1 Data Script 02108654
DATA_1_ORS_MASTER_DATA_260441.sql 1.2 Data Script 00260441
DATA_1_ORS_MASTER_DATA_287039.sql 1.1 Data Script 00287039
DATA_1_ORS_SQL_00278514.sql 1.1 Data Script 00278514
DATA_1_ORS_SQL_260441.sql 1.4 Data Script 00260441
DATA_1_ORS_SQL_287039.sql 1.1 Data Script 00287039
DATA_2_IMP_IMPORT_TYPE_REC_TYPE.sql 1.2 Data Script 00256955
DATA_2_MSG_TYPE_02108654.sql 1.1 Data Script 02108654
DATA_2_ORS_MASTER_DATA_00278514.sql 1.1 Data Script 00278514
DATA_2_ORS_MASTER_DATA_260441.sql 1.2 Data Script 00260441
DATA_2_ORS_MASTER_DATA_287039.sql 1.1 Data Script 00287039
DATA_2_ORS_SQL_260441.sql 1.1 Data Script 00260441
DATA_2_ORS_SQL_287039.sql 1.1 Data Script 00287039
DATA_3_IMP_FIELD_256955.sql 1.3 Data Script 00256955
DATA_3_MSG_REQ_02108654.sql 1.1 Data Script 02108654
DATA_3_ORS_MASTER_DATA_260441.sql 1.3 Data Script 00260441
DATA_3_ORS_MASTER_DATA_287039.sql 1.1 Data Script 00287039
DATA_3_ORS_SQL_260441.sql 1.3 Data Script 00260441
DATA_3_ORS_SQL_287039.sql 1.1 Data Script 00287039
DATA_4_IMP_IMPORT_TYPE_256955.sql 1.2 Data Script 00256955
DATA_4_ORS_MASTER_DATA_260441.sql 1.3 Data Script 00260441
DATA_4_ORS_SQL_260441.sql 1.2 Data Script 00260441
DATA_5_IMP_IMPORT_TYPE_REC_TYPE.sql 1.2 Data Script 00256955
DATA_5_ORS_MASTER_DATA_260441.sql 1.2 Data Script 00260441
DATA_5_ORS_SQL_260441.sql 1.2 Data Script 00260441
DATA_6_IMP_FIELD_256955.sql 1.2 Data Script 00256955
DATA_6_ORS_MASTER_DATA_260441.sql 1.5 Data Script 00260441
DATA_6_ORS_SQL_260441.sql 1.2 Data Script 00260441
DATA_ADM_FORM_TAB_02117529.sql 1.1 Data Script 02117529
DATA_ADM_FORM_TAB_249891.sql 1.2 Data Script 00249891
DATA_ADM_FUNCTION_02030242.sql 1.1 Data Script 02030242
DATA_ADM_FUNCTION_242929.sql 1.1 Data Script 00242929
DATA_ADM_LOG_PROG_NAME_0198861.sql 1.1 Data Script 01988611
DATA_ADM_SYSTEM_PARAM_00244856.sql 1.1 Data Script 00244856
DATA_ADM_SYSTEM_PARAM_00266101.sql 1.1 Data Script 00266101
DATA_ADM_SYSTEM_PARAM_00273451 1.1 Data Script 00273451
DATA_ADM_SYSTEM_PARAM_00278514.sql 1.1 Data Script 00278514
DATA_ADM_SYSTEM_PARAM_00308136.sql 1.1 Data Script 00308136
DATA_ADM_SYSTEM_PARAM_00530144.sql 1.1 Data Script 00530144
DATA_ADM_SYSTEM_PARAM_00530148.sql 1.1 Data Script 00530148
DATA_ADM_SYSTEM_PARAM_01826171.sql 1.1 Data Script 00308136
DATA_ADM_SYSTEM_PARAM_01899265.sql 1.1 Data Script 01899265
DATA_ADM_SYSTEM_PARAM_01909696.sql 1.1 Data Script 01909696
DATA_ADM_SYSTEM_PARAM_01929119.sql 1.1 Data Script 01929119
DATA_ADM_SYSTEM_PARAM_01968623.sql 1.2 Data Script 00287384
DATA_ADM_SYSTEM_PARAM_01984366.sql 1.1 Data Script 01984366
DATA_ADM_SYSTEM_PARAM_01988611.sql 1.1 Data Script 01988611
DATA_ADM_SYSTEM_PARAM_02011793.sql 1.1 Data Script 02011793
DATA_ADM_SYSTEM_PARAM_02066885.sql 1.1 Data Script 02066885
DATA_ADM_SYSTEM_PARAM_02108654.sql 1.1 Data Script 02108654
DATA_ADM_SYSTEM_PARAM_02108659.sql 1.1 Data Script 02108659
DATA_ADM_SYSTEM_PARAM_02112078.sql 1.1 Data Script 02112078
DATA_ADM_SYSTEM_PARAM_233816.sql 1.1 Data Script 00233816
DATA_ADM_SYSTEM_PARAM_250543.sql 1.1 Data Script 00250543
DATA_ADM_SYSTEM_PARAM_261979.sql 1.1 Data Script 00261979
DATA_ADM_SYSTEM_PARAM_274077.sql 1.1 Data Script 00274077
DATA_ADM_SYSTEM_PARAM_279282.sql 1.1 Data Script 00279282
DATA_ADM_SYSTEM_PARAM_287638.sql 1.1 Data Script 00287638
DATA_ADM_SYSTEM_PARAM_CONFIG_261979.sql 1.1 Data Script 00261979
DATA_ADM_SYSTEM_PARAM_CONFIG_279282.sql 1.1 Data Script 00279282
DATA_ADM_SYSTEM_PARAM_CONFIG_287638.sql 1.1 Data Script 00287638
DATA_CNT_CONDITION_01966393.sq 1.1 Data Script 00287229
DATA_CNT_CONDITION_VALUE_01966 1.1 Data Script 00287229
DATA_EDI_FLOW_TYPES_01909696.sql 1.1 Data Script 01909696
DATA_EDI_PROCESS_TRIGGERS_296022.sql 1.1 Data Script 00296022
DATA_IMP_DECODE_02108654.sql 1.1 Data Script 02108654
DATA_IMP_FIELD_01899265.sql 1.1 Data Script 01899265
DATA_IMP_FIELD_02023242.sql 1.1 Data Script 02023242
DATA_IMP_FIELD_287950.sql 1.1 Data Script 00287950
DATA_IMP_IMPORT_TYPE_01899265.sql 1.1 Data Script 01899265
DATA_ORS_MASTER_DATA_02126440.sql 1.1 Data Script 02126440
DATA_ORS_MASTER_DATA_260026.sql 1.3 Data Script 00260026
DATA_ORS_MASTER_DATA_322735.sql 1.1 Data Script 00322735
DATA_ORS_USER_DETAILS_322735.sql 1.1 Data Script 00322735
DATA_REP_REPORT_02069048.sql 1.1 Data Script 02069048
DATA_REP_REPORT_PARAM_02069048 1.1 Data Script 02069048
DP_ASKGEO.sql 1.2 AskGEO Interface 00274074
DP_CARRIER.sql 1.95 Carrier Management 01929119
DP_CARRIER_API.sql 5.1 Carrier API 01899265
DP_CARRIER_API.sql 5.2 Carrier API 01970111
DP_CARRIER_API.sql 5.3 Carrier API 00284500
DP_CARRIER_API.sql 5.5 Carrier API 01985598
DP_CARRIER_API.sql 5.6 Carrier API 02011793
DP_CARRIER_API.sql 5.7 Carrier API 00274074
DP_CARRIER_API.sql 5.8 Carrier API 00311975
DP_CARRIER_API_JSON_stub.sql 1.1 Carrier API 01899265
DP_CSV6.sql 1.43 CSV Extract package 02069048
DP_CTMS_IMPORT.sql 5.1 API Import Database Package 00266101
DP_CTMS_IMPORT.sql 5.2 API Import Database Package 00273451
DP_CTMS_IMPORT.sql 5.4 API Import Database Package 00296022
DP_CTMS_IMPORT.sql 5.5 API Import Database Package 02131348
DP_CUST_SERV.sql 1.35 Customer Service Package 01584585
DP_CUST_SERV.sql 1.37 Customer Service Package 00260047
DP_CUST_SERV.sql 1.38 Customer Service Package 00308136
DP_EPOD_WEB_SERVICE.sql 1.135 EPOD Web Service 00244856
DP_EPOD_WEB_SERVICE.sql 1.136 EPOD Web Service 00252522
DP_EPOD_WEB_SERVICE.sql 1.137 EPOD Web Service 00261979
DP_EPOD_WEB_SERVICE.sql 1.138 EPOD Web Service 00265284
DP_EPOD_WEB_SERVICE.sql 1.139 EPOD Web Service 00287638
DP_EPOD_WEB_SERVICE.sql 1.140 EPOD Web Service 00294874
DP_EPOD_WEB_SERVICE.sql 1.141 EPOD Web Service 00295843
DP_EPOD_WEB_SERVICE.sql 1.142 EPOD Web Service 00301831
DP_EPOD_WEB_SERVICE.sql 1.143 EPOD Web Service 02065820
DP_EPOD_WEB_SERVICE.sql 1.144 EPOD Web Service 00310665
DP_EPOD_WEB_SERVICE.sql 1.145 EPOD Web Service 00310663
DP_EPOD_WEB_SERVICE.sql 1.146 EPOD Web Service 02124442
DP_EPOD_WEB_SERVICE.sql 1.147 EPOD Web Service 02069996
DP_EPOD_WEB_SERVICE.sql 1.149 EPOD Web Service 00323040
DP_EPOD_WEB_SERVICE.sql 1.150 EPOD Web Service 02131420
DP_EXPORT_EVENTS.sql 5.10 API Export Database Package 02131420
DP_EXPORT_EVENTS.sql 5.2 API Export Database Package 01969607
DP_EXPORT_EVENTS.sql 5.3 API Export Database Package 00266101
DP_EXPORT_EVENTS.sql 5.4 API Export Database Package 00274074
DP_EXPORT_EVENTS.sql 5.5 API Export Database Package 00273451
DP_EXPORT_EVENTS.sql 5.7 API Export Database Package 00296022
DP_EXPORT_EVENTS.sql 5.9 API Export Database Package 00321455
DP_IMP.sql 5.42 Imports Package 01899265
DP_INT_XML_CFX.sql 1.6 Database Package 01969399
DP_LFE_POD.sql 5.1 LFE POD Database package 01899265
DP_LFE_POD.sql 5.2 LFE POD Database package 01970111
DP_LFE_POD.sql 5.4 LFE POD Database package 02042658
DP_LFE_POD.sql 5.5 LFE POD Database package 02023242
DP_MIS.sql 5.7 MIS Interface Package 01988611
DP_NOKIA_LOC_PLAT.sql 1.36 Nokia Location Platform Interface 00274077
DP_ORS_FUNCS.sql 5.27 Change to DOOD status function 00287039
DP_ORS_FUNCS.sql 5.28 Change to DOOD status function 00278514
DP_PAR_API.sql 5.1 Database Package 00281601
DP_PAR_API.sql 5.3 Database Package 02124442
DP_PAR_API.sql 5.7 Database Package 02131420
DP_PORTAL.sql 5.19 Portal Package 02112923
DP_RDT_FAST_LOAD.sql 5.32 Load confirmation message procedure 02066885
DP_REPORTS.sql 5.65 Reports package 00260058
DP_REPORTS.sql 5.66 Reports package 00278514
DP_REPORTS.sql 5.68 Reports package 02124442
DP_SCHEDULING_ENGINE.sql 5.178 Scheduling Package 02123480
DP_SFTP.sql 5.1 SFTP processing 01988611
DP_TOMTOM.sql 1.34 TomTom Package 00274074
DP_TOMTOM.sql 1.35 TomTom Package 00530144
DP_TOMTOM.sql 1.36 TomTom Package 02116783
DP_TOMTOM.sql 1.37 TomTom Package 02131420
DP_WEB_SERVICE_ENQUIRY.sql 1.6 Web Service Package 00530148
DP_WEB_SERVICE_ORD.sql 1.29 Web Service Package 01984366
DP_XML_EPOD.sql 1.2 XML Database Package 00265284
DP_XML_EPOD.sql 1.3 XML Database Package 00273451
EDI_MAINT.fmx 10.16 EDI Maintenance Screen 00242929
EPOD_WSA.fmx 1.8 EPOD Web Service Audit Form 00273451
EPOD_WSA.fmx 1.9 EPOD Web Service Audit Form 02108654
IMP.sql 5.210 CSV Imports Package 00256955
IMP.sql 5.212 CSV Imports Package 00287950
IMP.sql 5.213 CSV Imports Package 00266101
IMP.sql 5.214 CSV Imports Package 00294849
INT_ERR_ORD.fmx 2.9 Interface error correction 00256553
INT_XML_IN.sql 5.232 Order Import Package 01899265
INT_XML_IN.sql 5.234 Order Import Package 01909696
INT_XML_IN.sql 5.235 Order Import Package 02041304
INT_XML_IN.sql 5.236 Order Import Package 02064763
INT_XML_IN.sql 5.237 Order Import Package 00319844
INT_XML_IN_REFS.sql 1.14 Openfield Order upload procedures 02108659
INT_XML_OUT2.sql 5.321 Outbound XML Package 01909696
INT_XML_OUT2.sql 5.323 Outbound XML Package 00279282
INT_XML_OUT2.sql 5.324 Outbound XML Package 02064763
INT_XML_OUT2.sql 5.325 Outbound XML Package 02133144
LFS_LABEL.rep 1.24 Label Report 01929119
LFS_LABEL_MULTI.rep 1.12 Label Report 01929119
LOAD_MAN.fmx 1.28 Load Management Form 01984366
LOCATION.fmx 2.200 Location Maintenance 00249891
LOCATION.fmx 2.201 Location Maintenance 01909696
MSG_CONSTRUCTOR.sql 5.20 E-mail construction 02112078
MSG_CONSTRUCTOR.sql 5.21 E-mail construction 02131420
MSG_JOB.sql 5.12 Message job functionality 01976934
MSG_PROCESSING.sql 5.72 Message Processing package 02112078
MSG_PROCESSING.sql 5.73 Message Processing package 02108654
MSG_PROCESSING.sql 5.74 Message Processing package 02131420
OMS.sql 5.248 Order package 01929119
OMS.sql 5.249 Order package 00266101
OMS.sql 5.250 Order package 02124954
ORDERS.fmx 2.446 Order Screen 01929119
ORDERS.fmx 2.447 Order Screen 01899265
ORDERS.fmx 2.448 Order Screen 01967222
ORDERS.fmx 2.449 Order Screen 02030242
ORDERS.fmx 2.450 Order Screen 02110684
ORDERS.fmx 2.451 Order Screen 02121883
ORDERS_WIDE.fmx 1.42 Orders Screen 01929119
ORDERS_WIDE.fmx 1.43 Orders Screen 01899265
ORDERS_WIDE.fmx 1.44 Orders Screen 01967222
ORDERS_WIDE.fmx 1.45 Orders Screen 02030242
ORDERS_WIDE.fmx 1.46 Orders Screen 02110684
ORDERS_WIDE.fmx 1.47 Orders Screen 02121883
ORS.fmx 1.32 Oracle Reporting suite 00282311
ORS.fmx 1.34 Oracle Reporting suite 00287894
ORS.fmx 1.35 Oracle Reporting suite 00278514
ORS.sql 5.11 Oracle Reporting suite 02124442
PLANNING.fmx 1.123 Planning Screen 00287229
PLANNING.fmx 1.124 Planning Screen 00287384
PLANNING.fmx 1.125 Planning Screen 01970111
PLANNING.fmx 1.126 Planning Screen 00279865
PLANNING.fmx 1.127 Planning Screen 02108659
RATE.sql 5.162 Rates Tariff database package 00287229
RATE.sql 5.163 Rates Tariff database package 00266101
RATE.sql 5.164 Rates Tariff database package 02124442
RESOURCE.fmx 2.195 Resource Maintenance form 00287229
T_SCH_ORD_AUDIT.sql 5.19 Trigger for SCH_ORD_AUDIT 00265284
TI_SCH_ORD_STATUS.sql 1.22 Trigger on SCH_ORD for status change 00266101
TI_SCH_ORD_STATUS.sql 1.23 Trigger on SCH_ORD for status change 00273451
TI_SCH_ORD_STATUS.sql 1.24 Trigger on SCH_ORD for status change 02124442
TRG_EPOD_WEB_SERVICE_AUDIT.sql 1.4 Trigger 02108654
TRG_EPOD_WEB_SERVICE_AUDIT.sql 1.5 Trigger 02131420
TRG_GEO_LOCATION_UID.sql 5.2 Trigger 00266101
TRG_LOCATIONS_UID.sql 5.1 Trigger 02124442
TRG_ORD_TYRE_INSPECTION_BIU.sql 1.1 Trigger 00239646
TRG_ORD_TYRE_INSPECTION_BIU.sql 1.2 Trigger 00265284
TRG_ORD_TYRE_INSPECTION_BIU.sql 1.3 Trigger 00287638
TRG_RES_VEHICLE_AXLE_BIU.sql 1.1 Database Trigger 00239646
TRG_RES_VEHICLE_CONFIG_AXLE_BIU.sql 1.1 Database Trigger 00239646
TRG_RES_VEHICLE_CONFIG_BIU.sql 1.1 Database Trigger 00239646
TRG_RES_VEHICLE_CONFIG_EPOD.sql 1.1 Trigger 00293881
TRG_RES_VEHICLE_CUST_LOC_BIU.sql 1.1 Database Trigger 00239646
TRG_RES_VEHICLE_TYRE_BIU.sql 1.1 Database Trigger 00239646
TRG_SCH_ORD_CURRENT_DEPOT.sql 5.2 Trigger 00266101
TRG_SCH_ORD_CURRENT_DEPOT.sql 5.3 Trigger 02124442
TRG_SCH_ORD_INFORMATION_IU.sql 1.6 Trigger 00266101
TRG_SCH_ORD_ITEMS_REASONS.sql 5.15 Trigger 00266101
TRG_SCH_ORD_REFERENCE_AI.sql 1.4 Trigger on SCH_ORD_REFERENCE 01969607
TRG_SCH_ORD_REFERENCE_AI.sql 1.5 Trigger on SCH_ORD_REFERENCE 02108659
TRG_SCH_ORD_TRACKING.sql 1.1 Trigger 01970111
TRG_SCH_ORD_TRACKING.sql 1.2 Trigger 02023242
TRG_SCH_ORD_VEHICLE_BIU.sql 1.1 Trigger 00265284
TRG_SCH_ORD_VEHICLE_PAR.sql 5.2 Trigger 02124442
TRG_SCH_ORDER_LINE_PAR.sql 5.1 Trigger 02124442
TRG_SCH_TRIP_CARRIER_ID_U.sql 5.3 Trigger 02112078
TRG_SCH_TRIP_CARRIER_ID_U.sql 5.4 Trigger 02131420
TRG_SCH_TRIP_MTM_COST.sql 1.1 Trigger 00266101
TRG_SCH_TRIP_STOP_ACPT.sql 5.1 Trigger 02124442
TRG_SCH_TRIP_XML_INT.sql 5.36 Trigger 00266101
TRG_SCH_TRIP_XML_INT.sql 5.37 Trigger 00273451
TRG_SCH_TRIP_XML_INT.sql 5.38 Trigger 02112078
TRG_SCH_TRIP_XML_INT.sql 5.39 Trigger 02131420
TRG_SCH_TRIP_XML_MX.sql 1.1 Trigger 01909696
TRG_SHA_LOTS.sql 5.8 Trigger 00266101
TRG_SOI_XML.sql 5.23 Trigger 00273451
TRG_SOL_XML.sql 5.47 Trigger 00266101
TRG_SOL_XML.sql 5.48 Trigger 00273451
TRG_SONC_DELETE_MIS.sql 5.7 Trigger 00266101
TRG_STS_AI.sql 1.2 Trigger 00530144
TRG_STS_XML.sql 5.24 Trigger 00266101
TRG_STS_XML.sql 5.25 Trigger 00530144
TRG_STS_XML_OUT.sql 5.36 Trip Stop Trigger 00266101
TRG_TOMTOM_ETA_EVENTS_INSERT.sql 1.1 Trigger 00530148
TRG_TOMTOM_STOP_EVENTS_INSERT.sql 1.1 Trigger 00530144
TRG_TRIP_COST.sql 1.3 Trigger 02124442
TRG_TT_EVENTS_STORE.sql 1.1 Trigger 00530144
TRG_TT_EVENTS_STORE.sql 1.2 Trigger 00530148
TRG_TT_EVENTS_STORE.sql 1.3 Trigger 02124442
TRM.sql 5.204 Trip manipulation package 00261979
TRM.sql 5.205 Trip manipulation package 00287229
TRM.sql 5.206 Trip manipulation package 00265284
TRM.sql 5.207 Trip manipulation package 00287384
TRM.sql 5.208 Trip manipulation package 01984366
TRM.sql 5.209 Trip manipulation package 02011793
TRM.sql 5.210 Trip manipulation package 02124442
UTL_FILE.sql 5.3 UTL File Package 00233816
V_CTL_CUSTLOC.sql 5.3 View 00260047
V_CTL_MENUS.sql 5.2 View 00260047
V_DRIVER_LIST.sql 5.1 View 00308136
V_JOB_TYPE.sql 5.3 View 00260047
V_JOB_TYPE.sql 5.4 View 00308136
V_ORD_ORDER_CONTACT.sql 1.4 View 00308136
V_ORD_ORDER_HEADER.sql 1.11 View 00260047
V_ORD_ORDER_HEADER.sql 1.12 View 00308136
V_ORD_REQUIREMENT.sql 1.8 View 01584585
V_PRODUCT_CTL.sql 1.1 View 00308136
V_SCH_TRIP_AUDIT.sql 1.1 View 02064838
V_TRP_TRIP_STOP.sql 1.3 View 00260047
V_TRP_TRIP_STOP.sql 1.4 View 00308136
V_VEHICLE_DETAILS.sql 5.1 View 00301397
XML.sql 5.15 XML file upload 00266101


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_P042&oldid=10126’