This table requires activation of Project Asset functional area. This table stores the capital assets which have been capitalized.
Module: Project Costing
PROJECT_ASSET_ID
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.