Air Detailed Manifest (M) (xls)

From UG

(Difference between revisions)
Jump to: navigation, search
(Output)
(Output)
 
(17 intermediate revisions not shown)
Line 2: Line 2:
== Mantis ==
== Mantis ==
-
[http://mantis.jaguarfreight.com/mantis/view.php?id=1583 1583]
+
Parent: [http://mantis.jaguarfreight.com/mantis/view.php?id=1583 1583]
 +
 
 +
Task: [http://mantis.jaguarfreight.com/mantis/view.php?id=1531 1531]
== Business Needs and Requirements ==
== Business Needs and Requirements ==
Line 17: Line 19:
=== Hard Coded Conditions ===   
=== Hard Coded Conditions ===   
-
* This report is used to identify CT records in a Master
+
* This report is used to identify ALL CT records in a Master
-
* Display result
+
* Display result
-
   
+
 
=== User Defined Conditions ===
=== User Defined Conditions ===
-
N/A
+
* User can define the result whether showing type/unit of Ttl pkgs on plts and loose pkgs
 +
* Default value is "No" which is not showing types of Ttl pgks on plts and loose pkgs.
 +
** For example: Ttl pkgs on plts is ''10'' versus ''10 cartons''.
=== Steps ===
=== Steps ===
Line 27: Line 31:
* Select Air Master
* Select Air Master
* Click "Master Air Total" Tab
* Click "Master Air Total" Tab
 +
* Select option to display Pkg(s) Type(s) radio button -> ''optional''
* Click "Download To Spreadsheet" Button
* Click "Download To Spreadsheet" Button
Line 32: Line 37:
* Output is an Excel spreadsheet
* Output is an Excel spreadsheet
* There is ONLY one tab on spreadsheet
* There is ONLY one tab on spreadsheet
-
* Result shows 1 CT per section with total numbers
+
* Result shows 1 CT per section with total numbers for each column
* Spreadsheet consists of Header, Body, and Footer
* Spreadsheet consists of Header, Body, and Footer
* Header
* Header
Line 40: Line 45:
* 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
-
** SKU
+
* SKU
-
** Qty
+
* Qty
-
** Ttl# plt  
+
* Ttl# plt  
-
** Ttl pkgs on plts
+
* Ttl pkgs on plts
-
** Loose pkgs
+
* Type (Optional)
-
** Ttl G kg
+
* Loose pkgs
-
** CBM
+
* Type (Optional)
 +
* Ttl G kg
 +
* CBM
* Footer
* Footer
** There is no footer
** There is no footer
Line 67: Line 74:
* Master Consignee ref:
* Master Consignee ref:
-
:*
+
:* Mapped to Master Air field.MasterGeneral.Master Consignee ref:
 +
 
* Flight Number:
* Flight Number:
 +
:* Mapped to Master Details.Flight One #:
 +
* Airline:
* Airline:
 +
:* Mapped to Master Details.Airline:
 +
'''Section 2'''
'''Section 2'''
* Shipper/Consignee
* Shipper/Consignee
 +
:* Mapped to [[Ct#Shipper]]
 +
:* Mapped to [[Ct#Consignee]]
 +
* HAWB
* HAWB
 +
:* Mapped to [[Ct#HAWB]]
 +
* CT#
* CT#
 +
:* Mapped to [[Ct#CT Num]]
 +
* PO Num
* PO Num
 +
:* Mapped to ContTab.TableA.P.O.
 +
* SKU
* SKU
 +
:* Mapped to ContTab.TableA.SKU
 +
* Qty
* Qty
 +
:* Mapped to ContTab.TableA.Qty
 +
* Ttl# plt  
* Ttl# plt  
 +
:* Mapped to ContTab.TableA.Ttl # of plt
 +
* Ttl pkgs on plts
* Ttl pkgs on plts
 +
:* Mapped to ContTab.TableA.Ttl pkgs on plts
 +
:* Mapped to ContTab.TableA.Ttl pkgs on plts >Type
 +
:** This is an '''Option''' for user to select on the template in order to show the unit of total packages on plts.
 +
* Loose pkgs
* Loose pkgs
-
* Ttl G kg
+
:* Mapped to ContTab.TableA.Loose pkgs
-
* CBM
+
:* Mapped to ContTab.TableA.Loose pkgs >Type
 +
:** This is an '''Option''' for user to select on the template in order to show the unit of Loose pkgs.
 +
* Ttl G kg
 +
:* Mapped to ContTab.TableA.Ttl G kg
-
CT_bo#HAWB
+
* CBM
 +
:* Mapped to ContTab.TableB.Total (in cbm)
==== Sort By Definitions ====
==== Sort By Definitions ====
Line 95: Line 130:
=== Figure 2. Spreadsheet result view ===
=== Figure 2. Spreadsheet result view ===
 +
 +
[[File:AirDetailedManifestSpreadsheet.JPG]]
== History ==
== History ==
== RFC ==
== RFC ==
 +
* This report may be moved to Misc tab, still need an approval, since this report has no template. Right now just leave on Master Air Total
== History ==
== History ==

Current revision as of 18:47, 15 March 2010


Contents

[edit] Mantis

Parent: 1583

Task: 1531

[edit] 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

[edit] Technical Specification

[edit] 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

[edit] User Interface

[edit] Hard Coded Conditions

  • This report is used to identify ALL CT records in a Master
  • Display result

[edit] User Defined Conditions

  • User can define the result whether showing type/unit of Ttl pkgs on plts and loose pkgs
  • Default value is "No" which is not showing types of Ttl pgks on plts and loose pkgs.
    • For example: Ttl pkgs on plts is 10 versus 10 cartons.

[edit] Steps

  • Go to Master shipment
  • Select Air Master
  • Click "Master Air Total" Tab
  • Select option to display Pkg(s) Type(s) radio button -> optional
  • Click "Download To Spreadsheet" Button

[edit] Output

  • Output is an Excel spreadsheet
  • There is ONLY one tab on spreadsheet
  • Result shows 1 CT per section with total numbers for each column
  • 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
  • Type (Optional)
  • Loose pkgs
  • Type (Optional)
  • Ttl G kg
  • CBM
  • Footer
    • There is no footer
  • Show output heading for each CT
  • Each CT result is separated by 1 row

[edit] Columns Definitions

Section 1

  • Master Shipper ref:
  • Mapped to Master Air field.MasterGeneral.Master Shipper ref:
  • Master Consignee ref:
  • Mapped to Master Air field.MasterGeneral.Master Consignee ref:
  • Flight Number:
  • Mapped to Master Details.Flight One #:
  • Airline:
  • Mapped to Master Details.Airline:

Section 2

  • Shipper/Consignee
  • HAWB
  • CT#
  • PO Num
  • Mapped to ContTab.TableA.P.O.
  • SKU
  • Mapped to ContTab.TableA.SKU
  • Qty
  • Mapped to ContTab.TableA.Qty
  • Ttl# plt
  • Mapped to ContTab.TableA.Ttl # of plt
  • Ttl pkgs on plts
  • Mapped to ContTab.TableA.Ttl pkgs on plts
  • Mapped to ContTab.TableA.Ttl pkgs on plts >Type
    • This is an Option for user to select on the template in order to show the unit of total packages on plts.
  • Loose pkgs
  • Mapped to ContTab.TableA.Loose pkgs
  • Mapped to ContTab.TableA.Loose pkgs >Type
    • This is an Option for user to select on the template in order to show the unit of Loose pkgs.
  • Ttl G kg
  • Mapped to ContTab.TableA.Ttl G kg
  • CBM
  • Mapped to ContTab.TableB.Total (in cbm)

[edit] Sort By Definitions

  • Earlier CT# to latest CT#

[edit] Special Cases

[edit] Figures

[edit] Figure 1. Download To Spreadsheet button

File:AirDetailedManifest.JPG

[edit] Figure 2. Spreadsheet result view

File:AirDetailedManifestSpreadsheet.JPG

[edit] History

[edit] RFC

  • This report may be moved to Misc tab, still need an approval, since this report has no template. Right now just leave on Master Air Total

[edit] History

[edit] Implement this new feature

Personal tools