EDI to CargoSmart

From UG

Revision as of 11:59, 11 May 2015 (edit) Andrei (Talk | contribs) (→Core Requirements) ← Older edit		Revision as of 15:03, 25 May 2015 (edit) (undo) Andrei (Talk | contribs) Newer edit →
Line 23:		Line 23:
	==== Solution ====		==== Solution ====
-	* 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.	+
Line 54:		Line 52:
	<hr>		<hr>
-	=== SOW 2: ... ===	+	=== SOW 2 Cargosmart Events ===
	<hr>		<hr>
-	'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=??? '''???'''] (''phase:'' ???, ''status:'' ???)	+	'''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 ====		==== 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 ====
-	[[TBD]]	+	* 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 Vessel 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
		+	:*
		+	:*
		+	:*
		+	:*
		+	:*
	<hr>		<hr>

---

Revision as of 15:03, 25 May 2015

Contents 1 Info 2 SOWs 2.1 SOW 1 EDI to CargoSmart 2.1.1 Core Requirements 2.1.2 Solution 2.1.3 Post-Implementation Notes 2.2 SOW 2 Cargosmart Events 2.2.1 Core Requirements 2.2.2 Solution

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 Vessel 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

---