Requirements for EDI to TMS

From UG

(Difference between revisions)
Jump to: navigation, search
(→User to TMS interaction and workflow)
(→About and See also)
 
(17 intermediate revisions not shown)
Line 2: Line 2:
== About and See also ==  
== About and See also ==  
-
This is a Analysis / Requirements wiki for EDI to TMS proj
+
This is a Analysis / Requirements wiki for EDI to TMS proj Mantis: [http://mantis.jaguarfreight.com/mantis/view.php?id=2183 2183]
=== Related ===
=== Related ===
Line 47: Line 47:
* from Lean Logistics
* from Lean Logistics
-
=== CT2 and TMS integration ===
+
=== CT2 and TMS integration in a nutshell ===
In a nutshell:
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, code 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, code 214''' TMS '''periodically''' submits updates into TMS (example: actual pickup date, etc)
Line 75: Line 75:
Below are some examples of EDI messages used in Transportation
Below are some examples of EDI messages used in Transportation
Manager.
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 ==
+
* '''Shipment Import'''
 +
* 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.
-
See also: [[Data_Dictionary_for_EDI_to_TMS#Descartes_Objects_and_fields]]
+
== Business Requirements ==
-
=== Add ===
+
== Integration points ==
-
==== Example xml ====
+
See following wikis:
-
Filename: Sample Shipment Import.xml
+
* [[Shipment Import]]
 +
* [[Load Plan]]
 +
* [[Status Message]]
-
<pre>
+
== Data dictionary and mapping ==
-
<?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&#xA;" 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>
+
-
</pre>
+
-
=== Update ===
+
see [[Data Dictionary for EDI to TMS]]
-
=== Delete ===
+
-
== IP2 Order Sequencing ==
+
== History ==
-
== IP3 Carrier Info ==
+
-
== IP4 Load Status ==
+
-
=== Example xml ===
+
=== 0002346: [EDI to TMS] Shipper role features ===
-
''Filename:'' Sample Status Message.xml
+
=== 0002361: [EDI to TMS] Implement FTP-connection functionality ===
-
<pre>
+
=== 0002327: [EDI to TMS] (Preliminary) a) proof of concept for ... CT data in the form of XML b) settings in non jag user profile for TMS ===
-
<?xml version="1.0" encoding="utf-8"?>
+
* This task was replaced by M 2418
-
<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>
+
=== 0002418: [EDI to TMS] (Client App Admin) (TMS Tab) Add TMS tab with config options ===
-
    <Sender>
+
 
-
      <senderID>069035124</senderID>
+
=== 0002361: [EDI to TMS] Implement FTP-connection functionality ===
-
    </Sender>
+
 
-
    <Receiver>
+
=== 002493[EDI to TMS] Hide TMS Status on CT record header description for MOT Air&Ocean; if possible pls hide for truck air & truck ocean ===
-
      <receiverID>069035124</receiverID>
+
 
-
    </Receiver>
+
=== 0002451: [EDI to TMS] (Client App Admin) (TMS Tab) Changes to accomodate Connecting Production/Demo Environments ===
-
    <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>
+
-
</pre>
+

Current revision as of 20:17, 20 December 2010


Contents

[edit] About and See also

This is a Analysis / Requirements wiki for EDI to TMS proj Mantis: 2183

[edit] Related

See also: Data Dictionary for EDI to TMS

[edit] 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

[edit] Introduction

Core Business Need: Jaguar needs ability to optimize truck domestic shipments:

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:

[edit] Vendor evaluation

Currently there are 2 systems we are considering:

  • from Descartes
  • from Lean Logistics

[edit] 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, code 990 TMS sends updates to CT2 (Carrier confirmed, etc)
  • (start processing shipments)
  • IP3: Status Message, code 214 TMS periodically submits updates into TMS (example: actual pickup date, etc)


See Figure below:

[edit] Figure Integration Points as defined by Descartes

File:Descartes IPs.JPG

[edit] Examples

Below are some examples of EDI messages used in Transportation Manager.

  • Shipment Import
  • 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.

[edit] Business Requirements

[edit] Integration points

See following wikis:

[edit] Data dictionary and mapping

see Data Dictionary for EDI to TMS

[edit] History

[edit] 0002346: [EDI to TMS] Shipper role features

[edit] 0002361: [EDI to TMS] Implement FTP-connection functionality

[edit] 0002327: [EDI to TMS] (Preliminary) a) proof of concept for ... CT data in the form of XML b) settings in non jag user profile for TMS

  • This task was replaced by M 2418

[edit] 0002418: [EDI to TMS] (Client App Admin) (TMS Tab) Add TMS tab with config options

[edit] 0002361: [EDI to TMS] Implement FTP-connection functionality

[edit] 002493[EDI to TMS] Hide TMS Status on CT record header description for MOT Air&Ocean; if possible pls hide for truck air & truck ocean

[edit] 0002451: [EDI to TMS] (Client App Admin) (TMS Tab) Changes to accomodate Connecting Production/Demo Environments

Retrieved from "https://wiki.jaguarfreight.com/Requirements_for_EDI_to_TMS"
Personal tools