255572

255572-PA-7JUG5V ADD Trip id barcode to TripSheet

Copyright OBS Logistics © 2008

The information contained herein is the property of OBS Logistics and is supplied without liability for errors or omissions. No part may be reproduced or used except as authorised by contract or other written permission. The copyright and foregoing restriction on reproduction and use extend to all media in which the information may be embodied

FUNCTIONAL OVERVIEW

Client Requirement

1: Add Code 39 (3 of 9) Barcode to CN Trip Sheet (MTS Modules/Reports/CN Trip Sheet) of Trip ID (MAN-00XXXXXX) to enable this to be read and decoded by the LOTS system scanner.Suggest position to the right of Report header, approx 4cm x 1cm.

2: CN Trip Sheet pdf Report (MTS Modules/Reports/CN Trip Sheet) change [Booking Window] to [Booked Time] and amend field link to read respective field in MTS ie [Late_Del] (time only)

Added by SS - Barcode should only hold trip no eg MAN-123456. A new trip sheet containing barcode should be created this report should be based on CN Trip Sheet report. However the new report should contain the barcode in the top right corner of the report. Version number and time of report will need to be relocated.

Solution

A new version of TRIP_SHEET.RDF will be created called TRIP_SHEET_BAR.RDF

Add BARCODE

The barcode will be displayed at the top of the report , to print this is the margin will cause a conflict in Oracle reports as the trip-id is being displayed in detail of the report, this conflict will have to be resolved to print the barcode in the desired place. A brief description of the required steps is listed below:

• Create a function to read in data and return the data in barcode 39 format. This function will be stored on the database. • Download the BARCODE 39 font • In the report, create a formula column CF_TRIP_BARCODE. The formula of this column will run the BARCODE function, reading in TRIP_ID as the data source. • The barcode 39 data will be returned into a data field F_TRIP_BAR_CODE which will be displayed in the margin of the report. The source of F_TRIP_BAR_CODE will be the formula column CF_TRIP_BARCODE. This field will be assigned the barcode font -IDAutomationHC39M.

Amend Booking Window

Within the trip stop detail, the Booking Window will be amended to display Booked Time, and the time part of the late delivery field will be displayed under the Booked Time heading.

• Add LATE_DEL from SCH_ORD to the data model, SCH_ORD is already a data source so the relevant where statements exist. • Change the Boiler Plate text from ‘Booking Window’ to ‘Booked Time’ and create a data field sourced by LATE_DEL., this will be displayed in the TRIP STOP repeating frame.

Scope

This change will be applied to system version 10.5 on CONTST and once approved CONPRD.