Excel Add-In for SAP Concur

Build 24.0.9062

UsersV4

Read the user's core identity profile.

Table Specific Information

Select

The 本製品 uses the SAP Concur APIs to process filters that refer to Id, UserName, and ExternalId. The 本製品 processes other filters client-side within the 本製品.

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 本製品 will offload 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 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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062