Allocations
Lists all allocations per entry or report.
テーブル固有の情報
Select
本製品 はSAP Concur API を使用して、Id を参照するフィルタ、 またはReportId_p、ItemizationId_p、EntryId の任意の組み合わせを参照するフィルタを処理します。本製品 はクライアント側で本製品 内で他のフィルタを処理します。
例えば、本製品 はSAP Concur API に次のクエリの処理をオフロードします。
SELECT * FROM Allocations WHERE Id = 'sampleAllocationsId' SELECT * FROM Allocations WHERE ItemizationId_p = 'sampleItemizationId' AND ReportId_p = 'sampleReportId' AND EntryId = 'sampleEntryId'
Columns
| Name | Type | References | Description |
| ID [KEY] | String | The unique identifier of the resource. | |
| Custom10ListItemID | String | For list fields, this is the list item ID. | |
| Custom11ListItemID | String | For list fields, this is the list item ID. | |
| Custom12ListItemID | String | For list fields, this is the list item ID. | |
| Custom13ListItemID | String | For list fields, this is the list item ID. | |
| Custom14ListItemID | String | For list fields, this is the list item ID. | |
| Custom15ListItemID | String | For list fields, this is the list item ID. | |
| Custom16ListItemID | String | For list fields, this is the list item ID. | |
| Custom17ListItemID | String | For list fields, this is the list item ID. | |
| Custom18ListItemID | String | For list fields, this is the list item ID. | |
| Custom19ListItemID | String | For list fields, this is the list item ID. | |
| Custom1ListItemID | String | For list fields, this is the list item ID. | |
| Custom20ListItemID | String | For list fields, this is the list item ID. | |
| Custom2ListItemID | String | For list fields, this is the list item ID. | |
| Custom3ListItemID | String | For list fields, this is the list item ID. | |
| Custom4ListItemID | String | For list fields, this is the list item ID. | |
| Custom5ListItemID | String | For list fields, this is the list item ID. | |
| Custom6ListItemID | String | For list fields, this is the list item ID. | |
| Custom7ListItemID | String | For list fields, this is the list item ID. | |
| Custom8ListItemID | String | For list fields, this is the list item ID. | |
| Custom9ListItemID | String | For list fields, this is the list item ID. | |
| EntryID | String | The unique identifier for the expense entry. | |
| IsHidden | Bool | Indicates whether the allocation is hidden. Format: true or false | |
| AccountCode1 | String | The primary accounting code assigned to the expense type associated with this allocation. Typically, expense types have only a primary account code. | |
| AccountCode2 | String | The secondary or alternative accounting code assigned to the expense type associated with this allocation. | |
| Custom10Code | String | For list fields, this is the list item code. | |
| Custom10Label | String | The label value for the custom field. | |
| Custom10Sequence | Int | The sequence value for this custom field i.e. the order in which this field appears on the form. | |
| Custom10Type | String | The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom10Value | String | 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 | For list fields, this is the list item code. | |
| Custom11Label | String | The label value for the custom field. | |
| Custom11Sequence | Int | The sequence value for this custom field i.e. the order in which this field appears on the form. | |
| Custom11Type | String | The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom11Value | String | 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 | For list fields, this is the list item code. | |
| Custom12Label | String | The label value for the custom field. | |
| Custom12Sequence | Int | The sequence value for this custom field i.e. the order in which this field appears on the form. | |
| Custom12Type | String | The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom12Value | String | 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 | For list fields, this is the list item code. | |
| Custom13Label | String | The label value for the custom field. | |
| Custom13Sequence | Int | The sequence value for this custom field i.e. the order in which this field appears on the form. | |
| Custom13Type | String | The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom13Value | String | 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 | For list fields, this is the list item code. | |
| Custom14Label | String | The label value for the custom field. | |
| Custom14Sequence | Int | The sequence value for this custom field i.e. the order in which this field appears on the form. | |
| Custom14Type | String | The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom14Value | String | 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 | For list fields, this is the list item code. | |
| Custom15Label | String | The label value for the custom field. | |
| Custom15Sequence | Int | The sequence value for this custom field i.e. the order in which this field appears on the form. | |
| Custom15Type | String | The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom15Value | String | 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 | For list fields, this is the list item code. | |
| Custom16Label | String | The label value for the custom field. | |
| Custom16Sequence | Int | The sequence value for this custom field i.e. the order in which this field appears on the form. | |
| Custom16Type | String | The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom16Value | String | 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 | For list fields, this is the list item code. | |
| Custom17Label | String | The label value for the custom field. | |
| Custom17Sequence | Int | The sequence value for this custom field i.e. the order in which this field appears on the form. | |
| Custom17Type | String | The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom17Value | String | 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 | For list fields, this is the list item code. | |
| Custom18Label | String | The label value for the custom field. | |
| Custom18Sequence | Int | The sequence value for this custom field i.e. the order in which this field appears on the form. | |
| Custom18Type | String | The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom18Value | String | 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 | For list fields, this is the list item code. | |
| Custom19Label | String | The label value for the custom field. | |
| Custom19Sequence | Int | The sequence value for this custom field i.e. the order in which this field appears on the form. | |
| Custom19Type | String | The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom19Value | String | 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 | For list fields, this is the list item code. | |
| Custom1Label | String | The label value for the custom field. | |
| Custom1Sequence | Int | The sequence value for this custom field i.e. the order in which this field appears on the form. | |
| Custom1Type | String | The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom1Value | String | 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 | For list fields, this is the list item code. | |
| Custom20Label | String | The label value for the custom field. | |
| Custom20Sequence | Int | The sequence value for this custom field i.e. the order in which this field appears on the form. | |
| Custom20Type | String | The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom20Value | String | 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 | For list fields, this is the list item code. | |
| Custom2Label | String | The label value for the custom field. | |
| Custom2Sequence | Int | The sequence value for this custom field i.e. the order in which this field appears on the form. | |
| Custom2Type | String | The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom2Value | String | 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 | For list fields, this is the list item code. | |
| Custom3Label | String | The label value for the custom field. | |
| Custom3Sequence | Int | The sequence value for this custom field i.e. the order in which this field appears on the form. | |
| Custom3Type | String | The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom3Value | String | 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 | For list fields, this is the list item code. | |
| Custom4Label | String | The label value for the custom field. | |
| Custom4Sequence | Int | The sequence value for this custom field i.e. the order in which this field appears on the form. | |
| Custom4Type | String | The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom4Value | String | 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 | For list fields, this is the list item code. | |
| Custom5Label | String | The label value for the custom field. | |
| Custom5Sequence | Int | The sequence value for this custom field i.e. the order in which this field appears on the form. | |
| Custom5Type | String | The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom5Value | String | 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 | For list fields, this is the list item code. | |
| Custom6Label | String | The label value for the custom field. | |
| Custom6Sequence | Int | The sequence value for this custom field i.e. the order in which this field appears on the form. | |
| Custom6Type | String | The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom6Value | String | 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 | For list fields, this is the list item code. | |
| Custom7Label | String | The label value for the custom field. | |
| Custom7Sequence | Int | The sequence value for this custom field i.e. the order in which this field appears on the form. | |
| Custom7Type | String | The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom7Value | String | 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 | For list fields, this is the list item code. | |
| Custom8Label | String | The label value for the custom field. | |
| Custom8Sequence | Int | The sequence value for this custom field i.e. the order in which this field appears on the form. | |
| Custom8Type | String | The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom8Value | String | 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 | For list fields, this is the list item code. | |
| Custom9Label | String | The label value for the custom field. | |
| Custom9Sequence | Int | The sequence value for this custom field i.e. the order in which this field appears on the form. | |
| Custom9Type | String | The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text | |
| Custom9Value | String | The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters | |
| IsPercentEdited | Bool | Indicates whether the percentage has been edited. Format: true or false | |
| Percentage | String | The percentage of the expense that is included in this allocation. | |
| URI | String | The URI to the resource. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| ReportID_p | String | The unique identifier for the report as it appears in the Concur Expense UI. Format: A variable-length string. Maximum length: 32 characters. | |
| ItemizationID_p | String | The unique identifier for the expense itemization. | |
| LoginId | String | The login ID of the user who owns the allocation. The user must have the Web Services Admin role to use this parameter. |