Ocean Detailed Manifest (M) (xls)

From UG

(Difference between revisions)
Jump to: navigation, search
(→SOW 1)
(→SOW 1)
 
(40 intermediate revisions not shown)
Line 126: Line 126:
== SOW 1 ==
== SOW 1 ==
-
Mantis [[http://ct.jaguarfreight.com/mantis/view.php?id=3456 3456]]
+
Mantis [http://ct.jaguarfreight.com/mantis/view.php?id=3456 3456]
 +
 
 +
Core Requirements:
 +
 
 +
This is a change request for any Ocean masters.  Changes for the ''ocean container'' manifest and is based upon conditions:
 +
 
 +
1. MOT = Ocean FCL (AW, MLB) OR Ocean Client Consol
 +
 
 +
1a. If E0 client is NOT common, add an '''exception message''' for when user clicks on "Download to Spreadsheet" option.
 +
 +
Exception message IE:
 +
One or more CT records in the master has a different E0 client company.  This needs to be corrected before you can download the 
 +
container manifest.
 +
 
 +
2. E0 client company has Commodity Table Optional Fields (Invoice, Pieces Per Package, Package Type) & Extra Fields (Extra field 1, Extra field 2, Extra field 3) SET inside Admin > Client Companies >> Part E. Commodity Table Management
 +
 
 +
If CT meets the above criteria, then Add Columns for Optional Fields "Invoice", "Pieces Per Package", "Package Type" & "Extra Fields" to report as follows:
 +
 
 +
*Change Report Header Name from Ocean Detailed Manifest Report to Container Manifest Report
 +
 
 +
*Add commodity table fields "Invoice", "Pieces Per Package", "Package Type" & "Extra Field" ''"Extra Field"'' onto the excel file output only.
 +
**Not necessary to add columns to current data grid/view found on the Master Container Totals Tab.
 +
 
 +
*List columns in order on excel output file after CT column:
 +
**Extra Field 1   
 +
**Extra Field 2   
 +
**Extra Field 3 
 +
**Invoice   
 +
**P.O.   
 +
**SKU   
 +
**Qty 
 +
**Pkg Type   
 +
**Item Description   
 +
**Pcs/pkg 
 +
**Ttl # of plts 
 +
**Ttl pkgs on plts 
 +
**Loose pkgs   
 +
**Ttl GW
 +
 +
*Column Names = same name values set (default name & custom name) that are in that Client Companies >> Part E. Commodity Table Management
 +
 
 +
*Do not add/list columns to report for unchecked Commodity Table Fields
 +
 
 +
Example:
 +
CT 373405 has E0 Client Company = Elizabeth Arden
 +
AND Client Company Elizabeth Arden has Optional Field Invoice set AND Custom Fields - Extra Field 1=Division, 2= Lot #, 3=Blank set
 +
inside of Part E. Commodity Table Management
 +
Excel Output (Manifest) should include these 3 Columns, named according to their settings in Part E of their client company profile
 +
AND include their values from the commodity table's settings inside of the CT record - See [[#Ocean Client Consol Manifest]]
 +
 +
=== Master Container Totals Tab ===
 +
 
 +
[[File:Cont Master Tab.JPG]]
 +
 
 +
==== Ocean Client Consol Manifest ====
 +
[[File:Ocean Detailed Manifest Rep 2.JPG]]
 +
 
 +
==== FCL Ocean Manifest ====
 +
[[File:Ocean Detailed Manifest Rep fcl.JPG]]
== Figures ==
== Figures ==

Current revision as of 15:55, 7 March 2012


Contents

[edit] Mantis

Parent: 1582

Task: 1860

[edit] 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

[edit] Technical Specification

[edit] 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

[edit] User Interface

[edit] Hard Coded Conditions

  • This report is used to identify ALL containers in a Master
  • Display result CTs that are grouped by container#
  • One container per section; many CTs can be assigned to one container or more.

[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 Ocean Master
  • Click "Master Container Totals" 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 container 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:
  • Vessel Name:
  • Shipping Line:

Section 2

  • Container#
  • Shipper/Consignee
  • CT#
  • PO Num
  • SKU
  • Qty
  • Ttl# plt
  • Ttl pkgs on plts
  • Type (optional)
  • Loose pkgs
  • Type (Optional)
  • Ttl G kg
  • CBM (Please see Note below under Section 2)
  • 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:
  • Vessel Name:
  • Mapped to Master Details.9a. Vessel Name:
  • Shipping Line:
  • Mapped to Master Details.4.Steamshipline:

Section 2

  • Shipper/Consignee
  • 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)
  • NOTE: one CT has 1 number of cbm, so in this case, display it on every CT even though it is repeated.

[edit] Sort By Definitions

  • Earlier Container# to latest Container# (Ascending order)

[edit] Special Cases

[edit] SOW 1

Mantis 3456

Core Requirements:

This is a change request for any Ocean masters. Changes for the ocean container manifest and is based upon conditions:

1. MOT = Ocean FCL (AW, MLB) OR Ocean Client Consol

1a. If E0 client is NOT common, add an exception message for when user clicks on "Download to Spreadsheet" option. 

Exception message IE: 
One or more CT records in the master has a different E0 client company.  This needs to be corrected before you can download the  
container manifest.

2. E0 client company has Commodity Table Optional Fields (Invoice, Pieces Per Package, Package Type) & Extra Fields (Extra field 1, Extra field 2, Extra field 3) SET inside Admin > Client Companies >> Part E. Commodity Table Management

If CT meets the above criteria, then Add Columns for Optional Fields "Invoice", "Pieces Per Package", "Package Type" & "Extra Fields" to report as follows:

  • Change Report Header Name from Ocean Detailed Manifest Report to Container Manifest Report
  • Add commodity table fields "Invoice", "Pieces Per Package", "Package Type" & "Extra Field" "Extra Field" onto the excel file output only.
    • Not necessary to add columns to current data grid/view found on the Master Container Totals Tab.
  • List columns in order on excel output file after CT column:
    • Extra Field 1
    • Extra Field 2
    • Extra Field 3
    • Invoice
    • P.O.
    • SKU
    • Qty
    • Pkg Type
    • Item Description
    • Pcs/pkg
    • Ttl # of plts
    • Ttl pkgs on plts
    • Loose pkgs
    • Ttl GW
  • Column Names = same name values set (default name & custom name) that are in that Client Companies >> Part E. Commodity Table Management
  • Do not add/list columns to report for unchecked Commodity Table Fields 
Example: 
CT 373405 has E0 Client Company = Elizabeth Arden 
AND Client Company Elizabeth Arden has Optional Field Invoice set AND Custom Fields - Extra Field 1=Division, 2= Lot #, 3=Blank set 
inside of Part E. Commodity Table Management 
Excel Output (Manifest) should include these 3 Columns, named according to their settings in Part E of their client company profile
AND include their values from the commodity table's settings inside of the CT record - See #Ocean Client Consol Manifest

[edit] Master Container Totals Tab

File:Cont Master Tab.JPG

[edit] Ocean Client Consol Manifest

File:Ocean Detailed Manifest Rep 2.JPG

[edit] FCL Ocean Manifest

File:Ocean Detailed Manifest Rep fcl.JPG

[edit] Figures

[edit] Figure 1. Download To Spreadsheet button

File:OceanDetailedManifest.JPG

[edit] Figure 2. Spreadsheet result view

File:OceanDetailedManifestSpreadsheet.JPG

[edit] History

[edit] RFC

[edit] 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

[edit] Review against new examples, Move to Doc Tab

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