PATCH C-TMS 11.0 P017 071015: Difference between revisions

From Calidus HUB
No edit summary
No edit summary
Line 252: Line 252:
|-
|-
| 330091 || DF-TMS-006 || 3 || Fix added to remove files from export out directory once the FTP process has completed successfully, and a copy has been moved into the Archive folder. || u/a || Interfaces || Peter Blackburn || 016-080 || N || N || N || N || N
| 330091 || DF-TMS-006 || 3 || Fix added to remove files from export out directory once the FTP process has completed successfully, and a copy has been moved into the Archive folder. || u/a || Interfaces || Peter Blackburn || 016-080 || N || N || N || N || N
|-
| 328052 || - || 4 || add epod times to stops view || u/a || Setup / Maintenance || Ed Bond || 016-081 || N || N || N || N || N
|-
|-
| 327706 || - || 4 || The radial routing code will be evaluated by the same method as the scheduling engine to assess the location zones for consistency. The radial routing code and region will be obtained from the RADIAL route stops for the POSTCODE zone for the location being inserted or updated with a different address. || Australia || Orders || Matthew Tipping || - || N || N || N || N || N
| 327706 || - || 4 || The radial routing code will be evaluated by the same method as the scheduling engine to assess the location zones for consistency. The radial routing code and region will be obtained from the RADIAL route stops for the POSTCODE zone for the location being inserted or updated with a different address. || Australia || Orders || Matthew Tipping || - || N || N || N || N || N
Line 262: Line 264:
|-
|-
| 329370 || - || 3 || New rule FIRST_RDC_LOAD added to TRM_SET_OWNING_DEPOT to determine the value to be used for setting the owning depot on new trips. || u/a || Trips || Pete Crane || - || N || N || N || N || N
| 329370 || - || 3 || New rule FIRST_RDC_LOAD added to TRM_SET_OWNING_DEPOT to determine the value to be used for setting the owning depot on new trips. || u/a || Trips || Pete Crane || - || N || N || N || N || N
|-
| 328052 || - || 4 || add epod times to stops view || u/a || Setup / Maintenance || Ed Bond || - || N || N || N || N || N
|-
|-
| 328282 || - || 3 || Product change to allow all Locations to be updated if the Planning Region is changed via the Static Data Maintenance form.  The following group function will be used to activate the above changes: ADM_PLAN_REGION_UPDATE, this will require access via the group maintenance form. || u/a || u/a || Pete Crane || - || N || N || N || N || N
| 328282 || - || 3 || Product change to allow all Locations to be updated if the Planning Region is changed via the Static Data Maintenance form.  The following group function will be used to activate the above changes: ADM_PLAN_REGION_UPDATE, this will require access via the group maintenance form. || u/a || u/a || Pete Crane || - || N || N || N || N || N

Revision as of 12:30, 9 October 2015





Aptean Logo.png







OBS Logistics Ltd

Software Release Notes


CALIDUS TMS

2nd Oct 2015 - 1.0
Reference: P017












































Development Defects

  Changes Required
Log Number Client Ref Log Priority Issue Raised and Test Objective Project/Site Functional Area Reported ER Number WCS EPOD TTM EDI MCS
328682 Bath030 3 Fix to Microlise DEL message import so that the order status is set correctly. u/a Interface - Imports Tom Judge 016-001 N N N N N
328683 Bath031 3 Changed the date format u/a u/a Tom Judge 016-002 N N N N N
328761 - 3 The 'TRP' file will not be sent for the milestone event until all of the order lines for the milestone type have been confirmed. Any orders on the trip that do not generate milestone events will still be included in the 'TRP' file when it is generated.

The 'Set Desp' and 'Set Del' buttons for the order lines in the 'Trip Debrief' screen will be enabled if any of the order lines for the trip can have their actual despatched or actual delivered quantities set for the trip stop. The 'TRM_DESP_FOR_DEL' system parameter controls when an order line can maintain a quantity and the 'Set Desp' and 'Set Del' buttons will be active when an order line can have the relevant quantity set for the trip.

Poland - Warsaw EDI - Outbound Arkadiusz Garbacik 016-003 N N N N N
327985 INVALID orders 3 New system parameter to control how far back to go when clearing invalid orders for Buffaload. Ely u/a Peter Crane 016-004 N N N N N
328343 - 3 The urgent order messages will be processed if they are still required for the current delivery type of the order: if the delivery type is no longer urgent then a message will not be generated.

All of the current recipient types can be listed for selection in the Message Maintenance screen. The urgent order messages will be processed via an EDI process with the following report values:

Title: Package Name Name: PROCESS Value: DP_REPORTS.P_PROCESS_URGENT

Title: Parameter Name: p_process Value: URGENT

