# DW_FA_ASSET_D

This is the FA dimension table for Fixed asset details

## Details

Module: Assets

## Key Columns

ASSET_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
ASSET_ID | NUMBER | 38 | 0 | True | Identifier of the asset number. |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. Source record identifier. Value is derived from a combination of Asset identifiers. |  |
ASSET_NUMBER | VARCHAR2 | 32 |  |  | User-defined asset identification number. |  |
DESCRIPTION | VARCHAR2 | 128 |  |  | Asset description |  |
ASSET_TYPE | VARCHAR2 | 16 |  |  | Type of the asset allowed in the Oracle Fusion Assets. The asset types allowed are Capitalized, Construction-in-Process, Expensed, and Group. |  |
TAG_NUMBER | VARCHAR2 | 16 |  |  | Unique user-defined tracking number for an asset. |  |
SERIAL_NUMBER | VARCHAR2 | 64 |  |  | Serial number assigned to the asset. |  |
IN_USE_FLAG | VARCHAR2 | 16 |  |  | Indicator used to determine whether the asset is in use. |  |
OWNED_LEASED | VARCHAR2 | 16 |  |  | Indicates whether asset is owned or leased. |  |
COMMITMENT | VARCHAR2 | 32 |  |  | Financial liability or commitment assigned to the asset. |  |
PARENT_ASSET_ID | NUMBER | 38 | 0 |  | Identifier of the parent asset for the child or component asset. |  |
INVENTORIAL_FLAG | VARCHAR2 | 16 |  |  | Indicates whether the asset should be included in physical inventory. |  |
PROPERTY_TYPE_CODE | VARCHAR2 | 32 |  |  | Option indicating whether the asset is considered personal, real, or residential property. |  |
PROPERTY_1245_1250_CODE | VARCHAR2 | 16 |  |  | Indicates whether the asset belongs to the 1245 property class or 1250 property class. |  |
INTANGIBLE_ASSET_FLAG | VARCHAR2 | 16 |  |  | Indicates whether the asset is an intangible asset. |  |
MANUFACTURER_NAME | VARCHAR2 | 512 |  |  | Name of the manufacturer of the asset. |  |
MODEL_NUMBER | VARCHAR2 | 64 |  |  | Model number assigned to the asset. |  |
NEW_USED | VARCHAR2 | 16 |  |  | Option indicating whether asset is new or used. |  |
INVESTMENT_LAW | VARCHAR2 | 32 |  |  | Benefit incentives applied to the asset. |  |
ASSET_KEY_CCID | NUMBER | 38 | 0 |  | Identifier of the asset key flexfield combination. |  |
ASSET_CATEGORY_ID | NUMBER | 38 | 0 |  | Identifier of the asset category. |  |
CURRENT_UNITS | NUMBER |  |  |  | Current number of units for an asset. |  |
CREATION_DATE | TIMESTAMP |  |  |  | Creation Date |  |

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