In Transit Report ARC
From UG
(Difference between revisions)
(→Tweaks V.1.1 b) |
|||
| (One intermediate revision not shown) | |||
| Line 1: | Line 1: | ||
| - | [[Category: | + | [[Category:Ops Reps Old]] |
=== Ver 0 === | === Ver 0 === | ||
| Line 115: | Line 115: | ||
''No update to TS'' | ''No update to TS'' | ||
| + | |||
| + | === Old versions of Column 1 and 2 on spreadsheet === | ||
| + | [[File:In Tansit Spreadsheet.JPG|thumb|600px|Figure 2:In Tansit Spreadsheet.JPG]] | ||
Current revision as of 15:49, 4 January 2010
Contents |
[edit] 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 [^]
[edit] 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
[edit] 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
[edit] 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
[edit] 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
[edit] 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
[edit] 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
[edit] 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
[edit] 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
[edit] 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
[edit] Old versions of Column 1 and 2 on spreadsheet
