I-Portal REQUIREMENTS

From UG

(Difference between revisions)
Jump to: navigation, search
(View list of CT records as a shipper)
(BR 1.3 View list of CT records as a shipper)
Line 357: Line 357:
2) Add note to the screen "Both Loose Pkgs and Plts  cant be zero at the same time on one line."
2) Add note to the screen "Both Loose Pkgs and Plts  cant be zero at the same time on one line."
-
=== BR 1.3 View list of CT records as a shipper ===
+
==== BR 1.3 View list of CT records as a shipper ====
* Shipper can view records that anyone in their company created.
* Shipper can view records that anyone in their company created.

Revision as of 16:49, 1 June 2012


Contents

Mantis

Mantis 3547 http://ct.jaguarfreight.com/mantis/view.php?id=99
Code Branch To Be Determined
DEV Environment To Be Determined
QA Environment To Be Determined
SIT Environment To Be Determined


Introduction

The primary objective of International Portal (I-Portal) is to create a platform for CyberTrax2 to transform into Software-As-A-Service (SaaS) system that Jaguar Freight Services can offer as a fee-based service to external clients. Clients would be able to manage all aspects of their shipments from within CyberTrax2 for both domestic and international shipments. The portal should provide client users with the ability to create shipments, approve shipments, track shipments, etc.. This will streamline a business process of submitting and approving shipments and seamless communication at Elizabeth Arden. It is proposed to provide a web portal that can expand to cover other modes of transportation for international shipment as an additionfrom truck domestic shipments portal. Required software is a tool that allow a supplier to enter an Elizabeth Arden international traffic order as well as planner to approve shipments for transportation and additional features for automated system.


The portal must be web accessible, secure, user-friendly, flexible, and scalable. The portal must also take into account data visibility rules (Clients will only be able to edit/view their own data) and system performance. This portal is mimic from ASN portal (Trucking domestic portal for Elizabeth Arden)


There are a number of features that should be postponed and released in phase two. This was done to launch international portal with core features with/without automated Purchase Order Event Management as soon as possible.

Functionality Overview

High Level Deliverable

  • Flexible Entitlements Management System
  • Flexible admin functionality for each user role
  • User Interface Templates
  • User visibility
  • External user Specific Reporting
  • Search/where is record(s) report
  • Download to Excel
  • Sorting ascending/descending
  • Internal user Specific Reporting
  • Dashboard/KPI
  • Download to Excel
  • Optimize current CT2 Client performance


Summary

  • Existing ASN portal should support two additional user roles for international shipments:
  • Shipper (a.k.a. Supplier)
  • Planner (a.k.a. EM)


Core Shipper User Functionality:

  • Manual creation
  • Create CT record
  • Edit CT record
  • Delete CT record
  • View CT record
  • Notifications
  • Appropriate visibility
  • Automated Purchase Order Event Management
  • See POEM
  • Edit CT record
  • Delete CT record
  • View CT record
  • Submit to create CT record
  • Notifications
  • Appropriate visibility
  • Flexibility admin for shipper's functionality


Core Planner User Functionality:

  • Single approval process
  • View CT record
  • set "approval status" on selected CT record
  • notifications
  • appropriate visibility
  • Double approval process
  • View CT record
  • set "approval status" on selected CT record
  • notifications
  • appropriate visibility
  • Auto approval
  • After record creation X hrs
  • Flexibility admin for planner's functionality


Client Functionality and Changes:

  • should not be affected
  • shipment becomes available on client for client visibility rule


Core Jaguar User and Cybertrax Internal Functionality:

  • non jaguar user profile will have 3 roles defined
  • Client
  • Shipper (International portal and Domestic portal)
  • Planner (International portal and Domestic portal)
  • Jaguar User will see new additional fields
  • Jaguar User will see only shipments on Live tab when the CT has been approved by a planner or auto approved by system with rule set in admin
  • Jaguar User will see shipment with MOT or without MOT
  • Logic will be provided for each use case such as:
    • Jaguar user can edit MOT
    • MOT becomes read only field by approval process for MOT from portal
    • System automatically assign MOT with some criteria
  • constraint on how many lines commodity table might have
  • some fields might become read only
  • additional report
  • dashboard report for approved shipments by modes with ability to create a group shipment
  • validation
  • Jaguar User will be able to create a group from list of shipment
  • etc


Project Stakeholders & Roles

  • Simon Kaye - CEO - Project Sponsor
  • Marc Selter - VP - Product Manager
  • Alex Dobrovolsky - Director of Technology - Solutions Architect
  • Montira Renfrew - CT2 Systems Analyst/ CT2 Project manager
  • Konstantin Ushakov - CT2 Software Developer (Elcosol)
  • Denise Guastella - CT2 Support Manager


