List CTs

(Difference between revisions)

Revision as of 14:18, 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/

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 53: / Line 53: @@
 * 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 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: dispay pallet count
+** 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"