ADO.NET Provider for Oracle Fusion Cloud Financials

Build 24.0.9111

Expenses

The expenses resource is a parent resource that contains all the expense information incurred by an employee.

Table Specific Information

Select

The 本製品 uses the Oracle Fusion Cloud Financials API to process some of the filters having queryable=true in metadata. The 本製品 processes other filters within the 本製品.

For example, the following query is processed server side:

SELECT * FROM [Cdata].[Financials].[Expenses] WHERE ExpenseId = 10003

Insert

Create an expense record.

INSERT INTO [Cdata].[Financials].[Expenses] (Location) VALUES ('India')

If you want to add child views/tables along with the parent table, you can add the child in following ways:

  • Using TEMP table:

    INSERT into ExpensesExpenseAttendee#TEMP(Name,EmployeeFlag,Amount) values ('Ted Brown',true,25);
    INSERT INTO Expenses (Location,ExpenseAttendee) VALUES ('India','ExpensesExpenseAttendee#TEMP');

  • Directly providing the aggregate:

    INSERT INTO Expenses (Location,ExpenseAttendee) VALUES ('India','[
      {
        "Amount": 25,
        "EmployeeFlag": y,
        "Name": "Ted Brown"
      }
    ]');

Update

The Oracle Fusion Cloud Financials API uses ExpenseUniqId instead of ExpenseId as a path parameter in the URL to update the expenses.

If you want to update a record directly using the id (without any other filter), you can update the record in the following way:

Update [Cdata].[Financials].[Expenses] set NumberPeople=566 where ExpenseUniqId=300000294909513;

Note: This does not require any extra GET request to retrieve the UniqId.

Alternatively, if you want to apply any other filter. Please use ExpenseId instead of ExpenseUniqId. You can update the record in the following way:

Update [Cdata].[Financials].[Expenses] set NumberPeople=566 where ExpenseId=300000294909513 and Location='India';

Note : Update on aggregates are not allowed by API, use the child tables to add/update/delete aggregates.

Columns

Name Type ReadOnly Description
AgencyName String False

Name of the service that provided car rental or airfare.

AssignmentId Long False

Value that uniquely identifies the individual who owns the expense.

AuditAdjustmentReason String False

Auditor's reason for adjusting the reimbursable amount to the individual.

AuditAdjustmentReasonCode String False

Code that indicates the auditor's reason for adjusting the reimbursable amount to the individual.

AwtGroupId Long False

Value that uniquely identifies an alternate tax withholding group.

BilledAmount Decimal False

Amount billed to the corporate card account.

BilledCurrencyCode String False

Code that indicates the amount billed to the corporate card account.

CardId Long True

Value that uniquely identifies a specific corporate card.

CheckoutDate Date False

Date when a person departs a place associated with an accommodations expense category.

CreatedBy String True

User who created the row.

CreationDate Datetime True

Date and time when the row was created.

CreditCardTrxnId Long True

Value that uniquely identifies a specific corporate card transaction.

DailyAmount Decimal False

Amount of the daily expense receipt in the receipt currency.

DailyDistance Decimal False

Distance traveled in a day for business.

DailyLimit String False

Daily expense limit of a trip.

DepartureLocationId Long False

Value that uniquely identifies the departure location.

Description String False

Description of an expense item.

DestinationFrom String False

Starting or departure location of the trip.

DestinationTo String False

Ending or arrival location of the trip.

DistanceUnitCode String False

Code that indicates the travel distance unit. Possible values are KILOMETER and MILE.

EndDate String False

Last day of an expense that spans multiple days.

EndDateTimestamp Datetime True

Last day and time of an expense that spans multiple days.

EndOdometer Decimal False

Odometer reading at the end of a trip.

ExchangeRate Decimal False

Rate that represents the amount one currency can be exchanged for another at a specific point in time.

ExpenseCategoryCode String False

Code that indicates the classification of an expense item. Possible values are BUSINESS and PERSONAL.

ExpenseCreationMethodCode String False

Code that indicates the method of expense item creation. Possible values are MOBILE iOS DEVICE and MOBILE ANDROID DEVICE.

ExpenseId [KEY] Long False

