Share your thoughts about your self-service experience by completing this year’s survey.
What can we help you find?
Products
Total Spend Management Platform
Integration Playbooks and Resources
Other Integration Playbooks
Additional CSV Exports
Suppliers Export
Suppliers Export
Revised: 28 May 2019
Overview
The suppliers export process from Coupa queries for all suppliers. The frequency of the integration run is once per day. The generated files will be placed into ./Outgoing/Suppliers.
Export of these records is limited to those customers with the Additional SFTP Exports license.
| Position | Column Name | Description | Req/Unique | Type | Allowable Values |
|---|---|---|---|---|---|
| 1 | Name | Name | Yes/Yes | string(100) | any |
| 2 | Status | Status | No/No | string(20) | any |
| 3 | Id | Id | No/No | integer(11) | any |
| 4 | Commodity | Commodity | No/No | string(255) | Commodity must exist in Coupa |
| 5 | Supplier Number | Supplier Number | No/Yes | string(255) | any |
| 6 | Account Number | Account Number | No/No | string(255) | any |
| 7 | Tax ID | Tax ID | No/No | string(255) | any |
| 8 | DUNS | DUNS | No/No | string(255) | any |
| 9 | Online Store URL | Online Store URL | No/No | string(255) | any |
| 10 | Online Store Login | Online Store Login | No/No | string(255) | any |
| 11 | Primary Contact Email | Primary Contact Email | No/No | string(255) | any |
| 12 | Primary Contact Phone Work | Primary Contact Phone Work | No/No | integer(11) | any |
| 13 | Primary Contact Phone Mobile | Primary Contact Phone Mobile | No/No | integer(11) | any |
| 14 | Primary Contact Phone Fax | Primary Contact Phone Fax | No/No | integer(11) | any |
| 15 | Primary Contact Name Given | Primary Contact Name Given | No/No | string(40) | any |
| 16 | Primary Contact Name Family | Primary Contact Name Family | No/No | string(40) | any |
| 17 | Primary Address Street1 | Primary Address Street1 | No/No | string(255) | any |
| 18 | Primary Address Street2 | Primary Address Street2 | No/No | string(100) | any |
| 19 | Primary Address City | Primary Address City | No/No | string(100) | any |
| 20 | Primary Address State | Primary Address State | No/No | string(50) | any |
| 21 | Primary Address Postal Code | Primary Address Postal Code | No/No | string(50) | any |
| 22 | Primary Address Country Code | Primary Address Country Code | No/No | string(50) | any |
| 23 | Primary Address Tax Number | Primary Address Tax Number | No/No | string(255) | any |
| 24 | Primary Address Tax Country Code | Primary Address Tax Country Code | No/No | string(100) | any |
| 25 | Primary Address Local Tax Number | Primary Address Local Tax Number | No/No | string(255) | any |
| 26 | Invoice Matching Level | Invoice Matching Level | No/No | string(255) | 2-way, 3-way, none |
| 27 | Po Method | Po Method | No/No | string(255) | cxml, xml, email, prompt, mark_as_sent, buy_online |
| 28 | PO Change Method' | PO Change Method' | No/No | string(255) | cxml, xml, email, prompt, mark_as_sent, buy_online |
| 29 | Buyer Hold | Buyer Hold | No/No | boolean | Yes/No, True/False |
| 30 | Default Locale | Will accept any valid locale short code i.e. en, en-GB, fr, fr-CA, etc. | No/No | string(255) | |
| 31 | PO Email | PO Email | Yes/No | string(255) | any |
| 32 | Payment Method | Must be "Invoice", "P-Card", "Invoice Only", or "P-Card Only" | Yes/No | string(255) | |
| 33 | Payment Method | Payment Method | Yes/No | string(255) | invoice, pcard, invoice_only, pcard_only, virtual_card |
| 34 | Virtual Card Email | Required when Payment Method = virtual_card; supplier email where Virtual Cards are sent | Yes/No | string(255) | any |
| 35 | Payment Terms | Payment Terms | No/No | integer(11) | any |
| 36 | Shipping Terms | Shipping Terms | No/No | integer(11) | any |
| 37 | PO cXML URL | PO cXML URL | Yes/No | string(255) | any |
| 38 | PO cXML Domain | PO cXML Domain | Yes/No | string(255) | any |
| 39 | PO cXML Identity | PO cXML Identity | Yes/No | string(255) | any |
| 40 | PO cXML Supplier Domain | PO cXML Supplier Domain | Yes/No | string(255) | any |
| 41 | PO cXML Supplier Identity | PO cXML Supplier Identity | Yes/No | string(255) | any |
| 42 | PO cXML Secret | PO cXML Secret | Yes/No | string(940) | any |
| 43 | PO cXML Protocol | PO cXML Protocol | Yes/No | string(255) | any |
| 44 | Savings (%) | Savings (%) | No/No | decimal(8,2) | any |
| 45 | On Hold | On Hold | No/No | boolean | Yes/No, True/False |
| 46 | Allow cXML Invoicing | Allow cXML Invoicing | No/No | boolean | Yes/No, True/False |
| 47 | cXML Invoicing - Supplier Domain | cXML Invoicing - Supplier Domain | Yes/No | string(255) | any |
| 48 | cXML Invoicing - Supplier Identity | cXML Invoicing - Supplier Identity | Yes/Yes | string(255) | any |
| 49 | cXML Invoicing - Buyer Domain | cXML Invoicing - Buyer Domain | Yes/No | string(255) | any |
| 50 | cXML Invoicing - Buyer Identity | cXML Invoicing - Buyer Identity | Yes/No | string(255) | any |
| 51 | cXML Invoicing Shared Key | cXML Invoicing Shared Key | Yes/No | string(255) | any |
| 52 | Invoice Emails | Invoice Emails | No/No | string(255) | any |
| 53 | Send Invoices To Approvals | Send Invoices To Approvals | No/No | boolean | Yes/No, True/False |
| 54 | Allow Invoicing From CSN | Allow Invoicing From CSN | No/No | boolean | Yes/No, True/False |
| 55 | Allow Invoicing No Backing Doc From CSN | Allow Invoicing No Backing Doc From CSN | No/No | boolean | Yes/No, True/False |
| 56 | custom-field-1 | Integration Custom Field 1 | No/No | string(255) | any |
| 57 | custom-field-2 | Integration Custom Field 2 | No/No | string(255) | any |
| 58 | custom-field-3 | Integration Custom Field 3 | No/No | string(255) | any |
| 59 | custom-field-4 | Integration Custom Field 4 | No/No | string(255) | any |
| 60 | custom-field-5 | Integration Custom Field 5 | No/No | string(255) | any |
| 61 | custom-field-6 | Integration Custom Field 6 | No/No | string(255) | any |
| 62 | custom-field-7 | Integration Custom Field 7 | No/No | string(255) | any |
| 63 | custom-field-8 | Integration Custom Field 8 | No/No | string(255) | any |
| 64 | custom-field-9 | Integration Custom Field 9 | No/No | string(255) | any |
| 65 | custom-field-10 | Integration Custom Field 10 | No/No | string(255) | any |
| 66 | Virtual Card Email | Email where Virtual Cards are sent when Payment Method is Virtual Card | Yes/No | string(255) | any |
| 67 | PO cXML Secret | Required if PO method is cXML and wasn't previously configured. | Yes/No | string(940) | any |
| 68 | PO cXML HTTP Basic Auth Password | Required if sending PO cXML requires HTTP Basic Auth. | Yes/No | string(255) | any |