DW_FA_MC_SLA_TRX_DEPRN_CA
This Table contains aggregated information about fixed asset transactions and depreciation accounting
Details
Module: Assets
Key Columns
XLA_LEDGER_ID, TRANSACTION_TYPE_CODE, ASSET_CAL_PERIOD_NAME, ACCOUNTING_CLASS_CODE, FISCAL_PERIOD_TYPE, CALENDAR_TYPE, GL_CODE_COMBINATION_ID, ADJUSTMENT_TYPE, FISCAL_PERIOD_NAME, BOOK_TYPE_CODE, CATEGORY_ID, LEDGER_ID, FISCAL_PERIOD_SET_NAME
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. | |||
| ADJUSTMENT_TYPE | VARCHAR2 | 16 | True | The type of account this row affects. | |||
| TRANSACTION_TYPE_CODE | VARCHAR2 | 32 | True | Identifier of the asset transaction type. | |||
| XLA_LEDGER_ID | NUMBER | 38 | 0 | True | Identifier of a self-contained accounting information set for single or multiple legal or management entities. | ||
| CALENDAR_TYPE | VARCHAR2 | 16 | True | Name of the depreciation calendar. | |||
| ASSET_CAL_PERIOD_NAME | VARCHAR2 | 64 | True | Asset calendar Period Name | |||
| CATEGORY_ID | NUMBER | 38 | 0 | True | Identifier of the asset category. | ||
| ACCOUNTING_CLASS_CODE | VARCHAR2 | 32 | True | Short name of a lookup type that is shared across application used to classify journal entry lines. | |||
| FISCAL_PERIOD_NAME | VARCHAR2 | 64 | True | Accounting period name. | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME | |
| FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 | True | Accounting calendar name. | |||
| FISCAL_PERIOD_TYPE | VARCHAR2 | 16 | True | Accounting period type. | |||
| GL_CODE_COMBINATION_ID | NUMBER | 38 | 0 | True | GL account identifier. | ||
| SOURCE_RECORD_ID | VARCHAR2 | 999 | This column is for Oracle Internal use only. Unique Identifier | ||||
| LEGAL_ENTITY_ID | NUMBER | 38 | 0 | Legal entity identifier. | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID | |
| 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. | ||||
| IS_TRX_FLAG | VARCHAR2 | 16 | Flag to indicate the source of data is transactions or Depreciation dataset | ||||
| XLA_LEDGER_CURRENCY_CODE | VARCHAR2 | 16 | Functional currency of the ledger. | ||||
| XLA_LEDGER_AMOUNT | BIGDECIMAL | 10 | |||||
| XLA_ACCOUNTED_DR_AMOUNT | BIGDECIMAL | 10 | |||||
| XLA_ACCOUNTED_CR_AMOUNT | BIGDECIMAL | 10 | |||||
| GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 | Global currency code. | ||||
| XLA_GLOBAL_AMOUNT | BIGDECIMAL | 10 | |||||
| XLA_GLOBAL_DR_AMOUNT | BIGDECIMAL | 10 | |||||
| XLA_GLOBAL_CR_AMOUNT | BIGDECIMAL | 10 |