Value that uniquely identifies a specific expense item.

ExpenseUniqId [KEY] String True

Value that uniquely identifies a specific expense item. Use this column's value in insert, update and delete operations, wherever applicable, instead of ExpenseId

ExpenseReference Int False

Reference number to identify the expense.

ExpenseReportId Long False

Value that uniquely identifies a specific expense report.

ExpenseSource String False

Code that indicates the source of an expense item. Possible values are CASH and CORP_CARD.

ExpenseTemplateId Long False

Value that uniquely identifies a specific expense template.

ExpenseTypeCategoryCode String False

Code of the category to which an expense belongs, such as AIRFARE, CAR_RENTAL, or ACCOMMODATIONS.

ExpenseTypeId Long False

Value that uniquely identifies a specific expense type.

FlightClassLimit String False

Expense limit for a flight class.

FlightDuration Decimal False

Duration of an airline flight in hours.

FlightNumber String False

Number of an airline flight.

FuelType String False

Types of fuel for which a fuel charge is reimbursed.

ImageReceiptRequiredFlag Bool False

Indicates whether an expense requires an imaged receipt.

ItemizationParentExpenseId Long False

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 Decimal False

Expense receipt amount to be reimbursed by the employer.

ItemizationReceiptPersonalTotalAmount Decimal False

Amount on the receipt that was incurred by the employee for personal use.

ItineraryReservationId Long False

Value that uniquely identifies a travel reservation.

Justification String False

Reason an expense was incurred.

JustificationRequiredFlag Bool False

Indicates whether an expense requires justification.

LastUpdateDate Datetime True

Date and time when the row was last updated.

LastUpdateLogin String True

Session login associated with the user who last updated the row.

LastUpdatedBy String True

User who last updated the row.

LicensePlateNumber String False

Number of the vehicle license plate.

Location String False

Location where the expense was incurred.

LocationId Long False

Value that uniquely identifies a specific expense location.

LongTermTripFlag Bool False

Indicates whether a trip is long-term.

LongTermTripStartDate Date False

Date when a long-term trip started.

MerchantDocumentNumber String False

Number on the receipt issued by the merchant.

MerchantName String False

Name of the merchant where the expense was incurred.

MerchantReference String False

Purchase identification of a transaction provided by the merchant at the point of sale.

MerchantTaxRegNumber String False

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 False

Value that uniquely identifies a merchant tax payer.

MileagePolicyId Long False

Value that uniquely identifies a mileage policy.

NumberOfAttendees Decimal False

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 False

Number of days the expense is incurred.

NumberPeople Int False

Number of passengers in the vehicle.

OrgId Long False

Value that uniquely identifies the business unit associated with the row.

PassengerAmount Decimal False

Total reimbursement for carrying passengers in the vehicle.

PassengerName String False

Name of airline flight passenger.

PassengerRateType String False

Passenger rate type used for mileage reimbursement for an expense.

PaymentDueFromCode String False

Code that indicates the liability owner of the transaction.

PersonId Long False

Value that uniquely identifies the individual who owns the expense.

PersonalReceiptAmount Decimal False

Amount of the receipt that's marked as a personal expense.

PolicyShortpayFlag Bool False

Indicates whether the expense is short-paid due to policy noncompliance.

PolicyViolatedFlag Bool False

Indicates whether the expense violates company policies.

PolicyWarningFlag Bool False

Indicates whether the expense is marked with a warning.

PolicyWarningReasonCode String False

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 False

Value that uniquely identifies the person who created the expense report.

RatePerPassenger Decimal False

Mileage rate per passenger for an expense.

ReceiptAmount Decimal False

Amount of the receipt in the receipt currency.

ReceiptCurrencyCode String False

Code that indicates the receipt currency of an expense item.

ReceiptDate Date False

Date when a receipt is generated.

ReceiptMissingDecRequiredFlag Bool False

Indicates whether an expense item with missing receipts requires submission of a missing receipts declaration.

ReceiptMissingFlag Bool False

Indicates whether receipts are missing for an expense.

ReceiptRequiredFlag Bool False

Indicates whether an expense requires a receipt.

ReceiptVerifiedFlag Bool False

