In Transit Report
From UG
(Difference between revisions)
(→Output) |
(→Output) |
||
Line 88: | Line 88: | ||
* out6] If user selects another CT then all fields are re-freshed (except Quantity that always shows value for entire Master) | * out6] If user selects another CT then all fields are re-freshed (except Quantity that always shows value for entire Master) | ||
- | * out7] [View] button | + | * out7] [View] button opens CT record |
Revision as of 01:24, 30 June 2009
Contents |
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
Output
Output
- Is in the form of Excel file
- It consists of 4 sections (one per MOT). Each has same design
- Each section is a table with the following columns
- CT #
- Shipper
- Consignee
- Quantity
- from country
- to country
- estimated/actual departure
- estimated/actual arrival
- out2] sort by: estimated/actual arrival, to country, qty
- out3] For MOT=Air, Truck each line represents one of CTs that satisfied ALL "hard coded conditions" and Filters. Each column shows field for given CT
- out4] For MOT=FCL, LCL each line represents One CT only if that CT does not have Master
- out5] If CT has a Master then each line in the table above represent one master and ANY CT from that master is shown in a dropdown (dd). All fields displayed are fields for THAT CT.
- out6] If user selects another CT then all fields are re-freshed (except Quantity that always shows value for entire Master)
- out7] [View] button opens CT record