ADO.NET Provider for Oracle Fusion Cloud Financials

Build 23.0.8839

Expenses

Expenses

Columns

Name Type Description
AgencyName String Name of the service that provided car rental or airfare.
AssignmentId Long Value that uniquely identifies the individual who owns the expense.
AuditAdjustmentReason String Auditor's reason for adjusting the reimbursable amount to the individual.
AuditAdjustmentReasonCode String Code that indicates the auditor's reason for adjusting the reimbursable amount to the individual.
AwtGroupId Long Value that uniquely identifies an alternate tax withholding group.
BilledAmount Double Amount billed to the corporate card account.
BilledCurrencyCode String Code that indicates the amount billed to the corporate card account.
CardId Long Value that uniquely identifies a specific corporate card.
CheckoutDate Date Date when a person departs a place associated with an accommodations expense category.
CreatedBy String User who created the row.
CreationDate Datetime Date and time when the row was created.
CreditCardTrxnId Long Value that uniquely identifies a specific corporate card transaction.
DailyAmount Double Amount of the daily expense receipt in the receipt currency.
DailyDistance Double Distance traveled in a day for business.
DailyLimit String Daily expense limit of a trip.
DepartureLocationId Long Value that uniquely identifies the departure location.
Description String Description of an expense item.
DestinationFrom String Starting or departure location of the trip.
DestinationTo String Ending or arrival location of the trip.
DistanceUnitCode String Code that indicates the travel distance unit. Possible values are KILOMETER and MILE.
EndDate String Last day of an expense that spans multiple days.
EndDateTimestamp Datetime Last day and time of an expense that spans multiple days.
EndOdometer Double Odometer reading at the end of a trip.
ExchangeRate Double Rate that represents the amount one currency can be exchanged for another at a specific point in time.
ExpenseCategoryCode String Code that indicates the classification of an expense item. Possible values are BUSINESS and PERSONAL.
ExpenseCreationMethodCode String Code that indicates the method of expense item creation. Possible values are MOBILE iOS DEVICE and MOBILE ANDROID DEVICE.
ExpenseId [KEY] Long Value that uniquely identifies a specific expense item.
ExpenseReference Int Reference number to identify the expense.
ExpenseReportId Long Value that uniquely identifies a specific expense report.
ExpenseSource String Code that indicates the source of an expense item. Possible values are CASH and CORP_CARD.
ExpenseTemplateId Long Value that uniquely identifies a specific expense template.
ExpenseTypeCategoryCode String Code of the category to which an expense belongs, such as AIRFARE, CAR_RENTAL, or ACCOMMODATIONS.
ExpenseTypeId Long Value that uniquely identifies a specific expense type.
FlightClassLimit String Expense limit for a flight class.
FlightDuration Double Duration of an airline flight in hours.
FlightNumber String Number of an airline flight.
FuelType String Types of fuel for which a fuel charge is reimbursed.
ImageReceiptRequiredFlag Bool Indicates whether an expense requires an imaged receipt.
ItemizationParentExpenseId Long Value that uniquely identifies the parent expense of an itemized expense item. Possible values are NULL, which indicates that the expense isn't itemized, -1 which indicates that the expense is a parent line with itemization, and greater than 0, which indicates that the expense is an itemized child line and the value is the parent line's identifier.
ItemizationReceiptBusinessTotalAmount Double Expense receipt amount to be reimbursed by the employer.
ItemizationReceiptPersonalTotalAmount Double Amount on the receipt that was incurred by the employee for personal use.
ItineraryReservationId Long Value that uniquely identifies a travel reservation.
Justification String Reason an expense was incurred.
JustificationRequiredFlag Bool Indicates whether an expense requires justification.
LastUpdateDate Datetime Date and time when the row was last updated.
LastUpdateLogin String Session login associated with the user who last updated the row.
LastUpdatedBy String User who last updated the row.
LicensePlateNumber String Number of the vehicle license plate.
Location String Location where the expense was incurred.
LocationId Long Value that uniquely identifies a specific expense location.
LongTermTripFlag Bool Indicates whether a trip is long-term.
LongTermTripStartDate Date Date when a long-term trip started.
MerchantDocumentNumber String Number on the receipt issued by the merchant.
MerchantName String Name of the merchant where the expense was incurred.
MerchantReference String Purchase identification of a transaction provided by the merchant at the point of sale.
MerchantTaxRegNumber String Unique sequence of letters or numbers assigned to a party or party site by a tax authority when it's registered and by which the party or party site registration is identified.
MerchantTaxpayerId String Value that uniquely identifies a merchant tax payer.
MileagePolicyId Long Value that uniquely identifies a mileage policy.
NumberOfAttendees Double Number of people that attended an event for which expenses were incurred. For example, the number of people who attended a business dinner or an entertainment event.
NumberOfDays Int Number of days the expense is incurred.
NumberPeople Int Number of passengers in the vehicle.
OrgId Long Value that uniquely identifies the business unit associated with the row.
PassengerAmount Double Total reimbursement for carrying passengers in the vehicle.
PassengerName String Name of airline flight passenger.
PassengerRateType String Passenger rate type used for mileage reimbursement for an expense.
PaymentDueFromCode String Code that indicates the liability owner of the transaction.
PersonId Long Value that uniquely identifies the individual who owns the expense.
PersonalReceiptAmount Double Amount of the receipt that's marked as a personal expense.
PolicyShortpayFlag Bool Indicates whether the expense is short-paid due to policy noncompliance.
PolicyViolatedFlag Bool Indicates whether the expense violates company policies.
PolicyWarningFlag Bool Indicates whether the expense is marked with a warning.
PolicyWarningReasonCode String Code that indicates the reason for a warning that an expense auditor applies to an expense item. A list of accepted values are defined in the lookup type ORA_EXM_WARNING_REASON.
PreparerId Long Value that uniquely identifies the person who created the expense report.
RatePerPassenger Double Mileage rate per passenger for an expense.
ReceiptAmount Double Amount of the receipt in the receipt currency.
ReceiptCurrencyCode String Code that indicates the receipt currency of an expense item.
ReceiptDate Date Date when a receipt is generated.
ReceiptMissingDecRequiredFlag Bool Indicates whether an expense item with missing receipts requires submission of a missing receipts declaration.
ReceiptMissingFlag Bool Indicates whether receipts are missing for an expense.
ReceiptRequiredFlag Bool Indicates whether an expense requires a receipt.
ReceiptVerifiedFlag Bool Indicates whether an auditor verifies the receipt for an expense.
ReimbursableAmount Double Amount to be reimbursed to the individual in reimbursable currency for an expense.
ReimbursementCurrencyCode String Code that indicates the currency of the amount to be reimbursed to the individual for expenses incurred.
SequenceNumber Double Number associated with a sequence in which expense items are entered in an expense report.
StartDate Date Date when the expense occurred or the first day of an expense that spans multiple days.
StartDateTimestamp Datetime Date and time when the expense occurred or the first day of an expense that spans multiple days.
StartOdometer Double Odometer reading at the start of a trip.
TaxClassificationCode String Code that indicates a tax classification that applies to an expense item.
TicketClassCode String Code that indicates the ticket class of a ship cabin or a flight. Possible values are BUSINESS and ECONOMY.
TicketNumber String Number of the airline ticket.
TravelMethodCode String Code that indicates the method of travel used during a trip.
TravelType String Type of flight. Possible values are DOMESTIC and INTERNATIONAL.
TripDistance Double Total distance traveled during a business trip for which mileage reimbursement is requested.
UOMDays Double Calculation for the number of per diem expense days based on the unit of measure.
ValidationErrorFlag Bool Indicates whether a validation error exists.
ValidationErrorMessages String Error messages populated during validation.
ValidationWarningMessages String Warning messages populated during validation.
VehicleCategoryCode String Code that indicates the vehicle type category. Possible values are COMPANY, PRIVATE, and RENTAL.
VehicleType String Type of vehicle for which mileage reimbursement is permitted. Possible values are CAR, MOTORCYCLE, and VAN.
ZoneCode String Code that indicates the geographical area of the trip.
ZoneTypeCode String Code that indicates the lookup type that defines the zones for which mileage rates are defined.
BusinessUnit String Business unit associated with the incurred expense.
PersonName String Name of the person who incurs the expense.
ExpenseTemplate String Expense template against which the expense is incurred.
ExpenseType String Expense type against which the expense is incurred.
ReceiptCurrency String Currency of the expense receipt for an expense.
ReimbursementCurrency String Currency used to reimburse an expense.
DistanceUnit String Unit of measurement for the distance traveled. Possible values are KILOMETER and MILE.
TicketClass String Class of ticket. Possible values are BUSINESS and ECONOMY.
ExpenseSourceName String Source of an expense item. Possible values are Cash and Corporate Card.
ReferenceNumber String Unique reference number alias for the object version.
Request Long Unique identifier of the credit card upload process.
AttachmentExists String Indicates whether an attachment exists for the expense.
ExpenseReportStatus String Status of an expense report.
AuthTrxnNumber String Code of a credit card transaction authorization.
TravelTypeName String Type of flight. Possible values are Domestic and International. Setting of the TravelType attribute is based on the value of this attribute.
VehicleCategory String Category of vehicle.
VehicleTypeName String Name of type of vehicle.
FuelTypeName String Name of type of fuel.
TaxClassification String Tax classification meaning. Setting of the TaxClassificationCode attribute is based on the value of this attribute.
CountryCode String Code that indicates the country where the expense is incurred.
AutoSubmitDate Datetime Date when the expense is submitted.
ReceiptTime Datetime Date and time when the transaction occurred. Allows you to differentiate transactions made on the same day based on their accounting time.
TipAmount Double Amount of tip given in the transaction. Allows you to manage receipts that have different total amounts due to tips.
VisitedFlag Bool Indicates whether the user has confirmed the expense.
ValidationStatus String Indicates the status of the expense item validation. The valid values are NULL for old expenses that need to be revalidated, E for expenses with at least one error, W for expenses that have no errors but have warnings, and C for expenses without any errors or warnings.
PrepaidFlag Bool Indicates whether the expense is prepaid.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
SysEffectiveDate String SysEffectiveDate
Finder String finder

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