In Transit Report

From UG

Revision as of 20:11, 8 December 2009 by Alex (Talk | contribs)
Jump to: navigation, search
In Tansit UI for User Defined Conditions.JPG


Contents

Business Needs and Requirements

This report is used to identify those shipments that already "considered on the move" but "considered not yet delivered".

Technical Specification

Summary

  • Input for this report is a list of all CTs in the system
  • In Output section of this specification it is defined how user can control format of the output and in what form it is presented to the user (what columns to include, etc.)
  • To appear on the report CT must satisfy:

Hard Coded Conditions

For CT to appear on this report it must satisfy all conditions below:

  • CT does not have *Deleted* status AND
  • CT does not have *Archived* status AND
  • CT satisfy *MOT specific conditions* - see below:

MOT = Air

  • ExpTab.Master Airway bill "is not empty" AND
  • ImpTab.Actual Delivery Date "is empty" or today's date or yesterday's date

MOT = LCL/Client Consol

  • CT has at least one container AND
  • Container# field "is not empty" for one or more containers on ContTab.ContainersTable AND
  • ImpTab.Actual Delivery Date "is empty" or today's date or yesterday's date


MOT = FCL and MOT = Truck-Ocn

  • CT has at least one container AND
  • Container# field "is not empty" for one or more containers on ContTab.ContainersTable AND
  • ContTab.ContainersTable.ContainerX.Actual Delivery Date "is empty" or today's date or yesterday's date for all for one or more containers

MOT = Truck-Dom; Truck-Air

  • GenTab.Estimated Export Pick-Up Date "is not empty" AND
  • ImpTab.Actual Delivery Date "is empty" or today's date or yesterday's date

Note About Containers

User Defined Conditions

These are also called filters.

Summary

  • See Media:In Tansit UI for User Defined Conditions.JPG
  • All filters are located on "Filters" tab
  • There is a check box in front of every filter. Filter is applied only when checked
  • All filters are "multiselect".
  • Filters consists of several groups
  • Every filter connected by AND and selections inside filter are connected by OR
    • For example:
      • (Origin Airports=JFK OR Origin Airports=SFO) AND (Destination Airports=BKK OR Destination Airports=OKA)

Non-specific to MOT group of filters

  • Client
    • List is from: Admin > Client Companies
    • Mapped to: CT, Gen Tab, E0. Client
  • Origin Country
    • List is from: Admin > Geography > Countries
    • Mapped to: CT, Gen Tab, Origin country
  • Destination Country
    • List is from: Admin > Geography > Countries
    • Mapped to: CT, Gen Tab, Destination country
  • Origin Region
    • List is from: Admin > Geography > Region
    • Mapped to: CT, Gen Tab, Origin country (based on Country TO Region mapping in Admin)
    • NOTE: Selecting one Origin Region is equivalent to selecting all countries in this region in "Origin Country" filter
  • Destination Region
    • List is from: Admin > Geography > Region
    • Mapped to: CT, Gen Tab, Destination country (based on Country TO Region mapping in Admin)

Air filters

  • Airport(s) of departure
    • List is from: Admin > Geography > Airports
    • Mapped to: CT, Exp Tab, Airport of Departure
  • Airport(s) of destination
    • List is from: Admin > Geography > Airports
    • Mapped to: CT, Exp Tab, Airport of Destination

Ocean filters

  • Terminals of departure
    • List is from: Admin > Geography > Ports/Terminals
    • Mapped to: CT, Exp Tab, Origin Terminal
  • Terminals of destination
    • List is from: Admin > Geography > Ports/Terminals
    • Mapped to: CT, Exp Tab, Destination Terminal

MOT filter

  • AIR
  • OCEAN
  • TRUCKING

User Interface

  • In order to generate report user have to:
    • configure "user defined conditions" (select desired Client Company for example) and
    • configure "output" (Select Shipper CT field to appear on the generated table)
  • All settings are grouped into two tabs:
    • Filters
    • Output
  • Action controls:
    • Generate Report button - to generate report
    • Reset Form button - to clear form on both tabs
  • See Media:In Tansit UI for User Defined Conditions.JPG and Media:In_Tansit_Output_Tab.JPG.

Output

