Shipment Progress condition

From UG

Revision as of 21:29, 29 July 2009 (edit) Alex (Talk | contribs) ← Older edit		Revision as of 21:31, 29 July 2009 (edit) (undo) Alex (Talk | contribs) (→Arr logic) Newer edit →
Line 56:		Line 56:
	ELSE no bar		ELSE no bar
		+	* MOT = Trucking Air or Trucking Domestic
-	** Trucking Air, Trucking Domestic, Trucking Ocean	+	If "Y.Actual Delivery" is not empty
-	*** If "Y.Actual Delivery" is not empty, show a solid bar	+	THEN show a solid bar
		+	ELSE no bar
		+
		+	* MOT = Truck-ocean
	== Deliv Logic ==		== Deliv Logic ==

---

Revision as of 21:31, 29 July 2009

Contents 1 Auth logic 2 Collected (Picked) logic 3 Dept logic 4 Arr logic 5 Deliv Logic 6 CC 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 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

• MOT = Truck-Dom or Truck-Air

same as in Collected (Picked) logic

• MOT = Truck-Ocn

same as in Collected (Picked) logic

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

• MOT = Trucking Air or Trucking Domestic

If "Y.Actual Delivery" is not empty
THEN show a solid bar
ELSE no bar

• MOT = Truck-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

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

???