SSIS Components for SAP Concur

Build 24.0.9060

ExpenseDetails

Retrieves the details of a Expense by specifying an ExpenseId

Table Specific Information

Select

The component 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 ExpenseDetails
the driver:
  1. Pulls all users (For CompanyLevelOAuth) to resolve the userId,
  2. Pulls all Reports to resolve the reportId,
  3. Pulls all Expenses to resolve the ExpenseId, and then
  4. 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 component 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 Description
ExpenseId [KEY] String The unique identifier for the expense.
AllocationSetId String The identifier of the allocation set associated with the expense. Allocations that 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.

The default value is TRAVELER.

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