DW_PROJECT_ASSET_CPTLZD_D (Preview)

This table requires activation of Project Asset functional area. This table stores the capital assets which have been capitalized.

Details

Module: Project Costing

Key Columns

PROJECT_ASSET_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PROJECT_ASSET_ID NUMBER 38 0 True Unique identifier for the Asset.
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. System generated Unique Identifier.
PROJECT_ID NUMBER 38 0 The identifier of the project to which this asset belongs
ASSET_NUMBER VARCHAR2 32 Unique asset identifier. It can be user-entered or system-generated by Oracle Assets.
ASSET_NAME VARCHAR2 256 User-defined name that uniquely identifies an asset within a project.
ASSET_DESCRIPTION VARCHAR2 128 Description for Asset.
LOCATION_ID NUMBER 38 0 The identifier of the location to which the asset is assigned
ASSIGNED_TO_PERSON_ID NUMBER 38 0 The identifier of the employee to whom the asset is assigned
ASSET_CATEGORY_ID NUMBER 38 0 The identifier of the asset category to which the asset is assigned
ASSET_KEY_CCID NUMBER 38 0 Key flexfield code combination identifier for asset key flexfield
CAPITAL_EVENT_ID NUMBER 38 0 Capital Event Identifier
PARENT_ASSET_ID NUMBER 38 0 Parent Asset Identifier
FA_ASSET_ID NUMBER 38 0 FA Asset identifier for Tieback purposes.
BOOK_TYPE_CODE VARCHAR2 32 The corporate book to which the asset is assigned
DEPRECIATION_EXPENSE_CCID NUMBER 38 0 The identifier of the depreciation expense account for the asset
AMORTIZE_FLAG VARCHAR2 16 Indicates whether or not cost adjustments should be amortized in Oracle Assets
CAPITALIZED_FLAG VARCHAR2 16 Indicates whether or not the asset has been interfaced to Oracle Assets
CAPITAL_HOLD_FLAG VARCHAR2 16 Flag to prevent generation of new asset lines.
DEPRECIATE_FLAG VARCHAR2 16 Indicates whether or not the asset should be depreciated in Oracle Assets
REVERSE_FLAG VARCHAR2 16 Indicates whether the asset will be reversed in the next Generate Asset Lines run
CAPITALIZED_DATE DATE The last date non-reversing cost adjustments were interfaced to Oracle Assets
DATE_PLACED_IN_SERVICE DATE Date placed in service of the asset
ESTIMATED_IN_SERVICE_DATE DATE The asset's estimated date placed in service
REVERSAL_DATE DATE The last date reversing asset lines were created.
ESTIMATED_COST NUMBER Estimated Asset Cost
ESTIMATED_ASSET_UNITS NUMBER Estimated Asset Units
PM_PRODUCT_CODE VARCHAR2 32 The identifier of the external project management system from which the project was imported.
PM_ASSET_REFERENCE VARCHAR2 256 The identifier of the project in the external project management system from which the project was imported.
MANUFACTURER_NAME VARCHAR2 32 Name of the Asset Manufacturer
MODEL_NUMBER VARCHAR2 64 Model Number of the Asset
TAG_NUMBER VARCHAR2 16 Tag Number of the Asset
SERIAL_NUMBER VARCHAR2 64 Serial Number of the Asset
PROJECT_ASSET_TYPE VARCHAR2 32 Project Asset Classification. Default value is ESTIMATED.
ASSET_UNITS NUMBER Actual Units
LAST_UPDATE_DATE TIMESTAMP Asset Last Updated Date
CREATION_DATE TIMESTAMP Asset Creation Date