ESM_Appendix D USM Internal and External Systems Interface Descriptions Final.xlsx
XLSX spreadsheet 13 KB Posted
- Attached to
- Enterprise Sales and Marketing Solution Federal contract opportunity
- Solicitation number
- 2031JG22R00025
About this file
This document contains an appendix detailing the internal and external system interfaces for an Enterprise Sales and Marketing Solution being solicited by the United States Mint. The solution seeks an integrated order management, eCommerce, and customer relationship management system, along with contact center, fulfillment, and point-of-sale capabilities. Daily interfaces are required to transfer customer, order, product, and accounting data to and from systems like Pay.gov, Oracle, Amazon, and GovDelivery. Real-time APIs will connect payment processing, inventory allocation, and receipt acknowledgement across platforms. The solicitation aims to modernize the Mint's end-to-end numismatic retail operations through a single contractor providing all necessary hardware, software, hosting, staffing, and system integration.
View the file
Other files for this federal contract opportunity
Show all 23
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Sheet1
| Appendix D: USM Internal and External Systems Interface Descriptions | ||||
| This information is provided for reference purposes. New system will dictate actual requirements. USM desires use of standard APIs. | ||||
| System to be Integrated | Interface Name | Interface Description | Publisher (Source System) | |
| Subscriber (Target System) | Data Exchange | Interface Type | Frequency | Comment |
| Pay.gov | Payment Authorization | Real time payment authorizations for credit card, PayPal, and ACH payments. | OMS | Pay.gov | Two-way | Real-time | Real-time | Existing |
| Payment Re-Authorization | Real time payment re-authorizations for credit card and PayPal payments w/expired authorizations. Typically handled for backorders during inventory allocation. | OMS | Pay.gov | Two-way | Real-time | Real-time | Existing | |
| Reverse Authorization | Funds on hold against customer credit/debit cards and PayPal are released when customer orders are cancelled. | OMS | Pay.gov | Two-way | Real-time | Real-time | Existing | |
| Batch Authorization | Batch interface to process authorization requests. | OMS | Pay.gov | Two-way | Batch | Real-time | Existing | |
| Payment Settlement | Payment is successfully settled for orders shipped / fulfilled by the warehouse through this interface. Payment transactions are settled when shipment confirmation is received for online, call-center and subscription orders. | OMS | Pay.gov | Two-way | Real-time | Real-time | Existing | |
| Batch Settlement | Batch interface to process payment settlement. | OMS | Pay.gov | Two-way | Batch | Real-time | Existing | |
| Credit/Refund | Payments are refunded to the customer after returns are processed online and goods physically received at the warehouse. | OMS | Pay.gov | Two-way | Real-time | Real-time | Existing | |
| USM Data Warehouse | Product Data | Daily snapshot of product / category data hosted in OMS. Includes inventory extract, catalog export, and purchase order history | OMS | Data Warehouse | One-way | Batch | Once a day | Existing |
| Customer Data | Daily snapshot of customer data (newly registered, guest or customer information tied to orders). Includes customer support records and marketing information. | OMS | Data Warehouse | One-way | Batch | Once a day | Existing | |
| Order Data | Daily snapshot of customer order/returns data (order types from various sales channels, order states such as on hold, backorder, declined payment, shipped etc.). Includes sales orders and sales order details, settlement files, and website order data. | OMS | Data Warehouse | One-way | Batch | Once a day | Existing | |
| Returns Data | Returns initiated and closed in the OMS are sent using this interface. | OMS | Data Warehouse | One-way | Batch | Once a day | Existing | |
| Customer Subscriptions Data | Customer subscriptions that resulted in new orders, or new customer subscriptions to products are exported to datawarehouse for reporting purposes. | OMS | Data Warehouse | One-way | Batch | Once a day | Existing | |
| Accounting data | Includes AR file, cash file, GL header, and GL detail. | OMS | Data Warehouse | One-way | Batch | Once a day | Existing | |
| Oracle Federal Financials | Oracle GL Summary | The OMS interface to Oracle GL brings in summarized financial information on |
order entry, billing, revenue, inventory, expenses, payables and accounts
| receivable processes for orders in the numismatic line of business. | OMS | Oracle GL | One-way | Batch | Once a day | Existing | |||
| Oracle Manufacturing WMS | Item Master | Create Item Master in Fulfillment WMS from Oracle Manufacturing WMS. | Oracle WMS | OMS | One-way | Real-time | Real-time | New | |
| Product Receipt | Manage process of shipping products from manufacturing WMS to fulfillment WMS against internal sales order. | Oracle WMS | OMS | One-way | Real-time | Real-time | New | ||
| Receipt Acknowledgement | Process Receipt of products received in fulfillment WMS. | OMS | Oracle WMS | One-way | Real-time | Real-time | New | ||
| Oracle Inventory | Internal Sales Order Inventory Update | The OMS interface to Oracle Inventory brings in detailed purchase order data to support the inventory control of stock requests of orders in the retail business. | OMS | Oracle Inventory | One-way | Batch | Once a day | Existing | |
| Sales Inventory Synchronization | Synchronize Oracle Inventory with fulfillment WMS. | OMS | Oracle Inventory | One-way | Real-time | Real-time | New | ||
| GovDelivery.com | GovDelivery Email Marketing Data | Email marketing or email communication follow up with customers will be sent via GovDelivery. Data extracted from OMS will feed GovDelivery via a interface. | OMS | GovDelivery | One-way | Batch | As Needed | New | |
| Amazon | Amazon API | Acceptance of new orders and updates on order status. | OMS | Amazon.com | Two-way | Batch | Daily | Existing | |
| Amazon Inventory Allocation | Allocate inventory splits to Amazon. | OMS | Amazon.com | One-way | Batch | Daily | Existing |
File details come from the government source that posted it. Updated .