In Transit Report ARC
From UG
(Difference between revisions)
Line 1: | Line 1: | ||
- | [[Category: | + | [[Category:Ops Reps Old]] |
=== Ver 0 === | === Ver 0 === |
Revision as of 22:02, 13 December 2009
Contents |
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.0 : Dates Conditions
- These conditions are MOT specific
- Conditions below must be true for CT to be on this report
- They are hard coded
MOT=Truck
((GenTab Estimated Export Pickup Date is not empty OR GenTab Actual Export Pickup Date is not empty )AND GenTab Actual Delivery is empty ) = true
Or to re-phrase:
2 conditions must be satisfied at the same time:
- cond1) One or more of the dates from the following list are NOT empty:
- GenTab Estimated Export Pickup Date
- GenTab Actual Export Pickup Date
- cond2) GenTab Actual Delivery is empty
MOT = Air
((GenTab Estimated Export Pickup Date is not empty OR GenTab Actual Export Pickup Date is not empty OR ExpTab Arrival Into Warehouse Date is not empty OR ExpTab Airport of Departure ETD is not empty OR ExpTab Airport of Departure ATD is not empty ) AND ImpTab Actual Delivery is empty ) = true
MOT = LCL
((GenTab Estimated Export Pickup Date is not empty OR GenTab Actual Export Pickup Date is not empty OR ExpTab Arrival Into Warehouse Date is not empty OR ExpTab Origin Terminal ETD is not empty OR ExpTab Origin Terminal ATD is not empty OR ExpTab Port Of Loading ETD is not empty OR ExpTab Port Of Loading ATD is not empty ) AND ImpTab Actual Delivery is empty ) = true
MOT = FCL
(For every containerX on Container Table: Estimated collection OR Actual collection is not empty) OR ExpTab Origin Terminal ETD is not empty OR ExpTab Origin Terminal ATD is not empty OR ExpTab Port Of Loading ETD is not empty OR ExpTab Port Of Loading ATD is not empty AND For at least one containerX on Container Table: Actual Delivery is empty
QA Plan
- t1 for every MOT above design and run:
- at least 2 sets of conditions for given CT that should make it APPEAR on report
- at least 2 sets of conditions for given CT that should make it NOT APPEAR on report
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 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
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