EDI to CargoSmart
From UG
(Difference between revisions)
(→SOW 3 Some Dates/Deadlines mapping in EDI 301 Booking Confirmation) |
(→Solution) |
||
| Line 98: | Line 98: | ||
::* Example: "304 submission deadline: 01-23-15". | ::* Example: "304 submission deadline: 01-23-15". | ||
:* CUTOFF DATE/TIME. | :* CUTOFF DATE/TIME. | ||
| + | ::* Transmitting data: ETA at Place of Receipt as declared in DTM*139*<Date> under R4*R. | ||
::* CT2 mapping: text line in "[Master] Bill Of Lading Comment". | ::* CT2 mapping: text line in "[Master] Bill Of Lading Comment". | ||
::* Example: "Cargo to port delivery deadline: 01-20-15". | ::* Example: "Cargo to port delivery deadline: 01-20-15". | ||
Revision as of 11:38, 8 April 2016
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)
- Sending
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:
Core Requirements
- Send EDI 303 Booking Cancellation to Cargosmart from CT Master
Solution
- .
SOW 3 Some Dates/Deadlines 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.
- Transmitting data: ETA at Place of Receipt as declared in DTM*139*<Date> under R4*R.
- 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:
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 |
