This is the Fact table for Fixed asset unaccounted Depreciation details
Module: Assets
PERIOD_COUNTER, LEDGER_ID, DISTRIBUTION_ID, ASSET_ID, BOOK_TYPE_CODE, DEPRN_RUN_ID
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 |
Copyright © 2019, 2024, Oracle and/or its affiliates.