Shipment Progress condition

From UG

(Difference between revisions)
Jump to: navigation, search
Line 1: Line 1:
-
* '''Auth logic''' - this field is mapped to the "19. Authorized on" field n CT2(Internal)-> Gen tab
+
== Auth logic ==
-
** If "19.Authorized on" field is not empty, show a solid bar** Collected logic - this field is mapped to the actual picked up date field
+
 
 +
* MOT = any
 +
** If "GenTab.19.Authorized on" field is not empty, show a solid bar else show no bar
 +
 
 +
== Collected (Picked) logic ==
 +
 
 +
* MOT = AIR
 +
** If "GenTab.10.Actual Export Pickup Date:" is not empty, show a solid bar, else show no bar
-
* '''Collected logic'''
 
-
** AIR - this field is mapped to the "General tab, #10"
 
-
*** If "10.Actual Export Pickup Date:" is not empty, show a solid bar
 
** FCL - this field is mapped to  '''all''' "Actual dates" <span style ="color:#ff0000"> need to ensure the logic with Alex and Simon </span>
** FCL - this field is mapped to  '''all''' "Actual dates" <span style ="color:#ff0000"> need to ensure the logic with Alex and Simon </span>
*** If '''all''' actual dates (Exp tab, #11c,#12c, #13c, #14c, and #15c) are not empty, show a solid bar
*** If '''all''' actual dates (Exp tab, #11c,#12c, #13c, #14c, and #15c) are not empty, show a solid bar
*** If '''at least 1 actual date''' from (Exp tab, #11c,#12c, #13c, #14c, and #15c) is not empty, show a non-solid bar(shaded bar)
*** If '''at least 1 actual date''' from (Exp tab, #11c,#12c, #13c, #14c, and #15c) is not empty, show a non-solid bar(shaded bar)
-
* '''Dept logic'''
+
 
-
** AIR - this field is mapped to the "Exp tab #11c" or "Origin terminal Actual Date"
+
== Dept logic ==
-
*** If "11c Export tab" is not empty, show a solid bar
+
 
 +
* MOT = AIR
 +
** If "ExpTab.11c ATD - Actual Time of Dept:" is not empty, show a solid bar, else no bar
 +
 
** LCL - this field is mapped to the "Exp tab #12c" or "Port of load Actual Date"
** LCL - this field is mapped to the "Exp tab #12c" or "Port of load Actual Date"
*** If "12c Export tab" is not empty, show a solid bar
*** If "12c Export tab" is not empty, show a solid bar
 +
** FCL - this field is mapped to the "Exp tab #12c" or "Port of load Actual Date"
** FCL - this field is mapped to the "Exp tab #12c" or "Port of load Actual Date"
*** If "12c Export tab" is not empty, show a solid bar
*** If "12c Export tab" is not empty, show a solid bar
 +
** Trucking Air - this field is mapped to the "Gen tab #10"
** Trucking Air - this field is mapped to the "Gen tab #10"
*** If "Gen #10" is not empty, show a solid bar
*** If "Gen #10" is not empty, show a solid bar
** Trucking Ocean  
** Trucking Ocean  
*** If "Y.Actual Delivery" is not empty, show a solid bar
*** If "Y.Actual Delivery" is not empty, show a solid bar
-
* '''Arr logic'''
+
 
-
** AIR  
+
== Arr logic ==
-
*** If "Exp tab, #14c" is not empty, show a solid bar
+
 
 +
* AIR  
 +
** If "ExpTab.14c. ATA - Actual Time of Arrival:" is not empty, show a solid bar; else no bar
 +
 
** Ocean ?????????
** Ocean ?????????
*** If "Exp tab, #15" is not empty, show a solid bar?????
*** If "Exp tab, #15" is not empty, show a solid bar?????

Revision as of 19:36, 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
    • If "GenTab.10.Actual Export Pickup Date:" is not empty, show a solid bar, else show no bar
    • FCL - this field is mapped to all "Actual dates" need to ensure the logic with Alex and Simon
      • If all actual dates (Exp tab, #11c,#12c, #13c, #14c, and #15c) are not empty, show a solid bar
      • If at least 1 actual date from (Exp tab, #11c,#12c, #13c, #14c, and #15c) is not empty, show a non-solid bar(shaded bar)

Dept logic

  • MOT = AIR
    • If "ExpTab.11c ATD - Actual Time of Dept:" is not empty, show a solid bar, else no bar
    • LCL - this field is mapped to the "Exp tab #12c" or "Port of load Actual Date"
      • If "12c Export tab" is not empty, show a solid bar
    • FCL - this field is mapped to the "Exp tab #12c" or "Port of load Actual Date"
      • If "12c Export tab" is not empty, show a solid 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
    • Ocean ?????????
      • If "Exp tab, #15" is not empty, show a solid bar?????
    • LCL
      • If "Exp tabm # 14c" is not empty, show a solid bar
    • FCL
      • If "Exp tabm # 14c" is not empty, show a solid 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 "Act Deliver Date, Import tab" is not empty, show a solid 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
    • AIR and Ocean
      • If "Custom status released" and "Custom Status Date" are not empty, show a solid bar
Personal tools