List CTs

From UG

Revision as of 17:56, 23 June 2009 by Alex (Talk | contribs)

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

Jump to: navigation, search

List CTs

Summary

This is a very frequently used report
It lists all shipments in the system grouped by undefined / live / delivered / archived
Path: CT Home, Main Toolbar > List CTs
see example here: TBD
mantis id = 756
mantis link: TBD

Definition of LIVE DELIVERED ARCHIVED shipments

1) MOT = “undefined”

live - never
delivered - never
archived - never

2) CT is "live" if the following conditions are met:

MOT = air: ImportTab.ActualDeliveryDateDATEBOX is empty

MOT = oceanLCL: ImportTab.ActualDeliveryDateDATEBOX is empty 
MOT = oceanFCL: ComTable.ContainerTable.ActualDeliveryDateDATEBOX is empty (for at least one container)

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

3) CT is "delivered" if the following conditions are met:

- MOT = air: ImportTab.ActualDeliveryDateDATEBOX is not empty

- MOT = oceanLCL: ImportTab.ActualDeliveryDateDATEBOX is not empty
- MOT = oceanFCL: ComTable.ContainerTable.ActualDeliveryDateDATEBOX is not empty (for all containers)

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

4) CT is "archived" if the following conditions are met:

MOT = air: ImportTab.ActualDeliveryDateDATEBOX value is 6 month (or more) older than todays date

MOT = oceanLCL: ImportTab.ActualDeliveryDateDATEBOX value is 6 month (or more) older than todays date MOT = oceanFCL: 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)

MOT = truckAir: GenTab.y.ActualDelivery: value is 6 month (or more) older than todays date MOT = truckOcn: GenTab.y.ActualDelivery: value is 6 month (or more) older than todays date MOT = truckDom: GenTab.y.ActualDelivery: value is 6 month (or more) older than todays date

version 2 new features and changes

0000757 [Ops.CT.ListCTs] v2 :

- If containers are present in container table: display 1 cont. or 10 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.