This is the Dimension table for Fixed asset depreciation period details
Module: Assets
LEDGER_ID, MC_FLAG, BOOK_TYPE_CODE, PERIOD_COUNTER
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| BOOK_TYPE_CODE | VARCHAR2 | 32 | True | Unique book identification name. | |||
| PERIOD_COUNTER | NUMBER | 38 | 0 | True | Identifier of the depreciation period. | ||
| LEDGER_ID | NUMBER | 38 | 0 | True | Identifier of the accounting ledger | ||
| MC_FLAG | VARCHAR2 | 16 | True | Flag to indicate the source of data is MC or Regular dataset | |||
| SOURCE_RECORD_ID | VARCHAR2 | 64 | This column is for Oracle Internal use only. Source record identifier. Value is derived from a combination of BOOK_TYPE_CODE and PERIOD_COUNTER. | ||||
| PERIOD_NAME | VARCHAR2 | 16 | Asset book depreciation calendar period name. | ||||
| PERIOD_NUM | NUMBER | 38 | 0 | Period number of depreciation period in the fiscal year. | |||
| FISCAL_YEAR | NUMBER | 38 | 0 | Name of the accounting fiscal year. | |||
| PERIOD_OPEN_DATE | TIMESTAMP | System date when the depreciation period is opened. | |||||
| PERIOD_CLOSE_DATE | TIMESTAMP | System date when the depreciation period was closed. | |||||
| CALENDAR_PERIOD_OPEN_DATE | DATE | Start date of the calendar period. | |||||
| CALENDAR_PERIOD_CLOSE_DATE | DATE | End date of the calendar period. | |||||
| DEPRN_RUN_FLAG | VARCHAR2 | 16 | Indicator used to determine whether depreciation has been run for a period. | ||||
| PERIOD_OPEN_DATE_1 | DATE | System date when the depreciation period is opened. | |||||
| PERIOD_CLOSE_DATE_1 | DATE | System date when the depreciation period was closed. |
Copyright © 2019, 2024, Oracle and/or its affiliates.