EDI to CargoSmart
From UG
(Difference between revisions)
(→Core Requirements) |
(→Solution) |
||
(15 intermediate revisions not shown) | |||
Line 7: | Line 7: | ||
== SOWs == | == SOWs == | ||
- | === SOW 1 EDI to CargoSmart === | + | === SOW 1 EDI to CargoSmart (initial tasks) === |
<hr> | <hr> | ||
Line 14: | Line 14: | ||
==== Core Requirements ==== | ==== Core Requirements ==== | ||
* Implement EDI to Cargosmart to send booking request and shipment instruction to receive status updates to update CT2. | * Implement EDI to Cargosmart to send booking request and shipment instruction to receive status updates to update CT2. | ||
- | :* EDI 300 Booking Request | + | :* Sending |
- | :* EDI | + | :** EDI 300 Booking Request |
- | :* | + | :** EDI 304 Shipment Instruction |
- | :* EDI | + | :* Receiving |
- | :* EDI 315 Status Details (Ocean) | + | :** EDI 301 Booking Confirmation |
+ | :** EDI 315 Status Details (Ocean) | ||
==== Solution ==== | ==== Solution ==== | ||
- | * | + | *. |
- | + | ||
- | + | ||
Line 52: | Line 51: | ||
<hr> | <hr> | ||
- | === SOW 2 | + | === SOW 2 EDI 303 Booking Cancellation === |
<hr> | <hr> | ||
- | ''' | + | '''mantises''': |
+ | : [http://mantis.jaguarfreight.com/mantis/view.php?id=4743 '''0004743'''], (''phase:'' Dev, ''status:'' feedback) | ||
+ | : [http://mantis.jaguarfreight.com/mantis/view.php?id=4909 '''0004909'''], (''phase:'' UAT, ''status:'' new) | ||
==== Core Requirements ==== | ==== Core Requirements ==== | ||
- | * ... | + | * Send EDI 303 Booking Cancellation to Cargosmart from CT Master |
- | * ... | + | |
+ | ==== Solution ==== | ||
+ | * Implemented in sending of EDI 300 with B104="D". | ||
+ | |||
+ | |||
+ | |||
+ | <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. | ||
+ | ::* 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. | ||
+ | |||
+ | |||
+ | |||
+ | <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 5 EDI 315 Status Details (Ocean) === | ||
+ | <hr> | ||
+ | |||
+ | '''mantises''': | ||
+ | : [http://mantis.jaguarfreight.com/mantis/view.php?id=4743 '''0004743'''], (''phase:'' QA, ''status:'' released) | ||
+ | : [http://mantis.jaguarfreight.com/mantis/view.php?id=4898 '''0004898'''], (''phase:'' QA, ''status:'' released) | ||
+ | : [http://mantis.jaguarfreight.com/mantis/view.php?id=5293 '''0005293'''], (''phase:'' QA, ''status:'' released) | ||
+ | |||
+ | ==== Core Requirements ==== | ||
+ | * Receive EDI 315 Status Details (Ocean) from Cargosmart to Master and related CT (s) | ||
+ | |||
+ | ==== Solution ==== | ||
+ | * . | ||
+ | |||
+ | |||
+ | ==== Post-Implementation Notes ==== | ||
+ | * Ports mapping in R4 segment (R401): | ||
+ | ** R. Place of Receipt (Contractual). Place at which cargo enters the care and custody of carrier. // Origin Terminal in CT2 | ||
+ | ** L. Port of Loading (Operational). Port at which cargo is loaded on vessel. | ||
+ | ** D. Port of Discharge (Operational). Port at which cargo is unloaded from vessel. | ||
+ | ** E. Place of Delivery (Contractual). Place at which cargo leaves its care and custody of carrier. // Destination Terminal in CT2 | ||
+ | * Ports/Terminals are also updates from R4 segments: | ||
+ | R4*R*UN*BEANR*Antwerpen*BE~ | ||
+ | DTM*140*20141231*0700~ | ||
+ | R4*L*UN*NLRTM*Rotterdam*NL~ | ||
+ | DTM*140*20150111*2157~ | ||
+ | R4*D*UN*USNYC*New York*US***NY~ | ||
+ | DTM*139*20150125*0230~ | ||
+ | R4*E*UN*USNYC*New York*US***NY~ | ||
+ | DTM*139*20150127*0700~ | ||
+ | * It will override B403 value if they are diferrent (''probably that will not happened in real life''). | ||
+ | * Please also note that ''portOfDischarge'' will override ''destinationalTerminal'' and ''portOfLoading'' will override ''originalTerminal'' if terminals are disabled in CT editor. - <span style="color:red">THIS removed in mantis [http://mantis.jaguarfreight.com/mantis/view.php?id=5348 '''0005348''']</span>. | ||
+ | |||
+ | |||
+ | |||
+ | <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 ==== | ==== 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> | <hr> |
Current revision as of 12:46, 23 January 2017
Contents |
[edit] Info
- ...
[edit] SOWs
[edit] SOW 1 EDI to CargoSmart (initial tasks)
mantis: 0004743 (phase: Dev, status: feedback)
[edit] 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
[edit] Solution
- .
[edit] 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.
[edit] SOW 2 EDI 303 Booking Cancellation
mantises:
[edit] Core Requirements
- Send EDI 303 Booking Cancellation to Cargosmart from CT Master
[edit] Solution
- Implemented in sending of EDI 300 with B104="D".
[edit] SOW 3 Some Dates/Deadlines mapping in EDI 301 Booking Confirmation
mantises:
- 0004908, (phase: UAT, status: new)
[edit] 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
[edit] 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.
[edit] SOW 4 EDI 304 Shipment Instruction
mantises:
- 0004743, (phase: Dev, status: feedback)
[edit] Core Requirements
- Send EDI 304 Shipment Instruction to Cargosmart from CT Master
[edit] Solution
- .
[edit] SOW 5 EDI 315 Status Details (Ocean)
mantises:
- 0004743, (phase: QA, status: released)
- 0004898, (phase: QA, status: released)
- 0005293, (phase: QA, status: released)
[edit] Core Requirements
- Receive EDI 315 Status Details (Ocean) from Cargosmart to Master and related CT (s)
[edit] Solution
- .
[edit] Post-Implementation Notes
- Ports mapping in R4 segment (R401):
- R. Place of Receipt (Contractual). Place at which cargo enters the care and custody of carrier. // Origin Terminal in CT2
- L. Port of Loading (Operational). Port at which cargo is loaded on vessel.
- D. Port of Discharge (Operational). Port at which cargo is unloaded from vessel.
- E. Place of Delivery (Contractual). Place at which cargo leaves its care and custody of carrier. // Destination Terminal in CT2
- Ports/Terminals are also updates from R4 segments:
R4*R*UN*BEANR*Antwerpen*BE~ DTM*140*20141231*0700~ R4*L*UN*NLRTM*Rotterdam*NL~ DTM*140*20150111*2157~ R4*D*UN*USNYC*New York*US***NY~ DTM*139*20150125*0230~ R4*E*UN*USNYC*New York*US***NY~ DTM*139*20150127*0700~
- It will override B403 value if they are diferrent (probably that will not happened in real life).
- Please also note that portOfDischarge will override destinationalTerminal and portOfLoading will override originalTerminal if terminals are disabled in CT editor. - THIS removed in mantis 0005348.
[edit] SOW Z Cargosmart Events
mantises:
[edit] 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.
[edit] 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 |