Shipment Progress condition

From UG

Revision as of 21:41, 29 July 2009 by Alex (Talk | contribs)
Jump to: navigation, search

Contents

Auth logic

  • MOT = any
    • If "GenTab.19.Authorized on" field is not empty, show a solid bar else show no 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


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

- this field is mapped to "Act Deliver Date, Import tab" for AIR and Ocean
  • 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" == released AND "ImpTab.Custom Status Date" are not empty, then show a solid bar; else no bar
  • MOT = Truck modes

???

Personal tools