PATCH C-TMS 11.0 P021: Difference between revisions

From Calidus HUB
No edit summary
m (Text replacement - "<!-- TOC --> ↵<div class="noprint">" to "<!-- TOC --> ")
 
(29 intermediate revisions by 2 users not shown)
Line 1: Line 1:
<div class="noprint">
<div class="noprint">
{{#vardefine:Client|OBS}}
{{#vardefine:Client|CTMS}}
{{#vardefine:ClientName|OBS Logistics Ltd}}
{{#vardefine:ClientName|OBS Logistics Ltd}}
{{#vardefine:System|''CALIDUS'' C-TMS}}
{{#vardefine:System|''CALIDUS'' C-TMS}}
Line 19: Line 19:
}}
}}
<!-- TOC -->  
<!-- TOC -->  
<div class="noprint">


= SUMMARY INTRODUCTION =
= SUMMARY INTRODUCTION =
Line 83: Line 82:
-->
-->


== Customer Ref: CR-18/PO:61544552 ==
 
== Customer Ref: CR-18/PO:61544552 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 330260
|-
|'''Reporter: ''' || Ed Bond
|-
|'''Summary of Call'''|| CR-18a: Hand over to TNT and HOT
|-
|'''Detail of Fix''' || Hand over to TNT and HOT
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== Customer Ref: SCR-001 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 333089
|-
|'''Reporter: ''' || Matthew Tipping
|-
|'''Summary of Call'''|| SCR-1 - Supply & service agreement screen
|-
|'''Detail of Fix''' || New screen for entering Agreements and generating C-TMS contracts
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== Customer Ref: SCR-002 & 004 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 333090
|-
|'''Reporter: ''' || Matthew Tipping
|-
|'''Summary of Call'''|| SCR-2 & 4 - Stack audit and inv management
|-
|'''Detail of Fix''' || New forms for manually entering Stacks.
|-
|'''Set-up and Configuration''' ||
|}
 
<table border="1px" width="100%">
<tr>
<td colspan="3" bgcolor="silver"><font size="2">'''New Access'''</font></td>
</tr>
<tr>
<td bgcolor="silver"><font size="2">'''Access Tab'''</font></td>
<td bgcolor="silver"><font size="2">'''Name'''</font></td>
<td bgcolor="silver"><font size="2">'''Description'''</font></td>
</tr>
 
<tr>
<td>Function</td>
<td>ALLOW_INVENTORY_UPDATE</td>
<td>Allow inventory data to be updated</td>
</tr>
 
</table>
 
 
<table border="1px" width="100%">
<tr>
<td colspan="4" bgcolor="silver"><font size="2">'''New Parameters'''</font></td>
</tr>
<tr>
<td bgcolor="silver"><font size="2">'''Parameter Name'''</font></td>
<td bgcolor="silver"><font size="2">'''Config Level'''</font></td>
<td bgcolor="silver"><font size="2">'''Setting Value'''</font></td>
<td bgcolor="silver"><font size="2">'''Result'''</font></td>
</tr>
 
<tr>
<td>GEO_LOCATION_STACK</td>
<td>Database</td>
<td>Y</td>
<td>Turns off the new stack functionality in the location form. </td>
</tr>
 
<tr>
<td>GEO_DEFAULT_DEPOT</td>
<td>Database</td>
<td>STACK</td>
<td>Default Depot for new locations</td>
</tr>
 
<tr>
<td>GEO_DEFAULT_COUNTRY</td>
<td>Database</td>
<td>GB</td>
<td>Default Country for new locations</td>
</tr>
 
<tr>
<td>MTS_LOCATION_USAGE</td>
<td>Database</td>
<td>AGREEMENT</td>
<td>Location usage to group locations</td>
</tr>
 
<tr>
<td>GEO_MIN_INVENTORY</td>
<td>Database</td>
<td>90</td>
<td>Minimum inventory threshold to generate warning</td>
</tr>
 
<tr>
<td>GEO_MAX_INVENTORY</td>
<td>Database</td>
<td>110</td>
<td>Maximum inventory threshold to generate warning</td>
</tr>
 
<tr>
<td>GEO_KEEP_LATLONG</td>
<td>Database</td>
<td>Y</td>
<td>Keep location Lat/long when other values change</td>
</tr>
 
</table>
 
 
== Customer Ref: SCR-006 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 333091
|-
|'''Reporter: ''' || Matthew Tipping
|-
|'''Summary of Call'''|| SCR-006 Debrief - additional data & proc
|-
|'''Detail of Fix''' || Added STACK based processing to the debrief process.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== Customer Ref: SCR-13 & 14 & 16 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 333092
|-
|'''Reporter: ''' || Matthew Tipping
|-
|'''Summary of Call'''|| SCR-13,14,16 - Finance changes
|-
|'''Detail of Fix''' || Finance changes to add indexation.
|-
|'''Set-up and Configuration''' ||
|}
 
<table border="1px" width="100%">
<tr>
<td colspan="4" bgcolor="silver"><font size="2">'''New Parameters'''</font></td>
</tr>
<tr>
<td bgcolor="silver"><font size="2">'''Parameter Name'''</font></td>
<td bgcolor="silver"><font size="2">'''Config Level'''</font></td>
<td bgcolor="silver"><font size="2">'''Setting Value'''</font></td>
<td bgcolor="silver"><font size="2">'''Result'''</font></td>
</tr>
 
<tr>
<td>ACC_INDEXES</td>
<td>System</td>
<td>N</td>
<td>Controls Acc indexes being used</td>
</tr>
 
</table>
 
== Customer Ref: SCR-018 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 333095
|-
|'''Reporter: ''' || Matthew Tipping
|-
|'''Summary of Call'''|| SCR-018 - Auditing process
|-
|'''Detail of Fix''' || New import for auditing only.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== Customer Ref: SCR-003 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 334291
|-
|'''Reporter: ''' || Phil White
|-
|'''Summary of Call'''|| SCR-003 Delivery management Screen
|-
|'''Detail of Fix''' || New delivery management form to generate orders and trips from stacks.
|-
|'''Set-up and Configuration''' ||
|}
 
<table border="1px" width="100%">
<tr>
<td colspan="4" bgcolor="silver"><font size="2">'''New Parameters'''</font></td>
</tr>
<tr>
<td bgcolor="silver"><font size="2">'''Parameter Name'''</font></td>
<td bgcolor="silver"><font size="2">'''Config Level'''</font></td>
<td bgcolor="silver"><font size="2">'''Setting Value'''</font></td>
<td bgcolor="silver"><font size="2">'''Result'''</font></td>
</tr>
 
<tr>
<td>ORD_LATE_TIME</td>
<td>Database</td>
<td>20:00</td>
<td>Default time for setting late order windows for generated stack orders</td>
</tr>
 
</table>
 
<!-- NEW PAGE -->
== Customer Ref: SCR-019 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 335409
|-
|'''Reporter: ''' || Phil White
|-
|'''Summary of Call'''|| New RHA Indexation Requirement
|-
|'''Detail of Fix''' || New RHA calculations.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== Customer Ref: 335581 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 335581
|-
|'''Reporter: ''' || Michelle Naumovski
|-
|'''Summary of Call'''|| Allow any location default at collect
|-
|'''Detail of Fix''' || Add user parameter ORD_COLLECT_FROM so when an order is created the system will automatically populate the from location of the order.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== Customer Ref: 336006 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336006
|-
|'''Reporter: ''' || Hayley Keegan
|-
|'''Summary of Call'''|| Add commodity & class to order well
|-
|'''Detail of Fix''' || Added Commodities, DG and EQ from PRD_COMMODITY table to the order well on PLANNING and TRIPSUM forms, as well added rank column to PRD_COMMODITY table
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== Customer Ref: SCR-008 & SCR-009 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336148
|-
|'''Reporter: ''' || Ian Gaunt
|-
|'''Summary of Call'''|| Redirection Process & Rejections Process
|-
|'''Detail of Fix''' || A new system parameter called TRM_ALLOW_REJECTIONS will be introduced to allow trips that are not at status TENDERED to be updated to status REJECTED when the system parameter is set to Y.                                                                           
 
New menu options of Redirect Trip and Reject Trip will be available in the Planning screen when the new user functions TRM_ENABLE_REDIRECTION and TRM_ENABLE_REJECTIONS respectively are authorised for user for the user group.
|-
|'''Set-up and Configuration''' ||
|}
 
<table border="1px" width="100%">
<tr>
<td colspan="4" bgcolor="silver"><font size="2">'''New Parameters'''</font></td>
</tr>
<tr>
<td bgcolor="silver"><font size="2">'''Parameter Name'''</font></td>
<td bgcolor="silver"><font size="2">'''Config Level'''</font></td>
<td bgcolor="silver"><font size="2">'''Setting Value'''</font></td>
<td bgcolor="silver"><font size="2">'''Result'''</font></td>
</tr>
 
<tr>
<td>TRM_ALLOW_REJECTIONS</td>
<td>System</td>
<td>Y</td>
<td>Allows trip to be rejected when they are not at TENDERED status</td>
</tr>
 
<tr>
<td>TRM_ALLOW_REJECTIONS</td>
<td>SYSTEM</td>
<td>N</td>
<td>Does not allow trips to be rejected when they are not at TENDERED status</td>
</tr>
 
</table>
 
 
== Customer Ref: SCR-015 ==
{| width="100%"
{| width="100%"
|-
|width="30%"|'''OBS Log Number: 330260 '''  || '''Reporter: Ed Bond '''
|-
|-
|'''Summary of Call'''||
|width="30%"|'''OBS Log Number:'''|| 336149
CR-18a: Hand over to TNT and HOT
|-
|'''Reporter: ''' || Ian Gaunt
|-
|'''Summary of Call'''|| Storage Services finance entry
|-
|'''Detail of Fix''' || New form to maintain service contracts and charges. It will need new form SERVICE_CHARGES manually promoting to appropriate groups.  It will need the TOP_UP charge type manually creating. It will need the ACC_CALC_SERVICES system paramater chaging to 'Y'. It will need INVOICES form released under 336257 before invoice can be printed from screen.
|-
|'''Set-up and Configuration''' ||
|}
 
<table border="1px" width="100%">
<tr>
<td colspan="4" bgcolor="silver"><font size="2">'''New Parameters'''</font></td>
</tr>
<tr>
<td bgcolor="silver"><font size="2">'''Parameter Name'''</font></td>
<td bgcolor="silver"><font size="2">'''Config Level'''</font></td>
<td bgcolor="silver"><font size="2">'''Setting Value'''</font></td>
<td bgcolor="silver"><font size="2">'''Result'''</font></td>
</tr>
 
<tr>
<td>ACC_CALC_SERVICES</td>
<td>Database</td>
<td>N</td>
<td>Service charges applicable</td>
</tr>
</table>
 
 
== Customer Ref: SCR-010 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336151
|-
|'''Reporter: ''' || Ian Gaunt
|-
|'''Summary of Call'''|| Debrief - CTMS Inbound Flow
|-
|'''Detail of Fix''' || New Crane interface including Interface Errors tab for re-processing.
|-
|'''Set-up and Configuration''' ||
|}
<table border="1px" width="100%">
<tr>
<td colspan="3" bgcolor="silver"><font size="2">'''New Access'''</font></td>
</tr>
<tr>
<td bgcolor="silver"><font size="2">'''Access Tab'''</font></td>
<td bgcolor="silver"><font size="2">'''Name'''</font></td>
<td bgcolor="silver"><font size="2">'''Description'''</font></td>
</tr>
 
<tr>
<td>INT_ERR</td>
<td>DEBRIEF_ORDER</td>
<td>Inbound interface data from the crane system</td>
</tr>
 
</table>
 
 
== Customer Ref: SCR-12.1 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336152
|-
|'''Reporter: ''' || Ian Gaunt
|-
|'''Summary of Call'''|| SSS - Debrief Process
|-
|'''Detail of Fix''' || Add new fields to configurable layouts in the waterfall screen
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
<!-- NEW PAGE -->
 
== Customer Ref: SCR-13 & 14 & 16 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336257
|-
|'''Reporter: ''' || Julie Taylor
|-
|'''Summary of Call'''|| SCR-13,14,16 Invoicing Format (dev split)
|-
|'''Detail of Fix''' || Customer Invoices
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== Customer Ref: SCR-13, 14 & 16 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336377
|-
|'''Reporter: ''' || Roger Egdell
|-
|'''Summary of Call'''|| Finance Changes
|-
|-
|'''Detail of Fix''' ||
|'''Detail of Fix''' || Finance indexation changes.
Hand over to TNT and HOT
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
|}
|}


Line 101: Line 514:
{| width="100%"
{| width="100%"
|-
|-
|width="30%"|'''OBS Log Number:'''|| 333089
|width="30%"|'''OBS Log Number:'''|| 336378
|-
|-
|'''Reporter:'''|| Matthew Tipping
|'''Reporter: ''' || Ben Doft
|-
|-
|'''Summary of Call'''|| SCR-1 - Supply & service agreement scree
|'''Summary of Call'''|| Fixes to Supply Agreement screen
|-
|-
|'''Detail of Fix''' || New BWSC screen for entering Agreements and generating C-TMS contracts
|'''Detail of Fix''' || Fixes following internal testing
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== Customer Ref: 336466 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336466
|-
|'''Reporter: ''' || Michelle Naumovski
|-
|'''Summary of Call'''|| <ORS- Customer as Range>
|-
|'''Detail of Fix''' || Add delivery time and cust group to ex_ordhead and sched_ords reports
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 116: Line 544:
{| width="100%"
{| width="100%"
|-
|-
|width="30%"|'''OBS Log Number: 333089
|width="30%"|'''OBS Log Number:'''|| 336537
|-
|'''Reporter: ''' || Suzanne Woodcock
|-
|'''Summary of Call'''|| Release following internal testing
|-
|'''Detail of Fix''' || Changes to Agreement screen following internal testing
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== Customer Ref: SCR-001 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336572
|-
|'''Reporter: ''' || Matthew Tipping
|-
|'''Summary of Call'''|| Supply agreement screen cost centre seg
|-
|'''Detail of Fix''' || Various changes to the layout and toolbar for presentation. Other changes:
 
1. Saves the 'indexes' records as they are entered.
 
2. Displays the tier charges for the current contract agreement record.
 
3. The seller, buyer and operator may only be entered via the dropdown LOV for new contract agreement records.
 
4. The Operator LOV will refer to the COST_CENTRE user parameter.
 
5. The same user parameter will control which contract agreement records are displayed.
 
6. The seller, buyer and operator are stored for the contract agreement record in the database.
 
7. The first, previous, next and last records may be displayed using the appropriate buttons in the toolbar.
 
8. The Seller and Buyer dropdown lists of values will refer to the CUSTOMER and COST_CENTRE user parameters to display the customers for selection.
 
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== Customer Ref: SCR-003 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336595
|-
|'''Reporter: ''' || Phil White
|-
|'''Summary of Call'''|| Default cust ref to OMS ref
|-
|'''Detail of Fix''' || Default Customer Ref to OMS Ref when not provided on generation of orders.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== Customer Ref: 336863 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336863
|-
|'''Reporter: ''' || Michelle Naumovski
|-
|'''Summary of Call'''|| ORS - Select column order
|-
|'''Detail of Fix''' || Allow users to determine the order in which the columns are displayed.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== Customer Ref: SCR-006 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336890
|-
|'''Reporter: ''' || Matthew Tipping
|-
|'''Summary of Call'''|| SCR-006 - Rework
|-
|'''Detail of Fix''' || New fields called 'Driver', 'Carrier', 'Supplier', will be displayed in the 'Driver Debrief' tab page in the 'Trip Debrief' screen when the new system parameter called 'TRM_STACK_DEBRIEF' is set to 'Y' for the cost centre of the trip.
|-
|'''Set-up and Configuration''' ||
|}
 
<table border="1px" width="100%">
<tr>
<td colspan="4" bgcolor="silver"><font size="2">'''New Parameters'''</font></td>
</tr>
<tr>
<td bgcolor="silver"><font size="2">'''Parameter Name'''</font></td>
<td bgcolor="silver"><font size="2">'''Config Level'''</font></td>
<td bgcolor="silver"><font size="2">'''Setting Value'''</font></td>
<td bgcolor="silver"><font size="2">'''Result'''</font></td>
</tr>
 
<tr>
<td>TRM_STACK_DEBRIEF</td>
<td>COST_CENTRE</td>
<td>Y</td>
<td>New fields called 'Driver', 'Carrier', 'Supplier', 'Driver Delivery Instructions' and 'Unloading Comments' will be displayed in the 'Driver Debrief' tab page in the 'Trip Debrief' Screen.</td>
</tr>
 
<tr>
<td>TRM_STACK_DEBRIEF</td>
<td>COST_CENTRE</td>
<td>N</td>
<td>The new fields will not be displayed</td>
</tr>
 
</table>
 
 
== Customer Ref: 337123 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 337123
|-
|'''Reporter: ''' || Hayley Keegan
|-
|-
|'''|| '''Reporter: ''' || Matthew Tipping
|'''Summary of Call'''|| Order status added to payment report
|-
|-
|'''Summary of Call'''|| SCR-1 - Supply & service agreement scree
|'''Detail of Fix''' || Added order status to the payments_dtls report, the new column is after "order reference" before "transport"
|-
|-
|'''Detail of Fix''' || New BWSC screen for entering Agreements and generating C-TMS contracts
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== Customer Ref: 333896 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 333896
|-
|'''Reporter: ''' || Sue Blake
|-
|'''Summary of Call'''|| Microlise Interface (Inbound/Outbound)
|-
|'''Detail of Fix''' || New package DP_INT_XML_MIC2 to handle XML files to and from Microlise.                                                                                              Database triggers have been amended so that if MIC_SEND_DIRECT registry value set to Yes, outbound Microlise files are processed and sent directly to Microlise, using their file format, rather than the standard OBS format.
|-
|'''Set-up and Configuration''' ||
|}
 
<table border="1px" width="100%">
<tr>
<td colspan="4" bgcolor="silver"><font size="2">'''New Parameters'''</font></td>
</tr>
<tr>
<td bgcolor="silver"><font size="2">'''Parameter Name'''</font></td>
<td bgcolor="silver"><font size="2">'''Config Level'''</font></td>
<td bgcolor="silver"><font size="2">'''Setting Value'''</font></td>
<td bgcolor="silver"><font size="2">'''Result'''</font></td>
</tr>
 
<tr>
<td>MIC_SEND_DIRECT</td>
<td>NSS</td>
<td>Y</td>
<td>Flag to indicate that Direct communication to Microlise required</td>
</tr>
 
<tr>
<td>MIC_USE_STOP_ID</td>
<td></td>
<td>Y</td>
<td>Ensure stop id to get stop sequence</td>
</tr>
 
<tr>
<td>MIC_DIRECT_PATH_OUT</td>
<td>NSS</td>
<td>/webint/{DATABASE}/interface/MICD/OUT</td>
<td>Outbound FTP directory</td>
</tr>
 
<tr>
<td>MIC_DIRECT_PATH_OUT_ARCH</td>
<td></td>
<td>/webint/{DATABASE}/interface/MICD/OUT/archive</td>
<td>Outbound FTP archive directory</td>
</tr>
 
<tr>
<td>MIC_DIRECT_PATH_IN</td>
<td></td>
<td>/webint/{DATABASE}/interface/MICD/IN</td>
<td>Inbound files ‘source’ directory</td>
</tr>
 
<tr>
<td>MIC_DIRECT_PATH_IN_FAIL</td>
<td></td>
<td>/webint/{DATABASE}/interface/MICD/IN/failures</td>
<td>Inbound ‘archive’ directory</td>
</tr>
 
<tr>
<td>MIC_DIRECT_PATH_IN_ARCH</td>
<td></td>
<td>/webint/{DATABASE}/interface/MICD/IN/archive</td>
<td>Inbound ‘failure’ directory</td>
</tr>
 
<tr>
<td>MIC_DIRECT_PATH_IN_LIST</td>
<td></td>
<td>MICD_TRIP_FILES.lst</td>
<td></td>
</tr>
 
<tr>
<td>MIC_DIRECT_PATH_IN_SCRIPT</td>
<td></td>
<td>MICD_TRIP_SCRIPT.ksh</td>
<td></td>
</tr>
 
<tr>
<td>MIC_DIRECT_DEF_COST</td>
<td></td>
<td>NSS</td>
<td></td>
</tr>
 
<tr>
<td>MIC_DIRECT_PATH_IN_IDENT</td>
<td></td>
<td>PODPOC*</td>
<td>Expected file name for ‘PODPOC’ files</td>
</tr>
 
<tr>
<td>MICD_EE_PATH_IN_IDENT</td>
<td></td>
<td>EventExport*</td>
<td>Expected file name for ‘Event’ files</td>
</tr>
 
<tr>
<td>MICD_JSE_PATH_IN_IDENT</td>
<td></td>
<td>JourneySummaryExport*</td>
<td>Expected file name for ‘Journey Summary’ files</td>
</tr>
 
<tr>
<td>MIC_DIRECT_FTP_DEST_DIRECTORY</td>
<td></td>
<td>\UAT\ToMicrolise</td>
<td>Outbound destination ftp directory (ctms to Microlise)</td>
</tr>
 
<tr>
<td>MIC_DIRECT_FTP_DEST_IP_ADDRESS</td>
<td></td>
<td>mmsftp2.microlise.com</td>
<td>Outbound IP address (ctms to Microlise)</td>
</tr>
 
<tr>
<td>MIC_DIRECT_FTP_DEST_PASSWORD</td>
<td></td>
<td>nh5uat</td>
<td>Outbound IP login password (ctms to Microlise)</td>
</tr>
 
<tr>
<td>MIC_DIRECT_FTP_DEST_PORT</td>
<td></td>
<td>21</td>
<td>Outbound port (ctms to Microlise)</td>
</tr>
 
<tr>
<td>MIC_DIRECT_FTP_DEST_USERNAME</td>
<td></td>
<td>NHSSCOTLANDUAT</td>
<td>Outbound IP login username (ctms to Microlise)</td>
</tr>
</table>
 
 
== Customer Ref: SH-A8XJSG ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 334630
|-
|'''Reporter: ''' || Sarah Howells
|-
|'''Summary of Call'''|| RIO:Trigger ALC, MAR & LOA messages
|-
|'''Detail of Fix''' || Trigger ALC, MAR and LOA messages to LOTS
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== Customer Ref: SH-AARB5V ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336000
|-
|'''Reporter: ''' || Sarah Howells
|-
|'''Summary of Call'''|| RIO:Additional fields required for LOTS
|-
|'''Detail of Fix''' || Added system parameter LOTS_VERSION_NUMBER and added <ACTUAL_RPE_QTY> when LOTS_VERSION_NUMBER is 300 or over
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== Customer Ref: AR-AB5GUN ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336130
|-
|'''Reporter: ''' || Andrew Rowe
|-
|'''Summary of Call'''|| RIO:Support Barcode Scanning
|-
|'''Detail of Fix''' || Additional field add to morning failed report, AR-AB5GUN Support Barcode Scanning
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== Customer Ref: 336197 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336197
|-
|'''Reporter: ''' || Hayley
|-
|'''Summary of Call'''|| Cost Centre Segregation (4) - Carriers
|-
|'''Detail of Fix''' || Data segregation by cost centre phase 4 - Trip manipulation planning screen to show cost centre specific carriers on carrier selection on new trip, carrier change and trip filter
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== Customer Ref: SCR-336807-2 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336639
|-
|'''Reporter: ''' || DM
|-
|'''Summary of Call'''|| RIO: CTMS to MLS WMS Interface
|-
|'''Detail of Fix''' || A new EDI process will need to be setup as follows:
                                                         
Process Name: BNLMLS_PLAN_OUT                         
 
Filename Format: Planresultaat
                       
Customer: As Customer (see FS)                       
 
Cost Centre Code: As Cost Centre (see FS)             
 
Location: As Depot (see FS)                           
 
Direction: Outbound                                   
 
Flow Type: PROCESS                                   
 
Frequency Type: Interval                             
 
Interval Length: 2 Minutes
 
Delivery Folder: /webint/{DATABASE}/interface/ORDXML/{CUST}/OUT
 
Archive Folder: /webint/{DATABASE}/interface/ORDXML/{CUST}/OUT/archive
 
Failures Folder: /webint/{DATABASE}/interface/ORDXML/{CUST}/OUT/failures
 
Triggers:
STATUS: ACCEPTED
STATUS: TENDERED
 
Parameters:
DELIMITER: PIPE
ORDER_SOURCE_SYSTEM: As Source System (see FS)
 
Report Values:
Title: Package Name
Name: PROCESS
Value: DP_BNL_EDI_OUT.P_PROCESS_PLAN
Title: Process Name
Name: pi_proc_name
Value: BNLMLS_PLAN_OUT
 
The following directory structure will need to be setup:
 
/webint/{DATABASE}/interface/ORDXML/{CUST}/OUT
/webint/{DATABASE}/interface/ORDXML/{CUST}/OUT/archive
/webint/{DATABASE}/interface/ORDXML/{CUST}/OUT/failures
 
The OBS FTP Server will need to be setup to transfer the 'Plan' files from CTMS.
 
The external systems will need to be setup to receive the 'Plan' files from the OBS FTP Server.
 
A new system directory will need to be setup for the outbound EDI directory for the 'Plan' files.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
|}
|}


<!-- NEW PAGE -->
== Customer Ref: SCR-336807-1 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336655
|-
|'''Reporter: ''' || JS
|-
|'''Summary of Call'''|| RIO: MLS WMS to C-TMS Interface
|-
|'''Detail of Fix''' ||
A new EDI process will need to be setup as follows:                                                         
Process Name: BNLMLS_ORDERS                           
Filename Format: tms_sscc_CRE_*.dat                   
Customer: As Customer (see FS)                       
Cost Centre Code: As Cost Centre (see FS)             
Location: As Depot (see FS)                           
Direction: Inbound                                   
Flow Type: PROCESS                                   
Frequency Type: Interval                             
Interval Length: 2 Minutes
Delivery Folder: /webint/{DATABASE}/interface/ORDXML/{CUST}/IN
Archive Folder: /webint/{DATABASE}/interface/ORDXML/{CUST}/IN/archive
Failures Folder: /webint/{DATABASE}/interface/ORDXML/{CUST}/IN/failures
Parameters:
DEFAULT_DEL_TYPE: Standard
DEFAULT_GROUP_NAME: As Group Name (see FS)
DEFAULT_PROD_TYPE_ID: AMBIENT
DEFAULT_SRCE_SYSTEM: As Source System (see FS)
DELIMITER: |
EARLY_AVAILABLE_TIME: 0000
LATE_AVAILABLE_TIME: 1200
USE_DIMENSIONS: Y
Report Values:
Title: Package Name
Name: PROCESS
Value: DP_BNL_EDI_IN.P_PROCESS_FILES
Title: Process Name
Name: pi_proc_name
Value: BNLMLS_ORDERS
The following static data will need to be setup:
Locations: Depot, Stores and Suppliers (see FS)
Product Types: Ambient
Despatch Unit Types: For Pallet Types (see FS)
Source System: For Source System (see FS)
Delivery Types: Standard                       
Group Names: As Customer Group (see FS)
Import Decodes:
BNLDIY_LOCATIONS: As Stores and Suppliers from Source System (see FS)


BNLDIY_XDOCK:
Source Value: XD
Target Value: As Depot (see FS)           


The following tab page will need to be authorised for the appropriate user groups:


Form: Interface Errors
Tab: BNL Orders In


The following directory structure will need to be setup:


== Customer Ref: SCR-002 & 004 ==
/webint/{DATABASE}/interface/ORDXML/{CUST}/IN
{| width="100%"
 
|-
/webint/{DATABASE}/interface/ORDXML/{CUST}/IN/archive
|width="30%"|'''OBS Log Number: 333090 '''|| '''Reporter: Matthew Tipping '''
 
|-
/webint/{DATABASE}/interface/ORDXML/{CUST}/IN/failures
|'''Summary of Call'''|| SCR-2 & 4 - Stack audit and inv manageme
 
|-
The OBS FTP Server will need to be setup to transfer the 'Ship' files to CTMS.
|'''Detail of Fix''' || New forms for manually entering Stacks for BWSC only.
 
|-
The external systems will need to be setup to transfer the 'Ship' files to the OBS FTP Server.
|'''Set-up and Configuration''' || No set-up/configuration required
|-
|}
|'''Set-up and Configuration''' ||
|}
 
<table border="1px" width="100%">
<tr>
<td colspan="3" bgcolor="silver"><font size="2">'''New Access'''</font></td>
</tr>
<tr>
<td bgcolor="silver"><font size="2">'''Access Tab'''</font></td>
<td bgcolor="silver"><font size="2">'''Name'''</font></td>
<td bgcolor="silver"><font size="2">'''Description'''</font></td>
</tr>
 
<tr>
<td>BNL_ORDER_IN</td>
<td>Interface Errors/BNL Orders In</td>
<td>A new tab page for the 'BNL' orders recieved in the 'Ship' file for review and processing.</td>
</tr>
 
</table>
 
 
== Customer Ref: SCR-336807-3 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336656
|-
|'''Reporter: ''' || JS
|-
|'''Summary of Call'''|| Delivery Note Print
|-
|'''Detail of Fix''' || New Delivery Report, to be generated from the reports screen and the Planning Trip tree
|-
|'''Set-up and Configuration''' ||
|}
 
<table border="1px" width="100%">
<tr>
<td colspan="3" bgcolor="silver"><font size="2">'''New Access'''</font></td>
</tr>
<tr>
<td bgcolor="silver"><font size="2">'''Access Tab'''</font></td>
<td bgcolor="silver"><font size="2">'''Name'''</font></td>
<td bgcolor="silver"><font size="2">'''Description'''</font></td>
</tr>
 
<tr>
<td>BNL_DELIVERY</td>
<td>New Report</td>
<td>Added to Group Maintenance</td>
</tr>
 
</table>
 
 
<table border="1px" width="100%">
<tr>
<td colspan="4" bgcolor="silver"><font size="2">'''New Parameters'''</font></td>
</tr>
<tr>
<td bgcolor="silver"><font size="2">'''Parameter Name'''</font></td>
<td bgcolor="silver"><font size="2">'''Config Level'''</font></td>
<td bgcolor="silver"><font size="2">'''Setting Value'''</font></td>
<td bgcolor="silver"><font size="2">'''Result'''</font></td>
</tr>
 
<tr>
<td>DELIVERY_NOTE</td>
<td>COST CENTRE</td>
<td>BNL_DELIVERY</td>
<td>Name of Delivery report to be generated from trip tree in the planning screen</td>
</tr>
 
</table>


<!-- NEW PAGE -->  
<!-- NEW PAGE -->  


== Customer Ref: CR-18/PO:61544552 ==
== Customer Ref: SCR-336807-5 ==
"{| width=""100%"""
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336657
|-
|'''Reporter: ''' || JS
|-
|'''Summary of Call'''|| Loading Meters
|-
|'''Detail of Fix''' || The configurable layouts for the order items data block in the Order Details screen will be changed to include 3 extra columns for the length, width and height.                                                                                                     
 
A new system parameter called ORD_EDIT_RPE will be available to configure by cost centre to allow the RPE quantity of the order lines in the Order Details screen to be edited.
 
A new system parameter called ORD_RPE_LM_FACTOR will be available to configure by cost centre to set a loading meter factor to calculate the RPE quantity of the order lines based on the dimensions of the DU types of the order items in preference to the RPE quantity of the DU types themselves (which should be set based on the loading meter factor).
 
The RPE quantity, weight and volume of the order lines will be based on the order items with reference to the system parameters for the manual order entry and maintenance and the processing of the EDI Ship file that provides the parent and child items for the orders.
 
See the functional specification for further information about the setup in CTMS and the OBS FTP Server.
|-
|'''Set-up and Configuration''' ||
|}
 
