Delivery Trailer Report (BR)
From UG
(→CBN: Core Business Need) |
(→Core Business Need) |
||
(5 intermediate revisions not shown) | |||
Line 1: | Line 1: | ||
[[Category:BA]] | [[Category:BA]] | ||
- | == | + | == 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 | + | actual amount of space inside of a trailer. It is based upon the loaded number of pallets and how much they weigh. |
- | + | ||
</div> | </div> | ||
- | == | + | == 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) | + | b) Section Header Needed |
+ | * Delivery Trailer # | ||
- | * First | + | 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 | ||
- | + | d) One Tabs or many tabs? If more than one then what is the logic? | |
* One tab | * One tab | ||
- | + | e) Define Sort Order | |
* Sort by delivery trailer #; earliest delivery date on the top. | * Sort by delivery trailer #; earliest delivery date on the top. | ||
- | + | 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?
- Minimum: the same as Receiving Report.
- Maximum: all CT fields.
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
- It is similar in nature to Truck Detailed Manifest - See Figure 3b.