EXM_EXPENSE_REPORTS

This table contains the general information for expense reports, such as the report number, purpose of the report, and the person on the expense report.

Details

  • Schema: FUSION

  • Object owner: EXM

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

EXM_EXPENSE_REPORTS_PK

EXPENSE_REPORT_ID

Columns

Name Datatype Length Precision Not-null Comments
EXPENSE_REPORT_ID NUMBER 18 Yes Identifier of the expense report.
AUDIT_PRIOR_MGR_STATUS_CODE VARCHAR2 30 Expense report approval status when expense auditor audits an expense report before manager approvals are complete.
PAYMENT_METHOD_CODE VARCHAR2 120 Method of payment for this expense report such as check, cash, or credit.
PARENT_EXPENSE_REPORT_ID NUMBER 18 Identifier of the parent expense report.
PREPARER_ID NUMBER 18 Identifier of the person who created the expense report.
PERSON_ID NUMBER 18 Identifier of the person whose expenses are included in this expense report.
ASSIGNMENT_ID NUMBER 18 Identifier of the assignment of the person on the expense report.
EXPENSE_REPORT_DATE DATE Month, day, and year in which an expense report is saved or submitted.
EXPENSE_REPORT_TOTAL NUMBER Total amount of the expense report in reimbursement currency. Amount in approver preferred currency is also shown if approver has a different preferred currency.
EXPENSE_REPORT_NUM VARCHAR2 50 Unique number that references an expense report and follows the numbering policies of the company.
PURPOSE VARCHAR2 240 Business activities that justify the expense report.
REIMBURSEMENT_CURRENCY_CODE VARCHAR2 15 Currency of the amount to be reimbursed to the individual for the expenses incurred.
EXCHANGE_RATE_TYPE VARCHAR2 30 Conversion rate type used for calculating the reimbursable amount.
OVERRIDE_APPROVER_ID NUMBER 18 Identifier of the person chosen as the initial approver by the individual.
CURRENT_APPROVER_ID NUMBER 18 Identifier of the current approver of the expense report.
AWT_GROUP_ID NUMBER 18 Alternate tax withholding group identifier.
UNAPPLIED_ADVANCES_JUST VARCHAR2 240 Justification for not applying an outstanding cash advance against this expense report.
REPORT_SUBMIT_DATE DATE Month, day, and year in which an expense report is submitted.
EXPENSE_STATUS_CODE VARCHAR2 30 Expense report approval status, such as Approved, Pending Manager Approval, or Paid.
EXPENSE_STATUS_DATE DATE Date when expense report acquired the current status.
EXP_REP_PROCESSING_ID NUMBER 18 Identifier of the details of expense report, such as report status change history.
RECEIPTS_STATUS_CODE VARCHAR2 30 Receipt status of an expense report, such as Missing, Required, and Received.
RECEIPTS_FILING_NUMBER VARCHAR2 240 Receipt filing number that is manually entered by the expense auditor.
RECEIPTS_RECEIVED_DATE DATE Date when receipts for the expense report are received.
HOLDING_EXPENSE_REPORT_ID NUMBER 18 Identifier of the expense report that is on payment hold, thereby preventing the reimbursement of this expense report.
AUDIT_CODE VARCHAR2 30 Audit type for the expense report based on receipt requirements, such as original receipt-based audit and imaged receipt-based audit.
LAST_AUDIT_BY NUMBER 18 Person identifier of the expense auditor who previously audited the expense report.
AUDIT_RETURN_REASON_CODE VARCHAR2 30 Reason why the expense report was returned to the individual during audit.
SHORTPAY_TYPE_CODE VARCHAR2 30 Indicator of why the expense report is short paid.
BOTHPAY_FLAG VARCHAR2 1 Indicator of whether the expense report contains corporate card transactions with Both Pay payment liability.
EXPORT_REJECT_CODE VARCHAR2 30 Reason for the rejection of the expense report by the payment request creation process.
EXPORT_REQUEST_ID NUMBER 18 Identifier of a specific instance of the expense reimbursement process that processed this report.
ATTRIBUTE_CATEGORY VARCHAR2 240 Descriptive Flexfield: structure definition of the user descriptive flexfield.
ATTRIBUTE_CHAR1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP1 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP2 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
FINAL_APPROVAL_DATE DATE Date when final approval is obtained.
CASH_EXPENSE_PAID_DATE DATE Date when cash expense was reimbursed to the individual.
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row.
WORKFLOW_CORRELATION_ID VARCHAR2 64 Human workflow composite identifier of the approval notification.
OBJECT_VERSION_NUMBER NUMBER 9 Yes 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.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
IMAGED_RECEIPTS_STATUS_CODE VARCHAR2 20 Status of the imaged receipts for an expense report, such as Required, Missing, and Received.
IMAGED_RECEIPTS_RECEIVED_DATE DATE Date when an imaged receipt is received for an expense report.
MISSING_IMAGES_REASON VARCHAR2 80 Reason imaged receipts are not submitted with the expense report.
OVERDUE_RCPT_CORRELATION_ID VARCHAR2 64 Human workflow composite identifier of the overdue receipt notification.
PAYMENT_HOLD_CORRELATION_ID VARCHAR2 64 Human workflow composite identifier of the expense report payment hold notification.
APPLY_CASH_ADV_FLAG VARCHAR2 1 Indicator of whether available cash advances are applied to this expense report.
UNAPPLIED_CASH_ADV_REASON VARCHAR2 240 Reason outstanding cash advances are not applied to this expense report.
TRIP_ID NUMBER 18 Business trip for which report was created.
REPORT_CREATION_METHOD_CODE VARCHAR2 30 Method of expense report creation, such as mobile iOS device or mobile Android device.
SPLIT_ALLOCATION_SET_ID NUMBER 18 Specific split allocation set identifier.
AUDIT_RULES_SNAPSHOT VARCHAR2 4000 Audit rules configured by customer
CASH_ADV_APPLIED_METHOD_CODE VARCHAR2 30 Method of applying cash advances to expenses. Possible values are from the EXM_ENABLE_APPLY_ADVANCES lookup-Manual,Automatic
CA_REVERSAL_GROUP_ID NUMBER 18 Identifier of the last reverted cash advances that were associated with an expense report. The Group ID is NULL for cash advances applied to the report.
CA_BANNER_DISPLAY_CODE VARCHAR2 30 Identifier to check whether to display cash advance adjusted, removed, withdrawn, or shortpaid message in the banner.

