List CTs

From UG

(Difference between revisions)

Jump to: navigation, search

Current revision as of 14:00, 27 May 2013

1 Parent Mantis
2 Summary
3 Columns
4 QUANTITY column logic
5 Definition of UNDEFINED LIVE DELIVERED ARCHIVED
6 version 2.0
7 Ver 2.1
8 Ver 2.2
- 8.1 AIR and LCL
- 8.2 FCL
9 Rel 2.3
10 Ver 2.4 Filter by Client and CT
11 Ver 2.5 Archived Tab to be updated once a day
12 Ver 3.0 major re-design
13 RFC
- 13.1 Note About Archived Status
14 SOWs
- 14.1 SOW 1 Dbl click on a CT record in any list in the CT2 (Client and Internal) system should open that record in a new browser tab
  - 14.1.1 Core Requirements
  - 14.1.2 Solution

[edit] Parent Mantis

1592

[edit] 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/

[edit] 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

[edit] 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)

[edit] Definition of UNDEFINED LIVE DELIVERED ARCHIVED

!!! This is old def, see new below in Ver 2.2 section !!!

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

[edit] Undefined Tab

CT is undefined if its MOT = “undefined”

[edit] 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

[edit] 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

[edit] 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

[edit] 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

[edit] Ver 2.1

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

[edit] 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)

[edit] AIR and LCL

if (CT.MOT is undefined)
   CT must appear on "Undef Tab"
else if (ImpTab.ActualDeliveryDate is empty)
   CT must appear on "Live Tab"
