ExpenseDetails
Read the details of an expense by specifying an ExpenseId.
Table Specific Information
Select
The add-in uses the SAP Concur APIs to get the expense details by specifying the expenseId. We strongly recommend that the queries be as specific as possible.
The API requires the reportId, ExpenseId and in the case of CompanyLevelOAuth, UserId.
The driver can resolve each one of these properties internally, but it needs to pull all records first.
For example, for a query like:
SELECT * FROM ExpenseDetailsthe driver:
- Pulls all users (For CompanyLevelOAuth) to resolve the userId,
- Pulls all Reports to resolve the reportId,
- Pulls all Expenses to resolve the ExpenseId, and then
- Generates valid combinations for each of them to pull the correct data.
Because this is a very costly operation, we strongly advise the use of specific queries.
For example, in the following queries the add-in offloads the processing to the SAP Concur APIs:
SELECT * FROM ExpenseDetails WHERE UserId = '1f338d3-68e3-4a88-a760-f979ddef61dc' AND ReportId = '54CF09456D56445CBA37' AND ExpenseId = 'F4CFC3D027EE1548B6423A9BEDE039C7' SELECT * FROM ExpenseDetails WHERE UserId = '1f338d3-68e3-4a88-a760-f979ddef61dc' AND ReportId = '277FC923845B4E5FB9CE' AND ContextType = 'TRAVELER' AND ExpenseId = 'F4CFC3D027EE1548B6423A9BEDE039C7'
Columns
Name | Type | References | Description |
ExpenseId [KEY] | String | The unique identifier for the expense. | |
AllocationSetId | String | The identifier of the allocation set associated with the expense. Allocations which belong to the same set are created at the same time. | |
AllocationState | String | Allocation state for the expense. Supported values: FULLY_ALLOCATED, NOT_ALLOCATED, PARTIALLY_ALLOCATED | |
ApprovedAmount | Double | The value for the approved amount of the expense. | |
ApprovedAmountCurrencyCode | String | The currency for the approved amount of the expense. | |
ApproverAdjustedAmount | Double | The total amount value adjusted for the expense by the approver. | |
ApproverAdjustedAmountCurrencyCode | String | The currency code for the expense adjusted by the approver. | |
AttendeeCount | Int | The total number of attendees associated with the expense. | |
AuthorizationRequestExpenseId | String | The authorization request expense ID associated with the expense. | |
BudgetAccrualDate | Date | The budget accrual date of the expense. | |
BusinessPurpose | String | The text input for the business purpose by the user. | |
CanAllocate | Boolean | ||
CanDelete | Boolean | ||
ClaimedAmount | Double | The total non-personal amount claimed for reimbursement for the expense | |
ClaimedAmountCurrencyCode | String | The currency code for the claimed amount. | |
ERceiptImageId | String | The unique identifier of the eReceipt image associated with the expense. | |
ExchangeRateValue | Double | Exchange rate data for the expense. | |
ExchangeRateOperation | String | Currency code for the exchange rate | |
ExpenseSourceIdentifiers | String | The list of expense sources associated with the expense. | |
ExpenseTypeID | String | The expense type information for the expense. | |
ExpenseTypeCode | String | The expense type information for the expense. | |
ExpenseTypeIsDeleted | Boolean | The expense type information for the expense. | |
ExpenseTypeListItemId | String | The expense type information for the expense. | |
ExpenseTypeName | String | The expense type information for the expense. | |
FuelTypeListItem | String | The unique id of Fuel Type. | |
HasBlockingExceptions | Boolean | Whether the expense has any exceptions that blocks it from being submitted. | |
HasExceptions | Boolean | Whether the expense has any exceptions. | |
HasMissingReceiptDeclaration | Boolean | Whether the expense has an affidavit declaration for missing receipt. | |
ImageCertificationStatus | String | The final status of the receipt image associated with the expense. Supported values: ACCEPTED, PROCESSED, PROCESSING, PDF, FAILED, NO_PROCESSING_REQUIRED | |
IsAutoCreated | Boolean | Whether the expense is auto created. | |
IsImageRequired | Boolean | Whether the image is required for the expense. | |
IsPaperReceiptRequired | Boolean | Whether the paper receipt is required for the expense to be submitted. | |
IsPersonalExpense | Boolean | Whether the expense is marked as personal (non-reimbursable) by the user. | |
JptRouteId | String | The unique route ID to identify a Japan rail route. | |
LocationName | String | The location information of the expense. | |
LocationCity | String | The location information of the expense. | |
LocationCountryCode | String | The location information of the expense. | |
LocationCountrySubDivisionCode | String | The location information of the expense. | |
LocationId | String | The location information of the expense. | |
MerchantTaxId | String | Merchant tax ID for the expense. | |
Mileage | String | The mileage data associated with the expense. | |
ParentExpenseId | String | Expense ID of the parent expense. | |
PaymentTypeId | String | The payment type information for the expense. | |
PaymentTypeCode | String | The payment type information for the expense. | |
PostedAmount | Double | The PostedAmount value. | |
PostedAmountCode | String | The PostedAmount code. | |
ReceiptId | String | The id of the ReceiptType. | |
ReceiptStatus | String | The status of the ReceiptType | |
TaxRateLocation | String | Transaction location relative to the employee?s home location as defined by their user profile. Supported values: FOREIGN - The expense transaction took place in foreign currency, HOME - The expense transaction took place in the reimbursement currency, OUT_OF_PROVINCE - The expense transaction took place outside the state jurisdiction. Default: HOME. | |
TicketNumber | String | The ticket number associated with the travel. | |
TransactionAmount | Double | The amount of the expense, in the transaction currency paid to the vendor. | |
TransactionAmountCode | String | The currency code for the TransactionAmount. | |
TransactionDate | Date | The transaction date. | |
Travel | String | The travel data associated with the expense. | |
IsExpensePartOfTravelAllowance | Boolean | The travel allowance data associated with the expense. | |
TravelAllowanceDailyLimit | String | The travel allowance data associated with the expense. | |
DailyTravelAllowanceId | String | The travel allowance data associated with the expense. | |
VendorId | String | The unique identifier of the vendor. | |
VendorName | String | The name of the vendor. | |
VendorDescription | String | The description of the vendor. Maximum length: 64 characters | |
NetAdjustedTaxAmount | Double | Net adjusted tax amount. | |
NetAdjustedTaxAmountCurrencyCode | String | Currency code for the net adjusted tax amount. | |
NetReclaimAdjustedAmount | Double | Net reclaim adjusted amount. | |
NetReclaimAdjustedAmountCurrencyCode | String | Currency code for the net reclaim adjusted amount. | |
NetReclaimAmount | Double | Net reclaim amount. | |
NetReclaimAmountCurrencyCode | String | Currency code for the net reclaim amount. | |
NetTaxAmount | Double | Net tax amount. | |
NetTaxAmountCurrencyCode | String | Currency code for the net tax amount. | |
TotalReclaimAdjustedAmount | Double | Total reclaim adjusted amount. | |
TotalReclaimAdjustedAmountCurrencyCode | String | Currency code for the total reclaim adjusted amount. | |
TotalReclaimPostedAmount | Double | Total reclaim posted amount. | |
TotalReclaimPostedAmountCurrencyCode | String | Currency code for the total reclaim posted amount. | |
TotalTaxAdjustedAmount | Double | Total tax adjusted amount. | |
TotalTaxAdjustedAmountCurrencyCode | String | Currency code for the total tax adjusted amount. | |
TotalTaxPostedAmount | Double | Total tax posted amount. | |
TotalTaxPostedAmountCurrencyCode | String | Currency code for the total tax posted amount. | |
VatTaxTotal | Double | VAT tax total amount. | |
VatTaxTotalCurrencyCode | String | Currency code for the VAT tax total amount. | |
CustomDataId [KEY] | String | The unique identifier of the custom field. Examples: custom1, orgUnit1 | |
CustomDataIsValid | Boolean | 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 | |
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 | |
CustomDataItemURL | String | ||
ReportId | String | The unique identifier of the report that is being read. | |
UserId | String | The unique identifier of the SAP Concur user. Query the Identity table to retrieve this value. | |
ContextType | String | The access level of the SAP Concur user, which determines the form fields they can view/modify. Supported values: TRAVELER, PROXY. Default value is TRAVELER. |