DW_PROJECT_ASSET_D (Preview)

This table requires activation of Project Asset functional area. This view stores all the capital assets.

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     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    

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