Middletong: /* Document History */

2009-09-10T15:03:26Z

Document History

← Older revision		Revision as of 17:03, 10 September 2009
Line 55:		Line 55:


	== Document History ==		= Document History =

	{\| Border="1"		{\| Border="1"
Line 78:		Line 78:
	\| <center>MJC</center>		\| <center>MJC</center>
	\|}		\|}


	= Authorised By =		= Authorised By =

Middletong: New page: =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 ...

2009-09-10T15:02:58Z

New page

=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 =
{| Border="1"
| <center>'''Ref No'''</center>
| <center>'''Document Title & ID'''</center>
| <center>'''Version'''</center>
| <center>'''Date'''</center>

|-
| <center>1</center>
| EST-261673 MA-7PCNBY Add Fields to CN Warehouse Extract v1a.doc
| <center>1a</center>
| <center>25/02/09</center>
|}

= Glossary =

Not Available

== Document History ==

{| Border="1"
| <center>'''Version'''</center>
| <center>'''Date'''</center>
| <center>'''Status'''</center>
| <center>'''Reason'''</center>
| <center>'''Initials'''</center>

|-
| <center>0.1</center>
| <center>02/03/09</center>
| <center>Draft</center>
| Initial version
| <center>SW</center>

|-
| <center>1.0</center>
| <center>03/03/09</center>
| <center>Issue</center>
| Reviewed and Issued
| <center>MJC</center>
|}

= Authorised By =
{| Border="1"
| '''''Matt Crisford'''''
| Development Manager
|

|-
| '''''Suk Sandhu'''''
| TMSCC MTS Product Manager
|

|}

261673 - Revision history

Middletong: /* Document History */

Middletong: New page: =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 ...