Australia Setup / Maintenance Paul Roscoe 016-005 N N N N N
328770 - 3 Duplicated content based on mutliple delivery locations. Code amended to prevent duplicated content DESPATCH_EMAIL set to N, emails will only be generated when trips are despatched using MCS Australia u/a Suzanne Woodcock 016-005 N N N N N
328361 - 3 Do not convert files already in UTF8 Poland - Warsaw Interfaces Dave Meir 016-006 N N N N N
328280 - 3 Fix to trip manipulation within the x-dock screen to prevent orders being planned to the same location twice within the same trip. Additionally any orders that have been planned to the same location on different trips required a fix to the un-scheduling process to handle multiple occurrences of the same location for the same order on different trips. u/a Trips - Trip Planning Various 016-007 N N N N N
328880 Bath034 3 Change to the format of the arrive time in the required format for Kerridge u/a u/a Tom Judge 016-008 N N N N N
328814 Bath032 3 Functionality added so that is the system parameters: REBOOK_COPY_SUB_REF_CONTACTS is configured to 'Y' for a given cost centre then all contact sub references will be copied when an order is rebooked. u/a Orders Tom Judge 016-009 N N N N N
328681 Bath029 3 Many changes to Morning Report following clarification of requirements. u/a Interface - Exports Tom Judge 016-010 N N N N N
328928 Bath035 3 Fix applied so that the correct quantity is displayed for failed (returned) items. u/a Reports Tom Judge 016-011 N N N N N
328957 Bath036 3 Exclude rebooks based on the _R extrenal ref rather than use of the REBOOK reason code u/a u/a Tom Judge 016-012 N N N N N
328952 - 3 Does not recalculate volume when NO_RECALC_VOL set to Y. u/a Orders - Entry Arkadiusz Garbacik 016-013 N N N N N
328953 - 3 Fixes to the debrief screen to include Actual Volume when setting all actuals and to prevent all actuals being set when volume is populated. Parameter TRM_UPDATE_ALL_ACTUALS , set to N. The actual delivered cases, weight and volume columns for the order lines in the Trip Debrief screen will not be enabled for editing for a non-delivery trip if the system parameter TRM_DESP_FOR_DEL is Y. u/a Trips - Trip Debrief Arkadiusz Garbacik 016-014 N N N N N
329015 Bath037 3 Fix to Microlise import interface to correctly log reason codes into the table SCH_ORD_LATE_REASONS. Additionally a fix has been applied to the Morning Report to prevent error occurring if the External Ref is greater the 12 characters. u/a Interface - Imports Tom Judge 016-015 N N N N N
328572 Bath021 3 Fix to location extract report to prevent error occurring when no parameters are selected for the extract to run. u/a Reports Tom Judge 016-016 N N N N N
329029 PO:95347 3 Changes to the invoice report to display the Vat reg no when the customer is not based in GB for VAT Leicester u/a Gary King 016-017 N N N N N
325500 04032015-Req3 3 New SMS message to customer when trip leaves depot. Needs cost centre level parameter SEND_SMS_EMAIL setting to appropriate trip status. Skelmersdale u/a Sue Blake 016-018 N N N N N
328613 - 3 Add carrier selection to tractor and trailer. Bolton Setup / Maintenance Steve Atkins 016-019 N N N N N
328117 - 3 New Trip Debreif Import to allow PCL carriers to send in debreif information which is uploaded to C-TMS Australia u/a Hayley Keegan 016-020 N N N N N
329060 Bath039 3 Changes to the Morning reports to reflect changes made to DEL_TIMES. u/a u/a Tom Judge 016-021 N N N N N
329036 Bath038 3 Collections: Fix report so that ONLY successful collection order items are displayed on the report.

Deliveries: Failed items which are split between multiple failure reasons will now display correct quantities values against each failure line.

u/a Reports Tom Judge 016-022 N N N N N
329156 - 3 Changes to the despatch process to ensure the trip can be set to Completed, triggering the Carrier and Trip Manifests Australia u/a Suzanne Woodcock 016-023 N N N N N
329172 - 3 The entered actual weight and the actual volume will be retained in the 'Trip Debrief' screen for the order line when the system parameter 'TRM_UPDATE_ALL_ACTUALS' is set to N for the cost centre of the trip. u/a Trips - Trip Debrief Arkadiusz Garbacik 016-024 N N N N N
329102 - 3 The EDI parameters FROM_LOC_TYPE and TO_LOC_TYPE will be able to store multiple location types as a comma-separated list if the locations are setup as RDC as well as BRANCH. Poland - Warsaw EDI - Outbound Paul Roscoe 016-025 N N N N N
328506 - 3 The presence of a 'NON_CONFORMANCE_EMAIL' EDI process will control if an e-mail is required for under-delivered orders during trip debrief.

Direction: Outbound Flow Type: PROCESS Filename: E-mail Folders: E-mail

The report values will be setup as follows:

Title: Process Name: p_process Value: NON_CONFORMANCE_EMAIL

Title: Package Name: PROCESS Value:DP_REPORTS.SEND_NON_CONFORM_EMAIL

