UsersV4
Read the user's core identity profile.
Table Specific Information
Select
The add-in uses the SAP Concur APIs to process filters that refer to Id, UserName, and ExternalId. The add-in processes other filters client-side within the add-in.
Use the filters to retrieve data only for the authenticated user since SAP Concur requires Company Level Authentication for retrieving data for all users.
For example, the add-in offloads the processing of the following queries to the SAP Concur APIs:
SELECT * FROM UsersV4 WHERE UserName = '[email protected]' SELECT * FROM UsersV4 WHERE ExternalId = '1234_externalId' SELECT * FROM UsersV4 WHERE Id = '802546f7-52a4-4ce7-6380-d5a869af350f'Use the Id value returned from these queries when working with tables that require a UserId.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | False |
Unique identifier for the user, also known as the UUID. | |
| Active | Boolean | False |
If true, the user is active. | |
| UserName | String | False |
The name that can be used to login to Concur Travel and Expense. | |
| DisplayName | String | False |
The name of the user, suitable for public display. | |
| GivenName | String | False |
The given or first name of the user. | |
| MiddleName | String | False |
The middle name(s) of the user, if applicable. | |
| FamilyName | String | False |
The family or last name of the user. | |
| FormattedName | String | False |
The full name of the user, formatted for display. | |
| NickName | String | False |
The casual way to address the user. | |
| AddressesAggregate | String | False |
JSON aggregate of a physical mailing address for this user. | |
| DateOfBirth | Date | False |
The user's date of birth. | |
| EmailsAggregate | String | False |
JSON aggregate of the user's email addresses. | |
| EmergencyContactsAggregate | String | False |
JSON aggregate of emergency contact information for the user. | |
| Entitlements | String | False |
The features enabled for the user. Supported values: Expense, Invoice, Locate, Request, Travel. | |
| ExternalId | String | False |
User identifier from the provisioning client. | |
| Created | Datetime | False |
The datetime the user was created. | |
| LastModified | Datetime | False |
The datetime the user was last modified. | |
| PhoneNumbersAggregate | String | False |
JSON aggregate of the user's phone numbers. | |
| Timezone | String | False |
The user's time zone in the Olson time zone database format. | |
| Title | String | False |
The user's job title in the company. | |
| CompanyId | String | False |
The SAP Concur ID of the company. | |
| EmployeeNumber | String | False |
Client supplied employee number within the company, unique for the company. | |
| UserStartDate | Datetime | False |
The user's start date. | |
| UserTerminationDate | Datetime | False |
The user's termination date. | |
| CostCenter | String | False |
The employee cost center for product. | |
| PreferredLanguage | String | False |
Indicates the user's preferred written or spoken language. | |
| PreferenceEndDayViewHour | String | False |
Preferred hour setting for the end of day. | |
| PreferenceFirstDayOfWeek | String | False |
Preferred first day of the week for the user. | |
| PreferenceDateFormat | String | False |
Preferred date format for the user. | |
| PreferenceCurrencySymbolLocation | String | False |
Preferred currency symbol location for the user. Supported values: BeforeAmount, AfterAmount. | |
| PreferenceHourMinuteSeparator | String | False |
Preferred separator between hour and minute. | |
| PreferenceDistance | String | False |
Preferred distance metric. Supported values: mile, km. | |
| PreferenceDefaultCalView | String | False |
Preferred default calendar view for the user. Supported values: day, week, month. | |
| Preference24Hour | String | False |
Preferred 24 hour format for the user. | |
| PreferenceNumberFormat | String | False |
Preferred number format for the user. | |
| PreferenceStartDayViewHour | String | False |
Preferred start of day for the user, from 1. | |
| PreferenceNegativeCurrencyFormat | String | False |
Preferred negative currency format for the user. | |
| PreferenceNegativeNumberFormat | String | False |
Preferred negative number format for the user. | |
| SchemasAggregate | String | False |
A serialized or aggregated representation of the user's schema-specific settings or data access configurations, used for managing user entitlements across different data partitions or modules. |