Integration Schedules and File Names

Revised: 18 July 2018

Overview

Coupa's standard integrations run on a polling schedule. This means that Coupa will interrogate the target system on a periodic basis to determine if any data needs to be integrated. The frequency of the polling schedule can be controlled per business object.

Schedule Frequency

Typically, master or reference data is integrated on a daily basis, while transaction data is integrated on an hourly basis. You can work with your Coupa (or Partner) integration technical team to determine the appropriate frequency for each business object.

Schedule Times

It is recommended that data which is synchronized daily should be run during 'non-peak' hours (eg. 4am) to minimize the impact of additional system load produced by the integrations.

Business Object Primary System Synced System Frequency of Integration
Users HR System Coupa Daily
Account Codes Financial System Coupa Daily
Suppliers Financial System Coupa Daily
Purchase Orders Coupa Financial System Hourly
Purchase Order Revisions Coupa Financial System Hourly
Invoices Coupa Financial System Hourly
Invoice Voids/Credit Memos Coupa Financial System Hourly
Invoice Payments Financial System Coupa Hourly
Exchange Rates Financial System Coupa Daily
Budget Line Information Financial System Coupa Daily
Expense Lines Financial System Coupa Hourly

File Names

Depending on the method of integration there may be a requirement for a specific file format. To streamline integrations, Coupa loads data to and from files formatted as CSV and ZIP files with a file size limit of 8 MB.  

Your implementation manager can provide those formats. In addition to the format of the file, we also have a specific naming convention for any files that are generated from Coupa or that we require from our customers.

Please see the table below for those file names, please note the date time stamp in order to ensure that files do not override each other. If it's mandatory to change the file format name, then please document that in the table below.

Business Object File Name
Users users_<ddmmyyhhmmss>.<file format>
Account Codes accounts_<ddmmyyhhmmss>.<file format>
Suppliers suppliers_<ddmmyyhhmmss>.<file format>
Purchase Orders orders_<ddmmyyhhmmss>.<file format>
Purchase Order Revisions order_revisions_<ddmmyyhhmmss>.<file format>
Invoices, Invoice Voids, & Credit Memos invoices_<ddmmyyhhmmss>.<file format>
Invoice Payments payments_<ddmmyyhhmmss>.<file format>
Exchange Rates fx_rates_<ddmmyyhhmmss>.<file format> System
Budget Line Information budget_lines_<ddmmyyhhmmss>.<file format>
Expense Lines expenses_<ddmmyyhhmmss>.<file format>