Title: Send Name: p_sender Value: [email protected]

Title: Email Name: p_address Value: [email protected]

Title: Subject Name: p_subject Value: Short Delivery or Cancellation

u/a EDI - Outbound Dave Meir 016-026 N N N N N
328336 - 3 New PDF report, upon release OBS to create 2 new EDI jobs to automate the generation and email of the reports. LFS may use these processes as the basis of new specific versions of the report to be run. Australia u/a Hayley Keegan 016-027 N N N Y N
328276 PG-9Y6HH7 1 The database script will create a new cost-centre-level system parameter called 'TRM_SET_OWNING_DEPOT' that will enable the setting of the owning depot of trip to be configurable. The trip planning screens will include filters to display the trips for the depots, locations and schedule groups. u/a u/a Peter Greer 016-028 N N N N N
329385 - 3 The 'Trip Debrief' screen will refer to the system parameter 'TRM_UPDATE_ALL_ACTUALS' so that when it is 'N' the actual weight and volume will be set to the planned values when the actual despatched quantities are set and the actual weight and volume have not been set previously. The functionality will then follow the 'Set Desp' button and the actual weight will not be set to 0 by default when the actual despatched quantities are set and the actual weight has not been set previously. Poland - Warsaw Trips - Trip Debrief Arkadiusz Garbacik 016-029 N N N N N
329242 - 4 The Poland Pallet Label report will use the current depot of the orders that have been cross-docked to that depot on the specific schedule date. Poland - Warsaw Reports Arkadiusz Garbacik 016-030 N N N N N
329202 Bath041 3 Added DelDate to Morning Report - Held u/a Reports Tom Judge 016-032 N N N N N
329395 Bath045 3 Re-Order of report columns within Failed Morning Report, plus script to re-build ALL morning reports across all environments. All saved reports will be removed and will require creating again. u/a Reports Tom Judge 016-033 N N N N N
329398 Bath046 3 Adjustments to manifest report to correctly calculated total number of visits, plus change planned duration time from mins to hrs/mins u/a Reports Tom Judge 016-034 N N N N N
329401 - 4 Changes to the logo and alignement on the Distribution report Australia Reports Hayley Keegan 016-035 N N N N N
329392 - 3 The existing database job to check the message events will be amended to pass a parameter for all non-SMS/EMAIL messages. A separate database job will be created for the SMS/EMAIL messages. The database job will run the process called 'MSG_JOB.P_CHECK_EVENT' with a parameter of 'OTHER' for non-SMS/EMAIL messages and a parameter of 'SMS_EMAIL' for SMS/EMAIL messages. u/a Interface - Mail messaging Barry Preece 016-036 N N N N N
329529 Bath048 3 Re-Order of report columns within Held Morning Report related to log 329528, plus additional fix to display item reason code and description. u/a Reports Tom Judge 016-037 N N N N N
329177 TJ-9ZGAQR 2 Include all failed deliveries and add action column. u/a Reports Tom Judge 016-038 N N N N N
328904 EH-9WXHNL 3 Pass in process name so it can be run for multiple cost centre's. u/a u/a Dave Meir 016-039 N N N N N
328404 BC-9Y9JDX 4 New message for Portal when packed quantities changed and include the packed quatity field in XML. u/a u/a Brett Court 016-040 N N Y N N
329265 E2E Session line 3 3 Session Amendment updating orders u/a EDI - Inbound Neville Robinson 016-041 N N N N N
329371 - 3 If the system parameter 'TRM_SET_OWNING_DEPOT' has not been setup for your cost centre then do not update the trip owning depot in the trip forms automatically when it is already set. i.e. Keep original value and functionality. u/a Trips Pete Crane 016-042 N N N N N
329579 - 3 Fix to allow completed trips to be debriefed via import file which will send DEL messages to portal which will update LOTS. The following system parameter will require configuring to Y to allow this functionality to work: LOTS_DEL_MSG_TRIP_STATUS_COMPLETE Australia u/a Hayley Keegan 016-043 N N N N N
328570 - 3 The NON_CONFORMANCE_EMAIL control record will only be created for the cancelled jobs if there is an EDI process for the trigger. u/a Interfaces Dave Meir 016-044 N N N N N
323882 - 3 EPOD job level cancel u/a u/a Tina Kinsella 016-044 N N N N N
329712 INC10816177 3 Fix for Held Morning report so that including the Date Booked For column does not prevent the report from completing successfully u/a Reports Tom Judge 016-045 N N N N N
329374 - 3 Validate vehicle based on DU u/a Trips - Trip Manipulation Neville Robinson 016-046 N N N N N
329569 INTSUB002 3 Do not change owning depot on trip if already set. Coventry Trips Sarah Howells 016-046 N N N N N
328617 COOP - Labels 3 A new EDI process will need to be setup as follows, for example:

Process Name = BUFF_ORD_XML_IN

