Arrival Notice

From UG

Contents 1 Business Needs and Terminology 2 Location 3 Arrival Notice Ocean 3.1 Template 3.1.1 Top Section 3.1.2 Commodity Table Section 3.1.3 Bottom Section 3.2 Pdf 3.2.1 Header 3.2.2 Top Section 3.2.3 Commodity Section 3.2.4 TOC Section 3.2.5 Bottom Section 3.2.6 Footer 3.2.7 Multipage case 3.3 Figures 3.3.1 Figure 1. Arrival Notice Ocean Template 3.3.2 Figure 2. Arrival Notice Ocean Pdf 3.3.3 Figure 3. Arrival Notice Ocean Pdf 2nd Page 4 Arrival Notice Air 4.1 Template 4.1.1 Template Top Section 4.1.2 Template Bottom Section 4.1.2.1 PO 4.1.2.2 Commodity table 4.1.2.3 Remarks 4.1.2.4 Freight Invoice 4.2 Pdf 4.2.1 Header 4.2.2 Top Section 4.2.3 Bottom Section 4.2.4 Footer 4.3 Special case: Groups 4.4 Special case: Multiple pages 4.5 Additional Figures 4.5.1 Figure 1: Template Top Section 4.5.2 Figure 2: Template Bottom Section 4.5.3 Figure 3: Arr Notice Pdf 5 Known Non Critical Bugs and Issues 6 See Also 7 SOWs 7.1 SOW 1 2 3 7.2 SOW 4 Changes to TOC 7.3 SOW 2

Business Needs and Terminology

The purpose of this document is to notify that shipment is about to arrive.

Notify one or more from the list:

• Customs Broker (most of the times) [Imp Tab]
  • option 1) this is a "Jaguar broker" (ex: Overton)
  • option 2) this is a "Customer's broker"
    • like in case of Basic Fun
    • then Freight Invoice section (TOC) will be printed
• Notify Party [Gen Tab]

It is created by operator in Import Department.

There are two types of this documents:

• one for MOT Air: #Arrival Notice Air
• one for MOT Ocean: #Arrival Notice Ocean

Location

CT profile > Doc Tab

Arrival Notice Ocean

Parent Mantis: 581

Template

As usual document can be pre-viewed and edited through pdf template.

See Example on #Figure 1. Arrival Notice Ocean Template

See field descriptions, mappings, etc below.

Top Section

• Office Logo

copy of Office#Logo; it is office specific based on user login

• DOCUMENT ADDRESS

copy of Office#Address; it is office specific based on user login

• "ARRIVAL NOTICE / FREIGHT INVOICE" line

• CT #

current CT#; in case of group generate this field contains all selected CTs

• REFERENCE NO

copy of CT field CT#ImportRef

• SHIPPER:

copy of CT field CT#Shipper

• CONSIGNEE:

copy of CT field CT#Consignee

• NOTIFY:

copy of CT field CT#Notify

• BROKER:

copy of CT field CT#Customs Broker

• DATE

displays todays date (user's time zone)

• Master Bill of Lading:

copy of CT field CT#MBL

• AMS Bill of Lading:

pre-fill to blank

• PREPARED BY:

1)first and last name of login User; 2) e-mail associated with login User

• House Bill of Lading:

copy of CT field CT#HBL

• SubHouse Bill of Lading:

pre-fill to blank

• Freight Location:

copy of CT field CT#Cargo location

• RELEASE TYPE

Release Type field should be pulling from CT#Original BL Required Yes No.

When “Yes” is clicked, the Release Type field should display “OB/L Required”.

When “No” is clicked, the Release Type field should display “Express”.

• PORT OF LOADING

copy of CT field CT#Port Of Loading

• PORT OF DISCHARGE

copy of CT field CT#Port Of Discharge

• DESTINATION TERMINAL

copy of CT field CT#Destination Terminal

• Vessel/Voyage

merge of values of two fields:

copy of CT field CT#Vessel Name

copy of CT field CT#Voyage Num

• ETD:

copy of CT field CT#Port Of Loading Estimated Date

• Discharge Date

copy of CT field CT#Port Of Discharge Estimated Date

• Destination Date

copy of CT field CT#Destination Terminal Estimated Date

• IT#

copy of CT field CT#IT

• IT Date

copy of CT field CT#IT Date

• IT Location

copy of CT field CT#IT Location

• PO Numbers:

all PO's from ContTab.TableA; in case of group generate this field contains all PO's from all selected CTs

