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 | 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
デフォルト値は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 |