EDI 304

From UG

Revision as of 15:35, 25 October 2013 (edit) Alex (Talk | contribs) m (moved GLN 304 to 304 Shipping Instructions) ← Older edit		Current revision as of 05:51, 8 November 2013 (edit) (undo) Alex (Talk | contribs) (→Master Comments Tab)
(17 intermediate revisions not shown)
Line 1:		Line 1:
	[[Category:Ocean Status]]		[[Category:Ocean Status]]
-	== Fields ==	+	== Intro ==
-	Will include ALL the Booking Request / Booking Confirmation Data + the following:	+	* EDI 304 is an '''Ocean Shipping Instructions''' message.
-	Master Shipper	+	* It is outgoing message: Jag --> Carrier.
-	Master Consignee	+	* 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).
-	Booking Number	+	=== Message Flow ===
-	Container(s) Number	+	[[File:Message flow 304.JPG | 700px]]
-	Seal(s) number for each container	+	== Master Doc Tab ==
-	HTS # (commodity customs code)	+	* detect that given master is a subject to EDI transmission (carrier is on the EDI list)
-	Freight Prepaid / Collect	+	* modify MBL template to accommodate EDI case (add new fields and validations!)
-	MBL Type (original / express)	+	* on "generate report":
		+	** show Preview (with Back and Submit Shipping Instructions Electronically buttons) [requested by end users]
		+	** generate MBL pdf
		+	** show confirmation
