EDI 300

From UG

(Difference between revisions)
Jump to: navigation, search
(→Reporting)
Line 107: Line 107:
[[File:Transmit Booking request.JPG |700px]]
[[File:Transmit Booking request.JPG |700px]]
-
== Reporting ==
+
== Reporting and Notifications ==
-
See [[Ocean Status#997 Reporting]].
+
=== Master Comments Tab ===
 +
Post updates?
 +
 
 +
=== Email Notifications ===
 +
 
 +
997?
 +
 
 +
=== Email Template ===
 +
TBD
 +
 
 +
=== Reports ===
 +
None?
 +
 
 +
=== Log ===
 +
 
 +
Post updates?
== Required Fields ==
== Required Fields ==

Revision as of 05:43, 8 November 2013


Contents

Intro

EDI 300 is a Booking Request message.

It is an outgoing Message: Jaguar sends info to Carrier.

The shipper or forwarder can use this transaction set to reserve cargo space.

Types of 300 message:

  • Initial Booking
  • Booking Update - Booking amendment, initiated by the customer. You can only send amendments on confirmed, conditionally accepted or pending bookings. For rejected bookings a new initial booking needs to be sent
  • Booking Cancellation - initiated by the customer. You can

only send cancellations on confirmed, conditionally accepted or pend ing bookings.

Basic booking request 

   7.1 Rate/Reference Information
   7.2 Parties
   7.3 Cargo
   7.4 Routing
   7.5 Container
   7.6 Trucking and Haulage
   7.7 Special Requirements
   7.8 Booking Remarks


Message Flow

Below covers most scenarious except updates from carriers.


Business Process

Regular BP

  • 1/ Combine CTs into GRP and then into Master (currently not all operators are doing this at the moment of booking)
  • 2/
    • Enter all required information such as containers, etc.
    • Pass all #Validations.
  • 3/ Browse #Sailing Schedule to identify appropriate Vessel / Voyage (example: VANCOUVER EXPRESS / 029W)
  • 4/ Enter Vessel / Voyage
  • 5/ Send booking request by pressing a button in Master Context Menu. See #Master UI 1.

Blind BP

skip 3,4 in Regular BP

Phone BP

At step 3 if there are no space then make a phone call. Then if space provided then complete it over the phone or proceed to 4,5 in Regular BP.

Empty Master BP

  • 1/ create empty master from Master template
  • 2/ Change / add booking related fields
  • 3/ follow steps 3,4,5 from Regular BP

Validations

EDI transmission assumes strict validations.

All required fields mast be marked as "required". See #Master UI 1.

On "Transmit" system should:

  • validate all fields and present user with all required fields. See #Required fields
  • validate that all contents are assigned to containers in all CTs under Master

Sailing Schedule

User needs access to this info in many cases before they make a booking. 

Tech Note
---------
User accesses this through:
.
option A) A different free URL (example: https://www.e-usiship.com/party/sailingschedule/ss_expresslink.jsf?ANONYMOUS_BEHAVIOR=BUILD_UP&domainName=PARTY_DOMAIN&ENTRY_TYPE=USI&ENTRY=MCC&PREFER_LANGUAGE=en-US)
A1) on separate browser tab OR
A2) embedded into CT2 page
.
option B) CT2 module that connects through Web Service or alike(not free, example: CargoSmart's Sailing Schedule feature)

File:Sailing schedule.JPG

Transmit button

  • Add Booking Request button to initiate 300 message.
  • On Press Message will be sent and confirmation pop-up will be shown.

Reporting and Notifications

Master Comments Tab

Post updates?

Email Notifications

997?

Email Template

TBD

Reports

None?

Log

Post updates?

Required Fields

  • Traffic Mode
    • FCL: constant "FCL/FCL"

Rate/Reference Information

Parties

  • Forwarder

Cargo

  • Outbound Traffic Mode
    • constant FCL: Full Container Load for FCL/FCL
  • Inbound Traffic Mode
    • constant FCL: Full Container Load for FCL/FCL
  • Cargo Nature
    • General / Reefer / Dangerous

Routing

Container

For each size type:

  • Quantity
    • calculate from Master containers table

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

  • Document Upload
    • O
    • no need?

Booking Remarks

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

Old fields

Estimated Departure Date

  • map:
  • required: Y
  • EDI:
  • Notes: might be labeled something else, ready to ship date, or cargo delivery date, for example

Commodity

Hazardous Information

  • map: Hazardous (Master General tab. 18)
  • required: Y
  • EDI:
  • Notes: if any

Maybe: Estimated Arrival Date

  • map:
  • required: Y
  • EDI:
  • Notes:

Freight Prepaid / Freight Collect

Gross Weight

Service Mode (move type)

New Fields

Export Declaration

  • options:
    • Filing Electronically (Canada, China, and United States)
    • Submitting Forms (Canada, China, and United States)
    • 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

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.

Container Size Type ISO Code

  • map: see below
  • required: Y
  • EDI:
  • Notes: cover all containers in the loop


Related to http://wiki.jaguarfreight.com/wiki/SI_EDI#SOW_18_Fix_Container_info

In Admin > Transportation > Container Size/Type

  • add field "ISO code", same format/validation
  • add Long Description field (100 char string) 
NOTE:
D2L codes are based on ISO but not identical.
For example, open top type.
In ISO it is tagged as "UT" or U0, U1 or .... or U5.
In D2L classification it is "OT"
References:
ISO: http://en.wikipedia.org/wiki/ISO_6346
D2L: http://wiki.jaguarfreight.com/wiki/File:Container_Codes.xls

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

Misc

Grouping inside Master

Add ability to group/ungroup selected CTs inside the Master.

Extend Master Templates

Following additional fields must be copied at the moment of creating a template from Master Clone.

Add column / filter of user who created them.

EDI Vendor Implementations

Retrieved from "https://wiki.jaguarfreight.com/EDI_300"
Personal tools