ODBC Driver for SAP Concur

Build 22.0.8462

Attendees

Create, update, delete, and query all attendees owned by the specified user.

Table Specific Information

Select

The driver uses the SAP Concur APIs to process filters that refer to Id or to AttendeeTypeId and LoginId. The driver processes other filters client-side within the driver.

For example, the driver will offload the processing of the following queries to the SAP Concur APIs: 

SELECT * FROM Attendees WHERE Id = 'attendeeId'
SELECT * FROM Attendees WHERE AttendeeTypeId = 'attendeeTypeId' AND LoginId = 'loginID'

Insert

To insert an attendee the following columns are required: AttendeeTypeId and LastName. 

INSERT INTO Attendees (AttendeeTypeId, FirstName, LastName, Company, CurrencyCode, MiddleInitial, Suffix, Title, TotalAmountYTD) VALUES ('IdValue', 'John', 'Doe', 'CDATA', 'USD', 'C', 'SuffixValue', 'TitleValue', 1000);

Update

To update an attendee the following column is required: Id. 

UPDATE Attendees SET LastName = 'newlastname' WHERE ID = '123456'

Delete

Deletes are not supported for this table.

Columns

Name Type ReadOnly References Description
ID [KEY] String True

The unique identifier of the resource.

Custom10ListItemID String True

For list fields, this is the list item ID.

AttendeeTypeID String False

The ID of the attendee type.

Custom11ListItemID String True

For list fields, this is the list item ID.

Custom12ListItemID String True

For list fields, this is the list item ID.

Custom13ListItemID String True

For list fields, this is the list item ID.

Custom14ListItemID String True

For list fields, this is the list item ID.

Custom15ListItemID String True

For list fields, this is the list item ID.

Custom16ListItemID String True

For list fields, this is the list item ID.

Custom17ListItemID String True

For list fields, this is the list item ID.

Custom18ListItemID String True

For list fields, this is the list item ID.

Custom19ListItemID String True

For list fields, this is the list item ID.

Custom1ListItemID String True

For list fields, this is the list item ID.

Custom20ListItemID String True

For list fields, this is the list item ID.

Custom21ListItemID String True

For list fields, this is the list item ID.

Custom22ListItemID String True

For list fields, this is the list item ID.

Custom23ListItemID String True

For list fields, this is the list item ID.

Custom24ListItemID String True

For list fields, this is the list item ID.

Custom25ListItemID String True

For list fields, this is the list item ID.

Custom2ListItemID String True

For list fields, this is the list item ID.

Custom3ListItemID String True

For list fields, this is the list item ID.

Custom4ListItemID String True

For list fields, this is the list item ID.

Custom5ListItemID String True

For list fields, this is the list item ID.

Custom6ListItemID String True

For list fields, this is the list item ID.

Custom7ListItemID String True

For list fields, this is the list item ID.

Custom8ListItemID String True

For list fields, this is the list item ID.

Custom9ListItemID String True

For list fields, this is the list item ID.

ExternalID String False

A unique identifier for the attendee, assigned outside of Concur. Maximum length: 48 characters

MiddleInitial String False

The attendee's middle initial. Maximum length: 1 character

OwnerLoginID String True

The login ID of the user who owns the attendee record.

AttendeeTypeCode String True

A code that indicates the type of attendee. Examples: EMPLOYEE, SPOUSE, BUSGUEST. Maximum length: 40 characters

Company String False

The name of the attendee's company. Maximum length: 150 characters

CurrencyCode String False

The ISO 4217 currency code for monetary amounts related to an attendee.

Custom10Code String True

For list fields, this is the list item code.

Custom10Type String True

The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text

Custom10Value String False

The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters

Custom11Code String True

For list fields, this is the list item code.

Custom11Type String True

The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text

Custom11Value String False

The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters

Custom12Code String True

For list fields, this is the list item code.

Custom12Type String True

The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text

Custom12Value String False

The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters

Custom13Code String True

For list fields, this is the list item code.

Custom13Type String True

The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text

Custom13Value String False

The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters

Custom14Code String True

For list fields, this is the list item code.

Custom14Type String True

The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text

Custom14Value String False

The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters

Custom15Code String True

For list fields, this is the list item code.

Custom15Type String True

The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text

Custom15Value String False

The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters

Custom16Code String True

For list fields, this is the list item code.

Custom16Type String True

The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text

Custom16Value String False

The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters

Custom17Code String True

For list fields, this is the list item code.

Custom17Type String True

The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text

Custom17Value String False

The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters

Custom18Code String True

For list fields, this is the list item code.

Custom18Type String True

The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text

Custom18Value String False

The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters

Custom19Code String True

For list fields, this is the list item code.

Custom19Type String True

The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text

Custom19Value String False

The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters

Custom1Code String True

For list fields, this is the list item code.

Custom1Type String True

The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text

Custom1Value String False

The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters

Custom20Code String True

For list fields, this is the list item code.

Custom20Type String True

The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text

Custom20Value String False

The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters

Custom21Code String True

For list fields, this is the list item code.

Custom21Type String True

The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text

Custom21Value String False

The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters

Custom22Code String True

For list fields, this is the list item code.

Custom22Type String True

The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text

Custom22Value String False

The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters

Custom23Code String True

For list fields, this is the list item code.

Custom23Type String True

The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text

Custom23Value String False

The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters

Custom24Code String True

For list fields, this is the list item code.

Custom24Type String True

The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text

Custom24Value String False

The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters

Custom25Code String True

For list fields, this is the list item code.

Custom25Type String True

The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text

Custom25Value String False

The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters

Custom2Code String True

For list fields, this is the list item code.

Custom2Type String True

The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text

Custom2Value String False

The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters

Custom3Code String True

For list fields, this is the list item code.

Custom3Type String True

The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text

Custom3Value String False

The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters

Custom4Code String True

For list fields, this is the list item code.

Custom4Type String True

The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text

Custom4Value String False

The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters

Custom5Code String True

For list fields, this is the list item code.

Custom5Type String True

The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text

Custom5Value String False

The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters

Custom6Code String True

For list fields, this is the list item code.

Custom6Type String True

The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text

Custom6Value String False

The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters

Custom7Code String True

For list fields, this is the list item code.

Custom7Type String True

The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text

Custom7Value String False

The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters

Custom8Code String True

For list fields, this is the list item code.

Custom8Type String True

The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text

Custom8Value String False

The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters

Custom9Code String True

For list fields, this is the list item code.

Custom9Type String True

The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text

Custom9Value String False

The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters

FirstName String False

The attendee's first name. Maximum length: 50 characters

HasExceptionsPrevYear Bool True

Determines whether the attendee had exceptions in the previous year, based on yearly total limits for attendees. Format: true or false

HasExceptionsYTD Bool True

Determines whether the attendee has exceptions in the current year, based on yearly total limits for attendees. Format: true or false

LastName String False

The attendee's last name. Maximum length: 132 characters

OwnerName String True

The name of the user who owns the attendee record.

Suffix String False

The attendee's name suffix. Maximum length: 32 characters

Title String False

The attendee's title. Maximum length: 32 characters

TotalAmountPrevYear Decimal True

The total amount spent on the attendee in the previous calendar year.

TotalAmountYTD Decimal False

The total amount spent on the attendee in the current calendar year.

URI String True

The URI to the resource.

VersionNumber Int True

The attendee's version number.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
LoginId String

The login ID of the user that has added the attendee to an expense. The user who is performing this API request must have the Web Services Admin (Professional) or Can Administer (Standard) user role to use this parameter.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462