Allocations
Lists all allocations per entry or report.
Table Specific Information
Select
The connector uses the SAP Concur APIs to process filters that refer to Id or to any combination of ReportId_p, ItemizationId_p, and EntryId. The connector processes other filters client-side within the connector.
For example, the connector 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 | Description |
| Id [KEY] | String | The unique identifier of the resource. |
| ContextType | String | The access level of the SAP Concur user, which determines the form fields they can view/modify. Supported value: TRAVELER
The default value is TRAVELER. |
| ReportId | String | The unique identifier of the report to which the expense entry belongs whose allocations are being retrieved. |
| ExpenseId | String | The unique identifier of the expense entry whose allocations are being retrieved. |
| UserID | String | The unique identifier of the SAP Concur user. Use UsersV4 to resolve the userId |
| AccountCode | String | The ledger account code associated with the allocation. |
| IsPercentEdited | Boolean | Whether the allocation percent has been edited. |
| IsSystemAllocation | Boolean | Whether the allocation is a system allocation, usually hidden from the user. If displayed to the user, should be read-only. |
| OverLimitAccountCode | String | The ledger account code associated with the allocation if it exceeds a pre-defined threshold, for example, the user's travel allowance limit. |
| Percentage | Double | The percentage of the total expense that this allocation represents. |
| ApprovedAmountCurrencyCode | String | The 3-letter ISO 4217 currency code for the expense report currency, based on the user?s assigned reimbursement currency when the report was created. Examples: USD - US dollars; BRL - Brazilian real; CAD - Canadian dollar; CHF - Swiss franc; EUR - Euro; GBO - Pound sterling; HKD - Hong Kong dollar; INR - Indian rupee; MXN - Mexican peso; NOK - Norwegian krone; SEK - Swedish krona |
| ApprovedAmountValue | Double | The amount in the defined currency. |
| ClaimedAmountCurrencyCode | String | The 3-letter ISO 4217 currency code for the expense report currency, based on the user?s assigned reimbursement currency when the report was created. Examples: USD - US dollars; BRL - Brazilian real; CAD - Canadian dollar; CHF - Swiss franc; EUR - Euro; GBO - Pound sterling; HKD - Hong Kong dollar; INR - Indian rupee; MXN - Mexican peso; NOK - Norwegian krone; SEK - Swedish krona |
| ClaimedAmountValue | Double | The amount in the defined currency. |
| CustomDataId [KEY] | String | The unique identifier of the custom field. Examples: custom1, orgUnit1 |
| CustomDataIsValid | String | Whether the value returned is valid or not. This value is returned for custom fields of all data types and is specifically evaluated for list items to represent the current status. Default: true |
| CustomDataIsListItemUrl | String | |
| CustomDataValue | String | The value of the custom field. This field can have values for all the supported data types such as text, integer, boolean and listItemId. Maximum length: 48 characters |