Air Detailed Manifest (M) (xls)
From UG
(Difference between revisions)
(→Output) |
(→Output) |
||
| (18 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 === | ||
| - | + | * 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 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 | * Footer | ||
** There is no footer | ** There is no footer | ||
| Line 62: | Line 69: | ||
==== Columns Definitions ==== | ==== 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) | ||
==== Sort By Definitions ==== | ==== Sort By Definitions ==== | ||
| Line 73: | 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
- 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
