ExpenseReportsexpenseNotes

Columns


Name	Type	Description
ExpenseReportsExpenseReportId [KEY]	Long	Expense report identifier of the expense reports.
CreatedBy	String	User who created an expense note.
CreationDate	Datetime	Date when an expense note was created.
ExpenseReportId	Long	Unique identifier of an expense report for which expense notes are entered.
ExpenseReportProcessingId [KEY]	Long	Unique identifier of an expense report's processing detail.
Event	String	Event that triggered an expense report status change, such as approval or audit.
FullName	String	Name of the person who's associated with an expense note.
LastUpdatedBy	String	User who last updated the expense note.
LastUpdateDate	Datetime	Date when the expense note was last updated.
LastUpdateLogin	String	Session login that's associated with the user who last updated the expense note.
NoteId	Long	Unique identifier of the expense note that resulted from a change of status of the expense report.
NoteText	String	Text of the expense note that was entered by an approver or an auditor.
NoteTextTrunc	String	First 1,024 characters in an expense note that were entered by an approver or an auditor.
NoteTypeCode	String	Code that's associated with an expense note's category.
PersonId	Long	Unique identifier of the person who's associated with the expense note.
SourceObjectCode	String	Code that's associated with the source object as defined in OBJECTS Metadata.
SourceObjectUid	String	Unique identifier of the source object, such as Activities or Opportunities as defined in OBJECTS Metadata.
UserLastUpdateDate	Datetime	Date and time when the user last updated the row on a disconnected mobile device.

Pseudo-Columns

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


Name	Type	Description
BusinessUnit	String	BusinessUnit
SysEffectiveDate	String	SysEffectiveDate
Finder	String	finder

ODBC Driver for Oracle Fusion Cloud Financials

ExpenseReportsexpenseNotes

Columns

Pseudo-Columns