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. |