DW_FA_MC_SLA_TRX_DEPRN_CA_CHANGE_STAGE

This Table staging table to capture the changes for incremental load

Details

Module: Assets

Key Columns

TRANSACTION_TYPE_CODE, FISCAL_PERIOD_SET_NAME, ADJUSTMENT_TYPE, BOOK_TYPE_CODE, ASSET_CAL_PERIOD_NAME, ACCOUNTING_CLASS_CODE, FISCAL_PERIOD_TYPE, GL_CODE_COMBINATION_ID, LEDGER_ID, CATEGORY_ID, CALENDAR_TYPE, FISCAL_PERIOD_NAME, IS_TRX_FLAG, XLA_LEDGER_ID

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.    
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.    
IS_TRX_FLAG VARCHAR2 16   True Flag to indicate the source of data is transactions or Depreciation dataset