Requirements for EDI to TMS

From UG

(Difference between revisions)
Jump to: navigation, search
(CT2 and TMS integration)
Line 39: Line 39:
* update above will be forwarded into CT2 through EDI
* update above will be forwarded into CT2 through EDI
-
Requirements/Design tasks breakdown:
+
==== Requirements/Design tasks breakdown ====
* analyze documentation provided by TMS vendor  
* analyze documentation provided by TMS vendor  
Line 53: Line 53:
** document most typical use cases
** document most typical use cases
-
Development tasks breakdown:
+
==== Development tasks breakdown ====
 +
 
* review REQ doc
* review REQ doc
* review TMS guide
* review TMS guide

Revision as of 16:26, 16 July 2010


Contents

About

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

Intro

Jaguar needs ability to optimize truck domestic shipments:

  • create optimal loads, cost, routs, etc
  • automate tariffs, communication with carriers

Above features are normally present in TMS software.

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

Currently there are 2 systems we are considering:

  • from Descartes
  • from Lean Logistics

CT2 and TMS integration

In a nutshell:

  • shipment record will be created in CT2 and forwarded to TMS through EDI
  • in TMS Jag oper will run optimizations
  • TMS sens bids to carriers
  • one carrier accepts the bid and start moving shipments
  • carrier submits updates into TMS (example: actual pickup date)
  • update above will be forwarded into CT2 through EDI

Requirements/Design tasks breakdown

  • analyze documentation provided by TMS vendor
  • identify what CT fields to send to TMS
    • provide mapping (name in CT2 vs name in TMS, for example in CT2 what we call "HU" in TMS might be called "Units")
    • create "DD (data dictionary) wiki"
      • identify and document gaps between type/format of fields in TMS vs EDI
    • identify if we have any fields missing in CT2 that is required for optimization
    • create examples of XML strings that would be used to send (assume we send over FTP):
      • CT info to TMS from CT2
      • updates from TMS to CT2
  • design complete workflow
    • document most typical use cases

Development tasks breakdown

  • review REQ doc
  • review TMS guide
  • decide on particular technology for EDI (message format, protocol)
  • implement
  • test
Personal tools