Ocean Detailed Manifest (M) (xls)

From UG

(Difference between revisions)
Jump to: navigation, search
(→Business Needs and Requirements)
Line 10: Line 10:
== Technical Specification ==
== Technical Specification ==
-
=== Summary ===
+
=== Summary ===  
-
=== Template ===
+
* This report is a spreadsheet report for Totals of Master Ocean. It has one panel which displays a table of contents totals that is grouped per CT.
-
====  Template Top Section ====  
+
* This report can be generated from Master OCEAN Totals tab
-
====  Template Bottom Section ====  
+
 
-
=== Pdf ===
+
=== User Interface ===
-
====  Header ====  
+
* See [[#Figure 1. Download To Spreadsheet button ]]
-
====   Top Section ====  
+
* See [[#Figure 2. Spreadsheet result view]]
-
====   Bottom Section ====  
+
 
-
====    Footer ====  
+
=== Hard Coded Conditions ===
-
=== Special case: Groups ===
+
* This report is used to identify ALL containers in a Master
-
== Additional Figures ==
+
* Display result CTs that are grouped by container#
-
===   Figure X ===
+
 
 +
=== 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 Ocean Master
 +
* Click "Master Container Totals" 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
 +
* 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
 +
* Loose pkgs
 +
* 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 ==
== History ==
 +
== RFC ==
=== v 1.1 ===
=== v 1.1 ===

Revision as of 15:59, 15 March 2010


Contents

Mantis

Parent: 1582

Task: 1860

Business Needs and Requirements

User would like to be able to generate a report that shows result of Ocean container detailed manifest. The result will show detail that is grouped CT# by Container with content information

Technical Specification

Summary

  • This report is a spreadsheet report for Totals of Master Ocean. It has one panel which displays a table of contents totals that is grouped per CT.
  • This report can be generated from Master OCEAN Totals tab

User Interface

Hard Coded Conditions

  • This report is used to identify ALL containers in a Master
  • Display result CTs that are grouped by container#

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 Ocean Master
  • Click "Master Container Totals" 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
  • 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
  • Loose pkgs
  • 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

v 1.1

Master Ocean Container Totals Tab must have one panel which displays a table - per container per CT "contents totals" report. 

Vedor = Shipper
Ignore Drums column
This is per container (example has 1 cont but could be many containers)

(0004851)
alex (administrator) [ private ]
2009-11-12 12:27

1. Jaguar Import Ref - is it ShipperRef?
>>> GenTab.B. Import ref#:

2. Jaguar Export Ref - is it ConsigneeRef?
>>> GenTab.A. Export ref#:

3. Flight Number/Vessel Name - Flight Number is specific for Air Shipment. Not applicable for container's report. Should I just write Vessel Name (Maybe with Voyage number, because it's usefull information)?
>>> OK

4. The same with House Waybill

>>> remove this label/field

5. Shipping Line ref - what is it? I did not found this field in Shipment object.

>>> remove this label/field

6. Lot# - this value is in the Client Specific extra fields of commodity item. On the moment of creating report I can't define what one of the 3 extra fields is contains "Lot" value.

>>> remove this column

Review against new examples, Move to Doc Tab

Retrieved from "https://wiki.jaguarfreight.com/Ocean_Detailed_Manifest_(M)_(xls)"
Personal tools