In Transit Report

From UG

Revision as of 01:04, 30 June 2009 (edit) Alex (Talk | contribs) (→Intro) ← Older edit		Revision as of 01:12, 30 June 2009 (edit) (undo) Alex (Talk | contribs) (→MOT = FCL) Newer edit →
Line 45:		Line 45:
	AND		AND
	ContTab Actual Delivery is empty for at least one container		ContTab Actual Delivery is empty for at least one container
		+
		+	== Filters ==
		+
		+	* Filters are selected by user
		+	* In front of each filter there is a checkbox. If checked then this filter must be applied.
		+	* All filters are multiselect
		+	* Air only filters:
		+	** Airport(s) of departure
		+	** Airport(s) of destination
		+	* Ocean only filters:
		+	** port(s) of departure
		+	** port(s) of destination
		+	* Other filters (any MOT):
		+	* Client
		+	* Origin Country
		+	* Destination Country
		+	* Origin Region
		+	* Destination Region
		+	* Display PO Numbers on report results

---

Revision as of 01:12, 30 June 2009

Contents 1 Intro 2 Hard Coded Conditions 2.1 MOT=Truck 2.2 MOT = Air 2.3 MOT = LCL 2.4 MOT = FCL 3 Filters

Intro

• The result of this report is a number of CTs in the system that satisfy Hard Coded Conditions and Filters.
• 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

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

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 container: ContTab Estimated collection OR ContTab Actual collection is not empty) 
AND 
ContTab Actual Delivery is empty for at least one container

Filters

• Filters are selected by user
• In front of each filter there is a checkbox. If checked then this filter must be applied.
• All filters are multiselect
• Air only filters:
  • Airport(s) of departure
  • Airport(s) of destination
• Ocean only filters:
  • port(s) of departure
  • port(s) of destination
• Other filters (any MOT):
• Client
• Origin Country
• Destination Country
• Origin Region
• Destination Region
• Display PO Numbers on report results