Truck Detailed Manifest

From UG

(Difference between revisions)
Jump to: navigation, search
Line 1: Line 1:
[[Category:New Arden Trucking Project]]
[[Category:New Arden Trucking Project]]
 +
 +
== Mantis ==
 +
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 ==
 +
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
 +
 +
== Technical Specification ==
 +
=== 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
 +
 +
=== User Interface ===
 +
* See [[#Figure 1. Download To Spreadsheet button ]]
 +
* See [[#Figure 2. Spreadsheet result view]]
 +
 +
=== Hard Coded Conditions === 
 +
* This report is used to identify ALL CT records in a Master
 +
* Display result
 +
 +
=== 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 ===
 +
* 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
 +
 +
=== 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
 +
 +
==== 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 ====
 +
* Earlier CT# to latest CT#
 +
 +
=== Special Cases ===
 +
== Figures ==
 +
=== Figure 1. Download To Spreadsheet button ===
 +
[[File:AirDetailedManifest.JPG]]
 +
 +
=== Figure 2. Spreadsheet result view ===
 +
 +
[[File:AirDetailedManifestSpreadsheet.JPG]]
 +
 +
== History ==
 +
== 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 ==
 +
 +
=== Implement this new feature ===
 +
* ver 1.0
 +
* http://mantis.jaguarfreight.com/mantis/view.php?id=1531

Revision as of 15:40, 1 April 2010


Contents

Mantis

Parent: 1583

Task: 1531

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

Technical Specification

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

User Interface

Hard Coded Conditions

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

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

  • 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

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

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)

Sort By Definitions

  • Earlier CT# to latest CT#

Special Cases

Figures

Figure 1. Download To Spreadsheet button

File:AirDetailedManifest.JPG

Figure 2. Spreadsheet result view

File:AirDetailedManifestSpreadsheet.JPG

History

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

Implement this new feature

Retrieved from "https://wiki.jaguarfreight.com/Truck_Detailed_Manifest"
Personal tools