This is the Fact table for Fixed asset unaccounted transactions details
Module: Assets
LEDGER_ID, TRANSACTION_HEADER_ID, ADJUSTMENT_LINE_ID, DISTRIBUTION_ID, ASSET_ID, BOOK_TYPE_CODE
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
LEDGER_ID | NUMBER | 38 | 0 | True | Identifier of the accounting ledger | ||
BOOK_TYPE_CODE | VARCHAR2 | 32 | True | Unique book identification name. | |||
ASSET_ID | NUMBER | 38 | 0 | True | Identifier of the asset number. | ||
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. | ||
DISTRIBUTION_ID | NUMBER | 38 | 0 | True | Identifier of the asset distribution. | ||
SOURCE_RECORD_ID | VARCHAR2 | 256 | This column is for Oracle Internal use only. | ||||
MC_FLAG | VARCHAR2 | 16 | Flag to indicate the source of data is MC or Regular dataset | ||||
ASSET_NUMBER | VARCHAR2 | 32 | User-defined asset identification number. | ||||
ASSET_DESCRIPTION | VARCHAR2 | 128 | Asset description | ||||
PARENT_ASSET_ID | NUMBER | 38 | 0 | Identifier of the parent asset for the child or component asset. | |||
GROUP_ASSET_ID | NUMBER | 38 | 0 | Identification number of the group asset. | |||
SOURCE_LINE_ID | NUMBER | 38 | 0 | Identifier of the asset source line. | |||
CATEGORY_ID | NUMBER | 38 | 0 | Identifier of the asset category. | |||
LOCATION_ID | NUMBER | 38 | 0 | Location flexfield identification number. | |||
ASSIGNED_TO_ID | NUMBER | 38 | 0 | Identifier of the employee to whom the asset is assigned. | |||
ASSET_KEY_CCID | NUMBER | 38 | 0 | Asset Keyword identifier. | |||
RETIREMENT_ID | NUMBER | 38 | 0 | Identifier of the asset retirement transaction. | |||
IMPAIRMENT_ID | NUMBER | 38 | 0 | Identifier of the asset Impairment transaction. | |||
METHOD_ID | NUMBER | 38 | 0 | Identifier of the depreciation method. | |||
CONVENTION_TYPE_ID | NUMBER | 38 | 0 | Identifier of the prorate convention | |||
CASH_GENERATING_UNIT_ID | NUMBER | 38 | 0 | Identifier of the cash generating unit. | |||
CEILING_TYPE_ID | NUMBER | 38 | 0 | Identifier of the depreciation ceiling. | |||
TRANSACTION_TYPE_CODE | VARCHAR2 | 32 | Identifier of the asset transaction type. | ||||
SOURCE_TYPE_CODE | VARCHAR2 | 16 | Asset transaction type of the accounting line. | ||||
ADJUSTMENT_TYPE | VARCHAR2 | 16 | The type of account this row affects. | ||||
TRANSACTION_DATE_ENTERED | DATE | Date when the transaction occurred. | |||||
TXN_HDR_DATE_EFFECTIVE | TIMESTAMP | Date when the row became effective. | |||||
DATE_PLACED_IN_SERVICE | DATE | Date on which the asset was placed in service. | |||||
PRORATE_DATE | DATE | Date used to calculate the annual depreciation for assets. | |||||
AMORTIZATION_START_DATE | DATE | Date to start amortizing the net book value for an asset . | |||||
CALENDAR_TYPE | VARCHAR2 | 16 | Name of the depreciation calendar. | ||||
PERIOD_NAME | VARCHAR2 | 16 | Asset book depreciation calendar period name. | ||||
PERIOD_COUNTER_CREATED | NUMBER | 38 | 0 | Identifier of the depreciation period in which the transaction was performed. | |||
PERIOD_COUNTER_CAPITALIZED | NUMBER | 38 | 0 | Identifier of the depreciation period in which asset is capitalized. | |||
PERIOD_COUNTER_FULLY_RESERVED | NUMBER | 38 | 0 | Identifier of the depreciation period in which the asset was fully reserved. | |||
PERIOD_COUNTER_FULLY_RETIRED | NUMBER | 38 | 0 | Identifier of the depreciation period in which the asset was fully retired. | |||
ACTIVE_ASSET_FLAG | VARCHAR2 | 16 | |||||
ACTIVE_ASSIGNMENT_FLAG | VARCHAR2 | 16 | |||||
ACTIVE_FINANCIAL_FLAG | VARCHAR2 | 16 | |||||
DEPRN_OVERRIDE_FLAG | VARCHAR2 | 16 | Indicator as to whether the depreciation amount for the transaction is overridden or not. | ||||
DEPRECIATE_FLAG | VARCHAR2 | 16 | Option indicating whether the asset is depreciating or not. | ||||
LOW_VALUE_ASSET_FLAG | VARCHAR2 | 16 | Indicates whether this line is a low value asset. | ||||
AMORTIZE_FLAG | VARCHAR2 | 16 | |||||
UNITS_ASSIGNED | NUMBER | Number of units assigned to the distribution. | |||||
TRANSACTION_UNITS | NUMBER | Number of units involved in the transaction. Negative value for the row from which the units were transferred away or retired. Positive value for the row to which the units were transferred to or added. | |||||
GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 | Global currency code. | ||||
GLOBAL_CURRENCY_EXCH_RATE | BIGDECIMAL | 10 | Global currency conversion rate. | ||||
TRANSACTION_CURRENCY_CODE | VARCHAR2 | 16 | Entered currency for the transaction data. | ||||
LEDGER_CURRENCY_CODE | VARCHAR2 | 16 | Functional currency of the ledger. | ||||
TRANSACTION_ADJUSTMENT_AMOUNT | BIGDECIMAL | 10 | Adjustment amount in transaction currency | ||||
LEDGER_ADJUSTMENT_AMOUNT | BIGDECIMAL | 10 | Adjustment amount in ledger currency | ||||
GLOBAL_ADJUSTMENT_AMOUNT | BIGDECIMAL | 10 | Adjustment amount in global currency | ||||
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 | Accounting calendar name. | ||||
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 | Accounting period type. | ||||
LEGAL_ENTITY_ID | NUMBER | 38 | 0 | Legal entity identifier. | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID | |
CODE_COMBINATION_ID | NUMBER | 38 | 0 | Account identifier. | |||
COST_CENTER_SEGMENT | VARCHAR2 | 32 | Cost center segment. | ||||
COST_CENTER_VALUESET_CODE | VARCHAR2 | 64 | Cost center value set code. | ||||
GL_BALANCING_SEGMENT | VARCHAR2 | 32 | Balancing segment. | ||||
GL_BLNC_SGMNT_VALUESET_CODE | VARCHAR2 | 64 | Balancing segment value set code. | ||||
NATURAL_ACCOUNT_SEGMENT | VARCHAR2 | 32 | Natural account segment. | ||||
NTRL_ACNT_SGMNT_VALUESET_CODE | VARCHAR2 | 64 | Natural account value set code. | ||||
GL_SEGMENT1 | VARCHAR2 | 32 | Accounting segment 1. | ||||
GL_SEGMENT1_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 1 value set code. | ||||
GL_SEGMENT2 | VARCHAR2 | 32 | Accounting segment 2. | ||||
GL_SEGMENT2_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 2 value set code. | ||||
GL_SEGMENT3 | VARCHAR2 | 32 | Accounting segment 3. | ||||
GL_SEGMENT3_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 3 value set code. | ||||
GL_SEGMENT4 | VARCHAR2 | 32 | Accounting segment 4. | ||||
GL_SEGMENT4_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 4 value set code. | ||||
GL_SEGMENT5 | VARCHAR2 | 32 | Accounting segment 5. | ||||
GL_SEGMENT5_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 5 value set code. | ||||
GL_SEGMENT6 | VARCHAR2 | 32 | Accounting segment 6. | ||||
GL_SEGMENT6_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 6 value set code. | ||||
GL_SEGMENT7 | VARCHAR2 | 32 | Accounting segment 7. | ||||
GL_SEGMENT7_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 7 value set code. | ||||
GL_SEGMENT8 | VARCHAR2 | 32 | Accounting segment 8. | ||||
GL_SEGMENT8_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 8 value set code. | ||||
GL_SEGMENT9 | VARCHAR2 | 32 | Accounting segment 9. | ||||
GL_SEGMENT9_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 9 value set code. | ||||
GL_SEGMENT10 | VARCHAR2 | 32 | Accounting segment 10. | ||||
GL_SEGMENT10_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 10 value set code. | ||||
TRANSACTION_SUBTYPE | VARCHAR2 | 64 | Further detail of transaction type. | ||||
TRANSACTION_PERIOD_NAME | VARCHAR2 | 64 | Asset transaction calendar period name. | ||||
CREATION_DATE | TIMESTAMP | Creation Date |
Copyright © 2019, 2024, Oracle and/or its affiliates.