In Transit Report ARC

From UG

(Difference between revisions)
Jump to: navigation, search
(Created page with 'Category:OpsRepsCore')
Line 1: Line 1:
[[Category:OpsRepsCore]]
[[Category:OpsRepsCore]]
 +
 +
== 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

Revision as of 19:39, 4 December 2009


Contents

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
Retrieved from "https://wiki.jaguarfreight.com/In_Transit_Report_ARC"
Personal tools