<table border="1px" width="100%">
<tr>
<td colspan="4" bgcolor="silver"><font size="2">'''New Parameters'''</font></td>
</tr>
<tr>
<td bgcolor="silver"><font size="2">'''Parameter Name'''</font></td>
<td bgcolor="silver"><font size="2">'''Config Level'''</font></td>
<td bgcolor="silver"><font size="2">'''Setting Value'''</font></td>
<td bgcolor="silver"><font size="2">'''Result'''</font></td>
</tr>
 
<tr>
<td>ORD_EDIT_RPE</td>
<td>COST_CENTRE</td>
<td>Y</td>
<td>The RPE column in the Order Details screen can be edited for the order lines.</td>
</tr>
 
<tr>
<td>ORD_EDIT_RPE</td>
<td>COST_CENTRE</td>
<td>N</td>
<td>The RPE column in the Order Details screen cannot be edited for the order lines.</td>
</tr>
 
<tr>
<td>ORD_RPE_LM_FACTOR</td>
<td>COST_CENTRE</td>
<td>2.4</td>
<td>The loading meter factor will be used to calculated the RPE of the order item for the length and width of the item should the dimensions of the item differ to the dimensions of the DU type of the item, if the dimensions do not differ then the RPE of the DU type will apply as at present.</td>
</tr>
 
<tr>
<td>ORD_RPE_LM_FACTOR</td>
<td>COST_CENTRE</td>
<td>NULL</td>
<td>The RPE of the DU type of the order item will apply as at present.</td>
</tr>
 
</table>
 
 
== Customer Ref: SCR-336807-4 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336963
|-
|'''Reporter: ''' || Dave Meir
|-
|'''Summary of Call'''|| CMR Print - pdf
|-
|'''Detail of Fix''' || New CMR report to be run from Trip Planning screen for a single trip
|-
|'''Set-up and Configuration''' ||
|}
 
<table border="1px" width="100%">
<tr>
<td colspan="3" bgcolor="silver"><font size="2">'''New Access'''</font></td>
</tr>
<tr>
<td bgcolor="silver"><font size="2">'''Access Tab'''</font></td>
<td bgcolor="silver"><font size="2">'''Name'''</font></td>
<td bgcolor="silver"><font size="2">'''Description'''</font></td>
</tr>
 
<tr>
<td>CMR_NL</td>
<td>New Report</td>
<td>Added to group Maintenance</td>
</tr>
 
</table>
 
 
<table border="1px" width="100%">
<tr>
<td colspan="4" bgcolor="silver"><font size="2">'''New Parameters'''</font></td>
</tr>
<tr>
<td bgcolor="silver"><font size="2">'''Parameter Name'''</font></td>
<td bgcolor="silver"><font size="2">'''Config Level'''</font></td>
 
<td bgcolor="silver"><font size="2">'''Setting Value'''</font></td>
<td bgcolor="silver"><font size="2">'''Result'''</font></td>
</tr>
 
<tr>
<td>CMR_NOTE</td>
<td>COST CENTRE</td>
<td>CMR_NL</td>
<td>Name of Delivery report to be generated from trip tree in the planning screen</td>
</tr>
 
</table>
 
 
== Customer Ref: SCR-002 & 004 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336770
|-
|'''Reporter: ''' || Rob Merrill
|-
|'''Summary of Call'''|| Log for release of internal testing issue
|-
|'''Detail of Fix''' || Changes to Threshold calculation and call-off-month.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== Customer Ref: SCR-13,14,16 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 337543
|-
|'''Reporter: ''' || Ben Doft
|-
|'''Summary of Call'''|| Finance fixes coming from OBS testing
|-
|'''Detail of Fix''' || Changes to the RPI application and calculation to improve accuracy, fix for ABOVE_DISTANCE application, invoice requirements creation
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== Customer Ref: SCR-001 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336956
|-
|'''Reporter: ''' || Ben Doft
|-
|'''Summary of Call'''|| SCR-001 - Testing Issues
|-
|'''Detail of Fix''' || Various changes to the screen:
 
1. Includes cost centre segregation for the Find functionality.
 
2. The 'x' button can be used to close windows that are called.
 
3. The red field background will be converted to grey and vice versa when the total weight is changed and assessed.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== Customer Ref: CR-18 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 335812
|-
|'''Reporter: ''' || Tina Kinsella
|-
|'''Summary of Call'''|| CR18a: Additional Changes
|-
|'''Detail of Fix''' || Fix for auto debrief on HOT and TNT
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== Customer Ref: CR-16 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 335931
|-
|'''Reporter: ''' || Paul Jones
|-
|-
|width="30%"|'''OBS Log Number: " 330260 '''|| '''Reporter: Ed Bond'''
|'''Summary of Call'''|| CR-16 special characters
|-
|-
|'''Summary of Call'''|| CR-18a: Hand over to TNT and HOT
|'''Detail of Fix''' || Use driveruid rather than driverno for kpi query.
|-
|-
|'''Detail of Fix''' || Hand over to TNT and HOT
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
|}
|}


== Customer Ref: SCR-001 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336459
|-
|'''Reporter: ''' || Suzanne Woodcock
|-
|'''Summary of Call'''|| Release of agreements screen
|-
|'''Detail of Fix''' || Format and Functional amendments to the Agreement screen to allow release excluding the Finance log
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}




Line 174: Line 1,343:
|}
|}
-->
-->
== Customer Ref:  ==
 
== Customer Ref: DF036 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 334029
|-
|'''Reporter: ''' || Emily Collins
|-
|'''Summary of Call'''|| Paragon - reset new audit
|-
|'''Detail of Fix''' || Created PAR_RESET_AUDIT table, SEQ_PAR_RESET_AUDIT sequence and modified PAR_INT form to store export parameters, user and date when reset new button is pressed.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== Customer Ref: 334812 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 334812
|-
|'''Reporter: ''' || Julie Scott
|-
|'''Summary of Call'''|| Re-book Functionality
|-
|'''Detail of Fix''' || Alternate rebook functionality.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== Customer Ref: INC13787271 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 335391
|-
|'''Reporter: ''' || KELLY HEMBLING
|-
|'''Summary of Call'''|| Scheduling orders
|-
|'''Detail of Fix''' || If business type planning is active, the trip will only be created if the payment can be created if there is not a missing charge condition, for example.                                                             
 
If business type planning is not active, the trip will be created if it is not being debriefed and there is not a missing chargeable condition, for example.                                                             
 
If the missing chargeable condition is a TRACTOR or a TRAILER TYPE, the audit message will include the text:
 
'a CHARGE does not include the TRACTOR,' or 'a CHARGE does not include the TRAILER TYPE,'.
 
The audit message will apply to the charges for the orders and the trips but it will only be displayed once if a total cost cannot be obtained.
 
If there are multiple charges that are available for the parties, each individual charge will not be listed to ensure that the error message can be displayed on screen.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== Customer Ref: 335395 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 335395
|-
|'''Reporter: ''' || Julie Scott
|-
|'''Summary of Call'''|| Phase 3 - Cost Centre Segregation
|-
|'''Detail of Fix''' || Data segregation by cost centre phase 3 - business data maintenance (group names, location zones, time zones), resources (trailers), account maintenance (currency codes) and system configuration (Printers)
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== Customer Ref: 335421 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 335421
|-
|'''Reporter: ''' || Zina Fahd
|-
|'''Summary of Call'''|| Automated Manifest at End of day
|-
|'''Detail of Fix''' || Allow sysdate in ORS report
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== Customer Ref: 335422 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 335422
|-
|'''Reporter: ''' || Zina Fahd
|-
|'''Summary of Call'''|| Add suburb and post code to Trip Summary
|-
|'''Detail of Fix''' || The database scripts will update the existing ORS formats to extract the extra columns in the following report types:
 
1.      DEL_TRIPS                                   
 
2.      ORDLN_TYPE                                   
 
3.      SCHED_ORDS                                   
 
4.      STOPS                                         
 
5.      EX_ORDHEAD                                   
 
6.      EX_TRPSTOP                                   
 
7.      ORDER_ITEM
 
8.      ORD_TYPE                                     
 
9.      EX_ORDITEM                                                                               
 
The database scripts will only be effective in specific databases.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== Customer Ref: 335560 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 335560
|-
|'''Reporter: ''' || MICHELLE NAUMOVSKI
|-
|'''Summary of Call'''|| Showing CUST CLIENT CODES and shouldn't
|-
|'''Detail of Fix''' || 1) Show correct LOV options for customer client code relevant to the customer on the order.                                                                       
 
2) When customer is changed refresh the population of the from location LOV.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== Customer Ref: 335576 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 335576
|-
|'''Reporter: ''' || Michelle Naumovski
|-
|'''Summary of Call'''|| Portal events out of sequence
|-
|'''Detail of Fix''' || If the new system parameter called 'LOTS_PREVENT_MULTI_VLI_VUI' is set to 'Y' then the 'VLI' and 'VUI' files for LOTS/Portal will only be re-sent for an order on a trip should either of the actual arrival or actual departure times be set for the first time for the trip stop.                                                                            A file can be sent twice for the same order on the same trip but only of the actual times are set separately.
If the new system parameter does not exist or it is set to 'N' then multiple files will be generated whenever the actual arrival or actual departure time is updated for the trip stop.
|-
|'''Set-up and Configuration''' ||
|}
 
<table border="1px" width="100%">
<tr>
<td colspan="4" bgcolor="silver"><font size="2">'''New Parameters'''</font></td>
</tr>
<tr>
<td bgcolor="silver"><font size="2">'''Parameter Name'''</font></td>
<td bgcolor="silver"><font size="2">'''Config Level'''</font></td>
<td bgcolor="silver"><font size="2">'''Setting Value'''</font></td>
<td bgcolor="silver"><font size="2">'''Result'''</font></td>
</tr>
 
<tr>
<td>LOTS_PREVENT_MULTI_VLI_VUI</td>
<td>SYSTEM</td>
<td>Y</td>
<td>The 'VLI' and 'VUI' files for LOTS/Portal will only be re-sent for an order on a trip should either of the actual arrival or actual departure times be set for the first time for the trip stop.  A file can be sent twice for the same order on the same trip but only of the actual times are set separately.
</td>
</tr>
 
<tr>
<td>LOTS_PREVENT_MULTI_VLI_VUI</td>
<td>SYSTEM</td>
<td>N</td>
<td>Multiple files will be generated whenever the actual arrival or actual departure time is updated for the trip stop.</td>
</tr>
 
</table>
 
== Customer Ref: 335694 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 335694
|-
|'''Reporter: ''' || Peter Blackburn
|-
|'''Summary of Call'''|| Clear from/to locn on new customer
|-
|'''Detail of Fix''' || For environments with locations related to selected customer, the LOV for from/to location is updated when a new customer is entered. Amendment will also clear existing locations from the order if the customer is updated.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== Customer Ref: 335799 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 335799
|-
|'''Reporter: ''' || Peter Blackburn
|-
|'''Summary of Call'''|| Default Order From Location
|-
|'''Detail of Fix''' || Select order collect from user param from location id instead of name. Set up order entry deliver to location LOV if using defaulted collect from location id.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== Customer Ref: 335421 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 335825
|-
|'''Reporter: ''' || Paul Jones
|-
|'''Summary of Call'''|| Automated Manifest at end of day (rwk)
|-
|'''Detail of Fix''' || Reset sysdate parameters
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
   
 
== Customer Ref: 335903 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 335903
|-
|'''Reporter: ''' || Hayley Keegan
|-
|'''Summary of Call'''|| OOH: Issue entering orders
|-
|'''Detail of Fix''' || Issue with order entry and the delivery location being blanked out, identified cause and applied fix
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== Customer Ref: 335913 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 335913
|-
|'''Reporter: ''' || Michelle Naumovski
|-
|'''Summary of Call'''|| Segregate NZ & AUS trips while x docking
|-
|'''Detail of Fix''' || Amendment to Trip screen to remove the debug message and segregate the trips a user may select at cross dock
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== Customer Ref: 335924 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 335924
|-
|'''Reporter: ''' || Peter Blackburn
|-
|'''Summary of Call'''|| Phase 4 - Cost Centre Segregation
|-
|'''Detail of Fix''' || Amendment for cost centre segregation to location maintenance form so LOV for suburb and post_code is limited to the appropriate country.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== Customer Ref:  336145 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336145
|-
|'''Reporter: ''' || Hayley Keegan
|-
|'''Summary of Call'''|| Add cost centre to Invoicing report (ORS)
|-
|'''Detail of Fix''' || Segregate by cost centre
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== Customer Ref: 336158 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336158
|-
|'''Reporter: ''' || Hayley Keegan
|-
|'''Summary of Call'''|| Ensure Tailgate charges are generated
|-
|'''Detail of Fix''' || NVL tailgate flag to N on services trigger
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== Customer Ref: 336296 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336296
|-
|'''Reporter: ''' || Dave Meir
|-
|'''Summary of Call'''|| Prevent all unscheduled orders in well
|-
|'''Detail of Fix''' || A Sched From date must be present to select the unscheduled orders for the order well to ensure that the data is queried quickly.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== Customer Ref: 336374 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336374
|-
|'''Reporter: ''' || Peter Blackburn
|-
|'''Summary of Call'''|| Trip Planning screen order well handling
|-
|'''Detail of Fix''' || Amendment to trip planning options (TRIPSUM/PLANNING) so that when the user drops into the orders form to view/change and order, return to the trip screen focuses back on the correct order in the well.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== Customer Ref: 336552 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336552
|-
|'''Reporter: ''' || Julie Scott
|-
|'''Summary of Call'''|| Supporting Docs fail to ftp
|-
|'''Detail of Fix''' || Fix parameters on FTP call for Supporting documents.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== Customer Ref: 336580 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336580
|-
|'''Reporter: ''' || Michelle Naumovski
|-
|'''Summary of Call'''|| Pick Qty not mandatory for Portal orders
|-
|'''Detail of Fix''' || For portal orders, do not validate pick qty in fast order entry mode.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== Customer Ref: 336671 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336671
|-
|'''Reporter: ''' || Michelle Naumovski
|-
|'''Summary of Call'''|| Cost centre segregation - Location screen
|-
|'''Detail of Fix''' || Cost Centre Segregation - amendment to location maintenance screen so users can only see locations applicable to their user parameter cost centre
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== Customer Ref: ITINC0049954 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336677
|-
|'''Reporter: ''' || James Hutton
|-
|'''Summary of Call'''|| Barcodes are being deleted
|-
|'''Detail of Fix''' || Allow pulse orders to be amended after order issued, retain T2A information if order issued multiple times.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== Customer Ref:  Tailgate WGlove ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336679
|-
|'''Reporter: ''' || Hayley Keegan
|-
|'''Summary of Call'''|| Tailgate charges missing on Portal WG
|-
|'''Detail of Fix''' || Identified issue for portal orders, trigger only firing on UPDATE and not INSERT
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== Customer Ref: 336810 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336810
|-
|'''Reporter: ''' || Michelle Naumovski
|-
|'''Summary of Call'''|| Include hours on Tailgate charge
|-
|'''Detail of Fix''' || Tailgate charges calculated based on the number of hours entered.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== Customer Ref: 336924 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336924
|-
|'''Reporter: ''' || Matthew Tipping
|-
|'''Summary of Call'''|| Copy orders not working
|-
|'''Detail of Fix''' || Fixed entering time duplicate_order screen causing crash.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== Customer Ref: INC14665794 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336970
|-
|'''Reporter: ''' || Brett Court
|-
|'''Summary of Call'''|| Master & Child Issue
|-
|'''Detail of Fix''' || Restrict LOV to master locations if system parameter set.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== Customer Ref: Microlise Event ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 336976
|-
|'''Reporter: ''' || D. Meir
|-
|'''Summary of Call'''|| Microlise Events files - failed by C-TMS
|-
|'''Detail of Fix''' || New system parameter MIC_DIRECT_UPDATE_PRIORITY to control the population of actual arrival and delivery dates.                                                                                                       
 
Use new fields journeyDropRef to get stop sequence, and latitude and longitude to populate arrival and departure long and lat.
|-
|'''Set-up and Configuration''' ||
|}
<table border="1px" width="100%">
<tr>
<td colspan="4" bgcolor="silver"><font size="2">'''New Parameters'''</font></td>
</tr>
<tr>
<td bgcolor="silver"><font size="2">'''Parameter Name'''</font></td>
<td bgcolor="silver"><font size="2">'''Config Level'''</font></td>
<td bgcolor="silver"><font size="2">'''Setting Value'''</font></td>
<td bgcolor="silver"><font size="2">'''Result'''</font></td>
</tr>
 
<tr>
<td>MIC_DIRECT_UPDATE_PRIORITY</td>
<td>NSS</td>
<td>MEP</td>
<td>Indicates priority of population of Actual Deliver and Arrival.
 
M - Manual
E - EventExport
P - PODPOC
 
So using this order, if date populated by PODPOC message, and an EventExport message recieved with different date, the date will be over written.
 
However, if the date was keyed in manually, it will not be overwritten</td>
</tr>
 
