Delivery Trailer Report (BR)

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, based upon the loaded number of shipments and how much space they take up.

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

• 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

• a summary of the average weight per shipment

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.