EDI to CargoSmart

From UG

(Difference between revisions)
Jump to: navigation, search
(Solution)
(SOW 1 EDI to CargoSmart (initial tasks))
Line 16: Line 16:
:* Sending
:* Sending
:** EDI 300 Booking Request
:** EDI 300 Booking Request
-
:** EDI 303 Booking Cancellation
 
:** EDI 304 Shipment Instruction
:** EDI 304 Shipment Instruction
:* Receiving
:* Receiving

Revision as of 18:18, 25 May 2015


Contents

Info

  • ...

SOWs

SOW 1 EDI to CargoSmart (initial tasks)


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 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 EDI 303 Booking Cancellation


mantises:

0004743, (phase: Dev, status: feedback)
0004909, (phase: UAT, status: new)

Core Requirements

  • Send EDI 303 Booking Cancellation to Cargosmart from CT Master

Solution

  • .



SOW 3 Some mapping in EDI 301 Booking Confirmation


mantises:

0004908, (phase: UAT, status: new)

Core Requirements

  • Upload dates into the Master fields as listed below:
  • EXPECTED SAILING DATE : 05/28/2015
  • PORT OF DISCHARGE : 06/11/2015
  • Upload deadline for the documents/dates:
  • AES (for US laden cargo) customs document deadline
  • Shipping Instruction/BL Master deadline for 304 transmission
  • CUTOFF DATE/TIME : deadline for delivering the cargo at the Port
  • Note: phase 1 comments, phase 2 “TEvents” (in the Master?) > Dashboards for impending/Past due dates will be needed.
  • Support mapping of RETURN LOCATION to “Master delivery” in Master GEN Tab

Solution

  • Implemented with receiving EDI 301:
  • EXPECTED SAILING DATE
  • Transmitting data: The ETD at First POL as declared in DTM*139*<Date> under R4*L.
  • CT2 mapping: ETD of Master Port of Loading.
  • EXPECTED ARRIVAL AT PORT OF DISCHARGE.
  • Transmitting data: The ETA at Last POD as declared in DTM*139*<Date> under R4*D.
  • CT2 mapping: ETA of Master Port of Discharge.
  • Shipping Instruction/BL Master deadline for 304 transmission.
  • Transmitting data: the Document Due Date as declared in DTM*649*<Date> under R4*L.
  • CT2 mapping: text line in "[Master] Bill Of Lading Comment".
  • Example: "304 submission deadline: 01-23-15".
  • CUTOFF DATE/TIME.
  • CT2 mapping: text line in "[Master] Bill Of Lading Comment".
  • Example: "Cargo to port delivery deadline: 01-20-15".
  • Not implemented because of no current mapping in 301 for:
  • AES (for US laden cargo) customs document deadline.
  • RETURN LOCATION.



SOW 4 EDI 304 Shipment Instruction


mantises:

0004743, (phase: Dev, status: feedback)

Core Requirements

  • Send EDI 304 Shipment Instruction to Cargosmart from CT Master

Solution

  • .



SOW Z 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