FM_FORECAST_ACTUALS
The table stores the data for the forecast actuals linked to a financial summary.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
KNTA_USERS |
USER_ID |
CREATED_BY |
FM_USER_DATA |
USER_DATA_ID |
USER_DATA_ID |
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
FORECAST_ACTUAL_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 version for the entity. This column must not be updated manually. |
SHOW_ACTUALS_FLAG |
NOT NULL |
VARCHAR2(1) |
Used for UI to show actuals when the screen loads. In PPM Center 8.00, used for the default state. After first load, settings are stored elsewhere. This is ported over from PPM Center 7.5 |
VIEW_BY_PERIOD_TYPE_ID |
NOT NULL |
NUMBER |
Used for UI to show the data by period type (month, quarter) when the screen loads up. In PPM Center 8.00, used for the default state. After first load, settings are stored elsewhere. This is ported over from PPM Center 7.5. YEAR(6, 1, "Y"), HALF_YEAR(7, 2, "HY"), QUARTER(5, 3, "Q"), MONTH(4, 4, "M"), WEEK(8, 5, "W"); in FiscalPeriodType. |
ACTUAL_ROLL_UP_CODE |
NOT NULL |
VARCHAR2(30) |
Indicates whether the actuals for the entity are entered manually by the user or are rolled up and so cannot be modified directly by the user. |
CAPEX_OPEX_ENABLED_FLAG |
NOT NULL |
VARCHAR2(1) |
Indicates whether the costs and actuals are tracked by capitalization. The setting is "Financial Summary tracks capitalized costs". |
USER_DATA_ID |
NULLABLE |
NUMBER |
References any user data at the Forecast Actual level, if any. Referenced by FM_USER_DATA |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
FM_FORECAST_ACTUALS_PK |
UNIQUE |
1 |
FORECAST_ACTUAL_ID |
Sequences
Sequence Name |
Sequence Type |
---|---|
FM_FORECAST_ACTUALS_S |
FORECAST_ACTUAL_ID |