ExpenseReportsprocessingDetails
Logs status changes and processing steps (for example, approvals, rejections) for an expense report, providing an audit trail.
Columns
| Name | Type | Description |
| ExpenseReportsExpenseReportId [KEY] | Long | Unique identifier for the expense report, used to track and reference specific expense reports within the system. |
| ExpenseReportProcessingId [KEY] | Long | Unique identifier for the processing details associated with a specific expense report, enabling tracking of processing events. |
| ExpenseReportId | Long | Identifier for the expense report, used to track its status and changes throughout the approval and audit process. |
| Event | String | The specific event that triggered a status change in the expense report, such as 'Approval', 'Audit', or 'Rejection'. |
| EventPerformerId | String | Unique identifier for the user who initiated the status change event in the expense report, useful for tracking and auditing purposes. |
| EventPerformerName | String | Full name of the person who initiated the expense report status change event, helping to identify responsible parties. |
| ExpenseStatusCode | String | Code representing the current status of the expense report, such as 'Approved', 'Pending Manager Approval', or 'Paid'. |
| AuditCode | String | Code indicating the type of audit performed on the expense report, such as 'Original Receipt Audit' or 'Imaged Receipt Audit'. |
| AuditReturnReasonCode | String | Code indicating the reason for returning the expense report to the submitter during the audit process, such as 'Missing Documentation'. |
| EventDate | Date | Date when the expense report status was last updated, helping to track the timeline of the approval and audit process. |
| CreationDate | Datetime | Timestamp indicating when the processing detail record for the expense report was created, useful for data tracking and historical analysis. |
| NoteId | Long | Unique identifier for the note created by the user who performed the status change event, often used to record reasons or additional details. |
| BusinessUnit | String | Name or identifier of the business unit associated with the expense report, used for classification and financial reporting. |
| Finder | String | Search term or filter used to locate specific records or attachments related to the expense report, typically used for query functionality. |
| SysEffectiveDate | String | System-defined effective date, used to manage the validity of records and track changes in system data over time. |
| CUReferenceNumber | Int | Identifier used to link child aggregate data to parent tables in the financial data model, enabling hierarchical reporting. |
| EffectiveDate | Date | Date parameter used in queries to fetch records or data that are effective as of the specified start date, ensuring accurate historical data retrieval. |