ExpenseReportsExpensematchedExpenses

Columns


Name	Type	Description
ExpenseReportsExpenseReportId [KEY]	Long	Expense report identifier of the expense reports.
ExpenseExpenseId [KEY]	Long	Expense identifier of the expense record.
MatchedExpenseId	Long	Expense identifier of a matched record.
ExpenseId	Long	Unique identifier of an expense.
MergedFlag	String	Indicates whether expenses are merged after a match.
MatchPercentage	Double	Percentage that indicates the strength of the match.
MatchReference [KEY]	String	Unique identifier of a matched record.

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