Delivery Trailer Report (BR)

From UG

(Difference between revisions)
Jump to: navigation, search
(CBN: Core Business Need)
(Core Business Need)
 
(5 intermediate revisions not shown)
Line 1: Line 1:
[[Category:BA]]
[[Category:BA]]
-
== CBN: Core Business Need ==
+
== Core Business Need ==
<div style="background-color:DarkSalmon;">
<div style="background-color:DarkSalmon;">
Line 7: Line 7:
This report is for Elizabeth Arden's use.  It is to measure how well JFS is utilizing the  
This report is for Elizabeth Arden's use.  It is to measure how well JFS is utilizing the  
-
actual amount of space inside of a trailer, based upon the loaded number of shipments and how much  
+
actual amount of space inside of a trailer.  It is based upon the loaded number of pallets and how much they weigh.  
-
space they take up.  
+
</div>
</div>
-
== BR: Business Requirements and Design Ideas ==
+
== Business Requirements and Design Ideas ==
<div style="background-color:Moccasin;">
<div style="background-color:Moccasin;">
Line 33: Line 32:
a) Types of output (xls, html, pdf, etc)
a) Types of output (xls, html, pdf, etc)
-
b) Columns(BR)
+
b) Section Header Needed
 +
* Delivery Trailer #
-
* First 2 columns always show Delivery Trailer#XXXX and CT#YYYY.
+
c) Columns(BR)
 +
 
 +
* First column always show CT#YYYY.
* Other columns not selected by default. See below list.
* Other columns not selected by default. See below list.
Line 72: Line 74:
  Trucker Name Delivery Trucker
  Trucker Name Delivery Trucker
-
c) One Tabs or many tabs? If more than one then what is the logic?
+
d) One Tabs or many tabs? If more than one then what is the logic?
* One tab
* One tab
-
d) Define Sort Order  
+
e) Define Sort Order  
* Sort by delivery trailer #; earliest delivery date on the top.
* Sort by delivery trailer #; earliest delivery date on the top.
-
e) Schedule only? Generate only? Or both?
+
f) Schedule only? Generate only? Or both?
* Need both
* Need both

Current revision as of 13:34, 16 June 2010


[edit] Core Business Need

This wiki section is managed by: Module Owner

This report is for Elizabeth Arden's use. It is to measure how well JFS is utilizing the actual amount of space inside of a trailer. It is based upon the loaded number of pallets and how much they weigh.

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

  • Delivery Trailer #

c) Columns(BR)

  • First column always show 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

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

  • One tab

e) Define Sort Order

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

f) Schedule only? Generate only? Or both?

  • Need both

5) What is a typical use case?

a) Report will be run once a week on Monday's. Select MOT=Truck-Dom, Client=EA, for the Actual Deliveries from Monday to Friday for the previous weeks shipments.

b) Report will be run on the first day of every new month. Select MOT=Truck-Dom, Client=EA, for the Actual Deliveries for the entire previous months shipments.

6) Additional info

Personal tools