This is the Dimension table for Fixed asset depreciation period details
Module: Assets
LEDGER_ID, BOOK_TYPE_CODE, MC_FLAG, 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 | 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, 2023, Oracle and/or its affiliates.