Shipment Progress condition
From UG
(Difference between revisions)
(→Dept logic) |
(→Collected (Picked) logic) |
||
Line 10: | Line 10: | ||
* MOT = FCL | * 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 | IF "ContTab.Actual collection date" is not empty FOR ALL containers | ||
THEN show a solid bar | THEN show a solid bar |
Revision as of 21:27, 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 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
- 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
- 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
- Trucking Air, Trucking Domestic, Trucking Ocean
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
- Trucking Air, Trucking Domestic, and Trucking Ocean
- Id "Y.Actual Delivery" is not empty, show a solid bar
- Trucking Air, Trucking Domestic, and Trucking Ocean
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
???