This is the Dimension table for Fixed asset books details
Module: Assets
LEDGER_ID, MC_FLAG, ASSET_ID, BOOK_TYPE_CODE, TRANSACTION_HEADER_ID_IN
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
BOOK_TYPE_CODE | VARCHAR2 | 32 | True | Unique book identification name. | |||
ASSET_ID | NUMBER | 38 | 0 | True | Identifier of the asset number. | ||
TRANSACTION_HEADER_ID_IN | NUMBER | 38 | 0 | True | Identifier of the transaction that created the row. | ||
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 Fixed Asset book identifier. | ||||
TRANSACTION_HEADER_ID_OUT | NUMBER | 38 | 0 | Identifier of the transaction that terminated the row. | |||
DATE_EFFECTIVE | TIMESTAMP | Date when the row became effective. | |||||
DATE_INEFFECTIVE | TIMESTAMP | Date when the row became inactive. | |||||
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. | ||||
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. | |||||
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. | |||
CASH_GENERATING_UNIT_ID | NUMBER | 38 | 0 | Identifier of the cash generating unit. | |||
CEILING_TYPE_ID | NUMBER | 38 | 0 | Identifier of the depreciation ceiling. | |||
GROUP_ASSET_ID | NUMBER | 38 | 0 | Identification number of the group asset. | |||
CONVENTION_TYPE_ID | NUMBER | 38 | 0 | Identifier of the prorate convention | |||
METHOD_ID | NUMBER | 38 | 0 | Identifier of the depreciation method. | |||
COST | NUMBER | Total recorded cost of the asset. | |||||
ORIGINAL_COST | NUMBER | Original cost of the asset at the time of its addition. | |||||
RECOVERABLE_COST | NUMBER | Cost minus salvage value, or depreciation ceiling, whichever is lower. | |||||
SALVAGE_VALUE | NUMBER | Salvage value amount for the asset. | |||||
ADJUSTED_RECOVERABLE_COST | NUMBER | Adjusted recoverable cost with special depreciation limits taken into account. | |||||
LEDGER_CURRENCY_CODE | VARCHAR2 | 16 | Functional currency of the ledger | ||||
CREATION_DATE | TIMESTAMP | Creation Date |
Copyright © 2019, 2024, Oracle and/or its affiliates.