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