EDI to Schenker

From UG

(Difference between revisions)
Jump to: navigation, search
(Solution)
(Info)
Line 4: Line 4:
* This article covers Electronic Data Interchange ('''EDI''') between '''CT2''' ''as Client'' and '''Schenker''' ''as 3PL Company''.
* This article covers Electronic Data Interchange ('''EDI''') between '''CT2''' ''as Client'' and '''Schenker''' ''as 3PL Company''.
-
* It was agreed to use messages in ANSI X12 Standards:
+
* It was agreed to use the following messaging:
-
:* EDI 300 for bookings (from CT2 to Schenker)
+
:* for bookings: XLS spreadsheet (sent from approved ASN to Schenker)
-
:* EDI 214 for status updates (from Schenker to CT2)
+
:* for status updates: EDI 214 message in ANSI X12 Standard (from Schenker to CT2)
== SOWs ==
== SOWs ==

Revision as of 12:03, 24 December 2014


Contents

Info

  • This article covers Electronic Data Interchange (EDI) between CT2 as Client and Schenker as 3PL Company.
  • It was agreed to use the following messaging:
  • for bookings: XLS spreadsheet (sent from approved ASN to Schenker)
  • for status updates: EDI 214 message in ANSI X12 Standard (from Schenker to CT2)

SOWs

SOW 1 EDI to Schenker


mantis: 0004742 (phase: Dev, status: new)

Core Requirements

  • Communications
  • Schenker EDI policy is:
  • to push outbound documents to our client’s servers
  • expect clients to push files to Schenker's server.
  • FTP credentials
  • test:
  • address: dev.jaguarfreight.com
  • login: schenker_dev
  • password: *********
  • production:
  • address: ct.jaguarfreight.com
  • login: schenker
  • password: *********
  • List of Milestone Events for Air and Ocean (value in element AT701 of EDI 214).
  • Booked - A1
  • Estimated Time of Departure - C1
  • Estimated Time of Arrival - B6
  • Arrival - X4
  • Departure - AF
  • Pick up and delivery dates(estimated and actual) - to be confirmed
  • ISA and GS IDs for test and production
  • test:
  • ISA*00* *00* *02*JAFR *ZZ*SCHENKERAMT *140514*1631*U*00401*000000001*0*T*>~
  • GS*IM*JAFR*SCHENKERAMT*20140514*163038*118039*X*004010~
  • production:
  • ISA*00* *00* *02*JAFR *ZZ*SCHENKERAM *140514*1631*U*00401*000000001*0*P*>~
  • GS*IM*JAFR*SCHENKERAM*20140514*163038*118039*X*004010~

Solution

  • Currently, Schenker would want the booking emails sent to group mailbox: roacartage@dbschenker.com
  • Common IDs
  • EDI 300 mapping (bookings) example
ISA*00*          *00*          *02*JAFR           *ZZ*QUALIFIER      *140523*1428*U*00401*000000001*0*T*>~
GS*SM*JAFR*QUALIFIER*20140523*142840*475811*X*004010~
ST*300*0001~
B1*SCAC*CT475811**N~
Y1*20140323*N**Norfolk, VA~
Y2*2*40HQ~
N1*SH*ELIZABETH ARDEN~
N3*1751 BLUE HILLS DRIVE~
N4*ROANOKE*VA*24012*US~
N1*CN*CEPL~
N3*CHEMIN LES LONGS REAGES~
N4*ROANOKE*VA*24012*US~
N1*DA*NORFOLK INTERNATIONAL TERMINAL~
N3*7737 HAMPTON BLVD.~
N4*NORFOLK*VA*23504*US~
R4*L***Norfolk, VA~
DTM*370*20140323~
R4*D***Le Havre~
DTM*372*20140407~
LX*1~
N7*OOLU*8098014~
N7*OOLU*8098014~
V1**OOCL KAOHSIUNG**065E*OOLU~
SE*22*0001~
GE*000001*475811~
IEA*1*000000001~
  • EDI 214 mapping (status updates) example
ISA*00*          *00*          *ZZ*SCHENKERAMT    *02*JAFR           *141119*0213*U*00401*000002764*0*T*>
GS*QM*SCHENKERAMT*JAFR*20141119*0213*2764*X*004010
ST*214*000002764
B10*ROA92018894*SHIPMENT_NUMBER*SCNK
LX*1
AT7*X4*NS***20141115*175200*ES
L11*1*QN*USARD1
SE*6*000002764
GE*1*2764
IEA*1*000002764



SOW 2: ...


mantis: ??? (phase: ???, status: ???)

Core Requirements

  • ...
  • ...

Solution

TBD



Personal tools