FM_FINANCIAL_LINE_CELLS

This table stores financial line cells.

Foreign Keys

xref href="

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

LAST_UPDATED_BY

PPM_FISCAL_PERIODS_NLS

FISCAL_PERIOD_ID

PERIOD_ID

KNTA_USERS

USER_ID

CREATED_BY

Column Descriptions

xref href="

Column Name

Null?

Data Type

Description

FINANCIAL_LINE_CELL_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, used for hibernate version control

ACTUAL_VALUE_BSE

NULLABLE

NUMBER

Actual value in base currency

ACTUAL_VALUE_LCL

NULLABLE

NUMBER

Actual value in local currency

PLAN_VALUE_BSE

NULLABLE

NUMBER

Planned value in base currency

PLAN_VALUE_LCL

NULLABLE

NUMBER

Planned value in local currency

PARENT_TYPE_CODE

NOT NULL

VARCHAR2(30)

Parent type code. Possible values are FORECAST, BENEFIT and SUPPLY_BUDGET.

PARENT_ID

NULLABLE

NUMBER

Identifier of parent. Based on parent type, this column could be FORECAST_ACTUAL_LINE_ID in FM_FORECAST_ACTUAL_LINES, BENEFIT_ID in FM_BENEFITS or SUPPLY_BUDGET_ID in FM_SUPPLY_BUDGETS.

FISCAL_PERIOD_ID

NOT NULL

NUMBER

Identifier for fiscal period

Indexes

xref href="

Index Name

Index Type

Sequence

Column Name

FM_FINANCIAL_LINE_CELL_PK

UNIQUE

1

FINANCIAL_LINE_CELL_ID

FM_FLC_CELL_PARENT_ID_TYPE_IDX

NONUNIQUE

1

PARENT_TYPE_CODE

FM_FLC_CELL_PARENT_ID_TYPE_IDX

NONUNIQUE

2

PARENT_ID

Sequences

xref href="

Sequence Name

Sequence Type

FM_FINANCIAL_LINE_CELLS_S

FINANCIAL_LINE_CELL_ID