Commodity Table Section

See Ocean Docs Commodity Table (feature)

Bottom Section

• REMARKS:
  • checkbox of print this section in PDF (checked means print)
  • Release Type field should be pulling from CT#Payment Of Charges Required Yes No.

When “Yes” is clicked, REMARKS should be pre-filled with

PLEASE SEND CHASHIER'S CHECK, MONEY ORDER, OR BROKER CHECK PAYABLE TO JAGUARFREIGHT SERVICE; FREIGHT CAN ONLY BE RELEASED UPON RECEIPT OF CHARGES SHOWN

PRIOR TO CARGO PICK-UP, CONSIGNEE MUST CLEAR CUSTOMS AND CONFIRM FREIGHT RELEASE WITH PIER/CFS. PLEASE PICK UP YOUR CARGO UPON RELEASE IN ORDER TO AVOID UNNECESARY CHARGES

When “No” is clicked, REMARKS should be pre-filled with

PRIOR TO CARGO PICK-UP, CONSIGNEE MUST CLEAR CUSTOMS AND CONFIRM FREIGHT RELEASE WITH PIER/CFS. PLEASE PICK UP YOUR CARGO UPON RELEASE IN ORDER TO AVOID UNNECESSARY CHARGES

• TOC
  • See Table Of Charges For Receivable (TOC) feature
  • checkbox of don't print this section in PDF (checked means NOT print)

• generate report button

Pdf

See Examples on #Figure 2. Arrival Notice Ocean Pdf and #Figure 3. Arrival Notice Ocean Pdf 2nd Page

Header

• See section 1 on Figure 2. It is for page one.

Jaguar Logo. Reflects Template Office Logo.

Jaguar Address. Reflects Template DOCUMENT ADDRESS.

Doc Title. "ARRIVAL NOTICE / FREIGHT INVOICE" line.

DATE. Reflects Template DATE.

Page X of Y. X - current page num; Y - total num of pages.

Top Section

• See section 2 on Figure 2.

Reflects Template Top Section.

Commodity Section

• See section 3 on Figure 2.

Reflects Template Commodity Table Section.

TOC Section

• See section 2 on Figure 3.

Print TOC section if TOC checkbox is unchecked.

Bottom Section

• See section 4 on Figure 2.

Print REMARKS section if REMARKS checkbox is checked.

Footer

• See section 5 on Figure 2 or section 3 on Figure 3.

Print "PREPARED BY: " + first and last name of login User.

Multipage case

• Header for pages other than first
  • See Example on #Figure 3. Arrival Notice Ocean Pdf 2nd Page (section 1).
  • Same as header for page one but instead of date print CT# and Ref#.
• If there is subsequent page then print "Continued on next page" at the bottom of the page

Figures

Figure 1. Arrival Notice Ocean Template

Figure 2. Arrival Notice Ocean Pdf

Figure 3. Arrival Notice Ocean Pdf 2nd Page

Arrival Notice Air

Parent mantis: 565

Template

It has 2 sections: top and bottom.

Template Top Section

ARRIVAL NOTICE / FREIGHT

• This is a label

CT#:

• UI type: textbox
• UI params: tbd
• UI validation/constraint/overflow: tbd

• mapping: CT#
• default: value from current CT
• group generate case: show as many CTs as can fit; if not all can fit add "++" at the end of the string

REFERENCE NO.:

• UI type: textbox
• UI params: tbd
• UI validation/constraint/overflow: tbd

• mapping: Gen Tab.Import ref#
• default: value from current CT
• group generate case: pull from current CT

SHIPPER:

• UI type: textarea
• UI params: tbd
• UI validation/constraint/overflow: on pdf show up to 7 lines, discard the rest

• mapping: Gen Tab, Shipper
• default: value from current CT
• group generate case: pull from current CT

CONSIGNEE:

• UI type: textarea
• UI params: tbd
• UI validation/constraint/overflow: on pdf show up to 7 lines, discard the rest

• mapping: Gen Tab, Consignee
• default: value from current CT
• group generate case: pull from current CT

NOTIFY:

• UI type: textarea
• UI params: tbd
• UI validation/constraint/overflow: on pdf show up to 7 lines, discard the rest

• mapping: Gen Tab, Notify
• default: value from current CT
• group generate case: pull from current CT

BROKER:

• UI type:
• UI params: tbd
• UI validation/constraint/overflow: on pdf show up to 7 lines, discard the rest

• mapping: Imp Tab, Customs Broker
• default: value from current CT
• group generate case: pull from current CT

