SSIS Components for Oracle Fusion Cloud Financials

Build 24.0.9060

ExpenseCashAdvances

The cash advance resource is used to manage all employee cash advances, which includes creation, update, deletion, and selection.

Columns

Name Type Description
AdjustedAmount Decimal Amount specified by an auditor during an audit.
AdvanceStatus String Status of the cash advance. References lookup type EXM_CASH_ADVANCE_STATUS.
Amount Decimal Amount of a cash advance.
AssignmentId Long Value that uniquely identifies the assignment of the person requesting a cash advance.
BusinessUnit String BusinessUnit of ExpenseCashAdvances
CashAdvanceId [KEY] Long Value that uniquely identifies a cash advance.
CashAdvanceNumber String Number used to identify a cash advance.
CashAdvanceType String Type of cash advance. The default value for CashAdvanceType is TRAVEL. A list of accepted values is defined in the lookup type EXM_CASH_ADVANCE_TYPE.
CreatedBy String CreatedBy of ExpenseCashAdvances
CreationDate Datetime CreationDate of ExpenseCashAdvances
Currency String Currency of ExpenseCashAdvances
CurrencyCode String Code that indicates the currency of the cash advance.
EmployeeNumber String Employee number of the person requesting the cash advance.
ExchangeRate Decimal ExchangeRate of ExpenseCashAdvances
LastUpdateDate Datetime LastUpdateDate of ExpenseCashAdvances
LastUpdateLogin String LastUpdateLogin of ExpenseCashAdvances
LastUpdatedBy String LastUpdatedBy of ExpenseCashAdvances
Location String Location of ExpenseCashAdvances
PaymentAmount Decimal Cash advance amount paid to an employee.
PaymentCurrency String PaymentCurrency of ExpenseCashAdvances
PaymentCurrencyCode String Code that indicates the payment currency of a cash advance.
PaymentMethodCode String Code that indicates the payment method of a cash advance.
PersonId Long Value that uniquely identifies the person requesting the cash advance.
PersonName String Name of the person requesting the cash advance.
Purpose String Purpose of the cash advance.
SettlementDate Date Date when the cash advance should be applied to an expense report.
StatusCode String Code that indicates the status of the cash advance.
SubmittedDate Date Date when the cash advance was submitted.
TripEndDate Date Date when the trip ends for which a cash advance was requested.
TripId Long TripId of ExpenseCashAdvances
TripStartDate Date Date when the trip starts for which a cash advance was requested.
UnappliedAmount Decimal Outstanding cash advance balance that remains to be applied to expense reports.
Description String Description of the cash advance.
SequoiaAdvanceStatus String SequoiaAdvanceStatus of ExpenseCashAdvances
SequoiaStatusCode String SequoiaStatusCode of ExpenseCashAdvances
Finder String Finder of ExpenseCashAdvances

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