Shipment Progress condition

From UG

Contents 1 Auth logic 2 Collected (Picked) logic 3 Dept logic 4 Arr logic

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