Filename Format = BUFF_TMS_ORD_*

Customer = COOP LOGISTI or NULL (to be used as a default customer if a customer is not included in the file)

Cost Centre Code = BUFFALOAD or NULL (to be used as a default cost centre if a cost centre is not included in the file)

u/a u/a Darren Morton 016-047 N N N N Y
329814 - 3 Efficiency Changes to improve the run time of the DISTRIBUTION reports Australia u/a Suzanne Woodcock 016-048 N N N N N
329779 TJ-9ZYGRK 3 Change date format to include century u/a u/a Tom Judge 016-049 N N N N N
328306 CR-14 3 New import for shift patterns. Needs to be manually created using the new standing data and then manually promoted to an approprate group. u/a Interface - Imports Ed Bond 016-050 N N N N N
329891 - 3 Issue with the postcode type Zone import, cursor error has been resolved. Australia u/a Hayley Keegan 016-051 N N N N N
329664 MS-9ZWBCD 2 Address changed to pallet label which will display the from location of the order rather than the owning depot location Poland/European u/a Michal Szopa 016-052 N N N N N
329840 INC10787644 4 Amendment to WCS order confirmation process so when the last item is removed (action type D) from an order line, the line is deleted. When the line was kept with a 0 quantity the trip status could not be updated. Hatfield Interface - WCS Suzie Maskery 016-053 N N N N N
329983 INC10949916 2 Fix applied to Kerridge Interface so that a value 'NONE' is returned if a route code cannot be found. u/a Interface - Exports TOM JUDGE 016-054 N N N N N
329671 Bath050 3 Change how collections calculate quantity (no need to get reason codes). u/a Reports Tom Judge 016-055 N N N N N
329613 - 3 Formal release of values for the message maintenance screen for the Bathstore SMS emails u/a Setup / Maintenance Tom Judge 016-057 N N N N N
325461 - 3 Part one release of Interface changes for Sigma Inbound Orders Australia u/a Matthew Tipping 016-058 N N N N N
326855 PHASE 1 3 Invoice export Phase 1 changes. The following existing System Parameters will require setting to the correct FTP configuration for each environment:

OF_FTP_DESTINATION_ DIRECTORY

OF_FTP_DESTINATION_IP_ADDRESS

OF_FTP_DESTINATION_PASSWORD

OF_FTP_DESTINATION_PORT

OF_FTP_DESTINATION_USERNAME

