Expense Reports

The expense reports view object contains general information for expense reports, such as the report number, purpose of the report, and the person on the expense report.

Data store key : FscmTopModelAM.FinExtractAM.ExmBiccExtractAM.ExpenseReportExtractPVO

Primary Keys : ExpenseReportId

Initial Extract Date : ExpenseReportCreationDate

Incremental Extract Date : ExpenseReportLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
ExpenseReportApplyCashAdvFlag	Indicates whether available cash advances are applied to this expense report.
ExpenseReportAssignmentId	The identifier of the assignment of the person on the expense report.
ExpenseReportAttributeCategory	The context name for the Expense Reports descriptive flexfield.
ExpenseReportAttributeChar1	A character segment for the Expense Reports descriptive flexfield.
ExpenseReportAttributeChar10	A character segment for the Expense Reports descriptive flexfield.
ExpenseReportAttributeChar11	A character segment for the Expense Reports descriptive flexfield.
ExpenseReportAttributeChar12	A character segment for the Expense Reports descriptive flexfield.
ExpenseReportAttributeChar13	A character segment for the Expense Reports descriptive flexfield.
ExpenseReportAttributeChar14	A character segment for the Expense Reports descriptive flexfield.
ExpenseReportAttributeChar15	A character segment for the Expense Reports descriptive flexfield.
ExpenseReportAttributeChar2	A character segment for the Expense Reports descriptive flexfield.
ExpenseReportAttributeChar3	A character segment for the Expense Reports descriptive flexfield.
ExpenseReportAttributeChar4	A character segment for the Expense Reports descriptive flexfield.
ExpenseReportAttributeChar5	A character segment for the Expense Reports descriptive flexfield.
ExpenseReportAttributeChar6	A character segment for the Expense Reports descriptive flexfield.
ExpenseReportAttributeChar7	A character segment for the Expense Reports descriptive flexfield.
ExpenseReportAttributeChar8	A character segment for the Expense Reports descriptive flexfield.
ExpenseReportAttributeChar9	A character segment for the Expense Reports descriptive flexfield.
ExpenseReportAttributeDate1	A date segment for the Expense Reports descriptive flexfield.
ExpenseReportAttributeDate2	A date segment for the Expense Reports descriptive flexfield.
ExpenseReportAttributeDate3	A date segment for the Expense Reports descriptive flexfield.
ExpenseReportAttributeDate4	A date segment for the Expense Reports descriptive flexfield.
ExpenseReportAttributeDate5	A date segment for the Expense Reports descriptive flexfield.
ExpenseReportAttributeNumber1	A number segment for the Expense Reports descriptive flexfield.
ExpenseReportAttributeNumber2	A number segment for the Expense Reports descriptive flexfield.
ExpenseReportAttributeNumber3	A number segment for the Expense Reports descriptive flexfield.
ExpenseReportAttributeNumber4	A number segment for the Expense Reports descriptive flexfield.
ExpenseReportAttributeNumber5	A number segment for the Expense Reports descriptive flexfield.
ExpenseReportAttributeTimestamp1	A date and time segment for the Expense Reports descriptive flexfield.
ExpenseReportAttributeTimestamp2	A date and time segment for the Expense Reports descriptive flexfield.
ExpenseReportAuditCode	The audit type for the expense report based on receipt requirements, such as original receipt-based audit and imaged receipt-based audit.
ExpenseReportAuditPriorMgrStatusCode	The expense report approval status when expense auditor audits an expense report before manager approvals are complete.
ExpenseReportAuditReturnReasonCode	The reason why the expense report was returned to the individual during audit.
ExpenseReportAwtGroupId	The identifier for alternate tax withholding group.
ExpenseReportBothpayFlag	Indicates whether the expense report contains corporate card transactions with Both Pay payment liability.
ExpenseReportCashExpensePaidDate	The date when cash expense was reimbursed to the individual.
ExpenseReportCreatedBy	The user who created the expense report row.
ExpenseReportCreationDate	The date and time when the expense report was created.
ExpenseReportCreationMethodCode	The method of expense report creation, such as mobile iOS device or mobile Android device.
ExpenseReportCurrentApproverId	The identifier of the current approver of the expense report.
ExpenseReportDate	The month, day, and year in which an expense report is saved or submitted.
ExpenseReportExchangeRateType	The conversion rate type used for calculating the reimbursable amount.
ExpenseReportExpRepProcessingId	The identifier of the details of expense report, such as report status change history.
ExpenseReportExpenseStatusCode	The expense report approval status, such as Approved, Pending Manager Approval, or Paid.
ExpenseReportExpenseStatusDate	The date when expense report acquired the current status.
ExpenseReportExportRejectCode	The reason for the rejection of the expense report by the payment request creation process.
ExpenseReportExportRequestId	The identifier of a specific instance of the expense reimbursement process that processed this report.
ExpenseReportFinalApprovalDate	The date when final approval is obtained.
ExpenseReportHoldingExpenseReportId	The identifier of the expense report that is on payment hold, thereby preventing the reimbursement of this expense report.
ExpenseReportId	The unique identifier of the expense report.
ExpenseReportImagedReceiptsReceivedDate	The date when an imaged receipt is received for an expense report.
ExpenseReportImagedReceiptsStatusCode	The status of the imaged receipts for an expense report, such as Required, Missing, and Received.
ExpenseReportLastAuditBy	The identifier of the expense auditor who previously audited the expense report.
ExpenseReportLastUpdateDate	The date and time when the expense report row was last updated.
ExpenseReportLastUpdateLogin	The session login associated with the user who last updated the expense report row.
ExpenseReportLastUpdatedBy	The user who last updated the expense report row.
ExpenseReportMissingImagesReason	The reason why imaged receipts are not submitted with the expense report.
ExpenseReportNum	The unique number that references an expense report and follows the numbering policies of the company.
ExpenseReportObjectVersionNumber	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
ExpenseReportOrgId	The identifier of the business unit associated to the row.
ExpenseReportOverdueRcptCorrelationId	The human workflow composite identifier of the overdue receipt notification.
ExpenseReportOverrideApproverId	The identifier of the person chosen as the initial approver by the individual.
ExpenseReportParentExpenseReportId	The identifier of the parent expense report.
ExpenseReportPaymentHoldCorrelationId	The human workflow composite identifier of the expense report payment hold notification.
ExpenseReportPaymentMethodCode	The method of payment for this expense report such as check, cash, or credit.
ExpenseReportPersonId	The identifier of the person whose expenses are included in this expense report.
ExpenseReportPreparerId	The identifier of the person who created the expense report.
ExpenseReportPurpose	The business activities that justify the expense report.
ExpenseReportReceiptsFilingNumber	The receipt filing number that is manually entered by the expense auditor.
ExpenseReportReceiptsReceivedDate	The date when receipts for the expense report are received.
ExpenseReportReceiptsStatusCode	The receipt status of an expense report, such as Missing, Required, and Received.
ExpenseReportReimbursementCurrencyCode	The currency of the amount to be reimbursed to the individual for the expenses incurred.
ExpenseReportShortpayTypeCode	Indicates why the expense report is short paid.
ExpenseReportSubmitDate	The month, day, and year in which an expense report is submitted.
ExpenseReportTotal	The total amount of the expense report in reimbursement currency. Amount in approver preferred currency is also shown if approver has a different preferred currency.
ExpenseReportTripId	The business trip for which report was created.
ExpenseReportUnappliedAdvancesJust	The justification for not applying an outstanding cash advance against this expense report.
ExpenseReportUnappliedCashAdvReason	The reason outstanding cash advances are not applied to this expense report.
ExpenseReportWorkflowCorrelationId	The human workflow composite identifier of the approval notification.