1. Tables and Views for Financials
  2. EXM_EXPENSES

EXM_EXPENSES

EXM_EXPENSES stores detailed information about expense items for individual expense reports you enter.

Details

  • Schema: FUSION

  • Object owner: EXM

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

EXM_EXPENSES_PK

EXPENSE_ID

Columns

Name Datatype Length Precision Not-null Comments Flexfield-mapping Status
EXPENSE_ID NUMBER 18 Yes Unique identifier of a specific expense item. Active
CARD_USAGE_ID NUMBER 18 Card usage identifier that is associated with an existing card usage
RCPT_MISSING_THRESHOLD_FLAG VARCHAR2 1 Indicates whether the expense item receipt amount is below a specific threshold percentage.
VALIDATION_STATUS_CODE VARCHAR2 30 Types of exceptions for an expense item. Possible values are NULL for old expenses that need to be revalidated, E for expenses with at least one error, W for expenses that have no errors but have warnings, and C for expenses without any errors or warnings.
TRXN_AVAILABLE_DATE DATE Date when a corporate card transaction is available for inclusion in an expense report.
CARD_ID NUMBER 18 Unique identifier of a specific corporate card. Active
PERSON_ID NUMBER 18 Yes Person identifier of the individual on the corporate card. Active
ASSIGNMENT_ID NUMBER 18 Yes Assignment identifier of the individual on the corporate card. Active
EXPENSE_REPORT_ID NUMBER 18 Unique identifier of a specific expense report. Active
ITEMIZATION_PARENT_EXPENSE_ID NUMBER 18 Unique identifier of the parent expense of an itemized expense item. Possible values are NULL indicating that the expense is not itemized, -1 indicating that the expense is a parent line with itemization, and greater than 0 indicating that the expense is an itemized child line and the value is the parent line's identifier. Active
SEQUENCE_NUM NUMBER Sequence in which expenses items are entered into an expense report. Active
REIMBURSABLE_AMOUNT NUMBER Amount to be reimbursed to the individual in reimbursable currency for this expense. Active
ORIG_REIMBURSABLE_AMOUNT NUMBER Original amount to be reimbursed to the individual for this expense. Active
DESCRIPTION VARCHAR2 240 Description of an expense item. Active
JUSTIFICATION VARCHAR2 240 Reason an expense was incurred. Active
MERGED_PARENT_EXPENSE_ID NUMBER 18 Identifies the expense to which the duplicate expenses are merged.
VISITED_FLAG VARCHAR2 1 Indicates whether the user has confirmed the expense.
START_DATE DATE Date when the expense occurred or the first day of an expense that spans multiple days. Active
END_DATE DATE Last day of an expense that spans multiple days. Active
RECEIPT_DATE DATE Date when the expense occurred.
CC_PAYMENT_DUE_DATE DATE Date when the corporate credit card amount needs to be paid.
RECEIPT_CURRENCY_CODE VARCHAR2 15 Receipt currency of an expense item. Active
EXCHANGE_RATE NUMBER Rate that represents the amount one currency can be exchanged for another at a specific point in time. Active
RECEIPT_AMOUNT NUMBER Amount of the receipt in the receipt currency. Active
DAILY_AMOUNT NUMBER Amount consumed in a day for the expense.
TIP_AMOUNT NUMBER Amount of tip given in the transaction. This helps to manage cases where receipts have different amount because of the tips involved. Active
EXPENSE_SOURCE VARCHAR2 30 Source of an expense item, such as cash or corporate card. Active
EXPENSE_TEMPLATE_ID NUMBER 18 Unique identifier of a specific expense template. Active
EXPENSE_TYPE_ID NUMBER 18 Unique identifier for a specific expense type. Active
EXPENSE_TYPE_CATEGORY_CODE VARCHAR2 30 Grouping of expense types and additional data fields that are relevant for a particular grouping of expenses. An example is airfare. This grouping allows expense types to include information such as class of fare, merchant, ticket number, location from, and location to. Active
FUNC_CURRENCY_AMOUNT NUMBER Amount to be reimbursed to the individual in functional currency for expenses incurred. Active
CREDIT_CARD_TRXN_ID NUMBER 18 Unique identifier of a specific corporate card transaction. Active
RECEIPT_REQUIRED_THRESHOLD NUMBER Amount above which receipt is required for the expense item.
CC_PREPAID_INVOICE_ID NUMBER 18 Identifier of the payment request generated to reimburse the individual. Active
LOCATION_ID NUMBER 18 Unique identifier of a specific location. Active
NUMBER_OF_ATTENDEES NUMBER Number of people that attended the event for which an expense was incurred. For example, the number of people that attended a business dinner or an entertainment event. Active
MERCHANT_DOCUMENT_NUMBER VARCHAR2 80 Receipt number on the receipt issued by the merchant. Active
MERCHANT_NAME VARCHAR2 80 Name of the merchant where the expense was incurred. Active
MERCHANT_REFERENCE VARCHAR2 240 Purchase identification of a transaction provided by the merchant at the point of sale. Active
MERCHANT_TAX_REG_NUMBER VARCHAR2 80 Unique sequence of letters and/or numbers assigned to a party or party site, by a tax authority, when it is registered and by which the party or party site registration will be identified. Active
MERCHANT_TAXPAYER_ID VARCHAR2 80 Tax payer identifier of the merchant. Active
COUNTRY_OF_SUPPLY VARCHAR2 5 Country where the supplier resides. Active
VEHICLE_CATEGORY_CODE VARCHAR2 30 Grouping of vehicle types such as, company, private, or rental. Active
VEHICLE_TYPE VARCHAR2 30 Types of vehicles for which mileage reimbursement is permitted such as, car, motorcycle, and van. Active
FUEL_TYPE VARCHAR2 30 Types of fuel for which fuel charge reimbursement is permitted. Active
NUMBER_PEOPLE NUMBER Number of passengers in the vehicle. Active
DAILY_DISTANCE NUMBER Distance traveled in a day for business. Active
DISTANCE_UNIT_CODE VARCHAR2 30 Unit of the distance traveled, such as kilometer and mile. Active
AVG_MILEAGE_RATE NUMBER Average mileage rate including additional applicable rates such as passenger rates and rates for hauling a trailer. Active
DESTINATION_FROM VARCHAR2 4000 Starting or departure location of the trip. Active
DESTINATION_TO VARCHAR2 4000 Ending or arrival location of the trip. Active
DISPLAYED_FROM_ADDRESS VARCHAR2 4000 Full address of the starting or departure location of the trip.
DISPLAYED_TO_ADDRESS VARCHAR2 4000 Full address of the ending or arrival location of the trip.
TO_ADDRESS_CITY VARCHAR2 1000 City of the ending or arrival location of the trip.
ROUND_TRIP_FLAG VARCHAR2 1 Indicates whether the trip is a round trip.
TRIP_DISTANCE NUMBER Total distance traveled during a business trip for which mileage reimbursement is requested. Active
LICENSE_PLATE_NUMBER VARCHAR2 30 License plate number of the vehicle. Active
MILEAGE_RATE_ADJUSTED_FLAG VARCHAR2 1 Indicator of whether the mileage rate was adjusted after expense report approval. Active
TRAVEL_TYPE VARCHAR2 30 Indicator of whether a flight is domestic or international. Active
TICKET_CLASS_CODE VARCHAR2 30 Cabin class of a flight or ship, for example business or economy. Active
TICKET_NUMBER VARCHAR2 80 Airline ticket number. Active
FLIGHT_NUMBER VARCHAR2 80 Airline flight number. Active
DEPARTURE_LOCATION_ID NUMBER 18 Unique identifier of the departure location. Active
RATE_PER_PASSENGER NUMBER Applicable mileage rate per passenger for this expense. Active
PASSENGER_RATE_TYPE VARCHAR2 30 Passenger rate type used for mileage reimbursement for this expense. Active
PASSENGER_AMOUNT NUMBER Total reimbursement for carrying passengers in the vehicle. Active
RANGE_LOW NUMBER Lower limit of the distance threshold range used in mileage rate calculation. Active
RANGE_HIGH NUMBER Higher limit of the distance threshold range used in mileage rate calculation. Active
UOM_DAYS NUMBER Number of per diem expense days calculated based on the unit of measure. Active
ALLOCATION_REASON VARCHAR2 240 Reason for updating allocations for this report line. Active
ALLOCATION_SPLIT_CODE VARCHAR2 30 Indicator of how this expense line is split. A null value indicates that the line is not split. Active
TAX_CLASSIFICATION_CODE VARCHAR2 30 Tax code applicable to the expense item. Active
AWT_GROUP_ID NUMBER 18 Alternate tax withholding group identifier. Active
AUDIT_ADJUSTMENT_REASON_CODE VARCHAR2 30 Reason code for reimbursable amount to the individual during audit. Active
AUDIT_ADJUSTMENT_REASON VARCHAR2 240 Reason for adjusting the reimbursable amount to the individual during audit. Active
POLICY_VIOLATED_FLAG VARCHAR2 1 Indicator of whether the expense violated company policies. Active
POLICY_SHORTPAY_FLAG VARCHAR2 1 Indicator of whether the expense is short paid due to policy noncompliance. Active
RECEIPT_VERIFIED_FLAG VARCHAR2 1 Indicator of whether the auditor verified the receipt for this expense. Active
RECEIPT_REQUIRED_FLAG VARCHAR2 1 Indicator of whether this expense requires a receipt. Active
RECEIPT_MISSING_FLAG VARCHAR2 1 Indicator of whether the receipts are missing for this expense. Active
DAILY_LIMIT_POLICY_LINE_ID NUMBER 18 Identifier of the daily limit policy associated to the row.
JUSTIFICATION_REQUIRED_FLAG VARCHAR2 1 Indicator of whether the expense requires justification. Active
ITINERARY_RESERVATION_ID NUMBER 18 Travel reservation for which expense was created.
ATTRIBUTE_CATEGORY VARCHAR2 150 Descriptive Flexfield: structure definition of the user descriptive flexfield. Expenses (EXM_EXPENSES) Active
ATTRIBUTE_CHAR1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Expenses (EXM_EXPENSES) Active
ATTRIBUTE_CHAR2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Expenses (EXM_EXPENSES) Active
ATTRIBUTE_CHAR3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Expenses (EXM_EXPENSES) Active
ATTRIBUTE_CHAR4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Expenses (EXM_EXPENSES) Active
ATTRIBUTE_CHAR5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Expenses (EXM_EXPENSES) Active
ATTRIBUTE_CHAR6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Expenses (EXM_EXPENSES) Active
ATTRIBUTE_CHAR7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Expenses (EXM_EXPENSES) Active
ATTRIBUTE_CHAR8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Expenses (EXM_EXPENSES) Active
ATTRIBUTE_CHAR9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Expenses (EXM_EXPENSES) Active
ATTRIBUTE_CHAR10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Expenses (EXM_EXPENSES) Active
ATTRIBUTE_CHAR11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Expenses (EXM_EXPENSES) Active
ATTRIBUTE_CHAR12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Expenses (EXM_EXPENSES) Active
ATTRIBUTE_CHAR13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Expenses (EXM_EXPENSES) Active
ATTRIBUTE_CHAR14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Expenses (EXM_EXPENSES) Active
ATTRIBUTE_CHAR15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Expenses (EXM_EXPENSES) Active
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_DATETIME1 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATETIME2 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row. Active
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. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
RECEIPT_TIME TIMESTAMP Date and time of the transaction. This helps to differentiate transactions made on same day by their accounting time. Active
EXPENSE_CATEGORY_CODE VARCHAR2 30 Classification of an expense item such as business or personal. Active
LOCATION VARCHAR2 80 Location where the expense was incurred. Active
REIMBURSEMENT_CURRENCY_CODE VARCHAR2 15 Currency of the amount to be reimbursed to the individual for expenses incurred. Active
INACTIVE_EMP_PROCESS_ID NUMBER 18 Request identifier of the job that processes the expenses of inactive employees. Applicable only if the expense is processed after the employee is terminated.
PREPARER_ID NUMBER 18 Identifier of the person who created the expense.
CHECKOUT_DATE DATE Date when a person departs a place associated with an accommodation expense category.
CC_PREPAID_REQUEST_ID NUMBER 18 Request identifier of the job that processes a corporate card transaction for reimbursement to corporate card issuer. Applicable only when payment liability is company pay.
EMP_DEFAULT_COST_CENTER VARCHAR2 100 Default cost center assigned to an individual.
ORIG_RECEIPT_AMOUNT NUMBER Original amount of the receipt for this expense.
ORIG_EXPENSE_TYPE_ID NUMBER 18 Expense type of this expense before it was changed.
ORIG_EXCHANGE_RATE NUMBER Exchange rate of the expense before it was changed.
IMG_RECEIPT_REQUIRED_FLAG VARCHAR2 1 Indicator of whether this expense requires an imaged receipt.
PERSONAL_RECEIPT_AMOUNT NUMBER Amount of the expense that is marked as personal.
PERSONAL_AMT_PAID_FLAG VARCHAR2 1 Indicates whether the personal amount is paid by the user.
RECEIPT_MISSING_DEC_REQ_FLAG VARCHAR2 1 Indicator of whether an expense item with missing receipts is required to submit missing receipts declaration.
MOBILE_EXPENSE_FLAG VARCHAR2 1 Indicator of whether the expense item was created from a mobile device.
MASKED_CC_NUMBER VARCHAR2 30 Masked corporate card number that is obtained by scanning a transaction receipt for a cash expense.
ZONE_CODE VARCHAR2 30 Zone code of a zone type that is referred by this expense.
START_ODOMETER NUMBER Mileage Start Odometer reading.
END_ODOMETER NUMBER Mileage End Odometer reading.
AGENCY_NAME VARCHAR2 80 Name of agency where car rental expense incurred.
PASSENGER_NAME VARCHAR2 240 Name of airline flight passenger.
FLIGHT_DURATION NUMBER Airline flight duration in hours.
EXPENSE_CREATION_METHOD_CODE VARCHAR2 30 Method of expense item creation, such as mobile iOS device or mobile Android device.
ACCOM_TYPE_CODE VARCHAR2 30 Type of accommodation used during a trip.
LONG_TERM_TRIP_FLAG VARCHAR2 1 Indicates if trip is a long term trip.
LONG_TERM_TRIP_START_DATE DATE Date when long term trip started.
MULTI_DESTINATION_FLAG VARCHAR2 1 Indicates if trip contains multiple destinations.
PREPAID_FLAG VARCHAR2 1 Indicates whether the expense is prepaid.
TRAVEL_METHOD_CODE VARCHAR2 30 Method of travel used during a trip.
POLICY_WARNING_FLAG VARCHAR2 1 Indicates whether the expense item is marked with a warning.
POLICY_WARNING_REASON_CODE VARCHAR2 30 Reason code for a warning that an expense auditor applies to an expense item. Values are from the lookup ORA_EXM_WARNING_REASON.
SPEND_AUTH_LINE_ID NUMBER 18 Spend authorization expense line identifier.
AUTH_TRXN_NUMBER VARCHAR2 240 The credit card transaction authorization code. The value is obtained from the credit card charge.
DEDUCT_COMMUTE_DISTANCE_FLAG VARCHAR2 1 Indicates whether commute distance is deducted when calculating trip distance.
DEDUCT_ROUND_TRIP_FLAG VARCHAR2 1 Indicates whether round trip commute distance is deducted when calculating trip distance.
COMMUTE_DISTANCE NUMBER Commute distance during business trip for which mileage reimbursement is requested.
CALCULATED_TRIP_DISTANCE_FLAG VARCHAR2 1 Indicates whether trip distance is calculated by Google Maps.
SPLIT_ALLOCATION_SET_ID NUMBER 18 Specific split allocation set identifier.
AUTO_SUBMIT_DATE TIMESTAMP Date on which the expense is added to a report and submitted by the Automatically Submit Expense Reports process. A null value indicates that the expense is not yet ready to be picked up by the process.
TAX_PRODUCT_CATEGORY_CODE VARCHAR2 240 Tax product category assigned to expense item to determine the recoverable tax for an expense.
CC_AUTHORIZATION_IDENTIFIER VARCHAR2 240 Unique identifier that maps authorization requests to credit card transactions in the transaction files when the files are uploaded to Expenses. The identifier links the original authorization data to all related transactions, such as reversals, adjustments, confirmations and chargebacks.
GEOCODE_FROM VARCHAR2 60 Latitude and longitude values of the starting location for mileage expenses in JSON format.
GEOCODE_TO VARCHAR2 60 Latitude and longitude values of the destination for mileage expenses in JSON format.
YEARLY_LIMIT_POLICY_LINE_ID NUMBER 18 Unique identifier of the yearly limit policy line.
DAILY_LIMIT_ATTEND_POLICY_ID NUMBER 18 Unique identifier of the daily limit attendee policy line.
YEARLY_LIMIT_ATTEND_POLICY_ID NUMBER 18 Unique identifier of the yearly limit attendee policy line.
AUTO_PERSONAL_FLAG VARCHAR2 1 An indicator of whether an expense is automatically categorized as personal based on the derived expense type.
CC_NETWORK_REFERENCE_NUMBER VARCHAR2 240 Unique identifier generated by the payment network for each corporate card authorization request.
CC_MERCHANT_CATEGORY_CODE VARCHAR2 30 Code assigned to the merchant by the credit card company to classify the type of business.
APPROVAL_STATUS_CODE VARCHAR2 30 Indicates the automatic approval status of the expense.
VENDOR_EXPENSE_REFERENCE_ID NUMBER Unique identifier of an expense used for grouping similar expenses.

