267723 - Revision history

Middletong at 11:40, 29 April 2010

2010-04-29T11:40:51Z

← Older revision		Revision as of 13:40, 29 April 2010
Line 660:		Line 660:

	\|}		\|}

	~~Back to [[CONPRD Release - 24/02/2010]]~~

Middletong at 10:32, 31 March 2010

2010-03-31T10:32:34Z

← Older revision		Revision as of 12:32, 31 March 2010
Line 660:		Line 660:

	\|}		\|}

			Back to [[CONPRD Release - 24/02/2010]]

Middletong at 10:27, 31 March 2010

2010-03-31T10:27:26Z

← Older revision		Revision as of 12:27, 31 March 2010
Line 614:		Line 614:
	\|-		\|-
	\| <center>1</center>		\| <center>1</center>
	\| EST-~~259410 PA~~-~~7MKDYG CN Loading Schedule Report Changes~~ v1.~~doc~~		\| EST-267723 MW-7UDAYY Purchase Order Extract v1.0
	\| <center>1</center>		\| <center>1.0</center>
	\| <center>06/01/09</center>		\| <center>30/07/09</center>
	\|}		\|}

Line 630:		Line 630:

	\|-		\|-
	\| <center>1a</center>		\| <center>0.1</center>
	\| <center>12/01/09</center>		\| <center>10/08/09</center>
	\| <center>Draft</center>		\| <center>Draft</center>
	\| Initial version		\| Initial version
	\| <center>~~PDR~~</center>		\| <center>MJC</center>

	\|-		\|-
	\| <center>1</center>		\| <center>1.0</center>
	\| <center>12/01/09</center>		\| <center>12/01/09</center>
	\| <center>Issue</center>		\| <center>Issue</center>

Middletong: /* FUNCTIONAL DESCRIPTION */

2010-03-31T10:24:46Z

FUNCTIONAL DESCRIPTION

← Older revision		Revision as of 12:24, 31 March 2010
Line 439:		Line 439:

	\|}		\|}
			<br/>
			<br/>
	<br/>		<br/>
	<br/>		<br/>

Middletong: /* FUNCTIONAL DESCRIPTION */

2010-03-31T10:24:28Z

FUNCTIONAL DESCRIPTION

← Older revision		Revision as of 12:24, 31 March 2010
Line 429:		Line 429:
	\| style="border:3px solid darkblue;"\|DATE		\| style="border:3px solid darkblue;"\|DATE
	\| style="border:3px solid darkblue;"\|06/08/2009 12:53:39		\| style="border:3px solid darkblue;"\|06/08/2009 12:53:39

			\|-
			\| style="border:3px solid darkblue;"\|'''57'''
			\| style="border:3px solid darkblue;"\|Order Reference
			\| style="border:3px solid darkblue;"\|OMS Reference from SCH_ORD where Booking Ref = PO Reference
			\| style="border:3px solid darkblue;"\|VARCHAR2(12)
			\| style="border:3px solid darkblue;"\|999603

Middletong: /* FUNCTIONAL DESCRIPTION */

2010-03-31T10:22:55Z

FUNCTIONAL DESCRIPTION

@@ Line 432: / Line 432: @@
 |}
 <br/>
 <br/>

Middletong: /* FUNCTIONAL DESCRIPTION */

2010-03-31T10:22:34Z

FUNCTIONAL DESCRIPTION

@@ Line 432: / Line 432: @@
 |}
 <br/>
 <br/>

Middletong at 10:21, 31 March 2010

2010-03-31T10:21:51Z

@@ Line 377: / Line 377: @@
     | style="border:3px solid darkblue;"|SPECIAL_INSTRUCTIONS
     | style="border:3px solid darkblue;"|VARCHAR2(4000)
-ItemType:P|StyleCode_Desc:KC920411|V
+   | style="border:3px solid darkblue;"|ItemType:P|StyleCode_Desc:KC920411|V
 endorPartNumber:|PO_Created_DateTime:2009-05-15T00:00:00+00:00|LastModified_DateTime:2009-05-15T00:00:00+00:00|PO_StatusEffDateTime:2009-05-T00:00:00+00:00|PO_NumberRedirected:|PO etc….
-    | style="border:3px solid darkblue;"|n/a
+|-
 |}
 <br/>
 <br/>

Middletong: New page: =267723 - MW-7UDAYY / Purchase Order Extract= Copyright OBS Logistics © 2010 The information contained herein is the property of OBS Logistics and is supplied without liability for erro...

2010-03-31T10:07:38Z

