Skip to main content

 

 

Coupa Success Portal

Suppliers Export

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.

Supplier header columns

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

 

  • Was this article helpful?