Foreign Keys

Table Foreign Table Foreign Key Column
EXM_EXPENSES exm_expense_reports EXPENSE_REPORT_ID
EXM_EXPENSES ap_awt_groups AWT_GROUP_ID
EXM_EXPENSES exm_credit_card_trxns CREDIT_CARD_TRXN_ID
EXM_EXPENSES exm_expense_templates EXPENSE_TEMPLATE_ID
EXM_EXPENSES exm_expense_types EXPENSE_TYPE_ID
EXM_EXPENSES exm_expenses ITEMIZATION_PARENT_EXPENSE_ID
EXM_EXPENSES per_persons PERSON_ID
EXM_EXPENSES exm_card_usage CARD_USAGE_ID
exm_cc_auth_trxns exm_expenses EXPENSE_ID
exm_expense_risk_indicators exm_expenses EXPENSE_ID
exm_expense_dists exm_expenses EXPENSE_ID
exm_recurring_schedules exm_expenses RECURRING_EXPENSE_ID
exm_expense_perdiem_dests exm_expenses EXPENSE_ID
exm_expense_perdiem_details exm_expenses EXPENSE_ID
exm_expense_violations exm_expenses EXPENSE_ID

Indexes

Index Uniqueness Tablespace Columns Status
EXM_EXPENSES_N1 Non Unique FUSION_TS_TX_IDX EXPENSE_REPORT_ID Obsolete
EXM_EXPENSES_N10 Non Unique Default PERSON_ID
EXM_EXPENSES_N2 Non Unique FUSION_TS_TX_IDX UPPER("DESCRIPTION") Active
EXM_EXPENSES_N3 Non Unique Default ITEMIZATION_PARENT_EXPENSE_ID
EXM_EXPENSES_N4 Non Unique Default ORG_ID, ASSIGNMENT_ID, PERSON_ID
EXM_EXPENSES_N5 Non Unique Default LAST_UPDATE_DATE
EXM_EXPENSES_N6 Non Unique Default EXPENSE_REPORT_ID, EXPENSE_TEMPLATE_ID
EXM_EXPENSES_N7 Non Unique Default CARD_ID
EXM_EXPENSES_N8 Non Unique Default CC_PREPAID_REQUEST_ID, CC_PREPAID_INVOICE_ID
EXM_EXPENSES_N9 Non Unique Default CREDIT_CARD_TRXN_ID, EXPENSE_ID
EXM_EXPENSES_U1 Unique Default EXPENSE_ID