Air Detailed Manifest (M) (xls)

From UG

Revision as of 19:44, 12 March 2010 (edit) Montira (Talk | contribs) (→Columns Definitions) ← Older edit		Current revision as of 18:47, 15 March 2010 (edit) (undo) Montira (Talk | contribs) (→Output)
(13 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 53:		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
Line 100:		Line 107:
	* Ttl pkgs on plts		* Ttl pkgs on plts
	:* Mapped to ContTab.TableA.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
	:* Mapped to ContTab.TableA.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		* Ttl G kg
Line 109:		Line 120:
	* CBM		* CBM
	:* Mapped to ContTab.TableB.Total (in cbm)		:* Mapped to ContTab.TableB.Total (in cbm)
-
-
-	CT_bo#HAWB
	==== Sort By Definitions ====		==== Sort By Definitions ====
Line 122:		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 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