else if (number of days between today's date and CT.ImpTab.ActualDeliveryDate is > 180)
   CT must appear on "Archived Tab"
else
   CT must appear on "Delivered Tab"

[edit] FCL

Important Note1:

Definition: "CT containers" are containers that have at least some commodities defined on CT Commodity table. To compile this list - pull all unique cont#s from "Cont-r#" column in ContTab.Table A (Commodity table)
Please note that Containers Panel on CT ContTab always consists of "Master containers" (which is a superset of "CT containers")
Live/deliv/arch state depends on the state of this field: CT.ContainerTable.ContainerXActualDeliveryDate for all CT containers (but not Master containers!)

if (CT.MOT is undefined)
   CT must appear on "Undef Tab"
else if (for at least one "CT container [see Note1]"  
        CT.ContainerTable.ContainerXActualDeliveryDate is empty )
   CT must appear on "Live Tab"
else if ( for ALL "CT container [see Note1]"
        num. of days btw today and CT.ContainerTable.ContXActualDeliveryDate is > 180)
   CT must appear on "Archived Tab"
else
   CT must appear on "Delivered Tab"

[edit] Rel 2.3

Make lists on every tab appear sorted by CT#. Largest CT# at the top.

[edit] Ver 2.4 Filter by Client and CT

ss1 // 2 filters have been added that must be used independently

ss2 // Filter by client:

select one client company + click "use filter"
system must display in List CTs only shipments for this client (on correct tabs). Btw this what we see in Client App
click "Clear" and it will clear combobox
ideally show tab with at least one CT
ideally print Status line "X shipments has been found"

ss3 // Filter by CT#

enter CT# and click Use Filter
If CT# is found shouw CT on appropriate tab in table
If not found show message "Could not find CT# xxx"
RFC (leave this for future if hard to implement) Ideally we should be able to enter multiple CTs separated by space and see them on List CTs under appropriate tabs

[edit] Ver 2.5 Archived Tab to be updated once a day

To make List CTs Report run faster and simplify logic - have Archived Tab updated once in 24 hours. System will run this report on a background calculating "Archived status: Y/N" for each CT.

[edit] Ver 3.0 major re-design

List CTs is a multitab view that presents a number of reports generated by the system.

There are 4 major reports: undef, live, deliv, arch.

Trucking CTs are displayed on their own tabs.

Deleted CTs are not included on the reports.

See additional MOT specific conditions below.

See Note About Containers.

[edit] UNDEFINED

List all CTs that have MOT = undef

[edit] LIVE

[edit] Air and LCL / Client Consol

ImpTab.ActualDeliveryDate is empty

[edit] FCL

CT/Master has no containers OR
CT/Master has at least one container AND CT.ContainerTable.ContainerXActualDeliveryDate is empty for at least one container

[edit] Truck-Ocean

CT has no containers OR
CT has at least one container AND CT.ContainerTable.ContainerXActualDeliveryDate is empty for at least one container

[edit] Truck-Dom and Truck-Air

GenTab.ActualDeliveryDate is empty

[edit] DELIVERED

[edit] Air and LCL / Client Consol

ImpTab.ActualDeliveryDate is FROM 180 days in the past TO today

[edit] FCL

CT/Master has at least one container AND
CT.ContainerTable.ContainerXActualDeliveryDate is FROM 180 days in the past TO today for ~~ALL~~ AT LEAST ONE container

[edit] Truck-Ocean

CT has at least one container AND
CT.ContainerTable.ContainerXActualDeliveryDate is FROM 180 days in the past TO today for ~~ALL~~ AT LEAST ONE container

[edit] Truck-Dom and Truck-Air

GenTab.ActualDeliveryDate is FROM 180 days in the past TO today

[edit] ARCHIVED

[edit] Air and LCL / Client Consol

ImpTab.ActualDeliveryDate is over 180 days in the past

[edit] FCL

CT.ContainerTable.ContainerXActualDeliveryDate for ALL containers in CT/Master is over 180 days in the past

[edit] Truck-Ocean

CT.ContainerTable.ContainerXActualDeliveryDate for ALL containers in CT is over 180 days in the past

[edit] Truck-Dom and Truck-Air

GenTab.ActualDeliveryDate is over 180 days in the past

[edit] Note about valid Actual Delivery Date range

Validation in the system is preventing users from entering Actual Delivery Date that is in the future. That is why date range from tomorrow to any other day in the future is not considered in the logic above.

[edit] Note About Containers

"CT/Master" means that if CT has no master system should apply logic to just containers attached to CT. And if CT has a Master then system should consider all CTs in the Master.
also see http://mantis.jaguarfreight.com/wiki/Containers_and_Contents_Component#FCL_.2F_LCL_vs_Ocean-Truck

[edit] RFC

add M# column

[edit] Note About Archived Status

I suggest having ArcStatus for every CT in the system. Once CT is defined as Archived (CT satisfied Arc Tab conditions) ArcStatus would be set to true . Then system would not have to analyze that growing segment of shipments at the moment of generating List CT's Live/Delivered reports or InTransit report or any other report that would like to utilize that flag.

Advantage: List CTs and other reports would load faster.

[edit] SOWs

[edit] SOW 1 Dbl click on a CT record in any list in the CT2 (Client and Internal) system should open that record in a new browser tab

mantis: 4184 (phase: BA, status: started)

[edit] Core Requirements

Please focus only on CT LIST (CT2 Internal), Shipment list (CT2 Client) and Watch List (CT2 Client).
However, any/all future lists should be designed accordingly when created

[edit] Solution

Implement opening CT in new browser tab after double clicking in the following places:

CT LIST (CT2 Internal) - covered by this article.
Shipment list (CT2 Client) - Client Shipment List.
Watch List (CT2 Client) - Client Watch List.

@@ Line 1: / Line 1: @@
+[[Category:OpsReps]]
+== Parent Mantis ==
+[http://mantis.jaguarfreight.com/mantis/view.php?id=1592 1592]
 == Summary ==
 [[File:Internal.ListCTs.JPG|thumb|500px]]
@@ Line 174: / Line 179: @@
 See Note About Containers.
-=== Undefined Tab MOT specific conditions ===
+=== UNDEFINED ===
 List all CTs that have MOT = undef
-=== Live Tab MOT specific conditions ===
+=== LIVE ===
-MOT = Air  ;  MOT = LCL / Client Consol
+==== Air  and  LCL / Client Consol ====
 * ImpTab.ActualDeliveryDate is empty
-''' MOT = FCL ''' and ''' MOT = Truck-Ocean '''
+==== FCL ====
+* ''CT/Master has no containers OR''
+* ''CT/Master has at least one container AND'' CT.ContainerTable.ContainerXActualDeliveryDate is empty for at least one container
+==== Truck-Ocean ====
 * ''CT has no containers OR''
@@ Line 191: / Line 201: @@
-''' MOT = Truck-Dom ''' and ''' MOT = Truck-Air '''
+====  Truck-Dom   and    Truck-Air ====
 * GenTab.ActualDeliveryDate is empty
-=== Deliv Tab MOT specific conditions ===
+=== DELIVERED ===
-''' MOT = Air ''' and ''' MOT = LCL / Client Consol '''
+====   Air  and LCL / Client Consol ====
 * ImpTab.ActualDeliveryDate is FROM 180 days in the past TO today
+==== FCL ====
-''' MOT = FCL ''' and ''' MOT = Truck-Ocean '''
+* ''CT/Master has at least one container AND''
+* CT.ContainerTable.ContainerXActualDeliveryDate is FROM 180 days in the past TO today for <strike>ALL</strike> AT LEAST ONE container
-* ''CT has at least one container AND'' CT.ContainerTable.ContainerXActualDeliveryDate is FROM 180 days in the past TO today (for ALL containers)
+====   Truck-Ocean ====
+* ''CT has at least one container AND''
+* CT.ContainerTable.ContainerXActualDeliveryDate is FROM 180 days in the past TO today for <strike>ALL</strike> AT LEAST ONE container
-''' MOT = Truck-Dom ''' and ''' MOT = Truck-Air '''
+==== Truck-Dom and Truck-Air ====
 * GenTab.ActualDeliveryDate is FROM 180 days in the past TO today
-===  Arc Tab MOT specific conditions ===
+===  ARCHIVED ===
-''' MOT = Air ''' and ''' MOT = LCL / Client Consol '''
+==== Air and  LCL / Client Consol ====
 * ImpTab.ActualDeliveryDate is over 180 days in the past
+==== FCL ====
-''' MOT = FCL ''' and ''' MOT = Truck-Ocean '''
+* CT.ContainerTable.ContainerXActualDeliveryDate for ALL containers in CT/Master is over 180 days in the past
-* CT.ContainerTable.ContainerXActualDeliveryDate for ALL containers is over 180 days in the past
+==== Truck-Ocean ====
+* CT.ContainerTable.ContainerXActualDeliveryDate for ALL containers in CT is over 180 days in the past
-''' MOT = Truck-Dom ''' and ''' MOT = Truck-Air '''
+==== Truck-Dom and  Truck-Air ====
 * GenTab.ActualDeliveryDate is over 180 days in the past
@@ Line 232: / Line 248: @@
 === Note About Containers ===
-* If CT is a part of a Master then Container Table is common for Master and every CTs in this Master (it is shared). So in the logic above system should look at all containers in Master, not just containers that have commodity assignments from given CT.
+* "CT/Master" means that if CT has no master system should apply logic to just containers attached to CT. And if CT has a Master then system should consider all CTs in the Master.
+* also see http://mantis.jaguarfreight.com/wiki/Containers_and_Contents_Component#FCL_.2F_LCL_vs_Ocean-Truck
-* To calculate this report we no longer look at what is happening with commodities / assignments of particular commodities to containers:
-** commodities from what CTs assigned to what containers
-** if containers have no assigned commodities
-** if CTs have unassigned commodities
-** if master have "empty" containers or unassigned commodities
-** etc
 == RFC ==
@@ Line 251: / Line 261: @@
+== SOWs ==
-[[Category:OpsReps]]
+=== SOW 1 Dbl click on a CT record in any list in the CT2 (Client and Internal) system should open that record in a new browser tab ===
+<hr>
+'''mantis''': [http://mantis.jaguarfreight.com/mantis/view.php?id=4184 '''4184'''] (''phase:'' BA, ''status:'' started)
+==== Core Requirements ====
+* Please focus only on CT LIST (CT2 Internal), Shipment list (CT2 Client) and Watch List (CT2 Client).
+* However, any/all future lists should be designed accordingly when created
+==== Solution ====
+*Implement opening CT in new browser tab after double clicking in the following places:
+:* CT LIST (CT2 Internal) - covered by this article.
+:* Shipment list (CT2 Client) - [http://wiki.jaguarfreight.com/wiki/Client_Shipment_List Client Shipment List].
+:* Watch List (CT2 Client) - [http://wiki.jaguarfreight.com/wiki/Client_Watch_List Client Watch List].
+<hr>
+[[Category:OpsRepsCore]]

List CTs

From UG

Current revision as of 14:00, 27 May 2013

Contents

[edit] Parent Mantis

[edit] Summary

[edit] Columns

[edit] QUANTITY column logic

[edit] Definition of UNDEFINED LIVE DELIVERED ARCHIVED

[edit] Undefined Tab

[edit] Live Tab

[edit] Delivered Tab

[edit] Archived Tab

[edit] version 2.0

[edit] Ver 2.1

[edit] Ver 2.2

[edit] AIR and LCL

[edit] FCL

[edit] Rel 2.3

[edit] Ver 2.4 Filter by Client and CT

[edit] Ver 2.5 Archived Tab to be updated once a day

[edit] Ver 3.0 major re-design

[edit] UNDEFINED

[edit] LIVE

[edit] Air and LCL / Client Consol

[edit] FCL

[edit] Truck-Ocean

[edit] Truck-Dom and Truck-Air

[edit] DELIVERED

[edit] Air and LCL / Client Consol

[edit] FCL

[edit] Truck-Ocean

[edit] Truck-Dom and Truck-Air

[edit] ARCHIVED

[edit] Air and LCL / Client Consol

[edit] FCL

[edit] Truck-Ocean

[edit] Truck-Dom and Truck-Air

[edit] Note about valid Actual Delivery Date range

[edit] Note About Containers

[edit] RFC

[edit] Note About Archived Status

[edit] SOWs

[edit] SOW 1 Dbl click on a CT record in any list in the CT2 (Client and Internal) system should open that record in a new browser tab

[edit] Core Requirements

[edit] Solution

Views

Personal tools

Navigation

Toolbox

Search