In Transit Report
From UG
(→Summary) |
(→Note About Containers) |
||
Line 50: | Line 50: | ||
==== Note About Containers ==== | ==== Note About Containers ==== | ||
- | * see [[Containers_and_Contents_Component#FCL_.2F_LCL_vs_Ocean-Truck]] | + | * see [[Containers_and_Contents_Component#FCL_.2F_LCL_vs_Ocean-Truck| FCL vs Truck-Ocean ]] |
==== Note about Archived CTs ==== | ==== Note about Archived CTs ==== |
Revision as of 21:26, 5 December 2009
Contents |
Parent Mantis
Business Needs and Requirements
This report is used to identify those shipments that already "considered on the move" but "considered not yet delivered". Of course we can find out about that based on dates we store for shipment.
Technical Specification
Summary
- Input for this report is a list of all CTs in the system.
- To appear on the report CT must satisfy Hard Coded Conditions and User Defined Conditions .
- In Output section it is defined how user can control output and in what form it is presented to the user
Hard Coded Conditions
For CT to appear on this report it must satisfy all conditions below:
- CT does not have Deleted status AND
- Additional conditions are mode specific - see below:
MOT = Air
- ExpTab.Master Airway bill "is not empty" AND
- ImpTab.Actual Delivery Date "is empty" or today's date or yesterday's date
MOT = LCL/Client Consol
- CT has at least one container AND
- Container# field "is not empty" for one or more containers on ContTab.ContainersTable AND
- ImpTab.Actual Delivery Date "is empty" or today's date or yesterday's date
MOT = FCL and MOT = Truck-Ocn
- CT has at least one container AND
- Container# field "is not empty" for one or more containers on ContTab.ContainersTable AND
- ContTab.ContainersTable.ContainerX.Actual Delivery Date "is empty" or today's date or yesterday's date
for allfor one or more containers
MOT = Truck-Dom
- GenTab.Estimated Export Pick-Up Date "is not empty" AND
- ImpTab.Actual Delivery Date "is empty" or today's date or yesterday's date
MOT = Truck-Air
- GenTab.Estimated Export Pick-Up Date "is not empty" AND
- ImpTab.Actual Delivery Date "is empty" or today's date or yesterday's date
Note About Containers
Note about Archived CTs
They are not included into this Report
User Defined Conditions
These are also called filters.
- s1 Filters are selected by user
- s2 In front of each filter there is a checkbox. If checked then this filter must be applied.
- s3 All filters are multiselect
- s4 Air only filters:
- Airport(s) of departure
- Airport(s) of destination
- s5 Ocean only filters:
-
port(s)Terminals of departure -
port(s)Terminals of destination
-
- s6 Other filters (any MOT):
- 1 Client
- 2 Origin Country
- 3 Destination Country
- 4 Origin Region
- 5 Destination Region
- s7 Display PO Numbers on report results
- s8 [new] MOT filter - controls for what MOT to run this report --Alex 22:54, 30 June 2009 (UTC)
Output
- s1 Is in the form of Excel file
- s2 It consists of 4 sections (one per MOT). Each has same design
- s3 Each section is a table with the following columns
- CT #
- Shipper
- Consignee
- Quantity,
- new start: depends on the MOT:
- if FCL, then show number of containers (example: "5 containers")
- if LCL, then show Volume ("23 cbm")
- if AIR, then show Chargeable Weight ("200 kg")
- if TRUCK, then show Gross Weight ("200 kg")
- new end --Alex 23:05, 7 July 2009 (UTC)
- new start: depends on the MOT:
- from country
- to country
- estimated/actual departure
- estimated/actual arrival
- PO (show only first PO, show PO++ if more than one PO exists)
- s4 sort by: estimated/actual arrival, to country, qty
- s5 For MOT=Air, Truck each line represents one CT
- s6 For MOT=FCL, LCL each line represents:
- One CT only if that CT does not have Master
- If CT has a Master then:
- each line in the table above represent one master
- ANY CT from that master is shown in a dropdown
- all fields displayed are fields for THAT CT (except Quantity that always shows value for entire Master)
- if user selects another CT then all fields are re-freshed
- s7 [View] button opens CT record
- s8 For departure and arrival columns: Show estimated value if actual value is not set
History
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 [^]
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.
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
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
Rel 2.0 Complete change of report conditions
In this version all hard coded conditions has been completely changed
RFC
1.need to exact order and form of sorting rules (include sorting rules by date for masters)--Andrei 09:51, 23 July 2009 (UTC)--