261357
261357 MW-7PBH9Q Tesco Outbound Booking Msg
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
1. An outbound EDI is required to trigger messages to Tesco on booking status changes such as confirmed and cancelled. 2. An outbound message should also be triggered by trip status confirmed (this would effectively end the lifecycle of the booking). 3. Lastly an outbound message containing booking and trip information of all current Tesco bookings, orders and trips should be sent to Tesco via ESI daily (this should exclude any orders/bookings which have had a prior message of confirmed sent to Tesco earlier in trip process). It is suggested this should be at 00:01.
Solution
A new outbound flow will be created for Tesco orders. The file will be created using XML and will match the format provided in the RIO.
The message will be triggered when the status is change for a Purchase Order. When this is the case the file will contain the Purchase Order information only.
The message will also be triggered for some trip status changes.
When the trip moves to Accepted status. When the POC is set for an order and the trip is at status EN-ROUTE When the POD is set for an order and the trip is at status COMPLETED
When the message is triggered by the trip status change the file will contain the trip information and the order and purchase order information for any orders that match the criteria (POC, POD flag).
The files will be placed in a specific outbound folder for collection.
Information about each file sent will be viewed in the Interface Errors screen.
Scope
This change will be applied to system version 10.6.
Functional Description
A new outbound file, created using XML, will be produced for Tesco orders. This file will be generated under the following circumstances.
1) When a status is changed on a Purchase Order. 2) When a Trip is set to status Accepted. 3) When a Trip is set to status En-route and an order on the trip has the POC flag set to ‘Y’, or the status is currently En-route and the POC flag is set to ‘Y’. 4) When a Trip is set to status Completed and an order on the trip has the POD flag set to ‘Y’, or the status is currently Completed and the POD flag is set to ‘Y’.
When the file is created from a status change on the purchase order, only the purchase order information will be included in the file (no trip or order information). If the file is created from a status change on a trip then all the information (Purchase order, order and trip) will be included.
Each time a status change occurs a record will be written to the new table INT_PO_OUTBOUND_HEADER, providing an unsent record does not exists for the PO_REFERENCE.
A database job will be set up to process any records in the table that have a status of ‘SEND’. All the records at status ‘SEND’ will be included in the file, and the record status will be updated to ‘SENT’. The created file will be put in the outbound directory ready for collection.
Appendix A
New Tables INT_PO_OUTBOUND FILE and INT_PO_OUTBOUND_NON_CONFORM created under different log.
Add column RECORD_STATUS (varchar2 (12)) to table INT_PO_OUTBOUND_NON_CONFORM.
Appendix B
<OBS_POM>
<EVENT>
<EVENT_HEADER>
<EVENT_DESTINATION_TYPE>MTS</EVENT_DESTINATION_TYPE>
<EVENT_DESTINATION_NAME>IILV</EVENT_DESTINATION_NAME>
<EVENT_SOURCE_NAME>TESCO</EVENT_SOURCE_NAME>
<EVENT_DATE>2009-03-16T12:34:12</EVENT_DATE>
<EVENT_ACTION>A</EVENT_ACTION>
</EVENT_HEADER>
<EVENT_DETAIL>
<PURCHASE_ORDERS>
<PURCHASE_ORDER>
<PO_HEADER>
<PO_REFERENCE>123456123456789</PO_REFERENCE>
<PO_ID>123456</PO_ID>
<ITEM_NUMBER>123456789</ITEM_NUMBER>
<PO_NUMBER>460-81733</PO_NUMBER>
<COST_CENTRE>EXEL</COST_CENTRE>
<CUSTOMER>TESCO</CUSTOMER>
1000709 <HUB>TR</HUB>
<DESTINATION>5662738</DESTINATION>
<CARGO_READY>2009-03-16</CARGO_READY>
<PROD_TYPE_ID>AMBIENT</PROD_TYPE_ID>
<DELIVERY_DATE>2009-03-26</DELIVERY_DATE>
<TRANSPORT_MODE>Road</TRANSPORT_MODE>
<UNIT_COST>7.0095</UNIT_COST>
<UNIT_CURRENCY>USD</UNIT_CURRENCY>
<ITEM_DESCRIPTION>T-SHIRT LARGE</ITEM_DESCRIPTION>
<FREIGHT_TERMS>PPD</FREIGHT_TERMS>
<PO_DU_TYPE>PAIRS</PO_DU_TYPE>
<PO_QTY>15000</PO_QTY>
<PO_VERSION>1</PO_VERSION>
<SUPP_BKG_ACTION>SBA ACCEPTED</SUPP_BKG_ACTION>
<CUST_STATUS>Open</CUST_STATUS>
<SPECIAL_INSTRUCTIONS>39584|460-81733|N|900|100|Y|BDCGP|BDCGP|GBP|Y|S|T-SHIRT LARGE|2763294|EVENT|SS08|Y|Y|128|RHL1|RHL2|RHL3</SPECIAL_INSTRUCTIONS>
</PO_HEADER>
<PO_TRACKING>
<PO_STATUS>CONFIRMED</PO_STATUS>
<ORIGINAL_QTY>10000</ORIGINAL_QTY>
<LOAD_TYPE>CY/CY</LOAD_TYPE>
<SCHED_NAME>080516</SCHED_NAME>
<BOOKING_DU_TYPE>PAIRS</BOOKING_DU_TYPE>
<BOOKING_DU_QTY>10000</BOOKING_DU_QTY>
<TRANSIT_DU_TYPE>CARTONS</TRANSIT_DU_TYPE>
<TRANSIT_DU_QTY>500</TRANSIT_DU_QTY>
<TRANSIT_WEIGHT>5000</TRANSIT_WEIGHT>
<TRANSIT_VOLUME>64.123</TRANSIT_VOLUME>
<SUB_TRANSIT_DU_TYPE>PAIRS</SUB_TRANSIT_DU_TYPE>
<SUB_TRANSIT_DU_QTY>10000</SUB_TRANSIT_DU_QTY>
<RECEIPTED_DATE>2009-03-16</RECEIPTED_DATE>
<PO_REASON_CODE1>EL_SP</PO_REASON_CODE1>
<PO_REASON_CODE2>EL_PL</PO_REASON_CODE2>
<PO_REASON_CODE3>EL_RO</PO_REASON_CODE3>
<TI_GENERATED>Y</TI_GENERATED>
<SOURCE_SYSTEM>MTS_IFACE</SOURCE_SYSTEM>
<CREATED_BY>MTS_INTERFACE</CREATED_BY>
<CREATED_DATE>2009-03-16T12:24:34</CREATED_DATE>
<UPDATED_BY>WILSONM</UPDATED_BY>
<UPDATED_DATE>2009-03-16T15:23:24</UPDATED_DATE>
</PO_TRACKING>
<TRIP_TRACKING>
<TRIP_ID>MAN-00460155</TRIP_ID>
<TRIP_REF>M358104</TRIP_REF>
<TRIP_STATUS>ACCEPTED</TRIP_STATUS>
<CONTAINER>123324</CONTAINER>
<TRIP_TRAILER_ID>78643</TRIP_TRAILER_ID>
<TRIP_TRAILER_TYPE>44ft Rigid</TRIP_TRAILER_TYPE>
<TRACTOR>VE55 ODM</TRACTOR>
<HAULIER>PRIMUS</HAULIER>
<SHIP_FROM_COUNTRY>TR</SHIP_FROM_COUNTRY>
<SHIP_TO_COUNTRY>UK</SHIP_TO_COUNTRY>
<PLAN_REG_FROM>AP</PLAN_REG_FROM>
<PLAN_REG_TO>L1</PLAN_REG_TO>
<PLAN_EARLY_DEPART>2009-03-16T12:59:10</PLAN_EARLY_DEPART>
<PLAN_EARLY_ARRIVAL>2009-03-26T12:59:00</PLAN_EARLY_ARRIVAL>
<ACT_EARLY_DEPART>2009-03-16T11:59:00</ACT_EARLY_DEPART>
<ACT_EARLY_ARRIVAL>2009-03-26T13:59:00</ACT_EARLY_ARRIVAL>
<SEAL_NO>12123376</SEAL_NO>
<FULL_LOAD>GROUPAGE</FULL_LOAD>
<TRIP_COMMENTS>http://www.dhl.com/supplierconf?dsff</TRIP_COMMENTS>
</TRIP_TRACKING>
<ORDER_TRACKING>
<OMS_REF>17475</OMS_REF>
<DELIVERY_TYPE>Standard</DELIVERY_TYPE>
<DESTINATION>TESCCHEST</DESTINATION>
<ORDER_COMMENT>V613-5 TAUT LINERS NO BOX TRAILERS DELIVER BETWEEN 8.30-16.00 DEL.FRI 8.30AM - 11.30AM NO COOLER TRAILER 1 REEL WRAPPED TOGETHER</ORDER_COMMENT>
<STOP_SEQ>0203</STOP_SEQ>
<EXTERNAL_REF>105381419053</EXTERNAL_REF>
<DEL_POINT_REF>AS274493</DEL_POINT_REF>
</ORDER_TRACKING>
<DELIVERY_REASON_CODES>
<REASON_CODE>
<RC_CODE>01</RC_CODE>
<RC_DESCRIPTION>Late due to supplier issue.</RC_DESCRIPTION>
</REASON_CODE>
</DELIVERY_REASON_CODES>
</PURCHASE_ORDER>
</PURCHASE_ORDERS>
</EVENT_DETAIL>
</EVENT>
</OBS_POM>
References
Document History
| Initial version |
Authorised By
| Dave Meir | Development Manager |
|
| Suk Sandhu | TMSCC MTS Product Manager |
