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