Indicates whether an auditor verifies the receipt for an expense.

ReimbursableAmount Decimal False

Amount to be reimbursed to the individual in reimbursable currency for an expense.

ReimbursementCurrencyCode String False

Code that indicates the currency of the amount to be reimbursed to the individual for expenses incurred.

SequenceNumber Decimal False

Number associated with a sequence in which expense items are entered in an expense report.

StartDate Date False

Date when the expense occurred or the first day of an expense that spans multiple days.

StartDateTimestamp Datetime True

Date and time when the expense occurred or the first day of an expense that spans multiple days.

StartOdometer Decimal False

Odometer reading at the start of a trip.

TaxClassificationCode String False

Code that indicates a tax classification that applies to an expense item.

TicketClassCode String False

Code that indicates the ticket class of a ship cabin or a flight. Possible values are BUSINESS and ECONOMY.

TicketNumber String False

Number of the airline ticket.

TravelMethodCode String False

Code that indicates the method of travel used during a trip.

TravelType String False

Type of flight. Possible values are DOMESTIC and INTERNATIONAL.

TripDistance Decimal False

Total distance traveled during a business trip for which mileage reimbursement is requested.

UOMDays Decimal False

Calculation for the number of per diem expense days based on the unit of measure.

ValidationErrorFlag Bool False

Indicates whether a validation error exists.

ValidationErrorMessages String False

Error messages populated during validation.

ValidationWarningMessages String False

Warning messages populated during validation.

VehicleCategoryCode String False

Code that indicates the vehicle type category. Possible values are COMPANY, PRIVATE, and RENTAL.

VehicleType String False

Type of vehicle for which mileage reimbursement is permitted. Possible values are CAR, MOTORCYCLE, and VAN.

ZoneCode String False

Code that indicates the geographical area of the trip.

ZoneTypeCode String False

Code that indicates the lookup type that defines the zones for which mileage rates are defined.

BusinessUnit String False

Business unit associated with the incurred expense.

PersonName String False

Name of the person who incurs the expense.

ExpenseTemplate String False

Expense template against which the expense is incurred.

ExpenseType String False

Expense type against which the expense is incurred.

ReceiptCurrency String False

Currency of the expense receipt for an expense.

ReimbursementCurrency String False

Currency used to reimburse an expense.

DistanceUnit String True

Unit of measurement for the distance traveled. Possible values are KILOMETER and MILE.

TicketClass String False

Class of ticket. Possible values are BUSINESS and ECONOMY.

ExpenseSourceName String True

Source of an expense item. Possible values are Cash and Corporate Card.

ReferenceNumber String True

Unique reference number alias for the object version.

Request Long True

Unique identifier of the credit card upload process.

AttachmentExists String True

Indicates whether an attachment exists for the expense.

ExpenseReportStatus String True

Status of an expense report.

AuthTrxnNumber String False

Code of a credit card transaction authorization.

TravelTypeName String False

Type of flight. Possible values are Domestic and International. Setting of the TravelType attribute is based on the value of this attribute.

VehicleCategory String False

Category of vehicle.

VehicleTypeName String False

Name of type of vehicle.

FuelTypeName String False

Name of type of fuel.

TaxClassification String False

Tax classification meaning. Setting of the TaxClassificationCode attribute is based on the value of this attribute.

CountryCode String False

Code that indicates the country where the expense is incurred.

AutoSubmitDate Datetime False

Date when the expense is submitted.

ReceiptTime Datetime False

Date and time when the transaction occurred. Allows you to differentiate transactions made on the same day based on their accounting time.

TipAmount Decimal False

Amount of tip given in the transaction. Allows you to manage receipts that have different total amounts due to tips.

VisitedFlag Bool False

Indicates whether the user has confirmed the expense.

ValidationStatus String False

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 False

Indicates whether the expense is prepaid.

ExpenseAttendee String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

ExpenseDff String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

expenseErrors String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

matchedExpenses String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

ExpenseItemization String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

duplicateExpenses String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

ExpenseDistribution String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

Finder String True

finder

SysEffectiveDate String True

syseffectivedate

EffectiveDate Date True

This query parameter is used to fetch resources which are effective dated as of the specified start date.

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