DW_FA_ADJUSTMENTS_EN

This is the Entity table for Fixed asset adjustment details

Details

Module: Assets

Key Columns

ADJUSTMENT_LINE_ID, SET_OF_BOOKS_ID, TRANSACTION_HEADER_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
TRANSACTION_HEADER_ID NUMBER 38 0 True Identifier of the asset transaction.    
ADJUSTMENT_LINE_ID NUMBER 38 0 True Identifier of the asset accounting line.    
SET_OF_BOOKS_ID NUMBER 38 0 True Identifier of the accounting ledger    
SOURCE_RECORD_ID VARCHAR2 128     Source record identifier. Value is derived from a combination of Asset adjustment identifiers.    
SUBLEDGER_LINKAGE_DST_ENTITY_ID VARCHAR2 128     Subledger Linkage Distribution Entity Identifier    
ASSET_ID NUMBER 38 0   Identifier of the asset number.    
BOOK_TYPE_CODE VARCHAR2 32     Unique book identification name.    
DISTRIBUTION_ID NUMBER 38 0   Identifier of the asset distribution.    
SOURCE_LINE_ID NUMBER 38 0   Identifier of the asset source line.    
PERIOD_COUNTER_CREATED NUMBER 38 0   Identifier of the depreciation period in which the transaction was performed.    
ADJUSTMENT_AMOUNT NUMBER       Amount of the asset adjustment broken down by the account type and asset distribution.    
ADJUSTMENT_TYPE VARCHAR2 16     The type of account this row affects.    
SOURCE_TYPE_CODE VARCHAR2 16     Asset transaction type of the accounting line.    
DEPRN_OVERRIDE_FLAG VARCHAR2 16     Indicator as to whether the depreciation amount for the transaction is overridden or not.    
MC_FLAG VARCHAR2 16     Flag to indicate the source of data is MC or Regular dataset    
H_ASSET_NUMBER VARCHAR2 32     User-defined asset identification number.    
H_ASSET_KEY_CCID NUMBER 38 0   Identifier of the asset key flexfield combination.    
H_ASSET_CATEGORY_ID NUMBER 38 0   Identifier of the asset category.    
H_DESCRIPTION VARCHAR2 128     Asset description    
H_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.    
H_TAG_NUMBER VARCHAR2 16     Unique user-defined tracking number for an asset.    
H_SERIAL_NUMBER VARCHAR2 64     Serial number assigned to the asset.    
H_IN_USE_FLAG VARCHAR2 16     Indicator used to determine whether the asset is in use.    
H_OWNED_LEASED VARCHAR2 16     Indicates whether asset is owned or leased.    
H_COMMITMENT VARCHAR2 32     Financial liability or commitment assigned to the asset.    
H_PARENT_ASSET_ID NUMBER 38 0   Identifier of the parent asset for the child or component asset.    
H_INVENTORIAL VARCHAR2 16     Indicates whether the asset should be included in physical inventory.    
H_PROPERTY_1245_1250_CODE VARCHAR2 16     Indicates whether the asset belongs to the 1245 property class or 1250 property class.    
H_PROPERTY_TYPE_CODE VARCHAR2 32     Option indicating whether the asset is considered personal, real, or residential property.    
H_INTANGIBLE_ASSET_FLAG VARCHAR2 16     Indicates whether the asset is an intangible asset.    
H_MANUFACTURER_NAME VARCHAR2 512     Name of the manufacturer of the asset.    
H_MODEL_NUMBER VARCHAR2 64     Model number assigned to the asset.    
H_NEW_USED VARCHAR2 16     Option indicating whether asset is new or used.    
H_INVESTMENT_LAW VARCHAR2 32     Benefit incentives applied to the asset.    
H_CURRENT_UNITS NUMBER       Current number of units for an asset.