OOCL 300

From UG

Revision as of 06:31, 15 November 2013

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)

OOCL Example: If an item is over one ton, enter the Gross Weight per package

New Fields

RF Temperature

• RF Temperature // Format: 9999.99 // Temperature Requirement for RF containers.
  • UI: add to container profile; textfield; default = TBD

• RF Temperature Unit // C (Celsius) or F(Farenheit) // Unit of measurement
  • UI: add to container profile; dropdown ; default = TBD;

Above needs to be presented/validated only for RF type of containers - use #Reefer Indicator to distinguish.

Editable in container table in M only or in CT as well when CTs are under Master.

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.