OOCL 300
From UG
Contents |
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
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
- Voyage Number
- Intended Date Range
- sailing within X weeks from Date Y, details TBD
Container
For each container:
- Size Type
- Cargo Weight
- Cargo Weight Unit (kg / lb)
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
- Special Stowage
- see #Special Stowage
- Document Upload
- O
- no need?
Booking Remarks
- #Booking Remarks
- OOCL Example: If an item is over one ton, enter the Gross Weight per package
New Fields
Export Declaration
- options:
- No Export Declaration
Special Stowage
- options:
- Stow below Deck
- Stow on Deck
- No Special Stowage
Booking Remarks
- required: N (used in some cases)
- AN // size TBD
- UI: textarea
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.
Reefer Indicator
Add "Reefer Indicator" attribute to container types. Values: "Y" or "No"
Contract Number NEW
Contract number for contract between Jaguar and Steamshipline.
UI: Add to Admin > Carriers > Steamshiplines
- OOCL
- Format: AN, 8 chars
- example: MT136710
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.
Est GW
- "Est GW" checkbox
- NOTE: "Use Estimated Weight for Booking Request instead of actual?"
- above master container table
Add Weight per container
- add extra column "GW" to cont table
- with dropdown with unit (kg/lb) in the header of column
- if Est GW is checked then show show textfield in each line (float, format same as GW in commod table) else show calculated read only from CTs
- if CTs have mixed kg/lb then recalculate in unit above table