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 |