Air Detailed Manifest (M) (xls)

From UG

(Difference between revisions)
Jump to: navigation, search
(Output)
(Output)
Line 30: Line 30:
=== Output ===
=== Output ===
-
* Excel spreadsheet
+
* Output is an Excel spreadsheet
-
* Output heading for each CT
+
* 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

1583

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
  • 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#

Special Cases

Figures

Figure 1. Download To Spreadsheet button

File:AirDetailedManifest.JPG

Figure 2. Spreadsheet result view

History

RFC

History

Implement this new feature

Personal tools