List CTs
From UG
(Difference between revisions)
(Created page with '== Summary == * This is a very frequently used report * It lists all shipments in the system grouped by undefined / live / delivered / archived * see example here: TBD * mantis …') |
|||
Line 10: | Line 10: | ||
* 1) MOT = “undefined” | * 1) MOT = “undefined” | ||
- | live - never | + | live - never |
- | delivered - never | + | delivered - never |
- | archived - never | + | archived - never |
* 2) CT is "live" if the following conditions are met: | * 2) CT is "live" if the following conditions are met: | ||
- | |||
- | MOT = | + | MOT = air: ImportTab.ActualDeliveryDateDATEBOX is empty |
- | + | ||
- | MOT = truckAir: GenTab.y.ActualDelivery: is empty | + | MOT = oceanLCL: ImportTab.ActualDeliveryDateDATEBOX is empty |
- | MOT = truckOcn: GenTab.y.ActualDelivery: is empty | + | MOT = oceanFCL: ComTable.ContainerTable.ActualDeliveryDateDATEBOX is empty (for at least one container) |
- | MOT = truckDom: GenTab.y.ActualDelivery: is empty | + | |
+ | 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: | * 3) CT is "delivered" if the following conditions are met: | ||
- | |||
- | MOT = oceanLCL: ImportTab.ActualDeliveryDateDATEBOX is not empty | + | ** MOT = air: ImportTab.ActualDeliveryDateDATEBOX is not empty |
- | MOT = oceanFCL: ComTable.ContainerTable.ActualDeliveryDateDATEBOX is not empty (for all containers) | + | |
+ | ** 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 = truckAir: GenTab.y.ActualDelivery: is not empty |
- | MOT = truckOcn: GenTab.y.ActualDelivery: is not empty | + | ** MOT = truckOcn: GenTab.y.ActualDelivery: is not empty |
- | MOT = truckDom: GenTab.y.ActualDelivery: is not empty | + | ** MOT = truckDom: GenTab.y.ActualDelivery: is not empty |
* 4) CT is "archived" if the following conditions are met: | * 4) CT is "archived" if the following conditions are met: | ||
Line 51: | Line 53: | ||
* 0000757 [Ops.CT.ListCTs] v2 : | * 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 containers are present in container table: display 1 cont. or 10 cont. | + | ** (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. |
- | (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: dispay pallet count | + | ** If no containers entered in the container table: dispay pallet count |
- | If no pallets entered in contents table: Display carton count | + | ** If no pallets entered in contents table: Display carton count |
- | If no containers, no pallets, no cartons, do not display any "quantity" | + | ** If no containers, no pallets, no cartons, do not display any "quantity" |
- | |||
* "Volume Weight (kg)" = Chargeable Weight | * "Volume Weight (kg)" = Chargeable Weight |
Revision as of 17:54, 23 June 2009
Summary
- This is a very frequently used report
- It lists all shipments in the system grouped by undefined / live / delivered / archived
- see example here: TBD
- mantis id = 756
- mantis link:
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.
- If no containers entered in the container table: dispay 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
- 0000910 [Ops.CT.ListCTs] add unit type, etc
- add tooltip for cont#