OOCL 300

From UG

Revision as of 06:35, 15 November 2013 (edit) Alex (Talk | contribs) (→RF Temperature) ← Older edit		Revision as of 06:40, 15 November 2013 (edit) (undo) Alex (Talk | contribs) (→Booking Remarks) Newer edit →
Line 155:		Line 155:
	Required: No (used in some cases)		Required: No (used in some cases)
-	:: OOCL Example: If an item is over one ton, enter the Gross Weight per package
	== New Fields ==		== New Fields ==

---

Revision as of 06:40, 15 November 2013

Contents 1 Data Elements 1.1 Misc 1.1.1 Traffic Mode 1.1.2 Booking Number 1.2 Rate/Reference Information 1.2.1 Contract Number 1.3 Parties 1.3.1 Shipper 1.3.2 Forwarder 1.3.3 Consignee 1.4 Cargo 1.4.1 Outbound Traffic Mode 1.4.2 Inbound Traffic Mode 1.4.3 Cargo Nature 1.4.4 Cargo Descriptions 1.5 Routing 1.6 Container 1.7 Trucking and Haulage 1.8 Special Requirements 1.8.1 Export Declaration 1.8.2 Special Stowage 1.9 Booking Remarks 2 New Fields 2.1 AMS SCAC Code

Data Elements

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

By default these fields are read only on Message Template.

Misc

Traffic Mode

Constant = "FCL/FCL".

Booking Number

Available only for Bookings that were confirmed/rejected by carrier.

Rate/Reference Information

Contract Number

New field, see #Contract Number NEW

Parties

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

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

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

Cargo

Outbound Traffic Mode

constant = FCL

Inbound Traffic Mode

constant = FCL

Cargo Nature

• • General / Reefer / Dangerous
  • use Master#Hazardous, details TBD

Cargo Descriptions

• • #Commodity

Routing

• Origin City
  • for door/* moves: Master#Origin_Terminal
  • for door/* moves: Master#Master_Pick-up

• Destination City
  • for */port moves: Master#Destination_Terminal
  • for */port moves: Master#Master_Delivery_Address

• Vessel Name
  • Master#Vessel_Name

• Voyage Number
  • Master#Voyage_Num

• Intended Date Range
  • sailing within X weeks from Date Y, details TBD

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

Trucking and Haulage

• Door Pickup
  • options: all 4 combinations of cy and door
  • map to Move Type/MBL (Master Details tab. 2)
    • cy = port

? do we need to add Appointment interface or always use "To be Advised"?

• Empty Container Pickup Request
  • O
  • do we need this?

Special Requirements

Export Declaration

Constant value = "No Export Declaration"

Special Stowage

See EDI 300#Special Stowage

Booking Remarks

See EDI 300#Booking Remarks.

Required: No (used in some cases)

New Fields

AMS SCAC Code

• AMS SCAC Code - 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.