This is the Dimension table for Fixed asset Book Control details
Module: Assets
BOOK_TYPE_CODE
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
BOOK_TYPE_CODE | VARCHAR2 | 32 | True | Unique book identification name. | |||
SOURCE_RECORD_ID | VARCHAR2 | 64 | Source record identifier. Value is derived from a combination of Book Control identifiers. | ||||
BOOK_TYPE_NAME | VARCHAR2 | 32 | General description for the asset book. | ||||
BOOK_CLASS | VARCHAR2 | 16 | Type of the asset book. Possible values can be Corporate or Tax. | ||||
MASS_COPY_SOURCE_BOOK | VARCHAR2 | 32 | Associated corporate book from which transactions are to be copied. | ||||
FISCAL_YEAR_NAME | VARCHAR2 | 32 | Fiscal year in which the current period of the book falls. | ||||
LAST_PERIOD_COUNTER | NUMBER | 38 | 0 | Identifier of the last period for which depreciation process is run. | |||
CURRENT_FISCAL_YEAR | NUMBER | 38 | 0 | Current fiscal year for the book. | |||
DEPRN_CALENDAR | VARCHAR2 | 16 | Name of the depreciation calendar. | ||||
LAST_PURGE_PERIOD_COUNTER | NUMBER | 38 | 0 | Identifier of the last period for which purge process is run. | |||
LEDGER_ID | NUMBER | 38 | 0 | Identifier of the accounting ledger. | |||
CURRENT_PERIOD_COUNTER | NUMBER | 38 | 0 | Identifier of the current period | |||
CURRENT_PERIOD | VARCHAR2 | 16 | Current period of the book | ||||
LEDGER_CURRENCY_CODE | VARCHAR2 | 16 | Functional currency of the ledger. | ||||
NUM_PER_FISCAL_YEAR | NUMBER | 38 | 0 | Number of accounting periods for the fiscal year. |
Copyright © 2019, 2022, Oracle and/or its affiliates.