Appendix_D_USM_Internal_and_External_Systems_Interface_Descriptions.xlsx
XLSX spreadsheet 15 KB Posted
- Solicitation number
- USM-HQ-13-0018
About this file
Appendix D - USM Internal and External Systems Interface Descriptions
View the file
Other files
Show all 32
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
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 payments. | OMS | Pay.gov | Two-way | Real-time | Real-time | Existing |
| Payment Re-Authorization | Real time payment re-authorizations for credit card 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 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 | |
| Mail Order Processing | Mail Orders | Mailorders received at Citi Lockbox are transferred into the OMS system through this interface. | Citigroup | OMS | One-way | Batch | Twice a day | Existing |
| USM Data Mart | Product Data | Daily snapshot of product / category data hosted in OMS. | OMS | Data Mart | One-way | Batch | Once a day | Existing |
| Customer Data | Daily snapshot of customer data (newly registered, guest or customer information tied to orders). | OMS | Data Mart | 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.). | OMS | Data Mart | One-way | Batch | Once a day | Existing | |
| Returns Data | Returns initiated and closed in the OMS are sent using this interface. | OMS | Data Mart | 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 Mart | 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
Sheet2
Sheet3
File details come from the government source that posted it. Updated .