Ocean Detailed Manifest (M) (xls)

From UG

Revision as of 22:16, 22 February 2012 (edit) Denise (Talk | contribs) (→SOW 1) ← Older edit		Current revision as of 15:55, 7 March 2012 (edit) (undo) Denise (Talk | contribs) (→SOW 1)
(21 intermediate revisions not shown)
Line 130:		Line 130:
	Core Requirements:		Core Requirements:
-	This is a change request for the ''ocean container'' manifest and are based upon these 2 conditions:	+	This is a change request for any Ocean masters.  Changes for the ''ocean container'' manifest and is based upon conditions:
-	1. MOT = FCL (AW, MLB) Ocean OR Ocean Client Consol	+	1. MOT = Ocean FCL (AW, MLB) OR Ocean Client Consol
-	2. E0 client company has Commodity Table Extra Fields SET inside Admin > Client Companies >> Part E. Commodity Table Management	+	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.
-	If CT meets the above criteria, then Add Columns "Extra Field" to report	+	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
-	*Add commodity table ''"Extra Field"'' onto the excel file output only.	+	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.		**Not necessary to add columns to current data grid/view found on the Master Container Totals Tab.
-	*List ''"Extra Field"'' columns in between CT# & PO Num columns on excel output file.	+	*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 inside of that Client Companies >> Part E. Commodity Table Management, Extra Field 1, 2, 3	+	*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:		Example:
	CT 373405 has E0 Client Company = Elizabeth Arden		CT 373405 has E0 Client Company = Elizabeth Arden
-	AND Client Company Elizabeth Arden has Extra Field 1=Division, 2= Lot #, 3=Blank set inside of Part E. Commodity Table Management	+	AND Client Company Elizabeth Arden has Optional Field Invoice set AND Custom Fields - Extra Field 1=Division, 2= Lot #, 3=Blank set
-	Manifest should include these 2 Extra Field Columns, named as they are set in Part E of their client company profile	+	inside of Part E. Commodity Table Management
-	AND include their values from the commodity table inside of the CT record - See [[#SOW 1 MU IE]]	+	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]]
-	=== SOW 1 MU IE ===	+	=== Master Container Totals Tab ===
-	[[File:Ocean Detailed Manifest Rep.JPG]]	+
		+	[[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 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 SOW 1 4.1 Master Container Totals Tab 4.1.1 Ocean Client Consol Manifest 4.1.2 FCL Ocean Manifest 5 Figures 5.1 Figure 1. Download To Spreadsheet button 5.2 Figure 2. Spreadsheet result view 6 History 7 RFC 7.1 v 1.1 7.2 Review against new examples, Move to Doc Tab

[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

• See #Figure 1. Download To Spreadsheet button
• See #Figure 2. Spreadsheet result view

[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

• Mapped to Ct#Shipper
• Mapped to Ct#Consignee

• 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)
• 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

[edit] Ocean Client Consol Manifest

[edit] FCL Ocean Manifest

[edit] Figures

[edit] Figure 1. Download To Spreadsheet button

[edit] Figure 2. Spreadsheet result view

[edit] History

[edit] RFC

[edit] v 1.1

• http://mantis.jaguarfreight.com/mantis/view.php?id=1319

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

• ss1 // add "Download to spreadsheet" feature
• ss2 // add "Download to spreadsheet" button to this tab. xls should look like this file: CT1%20manifest_20091007134418.pdf uploaded to http://mantis.jaguarfreight.com/mantis/view.php?id=1319
• ss3 // In this file:

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

• v 1.2
• http://mantis.jaguarfreight.com/mantis/view.php?id=1584
• Detailed spec - TBD