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.

SET-UP

Pre-requisites

None

Menu Structure

Unchanged

Data

The new report will be added to the standing data to allow it to be selected from the standard reports form. The selection criteria for the report will by the same as that for TRIP_SHEET

FUNCTIONAL DESCRIPTION

This RIO can be split into the following tasks

Display the TRIP_ID as a BARCODE

The format of this BARCODE must support code 39. For the barcode to be displayed on the report the following steps must be completed:

Down load a version of BARCODE 39 font for use in the report Create a function which will read in the TRIP_ID and output a format which can be read by the BARCODE font. Function BARCODE_39 will be created in the database.

Use a Formula field in Oracle reports to run the barcode function, the formula field will be created with the following properties and will call the function BARCODE_39 and apply it to trip_id.

NAME CF_TRIP_BARCODE PL/SQL RETURN BARCODE_39(|| :TRIP_ID ||);

Create a data field which will be sourced by the formula field. Both the data field and formula fields must be set up as char. The formula field will specifically have the following properties

Name F_TRIP_BARCODE Source CF_TRIP_BARCODE Type CHAR Length 22 Font IDAutomationHC39M

We must ensure that the report will compile on the development, test and production servers. This may require the new BARCODE font to be loaded onto the different servers.

Displaying the BARCODE in the requested place.

The requirements have requested that the barcode is displayed in the margin of the report. Margins should only be used for displaying static text like headings or parameter values but the nature of the report is that trip id will change for each record.

The easiest way to display the trip bar code and keep the existing report format is to leave the margin as it is and move the data currently displayed within the Trip Detail section to create space at the top of the Trip Detail section for the trip_id. This will mean that the trip bar code is displayed slightly lower in the report than originally requested, but the report will retain all existing formatting surrounding page set up and margin display.

The report displayed below is a sample of the positioning of the bar code in the report. The black block is where the bar code will appear,

IMAGE

Changes to the Booking Window

The late delivery field has already been formatted to display the time only within the data model. The trip stop data is formatted depending on the trip stop type – SU or non SU. This has been done to ensure that the SU trip stop always appears first in the report. Currently within the report the only order information which is displayed against the SU stop is total weight. Following this formatting, we will be displaying late del for non SU stops only. A conditional formatting trigger will ensure that the late del time is not displayed for SU trip stop records.

APPENDIX A TABLE UPDATES REQUIRED

No table changes are required for this development

APPENDIX B QUOTE & DOCUMENT HISTORY

IMAGE

References

IMAGE

Glossary

IMAGE

Document History

IMAGE

Authorised By

IMAGE