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
| EST-261673 MA-7PCNBY Add Fields to CN Warehouse Extract v1a.doc |
Glossary
Not Available
Document History
| Initial version | ||||
| Reviewed and Issued |
Authorised By
| Matt Crisford | Development Manager | |
| Suk Sandhu | TMSCC MTS Product Manager |
