JDBC Driver for Oracle Fusion Cloud Financials

Build 24.0.9062

ExpenseReportsExpense

ExpenseReportsExpense

Columns

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

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