</table>
 
 
== Customer Ref: INC14705705 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 337038
|-
|'''Reporter: ''' || Brett Court
|-
|'''Summary of Call'''|| Unauthorised Location Update
|-
|'''Detail of Fix''' || Is user changes content of a Master Location, prevent close/next record etc. whilst records has been changed. User must toggle the master location to enable the save button or cancel the change.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== Customer Ref: 337100 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 337100
|-
|'''Reporter: ''' || Michelle
|-
|'''Summary of Call'''|| OOH cannot create orders
|-
|'''Detail of Fix''' || Amendment to services update for DG order lines, if order has more than one dangerous goods order line.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== Customer Ref: INC14748025 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 337133
|-
|'''Reporter: ''' || Marta Iglik
|-
|'''Summary of Call'''|| Unable to extract the report
|-
|'''Detail of Fix''' || The number of assets on the system is too great for the drop down list. This has been changed to a lookup selection instead.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== Customer Ref: 337152 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 337152
|-
|'''Reporter: ''' || Graham Rothwell
|-
|'''Summary of Call'''|| Portal/C-TMS error
|-
|'''Detail of Fix''' || Always get schedule from trip for LOTS messages
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== Customer Ref: 337170 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 337170
|-
|'''Reporter: ''' || Dave Meir
|-
|'''Summary of Call'''|| Planning Screen - Freetext Resource
|-
|'''Detail of Fix''' || New trip sheet using schedule
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== Customer Ref: 337184 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 337184
|-
|'''Reporter: ''' || Michelle Naumovski
|-
|'''Summary of Call'''|| Incorrect To Route and Scheduling
|-
|'''Detail of Fix''' || Ensure correct radial / suburb are applied to new locations.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== Customer Ref: INC14737834 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 337205
|-
|'''Reporter: ''' || Suzie Maskery
|-
|'''Summary of Call'''|| Unable to load scan at delivery point
|-
|'''Detail of Fix''' || Increased size of store_array_no from 100 to 200, increased size of store_array_name from 200 to 480 in C-TMS and WCS interface message 442, along with  t_store_no_out was increased with corresponding substring and rpad sizes.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== Customer Ref: INC14786002 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 337209
|-
|'''Reporter: ''' || Damian Tobjasz
|-
|'''Summary of Call'''|| Trip Manipulation slow response
|-
|'''Detail of Fix''' || A Sched From date must be present to select the unscheduled orders for the order well to ensure that the data is queried quickly.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== Customer Ref: 337348 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 337348
|-
|'''Reporter: ''' || HAYLEY KEEGAN
|-
|'''Summary of Call'''|| OOH error setting trip to accepted
|-
|'''Detail of Fix''' || Amendment to process called when order total dry ice is changed and the order services are updated - either as a new service record or an update to an existing one.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== Customer Ref: 337350 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 337350
|-
|'''Reporter: ''' || Michelle Naumovski
|-
|'''Summary of Call'''|| OOH SYD DAILY P/U Scheduling Query
|-
|'''Detail of Fix''' || The scheduling engine has been changed to handle exceptional errors that invalidate the savepoints and thus do not rollback the data for orders that have been partially scheduled.
The orders will then not be at SCHED_COLL status.
The audit records will indicate that the order has been unsuccessfully scheduled.
If an order is partially scheduled and it cannot be rolled back successfully, the order will remain at status SCHED_COLL but an appropriate audit record will be created for reference.
The exceptional error is being triggered by a process external to the scheduling engine so the scheduling engine has been changed to account for such failures to ensure that the orders are reset if possible.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== Customer Ref: 337352 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 337352
|-
|'''Reporter: ''' || Michelle Naumovski
|-
|'''Summary of Call'''|| Unscheduled order still appearing in MCS
|-
|'''Detail of Fix''' || Amendment to process called when order total gel packs is changed so when updating the order services the WETICE record is inserted or updates an existing one for the order.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== Customer Ref: 337353 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 337353
|-
|'''Reporter: ''' || Michelle Naumovski
|-
|'''Summary of Call'''|| Query: MTS_OWNER.PK_ORDER_ITEMS_REASON
|-
|'''Detail of Fix''' || Amendment to the scanning package to remove the check on drop sequence when adding a package to a pallet and removing the package from the trip.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
<!-- NEW PAGE -->
 
== Customer Ref: 337375 ==
{| width="100%"
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''  || '''Reporter:'''
|-
|-
|'''Summary of Call'''||  
|width="30%"|'''OBS Log Number:'''|| 337375
|-
|'''Reporter: ''' || Paul Jones
|-
|'''Summary of Call'''|| Error messages in Planning & Waterfall
|-
|-
|'''Detail of Fix''' ||
|'''Detail of Fix''' || Issues with Planning form when configured for specific customer. Also changes to Location for inventory creation. Additionally get Delivery form working for Store to Plant.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
|}
|}


== Customer Ref: 337393 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 337393
|-
|'''Reporter: ''' || Peter Blackburn
|-
|'''Summary of Call'''|| Log to Release SCHED_RULES form
|-
|'''Detail of Fix''' || Correction to Cost Centre Segregation on the schedule rules form for data query build for combinations of system parameter and users own customer and cost centre parameters.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
== Customer Ref: BEN-TRAIN02 ==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''|| 337446
|-
|'''Reporter: ''' || Dave Meir
|-
|'''Summary of Call'''|| Trip Sheet
|-
|'''Detail of Fix''' || New Trip sheet TRIP_SHEET_BNL
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}




Line 202: Line 2,084:
|}
|}
-->
-->
== OBS Log Number:  ==
 
== OBS Log Number: 335403 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Kelly Hembling
|-
|'''Summary of Call'''|| Report running slow
|-
|'''Detail of Fix''' || The NR Finance extract has been changed to query the data by trip and then by order to increase the rate of production when including debriefed trips and non-debriefed trips.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== OBS Log Number: 335407 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Kelly Hembling
|-
|'''Summary of Call'''|| NR Finance Extract
|-
|'''Detail of Fix''' || The Total Revenue, Total Revenue Excluding Fuel and Margin columns for the NR Finance and Invoice extracts (except Margin is not displayed for the Invoice extract) will include the revenue override amount from the order charge and the matrix rate for the trip revenue columns.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== OBS Log Number: 335495 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Terry Mann
|-
|'''Summary of Call'''|| No error message when creating duplicate
|-
|'''Detail of Fix''' || The following tab pages in the Resource Maintenance screen have been changed to prevent any duplicate records being entered:                                                                                       
 
Carriers                                             
 
Carrier Groups                                       
 
Carrier Types                                         
 
Carrier Service Level                                 
 
Fixed Charges                                         
 
Service Types                                         
 
Trailer Types (in combination with temp/group)
 
Loc Prd Conv                                         
 
Despatch Unit Types                                   
 
Standardised DUs                                     
 
RPEs                                                                                                         
 
The DU Type field for the Despatch Unit Types cannot be edited so that it can be changed.                                                                         
 
The Standardised DUs will be saved upon entry, change or deletion automatically.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== OBS Log Number: 335656 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Suzie Maskery
|-
|'''Summary of Call'''|| Unload claim scan not sent
|-
|'''Detail of Fix''' || Find latest return order based upon the provided asset id and assume this is the order being unload scanned.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== OBS Log Number: 335682 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Terry Mann
|-
|'''Summary of Call'''|| Identifier reference stripping
|-
|'''Detail of Fix''' || The file to Microlise will only remove a suffix from the item identifiers if the format is '-NNNN' with numbers between '0001' and '9999'.                                                                           
The file from Microlise will not remove any characters from and item identifier should a hyphen be detected based on the assumption that an asset being scanned will not provide a suffix.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
<!-- NEW PAGE -->
 
== OBS Log Number: 335692 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Terry Mann
|-
|'''Summary of Call'''|| Actual despatched not populating
|-
|'''Detail of Fix''' || To Be Confirmed:                                                                                             
 
Changes are expected to be made for the interface between Microlise and Link to assess hyphens differently for some XML items.                                                                              The asset codes will be assessed differently during WCS scanning for loading and unloading, Microlise files and Trip Debrief.                                                                                      The OBS suffix for assets will be removed if the format ends in '-NNNN' where 'NNNN' is between '0001' and '9999'.                                                                                                  The data will be retained should hyphens be used in the item identifier codes as loose items or reusable assets except that the OBS suffix will be removed for asset processing and scanning.                                                                               
The actual despatched quantities of the order lines and items will be set to 1 from the order items file and any unscanned order lines and items will only be set to 0 if the order line has a NULL quantity.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== OBS Log Number: 335851 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Suzie Maskery
|-
|'''Summary of Call'''|| The delivery order file has failed
|-
|'''Detail of Fix''' || The sequence number and the asset details and history will be created for new child assets.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== OBS Log Number: 335932 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Sarah Howells
|-
|'''Summary of Call'''|| LOTS displaying incorrect item code
|-
|'''Detail of Fix''' || Send alternate item id to LOTS
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== OBS Log Number: 335935 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Paul Roscoe
|-
|'''Summary of Call'''|| Check digit updates / Microlise updates
|-
|'''Detail of Fix''' || The 804 messages will add the check digit if the full barcode with the check digit has not been scanned because the keyed item code will not include the check digit.                                                                                                       
A space check digit will be assessed as a space for an existing item on the order but it will only be added to the item should the MODULO_43 decoded values not include NULL for a SPACE.                                                                                   
The outbound files to Microlise will add a space check digit to the item if it has not been stored in C-TMS and WCS.
The inbound files from Microlise will update the to deliver and delivered quantities for the items on the order if the item has a pallet but the pallet has not been provided by Microlise.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== OBS Log Number: 336061 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Susy Maskery
|-
|'''Summary of Call'''|| Claims file not creating
|-
|'''Detail of Fix''' || Remove status check for unscheduled orders
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== OBS Log Number: 336078 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Suzie Maskery
|-
|'''Summary of Call'''|| Order not updating correctly
|-
|'''Detail of Fix''' || Add parent item to configurable layout, ensure claims records created if parent item has no content.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== OBS Log Number: 336117 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Hayley Keegan
|-
|'''Summary of Call'''|| ORS_SYSDATE - Report does not work
|-
|'''Detail of Fix''' || The date ranges can be entered using offsets and validation will be performed on the calculated dates.                                                        The ORS file can be produced via the screen or via an EDI process via an email.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== OBS Log Number: 336157 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Hayley Keegan
|-
|'''Summary of Call'''|| ORS_DELIMITER Must be a pipe character
|-
|'''Detail of Fix''' || The system parameter ORS_DELIMITER will be used as the separator of the values in the ORS extract files whether they be generated via the ORS maintenance screen or via an EDI process.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== OBS Log Number: 336177 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Ben Doft
|-
|'''Summary of Call'''|| CR18-T2A Removing an item
|-
|'''Detail of Fix''' || Not updating last reason code in items string
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== OBS Log Number: 336181 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Suzie Maskery
|-
|'''Summary of Call'''|| Claims files not producing
|-
|'''Detail of Fix''' || Claims file not produced when parent id has no suffix
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== OBS Log Number: 336261==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Paul Roscoe
|-
|'''Summary of Call'''|| Include pack description for item
|-
|'''Detail of Fix''' || The item description will include the pack description as well as the shipment and delivery numbers from the order item files via the EDI interface.                                                                     
If a pack description is not mapped for the AKA code of the item, the pack description will not be present in the item description.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== OBS Log Number: 336289 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Roger Egdell
|-
|'''Summary of Call'''|| CR18-T2A despatch
|-
|'''Detail of Fix''' || Change to T2A to list despatched qty correctly after despatch.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== OBS Log Number: 336298 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''|| CR-22-CL stop
|-
|'''Reporter: ''' || Paul Jones
|-
|'''Summary of Call'''|| CR-22: Depart time on the CL stop
|-
|'''Detail of Fix''' || Changes to geo-fence processing at SU and CL in case geo-fence is not broken as vehicle starts or stays within depot area.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== OBS Log Number: 336299 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Sarah Howells
|-
|'''Summary of Call'''|| Trip Planning - Create New Trip
|-
|'''Detail of Fix''' || Retain carrier selected for trips in the Trip Planning Screen.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== OBS Log Number: 336319 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Sarah Howells
|-
|'''Summary of Call'''|| Interface Errors screen - date/time
|-
|'''Detail of Fix''' || The Interface Errors screen will pre-populate the Start and End dates and times for the previous 24 hours for the XML Trip and XML Outbound tab pages when they are opened as per the XML Orders tab page, for example.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== OBS Log Number: 336323 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Damian Jackson
|-
|'''Summary of Call'''|| Trip Planning screen handling
|-
|'''Detail of Fix''' || Amendment to trip planning screen so when mouse clicking on an unscheduled order in the well the focus is kept on the selected order, at the same point in the list.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== OBS Log Number: 336331 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Kate Hunter
|-
|'''Summary of Call'''|| Driver Scanning Report query changes
|-
|'''Detail of Fix''' || The queries for the Driver Scanning file have been change to increase the rate of production.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== OBS Log Number: 336412 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Dave Meir
|-
|'''Summary of Call'''|| Add Trailer type to outbound message
|-
|'''Detail of Fix''' || Add trailer type segment to outbound message.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== OBS Log Number: 336457 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Denis Starodubov
|-
|'''Summary of Call'''|| Unpacked order email notification
|-
|'''Detail of Fix''' || Increase size of field to prevent failures when sending multiple emails
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== OBS Log Number: 336487 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Paul Jones
|-
|'''Summary of Call'''|| CR18-cTMS Signature etc
|-
|'''Detail of Fix''' || Hostiptal Own Transport signature display
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== OBS Log Number: 336513 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Dave Meir
|-
|'''Summary of Call'''|| Use stop id to populate journeydropref
|-
|'''Detail of Fix''' || Archive inbound files correctly so duplicate file error removed
 
Use stop id rather than stop no to populate 'journeydropref' in outbound message.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== OBS Log Number: 336524 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Dave Meir
|-
|'''Summary of Call'''|| Use journeydropref to get stop id
|-
|'''Detail of Fix''' || Amend the inbound PODPOC message to get stop no using the stop id, which is stored in the 'journeydropref' field.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== OBS Log Number: 336557 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Denis Starodubov
|-
|'''Summary of Call'''|| LOAD message to Unison
|-
|'''Detail of Fix''' || The trip file will be generated at the specified status (e.g. TENDERED for a LOAD message) for the EDI process parameter.                                                                                           
The file will include the orders on the trip that satisfy the EDI fields and parameters (e.g. customer, location, ORDER_SOURCE_SYSTEM).                                                                              The file will be regenerated if the planned times at the loading location are changed when the trip is at the specified status.
The file will also be regenerated when appropriate orders are added to the trip at the specified status.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== OBS Log Number: 336568 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Dave Potter
|-
|'''Summary of Call'''|| Fix seq bug in 336524
|-
|'''Detail of Fix''' || Fix issue where trip has legs added by the addition of collection legs. Ensure that the the 2nd, 3rd, 4th etc collection legs are added to the trip.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== OBS Log Number: 336591 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Dave Meir
|-
|'''Summary of Call'''|| Amend journeysitenote in outb microlise
|-
|'''Detail of Fix''' || Amend the calculation of the 'journeySiteNote'.                                                             
 
Modify the logic so that for the SU stop 1, the journey site note is populated from the Trip General Comments. If there are no records then don't generate the tag for the SU stop 1. Remove the hard-code 'ORDERS:' that is not needed.
 
For each successive site visit (stop in C-TMS) include the special instructions for the order or orders on the stop.  Again remove any CRLF and replace with space, deal with special characters like & and £.  If more than one order on the stop then concatenate the special instructions and separate with a space. Leave out the tag altogether if no special instructions on the order. Remove the hard-code 'ORDERS:' that is not needed.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
   
 
== OBS Log Number: 336616 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Dave Potter
|-
|'''Summary of Call'''|| Fix bug with 336591
|-
|'''Detail of Fix''' || Ensure that 'journeySiteNote' are correctly displayed in outbound file.                                                                                            Ensure that stop_seq is correctly populated.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== OBS Log Number: 336643 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Emily Collins
|-
|'''Summary of Call'''|| Don't gen files if ftp connection failed.
|-
|'''Detail of Fix''' || Ensure outbound JourneyScheduleImport files are not created if the system can not connect to outbound ftp.                                                        Also for outbound messages, only write <resource> record for trailer id if it is different from tractor id. This will stop Microlise rejecting the file for containing duplicate tags.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== OBS Log Number: 336673 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || N Robinson
|-
|'''Summary of Call'''|| No routes found in step 4
|-
|'''Detail of Fix''' || Find fixed routes for deliveries at the depot.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== OBS Log Number: 336676 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Dave Meir
|-
|'''Summary of Call'''|| Dont report blank trailer ID's
|-
|'''Detail of Fix''' || Change package so outbound JourneyScheduleImport file doesnt create a <resource> segment for trailer id when they are blank.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== OBS Log Number: 337117 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''|| SCR-018 rework
|-
|'''Reporter: ''' || Rob Merrill
|-
|'''Summary of Call'''|| Raised for testing issues fixes
|-
|'''Detail of Fix''' || Couple of minor issues found during testing for monthly interface.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== OBS Log Number: 337206 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Andy Rowe
|-
|'''Summary of Call'''|| Trip debrief truncation - item desc'
|-
|'''Detail of Fix''' || Increased the size of item_description on form TRIPDTL to match the size of item_description on the sch_ord_items table
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== OBS Log Number: 337297 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Andy Rowe
|-
|'''Summary of Call'''|| PODPOC not applying
|-
|'''Detail of Fix''' || The size of item_description on the xml orders tab, had its size set incorrectly compared to sch_ord_items table its size has been set to match this value, this has removed the truncation errors
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== OBS Log Number: 337359 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''|| Delivery note sort
|-
|'''Reporter: ''' || Dave Meir
|-
|'''Summary of Call'''|| Change delivery note sort order
|-
|'''Detail of Fix''' || Amendment to delivery note to change the sort order
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== OBS Log Number: 337388 ==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''|| scr-018 rework
|-
|'''Reporter: ''' || Ben Doft
|-
|'''Summary of Call'''|| Raised for testing issue fixes
|-
|'''Detail of Fix''' || Changes to Debrief for customer stack processing.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== OBS Log Number: 337506 ==
{| width="100%"
{| width="100%"
|-
|width="30%"|'''Cust Ref:'''  || '''Reporter:'''
|-
|-
|'''Summary of Call'''||  
|width="30%"|'''Customer Ref:'''||
|-
|'''Reporter: ''' || Paul Roscoe
|-
|'''Summary of Call'''|| Release of database scripts for CMR
|-
|-
|'''Detail of Fix''' ||
|'''Detail of Fix''' || Database scripts will be run to allow the CMR Note to be configured for the appropriate cost centres and user groups.
|-
|-
|'''Set-up and Configuration''' ||  
|'''Set-up and Configuration''' || No set-up/configuration required
|}
|}


<table border="1px" width="100%">
<tr>
<td colspan="3" bgcolor="silver"><font size="2">'''New Access'''</font></td>
</tr>
<tr>
<td bgcolor="silver"><font size="2">'''Access Tab'''</font></td>
<td bgcolor="silver"><font size="2">'''Name'''</font></td>
<td bgcolor="silver"><font size="2">'''Description'''</font></td>
</tr>
<tr>
<td>CMR_NL</td>
<td>New report</td>
<td>Added to Group Maintenance</td>
</tr>
</table>
<table border="1px" width="100%">
<tr>
<td colspan="4" bgcolor="silver"><font size="2">'''New Parameters'''</font></td>
</tr>
<tr>
<td bgcolor="silver"><font size="2">'''Parameter Name'''</font></td>
<td bgcolor="silver"><font size="2">'''Config Level'''</font></td>
<td bgcolor="silver"><font size="2">'''Setting Value'''</font></td>
<td bgcolor="silver"><font size="2">'''Result'''</font></td>
</tr>
<tr>
<td>CMR_NOTE</td>
<td>COST CENTRE</td>
<td>CMR_NL.rep</td>
<td>Name of Delivery report to be generated from trip tree in the planning screen</td>
</tr>
</table>




Line 230: Line 2,781:
|}
|}
-->
-->
== OBS Log Number:  ==
 
