This is the Entity table for Fixed asset adjustment details
Module: Assets
ADJUSTMENT_LINE_ID, SET_OF_BOOKS_ID, TRANSACTION_HEADER_ID
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. |