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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
BusinessUnit | String | BusinessUnit |
SysEffectiveDate | String | SysEffectiveDate |
Finder | String | finder |