ExpensesmatchedExpenses
ExpensesmatchedExpenses
Columns
Name | Type | Description |
ExpensesExpenseId [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. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
PersonId | String | PersonId |
Request | String | Request |
SysEffectiveDate | String | SysEffectiveDate |
Finder | String | finder |