List CTs

From UG

(Difference between revisions)
Jump to: navigation, search
(FCL)
(FCL)
Line 106: Line 106:
=== FCL ===
=== FCL ===
-
NOTE: Assume that CT has N containers. ''live/deliv/arch state'' depends on the state of N fields: CT.ContainerTable.ContainerXActualDeliveryDate
+
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 ALL containers with '''Cont. assigned?=true'''
  if (for ALL containers with '''Cont. assigned?=true'''

Revision as of 20:55, 8 October 2009

Contents

Summary

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


! See related: http://mantis.jaguarfreight.com/wiki/Ops_Misc#Delivery_Comment_Check_Box

RFC

  • add M# column
Personal tools