This Table staging table to capture the changes for incremental load
Module: Assets
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
| 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 |