261673

261673 MA-7PCNBY Add Fields to CN Warehouse Extract

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

Functional Overview

Client Requirement

Change required to "CN Warehouse Extract" to have two additional fields added 'OMS Ref' and 'Schedule'Copy from estimate

Solution

The OMS Ref and Schedule will be added to the end Warehouse extract portion of the CSV package, the new output will be as follows:

Load Date, Depart Time, Trip ID, Carrier, Trailer ID, Trailer Type, Book Date, Book Time, Destination, Deliver For, Customer, Lifts, Cases, Customer Ref, Loading Ref, Delivery Point Ref, OMS Ref, Schedule.

Scope

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

Data

The CL cursor in the CSV.Write_Warehouse_Extract procedure will be updated to select OMS_REF and SCHED_NAME.

The OMS_REF will be selected from SCH_HAULAGE_ACTIVITY and the SCHED_NAME will be selected from SCH_TRIP_STOP. Both tables are currently accessed within the cursor for other information so no additional where clauses are required.

The two fields will be added to the v_file_rec string , which stores the information to be displayed in the CSV file.

Functional Description

The two additional fields will be added to the end of the Warehouse Extract and will appear at the end of the CSV file.

References

Ref No	Document Title & ID	Version	Date
1	EST-261673 MA-7PCNBY Add Fields to CN Warehouse Extract v1a.doc	1a	25/02/09

Glossary

Not Available

Document History

Version	Date	Status	Reason	Initials
0.1	02/03/09	Draft	Initial version	SW
1.0	03/03/09	Issue	Reviewed and Issued	MJC

Authorised By

Matt Crisford	Development Manager
Suk Sandhu	TMSCC MTS Product Manager