ExpensesmatchedExpenses
Syncs submitted expenses with matched records (for example, credit card data), preventing duplicates and maintaining consistency.
Columns
| Name | Type | Description |
| ExpensesExpenseId [KEY] | Long | Unique identifier for the expense record, used to track and manage individual expenses across the system. |
| MatchedExpenseId | Long | Identifier for a matched expense record, used to link the current expense to a corresponding matching entry in the system. |
| ExpenseId | Long | Unique identifier for an expense, helping to track and categorize each specific expense item in the system. |
| MergedFlag | String | Indicates whether two or more expenses have been merged after being matched, helping to track combined records. |
| MatchPercentage | Decimal | Percentage indicating the strength or confidence level of the match between the expenses, used to assess the accuracy of matched records. |
| MatchReference [KEY] | String | Unique identifier associated with the matched record, used to reference and verify the matching process for an expense. |
| Finder | String | Search term or identifier used to locate and filter specific records or entries within the database, enhancing data retrieval. |
| PersonId | String | Unique identifier for the person associated with the expense, linking the record to the individual responsible for the expense. |
| Request | String | Request identifier associated with the expense, used for tracking the approval, validation, or review process of the expense submission. |
| SysEffectiveDate | String | System-defined effective date, indicating when the record becomes valid in the system and applicable for processing. |
| CUReferenceNumber | Int | Reference number used to link child aggregates to their parent tables, maintaining relational integrity within the system. |
| EffectiveDate | Date | Date parameter used to fetch resources effective as of a specified start date, ensuring accurate and time-sensitive data retrieval. |