SSIS Components for SAP Concur

Build 25.0.9434

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/modify.

デフォルト値は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 info for the approver of the reports 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 Flags whether the report contains exceptions that prevent submission or approval (true if blocking exceptions are present).
IsApproved Boolean Indicates if the report has been formally approved in the workflow.
IsEnabledForFinancialIntegration Boolean Specifies whether the report is eligible for export to or processing by a financial system.
IsEnabledForReopen Boolean Flags 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 Shows whether the report is currently awaiting approval in the workflow.
IsPendingDelegatorReview Boolean Indicates if the report is awaiting review by a delegate acting on behalf of the user.
IsPendingProcessor Boolean Flags whether the report is waiting for action from a financial processor or auditor.
IsReopened Boolean Whether the report is reopened.
IsReportEverSentBack Boolean Shows if the report has ever been returned to the submitter for changes or corrections.
IsSentBack Boolean Indicates if 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 of the payment status of the report.
ReportDate Date The date assigned to the report by the user.
ReportNumber String 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 and 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 as 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 the total amount of expenses marked as personal on the report.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434