Editing EDI to CargoSmart

[[Category:3PL Integration]]

== Info ==

* ...

== SOWs ==

=== SOW 1 EDI to CargoSmart (initial tasks) ===
<hr>

'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=4743 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.



<hr>

=== SOW 2 EDI 303 Booking Cancellation ===
<hr>

'''mantises''':
: [http://mantis.jaguarfreight.com/mantis/view.php?id=4743 '''0004743'''],  (''phase:'' Dev, ''status:'' feedback)
: [http://mantis.jaguarfreight.com/mantis/view.php?id=4743 '''0004909'''],  (''phase:'' UAT, ''status:'' new)

==== Core Requirements ====
* Send EDI 303 Booking Cancellation to Cargosmart from CT Master

==== Solution ====
* .



<hr>

=== SOW 3 Some Dates/Deadlines mapping in EDI 301 Booking Confirmation ===
<hr>

'''mantises''':
: [http://mantis.jaguarfreight.com/mantis/view.php?id=4908 '''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.



<hr>

=== SOW 4 EDI 304 Shipment Instruction ===
<hr>

'''mantises''':
: [http://mantis.jaguarfreight.com/mantis/view.php?id=4743 '''0004743'''],  (''phase:'' Dev, ''status:'' feedback)

==== Core Requirements ====
* Send EDI 304 Shipment Instruction to Cargosmart from CT Master

==== Solution ====
* .



<hr>

=== SOW Z Cargosmart Events ===
<hr>

'''mantises''':
: [http://mantis.jaguarfreight.com/mantis/view.php?id=4743 '''0004743'''],  (''phase:'' Dev, ''status:'' feedback)
: [http://mantis.jaguarfreight.com/mantis/view.php?id=4898 '''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:
{| border="1" valign="top" style="border-collapse:collapse;margin: 1em auto 1em auto;" cellpadding="2" width="75%"
|-
! width="400px" | Event Description
! width="200px" style="text-align: center;" | Shipment Status Code
! CT2 Mapping
|-
|-
| Arrival at Last Intermodal Hub
| style="text-align: center;" | AR
| Actual Arrival date - Destination Terminal
|-
| Last Vessel Arrival
| style="text-align: center;" | VA
| Actual Arrival Date - Port of Arrival
|-
| Actual Door Delivery
| style="text-align: center;" | D
| Actual Delivery Date
|-
| First Loaded on Rail Under Outbound
| style="text-align: center;" | AL
| Actual departure date - Origin Terminal
|-
| First Vessel Departure
| style="text-align: center;" | VD	
| Actual Departure date - Port of Departure
|-
| Transshipment Vessel Departure
| style="text-align: center;" | Z5
| Actual Departure Date - Transshipment Port
|-
| Actual Door Pickup
| style="text-align: center;" | AF
| Actual Pick Up Date
|-
| Empty Container Picked Up
| style="text-align: center;" | EE
| rowspan="26" style="text-align: center;" | New Fields (TEvents)
|-
| Full Container Received by Carrier at Origin
| style="text-align: center;" | OA
|-
| Departure from First Intermodal Hub
| style="text-align: center;" | RL
|-
| Arrival at First Port of Load
| style="text-align: center;" | I
|-
| Loaded on Board at First Port of Load
| style="text-align: center;" | AE
|-
| Loaded at Port
| style="text-align: center;" | W6
|-
| Vessel Departure
| style="text-align: center;" | X2
|-
| Loaded at Port of Transshipment
| style="text-align: center;" | Z3
|-
| Discharged at Port of Transshipment
| style="text-align: center;" | Z4
|-
| Discharged from Vessel at Last Port of Discharge
| style="text-align: center;" | UV
|-
| Container Picked up from Port of Discharge/Transshipment Port
| style="text-align: center;" | Y9
|-
| First Loaded on Rail Under Inbound
| style="text-align: center;" | Z7
|-
| Intermodal Departure from Last Port of Discharge
| style="text-align: center;" | Z6
|-
| Equipment Delayed due to Transportation
| style="text-align: center;" | W3
|-
| Loaded on Rail
| style="text-align: center;" | Y3
|-
| Arrival at Intermodal Hub by Rail
| style="text-align: center;" | Y2
|-
| Gate In Full at Inland Terminal
| style="text-align: center;" | W2
|-
| Gate Out Full at Inland Terminal
| style="text-align: center;" | W1
|-
| Loaded on Truck
| style="text-align: center;" | AM
|-
| Customs Hold
| style="text-align: center;" | PA
|-
| Carrier Held
| style="text-align: center;" | X9
|-
| Freight Charges Settled
| style="text-align: center;" | NO
|-
| Carrier Released
| style="text-align: center;" | CR
|-
| Customs Released
| style="text-align: center;" | CT
|-
| Picked up at Final Destination for Delivery
| style="text-align: center;" | Z8
|-
| Empty Container Returned to Carrier at Destination
| style="text-align: center;" | RD
|-
|}



<hr>