Shipment Progress condition
From UG
Contents |
Intro
new Read Shipment Milestones and Phases to get some background info. --Alex 19:46, 9 August 2009 (UTC)
Auth logic
- MOT = any
- If "GenTab.19.Authorized on" field is not empty, show a solid bar else show empty bar
Collected (Picked) logic
- MOT = AIR or LCL or Truck-Air or Truck-Dom or Truck-ocean
- If "GenTab.10.Actual Export Pickup Date:" is not empty, show a solid bar, else show no bar
- MOT = FCL
IF "ContTab.Actual collection date" is not empty FOR ALL containers THEN show a solid bar ELSE IF "ContTab.Actual collection date" is not empty FOR AT LEAST ONE container THEN show a shaded(or broken) bar ELSE show no bar
- MOT = Truck-Dom or Truck-Air
IF "GenTab.10. Actual Pick-Up Date" is not empty THEN show a solid bar ELSE show no bar
- MOT = Truck-Ocn
IF "ContTab.Actual collection date" is not empty FOR ALL containers THEN show a solid bar ELSE IF "ContTab.Actual collection date" is not empty FOR AT LEAST ONE container THEN show a shaded(or broken) bar ELSE show no bar
Dept logic
- MOT = AIR
- If "ExpTab.11c ATD - Actual Time of Dept:" is not empty, show a solid bar, else no bar
- MOT = LCL or FCL
- If "ExpTab.12c. ATD" not empty show a solid bar; ELSE show no bar
- MOT = Truck-Dom or Truck-Air
same as in Collected (Picked) logic
- MOT = Truck-Ocn
same as in Collected (Picked) logic
- All MOT:
- IF "Dept" bar exists but conditions for "Collected" is not satisfied THEN show bar before that anyway so that bar is not broken
- This could happen when non jaguar company collects shipment. in this case jag opers do not enter Coll date
Arr logic
- AIR
- If "ExpTab.14c. ATA - Actual Time of Arrival:" is not empty, show a solid bar; else no bar
- MOT = LCL or FCL
IF "ExpTab.14c. ATA:" is not empty THEN show a solid bar ELSE no bar
- MOT = Trucking Air or Trucking Domestic
If "Y.Actual Delivery" is not empty THEN show a solid bar ELSE no bar
- MOT = Truck-ocean
same logic as for Deliv Logic for MOT = FCL
Deliv Logic
- AIR
- If "ImpTab.Act Deliver Date" is not empty, show a solid bar; else no bar
- MOT = LCL
IF "ImpTab.11. Actual Delivery Date" not empty THEN show solid bar ELSE show no bar
- MOT = FCL
IF "ContTab.Actual Delivery date" is not empty FOR ALL containers THEN show a solid bar ELSE IF "ContTab.Actual Delivery date" is not empty FOR AT LEAST ONE container THEN show a shaded(or broken) bar ELSE show no bar
- MOT = Trucking Air or Trucking Domestic
same logic as for Arrived Logic for MOT = Trucking Air or Trucking Domestic
- MOT = Truck-ocean
same logic as for Deliv Logic for MOT = FCL
CC Logic
- MOT = AIR or Ocean FCL or LCL
IF "ImpTab.Custom status" == (Custom Status) AND "ImpTab.Custom Status Date" are both not empty THEN show a filled circle color by status; else no color (blank circle)
- MOT = Truck modes
always show always unchecked
- CC status
ONLY green color has checked mark symbol
History
m1342
- Make an empty bar for the status of progressing bar that is empty and occurred before the other bars(partial/solid bar)
- See #Auth logic
- Spec is updated: Y
- see attached image on Mantis 1342