Project Scope

<Identify in-scope and out-of-scope items>


Out-Of-Scope

  • SAS 70 & ISO27001 Compliance
  • Web Application Penetration Tests
  • High Availability (HA) Disaster Recovery environment(s)
  • 100% integration of both Internal CT2 & Client CT2
  • Functional & Non-Functional gaps in Internal CT2


Project Dependencies

  • POEM project
  • DR/KPI project


High-Level Timelines

<High-level milestone dates>


Risks

<Identify internal and external risks to the project: schedule, resources, technical, business, cost, market conditions, external vendors/partners, etc..>

  • Flexibility to implement to support many different workflows require more time
  • [Extermal Risk] Without customers' requirements or feedback, it will be hard to guess what to implement and this is high risk in term of cost, resources that we offers something that they do not want
  • [External Risk] Elizabeth Arden can have different workflows inside the company for different users, systems may not be able to meet all the workflows. Need to make all different workflows to meet a few workflow standard as to avoid implementing too complex and too specific workflow for each individual users.

Assumptions / Constraints

<Identify all assumptions and constraints for this project>

Business Requirements

Figure 1: Supplier/Shipper automatically generates CT record(s) by submitting P.O. to ASN portal. See diagram below.

Figure 2: Reject CT that was submitted from POEM

Figure 3: Supplier/Shipper manually generates CT record(s) similar workflow as Truck-Dom portal. See diagram below.


BR 1. Core International Shipper Functionality

BR 1.1 Creating Shipper User and Shipper Profile

Admin - all CTs created by specific Shipper user must have:

  • MOT
  • Include mode [Y/N]
    • IF [Y]
      • THEN Default MOT is selected
      • OR THEN Allow shipper to assign MOT
    • IF [N]
    • THEN MOT is read only when it is available on the view shipment
      • MOT is not available for shipper to edit, only when planner or Jaguar operator assign the MOT
  • E0. Client Company
  • Relationship: one to many (one shipper: many E0. Client company)
    • Phase I: Start with one shipper: one E0. Client company
    • one portal: one shipper: one E0. Client company
  • Shipper
  • Relationship: single selected, one shipper company
  • Shipments Weight in [LB/KG]
  • Default value
    • LB only
    • KG only
    • KG and LB
  • Currency in [USD/EUR/GBP/HKD]
  • Default value
    • single select or multiple select option
  • CT Creation
  • IF POEM = [Y] THEN requested P.O. are automated available to submit to create a CT record
  • IF Manual = [Y] THEN apply manual record creation
  • IF POEM and Manual = [Y] THEN allow automated and manual CT record(s) creation


NOTE: These parameters must be defined in the Shipper Profile which is a part of the Client Profile:

1) located in "Edit user profile" window and specify role and additional specific info
2) link to UI mock-up see []


Shipper's role for current user role profile appoints through selecting shipper user role and identify shipper account on additional tab on the separate Shipper/Supplier Role Profile section:

  • functionality - when shipper roles is assigned for the user role then user is a Shipper.
  • Specific shipper profile must be defined:
  • MOT - enable/disable
  • E0. Client company - mandatory
  • Shipper - mandatory
  • CT creation - mandatory
  • Shipments Weight in [LB/KG] - mandatory
  • Currency in [USD/EUR/GBP/HKD] - mandatory


USE CASES for shipper's profile

Shipper MOT:

  • MOT: defined MOT default to be read only [Air or Ocean or Truck-Dom]
  • IF MOT = Truck DOM, THEN direct to Truck-Dom portal
  • IF MOT = Air or Ocean, THEN direct to International portal
  • NOTE: Future - combine to be one portal for Truck-Dom and International portal
  • MOT: defined MOT option to be able to edit [Air and Ocean and Truck-Dom]
  • IF MOT = Air and Ocean, THEN give ability for shipper to assign MOT [Air or Ocean]
  • IF MOT = Truck-Dom AND Air AND Ocean, THEN give ability for shipper options/menu to select Truck-DOM OR [Air and Ocean] International Portal
  • NOTE: Future - combine to be one portal for Truck-Dom and International portal
  • MOT: No MOT defined. Shipment will be created [without MOT]


