EntryAttendeeAssociations
Create, update, delete, and query all entry-attendee associations owned by the user. These are the associations between an expense entry and an attendee.
Table Specific Information
Select
The component uses the SAP Concur APIs to process filters that refer to Id or to EntryId 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 EntryAttendeeAssociations WHERE Id = 'sampleId' SELECT * FROM EntryAttendeeAssociations WHERE EntryId = 'sampleEntryId' AND LoginId = 'LoginId'
Insert
To insert a new record in EntryAttendeeAssociations the following columns are required: EntryId and AttendeeId.
INSERT INTO EntryAttendeeAssociations (EntryId, AttendeeId) VALUES ('EntryIdValue', 'AttendeeIdValue')
Update
To update a record in EntryAttendeeAssociations the following column is required: Id. The EntryId and AttendeeId columns cannot be updated.
UPDATE EntryAttendeeAssociations SET Custom = 'Custom' WHERE Id = '12345'
Delete
To delete a department, the following column is required: Id.
DELETE FROM EntryAttendeeAssociations WHERE Id = '123456'
Columns
Name | Type | ReadOnly | References | Description |
ID [KEY] | String | True |
The primary key. | |
AttendeeID | String | False |
The unique identifier of the associated attendee. To obtain the attendee ID value, use the GET /expense/attendees endpoint. The value of the ID element in the response is the attendee ID. | |
EntryID | String | False |
The unique identifier of the associated entry. To obtain the attendee ID value, use the GET /expense/entries endpoint. The value of the ID element in the response is the entry ID. | |
Amount | Decimal | False |
The portion of the entry transaction amount assigned to this attendee. | |
AssociatedAttendeeCount | Int | False |
The count of additional attendees associated with this attendee. A count greater than 1 means there are unnamed attendees associated with this attendee. | |
Custom1 | String | False |
The details from the Custom fields. These fields may not have data, depending on the configuration. | |
Custom2 | String | False |
The details from the Custom fields. These fields may not have data, depending on the configuration. | |
Custom3 | String | False |
The details from the Custom fields. These fields may not have data, depending on the configuration. | |
Custom4 | String | False |
The details from the Custom fields. These fields may not have data, depending on the configuration. | |
Custom5 | String | False |
The details from the Custom fields. These fields may not have data, depending on the configuration. | |
URI | String | True |
null |
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 who owns this entry-attendee association. The user must have the Web Services Admin role to use this parameter. |