EXM_EXPENSE_TEMPLATES

This table contains sets of expense types grouped for specific purposes by business unit, such as Education, Travel, and Relocation.

Details

  • Schema: FUSION

  • Object owner: EXM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

EXM_EXPENSE_TEMPLATES_PK

EXPENSE_TEMPLATE_ID

Columns

Name Datatype Length Precision Not-null Comments
EXPENSE_TEMPLATE_ID NUMBER 18 Yes Unique identifier of an expense report template.
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row.
NAME VARCHAR2 80 Yes Name of the expense report template.
DESCRIPTION VARCHAR2 240 Description of the expense report template.
START_DATE DATE Yes Date from which the expense type is available for use in expense reports.
INACTIVE_DATE DATE Date from which the expense type can no longer be used.
DFLT_CC_EXP_TYPE_ID NUMBER 18 Expense type assigned to a credit card transaction if an expense type mapping has not been defined.
ENABLE_CC_MAPPING_FLAG VARCHAR2 1 Indicator of whether the lookup codes from the charge file are associated with the company's expense types.
CASH_RECEIPT_REQ_FLAG VARCHAR2 1 Indicator of whether receipts are required for cash expense lines above a specified amount.
CASH_RECEIPT_REQ_LIMIT NUMBER Amount limit, above which a cash expense requires receipt.
CC_RECEIPT_REQ_FLAG VARCHAR2 1 Indicator of whether receipts are required for corporate card expense lines above a specified limit.
CC_RECEIPT_REQ_LIMIT NUMBER Amount limit, above which a corporate card expense requires receipt.
NEGATIVE_RCPT_REQ_FLAG VARCHAR2 1 Indicator of whether receipt requirement rules are applied to negative expense lines.
ALLOW_RCPT_MISSING_FLAG VARCHAR2 1 Indicator of whether individuals can indicate that receipts are missing when they submit their expense report.
DISP_RCPT_VIOLATION_FLAG VARCHAR2 1 Indicator of whether a receipt missing policy warning is displayed to the user.
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.

Foreign Keys

Table Foreign Table Foreign Key Column
exm_expenses exm_expense_templates EXPENSE_TEMPLATE_ID
exm_preferences exm_expense_templates EXPENSE_TEMPLATE_ID
exm_spend_auth_lines exm_expense_templates EXPENSE_TEMPLATE_ID
exm_card_exp_type_maps exm_expense_templates EXPENSE_TEMPLATE_ID
exm_expense_types exm_expense_templates EXPENSE_TEMPLATE_ID

Indexes

Index Uniqueness Tablespace Columns Status
EXM_EXPENSE_TEMPLATES_N1 Non Unique Default ORG_ID Obsolete
EXM_EXPENSE_TEMPLATES_N2 Non Unique Default DESCRIPTION
EXM_EXPENSE_TEMPLATES_N3 Non Unique Default START_DATE
EXM_EXPENSE_TEMPLATES_N4 Non Unique Default INACTIVE_DATE
EXM_EXPENSE_TEMPLATES_N5 Non Unique Default UPPER("NAME")
EXM_EXPENSE_TEMPLATES_N6 Non Unique Default UPPER("DESCRIPTION")
EXM_EXPENSE_TEMPLATES_PK Unique Default EXPENSE_TEMPLATE_ID
EXM_EXPENSE_TEMPLATES_U1 Unique Default ORG_ID, UPPER("NAME")