ExpenseReportsExpensematchedExpenses
Identifies expense lines matched with existing records (such as credit card transactions), reducing redundant entries.
Columns
| Name | Type | Description |
| ExpenseReportsExpenseReportId [KEY] | Long | Unique identifier for an expense report within the Oracle Financial Cloud system. This ID is used to track and reference specific expense reports across the platform. |
| ExpenseExpenseId [KEY] | Long | Unique identifier for a specific expense record within the system. This ID helps differentiate between individual expenses and is essential for expense management. |
| MatchedExpenseId | Long | Expense identifier of a matched record, representing an expense that has been matched with another record, typically in a reconciliation or audit process. |
| ExpenseId | Long | Unique identifier of an expense in the system, used for tracking and referencing individual expense entries across the platform. |
| MergedFlag | String | Flag indicating whether two or more expenses have been merged after a match. This helps in managing duplicate records or consolidating expenses. |
| MatchPercentage | Decimal | Percentage value that represents the strength of the match between two expense records. A higher percentage indicates a stronger match. |
| MatchReference [KEY] | String | Unique identifier for a matched record, typically used in reconciliation or audit processes to track the relationship between matched expenses. |
| BusinessUnit | String | The business unit associated with the expense report. This is used for categorizing expenses by organizational divisions or departments for reporting and budgeting. |
| ExpenseReportId | Long | Unique identifier for the associated expense report. This ID links individual expenses to a specific expense report for consolidated reporting. |
| Finder | String | Search term or filter used to locate specific records, such as an expense or report, within the system, typically used in query or search functionalities. |
| SysEffectiveDate | String | System-defined effective date, which indicates when the data in the record becomes valid. Used for managing and querying records based on their validity period. |
| CUReferenceNumber | Int | Identifier that links child aggregates to parent tables in the database. This reference is crucial for maintaining relationships within hierarchical data structures. |
| EffectiveDate | Date | The date that marks the start of the effective period for the resource, allowing the system to retrieve resources or records that are valid as of the specified date. |