{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["Notes","POS","Reporting","Back Office","Technology"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Notes","index":0,"n_rows":18,"n_cols":1,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
["Instructions for the Requirements Spreadsheet"]
[]
["This appendix to the RFP document contains a detailed requirements matrix (this spreadsheet), Attachment A, which outlines the capabilities determined to be important functionally in overall order management. The requirements are listed in the adjoining tab, with detailed line items by section constructed to convey in precise detail what is needed. Please complete the matrix in the Excel file in the following manner:"]
[]
["For the functionality defined, please enter a single number in the appropriate column using the following definitions. Where appropriate or required, provide comments."]
[]
["a) A “1” in the In Base column means that nothing has to be done in order to execute this functionality."]
["b) A “1” in the Configurable column means that a non-technical resource has access to a utility that will allow them to create the ability to execute this function."]
["c) A “1” in the Tech/Dev column means that a technical resource has access to a utility that will allow them to create the ability to execute this function (I.e. SQL or development scripting code is required)"]
["d) A “1”, “2”, or “3” in the Custom Modification column means that this function requires custom coding to be able to activate and execute this functionality. Please indicate the modifications level of effort which includes development, testing, and implementation:"]
["· “1” = up to 2 weeks"]
["· “2” = 3 to 4 weeks"]
["· “3” = 5 + weeks"]
["e) A “1” in the 3rd Party Software column means that you believe the best way to provide this functionality would be to engage and integrate to other software."]
["f) A “1” in the Other column if none of the above statements apply. Please provide a comment for what that means."]
[]
["In order to expedite our review of each software vendor’s response, please do not alter the formatting of the spreadsheet when entering your responses other than to rename the document."]

{"sheet":"POS","index":1,"n_rows":280,"n_cols":9,"rows_kept":280,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
[]
[null,"POS Solution Requirements","In Base","Configurable","Tech/Dev","Custom Modification\n \"1\", \"2\", \"3\"","3rd Party Software","Other","Vendor Comments"]
["1","General "]
["1.01","Ability to support configurable operator prompts, functions and online help"]
["1.02","Ability to support on-screen virtual receipt, including running transaction total and all manual and automatic discounts"]
["1.03","Ability to customize error messages to make them more user friendly"]
["1.04","Ability to customize graphics of POS and add logos"]
["2","Receipts "]
["2.01","Ability to have customized logo "]
["2.02","Ability to customize return policy on receipt "]
["2.03","Ability to display store information on the receipt "]
[2.04,"Ability to display transaction information on the receipt "]
["2.05","Ability to email receipts "]
["2.06","Ability to email gift receipts "]
["2.07","Ability to print and email receipts for the same transaction "]
["2.08","Ability to print gift receipts "]
["2.09","Ability to reprint receipts "]
["2.10","Ability to display tax exempt details on the receipt "]
["2.11","Ability to display multiple tax lines on the receipt (sales tax, PIF, PUF) "]
[2.12,"Supports receipt configuration (e.g. state specific receipt rules, line item taxed, EMV, promotions, discounts, store details, header & footer)"]
["2.13","Ability to print coupon or verbiage on bottom of receipt based on item or class level purchased"]
["2.14","Ability to print second receipt for all exchanges and refunds with separate verbiage and signature spot for cashier, manager and customer"]
["2.15","Ability to Markdown or discount information printed on receipt (in addition to original)"]
["2.16","Ability to Show \"You Saved…\" summary on receipts using either total of discounts and promotions or list price/selling price"]
["2.17","Ability to show salesperson on receipt  "]
["2.18","Ability to show Cashier number on receipt  "]
["2.19","Ability to print electronic signature on receipt "]
["2.20","Ability to print QR codes on a receipt "]
["2.21","Ability to send receipts via SMS  "]
["2.22","Ability to configure number of receipts printed at a store level "]
["2.23","Support multiple receipt formats by store / franchisee"]
["3","Employee Management "]
["3.01","Ability to have unique employee logins "]
["3.02","Ability to manually reset employee passwords on POS "]
["3.03","Ability for employees to clock in/out at POS "]
["3.04","Ability to enforce complex password requirements for employee passwords"]
["3.05","Ability to automate forced password resets after a defined period of time (ex 30 days)"]
["3.06","Ability to assign & un-assign employees to multiple store locations "]
["3.07","Ability have single set of credentials for an employee at multiple locations "]
["3.08","Ability to manually add and terminate employees at store and Corporate level "]
["3.09","Ability to maintain unique employee listings across multiple franchisee groups "]
["3.10","Ability to capture employee ID when applying employee discount"]
["3.11","Ability to transfer employees between franchise groups "]
["4","Retail Transactions "]
["4.01","Ability to discount an item"]
["4.02","Ability to modify and item to print on a gift receipt"]
["4.03","Ability to tax exempt an item"]
["4.04","Ability to void and item"]
["4.05","Ability to price override an item"]
["4.06","Ability to void an item in a transaction "]
["4.07","Ability to void a tender during a transaction "]
["4.08","Ability to void a transaction "]
["4.09","Ability to post void a transaction "]
["4.10","Ability to override tax on an item"]
["4.11","Ability to change quantity of an item"]
["4.12","Ability to modify multiple line items simultaneously (e.g. apply discount)"]
["4.13","Ability to return online purchases in store "]
["4.14","Ability to initiate a return by scanning a transaction receipt "]
["4.15","Ability to initiate a return from guest profile / purchase history, including ecom orders "]
["4.16","Ability to capture reason code for returns and exchanges "]
["4.17","Ability to issue gift certificates or other configurable tender as refund for returns"]
["4.18","Ability to manage returns from multiple transactions in one return"]
["4.19","Ability to track multiple customers and associated items in a single transaction (e.g., husband and wife) "]
["4.20","Ability to perform exchanges at the POS (e.g., guest receives refund, even exchange, guest pays)"]
["4.21","Ability to create a single or multiple-item layaway"]
["4.22","Ability to cancel a single item within a layaway order"]
["4.23","Ability to cancel entire layaway and credit layaway payments"]
["4.24","Ability to create layaway within regular sale"]
["4.25","Ability to pre-pay for items not in stock but will be ordered "]
["4.26","Ability to partial pickup layaway order"]
["4.27","Ability to perform a pay in"]
["4.28","Ability to perform a pay out"]
["4.29","Ability to perform a tender exchange"]
["4.30","Ability to suspend and resume transactions on the same register "]
["4.31","Ability to suspend a transaction and resume it on a different register "]
["4.32","Ability to support state specific transaction configurations (e.g. do not prompt to profile guest in specific states)"]
["4.33","Ability to View previous transactions in an \"electronic journal\""]
["4.34","Supports price override with reason codes and security prompts based on user defined boundries "]
["4.35","Ability to assign a salesperson to item(s) in a transaction for commission purposes "]
["4.36","Ability to assign multiple salespersons to a transaction for for commission purposes "]
["5","Item Entry / Lookup "]
["5.01","Supports item input via scanner or manual entry on keyboard"]
["5.02","Supports standard barcode and item number formats"]
["5.03","Supports Configurable transaction flow for not-on-file items, with tracking"]
["5.04","Supports Suggestive item selling prompts by item number"]
["5.05","Supports item search, with auto add to transaction"]
["5.06","Ability to search inventory qty on hand, available & by location within a Franchise group "]
["5.07","Ability to search for item by vendor"]
["5.08","Ability to search for item by Description"]
["5.09","Ability to search for item by partial description"]
["5.10","Ability to search for item by barcode"]
["5.11","Ability to search for item by price"]
["5.12","Ability to search for item by size/width "]
["5.13","Ability to hide product cost at store level "]
["6","Discounts and Promotions "]
["6.01","Supports Automatic promotion application based on set criteria"]
["6.02","Ability to manually apply a % off discount on an item "]
["6.03","Ability to manually apply a $ off discount on an item "]
["6.04","Ability to manually apply a % off discount on a transaction "]
["6.05","Ability to manually apply a $ off discount on a transaction "]
["6.06","Supports Gift with Purchase (including gift card activation as gift)"]
["6.07","Supports discounts across specific assortment of products (bundles / kitting) "]
["6.08","Supports brand total based promotion ($200 of product from a specific brand)"]
["6.09","Supports payment total based promotion"]
["6.10","Supports tiered promotions ($50-$100 purchase of a brand gets a $25 item for $10, $100-$200 gets the $25 item for free)"]
["6.11","Supports stacked promotions"]
["6.12","Ability to apply a discount on a gift card"]
["6.13","Ability to use a merch card as a return tender"]
["6.14","Supports Potential Promotion Display - ex you are x unit(s) away from a $ of or % off discount"]
["6.15","Ability to see online promotions in store at time of return"]
["6.16","Ability to Handle user group-based discounts (e.g., public service, student, etc.)"]
["6.17","Support Department classes  for use in promotions"]
["6.18","Ability to query promotions available on items within a transaction "]
["6.19","Supports single use coupon codes "]
["6.20","Supports multi-use coupon codes "]
["6.21","Supports setup of a unique coupon range(s) for a specified promotion "]
["6.22","Ability to configure promotions at the corporate level (all stores regardless of Franchise Group) "]
["6.23","Ability to configure promotions at the Franchisee level (specific store groups) "]
["6.24","Ability to configure promtions for specific store(s) within a Franchise group"]
["6.25","Supports manual markdowns/discounts with security permissions"]
["6.26","Ability to require reason codes for manual markdowns/discounts"]
["6.27","Ability to prevent/allow multiple promotional discounts on same item"]
["6.28","Ability to Prevent/allow combinations of concurrent promotions, discounts and allowances within a transaction "]
["6.30","Supports prompts if item is not valid for a particular type of discount"]
["6.31","Ability to support employee discounts "]
["6.32","Supports prompts if another promotion invalidates employee discount"]
["6.33","Supports Best Buy between multiple promotions, to customer’s or store’s benefit"]
["6.34","Ability to set precedence on a promotion so that promotion always applies instead of other eligible promotions (e.g., only apply employee discount even if other promotions are active) "]
["7","Payments & Tax "]
["7.01","Ability to tender with Cash "]
["7.02","Ability to tender with Check "]
["7.03","Ability to tender with Credit Card"]
["7.04","Ability to tender with Debit Card"]
["7.05","Ability to tender with Gift Card"]
["7.06","Ability to tender with state voucher "]
["7.07","Ability to tender with mall voucher "]
["7.08","Ability to tender with foreign currency "]
["7.09","Ability to tender with Merch Card"]
["7.10","Ability to tender with Afterpay "]
["7.11","Ability to tender with GooglePay"]
["7.12","Ability to tender with Klarna "]
["7.13","Ability to tender with ApplePay "]
["7.14","Ability to track HSA / FSA tender types  "]
["7.15","Ability to track financing tender types (Snap,Wells Fargo, etc.)  "]
["7.16","Supports integration with Waterfall financing to finance transactions at POS "]
["7.17","Ability to tender with Loyalty points/rewards "]
["7.18","Supports Tender: Stored payment (i.e., universal payment)"]
["7.19","Ability to capture check details (phone, birthdate, ID, ID type, ID State)"]
["7.20","Supports Gift card (activate on return, swipe, hand key, scan barcode)"]
["7.21","Supports Unlimited split between tender types per transaction (i.e. loyalty points, gift card, 2 credit cards in one transaction)"]
["7.22","Supports Private Label Credit Cards "]
["7.23","Ability to void tender without canceling the entire transaction"]
["7.24","Supports ceiling amounts on tender types"]
["7.25","Supports Integration with stored payments for purchase w/o card present"]
["7.26","Supports Tax free holidays"]
["7.27","Supports Taxable public improvement fee"]
["7.28","Supports Taxable store fees"]
["7.29","Supports Tax engine (e.g. ability to calculate tax where people live, based on store location, tax holiday)"]
["7.30","Supports Location-based tax exempt processing"]
["7.31","Ability to manually override tax"]
["7.32","Ability to manually configure and manage tax at the store level "]
["7.33","Ability to support donations"]
["7.34","Ability to roundup a transaction "]
["8","Sales Orders "]
["8.01","Ability to Create and complete customer orders at POS, kiosk, e-commerce site"]
["8.02","Ability to Retrieve and finalize customer orders at POS (regardless of where order was initiated)"]
["8.03","Ability to support buy online, ship from store"]
["8.04","Supports Order tracking capabilities"]
["8.05","Ability to scan order number at POS from kiosk receipt"]
["8.06","Ability to reference customer order history at any point during transaction"]
["9","Reports"]
["9.01","Supports Flash Sales "]
["9.02","Supports Sales Summary"]
["9.03","Supports Hourly Sales"]
["9.04","Supports Sales by Department "]
["9.05","Supports Non-Merch"]
["9.06","Supports Top Sellers By Quantity"]
["9.07","Supports Hourly Sales (by register) "]
["9.08","Supports Sales Plan"]
["9.09","Supports Merchandise Restocking"]
["9.10","Supports Store Productivity "]
["9.11","Supports Associate Productivity "]
["9.12","Supports Store bank and deposit management reporting"]
["9.13","Supports Exception Report - keyed cards"]
["9.14","Supports Exception Report - Price Override "]
["9.15","Supports Exception Report - Voided Transactions "]
["9.16","Supports Exception Report - Item not on file "]
["9.17","Supports Exception Report - Non-Sale"]
["9.18","Supports Exception Report - discounts by employee"]
["9.19","Supports Exception Report - Return/Exchange analysis "]
["9.20","Supports Exception Report - Monthly over/short analysis"]
["9.21","Supports Exception Report - Refund reporting by store. "]
["9.22","Supports Exception Report - Refund reporting by associate"]
["9.23","Supports Settlement Report - Till declaration summary "]
["9.24","Supports Settlement Report - Till float report "]
["9.25","Supports Settlement Report - Store bank and deposit management "]
["9.26","Ability for stores to create customizable reports "]
["9.27","Ability to include employee sales from sales reports "]
["10","Mobile POS"]
["10.01","Ability to support the same functionality as the standalone POS"]
["10.02","Ability to support the same tendering options as the standalone POS"]
["10.06","Ability to include mobile POS transactions in store reporting"]
["10.07","Ability to include mobile POS transactions in HQ reporting"]
["10.09","Ability to perform CRM/customer name lookup on mobile POS"]
["10.11","Ability to support the same security levels same as POS?"]
["11","Offline Features "]
[11.01,"Ability to do full PLU lookup POS device is offline"]
[11.02,"Supports All POS functions available during offline mode.  Note any functions that are not available in offline mode."]
[11.03,"Allows Full promotion functionality in offline mode"]
[11.04,"Allows Full resynchronization once server or workstation returns online"]
[11.05,"Ability to support Store and Forward credit transactions"]
["12","Internationalization"]
["12.01","Supports Multiple languages based on store location (please provide list of supported languages)"]
["12.02","Ability to define language preference User ID or toggle option?"]
["12.03","Ability to to toggle between languages (e.g., toggle between English and Spanish) "]
["12.04","Support for more than 60 world currencies (Please provide list of supported currencies) "]
["12.05","Supports interfaces to fiscal printers (Italy, Brazil, Germany, etc)"]
["12.06","Supports interfaces to for tax reporting to government authorities (ex. Puerto Rico Lottery) "]
["13","Security"]
["13.01","Supports configurable, multi-level security access (Indicate levels if predefined) "]
["13.02","Support for temporary employee sign on (sign in for each tranasction) "]
["13.03","Support for permanent employee sign on "]
["13.04","Supports configurable supervisor or manager overrides for defined functions or exception scenarios "]
["13.05","Supports validation of user ID and password against local database"]
["13.06","Provides option to limit sign-ons to only one user per register or to one register at a time"]
["13.07","Ability to prompt for security information when employee signed on does not have sufficient security level"]
["13.08","Supports system auto-lock after a configurable amount of time"]
["13.09","Supports security levels and management functions available for both POS and back office."]
["13.10","Cash drawer only opens for appropriate transactions (e.g., cash drawer should not open when a credit/debit card tender is completed or in training mode)."]
["13.11","Ability to prompt for authorization by transaction type (i.e. discounts)"]
["13.12","Ability to set up manager approval rules by dollar amount"]
["13.13","Ability to require manager approvals for certain transactions, (e.g., post voids, returns)"]
["13.14","Ability to require manager approvals for transactions that exceed a configurable dollar limit"]
["13.15","Allows the option to capture selling associate ID to tie to transaction"]
["13.16","Allow access to functions based off of role based security (Manager, CSR, etc.)"]
[14.0,"In-Store CRM"]
[{"$f":"A236+0.01","v":14.01},"Supports centralized collection of customer data and replication of customer information to all stores, store groups or specific stores."]
[14.02,"Ability to maintain consolidated database of customer transaction history across all stores and channels"]
[14.03,"Ability to add/modify customers through GUI"]
[14.04,"Ability to capture name"]
[14.05,"Ability to capture phone number "]
[14.06,"Ability to capture address "]
[14.07,"Ability to capture postal code "]
[14.08,"Ability to capture telephone "]
[14.09,"Ability to capture email address "]
[14.1,"Ability to track customer creation date "]
[14.11,"Ability to track a last modified date on a customer record "]
[14.12,"Ability to track flags on customer record for tax exemption"]
[14.13,"Ability to add in unique comments on customer record"]
[14.14,"Ability to collect customer data at the beginning, during and end of transaction"]
[14.15,"Ability to collect customer data in the transaction post tendering"]
[null,"Supports separate messages displayed to a cashier that are customer specific relating to: "]
[{"$f":"A251+0.01","v":14.16},"- Information (i.e. suggested selling)"]
[{"$f":"A253+0.01","v":14.17},"- Warnings (i.e. frequent returns)"]
[14.18,"- Action (tell the customer they are close to a reward level)"]
[14.19,"Ability to limit visiblity to customer data for VIP customers (ex. Limit visibility to PII based on security levels) "]
[15.0,"Banking "]
[15.01,"Supports Start of Day and End of Day processes with opening count and closing counts "]
[15.02,"Ability to define a starting till float on a store by store basis "]
[15.03,"Ability to tracks all money within store safe and register tills"]
[15.04,"Supports safe to till transfers"]
[15.05,"Supports till to till transfers "]
[15.06,"Ability to prompt associate for cash pickup (POS)"]
[15.07,"Ability to configure blind declarations by tender in pickups and banking"]
[15.08,"Supports safe and till float maintenance"]
[15.09,"Supports float or opening/closing balance entry for each till, with ability to override"]
[15.1,"Provides summary reports (e.g., safe settlement, till settlement, daily banking, weekly banking)"]
[15.11,"Provides per-tender printable banking slips; configurable limit on amount that can be banked on an individual banking slip "]
[15.12,"Supports auto-population of declaration/banking functions if bank-counted cash systems are in place"]
[15.13,"Ability to force recounts when variances are found during opening or closing counts"]
[15.14,"Ability to require manager approvals if variance can't be reconciled during opening or closing counts "]
[15.15,"Ability to enter comments for variances"]
[15.16,"Ability to add cash to the safe, with safe receipts"]
[16.0,"Hardware"]
[16.01,"Supports network connected or wireless POS hardware"]
["16.02","Supports network conneted or wireless recipt printers"]
[16.03,"Supports network connected or wireless cash drawers"]
[16.04,"Supports iOS, Android and Windows"]
["16.05","Supports wired and wireless scanners (i.e. Bluetooth)."]
[16.06,"Supports pole display "]

{"sheet":"Reporting","index":2,"n_rows":84,"n_cols":9,"rows_kept":84,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
[]
[null,"Back Office Reporting","In Base","Configurable","Tech/Dev","Custom Modification\n \"1\", \"2\", \"3\"","3rd Party Software","Other","Vendor Comments"]
[1.0,"General"]
[{"$f":"A3+0.01","v":1.01},"Ability to create / run reports must be based on a security role"]
[1.02,"Ability to save a report for re-use and share this report based on the security set-up for it"]
[1.03,"Ability to provide reporting capabilities in a variety of formats (web, on-line, paper, pdf)"]
[1.04,"Ability to distribute reports in a variety of formats (paper, electronic, email)"]
[1.05,"Ability to produce decision support \"reports\" that can be distributed electronically with drilldown capability and various view"]
[1.06,"Ability to create custom reports based on user defined fields and dates and save them for future use"]
[1.07,"Ability to view on screen, email, or print, all reports."]
[1.08,"Ability to schedule reports"]
[2.0,"PO Reporting"]
[{"$f":"A12+0.01","v":2.01},"Ability to produce a Purchase order status report"]
[2.02,"Ability to produce a Item purchase history report"]
[2.03,"Ability to Generate past due reports by vendor or item number in due date sequence"]
[2.04,"The system provides the ability to search transaction history of a PO and associated receipts down to the UPC (size and color) and store level."]
[2.05,"Vendor analysis reports include transaction data related to purchase orders, receipts, price changes, sales, Gross Margin, returns."]
[2.06,"The system allows the user to set the date range for what is considered an early or late receipt for vendor analysis purposes."]
[3.0,"Sales & Inventory Reporting"]
[{"$f":"A19+0.01","v":3.01},"Provides Style Ranking Reports - fast sellers, slow sellers by store group and consolidated with user defined criteria for regular price merchandise using the product hierarchy and to rank by user defined ratios like % sold etc"]
[3.02,"Ability to track total and subtotal across hierarchy level"]
[3.03,"Ability to select portions of the hierarchy for reporting"]
[3.04,"The system allows the user to customize the data included on SKU displays and reports by department"]
[3.05,"Ability to produce Sales totals by specified time (enter beginning and ending dates)"]
[3.06,"Ability to produce Sales totals for each department, category, manufacturer or supplier or any combination"]
[3.07,"The system maintains a minimum of 3 years history of sales and beginning of month on-hand inventory at the UPC level."]
[3.08,"The system maintains a minimum total units or minimum total cost OR MINIMUM TOTAL RETAIL$ required for an order at the vendor level. This information factors into the replenishment recommendation."]
[4.0,"Operational Reporting"]
[{"$f":"A28+0.01","v":4.01},"Ability to produce In-transit reports"]
[4.02,"Ability to produce Discrepancy reports - shipped but not received, quantity discrepancies, etc."]
[4.03,"Ability to produce P/O Status reports"]
[4.04,"Ability to produce Inventory movement transaction reports"]
[4.05,"Ability to produce Inventory shrinkage reports"]
[4.06,"Ability to produce Inventory adjustment reports"]
[4.07,"Ability to produce Inventory aging reports"]
[4.08,"Ability to produce Comp Reporting"]
[5.0,"Basic Merchandising Analytics Reporting"]
[null,"Reporting available at the following levels:"]
[{"$f":"A37+0.01","v":5.01}," - Merch Group Level (any level)"]
[{"$f":"A39+0.01","v":5.02}," - Merch Group Level/ (any level) by Store (or Location Group)"]
[5.03," - Alternate Hierarchy Merch Group Levels"]
[5.04," - Alternate Hierarchy Merch Group Levels by Store (or Location Group)"]
[5.05," - Vendor"]
[5.06," - Vendor by Store (or Location Group)"]
[5.07," - Merch Group Level (any level) by Vendor"]
[5.08," - Style"]
[5.09," - Style by Store (or Location Group)"]
[5.1," - Style/Color"]
[5.11," - Style/Color by Store (or Location Group)"]
[5.12," - Style/Color/Size"]
[5.13," - Style/Color/Size by Store (or Location Group)"]
[5.14," - Style/Size"]
[5.15," - Style/Size by Store (or Location Group)"]
[5.16," - By all user defined attributes, "]
[5.17," - By all user defined attributes by Store"]
[null,"Includes the following data components for each of the above levels:"]
[{"$f":"A55+0.01","v":5.18}," - Sales units/retail/cost"]
[{"$f":"A57+0.01","v":5.19}," - Sales by Price Status units/retail/cost"]
[5.2," - On-hand units/retail/cost"]
[5.21," - On-hand by inventory status units/retail/cost"]
[5.22," - On-order units/retail/cost"]
[5.23," - Open Order reporting for all PO attributes"]
[5.24," - Markdown units/$"]
[5.25," - Receipts units/retail/cost"]
[5.26," - Ability to create user defined calculated fields - ie: Gross Margin "]
[null,"Includes the following time periods:"]
[{"$f":"A65+0.01","v":5.27}," - Current, daily, WTD, MTD, STD, YTD"]
[{"$f":"A67+0.01","v":5.28}," - At least 3 year of daily history"]
[5.29," - At least 3 years of weekly and monthly history"]
[5.3," - Support user defined custom time periods "]
[5.31,"Ability to produce Drilldown capability (e.g. Merch Group Level to lower Merch group level, Merch group to merch group by store or Style, Style to Style & Color or Style by Location, etc)"]
[5.32,"Ability to produce Fast/Slow Seller reporting"]
[5.33,"Ability to produce Stock Reporting"]
[5.34,"Ability to produce Comp Store  Performance Reporting"]
[6.0,"Financial Reporting "]
[6.01,"Ability to provide register balancing reports, accept and rejection reports, and audit trail of all transactions and adjustments"]
[{"$f":"A76+0.01","v":6.02},"Ability to provide the ability to audit on all user activity that occurs within the application"]
[6.03,"Ability to provide Subledger reports"]
[6.04,"Ability to provide reporting by general ledger account"]
[6.05,"Ability to provide employee purchases reporting."]
[{"$f":"A80+0.01","v":6.06},"Ability to provide payment type reporting (Visa, Master Card, Amex...)."]
[6.07,"Ability to provide tender type reporting"]
[6.08,"Ability to provide reporting by store/register/day for transaction list detail"]
[6.09,"Ability to provide hourly sales and transaction count reporting",1.0]

{"sheet":"Back Office","index":3,"n_rows":295,"n_cols":9,"rows_kept":295,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
[]
[null,"Back Office Solution Requirements","In Base","Configurable","Tech/Dev","Custom Modification\n \"1\", \"2\", \"3\"","3rd Party Software","Other","Vendor Comments"]
[1.0,"Audit Management"]
[1.01,"Ability to provide an easy to use user interface to verify, audit and reconcile transactions daily."]
[1.02,"Ability to track cashier, date, and time of day for each transaction."]
[2.0,"Liability tracking"]
[{"$f":"A6+0.01","v":2.01},"Ability to track Credit Notes"]
[2.02,"Ability to track Gift Cards / Merch Credits"]
[2.03,"Ability to track Vouchers"]
[2.04,"Ability to track Layaways"]
[2.05,"Ability to track  Employee Purchases"]
[2.06,"Ability to track Coupons"]
[2.07,"Ability to track Open Orders with Status"]
[3.0,"Allocation & Replenishment"]
[{"$f":"A14+0.01","v":3.01},"Ability to recommend allocations based on user defined algorithms."]
[3.02,"Ability to set min and max by store."]
[3.03,"Ability to set and use store groups minimums for allocations."]
[3.04,"Ability to pick sales history time periods for calculating demand."]
[3.05,"Ability to allocate from PO ordered quantity."]
[3.06,"Ability to do manual allocations."]
[3.07,"Ability to allocate fixed quantities to stores."]
[3.08,"Ability to modify or delete an allocation."]
[3.09,"Ability to view stores data in store order, store groups or on the fly ranking."]
[3.1,"Ability to exclude stores from a style or class."]
[3.11,"Ability to set parameters to manage short shipped inventory."]
[3.12,"Ability to distribute based on predefined criteria."]
[3.13,"Ability to create order or to allocate product based on forecasted sales."]
[3.14,"Ability to see original/past distribution(s) & sales to distribute re-orders / resupplies."]
[3.15,"Ability to view current inventory plus what was in new allocation --in distribution amt and then give total on hand."]
[3.16,"Ability to take into account store inventory, dc inventory, in transit, on order when calculating future needs."]
[3.17,"Ability to include out of stocks into consideration at the store style sku level."]
[3.18,"Ability to replenish to base stock and include sales curves and current trends."]
[3.19,"Ability to use store groups / grading down to style level."]
[3.2,"Ability to build in safety stock as either a percentage or weeks of supply."]
[3.21,"Explain your forecast methodology for base sales, seasonal sales, and promotional sales."]
[3.22,"Ability to recommend inter store transfers based on user defined algorithms. Please describe."]
[3.23,"Ability to set min/max order levels for replenishment."]
[3.24,"Ability to set customizable seasonal min/max order levels for replenishment."]
[3.25,"Ability to forecast using a model product or categories for new items."]
[3.26,"Provide a list of stock status fields the system supports (I.e. on hand, on order, in-transit, etc)."]
[3.27,"Ability to run replenishments on different frequency."]
[3.28,"Ability to inactivate items from replenishment."]
[3.29,"Ability to run replenishment for selected DCs or stores on a given schedule."]
[3.3,"Ability to run replenishment for selected vendors for all stores on a given schedule."]
[3.31,"Ability to manually override order quantities."]
[3.32,"Ability to create suggested POs that can then be modified by the user."]
[3.33,"Ability to support ordering/replenishing on negative inventory."]
[3.34,"Ability to recommend store to store transfers rather than creating a PO when appropriate."]
[3.35,"Ability to use multiple search and sort capability over items considered for replenishment. Describe options."]
[4.0,"Stock Adjustments"]
[{"$f":"A50+0.01","v":4.01},"Ability to view current inventory totals"]
[4.02,"Ability to adjust on-hand inventory quantities w/security clearance"]
[4.03,"Ability to enter reason codes for adjustments"]
[5.0,"Transfer In, Transfer Out and Goods Receiving"]
[{"$f":"A54+0.01","v":5.01},"Ability to receive advanced notification of shipments"]
[5.02,"Supports item-level receiving"]
[5.03,"Ability to integrate to a peripheral scanning device for uploads of counting information"]
[5.04,"Ability to view or print receiving document when shipment arrives at store"]
[5.05,"Supports processing of unexpected items"]
[5.06,"Ability to record merchandise to be transferred or shipped to other stores, vendors or DC"]
[5.07,"Ability to reprint transfer documents"]
[5.08,"Ability to capture and record damaged goods "]
[5.09,"Ability to suspend and resume transfer"]
[5.1,"Ability to limit transfers between stores in a specific franchise group "]
[5.11,"Supports multi-user capability"]
[5.12,"Ability to record reason codes for transfers"]
[null,"Supports Output documents generated include:"]
[{"$f":"A66+0.01","v":5.13}," -control number"]
[{"$f":"A68+0.01","v":5.14}," -dates "]
[5.15," -sending store information (store #, name, address, manager name)"]
[5.16," -receiving store information (store #, name, address, manager name)"]
[5.17," -item specifics (SKU, UPC, vendor, description, retail, last cost, freight charge,  quantity to ship, quantity shipped, reason code)"]
[5.18," -document can be printed and downloaded to stores."]
[5.19,"-document can be emailed"]
[6.0,"Open to Buy & Forecasting"]
[{"$f":"A75+0.01","v":6.01},"Supports Open to Buy system based on the retail method by class and store"]
[6.02,"Supports OTB system work based on cost and units"]
[6.03,"Ability to track OTB and related forecasting by store, dept, class, subclass and to be able to copy the factors from class to class"]
[6.04,"Ability to allow easy user setup to track markdown dollars, cost, GM$ and %, Initial Markup $ and %, Stock to sales ratios based on turnover targets? Please explain and show reports."]
[6.05,"Ability to develop weekly and monthly and yearly sales trends by class based on a user defined period's history while within the month"]
[6.06,"Ability to calculate planned inventory levels and forecasted sales"]
[7.0,"Enterprise Data Management"]
[{"$f":"7+0.01","v":7.01},"Supports Merchandise Hierarchy that has at least Department, Sub-Department, Class, Sub-Class.\nIs there a limit on the number of levels, if so, how many?"]
[{"$f":"A83+0.01","v":7.02},"Ability to customize Merchandise Hierarchy level labels"]
[7.03,"Supports alternate merchandise hierarchies, if so, is there a limit?"]
[7.04,"Ability to define taxes at the Merch Group Level. If so, what level?"]
[7.05,"Ability to assign other attributes at Merchandise Group levels.\nPlease explain/list."]
[7.06,"Ability to assign user-defined attributes to any Merch Group at any level."]
[{"$f":"A110+0.01","v":7.08},"Ability to customize Location Hierarchy level labels."]
[{"$f":"A89+0.01","v":7.09},"Ability to assign other attributes at Location Group levels.\nPlease explain/list."]
[7.1,"Ability to assign user-defined attributes to any Location Group at any level."]
[7.11,"Ability to assign Location Comp dates for Comp reporting."]
[7.12,"Ability for user-defined Comp periods."]
[7.13,"Ability to define Open/Close dates for temporary close/renovations."]
[7.14,"Supports other dates maintained by Location? If so please list."]
[7.15,"Ability to define seasons. Any limits to the number of seasons?"]
[7.16,"Ability to assign time periods to Seasons."]
[7.17,"Supports Cost Method of Accounting"]
[8.0,"Vendor / Supplier Management"]
[{"$f":"A99+0.01","v":8.01},"Ability to create/maintain Merchandise Vendors."]
[8.02,"Ability to add multiple addresses per supplier."]
[8.03,"Ability to add multiple contacts - including name, phone number, email address, web site, etc."]
[8.04,"Ability to add Supplier notes."]
[8.05,"Ability to add multiple Discounts.\nExplain Discount Types supported."]
[8.06,"Supports Vendor Factors."]
[8.07,"Ability to define sub-Vendors, linking a Vendor to a parent Vendor."]
[8.08,"Ability to define landed cost factors including customs, duty, freight, commissions and exchange rate."]
[8.09,"Supports feed of Merchandise Vendors from Financial system."]
[8.1,"Supports EDI parameters for vendors including EDI point of contact, EDI identifier, EDI version, vendor interchange service"]
[{"$f":"A88+0.01","v":7.07},"Supports location hierarchy that has at least Chain, Region, District, Store. Is there a limit on the number of levels. If so, how many?"]
[null,"Supports the following EDI Transactions:"]
[{"$f":"A109+0.01","v":8.11}," - POs "]
[{"$f":"A112+0.01","v":8.12}," - ASNs"]
[8.13," - Inventory"]
[8.14,"Supports audit trail of a Vendor master additions/edits"]
[9.0,"Product Maintenance"]
[{"$f":"A116+0.01","v":9.01},"Ability to create/maintain Products/Styles with associated SKUs."]
[9.02,"Ability for system-generated Style numbers. Describe format."]
[9.03,"Ability to define a Style number mask based on Merch group, Vendor code, etc."]
[9.04,"Ability for Style number to be fully random (meaningless)."]
[9.05,"Ability to assign a Vendor Style Code to a Style."]
[9.06,"Ability to assign the same Vendor Style Code to more than 1 style for different Vendors."]
[9.07,"Ability to assign more than one Vendor to a Style."]
[9.08,"Ability to assign a Vendor as the primary Vendor to a Style."]
[9.09,"Supports multi-color Styles."]
[9.1,"Supports NRF Color codes (3 digits)."]
[9.11,"Ability to assign a color description override for a given Style."]
[9.12,"Ability to assign Size Categories for groups of sizes related to merchandise type (e.g. Mens' shoes, Women's pants, etc)."]
[9.13,"Ability to assign individual sizes to a Style."]
[9.14,"Ability to define size ranges for rapid addition of sizes to a Style (e.g. S-M-L)."]
[9.15,"Supports NRF size codes."]
[9.16,"Ability to create a Product as a single SKU item (no color/size)."]
[9.17,"Ability for SKU Numbers to be assigned automatically. Describe format."]
[9.18,"Supports Vendor UPCs."]
[9.19,"Ability to assign more than 1 Vendor UPC to a SKU."]
[9.2,"Ability for in-house UPCs generated for each SKU."]
[9.21,"Ability to have SKUs that have both an in-house and Vendor UPC."]
[9.22,"Supports other identifiers that can be assigned to a SKU for ticketing purposes. If so, describe."]
[null,"Supports the following retails:"]
[{"$f":"A138+0.01","v":9.23}," - Original Retail"]
[{"$f":"A140+0.01","v":9.24}," - Compare at Retail"]
[9.25," - Selling Retail (permanent price)"]
[9.26,"Ability to assign a Price Status to the Style (i.e. Regular, Outlet, Markdown, Clearance, etc)."]
[null,"Supports the following Style costs:"]
[{"$f":"A143+0.01","v":9.27}," - Original Cost"]
[{"$f":"A145+0.01","v":9.28}," - Last PO Cost"]
[9.29," - Average Cost (Chain)"]
[9.3," - Average Cost (Store)"]
[9.31,"Ability to reclassify a Style."]
[9.32,"Ability for the history of a reclassified Style to move to a new classification."]
[9.33,"Ability to set a Style as Inactive "]
[9.34,"Ability to set a Style as not re-orderable (e.g. re-orderable flag)? "]
[9.35,"Ability to delete a Style. If so, what happens to any inventory or history for that Style?"]
[9.36,"Ability to define inner/outer packs for a Style."]
[9.37,"Ability to define Order and Distribution multiples of a Style."]
[9.38,"Ability to define Packs for ordering/receiving."]
[9.39,"Supports Packs that consist of multiple colors of a Style."]
[9.4,"Supports Pack that consists of multiple colors & sizes"]
[9.41,"Supports Packs that consist of multiple Styles."]
[9.42,"Ability to assign user-defined Attributes to a Style."]
[9.43,"Supports feed of Merchandise Vendors from Financial system"]
[9.44,"Supports free-form Attribute Values."]
[9.45,"Supports Attribute Values defined as a Date, Numeric, or General text."]
[9.46,"Ability to define Attributes as mandatory or not mandatory."]
[9.47,"Ability to define Attributes as exclusive (one value per attribute) or non-exclusive (multiple values assigned to an Attribute)."]
[9.48,"Supports any other types of user-defined or custom fields that can be assigned to a Style. Please describe."]
[9.49,"Ability to assign an image to a Style."]
[9.5,"Ability to assign an image to a Style/Color."]
[9.51,"Indicate if images are maintained internal to system db or referential links "]
[9.52,"Ability to assign a Ticket Format to the Style."]
[9.53,"Ability to default the Ticket Format of a Style based on Merch Group of Style."]
[9.54,"Supports buying/selling items in bulk (ie class level inventory). If yes, please describe."]
[9.55,"Ability to specify if expiry dates are required."]
[9.56,"Ability to define Kits that contain a group of any SKUs."]
[9.57,"Ability to assign a separate Retail to a Kit."]
[9.58,"Ability to assign additional costs to a Kit (material, labour, etc)."]
[9.59,"Ability to create Kits post-receipt."]
[9.6,"Ability to create/break Kits at the Store."]
[9.61,"Ability to create non-merchandise SKUs for things like gift wrapping, alterations, etc"]
[9.62,"Audit trail of all Style/SKU/Packs, Kits additions/edits."]
[10.0,"Purchase Order Management"]
[{"$f":"A181+0.01","v":10.01},"Ability to add new and modify Purchase Orders."]
[null,"Supports the following types of Purchase Orders:"]
[{"$f":"A182+0.01","v":10.02}," - Bulk to DC"]
[{"$f":"A184+0.01","v":10.03}," - Dropship to Store"]
[10.04," - Blanket/Release"]
[10.05," - Cross dock"]
[10.06," - Special Orders"]
[null,"Ability to assign vendor defaults to PO automatically: "]
[{"$f":"A188+0.01","v":10.07}," - Processing Codes"]
[{"$f":"A190+0.01","v":10.08}," - Pre-ticketing"]
[10.09," - EDI"]
[10.1," - Describe other"]
[10.11,"Supports Merchandise discounts - $ or %."]
[10.12,"Supports Cost factors - Duty, Freight, other."]
[10.13,"Ability for customized PO Vendor Form ."]
[10.14,"Ability to automatically send PO Form to Vendor via email."]
[null,"Supports the following PO Dates:"]
[{"$f":"A197+0.01","v":10.15}," - Cancel Date"]
[{"$f":"A199+0.01","v":10.16}," - Expected Receipt Date"]
[10.17," - Start Delivery Date"]
[10.18," - End Delivery Date"]
[10.19,"Ability to add PO Messages based on Message Type (i.e. Vendor, Warehouse, Internal, etc.).\nIs there any limit to type and number of messages that can be added?"]
[10.2,"Ability to add PO messages to a PO Line."]
[10.21,"Ability to create user-defined PO Processing Codes."]
[10.22,"Ability to assign Processing Codes to a PO Line. \nIs there a limit on how many that can be assigned?"]
[10.23,"Ability to assign user-defined attributes to a PO."]
[10.24,"Ability to assign user-defined attributes to a PO Line."]
[10.25,"Ability for Styles to be created during PO Creation."]
[10.26,"Ability for Colors or sizes to be added to a Style during PO creation."]
[10.27,"Ability to order by Packs."]
[10.28,"Ability to order a mixture of loose units and Packs on the same PO."]
[10.29,"Ability to create Packs during PO Creation."]
[10.3,"Ability to apply/enforce Order Multiples."]
[10.31,"Ability to manually Cancel a PO."]
[10.32,"Ability to manually Cancel a PO Line"]
[10.33,"Ability to auto cancel PO based on Cancel date plus 'X' days.\nPlease describe other methods of auto cancel"]
[10.34,"Ability to specify a PO to NOT be auto canceled."]
[10.35,"Supports PO Approval."]
[10.36,"Ability for multi-level PO Approval.\nAny limit to the number of levels?"]
[10.37,"Ability to define Thresholds for PO Approval."]
[10.38,"Ability to define Thresholds at each approval level."]
[10.39,"Ability to set different Thresholds by Merch Group."]
[10.4,"Supports Audit trail of all PO additions/edits"]
[11.0,"Manual Allocation"]
[{"$f":"A225+0.01","v":11.01},"Ability to do manual allocations."]
[11.02,"Ability to allocate fixed quantities to stores."]
[11.03,"Ability to modify or delete an allocation."]
[12.0,"Inventory Management"]
[{"$f":"A229+0.01","v":12.01},"Ability to manually receive without a purchase order."]
[null,"Ability to received at the store by: "]
[{"$f":"A230+0.01","v":12.02},"    - Purchase Order"]
[{"$f":"A232+0.01","v":12.03},"    - ASN "]
[12.04,"Ability to create store to store transfers from head office"]
[12.05,"Ability to see effect on inventory onhand from Transfers."]
[12.06,"Ability to track/update in transit inventory."]
[12.07,"Ability to create manual inventory adjustments."]
[12.08,"Ability to create user defined reason codes for inventory adjustments."]
[12.09,"Ability to support different inventory statuses (available vs unavailable)."]
[12.1,"Ability to have user defined inventory status codes."]
[12.11,"Ability to see audit trails on all products quantity changes"]
[12.12,"Explain inventory aging methods supported - LIFO, FIFO, etc.."]
[12.13,"Ability to track inventory transaction discrepancies (e.g. shipped but not received, etc.)"]
[12.14,"Ability to search inventory at stores by vendor, vendor style, buyer, brand, merchandise category, description, etcc"]
[12.15,"Ability to print tickets at Stores"]
[12.16,"Ability to manage physical inventory counts"]
[12.17,"Ability to create snapshots by location & date"]
[12.18,"Ability to manage user defined store sections / areas"]
[12.19,"Ability to export master product sku list"]
[12.2,"Ability to enter manual counts"]
[12.21,"Ability to import counts"]
[12.22,"Ability to import counts from 3rd party services"]
[12.23,"Ability to make count corrections"]
[12.24,"Ability to report shrink / variance by location & product"]
[12.25,"Ability to count beginning inventory"]
[12.26,"Ability to allocate inventory as pending shrink"]
[12.27,"Ability to apply inventory variance as shrink."]
[12.28,"Ability to perfrom store-level physical inventory counts (Actual & Available)"]
[12.29,"Ability to count entry by item hierarchy and location"]
[12.3,"Provides SKU variance reporting by item hierarchy and location"]
[12.31,"Ability to integrate to a peripheral scanning device for uploads of counting information"]
[12.32,"Allows for correction of variations prior to posting"]
[12.33,"Supports multi-user capability"]
[12.34,"Supports configurable stock taking locations"]
[12.35,"Supports configurable variance tolerances"]
[13.0,"Price Management"]
[null,"Ability to support prices at multiple levels:"]
[{"$f":"A266+0.01","v":13.01},"   - Style"]
[{"$f":"A268+0.01","v":13.02},"   - Color"]
[13.03,"   - Size "]
[13.04,"   - Store"]
[13.05,"   - Region"]
[13.06,"   - Store Groups (Franchisees can manage their own prices) "]
[null,"Supports Price Change types: "]
[{"$f":"A273+0.01","v":13.07},"   - Permanent Markdowns "]
[{"$f":"A275+0.01","v":13.08},"   - Permanent Markups"]
[13.09,"   - Temporary Markdowns"]
[13.1,"   - Temporary Markups"]
[13.11,"Ability to specify effective and end dates."]
[13.12,"Ability to approve price changes."]
[13.13,"Ability to apply price changes at stores on demand. "]
[null,"Supports price calculation methods: "]
[{"$f":"A281+0.01","v":13.14},"   - percent off original"]
[{"$f":"A283+0.01","v":13.15},"   - percent off current"]
[13.16,"   - Fixed price"]
[13.17,"   - Markup percent off cost"]
[13.18,"Ability to support different price rounding rules"]
[13.19,"Ability to support price statuses."]
[13.2,"Ability to advance price status based on price change type."]
[null,"Ability to recommend price changes based on user defined algorithms using: "]
[{"$f":"A289+0.01","v":13.21},"   - item age or status"]
[{"$f":"A291+0.01","v":13.22},"   - Season"]
[13.23,"   - Sell through %"]
[13.24,"   - Other? Please describe"]
[13.25,"Ability to maintain price change history with effective dates"]

{"sheet":"Technology","index":4,"n_rows":58,"n_cols":9,"rows_kept":58,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
[]
[null,"Application Suite","In Base","Configurable","Tech/Dev","Custom Modification\n \"1\", \"2\", \"3\"","3rd Party Software","Other","Vendor Comments"]
[1.0,"Integration"]
[null,"Ability to utilize PUT & GET REST APIs to create/modify/delete the below information datasets.  Note any areas where the ability to utilize REST APIs do not meet these requirements and list out alternate methods of importing and exporting of data. Provide API specification documentation."]
[{"$f":"A3+0.01","v":1.01}," - Sku/UPC/Style/Vendor"]
[{"$f":"A5+0.01","v":1.02}," - Product hierarchy"]
[1.03," - Locations"]
[1.04," - Purchase orders"]
[1.05," - Merchandise packs"]
[1.06," - Temporary, permanent and promotional pricing"]
[1.07," - Product inventory and inventory adjustments"]
[1.08," - Product Allocations"]
[1.09," - Receipts"]
[1.1," - Transfers"]
[1.11," - Physical Inventory / Cycle Counts"]
[{"$f":"A12+0.01","v":1.09}," - Sales History"]
[{"$f":"A16+0.01","v":1.1}," - Sales Orders"]
[1.11," - Customers"]
[{"$f":"A20+0.01","v":1.13}," - Customer transactions"]
[{"$f":"A18+0.01","v":1.12}," - Customer Liabilites"]
[1.14," - Customer Loyalty information"]
[{"$f":"A21+0.01","v":1.15}," - General Ledger"]
[1.16," - Stock Ledger"]
[1.17," - Sales Audited transactions"]
[1.18," - Employees"]
[2.0,"Platform"]
[{"$f":"A26+0.01","v":2.01},"Ability to host application(s) in a secure cloud location"]
[2.02,"Ability for customer to host application(s) in their own cloud or data center"]
[2.03,"Ability to upgrade application centrally without client upgrades"]
[2.04,"Ability to support strong version and release control"]
[2.05,"Ability to support All APIs utilize authentication via managed key or 128-bit encryption or higher."]
[2.06,"Ability to ensure customizations do not impact upgrades"]
[2.07,"Ability to ensure customizations are included in future release base"]
[2.08,"Ability to support configurable event logging for key systemic events"]
[2.09,"Ability for IT staff to access logs"]
[2.1,"Ability to set up alerts based on certain logged events / triggers"]
[2.11,"Ability to support audit trail reporting for all transactions"]
[2.12,"Support for automated testing tools. Detail out automated testing solutions supported"]
[2.13,"Applications provide data retention policies to properly dispose of or archive old data."]
[2.14,"Solution supports automated monitoring and alerting"]
[2.15,"Ability for application(s) to support a training mode"]
[2.16,"Solution provides development, test, staging and production environments"]
[2.17,"Solution provides a robust and simple way to promote and track changes between environments (CI/CD)"]
[2.18,"Solution provides a robust and simple way to rollback changes between environments"]
[3.0,"Security"]
[{"$f":"A45+0.01","v":3.01},"Solution(s) support data encryption in flight.  Note any data types that cannot be encrypted in flight."]
[3.02,"Solution(s) support data encryption at rest.  Note any data types that cannot be encrypted at rest"]
[3.03,"Solution(s) require user login to the application"]
[3.04,"Solution(s) support complex passwords (characters, upper case, lower case, numbers and special characters)"]
[3.05,"Configurable ability to carry login credentials over from other client internal applications"]
[3.06,"Application to display a prompt or message when the current user’s credentials do not meet the minimum authorization requirements"]
[3.07,"Application to display an input field to enter authorization override credentials"]
[3.08,"User password retrieval (if password forgotten)"]
[3.09,"System(s) to enforce timeout for inactivity"]
[3.1,"Provide flexibility in defining user/role-based data access and security levels and authorization to restrict access to information"]
[3.11,"Ability to support multi-factor authentication for users"]
[3.12,"Ability to have a unique user / employee id/password across all applications and stores"]
[3.13,"Supports Single sign-on applications"]