New page

=267723 - MW-7UDAYY / Purchase Order Extract=

Copyright OBS Logistics © 2010

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==

We require a full extract out of the new Purchase order screen,

Apart from the full details - we also need the date and time when the po was first approved from the audit log - other fields like the OMS ref once the po has been generated via TI is also required.

Added by Mark Wilson via email 05/08/09:

The additional requirements are for the Country and Postcode from the Location file to be added against the Source and Destination locations against the order line.

Also - when we run the report this is by schedule date (Cargo ready date) parameter and we are able to select the Status i.e. just Accepted - when we run ALL - this is to remove Deleted and Cancelled orders - so this will show operationally what we have to action in the other status.

==Solution==

A new extract format will be added to the Export form’s options called ‘Purchase Order Extract’ a date range will be available for selection and will restrict the export contents to only records that have a delivery date within the date range entered. The export format will be a CSV type file separated by the user parameter EXP_DELIMITER if set or the default ‘,’

The fields contained in the export will be taken from the following screen:

[[Image:267723_1.png]]

In addition the date of a PO’s first status change to ‘APPROVED’ will be reported along with any OMS reference(s) generated from the Create Ti function. NB if users change the booking reference of the order then the linkage will be broken and orders may not be reported. The TI’s Generated flag will be displayed in the export, this could then be used to identify these orders.
A header row will be displayed at the top of the export to assist with field identification i.e:

PO Reference, PO Status, Cust Status, Supp Bkg Action….etc
434387015960407,CONFIRMED,Open,SBA NO ACTION,….etc

Included in costing is 0.25 days for UAT assistance, any further implementation/testing support would need to be agreed on a T&M basis.

==Scope==

This change will be applied to system version 10.5 on IIBTST and once approved on IIBPRD. NB this will be developed in such a manner as to be compatible with any database that has the Purchase Order Module installed.

==Data==

A new record will be added to the REP_REPORT table :

=FUNCTIONAL DESCRIPTION=

Extract Definition

{| class="wikitable" align=left width=55% style="background:lightyellow;color:black;"

|-
! style="background:darkblue;color:white;"| POSITION
! style="background:darkblue;color:white;"| ITEM NAME
! style="background:darkblue;color:white;"| MTS SLOT IMPORT FIELD TYPE
! style="background:darkblue;color:white;"| FORMAT
! style="background:darkblue;color:white;"| VALUES
|-
| style="border:3px solid darkblue;"|'''1'''
| style="border:3px solid darkblue;"|PO Reference
| style="border:3px solid darkblue;"|PO_REFERENCE
| style="border:3px solid darkblue;"|VARCHAR2(24)
| style="border:3px solid darkblue;"|435488015976936

|-
| style="border:3px solid darkblue;"|'''2'''
| style="border:3px solid darkblue;"|PO ID
| style="border:3px solid darkblue;"|PO_ID
| style="border:3px solid darkblue;"|VARCHAR2(12)
| style="border:3px solid darkblue;"|435488

|-
| style="border:3px solid darkblue;"|'''3'''
| style="border:3px solid darkblue;"|Item Number
| style="border:3px solid darkblue;"|ITEM_NUMBER
| style="border:3px solid darkblue;"|VARCHAR2(12)
| style="border:3px solid darkblue;"|015976936

|-
| style="border:3px solid darkblue;"|'''4'''
| style="border:3px solid darkblue;"|PO Number
| style="border:3px solid darkblue;"|PO_NUMBER
| style="border:3px solid darkblue;"|VARCHAR2(12)
| style="border:3px solid darkblue;"|460-73197

|-
| style="border:3px solid darkblue;"|'''5'''
| style="border:3px solid darkblue;"|Cost Centre
| style="border:3px solid darkblue;"|COST_CENTRE
| style="border:3px solid darkblue;"|VARCHAR2(12)
| style="border:3px solid darkblue;"|EXEL

|-
| style="border:3px solid darkblue;"|'''6'''
| style="border:3px solid darkblue;"|Customer
| style="border:3px solid darkblue;"|CUSTOMER
| style="border:3px solid darkblue;"|VARCHAR2(12)
| style="border:3px solid darkblue;"|Tesco

|-
| style="border:3px solid darkblue;"|'''7'''
| style="border:3px solid darkblue;"|Source
| style="border:3px solid darkblue;"|SOURCE
| style="border:3px solid darkblue;"|VARCHAR2(12)
| style="border:3px solid darkblue;"|TE-202210

|-
| style="border:3px solid darkblue;"|'''8'''
| style="border:3px solid darkblue;"|Source Postcode
| style="border:3px solid darkblue;"|Derived from GEO_LOCATION based on Source matching a location id
| style="border:3px solid darkblue;"|VARCHAR2(9)
| style="border:3px solid darkblue;"|34 520

|-
| style="border:3px solid darkblue;"|'''9'''
| style="border:3px solid darkblue;"|Source Country
| style="border:3px solid darkblue;"|Derived from GEO_LOCATION based on Source matching a location id
| style="border:3px solid darkblue;"|VARCHAR2(3)
| style="border:3px solid darkblue;"|TR

|-
| style="border:3px solid darkblue;"|'''10'''
| style="border:3px solid darkblue;"|Hub
| style="border:3px solid darkblue;"|HUB
| style="border:3px solid darkblue;"|VARCHAR2(12)
| style="border:3px solid darkblue;"|TR

|-
| style="border:3px solid darkblue;"|'''11'''
| style="border:3px solid darkblue;"|Destination
| style="border:3px solid darkblue;"|DESTINATION
| style="border:3px solid darkblue;"|VARCHAR2(12)
| style="border:3px solid darkblue;"|TE-460

|-
| style="border:3px solid darkblue;"|'''12'''
| style="border:3px solid darkblue;"|Destination Postcode
| style="border:3px solid darkblue;"|Derived from GEO_LOCATION based on Destination matching a location id
| style="border:3px solid darkblue;"|VARCHAR2(9)
| style="border:3px solid darkblue;"|NN6 7EA

|-
| style="border:3px solid darkblue;"|'''13'''
| style="border:3px solid darkblue;"|Destination Country
| style="border:3px solid darkblue;"|Derived from GEO_LOCATION based on Destination matching a location id
| style="border:3px solid darkblue;"|VARCHAR2(3)
| style="border:3px solid darkblue;"|GB

|-
| style="border:3px solid darkblue;"|'''14'''
| style="border:3px solid darkblue;"|Cargo Ready
| style="border:3px solid darkblue;"|CARGO_READY
| style="border:3px solid darkblue;"|DATE
| style="border:3px solid darkblue;"|06-JUL-2009

|-
| style="border:3px solid darkblue;"|'''15'''
| style="border:3px solid darkblue;"|Schedule Name
| style="border:3px solid darkblue;"|SCHED_NAME
| style="border:3px solid darkblue;"|VARCHAR2(12)
| style="border:3px solid darkblue;"|090706

|-
| style="border:3px solid darkblue;"|'''16'''
| style="border:3px solid darkblue;"|Product Type
| style="border:3px solid darkblue;"|PROD_TYPE_ID
| style="border:3px solid darkblue;"|VARCHAR2(12)
| style="border:3px solid darkblue;"|AMBIENT

|-
| style="border:3px solid darkblue;"|'''17'''
| style="border:3px solid darkblue;"|Status
| style="border:3px solid darkblue;"|STATUS resolved from STATUS_ID linked to SCH_PO_STATUS
| style="border:3px solid darkblue;"|VARCHAR2(2)
| style="border:3px solid darkblue;"|PROVISIONAL

|-
| style="border:3px solid darkblue;"|'''18'''
| style="border:3px solid darkblue;"|Delivery Date
| style="border:3px solid darkblue;"|DELIVERY_DATE
| style="border:3px solid darkblue;"|DATE
| style="border:3px solid darkblue;"|13-JUL-2009

|-
| style="border:3px solid darkblue;"|'''19'''
| style="border:3px solid darkblue;"|Transport Mode
| style="border:3px solid darkblue;"|TRANSPORT_MODE
| style="border:3px solid darkblue;"|VARCHAR2(12)
| style="border:3px solid darkblue;"|TRUCK

|-
| style="border:3px solid darkblue;"|'''20'''
| style="border:3px solid darkblue;"|Original UOM
| style="border:3px solid darkblue;"|ORIG_UOM
| style="border:3px solid darkblue;"|VARCHAR2(20)
| style="border:3px solid darkblue;"|BHG

|-
| style="border:3px solid darkblue;"|'''21'''
| style="border:3px solid darkblue;"|Original DU
| style="border:3px solid darkblue;"|ORIG_DU
| style="border:3px solid darkblue;"|VARCHAR2(20)
| style="border:3px solid darkblue;"|401

|-
| style="border:3px solid darkblue;"|'''22'''
| style="border:3px solid darkblue;"|Original QTY
| style="border:3px solid darkblue;"|ORIG_QTY
| style="border:3px solid darkblue;"|NUMBER(24,4)
| style="border:3px solid darkblue;"|n/a

|-
| style="border:3px solid darkblue;"|'''23'''
| style="border:3px solid darkblue;"|Unit Cost
| style="border:3px solid darkblue;"|UNIT_COST
| style="border:3px solid darkblue;"|NUMBER(12,4)
| style="border:3px solid darkblue;"|36.0600

|-
| style="border:3px solid darkblue;"|'''24'''
| style="border:3px solid darkblue;"|Unit Currency
| style="border:3px solid darkblue;"|UNIT_CURRENCY
| style="border:3px solid darkblue;"|VARCHAR2(3)
| style="border:3px solid darkblue;"|EUR

|-
| style="border:3px solid darkblue;"|'''25'''
| style="border:3px solid darkblue;"|Item Description
| style="border:3px solid darkblue;"|ITEM_DESCRIPTION
| style="border:3px solid darkblue;"|VARCHAR2(100)
| style="border:3px solid darkblue;"|RATIO AW09 CHK SRUCH WST

|-
| style="border:3px solid darkblue;"|'''26'''
| style="border:3px solid darkblue;"|Load Type
| style="border:3px solid darkblue;"|LOAD_TYPE
| style="border:3px solid darkblue;"|VARCHAR2(12)
| style="border:3px solid darkblue;"|FTL

|-
| style="border:3px solid darkblue;"|'''27'''
| style="border:3px solid darkblue;"|Freight Terms
| style="border:3px solid darkblue;"|FREIGHT_TERMS
| style="border:3px solid darkblue;"|VARCHAR2(12)
| style="border:3px solid darkblue;"|CCX

|-
| style="border:3px solid darkblue;"|'''28'''
| style="border:3px solid darkblue;"|PO DU Type
| style="border:3px solid darkblue;"|PO_DU_TYPE
| style="border:3px solid darkblue;"|VARCHAR2(20)
| style="border:3px solid darkblue;"|BHG

|-
| style="border:3px solid darkblue;"|'''29'''
| style="border:3px solid darkblue;"|PO Qty
| style="border:3px solid darkblue;"|PO_QTY
| style="border:3px solid darkblue;"|NUMBER(24,4)
| style="border:3px solid darkblue;"|401

|-
| style="border:3px solid darkblue;"|'''30'''
| style="border:3px solid darkblue;"|PO Version
| style="border:3px solid darkblue;"|PO_VERSION
| style="border:3px solid darkblue;"|VARCHAR2(12)
| style="border:3px solid darkblue;"|12

|-
| style="border:3px solid darkblue;"|'''31'''
| style="border:3px solid darkblue;"|Booking DU Type
| style="border:3px solid darkblue;"|BOOKING_DU_TYPE
| style="border:3px solid darkblue;"|VARCHAR2(20)
| style="border:3px solid darkblue;"|BHG

|-
| style="border:3px solid darkblue;"|'''32'''
| style="border:3px solid darkblue;"|Booking DU Qty
| style="border:3px solid darkblue;"|BOOKING_DU_QTY
| style="border:3px solid darkblue;"|NUMBER(24,4)
| style="border:3px solid darkblue;"|401

|-
| style="border:3px solid darkblue;"|'''33'''
| style="border:3px solid darkblue;"|Transit DU Type
| style="border:3px solid darkblue;"|TRANSIT_DU_TYPE
| style="border:3px solid darkblue;"|VARCHAR2(20)
| style="border:3px solid darkblue;"|n/a

|-
| style="border:3px solid darkblue;"|'''34'''
| style="border:3px solid darkblue;"|Transit DU Qty
| style="border:3px solid darkblue;"|TRANSIT_DU_QTY
| style="border:3px solid darkblue;"|NUMBER(24,4)
| style="border:3px solid darkblue;"|n/a

|-
| style="border:3px solid darkblue;"|'''35'''
| style="border:3px solid darkblue;"|Transit Weight
| style="border:3px solid darkblue;"|TRANSIT_WEIGHT
| style="border:3px solid darkblue;"|NUMBER(12,2)
| style="border:3px solid darkblue;"|n/a

|-
| style="border:3px solid darkblue;"|'''36'''
| style="border:3px solid darkblue;"|Transit Volume
| style="border:3px solid darkblue;"|TRANSIT_VOLUME
| style="border:3px solid darkblue;"|NUMBER(25,5)
| style="border:3px solid darkblue;"|n/a

|-
| style="border:3px solid darkblue;"|'''37'''
| style="border:3px solid darkblue;"|Sub Transit DU Type
| style="border:3px solid darkblue;"|SUB_TRANSIT_DU_TYPE
| style="border:3px solid darkblue;"|VARCHAR2(20)
| style="border:3px solid darkblue;"|n/a

|-
| style="border:3px solid darkblue;"|'''38'''
| style="border:3px solid darkblue;"|Sub Transit DU Qty
| style="border:3px solid darkblue;"|SUB_TRANSIT_DY_QTY
| style="border:3px solid darkblue;"|NUMBER(24,4)
| style="border:3px solid darkblue;"|n/a

|-
| style="border:3px solid darkblue;"|'''41'''
| style="border:3px solid darkblue;"|Receipted Date
| style="border:3px solid darkblue;"|RECEIPTED_DATE
| style="border:3px solid darkblue;"|DATE
| style="border:3px solid darkblue;"|07-JUL-2009

|-
| style="border:3px solid darkblue;"|'''42'''
| style="border:3px solid darkblue;"|Supplier Bkg Action
| style="border:3px solid darkblue;"|SUPP_BKG_ACTION
| style="border:3px solid darkblue;"|VARCHAR2(50)
| style="border:3px solid darkblue;"|SBA NO ACTION

|-
| style="border:3px solid darkblue;"|'''43'''
| style="border:3px solid darkblue;"|Supplier Bkg Action 1
| style="border:3px solid darkblue;"|SUPP_BKG_ACTION1
| style="border:3px solid darkblue;"|VARCHAR2(12)
| style="border:3px solid darkblue;"|SBA NO ACTION

|-
| style="border:3px solid darkblue;"|'''44'''
| style="border:3px solid darkblue;"|Supplier Bkg Action 2
| style="border:3px solid darkblue;"|SUPP_BKG_ACTION2
| style="border:3px solid darkblue;"|VARCHAR2(12)
| style="border:3px solid darkblue;"|SBA NO ACTION

|-
| style="border:3px solid darkblue;"|'''45'''
| style="border:3px solid darkblue;"|Supplier Bkg Action 3
| style="border:3px solid darkblue;"|SUPP_BKG_ACTION3
| style="border:3px solid darkblue;"|VARCHAR2(12)
| style="border:3px solid darkblue;"|SBA NO ACTION

|-
| style="border:3px solid darkblue;"|'''46'''
| style="border:3px solid darkblue;"|Customer Status
| style="border:3px solid darkblue;"|CUST_STATUS
| style="border:3px solid darkblue;"|VARCHAR2(12)
| style="border:3px solid darkblue;"|Open

|-
| style="border:3px solid darkblue;"|'''47'''
| style="border:3px solid darkblue;"|Delivery Priority
| style="border:3px solid darkblue;"|DEL_PRIORITY
| style="border:3px solid darkblue;"|VARCHAR2(2)
| style="border:3px solid darkblue;"|n/a

|-
| style="border:3px solid darkblue;"|'''48'''
| style="border:3px solid darkblue;"|Special Instructions
| style="border:3px solid darkblue;"|SPECIAL_INSTRUCTIONS
| style="border:3px solid darkblue;"|VARCHAR2(4000)
ItemType:P|StyleCode_Desc:KC920411|V
endorPartNumber:|PO_Created_DateTime:2009-05-15T00:00:00+00:00|LastModified_DateTime:2009-05-15T00:00:00+00:00|PO_StatusEffDateTime:2009-05-T00:00:00+00:00|PO_NumberRedirected:|PO etc….

| style="border:3px solid darkblue;"|n/a

|}
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

=REFERENCES=

{| Border="1"
| <center>'''Ref No'''</center>
| <center>'''Document Title & ID'''</center>
| <center>'''Version'''</center>
| <center>'''Date'''</center>

|-
| <center>1</center>
| EST-259410 PA-7MKDYG CN Loading Schedule Report Changes v1.doc
| <center>1</center>
| <center>06/01/09</center>
|}

=DOCUMENT HISTORY=

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

|-
| <center>1a</center>
| <center>12/01/09</center>
| <center>Draft</center>
| Initial version
| <center>PDR</center>

|-
| <center>1</center>
| <center>12/01/09</center>
| <center>Issue</center>
| Reviewed and Issued
| <center>MJC</center>
|}

=AUTHORISED BY=

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

|-
| '''''Peter Greer'''''
| TMSCC MTS Product Manager
|

|}