Delivery Trailer Report (BR)
From UG
CBN: Core Business Need
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.
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.