In Transit Report

From UG

Revision as of 23:39, 29 June 2009 (edit) Alex (Talk | contribs) (→MOT=Air) ← Older edit		Revision as of 23:43, 29 June 2009 (edit) (undo) Alex (Talk | contribs) (→MOT = Air) Newer edit →
Line 25:		Line 25:
	OR Airport of Departure ETD ''is not empty''		OR Airport of Departure ETD ''is not empty''
	OR Airport of Departure ATD ''is not empty''		OR Airport of Departure ATD ''is not empty''
		+	) AND
		+	Gen Tab Actual Delivery ''is empty'' ) = true
		+
		+	=== MOT = LCL ===
		+
		+	((Gen Tab Estimated Export Pickup Date ''is not empty''
		+	OR Gen Tab Actual Export Pickup Date ''is not empty''
		+	OR Exp Tab Arrival Into Warehouse Date ''is not empty''
		+	OR Origin Terminal ETD ''is not empty''
		+	OR Origin Terminal ATD ''is not empty''
		+	OR Port Of Loading ETD ''is not empty''
		+	OR Port Of Loading ATD ''is not empty''
	) AND		) AND
	Gen Tab Actual Delivery ''is empty'' ) = true		Gen Tab Actual Delivery ''is empty'' ) = true

---

Revision as of 23:43, 29 June 2009

Contents 1 Intro 2 Hard Coded Conditions 2.1 MOT=Truck 2.2 MOT = Air 2.3 MOT = LCL

Intro

• The result of this report is a number of CTs in the system that satisfy Hard Coded Conditions and "Parameters selected by user".
• For every CT there are other fields being displayed
• "Hard coded conditions" and "output definitions" are MOT-specific but user has of choice of running report for several or all MOT at once.
• CTs in output are grouped - each group corresponds to one MOT. This is similar to how CTs are grouped per MOT in Where Is Report

Hard Coded Conditions

• These conditions are MOT specific
• Conditions below must be true for CT to be on this report

MOT=Truck

((Gen Tab Estimated Export Pickup Date is not empty 
  OR GenTab Actual Export Pickup Date is not empty 
 )AND
  Gen Tab Actual Delivery is empty ) = true

MOT = Air

((Gen Tab Estimated Export Pickup Date is not empty 
  OR Gen Tab Actual Export Pickup Date is not empty 
  OR Exp Tab Arrival Into Warehouse Date is not empty
  OR Airport of Departure ETD is not empty 
  OR Airport of Departure ATD is not empty
  ) AND
  Gen Tab Actual Delivery is empty ) = true

MOT = LCL

((Gen Tab Estimated Export Pickup Date is not empty 
  OR Gen Tab Actual Export Pickup Date is not empty 
  OR Exp Tab Arrival Into Warehouse Date is not empty
  OR Origin Terminal ETD is not empty 
  OR Origin Terminal ATD is not empty
  OR Port Of Loading ETD is not empty 
  OR Port Of Loading ATD is not empty
  ) AND
  Gen Tab Actual Delivery is empty ) = true