Allocations
Lists all allocations per entry or report.
Table Specific Information
Select
The add-in uses the SAP Concur APIs to process filters that refer to Id or to any combination of ReportId_p, ItemizationId_p, and EntryId. The add-in processes other filters client-side within the add-in.
For example, the add-in 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'
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. |