AttendeeTypes
Create, update, delete, and query all active attendee types for the company.
Table Specific Information
Select
The provider uses the SAP Concur APIs to process a filter that refers to Id. The provider processes other filters client-side within the provider.
For example, the provider will offload the processing of the following query to the SAP Concur APIs:
SELECT * FROM AttendeeTypes WHERE Id = '123456'
Insert
To insert an attendee type the following columns are required: Name, Code, AttendeeFormId, and DuplicateSearchFields.
INSERT INTO AttendeeTypes (Name, Code, AttendeeFormId, DuplicateSearchFields) VALUES ('AttendeeTypeName', '01234', '123456', 'Title,Company')
Update
To update an attendee type the following column is required: Id.
UPDATE AttendeeTypes SET Code = 'BUSGUEST' WHERE Id = 'gWjEPiokzJTpMsdq34zvJEM$ptCXpT'
Delete
Deletes are not supported for this table.
Columns
Name | Type | ReadOnly | References | Description |
ID [KEY] | String | True |
The URI of the next page of results, if any. | |
AttendeeFormID | String | False |
The unique identifier for the attendee form for this attendee type. | |
ConnectorID | String | False |
The unique identifier for the Application Connector that is the data source for this attendee type. When this field is empty, the Expense database is the data source. | |
AllowAttendeeCountEditing | Bool | False |
Determines whether users are allowed to edit the count for this attendee type. Format: true or false | |
AllowManuallyEnteredAttendees | Bool | False |
Determines whether users are allowed to add attendees for this attendee type. Format: true or false | |
Code | String | False |
A code that indicates the type of attendee. Examples: EMPLOYEE, SPOUSE, BUSGUEST. Maximum length: 40 characters | |
DuplicateSearchFields | String | False |
The list of Attendee field IDs used by the Add Attendee user interface to alert users that the attendee they want to add is a possible duplicate. This parent element has a DuplicateSearchField child element for each field ID. | |
Name | String | False |
The name for the attendee type. This name must be unique. Maximum length: 40 characters | |
URI | String | True |
The URI of the next page of results, if any. |