ExpenseReportsprocessingDetails

Columns


Name	Type	Description
ExpenseReportsExpenseReportId [KEY]	Long	Expense report identifier of the expense reports.
ExpenseReportProcessingId [KEY]	Long	Unique identifier of a processing detail record of a specific expense report.
ExpenseReportId	Long	Identifier of the expense report for which status changes are tracked.
Event	String	Event that triggered the expense report status change, such as approval and audit.
EventPerformerId	String	User who initiated the expense report status change event.
EventPerformerName	String	Name of the person who initiated the expense report status change event.
ExpenseStatusCode	String	Status of the expense report, such as Approved, Pending Manager Approval, and Paid.
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 for returning the expense report to the submitter during audit.
EventDate	Date	Date when the expense report status changed.
CreationDate	Datetime	Date and time when the processing detail record was created.
NoteId	Long	Identifier of the note that was created by the performer of the expense report status change event.

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