EDI 304

From UG

Revision as of 04:38, 9 October 2013 (edit) Alex (Talk | contribs) ← Older edit		Current revision as of 05:51, 8 November 2013 (edit) (undo) Alex (Talk | contribs) (→Master Comments Tab)
(19 intermediate revisions not shown)
Line 1:		Line 1:
	[[Category:Ocean Status]]		[[Category:Ocean Status]]
-	We send the following to the steamshipline:	+	== Intro ==
-	1. Booking #	+	* EDI 304 is an '''Ocean Shipping Instructions''' message.
-	2. Shipper	+	* It is outgoing message: Jag --> Carrier.
-	3. 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).
-	4. Container Numbers	+	=== Message Flow ===
-	5. Seal Numbers	+	[[File:Message flow 304.JPG | 700px]]
-	6. Packaging Count (all, pallets, weights)	+	== Master Doc Tab ==
-	7. Commodity Description	+	* detect that given master is a subject to EDI transmission (carrier is on the EDI list)
-	8. Haz Description (if hazardous)	+	* modify MBL template to accommodate EDI case (add new fields and validations!)
-	9. Freight Prepaid / Collect	+	* on "generate report":
		+	** show Preview (with Back and Submit Shipping Instructions Electronically buttons) [requested by end users]
		+	** generate MBL pdf
		+	** show confirmation
-	10. Move Type (CY/CY etc)	+	== Old Fields ==
		+
		+	=== Master Notify ===
		+
		+	* '''map''': [[Master#Master_Notify | Master Notify]]
		+	* '''required''': Y
		+	* '''EDI''':
		+	* '''Notes''':
		+
		+	=== Master Shipper ===
		+
		+	* '''map''': [[Master#Master_Shipper | Master Shipper]]
		+	* '''required''': Y
		+	* '''EDI''':
		+	* '''Notes''':
		+
		+	=== Master Consignee ===
		+
		+	* '''map''': [[Master#Master_Consignee | Master Consignee]]
		+	* '''required''': Y
		+	* '''EDI''':
		+	* '''Notes''':
		+
		+	=== Booking Number ===
		+
		+	* '''map''': [[Master#Booking_Num | Booking Num]]
		+	* '''required''': Y
		+	* '''EDI''':
		+	* '''Notes''':
		+
		+	=== 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?