Expense Report

Stores the general information for an expense report, such as the report number, purpose of the report, and the person for whom the report is prepared.

QName: {http://xmlns.oracle.com/apps/financials/expenses/shared/common/expenseExternalService/}ExpenseReport

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type	Object or Service
Contains	Expense Item
Contains	Expense Report Descriptive Flexfield SDO
Handled by	Expense Item and Expense Report

Attributes

The following table describes attributes in the service data object.

Name	Type	Description
AssignmentId	long	The unique identifier of the primary assignment for the person named on the expense report.
BothpayFlag	boolean	Indicates whether the expense report contains both pay corporate card transactions.
CashExpensePaidDate	{http://xmlns.oracle.com/adf/svc/types/}date-Date	The date on which cash expenses are reimbursed to the person named on the expense report.
CurrentApproverId	long	The identifier of the current approver for the expense report.
ExchangeRateType	string	The exchange rate type used to retrieve the exchange rate for the expense.
ExpReportProcessingId	long	The unique identifier of a specific instance of the expense report status and change date.
Expense	Expense Item	The expense item included in an expense report.
ExpenseHeaderDffVL	Expense Report Descriptive Flexfield SDO	The view link to the expense report header DFF.
ExpenseReportDate	{http://xmlns.oracle.com/adf/svc/types/}date-Date	The date of the expense report.
ExpenseReportId	long	The unique identifier of the expense report. Primary Key
ExpenseReportNumber	string	The number assigned to the expense report.
ExpenseReportTotal	decimal	The total amount of the expense report.
ExpenseStatusCode	string	The status of the expense report at a point in time.
ExpenseStatusDate	{http://xmlns.oracle.com/adf/svc/types/}date-Date	The date on which the expense report obtained a specific status.
ExportRejectCode	string	The reason the expense report is rejected by Oracle Fusion Payables.
ExportRequestId	long	The identifier of the Oracle Fusion Payables process that creates documents payable for the expense report.
FinalApprovalDate	{http://xmlns.oracle.com/adf/svc/types/}date-Date	The final approval date of the expense report.
ObjectVersionNumber	int	The versioning ability implemented for record locking. This number is incremented every time the record is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the record since it was queried.
OrgId	long	The identifier of the business unit for the person named on the expense report.
OverrideApproverId	long	The person identifier of the overriding approver.
ParentExpenseReportId	long	The identifier of an expense report that generates a related both pay corporate card issuer expense report.
PaymentMethodCode	string	The payment method code selected for reimbursing the person named on the expense report.
PersonId	long	The identifier of the person named on the expense report.
PreparerId	long	The identifier of the person who submitted the expense report.
Purpose	string	The purpose of the expense report.
ReceiptsReceivedDate	{http://xmlns.oracle.com/adf/svc/types/}date-Date	The date on which the receipt is received.
ReceiptsStatusCode	string	The receipt status of the expense report, such as Receipt Required and Receipt Missing.
ReimbursementCurrencyCode	string	The currency code of the reimbursable amount.
ReportSubmitDate	{http://xmlns.oracle.com/adf/svc/types/}date-Date	The expense report submission date.