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 |