Share this page

# 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

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: