JDBC Driver for Oracle Fusion Cloud Financials

Build 24.0.9060

Expenses

Expenses

Columns

Name Type Description
AgencyName String AgencyName of Expenses
AssignmentId Long AssignmentId of Expenses
AuditAdjustmentReason String AuditAdjustmentReason of Expenses
AuditAdjustmentReasonCode String AuditAdjustmentReasonCode of Expenses
AwtGroupId Long AwtGroupId of Expenses
BilledAmount Decimal BilledAmount of Expenses
BilledCurrencyCode String BilledCurrencyCode of Expenses
CardId Long CardId of Expenses
CheckoutDate Date CheckoutDate of Expenses
CreatedBy String CreatedBy of Expenses
CreationDate Datetime CreationDate of Expenses
CreditCardTrxnId Long CreditCardTrxnId of Expenses
DailyAmount Decimal DailyAmount of Expenses
DailyDistance Decimal DailyDistance of Expenses
DailyLimit String DailyLimit of Expenses
DepartureLocationId Long DepartureLocationId of Expenses
Description String Description of Expenses
DestinationFrom String DestinationFrom of Expenses
DestinationTo String DestinationTo of Expenses
DistanceUnitCode String DistanceUnitCode of Expenses
EndDate String EndDate of Expenses
EndDateTimestamp Datetime EndDateTimestamp of Expenses
EndOdometer Decimal EndOdometer of Expenses
ExchangeRate Decimal ExchangeRate of Expenses
ExpenseCategoryCode String ExpenseCategoryCode of Expenses
ExpenseCreationMethodCode String ExpenseCreationMethodCode of Expenses
ExpenseId [KEY] Long ExpenseId of Expenses
ExpenseReference Int ExpenseReference of Expenses
ExpenseReportId Long ExpenseReportId of Expenses
ExpenseSource String ExpenseSource of Expenses
ExpenseTemplateId Long ExpenseTemplateId of Expenses
ExpenseTypeCategoryCode String ExpenseTypeCategoryCode of Expenses
ExpenseTypeId Long ExpenseTypeId of Expenses
FlightClassLimit String FlightClassLimit of Expenses
FlightDuration Decimal FlightDuration of Expenses
FlightNumber String FlightNumber of Expenses
FuelType String FuelType of Expenses
ImageReceiptRequiredFlag Bool ImageReceiptRequiredFlag of Expenses
ItemizationParentExpenseId Long ItemizationParentExpenseId of Expenses
ItemizationReceiptBusinessTotalAmount Decimal ItemizationReceiptBusinessTotalAmount of Expenses
ItemizationReceiptPersonalTotalAmount Decimal ItemizationReceiptPersonalTotalAmount of Expenses
ItineraryReservationId Long ItineraryReservationId of Expenses
Justification String Justification of Expenses
JustificationRequiredFlag Bool JustificationRequiredFlag of Expenses
LastUpdateDate Datetime LastUpdateDate of Expenses
LastUpdateLogin String LastUpdateLogin of Expenses
LastUpdatedBy String LastUpdatedBy of Expenses
LicensePlateNumber String LicensePlateNumber of Expenses
Location String Location of Expenses
LocationId Long LocationId of Expenses
LongTermTripFlag Bool LongTermTripFlag of Expenses
LongTermTripStartDate Date LongTermTripStartDate of Expenses
MerchantDocumentNumber String MerchantDocumentNumber of Expenses
MerchantName String MerchantName of Expenses
MerchantReference String MerchantReference of Expenses
MerchantTaxRegNumber String MerchantTaxRegNumber of Expenses
MerchantTaxpayerId String MerchantTaxpayerId of Expenses
MileagePolicyId Long MileagePolicyId of Expenses
NumberOfAttendees Decimal NumberOfAttendees of Expenses
NumberOfDays Int NumberOfDays of Expenses
NumberPeople Int NumberPeople of Expenses
OrgId Long OrgId of Expenses
PassengerAmount Decimal PassengerAmount of Expenses
PassengerName String PassengerName of Expenses
PassengerRateType String PassengerRateType of Expenses
PaymentDueFromCode String PaymentDueFromCode of Expenses
PersonId Long PersonId of Expenses
PersonalReceiptAmount Decimal PersonalReceiptAmount of Expenses
PolicyShortpayFlag Bool PolicyShortpayFlag of Expenses
PolicyViolatedFlag Bool PolicyViolatedFlag of Expenses
PolicyWarningFlag Bool PolicyWarningFlag of Expenses
PolicyWarningReasonCode String PolicyWarningReasonCode of Expenses
PreparerId Long PreparerId of Expenses
RatePerPassenger Decimal RatePerPassenger of Expenses
ReceiptAmount Decimal ReceiptAmount of Expenses
ReceiptCurrencyCode String ReceiptCurrencyCode of Expenses
ReceiptDate Date ReceiptDate of Expenses
ReceiptMissingDecRequiredFlag Bool ReceiptMissingDecRequiredFlag of Expenses
ReceiptMissingFlag Bool ReceiptMissingFlag of Expenses
ReceiptRequiredFlag Bool ReceiptRequiredFlag of Expenses
ReceiptVerifiedFlag Bool ReceiptVerifiedFlag of Expenses
ReimbursableAmount Decimal ReimbursableAmount of Expenses
ReimbursementCurrencyCode String ReimbursementCurrencyCode of Expenses
SequenceNumber Decimal SequenceNumber of Expenses
StartDate Date StartDate of Expenses
StartDateTimestamp Datetime StartDateTimestamp of Expenses
StartOdometer Decimal StartOdometer of Expenses
TaxClassificationCode String TaxClassificationCode of Expenses
TicketClassCode String TicketClassCode of Expenses
TicketNumber String TicketNumber of Expenses
TravelMethodCode String TravelMethodCode of Expenses
TravelType String TravelType of Expenses
TripDistance Decimal TripDistance of Expenses
UOMDays Decimal UOMDays of Expenses
ValidationErrorFlag Bool ValidationErrorFlag of Expenses
ValidationErrorMessages String ValidationErrorMessages of Expenses
ValidationWarningMessages String ValidationWarningMessages of Expenses
VehicleCategoryCode String VehicleCategoryCode of Expenses
VehicleType String VehicleType of Expenses
ZoneCode String ZoneCode of Expenses
ZoneTypeCode String ZoneTypeCode of Expenses
BusinessUnit String BusinessUnit of Expenses
PersonName String PersonName of Expenses
ExpenseTemplate String ExpenseTemplate of Expenses
ExpenseType String ExpenseType of Expenses
ReceiptCurrency String ReceiptCurrency of Expenses
ReimbursementCurrency String ReimbursementCurrency of Expenses
DistanceUnit String DistanceUnit of Expenses
TicketClass String TicketClass of Expenses
ExpenseSourceName String ExpenseSourceName of Expenses
ReferenceNumber String ReferenceNumber of Expenses
Request Long Request of Expenses
AttachmentExists String AttachmentExists of Expenses
ExpenseReportStatus String ExpenseReportStatus of Expenses
AuthTrxnNumber String AuthTrxnNumber of Expenses
TravelTypeName String TravelTypeName of Expenses
VehicleCategory String VehicleCategory of Expenses
VehicleTypeName String VehicleTypeName of Expenses
FuelTypeName String FuelTypeName of Expenses
TaxClassification String TaxClassification of Expenses
CountryCode String CountryCode of Expenses
AutoSubmitDate Datetime AutoSubmitDate of Expenses
ReceiptTime Datetime ReceiptTime of Expenses
TipAmount Decimal TipAmount of Expenses
VisitedFlag Bool VisitedFlag of Expenses
ValidationStatus String ValidationStatus of Expenses
PrepaidFlag Bool PrepaidFlag of Expenses
Finder String Finder of Expenses
SysEffectiveDate String SysEffectiveDate of Expenses

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