User Export

Export of these records is included as a Standard CSV Export.

User

Field NameDescriptionField TypeRequired/UniquePossible Values
LoginLoginstring(255)Yes/Yes
StatusStatusstring(255)No/No
IdIdintegerNo/No
Purchasing LicensePurchasing LicensebooleanNo/No
Expense LicenseExpense LicensebooleanNo/No
Analytics LicenseAnalytics LicensebooleanNo/No
AI Classification LicenseAI Classification LicensebooleanNo/No
Spend Guard LicenseSpend Guard LicensebooleanNo/No
Contingent Workforce LicenseContingent Workforce LicensebooleanNo/No
Supply Chain LicenseSupply Chain LicensebooleanNo/No
Risk Assess LicenseRisk Assess LicensebooleanNo/No
Authentication MethodAuthentication Methodstring(255)No/No
Single Sign-on IDSingle Sign-on IDstring(255)No/No
EmailEmailstring(255)Yes/Yes
FirstnameFirstnamestring(40)Yes/No
LastnameLastnamestring(40)Yes/No
Employee NumberEmployee Numberstring(255)No/Yes
DepartmentDepartmentNo/No
Phone WorkPhone Workstring(255)No/No
Phone MobilePhone Mobilestring(255)No/No
Approval Limit NameApproval Limit NameNo/No
Approval Limit AmountApproval Limit AmountNo/No
Approval Limit CurrencyApproval Limit CurrencyNo/No
Self-Approval Limit NameSelf-Approval Limit NameNo/No
Self-Approval Limit AmountSelf-Approval Limit AmountNo/No
Self-Approval Limit CurrencySelf-Approval Limit CurrencyNo/No
Service/Time Sheets Approval Limit AmountService/Time Sheets Approval Limit AmountNo/No
Service/Time Sheets Approval Limit CurrencyService/Time Sheets Approval Limit CurrencyNo/No
Approver LoginApprover LoginNo/No
Default Chart Of Accounts NameDefault Chart Of Accounts NameNo/No
Default Chart Of Accounts CodeDefault Chart Of Accounts CodeNo/No
Default Chart Of Accounts CCW FlagDefault Chart Of Accounts CCW FlagNo/No
Default Account Code Segment-1Default Account Code Segment-1No/No
Default Account Code Segment-1 CategoryDefault Account Code Segment-1 CategoryNo/No
Default Account Code Segment-2Default Account Code Segment-2No/No
Default Account Code Segment-2 CategoryDefault Account Code Segment-2 CategoryNo/No
Default Account Code Segment-3Default Account Code Segment-3No/No
Default Account Code Segment-3 CategoryDefault Account Code Segment-3 CategoryNo/No
Default Account Code Segment-4Default Account Code Segment-4No/No
Default Account Code Segment-4 CategoryDefault Account Code Segment-4 CategoryNo/No
Default Account Code Segment-5Default Account Code Segment-5No/No
Default Account Code Segment-5 CategoryDefault Account Code Segment-5 CategoryNo/No
Default Account Code Segment-6Default Account Code Segment-6No/No
Default Account Code Segment-6 CategoryDefault Account Code Segment-6 CategoryNo/No
Default Account Code Segment-7Default Account Code Segment-7No/No
Default Account Code Segment-7 CategoryDefault Account Code Segment-7 CategoryNo/No
Default Account Code Segment-8Default Account Code Segment-8No/No
Default Account Code Segment-8 CategoryDefault Account Code Segment-8 CategoryNo/No
Default Account Code Segment-9Default Account Code Segment-9No/No
Default Account Code Segment-9 CategoryDefault Account Code Segment-9 CategoryNo/No
Default Account Code Segment-10Default Account Code Segment-10No/No
Default Account Code Segment-10 CategoryDefault Account Code Segment-10 CategoryNo/No
Default Account Code Segment-11Default Account Code Segment-11No/No
Default Account Code Segment-11 CategoryDefault Account Code Segment-11 CategoryNo/No
Default Account Code Segment-12Default Account Code Segment-12No/No
Default Account Code Segment-12 CategoryDefault Account Code Segment-12 CategoryNo/No
Default Account Code Segment-13Default Account Code Segment-13No/No
Default Account Code Segment-13 CategoryDefault Account Code Segment-13 CategoryNo/No
Default Account Code Segment-14Default Account Code Segment-14No/No
Default Account Code Segment-14 CategoryDefault Account Code Segment-14 CategoryNo/No
Default Account Code Segment-15Default Account Code Segment-15No/No
Default Account Code Segment-15 CategoryDefault Account Code Segment-15 CategoryNo/No
Default Account Code Segment-16Default Account Code Segment-16No/No
Default Account Code Segment-16 CategoryDefault Account Code Segment-16 CategoryNo/No
Default Account Code Segment-17Default Account Code Segment-17No/No
Default Account Code Segment-17 CategoryDefault Account Code Segment-17 CategoryNo/No
Default Account Code Segment-18Default Account Code Segment-18No/No
Default Account Code Segment-18 CategoryDefault Account Code Segment-18 CategoryNo/No
Default Account Code Segment-19Default Account Code Segment-19No/No
Default Account Code Segment-19 CategoryDefault Account Code Segment-19 CategoryNo/No
Default Account Code Segment-20Default Account Code Segment-20No/No
Default Account Code Segment-20 CategoryDefault Account Code Segment-20 CategoryNo/No
User Role NamesUser Role NamesRoleNo/No
Default CurrencyDefault CurrencyNo/No
Default LocaleDefault Localestring(10)No/No
Pcard NamePcard NameNo/No
Content GroupsContent GroupsBusinessGroupNo/No
Default Address AttentionDefault Address AttentionNo/No
Default Address Street1Default Address Street1No/No
Default Address Street2Default Address Street2No/No
Default Address CityDefault Address CityNo/No
Default Address StateDefault Address StateNo/No
Default Address Postal CodeDefault Address Postal CodeNo/No
Default Address Country CodeDefault Address Country CodeNo/No
Receive Coupa EmailsReceive Coupa EmailsbooleanNo/No
Limited Data Table ViewingLimited Data Table ViewingbooleanNo/No
Account Security TypeAccount Security TypeintegerNo/No
Account Group NamesAccount Group NamesAccountGroupNo/No
Approval Group NamesApproval Group NamesUserGroupNo/No
Country Of Residence CodeCountry of Residence CodeNo/No
Avatar Thumbnail URLAvatar Thumbnail URLNo/No
MSP UserMSP UserNo/No
Category Planner LicenseCategory Planner LicensebooleanNo/No
Intake LicenseIntake LicensebooleanNo/No
Category Strategry UserCategory Strategry UserbooleanNo/No

User Group

Position Column Name Description Type Req/Unique Allowable Values
1 custom-field-1 Integration Custom Field 1 No/No any
2 custom-field-2 Integration Custom Field 2 No/No any
3 custom-field-3 Integration Custom Field 3 No/No any
4 custom-field-4 Integration Custom Field 4 No/No any
5 custom-field-5 Integration Custom Field 5 No/No any
6 custom-field-6 Integration Custom Field 6 No/No any
7 custom-field-7 Integration Custom Field 7 No/No any
8 custom-field-8 Integration Custom Field 8 No/No any
9 custom-field-9 Integration Custom Field 9 No/No any
10 custom-field-10 Integration Custom Field 10 No/No any