Looking up primary data in Coupa
You can run a job to look up primary data from different ERP sources into ServiceNow
Before you start the ERP integration, you must configure the integration services record for the target ERP source using the [sn_fcms_intg_service] table. The [sn_fcms_intg_service] table is a mapping table between sub flows and target ERP source. For more information on creating an integration service record, see Create Integration Service record.
You can manually run jobs for the following entities:
| Entity | Description | Table name |
|---|---|---|
| Currencies | Look up currencies from Coupa. | FX Currency Stage inbound staging table |
| FX Currency rates | Look up FX rates from Coupa. | FX Rate Stage inbound staging table |
| Legal entities | Look up legal entities from Coupa. | Legal Entity Stage inbound staging table |
| Purchase Line Shipment Details | Look up purchase line shipment details from Coupa. | Purchase Requisition staging table |
| Shipment Notices | Look up shipment notices from Coupa | - |
| Suppliers | Look up suppliers from Coupa. | Supplier Location inbound staging table |
| Cost Centers | Look up cost centers from Coupa. | Cost Center Stage inbound staging table |
| Supplier Payment Information | Look up supplier payment information from Coupa. | Supplier Payment inbound staging table |
| Invoices | Look up invoices from Coupa. | Invoice import inbound staging table |
| Purchase Orders | Look up purchase orders from Coupa | Purchase Order inbound staging table |
| Invoice Payment Details | Look up invoice payment details from Coupa. | Invoice payment detail import inbound table |
| Receipts | Look up receipts from Coupa. | Receipt inbound staging table |
| Product Models | Look up product models from Coupa. | Product Model Stage inbound staging table |