ExpenseReports

Columns


Name	Type	Description
AssignmentId	Long	Identifier of the assignment of the person on the expense report.
AuditCode	String	Audit type for the expense report based on receipt requirements, such as original receipt-based audit and imaged receipt-based audit.
AuditReturnReasonCode	String	Reason why the expense report was returned to the individual during audit.
BothpayFlag	Bool	Indicator of whether the expense report contains corporate card transactions with Both Pay payment liability.
CurrentApproverId	Long	Identifier of the current approver of the expense report.
ExchangeRateType	String	Conversion rate type used for calculating the reimbursable amount.
ExpenseReportDate	Date	Month, day, and year in which an expense report is saved or submitted.
ExpenseReportId [KEY]	Long	Identifier of the expense report.
ExpenseReportNumber	String	Unique number that references an expense report and follows the numbering policies of the company.
ExpenseReportTotal	Double	Total amount of the expense report in reimbursement currency. Amount in approver preferred currency is also shown if approver has a different preferred currency.
ExpenseStatusCode	String	Expense report approval status, such as Approved, Pending Manager Approval, or Paid.
ExpenseStatusDate	Date	Date when expense report acquired the current status.
FinalApprovalDate	Date	Date when final approval is obtained.
ImagedReceiptsReceivedDate	Date	Date when an imaged receipt is received for an expense report.
ImagedReceiptsStatusCode	String	Code that indicates status of the imaged receipts for an expense report, such as Required, Missing, and Received.
MissingImagesReason	String	Reason imaged receipts aren't submitted with the expense report.
OrgId	Long	Indicates the identifier of the business unit associated to the row.
OverrideApproverId	Long	Identifier of the person chosen as the initial approver by the individual.
ParentExpenseReportId	Long	Identifier of the parent expense report.
PaymentMethodCode	String	Method of payment for this expense report such as check, cash, or credit.
PersonId	Long	Value that uniquely identifies the person who owns the expense report.
PreparerId	Long	Value that uniquely identifies the person who created the expense report.
Purpose	String	Business activities that justify the expense report.
ReceiptsFilingNumber	String	Receipt filing number that's manually entered by the expense auditor.
ReceiptsReceivedDate	Date	Date when receipts for the expense report are received.
ReceiptsStatusCode	String	Receipt status of an expense report, such as Missing, Required, and Received.
ReimbursementCurrencyCode	String	Code that indicates the currency of the amount to be reimbursed to the individual for expenses incurred.
ReportCreationMethodCode	String	Method of expense report creation, such as mobile iOS device or mobile Android device.
ReportSubmitDate	Date	Month, day, and year in which an expense report is submitted.
TripId	Long	Business trip for which report was created.
UnappliedAdvancesJust	String	Justification for not applying an outstanding cash advance against this expense report.
UnappliedCashAdvReason	String	Reason outstanding cash advances aren't applied to this expense report.
CreatedBy	String	Who column: indicates the user who created the row.
CreationDate	Datetime	Who column: indicates the date and time of the creation of the row.
LastUpdateDate	Datetime	Who column: indicates the date and time of the last update of the row.
LastUpdateLogin	String	Session login associated to the user who last updated the row.
LastUpdatedBy	String	Indicates the user who last updated the row.
BusinessUnit	String	Indicates the identifier of the business unit associated with the row.
SubmitReport	String	Indicates whether the expense report can be created and submitted.
MatchExpenses	String	Identifies whether corporate card transactions can be matched against expenses.
SubmitErrors	String	Identifies whether errors occurred during submission of the expense report.
PersonName	String	Name of the person for whom the expense report is created.
OriginalReceiptsStatus	String	Status of the original receipts for an expense report, such as Required, Missing, and Received.
ImagedReceiptsStatus	String	Status of the imaged receipts for an expense report, such as Required, Missing, and Received.
ExpenseReportStatus	String	Status of the expense report.
AuditCodeName	String	Lookup meaning of Audit Code.
CurrentApprovers	String	List of persons with whom expense report approval is pending.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
SysEffectiveDate	String	SysEffectiveDate
Finder	String	finder

ODBC Driver for Oracle Fusion Cloud Financials

ExpenseReports

Columns

Pseudo-Columns