Requirements for EDI to TMS

From UG

(Difference between revisions)
Jump to: navigation, search
(Created page with 'Category:EDI to TMS')
Line 1: Line 1:
[[Category:EDI to TMS]]
[[Category:EDI to TMS]]
 +
 +
== 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]]
 +
* [[#CT2 and TMS integration]]
 +
 +
=== 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

Revision as of 16:25, 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