Client Shipment Details Containers Tab

From UG

(Difference between revisions)
Jump to: navigation, search
(SOW 1)
 
(24 intermediate revisions not shown)
Line 74: Line 74:
Core Requirements:
Core Requirements:
-
This is a change request to the Client Application's Client Shipment Details Container Tab
+
This is a change request for the Client Application's, Client Shipment Details, Container Tab and is based upon the following conditions:
-
It is to Add the an ocean container manifest download to excel option for CT records that have MOT = Ocean FCL (AW/MLB) AND Client Consol
+
1. CTs MOT = FCL (AW, MLB) Ocean OR Ocean Client Consol
-
It is to act like [[Ocean_Detailed_Manifest_%28M%29_%28xls%29#SOW_1]] but is subject to Client Visibility Rule
+
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
-
 
+
-
1. MOT = FCL (AW, MLB) Ocean OR Ocean Client Consol
+
-
2. E0 client company has Commodity Table Extra Fields SET inside Admin > Client Companies >> Part E. Commodity Table Management
+
If CT meets the above criteria, then have Container Manifest Report with Download to excel option on the Shipment Details Container Tab with changes as follows: 
-
If CT meets the above criteria, then Add Columns "Extra Field" to report as follows:
+
*Change Report Header Name from Ocean Detailed Manifest Report to Container Manifest Report
-
*Add commodity table ''"Extra Field"'' onto the excel file output only.
+
*Change Shipper ref values
-
**Not necessary to add columns to current data grid/view found on the Master Container Totals Tab.
+
**If more than 1 shipper is set in the container's CT records than shipper ref = "Multiple"
 +
**If only 1 shipper is set in the container's CT records than shipper ref = Actual shippers name
-
*List ''"Extra Field"'' columns in between CT# & PO Num columns on excel output file.
+
*Change Consignee ref values
-
+
**If more than 1 consignee is set in the container's CT records than consignee ref = "Multiple"
-
*Column Names = same name values set inside of that Client Companies >> Part E. Commodity Table Management, Extra Field 1, 2, 3
+
**If only 1 consignee is set in the container's CT records than consignee ref = actual consignees name
-
Example:
+
*Add commodity table fields "Invoice", "Pieces Per Package", "Package Type" & "Extra Field" ''"Extra Field"'' onto the excel file output only.
-
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
+
*List columns in order on excel output file after CT column:
-
Manifest should include these 2 Extra Field Columns, named as they are set in Part E of their client company profile
+
**Extra Field 1  
-
  AND include their values from the commodity table inside of the CT record - See [[#SOW 1 MU IE]]
+
**Extra Field 2  
 +
**Extra Field
 +
**Invoice   
 +
**P.O.   
 +
**SKU   
 +
**Qty 
 +
**Pkg Type   
 +
**Item Description   
 +
**Pcs/pkg 
 +
**Ttl # of plts 
 +
**Ttl pkgs on plts  
 +
**Loose pkgs   
 +
**Ttl GW
   
   
-
=== SOW 1 MU IE ===
+
*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
 +
 
 +
'''Note:''' It is possible for a container to have CT records for different E0 client companies.  Do not include any CT record on the report, that has a different E0 client companies unless client user has visibility rights for it.
 +
 
 +
'''This feature is to act like the [[Ocean_Detailed_Manifest_%28M%29_%28xls%29#SOW_1]] but is subject to the [[Client_visibility_rule]].'''
 +
 
 +
=== Shipment Detail View ===
 +
 
 +
==== Containers Tab View ====
 +
[[File:Client Ocean Manifest Opt.JPG]]
 +
 
 +
=== Client App Container Manifest ===
 +
 
 +
==== Ocean Client Consol ====
 +
[[File:Ocean Detailed Manifest Rep cc.JPG]]
 +
 
 +
==== Ocean FCL ====
 +
[[File:Ocean Detailed Manifest Rep cc fcl CA.JPG]]
== Figures ==
== Figures ==
Line 106: Line 136:
== History ==
== History ==
 +
 +
== SOW 2 ==
 +
Mantis: [http://ct.jaguarfreight.com/mantis/view.php?id=3366 3366]
 +
 +
'''NOTE: MAWB interface with Icarus is no longer supported. Icarus suspended support and service of this interface in 2008. An alternate provider has been identified.''' (www.track-trace.com)
 +
 +
Behavior of the interface should remain as-is. The only change is to redirect to a new URL.
 +
 +
Only change requested is to '''Track Shipment''' button.
 +
 +
* Track Shipment button
 +
:* This button MUST show ONLY when container# AND SS line are NOT EMPTY
 +
:* See [[Client MAWB Tracking#SOW_2]]

Current revision as of 20:51, 2 April 2012

Contents

[edit] Mantis

Parent Mantis: 2010

[edit] Biz Analyst Intro

This tab is providing containers detail as same as ContTab in Internal App excluding Estimated collection Date and Actual collection Date. It is also providing a tracking shipment feature for ocean mode.

This requirement is for all modes except Trucking - Domestic and Trucking - Air; For these 2 modes please see Client Shipment Detail Trucker Info Tab

[edit] Sys Analyst Intro

  • This tab provides how many container records for a specific shipment; Containers count( ) records
  • This tab consists of 7 columns
  • Container
  • SS Line
  • Seal
  • Size
  • Type
  • Requested Delivery
  • Actual Delivery
  • Track Shipment button
  • Printer Friendly button

[edit] Design

Container

  • Mapping: ContTab.Container

SS Line

  • Mapping: ExpTab.b4.Steamshipline

Seal

  • Mapping: ContTab.Seal

Size

  • Mapping: ContTab.Size

Type

  • Mapping: ContTab.Type

Requested Delivery

  • Mapping: ContTab.Requested Delivery

Actual Delivery

  • Mapping: ContTab.Actual Delivery

Track Shipment

  • Type: Button
  • Logic: Show when container# AND SS line are NOT EMPTY

[edit] Use cases

Goal Client is able to see Containers detail from Container tab

  • Client clicks on Container tab
  • Container field in Client App shows the same data as Container field in Internal App
  • Seal field in Client App shows the same data as Seal field in Internal App
  • Size field in Client App shows the same data as Size field in Internal App
  • Type field in Client App shows the same data as Type field in Internal App
  • Requested Delivery field in Client App shows the same data as Requested Delivery field in Internal App
  • Actual Delivery field in Client App shows the same data as Actual Delivery field in Internal App
  • Containers Tab provides containers count()

[edit] SOW 1

Mantis 3313

Core Requirements:

This is a change request for the Client Application's, Client Shipment Details, Container Tab and is based upon the following conditions:

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

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 have Container Manifest Report with Download to excel option on the Shipment Details Container Tab with changes as follows:

  • Change Report Header Name from Ocean Detailed Manifest Report to Container Manifest Report
  • Change Shipper ref values
    • If more than 1 shipper is set in the container's CT records than shipper ref = "Multiple"
    • If only 1 shipper is set in the container's CT records than shipper ref = Actual shippers name
  • Change Consignee ref values
    • If more than 1 consignee is set in the container's CT records than consignee ref = "Multiple"
    • If only 1 consignee is set in the container's CT records than consignee ref = actual consignees name
  • Add commodity table fields "Invoice", "Pieces Per Package", "Package Type" & "Extra Field" "Extra Field" onto the excel file output only.
  • 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

Note: It is possible for a container to have CT records for different E0 client companies. Do not include any CT record on the report, that has a different E0 client companies unless client user has visibility rights for it.

This feature is to act like the Ocean_Detailed_Manifest_(M)_(xls)#SOW_1 but is subject to the Client_visibility_rule.

[edit] Shipment Detail View

[edit] Containers Tab View

File:Client Ocean Manifest Opt.JPG

[edit] Client App Container Manifest

[edit] Ocean Client Consol

File:Ocean Detailed Manifest Rep cc.JPG

[edit] Ocean FCL

File:Ocean Detailed Manifest Rep cc fcl CA.JPG

[edit] Figures

[edit] Figure 1. Containers Tab

File:ContainerTab.JPG

[edit] History

[edit] SOW 2

Mantis: 3366

NOTE: MAWB interface with Icarus is no longer supported. Icarus suspended support and service of this interface in 2008. An alternate provider has been identified. (www.track-trace.com)

Behavior of the interface should remain as-is. The only change is to redirect to a new URL.

Only change requested is to Track Shipment button.

  • Track Shipment button
Personal tools