Shipper E0. Client Company:

  • E0: defined E0 default to be read only [E0. Client Company]
  • IF E0.Client Company = EA DOM PORTAL, THEN default to EA DOM Portal
  • E0: defined E0 for multiple E0. Client Company to edit such as Elizabeth Arden and Coty
  • IF EO.Client Company = Elizabeth Arden AND Coty, THEN give option to 2 portals; one for Elizabeth Arden portal, and the other is Coty portal
  • NOTE: Multiple E0. Client companies - Multiple portal environments for each E0. Client Company each portal


Shipper Shipper (T1):

  • Shipper (T1): [one:one]
  • value - must be selected one from the list of Shippers. This list reflects the set of records from "Admin > Address Book > Transportation" with T1="Yes".


Shipper CT creation:

  • CT creation: Option dropdown
  • POEM Only
  • Manual Only
  • POEM and Manual
  • value:
    • IF POEM is selected, THEN apply POEM automated workflow to shipper Refer POEM admin and not allow to create CT manually
    • IF Manual is selected, THEN enable manual process/workflow of CT record(s) creation to shipper
    • IF POEM and Manual is selected, THEN allow both automated and manual CT record(s) creation


Shipper Shipments Weight in:

  • Shipments Weight in: option from drop down list for single select:
  • LB only
  • KG only
  • LB and KG


Shipper Currency:

  • Currency: this is currency options for setting default value for shipper to view or edit
  • [ ] EUR () Default value
  • [ ] GBP () Default value
  • [ ] HKD () Default value
  • [ ] USD () Default value
  • Default value MUST be one currency among selected currencies


BR 1.2 Create CT record

Automated CT record creation
[a] Shipper/supplier submits purchase order with quantity and some handful of information from POEM to generate CT record(s) and pass through generated CT record(s) to ASN
[b] CT record(s) that were passed through ASN will display on NEW tab for both shipper and planner portals
[c] Shipper can edit CT record(s) on allowed field(s) until planner applies approval process
[d] Upon saving the modified information entered, an automatic validation notification will "pop up" asking the user to review the following information that they entered, including the shipment CT records. To go back to edit or proceed to save. Read more here: CT preview and disclaimer screen
[e] Upon user clicking on save on CT preview and disclaimer screen: automatic confirmation will "pop up", reconfirming the information. Read more here: CT confirmation screen
[f] CT record(s) was submitted through POEM or modified by a shipper company through ASN portal should display for ALL users who are a part of the same shipper company
[g] See figure below
Figure BR 1.2.1 Edit and View CT record that was submitted via POEM by shipper

Manual CT record creation
[a] Shipper will be able to add Cybertrax 2.1 Client (glossary)#Shipping request once the product is ready to ship.
[b] See detailed definitions of shipments fields in Cybertrax 2.1 Client (data dictionary).//// Update data dictionary is needed
[c] They can enter a number of lines of PO/SKU’s for only one E.M. at a time, including the piece price per PO/SKU.
[d] System will create one CT record per commodity line.
[e] Upon saving the information entered, an automatic validation notification will “pop up” asking the user to review the following information that they entered, noting the disclaimer. Read more here: CT preview and disclaimer screen
[f] Upon user clicking save:
[g] Records created by a shipper company should display for ALL users who are a part of the same shipper company
[h] See figure below
Figure BR 1.2.2 Edit and View CT record that was submitted via POEM by shipper

CT preview and disclaimer screen

This screen is for the operator to "review" and "confirm" that the information they entered is correct.

This screen should contain the following information:

CT confirmation screen

This is a confirmation to the supplier of the information they just entered and should contain the following information:

Constraint on the number of lines in Commodity table in CTs created by Shipper User

Commodity table in CTs created by Shipper may have only ONE line.

Show all addresses

  • Ship to Location
  • Pick up Location

Mark validation clearly

1) Add red star to required field 2) Add note to the screen "Both Loose Pkgs and Plts cant be zero at the same time on one line."

