8_S-DASOBO-00008678_RFP_Attachment_H_DSSC_SOLUTION REQUIREMENTS- corrected.xlsx
XLSX spreadsheet 198 KB Posted
- Attached to
- Web-based Software as a Service (SaaS) Solution - OLCC Integrated Distilled Spirits Supply Chain
- Solicitation number
- S-DASOBO-00008678
- Issued by
- Marion County, Oregon
About this file
This document is a Request for Proposal (RFP) for a Web-based Software as a Service (SaaS) solution for an Integrated Distilled Spirits Supply Chain for the Oregon Liquor and Cannabis Commission (OLCC). The RFP is being issued by the State of Oregon Department of Administrative Services (DAS) and OLCC. The solution will deliver the system, services, and any goods (e.g., hardware and equipment) necessary for the OLCC to meet the goals of the Distilled Spirits program. The scope includes provisions for product catalog management, ordering, inventory management, sales reporting, financial services, and carrier freight billing. The RFP is open to all qualified vendors, and responses are due by a specified date. The contract resulting from this RFP will be for an initial term with renewal options.
The RFP does not provide specifics on pricing terms, set asides, incumbents, or funding sources. However, it does indicate that the solution must comply with various state statutes, regulations, and accounting standards, as well as integrate with the Oregon Statewide Financial Management System (SFMS). The solution must also provide robust security, data management, and system performance capabilities to support the OLCC's operational needs.
View the file
Other files
Show all 19
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Instructions
| Distilled Spirits Supply Chain |
| Proposer Instructions - Responding to Attachment H |
Proposer Name:
| Table of Contents | Requirement Line Items (RLI) | |||
| Tab No. | Requirements Functional Area | Number of Requirements | Category Name | # of RLI |
| 1 | Instructions Tab | 0 | Agent & Store Management | 77 |
| 2 | Glossary of Terms | 0 | All Systems | 111 |
| 3 | Technical Business Functionality - High | 6,140 | Financial Management | 77 |
| 3 | Technical Business Functionality - Medium | 5,120 | Point of Sale | 131 |
| 3 | Technical Business Functionality - Low | 552 | Supply Chain | 140 |
| Total Requirements | 11,812 | Warehouse Management | 153 | |
| Communication | 3 | |||
| TOTAL RLI | 692 | |||
| Instructions: Enter Proposer name on Line 5 in the Instructions Tab. |
In columns J, K, L on Requirements Tab, select either "Yes" or "No" from the drop down menu to indicate the system(s) in which the requirement will be met.
Provide a response indicator in the column titled "Proposer Response" based on the description of indicators below. For each requirement, utilize the Proposer Comments, Descriptions, and Explanation field to provide additional information. If a proposer plans to meet a requirement using a third-party application, describe how the requirement will be met.
| Meets with base system functionality, no modification required | Feature/Function is included in the base solution (out of the box functionality) |
| Meets with configuration (either via customer or vendor) | COTS Solution compliant via configuration either by “Customer configuration option” (by customer) or by "Vendor configuration option" (by vendor) |
| Meets with customization (changes to source code) | Feature/function will be available by the proposed go-live date of the planned phase via minimal changes to the source code |
| New development required (by vendor) | Feature/function requires significant new development not provided by out of the box functionality that will be available within the proposed go-live date of the planned phase. |
| Planned in a future release | Feature/function is identified to be included in a future planned release by vendor, but not by the proposed go-live date of the planned phase (include when the new release is expected to be available) |
| Functionality cannot be met | Feature/function cannot be provided. |
Proposers stating that functions will be supplied will be contractually obligated to warrant their claim. In the event that such functionality is not available in the current release, the Proposer will be liable for any additional services and/or costs associated with developing or procuring such functionality.
Any modification to this workbook outside of the "Proposer Response" and "Proposer Comments, Descriptions, and Explanation" fields is an automatic disqualification from the Request for Proposal.
| Prioritization of Requirements | |
| High | A Critical requirement without which the product is not acceptable to the stakeholders. |
| Medium | A necessary but deferrable requirement which makes the product less usable but still functional. |
| Low | A nice feature to have if there are resources but the product functions well without it. |
Proposer’s response to the Requirements will be scored on a point scale based on the ability of Proposer to deliver functionality. The following range of points will be given, factoring priority, and Proposer’s ability to deliver a Solution providing the function, and related effort to deliver.
| Point Scale | ||||
| Point Scale | High | Medium | Low | |
| Meets with base system functionality, no modification required | 20 | 16 | 8 | |
| Meets with configuration (either via customer or vendor) | 16 | 12 | 6 | |
| Meets with customization (minimal changes to source code) | 12 | 8 | 4 | |
| New development required (by vendor) | 8 | 4 | 2 | |
| Planned in a future release | 2 | 2 | 1 | |
| Functionality cannot be met | 0 | 0 | 0 |
Glossary
| Glossary of Terms | |||
| Term/ Acronym | Description | Notes | |
| ACH | Automated Clearing House | ||
| The ACH Network is the electronic payment-transfer system run by the National Automated Clearing House Association (Nacha) | AKA: Electronic Funds Transfer | ||
| Advanced Notification | Shipping notification from vendor of what will be in a shipment | ||
| Agency | OLCC, the state Agency procuring and implementing the solution(s) | For the purposes of this document, Agency always and only refers to the Oregon State Agency OLLC | |
| Agent Evaluation | Annual evaluation, conducted by the OLCC, of Liquor Store sales/store performance | ||
| Audit Trail | Data trail associated with internal quality and compliance controls; activity logging | Ex: the name of person and date a data item was entered or changed | |
| Inventory Auditing | Liquor store and OLCC warehouse inventory auditing | ||
| Bailment | Inventory owned by Distilled Spirits Suppliers and held in OLCC warehouse. This is a virtual designation within tracking systems (inventory is purchased by OLCC when it is Picked for an outgoing order to a Liquor Store) | Items are only in bailment until withdrawn or removed from bailment | |
| Bailment Withdrawal | Items removed from the OLCC warehouse (bailment) and shipped to Liquor Stores | ||
| Bank Advice | Document provided by treasury, backups for debits / credits issued | ||
| BOL | Bill of Lading | ||
| Special Order | Special Orders | ||
| Special order requests from customers to Liquor Stores for a new item not currently listed by the OLCC. Any item not currently stocked in the warehouse is a 'Specialty Item'. Specialty Items are requested through the Special Order process | AKA: Customer Request Order | ||
| CRV | Container Recovery Value (Bottle Deposit) | ||
| CTR | Claims Transfer Returns (Financial and Distribution) | ||
| Cycle Count | Standard industry naming for the ability to count physical inventory and update associated systems | ||
| Deposit Error | Created to record an over payment or short payment, to the OLCC, of Liquor or Distillery Agent sales | ||
| Distilled Spirits Supplier | Any vendor, supplier or manufacturer who supplies distilled spirits to OLCC or requests spirits samples from OLCC | AKA: Distillery Vendor, Manufacturer, Supplier | |
| Distillery Agent | An individual or business entity with a Distillery License. A person or business entity with a license allowing production and bottling of distilled spirits | AKA: Distillery Representative, Distillery Retail Outlet Agent |
A Distillery Agent can only sell if they have a license AND a Distillery Retail Outlet Agreement, which allows sales of spirits A Distillery can sell to the public in their tasting room ONLY if they ALSO have a Distillery Outlet Agreement A type of 'Licensee'
| Distillery Retail Outlet | A physical location used by a Distillery Agent to sell distilled spirits | |
| EDI | Electronic Data Interface | |
| ERP | Enterprise Resource Planning System | |
| Freight Carrier | Inbound or outbound freight shipping company (see inbound/outbound definitions) | Inbound: Freight carrier contracted/hired/managed by distilled spirits suppliers that delivers distilled spirits to OLCC warehouse |
Outbound: Freight carrier contracted by OLCC to pick up product from OLCC warehouse and deliver to Liquor Agents
| Incident | Any carrier issue (inbound delivery to OLCC warehouse) or transportation claim (outbound delivery to Liquor Store) |
| Invoice | A bill showing an amount due or payment made |
| Licensee | A business entity or person with an OLCC liquor license |
Licensee includes ALL OLCC license types: Brew pubs, wineries, On-Premise, distilleries, Off-Premise, etc.
Liquor Agent A person or business entity acting as an independent contractor authorized by OLCC to sell distilled spirits at a specific location A Liquor Agent may or may not ALSO be a Licensee AKA: Retail Liquor Agent, Retail Sales Agent, Agent, Liquor Store Agent Liquor Store A physical location (store front) used by a Liquor Agent for the sale of distilled spirits Liquor Stores were formerly referred to as "agencies", a term that was often confused with state agencies and supported the misconception that liquor stores were state stores, not independent contractors.
For the purposes of this document, Agency always and only refers to the Oregon State Agency OLLC
| NACHA | National Automated Clearing House Association |
| NBV | Non Budget Voucher |
All non-budgeted purchases
| Non-Distilled Spirits Items | Any item sold in Liquor Stores that is not a distilled spirits product | |
| Non-Liquor Agent | Buyers authorized to purchase spirits from the OLCC warehouse who are not Liquor Agents | Buyer types include Casinos, military, airlines, etc. |
| NSF | Non-Sufficient Funds |
Any returned item is an NSF (legal line difference, refer to maker, closed account, hold on account, etc.)
OLCC Oregon Liquor and Cannabis Commission An agency within Oregon State Government
| Onpack | Promotional item added to a distilled spirits package, such as a shot glass | |
| Order Guide | A predefined list of items that customers can order on a regular basis. Order guides enable you to add any or all of the predefined items in bulk to a sales order. | Items not listed on the Order Guide can still be ordered by a Licensee using the CRO process |
| OST | Oregon State Treasury | |
| PCI | Payment Card Industry |
PCI Compliance is based on standards developed by the PCI Security Standards Council.
| Pick | Selection of distilled spirits cases or individual bottle for order fulfillment | |
| POS | Point of Sale System | |
| Quote | Request from a distilled spirits provider to add a new item (product), update item attributes, or change item pricing | |
| Replenishment Request | Request to a Distilled Spirits Supplier to replenish inventory in the OLCC warehouse | |
| Sample Request | Request from a distilled spirits provider to purchase sample inventory from the OLCC warehouse | |
| SCC | Shipping Container Code: A 14-digit barcode placed on the outside of a shipping carton or pallet | |
| SFMA | Statewide Financial Management Application | |
| SFMS | Statewide Financial Management Services | |
| TIN | Trade identification Number | |
| Unique identification number used to identify and track the case or pallet through its movement in the warehouse | Used for WHM & WMS. When the product is received a physical label is placed on the case or pallet to track its movement in the inventory system. | |
| Transportation Claim | Claims triggered by product damage during transportation between OLCC warehouse and store receipt. | |
| UPC | Universal Product Code |
A machine-readable barcode and the unique 12-digit number beneath it
| Wave | Industry standard name for the ability to sequence orders for preparation and loading for shipping |
| WHM | Warehouse Management |
| WMS | Warehouse Management Solution |
Requirements
| ID | Category | Subcategory | Short Name | Description | Priority | Functional / Non-Functional | Proposer Response | Proposer Comments, Descriptions, and Explanation | WMS | ERP | POS | Score | Total Score | |
| Agent and Store Mgmt | ||||||||||||||
| AGAC-01 | Agent and Store Mgmt | Agent Account | Agent Account | Solution provides the ability for OLCC staff to create a Liquor Agent account | High | Non-Functional | 0 | Yes | ||||||
| AGAC-02 | Agent and Store Mgmt | Agent Account | Agent Online Access | Solution provides the ability for Liquor Agents to access their accounts online | High | Non-Functional | No | |||||||
| AGAC-03 | Agent and Store Mgmt | Agent Account | Update Agent Account | Solution provides the ability for Liquor Agents to update their account information | Medium | Non-Functional | ||||||||
| AGAC-04 | Agent and Store Mgmt | Agent Account | Upload Documents to Agent Account | Solution provides the ability to upload documents to a Liquor Agent account | Medium | Non-Functional | ||||||||
| AGAC-05 | Agent and Store Mgmt | Agent Account | Approve/Reject Account Updates | Solution provides the ability for OLCC staff to approve/reject Liquor Agent account updates | Medium | Non-Functional | ||||||||
| AGAC-06 | Agent and Store Mgmt | Agent Account | OLCC Edit Agent Account | Solution provides the ability for OLCC to edit Liquor Agent account information | Medium | Non-Functional | ||||||||
| AGAC-07 | Agent and Store Mgmt | Agent Account | View Agent Account | Solution provides the ability to search for and view Liquor Agent accounts | High | Non-Functional | ||||||||
| AGAC-08 | Agent and Store Mgmt | Agent Account | Deactivate Agent Account | Solution provides the ability to deactivate a Liquor Agent account | High | Non-Functional | ||||||||
| AGDB-01 | Agent and Store Mgmt | Agent Dashboard | Agent Dashboard | Solution provides the ability to display a dashboard for authenticated Liquor Agents which includes: store(s) total sales, inventory, state-wide comparisons, trends, product category, SKUs, and item level data | Medium | Functional | ||||||||
| AGDB-02 | Agent and Store Mgmt | Agent Dashboard | Distilled Spirits and Non-Distilled Spirits Items | Solution provides the ability to display sales data for distilled spirits and Non-Distilled Spirits Items on Liquor Agent dashboard | Medium | Functional | ||||||||
| AGDB-03 | Agent and Store Mgmt | Agent Dashboard | Highlights KPIs | Solution provides the ability to display Liquor Agent KPI data on Liquor Agent dashboard | Medium | Functional | ||||||||
| AGDB-04 | Agent and Store Mgmt | Agent Dashboard | Agent Portal Banner | Solution provides the ability to display alerts/banners to Liquor Agents | Medium | Functional | ||||||||
| AGDB-05 | Agent and Store Mgmt | Agent Dashboard | Create/Update Banners | Solution provides the ability to create/update/remove banner messages | Medium | Functional | ||||||||
| AGDB-06 | Agent and Store Mgmt | Agent Dashboard | Automated Alerts | Solution provides the ability to display automated alerts to Liquor Agents | Medium | Functional | ||||||||
| AGDB-07 | Agent and Store Mgmt | Agent Dashboard | Banners Displayed by Time/Date Span | Solution provides the ability to pre-set begin and end date for specified banner displays | Medium | Functional | ||||||||
| AGDB-08 | Agent and Store Mgmt | Agent Dashboard | Liquor Agents by Group | Solution provides the ability to display banners to all Liquor Agents within a specified district/geography | Medium | Functional | ||||||||
| AGDB-09 | Agent and Store Mgmt | Agent Dashboard | Resignation | Solution provides the ability for Liquor Agent to submit resignation | Low | Functional | ||||||||
| AGDB-09.1 | Agent and Store Mgmt | Agent Dashboard | Transfer Ownership | Solution provides the ability for Liquor Agent to request a transfer of ownership | Low | Functional | ||||||||
| AGDB-10 | Agent and Store Mgmt | Agent Dashboard | Store Relocation Notification | Solution provides the ability for Liquor Agent to request a store relocation | Low | Functional | ||||||||
| AGDB-11 | Agent and Store Mgmt | Agent Dashboard | Non-Compete | Solution provides the ability for resigning Liquor Agent to agree to non-compete agreement | Low | Functional | ||||||||
| AGDB-12 | Agent and Store Mgmt | Agent Dashboard | Submit Change for Internal Product Catalog | Solution provides the ability for Liquor Agents to request changes to the distilled spirits product catalog | Low | Functional | ||||||||
| AGDB-14 | Agent and Store Mgmt | Action Request | Action Request | Solution provides the ability for OLCC staff to request an action from a Liquor Agent | High | Functional | ||||||||
| AGDB-15 | Agent and Store Mgmt | Action Request | Notify Agent of Action Request | Solution notifies Liquor Agent when an action request is created for the Liquor Agent | Medium | Functional | ||||||||
| AGDB-16 | Agent and Store Mgmt | Action Request | Respond to Action Request | Solution provides the ability for Liquor Agent to respond to an action request | Medium | Functional | ||||||||
| AGDB-17 | Agent and Store Mgmt | Action Request | Update Action Request | Solution provides the ability for OLCC staff to update action requests | Medium | Functional | ||||||||
| AGDB-18 | Agent and Store Mgmt | Action Request | View Action Request | Solution provides the ability for OLCC staff to view action requests | Medium | Functional | ||||||||
| AGDB-19 | Agent and Store Mgmt | Action Request | Close Action Request | Solution provides the ability for OLCC staff to close an action request | Medium | Functional | ||||||||
| AGMT-01 | Agent and Store Mgmt | Agent Evaluation | Agent Evaluation | Solution provides the ability to manage Liquor Agent Evaluations | Medium | Functional | ||||||||
| AGMT-02 | Agent and Store Mgmt | Agent Evaluation | Auto-Populate Agent Information | Solution auto-populates evaluation with Liquor Agent name, store number, and store location | Medium | Functional | ||||||||
| AGMT-03 | Agent and Store Mgmt | Agent Evaluation | Auto-Populate Financial Services Information | Solution auto-populates financial information into Liquor Agent Evaluation, including Inventory Audit information, late or missing weekly reports, Deposit Errors, and late deposits | Medium | Functional | ||||||||
| AGMT-04 | Agent and Store Mgmt | Agent Evaluation | Auto-Populate Prior Evaluation Information | Solution auto-populates information from most recent Liquor Agent Evaluation into the new evaluation | Medium | Functional | ||||||||
| AGMT-05 | Agent and Store Mgmt | Agent Evaluation | Auto-Populate Warehouse Information | Solution auto-populates warehouse information into Liquor Agent Evaluation, including late orders and repack information | Medium | Functional | ||||||||
| AGMT-06 | Agent and Store Mgmt | Agent Evaluation | Comments | Solution provides the ability to enter evaluation comments | Medium | Functional | ||||||||
| AGMT-07 | Agent and Store Mgmt | Agent Evaluation | Canned Comments | Solution provides the ability to select from a list of canned comments | Medium | Functional | ||||||||
| AGMT-08 | Agent and Store Mgmt | Agent Evaluation | Sales Review | Solution provides the ability to display sales summary reports in the Liquor Agent Evaluation | Medium | Functional | ||||||||
| AGMT-09 | Agent and Store Mgmt | Agent Evaluation | Scoring by Evaluation Categories | Solution provides evaluation scoring by pre-determined categories | Medium | Functional | ||||||||
| AGMT-10 | Agent and Store Mgmt | Agent Evaluation | Scoring by Evaluation Sub-Categories | Solution provides evaluation scoring by pre-determined sub-categories | Medium | Functional | ||||||||
| AGMT-11 | Agent and Store Mgmt | Agent Evaluation | Corrective Action Comments | Solution provides the ability to enter corrective action comments | Medium | Functional | ||||||||
| AGMT-12 | Agent and Store Mgmt | Agent Evaluation | Corrective Actions | Solution provides the ability to select corrective actions for evaluation categories | Medium | Functional | ||||||||
| AGMT-13 | Agent and Store Mgmt | Agent Evaluation | View Completed Evaluation | Solution provides the ability for a Liquor Agent to view a completed Liquor Agent Evaluation | Medium | Functional | ||||||||
| AGMT-14 | Agent and Store Mgmt | Agent Evaluation | Evaluation E-Signature | Solution provides the ability for a Liquor Agent to electronically sign a Liquor Agent Evaluation | Low | Functional | ||||||||
| DV-01 | Agent and Store Mgmt | Data View | Data View | Solution provides the ability to do ad hoc search, sort, and view of Liquor Agent and store data | High | Functional | ||||||||
| DV-02 | Agent and Store Mgmt | Data View | Monthly Compensation | Solution provides the ability for a Liquor Agent to view monthly OLCC compensation details | Medium | Functional | ||||||||
| DV-03 | Agent and Store Mgmt | Data View | Historical Price Changes | Solution provides the ability to view historical price changes for each item | Medium | Functional | ||||||||
| DV-04 | Agent and Store Mgmt | Data View | Sales Trends | Solution provides the ability to view sales trends by product category, date, month, year, region, and store size | Medium | Functional | ||||||||
| LSA-01 | Agent and Store Mgmt | Liquor Store Auditing | Liquor Store Auditing | Solution provides a mechanism for inventory auditing of distilled spirits at liquor stores | High | Functional | ||||||||
| LSA-02 | Agent and Store Mgmt | Liquor Store Auditing | Scan Items | Solution provides the ability to scan item SKUs with a handheld device | High | Functional | ||||||||
| LSA-03 | Agent and Store Mgmt | Liquor Store Auditing | Inventory Audit | Solution provides the ability record liquor store inventory data in near real time with a handheld device | High | Functional | ||||||||
| LSA-04 | Agent and Store Mgmt | Liquor Store Auditing | Track Store Audit Results | Solution provides the ability to track inventory audit results for each store | High | Functional | ||||||||
| LSA-05 | Agent and Store Mgmt | Liquor Store Auditing | Final Audit | Solution provides the ability to complete a final inventory audit for a liquor store that is permanently closing or changing ownership | High | Functional | ||||||||
| LSA-06 | Agent and Store Mgmt | Liquor Store Auditing | Audit Reconciliation | Solution provides the ability to compare real-time POS inventory data to handheld device data while at the Liquor Store | High | Functional | ||||||||
| LSA-07 | Agent and Store Mgmt | Liquor Store Auditing | Audit Variance | Solution provides the ability to validate variances discovered during Audit Reconciliation prior to posting changes to Liquor Store's POS | High | Functional | ||||||||
| RT-01 | Agent and Store Mgmt | Returns | Returns | Solution provides the ability to manage distilled spirits items which are returned from a liquor store to the OLCC warehouse | High | Functional | ||||||||
| RT-02 | Agent and Store Mgmt | Returns | Request Returns | Solution provides the ability for a Liquor Agent to request to return distilled spirits items to the warehouse | High | Functional | ||||||||
| RT-03 | Agent and Store Mgmt | Returns | Approved Returned Items List | Solution provides the ability for OLCC staff to approve or deny distilled spirits items for return to the warehouse | Medium | Functional | ||||||||
| RT-04 | Agent and Store Mgmt | Returns | Notify Financial Services of Authorized Return | Solution notifies financial services when an item return is approved by retail services | Medium | Functional | ||||||||
| RT-05 | Agent and Store Mgmt | Returns | Notify Liquor Agent of Return Invoice | Solution notifies Liquor Agent of a completed return Invoice | Medium | Functional | ||||||||
| RT-06 | Agent and Store Mgmt | Returns | Update Expected Store Inventory | Solution provides the ability to adjust store inventory when items are returned | High | Functional | ||||||||
| STPR-01 | Agent and Store Mgmt | Store Profile | Store Profile | Solution provides the ability to create a store profile | High | Functional | ||||||||
| STPR-02 | Agent and Store Mgmt | Store Profile | Associate Agents to Stores | Solution provides the ability to associate a Liquor Agent account with one or more store profiles | Medium | Functional | ||||||||
| STPR-03 | Agent and Store Mgmt | Store Profile | Edit Store Profile | Solution provides the ability for assigned Liquor Agent to edit store profile information | Medium | Functional | ||||||||
| STPR-04 | Agent and Store Mgmt | Store Profile | Approve/Reject Store Profile Updates | Solution provides the ability for OLCC staff to approve/reject store profile updates | Medium | Functional | ||||||||
| STPR-05 | Agent and Store Mgmt | Store Profile | OLCC Edit Store Profile | Solution provides the ability for OLCC to edit store profile information | Medium | Functional | ||||||||
| STPR-06 | Agent and Store Mgmt | Store Profile | Upload Documents to Store Profile | Solution provides the ability to upload documents to a store profile | Medium | Functional | ||||||||
| STPR-07 | Agent and Store Mgmt | Store Profile | Track Insurance | Solution provides the ability to track store insurance information | Medium | Functional | ||||||||
| STPR-08 | Agent and Store Mgmt | Store Profile | Track Store History | Solution provides the ability to track store history (owner, violations, Inventory Audit shortages/overages) per retention schedule | Medium | Functional | ||||||||
| STPR-09 | Agent and Store Mgmt | Store Profile | Manage Relocation Information | Solution allows OLCC to enter and manage store relocation | Low | Functional | ||||||||
| STPR-10 | Agent and Store Mgmt | Store Profile | Track Store Relocation Input | Solution allows OLCC to enter/track input received from public associated with store relocation | Low | Functional | ||||||||
| STRC-01 | Agent and Store Mgmt | Store Report Card | Store Report Card | Solution provides the ability to create a monthly evaluation report for each store (report card) | High | Functional | ||||||||
| STRC-02 | Agent and Store Mgmt | Store Report Card | Top Selling Categories | Solution provides the ability to display top selling categories by store, city, state, district, county, or region on store report card | Medium | Functional | ||||||||
| STRC-03 | Agent and Store Mgmt | Store Report Card | Top Selling Brands | Solution provides the ability to display top selling brands by store, city, state, district, county, or region on store report card | Medium | Functional | ||||||||
| STRC-04 | Agent and Store Mgmt | Store Report Card | Top Selling SKUs | Solution provides the ability to display top selling SKUs by store, city, state, district, county, or region on store report card | Medium | Functional | ||||||||
| STRC-05 | Agent and Store Mgmt | Store Report Card | Missing Top Selling Items | Solution provides the ability to identify high volume selling SKUs which the store is not carrying on store report card | Medium | Functional | ||||||||
| STRC-06 | Agent and Store Mgmt | Store Report Card | Under Selling Items | Solution provides the ability to identify items carried by the store which are under selling | Medium | Functional | ||||||||
| STTR-01 | Agent and Store Mgmt | Store to Store Transfer | Store to Store Transfer | Solution provides the ability for a Liquor Agent to create a transfer of distilled spirits items from one store to another | Medium | Functional | ||||||||
| STTR-02 | Agent and Store Mgmt | Store to Store Transfer | Approve/Deny Transfer Request | Solution provides the ability for OLCC staff to approve or deny a store-to-store transfer when a conflict occurs | Medium | Functional | ||||||||
| STTR-03 | Agent and Store Mgmt | Store to Store Transfer | Delivery Tracking Transfer Request | Solution provides the ability to record confirmation of delivery for store-to-store transfers | Medium | Functional | ||||||||
| All Systems | ||||||||||||||
| ACSE-01 | All Systems | Access & Security | Access & Security | Solution provides the ability for OLCC staff to request an account login | High | Non-Functional | ||||||||
| ACSE-02 | All Systems | Access & Security | Staff Account Management | Solution provides the ability for OLCC authorized staff to create other OLCC staff accounts | High | Non-Functional | ||||||||
| ACSE-03 | All Systems | Access & Security | Account Require Password and Login ID | Solution provides a unique account login ID and password for each user | High | Non-Functional | ||||||||
| ACSE-04 | All Systems | Access & Security | Public Accounts | Solution provides the ability for users external to OLCC to request an account login | High | Non-Functional | ||||||||
| ACSE-05 | All Systems | Access & Security | Acknowledge System Usage Rules | Solution provides an end user agreement for all public account registrants | High | Non-Functional | ||||||||
| ACSE-06 | All Systems | Access & Security | Review Account Set-Up Requests | Solution provides authorized OLCC staff the ability to approve or deny requests to create an account login, for internal and external users | High | Non-Functional | ||||||||
| ACSE-07 | All Systems | Access & Security | Admin | Solution provides the ability for OLCC staff to activate, deactivate, or lock/unlock user accounts | High | Non-Functional | ||||||||
| ACSE-08 | All Systems | Access & Security | Reactivate Accounts | Solution provides the ability to reactivate deactivated accounts | High | Non-Functional | ||||||||
| ACSE-09 | All Systems | Access & Security | Enforce Strong Passwords | Solution enforces strong/complex passwords | High | Non-Functional | ||||||||
| ACSE-10 | All Systems | Access & Security | Encrypt Passwords | Solution encrypts stored passwords | High | Non-Functional | ||||||||
| ACSE-11 | All Systems | Access & Security | Login/Password Security | Solution protects against password hacking | High | Non-Functional | ||||||||
| ACSE-12 | All Systems | Access & Security | Password Protection | Solution protects passwords during entry (obfuscating typing) | High | Non-Functional | ||||||||
| ACSE-12.1 | All Systems | Access & Security | MFA | Solution supports multi-factor authentication | Medium | Non-Functional | ||||||||
| ACSE-13 | All Systems | Access & Security | User Roles | Solution provides the ability to create multiple roles with different permissions and access levels | High | Non-Functional | ||||||||
| ACSE-14 | All Systems | Access & Security | Role Management | Solution provides authorized users administrative control to set user roles and permissions | High | Non-Functional | ||||||||
| ACSE-15 | All Systems | Access & Security | Account Holder Update Capability | Solution provides the ability for account holder to update account information | High | Non-Functional | ||||||||
| ACSE-16 | All Systems | Access & Security | View Users | Solution provides the ability for OLCC staff user to view list of users and roles | High | Non-Functional | ||||||||
| ACSE-17 | All Systems | Access & Security | Staff Update Account Information | Solution provides the ability for OLCC staff to update account information | High | Non-Functional | ||||||||
| ACSE-18 | All Systems | Access & Security | Notify Account Holder of Changes to Account | Solution notifies account holder when account information is updated | High | Non-Functional | ||||||||
| ACSE-19 | All Systems | Access & Security | Self-Service Passwords | Solution provides the ability for users to reset their passwords | High | Non-Functional | ||||||||
| ACSE-20 | All Systems | Access & Security | Password Admin | Solution provides the ability for admin users to reset user passwords | High | Non-Functional | ||||||||
| ACSE-21 | All Systems | Access & Security | Session Management | Solution provides session management for authenticated users | High | Non-Functional | ||||||||
| ACSE-22 | All Systems | Access & Security | Session Management: Logout | Solution provides the ability to logout | High | Non-Functional | ||||||||
| ACSE-23 | All Systems | Access & Security | Session Management: Session Timeout | Solution provides a configurable session time-out | High | Non-Functional | ||||||||
| ACSE-23.1 | All Systems | Access & Security | Timeout Alert | Solution alerts users prior to timeout | Medium | Non-Functional | ||||||||
| ACSE-23.2 | All Systems | Access & Security | Timeout Reset | Solution provides the ability for users to reset session timeout | Medium | Non-Functional | ||||||||
| ACSE-23.3 | All Systems | Access & Security | Timeout | Solution ends user's session when timeout period has expired | Medium | Non-Functional | ||||||||
| ACSE-23.4 | All Systems | Access & Security | Automatic Account Lockout | Solution provides the ability to automatically lock a user account when the number of unsuccessful log in attempts exceeds the lockout threshold | High | Non-Functional | ||||||||
| ACSE-24 | All Systems | Access & Security | Indicate Sensitive Data | Solution provides the ability to flag specific data elements and tables as containing sensitive or protected data | High | Non-Functional | ||||||||
| ACSE-25 | All Systems | Access & Security | Protect Sensitive Data | Solution provides methods to protect sensitive or protected data from access by unauthorized people | High | Non-Functional | ||||||||
| ACSE-26 | All Systems | Access & Security | Provide Interface/API | Solution provides the ability to send, request, and receive information from external systems via current industry standard APIs (SOAP, XML-RPC, JSON-RPC, REST) | High | Non-Functional | ||||||||
| ACSE-27 | All Systems | Access & Security | Data Encryption at Rest and in Transit | Solution encrypts sensitive data both at rest and during transmission to ensure protection from unauthorized access or interception | High | Non-Functional | ||||||||
| ACSE-28 | All Systems | Access & Security | Incident Response | Solution provides mechanisms to detect, report, and respond to security incidents or breaches, in order to limit damage and reduce recovery time and costs | High | Non-Functional | ||||||||
| ANRP-01 | All Systems | Analytics/Reporting | Analytics/Reporting | Solution provides the ability to create, manage, and view ad hoc reports | High | Non-Functional | ||||||||
| ANRP-01.1 | All Systems | Analytics/Reporting | Filter Values | Solution provides the ability to filter reports based upon user-defined criteria | Medium | Non-Functional | ||||||||
| ANRP-01.2 | All Systems | Analytics/Reporting | Report Time Limits | Solution provides the ability to define limits on the time a report or query takes to execute and the number of records to be retrieved | Medium | Non-Functional | ||||||||
| ANRP-02 | All Systems | Analytics/Reporting | Tableau | Solution provides the ability to interface with Tableau | Medium | Non-Functional | ||||||||
| ANRP-03 | All Systems | Analytics/Reporting | Business Objects | Solution provides the ability to interface with Business Objects | Medium | Non-Functional | ||||||||
| ANRP-04 | All Systems | Analytics/Reporting | Data Store | Solution provides a data warehouse for reporting | High | Non-Functional | ||||||||
| ANRP-05 | All Systems | Analytics/Reporting | Data Access | Solution provides the ability to access all data for Agency's data analysis | High | Non-Functional | ||||||||
| ANRP-06 | All Systems | Analytics/Reporting | Export/Download | Solution provides the ability to export/download all reports as Excel and CVS files | High | Non-Functional | ||||||||
| ANRP-06.1 | All Systems | Analytics/Reporting | Reporting Templates | Solution provides standard ad hoc reporting templates and allow users to create new reporting templates | Medium | Non-Functional | ||||||||
| ANRP-07 | All Systems | Analytics/Reporting | Save Reports | Solution provides the ability to save ad hoc reports | High | Non-Functional | ||||||||
| ANRP-08 | All Systems | Analytics/Reporting | Refresh Save Reports | Solution provides the ability to refresh saved reports with current data | High | Non-Functional | ||||||||
| ANRP-08.1 | All Systems | Analytics/Reporting | Edit Save Reports | Solution provides the ability to edit saved reports | High | Non-Functional | ||||||||
| ANRP-09 | All Systems | Analytics/Reporting | Share Reports | Solution provides the ability to share saved reports with other users | Medium | Non-Functional | ||||||||
| ANRP-10 | All Systems | Analytics/Reporting | KPI Data | Solution provides the ability to report on Key Performance Indicators | Medium | Non-Functional | ||||||||
| ANRP-10.1 | All Systems | Analytics/Reporting | Reporting Dashboards | Solution provides the ability to build/configure reporting dashboards | Medium | Non-Functional | ||||||||
| ANRP-11 | All Systems | Analytics/Reporting | Near Real-Time Data Reporting | Solution provides the ability to report on near-real-time data | High | Non-Functional | ||||||||
| ANRP-12 | All Systems | Analytics/Reporting | Point-in-Time Data | Solution provides the ability to generate a report for a specified time period | Medium | Non-Functional | ||||||||
| ANRP-13 | All Systems | Analytics/Reporting | Scheduled Reports | Solution provides the ability to automatically generate reports on a pre-set day/date/time schedule | Low | Non-Functional | ||||||||
| ANRP-14 | All Systems | Analytics/Reporting | Scheduling by Staff | Solution provides the ability for OLCC staff users to schedule report generation | High | Non-Functional | ||||||||
| ANRP-15 | All Systems | Analytics/Reporting | Scheduled Reports Saved on Network | Solution provides the ability to save generated scheduled reports to a specified internal network locations | Low | Non-Functional | ||||||||
| ANRP-16 | All Systems | Analytics/Reporting | Data Import/Export | Solution supports the ability to port data in and out of the system | High | Non-Functional | ||||||||
| ANRP-17 | All Systems | Analytics/Reporting | System Use Analytics | Solution allows authorized users to gather analytics about system use patterns | Medium | Non-Functional | ||||||||
| ANRP-18 | All Systems | Analytics/Reporting | Print Reports | Solution provides the ability to print all reports | High | Non-Functional | ||||||||
| AUDT-01 | All Systems | Auditing | Audit Trail | Solution captures an audit trail for user interactions with the system | High | Non-Functional | ||||||||
| AUDT-02 | All Systems | Auditing | System Logging | Solution provides tracking of data, transactions, history, changes and entries, including the date and person who made changes | High | Non-Functional | ||||||||
| AUDT-03 | All Systems | Auditing | Track Data Views | Solution provides the ability to track when sensitive or protected data is viewed by a user | High | Non-Functional | ||||||||
| AUDT-04 | All Systems | Auditing | System Communication | Solution logs system-generated communications in audit records | High | Non-Functional | ||||||||
| AUDT-05 | All Systems | Auditing | Note History | Solution records note history | High | Non-Functional | ||||||||
| AUDT-06 | All Systems | Auditing | History of Profile | Solution provides the ability to view history of account holder profile changes | High | Non-Functional | ||||||||
| AUDT-07 | All Systems | Auditing | Access to Audit Trail | Solution provides the ability to view the Audit Trail in read only mode | High | Non-Functional | ||||||||
| AUDT-08 | All Systems | Auditing | Protect Audit Trail | Solution prevents audit records from being deleted, or altered, by end users | High | Non-Functional | ||||||||
| AUDT-09 | All Systems | Auditing | Archive and Restore Audit Trail | Solution provides the ability to archive and restore audit logs | High | Non-Functional | ||||||||
| AUDT-10 | All Systems | Auditing | Log Invalid Access Attempts | Solution logs exceptions and invalid access attempts | High | Non-Functional | ||||||||
| CMPL-01 | All Systems | Compliance | Compliance | Solution complies with Generally Accepted Accounting Principles | High | Non-Functional | ||||||||
| CMPL-02 | All Systems | Compliance | Compliance: NACHA | Solution follows Oregon state statutes, NACHA, and other PCI-DSS regulations when collecting all payments | High | Non-Functional | ||||||||
| CMPL-03 | All Systems | Compliance | Compliance: OAM | Solution complies with requirements set forth in the Oregon Accounting Manual | High | Non-Functional | ||||||||
| CMPL-04 | All Systems | Compliance | Compliance: Oregon State Treasury Vendor Requirements | Solution supports compliance with OST FIN 214: Third Party Vendor Requirements (ORS 293.875 and ORS 352.135(3)) for any functionality that collects, stores, processes, transmits or otherwise provides certain cash management services on behalf of the Agency | High | Non-Functional | ||||||||
| CMPL-05 | All Systems | Compliance | Comply with Oregon Treasury (Alcohol) | Solution complies with Oregon State Treasury's Merchant Card Services Agreement and Public Fund Law (ORS 295 & ORS 293) | High | Non-Functional | ||||||||
| CMPL-06 | All Systems | Compliance | Align with Oregon State Information and Cyber Security Standards | Solution adheres to all State of Oregon information and cyber security standards | High | Non-Functional | ||||||||
| DE-01 | All Systems | Data Entry / Backup | Data Entry | Solution provides the ability to validate data when it is entered into the system | Medium | Functional | ||||||||
| DE-02 | All Systems | Data Entry / Backup | Data Rules | Solution provide the ability to create rules for each field/transaction type which determine whether data is required, optional or not allowed. | Medium | Functional | ||||||||
| DE-02.1 | All Systems | Data Entry / Backup | Send and Receive Batch Data Files | Solution provides the ability to send and receive batch data files | Medium | Functional | ||||||||
| DE-03 | All Systems | Data Entry / Backup | Validate Batch Data Files | Solution provides the ability to validate data received in batch files | Medium | Functional | ||||||||
| DE-04 | All Systems | Data Entry / Backup | Edit Invalid Batch File Data | Solution provides the ability to view and edit invalid batch file data | Medium | Functional | ||||||||
| DE-05 | All Systems | Data Entry / Backup | Re-start / Recycle Batch Transactions | Solution provides the ability to re-start/recycle rejected or errored adhoc/batch transactions | High | Functional | ||||||||
| DE-06 | All Systems | Data Entry / Backup | Data Precedence Rules | Solutions provides the ability to create data precedence rules | Medium | Functional | ||||||||
| DE-07 | All Systems | Data Entry / Backup | Archive Data | Solution provides the ability to archive application data | High | Functional | ||||||||
| DE-08 | All Systems | Data Entry / Backup | Retrieve Archived Data | Solution provides the ability to re-load archived data | High | Functional | ||||||||
| DE-09 | All Systems | Data Entry / Backup | Back Up Data | Solution provides the ability to back up data on a recurring schedule | High | Functional | ||||||||
| DE-10 | All Systems | Data Entry / Backup | Restore Backup Data | Solution provides the ability to restore data from a backup | High | Functional | ||||||||
| INT-01 | All Systems | Integration | Integration | Solution provides the ability to transfer data between systems | High | Functional | ||||||||
| PRFC-01 | All Systems | Maintenance/Performance | Performance | Solution responds to end users in three seconds, or less, for all common user interface actions | Medium | Non-Functional | ||||||||
| PRFC-02 | All Systems | Maintenance/Performance | Query Response | Solution returns complex query (query which joins two or more tables) response in 30 seconds or less | Medium | Non-Functional | ||||||||
| PRFC-03 | All Systems | Maintenance/Performance | Availability | Solution is available 99.9% of the time | High | Non-Functional | ||||||||
| PRFC-04 | All Systems | Maintenance/Performance | Peak Usage | Solution supports peak usage times | High | Non-Functional | ||||||||
| PRFC-04.1 | All Systems | Maintenance/Performance | Prioritize Processes | Solution provides the ability to administer/control the priority of processes based on configurable criteria | Medium | Non-Functional | ||||||||
| PRFC-04.2 | All Systems | Maintenance/Performance | Monitor Performance | Solution provides the ability to monitor system performance | Medium | Non-Functional | ||||||||
| PRFC-05 | All Systems | Maintenance/Performance | Scheduled Maintenance | Scheduled maintenance is performed during low traffic volume hours | Medium | Non-Functional | ||||||||
| PRFC-06 | All Systems | Maintenance/Performance | Advance Maintenance Notice | Forty-eight (48) hours advanced written notice of scheduled downtime is provided to Agency | Medium | Non-Functional | ||||||||
| PRFC-07 | All Systems | Maintenance/Performance | Secondary Data Storage | Solution provides a remote secondary data storage location to ensure disaster recovery and business continuity | High | Non-Functional | ||||||||
| USIN-01 | All Systems | User Interface | User Interface | Solution provides consistent, common, uniform look-and-feel | Medium | Non-Functional | ||||||||
| USIN-02 | All Systems | User Interface | Consistent Navigation | Solution provides consistent navigation | High | Non-Functional | ||||||||
| USIN-02.1 | All Systems | User Interface | User Preferences | Solutions provides the ability to store user preferences for menu, screen, column, field and default values | Medium | Non-Functional | ||||||||
| USIN-02.2 | All Systems | User Interface | Filter Values | Solutions provides the ability to store user filter and sort values | Medium | Non-Functional | ||||||||
| USIN-03 | All Systems | User Interface | Responsive Design | Solution provides a responsive user interface, to accommodate different screen sizes | Low | Non-Functional | ||||||||
| USIN-04 | All Systems | User Interface | System Error Handling | Solution returns user friendly messages when errors occur | High | Non-Functional | ||||||||
| USIN-05 | All Systems | User Interface | Search Results Sortable | Solution provides the ability for users to change the sort order of search results | High | Non-Functional | ||||||||
| USIN-06 | All Systems | User Interface | User Feedback | Solution provides the ability for users to submit feedback | High | Non-Functional | ||||||||
| USIN-07 | All Systems | User Interface | User Help | Solution provides user help/guides | High | Non-Functional | ||||||||
| USIN-08 | All Systems | User Interface | WCAG2 Web Accessibility Standards | Solution complies with WCAG2 web accessibility standards | Low | Non-Functional | ||||||||
| USIN-09 | All Systems | User Interface | Section 508 of the US Rehabilitation Act | Solution complies with section 508 of the US Rehabilitation Act of 1973 | Low | Non-Functional | ||||||||
| USIN-10 | All Systems | User Interface | Plain Language Act of 2010 | Solution complies with the Plain Language Act of 2010 | Low | Non-Functional | ||||||||
| WKF-01 | All Systems | Workflow | Workflow | Solution provides the ability to create and manage workflows | High | Non-Functional | ||||||||
| WKF-02 | All Systems | Workflow | Transaction Approval | Solution allows workflow transactions to be routed to one or more persons for approval | High | Non-Functional | ||||||||
| WKF-03 | All Systems | Workflow | User Notifications | Solution provides the ability to configurable user-defined rules-based automated notifications for workflow transactions | Medium | Non-Functional | ||||||||
| WKF-04 | All Systems | Workflow | Delegate Approval | Solution provides the ability to delegate workflow approvals | Medium | Non-Functional | ||||||||
| WKF-05 | All Systems | Workflow | Workflow Routing | Solution provides the ability to customize workflow routing based on transaction type | Medium | Non-Functional | ||||||||
| WKF-06 | All Systems | Workflow | Workflow History | Solution provides the ability to view history of workflow actions | Medium | Non-Functional | ||||||||
| Financial Mgmt | ||||||||||||||
| AGCO-01 | Financial Mgmt | Agent Compensation | Agent Compensation | Solution provides the ability to manage the compensation process for Liquor Agents | High | Functional | ||||||||
| AGCO-02 | Financial Mgmt | Agent Compensation | Calculate Liquor Agent Compensation | Solution provides the ability to calculate Liquor Agent compensation based on store sales, using the state's multiple compensation formulas | High | Functional | ||||||||
| AGCO-03 | Financial Mgmt | Agent Compensation | Variable Agent Compensation Rate for Licensee Sales | Solution provides the ability to apply a variable compensation rate for distilled spirits sales to Licensees, for Liquor Agent compensation calculations | High | Functional | ||||||||
| AGCO-04 | Financial Mgmt | Agent Compensation | Variable Agent Compensation Rate for Consumer Sales | Solution provides the ability to apply a variable compensation rate for distilled spirits sales to consumers, for Liquor Agent compensation calculations | High | Functional | ||||||||
| AGCO-05 | Financial Mgmt | Agent Compensation | Process Agent Earned Advances | Solution provides the ability to process and issue Liquor Agent earned advance payments | High | Functional | ||||||||
| AGCO-06 | Financial Mgmt | Agent Compensation | Enter Agent Earned Advances | Solution allows for manual entry of new earned advances on a Liquor Agent's record | High | Functional | ||||||||
| AGCO-07 | Financial Mgmt | Agent Compensation | Deduct Agent Earned Advances | Solution deducts earned advance Liquor Agent payments from the Liquor Agent's regular monthly compensation payment | High | Functional | ||||||||
| AGCO-08 | Financial Mgmt | Agent Compensation | Load Agent Compensation Application with Sales and Audit Transactions | Solution includes Liquor Agent sales and inventory audit information in Liquor Agent compensation calculation | High | Functional | ||||||||
| AGCO-09 | Financial Mgmt | Agent Compensation | Display Monthly Agent Compensation Processing Status | Solution provides the ability to display monthly processing status of Liquor Agent compensation and earned advances | High | Functional | ||||||||
| AGCO-10 | Financial Mgmt | Agent Compensation | Enter Deductions or Deferments for Open Month | Solution provides the ability to enter deductions for the open month | High | Functional | ||||||||
| AGCO-11 | Financial Mgmt | Agent Compensation | Positive and Negative Deductions and Adjustments | Solution provides the ability to enter multiple positive and negative deductions and adjustments | High | Functional | ||||||||
| AGCO-11.5 | Financial Mgmt | Agent Compensation | Agent Compensation statement | Solution provides the ability for staff and Liquor Agents to view detailed Agent Compensation statement showing all line item adjustments for each month (similar to a paycheck stub) | High | Functional | ||||||||
| AGCO-12 | Financial Mgmt | Agent Compensation | Enter Deferred Deductions | Solution provides the ability to enter deferred compensation deductions for the open month | High | Functional | ||||||||
| AGCO-13 | Financial Mgmt | Agent Compensation | Edit Deductions or Deferments for Open Month | Solution provides the ability to edit Liquor Agent compensation deductions or deferments for the open month | High | Functional | ||||||||
| AGCO-14 | Financial Mgmt | Agent Compensation | Enter Recurring Deduction | Solution provides the ability to enter a recurring deduction on a Liquor Agent's record, with a start and end date | High | Functional | ||||||||
| AGCO-15 | Financial Mgmt | Agent Compensation | Edit Data for an Agent's Compensation Payments | Solution provides the ability to edit data for a Liquor Agent’s compensation payment after the month is closed if there is a hold on that Liquor Agent’s compensation and payment has not yet been issued | High | Functional | ||||||||
| AGCO-16 | Financial Mgmt | Agent Compensation | Monthly Close Rules | Solution prevents closing the compensation month until liquor agent sales reporting, inventory audits, and earned advances have been closed for that month | High | Functional | ||||||||
| AGCO-17 | Financial Mgmt | Agent Compensation | View Deferments from Prior Months | Solution provides the ability to view Liquor Agent compensation deductions or deferments for all closed months | High | Functional | ||||||||
| AGCO-18 | Financial Mgmt | Agent Compensation | Calculate Final Compensation for Outgoing Agent | Solution calculates and processes final compensation for an outgoing Liquor Agent (Liquor Agent who is resigning/cancelling their OLCC retail sales agreement) | High | Functional | ||||||||
| AGCO-19 | Financial Mgmt | Agent Compensation | Hold Final Payment for Outgoing Agents | Solution provides the ability to hold final Liquor Agent payment for one month for schedule B Liquor Agents and for two months for schedule A Liquor Agents | High | Functional | ||||||||
| AGCO-20 | Financial Mgmt | Agent Compensation | Display Store Totals Separately for Agents with Multiple Stores | Solution displays store totals separately for Liquor Agents that have more than one store | High | Functional | ||||||||
| AGCO-21 | Financial Mgmt | Agent Compensation | Put Agent Compensation Payments on Hold | Solution provides the ability to place a hold on individual Liquor Agent compensation payments | High | Functional | ||||||||
| AGCO-22 | Financial Mgmt | Agent Compensation | Interface for Upstream Applications Calculates Deferred Compensation | Solution interfaces with the State Financial Management System to send regular monthly and Liquor Agent earned advance payment information | High | Functional | ||||||||
| FSAR-01 | Financial Mgmt | FS Analytics and Reporting | Financial Services Analytics and Reporting | Solution provides the ability to create, manage, and view on-demand reports | Medium | Non-Functional | ||||||||
| FSAR-02 | Financial Mgmt | FS Analytics and Reporting | Sales Detail Reporting | Solution provides Liquor Agent sales details and totals for all POS transactions, on a daily, weekly, monthly, and by selected date range | Medium | Non-Functional | ||||||||
| FSAR-03 | Financial Mgmt | FS Analytics and Reporting | Distillery Retail Sales Outlet Data | Solution provides daily, weekly, monthly, or by specified date range for payment data from Distillery Agents for reconciliation | Medium | Non-Functional | ||||||||
| FSAR-04 | Financial Mgmt | FS Analytics and Reporting | Bailment Withdrawal | Solution provides the ability to generate reports for Bailment Withdrawal by day, month and by a specified date range | High | Non-Functional | ||||||||
| FSAR-05 | Financial Mgmt | FS Analytics and Reporting | Delinquent Distillery Retail Outlet Sales | Solution provides the ability view a report showing all Distillery Retail Outlets that are in non-compliance with reporting requirements | Medium | Non-Functional | ||||||||
| FSAR-06 | Financial Mgmt | FS Analytics and Reporting | Delivery Date Lag Report for Mark Up/Mark Down | Solution provides a report of stores that received items with a price mark up/mark down during the month that the items were shipped and the items were received into the store's system in the next month | ||||||||||
| Medium | Non-Functional |
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .