List CTs

From UG

(Difference between revisions)
Jump to: navigation, search
(Live Tab)
(Live Tab)
Line 25: Line 25:
* If MOT = '''truckDom''' then GenTab.y.ActualDelivery must be empty
* If MOT = '''truckDom''' then GenTab.y.ActualDelivery must be empty
-
* 3) CT is "delivered" if the following conditions are met:
+
=== Delivered Tab ===
 +
 
 +
CT is "delivered" if the following conditions are met:
  MOT = air: ImportTab.ActualDeliveryDateDATEBOX is not empty  
  MOT = air: ImportTab.ActualDeliveryDateDATEBOX is not empty  
Line 36: Line 38:
  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:
+
=== Archived Tab ===
 +
 
 +
CT is "archived" if the following conditions are met:
  MOT = air: ImportTab.ActualDeliveryDateDATEBOX value is 6 month (or more) older than todays date
  MOT = air: ImportTab.ActualDeliveryDateDATEBOX value is 6 month (or more) older than todays date

Revision as of 15:21, 21 July 2009

Contents

Summary

  • This is a very frequently used report
  • It lists all shipments in the system grouped by undefined / live / delivered / archived
  • Each group of CTs mentioned above is listed under a separate tab: undefined / live / delivered / archived
  • Path: CT Home, Main Toolbar > List CTs
  • see example here: TBD
  • mantis id = 756
  • mantis link: TBD

Definition of UNDEFINED LIVE DELIVERED ARCHIVED

Undefined Tab

CT is undefined if its MOT = “undefined”

Live Tab

CT is live if the following conditions are met:

  • If MOT = AIR then ActualDeliveryDate in Import Tab must be empty.
  • If MOT = oceanLCL then ImportTab.ActualDeliveryDateDATEBOX must be empty
  • If MOT = oceanFCL then ComTable.ContainerTable.ActualDeliveryDateDATEBOX must be empty (for at least one container)
  • If MOT = truckAir then GenTab.y.ActualDelivery must be empty
  • If MOT = truckOcn then GenTab.y.ActualDelivery must be empty
  • If MOT = truckDom then GenTab.y.ActualDelivery must be empty

Delivered Tab

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

Archived Tab

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.0

  • 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
  • new layout here: http://mantis.jaguarfreight.com/svn/ct2/SS/ops/CT/list_cts/v2/specs.html

ver 2.1

  • 0000910 [Ops.CT.ListCTs] add unit type, etc
  • add tooltip for cont#

RFC

  • add M# column
Personal tools