This is the Fact table for Fixed asset Depreciation details
Module: Assets
BOOK_TYPE_CODE, DISTRIBUTION_ID, LEDGER_ID, PERIOD_COUNTER, DEPRN_RUN_ID, ASSET_ID, TEMP_LINE_NUM, REF_AE_HEADER_ID, AE_HEADER_ID
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. | ||
PERIOD_COUNTER | NUMBER | 38 | 0 | True | Identifier of the asset transaction. | ||
DEPRN_RUN_ID | NUMBER | 38 | 0 | True | Identifier of the asset accounting line. | ||
DISTRIBUTION_ID | NUMBER | 38 | 0 | True | Identifier of the asset distribution. | ||
REF_AE_HEADER_ID | NUMBER | 38 | 0 | True | Subledger journal entry identifier. | ||
TEMP_LINE_NUM | NUMBER | 38 | 0 | True | Intermediary line number generated by the accounting engine when the entries are in most detail form. | ||
AE_HEADER_ID | NUMBER | 38 | 0 | True | Subledger journal entry identifier. | ||
SOURCE_RECORD_ID | VARCHAR2 | 256 | Unique Identifier of the record. | ||||
SUBLEDGER_FACT_LINKAGE_ID | VARCHAR2 | 256 | Subledger Fact Linkage Identifier | ||||
MC_FLAG | VARCHAR2 | 16 | Internal column to identify the origin of row(from MC table or regular table) | ||||
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. | |||
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. | |||
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. | |||||
CALENDAR_TYPE | VARCHAR2 | 16 | Name of the depreciation calendar. | ||||
PERIOD_NAME | VARCHAR2 | 16 | Asset book depreciation calendar period name. | ||||
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_ASSIGNMENT_FLAG | VARCHAR2 | 16 | |||||
ACTIVE_FINANCIAL_FLAG | VARCHAR2 | 16 | |||||
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. | ||||
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. | ||||
XLA_TRANSACTION_CURRENCY_CODE | VARCHAR2 | 16 | Entered currency for the transaction data. | ||||
XLA_LEDGER_CURRENCY_CODE | VARCHAR2 | 16 | Functional currency of the ledger. | ||||
XLA_TRANSACTION_AMOUNT | BIGDECIMAL | 10 | |||||
XLA_LEDGER_AMOUNT | BIGDECIMAL | 10 | |||||
XLA_ENTERED_DR_AMOUNT | BIGDECIMAL | 10 | Unrounded entered debit amount for the journal line. | ||||
XLA_ENTERED_CR_AMOUNT | BIGDECIMAL | 10 | Unrounded entered credit amount for the journal line. | ||||
XLA_ACCOUNTED_DR_AMOUNT | BIGDECIMAL | 10 | Unrounded accounted debit amount of the journal entry line. | ||||
XLA_ACCOUNTED_CR_AMOUNT | BIGDECIMAL | 10 | Unrounded accounted credit amount of the journal entry line. | ||||
XLA_GLOBAL_AMOUNT | BIGDECIMAL | 10 | |||||
XLA_GLOBAL_DR_AMOUNT | BIGDECIMAL | 10 | |||||
XLA_GLOBAL_CR_AMOUNT | BIGDECIMAL | 10 | |||||
XLA_MANUAL_OVERRIDE_FLAG | VARCHAR2 | 32 | Indicates a manual override. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. | ||||
SOURCE_DISTRIBUTION_TYPE | VARCHAR2 | 32 | Classification of transaction source distribution. | ||||
ACCOUNTING_LINE_CODE | VARCHAR2 | 32 | Short name of a rule to convert transactional data into a journal entry line. | ||||
ACCOUNTING_LINE_TYPE_CODE | VARCHAR2 | 16 | Type of journal line rule: Debit, Credit, Gain or Loss. | ||||
AE_LINE_NUM | NUMBER | 38 | 0 | Number that is associated with each subledger journal entry line. | |||
ACCOUNTING_CLASS_CODE | VARCHAR2 | 32 | Short name of a lookup type that is shared across application used to classify journal entry lines. | ||||
XLA_LINE_TRANSACTION_AMOUNT | BIGDECIMAL | 10 | |||||
XLA_LINE_ENTERED_DR_AMOUNT | BIGDECIMAL | 10 | |||||
XLA_LINE_ENTERED_CR_AMOUNT | BIGDECIMAL | 10 | |||||
XLA_LINE_LEDGER_AMOUNT | BIGDECIMAL | 10 | |||||
XLA_LINE_ACCOUNTED_DR_AMOUNT | BIGDECIMAL | 10 | |||||
XLA_LINE_ACCOUNTED_CR_AMOUNT | BIGDECIMAL | 10 | |||||
XLA_LINE_GLOBAL_AMOUNT | BIGDECIMAL | 10 | |||||
XLA_LINE_GLOBAL_DR_AMOUNT | BIGDECIMAL | 10 | |||||
XLA_LINE_GLOBAL_CR_AMOUNT | BIGDECIMAL | 10 | |||||
XLA_EVENT_ID | NUMBER | 38 | 0 | Identifier of the categorization of accounting events that is unique within an application and event class. | |||
XLA_EVENT_CLASS_CODE | VARCHAR2 | 32 | Unique abbreviated name assigned to an event class and used for reporting or in reference to an option. | ||||
XLA_EVENT_TYPE_CODE | VARCHAR2 | 32 | Unique abbreviated name assigned to an event type and used for reporting or in reference to an option. | ||||
XLA_ACCOUNTING_DATE | DATE | Date, referenced from Oracle Fusion General Ledger, used to determine the accounting period for transactions. | |||||
XLA_LEDGER_ID | NUMBER | 38 | 0 | Identifier of a self-contained accounting information set for single or multiple legal or management entities. | |||
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 | Accounting calendar name. | ||||
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 | Accounting period type. | ||||
FISCAL_PERIOD_NAME | VARCHAR2 | 64 | Accounting period name. | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME | ||
LEGAL_ENTITY_ID | NUMBER | 38 | 0 | Legal entity identifier. | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID | |
GL_CODE_COMBINATION_ID | NUMBER | 38 | 0 | GL 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. | ||||
PERIOD_OPEN_DATE | DATE | Period open date. | |||||
XDL_CREATION_DATE | TIMESTAMP | Creation Date |
Copyright © 2019, 2023, Oracle and/or its affiliates.