Foreign Keys

Table Foreign Table Foreign Key Column
EXM_EXPENSE_REPORTS exm_expense_reports PARENT_EXPENSE_REPORT_ID
EXM_EXPENSE_REPORTS gl_daily_conversion_types EXCHANGE_RATE_TYPE
EXM_EXPENSE_REPORTS ap_awt_groups AWT_GROUP_ID
EXM_EXPENSE_REPORTS per_persons PERSON_ID
exm_cash_adv_applications exm_expense_reports EXPENSE_REPORT_ID
exm_expense_reports exm_expense_reports PARENT_EXPENSE_REPORT_ID
exm_expenses exm_expense_reports EXPENSE_REPORT_ID
exm_exp_rep_processing exm_expense_reports EXPENSE_REPORT_ID
exm_exp_rep_processing exm_expense_reports HOLDING_EXPENSE_REPORT_ID
exm_expense_risk_indicators exm_expense_reports EXPENSE_REPORT_ID
exm_expense_dists exm_expense_reports EXPENSE_REPORT_ID
exm_audit_queues exm_expense_reports EXPENSE_REPORT_ID
exm_expense_violations exm_expense_reports EXPENSE_REPORT_ID

Indexes

Index Uniqueness Tablespace Columns
EXM_EXPENSE_REPORTS_N1 Non Unique EXM_EXPENSE_REPORTS_N1 PERSON_ID
EXM_EXPENSE_REPORTS_N10 Non Unique EXM_EXPENSE_REPORTS_N10 LAST_UPDATE_DATE
EXM_EXPENSE_REPORTS_N11 Non Unique EXM_EXPENSE_REPORTS_N11 RECEIPTS_STATUS_CODE
EXM_EXPENSE_REPORTS_N12 Non Unique EXM_EXPENSE_REPORTS_N12 IMAGED_RECEIPTS_STATUS_CODE
EXM_EXPENSE_REPORTS_N13 Non Unique EXM_EXPENSE_REPORTS_N13 TRIP_ID
EXM_EXPENSE_REPORTS_N2 Non Unique EXM_EXPENSE_REPORTS_N2 UPPER("EXPENSE_REPORT_NUM")
EXM_EXPENSE_REPORTS_N3 Non Unique EXM_EXPENSE_REPORTS_N3 PARENT_EXPENSE_REPORT_ID
EXM_EXPENSE_REPORTS_N4 Non Unique EXM_EXPENSE_REPORTS_N4 LAST_AUDIT_BY
EXM_EXPENSE_REPORTS_N5 Non Unique EXM_EXPENSE_REPORTS_N5 RECEIPTS_RECEIVED_DATE
EXM_EXPENSE_REPORTS_N6 Non Unique EXM_EXPENSE_REPORTS_N6 EXPENSE_STATUS_CODE
EXM_EXPENSE_REPORTS_N7 Non Unique EXM_EXPENSE_REPORTS_N7 UPPER("PURPOSE")
EXM_EXPENSE_REPORTS_N8 Non Unique EXM_EXPENSE_REPORTS_N8 EXPORT_REQUEST_ID
EXM_EXPENSE_REPORTS_N9 Non Unique EXM_EXPENSE_REPORTS_N9 EXPORT_REJECT_CODE
EXM_EXPENSE_REPORTS_PK Unique EXM_EXPENSE_REPORTS_PK EXPENSE_REPORT_ID