EXM_RCPT_NOTIF_RULE

Details

Schema: FUSION
Object owner: EXM
Object type: TABLE
Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
EXM_RCPT_NOTIF_RULE_SETS_PK	RCPT_NOTIF_RULE_SET_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
RCPT_NOTIF_RULE_SET_ID	NUMBER		18	Yes	Unique identifier of the rule set that specifies the receipt requirements, overdue processing rules, and payment hold rules.
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.
NAME	VARCHAR2	60		Yes	Name of the receipt and notification rule set.
DESCRIPTION	VARCHAR2	240			Description of the receipt and notification rule set.
RECEIPT_REQUIRED_CODE	VARCHAR2	30			Type of receipt required, such as Original, Imaged, or Both.
IMG_RECEIPT_DUE_CODE	VARCHAR2	30			Stage when imaged receipts must be attached to an expense report requiring imaged receipts.
RECEIPT_DUE_DAYS	NUMBER				Number of days the application waits for required imaged receipts before returning the expense report to the preparer.
DEFAULT_RCPT_CHECKIN_DATE_CODE	VARCHAR2	30			Original receipt package check-in date option. Values are from the lookup ORA_EXM_DEFAULT_REC_PAC_DT.
OVERDUE_PROCESS_FLAG	VARCHAR2	1			Indicator of whether overdue and missing receipt processing rules are enabled in this rule set.
RECEIPT_OVERDUE_DAYS	NUMBER				Maximum number of days the application waits before receipts are considered overdue.
NOTIF_FILER_OVERDUE_FLAG	VARCHAR2	1			Indicator of whether individuals are notified when receipts are overdue.
NEXT_OVERDUE_NOTIF_DAYS	NUMBER				Number of days the application waits to send the next overdue notification.
OVERDUE_NOTIF_LIMIT	NUMBER				Maximum number of overdue notifications sent to the individual before the expense report is returned.
RCPT_RECEIVED_NOTIF_CODE	VARCHAR2	30			Indicator of whether individuals are notified when receipts are received.
RECPT_MISSING_DECL_REQ_FLAG	VARCHAR2	1			Indicator of whether a missing receipt declaration is required due to missing original receipts.
HOLD_PROCESS_FLAG	VARCHAR2	1			Indicator of whether expense report payment hold rules are enabled in this rule set.
HOLD_CODE	VARCHAR2	30			Payment hold rule that specifies when an expense report is placed on hold, such as when receipt is required and when receipt is overdue.
HOLD_REPORT_CODE	VARCHAR2	30			Type of expense reports placed on payment hold due to overdue receipts.
EMP_PAYMENT_HOLD_CODE	VARCHAR2	30			Indicator of whether expense report of an employee is placed on payment hold.
CC_PAYMENT_HOLD_CODE	VARCHAR2	30			Indicator of whether expense report of corporate card issuer expense report is placed on payment hold.
HOLD_PROJECT_ONLY_FLAG	VARCHAR2	1			Indicator of whether payment hold rules are applied to expense reports where all expense lines are project-related.
NEXT_SHORT_PAY_NOTIF_DAYS	NUMBER				Number of days the application waits to send the next short pay notification.
SHORT_PAY_NOTIF_LIMIT	NUMBER				Maximum number of short pay notifications sent to the individual before the expense report is returned.
REQ_MORE_INFO_RESP_DAYS	NUMBER				Maximum number of days in which the application expects a response for a notification requesting more information.
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_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated 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.

Indexes

Index	Uniqueness	Tablespace	Columns
EXM_RCPT_NOTIF_RULE_SETS_PK	Unique	FUSION_TS_TX_DATA	RCPT_NOTIF_RULE_SET_ID
EXM_RCPT_NOTIF_RULE_SETS_U1	Unique	FUSION_TS_TX_DATA	NAME