DW_FA_MC_DEPRN_PERIODS_D

This is the Dimension table for Fixed asset depreciation period details

Details

Module: Assets

Key Columns

BOOK_TYPE_CODE, LEDGER_ID, MC_FLAG, 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 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.    

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