OS

From UG

Revision as of 03:36, 9 October 2013 (edit) Alex (Talk | contribs) ← Older edit		Revision as of 23:26, 9 October 2013 (edit) (undo) Alex (Talk | contribs) (→Documentation) Newer edit →
Line 174:		Line 174:
	xlsx files:		xlsx files:
-	* [[File:CARRIER LIST SCAC.xlsx]]	+	* [[File:CARRIER LIST SCAC.xlsx]] - list of steamshiplines with SCAC and Shipping Agent codes
-	* [[File:Codelists - SMF OCEAN - v01.18.xlsx]]	+
-	* [[File:Event codes.xlsx]]	+	* [[File:Codelists - SMF OCEAN - v01.18.xlsx]] - various entities used such as Transport Mode, Charge Codes, etc with full list of values
-	* [[File:General elements and components.xlsx]]	+
		+	* [[File:Event codes.xlsx]] - status codes related to shipment status message [[GLN 315]]
		+
		+	* [[File:General elements and components.xlsx]]
		+
	* [[File:SMF-Ocean v01.39 E.xlsx]]		* [[File:SMF-Ocean v01.39 E.xlsx]]
		+
	* [[File:UN TP 7065 .xlsx]]		* [[File:UN TP 7065 .xlsx]]

---

Revision as of 23:26, 9 October 2013

Contents 1 Info 2 Contacts 3 Schedule and Log 4 Definitions 5 Training and Background Info 6 Business Need 7 Business Analysis and Requirements 7.1 Current Biz Process 7.2 Phases 7.3 Technical Requirements 8 Systems Analysis 9 Solution 9.1 Admin 9.2 Master Editor 9.2.1 Add EDI Status panel 9.2.2 Add Action Buttons 9.2.3 Add Validations 9.3 Messaging 9.3.1 Types of Messages 9.3.2 Message Exchange Scenarios 9.4 Email Notifications 9.5 Reports 9.6 Log 10 SOWs 11 See Also 11.1 Documentation 11.2 EDI Messages List 11.3 Links

Info

Mantis parent: 4172

Mantis Category: Ocean Status

Contacts

Eric Bossdorf
Descartes Systems Group
973-393-5008
ebossdorf@descartes.com

Eric Geerts 
Director, product management 
Duwijckstraat 17
B-2500 Lier - Belgium
Tel +32 (0)3 800 06 00
Mobile +32 (0)499058781 
Email address: egeerts@descartes.com 

Schedule and Log

• sep 5 Th
  • contract w/ Descartes is signed, green light from Marc, started writing wiki
  • due date - ASAP per Marc

• sep 13 Fri
  • tech training w/ Eric

• sep 10 - 20: BA/training phase
• sep 23 - oct 4: SA/solution phase

Definitions

Training and Background Info

Business:

Technical:

Business Need

To be able to:

1. book ocean with ocean carriers
2. subsequently receive updates electronically

Business Analysis and Requirements

Current Biz Process

Currently operators book with and get updates from ocean carriers manually (TBD in details). After that they manually update CT/Master record with the information they received. I suppose it is the following.

Bookings:

•  ???

Updates:

• actual date of departure from Origin Port
• actual arrival to Destination Port

Phases

Phase one will cover OOCL carrier only.

Technical Requirements

1. We will do this through Descartes.

Systems Analysis

Solution

Admin

Add the following controls:

• GLN FTP credentials: url, uname, pwd
• List of steamshiplines participating: On/Off switch
• email notification group

Master Editor

Add EDI Status panel

Add panel with EDI related statuses/info. This will show what messages have been sent/received.

Example:

Booking Request: sent on 2013-10-16; 1:56 pm EST by Rob Link
Booking Confirmation: pending
Shipping Instructions: not yet
Status updates: not yet
 

This is similar to GMS status panel by nature.

Add to bottom right corner of Master Details Tab where there is empty space.

Add Action Buttons

Add the following buttons:

• send Booking Request
• send Shipping Instructions

Add Validations

• Add required fields for transmissions:
  • TBD
  • TBD

• Add validations related to message sequencing:
  • prohibit sending Shipping Instructions before Booking Request

Messaging

Types of Messages

