ODBC Driver for SAP Concur

Build 23.0.8839

AttendeeTypes

Create, update, delete, and query all active attendee types for the company.

テーブル固有の情報

Select

本製品 はSAP Concur API を使用して、Id を参照するフィルタを処理します。本製品 はクライアント側で本製品 内で他のフィルタを処理します。

例えば、本製品 はSAP Concur API に次のクエリの処理をオフロードします。

SELECT * FROM AttendeeTypes WHERE Id = '123456'

Insert

出席者の種類を挿入するには、次のカラムが必要です:Name、Code、AttendeeFormId、およびDuplicateSearchFields。

INSERT INTO AttendeeTypes (Name, Code, AttendeeFormId, DuplicateSearchFields) VALUES ('AttendeeTypeName', '01234', '123456', 'Title,Company')

Update

出席者の種類を更新するには、以下のカラムが必要です: Id。

UPDATE AttendeeTypes SET Code = 'BUSGUEST' WHERE Id = 'gWjEPiokzJTpMsdq34zvJEM$ptCXpT'

Delete

削除は、このテーブルではサポートされていません。

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.

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