List CTs

(Difference between revisions)

Revision as of 14:22, 21 August 2009

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
mantis : http://mantis.jaguarfreight.com/mantis/view.php?id=756
old spec: http://mantis.jaguarfreight.com/svn/ct2/SS/ops/CT/list_cts/

Mode  	CT#  	Created on Date  	Client  	Quantity  	Shipper  	  
Consignee  	Shipper Country  	Consignee Country

ICON 	1111111 	1-Apr-09 	E0 	7plts 	Gen 2 	Gen 3 	Gen 11 	Gen 11

CT is undefined if its MOT = “undefined”

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

CT is "delivered" if the following conditions are met:

If MOT = oceanLCL then ImportTab.ActualDeliveryDateDATEBOX is not empty
If MOT = oceanFCL then ComTable.ContainerTable.ActualDeliveryDateDATEBOX is not empty (for all containers)

CT is "archived" if the following conditions are met:

If MOT = Air then ImportTab.ActualDeliveryDateDATEBOX value is 6 month (or more) older than todays date

If MOT = oceanLCL then ImportTab.ActualDeliveryDateDATEBOX value is 6 month (or more) older than todays date
If MOT = oceanFCL then 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)

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

0000757 [Ops.CT.ListCTs] v2 :
- If containers are present in container table: display numb. of containers (example: 2 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: display 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

@@ Line 6: / Line 6: @@
 * mantis : http://mantis.jaguarfreight.com/mantis/view.php?id=756
 * old spec: http://mantis.jaguarfreight.com/svn/ct2/SS/ops/CT/list_cts/
+== Columns ==
+ Mode  	CT#  	Created on Date  	Client  	Quantity  	Shipper
+ Consignee  	Shipper Country  	Consignee Country
+ ICON 	1111111 	1-Apr-09 	E0 	7plts 	Gen 2 	Gen 3 	Gen 11 	Gen 11
 == Definition of UNDEFINED LIVE DELIVERED ARCHIVED ==