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

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