Delivery Trailer Report (BR)

From UG

(Difference between revisions)
Jump to: navigation, search
(→CBN: Core Business Need)
(→Core Business Need)
 
(7 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]]''
-
 
-
This report is for Elizabeth Arden's use.  It is to see how JFS maximizes or utilizes the amount of space inside of a trailer load based upon the total number of cubic meters for all of the shipments.
 
-
 
-
For Elizabeth Arden to run weekly and/or monthly reports for delivering trailer loads, that
 
-
JFS arranges, to see how JFS maximizes or utilizes the amout of space inside of a trailer.
 
-
 
-
There are certin criteria to determine this.
 
-
 
-
the amount of space inside of a trailer based upon cubic meters.
 
-
 
-
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.
 
-
 
-
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.
 
-
 
-
For Elizabeth Arden to run weekly and/or monthly reports on delivering trailer
 
-
loads arranged by JFS.
 
-
 
-
This report is for Elizabeth Arden's use.  It is to measure how JFS is utilizing the
 
-
amount of space inside of a delivery trailer based upon the total cubic meters for all
 
-
of the shipments inside. 
 
-
 
-
 
 
-
 
-
amount of cubic meters of the shipments loaded inside that trailer.
 
-
 
-
maximizes
 
-
 
-
total cubic meters of shipments against the total cubic meters of the trailer.
 
-
 
-
amount of space inside of a trailer load based upon the total number of cubic meters for
 
-
all of the shipments.
 
-
 
-
 
-
 
-
 
-
 
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 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 are taking up.
+
-
 
+
-
total amount of space that all of the shipments inside are taking 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 73: 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 #
 +
 
 +
c) Columns(BR)
-
* First 2 columns always show Delivery Trailer#XXXX and CT#YYYY.
+
* 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 112: 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

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