List CTs

From UG

(Difference between revisions)
Jump to: navigation, search
(Created page with '== Summary == * This is a very frequently used report * It lists all shipments in the system grouped by undefined / live / delivered / archived * see example here: TBD * mantis …')
Line 10: Line 10:
* 1) MOT = “undefined”
* 1) MOT = “undefined”
-
live - never
+
live - never
-
delivered - never
+
delivered - never
-
archived - never
+
archived - never
* 2) CT is "live" if the following conditions are met:
* 2) CT is "live" if the following conditions are met:
-
MOT = air: ImportTab.ActualDeliveryDateDATEBOX is empty
 
-
MOT = oceanLCL: ImportTab.ActualDeliveryDateDATEBOX is empty  
+
MOT = air: ImportTab.ActualDeliveryDateDATEBOX is empty  
-
MOT = oceanFCL: ComTable.ContainerTable.ActualDeliveryDateDATEBOX is empty (for at least one container)
+
-
MOT = truckAir: GenTab.y.ActualDelivery: is empty
+
MOT = oceanLCL: ImportTab.ActualDeliveryDateDATEBOX is empty
-
MOT = truckOcn: GenTab.y.ActualDelivery: is empty
+
MOT = oceanFCL: ComTable.ContainerTable.ActualDeliveryDateDATEBOX is empty (for at least one container)
-
MOT = truckDom: GenTab.y.ActualDelivery: is empty
+
 
 +
MOT = truckAir: GenTab.y.ActualDelivery: is empty
 +
MOT = truckOcn: GenTab.y.ActualDelivery: is empty
 +
MOT = truckDom: GenTab.y.ActualDelivery: is empty
* 3) CT is "delivered" if the following conditions are met:
* 3) CT is "delivered" if the following conditions are met:
-
MOT = air: ImportTab.ActualDeliveryDateDATEBOX is not empty
 
-
MOT = oceanLCL: ImportTab.ActualDeliveryDateDATEBOX is not empty  
+
** MOT = air: ImportTab.ActualDeliveryDateDATEBOX is not empty
-
MOT = oceanFCL: ComTable.ContainerTable.ActualDeliveryDateDATEBOX is not empty (for all containers)
+
 
 +
** MOT = oceanLCL: ImportTab.ActualDeliveryDateDATEBOX is not empty  
 +
** MOT = oceanFCL: ComTable.ContainerTable.ActualDeliveryDateDATEBOX is not empty (for all containers)
-
MOT = truckAir: GenTab.y.ActualDelivery: is not empty
+
** MOT = truckAir: GenTab.y.ActualDelivery: is not empty
-
MOT = truckOcn: GenTab.y.ActualDelivery: is not empty
+
** MOT = truckOcn: GenTab.y.ActualDelivery: is not empty
-
MOT = truckDom: GenTab.y.ActualDelivery: is not empty
+
** MOT = truckDom: GenTab.y.ActualDelivery: is not empty
* 4) CT is "archived" if the following conditions are met:
* 4) CT is "archived" if the following conditions are met:
Line 51: Line 53:
* 0000757 [Ops.CT.ListCTs] v2 :
* 0000757 [Ops.CT.ListCTs] v2 :
-
===========
+
** If containers are present in container table: display 1 cont. or 10 cont.(no need to specify size(s)/type(s) entered.
-
If containers are present in container table: display 1 cont. or 10 cont.
+
** (if a line was used/saved showing a type/size but no container number, count as 1 container -> each (saved) "line" of container table counts as 1 container for this specific purpose.
-
(no need to specify size(s)/type(s) entered.
+
-
(if a line was used/saved showing a type/size but no container number, count as 1 container -> each (saved) "line" of container table counts as 1 container for this specific purpose.
+
-
If no containers entered in the container table: dispay pallet count
+
** If no containers entered in the container table: dispay pallet count
-
If no pallets entered in contents table: Display carton count
+
** If no pallets entered in contents table: Display carton count
-
If no containers, no pallets, no cartons, do not display any "quantity"
+
** If no containers, no pallets, no cartons, do not display any "quantity"
-
============
 
* "Volume Weight (kg)" = Chargeable Weight  
* "Volume Weight (kg)" = Chargeable Weight  

Revision as of 17:54, 23 June 2009

Summary

  • This is a very frequently used report
  • It lists all shipments in the system grouped by undefined / live / delivered / archived
  • see example here: TBD
  • mantis id = 756
  • mantis link:

Definition of LIVE DELIVERED ARCHIVED shipments

  • 1) MOT = “undefined”
live - never
delivered - never
archived - never
  • 2) CT is "live" if the following conditions are met:
MOT = air: ImportTab.ActualDeliveryDateDATEBOX is empty 
MOT = oceanLCL: ImportTab.ActualDeliveryDateDATEBOX is empty 
MOT = oceanFCL: ComTable.ContainerTable.ActualDeliveryDateDATEBOX is empty (for at least one container)
MOT = truckAir: GenTab.y.ActualDelivery: is empty
MOT = truckOcn: GenTab.y.ActualDelivery: is empty
MOT = truckDom: GenTab.y.ActualDelivery: is empty
  • 3) CT is "delivered" if the following conditions are met:
    • MOT = air: ImportTab.ActualDeliveryDateDATEBOX is not empty
    • MOT = oceanLCL: ImportTab.ActualDeliveryDateDATEBOX is not empty
    • MOT = oceanFCL: ComTable.ContainerTable.ActualDeliveryDateDATEBOX is not empty (for all containers)
    • MOT = truckAir: GenTab.y.ActualDelivery: is not empty
    • MOT = truckOcn: GenTab.y.ActualDelivery: is not empty
    • MOT = truckDom: GenTab.y.ActualDelivery: is not empty
  • 4) CT is "archived" if the following conditions are met:

MOT = air: ImportTab.ActualDeliveryDateDATEBOX value is 6 month (or more) older than todays date

MOT = oceanLCL: ImportTab.ActualDeliveryDateDATEBOX value is 6 month (or more) older than todays date MOT = oceanFCL: ComTable.ContainerTable.ActualDeliveryDateDATEBOX value is 6 month (or more) older than todays date (look at ActualDeliveryDate for ALL containers and compare the most recent value with todays date)

MOT = truckAir: GenTab.y.ActualDelivery: value is 6 month (or more) older than todays date MOT = truckOcn: GenTab.y.ActualDelivery: value is 6 month (or more) older than todays date MOT = truckDom: GenTab.y.ActualDelivery: value is 6 month (or more) older than todays date


version 2 new features and changes

  • 0000757 [Ops.CT.ListCTs] v2 :
    • If containers are present in container table: display 1 cont. or 10 cont.(no need to specify size(s)/type(s) entered.
    • (if a line was used/saved showing a type/size but no container number, count as 1 container -> each (saved) "line" of container table counts as 1 container for this specific purpose.
    • If no containers entered in the container table: dispay pallet count
    • If no pallets entered in contents table: Display carton count
    • If no containers, no pallets, no cartons, do not display any "quantity"


  • "Volume Weight (kg)" = Chargeable Weight
  • 0000910 [Ops.CT.ListCTs] add unit type, etc
  • add tooltip for cont#
Personal tools