BR 1.3 View list of CT records as a shipper

  • Shipper can view records that anyone in their company created.
  • Columns heading should have mouse over label (description).
  • Shipper should have ability to print the CT record that they view (print friendly)
  • View CTs table definitions:
  • Columns for New Tab:
    • CT Record
    • Created On
    • Pick Up Location
    • Delivery Location
    • PO
    • SKU
    • Qty
    • Piece Price
    • Total Value
  • Columns for Approved Tab:
    • CT Record
    • Approved On
    • Pick Up Location
    • Delivery Location
    • PO
    • SKU
    • Qty
    • Piece Price
    • Total Value
  • Columns for Hold Tab:
    • CT Record
    • Approved For
    • Pick Up Location
    • Delivery Location
    • PO
    • SKU
    • Qty
    • Piece Price
    • Total Value
  • Columns for Rejected Tab:
    • CT Record
    • Rejected On
    • Pick Up Location
    • Delivery Location
    • PO
    • SKU
    • Qty
    • Piece Price
    • Total Value
  • Columns for Delivered Tab:
    • CT Record
    • Created On
    • Pick Up Location
    • Delivery Location
    • PO
    • SKU
    • Qty
    • Piece Price
    • Total Value
  • Columns for Archived Tab:
    • CT Record
    • Created On
    • Pick Up Location
    • Delivery Location
    • PO
    • SKU
    • Qty
    • Piece Price
    • Total Value


  • Default order: Latest CT on top
  • Sortable?: Yes, ascending and descending,throughout all the shipments for all pages
  • Search feature: See #Search_feature_on_List_CTs
  • Action buttons per tab definitions:
    • Action Buttons for New Tab: Add, Copy or Clone, View, Edit, Delete
    • Action Buttons for Approved Tab: Copy or Clone, View
    • Action Buttons for Hold Tab: Copy or Clone, View
    • Action Buttons for Rejected Tab: Copy or Clone, View
    • Action Buttons for Archived Tab: Copy or Clone, View
    • Action Buttons for Delivered Tab: Copy or Clone, View

Edit CT record

What CTs Shipper may edit RULE

  • Shipper user may edit only records she created

When to lock CT record for edit by Shipper RULE

  • Shipper may edit an existing CT before it is approved or placed on hold or rejected by a planner.

Delete CT records

What CTs Shipper may delete RULE

  • Shipper user may delete only records she created

When to lock CT record for delete by Shipper RULE

  • Shipper may delete an existing CT before it is approved by a planner, placed on hold by a planner or rejected by a planner.

Field for text box/area that must be read only on Add/Clone shipments

  • Shipper
  • Pick up Location
  • Ship to Location
  • Created By
  • Total Value

Clone CT Record

Not applicable for shipment that was submitted via POEM

Clone feature Exception

  • Cargo Available Date: This should be the current date, do not copy the clone date
  • E0.Client Company: This should be the same as it is set on Shipper user profile, do not copy the clone E0.Client Company
  • MOT: This should be the same as it is set on Shipper user profile, do not copy the clone MOT
  • NOTE#1: Make E0.Client Company and MOT fields for all the shipments that were created by shippers to be READ ONLY fields on the internal application. Not allow operator to change E0.client company and MOT from the individual CT, group CT, etc.
  • NOTE#2: For the group case that contained some shipments that created by shipper, should have some validation and show err message that E0. client company/MOT cannot be changed if operator tries to change the E0.client company and/or to MOT to different company or MOT that was set as shipper user profile.
  • Prevent user to clone CT with unapproved and archived addresses.

Business Requirement 2...

Business Requirement 3...

Business Process Flow 1...

Business Process Flow 2...

Business Process Flow 3...

Functional/Non-Functional Requirements

<Identify all functional and non-functional requirements. Maintain standard headings. If a specific requirement is not required, note as Not Applicable. Each functional requirement must trace back to a specific business requirement.>

CyberTrax2 Internal Application

<Identify all functional requirements for CT2 Internal Application>

User Interface Requirements

Reporting Requirements

User Access / Security Requirements

Logging Requirements

Group / Master Requirements

Filtering Requirements

Archiving Requirements

CyberTrax2 Client Application

<Identify all functional requirements for CT2 Client Application>

User Interface Requirements

Reporting Requirements

User Access / Security Requirements

Logging Requirements

Group / Master Requirements

Filtering Requirements

Archiving Requirements

Non-Functional Requirements

<Identify all non-functional requirements for both CT2 Client Application and CT2 Internal Application>

Performance Requirements

Capacity Requirements

Support / Maintenance Requirements

User Guides
Training
Log(s) Accessibility

Testing Requirements

Security Requirements

Technical Design & Solution

Mock ups

<Include mock-ups of UI changes, report changes, etc..>

Technology Stack & Architecture

<Include changes to existing Technology Stack & Architecture - new libraries, updated library versions, new software/hardware, new interfaces, etc..>

Technical Diagrams (Flow Chart, Sequence, UML, Systems Architecture, Technical Architecture, Data Architecture, etc..)

<Include architecture diagrams and flow charts>

Web / Application (New/Modified classes, methods, etc..)

<List new or modified classes and methods>

Database (DDL changes - new/modified tables, indexes, stored procedures, etc..)

<Summarize database changes>

Configuration (Config File changes)

<Summarize config changes>

Logging (Log File changes)

