Data Dictionary for EDI to TMS

From UG

(Difference between revisions)
Jump to: navigation, search
(→Lean style CT2 data dictionary for Truck Dom)
Line 18: Line 18:
 +
 +
== CT2 Truck Dom fields as of July 2010 ==
 +
=== Shipper and Planner Fields ===
 +
List below is from [[Cybertrax 2.1 Client (data dictionary)]]
 +
<pre>
 +
# 1 CT fields
 +
 +
    * 1.1 PO Issued by
 +
    * 1.2 Pick up Location
 +
    * 1.3 Ship to Location
 +
    * 1.4 Pick up Instructions
 +
    * 1.5 Commodity Description
 +
    * 1.6 Cargo Available
 +
    * 1.7 Fields that Shipper can not edit
 +
          o 1.7.1 Shipper
 +
          o 1.7.2 Pick Up Trucker
 +
          o 1.7.3 Delivery Trucker
 +
          o 1.7.4 Estimated Pick up date
 +
          o 1.7.5 Actual Pick up date
 +
          o 1.7.6 Estimated Delivery date
 +
          o 1.7.7 Actual Delivery date
 +
          o 1.7.8 Last Update
 +
          o 1.7.9 Last Update date time
 +
          o 1.7.10 Routed Date
 +
    * 1.8 Field related to Planners
 +
          o 1.8.1 CT Authorization status
 +
          o 1.8.2 Approved For Date
 +
          o 1.8.3 Approved By
 +
          o 1.8.4 Approved On
 +
          o 1.8.5 Authorization Comment
 +
 +
# 2 Commodity fields
 +
 +
    * 2.1 P.O.
 +
    * 2.2 SKU
 +
    * 2.3 Quantity
 +
    * 2.4 Item Description
 +
    * 2.5 Number of Plts
 +
    * 2.6 Pkgs on Plts
 +
    * 2.7 Loose Pkgs
 +
    * 2.8 GW
 +
    * 2.9 GW Unit
 +
    * 2.10 Haz/Non-Haz
 +
    * 2.11 Stackable
 +
    * 2.12 Piece price
 +
    * 2.13 Total Value
 +
</pre>
 +
 +
=== Additional fields for Truck Dom available for Jaguar internal user ===
 +
 +
...
 +
 +
[[#Consol Warehouse]]
 +
 +
...
== Lean style CT2 data dictionary for Truck Dom ==
== Lean style CT2 data dictionary for Truck Dom ==

Revision as of 15:42, 20 July 2010


Contents

Intro

This document describes fields that will participate in integration with Lean.

It will be sent to Lean so they may review.

Required fields and updates

Minimum set of CT2 fields required by TMS from CT2 for IP1

Minimum set of fields required by CT2 from TMS for IP2 IP3 IP4

Internal

Client Shipper Planner

CT2 Truck Dom fields as of July 2010

Shipper and Planner Fields

List below is from Cybertrax 2.1 Client (data dictionary) 

# 1 CT fields

    * 1.1 PO Issued by
    * 1.2 Pick up Location
    * 1.3 Ship to Location
    * 1.4 Pick up Instructions
    * 1.5 Commodity Description
    * 1.6 Cargo Available
    * 1.7 Fields that Shipper can not edit
          o 1.7.1 Shipper
          o 1.7.2 Pick Up Trucker
          o 1.7.3 Delivery Trucker
          o 1.7.4 Estimated Pick up date
          o 1.7.5 Actual Pick up date
          o 1.7.6 Estimated Delivery date
          o 1.7.7 Actual Delivery date
          o 1.7.8 Last Update
          o 1.7.9 Last Update date time
          o 1.7.10 Routed Date
    * 1.8 Field related to Planners
          o 1.8.1 CT Authorization status
          o 1.8.2 Approved For Date
          o 1.8.3 Approved By
          o 1.8.4 Approved On
          o 1.8.5 Authorization Comment

# 2 Commodity fields

    * 2.1 P.O.
    * 2.2 SKU
    * 2.3 Quantity
    * 2.4 Item Description
    * 2.5 Number of Plts
    * 2.6 Pkgs on Plts
    * 2.7 Loose Pkgs
    * 2.8 GW
    * 2.9 GW Unit
    * 2.10 Haz/Non-Haz
    * 2.11 Stackable
    * 2.12 Piece price
    * 2.13 Total Value

Additional fields for Truck Dom available for Jaguar internal user

...

#Consol Warehouse

...

Lean style CT2 data dictionary for Truck Dom

Type:

  • A
  • AN - alphanumeric
  • N
  • D - date


CT2 Field 1

  • Description/Notes:
  • Matching Lean Field:
  • Link to CT bo:
  • Type:
  • Length:
  • Required?

CTNum

  • 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
  • Type: N
  • Length: ?
  • Required? N

XML representation of Jaguar CT record using Jaguar names

Only fields that required by TMS. 

<CT>
  <CTNum>124896</CTNum>
  <E0Client>EA Arden</E0Client>
  ...
  <CommodTable>
    <Commodity>
      <PO>5454</PO>
      <SKU></SKU>
      ...
    </Commodity>
  </CommodTable>
</CT>
Retrieved from "https://wiki.jaguarfreight.com/Data_Dictionary_for_EDI_to_TMS"
Personal tools