Excel Add-In for SAP Concur

Build 24.0.9062

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062