<Summarize Log File changes and locations>

External Interfaces (EDI Message(s), external vendors)

<Identify any new external interfaces. Include sample request and reply along with field definitions. Include Source/Target server(s)/webservice(s) and functional accounts. If this is a modification of an existing EDI message, include samples of current message(s) and new message(s)>

QUESTIONS

Admin Panel:

Q1. I-portal and ASN are separated?

  • Roles:Iportal: Shipper and planner
    • MOT: Air and Ocean only or specify MOT for each shipper one to one MOT?
    • Suggest for JG role to specify FCL, LCL, Console? with out letting shipper/planner assign
    • E0: Elizabeth Arden?
  • Roles:Truck-Dom: Shipper and Planner
    • MOT: Truck Dom only
    • E0: EA DOM PORTAL
  • Roles: combine shipper and planner?
    • All MOT: Air, Ocean, Truck Dom --> what about other trucks such as Truck air and Truck ocean
    • Should we even give International shipper to assign the breakdown of ocean from the beginning? FCL, LCL, Console?


Q2. If it does, how? what is the process? Will we change the current business process for EA DOM? If it does not, THEN?

Q3. Shipper Role:

  • one:one? for Shipper: EO.client Company?

Q4. Shipper Role:

  • one:one? one:many? For Shipper: MOT(s)?
  • Do they have ability to choose MOT?
  • MOT Air/Ocean --> available for shipper to assign? and keep the way it is for truck dom?
  • What is about Truck-air and truck-ocean? Could you describe the situation of when shipper wants to ship by truck air/ocean? When to consider? are they apart of i-portal? Should we not consider these yet only air and ocean first and we will think about that for future phase?

Q5. Who will assign MOT? Shipper? Planner? Jaguar? Do we have to give all the ability for all roles to assign/edit?

Q6.

Use case 1: Shipper assigns MOT by default from admin, or actual assign by shipper?

  • THEN Planner will approve the shipment...with date, etc including MOT?
  • THEN Planner (skip) --> automate approval

Use case 2: Shipper (NO MOT assign) view only once MOT is approved by Planner?

  • THEN Planner approves the shipment....etc including MOT assign
  • What would MOT be if automate approval for planner process. (Skip approval process)

Use case 3: Shipper and Planner (NO MOT assigned)

  • THEN Planner only approve the shipment...with date...etc without MOT assign.
  • THEN JAGUAR assigns the MOT
  • Work for AUTO approval as well


Q7. Any other fields? should allow shipper to edit? Label for all fields should be consistent for all MOTs? such as Pick up and Ship to location --> apply for all modes?

Q8. If we combine all modes, then drop down list of address should be all for all modes? or we have to narrow list of address for dom only when Truck dom is selected?

Q9. Currently create shipment Truck DOM - one line item = 1 CT (work well for TMS). for International--> what should it be (Will we use Descarte system for routing shipment same as TMS? and how as one CT can have many lines items? Should each line = each CT then Jaguar consolidates all the CT (line items) together to ship together by group/master?

Q10. Cont Tab for each mode for i-portal? not on one page--> separate shipment detail for each mode on Cont tab?

  • Any fields should be there for MOT selected? as Air and Ocean modes--> require fields can be different, should we make it common for both Air and Ocean?

Q11. Planner role: What is the process of this role for i-portal? what are the process of approvals? such as auto approval, etc?

Q12. Summary, What data feed from POEM and what process should change? such as the submission for QTY...detail of shipments....how to separate what is a part of POEM and I-portal? POEM Feed with submission ability for Shipper...if POEM not feed, shipper should create shipment from scratch like currently Truck Dom?

Q13. Shipment detail for edit or from data feed from POEM (must include in each mode for shipper and planner?)

  • FCL
  • Container#
  • Seal#
  • Size
  • Type
  • Est collection
  • Act collection
  • Request deliver
  • Act deliver
  • PO
  • SKU
  • QTY
  • Ttl# of Plts
  • Ttl PKG on plt
  • Loose PKGs
  • Ttl GW KG/LB
  • Piece price
  • total value
  • Stackable
  • Haz/non-haz
  • Ttl HU
  • CBM
  • VIEW EXP
  • streamshipline
  • booking#
  • Master BOL
  • HBOL
  • Origin terminal
  • Est/Act
  • Port of lading
  • Est/Act
  • Port of discharge
  • Est/Act
  • Destination Terminal
  • Any standard/common info for Cont tab for different modes if we allow shipper to assign MOT (air/ocean) as line by line can be different mode within one creation from shipper.
Personal tools