PATCH C-TMS 11.0 P017 071015
From Calidus HUB
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 |
| 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 | |
| 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 | |
| 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 |
