ExpenseReportsprocessingDetails
ExpenseReportsprocessingDetails
Columns
| Name | Type | Description |
| ExpenseReportsExpenseReportId [KEY] | Long | Expense report identifier of the expense reports. |
| ExpenseReportProcessingId [KEY] | Long | Unique identifier of a processing detail record of a specific expense report. |
| ExpenseReportId | Long | Identifier of the expense report for which status changes are tracked. |
| Event | String | Event that triggered the expense report status change, such as approval and audit. |
| EventPerformerId | String | User who initiated the expense report status change event. |
| EventPerformerName | String | Name of the person who initiated the expense report status change event. |
| ExpenseStatusCode | String | Status of the expense report, such as Approved, Pending Manager Approval, and Paid. |
| AuditCode | String | Audit type for the expense report based on receipt requirements, such as original receipt-based audit and imaged receipt-based audit. |
| AuditReturnReasonCode | String | Reason for returning the expense report to the submitter during audit. |
| EventDate | Date | Date when the expense report status changed. |
| CreationDate | Datetime | Date and time when the processing detail record was created. |
| NoteId | Long | Identifier of the note that was created by the performer of the expense report status change event. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| BusinessUnit | String | BusinessUnit |
| SysEffectiveDate | String | SysEffectiveDate |
| Finder | String | finder |