In Transit Report ARC

From UG

Current revision as of 15:49, 4 January 2010

[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

Figure 2:In Tansit Spreadsheet.JPG