Data Dictionary for EDI to TMS

From UG

(Difference between revisions)
Jump to: navigation, search
(Intro)
(History)
 
(32 intermediate revisions not shown)
Line 1: Line 1:
[[Category: EDI to TMS]]
[[Category: EDI to TMS]]
-
== Intro ==
+
== Mantis ==
-
This document describes fields that will participate in integration with Lean.
+
'''0002229''': [EDI to TMS] (Preliminary) Create data dictionary / TMS to CT2 fields mapping table
-
It will be sent to Lean so they may review.
+
== Intro ==
-
 
+
-
== XML representation of Jaguar CT record ==
+
-
Only fields that required by TMS.
+
This document describes objects, fields, related XML definitions, etc that will participate in integration with TMS.
-
<CT>
+
== Goals ==
-
  <CTNum>124896</CTNum>
+
-
  <E0Client>EA Arden</E0Client>
+
-
  ...
+
-
  <CommodTable>
+
We need to identify on per fields basis:
-
    <Commodity>
+
* CT2 fields to send to TMS for each IP
-
      <PO>5454</PO>
+
* TMS fields to send to CT2 for each IP
-
      <SKU></SKU>
+
* what fields to be updated in CT2 and what in TMS
-
      ...
+
** include into xml messaging what is required
 +
** if field is present in both systems then .... block user from corrupting data
 +
* what additional fields to create/re-define in CT2
 +
* what additional fields to create/re-define in TMS
 +
* mapping of CT2 to TMS fields
-
    </Commodity>
+
== Data Dictionary ==
-
  </CommodTable>
+
-
</CT>
+
-
== Lean style CT2 data dictionary for Truck Dom ==
+
See xls in http://ct.jaguarfreight.com/mantis/view.php?id=2229
-
Type:
+
-
* A
+
-
* AN - alphanumeric
+
-
* N
+
-
* D - date
+
 +
== History ==
-
=== CT2 Field 1 ===
+
=== 0002347: [EDI to TMS] (Preliminary) CT to XML mapping ===
-
* ''Type:''
+
-
* ''Length:''
+
-
* ''Description/Notes:''
+
-
* ''Matching Lean Field:''
+
-
* ''Link to [[CT bo]]:''
+
-
=== CT Num ===
+
=== 0002693: [EDI to TMS] (Shipment_Import) Change: Pass Loose Pkgs on Shipment Import as 1 line item ===
-
* ''Type:'' N
+
-
* ''Length:'' ?
+
-
* ''Required?'' N
+
-
* ''Description/Notes:'' Unique id for the CT2 shipment
+
-
* ''Matching Lean Field:'' [[ll#ScheduleNum]]? (but it is too smal - only 3 digits!)
+
-
* ''Link to CT bo:'' [[CT#CT_Num]]
+

Current revision as of 22:04, 14 January 2011


Contents

[edit] Mantis

0002229: [EDI to TMS] (Preliminary) Create data dictionary / TMS to CT2 fields mapping table

[edit] Intro

This document describes objects, fields, related XML definitions, etc that will participate in integration with TMS.

[edit] Goals

We need to identify on per fields basis:

  • CT2 fields to send to TMS for each IP
  • TMS fields to send to CT2 for each IP
  • what fields to be updated in CT2 and what in TMS
    • include into xml messaging what is required
    • if field is present in both systems then .... block user from corrupting data
  • what additional fields to create/re-define in CT2
  • what additional fields to create/re-define in TMS
  • mapping of CT2 to TMS fields

[edit] Data Dictionary

See xls in http://ct.jaguarfreight.com/mantis/view.php?id=2229

[edit] History

[edit] 0002347: [EDI to TMS] (Preliminary) CT to XML mapping

[edit] 0002693: [EDI to TMS] (Shipment_Import) Change: Pass Loose Pkgs on Shipment Import as 1 line item

Personal tools