ADO.NET Provider for SAP Concur

Build 25.0.9539

ReportsV4

Retrieves the expenses that belong to a specific expense report or modifies an expense on an existing expense report.

Columns

Name Type References Description
Id [KEY] String The unique identifier of the report that is being read.
UserID String

UsersV4.Id

The unique identifier of the SAP Concur user.
ContextType String The access level of the SAP Concur user, which determines the form fields they can view or modify.

The default value is TRAVELER.

Name String The expense report name input by the user.
ApprovalStatus String The report's approval status, in the user's language.
ApprovalStatusId String The unique identifier of the approval status.
Approver String Employee information for the approver of the report's current workflow step.
CanAddExpense Booolean Indicates whether new expense items can be added to the report (true if allowed).
CardProgramStatementPeriodId Booolean Identifier linking the report to a specific credit card program statement period.
EndDate Date The end date of the report as used for trip-based reporting.
HasBlockingExceptions Boolean Indicates whether the report contains exceptions that prevent submission or approval (true if blocking exceptions are present).
IsApproved Boolean Indicates whether the report has been formally approved in the workflow.
IsEnabledForFinancialIntegration Boolean Indicates whether the report is eligible for export to or processing by a financial system.
IsEnabledForReopen Boolean Indicates whether the report can be reopened after submission or approval.
IsPaymentConfirmed Boolean Denotes that payment has been processed and confirmed for the report.
IsPendingApproval Boolean Indicates whether the report is currently awaiting approval in the workflow.
IsPendingDelegatorReview Boolean Indicates whether the report is awaiting review by a delegate acting on behalf of the user.
IsPendingProcessor Boolean Indicates whether the report is waiting for action from a financial processor or auditor.
IsReopened Boolean Indicates whether the report is reopened.
IsReportEverSentBack Boolean Indicates whether the report has ever been returned to the submitter for changes or corrections.
IsSentBack Boolean Indicates whether the report is currently in a 'sent back' status.
IsSentForPayment Boolean Denotes that the report has been sent to the payment system for processing.
IsSubmitted Boolean Indicates whether the report has been officially submitted for approval.
PaidDate Datetime The date on which payment for the report was completed.
PaymentStatus String The report's payment status, in the user's language.
PaymentStatusId String The unique identifier for the payment status of the report.
ReportDate Date The date assigned to the report by the user.
ReportNumber String The user-friendly, unique identifier for the report.
ReportType String This value identifies the method used to create the report. 'Statement' refers to company-billed statement reports. 'Auto-created' refers to reports created by Expense Assistant.
SentBackDate Datetime The date on which the report was returned to the submitter for revision.
SponsorId String An identifier for the sponsor associated with the report, often used for grant or project funding tracking.
StartDate Date The start date of the report, used for trip-based reporting.
SubmitDate Datetime The datetime when the user submitted the report.
ReportTotalValue Decimal The total amount on the report.
ReportTotalCurrencyCode String The currency code of total amount on the report.
AmountNotApprovedValue Decimal The amount that was not approved for the report.
AmountNotApprovedCurrencyCode String The currency code of the amount that was not approved for the report.
ApprovedAmountValue Decimal The total amount of approved expenses in the report.
ApprovedAmountCurrencyCode String The currency code of the total amount that was approved for the report.
ClaimedAmountValue Decimal The total amount of all non-personal expenses in the report.
ClaimedAmountCurrencyCode String The currency code of the total amount of all non-personal expenses in the report.
AmountCompanyPaidValue Decimal The amount paid by the company.
AmountCompanyPaidCurrencyCode String The currency code of the amount paid by the company.
PaymentConfirmedAmountValue Decimal The amount that was paid on the report.
PaymentConfirmedAmountCurrencyCode String The currency code of the amount that was paid on the report.
AmountDueCompanyValue Decimal The amount that the employee/company owes the employee.
AmountDueCompanyCurrencyCode String The currency code of the amount that the employee/company owes the employee.
AmountDueCompanyCardValue Decimal The amount that the employee/company owes the corporate card.
AmountDueCompanyCardCurrencyCode String The currency code of the amount that the employee/company owes the corporate card.
AmountDueEmployeeValue Decimal The amount that the company owes the employee.
AmountDueEmployeeCurrencyCode String The currency code of the amount that the company owes the employee.
PersonalAmountValue Decimal The total amount of expenses marked as personal on the report.
PersonalAmountCurrencyCode String The currency code of the total amount of expenses marked as personal on the report.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 25.0.9539