In Transit Report

From UG

Revision as of 22:52, 5 December 2009 (edit) Alex (Talk | contribs) (→User Interface) ← Older edit		Revision as of 22:57, 5 December 2009 (edit) (undo) Alex (Talk | contribs) (→User Interface) Newer edit →
Line 22:		Line 22:
	** '''Generate Report BUTTON''' - to generate report		** '''Generate Report BUTTON''' - to generate report
	** '''Reset Form BUTTON''' - to clear form on both tabs		** '''Reset Form BUTTON''' - to clear form on both tabs
-	* See ''In Tansit UI for User Defined Conditions.JPG'' and ''File:In_Tansit_Output_Tab.JPG''.	+	* See [[Media:In Tansit UI for User Defined Conditions.JPG]] and ''File:In_Tansit_Output_Tab.JPG''.
	=== Hard Coded Conditions ===		=== Hard Coded Conditions ===

---

Revision as of 22:57, 5 December 2009

Contents 1 Business Needs and Requirements 2 Technical Specification 2.1 Summary 2.2 User Interface 2.3 Hard Coded Conditions 2.3.1 Note About Containers 2.3.2 Note about Archived CTs 2.4 User Defined Conditions 2.4.1 General functionality 2.4.2 Non-specific to MOT group of filters 2.4.3 Air filters 2.4.4 Output setting 2.5 Output 3 Development QA and History of Changes 3.1 Link to Parent Mantis 3.2 Ver 0 3.3 Ver 1 3.4 Tweaks V.1.1.a 3.5 Tweaks V.1.1 b 3.6 Tweaks version 1.1.a 3.7 Rel 2.0 Complete change of report conditions 3.8 Dec 5 Spec major cleanup 4 RFC

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.
• To appear on the report CT must satisfy Hard Coded Conditions and User Defined Conditions .
• In Output section of this specification it is defined how user can control output and in what form it is presented to the user

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 in 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 File:In_Tansit_Output_Tab.JPG.

Hard Coded Conditions

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

• CT does not have Deleted status AND
• Additional conditions are mode specific - 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

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

MOT = 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

• see containers: FCL vs Truck-Ocean

Note about Archived CTs

They are not included into this Report

User Defined Conditions

These are also called filters.

General functionality

• See 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

Non-specific to MOT group of filters

• • 1 Client (List is from Admin > Client Companies; Mapped to: CT, Gen Tab, E0. Client field)
  • 2 Origin Country (List is from Admin > Geography > Countries; Mapped to: CT, Gen Tab, Origin country field)
  • 3 Destination Country (List is from Admin > Geography > Countries; Mapped to: CT, Gen Tab, Destination country field)
  • 4 Origin Region
  • 5 Destination Region

Air filters

• • Airport(s) of departure
  • Airport(s) of destination

• s5 Ocean only filters:
  • port(s) Terminals of departure
  • port(s) Terminals of destination

Output setting

• "Display PO" numbers on report results checkbox
• MOT checkbox - controls for what MOT to run this report. Options are:
  • AIR
  • OCEAN
  • TRUCKING

Output

• s1 Is in the form of Excel file
• s2 It consists of 4 sections (one per MOT). Each has same design
• s3 Each section is a table with the following columns
  • CT #
  • Shipper
  • Consignee
  • Quantity,
    • new start: depends on the MOT:
      • if FCL, then show number of containers (example: "5 containers")
      • if LCL, then show Volume ("23 cbm")
      • if AIR, then show Chargeable Weight ("200 kg")
      • if TRUCK, then show Gross Weight ("200 kg")
    • new end --Alex 23:05, 7 July 2009 (UTC)
  • from country
  • to country
  • estimated/actual departure
  • estimated/actual arrival
  • PO (show only first PO, show PO++ if more than one PO exists)

• s4 sort by: estimated/actual arrival, to country, qty
• s5 For MOT=Air, Truck each line represents one CT

• s6 For MOT=FCL, LCL each line represents:
  • One CT only if that CT does not have Master
  • If CT has a Master then:
    • each line in the table above represent one master
    • ANY CT from that master is shown in a dropdown
    • all fields displayed are fields for THAT CT (except Quantity that always shows value for entire Master)
    • if user selects another CT then all fields are re-freshed

• s7 [View] button opens CT record
• s8 For departure and arrival columns: Show estimated value if actual value is not set

Development QA and History of Changes

Link to Parent Mantis

m#928(In Transit)

Ver 0

• http://mantis.jaguarfreight.com/svn/ct2/SS/2009/OpsReps/InTransit/v1/origDef.html [^]
• http://mantis.jaguarfreight.com/svn/ct2/SS/2009/OpsReps/html/CT2specsOpsReps.html [^]

Ver 1

See In Transit Report ARC

Tweaks V.1.1.a

Note: Feed back added from meeting on Oct1,2009

tw1) Add output tab for user in order to manage his report result. Heading consists of:

• CT#
• Shipper
• Consignee
• Quantity
• Departure
• Destination
• Departure Date
• Arrival Date
• P.O.

No update to TS

Tweaks V.1.1 b

tw1) Update filter names as below

• From Countries -> Origin Countries
• To Countries -> Destination Countries
• From Regions -> Origin Regions
• To Regions -> Destination Regions
• From Airports -> Origin Airports
• To Airports -> Destination Airports
• From Ports/Terminals -> Origin Ports/Terminals
• To Ports/Terminals -> Destination Ports/Terminals

No update to TS

Tweaks version 1.1.a

Note: Tira 9:50 28 Oct 2009

tw1) Add summary shipment record() count on the report to indicate that how many shipments...

tw2) Create a HTML result page before excel report

tw3) Create download to excel button -> generate xls report

No update to TS

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
• Ver 1.0 has been archived

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

RFC

1.need to exact order and form of sorting rules (include sorting rules by date for masters)--Andrei 09:51, 23 July 2009 (UTC)--