Date:

• UI type: datebox
• UI params: tbd
• UI validation/constraint/overflow: tbd

• mapping: none
• default: current date from user's PC
• group generate case: n/a

MAWB:

• UI type: textbox
• UI params: tbd
• UI validation/constraint/overflow: tbd

• mapping: Exp Tab, Master Airway bill
• default: value from current CT
• group generate case: pull from current CT

HAWB:

• UI type: textbox
• UI params: tbd
• UI validation/constraint/overflow: tbd

• mapping: Exp Tab, HAWB#
• default: value from current CT
• group generate case: pull from current CT

• note:

PREPARED BY:

• UI type: textbox + textbox
• UI params: tbd
• UI validation/constraint/overflow: tbd

• mapping: textbox 1: First Name and Last Name; textbox 2: email ; based on login user
• default: current user
• group generate case: n/a

Bank Release:

• UI type: textbox
• UI params: tbd
• UI validation/constraint/overflow: tbd

• mapping: none
• default: blank
• group generate case: n/a

Flight Number:

• UI type: textbox
• UI params: tbd
• UI validation/constraint/overflow: tbd

• mapping: Exp Tab, Flight One #
• default: value from current CT
• group generate case: pull from current CT

Freight Location:

• UI type: textarea
• UI params: tbd
• UI validation/constraint/overflow: tbd

• mapping: Imp Tab, Cargo Location
• default: value from current CT
• group generate case: pull from current CT

AIRPORT OF LOADING:

• UI type: textbox
• UI params: tbd
• UI validation/constraint/overflow: tbd

• mapping: Exp Tab, Airport of Departure
• default: value from current CT
• group generate case: pull from current CT

AIRPORT OF DISCHARGE:

• UI type: textbox
• UI params: tbd
• UI validation/constraint/overflow: tbd

• mapping: Exp Tab, Airport of Destination
• default: value from current CT
• group generate case: pull from current CT

FINAL DESTINATION:

• UI type: textbox
• UI params: tbd
• UI validation/constraint/overflow: tbd

• mapping: Imp Tab, Delivery Address (correct ???)
• default: value from current CT (correct ???)
• group generate case: pull from current CT

ETD:

• UI type: datebox
• UI params: tbd
• UI validation/constraint/overflow: tbd

• mapping: Exp Tab, ETD - Est Time of Dept
• default: value from current CT
• group generate case: pull from current CT

ETA:

• UI type: datebox
• UI params: tbd
• UI validation/constraint/overflow: tbd

• mapping: Exp Tab, ETA - Est Time of Arrival
• default: value from current CT
• group generate case: pull from current CT

IT number:

• UI type: textbox
• UI params: tbd
• UI validation/constraint/overflow: tbd

• mapping: Imp Tab, IT#
• default: value from current CT
• group generate case: pull from current CT

IT date:

• UI type: datebox
• UI params: tbd
• UI validation/constraint/overflow: tbd

• mapping: Imp Tab, IT Date
• default: value from current CT
• group generate case: pull from current CT

Location:

• UI type: datebox
• UI params: tbd
• UI validation/constraint/overflow: tbd

• mapping: Imp Tab, IT Location
• default: value from current CT
• group generate case: pull from current CT

Template Bottom Section

PO

See #Figure 2: Template Bottom Section , sec 1.

PO numbers:

• UI type: textbox
• UI params: tbd
• UI validation/constraint/overflow: fit as many as possible, add "++" at the end if not all can fit

• mapping: Cont Tab, Table A, PO numbers from all lines
• default: value from current CT
• group generate case: pull from all selected CT's, first from current CT

Commodity table

See #Figure 2: Template Bottom Section , section 2.

Marks and Numbers :

• UI type: textarea
• UI params: tbd
• UI validation/constraint/overflow: none

• mapping: none
• default: pre-fill to "Address"
• group generate case: TBD

Description of Goods and Pkgs :

• UI type: textarea
• UI params: tbd
• UI validation/constraint/overflow: none

• mapping: Gen Tab, Commodity description
• default: value from current CT
• group generate case: TBD

Weight:

• UI type: textarea
• UI params: tbd
• UI validation/constraint/overflow: see Precision

• mapping: Cont Tab, Table A, GRAND TOTAL: TtlGkg
• default: value from current CT
• group generate case: sum of all values for selected CT's

Measurement:

• UI type: textbox
• UI params: tbd
• UI validation/constraint/overflow: see Precision

