FM_COST_RULES

This table stores the cost rules used to assign costs to various units of work, such as the time spent working on a project task. The applicability of a cost rule to a given transaction is determined by its cost factors. A cost rule may have different rates for one or more independent time periods. Exactly one rule in the system is the default rule. The default rule may not be deleted and its set of cost factor values may not be altered.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
KNTA_USERS	USER_ID	CREATED_BY
KNTA_USERS	USER_ID	LAST_UPDATED_BY

Column Descriptions

Column Name	Null?	Data Type	Description
COST_RULE_ID	NOT NULL	NUMBER	System-generated identifier
VERSION	NOT NULL	NUMBER	System-generated version for the entity. This column must not be updated manually.
RULE_NUMBER	NOT NULL	NUMBER	Indicates the rule number (this is not the same as COST_RULE_ID)
IS_DEFAULT_RULE_FLAG	NOT NULL	VARCHAR2(1)	Default rule. Exactly one rule in the system is the default rule. The default rule must not be deleted and its set of cost factor values must not be altered.
CREATED_BY	NOT NULL	NUMBER	Identifier for the user who created the record
CREATION_DATE	NOT NULL	DATE	Date record was created
LAST_UPDATED_BY	NOT NULL	NUMBER	Identifier for the user who last updated the record
LAST_UPDATE_DATE	NOT NULL	DATE	Date record was last updated

Indexes

Index Name	Index Type	Sequence	Column Name
SYS_C005200076	UNIQUE	1	RULE_NUMBER
SYS_C005201520	UNIQUE	1	COST_RULE_ID

Sequences

Sequence Name	Sequence Type
FM_COST_RULES_S	COST_RULE_ID