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 |