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.
テーブル固有の情報
Select
本製品 はSAP Concur API を使用して、Id を参照するフィルタ、 またはEntryId とLoginId を参照するフィルタを処理します。本製品 はクライアント側で本製品 内で他のフィルタを処理します。
例えば、本製品 はSAP Concur API に次のクエリの処理をオフロードします。
SELECT * FROM EntryAttendeeAssociations WHERE Id = 'sampleId' SELECT * FROM EntryAttendeeAssociations WHERE EntryId = 'sampleEntryId' AND LoginId = 'LoginId'
Insert
EntryAttendeeAssociations に新しいレコードを挿入するには、次のカラムが必要です：EntryId およびAttendeeId。
INSERT INTO EntryAttendeeAssociations (EntryId, AttendeeId) VALUES ('EntryIdValue', 'AttendeeIdValue')
Update
EntryAttendeeAssociations のレコードを更新するには、次のカラムが必要です：Id。EntryId カラムとAttendeeId カラムは更新できません。
UPDATE EntryAttendeeAssociations SET Custom = 'Custom' WHERE Id = '12345'
Delete
EntryAttendeeAssociations のレコードを削除するには、次のカラムが必要です：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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| 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. |