ODBC Driver for SAP Concur

Build 23.0.8791

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.

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