OOCL 300

From UG

Revision as of 06:49, 15 November 2013 (edit) Alex (Talk | contribs) ← Older edit		Current revision as of 15:57, 15 November 2013 (edit) (undo) Alex (Talk | contribs) (→Cargo Nature)
(15 intermediate revisions not shown)
Line 19:		Line 19:
	==== AMS SCAC Code ====		==== AMS SCAC Code ====
-	* constant = JAFR	+	Constant = ''"JAFR"''
	SCAC/ACI Code.  For USA trade, this is a code with normally 4 digits for AMS filing		SCAC/ACI Code.  For USA trade, this is a code with normally 4 digits for AMS filing
Line 27:		Line 27:
	==== Booking Number ====		==== Booking Number ====
-	Available only for Bookings that were confirmed/rejected by carrier.	+	* Available only for Bookings that were confirmed/rejected by carrier.
		+	* pull from [[Master#Booking Num]]
	=== Rate/Reference Information ===		=== Rate/Reference Information ===
Line 33:		Line 34:
	==== Contract Number ====		==== Contract Number ====
-	New field, see [[#Contract Number NEW]]	+	New field, see [[EDI 300#Contract Number]]
	=== Parties ===		=== Parties ===
Line 65:		Line 66:
	* [[Address#State]]		* [[Address#State]]
-	See also [[Offices]].	+	See also [[EDI 300#Jaguar Offices]].
-		+
-	Tech Note	+
-	----------	+
-	There is a problem.	+
-	Office addr is stored in one field tblOffice.Address	+
-	Need to re-factor DB table to add separate fields that hold Zip, City, etc	+
-	and trigger to support existing field. Or other solution.	+
	==== Consignee ====		==== Consignee ====
Line 100:		Line 94:
	==== Cargo Nature ====		==== Cargo Nature ====
-	** ''General / Reefer / Dangerous''	+	* possible values: General / Reefer / Dangerous
-	** use [[Master#Hazardous]], details TBD	+
		+	* if at least one container is a reefer (use [[EDI 300#Reefer Indicator]]) then Cargo Nature = Reefer
		+
		+	* if Hazardous = Y then Cargo Nature = Hazardous
		+
		+	* else Cargo Nature = General
	==== Cargo Descriptions ====		==== Cargo Descriptions ====
-	** [[#Commodity]]	+	Pull from [[Master#Master Commodity Description]]
	=== Routing ===		=== Routing ===
-	* '''Origin City'''	+	See [[EDI 300#Move type]]
-	** for door/* moves: [[Master#Origin_Terminal]]	+
-	** for door/* moves: [[Master#Master_Pick-up]]	+
-	* '''Destination City'''	+	==== Origin City ====
-	** for */port moves: [[Master#Destination_Terminal]]	+
-	** for */port moves: [[Master#Master_Delivery_Address]]	+
-	* '''Vessel Name'''	+	For Move type = "door to cy" or "door to door":
-	** [[Master#Vessel_Name]]	+	* pull City from [[Master#Master_Pick-up]] address
-	* '''Voyage Number'''	+	For Move type = "cy to cy" or "cy to door":
-	** [[Master#Voyage_Num]]	+	* pull City from [[Master#Origin_Terminal]] address
-	* '''Intended Date Range'''	+	==== Destination City ====
-	** sailing within X weeks from Date Y, details TBD	+
		+	For Move type = "cy to door" or "door to door":
		+	* pull City from [[Master#Master Delivery Address]] address
		+
		+	For Move type = "cy to cy" or "door to cy":
		+	* pull City from [[Master#Destination_Terminal]] address
		+
		+	==== Vessel Name ====
		+
		+	Pull from [[Master#Vessel_Name]]
		+
		+	==== Voyage Number ====
		+
		+	Pull from [[Master#Voyage_Num]]
	=== Container ===		=== Container ===
Line 141:		Line 149:
	=== Trucking and Haulage ===		=== Trucking and Haulage ===
-	* '''Door Pickup'''	+	==== Move type ====
-	** options:  all 4 combinations of '''cy''' and '''door'''	+
-	** map to [[Master#Move_Type.2FMBL | Move Type/MBL ]] ''(Master Details tab. 2)''	+
-	*** cy = port	+
-	? do we need to add Appointment interface or always use "To be Advised"?	+	Pull from [[Master#Move Type/MBL]]
-		+
-	* '''Empty Container Pickup Request'''	+
-	** O	+
-	** do we need this?	+
	=== Special Requirements ===		=== Special Requirements ===
Line 167:		Line 168:
	Required: No (used in some cases)		Required: No (used in some cases)
		+
		+	=== Reefer Information ===
		+
		+	This section will be presented if [[#Cargo Nature]] = Reefer
		+
		+	See [[EDI 300#Reefer Info]]
	== 301 Data Elements ==		== 301 Data Elements ==
		+
		+	=== Booking Number ===
		+
		+	* save into [[Master#Booking_Num ]]
		+
		+	=== Vessel Name ===
		+
		+	* save into [[Master#Vessel_Name]]
		+
		+	=== Voyage Number ===
		+
		+	* save into [[Master#Voyage_Num ]]
		+
		+	=== Documentation Cut Off Date ===
		+
		+	* '''Documentation Cut Off Date''' // Date+Time // Last possible date documentation can be sent.
		+	** Read only, M Det Tab
		+
		+	* TBC!
		+
		+	=== CY open date ===
		+
		+	* '''CY open date''' // Date+Time // First possible date cargoes may be delivered to a ship or designated point.
		+
		+	* TBC!
		+
		+	=== CY Cutoff Date ===
		+
		+	* save into [[EDI 300#CY Cutoff Date]]

---

Current revision as of 15:57, 15 November 2013

Contents 1 Intro 2 300 Data Elements 2.1 Misc 2.1.1 Traffic Mode 2.1.2 AMS SCAC Code 2.1.3 Booking Number 2.2 Rate/Reference Information 2.2.1 Contract Number 2.3 Parties 2.3.1 Shipper 2.3.2 Forwarder 2.3.3 Consignee 2.4 Cargo 2.4.1 Outbound Traffic Mode 2.4.2 Inbound Traffic Mode 2.4.3 Cargo Nature 2.4.4 Cargo Descriptions 2.5 Routing 2.5.1 Origin City 2.5.2 Destination City 2.5.3 Vessel Name 2.5.4 Voyage Number 2.6 Container 2.7 Trucking and Haulage 2.7.1 Move type 2.8 Special Requirements 2.8.1 Export Declaration 2.8.2 Special Stowage 2.9 Booking Remarks 2.10 Reefer Information 3 301 Data Elements 3.1 Booking Number 3.2 Vessel Name 3.3 Voyage Number 3.4 Documentation Cut Off Date 3.5 CY open date 3.6 CY Cutoff Date

[edit] Intro

This list is based on OOCL/Cargosmart requirements (phase one is OOCL only).

We suppose that if we connect through other VANs/directly to other carriers we might have some but not very significant difference since X12 protocol for 300 is a standard.

[edit] 300 Data Elements

Below is a list of all data elements to be sent through EDI.

[edit] Misc

[edit] Traffic Mode

Constant = "FCL/FCL".

[edit] AMS SCAC Code

Constant = "JAFR"

SCAC/ACI Code.  For USA trade, this is a code with normally 4 digits for AMS filing
We need this code to submit AMS filing and Jaguar is registered. 
Our AMS SCAC code is JAFR.

[edit] Booking Number

• Available only for Bookings that were confirmed/rejected by carrier.
• pull from Master#Booking Num

[edit] Rate/Reference Information

[edit] Contract Number

New field, see EDI 300#Contract Number

[edit] Parties

[edit] Shipper

Name and Address for Master#Master_Shipper.

Send separately:

• Address#Company Name
• Address#Address 1
• Address#Address 2
• Address#Address 3
• Address#City
• Address#Zip
• Address#Country
• Address#State

[edit] Forwarder

Name and Address for Jaguar Office to which operator who creates message belongs.

Send separately:

• Address#Company Name
• Address#Address 1
• Address#Address 2
• Address#Address 3
• Address#City
• Address#Zip
• Address#Country
• Address#State

See also EDI 300#Jaguar Offices.

[edit] Consignee

Name and Address for Master#Master_Consignee.

Send separately:

• Address#Company Name
• Address#Address 1
• Address#Address 2
• Address#Address 3
• Address#City
• Address#Zip
• Address#Country
• Address#State

[edit] Cargo

[edit] Outbound Traffic Mode

constant = FCL

[edit] Inbound Traffic Mode

constant = FCL

[edit] Cargo Nature

• possible values: General / Reefer / Dangerous

• if at least one container is a reefer (use EDI 300#Reefer Indicator) then Cargo Nature = Reefer

• if Hazardous = Y then Cargo Nature = Hazardous

• else Cargo Nature = General

[edit] Cargo Descriptions

Pull from Master#Master Commodity Description

[edit] Routing

See EDI 300#Move type

[edit] Origin City

For Move type = "door to cy" or "door to door":

• pull City from Master#Master_Pick-up address

For Move type = "cy to cy" or "cy to door":

• pull City from Master#Origin_Terminal address

[edit] Destination City

For Move type = "cy to door" or "door to door":

• pull City from Master#Master Delivery Address address

For Move type = "cy to cy" or "door to cy":

• pull City from Master#Destination_Terminal address

[edit] Vessel Name

Pull from Master#Vessel_Name

[edit] Voyage Number

Pull from Master#Voyage_Num

[edit] Container

For each container:

• Size Type
  • see EDI 300#Container Type ISO Code

• Cargo Weight
  • see EDI 300#Container Weight

• Cargo Weight Unit (kg / lb)
  • see EDI 300#Container Weight Unit

[edit] Trucking and Haulage

[edit] Move type

Pull from Master#Move Type/MBL

[edit] Special Requirements

[edit] Export Declaration

Constant value = "No Export Declaration"

[edit] Special Stowage

See EDI 300#Special Stowage

[edit] Booking Remarks

See EDI 300#Booking Remarks.

Required: No (used in some cases)

[edit] Reefer Information

This section will be presented if #Cargo Nature = Reefer

See EDI 300#Reefer Info

[edit] 301 Data Elements

[edit] Booking Number

• save into Master#Booking_Num

[edit] Vessel Name

• save into Master#Vessel_Name

[edit] Voyage Number

• save into Master#Voyage_Num

[edit] Documentation Cut Off Date

• Documentation Cut Off Date // Date+Time // Last possible date documentation can be sent.
  • Read only, M Det Tab

• TBC!

[edit] CY open date

• CY open date // Date+Time // First possible date cargoes may be delivered to a ship or designated point.

• TBC!

[edit] CY Cutoff Date

• save into EDI 300#CY Cutoff Date