SSIS Components for SAP Concur

Build 24.0.9060

Attendees

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

Table Specific Information

Select

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

For example, the component 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 Description
ID [KEY] String False

The unique identifier of the resource.

Custom10ListItemID String False

For list fields, this is the list item ID.

AttendeeTypeID String False

The ID of the attendee type.

Custom11ListItemID String False

For list fields, this is the list item ID.

Custom12ListItemID String False

For list fields, this is the list item ID.

Custom13ListItemID String False

For list fields, this is the list item ID.

Custom14ListItemID String False

For list fields, this is the list item ID.

Custom15ListItemID String False

For list fields, this is the list item ID.

Custom16ListItemID String False

For list fields, this is the list item ID.

Custom17ListItemID String False

For list fields, this is the list item ID.

Custom18ListItemID String False

For list fields, this is the list item ID.

Custom19ListItemID String False

For list fields, this is the list item ID.

Custom1ListItemID String False

For list fields, this is the list item ID.

Custom20ListItemID String False

For list fields, this is the list item ID.

Custom21ListItemID String False

For list fields, this is the list item ID.

Custom22ListItemID String False

For list fields, this is the list item ID.

Custom23ListItemID String False

For list fields, this is the list item ID.

Custom24ListItemID String False

For list fields, this is the list item ID.

Custom25ListItemID String False

For list fields, this is the list item ID.

Custom2ListItemID String False

For list fields, this is the list item ID.

Custom3ListItemID String False

For list fields, this is the list item ID.

Custom4ListItemID String False

For list fields, this is the list item ID.

Custom5ListItemID String False

For list fields, this is the list item ID.

Custom6ListItemID String False

For list fields, this is the list item ID.

Custom7ListItemID String False

For list fields, this is the list item ID.

Custom8ListItemID String False

For list fields, this is the list item ID.

Custom9ListItemID String False

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

LoginId String False

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

AttendeeTypeCode String False

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 False

For list fields, this is the list item code.

Custom10Type String False

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 False

For list fields, this is the list item code.

Custom11Type String False

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 False

For list fields, this is the list item code.

Custom12Type String False

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 False

For list fields, this is the list item code.

Custom13Type String False

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 False

For list fields, this is the list item code.

Custom14Type String False

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 False

For list fields, this is the list item code.

Custom15Type String False

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 False

For list fields, this is the list item code.

Custom16Type String False

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 False

For list fields, this is the list item code.

Custom17Type String False

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 False

For list fields, this is the list item code.

Custom18Type String False

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 False

For list fields, this is the list item code.

Custom19Type String False

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 False

For list fields, this is the list item code.

Custom1Type String False

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 False

For list fields, this is the list item code.

Custom20Type String False

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 False

For list fields, this is the list item code.

Custom21Type String False

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 False

For list fields, this is the list item code.

Custom22Type String False

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 False

For list fields, this is the list item code.

Custom23Type String False

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 False

For list fields, this is the list item code.

Custom24Type String False

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 False

For list fields, this is the list item code.

Custom25Type String False

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 False

For list fields, this is the list item code.

Custom2Type String False

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 False

For list fields, this is the list item code.

Custom3Type String False

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 False

For list fields, this is the list item code.

Custom4Type String False

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 False

For list fields, this is the list item code.

Custom5Type String False

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 False

For list fields, this is the list item code.

Custom6Type String False

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 False

For list fields, this is the list item code.

Custom7Type String False

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 False

For list fields, this is the list item code.

Custom8Type String False

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 False

For list fields, this is the list item code.

Custom9Type String False

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 False

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

HasExceptionsYTD Bool False

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 False

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 False

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 False

The URI to the resource.

VersionNumber Int False

The attendee's version number.

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