Air Detailed Manifest (M) (xls)
From UG
(Difference between revisions)
(→Output) |
(→Output) |
||
Line 30: | Line 30: | ||
=== Output === | === Output === | ||
- | * Excel spreadsheet | + | * Output is an Excel spreadsheet |
- | * | + | * There is ONLY one tab on spreadsheet |
+ | * Result shows 1 CT per section with total numbers | ||
+ | * Spreadsheet consists of Header, Body, and Footer | ||
+ | * Header | ||
+ | ** Report name | ||
+ | ** Generated for ''user's first name and last name'' of JAGUAR FRIEGHT SERVICES LIMITED by CyberTrax | ||
+ | ** Date Time Stamp | ||
+ | * Body | ||
+ | ** Section 1 | ||
+ | *** Master Shipper ref: | ||
+ | *** Master Consignee ref: | ||
+ | *** Flight Number: | ||
+ | *** Master Airway Bill: | ||
+ | *** Airline: | ||
+ | ** Section 2 | ||
+ | *** Shipper/Consignee | ||
+ | *** HAWB | ||
+ | *** CT# | ||
+ | *** PO Num | ||
+ | *** Item Code | ||
+ | *** Quantity | ||
+ | *** Pallets | ||
+ | *** Cartons (plts) | ||
+ | *** Cartons (loose) | ||
+ | *** Weight | ||
+ | *** CBM | ||
+ | * Footer | ||
+ | ** There is no footer | ||
+ | * Show output heading for each CT | ||
* Each CT result is separated by 1 row | * Each CT result is separated by 1 row | ||
Revision as of 22:40, 11 March 2010
Contents |
Mantis
Business Needs and Requirements
User would like to be able to generate a report that shows result of air detailed manifest. The result will show detail per CT with content information
Technical Specification
Summary
- This report is a spreadsheet report for Totals of Master Air. It has one panel which displays a table of contents totals that is grouped per CT.
- This report can be generated from Master AIR Totals tab
User Interface
Hard Coded Conditions
- This report is used to identify CT records in a Master
- Display result
User Defined Conditions
N/A
Steps
- Go to Master shipment
- Select Air Master
- Click "Master Air Total" Tab
- Click "Download To Spreadsheet" Button
Output
- Output is an Excel spreadsheet
- There is ONLY one tab on spreadsheet
- Result shows 1 CT per section with total numbers
- Spreadsheet consists of Header, Body, and Footer
- Header
- Report name
- Generated for user's first name and last name of JAGUAR FRIEGHT SERVICES LIMITED by CyberTrax
- Date Time Stamp
- Body
- Section 1
- Master Shipper ref:
- Master Consignee ref:
- Flight Number:
- Master Airway Bill:
- Airline:
- Section 2
- Shipper/Consignee
- HAWB
- CT#
- PO Num
- Item Code
- Quantity
- Pallets
- Cartons (plts)
- Cartons (loose)
- Weight
- CBM
- Section 1
- Footer
- There is no footer
- Show output heading for each CT
- Each CT result is separated by 1 row
Columns Definitions
Sort By Definitions
- Earlier CT# to latest CT#