Delivery Trailer Report

From UG

(Difference between revisions)
Jump to: navigation, search
(→Columns (SA))
(→Detailed Design)
Line 102: Line 102:
== Detailed Design ==
== Detailed Design ==
<div style="background-color:DarkSeaGreen;" >
<div style="background-color:DarkSeaGreen;" >
-
 
-
''This wiki section is managed by: [[Systems Analyst]]''
 
-
 
-
 
-
 
-
=== MOT (SA) ===
 
-
For Truck-domestic only.
 
-
 
-
=== Hard coded conditions (SA) ===
 
-
 
-
=== Filters (SA) ===
 
-
 
-
The same as in [[Trucking Optimization Report]].
 
-
 
-
=== Output (SA)===
 
-
 
-
==== Types of output (SA) ====
 
-
 
-
Spreadsheet only.
 
-
 
-
==== Columns (SA) ====
 
-
 
-
1) Fields to include - see below
 
-
 
-
2) Order on xls (left to right) as below
 
-
 
-
3) First 2 columns always show Delivery Trailer#XXXX and CT#YYYY.
 
-
 
-
4) Other columns not selected by default. See below list
 
-
 
-
* [[CT#CT_Num]]
 
-
** use [[Reports_Output#CT_Num_without_hyperlink]]
 
-
* [[CT#Created On]]
 
-
* [[CT#Cargo available]]
 
-
* [[CT#Actual Pick Up Date]]
 
-
* [[CT#Actual Delivery Date]]
 
-
* [[CT#Cargo_due]]
 
-
 
-
* [[Address#Company]] related to [[Ct#Shipper]]
 
-
 
-
* [[Address#Company]] related to [[CT#Pick Up]]
 
-
* [[Address#Phone]] related to [[CT#Pick Up]]
 
-
* [[Address#City]] related to [[CT#Pick Up]]
 
-
* [[Address#State]] related to [[CT#Pick Up]]
 
-
* [[Address#Zip]] related to [[CT#Pick Up]]
 
-
 
-
*  [[Commodity#PO]] related to [[CT#CT Num]]
 
-
*  [[Commodity#SKU]] related to [[CT#CT Num]]
 
-
*  [[Commodity#Qty]] related to [[CT#CT Num]]
 
-
*  [[Commodity#Plts]] related to [[CT#CT Num]]
 
-
*  [[Commodity#Loose Pkgs]] related to [[CT#CT Num]]
 
-
*  [[Commodity#Gross_Lb]] related to [[CT#CT Num]]
 
-
 
-
* [[Address#Company]] related to [[Ct#Consignee]]
 
-
 
-
* [[Address#Company]] related to [[CT#Delivery To]]
 
-
* [[Address#Phone]] related to [[CT#Delivery To]]
 
-
* [[Address#City]] related to [[CT#Delivery To]]
 
-
* [[Address#State]] related to [[CT#Delivery To]]
 
-
* [[Address#Zip]] related to [[CT#Delivery To]]
 
-
 
-
* [[CT#Pick Up Trucker]]
 
-
* [[CT#Delivery Trucker]]
 
-
 
-
3) Use [[Reports_Output#LIPCO_one_line]] - Short term (Long term - option to choose to display [[Reports_Output#LIPCO_multi_line]] or [[Reports_Output#LIPCO_one_line]])
 
-
 
-
4) Label for each field - see below:
 
-
 
-
 
-
 
-
<pre>
 
-
 
-
CT#
 
-
 
-
Created On
 
-
Cargo available
 
-
Actual Pick Up Date
 
-
Actual Delivery Date
 
-
Cargo Due
 
-
 
-
Shipper
 
-
 
-
Pick Up Company
 
-
Pick Up Phone
 
-
Pick Up City
 
-
Pick Up State
 
-
Pick Up Zip
 
-
 
-
PO
 
-
SKU
 
-
Qty
 
-
Plts 
 
-
Loose Pkgs 
 
-
Gross Lb
 
-
CBM 
 
-
 
-
Consignee
 
-
 
-
Deliver To Company (! changed)
 
-
Delivery Phone
 
-
Delivery City
 
-
Delivery State
 
-
Delivery Zip
 
-
 
-
Pick Up Trucker
 
-
Delivery Trucker
 
-
 
-
</pre>
 
-
 
-
<!-- Use [[Standard Short Label]] -->
 
-
 
-
==== Tabs ====
 
-
 
-
One tab
 
-
 
-
====  Sort Order (SA) ====
 
-
 
-
Sort by [[CT#Actual Delivery Date]]; earliest on the top.
 
-
 
-
===  Schedule vs Generate (SA) ===
 
-
Need both.
 
</div>
</div>

Revision as of 16:05, 2 June 2010


Contents

General Info

CBN: Core Business Need

This wiki section is managed by: Module Owner

Core business need is for Elizabeth Arden to keep report on Jaguar Freight's trucking optimization


BR: Business Requirements and Design Ideas

This wiki section is managed by: Business Analyst

Summary (BR)

MOT (BR)

For Truck-Domestic only.

Filters (BR)

Minimum: the same as Receiving Report.

Maximum: all CT fields.

Output (BR)

Types of output (BR)

Spreadsheet only.

Columns(BR) 

* First 2 columns always show Delivery Trailer#XXXX and CT#YYYY.
* Other columns not selected by default. See below list.

 CT#	(text, not hyperlink)
 date created	
 date available	
 pick up date	
 delivery date
 Cargo Due
 --------------
 Shipper (Shipper company name)	
 -------------- (Pick up location information)
 Pick up location company	
 Tel #	
 City	
 State	
 ZIP	
 ------------ 
 PO #	
 SKU/Item
 Quantity	
 Plts	
 Lose Ctns	
 Gross Wt (LB) with LB Label
 CBM
 ------------
 Consignee (Consignee company name)	
 ------------ (delivery location information)
 Delivery to location company name	
 City	
 State	
 ZIP	
 Telephone #	
 ------------ Trucker info 
 Trucker Name Pick Up Trucker
 Trucker Name Delivery Trucker

Tabs

One tab

Sort Order (BR)

Sort by delivery trailer #; earliest delivery date on the top.

Schedule vs Generate (BR)

Need both.

Related Workflow (BR)

Unknown.

Detailed Design

History

m2092

BA 2092

SA 2092

Retrieved from "https://wiki.jaguarfreight.com/Delivery_Trailer_Report"
Personal tools