ExpenseReports
ExpenseReports
Columns
| Name | Type | Description |
| AssignmentId | Long | Identifier of the assignment of the person on the expense report. |
| 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 why the expense report was returned to the individual during audit. |
| BothpayFlag | Bool | Indicator of whether the expense report contains corporate card transactions with Both Pay payment liability. |
| CurrentApproverId | Long | Identifier of the current approver of the expense report. |
| ExchangeRateType | String | Conversion rate type used for calculating the reimbursable amount. |
| ExpenseReportDate | Date | Month, day, and year in which an expense report is saved or submitted. |
| ExpenseReportId [KEY] | Long | Identifier of the expense report. |
| ExpenseReportNumber | String | Unique number that references an expense report and follows the numbering policies of the company. |
| ExpenseReportTotal | Double | Total amount of the expense report in reimbursement currency. Amount in approver preferred currency is also shown if approver has a different preferred currency. |
| ExpenseStatusCode | String | Expense report approval status, such as Approved, Pending Manager Approval, or Paid. |
| ExpenseStatusDate | Date | Date when expense report acquired the current status. |
| FinalApprovalDate | Date | Date when final approval is obtained. |
| ImagedReceiptsReceivedDate | Date | Date when an imaged receipt is received for an expense report. |
| ImagedReceiptsStatusCode | String | Code that indicates status of the imaged receipts for an expense report, such as Required, Missing, and Received. |
| MissingImagesReason | String | Reason imaged receipts aren't submitted with the expense report. |
| OrgId | Long | Indicates the identifier of the business unit associated to the row. |
| OverrideApproverId | Long | Identifier of the person chosen as the initial approver by the individual. |
| ParentExpenseReportId | Long | Identifier of the parent expense report. |
| PaymentMethodCode | String | Method of payment for this expense report such as check, cash, or credit. |
| PersonId | Long | Value that uniquely identifies the person who owns the expense report. |
| PreparerId | Long | Value that uniquely identifies the person who created the expense report. |
| Purpose | String | Business activities that justify the expense report. |
| ReceiptsFilingNumber | String | Receipt filing number that's manually entered by the expense auditor. |
| ReceiptsReceivedDate | Date | Date when receipts for the expense report are received. |
| ReceiptsStatusCode | String | Receipt status of an expense report, such as Missing, Required, and Received. |
| ReimbursementCurrencyCode | String | Code that indicates the currency of the amount to be reimbursed to the individual for expenses incurred. |
| ReportCreationMethodCode | String | Method of expense report creation, such as mobile iOS device or mobile Android device. |
| ReportSubmitDate | Date | Month, day, and year in which an expense report is submitted. |
| TripId | Long | Business trip for which report was created. |
| UnappliedAdvancesJust | String | Justification for not applying an outstanding cash advance against this expense report. |
| UnappliedCashAdvReason | String | Reason outstanding cash advances aren't applied to this expense report. |
| CreatedBy | String | Who column: indicates the user who created the row. |
| CreationDate | Datetime | Who column: indicates the date and time of the creation of the row. |
| LastUpdateDate | Datetime | Who column: indicates the date and time of the last update of the row. |
| LastUpdateLogin | String | Session login associated to the user who last updated the row. |
| LastUpdatedBy | String | Indicates the user who last updated the row. |
| BusinessUnit | String | Indicates the identifier of the business unit associated with the row. |
| SubmitReport | String | Indicates whether the expense report can be created and submitted. |
| MatchExpenses | String | Identifies whether corporate card transactions can be matched against expenses. |
| SubmitErrors | String | Identifies whether errors occurred during submission of the expense report. |
| PersonName | String | Name of the person for whom the expense report is created. |
| OriginalReceiptsStatus | String | Status of the original receipts for an expense report, such as Required, Missing, and Received. |
| ImagedReceiptsStatus | String | Status of the imaged receipts for an expense report, such as Required, Missing, and Received. |
| ExpenseReportStatus | String | Status of the expense report. |
| AuditCodeName | String | Lookup meaning of Audit Code. |
| CurrentApprovers | String | List of persons with whom expense report approval is pending. |
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 |
| SysEffectiveDate | String | SysEffectiveDate |
| Finder | String | finder |