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 unique identifier of the resource. | |
| 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 to the resource. |