260548

260548 NW-7NPVPY / Modify the CN Haulier Trip Sheet for HCUK

Copyright OBS Logistics © 2009

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

Functiona Overview

Client Requirement

Add Trailer Type and Special Instructions to the CN Haulier Trip Sheet, rename to HC Haulier Trip Sheet and create in .csv format. Also add a new column to the far right of the export called Half / Full pallet, this is to be a blank column that will be entered manually.

Solution

A new extract will be created, that will run from the exports menu. The selection criteria will match the criteria that already exists for the CN Haulier Trip Sheet, which runs from the reports screen. These parameters are Schedule, Carrier, Group Name, Load Location, and Owning Depot. The SQL for the Extract will be taken from the existing Oracle report (CN Haulier Trip Sheet).

The fields displayed in the extract will be the same as in the oracle report, with three additions Trailer Type, special Instructions, Half / Full Pallet (no data required for this column). The other fields that will be displayed are,

• Carrier ID,
• Collection Date \ Time,
• Load Number (Trip_ID),
• Order Number,
• Customer Name,
• Customer Address,
• Customer,
• Booking Time,
• Planned Pallets,
• Pick By,
• Actual Pallets,

• Trailer Type,
• Special Instructions,
• Half / Full Pallet

v1.1 amended to include optional parameter ‘Trip Id’ as selection criteria for both Report and Export

Scope

These changes will be applied to system version 10.6 on HCRTST and once approved HCRPRD.

Data

Export Data

The new export will be added to the standing data to allow it to be selected from the standard exports form. The selection criteria for the export will be the same as that used for the report. This includes: Schedule, Carrier, Group Name, Load Location, and Owning Depot.

v1.1 amended to include optional parameter ‘Trip Id’ as selection criteria for Export

The export and parameter data will need to be created as follows :-

REP_REPORT :-

Name ’HC Haulier Trip Sheet’
Report_Type CSV
Filename HAULIER_TRIP_SHEET
Proc Name CSV.HAULIER_TRIP_SHEET
Printer_Type Laser
Orientation LANDSCAPE

REP_REPORT_PARAM :-

Common :-

Report_Name ’HC Haulier Trip Sheet’
Report_Type CSV

Specific :-

Param_Type	Param_Name	Conditional	Param_Title
PG_SELECT_LIST1	i_sched	M	Schedule
PG_SELECT_LIST2	i_carrier	O	Carrier
PG_SELECT_LIST1	i_group_name	O	Group Name
PG_LOV1	i_load_loc	M	Load Location
PG_LOV2	i_depot	O	Depot
PG_FFCHAR1	i_trip	O	Trip Id (optional)

Report Data

The amended 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 remain the same as that used for the CN version of the report. This includes: Schedule, Carrier, Group Name, Load Location, and Owning Depot.

v1.1 amended to include optional parameter ‘Trip Id’ as selection criteria for Report

The report and parameter data will need to be created as follows :-

REP_REPORT :-

Name ’HC Haulier Trip Sheet’
Report_Type REP
Filename HAULIER_TRIP_SHEET.rep
Printer_Type Laser
Show_Pform F
Orientation LANDSCAPE

REP_REPORT_PARAM :-

Common :-

Report_Name ’HC Haulier Trip Sheet’
Report_Type REP

Specific :-

Param_Type	Param_Name	Conditional	Param_Title
PG_SELECT_LIST1	P_SCHED	M	Schedule
PG_SELECT_LIST2	P_CARRIER	O	Carrier
PG_SELECT_LIST3	P_GROUP_NAME	O	Group Name
PG_LOV1	P_LOAD_LOC	M	Loading Location
PG_LOV2	P_DEPOT	O	Owning Depot
PG_FFCHAR1	P_TRIP_ID	O	Trip Id (optional)

Functional Description

HC Haulier Trip Sheet Export

This is how the exports screen will look for the new export, along with the parameters:

v1.1 amended to include optional parameter ‘Trip Id’ as selection criteria for Export

CSV Columns and Layouts

This CSV.sql package will be updated to include the code for the new export. The layout of the new export will be as follows, detailing the report parameters and columns:

v1.1 layout below will also display ‘And Trip Id like :’ followed by what the user entered or blank if no Trip Id was entered.

HC Haulier Trip Sheet Report

This is how the reports screen will look for the new report, along with the parameters:

v1.1 amended to include optional parameter ‘Trip Id’ as selection criteria for Report

Report Layout

The layout of the amended report will be the same as that below except it will have the additional requested columns Trailer Type, Special Instructions and a blank column Half/Full Pallet for user entry. The report may have to be changed from Portrait to Landscape in order to fit in the extra requested columns, considering that Special Instructions can be very long.

References

Ref No	Document Title & ID	Version	Date
1	Haulier Trip Sheet.pdf	N/A	N/A
2	EST-260548 NW-7NPVPY Modify the CN Haulier Trip Sheet for HCUK v1.doc	1	03/02/09
3	FS-260548 NW-7NPVPY Modify the CN Haulier Trip Sheet for HCUK v1.0.doc	1.0	20/04/09

Document History

Version	Date	Status	Reason	Initials
0.1	14/04/09	Draft	Initial version	LAD
0.2	20/04/09	Revise	Include Report info	LAD
1.0	20/04/09	Issue	Reviewed and Issued	MJC
1.1	21/04/09	Amend	Add parameter ‘Trip Id (optional)’ to report and export	LAD
2.0	21/04/09	Issued	Reviewed and Issued	MJC

Authorised By

Matt Crisford	Development Manager
Suk Sandhu	TMSCC MTS Product Manager

Back to CONPRD Release - 24/02/2010