Shipment Progress condition

From UG

(Difference between revisions)
Jump to: navigation, search
(Dept logic)
(Arr logic)
Line 32: Line 32:
** If "ExpTab.14c. ATA - Actual Time of Arrival:" is not empty, show a solid bar; else no bar
** If "ExpTab.14c. ATA - Actual Time of Arrival:" is not empty, show a solid bar; else no bar
-
** Ocean ?????????
+
* MOT = LCL or FCL
-
*** If "Exp tab, #15" is not empty, show a solid bar?????
+
IF "ExpTab.14c. ATA:" is not empty  
-
** LCL
+
THEN show a solid bar  
-
*** If "Exp tabm # 14c" is not empty, show a solid bar
+
ELSE no bar
-
** FCL
+
 
-
*** If "Exp tabm # 14c" is not empty, show a solid bar
+
 
** Trucking Air, Trucking Domestic, Trucking Ocean
** Trucking Air, Trucking Domestic, Trucking Ocean
*** If "Y.Actual Delivery" is not empty, show a solid bar
*** If "Y.Actual Delivery" is not empty, show a solid bar

Revision as of 20:14, 29 July 2009

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
    • 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

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
    • Trucking Air - this field is mapped to the "Gen tab #10"
      • If "Gen #10" is not empty, show a solid bar
    • Trucking Ocean
      • If "Y.Actual Delivery" is not empty, show a solid bar

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


    • Trucking Air, Trucking Domestic, Trucking Ocean
      • If "Y.Actual Delivery" is not empty, show a solid bar

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
    • Ocean, LCL, and FCL - If "Act Deliver Date, Import tab" is not empty, show a solid bar
    • Trucking Air, Trucking Domestic, and Trucking Ocean
      • Id "Y.Actual Delivery" is not empty, show a solid bar

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