# DW_FA_MC_DEPRN_PERIODS_D

This is the Dimension table for Fixed asset depreciation period details

## Details

Module: Assets

## Key Columns

MC_FLAG, LEDGER_ID, BOOK_TYPE_CODE, PERIOD_COUNTER

## 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 | 256 |  |  | 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. |  |

Copyright © 2019, 2026, Oracle and/or its affiliates.