Delivery Trailer Report (BR)

From UG

(Difference between revisions)
Jump to: navigation, search
(CBN: Core Business Need)
(Core Business Need)
 
(12 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;">
''This wiki section is managed by: [[Module Owner]]''
''This wiki section is managed by: [[Module Owner]]''
-
For Elizabeth Arden to run a report to see how Jaguar Freight is utilizing the amount of space inside of a trailer based upon cubic meters.
+
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.  
</div>
</div>
-
== BR: Business Requirements and Design Ideas ==
+
== Business Requirements and Design Ideas ==
<div style="background-color:Moccasin;">
<div style="background-color:Moccasin;">
Line 31: 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 70: 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
Line 84: Line 88:
5) What is a typical use case?
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.
+
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
6) Additional info

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