Air Detailed Manifest (M) (xls)

From UG

Revision as of 20:33, 12 March 2010 (edit) Montira (Talk | contribs) (→Hard Coded Conditions) ← Older edit		Current revision as of 18:47, 15 March 2010 (edit) (undo) Montira (Talk | contribs) (→Output)
(4 intermediate revisions not shown)
Line 23:		Line 23:
	=== User Defined Conditions ===		=== User Defined Conditions ===
-	* User can define the result showing type/unit of Ttl pkgs on plts and loose pkgs	+	* 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.	+	* 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''.		** For example: Ttl pkgs on plts is ''10'' versus ''10 cartons''.
Line 37:		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 58:		Line 58:
	* Ttl# plt		* Ttl# plt
	* Ttl pkgs on plts		* Ttl pkgs on plts
		+	* Type (Optional)
	* Loose pkgs		* Loose pkgs
		+	* Type (Optional)
	* Ttl G kg		* Ttl G kg
	* CBM		* CBM

---

Current revision as of 18:47, 15 March 2010

Contents 1 Mantis 2 Business Needs and Requirements 3 Technical Specification 3.1 Summary 3.2 User Interface 3.3 Hard Coded Conditions 3.4 User Defined Conditions 3.5 Steps 3.6 Output 3.6.1 Columns Definitions 3.6.2 Sort By Definitions 3.7 Special Cases 4 Figures 4.1 Figure 1. Download To Spreadsheet button 4.2 Figure 2. Spreadsheet result view 5 History 6 RFC 7 History 7.1 Implement this new feature

[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

• See #Figure 1. Download To Spreadsheet button
• See #Figure 2. Spreadsheet result view

[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

• Mapped to Ct#Shipper
• Mapped to Ct#Consignee

• HAWB

• Mapped to Ct#HAWB

• CT#

• Mapped to Ct#CT Num

• 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

[edit] Figure 2. Spreadsheet result view

[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

• ver 1.0
• http://mantis.jaguarfreight.com/mantis/view.php?id=1531