In Transit Report ARC
From UG
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