• mapping: Cont Tab, Table B, TOTALs: Total (in cbm)
• default: value from current CT
• group generate case: sum of all values for selected CT's

PCS:

• UI type: textbox
• UI params: tbd
• UI validation/constraint/overflow: see Precision

• mapping: Cont Tab, Table A, GRAND TOTAL: Ttl HU
• default: value from current CT
• group generate case: sum of all values for selected CT's

Remarks

See #Figure 2: Template Bottom Section , section 3.

It consists of checkbox and textarea. If unchecked - do not print this section.

Remarks (text):

• UI type: textbox
• UI params: tbd
• UI validation/constraint/overflow:

• mapping: Cont Tab, Table A, GRAND TOTAL: Ttl HU
• group generate case: set default based on current CT values
• default: see logic below

IF Imp Tab.Payment of freight charges required prior to release? = N THEN pre-fill:

PRIOR TO CARGO PICK-UP, CONSIGNEE MUST CLEAR CUSTOMS AND CONFIRM FREIGHT RELEASE WITH PIER/CFS. PLEASE PICK UP YOUR CARGO UPON RELEASE IN ORDER TO AVOID UNNECESSARY CHARGES

IF Imp Tab.Payment of freight charges required prior to release? = Y THEN pre-fill:

PLEASE SEND CHASHIER'S CHECK, MONEY ORDER, OR BROKER CHECK PAYABLE TO JAGUARFREIGHT SERVICE; FREIGHT CAN ONLY BE RELEASED UPON RECEIPT OF CHARGES SHOWN

PRIOR TO CARGO PICK-UP, CONSIGNEE MUST CLEAR CUSTOMS AND CONFIRM FREIGHT RELEASE WITH PIER/CFS. PLEASE PICK UP YOUR CARGO UPON RELEASE IN ORDER TO AVOID UNNECESARY CHARGES

Freight Invoice

See #Figure 2: Template Bottom Section , section 4.

This is a separate sub component. See Freight Invoice Section On Arrival Notice.

Pdf

See #Figure 3: Arr Notice Pdf.

Header

See sec 1.

Header for page 2,3, ... is different from Header page 1. See Freight Invoice Section On Arrival Notice

Header for 1-page version consists of:

Jaguar logo

• it is office specific based on login user

Issued By

• login user's first name and last name

Document name

Page X of Y

Address

• Jaguar Office address based on login user

Top Section

See #Figure 3: Arr Notice Pdf, sec 2.

All values come from Template.

Bottom Section

See #Figure 3: Arr Notice Pdf, sec 3.

All values come from Template.

Footer

See #Figure 3: Arr Notice Pdf, sec 4.

First, Last names and email of logged user (from template).

Special case: Groups

See "group generate case:" attribute in fields definition.

Special case: Multiple pages

• This may only happened in case of a very large TOC - see design in Freight Invoice Section On Arrival Notice

• "Continued on next page" should appear at the bottom right of pdf.

Additional Figures

Figure 1: Template Top Section

Figure 2: Template Bottom Section

Figure 3: Arr Notice Pdf

Known Non Critical Bugs and Issues

• See all TBD above

• Prepared By to be standardized

• Label case to be standardized (template and pdf)

• Marks and Numbers - should we pull from CT?

• discuss Precision

• Measurement or Volume ??? to be standardized

• Measurement : should we print unit (CBM) ?

• FINAL DESTINATION: default and mapping, is it correct ??? See Air_CT_Arrival_Notice#Version_3.1.c

• "Continued on next page" - is this only for this doc or we can make it "generic component"

• Make labels on pdf and template uniform.

See Also

• Old Specification: Air_CT_Arrival_Notice

SOWs

SOW 1 2 3

n/a

SOW 4 Changes to TOC

mantis: 4150

spec:

Estimated Sales Charges should propagate from Est Tab into "Table Of Charges" section on these pdfs:

• #Arrival Notice Air
• #Arrival Notice Ocean

We already have similar functionality but TOC is copied from Imp Tab which is to be replaced by TOC on Est tab.

There are some changes in functionality - see below:

• default is Do NOT print
• do not allow edit lines
• allow delete lines
• TOC on pdf should look like new TOC on Sales Inv
• Let user select only ONE Bill To, populate lines linked to it
• On Edit load old TOC but show Refresh button
  • if clicked refresh TOC to sync with current state of Est Tab
• On Generate give warning: "TOC will be refreshed. Are you sure?"

Mock up below shows current state of prototype:

SOW 2