FM_COST_FACTOR_VALS
This table stores values for different cost factors that are specified for each cost rule.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
FM_COST_FACTORS |
COST_FACTOR |
COST_FACTOR |
FM_COST_RULES |
COST_RULE_ID |
COST_RULE_ID |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
COST_RULE_ID |
NOT NULL |
NUMBER |
Indicates the cost rule ID from FM_COST_RULES. |
COST_FACTOR_VALUE |
NULLABLE |
VARCHAR2(255) |
Indicates the value for the cost factor indicated by the COST_FACTOR column |
COST_FACTOR |
NOT NULL |
NUMBER |
Indicates the cost factor from FM_COST_FACTORS |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
SYS_C005201517 |
UNIQUE |
1 |
COST_RULE_ID |
SYS_C005201517 |
UNIQUE |
2 |
COST_FACTOR |
Sequences
This table uses no sequences.