EXM_EXPENSE_TYPES

This table contains the expense types defined for an expense report template and the associated corporate policies.

Details

  • Schema: FUSION

  • Object owner: EXM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

EXM_EXPENSE_TYPES_PK

EXPENSE_TYPE_ID

Columns

Name Datatype Length Precision Not-null Comments
EXPENSE_TYPE_ID NUMBER 18 Yes Unique identifier of an expense type in an expense template.
ORG_ID NUMBER 18 Indicates the identifier of the business unit associated to the row.
EXPENSE_TEMPLATE_ID NUMBER 18 Yes Identifier of the expense template that contains the expense type.
NAME VARCHAR2 80 Yes Name of the expense type as appears in the expense report.
DESCRIPTION VARCHAR2 240 Description of the expense type.
START_DATE DATE Yes Date from which the expense template is available for use in expense reports.
END_DATE DATE Date from which the expense template can no longer be used.
CATEGORY_CODE VARCHAR2 30 Expense category assigned to the expense item.
TAX_CLASSIFICATION_CODE VARCHAR2 30 Default tax code assigned to the expense item.
RECEIPT_REQUIRED_FLAG VARCHAR2 1 Indicator of whether receipts are required for cash expense lines above a specified amount.
RECEIPT_THRESHOLD NUMBER Amount limit, above which a cash expense requires receipt.
CC_RECEIPT_REQUIRED_FLAG VARCHAR2 1 Indicator of whether receipts are required for corporate card expense lines above a specified limit.
CC_RECEIPT_THRESHOLD NUMBER Amount limit, above which a corporate card expense requires receipt.
NEGATIVE_RCPT_REQ_CODE VARCHAR2 30 Receipt requirement rules are applied to negative expense lines.
RCPT_REQUIRED_PROJ_FLAG VARCHAR2 1 Indicator of whether a receipt is required for this project-enabled expense type.
DISP_RCPT_VIOLATION_FLAG VARCHAR2 1 Indicator of whether a receipt missing policy warning is displayed to the user.
ITEMIZATION_BEHAVIOUR_CODE VARCHAR2 15 Indicator of whether itemization is disabled, enabled, or required for this expense type.
ITEMIZATION_ONLY_FLAG VARCHAR2 1 Indicator of whether this expense type is used only in itemization.
DEFAULT_PROJ_EXPEND_TYPE NUMBER 18 Project expenditure type that is assigned to an expense type that has not been set up at the project level.
ENABLE_PROJECTS_FLAG VARCHAR2 1 Indicator of whether the expense type can be used to charge project expenses.
PREPAID_FLAG VARCHAR2 1 Indicates whether prepayment is allowed for the expense type.
CODE_COMBINATION_ID NUMBER 18 Identifier of the general ledger account that accounts for this expense type.
SEGMENT1 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
SEGMENT2 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
SEGMENT3 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
SEGMENT4 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
SEGMENT5 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
SEGMENT6 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
SEGMENT7 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
SEGMENT8 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
SEGMENT9 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
SEGMENT10 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
SEGMENT11 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
SEGMENT12 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
SEGMENT13 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
SEGMENT14 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
SEGMENT15 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
SEGMENT16 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
SEGMENT17 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
SEGMENT18 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
SEGMENT19 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
SEGMENT20 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
SEGMENT21 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
SEGMENT22 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
SEGMENT23 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
SEGMENT24 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
SEGMENT25 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
SEGMENT26 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
SEGMENT27 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
SEGMENT28 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
SEGMENT29 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
SEGMENT30 VARCHAR2 25 Key Flexfield: segment of the key flexfield.
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.
DESCRIPTION_BEHAVIOUR_CODE VARCHAR2 30 Behavior of the expense item Description field, which is defined at the expense type level.
LOCATION_BEHAVIOUR_CODE VARCHAR2 30 Behavior of the Expense Location field, which is defined at the expense type level.
NUM_OF_DAYS_BEHAVIOUR_CODE VARCHAR2 30 Behavior of the Number of Days field, which is defined at the expense type level.
MERCHANT_BEHAVIOUR_CODE VARCHAR2 30 Behavior of the Merchant field, which is defined at the expense type level.
TAX_PRODUCT_CATEGORY_CODE VARCHAR2 240 Tax product category assigned to expense type to determine the recoverable tax for an expense.

Foreign Keys

Table Foreign Table Foreign Key Column
EXM_EXPENSE_TYPES exm_expense_templates EXPENSE_TEMPLATE_ID
EXM_EXPENSE_TYPES pjf_exp_types_b DEFAULT_PROJ_EXPEND_TYPE
exm_project_exp_type_maps exm_expense_types EXPENSE_TYPE_ID
exm_expenses exm_expense_types EXPENSE_TYPE_ID
exm_spend_auth_lines exm_expense_types EXPENSE_TYPE_ID
exm_card_exp_type_maps exm_expense_types EXPENSE_TYPE_ID
exm_expense_type_itemize exm_expense_types EXPENSE_TYPE_ID
exm_expense_type_itemize exm_expense_types EXPENSE_TYPE_PARENT_ID

Indexes

Index Uniqueness Tablespace Columns
EXM_EXPENSE_TYPES_N1 Non Unique Default LAST_UPDATE_DATE
EXM_EXPENSE_TYPES_N2 Non Unique Default NAME
EXM_EXPENSE_TYPES_PK Unique Default EXPENSE_TYPE_ID
EXM_EXPENSE_TYPES_U1 Unique Default EXPENSE_TEMPLATE_ID, EXPENSE_TYPE_ID
EXM_EXPENSE_TYPES_U2 Unique Default EXPENSE_TEMPLATE_ID, UPPER("NAME")