Allocations
Lists all allocations per entry or report.
Table Specific Information
Select
The driver uses the SAP Concur APIs to process filters that refer to Id or to any combination of ReportId_p, ItemizationId_p, and EntryId. The driver processes other filters client-side within the driver.
For example, the driver will offload the processing of the following queries to the SAP Concur APIs:
SELECT * FROM Allocations WHERE Id = 'sampleAllocationsId' SELECT * FROM Allocations WHERE ItemizationId_p = 'sampleItemizationId' AND ReportId_p = 'sampleReportId' AND EntryId = 'sampleEntryId'You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.
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
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| 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. |