== OBS Log Number: 334030 ==
{| width="100%"
|-
|width="30%"|'''Reporter: ''' || Emily Collins
|-
|'''Summary of Call'''|| Performance in interface errors screen
|-
|'''Detail of Fix''' || Implemented a change so when users open error correction on the xml order tab they will be returned to the next order, aswell removed unnecessary upper functions in the search condtion, and expanded location and date columns
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== OBS Log Number: 335337 ==
{| width="100%"
|-
|width="30%"|'''Reporter: ''' || Julie Scott
|-
|'''Summary of Call'''|| ORS - Export Reports
|-
|'''Detail of Fix''' || The ORS reports have had the following reports added CUST_DATA, CUST_FUELC, CUST_FUEL, CUST_SEC, CUST_SEC_C, CUST_PREFS, CUST_CHRGS, CUST_SCHED, CUST_COST, CUST_PAIN, DU_TYPES, CONTRACTS, CONT_JRNY OWN_CHRGS, RPE_CUST, FIX_ROUTE, CARR_SHIP, CARR_DUS, CARR_PRODS, CARR_COMMS, CARR_CLASS, CARR_ROUTE, ORD_OFFSET, NETWORK
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
   
 
== OBS Log Number: 335501 ==
{| width="100%"
|-
|width="30%"|'''Reporter: ''' || Julie Scott
|-
|'''Summary of Call'''|| CTMS Data Uploads - from CSV
|-
|'''Detail of Fix''' || Additional CSV import options for Customers, Drivers, Region data, Region depot, Accounts, Invoice requirements and Currency Usage.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== OBS Log Number: 335697 ==
{| width="100%"
|-
|width="30%"|'''Reporter: ''' || LBW
|-
|'''Summary of Call'''|| 12c system testing
|-
|'''Detail of Fix''' || Changes to replace single quotes in the reports screen with double quotes for 12c
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== OBS Log Number: 335725 ==
{| width="100%"
|-
|width="30%"|'''Reporter: ''' || Graham Rothwell
|-
|'''Summary of Call'''|| LOTS messages sent with no owner
|-
|'''Detail of Fix''' || Do not send LOTS message with no owner when a non-conformance is added to an order for a non-LOTS customer.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== OBS Log Number: 335861 ==
{| width="100%"
|-
|width="30%"|'''Reporter: ''' || Dave Meir
|-
|'''Summary of Call'''|| Issues with - delimiters and checkdigits
|-
|'''Detail of Fix''' || A new record will need to be added to the MODULO_43 decode name as follows to override the SPACE check digit as a NULL value:                                                                                        Source Value = NULL                                   
Target Value = SPACE                                                                                         
Related changes to WCS will be required to be implemented for log 335862.                                                                                 
This development will allow a hyphen to be used to identify the OBS suffix for the assets should there also be a customer suffix in the same format. Any other item codes will retain a hyphen.                                                                   
The check digit for the non-asset items will not be stored should the check digit be a space character: the space will then not be displayed in C-TMS nor will it be used in WCS.                                                                                           
The check digit of a space character will be included in the Microlise interface file for validating the scans of the barcodes for collection and delivery activities.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== OBS Log Number: 336188 ==
{| width="100%"
|-
|width="30%"|'''Reporter: ''' || Paul Roscoe
|-
|'''Summary of Call'''|| Main version for branch for log 335495
|-
|'''Detail of Fix''' || Main version for changes for branched version of the Resource Maintenance screen for log 335495.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
 
== OBS Log Number: 337040 ==
{| width="100%"
|-
|width="30%"|'''Reporter: ''' || Suzanne Woodcock
|-
|'''Summary of Call'''|| Log to release orders screen
|-
|'''Detail of Fix''' || Order screen changes to show self bill revenue as a cost, part of original finance changes in log 333092.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== OBS Log Number: 337229 ==
{| width="100%"
|-
|width="30%"|'''Reporter: ''' || Emily Collins
|-
|'''Summary of Call'''|| EDI screen audit
|-
|'''Detail of Fix''' || Added auditing for the Start/Stop buttons on the EDI Maintenance screen, records are stored on the EDI_AUDIT table.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
<!-- NEW PAGE -->
 
== OBS Log Number: 337337 ==
{| width="100%"
{| width="100%"
|-
|width="30%"| '''Reporter:''' ||
|-
|-
|'''Summary of Call'''||  
|width="30%"|'''Reporter: ''' || Dave Meir
|-
|'''Summary of Call'''|| Changes from branch 337335
|-
|-
|'''Detail of Fix''' ||
|'''Detail of Fix''' || Cosmetic changes to the planning screen and add CMR note menu item
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
|}
|}




== OBS Log Number: 337417 ==
{| width="100%"
|-
|width="30%"|'''Reporter: ''' || Rob Merrill
|-
|'''Summary of Call'''|| Amendments to waterfall screen (Depot)
|-
|'''Detail of Fix''' || Control depot drop down list and trips shown based upon the users based at.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
== OBS Log Number: 337519 ==
{| width="100%"
|-
|width="30%"|'''Reporter: ''' || Paul Jones
|-
|'''Summary of Call'''|| 12c issue spaces in URL
|-
|'''Detail of Fix''' || Replace spaces in Reports URL with %20 to ensure reports run in oracle 12c
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
<!-- NEW PAGE -->


= MODULES DELIVERED =
= MODULES DELIVERED =
Line 257: Line 2,958:
{| border="1" width="100%"
{| border="1" width="100%"
|- bgcolor="silver"
|- bgcolor="silver"
!Module Name !! Version No !! Description !! Log Number
!Module Name !! Version No !! Description !! Log Number  
|-
| ACC.sql || 5.42 || Accounts package || 336459
|-
| ACC.sql || 5.44 || Accounts package || 336377
|-
| ACC.sql || 5.45 || Accounts package || 335409
|-
| ACC.sql || 5.46 || Accounts package || 337543
|-
| ACC_MAINT.fmx || 2.65 || Accounts Maintenance || 335409
|-
| ACC_MAINT.fmx || 2.66 || Accounts Maintenance || 336149
|-
| ACC_MAINT.fmx || 2.67 || Accounts Maintenance || 336377
|-
| AGR.sql || 1.1 || Agreements Package || 333089
|-
| AGR.sql || 1.2 || Agreements Package || 336378
|-
| AGR.sql || 1.3 || Agreements Package || 336459
|-
| AGR.sql || 1.4 || Agreements Package || 336537
|-
| AGR.sql || 1.5 || Agreements Package || 337543
|-
| AGREEMENTS.fmx || 2.13 || Agreements Screen || 336537
|-
| AGREEMENTS.fmx || 2.16 || Agreements Screen || 336572
|-
| AGREEMENTS.fmx || 2.17 || Agreements Screen || 336956
|-
| AGREEMENTS.fmx || 2.3 || Agreements Screen || 333089
|-
| AGREEMENTS.fmx || 2.4 || Agreements Screen || 336378
|-
| AGREEMENTS.fmx || 2.6 || Agreements Screen || 336459
|-
| ASSET.sql || 5.3 || Asset Procedures || 335692
|-
| AT_2_CNT_AGREEMENT_333089.sql || 1.1 || Alter Table Script || 333089
|-
| AT_ACC_ACCOUNT_333089.sql || 1.1 || Alter Table Script || 333089
|-
| AT_ACC_CURRENCY_335395.sql || 1.1 || Alter Table Script || 335395
|-
| AT_ACC_PAYMENT_333092.sql || 1.1 || Alter Table Script || 333092
|-
| AT_ACC_PAYMENT_TYPE_333092.sql || 1.1 || Alter Table Script || 333092
|-
| AT_ACC_PAYMENT_TYPE_335409.sql || 1.1 || Alter Table Script || 335409
|-
| AT_ACC_PAYMENT_TYPE_335409.sql || 1.1 || Alter Table Script || 336459
|-
| AT_ACC_PRICE_INDEX_336377.sql || 1.1 || Alter Table Script || 336377
|-
| AT_CNT_AGREEMENT_333089.sql || 1.2 || Alter Table Script || 333089
|-
| AT_CNT_AGREEMENT_AUDIT_333089.sql || 1.1 || Alter Table Script || 333089
|-
| AT_CNT_AGREEMENT_FORECAST_336537.sql || 1.1 || Alter Table Script || 336537
|-
| AT_CNT_CHARGE_TIER_333089.sql || 1.3 || Alter Table Script || 333089
|-
| AT_CNT_TIER_NAME_333089.sql || 1.1 || Alter Table Script || 333089
|-
| AT_GEO_LOC_TYPE_333090.sql || 1.1 || Alter Table Script || 333090
|-
| AT_GEO_LOCATION_333090.sql || 1.1 || Alter Table Script || 333090
|-
| AT_GEO_LOCATION_ZONE_335395.sql || 1.1 || Alter Table Script || 335395
|-
| AT_MSG_SMS_AUDIT_336457.sql || 1.1 || Alter Table Script || 336457
|-
| AT_ORG_CUSTOMER_334630.sql || 1.1 || Alter Table Script || 334630
|-
| AT_ORS_USER_DETAILS_336863.sql || 1.1 || Alter Table Script || 336863
|-
| AT_PRD_COMMODITY_336006.sql || 1.1 || Alter Table Script || 336006
|-
| AT_RES_CARRIER_333095.sql || 1.1 || Alter Table Script || 333095
|-
| AT_RES_TRAILER_335395.sql || 1.1 || Alter Table Script || 335395
|-
| AT_SCH_ORD_333091.sql || 1.1 || Alter Table Script || 333091
|-
| AT_SCH_ORD_NON_CONFORM_333091.sql || 1.1 || Alter Table Script || 333091
|-
| AT_SCH_ORDER_LINE_333091.sql || 1.1 || Alter Table Script || 333091
|-
| AT_SCH_TRIP_333091.sql || 1.1 || Alter Table Script || 333091
|-
| AT_SCH_TRIP_STOP_333091.sql || 1.2 || Alter Table Script || 333091
|-
| AT_TIME_ZONE_MASTER_335395.sql || 1.1 || Alter Table Script || 335395
|-
| AT_TMP_CNT_TIER_NAME_336537.sql || 1.1 || Alter Table Script || 336537
|-
| AT_TOM_DRIV_GROUP_335931.sql || 1.1 || Alter Table Script || 335931
|-
| AT_TOM_DRIVER_KPI_335931.sql || 1.1 || Alter Table Script || 335931
|-
| BDM.fmx || 2.87 || Business Data Form || 333090
|-
| BDM.fmx || 2.89 || Business Data Form || 335395
|-
| BDM.fmx || 2.90 || Business Data Form || 336770
|-
| BNL_DELIVERY.rep || 1.2 || Delivery Report || 336656
|-
| BNL_DELIVERY.rep || 1.3 || Delivery Report || 337359
|-
| BNL_DELIVERY.rep || 1.4 || Delivery Report || 336963
|-
| CALENDAR.fmx || 1.5 || Calendar Pop-Up || 336595
|-
| CMR_NL.rep || 1.2 || CMR Report || 336963
|-
| CNT.sql || 5.38 || Contracts package || 335391
|-
| CNT.sql || 5.39 || Contracts package || 336377
|-
| CONTRACT.fmx || 2.57 || Contracts Form || 335409
|-
| CT_ACC_PRICE_INDEX_333089.sql || 1.1 || Create Table Script || 333089
|-
| CT_ACC_PRICE_INDEX_333092.sql || 1.1 || Create Table Script || 333092
|-
| CT_ACC_PRICE_INDEX_EFFECTIVE_333092.sql || 1.1 || Create Table Script || 333092
|-
| CT_CNT_AGREEMENT_333089.sql || 1.2 || Create Table Script || 333089
|-
| CT_CNT_AGREEMENT_AUDIT_333089.sql || 1.3 || Create Table Script || 333089
|-
| CT_CNT_AGREEMENT_FORECAST_333089.sql || 1.2 || Create Table Script || 333089
|-
| CT_CNT_AGREEMENT_INDEX_333089.sql || 1.1 || Create Table Script || 333089
|-
| CT_CNT_AGREEMENT_INDEX_333092.sql || 1.2 || Create Table Script || 333092
|-
| CT_CNT_AGREEMENT_INDEX_335409.sql || 1.1 || Create Table Script || 335409
|-
| CT_CNT_AGREEMENT_INDEX_335409.sql || 1.1 || Create Table Script || 336459
|-
| CT_CNT_RHA_CONFIG_335409.sql || 1.1 || Create Table Script || 335409
|-
| CT_CNT_RHA_CONFIG_335409.sql || 1.1 || Create Table Script || 336459
|-
| CT_CNT_RHA_INDEX_335409.sql || 1.1 || Create Table Script || 335409
|-
| CT_CNT_RHA_INDEX_335409.sql || 1.1 || Create Table Script || 336459
|-
| CT_CNT_SERVICE_CHARGES_336149.sql || 1.1 || Create Table Script || 336149
|-
| CT_CNT_SERVICE_CONTRACTS_336149.sql || 1.1 || Create Table Script || 336149
|-
| CT_EDI_AUDIT_337229.sql || 1.1 || Create Table Script || 337229
|-
| CT_GEO_LOC_ENTRIES.sql || 1.1 || Create Table Script || 333090
|-
| CT_GEO_LOC_ENTRIES_AUDIT_333090.sql || 1.4 || Create Table Script || 333090
|-
| CT_GEO_LOC_INFORMATION_333090.sql || 1.4 || Create Table Script || 333090
|-
| CT_GEO_LOC_NOTE_TYPE_333090.sql || 1.2 || Create Table Script || 333090
|-
| CT_GEO_LOC_STORAGE_TYPE_333090.sql || 1.1 || Create Table Script || 333090
|-
| CT_IMP_LOAD_AUDIT_333095.sql || 1.10 || Create Table Script || 333095
|-
| CT_INT_BNL_ORDERS_DETAIL_336655.sql || 1.1 || Create Table Script || 336655
|-
| CT_INT_BNL_ORDERS_HEADER_336655.sql || 1.1 || Create Table Script || 336655
|-
| CT_INT_BWSC_DEBRIEF_ORD_336151.sql || 1.1 || Create Table Script || 336151
|-
| CT_PAR_RESET_AUDIT_334029.sql || 1.1 || Create Table Script || 334029
|-
| CT_RES_TRAILER_PRODUCT_333095.sql || 1.2 || Create Table Script || 333095
|-
| CT_SCH_TRIP_STOP_SIGNATURE_330260.sql || 1.1 || Create Table Script || 330260
|-
| CT_SEQ_CNT_AGREEMENT_333089.sql || 1.1 || Create Table Script || 333089
|-
| CT_SEQ_CNT_AGREEMENT_AUDIT_333089.sql || 1.1 || Create Table Script || 333089
|-
| CT_SEQ_CNT_AGREEMENT_FORECAST_333089.sql || 1.1 || Create Table Script || 333089
|-
| CT_SEQ_EDI_AUDIT_337229.sql || 1.1 || Create Table Script || 337229
|-
| CT_SEQ_GLE_AUDIT_333090.sql || 1.1 || Create Table Script || 333090
|-
| CT_SEQ_IMP_FILE_ID_333095.sql || 1.1 || Create Table Script || 333095
|-
| CT_SEQ_INT_BNL_ORDERS_336655.sql || 1.1 || Create Table Script || 336655
|-
| CT_SEQ_INT_DEBRIEF_ORD_CSV_336151.sql || 1.1 || Create Table Script || 336151
|-
| CT_SEQ_MICD_OUTBOUND_333896.sql || 1.1 || Create Table Script || 333896
|-
| CT_SEQ_PAR_RESET_AUDIT_334029.sql || 1.1 || Create Table Script || 334029
|-
| CT_TMP_CNT_TIER_NAME_333089.sql || 1.2 || Create Table Script || 333089
|-
| CUST_COST.fmx || 2.98 || Customer Maintenance form || 334630
|-
| CUST_COST.fmx || 2.99 || Customer Maintenance form || 333089
|-
| DATA_1_ADM_SYSTEM_PARAM_333896.sql || 1.2 || Data Script || 333896
|-
| DATA_1_ADM_SYSTEM_PARAM_334812.sql || 1.1 || Data Script || 334812
|-
| DATA_1_ADM_SYSTEM_PARAM_336976.sql || 1.1 || Data Script || 336976
|-
| DATA_1_IMP_IMPORT_TYPE_335501.sql || 1.1 || Data Script || 335501
|-
| DATA_1_REP_REPORT_336257.sql || 1.1 || Data Script || 336257
|-
| DATA_1_REP_REPORT_337446.sql || 1.1 || Data Script || 337446
|-
| DATA_2_ADM_SYSTEM_PARAM_CONFIG_333896.sql || 1.1 || Data Script || 333896
|-
| DATA_2_ADM_SYSTEM_PARAM_CONFIG_334812.sql || 1.1 || Data Script || 334812
|-
| DATA_2_ADM_SYSTEM_PARAM_CONFIG_336976.sql || 1.1 || Data Script || 336976
|-
| DATA_2_IMP_FIELD_335501.sql || 1.1 || Data Script || 335501
|-
| DATA_2_REP_REPORT_PARAM_336257.sql || 1.1 || Data Script || 336257
|-
| DATA_2_REP_REPORT_PARAM_337446.sql || 1.1 || Data Script || 337446
|-
| DATA_3_ADM_LOG_PROG_NAME_333896.sql || 1.1 || Data Script || 333896
|-
| DATA_4_SCH_SOURCE_SYSTEM_333896.sql || 1.1 || Data Script || 333896
|-
| DATA_ADM_FORM_TAB_333090.sql || 1.1 || Data Script || 333090
|-
| DATA_ADM_FORM_TAB_333095.sql || 1.1 || Data Script || 333095
|-
| DATA_ADM_FORM_TAB_336151.sql || 1.1 || Data Script || 336151
|-
| DATA_ADM_FORM_TAB_336655.sql || 1.1 || Data Script || 336655
|-
| DATA_ADM_FUNCTION_333090.sql || 1.1 || Data Script || 333090
|-
| DATA_ADM_FUNCTION_336148.sql || 1.1 || Data Script || 336148
|-
| DATA_ADM_LOG_PROG_NAME_335692.sql || 1.1 || Data Script || 335692
|-
| DATA_ADM_LOG_PROG_NAME_336151.sql || 1.1 || Data Script || 336151
|-
| DATA_ADM_LOG_PROG_NAME_336639.sql || 1.1 || Data Script || 336639
|-
| DATA_ADM_LOG_PROG_NAME_336655.sql || 1.1 || Data Script || 336655
|-
| DATA_ADM_MENU_ITEM_334291.sql || 1.1 || Data Script || 334291
|-
| DATA_ADM_MENU_ITEM_336149.sql || 1.1 || Data Script || 336149
|-
| DATA_ADM_MSEL_FORM_PARAM_336006.sql || 1.1 || Data Script || 336006
|-
| DATA_ADM_MSEL_FORM_PARAM_336078.sql || 1.2 || Data Script || 336078
|-
| DATA_ADM_MSEL_FORM_PARAM_336152.sql || 1.1 || Data Script || 336152
|-
| DATA_ADM_MSEL_FORM_PARAM_336657.sql || 1.1 || Data Script || 336657
|-
| DATA_ADM_SYSTEM_PARAM_333090.sql || 1.1 || Data Script || 333090
|-
| DATA_ADM_SYSTEM_PARAM_333091.sql || 1.1 || Data Script || 333091
|-
| DATA_ADM_SYSTEM_PARAM_333092.sql || 1.1 || Data Script || 333092
|-
| DATA_ADM_SYSTEM_PARAM_334291.sql || 1.1 || Data Script || 334291
|-
| DATA_ADM_SYSTEM_PARAM_335409.sql || 1.1 || Data Script || 336459
|-
| DATA_ADM_SYSTEM_PARAM_335409.sql || 1.2 || Data Script || 335409
|-
| DATA_ADM_SYSTEM_PARAM_335576.sql || 1.1 || Data Script || 335576
|-
| DATA_ADM_SYSTEM_PARAM_336000.sql || 1.1 || Data Script || 336000
|-
| DATA_ADM_SYSTEM_PARAM_336148.sql || 1.1 || Data Script || 336148
|-
| DATA_ADM_SYSTEM_PARAM_336149.sql || 1.1 || Data Script || 336149
|-
| DATA_ADM_SYSTEM_PARAM_336257.sql || 1.1 || Data Script || 336257
|-
| DATA_ADM_SYSTEM_PARAM_336656.sql || 1.1 || Data Script || 336656
|-
| DATA_ADM_SYSTEM_PARAM_336657.sql || 1.1 || Data Script || 336657
|-
| DATA_ADM_SYSTEM_PARAM_336890.sql || 1.1 || Data Script || 336890
|-
| DATA_ADM_SYSTEM_PARAM_336963.sql || 1.1 || Data Script || 336963
|-
| DATA_ADM_SYSTEM_PARAM_337506.sql || 1.1 || Data Script || 337506
|-
| DATA_ADM_SYSTEM_PARAM_CONFIG_333091.sql || 1.1 || Data Script || 333091
|-
| DATA_ADM_SYSTEM_PARAM_CONFIG_333092.sql || 1.1 || Data Script || 333092
|-
| DATA_ADM_SYSTEM_PARAM_CONFIG_335409.sql || 1.1 || Data Script || 335409
|-
| DATA_ADM_SYSTEM_PARAM_CONFIG_336459.sql || 1.1 || Data Script || 336459
|-
| DATA_ADM_SYSTEM_PARAM_CONFIG_336656.sql || 1.1 || Data Script || 336656
|-
| DATA_ADM_SYSTEM_PARAM_CONFIG_336657.sql || 1.1 || Data Script || 336657
|-
| DATA_ADM_SYSTEM_PARAM_CONFIG_336890.sql || 1.1 || Data Script || 336890
|-
| DATA_ADM_SYSTEM_PARAM_CONFIG_336963.sql || 1.1 || Data Script || 336963
|-
| DATA_ADM_SYSTEM_PARAM_CONFIG_337506.sql || 1.1 || Data Script || 337506
|-
| DATA_ADM_USER_PARAM_TYPE_335581.sql || 1.1 || Data Script || 335581
|-
| DATA_ADM_USER_PARAM_TYPE_335799.sql || 1.1 || Data Script || 335799
|-
| DATA_ORG_CUST_ORD_REV_CHG_TYPE_333091.sql || 1.1 || Data Script || 333091
|-
| DATA_ORS_MASTER_DATA_335337_1.sql || 1.2 || Data Script || 335337
|-
| DATA_ORS_MASTER_DATA_335337_10.sql || 1.2 || Data Script || 335337
|-
| DATA_ORS_MASTER_DATA_335337_11.sql || 1.2 || Data Script || 335337
|-
| DATA_ORS_MASTER_DATA_335337_12.sql || 1.2 || Data Script || 335337
|-
| DATA_ORS_MASTER_DATA_335337_13.sql || 1.2 || Data Script || 335337
|-
| DATA_ORS_MASTER_DATA_335337_14.sql || 1.3 || Data Script || 335337
|-
| DATA_ORS_MASTER_DATA_335337_15.sql || 1.2 || Data Script || 335337
|-
| DATA_ORS_MASTER_DATA_335337_16.sql || 1.2 || Data Script || 335337
|-
| DATA_ORS_MASTER_DATA_335337_17.sql || 1.2 || Data Script || 335337
|-
| DATA_ORS_MASTER_DATA_335337_18.sql || 1.2 || Data Script || 335337
|-
| DATA_ORS_MASTER_DATA_335337_2.sql || 1.2 || Data Script || 335337
|-
| DATA_ORS_MASTER_DATA_335337_3.sql || 1.2 || Data Script || 335337
|-
| DATA_ORS_MASTER_DATA_335337_4.sql || 1.2 || Data Script || 335337
|-
| DATA_ORS_MASTER_DATA_335337_5.sql || 1.2 || Data Script || 335337
|-
| DATA_ORS_MASTER_DATA_335337_6.sql || 1.2 || Data Script || 335337
|-
| DATA_ORS_MASTER_DATA_335337_7.sql || 1.2 || Data Script || 335337
|-
| DATA_ORS_MASTER_DATA_335337_8.sql || 1.2 || Data Script || 335337
|-
| DATA_ORS_MASTER_DATA_335337_9.sql || 1.2 || Data Script || 335337
|-
| DATA_ORS_MASTER_DATA_335422.sql || 1.1 || Data Script || 335422
|-
| DATA_ORS_MASTER_DATA_336130.sql || 1.1 || Data Script || 336130
|-
| DATA_ORS_MASTER_DATA_336466.sql || 1.3 || Data Script || 336466
|-
| DATA_ORS_SQL_335337.sql || 1.2 || Data Script || 335337
|-
| DATA_ORS_SQL_335422.sql || 1.1 || Data Script || 335422
|-
| DATA_ORS_SQL_336466.sql || 1.1 || Data Script || 336466
|-
| DATA_REP_REPORT_336149.sql || 1.1 || Data Script || 336149
|-
| DATA_REP_REPORT_336656.sql || 1.1 || Data Script || 336656
|-
| DATA_REP_REPORT_336963.sql || 1.1 || Data Script || 336963
|-
| DATA_REP_REPORT_337506.sql || 1.1 || Data Script || 337506
|-
| DATA_REP_REPORT_PARAM_336149.sql || 1.1 || Data Script || 336149
|-
| DATA_REP_REPORT_PARAM_336656.sql || 1.1 || Data Script || 336656
|-
| DATA_REP_REPORT_PARAM_336963.sql || 1.1 || Data Script || 336963
|-
| DATA_REP_REPORT_PARAM_337133.sql || 1.1 || Data Script || 337133
|-
| DATA_REP_REPORT_PARAM_337506.sql || 1.1 || Data Script || 337506
|-
| DATA_SCH_SOURCE_SYSTEM_333095.sql || 1.1 || Data Script || 333095
|-
| DELIVERY.fmx || 1.1 || Delivery Management Screen || 334291
|-
| DELIVERY.fmx || 1.6 || Delivery Management Screen || 336595
|-
| DELIVERY.fmx || 1.8 || Delivery Management Screen || 337375
|-
| DP_ASSET_SCANNING.sql || 5.27 || Tag to Asset Scanning || 330260
|-
| DP_ASSET_SCANNING.sql || 5.28 || Tag to Asset Scanning || 335812
|-
| DP_ASSET_SCANNING.sql || 5.30 || Tag to Asset Scanning || 336177
|-
| DP_ASSET_SCANNING.sql || 5.31 || Tag to Asset Scanning || 336289
|-
| DP_ASSET_SCANNING.sql || 5.32 || Tag to Asset Scanning || 336487
|-
| DP_BMW_EDI_IN.sql || 1.15 || Inbound EDI Package || 335851
|-
| DP_BMW_EDI_OUT.sql || 1.8 || Outbound EDI Package || 336078
|-
| DP_BMW_EDI_OUT.sql || 1.9 || Outbound EDI Package || 336181
|-
| DP_BNL_EDI_IN.sql || 1.1 || Inbound EDI Package || 336655
|-
| DP_BNL_EDI_IN.sql || 1.2 || Inbound EDI Package || 336657
|-
| DP_BNL_EDI_OUT.sql || 1.2 || Outbound EDI Package || 336639
|-
| DP_BNL_EDI_OUT.sql || 1.3 || Outbound EDI Package || 336657
|-
| DP_BWSC.sql || 1.1 || Database package || 336151
|-
| DP_CSV_NR.sql || 5.48 || Network Rail CSV reports || 335407
|-
| DP_CSV_NR.sql || 5.49 || Network Rail CSV reports || 335403
|-
| DP_CSV5.sql || 1.63 || Fifth CSV extract package || 336257
|-
| DP_CSV6.sql || 1.28 || CSV Extract package || 336331
|-
| DP_IMP.sql || 5.29 || Imports Package || 336377
|-
| DP_IMP.sql || 5.30 || Imports Package || 335409
|-
| DP_IMP.sql || 5.30 || Imports Package || 336459
|-
| DP_IMP_3.sql || 1.1 || Imports Package || 333095
|-
| DP_IMP_3.sql || 1.2 || Imports Package || 337117
|-
| DP_IMP_4.sql || 4.1 || Imports Package || 335501
|-
| DP_INT_XML_MIC2.sql || 1.11 || CTMS to MIC Interface || 336643
|-
| DP_INT_XML_MIC2.sql || 1.12 || CTMS to MIC Interface || 336676
|-
| DP_INT_XML_MIC2.sql || 1.13 || CTMS to MIC Interface || 336976
|-
| DP_INT_XML_MIC2.sql || 1.2 || CTMS to MIC Interface || 333896
|-
| DP_INT_XML_MIC2.sql || 1.3 || CTMS to MIC Interface || 336412
|-
| DP_INT_XML_MIC2.sql || 1.4 || CTMS to MIC Interface || 336513
|-
| DP_INT_XML_MIC2.sql || 1.5 || CTMS to MIC Interface || 336524
|-
| DP_INT_XML_MIC2.sql || 1.6 || CTMS to MIC Interface || 336568
|-
| DP_INT_XML_MIC2.sql || 1.8 || CTMS to MIC Interface || 336591
|-
| DP_INT_XML_MIC2.sql || 1.9 || CTMS to MIC Interface || 336616
|-
| DP_MCS_SCANNING.sql || 5.35 || MCS Scanning Package || 337353
|-
| DP_ORS_FUNCS.sql || 5.20 || Change to DOOD status function || 335422
|-
| DP_ORS_FUNCS.sql || 5.24 || Change to DOOD status function || 335337
|-
| DP_PORTAL.sql || 5.13 || Portal Package || 336673
|-
| DP_PULSE.sql || 1.37 || Pulse Interface Package || 336677
|-
| DP_RDT_AUTO.sql || 5.40 || Client specific RDT funtions || 335861
|-
| DP_RDT_AUTO.sql || 5.41 || Client specific RDT funtions || 335935
|-
| DP_RDT_FAST_LOAD.sql || 5.22 || Load confirmation message procedure || 335692
|-
| DP_RDT_FAST_LOAD.sql || 5.23 || Load confirmation message procedure || 335861
|-
| DP_RDT_FAST_LOAD.sql || 5.24 || Load confirmation message procedure || 337205
|-
| DP_RDT_FAST_UNLOAD.sql || 5.32 || RF Unload Package || 335656
|-
| DP_RDT_FAST_UNLOAD.sql || 5.33 || RF Unload Package || 335692
|-
| DP_RDT_FAST_UNLOAD.sql || 5.34 || RF Unload Package || 335861
|-
| DP_RDT_FAST_UNLOAD.sql || 5.35 || RF Unload Package || 336061
|-
| DP_REPORTS.sql || 5.36 || Reports package || 335421
|-
| DP_REPORTS.sql || 5.37 || Reports package || 335825
|-
| DP_REPORTS.sql || 5.38 || Reports package || 336117
|-
| DP_REPORTS.sql || 5.39 || Reports package || 336157
|-
| DP_REPORTS.sql || 5.40 || Reports package || 336656
|-
| DP_REPORTS.sql || 5.41 || Reports package || 336963
|-
| DP_SCHEDULING_ENGINE.sql || 5.93 || Scheduling Package || 337350
|-
| DP_TOMTOM.sql || 1.18 || TomTom Package || 335931
|-
| DP_TOMTOM.sql || 1.19 || TomTom Package || 336298
|-
| DP_TOY_EDI_IN.sql || 1.3 || Inbound EDI database package || 335692
|-
| DP_TOY_EDI_IN.sql || 1.4 || Inbound EDI database package || 335861
|-
| DP_TOY_EDI_IN.sql || 1.5 || Inbound EDI database package || 336261
|-
| EDI_MAINT.fmx || 10.10 || EDI Maintenance Screen || 337229
|-
| GEO.sql || 5.3 || Location Processing || 337184
|-
| HAULIER_INVOICE.rep || 2.2 || Haulier Invoice Report || 336257
|-
| IMP.sql || 5.127 || CSV Imports Package || 333095
|-
| IMP.sql || 5.128 || CSV Imports Package || 335501
|-
| IMPORTS_EXEC.fmx || 10.18 || Import executions || 333095
|-
| INT_ERR.fmx || 1.88 || Interface Errors || 335861
|-
| INT_ERR.fmx || 1.89 || Interface Errors || 336319
|-
| INT_ERR.fmx || 1.90 || Interface Errors || 336655
|-
| INT_ERR.fmx || 1.91 || Interface Errors || 336151
|-
| INT_ERR.fmx || 1.92 || Interface Errors || 337297
|-
| INT_ERR.fmx || 1.94 || Interface Errors || 334030
|-
| INT_XML_IN.sql || 5.143 || Order Import Package || 334630
|-
| INT_XML_MIC.sql || 5.132 || MIC interface || 335682
|-
| INT_XML_MIC.sql || 5.133 || MIC interface || 335692
|-
| INT_XML_MIC.sql || 5.134 || MIC interface || 335861
|-
| INT_XML_MIC.sql || 5.135 || MIC interface || 335935
|-
| INT_XML_OUT2.sql || 5.232 || Outbound XML Package || 334630
|-
| INT_XML_OUT2.sql || 5.233 || Outbound XML Package || 335932
|-
| INT_XML_OUT2.sql || 5.234 || Outbound XML Package || 337152
|-
| INT_XML_OUT2.sql || 5.235 || Outbound XML Package || 336000
|-
| INV.sql || 5.20 || Invoice Package || 335409
|-
| INV.sql || 5.21 || Invoice Package || 336377
|-
| INV.sql || 5.22 || Invoice Package || 336149
|-
| INV.sql || 5.23 || Invoice Package || 336257
|-
| INVENTORY_MAN.fmx || 1.1 || Inventory Management || 333090
|-
| INVOICE_CARR.rep || 2.3 || Carrier Invoice || 336257
|-
| INVOICES.fmx || 2.37 || Invoices Screen || 336552
|-
| INVOICES.fmx || 2.38 || Invoices Screen || 336257
|-
| LOCATION.fmx || 2.148 || Location Maintenance || 333090
|-
| LOCATION.fmx || 2.149 || Location Maintenance || 335924
|-
| LOCATION.fmx || 2.151 || Location Maintenance || 336770
|-
| LOCATION.fmx || 2.152 || Location Maintenance || 336377
|-
| LOCATION.fmx || 2.153 || Location Maintenance || 336671
|-
| LOCATION.fmx || 2.154 || Location Maintenance || 337038
|-
| LOCATION.fmx || 2.156 || Location Maintenance || 337375
|-
| OF_INT.sql || 5.31 || Oracle Financials interface || 337123
|-
| OMS.sql || 5.154 || Order package || 336148
|-
| OMS.sql || 5.155 || Order package || 336006
|-
| OMS.sql || 5.156 || Order package || 336657
|-
| ORDERS.fmx || 2.342 || Order Screen || 335560
|-
| ORDERS.fmx || 2.344 || Order Screen || 335694
|-
| ORDERS.fmx || 2.345 || Order Screen || 335581
|-
| ORDERS.fmx || 2.346 || Order Screen || 335799
|-
| ORDERS.fmx || 2.347 || Order Screen || 335903
|-
| ORDERS.fmx || 2.348 || Order Screen || 336078
|-
| ORDERS.fmx || 2.350 || Order Screen || 336580
|-
| ORDERS.fmx || 2.351 || Order Screen || 336924
|-
| ORDERS.fmx || 2.352 || Order Screen || 336970
|-
| ORDERS.fmx || 2.353 || Order Screen || 337040
|-
| ORDERS.fmx || 2.355 || Order Screen || 334812
|-
| ORDERS.fmx || 2.356 || Order Screen || 336657
|-
| ORION.mmx || 1.39 || Orion Menu || 333089
|-
| ORION.mmx || 1.39 || Orion Menu || 333090
|-
| ORION.mmx || 1.40 || Orion Menu || 334291
|-
| ORION.mmx || 1.41 || Orion Menu || 336149
|-
| ORS.fmx || 1.22 || Oracle Reporting suite || 335421
|-
| ORS.fmx || 1.23 || Oracle Reporting suite || 336117
|-
| ORS.fmx || 1.24 || Oracle Reporting suite || 336863
|-
| ORS.sql || 5.9 || Oracle Reporting suite || 336863
|-
| PAR_INT.fmx || 10.33 || Paragon Interface form || 334029
|-
| PAYMENTS.fmx || 2.42 || Payments Screen || 336377
|-
| PLANNING.fmx || 1.26 || Planning Screen || 333896
|-
| PLANNING.fmx || 1.27 || Planning Screen || 335391
|-
| PLANNING.fmx || 1.28 || Planning Screen || 336296
|-
| PLANNING.fmx || 1.30 || Planning Screen || 336374
|-
| PLANNING.fmx || 1.31 || Planning Screen || 336148
|-
| PLANNING.fmx || 1.34 || Planning Screen || 336006
|-
| PLANNING.fmx || 1.35 || Planning Screen || 336656
|-
| PLANNING.fmx || 1.36 || Planning Screen || 337170
|-
| PLANNING.fmx || 1.38 || Planning Screen || 337337
|-
| PLANNING.fmx || 1.39 || Planning Screen || 337375
|-
| PRODUCT.fmx || 2.48 || Product form to maintain Volumetric data || 336006
|-
| RATE.sql || 5.113 || Rates Tariff database package || 336377
|-
| RATE.sql || 5.114 || Rates Tariff database package || 335409
|-
| RATE.sql || 5.115 || Rates Tariff database package || 337543
|-
| REPORTS.fmx || 2.31 || Reports Screen || 335697
|-
| REPORTS.fmx || 2.33 || Reports Screen || 337519
|-
| RESOURCE.fmx || 2.161 || Resource Maintenance form || 335495
|-
| RESOURCE.fmx || 2.162 || Resource Maintenance form || 333095
|-
| RESOURCE.fmx || 2.163 || Resource Maintenance form || 336188
|-
| RESOURCE.fmx || 2.164 || Resource Maintenance form || 335395
|-
| SCHED_RULES.fmx || 1.26 || Scheduling Screen || 337393
|-
| SERVICE_CHARGES.fmx || 1.2 || Service Charge Form || 336149
|-
| SERVICE_SELFBILL.rep || 1.1 || Selfbill Invoice Report || 336149
|-
| SUPPLIER_INVOICE.rep || 2.2 || Supplier Invoice Report || 336257
|-
| SYS_CFG.fmx || 2.11 || System Config Form || 335395
|-
| T_GEO_LOCATION_LATLONG.sql || 5.8 || Geo Location trigger for Lat/Long || 333090
|-
| T_SCH_ORD_PNL.sql || 5.90 || Trigger || 333091
|-
| TIU_TRIP_STATUS.sql || 5.41 || Trigger on SCH_TRIP for status change || 333091
|-
| TIU_TRIP_STATUS.sql || 5.43 || Trigger on SCH_TRIP for status change || 337388
|-
| TRG_BWSCDO_BIU.sql || 1.1 || Trigger || 336151
|-
| TRG_CNT_AGREEMENT_AI.sql || 1.1 || Trigger || 333089
|-
| TRG_CNT_AGREEMENT_BIU.sql || 1.1 || Trigger || 333089
|-
| TRG_CNT_RHA_AI.sql || 1.1 || Trigger || 335409
|-
| TRG_DRY_ICE.sql || 1.10 || Trigger || 337348
|-
| TRG_GEL_PACKS.sql || 1.6 || Trigger || 337352
|-
| TRG_GLE_AUDIT_BI.sql || 1.1 || Trigger || 333090
|-
| TRG_GLE_BIU.sql || 1.1 || Trigger || 333090
|-
| TRG_INT_BNL_ORDERS_DETAIL_BIU.sql || 1.1 || Trigger || 336655
|-
| TRG_INT_BNL_ORDERS_HEADER_BIU.sql || 1.1 || Trigger || 336655
|-
| TRG_SCH_ORD_LINES_SERVICES.sql || 5.6 || Database Trigger Script || 337100
|-
| TRG_SCH_ORD_NON_CONF_XML_INT.sql || 5.10 || Trigger || 335725
|-
| TRG_SCH_ORD_SERVICES.sql || 5.2 || Database Trigger Script || 336158
|-
| TRG_SCH_ORD_SERVICES.sql || 5.3 || Database Trigger Script || 336679
|-
| TRG_SCH_ORD_SERVICES.sql || 5.4 || Database Trigger Script || 336810
|-
| TRG_SCH_TRIP_XML_GEN.sql || 5.10 || Trigger || 336639
|-
| TRG_SCH_TRIP_XML_INT.sql || 5.29 || Trigger || 333896
|-
| TRG_SHA_XML.sql || 5.24 || Trigger || 333896
|-
| TRG_SHA_XML_GEN.sql || 5.6 || Trigger || 336557
|-
| TRG_SOI_XML.sql || 5.17 || Trigger || 333896
|-
| TRG_SOL_XML.sql || 5.38 || Trigger || 333896
|-
| TRG_STS_XML.sql || 5.19 || Trigger || 335576
|-
| TRG_STS_XML.sql || 5.20 || Trigger || 333896
|-
| TRG_STS_XML_GEN.sql || 5.5 || Trigger || 336557
|-
| TRIP_OVERVIEW.fmx || 1.53 || Trip Waterfall || 336152
|-
| TRIP_OVERVIEW.fmx || 1.54 || Trip Waterfall || 337417
|-
| TRIP_OVERVIEW.sql || 5.7 || Trip Waterfall || 336152
|-
| TRIP_PLAN.fmx || 1.270 || Trip Planning Screen || 336323
|-
| TRIP_PLAN.fmx || 1.271 || Trip Planning Screen || 336299
|-
| TRIP_SHEET_BNL.rep || 1.1 || Trip Sheet || 337446
|-
| TRIP_SHEET_SCHED.rep || 1.1 || Trip Sheet Schedule || 337170
|-
| TRIPDTL.fmx || 2.196 || Trip Debrief || 330260
|-
| TRIPDTL.fmx || 2.197 || Trip Debrief || 335692
|-
| TRIPDTL.fmx || 2.199 || Trip Debrief || 336148
|-
| TRIPDTL.fmx || 2.200 || Trip Debrief || 336890
|-
| TRIPDTL.fmx || 2.203 || Trip Debrief || 333091
|-
| TRIPDTL.fmx || 2.204 || Trip Debrief || 337206
|-
| TRIPDTL.fmx || 2.208 || Trip Debrief || 337388
|-
| TRIPSUM.fmx || 2.422 || Trip Manipulation screen || 335913
|-
| TRIPSUM.fmx || 2.423 || Trip Manipulation screen || 336197
|-
| TRIPSUM.fmx || 2.424 || Trip Manipulation screen || 336374
|-
| TRIPSUM.fmx || 2.426 || Trip Manipulation screen || 336006
|-
| TRIPSUM.fmx || 2.427 || Trip Manipulation screen || 337209
|-
| TRM.sql || 5.14 || Trip manipulation package || 336148
|-
| V_ORD_INC_INV.sql || 1.9 || View || 336145
|-
| V_TRIP_OVERVIEW.sql || 1.14 || Trip View || 336152
|-
| V_TRIP_OVERVIEW_ORD.sql || 5.13 || Trip/Order View || 336152
|-
|-
|  ||  ||  ||
 
|}
|}


Line 268: Line 3,759:


A WCS change is required for the following logs:  
A WCS change is required for the following logs:  
* Log
OR


There are no WCS changes required.
* 335861
* 337205
 


== EPOD/T2A ==
== EPOD/T2A ==


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


There are no ePOD/T2A changes required.
* 330260
* 335812
* 336289
 


== MCS ==
== MCS ==


An MCS change is required for the following logs:
There are no MCS changes required.
* Log
OR


There are no MCS changes required.


== PORTAL/TTM ==
== PORTAL/TTM ==


A Portal change is required for the following logs:  
A Portal change is required for the following logs:  
* Log
OR


There are no Portal changes required.
* 336000
* 335932
* 336457
* 336673
 


== EDI ==
== EDI ==


An EDI change is required for the following logs:  
An EDI change is required for the following logs:  
* Log
OR


There are no EDI changes required.
* 336639
* 336655
* 335692




</div>
</div>
[[Category:{{#var:Client}} PATCH]]
[[Category:{{#var:Client}} PATCH]]

Latest revision as of 14:55, 26 June 2025





Aptean Logo.png







OBS Logistics Ltd

Release Notes


CALIDUS C-TMS

30th August 2016 - 1.0
Reference: P021












































SUMMARY INTRODUCTION

INTRODUCTION

The main aim of this document is to provide CALIDUS C-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: CR-18/PO:61544552

OBS Log Number: 330260
Reporter: Ed Bond
Summary of Call CR-18a: Hand over to TNT and HOT
Detail of Fix Hand over to TNT and HOT
Set-up and Configuration No set-up/configuration required


Customer Ref: SCR-001

OBS Log Number: 333089
Reporter: Matthew Tipping
Summary of Call SCR-1 - Supply & service agreement screen
Detail of Fix New screen for entering Agreements and generating C-TMS contracts
Set-up and Configuration No set-up/configuration required


Customer Ref: SCR-002 & 004

OBS Log Number: 333090
Reporter: Matthew Tipping
Summary of Call SCR-2 & 4 - Stack audit and inv management
Detail of Fix New forms for manually entering Stacks.
Set-up and Configuration
New Access
Access Tab Name Description
Function ALLOW_INVENTORY_UPDATE Allow inventory data to be updated


New Parameters
Parameter Name Config Level Setting Value Result
GEO_LOCATION_STACK Database Y Turns off the new stack functionality in the location form.
GEO_DEFAULT_DEPOT Database STACK Default Depot for new locations
GEO_DEFAULT_COUNTRY Database GB Default Country for new locations
MTS_LOCATION_USAGE Database AGREEMENT Location usage to group locations
GEO_MIN_INVENTORY Database 90 Minimum inventory threshold to generate warning
GEO_MAX_INVENTORY Database 110 Maximum inventory threshold to generate warning
GEO_KEEP_LATLONG Database Y Keep location Lat/long when other values change


Customer Ref: SCR-006

OBS Log Number: 333091
Reporter: Matthew Tipping
Summary of Call SCR-006 Debrief - additional data & proc
Detail of Fix Added STACK based processing to the debrief process.
Set-up and Configuration No set-up/configuration required


Customer Ref: SCR-13 & 14 & 16

OBS Log Number: 333092
Reporter: Matthew Tipping
Summary of Call SCR-13,14,16 - Finance changes
Detail of Fix Finance changes to add indexation.
Set-up and Configuration
New Parameters
Parameter Name Config Level Setting Value Result
ACC_INDEXES System N Controls Acc indexes being used


Customer Ref: SCR-018

OBS Log Number: 333095
Reporter: Matthew Tipping
Summary of Call SCR-018 - Auditing process
Detail of Fix New import for auditing only.
Set-up and Configuration No set-up/configuration required


Customer Ref: SCR-003

OBS Log Number: 334291
Reporter: Phil White
Summary of Call SCR-003 Delivery management Screen
Detail of Fix New delivery management form to generate orders and trips from stacks.
Set-up and Configuration
New Parameters
Parameter Name Config Level Setting Value Result
ORD_LATE_TIME Database 20:00 Default time for setting late order windows for generated stack orders


Customer Ref: SCR-019

OBS Log Number: 335409
Reporter: Phil White
Summary of Call New RHA Indexation Requirement
Detail of Fix New RHA calculations.
Set-up and Configuration No set-up/configuration required


Customer Ref: 335581

OBS Log Number: 335581
Reporter: Michelle Naumovski
Summary of Call Allow any location default at collect
Detail of Fix Add user parameter ORD_COLLECT_FROM so when an order is created the system will automatically populate the from location of the order.
Set-up and Configuration No set-up/configuration required


Customer Ref: 336006

OBS Log Number: 336006
Reporter: Hayley Keegan
Summary of Call Add commodity & class to order well
Detail of Fix Added Commodities, DG and EQ from PRD_COMMODITY table to the order well on PLANNING and TRIPSUM forms, as well added rank column to PRD_COMMODITY table
Set-up and Configuration No set-up/configuration required


Customer Ref: SCR-008 & SCR-009

OBS Log Number: 336148
Reporter: Ian Gaunt
Summary of Call Redirection Process & Rejections Process
Detail of Fix A new system parameter called TRM_ALLOW_REJECTIONS will be introduced to allow trips that are not at status TENDERED to be updated to status REJECTED when the system parameter is set to Y.

New menu options of Redirect Trip and Reject Trip will be available in the Planning screen when the new user functions TRM_ENABLE_REDIRECTION and TRM_ENABLE_REJECTIONS respectively are authorised for user for the user group.

Set-up and Configuration
New Parameters
Parameter Name Config Level Setting Value Result
TRM_ALLOW_REJECTIONS System Y Allows trip to be rejected when they are not at TENDERED status
TRM_ALLOW_REJECTIONS SYSTEM N Does not allow trips to be rejected when they are not at TENDERED status


Customer Ref: SCR-015

OBS Log Number: 336149
Reporter: Ian Gaunt
Summary of Call Storage Services finance entry
Detail of Fix New form to maintain service contracts and charges. It will need new form SERVICE_CHARGES manually promoting to appropriate groups. It will need the TOP_UP charge type manually creating. It will need the ACC_CALC_SERVICES system paramater chaging to 'Y'. It will need INVOICES form released under 336257 before invoice can be printed from screen.
Set-up and Configuration
New Parameters
Parameter Name Config Level Setting Value Result
ACC_CALC_SERVICES Database N Service charges applicable


Customer Ref: SCR-010

OBS Log Number: 336151
Reporter: Ian Gaunt
Summary of Call Debrief - CTMS Inbound Flow
Detail of Fix New Crane interface including Interface Errors tab for re-processing.
Set-up and Configuration
New Access
Access Tab Name Description
INT_ERR DEBRIEF_ORDER Inbound interface data from the crane system


Customer Ref: SCR-12.1

OBS Log Number: 336152
Reporter: Ian Gaunt
Summary of Call SSS - Debrief Process
Detail of Fix Add new fields to configurable layouts in the waterfall screen
Set-up and Configuration No set-up/configuration required


Customer Ref: SCR-13 & 14 & 16

OBS Log Number: 336257
Reporter: Julie Taylor
Summary of Call SCR-13,14,16 Invoicing Format (dev split)
Detail of Fix Customer Invoices
Set-up and Configuration No set-up/configuration required


Customer Ref: SCR-13, 14 & 16

OBS Log Number: 336377
Reporter: Roger Egdell
Summary of Call Finance Changes
Detail of Fix Finance indexation changes.
Set-up and Configuration No set-up/configuration required


Customer Ref: SCR-001

OBS Log Number: 336378
Reporter: Ben Doft
Summary of Call Fixes to Supply Agreement screen
Detail of Fix Fixes following internal testing
Set-up and Configuration No set-up/configuration required


Customer Ref: 336466

OBS Log Number: 336466
Reporter: Michelle Naumovski
Summary of Call <ORS- Customer as Range>
Detail of Fix Add delivery time and cust group to ex_ordhead and sched_ords reports
Set-up and Configuration No set-up/configuration required


Customer Ref: SCR-001

OBS Log Number: 336537
Reporter: Suzanne Woodcock
Summary of Call Release following internal testing
Detail of Fix Changes to Agreement screen following internal testing
Set-up and Configuration No set-up/configuration required


Customer Ref: SCR-001

OBS Log Number: 336572
Reporter: Matthew Tipping
Summary of Call Supply agreement screen cost centre seg
Detail of Fix Various changes to the layout and toolbar for presentation. Other changes:

1. Saves the 'indexes' records as they are entered.

2. Displays the tier charges for the current contract agreement record.

3. The seller, buyer and operator may only be entered via the dropdown LOV for new contract agreement records.

4. The Operator LOV will refer to the COST_CENTRE user parameter.

5. The same user parameter will control which contract agreement records are displayed.

6. The seller, buyer and operator are stored for the contract agreement record in the database.

7. The first, previous, next and last records may be displayed using the appropriate buttons in the toolbar.

8. The Seller and Buyer dropdown lists of values will refer to the CUSTOMER and COST_CENTRE user parameters to display the customers for selection.

Set-up and Configuration No set-up/configuration required


Customer Ref: SCR-003

OBS Log Number: 336595
Reporter: Phil White
Summary of Call Default cust ref to OMS ref
Detail of Fix Default Customer Ref to OMS Ref when not provided on generation of orders.
Set-up and Configuration No set-up/configuration required


Customer Ref: 336863

OBS Log Number: 336863
Reporter: Michelle Naumovski
Summary of Call ORS - Select column order
Detail of Fix Allow users to determine the order in which the columns are displayed.
Set-up and Configuration No set-up/configuration required


Customer Ref: SCR-006

OBS Log Number: 336890
Reporter: Matthew Tipping
Summary of Call SCR-006 - Rework
Detail of Fix New fields called 'Driver', 'Carrier', 'Supplier', will be displayed in the 'Driver Debrief' tab page in the 'Trip Debrief' screen when the new system parameter called 'TRM_STACK_DEBRIEF' is set to 'Y' for the cost centre of the trip.
Set-up and Configuration
New Parameters
Parameter Name Config Level Setting Value Result
TRM_STACK_DEBRIEF COST_CENTRE Y New fields called 'Driver', 'Carrier', 'Supplier', 'Driver Delivery Instructions' and 'Unloading Comments' will be displayed in the 'Driver Debrief' tab page in the 'Trip Debrief' Screen.
TRM_STACK_DEBRIEF COST_CENTRE N The new fields will not be displayed


Customer Ref: 337123

OBS Log Number: 337123
Reporter: Hayley Keegan
Summary of Call Order status added to payment report
Detail of Fix Added order status to the payments_dtls report, the new column is after "order reference" before "transport"
Set-up and Configuration No set-up/configuration required


Customer Ref: 333896

OBS Log Number: 333896
Reporter: Sue Blake
Summary of Call Microlise Interface (Inbound/Outbound)
Detail of Fix New package DP_INT_XML_MIC2 to handle XML files to and from Microlise. Database triggers have been amended so that if MIC_SEND_DIRECT registry value set to Yes, outbound Microlise files are processed and sent directly to Microlise, using their file format, rather than the standard OBS format.
Set-up and Configuration
New Parameters
Parameter Name Config Level Setting Value Result
MIC_SEND_DIRECT NSS Y Flag to indicate that Direct communication to Microlise required
MIC_USE_STOP_ID Y Ensure stop id to get stop sequence
MIC_DIRECT_PATH_OUT NSS /webint/{DATABASE}/interface/MICD/OUT Outbound FTP directory
MIC_DIRECT_PATH_OUT_ARCH /webint/{DATABASE}/interface/MICD/OUT/archive Outbound FTP archive directory
MIC_DIRECT_PATH_IN /webint/{DATABASE}/interface/MICD/IN Inbound files ‘source’ directory
MIC_DIRECT_PATH_IN_FAIL /webint/{DATABASE}/interface/MICD/IN/failures Inbound ‘archive’ directory
MIC_DIRECT_PATH_IN_ARCH /webint/{DATABASE}/interface/MICD/IN/archive Inbound ‘failure’ directory
MIC_DIRECT_PATH_IN_LIST MICD_TRIP_FILES.lst
MIC_DIRECT_PATH_IN_SCRIPT MICD_TRIP_SCRIPT.ksh
MIC_DIRECT_DEF_COST NSS
MIC_DIRECT_PATH_IN_IDENT PODPOC* Expected file name for ‘PODPOC’ files
MICD_EE_PATH_IN_IDENT EventExport* Expected file name for ‘Event’ files
MICD_JSE_PATH_IN_IDENT JourneySummaryExport* Expected file name for ‘Journey Summary’ files
MIC_DIRECT_FTP_DEST_DIRECTORY \UAT\ToMicrolise Outbound destination ftp directory (ctms to Microlise)
MIC_DIRECT_FTP_DEST_IP_ADDRESS mmsftp2.microlise.com Outbound IP address (ctms to Microlise)
MIC_DIRECT_FTP_DEST_PASSWORD nh5uat Outbound IP login password (ctms to Microlise)
MIC_DIRECT_FTP_DEST_PORT 21 Outbound port (ctms to Microlise)
MIC_DIRECT_FTP_DEST_USERNAME NHSSCOTLANDUAT Outbound IP login username (ctms to Microlise)


Customer Ref: SH-A8XJSG

OBS Log Number: 334630
Reporter: Sarah Howells
Summary of Call RIO:Trigger ALC, MAR & LOA messages
Detail of Fix Trigger ALC, MAR and LOA messages to LOTS
Set-up and Configuration No set-up/configuration required


Customer Ref: SH-AARB5V

OBS Log Number: 336000
Reporter: Sarah Howells
Summary of Call RIO:Additional fields required for LOTS
Detail of Fix Added system parameter LOTS_VERSION_NUMBER and added <ACTUAL_RPE_QTY> when LOTS_VERSION_NUMBER is 300 or over
Set-up and Configuration No set-up/configuration required


Customer Ref: AR-AB5GUN

OBS Log Number: 336130
Reporter: Andrew Rowe
Summary of Call RIO:Support Barcode Scanning
Detail of Fix Additional field add to morning failed report, AR-AB5GUN Support Barcode Scanning
Set-up and Configuration No set-up/configuration required


Customer Ref: 336197

OBS Log Number: 336197
Reporter: Hayley
Summary of Call Cost Centre Segregation (4) - Carriers
Detail of Fix Data segregation by cost centre phase 4 - Trip manipulation planning screen to show cost centre specific carriers on carrier selection on new trip, carrier change and trip filter
Set-up and Configuration No set-up/configuration required


Customer Ref: SCR-336807-2

OBS Log Number: 336639
Reporter: DM
Summary of Call RIO: CTMS to MLS WMS Interface
Detail of Fix A new EDI process will need to be setup as follows:

Process Name: BNLMLS_PLAN_OUT

Filename Format: Planresultaat

Customer: As Customer (see FS)

Cost Centre Code: As Cost Centre (see FS)

Location: As Depot (see FS)

Direction: Outbound

Flow Type: PROCESS

Frequency Type: Interval

Interval Length: 2 Minutes

Delivery Folder: /webint/{DATABASE}/interface/ORDXML/{CUST}/OUT

Archive Folder: /webint/{DATABASE}/interface/ORDXML/{CUST}/OUT/archive

Failures Folder: /webint/{DATABASE}/interface/ORDXML/{CUST}/OUT/failures

Triggers: STATUS: ACCEPTED STATUS: TENDERED

Parameters: DELIMITER: PIPE ORDER_SOURCE_SYSTEM: As Source System (see FS)

Report Values: Title: Package Name Name: PROCESS Value: DP_BNL_EDI_OUT.P_PROCESS_PLAN Title: Process Name Name: pi_proc_name Value: BNLMLS_PLAN_OUT

The following directory structure will need to be setup:

/webint/{DATABASE}/interface/ORDXML/{CUST}/OUT /webint/{DATABASE}/interface/ORDXML/{CUST}/OUT/archive /webint/{DATABASE}/interface/ORDXML/{CUST}/OUT/failures

The OBS FTP Server will need to be setup to transfer the 'Plan' files from CTMS.

The external systems will need to be setup to receive the 'Plan' files from the OBS FTP Server.

A new system directory will need to be setup for the outbound EDI directory for the 'Plan' files.

Set-up and Configuration No set-up/configuration required


Customer Ref: SCR-336807-1

OBS Log Number: 336655
Reporter: JS
Summary of Call RIO: MLS WMS to C-TMS Interface
Detail of Fix

A new EDI process will need to be setup as follows:

Process Name: BNLMLS_ORDERS Filename Format: tms_sscc_CRE_*.dat Customer: As Customer (see FS) Cost Centre Code: As Cost Centre (see FS) Location: As Depot (see FS) Direction: Inbound Flow Type: PROCESS Frequency Type: Interval Interval Length: 2 Minutes

Delivery Folder: /webint/{DATABASE}/interface/ORDXML/{CUST}/IN

Archive Folder: /webint/{DATABASE}/interface/ORDXML/{CUST}/IN/archive

Failures Folder: /webint/{DATABASE}/interface/ORDXML/{CUST}/IN/failures

Parameters:

DEFAULT_DEL_TYPE: Standard DEFAULT_GROUP_NAME: As Group Name (see FS) DEFAULT_PROD_TYPE_ID: AMBIENT DEFAULT_SRCE_SYSTEM: As Source System (see FS) DELIMITER: | EARLY_AVAILABLE_TIME: 0000 LATE_AVAILABLE_TIME: 1200 USE_DIMENSIONS: Y

Report Values: Title: Package Name Name: PROCESS Value: DP_BNL_EDI_IN.P_PROCESS_FILES Title: Process Name Name: pi_proc_name Value: BNLMLS_ORDERS

The following static data will need to be setup:

Locations: Depot, Stores and Suppliers (see FS) Product Types: Ambient Despatch Unit Types: For Pallet Types (see FS) Source System: For Source System (see FS) Delivery Types: Standard Group Names: As Customer Group (see FS)

Import Decodes: BNLDIY_LOCATIONS: As Stores and Suppliers from Source System (see FS)

BNLDIY_XDOCK: Source Value: XD Target Value: As Depot (see FS)

The following tab page will need to be authorised for the appropriate user groups:

Form: Interface Errors Tab: BNL Orders In

The following directory structure will need to be setup:

/webint/{DATABASE}/interface/ORDXML/{CUST}/IN

/webint/{DATABASE}/interface/ORDXML/{CUST}/IN/archive

/webint/{DATABASE}/interface/ORDXML/{CUST}/IN/failures

The OBS FTP Server will need to be setup to transfer the 'Ship' files to CTMS.

The external systems will need to be setup to transfer the 'Ship' files to the OBS FTP Server.

Set-up and Configuration
New Access
Access Tab Name Description
BNL_ORDER_IN Interface Errors/BNL Orders In A new tab page for the 'BNL' orders recieved in the 'Ship' file for review and processing.


Customer Ref: SCR-336807-3

OBS Log Number: 336656
Reporter: JS
Summary of Call Delivery Note Print
Detail of Fix New Delivery Report, to be generated from the reports screen and the Planning Trip tree
Set-up and Configuration
New Access
Access Tab Name Description
BNL_DELIVERY New Report Added to Group Maintenance


New Parameters
Parameter Name Config Level Setting Value Result
DELIVERY_NOTE COST CENTRE BNL_DELIVERY Name of Delivery report to be generated from trip tree in the planning screen


Customer Ref: SCR-336807-5

OBS Log Number: 336657
Reporter: JS
Summary of Call Loading Meters
Detail of Fix The configurable layouts for the order items data block in the Order Details screen will be changed to include 3 extra columns for the length, width and height.

A new system parameter called ORD_EDIT_RPE will be available to configure by cost centre to allow the RPE quantity of the order lines in the Order Details screen to be edited.

A new system parameter called ORD_RPE_LM_FACTOR will be available to configure by cost centre to set a loading meter factor to calculate the RPE quantity of the order lines based on the dimensions of the DU types of the order items in preference to the RPE quantity of the DU types themselves (which should be set based on the loading meter factor).

The RPE quantity, weight and volume of the order lines will be based on the order items with reference to the system parameters for the manual order entry and maintenance and the processing of the EDI Ship file that provides the parent and child items for the orders.

See the functional specification for further information about the setup in CTMS and the OBS FTP Server.

Set-up and Configuration
New Parameters
Parameter Name Config Level Setting Value Result
ORD_EDIT_RPE COST_CENTRE Y The RPE column in the Order Details screen can be edited for the order lines.
ORD_EDIT_RPE COST_CENTRE N The RPE column in the Order Details screen cannot be edited for the order lines.
ORD_RPE_LM_FACTOR COST_CENTRE 2.4 The loading meter factor will be used to calculated the RPE of the order item for the length and width of the item should the dimensions of the item differ to the dimensions of the DU type of the item, if the dimensions do not differ then the RPE of the DU type will apply as at present.
ORD_RPE_LM_FACTOR COST_CENTRE NULL The RPE of the DU type of the order item will apply as at present.


Customer Ref: SCR-336807-4

OBS Log Number: 336963
Reporter: Dave Meir
Summary of Call CMR Print - pdf
Detail of Fix New CMR report to be run from Trip Planning screen for a single trip
Set-up and Configuration
New Access
Access Tab Name Description
CMR_NL New Report Added to group Maintenance


New Parameters
Parameter Name Config Level Setting Value Result
CMR_NOTE COST CENTRE CMR_NL Name of Delivery report to be generated from trip tree in the planning screen


Customer Ref: SCR-002 & 004

OBS Log Number: 336770
Reporter: Rob Merrill
Summary of Call Log for release of internal testing issue
Detail of Fix Changes to Threshold calculation and call-off-month.
Set-up and Configuration No set-up/configuration required


Customer Ref: SCR-13,14,16

OBS Log Number: 337543
Reporter: Ben Doft
Summary of Call Finance fixes coming from OBS testing
Detail of Fix Changes to the RPI application and calculation to improve accuracy, fix for ABOVE_DISTANCE application, invoice requirements creation
Set-up and Configuration No set-up/configuration required


Customer Ref: SCR-001

OBS Log Number: 336956
Reporter: Ben Doft
Summary of Call SCR-001 - Testing Issues
Detail of Fix Various changes to the screen:

1. Includes cost centre segregation for the Find functionality.

2. The 'x' button can be used to close windows that are called.

3. The red field background will be converted to grey and vice versa when the total weight is changed and assessed.

Set-up and Configuration No set-up/configuration required


Customer Ref: CR-18

OBS Log Number: 335812
Reporter: Tina Kinsella
Summary of Call CR18a: Additional Changes
Detail of Fix Fix for auto debrief on HOT and TNT
Set-up and Configuration No set-up/configuration required


Customer Ref: CR-16

OBS Log Number: 335931
Reporter: Paul Jones
Summary of Call CR-16 special characters
Detail of Fix Use driveruid rather than driverno for kpi query.
Set-up and Configuration No set-up/configuration required


Customer Ref: SCR-001

OBS Log Number: 336459
Reporter: Suzanne Woodcock
Summary of Call Release of agreements screen
Detail of Fix Format and Functional amendments to the Agreement screen to allow release excluding the Finance log
Set-up and Configuration No set-up/configuration required


SUPPORT INCIDENTS

Customer Ref: DF036

OBS Log Number: 334029
Reporter: Emily Collins
Summary of Call Paragon - reset new audit
Detail of Fix Created PAR_RESET_AUDIT table, SEQ_PAR_RESET_AUDIT sequence and modified PAR_INT form to store export parameters, user and date when reset new button is pressed.
Set-up and Configuration No set-up/configuration required


Customer Ref: 334812

OBS Log Number: 334812
Reporter: Julie Scott
Summary of Call Re-book Functionality
Detail of Fix Alternate rebook functionality.
Set-up and Configuration No set-up/configuration required


Customer Ref: INC13787271

OBS Log Number: 335391
Reporter: KELLY HEMBLING
Summary of Call Scheduling orders
Detail of Fix If business type planning is active, the trip will only be created if the payment can be created if there is not a missing charge condition, for example.

If business type planning is not active, the trip will be created if it is not being debriefed and there is not a missing chargeable condition, for example.

If the missing chargeable condition is a TRACTOR or a TRAILER TYPE, the audit message will include the text:

'a CHARGE does not include the TRACTOR,' or 'a CHARGE does not include the TRAILER TYPE,'.

The audit message will apply to the charges for the orders and the trips but it will only be displayed once if a total cost cannot be obtained.

If there are multiple charges that are available for the parties, each individual charge will not be listed to ensure that the error message can be displayed on screen.

Set-up and Configuration No set-up/configuration required


Customer Ref: 335395

OBS Log Number: 335395
Reporter: Julie Scott
Summary of Call Phase 3 - Cost Centre Segregation
Detail of Fix Data segregation by cost centre phase 3 - business data maintenance (group names, location zones, time zones), resources (trailers), account maintenance (currency codes) and system configuration (Printers)
Set-up and Configuration No set-up/configuration required


Customer Ref: 335421

OBS Log Number: 335421
Reporter: Zina Fahd
Summary of Call Automated Manifest at End of day
Detail of Fix Allow sysdate in ORS report
Set-up and Configuration No set-up/configuration required


Customer Ref: 335422

OBS Log Number: 335422
Reporter: Zina Fahd
Summary of Call Add suburb and post code to Trip Summary
Detail of Fix The database scripts will update the existing ORS formats to extract the extra columns in the following report types:

1. DEL_TRIPS

2. ORDLN_TYPE

3. SCHED_ORDS

4. STOPS

5. EX_ORDHEAD

6. EX_TRPSTOP

7. ORDER_ITEM

8. ORD_TYPE

9. EX_ORDITEM

The database scripts will only be effective in specific databases.

Set-up and Configuration No set-up/configuration required


Customer Ref: 335560

OBS Log Number: 335560
Reporter: MICHELLE NAUMOVSKI
Summary of Call Showing CUST CLIENT CODES and shouldn't
Detail of Fix 1) Show correct LOV options for customer client code relevant to the customer on the order.

2) When customer is changed refresh the population of the from location LOV.

Set-up and Configuration No set-up/configuration required


Customer Ref: 335576

OBS Log Number: 335576
Reporter: Michelle Naumovski
Summary of Call Portal events out of sequence
Detail of Fix If the new system parameter called 'LOTS_PREVENT_MULTI_VLI_VUI' is set to 'Y' then the 'VLI' and 'VUI' files for LOTS/Portal will only be re-sent for an order on a trip should either of the actual arrival or actual departure times be set for the first time for the trip stop. A file can be sent twice for the same order on the same trip but only of the actual times are set separately.

If the new system parameter does not exist or it is set to 'N' then multiple files will be generated whenever the actual arrival or actual departure time is updated for the trip stop.

Set-up and Configuration
New Parameters
Parameter Name Config Level Setting Value Result
LOTS_PREVENT_MULTI_VLI_VUI SYSTEM Y The 'VLI' and 'VUI' files for LOTS/Portal will only be re-sent for an order on a trip should either of the actual arrival or actual departure times be set for the first time for the trip stop. A file can be sent twice for the same order on the same trip but only of the actual times are set separately.
LOTS_PREVENT_MULTI_VLI_VUI SYSTEM N Multiple files will be generated whenever the actual arrival or actual departure time is updated for the trip stop.


Customer Ref: 335694

OBS Log Number: 335694
Reporter: Peter Blackburn
Summary of Call Clear from/to locn on new customer
Detail of Fix For environments with locations related to selected customer, the LOV for from/to location is updated when a new customer is entered. Amendment will also clear existing locations from the order if the customer is updated.
Set-up and Configuration No set-up/configuration required


Customer Ref: 335799

OBS Log Number: 335799
Reporter: Peter Blackburn
Summary of Call Default Order From Location
Detail of Fix Select order collect from user param from location id instead of name. Set up order entry deliver to location LOV if using defaulted collect from location id.
Set-up and Configuration No set-up/configuration required


Customer Ref: 335421

OBS Log Number: 335825
Reporter: Paul Jones
Summary of Call Automated Manifest at end of day (rwk)
Detail of Fix Reset sysdate parameters
Set-up and Configuration No set-up/configuration required


Customer Ref: 335903

OBS Log Number: 335903
Reporter: Hayley Keegan
Summary of Call OOH: Issue entering orders
Detail of Fix Issue with order entry and the delivery location being blanked out, identified cause and applied fix
Set-up and Configuration No set-up/configuration required


Customer Ref: 335913

OBS Log Number: 335913
Reporter: Michelle Naumovski
Summary of Call Segregate NZ & AUS trips while x docking
Detail of Fix Amendment to Trip screen to remove the debug message and segregate the trips a user may select at cross dock
Set-up and Configuration No set-up/configuration required


Customer Ref: 335924

OBS Log Number: 335924
Reporter: Peter Blackburn
Summary of Call Phase 4 - Cost Centre Segregation
Detail of Fix Amendment for cost centre segregation to location maintenance form so LOV for suburb and post_code is limited to the appropriate country.
Set-up and Configuration No set-up/configuration required


Customer Ref: 336145

OBS Log Number: 336145
Reporter: Hayley Keegan
Summary of Call Add cost centre to Invoicing report (ORS)
Detail of Fix Segregate by cost centre
Set-up and Configuration No set-up/configuration required


Customer Ref: 336158

OBS Log Number: 336158
Reporter: Hayley Keegan
Summary of Call Ensure Tailgate charges are generated
Detail of Fix NVL tailgate flag to N on services trigger
Set-up and Configuration No set-up/configuration required


Customer Ref: 336296

OBS Log Number: 336296
Reporter: Dave Meir
Summary of Call Prevent all unscheduled orders in well
Detail of Fix A Sched From date must be present to select the unscheduled orders for the order well to ensure that the data is queried quickly.
Set-up and Configuration No set-up/configuration required


Customer Ref: 336374

OBS Log Number: 336374
Reporter: Peter Blackburn
Summary of Call Trip Planning screen order well handling
Detail of Fix Amendment to trip planning options (TRIPSUM/PLANNING) so that when the user drops into the orders form to view/change and order, return to the trip screen focuses back on the correct order in the well.
Set-up and Configuration No set-up/configuration required


Customer Ref: 336552

OBS Log Number: 336552
Reporter: Julie Scott
Summary of Call Supporting Docs fail to ftp
Detail of Fix Fix parameters on FTP call for Supporting documents.
Set-up and Configuration No set-up/configuration required


Customer Ref: 336580

OBS Log Number: 336580
Reporter: Michelle Naumovski
Summary of Call Pick Qty not mandatory for Portal orders
Detail of Fix For portal orders, do not validate pick qty in fast order entry mode.
Set-up and Configuration No set-up/configuration required


Customer Ref: 336671

OBS Log Number: 336671
Reporter: Michelle Naumovski
Summary of Call Cost centre segregation - Location screen
Detail of Fix Cost Centre Segregation - amendment to location maintenance screen so users can only see locations applicable to their user parameter cost centre
Set-up and Configuration No set-up/configuration required


Customer Ref: ITINC0049954

OBS Log Number: 336677
Reporter: James Hutton
Summary of Call Barcodes are being deleted
Detail of Fix Allow pulse orders to be amended after order issued, retain T2A information if order issued multiple times.
Set-up and Configuration No set-up/configuration required


Customer Ref: Tailgate WGlove

OBS Log Number: 336679
Reporter: Hayley Keegan
Summary of Call Tailgate charges missing on Portal WG
Detail of Fix Identified issue for portal orders, trigger only firing on UPDATE and not INSERT
Set-up and Configuration No set-up/configuration required


Customer Ref: 336810

OBS Log Number: 336810
Reporter: Michelle Naumovski
Summary of Call Include hours on Tailgate charge
Detail of Fix Tailgate charges calculated based on the number of hours entered.
Set-up and Configuration No set-up/configuration required


Customer Ref: 336924

OBS Log Number: 336924
Reporter: Matthew Tipping
Summary of Call Copy orders not working
Detail of Fix Fixed entering time duplicate_order screen causing crash.
Set-up and Configuration No set-up/configuration required


Customer Ref: INC14665794

OBS Log Number: 336970
Reporter: Brett Court
Summary of Call Master & Child Issue
Detail of Fix Restrict LOV to master locations if system parameter set.
Set-up and Configuration No set-up/configuration required


Customer Ref: Microlise Event

OBS Log Number: 336976
Reporter: D. Meir
Summary of Call Microlise Events files - failed by C-TMS
Detail of Fix New system parameter MIC_DIRECT_UPDATE_PRIORITY to control the population of actual arrival and delivery dates.

Use new fields journeyDropRef to get stop sequence, and latitude and longitude to populate arrival and departure long and lat.

Set-up and Configuration
New Parameters
Parameter Name Config Level Setting Value Result
MIC_DIRECT_UPDATE_PRIORITY NSS MEP Indicates priority of population of Actual Deliver and Arrival.

M - Manual E - EventExport P - PODPOC

So using this order, if date populated by PODPOC message, and an EventExport message recieved with different date, the date will be over written.

However, if the date was keyed in manually, it will not be overwritten


Customer Ref: INC14705705

OBS Log Number: 337038
Reporter: Brett Court
Summary of Call Unauthorised Location Update
Detail of Fix Is user changes content of a Master Location, prevent close/next record etc. whilst records has been changed. User must toggle the master location to enable the save button or cancel the change.
Set-up and Configuration No set-up/configuration required


Customer Ref: 337100

OBS Log Number: 337100
Reporter: Michelle
Summary of Call OOH cannot create orders
Detail of Fix Amendment to services update for DG order lines, if order has more than one dangerous goods order line.
Set-up and Configuration No set-up/configuration required


Customer Ref: INC14748025

OBS Log Number: 337133
Reporter: Marta Iglik
Summary of Call Unable to extract the report
Detail of Fix The number of assets on the system is too great for the drop down list. This has been changed to a lookup selection instead.
Set-up and Configuration No set-up/configuration required


Customer Ref: 337152

OBS Log Number: 337152
Reporter: Graham Rothwell
Summary of Call Portal/C-TMS error
Detail of Fix Always get schedule from trip for LOTS messages
Set-up and Configuration No set-up/configuration required


Customer Ref: 337170

OBS Log Number: 337170
Reporter: Dave Meir
Summary of Call Planning Screen - Freetext Resource
Detail of Fix New trip sheet using schedule
Set-up and Configuration No set-up/configuration required


Customer Ref: 337184

OBS Log Number: 337184
Reporter: Michelle Naumovski
Summary of Call Incorrect To Route and Scheduling
Detail of Fix Ensure correct radial / suburb are applied to new locations.
Set-up and Configuration No set-up/configuration required


Customer Ref: INC14737834

OBS Log Number: 337205
Reporter: Suzie Maskery
Summary of Call Unable to load scan at delivery point
Detail of Fix Increased size of store_array_no from 100 to 200, increased size of store_array_name from 200 to 480 in C-TMS and WCS interface message 442, along with t_store_no_out was increased with corresponding substring and rpad sizes.
Set-up and Configuration No set-up/configuration required


Customer Ref: INC14786002

OBS Log Number: 337209
Reporter: Damian Tobjasz
Summary of Call Trip Manipulation slow response
Detail of Fix A Sched From date must be present to select the unscheduled orders for the order well to ensure that the data is queried quickly.
Set-up and Configuration No set-up/configuration required


Customer Ref: 337348

OBS Log Number: 337348
Reporter: HAYLEY KEEGAN
Summary of Call OOH error setting trip to accepted
Detail of Fix Amendment to process called when order total dry ice is changed and the order services are updated - either as a new service record or an update to an existing one.
Set-up and Configuration No set-up/configuration required


Customer Ref: 337350

OBS Log Number: 337350
Reporter: Michelle Naumovski
Summary of Call OOH SYD DAILY P/U Scheduling Query
Detail of Fix The scheduling engine has been changed to handle exceptional errors that invalidate the savepoints and thus do not rollback the data for orders that have been partially scheduled.

The orders will then not be at SCHED_COLL status. The audit records will indicate that the order has been unsuccessfully scheduled. If an order is partially scheduled and it cannot be rolled back successfully, the order will remain at status SCHED_COLL but an appropriate audit record will be created for reference. The exceptional error is being triggered by a process external to the scheduling engine so the scheduling engine has been changed to account for such failures to ensure that the orders are reset if possible.

Set-up and Configuration No set-up/configuration required


Customer Ref: 337352

OBS Log Number: 337352
Reporter: Michelle Naumovski
Summary of Call Unscheduled order still appearing in MCS
Detail of Fix Amendment to process called when order total gel packs is changed so when updating the order services the WETICE record is inserted or updates an existing one for the order.
Set-up and Configuration No set-up/configuration required


Customer Ref: 337353

OBS Log Number: 337353
Reporter: Michelle Naumovski
Summary of Call Query: MTS_OWNER.PK_ORDER_ITEMS_REASON
Detail of Fix Amendment to the scanning package to remove the check on drop sequence when adding a package to a pallet and removing the package from the trip.
Set-up and Configuration No set-up/configuration required


Customer Ref: 337375

OBS Log Number: 337375
Reporter: Paul Jones
Summary of Call Error messages in Planning & Waterfall
Detail of Fix Issues with Planning form when configured for specific customer. Also changes to Location for inventory creation. Additionally get Delivery form working for Store to Plant.
Set-up and Configuration No set-up/configuration required


Customer Ref: 337393

OBS Log Number: 337393
Reporter: Peter Blackburn
Summary of Call Log to Release SCHED_RULES form
Detail of Fix Correction to Cost Centre Segregation on the schedule rules form for data query build for combinations of system parameter and users own customer and cost centre parameters.
Set-up and Configuration No set-up/configuration required


Customer Ref: BEN-TRAIN02

OBS Log Number: 337446
Reporter: Dave Meir
Summary of Call Trip Sheet
Detail of Fix New Trip sheet TRIP_SHEET_BNL
Set-up and Configuration No set-up/configuration required


TID CHANGES

OBS Log Number: 335403

Customer Ref:
Reporter: Kelly Hembling
Summary of Call Report running slow
Detail of Fix The NR Finance extract has been changed to query the data by trip and then by order to increase the rate of production when including debriefed trips and non-debriefed trips.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 335407

Customer Ref:
Reporter: Kelly Hembling
Summary of Call NR Finance Extract
Detail of Fix The Total Revenue, Total Revenue Excluding Fuel and Margin columns for the NR Finance and Invoice extracts (except Margin is not displayed for the Invoice extract) will include the revenue override amount from the order charge and the matrix rate for the trip revenue columns.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 335495

Customer Ref:
Reporter: Terry Mann
Summary of Call No error message when creating duplicate
Detail of Fix The following tab pages in the Resource Maintenance screen have been changed to prevent any duplicate records being entered:

Carriers

Carrier Groups

Carrier Types

Carrier Service Level

Fixed Charges

Service Types

Trailer Types (in combination with temp/group)

Loc Prd Conv

Despatch Unit Types

Standardised DUs

RPEs

The DU Type field for the Despatch Unit Types cannot be edited so that it can be changed.

The Standardised DUs will be saved upon entry, change or deletion automatically.

Set-up and Configuration No set-up/configuration required


OBS Log Number: 335656

Customer Ref:
Reporter: Suzie Maskery
Summary of Call Unload claim scan not sent
Detail of Fix Find latest return order based upon the provided asset id and assume this is the order being unload scanned.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 335682

Customer Ref:
Reporter: Terry Mann
Summary of Call Identifier reference stripping
Detail of Fix The file to Microlise will only remove a suffix from the item identifiers if the format is '-NNNN' with numbers between '0001' and '9999'.

The file from Microlise will not remove any characters from and item identifier should a hyphen be detected based on the assumption that an asset being scanned will not provide a suffix.

Set-up and Configuration No set-up/configuration required


OBS Log Number: 335692

Customer Ref:
Reporter: Terry Mann
Summary of Call Actual despatched not populating
Detail of Fix To Be Confirmed:

Changes are expected to be made for the interface between Microlise and Link to assess hyphens differently for some XML items. The asset codes will be assessed differently during WCS scanning for loading and unloading, Microlise files and Trip Debrief. The OBS suffix for assets will be removed if the format ends in '-NNNN' where 'NNNN' is between '0001' and '9999'. The data will be retained should hyphens be used in the item identifier codes as loose items or reusable assets except that the OBS suffix will be removed for asset processing and scanning. The actual despatched quantities of the order lines and items will be set to 1 from the order items file and any unscanned order lines and items will only be set to 0 if the order line has a NULL quantity.

Set-up and Configuration No set-up/configuration required


OBS Log Number: 335851

Customer Ref:
Reporter: Suzie Maskery
Summary of Call The delivery order file has failed
Detail of Fix The sequence number and the asset details and history will be created for new child assets.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 335932

Customer Ref:
Reporter: Sarah Howells
Summary of Call LOTS displaying incorrect item code
Detail of Fix Send alternate item id to LOTS
Set-up and Configuration No set-up/configuration required


OBS Log Number: 335935

Customer Ref:
Reporter: Paul Roscoe
Summary of Call Check digit updates / Microlise updates
Detail of Fix The 804 messages will add the check digit if the full barcode with the check digit has not been scanned because the keyed item code will not include the check digit.

A space check digit will be assessed as a space for an existing item on the order but it will only be added to the item should the MODULO_43 decoded values not include NULL for a SPACE. The outbound files to Microlise will add a space check digit to the item if it has not been stored in C-TMS and WCS. The inbound files from Microlise will update the to deliver and delivered quantities for the items on the order if the item has a pallet but the pallet has not been provided by Microlise.

Set-up and Configuration No set-up/configuration required


OBS Log Number: 336061

Customer Ref:
Reporter: Susy Maskery
Summary of Call Claims file not creating
Detail of Fix Remove status check for unscheduled orders
Set-up and Configuration No set-up/configuration required


OBS Log Number: 336078

Customer Ref:
Reporter: Suzie Maskery
Summary of Call Order not updating correctly
Detail of Fix Add parent item to configurable layout, ensure claims records created if parent item has no content.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 336117

Customer Ref:
Reporter: Hayley Keegan
Summary of Call ORS_SYSDATE - Report does not work
Detail of Fix The date ranges can be entered using offsets and validation will be performed on the calculated dates. The ORS file can be produced via the screen or via an EDI process via an email.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 336157

Customer Ref:
Reporter: Hayley Keegan
Summary of Call ORS_DELIMITER Must be a pipe character
Detail of Fix The system parameter ORS_DELIMITER will be used as the separator of the values in the ORS extract files whether they be generated via the ORS maintenance screen or via an EDI process.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 336177

Customer Ref:
Reporter: Ben Doft
Summary of Call CR18-T2A Removing an item
Detail of Fix Not updating last reason code in items string
Set-up and Configuration No set-up/configuration required


OBS Log Number: 336181

Customer Ref:
Reporter: Suzie Maskery
Summary of Call Claims files not producing
Detail of Fix Claims file not produced when parent id has no suffix
Set-up and Configuration No set-up/configuration required


OBS Log Number: 336261

Customer Ref:
Reporter: Paul Roscoe
Summary of Call Include pack description for item
Detail of Fix The item description will include the pack description as well as the shipment and delivery numbers from the order item files via the EDI interface.

If a pack description is not mapped for the AKA code of the item, the pack description will not be present in the item description.

Set-up and Configuration No set-up/configuration required


OBS Log Number: 336289

Customer Ref:
Reporter: Roger Egdell
Summary of Call CR18-T2A despatch
Detail of Fix Change to T2A to list despatched qty correctly after despatch.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 336298

Customer Ref: CR-22-CL stop
Reporter: Paul Jones
Summary of Call CR-22: Depart time on the CL stop
Detail of Fix Changes to geo-fence processing at SU and CL in case geo-fence is not broken as vehicle starts or stays within depot area.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 336299

Customer Ref:
Reporter: Sarah Howells
Summary of Call Trip Planning - Create New Trip
Detail of Fix Retain carrier selected for trips in the Trip Planning Screen.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 336319

Customer Ref:
Reporter: Sarah Howells
Summary of Call Interface Errors screen - date/time
Detail of Fix The Interface Errors screen will pre-populate the Start and End dates and times for the previous 24 hours for the XML Trip and XML Outbound tab pages when they are opened as per the XML Orders tab page, for example.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 336323

Customer Ref:
Reporter: Damian Jackson
Summary of Call Trip Planning screen handling
Detail of Fix Amendment to trip planning screen so when mouse clicking on an unscheduled order in the well the focus is kept on the selected order, at the same point in the list.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 336331

Customer Ref:
Reporter: Kate Hunter
Summary of Call Driver Scanning Report query changes
Detail of Fix The queries for the Driver Scanning file have been change to increase the rate of production.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 336412

Customer Ref:
Reporter: Dave Meir
Summary of Call Add Trailer type to outbound message
Detail of Fix Add trailer type segment to outbound message.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 336457

Customer Ref:
Reporter: Denis Starodubov
Summary of Call Unpacked order email notification
Detail of Fix Increase size of field to prevent failures when sending multiple emails
Set-up and Configuration No set-up/configuration required


OBS Log Number: 336487

Customer Ref:
Reporter: Paul Jones
Summary of Call CR18-cTMS Signature etc
Detail of Fix Hostiptal Own Transport signature display
Set-up and Configuration No set-up/configuration required


OBS Log Number: 336513

Customer Ref:
Reporter: Dave Meir
Summary of Call Use stop id to populate journeydropref
Detail of Fix Archive inbound files correctly so duplicate file error removed

Use stop id rather than stop no to populate 'journeydropref' in outbound message.

Set-up and Configuration No set-up/configuration required


OBS Log Number: 336524

Customer Ref:
Reporter: Dave Meir
Summary of Call Use journeydropref to get stop id
Detail of Fix Amend the inbound PODPOC message to get stop no using the stop id, which is stored in the 'journeydropref' field.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 336557

Customer Ref:
Reporter: Denis Starodubov
Summary of Call LOAD message to Unison
Detail of Fix The trip file will be generated at the specified status (e.g. TENDERED for a LOAD message) for the EDI process parameter.

The file will include the orders on the trip that satisfy the EDI fields and parameters (e.g. customer, location, ORDER_SOURCE_SYSTEM). The file will be regenerated if the planned times at the loading location are changed when the trip is at the specified status. The file will also be regenerated when appropriate orders are added to the trip at the specified status.

Set-up and Configuration No set-up/configuration required


OBS Log Number: 336568

Customer Ref:
Reporter: Dave Potter
Summary of Call Fix seq bug in 336524
Detail of Fix Fix issue where trip has legs added by the addition of collection legs. Ensure that the the 2nd, 3rd, 4th etc collection legs are added to the trip.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 336591

Customer Ref:
Reporter: Dave Meir
Summary of Call Amend journeysitenote in outb microlise
Detail of Fix Amend the calculation of the 'journeySiteNote'.

Modify the logic so that for the SU stop 1, the journey site note is populated from the Trip General Comments. If there are no records then don't generate the tag for the SU stop 1. Remove the hard-code 'ORDERS:' that is not needed.

For each successive site visit (stop in C-TMS) include the special instructions for the order or orders on the stop. Again remove any CRLF and replace with space, deal with special characters like & and £. If more than one order on the stop then concatenate the special instructions and separate with a space. Leave out the tag altogether if no special instructions on the order. Remove the hard-code 'ORDERS:' that is not needed.

Set-up and Configuration No set-up/configuration required


OBS Log Number: 336616

Customer Ref:
Reporter: Dave Potter
Summary of Call Fix bug with 336591
Detail of Fix Ensure that 'journeySiteNote' are correctly displayed in outbound file. Ensure that stop_seq is correctly populated.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 336643

Customer Ref:
Reporter: Emily Collins
Summary of Call Don't gen files if ftp connection failed.
Detail of Fix Ensure outbound JourneyScheduleImport files are not created if the system can not connect to outbound ftp. Also for outbound messages, only write <resource> record for trailer id if it is different from tractor id. This will stop Microlise rejecting the file for containing duplicate tags.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 336673

Customer Ref:
Reporter: N Robinson
Summary of Call No routes found in step 4
Detail of Fix Find fixed routes for deliveries at the depot.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 336676

Customer Ref:
Reporter: Dave Meir
Summary of Call Dont report blank trailer ID's
Detail of Fix Change package so outbound JourneyScheduleImport file doesnt create a <resource> segment for trailer id when they are blank.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 337117

Customer Ref: SCR-018 rework
Reporter: Rob Merrill
Summary of Call Raised for testing issues fixes
Detail of Fix Couple of minor issues found during testing for monthly interface.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 337206

Customer Ref:
Reporter: Andy Rowe
Summary of Call Trip debrief truncation - item desc'
Detail of Fix Increased the size of item_description on form TRIPDTL to match the size of item_description on the sch_ord_items table
Set-up and Configuration No set-up/configuration required


OBS Log Number: 337297

Customer Ref:
Reporter: Andy Rowe
Summary of Call PODPOC not applying
Detail of Fix The size of item_description on the xml orders tab, had its size set incorrectly compared to sch_ord_items table its size has been set to match this value, this has removed the truncation errors
Set-up and Configuration No set-up/configuration required


OBS Log Number: 337359

Customer Ref: Delivery note sort
Reporter: Dave Meir
Summary of Call Change delivery note sort order
Detail of Fix Amendment to delivery note to change the sort order
Set-up and Configuration No set-up/configuration required


OBS Log Number: 337388

Customer Ref: scr-018 rework
Reporter: Ben Doft
Summary of Call Raised for testing issue fixes
Detail of Fix Changes to Debrief for customer stack processing.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 337506

Customer Ref:
Reporter: Paul Roscoe
Summary of Call Release of database scripts for CMR
Detail of Fix Database scripts will be run to allow the CMR Note to be configured for the appropriate cost centres and user groups.
Set-up and Configuration No set-up/configuration required
New Access
Access Tab Name Description
CMR_NL New report Added to Group Maintenance


New Parameters
Parameter Name Config Level Setting Value Result
CMR_NOTE COST CENTRE CMR_NL.rep Name of Delivery report to be generated from trip tree in the planning screen


OBSL PRODUCT DEVELOPMENT

OBS Log Number: 334030

Reporter: Emily Collins
Summary of Call Performance in interface errors screen
Detail of Fix Implemented a change so when users open error correction on the xml order tab they will be returned to the next order, aswell removed unnecessary upper functions in the search condtion, and expanded location and date columns
Set-up and Configuration No set-up/configuration required


OBS Log Number: 335337

Reporter: Julie Scott
Summary of Call ORS - Export Reports
Detail of Fix The ORS reports have had the following reports added CUST_DATA, CUST_FUELC, CUST_FUEL, CUST_SEC, CUST_SEC_C, CUST_PREFS, CUST_CHRGS, CUST_SCHED, CUST_COST, CUST_PAIN, DU_TYPES, CONTRACTS, CONT_JRNY OWN_CHRGS, RPE_CUST, FIX_ROUTE, CARR_SHIP, CARR_DUS, CARR_PRODS, CARR_COMMS, CARR_CLASS, CARR_ROUTE, ORD_OFFSET, NETWORK
Set-up and Configuration No set-up/configuration required


OBS Log Number: 335501

Reporter: Julie Scott
Summary of Call CTMS Data Uploads - from CSV
Detail of Fix Additional CSV import options for Customers, Drivers, Region data, Region depot, Accounts, Invoice requirements and Currency Usage.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 335697

Reporter: LBW
Summary of Call 12c system testing
Detail of Fix Changes to replace single quotes in the reports screen with double quotes for 12c
Set-up and Configuration No set-up/configuration required


OBS Log Number: 335725

Reporter: Graham Rothwell
Summary of Call LOTS messages sent with no owner
Detail of Fix Do not send LOTS message with no owner when a non-conformance is added to an order for a non-LOTS customer.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 335861

Reporter: Dave Meir
Summary of Call Issues with - delimiters and checkdigits
Detail of Fix A new record will need to be added to the MODULO_43 decode name as follows to override the SPACE check digit as a NULL value: Source Value = NULL

Target Value = SPACE Related changes to WCS will be required to be implemented for log 335862. This development will allow a hyphen to be used to identify the OBS suffix for the assets should there also be a customer suffix in the same format. Any other item codes will retain a hyphen. The check digit for the non-asset items will not be stored should the check digit be a space character: the space will then not be displayed in C-TMS nor will it be used in WCS. The check digit of a space character will be included in the Microlise interface file for validating the scans of the barcodes for collection and delivery activities.

Set-up and Configuration No set-up/configuration required


OBS Log Number: 336188

Reporter: Paul Roscoe
Summary of Call Main version for branch for log 335495
Detail of Fix Main version for changes for branched version of the Resource Maintenance screen for log 335495.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 337040

Reporter: Suzanne Woodcock
Summary of Call Log to release orders screen
Detail of Fix Order screen changes to show self bill revenue as a cost, part of original finance changes in log 333092.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 337229

Reporter: Emily Collins
Summary of Call EDI screen audit
Detail of Fix Added auditing for the Start/Stop buttons on the EDI Maintenance screen, records are stored on the EDI_AUDIT table.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 337337

Reporter: Dave Meir
Summary of Call Changes from branch 337335
Detail of Fix Cosmetic changes to the planning screen and add CMR note menu item
Set-up and Configuration No set-up/configuration required


OBS Log Number: 337417

Reporter: Rob Merrill
Summary of Call Amendments to waterfall screen (Depot)
Detail of Fix Control depot drop down list and trips shown based upon the users based at.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 337519

Reporter: Paul Jones
Summary of Call 12c issue spaces in URL
Detail of Fix Replace spaces in Reports URL with %20 to ensure reports run in oracle 12c
Set-up and Configuration No set-up/configuration required


MODULES DELIVERED

Module Name Version No Description Log Number
ACC.sql 5.42 Accounts package 336459
ACC.sql 5.44 Accounts package 336377
ACC.sql 5.45 Accounts package 335409
ACC.sql 5.46 Accounts package 337543
ACC_MAINT.fmx 2.65 Accounts Maintenance 335409
ACC_MAINT.fmx 2.66 Accounts Maintenance 336149
ACC_MAINT.fmx 2.67 Accounts Maintenance 336377
AGR.sql 1.1 Agreements Package 333089
AGR.sql 1.2 Agreements Package 336378
AGR.sql 1.3 Agreements Package 336459
AGR.sql 1.4 Agreements Package 336537
AGR.sql 1.5 Agreements Package 337543
AGREEMENTS.fmx 2.13 Agreements Screen 336537
AGREEMENTS.fmx 2.16 Agreements Screen 336572
AGREEMENTS.fmx 2.17 Agreements Screen 336956
AGREEMENTS.fmx 2.3 Agreements Screen 333089
AGREEMENTS.fmx 2.4 Agreements Screen 336378
AGREEMENTS.fmx 2.6 Agreements Screen 336459
ASSET.sql 5.3 Asset Procedures 335692
AT_2_CNT_AGREEMENT_333089.sql 1.1 Alter Table Script 333089
AT_ACC_ACCOUNT_333089.sql 1.1 Alter Table Script 333089
AT_ACC_CURRENCY_335395.sql 1.1 Alter Table Script 335395
AT_ACC_PAYMENT_333092.sql 1.1 Alter Table Script 333092
AT_ACC_PAYMENT_TYPE_333092.sql 1.1 Alter Table Script 333092
AT_ACC_PAYMENT_TYPE_335409.sql 1.1 Alter Table Script 335409
AT_ACC_PAYMENT_TYPE_335409.sql 1.1 Alter Table Script 336459
AT_ACC_PRICE_INDEX_336377.sql 1.1 Alter Table Script 336377
AT_CNT_AGREEMENT_333089.sql 1.2 Alter Table Script 333089
AT_CNT_AGREEMENT_AUDIT_333089.sql 1.1 Alter Table Script 333089
AT_CNT_AGREEMENT_FORECAST_336537.sql 1.1 Alter Table Script 336537
AT_CNT_CHARGE_TIER_333089.sql 1.3 Alter Table Script 333089
AT_CNT_TIER_NAME_333089.sql 1.1 Alter Table Script 333089
AT_GEO_LOC_TYPE_333090.sql 1.1 Alter Table Script 333090
AT_GEO_LOCATION_333090.sql 1.1 Alter Table Script 333090
AT_GEO_LOCATION_ZONE_335395.sql 1.1 Alter Table Script 335395
AT_MSG_SMS_AUDIT_336457.sql 1.1 Alter Table Script 336457
AT_ORG_CUSTOMER_334630.sql 1.1 Alter Table Script 334630
AT_ORS_USER_DETAILS_336863.sql 1.1 Alter Table Script 336863
AT_PRD_COMMODITY_336006.sql 1.1 Alter Table Script 336006
AT_RES_CARRIER_333095.sql 1.1 Alter Table Script 333095
AT_RES_TRAILER_335395.sql 1.1 Alter Table Script 335395
AT_SCH_ORD_333091.sql 1.1 Alter Table Script 333091
AT_SCH_ORD_NON_CONFORM_333091.sql 1.1 Alter Table Script 333091
AT_SCH_ORDER_LINE_333091.sql 1.1 Alter Table Script 333091
AT_SCH_TRIP_333091.sql 1.1 Alter Table Script 333091
AT_SCH_TRIP_STOP_333091.sql 1.2 Alter Table Script 333091
AT_TIME_ZONE_MASTER_335395.sql 1.1 Alter Table Script 335395
AT_TMP_CNT_TIER_NAME_336537.sql 1.1 Alter Table Script 336537
AT_TOM_DRIV_GROUP_335931.sql 1.1 Alter Table Script 335931
AT_TOM_DRIVER_KPI_335931.sql 1.1 Alter Table Script 335931
BDM.fmx 2.87 Business Data Form 333090
BDM.fmx 2.89 Business Data Form 335395
BDM.fmx 2.90 Business Data Form 336770
BNL_DELIVERY.rep 1.2 Delivery Report 336656
BNL_DELIVERY.rep 1.3 Delivery Report 337359
BNL_DELIVERY.rep 1.4 Delivery Report 336963
CALENDAR.fmx 1.5 Calendar Pop-Up 336595
CMR_NL.rep 1.2 CMR Report 336963
CNT.sql 5.38 Contracts package 335391
CNT.sql 5.39 Contracts package 336377
CONTRACT.fmx 2.57 Contracts Form 335409
CT_ACC_PRICE_INDEX_333089.sql 1.1 Create Table Script 333089
CT_ACC_PRICE_INDEX_333092.sql 1.1 Create Table Script 333092
CT_ACC_PRICE_INDEX_EFFECTIVE_333092.sql 1.1 Create Table Script 333092
CT_CNT_AGREEMENT_333089.sql 1.2 Create Table Script 333089
CT_CNT_AGREEMENT_AUDIT_333089.sql 1.3 Create Table Script 333089
CT_CNT_AGREEMENT_FORECAST_333089.sql 1.2 Create Table Script 333089
CT_CNT_AGREEMENT_INDEX_333089.sql 1.1 Create Table Script 333089
CT_CNT_AGREEMENT_INDEX_333092.sql 1.2 Create Table Script 333092
CT_CNT_AGREEMENT_INDEX_335409.sql 1.1 Create Table Script 335409
CT_CNT_AGREEMENT_INDEX_335409.sql 1.1 Create Table Script 336459
CT_CNT_RHA_CONFIG_335409.sql 1.1 Create Table Script 335409
CT_CNT_RHA_CONFIG_335409.sql 1.1 Create Table Script 336459
CT_CNT_RHA_INDEX_335409.sql 1.1 Create Table Script 335409
CT_CNT_RHA_INDEX_335409.sql 1.1 Create Table Script 336459
CT_CNT_SERVICE_CHARGES_336149.sql 1.1 Create Table Script 336149
CT_CNT_SERVICE_CONTRACTS_336149.sql 1.1 Create Table Script 336149
CT_EDI_AUDIT_337229.sql 1.1 Create Table Script 337229
CT_GEO_LOC_ENTRIES.sql 1.1 Create Table Script 333090
CT_GEO_LOC_ENTRIES_AUDIT_333090.sql 1.4 Create Table Script 333090
CT_GEO_LOC_INFORMATION_333090.sql 1.4 Create Table Script 333090
CT_GEO_LOC_NOTE_TYPE_333090.sql 1.2 Create Table Script 333090
CT_GEO_LOC_STORAGE_TYPE_333090.sql 1.1 Create Table Script 333090
CT_IMP_LOAD_AUDIT_333095.sql 1.10 Create Table Script 333095
CT_INT_BNL_ORDERS_DETAIL_336655.sql 1.1 Create Table Script 336655
CT_INT_BNL_ORDERS_HEADER_336655.sql 1.1 Create Table Script 336655
CT_INT_BWSC_DEBRIEF_ORD_336151.sql 1.1 Create Table Script 336151
CT_PAR_RESET_AUDIT_334029.sql 1.1 Create Table Script 334029
CT_RES_TRAILER_PRODUCT_333095.sql 1.2 Create Table Script 333095
CT_SCH_TRIP_STOP_SIGNATURE_330260.sql 1.1 Create Table Script 330260
CT_SEQ_CNT_AGREEMENT_333089.sql 1.1 Create Table Script 333089
CT_SEQ_CNT_AGREEMENT_AUDIT_333089.sql 1.1 Create Table Script 333089
CT_SEQ_CNT_AGREEMENT_FORECAST_333089.sql 1.1 Create Table Script 333089
CT_SEQ_EDI_AUDIT_337229.sql 1.1 Create Table Script 337229
CT_SEQ_GLE_AUDIT_333090.sql 1.1 Create Table Script 333090
CT_SEQ_IMP_FILE_ID_333095.sql 1.1 Create Table Script 333095
CT_SEQ_INT_BNL_ORDERS_336655.sql 1.1 Create Table Script 336655
CT_SEQ_INT_DEBRIEF_ORD_CSV_336151.sql 1.1 Create Table Script 336151
CT_SEQ_MICD_OUTBOUND_333896.sql 1.1 Create Table Script 333896
CT_SEQ_PAR_RESET_AUDIT_334029.sql 1.1 Create Table Script 334029
CT_TMP_CNT_TIER_NAME_333089.sql 1.2 Create Table Script 333089
CUST_COST.fmx 2.98 Customer Maintenance form 334630
CUST_COST.fmx 2.99 Customer Maintenance form 333089
DATA_1_ADM_SYSTEM_PARAM_333896.sql 1.2 Data Script 333896
DATA_1_ADM_SYSTEM_PARAM_334812.sql 1.1 Data Script 334812
DATA_1_ADM_SYSTEM_PARAM_336976.sql 1.1 Data Script 336976
DATA_1_IMP_IMPORT_TYPE_335501.sql 1.1 Data Script 335501
DATA_1_REP_REPORT_336257.sql 1.1 Data Script 336257
DATA_1_REP_REPORT_337446.sql 1.1 Data Script 337446
DATA_2_ADM_SYSTEM_PARAM_CONFIG_333896.sql 1.1 Data Script 333896
DATA_2_ADM_SYSTEM_PARAM_CONFIG_334812.sql 1.1 Data Script 334812
DATA_2_ADM_SYSTEM_PARAM_CONFIG_336976.sql 1.1 Data Script 336976
DATA_2_IMP_FIELD_335501.sql 1.1 Data Script 335501
DATA_2_REP_REPORT_PARAM_336257.sql 1.1 Data Script 336257
DATA_2_REP_REPORT_PARAM_337446.sql 1.1 Data Script 337446
DATA_3_ADM_LOG_PROG_NAME_333896.sql 1.1 Data Script 333896
DATA_4_SCH_SOURCE_SYSTEM_333896.sql 1.1 Data Script 333896
DATA_ADM_FORM_TAB_333090.sql 1.1 Data Script 333090
DATA_ADM_FORM_TAB_333095.sql 1.1 Data Script 333095
DATA_ADM_FORM_TAB_336151.sql 1.1 Data Script 336151
DATA_ADM_FORM_TAB_336655.sql 1.1 Data Script 336655
DATA_ADM_FUNCTION_333090.sql 1.1 Data Script 333090
DATA_ADM_FUNCTION_336148.sql 1.1 Data Script 336148
DATA_ADM_LOG_PROG_NAME_335692.sql 1.1 Data Script 335692
DATA_ADM_LOG_PROG_NAME_336151.sql 1.1 Data Script 336151
DATA_ADM_LOG_PROG_NAME_336639.sql 1.1 Data Script 336639
DATA_ADM_LOG_PROG_NAME_336655.sql 1.1 Data Script 336655
DATA_ADM_MENU_ITEM_334291.sql 1.1 Data Script 334291
DATA_ADM_MENU_ITEM_336149.sql 1.1 Data Script 336149
DATA_ADM_MSEL_FORM_PARAM_336006.sql 1.1 Data Script 336006
DATA_ADM_MSEL_FORM_PARAM_336078.sql 1.2 Data Script 336078
DATA_ADM_MSEL_FORM_PARAM_336152.sql 1.1 Data Script 336152
DATA_ADM_MSEL_FORM_PARAM_336657.sql 1.1 Data Script 336657
DATA_ADM_SYSTEM_PARAM_333090.sql 1.1 Data Script 333090
DATA_ADM_SYSTEM_PARAM_333091.sql 1.1 Data Script 333091
DATA_ADM_SYSTEM_PARAM_333092.sql 1.1 Data Script 333092
DATA_ADM_SYSTEM_PARAM_334291.sql 1.1 Data Script 334291
DATA_ADM_SYSTEM_PARAM_335409.sql 1.1 Data Script 336459
DATA_ADM_SYSTEM_PARAM_335409.sql 1.2 Data Script 335409
DATA_ADM_SYSTEM_PARAM_335576.sql 1.1 Data Script 335576
DATA_ADM_SYSTEM_PARAM_336000.sql 1.1 Data Script 336000
DATA_ADM_SYSTEM_PARAM_336148.sql 1.1 Data Script 336148
DATA_ADM_SYSTEM_PARAM_336149.sql 1.1 Data Script 336149
DATA_ADM_SYSTEM_PARAM_336257.sql 1.1 Data Script 336257
DATA_ADM_SYSTEM_PARAM_336656.sql 1.1 Data Script 336656
DATA_ADM_SYSTEM_PARAM_336657.sql 1.1 Data Script 336657
DATA_ADM_SYSTEM_PARAM_336890.sql 1.1 Data Script 336890
DATA_ADM_SYSTEM_PARAM_336963.sql 1.1 Data Script 336963
DATA_ADM_SYSTEM_PARAM_337506.sql 1.1 Data Script 337506
DATA_ADM_SYSTEM_PARAM_CONFIG_333091.sql 1.1 Data Script 333091
DATA_ADM_SYSTEM_PARAM_CONFIG_333092.sql 1.1 Data Script 333092
DATA_ADM_SYSTEM_PARAM_CONFIG_335409.sql 1.1 Data Script 335409
DATA_ADM_SYSTEM_PARAM_CONFIG_336459.sql 1.1 Data Script 336459
DATA_ADM_SYSTEM_PARAM_CONFIG_336656.sql 1.1 Data Script 336656
DATA_ADM_SYSTEM_PARAM_CONFIG_336657.sql 1.1 Data Script 336657
DATA_ADM_SYSTEM_PARAM_CONFIG_336890.sql 1.1 Data Script 336890
DATA_ADM_SYSTEM_PARAM_CONFIG_336963.sql 1.1 Data Script 336963
DATA_ADM_SYSTEM_PARAM_CONFIG_337506.sql 1.1 Data Script 337506
DATA_ADM_USER_PARAM_TYPE_335581.sql 1.1 Data Script 335581
DATA_ADM_USER_PARAM_TYPE_335799.sql 1.1 Data Script 335799
DATA_ORG_CUST_ORD_REV_CHG_TYPE_333091.sql 1.1 Data Script 333091
DATA_ORS_MASTER_DATA_335337_1.sql 1.2 Data Script 335337
DATA_ORS_MASTER_DATA_335337_10.sql 1.2 Data Script 335337
DATA_ORS_MASTER_DATA_335337_11.sql 1.2 Data Script 335337
DATA_ORS_MASTER_DATA_335337_12.sql 1.2 Data Script 335337
DATA_ORS_MASTER_DATA_335337_13.sql 1.2 Data Script 335337
DATA_ORS_MASTER_DATA_335337_14.sql 1.3 Data Script 335337
DATA_ORS_MASTER_DATA_335337_15.sql 1.2 Data Script 335337
DATA_ORS_MASTER_DATA_335337_16.sql 1.2 Data Script 335337
DATA_ORS_MASTER_DATA_335337_17.sql 1.2 Data Script 335337
DATA_ORS_MASTER_DATA_335337_18.sql 1.2 Data Script 335337
DATA_ORS_MASTER_DATA_335337_2.sql 1.2 Data Script 335337
DATA_ORS_MASTER_DATA_335337_3.sql 1.2 Data Script 335337
DATA_ORS_MASTER_DATA_335337_4.sql 1.2 Data Script 335337
DATA_ORS_MASTER_DATA_335337_5.sql 1.2 Data Script 335337
DATA_ORS_MASTER_DATA_335337_6.sql 1.2 Data Script 335337
DATA_ORS_MASTER_DATA_335337_7.sql 1.2 Data Script 335337
DATA_ORS_MASTER_DATA_335337_8.sql 1.2 Data Script 335337
DATA_ORS_MASTER_DATA_335337_9.sql 1.2 Data Script 335337
DATA_ORS_MASTER_DATA_335422.sql 1.1 Data Script 335422
DATA_ORS_MASTER_DATA_336130.sql 1.1 Data Script 336130
DATA_ORS_MASTER_DATA_336466.sql 1.3 Data Script 336466
DATA_ORS_SQL_335337.sql 1.2 Data Script 335337
DATA_ORS_SQL_335422.sql 1.1 Data Script 335422
DATA_ORS_SQL_336466.sql 1.1 Data Script 336466
DATA_REP_REPORT_336149.sql 1.1 Data Script 336149
DATA_REP_REPORT_336656.sql 1.1 Data Script 336656
DATA_REP_REPORT_336963.sql 1.1 Data Script 336963
DATA_REP_REPORT_337506.sql 1.1 Data Script 337506
DATA_REP_REPORT_PARAM_336149.sql 1.1 Data Script 336149
DATA_REP_REPORT_PARAM_336656.sql 1.1 Data Script 336656
DATA_REP_REPORT_PARAM_336963.sql 1.1 Data Script 336963
DATA_REP_REPORT_PARAM_337133.sql 1.1 Data Script 337133
DATA_REP_REPORT_PARAM_337506.sql 1.1 Data Script 337506
DATA_SCH_SOURCE_SYSTEM_333095.sql 1.1 Data Script 333095
DELIVERY.fmx 1.1 Delivery Management Screen 334291
DELIVERY.fmx 1.6 Delivery Management Screen 336595
DELIVERY.fmx 1.8 Delivery Management Screen 337375
DP_ASSET_SCANNING.sql 5.27 Tag to Asset Scanning 330260
DP_ASSET_SCANNING.sql 5.28 Tag to Asset Scanning 335812
DP_ASSET_SCANNING.sql 5.30 Tag to Asset Scanning 336177
DP_ASSET_SCANNING.sql 5.31 Tag to Asset Scanning 336289
DP_ASSET_SCANNING.sql 5.32 Tag to Asset Scanning 336487
DP_BMW_EDI_IN.sql 1.15 Inbound EDI Package 335851
DP_BMW_EDI_OUT.sql 1.8 Outbound EDI Package 336078
DP_BMW_EDI_OUT.sql 1.9 Outbound EDI Package 336181
DP_BNL_EDI_IN.sql 1.1 Inbound EDI Package 336655
DP_BNL_EDI_IN.sql 1.2 Inbound EDI Package 336657
DP_BNL_EDI_OUT.sql 1.2 Outbound EDI Package 336639
DP_BNL_EDI_OUT.sql 1.3 Outbound EDI Package 336657
DP_BWSC.sql 1.1 Database package 336151
DP_CSV_NR.sql 5.48 Network Rail CSV reports 335407
DP_CSV_NR.sql 5.49 Network Rail CSV reports 335403
DP_CSV5.sql 1.63 Fifth CSV extract package 336257
DP_CSV6.sql 1.28 CSV Extract package 336331
DP_IMP.sql 5.29 Imports Package 336377
DP_IMP.sql 5.30 Imports Package 335409
DP_IMP.sql 5.30 Imports Package 336459
DP_IMP_3.sql 1.1 Imports Package 333095
DP_IMP_3.sql 1.2 Imports Package 337117
DP_IMP_4.sql 4.1 Imports Package 335501
DP_INT_XML_MIC2.sql 1.11 CTMS to MIC Interface 336643
DP_INT_XML_MIC2.sql 1.12 CTMS to MIC Interface 336676
DP_INT_XML_MIC2.sql 1.13 CTMS to MIC Interface 336976
DP_INT_XML_MIC2.sql 1.2 CTMS to MIC Interface 333896
DP_INT_XML_MIC2.sql 1.3 CTMS to MIC Interface 336412
DP_INT_XML_MIC2.sql 1.4 CTMS to MIC Interface 336513
DP_INT_XML_MIC2.sql 1.5 CTMS to MIC Interface 336524
DP_INT_XML_MIC2.sql 1.6 CTMS to MIC Interface 336568
DP_INT_XML_MIC2.sql 1.8 CTMS to MIC Interface 336591
DP_INT_XML_MIC2.sql 1.9 CTMS to MIC Interface 336616
DP_MCS_SCANNING.sql 5.35 MCS Scanning Package 337353
DP_ORS_FUNCS.sql 5.20 Change to DOOD status function 335422
DP_ORS_FUNCS.sql 5.24 Change to DOOD status function 335337
DP_PORTAL.sql 5.13 Portal Package 336673
DP_PULSE.sql 1.37 Pulse Interface Package 336677
DP_RDT_AUTO.sql 5.40 Client specific RDT funtions 335861
DP_RDT_AUTO.sql 5.41 Client specific RDT funtions 335935
DP_RDT_FAST_LOAD.sql 5.22 Load confirmation message procedure 335692
DP_RDT_FAST_LOAD.sql 5.23 Load confirmation message procedure 335861
DP_RDT_FAST_LOAD.sql 5.24 Load confirmation message procedure 337205
DP_RDT_FAST_UNLOAD.sql 5.32 RF Unload Package 335656
DP_RDT_FAST_UNLOAD.sql 5.33 RF Unload Package 335692
DP_RDT_FAST_UNLOAD.sql 5.34 RF Unload Package 335861
DP_RDT_FAST_UNLOAD.sql 5.35 RF Unload Package 336061
DP_REPORTS.sql 5.36 Reports package 335421
DP_REPORTS.sql 5.37 Reports package 335825
DP_REPORTS.sql 5.38 Reports package 336117
DP_REPORTS.sql 5.39 Reports package 336157
DP_REPORTS.sql 5.40 Reports package 336656
DP_REPORTS.sql 5.41 Reports package 336963
DP_SCHEDULING_ENGINE.sql 5.93 Scheduling Package 337350
DP_TOMTOM.sql 1.18 TomTom Package 335931
DP_TOMTOM.sql 1.19 TomTom Package 336298
DP_TOY_EDI_IN.sql 1.3 Inbound EDI database package 335692
DP_TOY_EDI_IN.sql 1.4 Inbound EDI database package 335861
DP_TOY_EDI_IN.sql 1.5 Inbound EDI database package 336261
EDI_MAINT.fmx 10.10 EDI Maintenance Screen 337229
GEO.sql 5.3 Location Processing 337184
HAULIER_INVOICE.rep 2.2 Haulier Invoice Report 336257
IMP.sql 5.127 CSV Imports Package 333095
IMP.sql 5.128 CSV Imports Package 335501
IMPORTS_EXEC.fmx 10.18 Import executions 333095
INT_ERR.fmx 1.88 Interface Errors 335861
INT_ERR.fmx 1.89 Interface Errors 336319
INT_ERR.fmx 1.90 Interface Errors 336655
INT_ERR.fmx 1.91 Interface Errors 336151
INT_ERR.fmx 1.92 Interface Errors 337297
INT_ERR.fmx 1.94 Interface Errors 334030
INT_XML_IN.sql 5.143 Order Import Package 334630
INT_XML_MIC.sql 5.132 MIC interface 335682
INT_XML_MIC.sql 5.133 MIC interface 335692
INT_XML_MIC.sql 5.134 MIC interface 335861
INT_XML_MIC.sql 5.135 MIC interface 335935
INT_XML_OUT2.sql 5.232 Outbound XML Package 334630
INT_XML_OUT2.sql 5.233 Outbound XML Package 335932
INT_XML_OUT2.sql 5.234 Outbound XML Package 337152
INT_XML_OUT2.sql 5.235 Outbound XML Package 336000
INV.sql 5.20 Invoice Package 335409
INV.sql 5.21 Invoice Package 336377
INV.sql 5.22 Invoice Package 336149
INV.sql 5.23 Invoice Package 336257
INVENTORY_MAN.fmx 1.1 Inventory Management 333090
INVOICE_CARR.rep 2.3 Carrier Invoice 336257
INVOICES.fmx 2.37 Invoices Screen 336552
INVOICES.fmx 2.38 Invoices Screen 336257
LOCATION.fmx 2.148 Location Maintenance 333090
LOCATION.fmx 2.149 Location Maintenance 335924
LOCATION.fmx 2.151 Location Maintenance 336770
LOCATION.fmx 2.152 Location Maintenance 336377
LOCATION.fmx 2.153 Location Maintenance 336671
LOCATION.fmx 2.154 Location Maintenance 337038
LOCATION.fmx 2.156 Location Maintenance 337375
OF_INT.sql 5.31 Oracle Financials interface 337123
OMS.sql 5.154 Order package 336148
OMS.sql 5.155 Order package 336006
OMS.sql 5.156 Order package 336657
ORDERS.fmx 2.342 Order Screen 335560
ORDERS.fmx 2.344 Order Screen 335694
ORDERS.fmx 2.345 Order Screen 335581
ORDERS.fmx 2.346 Order Screen 335799
ORDERS.fmx 2.347 Order Screen 335903
ORDERS.fmx 2.348 Order Screen 336078
ORDERS.fmx 2.350 Order Screen 336580
ORDERS.fmx 2.351 Order Screen 336924
ORDERS.fmx 2.352 Order Screen 336970
ORDERS.fmx 2.353 Order Screen 337040
ORDERS.fmx 2.355 Order Screen 334812
ORDERS.fmx 2.356 Order Screen 336657
ORION.mmx 1.39 Orion Menu 333089
ORION.mmx 1.39 Orion Menu 333090
ORION.mmx 1.40 Orion Menu 334291
ORION.mmx 1.41 Orion Menu 336149
ORS.fmx 1.22 Oracle Reporting suite 335421
ORS.fmx 1.23 Oracle Reporting suite 336117
ORS.fmx 1.24 Oracle Reporting suite 336863
ORS.sql 5.9 Oracle Reporting suite 336863
PAR_INT.fmx 10.33 Paragon Interface form 334029
PAYMENTS.fmx 2.42 Payments Screen 336377
PLANNING.fmx 1.26 Planning Screen 333896
PLANNING.fmx 1.27 Planning Screen 335391
PLANNING.fmx 1.28 Planning Screen 336296
PLANNING.fmx 1.30 Planning Screen 336374
PLANNING.fmx 1.31 Planning Screen 336148
PLANNING.fmx 1.34 Planning Screen 336006
PLANNING.fmx 1.35 Planning Screen 336656
PLANNING.fmx 1.36 Planning Screen 337170
PLANNING.fmx 1.38 Planning Screen 337337
PLANNING.fmx 1.39 Planning Screen 337375
PRODUCT.fmx 2.48 Product form to maintain Volumetric data 336006
RATE.sql 5.113 Rates Tariff database package 336377
RATE.sql 5.114 Rates Tariff database package 335409
RATE.sql 5.115 Rates Tariff database package 337543
REPORTS.fmx 2.31 Reports Screen 335697
REPORTS.fmx 2.33 Reports Screen 337519
RESOURCE.fmx 2.161 Resource Maintenance form 335495
RESOURCE.fmx 2.162 Resource Maintenance form 333095
RESOURCE.fmx 2.163 Resource Maintenance form 336188
RESOURCE.fmx 2.164 Resource Maintenance form 335395
SCHED_RULES.fmx 1.26 Scheduling Screen 337393
SERVICE_CHARGES.fmx 1.2 Service Charge Form 336149
SERVICE_SELFBILL.rep 1.1 Selfbill Invoice Report 336149
SUPPLIER_INVOICE.rep 2.2 Supplier Invoice Report 336257
SYS_CFG.fmx 2.11 System Config Form 335395
T_GEO_LOCATION_LATLONG.sql 5.8 Geo Location trigger for Lat/Long 333090
T_SCH_ORD_PNL.sql 5.90 Trigger 333091
TIU_TRIP_STATUS.sql 5.41 Trigger on SCH_TRIP for status change 333091
TIU_TRIP_STATUS.sql 5.43 Trigger on SCH_TRIP for status change 337388
TRG_BWSCDO_BIU.sql 1.1 Trigger 336151
TRG_CNT_AGREEMENT_AI.sql 1.1 Trigger 333089
TRG_CNT_AGREEMENT_BIU.sql 1.1 Trigger 333089
TRG_CNT_RHA_AI.sql 1.1 Trigger 335409
TRG_DRY_ICE.sql 1.10 Trigger 337348
TRG_GEL_PACKS.sql 1.6 Trigger 337352
TRG_GLE_AUDIT_BI.sql 1.1 Trigger 333090
TRG_GLE_BIU.sql 1.1 Trigger 333090
TRG_INT_BNL_ORDERS_DETAIL_BIU.sql 1.1 Trigger 336655
TRG_INT_BNL_ORDERS_HEADER_BIU.sql 1.1 Trigger 336655
TRG_SCH_ORD_LINES_SERVICES.sql 5.6 Database Trigger Script 337100
TRG_SCH_ORD_NON_CONF_XML_INT.sql 5.10 Trigger 335725
TRG_SCH_ORD_SERVICES.sql 5.2 Database Trigger Script 336158
TRG_SCH_ORD_SERVICES.sql 5.3 Database Trigger Script 336679
TRG_SCH_ORD_SERVICES.sql 5.4 Database Trigger Script 336810
TRG_SCH_TRIP_XML_GEN.sql 5.10 Trigger 336639
TRG_SCH_TRIP_XML_INT.sql 5.29 Trigger 333896
TRG_SHA_XML.sql 5.24 Trigger 333896
TRG_SHA_XML_GEN.sql 5.6 Trigger 336557
TRG_SOI_XML.sql 5.17 Trigger 333896
TRG_SOL_XML.sql 5.38 Trigger 333896
TRG_STS_XML.sql 5.19 Trigger 335576
TRG_STS_XML.sql 5.20 Trigger 333896
TRG_STS_XML_GEN.sql 5.5 Trigger 336557
TRIP_OVERVIEW.fmx 1.53 Trip Waterfall 336152
TRIP_OVERVIEW.fmx 1.54 Trip Waterfall 337417
TRIP_OVERVIEW.sql 5.7 Trip Waterfall 336152
TRIP_PLAN.fmx 1.270 Trip Planning Screen 336323
TRIP_PLAN.fmx 1.271 Trip Planning Screen 336299
TRIP_SHEET_BNL.rep 1.1 Trip Sheet 337446
TRIP_SHEET_SCHED.rep 1.1 Trip Sheet Schedule 337170
TRIPDTL.fmx 2.196 Trip Debrief 330260
TRIPDTL.fmx 2.197 Trip Debrief 335692
TRIPDTL.fmx 2.199 Trip Debrief 336148
TRIPDTL.fmx 2.200 Trip Debrief 336890
TRIPDTL.fmx 2.203 Trip Debrief 333091
TRIPDTL.fmx 2.204 Trip Debrief 337206
TRIPDTL.fmx 2.208 Trip Debrief 337388
TRIPSUM.fmx 2.422 Trip Manipulation screen 335913
TRIPSUM.fmx 2.423 Trip Manipulation screen 336197
TRIPSUM.fmx 2.424 Trip Manipulation screen 336374
TRIPSUM.fmx 2.426 Trip Manipulation screen 336006
TRIPSUM.fmx 2.427 Trip Manipulation screen 337209
TRM.sql 5.14 Trip manipulation package 336148
V_ORD_INC_INV.sql 1.9 View 336145
V_TRIP_OVERVIEW.sql 1.14 Trip View 336152
V_TRIP_OVERVIEW_ORD.sql 5.13 Trip/Order View 336152


ADDITIONAL CHANGES

WCS

A WCS change is required for the following logs:

  • 335861
  • 337205


EPOD/T2A

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

  • 330260
  • 335812
  • 336289


MCS

There are no MCS changes required.


PORTAL/TTM

A Portal change is required for the following logs:

  • 336000
  • 335932
  • 336457
  • 336673


EDI

An EDI change is required for the following logs:

  • 336639
  • 336655
  • 335692