Attendees
Create, update, delete, and query all attendees owned by the specified user.
テーブル固有の情報
Select
本製品 はSAP Concur API を使用して、Id を参照するフィルタ、 またはAttendeeTypeId とLoginId を参照するフィルタを処理します。本製品 はクライアント側で本製品 内で他のフィルタを処理します。
例えば、本製品 はSAP Concur API に次のクエリの処理をオフロードします。
SELECT * FROM Attendees WHERE Id = 'attendeeId' SELECT * FROM Attendees WHERE AttendeeTypeId = 'attendeeTypeId' AND LoginId = 'loginID'
Insert
出席者を挿入するには、次のカラムが必要です:AttendeeTypeId およびLastName。
INSERT INTO Attendees (AttendeeTypeId, FirstName, LastName, Company, CurrencyCode, MiddleInitial, Suffix, Title, TotalAmountYTD) VALUES ('IdValue', 'John', 'Doe', 'CDATA', 'USD', 'C', 'SuffixValue', 'TitleValue', 1000);
Update
出席者を更新するには、次のカラムが必要です:Id。
UPDATE Attendees SET LastName = 'newlastname' WHERE ID = '123456'
Delete
削除は、このテーブルではサポートされていません。
Columns
Name | Type | ReadOnly | Description |
ID [KEY] | String | False |
The unique identifier of the resource. |
Custom10ListItemID | String | False |
For list fields, this is the list item ID. |
AttendeeTypeID | String | False |
The ID of the attendee type. |
Custom11ListItemID | String | False |
For list fields, this is the list item ID. |
Custom12ListItemID | String | False |
For list fields, this is the list item ID. |
Custom13ListItemID | String | False |
For list fields, this is the list item ID. |
Custom14ListItemID | String | False |
For list fields, this is the list item ID. |
Custom15ListItemID | String | False |
For list fields, this is the list item ID. |
Custom16ListItemID | String | False |
For list fields, this is the list item ID. |
Custom17ListItemID | String | False |
For list fields, this is the list item ID. |
Custom18ListItemID | String | False |
For list fields, this is the list item ID. |
Custom19ListItemID | String | False |
For list fields, this is the list item ID. |
Custom1ListItemID | String | False |
For list fields, this is the list item ID. |
Custom20ListItemID | String | False |
For list fields, this is the list item ID. |
Custom21ListItemID | String | False |
For list fields, this is the list item ID. |
Custom22ListItemID | String | False |
For list fields, this is the list item ID. |
Custom23ListItemID | String | False |
For list fields, this is the list item ID. |
Custom24ListItemID | String | False |
For list fields, this is the list item ID. |
Custom25ListItemID | String | False |
For list fields, this is the list item ID. |
Custom2ListItemID | String | False |
For list fields, this is the list item ID. |
Custom3ListItemID | String | False |
For list fields, this is the list item ID. |
Custom4ListItemID | String | False |
For list fields, this is the list item ID. |
Custom5ListItemID | String | False |
For list fields, this is the list item ID. |
Custom6ListItemID | String | False |
For list fields, this is the list item ID. |
Custom7ListItemID | String | False |
For list fields, this is the list item ID. |
Custom8ListItemID | String | False |
For list fields, this is the list item ID. |
Custom9ListItemID | String | False |
For list fields, this is the list item ID. |
ExternalID | String | False |
A unique identifier for the attendee, assigned outside of Concur. Maximum length: 48 characters |
MiddleInitial | String | False |
The attendee's middle initial. Maximum length: 1 character |
LoginId | String | False |
The login ID of the user who owns the attendee record. |
AttendeeTypeCode | String | False |
A code that indicates the type of attendee. Examples: EMPLOYEE, SPOUSE, BUSGUEST. Maximum length: 40 characters |
Company | String | False |
The name of the attendee's company. Maximum length: 150 characters |
CurrencyCode | String | False |
The ISO 4217 currency code for monetary amounts related to an attendee. |
Custom10Code | String | False |
For list fields, this is the list item code. |
Custom10Type | String | False |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text |
Custom10Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters |
Custom11Code | String | False |
For list fields, this is the list item code. |
Custom11Type | String | False |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text |
Custom11Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters |
Custom12Code | String | False |
For list fields, this is the list item code. |
Custom12Type | String | False |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text |
Custom12Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters |
Custom13Code | String | False |
For list fields, this is the list item code. |
Custom13Type | String | False |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text |
Custom13Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters |
Custom14Code | String | False |
For list fields, this is the list item code. |
Custom14Type | String | False |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text |
Custom14Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters |
Custom15Code | String | False |
For list fields, this is the list item code. |
Custom15Type | String | False |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text |
Custom15Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters |
Custom16Code | String | False |
For list fields, this is the list item code. |
Custom16Type | String | False |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text |
Custom16Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters |
Custom17Code | String | False |
For list fields, this is the list item code. |
Custom17Type | String | False |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text |
Custom17Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters |
Custom18Code | String | False |
For list fields, this is the list item code. |
Custom18Type | String | False |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text |
Custom18Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters |
Custom19Code | String | False |
For list fields, this is the list item code. |
Custom19Type | String | False |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text |
Custom19Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters |
Custom1Code | String | False |
For list fields, this is the list item code. |
Custom1Type | String | False |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text |
Custom1Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters |
Custom20Code | String | False |
For list fields, this is the list item code. |
Custom20Type | String | False |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text |
Custom20Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters |
Custom21Code | String | False |
For list fields, this is the list item code. |
Custom21Type | String | False |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text |
Custom21Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters |
Custom22Code | String | False |
For list fields, this is the list item code. |
Custom22Type | String | False |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text |
Custom22Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters |
Custom23Code | String | False |
For list fields, this is the list item code. |
Custom23Type | String | False |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text |
Custom23Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters |
Custom24Code | String | False |
For list fields, this is the list item code. |
Custom24Type | String | False |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text |
Custom24Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters |
Custom25Code | String | False |
For list fields, this is the list item code. |
Custom25Type | String | False |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text |
Custom25Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters |
Custom2Code | String | False |
For list fields, this is the list item code. |
Custom2Type | String | False |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text |
Custom2Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters |
Custom3Code | String | False |
For list fields, this is the list item code. |
Custom3Type | String | False |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text |
Custom3Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters |
Custom4Code | String | False |
For list fields, this is the list item code. |
Custom4Type | String | False |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text |
Custom4Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters |
Custom5Code | String | False |
For list fields, this is the list item code. |
Custom5Type | String | False |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text |
Custom5Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters |
Custom6Code | String | False |
For list fields, this is the list item code. |
Custom6Type | String | False |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text |
Custom6Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters |
Custom7Code | String | False |
For list fields, this is the list item code. |
Custom7Type | String | False |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text |
Custom7Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters |
Custom8Code | String | False |
For list fields, this is the list item code. |
Custom8Type | String | False |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text |
Custom8Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters |
Custom9Code | String | False |
For list fields, this is the list item code. |
Custom9Type | String | False |
The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text |
Custom9Value | String | False |
The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters |
FirstName | String | False |
The attendee's first name. Maximum length: 50 characters |
HasExceptionsPrevYear | Bool | False |
Determines whether the attendee had exceptions in the previous year, based on yearly total limits for attendees. Format: true or false |
HasExceptionsYTD | Bool | False |
Determines whether the attendee has exceptions in the current year, based on yearly total limits for attendees. Format: true or false |
LastName | String | False |
The attendee's last name. Maximum length: 132 characters |
OwnerName | String | False |
The name of the user who owns the attendee record. |
Suffix | String | False |
The attendee's name suffix. Maximum length: 32 characters |
Title | String | False |
The attendee's title. Maximum length: 32 characters |
TotalAmountPrevYear | Decimal | False |
The total amount spent on the attendee in the previous calendar year. |
TotalAmountYTD | Decimal | False |
The total amount spent on the attendee in the current calendar year. |
URI | String | False |
The URI to the resource. |
VersionNumber | Int | False |
The attendee's version number. |