List CTs

From UG

Revision as of 22:46, 8 November 2009 by Alex (Talk | contribs)

(diff) ← Older revision | Current revision (diff) | Newer revision → (diff)

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

QUANTITY column logic

{ change:

FCL
- ~~# of containers otherwise total plts or ctns. Display “3 cont” for example (no need to show types or size)~~
- display # of containers. “3 cont” for example.
- If # containers = 0 then display: # plts, # pkg/plts, # loose. Example: "10 plts, 200 pkg/plts, 6 loose"

--Alex 15:40, 21 August 2009 (UTC) }

LCL Total Weight (kg) or cbm whichever is known (CBM is default, if no cbm show kg)
Air Weight (kg) or Volume Weight (kg) if applicable
Truck Total Weight (kg)

Definition of UNDEFINED LIVE DELIVERED ARCHIVED

NOTE!!! CT can be a part of only ONE tab!

new: Actual delivery date(s) cannot be in the future. They can only be “today” or “in the past”.

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:

If MOT = Air then ImportTab.ActualDeliveryDateDATEBOX is not empty

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

If MOT = truckAir then GenTab.y.ActualDelivery: is not empty
If MOT = truckOcn then GenTab.y.ActualDelivery: is not empty
If MOT = truckDom then GenTab.y.ActualDelivery: is not empty

Archived Tab

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 {added: for ALL containers }(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

version 2.0

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

Ver 2.1

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

Ver 2.2

This version have 2 updates:

update 1: ActualDeliveryDate can be today's date or any date in the past but not in the future (this is in another mantis: 0001307 [Ops.CT.Dates] v1.1: Actual delivery date(s) cannot be in the future)

update 2: Logic related to Cont. assigned? flag added to FCL and logic re-written "per-mode"

AIR and LCL

NOTE: live/deliv/arch state depends only on the state of one field: ImpTab.ActualDeliveryDate

if (ImpTab.ActualDeliveryDate is empty)
   CT is live 
else if (number of days between today's date and ImpTab.ActualDeliveryDate is > 180)
   CT is archived
else
   CT is delivered

FCL

NOTE:

Assume that CT has N containers with Cont. assigned?=true. Then live/deliv/arch state depends on the state of N fields: CT.ContainerTable.ContainerXActualDeliveryDate
Cont. assigned? is a column in CT.ContainersTable

if (for at least one containers with Cont. assigned?=true
        CT.ContainerTable.ContainerXActualDeliveryDate is empty )
   CT is live 
else if ( for ALL containers with Cont. assigned?=true
        num. of days btw today and CT.ContainerTable.ContXActualDeliveryDate is > 180)
   CT is archived
else
   CT is delivered

Rel 2.3

Make ...

RFC

add M# column