EDI to CargoSmart

From UG

Revision as of 16:11, 25 May 2015 by Andrei (Talk | contribs)
Jump to: navigation, search


Contents

Info

  • ...

SOWs

SOW 1 EDI to CargoSmart


mantis: 0004743 (phase: Dev, status: feedback)

Core Requirements

  • Implement EDI to Cargosmart to send booking request and shipment instruction to receive status updates to update CT2.
  • Sending
    • EDI 300 Booking Request
    • EDI 303 Booking Cancellation
    • EDI 304 Shipment Instruction
  • Receiving
    • EDI 301 Booking Confirmation
    • EDI 315 Status Details (Ocean)

Solution

  • .


Post-Implementation Notes

  • 2.39.0
  • Implement EDI to Cargosmart to send booking request and shipment instruction to receive status messages to update CT2.
  • Create ability to add contract number per office for each steamshipline in admin.
  • 2.39.1
  • Implement EDI 300 and 304 messages to send “B.J. International, Inc. d/b/a Jaguar Freight Services” as hard coding master shipper information on EDI message
  • 2.39.2
  • N/A
  • 2.39.3
  • Provide ability to send EDI 300/304 from Master without shipments - remove validation
  • 2.39.4
  • Provided some more mapping info for LX loop.
  • 2.39.5
  • Provided some more required info to add validation for ports/terminals information.
  • 2.39.6
  • Provided some more mapping info for default weight value.
  • 2.39.7
  • Update a log for some updated vessel name info from 301.
  • 2.40.2
  • Create an admin setting to enable/disable process and how frequently to handle incoming files from cargosmart.



SOW 2 Cargosmart Events


mantises:

0004743, (phase: Dev, status: feedback)
0004898, (phase: Dev, status: feedback)

Core Requirements

  • Add new date fields in CT2, per listed CT2 Fields Map for Cargosmart Events.
  • CT2 Fields Map for Cargosmart Events
  • Create new "Ocean Transportation Events" tab for new fields, in CT and Master.

Solution

  • Dates of Cargosmart events will be transmitted from Cargosmart via EDI 315 Status Details (Ocean) Transaction Set to update CT2 dates:
  • B4 segment (Beginning Segment for Inquiry or Reply) transmits:
  • B403: Shipment Status Code (AE in Example below)
  • B404: Date of last reported status of cargo (20150107 in Example below)
  • Example: B4***AE*20150107*0851**OOLU*041034*L*22GP*BEANR*UN*2~ means "Loaded on Board at First Port of Load on 07-Jan-2015"
  • N9 segment (Reference Identification Qualifier) with N901 = BN (Booking Number) transmits:
  • N902: Booking Number as Reference Identification (2559940731 in Example below)
  • Example: N9*BN*2559940731~
  • For Ocean shipments, the following fields will be updated from EDI 315 including "TEvents" tab:
Event Description Shipment Status Code CT2 Mapping
Arrival at Last Intermodal Hub AR Actual Arrival date - Destination Terminal
Last Vessel Arrival VA Actual Arrival Date - Port of Arrival
Actual Door Delivery D Actual Delivery Date
First Loaded on Rail Under Outbound AL Actual departure date - Origin Terminal
First Vessel Departure VD Actual Departure date - Port of Departure
Transshipment Vessel Departure Z5 Actual Departure Date - Transshipment Port
Actual Door Pickup AF Actual Pick Up Date
Empty Container Picked Up EE New Fields (TEvents)
Full Container Received by Carrier at Origin OA
Departure from First Intermodal Hub RL
Arrival at First Port of Load I
Loaded on Board at First Port of Load AE
Loaded at Port W6
Vessel Departure X2
Loaded at Port of Transshipment Z3
Discharged at Port of Transshipment Z4
Discharged from Vessel at Last Port of Discharge UV
Container Picked up from Port of Discharge/Transshipment Port Y9
First Loaded on Rail Under Inbound Z7
Intermodal Departure from Last Port of Discharge Z6
Equipment Delayed due to Transportation W3
Loaded on Rail Y3
Arrival at Intermodal Hub by Rail Y2
Gate In Full at Inland Terminal W2
Gate Out Full at Inland Terminal W1
Loaded on Truck AM
Customs Hold PA
Carrier Held X9
Freight Charges Settled NO
Carrier Released CR
Customs Released CT
Picked up at Final Destination for Delivery Z8
Empty Container Returned to Carrier at Destination RD



Personal tools