ExpenseReportsExpenseduplicateExpenses
Highlights potential duplicate expenses within a report, flagging lines that share similar attributes for review.
Columns
| Name | Type | Description |
| ExpenseReportsExpenseReportId [KEY] | Long | Unique identifier for an expense report within the system, used to track and manage individual expense reports. |
| ExpenseExpenseId [KEY] | Long | Identifier for the expense record, linking it to the specific transaction or financial activity. |
| ExpenseId | Long | Unique identifier for the parent expense in cases where a duplicate expense is detected, ensuring proper tracking of related expenses. |
| DuplicateExpenseId | Long | Unique identifier for a specific duplicate expense entry, enabling the distinction between original and duplicate expenses. |
| DuplicateStatusCode | String | Flag indicating whether the expense is recognized as a duplicate; possible values include 'Duplicate' or 'Non-Duplicate'. |
| DuplicateGroupId | Long | Identifier for a set of duplicate expenses grouped together, helping to manage and identify patterns of duplicated spending. |
| DuplicateExpenseSource | String | Code representing the source of the duplicate expense; options include 'CASH' or 'CORP_CARD' for cash and corporate card transactions. |
| DuplicateReceiptAmount | Decimal | The amount stated on the duplicate expense receipt, expressed in the receipt's currency, used for financial reconciliation. |
| DuplicateReceiptCurrencyCode | String | Currency code for the duplicate expense receipt, indicating the currency in which the expense was recorded. |
| DuplicateLocation | String | Geographical location where the duplicate expense occurred, providing context for expense analysis and validation. |
| DuplicateDescription | String | Detailed description of the duplicate expense item, typically including details like the nature of the expense or reason for duplication. |
| DuplicateMerchantName | String | Name of the merchant or vendor where the duplicate expense occurred, used for vendor tracking and reconciliation. |
| DuplicateStartDate | Date | The date when the duplicate expense occurred or the start of a range of dates for an expense that spans multiple days. |
| DuplicateEndDate | String | The end date of the duplicate expense period, especially for multi-day expenses, to clearly define the duration of the duplication. |
| DuplicateCreationDate | Datetime | Timestamp of when the duplicate expense entry was created in the system, used for audit and tracking purposes. |
| DuplicateCreationMethodCode | String | Code representing the method used to create the duplicate expense entry, such as manual entry or automated import. |
| DuplicateExpenseType | String | Type of expense that has been flagged as a duplicate, helping to categorize and process duplicate expenses based on type. |
| DuplicateExpenseReportId | Long | Unique identifier for the specific expense report to which the duplicate expense belongs, ensuring proper linking within the system. |
| DuplicateExpenseStatusCode | String | Approval status of the duplicate expense within the expense report workflow, such as 'Approved', 'Pending Manager Approval', or 'Paid'. |
| DuplicateCreditCardTrxnId | Long | Identifier for the corporate credit card transaction linked to the duplicate expense, providing a direct connection to the transaction record. |
| DuplicateExpenseReportNumber | String | Unique number assigned to the duplicate expense report, following the company’s established numbering conventions for expense reports. |
| BusinessUnit | String | Identifier for the business unit associated with the expense, useful for categorizing expenses by organizational unit for reporting purposes. |
| ExpenseReportId | Long | Identifier for the expense report, linking the expense to a specific report for review and processing. |
| Finder | String | Search term or filter used in the system to locate or display specific expense records or reports, aiding in navigation and querying. |
| SysEffectiveDate | String | Date representing when the system’s data became effective, often used for data versioning and historical tracking. |
| CUReferenceNumber | Int | Reference number used to link child aggregate records with their corresponding parent records, maintaining data integrity and hierarchical relationships. |
| EffectiveDate | Date | Date parameter used to filter records by their effective date, ensuring only relevant resources as of that date are retrieved. |