Ocean CT ArrivalNotice
From UG
Mantis: http://mantis.jaguarfreight.com/mantis/view.php?id=581
History
See http://mantis.jaguarfreight.com/svn/ct2/SS/ops/pdfs/ocean_indiv_ct/Arrival_Notice/
Version 2.0
Pages
pg1) Right now even if TOC is empty it would print 2 pages.
pg2) TOC section is of variable size. It can make the size of this doc > 2 pages
Sec A (header for page one)
- Field Label // Pull from; Logic
- Jaguar Logo // Admin.Offices; it is office specific based on user login
- Jaguar Address // Admin.Offices; it is office specific based on user login
- DATE // current date on user's PC
- Page X of Y // X - current page num; Y - total num of pages
- Doc Title
Sec B (shipment fields)
Default group case logic - take values from current CT
- Field Label // Pull from; Logic
- CT # // CT# CT field
- REFERENCE NO. // GT.Import ref#:
- SHIPPER // GT.Shipper
- CONSIGNEE // GT.Consignee
- NOTIFY // GT.Notify
- BROKER // IT.CustomsBroker
- Master Bill of Lading // ETab.Master Bill of Lading
- HOUSE BILL OF LADING NO# // ETab.House Bill of Lading
- PREPARED BY // fist, last names and e-mail for login operator
- Bank release // blank by default
- Flight Number // ET.Flight One #:
- Freight Location // IT.Cargo Location
- PORT OF LOADING // ETab.Port of Loading
- PORT OF DISCHARGE // ETab.Port Of Discharge
- FINAL DESTINATION // IT.Delivery Address
- ETD // ET.ETD - Est Time of Dept
- ETA // ET.ETA - Est Time of Arrival
- IT# // IT.IT#
- IT Date // IT.IT Date
- Location // IT.IT Location
- PO Numbers // all PO's from ContTab.TableA
- --
- AMS Bill Of Lading // blank by default
- Release Type // blank by default
- Freight release // blank by default
- SubHouse Bill of Lading // blank by default
- Vessel, Voyage // ETab. Vessel Name + Voyage #
Sec C (commodity table)
- Field Label // Pull from/Logic
- Marks and Numbers // pre-fill to "Address"
- Description of Goods and Pkgs // GT.Commodity description
- Weight // ContT.TableA.TtlGkg
- Measurement // ContT.TableB.TotalCBM
- PCS // ContTab.TableA.TtlHU
Sec D (remarks)
Empty Textarea.
Sec E and W (prepared by)
First, Last names and email of logged user
Sec X (header for pages other than first)
Same as sec A but instead of date print CT# and Ref#
Sec Y (payment remarks)
One large text area.
IF IT.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 IT.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
Sec Z (table of charges)
This is a TOC from Import Tab
Table
- Description: IT.TOC.lineX.CC Descr
- Currency: IT.TOC.lineX.Curr
- Amount: IT.TOC.lineX.Amount
Footer
curr + total
Special case: Groups
Sec C:
- Weight // sum of these values for all selected CTs
- Measurement // sum of these values for all selected CTs
- PCS // sum of these values for all selected CTs
Sec B:
- PO Numbers // ContTab.TableA.PO numbers (from all lines)
Special case: VAT
TOC would have VAT in totals if login office has VAT
Version 2.1
This is a minor release.
Changes below are applied on the top of spec above (ver 3.0)
| PRI | STATUS | BUG DESCRIPTION |
| low | open | Section C must be shorter - allocate space just for 6 lines |
| low | open | Section C : vertically align lines in table to TOP |
| high | open | Delete sec D |
| high | open | Move sec Y to page 1 and name it "Remarks" |
| high | open | Add checkbox to sec Y. If unchecked - do not display. |
| high | open | Do not generate page 2 if TOC is empty |
| high | open | rename "Final Destination" into "Destination terminal", pull data from ETab.Destination Terminal |
| high | open | rename "port of arrival" into "Port of Discharge" |
| high | open | rename "ETA" into "Discharge date" |
| high | open | rename "Freight release" into "Destination Date" and pull from ETab.15b. ETA |
| high | open | enlarge CT# box so that up to 15 CT's can fit; print all CT#s there in case of group generate (OR if this approach takes too long to code then print "<current CT#>, see Remarks" and print remaining CT#s into "Remarks" section) |
| high | open | |
| high | open | |
| high | open |
Bugs
TBD
