# DW_FA_MC_SLA_TRANSACTIONS_CF

This is the Fact table for Fixed asset transactions details

## Details

Module: Assets

## Key Columns

REF_AE_HEADER_ID, ASSET_ID, TEMP_LINE_NUM, ADJUSTMENT_LINE_ID, AE_HEADER_ID, LEDGER_ID, DISTRIBUTION_ID, TRANSACTION_HEADER_ID, BOOK_TYPE_CODE

## Columns

Columns
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. |  |
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 |  |  | This column is for Oracle Internal use only. |  |
SUBLEDGER_FACT_LINKAGE_ID | VARCHAR2 | 256 |  |  | Subledger Fact Linkage Identifier |  |
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. |  |
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_YESNO_LKP_TL with CODE_TYPE=FA_YESNO. | DW_YESNO_LKP_TL | YESNO_LKP_CODE
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. |  |
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. |  |
TRANSACTION_SUBTYPE | VARCHAR2 | 64 |  |  | Further detail of transaction type. |  |
FISCAL_PERIOD_NAME | VARCHAR2 | 64 |  |  | Accounting period name. | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME
TRANSACTION_PERIOD_NAME | VARCHAR2 | 64 |  |  | Asset transaction calendar period name. |  |
XDL_CREATION_DATE | TIMESTAMP |  |  |  | Creation Date |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.