DeCA Systems - Functional Descriptions - Hardware v1(Jul24).xlsx
XLSX spreadsheet 358 KB Posted
- Solicitation number
- W58P05-24-S-C-0001
About this file
This document appears to be an Excel file containing functional descriptions for various hardware and software systems used by the Defense Commissary Agency (DeCA). The file provides an overview of 12 key DeCA systems, including the Automated Inventory Management System (AIMS), Coupons (C2K), Commissary Advanced Resale Transaction System Replacement/Modernization (CARTS R/M), Central Meat Processing Plant (CMPP), and the DeCA Electronic Commerce/Electronic Data Interchange (DECA EC/EDI) system, among others. The descriptions outline the purpose, functionality, and interfaces of these systems that support DeCA's grocery operations and financial processes.
The related federal contract opportunity is for a "Worldwide Commissary Upgrade Commercial Solutions Opening (CSO)" solicitation issued by the U.S. Army Contracting Command - Aberdeen Proving Ground, Tenant Division on behalf of DeCA. This continuously open CSO solicitation seeks commercial solutions to modernize DeCA's commissary operations, with an open period until August 12, 2025. Areas of Interest (AoIs) related to this opportunity will be posted separately.
View the file
Other files
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
SV-1 SoS
Sys Descriptions DITPR ID System Name Brhane, Mikael CTR (US) DeCA HQ ITP: Full system name
| System Acronym | System Description and Function | |||
| 3098 | AUTOMATED INVENTORY MANAGEMENT SYSTEM | AIMS | AIMS is a web-based application that is used to electronically send financial transactions to the DoD accounting system, STANFINS. AIMS generates store inventory accounts that are used by zones and regions. AIMS receives financial transactions from DeCA's Interactive Business System (DIBS) and receipts and Vendor Credit Memorandums from the Standard Automated Voucher Examination System (SAVES). AIMS posts transactions to individual store inventory accounts. AIMS also maintains a history of all of the records sent to the DoD financial system - STANFINS. | |
| 8670 | COUPONS | C2K | Coupons (C2K) supports both the tabulation and processing of manufacturer coupons through the use of automation and the coupon clearinghouse contractor. Accounts payable and accounts receivable information is received from each store and the contractor for verification,reconciliation, and account payment. | |
| 17161 | COMMISSARY ADVANCED RESALE TRANSACTION SYSTEM REPLACEMENT/MODERNIZATION | CARTS R/M | Replacement/Modernization (CARTS R/M) is a modernization of DeCA's point of sale (POS) hardware including all commissaries, server centers, and test bed. CARTS R/M will provide modernized POS hardware to help DeCA achieve its vision of providing its customers with an enhanced 21st century shopping experience. CARTS R/M is currently in the Engineering & Manufacturing Development phase. | |
| 871 | CENTRAL MEAT PROCESSING PLANT | CMPP | The CMPP system is a core priority mission business system that will provide automated capabilities to help manage and perform centralized meat processing plant operations to support commissaries and other government entities with fresh beef and pork products. It will provide retail cuts of fresh beef and pork to 59 commissaries, 9 NEXMARTS, and numerous DoD and state department activities in the European Theater, Africa, and Southwest Asia (e.g., Embassies Exchanges and Dining Halls are all handled through commissaries). CMPP is responsible for ordering and maintaining an on-hand inventory of beef and pork products to support resale demand.The CMPP System is being implemented to support DeCAs primary mission to deliver the premier quality of life benefit to the armed services community enhance recruiting retention and readiness provide exceptional savings and deliver excellent products and services. | |
| 3275 | DECA ELECTRONIC COMMERCE/ELECTRONIC DATA INTERCHANGE | DECA EC/EDI | The Electronic Data Interchange (EDI) system supports grocery operations by providing the mechanism for electronic exchange of grocery orders, price information, advanced shipping notices, credit/debit adjustments, product transfer and resale reports, and acknowledgements. DeCA's trading partners convey electronic documents to the EDI system via the file transfer protocol (FTP), direct-dial connections to a modem bank, the Internet (AS2), and an out-sourced web hosting service. The EDI documents use the American National Standards Institute (ANSI) Accredited Sub-Committee (ASC) X12 syntax 5010 standard. DeCA EDI messages conform to the Uniform Code Council (UCC) implementation conventions for the grocery industry. The DeCA EDI system uses a combination of custom developed application code (Perl, UNIX shell script) and commercial off-the-shelf (COTS) software to processes over 100,000 transactions per month from more than 200 vendors and distributors. EDI is a fully functional real-time system operational 24 hours a day, 7 days a week, except for scheduled or unscheduled downtime of the operating system or the database instance upon which it is totally dependent. | |
| 817 | DECA ELECTRONIC RECORDS MANAGEMENT ARCHIVE SYSTEM | DERMAS | DERMAS is DeCA's DoDD 5015.2 compliant electronic records system that captures data and images in a commonly accessible repository to satisfy the legal and regulatory requirements of records management and to provide Agency decision makers a resource to improve operational efficiency. | |
| 1689 | DECA INTERACTIVE BUSINESS SYSTEM | DIBS | The Defense Commissary Agency Interactive Business System (DIBS) enables DeCA to order & receive resale groceries. DeCA's core business system is designed to replace the various service specific systems inherited by DeCA. DIBS supports a variety of functions: ordering, receiving, shelf stock replacement, physical inventory and control operations such as deposits, demand reporting, and centralized control of file and database maintenance for store using Regions File Maintenance (RFM) and central cataloging. DIBS' sub-modules include Frequent Delivery System/Direct Store Delivery (FDS/DSD). DIBS' functions include daily file transfers to vendors and distributors for EDI pricing, ordering and advance shipping notices, to SAVES for voucher processing and to AAFES for the BX Marts; a bi-monthly interface also goes to ALA. FDS/DSD functions include placing orders, tracking the receipt of deliveries, totaling the amount owed for products received, supporting the reconciliation of deliveries, initiating payment to vendors and maintaining files of resale items provided by more than 100 distributors to over 200 CONUS, Alaska, and Hawaii stores on a daily basis. | |
| 8680 | ELECTRONIC DECA AUTOMATED REQUISITION TRACKING SYSTEM | EDARTS | eDARTS assists store personnel in developing on-line requisitions for operational equipment, supplies and services. eDARTS electronically routes the requisition for funding and approval prior to its transmission to DeCA's contracting system. Commissary, region and headquarters personnel utilize this system. eDARTS contains preloaded contract information (e.g., vendor, item, price, etc.) that is automatically entered into the requisition. eDARTS provides store personnel with an automated tool to track requisitions from the time of requisition entry until contract award, thus eliminating the need for phone calls and e-mails requesting status. | |
| 5930 | ENTERPRISE DATA WAREHOUSE | EDW | The EDW is a data warehouse, providing a single, logical view of product, sales, and human resource data across DeCA allowing end users to make informed business decisions. EDW obtains data from the DeCA human resources and business systems, then transforms it into an appropriate data warehouse format using business rules defined by functional experts. The transformed data is maintained in either a Teradata or Oracle database in a format that provides quick access to required raw data, summary data, and reports. As required, data is conveyed to DeCA's industry partners and other DoD components via a Secure File Transfer Protocol (SFTP) to a demilitarizedzone (DMZ) corporate server. The EDW environment is hosted on a set of clustered servers at DeCA Headquarters in Fort Lee, Virginia. | |
| 1694 | STANDARD AUTOMATED VOUCHER EXAMINATION SYSTEM | SAVES | The Standard Automated Voucher Examination System (SAVES) provides automated support for contracting and bill paying functions for DeCA Commissaries in the U.S., Guam and Europe. Its five major functional processes are: receipt entry, invoice entry, contract establishment/modification, overpayment /collection processing, and credit/collection processing. SAVES also maintains an online historical record of the payment transactions. The system performs interactive and batch processes and interfaces with AIMS, and DIBS. With the deployment of SAVES bill-paying system to Europe in FY 1998, DeCA increased accountability controls for payments. The major changes to SAVES accomplished foreign currency processing, receipt corrections at the ACS/store level through DIBS, and payment/ accounting for transportation costs. | |
| 1403 | WAREHOUSE MANAGEMENT SYSTEM | |||
| (WMSOS Manhattan™) | WMS | A key component of the DeCA supply chain is the Warehouse Management System (WMS), which primarily controls the movement and storage of materials within a warehouse and processes the associated transactions, including shipping,receiving, putaway and picking. The system also directs and optimizes stock putaway based on real-time information about the status of bin utilization.The WMS technology Refresh will also implement a new Transportation Management System to manage all outbound shipments from the CDCs. When fully implemented, WMS will be a practical warehouse management system bringing commercial best practices to DeCA CDC operations while providing support to the overseas commissaries and our military patrons. Primary benefits include a) Provide cyclic inventory to reduce physical inventories; b)Increase product inventory visibility; and c) Streamline and standardize inbound and outbound processing. | ||
| 12134 | ENTERPRISE BUSINESS SOLUTION | EBS | EBS is the modernization of DeCA's entire resale business operations including all processes associated with vendor/supplier portal; contracting, cataloging, pricing, and promotions (CCPP); Planogramming; ordering, receiving, and inventory (ORI); Omni-channel point-of-sale (POS) with customer relationship management (CRM) to include gift cards, loyalty marketing, and digital coupons, electronic/mobile (e/m) commerce; warehouse management (WMS), and the financial interface systems (FIS) that will interface with external DoD, Government, and commercial systems. EBS will be a fully integrated, grocery-specific, retail business suite based on commercial best practices to be deployed in four separate and distinct increments | |
| Category Analyzer | CA | Provides DeCA with item movement reporting and analysis capabilities at both the HQ and store levels by combining item movement and retail prices from the point-of-sale (POS) systems and merchandising data. | ||
| Power HQ | PHQ | Is the central repository for information on each and every line item, pricing, vendor and contract details, and sale history. Links vendor, item, and store information. Provides product details to POS, DAX ordering/receiving, Relex Planogramming, and other EBS systems. | ||
| Store Portal | The web-based application for the DeCA store users to view and access data specific to their store-locations on a daily basis, and is part of the Power HQ application. Provides all product details including description, cost, price, and vendor information. | |||
| Vendor Portal | Allows access to DeCA vendors to submit New and Modified Item, Price, and Deal Data to the Contract Authorized Negotiator that is Staged in Power HQ for Approval. Vendors can view or export their catalog of items but cannot edit. Provides all product details including description, cost, size, case pack, etc. | |||
| Relex Planogramming | Relex Planogramming provides functionality for end-to-end category planning and space to sales management. The capability of space planning automation, optimization, and assortment solutions assist stores in having the right items, help reduce balance-on-hand (BOH) inventory and slow-moving items. | |||
| Bill Back Manager | BBM | Bill Back Manager (BBM) tracks promotional offers and the creation, negotiation, tracking, and finalization of promotional agreements. Used in conjunction with Vendor Portal Agreements that supports vendor submission of promotional offers. Used for scan-based promotions. Generates invoices for reimbursement of promotions. | ||
| Clear Demand | ||||
| RETIRED | Clear Demand is a retail price optimization tool. It’s used by DeCA’s Pricing Team for price optimization using consumer demand and the market place to align everyday pricing with overall category strategies to meet competitive pricing goals and internal business rules while generating additional revenue and margin. | |||
| Invatron ePlum | Populates store scales with product data, prices, ingredients, and nutritional information from Power HQ. Information prints on scales labels which are then placed on product packages | |||
| Power DAX | DAX | Provides DeCA with demand driven order replenishment at the commissary level designed to maintain in-stock levels without having high levels of back stock. Provides robust algorithms used to predict the sales forecast needed, including consideration for promotional, seasonal and calendar impacted items. | ||
| Power Inventory | IM | Provides DeCA with inventory management to coincide with the demand forecast generated in Power DAX. Allows for order review, order edits, and order approval via the GUI or Hand Held Terminals (HHTs). Is the back door receiving solution, supporting manual free receiving or electronic/ASN receiving. Maintains balance on hand (BOH) of products at the store level. | ||
| Emerald Point-of-Sale | POS | Provides In-lane registers and Self-check outs (SCO). | ||
| Commissary CLICK2GO | CC2G | Online shopping platform provided by NCR Freshop. Freshop-for-Stores is a mobile app (iOS-only) used by store workers to fulfill customer online orders. Freshop White Label is a mobile app (Android & iOS) used by customers for online ordering. Uses integrated product data from Power HQ and Category Analyzer. Provides an Admin tool to manage product data, order fulfillment, recipe management, and reporting. | ||
| Retail One | Customer Relationship Management (CRM) Solution to create and deploy promotions related to customer loyalty. Allows creation of promotions and special offers to customers based on customer loyalty and purchases. Creates personalized offers down to the store and customer levels. Prints messages and notifications on customer receipts. | |||
| RTI Signage | Signage and label printing. Sign templates can be created at DeCA HQ to ensure consistency across the stores. Stores can print labels and replacement tags. | |||
| Manthan360 | Business analysis tool that provides the ability to understand customer shopping habits better. Customer loyalty analytics tool. Performs market basket analysis, generates target marketing lists, measures ROI. Utilizes data from store transaction logs (TLOGS) for customers using rewards cards. Used at DeCA HQ by the Analytics, Promotion, and Marketing teams. |
InLane Specs
| Make / Model / PID | NCR / RealPOS XR7 Plus / 7703 |
| Chipset | Intel Q170 |
| Processor | Intel i5-7500T |
| Processor, Base Frequency | 2.7 GHz |
| Processor, Cache | 6MB |
| Memory Type / Amount | DDR4-2133 / 16GB |
| Storage | 2.5” 120GB SSD |
| TPM 2.0 Chip | Yes |
| Ethernet LAN Port | RJ45, 10/100/1000MB (Gigabit) |
| PoweredUSB Ports (24V) | 1 |
| PoweredUSB Ports (12V) | 3 |
| RS232 | 1 |
| PC USB Ports (5V) | 2 |
| HDMI | 1 |
| DisplayPort | 1 |
| Cash Drawer Port | 1 |
| Display, Size / Touch Type | 15" / Projected Capacitive |
| Display, Native Resolution | 1024x768 |
| Display, Brightness | 500 nits typical |
| Display, Contrast Ratio | 700:1 typical |
| Display, Color Palette | 16.2M |
| Display, Pixel Pitch | 297x297 um |
| Display, Backlight | LED |
| Display, Life | 50K Hours to half brightness |
| Encrypted MSR | Yes |
| OS | Windows 10 IoT Enterprise 2016 |
| Terminal Dimensions (WxHxD) | 14.9 x 11.9" x 2.1" |
| Weight (no Stand) | 9.5 lb. |
SCO Specs
| SCO Make / Model / Product ID | NCR / R6C / 7360-3300-9090 | NCR / R6C / 7360-4330-9090 |
| Terminal Make / Model / Product ID | NCR / RealPOS XR7 / 7702 | NCR / RealPOS XR7 Plus / 7703 |
| Processor | Core i3-4350T | Core i3-6100TE |
| Memory Type / Amount | DDR3 -1600 / 16GB | DDR4-2133 / 16GB |
| Storage | 120GB SSD | 120GB SSD |
| TPM 2.0 Chip | Yes | Yes |
| Size / Touch Type | 15" / Projected Capacitive | 15" / Projected Capacitive |
| Native Resolution / Backlight | 1024x768 / LED | 1024x768 / LED |
| Brightness / Contrast Ratio | 500 nits typical / 700:1 typical | 500 nits typical / 700:1 typical |
| Color Palette / Pixel Pitch | 16.2M / 297x297 um | 16.2M / 297x297 um |
| OS | Windows 10 IoT Enterprise 2016 | Windows 10 IoT Enterprise 2016 |
| Dimensions (WxHxD) / Weight | 14.9 x 11.9" x 2.1" / 9.5 lb. | 14.9 x 11.9" x 2.1" / 9.5 lb. |
image1.jpeg
File details come from the government source that posted it. Updated .