Australia u/a Hayley Keegan 016-059 N N N N N
329835 TJ-A25GRR 3 Layout and cosmetic changes to Manifest Report, with the inclusion of an additional parameter for Cost Centre. u/a u/a Tom Judge 016-060 N N N N N
329747 - 3 New system parameter will require configuring to 'N' for the specific cost centre to prevent order retaining the DELIVERED status once the trip has completed: TRM_RETAIN_ORD_STATUS_TRIP_COMPLETE u/a Orders - Debrief Kelly Hembling 016-061 N N N N N
329996 325461 3 second phase release of Sigma development 325461 Australia u/a Suzanne Woodcock 016-062 N N N N N
330120 325461 3 Changes to Interface for Sigma following internal testing Australia u/a Peter Crane 016-063 N N N N N
330073 - 3 Fix to pallet label to fix issue with the label counts and resetting the counts correctly based on the location, DU Type & DU Quantity Poland - Warsaw Reports Arkadiusz Garbacik 016-064 N N N N N
330064 - 3 Change to the Zone import to prevent failures when new portcodes are added Australia u/a Hayley Keegan 016-065 N N N N N
330084 - 3 Invoice export Phase 1 changes. Additional fix for FTP configuration and Export Column heading change Australia u/a Suzanne Woodcock 016-066 N N N N N
330124 INC11021110 3 Amendment to order copy function for cost centres with configuration setting REBOOK_COPY_SUB_REF_CONTACTS to also copy order references for STORE and ORDER_TYPE. u/a Orders - Entry Tom Judge 016-067 N N N N N
330123 325461 3 Changes to the Sigma inbound orders code following internal testing at OBS Australia u/a Peter Crane 016-068 N N N N N
330236 testing 3 Added customer into export screen Australia u/a Hayley Keegan 016-070 N N N N N
329932 DF-TMS-001 3 Product fix for EPOD Web Services Audit form u/a u/a Emily Collins 016-071 N N N N N
330095 Bath 052 3 Change to postcode on Morning Report u/a Interface - Exports Tom Judge 016-072 N N N N N
330094 Bath 051 3 Treat items with a space in the collection reason code as a delivery. u/a Reports Tom Judge 016-073 N N N N N
329624 DF-TMS-003 3 Upgrade to latest API's for Nokia Interfaces. u/a u/a Julie Scott 016-074 N N N N N
330177 DF-TMS-007 3 Product changes to EDI processing screen to disable and enable buttons, refresh status, refresh data blocks, improve validation and present more information in error messages. u/a u/a Peter Crane 016-076 N N N N N
330145 DF-TMS-005 3 Turn Loading Interface form off by default so as not displayed initially for any users. u/a Administration - Access Control Peter Crance 016-077 N N N N N
330358 - 3 Changes to Fixed Route import to include the Schedule engine flag Australia - Hayley Keegan 016-078 N N N N N
329578 329409 3 Latest version of XML outbound package to overwrite previously released branch version for 329409. u/a EDI - Outbound Julie Taylor 016-079 N N N Y N
330091 DF-TMS-006 3 Fix added to remove files from export out directory once the FTP process has completed successfully, and a copy has been moved into the Archive folder. u/a Interfaces Peter Blackburn 016-080 N N N N N
328052 - 4 add epod times to stops view u/a Setup / Maintenance Ed Bond 016-081 N N N N N
327706 - 4 The radial routing code will be evaluated by the same method as the scheduling engine to assess the location zones for consistency. The radial routing code and region will be obtained from the RADIAL route stops for the POSTCODE zone for the location being inserted or updated with a different address. Australia Orders Matthew Tipping - N N N N N
329017 INC10495486 4 Add index to improve data access path the resource data when allocated resources are displayed in the waterfall screen. Lutterworth Trips - Trip Overview Dean Hudson - N N N N N
329145 - 3 Increased product type name to 50 Characters to match database size u/a u/a Paul Jones - N N N N N
329524 - 3 The NON_CONFORMANCE_EMAIL control record will only be created for the cancelled jobs if there is an EDI process for the trigger. The NON_CONFORMACE_EMAIL email will be generated for the orders that are not fully delivered when the trip status is COMPLETED or when a job is cancelled via EPOD. u/a Interfaces Paul Jones - N N N N N
329370 - 3 New rule FIRST_RDC_LOAD added to TRM_SET_OWNING_DEPOT to determine the value to be used for setting the owning depot on new trips. u/a Trips Pete Crane - N N N N N
328282 - 3 Product change to allow all Locations to be updated if the Planning Region is changed via the Static Data Maintenance form. The following group function will be used to activate the above changes: ADM_PLAN_REGION_UPDATE, this will require access via the group maintenance form. u/a u/a Pete Crane - N N N N N
330016 - 3 stop text being obscured when a carrier is selected u/a Trips - Trip Manipulation Dave Meir - N N N N N
329857 - 3 Extra auditing has been included. A SMS number will not be used for the same trip stop if it exists on different orders or on the same order. u/a Interface - Mail messaging Internal - N N N N N
330122 EH-9WXHNL 3 Update the last run parameter for the correct process(cost centre). u/a u/a Rob Merrill - N N N N N
330154 DF-TMS-004 3 Display all depots associated with the user in the drop down list u/a Administration Dave Meir - N N N N N
330279 INC11095342 3 Amendment to standing data behind the HELD Reporting. Suite option to prevent duplcated data where there are NON_CON and ITEM_NON_CON reason codes for the same reason. u/a Interface - Exports Tom Judge - N N N N N
330384 - 3 Changes to stops correctly planned from logs 330116 and 330196 Long Eaton Trips Tina Kinsella - N N N N N


Modules Delivered

