Share this page
FM_FORECAST_ACTUAL_LINES
This table stores and references all data related to forecast actual lines for a given forecast actual.
Foreign Keys
|
Primary Key Table |
Primary Key Column |
Foreign Key Column |
|---|---|---|
|
FM_FORECAST_ACTUALS |
FORECAST_ACTUAL_ID |
FORECAST_ACTUAL_ID |
|
KNTA_LOOKUPS_NLS |
LOOKUP_CODE |
LABOR_TYPE_CODE |
|
KNTA_USERS |
USER_ID |
CREATED_BY |
|
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
|
FM_USER_DATA |
USER_DATA_ID |
USER_DATA_ID |
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
FORECAST_ACTUAL_LINE_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 unique version number. Do not update manually. |
|
LABOR_TYPE_CODE |
NOT NULL |
VARCHAR2(30) |
Code for the labor type of the line. Values: LABOR, NON_LABOR. Referred to from the knta_lookups table. |
|
CATEGORY_CODE |
NOT NULL |
VARCHAR2(40) |
Code for the category of the line. For example, EMPLOYEE, CONTRACTOR, TRAINING, HARDWARE. Referred to from the knta_lookups table. |
|
EXPENSE_TYPE_CODE |
NULLABLE |
VARCHAR2(30) |
Expense type for the line. In case the financial summary is not capitalized, the lines for the forecast actual are all defaulted to operational type. Values: |
|
FORECAST_ACTUAL_ID |
NULLABLE |
NUMBER |
ID of forecast actual that the line belongs to |
|
SYNC_SOURCE_FLAG |
NULLABLE |
VARCHAR2(10) |
If the line is synchronized, describes the source. If the line is not a synchronized line, the value is "N". Listed in FSUtil.java, possible values are: "SP" - Staffing Profile, "P" - Project, "A" - Asset, "PR" - Proposal, "FSR" - Financial Summary Rollup. |
|
USER_DATA_ID |
NULLABLE |
NUMBER |
ID that refers to the User Data for the line, if any. Foreign key reference to FM_USER_DATA. |
Indexes
|
Index Name |
Index Type |
Sequence |
Column Name |
|---|---|---|---|
|
FM_FAL_FORECAST_ID_IDX |
NONUNIQUE |
1 |
FORECAST_ACTUAL_ID |
|
FM_FORECAST_ACTUAL_LINES_PK |
UNIQUE |
1 |
FORECAST_ACTUAL_LINE_ID |
Sequences
|
Sequence Name |
Sequence Type |
|---|---|
|
FM_FORECAST_ACTUAL_LINES_S |
FORECAST_ACTUAL_LINE_ID |
