Expense Item

Stores a business expense incurred by an employee. For example, a stay at a hotel or a car rental on a business trip.

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

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 Descriptive Flexfield
Contains	Expense Distribution
Contained by	Expense Report
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 of the person named on the expense report.
CcPrepaidInvoiceId	long	The invoice identifier of the company pay corporate card transaction.
CreditCardTrxnId	long	The identifier of the credit card transaction that is associated with the expense.
DepartureLocationId	long	The identifier of the flight departure location.
Description	string	The description of the expense.
DestinationFrom	string	The departure location.
DestinationTo	string	The arrival location.
EmployeeDefaultCostCenter	string	The default cost center of the person named on the expense report.
EndDate	{http://xmlns.oracle.com/adf/svc/types/}date-Date	The end date of the expense.
ExchangeRate	decimal	The exchange rate type used to retrieve the exchange rate of the expense.
ExpenseCategoryCode	string	The expense category code, such as Business or Personal.
ExpenseDFF	Expense Descriptive Flexfield	The descriptive flexfield values for the expense.
ExpenseDistribution	Expense Distribution	The expense account distribution and the project distribution for the expense.
ExpenseId	long	The unique identifier generated by the application for the expense item. Primary Key
ExpenseReportId	long	The unique identifier of the expense report.
ExpenseSource	string	The source of the expense, such as cash or corporate card.
ExpenseTemplateEntityId	long	The primary key identifier of the expense template.
ExpenseTemplateId	long	The identifier of the expense report template.
ExpenseTemplateName	string	The name of the expense template.
ExpenseTypeCategoryCode	string	The expense type category code, such as Accommodations or Meals.
ExpenseTypeEntityId	long	The primary key identifier for the expense type. The primary key identifier of the expense type.
ExpenseTypeId	long	The identifier of the expense type.
ExpenseTypeName	string	The expense type of the expense.
FlightNumber	string	The flight number.
FuncCurrencyAmount	{http://xmlns.oracle.com/adf/svc/types/}AmountType	The receipt amount of the expense in the functional currency of the business unit.
ItemizationParentExpenseId	long	The unique identifier of the parent expense that is associated with the itemized expense.
Justification	string	The justification for incurring the expense.
JustificationRequiredFlag	boolean	Indicates whether the expense requires a justification.
Location	string	The expense location.
LocationId	long	The identifier of the expense location.
MaskedCcNumber	string	Masked corporate card number that is obtained by scanning a transaction receipt for a cash expense.
MerchantDocumentNumber	string	The receipt number provided by the merchant.
MerchantName	string	The name of the merchant where the expense was incurred.
MerchantReference	string	The reference number on the receipt that is provided by the merchant.
MerchantTaxRegNumber	string	The tax registration number of the merchant where the expense was incurred.
MerchantTaxpayerId	string	The taxpayer identifier of the merchant where the expense was incurred.
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. This version number is for the expense item record.
ObjectVersionNumber1	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. This version number is for the expense type record used in the expense item.
ObjectVersionNumber2	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. This version number is for the expense template record used in the expense item.
OrgId	long	The identifier of the business unit that is associated with the person named on the expense report.
OrigReimbursableAmount	{http://xmlns.oracle.com/adf/svc/types/}AmountType	The original amount reimbursable to the person named on the expense report before any adjustments are made.
PersonId	long	The identifier of the person named on the expense report.
PolicyViolatedFlag	boolean	Indicates whether the expense violated the company policies.
PreparerId	long	The person identifier of the expense report preparer.
ReceiptAmount	{http://xmlns.oracle.com/adf/svc/types/}AmountType	The receipt amount of the expense.
ReceiptCurrencyCode	string	The currency code of the receipt amount.
ReceiptMissingFlag	boolean	Indicates whether the expense report preparer specified that the receipt is missing.
ReceiptRequiredFlag	boolean	Indicates whether a receipt is required for this expense.
ReceiptVerifiedFlag	boolean	Indicates whether the receipt is verified by the auditor.
ReimbursableAmount	{http://xmlns.oracle.com/adf/svc/types/}AmountType	The amount reimbursable to the person named on the expense report.
ReimbursementCurrencyCode	string	The currency code of the reimbursable amount.
StartDate	{http://xmlns.oracle.com/adf/svc/types/}date-Date	The start date of the expense.
TaxClassificationCode	string	The tax code associated with the expense.
TicketClassCode	string	The class of the ticket, such as Business or Economy.
TicketNumber	string	The flight ticket number.
TravelType	string	The type of travel, such as domestic or international.