Delivery Trailer Report (BR)

From UG

(Difference between revisions)
Jump to: navigation, search
(Created page with 'Category:BA')
Line 1: Line 1:
[[Category:BA]]
[[Category:BA]]
 +
 +
== CBN: Core Business Need ==
 +
<div style="background-color:DarkSalmon;">
 +
 +
''This wiki section is managed by: [[Module Owner]]''
 +
 +
Core business need is for Elizabeth Arden to keep report on Jaguar Freight's trucking optimization
 +
 +
 +
 +
</div>
 +
 +
== BR: Business Requirements and Design Ideas ==
 +
<div style="background-color:Moccasin;">
 +
 +
''This wiki section is managed by: [[Business Analyst]]''
 +
 +
1) What MOT should be supported?
 +
 +
* For Truck-Domestic only.
 +
 +
2) What are Hard coded conditions?
 +
 +
3) What Filters are required?
 +
 +
* Minimum: the same as [[Receiving Report]].
 +
* Maximum: all CT fields.
 +
 +
4) Output Requirements
 +
* Spreadsheet only.
 +
 +
a) Types of output (xls, html, pdf, etc)
 +
 +
b) 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
 +
 +
c) One Tabs or many tabs? If more than one then what is the logic?
 +
 +
* One tab
 +
 +
d) Define Sort Order
 +
 +
* Sort by delivery trailer #; earliest delivery date on the top.
 +
 +
e) Schedule only? Generate only? Or both?
 +
 +
* Need both
 +
 +
5) What is a typical use case?
 +
 +
Report will be run once a week. Select MOT=Truck-Dom, Client=EA, Actual Delivery from Monday to Friday current week.
 +
 +
6) Additional info
 +
 +
* It is similar in nature to [[Truck Detailed Manifest]] - See Figure 3b.
 +
 +
</div>

Revision as of 18:50, 4 June 2010


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

1) What MOT should be supported?

  • For Truck-Domestic only.

2) What are Hard coded conditions?

3) What Filters are required?

4) Output Requirements

  • Spreadsheet only.

a) Types of output (xls, html, pdf, etc)

b) 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

c) One Tabs or many tabs? If more than one then what is the logic?

  • One tab

d) Define Sort Order

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

e) Schedule only? Generate only? Or both?

  • Need both

5) What is a typical use case?

Report will be run once a week. Select MOT=Truck-Dom, Client=EA, Actual Delivery from Monday to Friday current week.

6) Additional info

Retrieved from "https://wiki.jaguarfreight.com/Delivery_Trailer_Report_(BR)"
Personal tools