What can we help you find?
Products
Platform
Integration Playbooks and Resources
Other Integration Playbooks
Additional CSV Exports
Users Export
Users Export
Revised: 28 May 2019
Overview
The users export process from Coupa queries for all users within Coupa. The frequency of the integration run is once per day. The generated files will be placed into ./Outgoing/Users.
Export of these records is limited to those customers with the Additional SFTP Exports license.
| Column Name | Description | Req'd | Unique | Type | Allowable Values |
|---|---|---|---|---|---|
| Login | Login | TRUE | TRUE | string(255) | any |
| Status | Status | FALSE | FALSE | string(255) | any |
| Id | Id | FALSE | FALSE | integer | any |
| Purchasing License | Purchasing License | FALSE | FALSE | boolean | any |
| Expense License | Expense License | FALSE | FALSE | boolean | any |
| Analytics License | Analytics License | FALSE | FALSE | boolean | any |
| AI Classification License | AI Classification License | FALSE | FALSE | boolean | any |
| Spend Guard License | Spend Guard License | FALSE | FALSE | boolean | any |
| Authentication Method | Authentication Method | FALSE | FALSE | string(255) | any |
| Single Sign-on ID | Single Sign-on ID | FALSE | FALSE | string(255) | any |
| TRUE | TRUE | string(255) | Must be in valid email format: user@example.com | ||
| Firstname | Firstname | TRUE | FALSE | string(40) | any |
| Lastname | Lastname | TRUE | FALSE | string(40) | any |
| Employee Number | Employee Number | FALSE | TRUE | string(255) | any |
| Department | Department | FALSE | FALSE | string(255) | any |
| Phone Work | Phone Work | FALSE | FALSE | string(255) | any |
| Phone Mobile | Phone Mobile | FALSE | FALSE | string(255) | any |
| Approval Limit Name | Approval Limit Name | FALSE | FALSE | string(255) | any |
| Approval Limit Amount | Approval Limit Amount | FALSE | FALSE | integer | any |
| Approval Limit Currency | Approval Limit Currency | FALSE | FALSE | string | any |
| Self-Approval Limit Name | Self-Approval Limit Name | FALSE | FALSE | string | any |
| Self-Approval Limit Amount | Self-Approval Limit Amount | FALSE | FALSE | integer | any |
| Self-Approval Limit Currency | Self-Approval Limit Currency | FALSE | FALSE | string | any |
| Approver Login | Approver Login | FALSE | FALSE | string | any |
| Default Chart Of Accounts Name | Default Chart Of Accounts Name | FALSE | FALSE | string | any |
| Default Chart Of Accounts Code | Default Chart Of Accounts Code | FALSE | FALSE | string | any |
| Default Account Code Segment-1 | Default Account Code Segment-1 | FALSE | FALSE | string(100) | any |
| Default Account Code Segment-2 | Default Account Code Segment-2 | FALSE | FALSE | string(100) | any |
| Default Account Code Segment-3 | Default Account Code Segment-3 | FALSE | FALSE | string(100) | any |
| Default Account Code Segment-4 | Default Account Code Segment-4 | FALSE | FALSE | string(100) | any |
| Default Account Code Segment-5 | Default Account Code Segment-5 | FALSE | FALSE | string(100) | any |
| Default Account Code Segment-6 | Default Account Code Segment-6 | FALSE | FALSE | string(100) | any |
| Default Account Code Segment-7 | Default Account Code Segment-7 | FALSE | FALSE | string(100) | any |
| Default Account Code Segment-8 | Default Account Code Segment-8 | FALSE | FALSE | string(100) | any |
| Default Account Code Segment-9 | Default Account Code Segment-9 | FALSE | FALSE | string(100) | any |
| Default Account Code Segment-10 | Default Account Code Segment-10 | FALSE | FALSE | string(100) | any |
| Default Account Code Segment-11 | Default Account Code Segment-11 | FALSE | FALSE | string(100) | any |
| Default Account Code Segment-12 | Default Account Code Segment-12 | FALSE | FALSE | string(100) | any |
| Default Account Code Segment-13 | Default Account Code Segment-13 | FALSE | FALSE | string(100) | any |
| Default Account Code Segment-14 | Default Account Code Segment-14 | FALSE | FALSE | string(100) | any |
| Default Account Code Segment-15 | Default Account Code Segment-15 | FALSE | FALSE | string(100) | any |
| Default Account Code Segment-16 | Default Account Code Segment-16 | FALSE | FALSE | string(100) | any |
| Default Account Code Segment-17 | Default Account Code Segment-17 | FALSE | FALSE | string(100) | any |
| Default Account Code Segment-18 | Default Account Code Segment-18 | FALSE | FALSE | string(100) | any |
| Default Account Code Segment-19 | Default Account Code Segment-19 | FALSE | FALSE | string(100) | any |
| Default Account Code Segment-20 | Default Account Code Segment-20 | FALSE | FALSE | string(100) | any |
| User Role Names | User Role Names | FALSE | FALSE | string | any |
| Default Currency | Default Currency | FALSE | FALSE | string | any |
| Default Locale | Default Locale | FALSE | FALSE | string(10) | See List of Default Locales |
| Pcard Name | Pcard Name | FALSE | FALSE | string | any |
| Content Groups | Content Groups | FALSE | FALSE | string | any |
| Default Address Attention | Default Address Attention | FALSE | FALSE | string(255) | any |
| Default Address Street1 | Default Address Street1 | FALSE | FALSE | string(100) | any |
| Default Address Street2 | Default Address Street2 | FALSE | FALSE | string(100) | any |
| Default Address City | Default Address City | FALSE | FALSE | string(50) | any |
| Default Address State | Default Address State | FALSE | FALSE | string(50) | any |
| Default Address Postal Code | Default Address Postal Code | FALSE | FALSE | string(50) | any |
| Default Address Country Code | Default Address Country Code | FALSE | FALSE | string | any |
| Receive Coupa Emails | Receive Coupa Emails | FALSE | FALSE | boolean | any |
| Limited Data Table Viewing | Limited Data Table Viewing | FALSE | FALSE | boolean | any |
| Account Security Type | Account Security Type | FALSE | FALSE | integer | any |
| Account Group Names | Account Group Names | FALSE | FALSE | string | any |
| Approval Group Names | Approval Group Names | FALSE | FALSE | string | any |
| custom-field-1 | Integration Custom Field 1 | FALSE | FALSE | string(255) | any |
| custom-field-2 | Integration Custom Field 2 | FALSE | FALSE | string(255) | any |
| custom-field-3 | Integration Custom Field 3 | FALSE | FALSE | string(255) | any |
| custom-field-4 | Integration Custom Field 4 | FALSE | FALSE | string(255) | any |
| custom-field-5 | Integration Custom Field 5 | FALSE | FALSE | string(255) | any |
| custom-field-6 | Integration Custom Field 6 | FALSE | FALSE | string(255) | any |
| custom-field-7 | Integration Custom Field 7 | FALSE | FALSE | string(255) | any |
| custom-field-8 | Integration Custom Field 8 | FALSE | FALSE | string(255) | any |
| custom-field-9 | Integration Custom Field 9 | FALSE | FALSE | string(255) | any |
| custom-field-10 | Integration Custom Field 10 | FALSE | FALSE | string(255) | any |
| Country Of Residence Code | Country of Residence Code | FALSE | FALSE | any | |
| Seniority Level | |||||
| Business Function | |||||
| Contingent Workforce License | Contingent Workforce License | FALSE | FALSE | boolean | any |
| Default Chart Of Accounts CCW Flag | Default Chart Of Accounts CCW Flag | FALSE | FALSE | any | |
| Default Account Code Segment-1 Category | Default Account Code Segment-1 Category | FALSE | FALSE | any | |
| Default Account Code Segment-2 Category | Default Account Code Segment-2 Category | FALSE | FALSE | any | |
| Default Account Code Segment-3 Category | Default Account Code Segment-3 Category | FALSE | FALSE | any | |
| Default Account Code Segment-4 Category | Default Account Code Segment-4 Category | FALSE | FALSE | any | |
| Default Account Code Segment-5 Category | Default Account Code Segment-5 Category | FALSE | FALSE | any | |
| Default Account Code Segment-6 Category | Default Account Code Segment-6 Category | FALSE | FALSE | any | |
| Default Account Code Segment-7 Category | Default Account Code Segment-7 Category | FALSE | FALSE | any | |
| Default Account Code Segment-8 Category | Default Account Code Segment-8 Category | FALSE | FALSE | any | |
| Default Account Code Segment-9 Category | Default Account Code Segment-9 Category | FALSE | FALSE | any | |
| Default Account Code Segment-10 Category | Default Account Code Segment-10 Category | FALSE | FALSE | any | |
| Default Account Code Segment-11 Category | Default Account Code Segment-11 Category | FALSE | FALSE | any | |
| Default Account Code Segment-12 Category | Default Account Code Segment-12 Category | FALSE | FALSE | any | |
| Default Account Code Segment-13 Category | Default Account Code Segment-13 Category | FALSE | FALSE | any | |
| Default Account Code Segment-14 Category | Default Account Code Segment-14 Category | FALSE | FALSE | any | |
| Default Account Code Segment-15 Category | Default Account Code Segment-15 Category | FALSE | FALSE | any | |
| Default Account Code Segment-16 Category | Default Account Code Segment-16 Category | FALSE | FALSE | any | |
| Default Account Code Segment-17 Category | Default Account Code Segment-17 Category | FALSE | FALSE | any | |
| Default Account Code Segment-18 Category | Default Account Code Segment-18 Category | FALSE | FALSE | any | |
| Default Account Code Segment-19 Category | Default Account Code Segment-19 Category | FALSE | FALSE | any | |
| Default Account Code Segment-20 Category | Default Account Code Segment-20 Category | FALSE | FALSE | any | |
| Risk Assess License | Risk Assess License | FALSE | FALSE | boolean | any |
| Supply Chain License | Supply Chain License | FALSE | FALSE | boolean | any |
| Avatar Thumbnail URL | Avatar Thumbnail URL | FALSE | FALSE | UTL | any |
List of Default Locales
en, tr, ja, cs, es, da, de-AT, de-CH, de, en-AU, en-CA, en-CN, en-GB, en-IE, en-IN, en-ME, en-MT, en-PH, en-TW, en-ZA, es-CO, es-MX, es-PR, fi, fr-BE, fr-CA, fr-CH, fr, hu, it-CH, it, ko, nl-BE, nl, no, pl, pt-BR, pt, ru, sv, zh-CN, zh-TW, zh-HK, en, tr, ja, cs, es, da, de-AT, de-CH, de, en-AU, en-CA, en-GB, en-IE, en-ZA, es-CO, es-MX, es-PR, fi, fr-BE, fr-CA, fr-CH, fr, hu, it-CH, it, ko, nl-BE, nl, no, pl, pt-BR, pt, ru, sv, zh-CN, zh-TW, zh-HK, de-BE, de-LU, en-HK, en-MY, en-NZ, fr-LU, ro, sr, de-BE, de-LU, en-HK, en-MY, en-NZ, fr-LU, ro, sr, es-IC