File:In Tansit Spreadsheet.JPG

Summary

  • Output is a spreadsheet
  • See example here: Media:In Tansit Spreadsheet.JPG
  • Spreadsheet tabs: there is only one
  • Spreadsheet consists of Header, Body Footer
  • Header (1):
    • Report Name
    • Date and Time (1a)
    • List of filters selected (1b)
  • Footer - there is no footer at the moment
  • Body, general info:
    • Consists of sections (one per MOT, trucking modes combined, FCL and LCL listed separately)
    • Each section has a header and a table
    • Header example: TRUCKING, 5 shipment(s)
    • Table consists of columns
  • Body, Column#1: CT# or dropdown with CT#s (see 5 on Fig).
    • Drop down appears if CT is a part of a Master (this logic is for FCL and LCL only)
    • Any CT be active shown first; CTs in dropdown can be in any order
    • To indicate that there is a hidden dropdown CT is underlined. Click on it and dropdown will appear.
    • If another CT is selected from drop down then all values in other columns would be refreshed to display values for this CT
  • Body, Column#2: It is a link to the CT edit page in CT2

Additional User Defined Columns

File:In Tansit Output Tab.JPG
  • User can control what additional columns to display
  • Filter Tab > "Display PO" check box.
    • Controls if this field is available and selected on Output tab
  • Shipper
    • from: CT > Gen Tab > Shipper
  • Consignee
    • from: CT > Gen Tab > Consignee
  • Quantity: value // label depends on the MOT:
    • if FCL, then show number of containers (example: "5 containers") // "Cntrs"
    • if LCL, then show Volume ("23 cbm") // "CBM"
    • if AIR, then show Chargeable Weight ("200 kg") // "KG"
    • if TRUCK, then show Gross Weight ("200 kg") // "KG"
    • must always show value for entire Master? Yes.
  • Departure
    • from: CT, Gen Tab, Origin country
  • Destination
    • Mapped to: CT, Gen Tab, Destination country
  • Departure date (Origin Terminal)
    • FCL: Exp Tab, Origin Terminal date
    • LCL: Exp Tab, Origin Terminal date
    • Air: Exp Tab, Airport of Departure Date
    • Truck Air/Dom: Gen Tab, Pick Up
    • Truck Ocean: ??? have multiple Collection dates on containers, which one to show?
    • Show estimated value if actual value is not set
  • Arrival date (Destination Terminal)
    • FCL: Exp Tab, Destination Terminal date
    • LCL: Exp Tab, Destination Terminal date
    • Air: Exp Tab, Airport of Destination Date
    • Truck Air/Dom: Gen Tab, Pick Up
    • Truck Ocean: ??? have multiple Delivery dates on containers, which one to show?
    • Show estimated value if actual value is not set
  • P.O.
    • from CT > Cont Tab > Commod Table A
    • show only first PO, show PO++ if more than one PO exists

Sort By

Sort in this order:

  • 1) Arrival date
  • 2) Departure date
  • 3) destination

In case of multiple CTs in dropdown use values from "shown" CT of course.

Dev, QA and History of Changes

Link to Parent Mantis

1300(Ops Core)

Link to Archive

See In Transit Report ARC

Rel 2.0 Complete change of report conditions

  • In this version all hard coded conditions has been completely changed.

No update to TS

Dec 5 Spec major cleanup

  • TS has been updated
  • All older versions has been archived

--Alex 21:31, 5 December 2009 (UTC)

Ver 2.1 Misc Updates and Bug Fixes: Quantity, Sorting, etc

  • mantis: TBD
  • chg1) [spec updated] Rename "Quantity" label on xls with unit names:
    • FCL section: "Cntrs"
    • LCL section: "KG"
    • Air section: "CBM"
    • Truck section: "KG"
  • chg2) [spec NOT updated]
    • Instead underline for Master case show drop down right away if possible. If not make it more prominent (bold? another color?)
    • If CT is not under Master - link CT# label itself and do not show "view" on that line
  • chg3) [spec not updated] Rename labels on xls:
Departure -> Origin
Depart Date -> Departure
Arriv Date -> Arrival
  • chg5) [spec updated] new sorting requirement - see #Sort By

RFC

Personal tools