Shipment Progress condition
From UG
(Difference between revisions)
Line 1: | Line 1: | ||
- | + | == Auth logic == | |
- | ** If " | + | |
+ | * 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" <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 == |
- | + | ||
+ | * 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 | ||
+ | ** 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)
- FCL - this field is mapped to all "Actual dates" need to ensure the logic with Alex and Simon
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
- LCL - 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
- FCL - this field is mapped to the "Exp tab #12c" or "Port of load Actual Date"
- 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
- Trucking Air - this field is mapped to the "Gen tab #10"
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
- Ocean ?????????
- 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
- AIR and Ocean