List CTs
From UG
(Difference between revisions)
(→AIR) |
(→AIR) |
||
Line 97: | Line 97: | ||
=== AIR === | === AIR === | ||
- | if (ImpTab.ActualDeliveryDate | + | if (ImpTab.ActualDeliveryDate is empty) |
CT is '''live''' | CT is '''live''' | ||
else if (number of days between today's date and ImpTab.ActualDeliveryDate is > 180) | else if (number of days between today's date and ImpTab.ActualDeliveryDate is > 180) |
Revision as of 20:09, 8 October 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
- 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#
Same Logic re-stated PER MOT
NOTE: ActualDeliveryDate can be today's date or any date in the past
AIR
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 live
! See related: http://mantis.jaguarfreight.com/wiki/Ops_Misc#Delivery_Comment_Check_Box
RFC
- add M# column