Module Name Version No Description Log Number
AT_EDI_PROCESS_HEADER_325461.sql 1.1 Alter Table Script 325461
AT_GEO_LOCATION_328282.sql 1.1 Alter Table Script 328282
AT_GEO_LOCATION_329996.sql 1.1 Alter Table Script 329996
AT_INT_XML_ORD_DETAILS_325461.sql 1.2 Alter Table Script 325461
AT_INT_XML_ORD_DETAILS_330120.sql 1.1 Alter Table Script 330120
AT_INT_XML_ORD_HEADER_325461.sql 1.1 Alter Table Script 325461
AT_MSG_EVENT_325461.sql 1.1 Alter Table Script 325461
AT_ORG_CUSTOMER_326855.sql 1.1 Alter Table Script 326855
AT_PRD_PRODUCT_VALIDATION_PERIODS_329374.sql 1.1 Alter Table Script 329374
AT_RES_CARRIER_328117.sql 1.1 Alter Table Script 328117
AT_SCH_TRIP_STOP_329017.sql 1.1 Alter Table Script 329017
BATHSTORE_MANIFEST.rep 1.4 Manifest Report 329398
BATHSTORE_MANIFEST.rep 1.5 Manifest Report 329835
BATHSTORE_RET_TO_BASE.rep 1.3 Return to Base Report 328928
BATHSTORE_RET_TO_BASE.rep 1.6 Return to Base Report 329036
BATHSTORE_RET_TO_BASE.rep 1.7 Return to Base Report 329177
BATHSTORE_RET_TO_BASE.rep 1.8 Return to Base Report 329671
BATHSTORE_RET_TO_BASE.rep 1.9 Return to Base Report 330094
BOX_STATUS.fmx 1.11 Box Status Screen 330154
CUST_COST.fmx 2.90 Customer Maintenance form 326855
DATA_1_ADM_SYSTEM_PARAM_328276.sql 1.1 Data Script 328276
DATA_1_IMP_IMPORT_TYPE_328117.sql 1.1 Data Script 328117
DATA_1_IMP_IMPORT_TYPE_328306.sql 1.1 Data Script 328306
DATA_2_ADM_SYSTEM_PARAM_CONFIG_328276.sql 1.1 Data Script 328276
DATA_2_IMP_FIELD_328306.sql 1.1 Data Script 328306
DATA_2_IMP_IMPORT_TYPE_REC_TYPE_329117.sql 1.1 Data Script 328117
DATA_ADM_FUNCTION_328282.sql 1.1 Data Script 328282
DATA_ADM_SYSTEM_PARAM_325461.sql 1.1 Data Script 325461
DATA_ADM_SYSTEM_PARAM_325500.sql 1.1 Data Script 325500
DATA_ADM_SYSTEM_PARAM_326855.sql 1.1 Data Script 326855
DATA_ADM_SYSTEM_PARAM_327985.sql 1.1 Data Script 327985
DATA_ADM_SYSTEM_PARAM_328814.sql 1.1 Data Script 328814
DATA_ADM_SYSTEM_PARAM_328953.sql 1.1 Data Script 328953
DATA_ADM_SYSTEM_PARAM_329374.sql 1.1 Data Script 329374
DATA_ADM_SYSTEM_PARAM_329579.sql 1.1 Data Script 329579
DATA_ADM_SYSTEM_PARAM_329624.sql 1.1 Data Script 329624
DATA_ADM_SYSTEM_PARAM_329747.sql 1.1 Data Script 329747
DATA_ADM_SYSTEM_PARAM_329857.sql 1.1 Data Script 329857
DATA_ADM_SYSTEM_PARAM_330064.sql 1.2 Data Script 330064
DATA_ADM_SYSTEM_PARAM_330084.sql 1.1 Data Script 330084
DATA_ADM_SYSTEM_PARAM_330177.sql 1.1 Data Script 330177
DATA_ADM_SYSTEM_PARAM_CONFIG_328814.sql 1.1 Data Script 328814
DATA_ADM_SYSTEM_PARAM_CONFIG_328953.sql 1.1 Data Script 328953
DATA_ADM_SYSTEM_PARAM_CONFIG_329579.sql 1.1 Data Script 329579
DATA_ADM_SYSTEM_PARAM_CONFIG_329374.sql 1.1 Data Script 329374
DATA_ADM_SYSTEM_PARAM_CONFIG_329747.sql 1.1 Data Script 329747
DATA_IMP_FIELD_328117.sql 1.1 Data Script 328117
DATA_MSG_SMS_VALUES_325500.sql 1.1 Data Script 325500
DATA_MSG_SMS_VALUES_329613.sql 1.1 Data Script 329613
DATA_ORS_MASTER_DATA_328681.sql 1.1 Data Script 328681
DATA_ORS_MASTER_DATA_329060.sql 1.1 Data Script 329060
DATA_ORS_MASTER_DATA_329202.sql 1.1 Data Script 329202
DATA_ORS_MASTER_DATA_329395.sql 1.1 Data Script 329395
DATA_ORS_MASTER_DATA_329529.sql 1.1 Data Script 329529
DATA_ORS_MASTER_DATA_330095.sql 1.1 Data Script 330095
DATA_ORS_MASTER_DATA_330279.sql 1.1 Data Script 330279
DATA_ORS_SQL_328681.sql 1.1 Data Script 328681
DATA_REP_REPORT_328336.sql 1.1 Data Script 328336
DATA_REP_REPORT_PARAM_328336.sql 1.1 Data Script 328336
DATA_REP_REPORT_PARAM_329835.sql 1.1 Data Script 329835
DISTRIBUTION.rep 1.2 Distribution Report 328336
DISTRIBUTION.rep 1.3 Distribution Report 329401
DISTRIBUTION.rep 1.4 Distribution Report 329814
DISTRIBUTION_REPORT.rep 1.2 Distribution Report 328336
DISTRIBUTION_REPORT.rep 1.3 Distribution Report 329401
DISTRIBUTION_REPORT.rep 1.4 Distribution Report 329814
DP_CSV2.sql 5.67 Second CSV extract package 328572
DP_CSV6.sql 1.11 CSV Extract package 328904
DP_CSV6.sql 1.12 CSV Extract package 330122
DP_CTMS_UTL_FILE.sql 1.2 Database package to override system package UTL_FILE 328361
DP_EPOD_WEB_SERVICE.sql 1.76 EPOD Web Service 328570
DP_EPOD_WEB_SERVICE.sql 1.77 EPOD Web Service 323882
DP_EPOD_WEB_SERVICE.sql 1.78 EPOD Web Service 329524
DP_EPOD_WEB_SERVICE_STUB.sql 1.21 Database package 328570
DP_EPOD_WEB_SERVICE_STUB.sql 1.21 Database package 323882
DP_EPOD_WEB_SERVICE_STUB.sql 1.21 Database package 329524
DP_IMP.sql 5.25 Imports Package 328117
DP_IMP.sql 5.26 Imports Package 329579
DP_IMP_2.sql 1.45 Import Package 325500
DP_IMP_2.sql 1.47 Import Package 328306
DP_IMP_2.sql 1.48 Import Package 329891
DP_IMP_2.sql 1.49 Import Package 330064
DP_KERRIDGE.sql 5.10 Kerridge upload package 328880
DP_KERRIDGE.sql 5.11 Kerridge upload package 328957
DP_KERRIDGE.sql 5.12 Kerridge upload package 329779
DP_KERRIDGE.sql 5.13 Kerridge upload package 329983
DP_KERRIDGE.sql 5.9 Kerridge upload package 328683
DP_MCS_SCANNING.sql 5.32 MCS Scanning Package 329156
DP_NOKIA_LOC_PLAT.sql 1.17 Nokia Location Platform Interface 329624
DP_ORS_FUNCS.sql 5.16 Change to DOOD status function 328681
DP_ORS_FUNCS.sql 5.17 Change to DOOD status function 329015
DP_ORS_FUNCS.sql 5.18 Change to DOOD status function 329060
DP_ORS_FUNCS.sql 5.19 Change to DOOD status function 329712
DP_PULSE.sql 1.31 Pulse Interface Package 329265
DP_RDT_AUTO.sql 5.37 Client specific RDT funtions 329840
DP_REPORTS.sql 5.31 Reports package 328343
DP_REPORTS.sql 5.32 Reports package 328770
DP_REPORTS.sql 5.33 Reports package 329524
DP_SCHEDULING_ENGINE.sql 5.87 Scheduling Package 327706
DP_XML_FUNCS.sql 1.1 Generic XML Functions 329932
EDI_MAINT.fmx 10.7 EDI Maintenance Screen 325461
EDI_MAINT.fmx 10.8 EDI Maintenance Screen 329996
EDI_MAINT.fmx 10.9 EDI Maintenance Screen 330123
EPOD_WSA.fmx 1.2 EPOD Web Service Audit Form 329932
IMP.sql 5.111 CSV Imports Package 325500
IMP.sql 5.112 CSV Imports Package 328117
IMP.sql 5.113 CSV Imports Package 328306
IMP.sql 5.114 CSV Imports Package 330358
INT_ERR.fmx 1.84 Interface Errors 330177
INT_ERR_ORD.fmx 2.4 Interface error correction 325461
INT_ERR_ORD.fmx 2.5 Interface error correction 330123
INT_ERR_ORD.fmx 2.6 Interface error correction 330177
INT_XML_IN.sql 5.123 Order Import Package 328617
INT_XML_IN.sql 5.126 Order Import Package 325461
INT_XML_IN.sql 5.127 Order Import Package 329996
INT_XML_IN.sql 5.128 Order Import Package 330120
INT_XML_IN.sql 5.129 Order Import Package 330123
INT_XML_IN.sql 5.130 Order Import Package 330177
INT_XML_MIC.sql 5.119 MIC interface 328682
INT_XML_MIC.sql 5.120 MIC interface 329015
INT_XML_OUT2.sql 5.200 Outbound XML Package 328761
INT_XML_OUT2.sql 5.201 Outbound XML Package 329102
INT_XML_OUT2.sql 5.202 Outbound XML Package 328404
INT_XML_OUT2.sql 5.203 Outbound XML Package 329578
INT_XML_OUT2.sql 5.204 Outbound XML Package 330091
INVOICE_CUST_DUN.rep 1.18 Customer Invoice Report 329029
INVOICES.fmx 2.29 Invoices Screen 326855
INVOICES.fmx 2.31 Invoices Screen 330084
INVOICES.fmx 2.32 Invoices Screen 330236
LOCATION.fmx 2.130 Location Maintenance 329996
MSG_JOB.sql 5.8 Message job functionality 328343
MSG_JOB.sql 5.9 Message job functionality 329392
MSG_MAINT.fmx 2.26 Message Maintenance screen 328343
MSG_PROCESSING.sql 5.51 Message Processing package 325461
MSG_PROCESSING.sql 5.52 Message Processing package 329857
OF_INT.sql 5.14 Oracle Financials interface 326855
OF_INT.sql 5.16 Oracle Financials interface 330084
OF_INT.sql 5.17 Oracle Financials interface 330236
OMS.sql 5.135 Order package 328814
OMS.sql 5.136 Order package 329747
OMS.sql 5.137 Order package 329996
OMS.sql 5.138 Order package 330124
OMS.sql 5.139 Order package 330123
ORDERS.fmx 2.314 Order Screen 328952
ORDERS.fmx 2.315 Order Screen 328276
ORION.mmx 1.35 Orion Menu 330145
ORS.sql 5.8 Oracle Reporting suite 329814
POLAND_PALLET_LABEL.rep 1.4 Label Report 329242
POLAND_PALLET_LABEL.rep 1.5 Label Report 329664
POLAND_PALLET_LABEL.rep 1.6 Label Report 330073
PRODUCT.fmx 2.40 Product form to maintain Volumetric data 329145
PRODUCT.fmx 2.41 Product form to maintain Volumetric data 329374
REPORTS.fmx 2.30 Reports Screen 328336
RESOURCE.fmx 2.150 Resource Maintenance form 328613
RESOURCE.fmx 2.151 Resource Maintenance form 328117
STATIC_DATA_MAINT.fmx 1.20 Static Data Maintenance Screen 328282
TIU_TRIP_STATUS.sql 5.37 Trigger on SCH_TRIP for status change 325500
TRG_SCH_ORD_XML_INT.sql 5.16 Trigger 328761
TRG_SCH_ORD_XML_INT.sql 5.17 Trigger 329102
TRG_SOL_XML.sql 5.33 Trigger 328404
TRG_SOL_XML.sql 5.35 Trigger 329579
TRG_TRIP_NON_CONFORM.sql 1.2 Database Trigger Script 328506
TRIP.sql 5.4 Order Cleardown Package 327985
TRIP_OVERVIEW.fmx 1.51 Trip Waterfall 328276
TRIP_PLAN.fmx 1.258 Trip Planning Screen 328276
TRIP_PLAN.fmx 1.259 Trip Planning Screen 329371
TRIP_PLAN.fmx 1.260 Trip Planning Screen 330016
TRIPDTL.fmx 2.189 Trip Debrief 328761
TRIPDTL.fmx 2.191 Trip Debrief 328953
TRIPDTL.fmx 2.192 Trip Debrief 329172
TRIPDTL.fmx 2.193 Trip Debrief 328276
TRIPDTL.fmx 2.194 Trip Debrief 329385
TRIPSUM.fmx 2.402 Trip Manipulation screen 328276
TRIPSUM.fmx 2.403 Trip Manipulation screen 329371
TRIPSUM.fmx 2.405 Trip Manipulation screen 330016
TRM.sql 5.128 Trip manipulation package 328280
TRM.sql 5.129 Trip manipulation package 328276
TRM.sql 5.131 Trip manipulation package 329374
TRM.sql 5.132 Trip manipulation package 329569
TRM.sql 5.133 Trip manipulation package 329370
TRM.sql 5.135 Trip manipulation package 330384
V_TRIP_STOP.sql 1.3 Trip Stop View 328052


