List CTs

From UG

Revision as of 14:22, 21 August 2009 (edit) Alex (Talk | contribs) ← Older edit		Revision as of 14:33, 21 August 2009 (edit) (undo) Alex (Talk | contribs) (→Columns) Newer edit →
Line 14:		Line 14:
	ICON 1111111 1-Apr-09 E0 7plts Gen 2 Gen 3 Gen 11 Gen 11		ICON 1111111 1-Apr-09 E0 7plts Gen 2 Gen 3 Gen 11 Gen 11
		+	== QUANTITY column logic ==
		+
		+	* FCL    # of containers otherwise total plts or ctns
		+	** Display “3 cont” for example (no need to show types or size)
		+	* 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 ==		== Definition of UNDEFINED LIVE DELIVERED ARCHIVED ==

---

Revision as of 14:33, 21 August 2009

Contents 1 Summary 2 Columns 3 QUANTITY column logic 4 Definition of UNDEFINED LIVE DELIVERED ARCHIVED 4.1 Undefined Tab 4.2 Live Tab 4.3 Delivered Tab 4.4 Archived Tab 5 version 2.0 6 ver 2.1 7 RFC

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

• FCL # of containers otherwise total plts or ctns
  • Display “3 cont” for example (no need to show types or size)
• 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

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 ComTable.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(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#

RFC

• add M# column