Air Detailed Manifest (M) (xls)
From UG
(Difference between revisions)
(→Output) |
(→Output) |
||
Line 40: | Line 40: | ||
* Body | * Body | ||
'''Section 1''' | '''Section 1''' | ||
- | + | ** Master Shipper ref: | |
- | + | ** Master Consignee ref: | |
- | + | ** Flight Number: | |
- | + | ** Airline: | |
- | + | '''Section 2''' | |
- | + | ** Shipper/Consignee | |
- | + | ** HAWB | |
- | + | ** CT# | |
- | + | ** PO Num | |
- | ** | + | ** SKU |
- | ** | + | ** Qty |
- | ** | + | ** Ttl# plt |
- | ** | + | ** Ttl pkgs on plts |
- | ** | + | ** Loose pkgs |
- | ** | + | ** Ttl G kg |
- | + | ** CBM | |
* Footer | * Footer | ||
** There is no footer | ** There is no footer | ||
Line 62: | Line 62: | ||
==== Columns Definitions ==== | ==== Columns Definitions ==== | ||
- | + | '''Section 1''' | |
+ | * Master Shipper ref: | ||
+ | :* Mapped to Master Air field.MasterGeneral.Master Shipper ref: | ||
+ | |||
+ | * Master Consignee ref: | ||
+ | :* | ||
+ | * Flight Number: | ||
+ | * Airline: | ||
+ | '''Section 2''' | ||
+ | * Shipper/Consignee | ||
+ | * HAWB | ||
+ | * CT# | ||
+ | * PO Num | ||
+ | * SKU | ||
+ | * Qty | ||
+ | * Ttl# plt | ||
+ | * Ttl pkgs on plts | ||
+ | * Loose pkgs | ||
+ | * Ttl G kg | ||
+ | * CBM | ||
+ | |||
+ | |||
+ | CT_bo#HAWB | ||
==== Sort By Definitions ==== | ==== Sort By Definitions ==== |
Revision as of 19:20, 12 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:
- Airline:
Section 2
- Shipper/Consignee
- HAWB
- CT#
- PO Num
- SKU
- Qty
- Ttl# plt
- Ttl pkgs on plts
- Loose pkgs
- Ttl G kg
- CBM
- Footer
- There is no footer
- Show output heading for each CT
- Each CT result is separated by 1 row
Columns Definitions
Section 1
- Master Shipper ref:
- Mapped to Master Air field.MasterGeneral.Master Shipper ref:
- Master Consignee ref:
- Flight Number:
- Airline:
Section 2
- Shipper/Consignee
- HAWB
- CT#
- PO Num
- SKU
- Qty
- Ttl# plt
- Ttl pkgs on plts
- Loose pkgs
- Ttl G kg
- CBM
CT_bo#HAWB
Sort By Definitions
- Earlier CT# to latest CT#