EXM_EXPENSE_TEMPLATES

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")