FM_COST_CONTOUR_COMPONENTS
This table stores the daily breakdown of planned and actual costs. Cost contour attributes such as cost category and expense type are stored in the FM_COST_CONTOURS table.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
FM_COST_CONTOURS |
FM_COST_CONTOUR_ID |
FM_COST_CONTOUR_ID |
KNTA_USERS |
USER_ID |
CREATED_BY |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
FM_COST_CONTOUR_COMPONENT_ID |
NOT NULL |
NUMBER |
System-generated identifier |
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 |
VERSION |
NOT NULL |
NUMBER |
System-generated |
ACTUAL_VALUE_BSE |
NULLABLE |
NUMBER |
Actual cost in base currency |
ACTUAL_VALUE_LCL |
NULLABLE |
NUMBER |
Actual cost in local currency |
PLAN_VALUE_BSE |
NULLABLE |
NUMBER |
Planned costs in base currency |
PLAN_VALUE_LCL |
NULLABLE |
NUMBER |
Planned costs in local currency |
FM_COST_CONTOUR_ID |
NULLABLE |
NUMBER |
Cost contour to which this component belongs |
START_TIME |
NOT NULL |
DATE |
Start time of day |
FINISH_TIME |
NOT NULL |
DATE |
Finish time of day |
COMPONENT_SEQ |
NULLABLE |
NUMBER |
Chronological sequence of components that belong to the same contour. |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
FM_COST_CONTOUR_COMPONENT_PK |
UNIQUE |
1 |
FM_COST_CONTOUR_COMPONENT_ID |
FM_COST_CONTOUR_ID_IDX |
NONUNIQUE |
1 |
FM_COST_CONTOUR_ID |
Sequences
This table uses no sequences.