Requirements for EDI to TMS
From UG
(→CT2 and TMS integration) |
(→CT2 and TMS integration in a nutshell) |
||
Line 59: | Line 59: | ||
* (TMS sens bids to carriers) | * (TMS sens bids to carriers) | ||
- | * '''IP2: Load Plan''' TMS sends updates to CT2 (Carrier confirmed, etc) | + | * '''IP2: Load Plan 990''' TMS sends updates to CT2 (Carrier confirmed, etc) |
* (start processing shipments) | * (start processing shipments) | ||
- | * '''IP3: Status Message''' TMS '''periodically''' submits updates into TMS (example: actual pickup date, etc) | + | * '''IP3: Status Message 214''' TMS '''periodically''' submits updates into TMS (example: actual pickup date, etc) |
Revision as of 18:31, 15 October 2010
Contents |
About and See also
This is a Analysis / Requirements wiki for EDI to TMS proj
Related
See also: Data Dictionary for EDI to TMS
Glossary
IP - Integration Point
Tendering - Tendering is the process of offering a load to a carrier and efficiently managing their response.
NOTE: Descartes Transportation Manager enables you to communicate with your contracted carriers electronically or manually. You set the communication method for a carrier when you set up your carrier contracts.
See also: p 205 of TM+10.1.3+Users+Guide.pdf
Introduction
Core Business Need: Jaguar needs ability to optimize truck domestic shipments:
- create optimal loads and routs (About Loads and Shipments p151, Consolidation p173 , TM 10.1.3 Users Guide.pdf in mantis http://mantis.jaguarfreight.com/mantis/view.php?id=2183)
Above features are normally present in TMS software. In addition this kind of system can:
- automate tariffs (Working with Contracts chapter)
- communication with carriers
To achieve that it was decided:
- buy and use existing TMS solution (phase 1)
- gradually add these features to CT2 (phase 2)
To complete phase 1 we need to implement:
- #Vendor evaluation (completed)
- #CT2 and TMS integration - arrange data interchange
- #TMS User interaction and workflow - how CT2 (Client and Internal) will be used in conjunction with TMS
Vendor evaluation
Currently there are 2 systems we are considering:
- from Descartes
- from Lean Logistics
CT2 and TMS integration in a nutshell
In a nutshell:
- (shipment record will be created in CT2 and approved)
- IP1: Shipment Import New CT2 forwarded to TMS through EDI
- (in TMS Jag oper will run optimizations and select carrier)
- (TMS sens bids to carriers)
- IP2: Load Plan 990 TMS sends updates to CT2 (Carrier confirmed, etc)
- (start processing shipments)
- IP3: Status Message 214 TMS periodically submits updates into TMS (example: actual pickup date, etc)
See Figure below:
Figure Integration Points as defined by Descartes
Examples
Below are some examples of EDI messages used in Transportation Manager.
- 204 – Load tender message from Transportation Manager to the
carrier. A load tender is a request to pick up a shipment and move it to another location.
- 990 – Load Plan - The carrier’s tender response back to Transportation Manager
(either a yes for picking up the shipment or no for not picking up the shipment).
- 214 – A Status message from the carrier to Transportation Manager
(e.g., “Delivered”).
- 210 – An invoice from the carrier to Transportation Manager. The
invoice will have the cost details of moving the shipment.
IP1 New Order
See also: Data_Dictionary_for_EDI_to_TMS#Descartes_Objects_and_fields
Add
Example xml
Filename: Sample Shipment Import.xml
<?xml version="1.0" encoding="iso-8859-1"?> <ns0:Envelope xmlns:wsa="http://schemas.xmlsoap.org/ws/2004/03/addressing" xmlns:ns0="http://www.w3.org/2003/05/soap-envelope" xmlns:ebi="http://www.myvan.descartes.com/ebi/2004/r1"> <ns0:Header> <wsa:From> <wsa:Address>urn:duns:657589457</wsa:Address> </wsa:From> <wsa:To>urn:duns:657589457</wsa:To> <wsa:Action>urn:myvan:856</wsa:Action> <ebi:Sequence> <ebi:MessageNumber>12117</ebi:MessageNumber> </ebi:Sequence> <wsa:MessageID></wsa:MessageID> </ns0:Header> <ns0:Body> <parmDocEnvelope> <DocShipment ShipmentNo="3161007" LoadNo="3161007" MessagePurpose="1005" CarrierCode="RDWY" EarliestAvailDate="2010-03-11T08:00:00" LatestAvailDate="2010-03-11T16:00:00" TotalWgt="98" WgtUOM="200"> <DSGOriginAddress LocationNo="08081831" StreetName="7725 PARKLAWN AVENUE" City="EDINA" State="MN" PostalCode="55439" Country="US" CompanyName="Company ABC"></DSGOriginAddress> <DSGDestinationAddress LocationNo="" StreetName="95 Paquin Road WINNIPEG " City="MANITOBA" State="MB" PostalCode="R2J 3V9" Country="CA" CompanyName="Consumer Products"></DSGDestinationAddress> <DSGReferenceNumbers RefNoType="SBU Unit" Value="XYZ"></DSGReferenceNumbers> <DSGReferenceNumbers RefNoType="System ID" Value="VSC"></DSGReferenceNumbers> <DSGReferenceNumbers RefNoType="GL Account 1" Value="080807114612010000002001000000000000000000"></DSGReferenceNumbers> <DocShpLineItem ContainerQuantity="1" Description="Goods" TotalLineItemWeight="98" WgtUOM="200" ContainerType="15" LineItemNumber="1"></DocShpLineItem> </DocShipment> </parmDocEnvelope> </ns0:Body> </ns0:Envelope>
Update
Delete
IP2 Order Sequencing
IP3 Carrier Info
IP4 Load Status
Example xml
Filename: Sample Status Message.xml
<?xml version="1.0" encoding="utf-8"?> <Dragon xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:Num="Num-namespace-URI" xmlns:Num2="Num2-namespace-URI"> <Header> <Sender> <senderID>069035124</senderID> </Sender> <Receiver> <receiverID>069035124</receiverID> </Receiver> <ControlData> <SendDateTime> <dateTime>20090402 182951</dateTime> </SendDateTime> <docType>214</docType> </ControlData> </Header> <Request> <DocTracking TrackingID="2507" BOLID="359" LoadID="479" BOLNo="BOL000000358" MasterShipmentNumber="LD000000352" TrackDate="2009-04-02T13:49:00" TrackInfo="LD000000352" City="ELK GROVE VILLAGE" State="IL" Country="US" Event="2028" Reason="3042" EventDescription="Picked up" ReasonDescription="Normal" SCAC="ABCD"> <DocShipment TrackingID="2507" ShipmentID="414" ShipmentNo="A8I106753-001"> <DSGReferenceNumbers RefNoType="" Value="0"></DSGReferenceNumbers> <DSGReferenceNumbers RefNoType="Inland carrier booking no" Value="203569317"></DSGReferenceNumbers> <DSGReferenceNumbers RefNoType="Shipment Type" Value="STD"></DSGReferenceNumbers> <DSGReferenceNumbers RefNoType="AJK Reference Number" Value="A8I106753"></DSGReferenceNumbers> <DSGReferenceNumbers RefNoType="Voyage or FlightNumber" Value="OS0094"></DSGReferenceNumbers> <DSGReferenceNumbers RefNoType="Customer Reference Number" Value="757264"></DSGReferenceNumbers> <DSGReferenceNumbers RefNoType="" Value="XYZ AIRLINES"></DSGReferenceNumbers> <DSGReferenceNumbers RefNoType="" Value="AIR FREIGHT"></DSGReferenceNumbers> </DocShipment> </DocTracking> </Request> </Dragon>