Rates DB (MAIN WIKI)

From UG

Contents 1 Info 2 Business Analysis and Requirements 3 Business Information 4 Pre Implementation Architect Notes 5 Implementation Notes 6 Post Implementation Architect Notes

Info

0002690: [Rates DB] ..... <project>

Business Analysis and Requirements

To be written by BA. This section should cover Needs, Requirements, Background and Design Ideas. Also could include Glossary, existing business workflow, cases, etc

"Rates DB" is a code name for tariff and contract management system with additional functionality that will affect multiple modules of CT2.

Business Information

It is required to create a data base that would maintain rates for each MOT.

• Ocean FCL
• Ocean LCL
• Air
• Trucking
• Customs

The database would be used for various reasons

• Generating Sales Quotes
  • Searched by Customers for general rates
  • Searched by Customers for customer specific rates
  • Searched by Jaguar employees to generate for Customers and enable overseas office to access rates.
• Searching Costs
  • Searched by Jaguar employees to
    • Quote costs
    • Compare costs
• Searching Carriers
  • Searched by Jaguar employees to compare carriers
  • History searched by Jaguar employees to better negotiate future rates
• Estimation of CT costs
• Estimate sales invoice with possible auto generation.

Main Features:

• management of tariffs and contracts (client and vendor sides)
• "Quotations" web portal for sales
• Automated population of charge table in "sales invoices"
• Automated calculation of "estimated cost and sale" for a shipment
• Etc

Pre Implementation Architect Notes

Written by Architect after previous section is completed.

Implementation Notes

To be written by Developer or BA by the time UAT is completed. Briefly defines what was implemented and how.

Post Implementation Architect Notes

Written by Architect after previous section is completed.