Delivery Trailer Report (BR)
From UG
(Difference between revisions)
(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?
- 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.