-	Commodity Description	+	== Old Fields ==
-	Hazardous Information	+	=== Master Notify ===
-	AES (Export Declaration #) ex USA	+	* '''map''': [[Master#Master_Notify | Master Notify]]
		+	* '''required''': Y
		+	* '''EDI''':
		+	* '''Notes''':
-	AMS / ACI code	+	=== Master Shipper ===
-	No. of Package / Gross Weight / Measurement	+	* '''map''': [[Master#Master_Shipper | Master Shipper]]
		+	* '''required''': Y
		+	* '''EDI''':
		+	* '''Notes''':
-	Shipping Mark	+	=== Master Consignee ===
-	Any wood packing material	+	* '''map''': [[Master#Master_Consignee | Master Consignee]]
		+	* '''required''': Y
		+	* '''EDI''':
		+	* '''Notes''':
-	HBL#	+	=== Booking Number ===
-	MBL#	+	* '''map''': [[Master#Booking_Num | Booking Num]]
		+	* '''required''': Y
		+	* '''EDI''':
		+	* '''Notes''':
-	Account Bullet	+	=== Container(s) Number ===
		+
		+	* '''map''': [[TBD]]
		+	* '''required''': Y
		+	* '''EDI''':
		+	* '''Notes''':
		+
		+	=== Seal(s) number for each container ===
		+
		+	* '''map''': [[TBD]]
		+	* '''required''': Y
		+	* '''EDI''':
		+	* '''Notes''':
		+
		+	=== Commodity Description ===
		+
		+	* '''map''': [[Master#Master_Commodity_Description | Master Commodity Description]]
		+	* '''required''': Y
		+	* '''EDI''':
		+	* '''Notes''': cargo description
		+
		+	=== Hazardous Information ===
		+
		+	* '''map''': [[Master#Hazardous | Hazardous]] ''(Master General tab. 18)''
		+	* '''required''': Y
		+	* '''EDI''':
		+	* '''Notes''':
		+
		+	=== No. of Package / Gross Weight / Measurement ===
		+
		+	* '''map''': [[TBD]]
		+	* '''required''': Y
		+	* '''EDI''':
		+	* '''Notes''':
		+
		+	=== Shipping Mark ===
		+
		+	* '''map''': [[Master#Master_Marks.2FNumbers | Master Marks/Numbers]]
		+	* '''required''': Y
		+	* '''EDI''':
		+	* '''Notes''':
		+
		+	=== HBL# ===
		+
		+	* '''map''': [[TBD]]
		+	* '''required''': Y
		+	* '''EDI''':
		+	* '''Notes''':
		+
		+	=== MBL# ===
		+
		+	* '''map''': [[Master#Master_Bill_Of_Lading | Master Bill Of Lading]]
		+	* '''required''': Y
		+	* '''EDI''':
		+	* '''Notes''':
		+
		+	=== Freight Prepaid Collect ===
		+
		+	* '''map''': [[Master#Freight]]
		+	* '''required''': Y
		+	* '''EDI''':
		+	* '''Notes''':
		+
		+	== New Fields ==
		+
		+	=== HTS Feature ===
		+
		+	==== HTS field ====
		+
		+	'''HTS''':
		+	* meaning: Harmonized System Code that is classifying commodity. Example: '''2907.11.0000''' is for Phenol (Hydroxybenzene) and its salts. More info: [[Ocean_Status_Misc#HTS]]
		+	* format:
		+	** option 1: XXXX.XX, X represents number from 0 to 9
		+	** option 2: XXXX.XX.XX, X represents number from 0 to 9
		+	* is an attribute of commodity table [[Commodity]]
		+
		+	==== HTS Functionality ====
		+
		+	* for those CT records that correspond to Master that is used in EDI transmissions need additional column appear in CT Commodity table
		+
		+	* If [[#HTS Spreadsheet]] is present then as user enters SKU system should auto-suggest HTS based on link in spreadsheet between SKU and HTS
		+
		+	*  If [[#HTS Spreadsheet]] is not present then it is a free entry
		+
		+	==== HTS Spreadsheet ====
		+
		+	Under PO Issued By in ASN:
		+
		+	* Add option to upload separate xls that contains a list of SKUs and corresponding HTS
		+
		+	=== MBL Type ===
		+
		+	* '''MBL Type''' // "original" or "express" // Defines what type of MBL is used. Takes one of two values: "original" or "express"
		+	** UI: add to Master Gen Tab below "2. Move type/MBL", default to "original"
		+
		+	=== AES Number ===
		+
		+	* '''AES Number''' // AN, 15 digits // aka Internal Transaction Number (ITN), id received from Automated Export System. The ITN consists of the letters “AES” followed by the ITN: for example, “AES X20080930987654. See also http://en.wikipedia.org/wiki/Automated_Export_System
		+
		+
		+	=== AMS / ACI code ===
		+
		+	=== Wood packing ===
		+
		+	* '''Wood packing''' // "used" or "not used" // Any wooden packaging material is used or not, this is what we have to declare to the shipping line for every single booking to USA and Canada.
		+
		+	=== Account Bullet ===
		+
		+	Additional info related to [[#Contract Number]].
		+
		+	This is lane (Country or Region) specific.
		+
		+	UI: Add to Admin > Carriers > Steamshiplines
		+
		+	Format: TBD
		+
		+	In Steamshipline Admin or Ocean Status Admin.
		+
		+	== Reporting and Notifications ==
		+
		+	=== Master Comments Tab ===
		+
		+	Post all events/updates related to all messages here:
		+	* Add record every time message was sent or received
		+	* Record content of the message, operator who initiated.
		+
		+	=== Email Notifications ===
		+
		+	997?
		+
		+	=== Email Template ===
		+	TBD
		+
		+	=== Reports ===
		+	None?
		+
		+	=== Log ===
		+
		+	Post updates?

---

Current revision as of 05:51, 8 November 2013

Contents 1 Intro 1.1 Message Flow 2 Master Doc Tab 3 Old Fields 3.1 Master Notify 3.2 Master Shipper 3.3 Master Consignee 3.4 Booking Number 3.5 Container(s) Number 3.6 Seal(s) number for each container 3.7 Commodity Description 3.8 Hazardous Information 3.9 No. of Package / Gross Weight / Measurement 3.10 Shipping Mark 3.11 HBL# 3.12 MBL# 3.13 Freight Prepaid Collect 4 New Fields 4.1 HTS Feature 4.1.1 HTS field 4.1.2 HTS Functionality 4.1.3 HTS Spreadsheet 4.2 MBL Type 4.3 AES Number 4.4 AMS / ACI code 4.5 Wood packing 4.6 Account Bullet 5 Reporting and Notifications 5.1 Master Comments Tab 5.2 Email Notifications 5.3 Email Template 5.4 Reports 5.5 Log

[edit] Intro

• EDI 304 is an Ocean Shipping Instructions message.

• It is outgoing message: Jag --> Carrier.

• 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).

[edit] Message Flow

[edit] Master Doc Tab

• detect that given master is a subject to EDI transmission (carrier is on the EDI list)

• modify MBL template to accommodate EDI case (add new fields and validations!)

• on "generate report":
  • show Preview (with Back and Submit Shipping Instructions Electronically buttons) [requested by end users]
  • generate MBL pdf
  • show confirmation

[edit] Old Fields

[edit] Master Notify

• map: Master Notify
• required: Y
• EDI:
• Notes:

[edit] Master Shipper

• map: Master Shipper
• required: Y
• EDI:
• Notes:

[edit] Master Consignee

• map: Master Consignee
• required: Y
• EDI:
• Notes:

[edit] Booking Number

• map: Booking Num
• required: Y
• EDI:
• Notes:

[edit] Container(s) Number

• map: TBD
• required: Y
• EDI:
• Notes:

[edit] Seal(s) number for each container

• map: TBD
• required: Y
• EDI:
• Notes:

[edit] Commodity Description

• map: Master Commodity Description
• required: Y
• EDI:
• Notes: cargo description

[edit] Hazardous Information

• map: Hazardous (Master General tab. 18)
• required: Y
• EDI:
• Notes:

[edit] No. of Package / Gross Weight / Measurement

• map: TBD
• required: Y
• EDI:
• Notes:

[edit] Shipping Mark

• map: Master Marks/Numbers
• required: Y
• EDI:
• Notes:

[edit] HBL#

• map: TBD
• required: Y
• EDI:
• Notes:

[edit] MBL#

• map: Master Bill Of Lading
• required: Y
• EDI:
• Notes:

[edit] Freight Prepaid Collect

• map: Master#Freight
• required: Y
• EDI:
• Notes:

[edit] New Fields

[edit] HTS Feature

[edit] HTS field

HTS:

• meaning: Harmonized System Code that is classifying commodity. Example: 2907.11.0000 is for Phenol (Hydroxybenzene) and its salts. More info: Ocean_Status_Misc#HTS
• format:
  • option 1: XXXX.XX, X represents number from 0 to 9
  • option 2: XXXX.XX.XX, X represents number from 0 to 9
• is an attribute of commodity table Commodity

[edit] HTS Functionality

• for those CT records that correspond to Master that is used in EDI transmissions need additional column appear in CT Commodity table

• If #HTS Spreadsheet is present then as user enters SKU system should auto-suggest HTS based on link in spreadsheet between SKU and HTS

• If #HTS Spreadsheet is not present then it is a free entry

[edit] HTS Spreadsheet

Under PO Issued By in ASN:

• Add option to upload separate xls that contains a list of SKUs and corresponding HTS

[edit] MBL Type

• MBL Type // "original" or "express" // Defines what type of MBL is used. Takes one of two values: "original" or "express"
  • UI: add to Master Gen Tab below "2. Move type/MBL", default to "original"

[edit] AES Number

• AES Number // AN, 15 digits // aka Internal Transaction Number (ITN), id received from Automated Export System. The ITN consists of the letters “AES” followed by the ITN: for example, “AES X20080930987654. See also http://en.wikipedia.org/wiki/Automated_Export_System

[edit] AMS / ACI code

[edit] Wood packing

• Wood packing // "used" or "not used" // Any wooden packaging material is used or not, this is what we have to declare to the shipping line for every single booking to USA and Canada.

[edit] Account Bullet

Additional info related to #Contract Number.

This is lane (Country or Region) specific.

UI: Add to Admin > Carriers > Steamshiplines

Format: TBD

In Steamshipline Admin or Ocean Status Admin.

[edit] Reporting and Notifications

[edit] Master Comments Tab

Post all events/updates related to all messages here:

• Add record every time message was sent or received
• Record content of the message, operator who initiated.

[edit] Email Notifications

997?

[edit] Email Template

TBD

[edit] Reports

None?

[edit] Log

Post updates?