This is a list of EDI messages being used here to exchange info between Jaguar and Steamshiline through Descartes GLN:

• Booking Request ( GLN 300 )
  • The shipper or forwarder can use this transaction set to reserve cargo space.
  • Also used for Booking Update and Booking Cancellation

• Booking Confirmation ( GLN 301 )
  • This message is used to confirm the Booking Request (Message 300).

• Ocean Shipping Instructions ( GLN 304 )
  • This message supplies the same information as the Shipper's Letter of Instruction. It provides all the information necessary to prepare and distribute a contract of carriage (ocean bill of lading and other shipping documents).

• Shipment Status ( GLN 315 )
  • This message is used to report status or event details (cargo receipt, departure and arrival) for individual shipments.

Message Exchange Scenarios

• Scenario One (main):

1) Jag operator initiates Booking Request 300
        Jaguar -> GLN -> Steamshipline

2) Steamshipline responds with Booking Confirmation 301
        Jaguar <- GLN <- Steamshipline 

3) Jag operator sends Ocean Shipping Instructions 304 
        Jaguar -> GLN -> Steamshipline 

4) Steamshipline sends Shipment Status 315 with Actual Departure Date: 
        Jaguar <- GLN <- Steamshipline

5) Steamshipline sends Shipment Status 315 with Actual Arrival Date: 
        Jaguar <- GLN <- Steamshipline

Email Notifications

Notify group defined in Admin when these messages are received:

• Booking Conf 301
• Status 315

Reports

TBD

Log

TBD

SOWs

See Also

• Air Status EDI

Documentation

xlsx files:

• File:CARRIER LIST SCAC.xlsx - list of steamshiplines with SCAC and Shipping Agent codes

• File:Codelists - SMF OCEAN - v01.18.xlsx - various entities used such as Transport Mode, Charge Codes, etc with full list of values

• File:Event codes.xlsx - status codes related to shipment status message GLN 315

• File:General elements and components.xlsx

• File:SMF-Ocean v01.39 E.xlsx

• File:UN TP 7065 .xlsx

pdf files:

• File:Ocean booking process 2.pdf
• File:WSAddressingForMyVan.pdf

xsd files:

• File:SMFGSFAPI V2100.xsd

xml files:

• File:SMF booking response sample.xml

EDI Messages List

From http://www.seaboardmarine.com/SML/ui/EDI.aspx

EDI 300 - Ocean Reservation (Booking Request)
EDI 301 - Ocean Confirmation
EDI 304 - Ocean Shipping Instructions
EDI 310 - Ocean Freight Receipt and Invoice
EDI 315 - Ocean Status Details

• Booking Request (Message 300)
  • The shipper or forwarder can use this transaction set to reserve cargo space.

• Booking Confirmation (Message 301)
  • This message is used to confirm the Booking Request (Message 300).

• Ocean Shipping Instructions (Message 304)
  • This message supplies the same information as the Shipper's Letter of Instruction. It provides all the information necessary to prepare and distribute a contract of carriage (ocean bill of lading and other shipping documents).

• Manifest data (Message 309)
  • This message is a summary of bills of lading on a manifest. It's currently being used to exchange information with several overseas governmental authorities.

• Automated Manifest System (AMS) with US Customs (Message 309)
  • This system transmits inbound cargo information to US Customs and receives cargo release/hold status from US Customs.

• Bill of Lading data and Ocean Invoice (Message 310)
  • This message includes all information normally found on a bill of lading, including freight charges.

• Arrival Notification (Message 312)
  • This message is used to notify Consignee of shipment arrival.

• Shipment Status (message 315)
  • This message is used to report status or event details (cargo receipt, departure and arrival) for individual shipments.

• Terminal Operations and Intermodal Ramp Activity (Message 322)
  • This message is used to communicate terminal and intermodal ramp activities (i.e. "ingates" and "outdates")

• Vessel Schedule and Itinerary (Message 323)
  • This message provides all information necessary to communicate the schedule and itinerary of an ocean vessel.

Links

• http://www.melcogroup.com/pdf/OASISEdi1.pdf

• http://www.inttra.com/home/assets/guides/ascx12_4010_301_out_v13.pdf

• http://www.malaysiaexports.com/inex13.3.shipping.stowage.htm