In Transit Report
From UG
(Difference between revisions)
(→MOT = Air) |
(→MOT = LCL) |
||
Line 30: | Line 30: | ||
=== MOT = LCL === | === MOT = LCL === | ||
- | (( | + | ((GenTab Estimated Export Pickup Date ''is not empty'' |
- | OR | + | OR GenTab Actual Export Pickup Date ''is not empty'' |
- | OR | + | OR ExpTab Arrival Into Warehouse Date ''is not empty'' |
- | OR Origin Terminal ETD ''is not empty'' | + | OR ExpTab Origin Terminal ETD ''is not empty'' |
- | OR Origin Terminal ATD ''is not empty'' | + | OR ExpTab Origin Terminal ATD ''is not empty'' |
- | OR Port Of Loading ETD ''is not empty'' | + | OR ExpTab Port Of Loading ETD ''is not empty'' |
- | OR Port Of Loading ATD ''is not empty'' | + | OR ExpTab Port Of Loading ATD ''is not empty'' |
) AND | ) AND | ||
- | + | ImpTab Actual Delivery ''is empty'' ) = true |
Revision as of 23:47, 29 June 2009
Contents |
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
((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