New Parameters

Log Number Path & Name Config Level Setting Value Result
329857 SMS_AUDITING SYSTEM Y Records will be written to the audit log for program ‘MSG_PROCESSING’ and type ‘AUDIT’ for the processing of the ‘SMS_EMAIL’ message events.
329857 SMS_AUDITING SYSTEM N No auditing will be included.
329624 GEO_NLP_URL_LOC Database http://geocoder.api.here.com/6.2/geocode.xml -
329624 GEO_NLP_URL_ROUTE Database http://route.api.here.com/routing/7.2/calculateroute.xml -
329747 TRM_RETAIN_ORD_STATUS_TRIP_COMPLETE COST CENTRE N Set to N (No) to prevent order status staying a status DELIVERED
326855 SUBMIT_CARGOWISE_HEADER SYSTEM 0 Sets the number of minutes before the header file export is sent after support documents
329374 TRM_VALIDATE_DU_TEMP COST CENTRE Y Vehicle validation will be performed at 'DU' level, not 'product' level
329579 LOTS_DEL_MSG_TRIP_STATUS_COMPLETE COST CENTRE Y Allow LOTS del messages to be sent to portal if trip is set to completed
328276 TRM_SET_OWNING_DEPOT COST_CENTRE OWNING_DEPOT, HUB_LOCATION, FIRST_RDC The priority to determine the owning depot for a trip.
325500 SEND_SMS_EMAIL Cost Centre ‘EN-ROUTE’ Status of trip for sending SMS messages.
328953 TRM_UPDATE_ALL_ACTUALS COST_CENTRE N When a line actual is debriefed all actuals are set
328814 REBOOK_COPY_SUB_REF_CONTACTS COST CENTRE Y Copy sub reference contact details when and order is rebooked
328770 DESPATCH_EMAIL SYSTEM N Controls if the system will create a Despatch email control record
327985 BUF_OLD_ORD_CLEAR_DAYS Database 30 Number of days in the past to be checked by the Buffaload order cleardown


New Access

Log Number Access Tab Name Description
328282 FUNCTIONS ADM_PLAN_REGION_UPDATE Update planning regions against locations from static data maintenance form