DW_FA_MC_DEPRECIATION_CF

This is the Fact table for Fixed asset unaccounted Depreciation details

Details

Module: Assets

Key Columns

DEPRN_RUN_ID, DISTRIBUTION_ID, PERIOD_COUNTER, BOOK_TYPE_CODE, LEDGER_ID, ASSET_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
LEDGER_ID NUMBER 38 0 True Identifier of the accounting ledger
BOOK_TYPE_CODE VARCHAR2 32 True Unique book identification name.
ASSET_ID NUMBER 38 0 True Identifier of the asset number.
PERIOD_COUNTER NUMBER 38 0 True Identifier of the asset transaction.
DEPRN_RUN_ID NUMBER 38 0 True Identifier of the asset accounting line.
DISTRIBUTION_ID NUMBER 38 0 True Identifier of the asset distribution.
SOURCE_RECORD_ID VARCHAR2 256 This column is for Oracle Internal use only. Unique Identifier of the record.
MC_FLAG VARCHAR2 16 Internal column to identify the origin of row(from MC table or regular table)
ASSET_NUMBER VARCHAR2 32 User-defined asset identification number.
ASSET_DESCRIPTION VARCHAR2 128 Asset description
PARENT_ASSET_ID NUMBER 38 0 Identifier of the parent asset for the child or component asset.
GROUP_ASSET_ID NUMBER 38 0 Identification number of the group asset.
CATEGORY_ID NUMBER 38 0 Identifier of the asset category.
LOCATION_ID NUMBER 38 0 Location flexfield identification number.
ASSIGNED_TO_ID NUMBER 38 0 Identifier of the employee to whom the asset is assigned.
ASSET_KEY_CCID NUMBER 38 0 Asset Keyword identifier.
RETIREMENT_ID NUMBER 38 0 Identifier of the asset retirement transaction.
IMPAIRMENT_ID NUMBER 38 0 Identifier of the asset Impairment transaction.
METHOD_ID NUMBER 38 0 Identifier of the depreciation method.
CONVENTION_TYPE_ID NUMBER 38 0 Identifier of the prorate convention
CASH_GENERATING_UNIT_ID NUMBER 38 0 Identifier of the cash generating unit.
CEILING_TYPE_ID NUMBER 38 0 Identifier of the depreciation ceiling.
DATE_PLACED_IN_SERVICE DATE Date on which the asset was placed in service.
PRORATE_DATE DATE Date used to calculate the annual depreciation for assets.
CALENDAR_TYPE VARCHAR2 16 Name of the depreciation calendar.
PERIOD_NAME VARCHAR2 16 Asset book depreciation calendar period name.
PERIOD_COUNTER_CAPITALIZED NUMBER 38 0 Identifier of the depreciation period in which asset is capitalized.
PERIOD_COUNTER_FULLY_RESERVED NUMBER 38 0 Identifier of the depreciation period in which the asset was fully reserved.
PERIOD_COUNTER_FULLY_RETIRED NUMBER 38 0 Identifier of the depreciation period in which the asset was fully retired.
ACTIVE_ASSIGNMENT_FLAG VARCHAR2 16
ACTIVE_FINANCIAL_FLAG VARCHAR2 16
DEPRECIATE_FLAG VARCHAR2 16 Option indicating whether the asset is depreciating or not.
LOW_VALUE_ASSET_FLAG VARCHAR2 16 Indicates whether this line is a low value asset.
UNITS_ASSIGNED NUMBER Number of units assigned to the distribution.
TRANSACTION_UNITS NUMBER Number of units involved in the transaction. Negative value for the row from which the units were transferred away or retired. Positive value for the row to which the units were transferred to or added.
GLOBAL_CURRENCY_CODE VARCHAR2 16 Global currency code.
GLOBAL_CURRENCY_EXCH_RATE BIGDECIMAL 10 Global currency conversion rate.
TRANSACTION_CURRENCY_CODE VARCHAR2 16 Entered currency for the transaction data.
LEDGER_CURRENCY_CODE VARCHAR2 16 Functional currency of the ledger.
TRANSACTION_DEPRN_AMOUNT BIGDECIMAL 10
LEDGER_DEPRN_AMOUNT BIGDECIMAL 10
GLOBAL_DEPRN_AMOUNT BIGDECIMAL 10
FISCAL_PERIOD_SET_NAME VARCHAR2 16 Accounting calendar name.
FISCAL_PERIOD_TYPE VARCHAR2 16 Accounting period type.
LEGAL_ENTITY_ID NUMBER 38 0 Legal entity identifier. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
CODE_COMBINATION_ID NUMBER 38 0 GL account identifier.
COST_CENTER_SEGMENT VARCHAR2 32 Cost center segment.
COST_CENTER_VALUESET_CODE VARCHAR2 64 Cost center value set code.
GL_BALANCING_SEGMENT VARCHAR2 32 Balancing segment.
GL_BLNC_SGMNT_VALUESET_CODE VARCHAR2 64 Balancing segment value set code.
NATURAL_ACCOUNT_SEGMENT VARCHAR2 32 Natural account segment.
NTRL_ACNT_SGMNT_VALUESET_CODE VARCHAR2 64 Natural account value set code.
GL_SEGMENT1 VARCHAR2 32 Accounting segment 1.
GL_SEGMENT1_VALUESET_CODE VARCHAR2 64 Accounting segment 1 value set code.
GL_SEGMENT2 VARCHAR2 32 Accounting segment 2.
GL_SEGMENT2_VALUESET_CODE VARCHAR2 64 Accounting segment 2 value set code.
GL_SEGMENT3 VARCHAR2 32 Accounting segment 3.
GL_SEGMENT3_VALUESET_CODE VARCHAR2 64 Accounting segment 3 value set code.
GL_SEGMENT4 VARCHAR2 32 Accounting segment 4.
GL_SEGMENT4_VALUESET_CODE VARCHAR2 64 Accounting segment 4 value set code.
GL_SEGMENT5 VARCHAR2 32 Accounting segment 5.
GL_SEGMENT5_VALUESET_CODE VARCHAR2 64 Accounting segment 5 value set code.
GL_SEGMENT6 VARCHAR2 32 Accounting segment 6.
GL_SEGMENT6_VALUESET_CODE VARCHAR2 64 Accounting segment 6 value set code.
GL_SEGMENT7 VARCHAR2 32 Accounting segment 7.
GL_SEGMENT7_VALUESET_CODE VARCHAR2 64 Accounting segment 7 value set code.
GL_SEGMENT8 VARCHAR2 32 Accounting segment 8.
GL_SEGMENT8_VALUESET_CODE VARCHAR2 64 Accounting segment 8 value set code.
GL_SEGMENT9 VARCHAR2 32 Accounting segment 9.
GL_SEGMENT9_VALUESET_CODE VARCHAR2 64 Accounting segment 9 value set code.
GL_SEGMENT10 VARCHAR2 32 Accounting segment 10.
GL_SEGMENT10_VALUESET_CODE VARCHAR2 64 Accounting segment 10 value set code.
PERIOD_OPEN_DATE DATE Period open date.
CALENDAR_PERIOD_OPEN_DATE DATE Start date of the calendar period.
CREATION_DATE TIMESTAMP Creation Date