PATCH C-TMS P044

From Calidus HUB
Revision as of 14:38, 7 June 2023 by StylesC (talk | contribs)




Aptean Logo.png










Release Notes

CALIDUS TMS

22nd May 2023 - 1.0
Reference: P044











































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

Module Name Version No Description Log Number
ACC_MAINT.fmx 2.98 Accounts Maintenance 02240275
AT_CNT_TARIFF_02240275.sql 1.3 AT Script 02240275
AT_GEO_LOCATION_00432970.sql 1.2 AT Script 00432970
AT_ORG_CUSTOMER_02240275.sql 1.1 AT Script 02240275
AT_PAR_API_STAGING_00432970.sql 1.1 AT Script 00432970
AT_PAR_JSON_IN_00432970.sql 1.1 AT Script 00432970
AT_RES_TRACTOR_00354055.sql 1.2 AT Script 00354055
CNT.sql 5.55 Contracts package 02240275
CNT.sql 5.57 Contracts package 00468785
CONTRACT.fmx 2.79 Contracts Form 02240275
CONTRACT.fmx 2.81 Contracts Form 02587737
CONTRACT.fmx 2.82 Contracts Form 00468785
CT_ACC_RATING_PARTY_02240275.sql 1.2 CT Script 02240275
CT_ACC_RATING_PARTY_459921.sql 1.1 CT Script 00459921
CT_PAR_FIX_API_00432970.sql 1.1 CT Script 00432970
CT_SCH_ORD_STATS.sql 1.1 CT Script 02280656
CT_T_DRIVER_LIST_375171.sql 1.1 CT Script 00375171
CT_TMP_TOKEN.sql 1.2 CT Script 00461571
CUST_COST.fmx 2.143 Customer Maintenance form 02240275
DATA_1_ORS_MASTER_DATA_459921.sql 1.1 Data Script 00459921
DATA_2_ORS_MASTER_DATA_459921.sql 1.1 Data Script 00459921
DATA_3_ORS_MASTER_DATA_459921.sql 1.1 Data Script 00459921
DATA_ADM_FORM_TAB_02240275.sql 1.1 Data Script 02240275
DATA_ADM_MSEL_FORM_PARAM_02554907.sql 1.1 Data Script 02554907
DATA_ADM_SYSTEM_PARAM_00415572.sql 1.2 Data Script 00415572
DATA_ADM_SYSTEM_PARAM_00432970.sql 1.1 Data Script 00432970
DATA_ADM_SYSTEM_PARAM_00463330.sql 1.1 Data Script 00463330
DATA_ADM_SYSTEM_PARAM_00466359.sql 1.1 Data Script 00466359
DATA_ADM_SYSTEM_PARAM_02230751 1.1 Data Script 02230751
DATA_ADM_SYSTEM_PARAM_02240275.sql 1.3 Data Script 02240275
DATA_ADM_SYSTEM_PARAM_02254537.sql 1.2 Data Script 02254537
DATA_ADM_SYSTEM_PARAM_02274554.sql 1.2 Data Script 00464609
DATA_ADM_SYSTEM_PARAM_02280682.sql 1.1 Data Script 02280682
DATA_ADM_SYSTEM_PARAM_02462955.sql 1.1 Data Script 02462955
DATA_ADM_SYSTEM_PARAM_02543350.sql 1.2 Data Script 02543350
DATA_ADM_SYSTEM_PARAM_CONFIG_02543350.sql 1.1 Data Script 02543350
DATA_CNT_CHARGE_PARAM_02240275.sql 1.6 Data Script 02240275
DATA_CNT_CONDITION_02240275.sql 1.2 Data Script 02240275
DATA_CNT_CONDITION_VALUE_02240275.sql 1.2 Data Script 02240275
DATA_EDI_PROCESS_TRIGGER_380366.sql 1.1 Data Script 00380366
DATA_EDI_PROCESS_TRIGGER_451971.sql 1.1 Data Script 00451971
DATA_GEO_LOC_TYPE_00354055.sql 1.1 Data Script 00354055
DATA_IMP_DECODE_00381747.sql 1.2 Data Script 00381747
DATA_IMP_DECODE_02240275.sql 1.1 Data Script 02240275
DATA_IMP_DECODE_ENTRY_00381747.sql 1.2 Data Script 00381747
DATA_IMP_DECODE_ENTRY_02240275.sql 1.3 Data Script 02240275
DATA_IMP_FIELD_02240275.sql 1.1 Data Script 02240275
DATA_ORS_MASTER_DATA_02280656.sql 1.1 Data Script 02280656
DATA_ORS_MASTER_DATA_1_02240275.sql 1.2 Data Script 02240275
DATA_ORS_MASTER_DATA_2_02240275.sql 1.2 Data Script 02240275
DATA_ORS_MASTER_DATA_3_02240275.sql 1.2 Data Script 02240275
DATA_ORS_MASTER_DATA_436894.sql 1.1 Data Script 00436894
DATA_ORS_SQL_02280656.sql 1.2 Data Script 02280656
DATA_ORS_SQL_1_02240275.sql 1.2 Data Script 02240275
DATA_ORS_SQL_459921.sql 1.1 Data Script 00459921
DATA_REP_REPORT_02280656.sql 1.1 Data Script 02280656
DATA_REP_REPORT_PARAM_02280656.sql 1.1 Data Script 02280656
DP_3PL_SCHED.sql 5.1 3PL Scheduling Engine Database Package 00432970
DP_3PL_SCHED.sql 5.2 3PL Scheduling Engine Database Package 00461571
DP_3PL_SCHED.sql 5.3 3PL Scheduling Engine Database Package 00462809
DP_3PL_SCHED.sql 5.4 3PL Scheduling Engine Database Package 00463330
DP_CSV_GEN.sql 1.7 Generic CVS package 02280656
DP_CSV_GEN.sql 1.8 Generic CVS package 00459742
DP_CTMS_IMPORT.sql 5.21 API Import Database Package 00432970
DP_CTMS_IMPORT.sql 5.22 API Import Database Package 02442010
DP_CTMS_IMPORT.sql 5.23 API Import Database Package 00380366
DP_CTMS_IMPORT.sql 5.24 API Import Database Package 00440788
DP_CTMS_IMPORT.sql 5.25 API Import Database Package 00453913
DP_CTMS_IMPORT.sql 5.26 API Import Database Package 00459135
DP_CTMS_IMPORT.sql 5.27 API Import Database Package 00451971
DP_CUST_SERV.sql 1.56 Customer Service Package 00375171
DP_CUST_SERV.sql 1.57 Customer Service Package 00377394
DP_CUST_SERV.sql 1.60 Customer Service Package 00381222
DP_CUST_SERV.sql 1.61 Customer Service Package 00433739
DP_CUST_SERV.sql 1.62 Customer Service Package 00433476
DP_CUST_SERV.sql 1.63 Customer Service Package 00380366
DP_CUST_SERV.sql 1.64 Customer Service Package 00445742
DP_CUST_SERV.sql 1.65 Customer Service Package 00452346
DP_CUST_SERV.sql 1.66 Customer Service Package 00464296
DP_EPOD_WEB_SERVICE.sql 1.178 EPOD Web Service 00354055
DP_EPOD_WEB_SERVICE.sql 1.179 EPOD Web Service 00377266
DP_EPOD_WEB_SERVICE.sql 1.180 EPOD Web Service 00377386
DP_EPOD_WEB_SERVICE.sql 1.181 EPOD Web Service 00378735
DP_EPOD_WEB_SERVICE.sql 1.182 EPOD Web Service 00381747
DP_EPOD_WEB_SERVICE.sql 1.183 EPOD Web Service 00432097
DP_EPOD_WEB_SERVICE.sql 1.184 EPOD Web Service 00433476
DP_EPOD_WEB_SERVICE.sql 1.185 EPOD Web Service 02281070
DP_EPOD_WEB_SERVICE.sql 1.186 EPOD Web Service 00437518
DP_EPOD_WEB_SERVICE.sql 1.187 EPOD Web Service 00440383
DP_EPOD_WEB_SERVICE.sql 1.188 EPOD Web Service 00464296
DP_EPOD_WEB_SERVICE.sql 1.189 EPOD Web Service 00465517
DP_EXPORT_EVENTS.sql 5.23 API Export Events Database Package 00461571
DP_MCS_SCANNING.sql 5.71 MCS Scanning Package 02254537
DP_MIS.sql 5.8 MIS Interface Package 02277663
DP_ORS_FUNCS.sql 5.29 Change to DOOD status function 00459921
DP_PAR_API.sql 5.12 Paragon API Database Package 02576783
DP_PAR_API.sql 5.13 Paragon API Database Package 02590010
DP_PAR_API_STP.sql 5.3 STP Paragon API Database Package 00432970
DP_PAR_API_STP.sql 5.5 STP Paragon API Database Package 00453913
DP_PAR_API_STP.sql 5.8 STP Paragon API Database Package 02576783
DP_PAR_API_STP.sql 5.9 STP Paragon API Database Package 02590010
DP_PORTAL.sql 5.20 Portal Package 00463873
DP_REPORTS.sql 5.74 Reports package 02240275
DP_SCHEDULING_ENGINE.sql 5.182 Scheduling Package 00432970
DP_SCHEDULING_ENGINE.sql 5.183 Scheduling Package 02566122
DP_TRM_CHANGE_SCHEDULE.sql 5.3 Change Schedule Database Package 02558002
EDI_MAINT.fmx 10.18 EDI Maintenance Screen 02539791
EPOD_WSA.fmx 1.10 EPOD Web Service Audit Form 00354055
IMP.sql 5.220 CSV Imports Package 02240275
IMP.sql 5.221 CSV Imports Package 00456483
IMP.sql 5.222 CSV Imports Package 02587737
INT_XML_IN.sql 5.239 Order Import Package 00451971
INT_XML_MIC.sql 5.156 MIC interface 02575003
INT_XML_OUT2.sql 5.329 Outbound XML Package 02537338
LOCATION.fmx 2.205 Location Maintenance 02433470
MSG_CONSTRUCTOR.sql 5.22 E-mail construction 02280682
MSG_CONSTRUCTOR.sql 5.23 E-mail construction 02574489
OMS.sql 5.331 Order package 02240275
OMS.sql 5.332 Order package 02440377
OMS.sql 5.333 Order package 00465515
ORS.sql 5.12 Oracle Reporting suite 02280656
ORS.sql 5.13 Oracle Reporting suite 00436894
PLANNING.fmx 1.136 Planning Screen 02274554
PLANNING.fmx 1.137 Planning Screen 02280656
PLANNING.fmx 1.138 Planning Screen 02543350
PLANNING.fmx 1.139 Planning Screen 00376072
RATE.sql 5.168 Rates Tariff database package 02240275
RES_TRACTOR_CARRIER_UID.sql 5.14 Trigger 00377345
ROUTES_MAINT.fmx 2.53 Fixed Routes Maintenance 00466359
STAP_LOAD_SHEET.rep 1.2 Loading Sheet 00380741
T_CNT_CONTRACT_CHECK_PARTYS.sql 1.2 Trigger 00468785
TI_SCH_ORD_STATUS.sql 1.26 Trigger on SCH_ORD for status change 00432970
TI_SCH_ORD_STATUS.sql 1.27 Trigger on SCH_ORD for status change 00461571
TIU_TRIP_STATUS.sql 5.56 Trigger on SCH_TRIP for status change 00375172
TIU_TRIP_STATUS.sql 5.57 Trigger on SCH_TRIP for status change 02593759
TRG_ACC_RATING_PARTY_BIU.sql 1.1 Trigger 02240275
TRG_DRY_ICE.sql 1.21 Trigger 02240275
TRG_GEL_PACKS.sql 1.16 Trigger 02240275
TRG_GEO_COUNTRY_CODE.sql 1.1 Trigger 00432970
TRG_GEO_DELIVERY_ROUTE_PRIORITY.sql 1.1 Trigger 00461571
TRG_GEO_LOCATION_UID.sql 5.5 Trigger 00432970
TRG_GEO_LOCATION_UID.sql 5.6 Trigger 00461571
TRG_SCH_ORD_CURRENT_DEPOT.sql 5.5 Trigger 00461571
TRG_SCH_ORD_EQUIP_SERVICES.sql 5.7 Database Trigger Script 02240275
TRG_SCH_ORD_LABOUR_SERVICES.sql 5.6 Database Trigger Script 02240275
TRG_SCH_ORD_LINES_SERVICES.sql 5.8 Database Trigger Script 02240275
TRG_SCH_ORD_LINES_SERVICES.sql 5.9 Database Trigger Script 00456483
TRG_SCH_ORD_SERVICES.sql 5.9 Database Trigger Script 02240275
TRG_SCH_ORD_SERVICES_BIUDR.sql 5.5 Trigger for SCH_ORD_SERVICES 02240275
TRG_SCH_ORDER_LINE_PAR.sql 5.2 Trigger 00461571
TRG_SCH_TRIP_XML_INT.sql 5.40 Trigger 02528443
TRIP_OVERVIEW.fmx 1.72 Trip Waterfall 02542209
TRIP_OVERVIEW.fmx 1.73 Trip Waterfall 00453913
TRIP_OVERVIEW.fmx 1.74 Trip Waterfall 02554907
TRIP_OVERVIEW.sql 5.10 Trip Waterfall 02554907
TRIP_OVERVIEW.sql 5.11 Trip Waterfall 00470954
TRIP_OVERVIEW.sql 5.9 Trip Waterfall 00453913
TRIP_PLAN.fmx 1.282 Trip Planning Screen 02543350
TRIP_SHEET_DUNELM_DETAIL.rep 5.29 Driver Trip Sheet 02437325
TRIP_SHEET_DUNELM_DETAIL.rep 5.31 Driver Trip Sheet 02539052
TRIPSUM.fmx 2.448 Trip Manipulation screen 02531360
TRIPSUM.fmx 2.449 Trip Manipulation screen 02543350
TRM.sql 5.220 Trip manipulation package 00375172
TRM.sql 5.221 Trip manipulation package 00376075
TRM.sql 5.222 Trip manipulation package 02462955
UTL.sql 5.4 Utility Database Package 02230751
V_ORD_ORDER_HEADER.sql 1.16 View 00381222
V_TRIP_OVERVIEW.sql 1.21 Trip View 00453913
V_TRIP_OVERVIEW.sql 1.22 Trip View 00462694
V_TRIP_OVERVIEW.sql 1.23 Trip View 02554907
V_TRIP_OVERVIEW_ORD.sql 5.14 Trip/Order View 02554907
V_VEHICLE_DETAILS.sql 5.5 View 00375171
WAREHOUSE.fmx 2.16 Warehouse Screen 02240275
WAREHOUSE.fmx 2.17 Warehouse Screen 02587737


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_P044&oldid=10600’