Air Detailed Manifest (M) (xls)

From UG

Revision as of 22:55, 11 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)
(19 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 39:		Line 44:
	** Date Time Stamp		** Date Time Stamp
	* Body		* Body
-	** Section 1	+	'''Section 1'''
-	*** Master Shipper ref:	+	* Master Shipper ref:
-	*** Master Consignee ref:	+	* Master Consignee ref:
-	*** Flight Number:	+	* Flight Number:
-	*** Master Airway Bill:	+	* Airline:
-	*** Airline:	+	'''Section 2'''
-	** Section 2	+	* Shipper/Consignee
-	*** Shipper/Consignee	+	* HAWB
-	*** HAWB	+	* CT#
-	*** CT#	+	* PO Num
-	*** PO Num	+	* SKU
-	*** Item Code	+	* Qty
-	*** Quantity	+	* Ttl# plt
-	*** Pallets	+	* Ttl pkgs on plts
-	*** Cartons (plts)	+	* Type (Optional)
-	*** Cartons (loose)	+	* Loose pkgs
-	*** Weight	+	* Type (Optional)
-	*** CBM	+	* Ttl G kg
		+	* CBM
	* Footer		* Footer
	** There is no footer		** There is no footer
Line 63:		Line 69:
	==== Columns Definitions ====		==== Columns Definitions ====
-	CT_bo#HAWB	+	'''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)
	==== Sort By Definitions ====		==== Sort By Definitions ====
Line 74:		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