ExpensesduplicateExpenses
Alerts users to expenses that may have been entered multiple times, aiding in cost control and policy enforcement.
Columns
| Name | Type | Description |
| ExpensesExpenseId [KEY] | Long | Unique identifier for each expense record, used to track and reference individual expenses within the system. |
| ExpenseId | Long | Value that uniquely identifies the parent expense associated with a duplicate expense, allowing for linking duplicates to their original expense. |
| DuplicateExpenseId | Long | Unique identifier for a specific duplicate expense item, helping to distinguish it from other expense records. |
| DuplicateStatusCode | String | Indicates whether an expense is a duplicate of another. Common values include 'Duplicate' or 'Original'. |
| DuplicateGroupId | Long | Unique identifier for a group of duplicate expenses, used for organizing and managing related duplicate entries. |
| DuplicateExpenseSource | String | Code that indicates the source of the duplicate expense, typically 'CASH' for cash expenses or 'CORP_CARD' for corporate card expenses. |
| DuplicateReceiptAmount | Decimal | Amount of the duplicate expense receipt in the currency in which the receipt was issued, important for accurate reimbursement or reporting. |
| DuplicateReceiptCurrencyCode | String | Currency code that represents the currency in which the duplicate expense receipt was issued, such as USD or EUR. |
| DuplicateLocation | String | The physical or virtual location where the duplicate expense was incurred, such as 'New York Office' or 'Online'. |
| DuplicateDescription | String | Detailed description of the duplicate expense item, providing context and details about the nature of the expense. |
| DuplicateMerchantName | String | Name of the merchant or vendor where the duplicate expense was incurred, typically a business or service provider. |
| DuplicateStartDate | Date | Date when the duplicate expense was first incurred, or the start date of a series of duplicate expenses that span multiple days. |
| DuplicateEndDate | String | Last date of the duplicate expense that spans multiple days, helping to define the time frame of the duplicate expense occurrence. |
| DuplicateCreationDate | Datetime | Timestamp of when the duplicate expense record was created in the system, aiding in tracking and auditing. |
| DuplicateCreationMethodCode | String | Code that indicates the method by which the duplicate expense was created, such as manual entry or automated system import. |
| DuplicateExpenseType | String | The type of expense for which the duplicate was recorded, such as 'Travel', 'Meals', or 'Office Supplies'. |
| DuplicateExpenseReportId | Long | Unique identifier for the expense report associated with the duplicate expense, allowing for easy reference and linking to reports. |
| DuplicateExpenseStatusCode | String | Approval status of the duplicate expense within its expense report, such as 'Approved', 'Pending Manager Approval', or 'Paid'. |
| DuplicateCreditCardTrxnId | Long | Unique identifier for the corporate card transaction related to the duplicate expense, enabling tracking and reconciliation of corporate card expenses. |
| DuplicateExpenseReportNumber | String | Unique number that references the expense report containing the duplicate expense, following company-specific numbering conventions for expense reports. |
| Finder | String | Search or filter term used in queries to locate specific expense records or related information in the database. |
| PersonId | String | Unique identifier for a person in the system, typically representing an employee, contractor, or individual associated with the expense. |
| Request | String | Request identifier used to link the expense to a particular request or approval process, often used in workflow management. |
| SysEffectiveDate | String | Date when the data record became effective in the system, helping to track and manage versioning and validity of records. |
| CUReferenceNumber | Int | Reference number that maps child aggregates (for example, individual transactions) to parent tables (for example, expense reports), supporting hierarchical data relationships. |
| EffectiveDate | Date | Date parameter used in queries to filter resources or records that are valid or effective as of the specified date, ensuring data relevance. |