261352

261352 - MW-7PBH2A Purchase Order Screens

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

From RIO: With the new business we have won with Tesco's, we require in IILV within the Booking Module either a new tab or modify the existing tabs to incorporate the level of purchase order detail attached to this email. Tesco require us as to hold and verify further details sent by EDI that is part of the Purchase order - therefore fields need to be re-named / new form created to incorporate this level of detail on a purchase order level.

From Meeting 20/02/09:

Attendees: Martyn Mann (DHL), Mark Wilson (DHL), Suk Sandhu (DHL), Dave Meir (OBS), Matt Crisford (OBS) and Peter Crane (OBS)

It was decided during the meeting that a new Purchase Order module should be designed and developed by OBS on a Time and Materials basis. The aim of this document is to record the solution deployed to satisfy the requirements of DHL’s customer: Tesco.

Scenario: It is understood that Tesco will send purchase order information to DHL via EDI which should be stored and amended in MTS on demand either via EDI or manually prior to the goods being available for collection/transport. Tesco expects EDI messages in return advising of any change of status of the Purchase Order and eventually details of the Transport Order once the goods have been assigned to a trip. The statuses will be described in more detail in the Outbound Purchase Order Flow specification.

Solution

As part of the overall Purchase Order Module a new Oracle form: PURCH_ORD has been developed for DHL’s International Inbound division. The rapid nature of development did not allow time to specify changes needed prior to development. Therefore to complete the process the final solution is being recorded in this document.

Scope

This change will be applied to system version 10.5 on IIBTST and once approved IIBPRD. This module has also been designed in such a manor as to be transferable to other databases should further opportunities arise where it may be beneficial.

Set-Up

Pre-Requisites

All new tables and parameters should be in place prior to release.

Tables

The following new tables have been created

• SCH_PURCHASE_ORDER
• SCH_PO_STATUS
• SCH_PO_AUDIT

===System Parameters

Parameter	Default Value
POM_DEF_COST	EXEL

References

Ref No	Document Title & ID	Version	Date
1	EST-259410 PA-7MKDYG CN Loading Schedule Report Changes v1.doc	1	06/01/09

Document History

Version	Date	Status	Reason	Initials
1a	12/01/09	Draft	Initial version	PDR
1	12/01/09	Issue	Reviewed and Issued	MJC

Authorised By

Matt Crisford	Development Manager
Suk Sandhu	TMSCC MTS Product Manager