Air Detailed Manifest (M) (xls)

From UG

(Difference between revisions)
Jump to: navigation, search
(Output)
(Output)
Line 40: Line 40:
* Body
* Body
'''Section 1'''
'''Section 1'''
-
*** Master Shipper ref:
+
** Master Shipper ref:
-
*** Master Consignee ref:
+
** Master Consignee ref:
-
*** Flight Number:
+
** Flight Number:
-
*** Airline:
+
** Airline:
-
** Section 2
+
'''Section 2'''
-
*** Shipper/Consignee
+
** Shipper/Consignee
-
*** HAWB
+
** HAWB
-
*** CT#
+
** CT#
-
*** PO Num
+
** PO Num
-
*** Item Code
+
** SKU
-
*** Quantity
+
** Qty
-
*** Pallets
+
** Ttl# plt
-
*** Cartons (plts)
+
** Ttl pkgs on plts
-
*** Cartons (loose)
+
** Loose pkgs
-
*** Weight
+
** Ttl G kg
-
*** CBM
+
** CBM
* Footer
* Footer
** There is no footer
** There is no footer
Line 62: Line 62:
==== Columns Definitions ====
==== Columns Definitions ====
-
CT_bo#HAWB
+
'''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

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

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