DW_FA_MC_DEPRN_PERIODS_D

This is the Dimension table for Fixed asset depreciation period details

Details

Module: Assets

Key Columns

LEDGER_ID, MC_FLAG, PERIOD_COUNTER, BOOK_TYPE_CODE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
BOOK_TYPE_CODE VARCHAR2 32 True Unique book identification name.
PERIOD_COUNTER NUMBER 38 0 True Identifier of the depreciation period.
LEDGER_ID NUMBER 38 0 True Identifier of the accounting ledger
MC_FLAG VARCHAR2 16 True Flag to indicate the source of data is MC or Regular dataset
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. Source record identifier. Value is derived from a combination of BOOK_TYPE_CODE and PERIOD_COUNTER.
PERIOD_NAME VARCHAR2 16 Asset book depreciation calendar period name.
PERIOD_NUM NUMBER 38 0 Period number of depreciation period in the fiscal year.
FISCAL_YEAR NUMBER 38 0 Name of the accounting fiscal year.
PERIOD_OPEN_DATE TIMESTAMP System date when the depreciation period is opened.
PERIOD_CLOSE_DATE TIMESTAMP System date when the depreciation period was closed.
CALENDAR_PERIOD_OPEN_DATE DATE Start date of the calendar period.
CALENDAR_PERIOD_CLOSE_DATE DATE End date of the calendar period.
DEPRN_RUN_FLAG VARCHAR2 16 Indicator used to determine whether depreciation has been run for a period.
PERIOD_OPEN_DATE_1 DATE System date when the depreciation period is opened.
PERIOD_CLOSE_DATE_1 DATE System date when the depreciation period was closed.