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
Supplier Items Export
Supplier Items 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/Supplier_Items.
Export of these records is limited to those customers with the Additional SFTP Exports license.
| Position | Column Name | Description | Type | Req'd/Unique | Allowable Values |
|---|---|---|---|---|---|
| 1 | Name | Item's Name | string(255) | No/No | any |
| 2 | Description | Item's Description | text | No/No | any |
| 3 | UOM Code | Item's Unit Of Measure Code | string(6) | No/No | Must be active in Coupa |
| 4 | Purchasable | Flag if item is purchasable | boolean | No/No | Yes/No |
| 5 | Item Number | Item Number | string(255) | No/No | any |
| 6 | Image Url | Item's Image Url | string(255) | No/No | URL |
| 7 | Commodity | Item's Commodity Name | string(255) | No/No | any |
| 8 | Tags | Item's Tags | (string300) | No/No | 30 characters per tag; maximum of 10 tags |
| 9 | Require Inspection? | Does the item require an Inspection? | boolean | No/No | Yes/No |
| 10 | Require Asset Tag? | Does the item require an Asset Tag? | boolean | No/No | Yes/No |
| 11 | Require RFID? | Does the item require an RFID tag? | boolean | No/No | Yes/No |
| 12 | Supplier | Supplier's Name | string(100) | No/No | any |
| 13 | Preferred | Is the item a preferred item? | boolean | No/No | Yes/No |
| 14 | Contract Number | Contract Number | string(50) | No/No | any |
| 15 | Price | Price for item | decimal(30,6) | No/No | Numerical |
| 16 | Currency | Currency Code for item | string(6) | No/No | ISO 4217 three letter currency code |
| 17 | Supplier Part Num | Supplier Part Number | string(255) | Yes/No | any |
| 18 | Lead Time | Lead Time for item | integer(11) | No/No | any |
| 19 | Manufacturer | Manufacturer Name | string(255) | No/No | any |
| 20 | Savings % | Captured Savings % for this item | decimal(8,2) | No/No | Numerical |
| 21 | Created At | Date document was created | datetime | No/No | YYYY-MM-DDTHH:MM:SS+HH:MM |
| 22 | Updated At | Date document was last updated | datetime | No/No | YYYY-MM-DDTHH:MM:SS+HH:MM |
| 23 | Created By (Email) | Email of user who created the record | string(255) | No/No | Must be in valid email format: user@example.com |
| 24 | Created By (Employee Number) | Employee Number of user who created the record | string(255) | No/No | any |
| 25 | Created By (Login) | Login of user who created the record | string(255) | No/No | any |
| 26 | Updated By (Email) | Email of user who last updated the record | string(255) | No/No | Must be in valid email format: user@example.com |
| 27 | Updated By (Employee Number) | Employee Number of user who last updated the record | string(255) | No/No | any |
| 28 | Updated By (Login) | Login of user who last updated the record | string(255) | No/No | any |
| 29 | Supplier Minimum Order Quantity | Supplier Minimum Order Quantity | decimal(30,6) | No/No | any |
| 30 | Supplier Order Increment | Supplier Order Increment | decimal(30,6) | No/No | any |