[Home] [Help] [Dependency Information]
Object Name: | FA_MC_BOOK_CONTROLS |
---|---|
Object Type: | TABLE |
Owner: | FA |
FND Design Data: | OFA.FA_MC_BOOK_CONTROLS |
Subobject Name: | |
Status: | VALID |
FA_MC_BOOK_CONTROLS is an MRC sub-table of FA_ BOOK_CONTROLS. This
table stores control information that affects all assets in a
reporting depreciation book.
The BOOK_TYPE_CODE in FA_MC_BOOK_CONTROLS is the same as the
BOOK_TYPE_CODE in the parent record in FA_ BOOK_CONTROLS.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FA_MC_BOOK_CONTROLS_U1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
SET_OF_BOOKS_ID
BOOK_TYPE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Reporting set of books identification number for GL sets of books |
BOOK_TYPE_CODE | VARCHAR2 | (30) | Yes | Book name |
CURRENCY_CODE | VARCHAR2 | (15) | Yes | Transaction currency |
DEPRN_STATUS | VARCHAR2 | (1) | Specifies whether the depreciation program is locking the book. Either C (completed), E (error), R (running), or S (submitted) | |
DEPRN_REQUEST_ID | NUMBER | (15) | Concurrent request identification number for the last depreciation run | |
LAST_PERIOD_COUNTER | NUMBER | (15) | Yes | Last period depreciated in this book |
LAST_DEPRN_RUN_DATE | DATE | Yes | Date of the last depreciation | |
CURRENT_FISCAL_YEAR | NUMBER | (4) | Yes | Current fiscal year for the book |
RETIRED_STATUS | VARCHAR2 | (1) | Yes | Reserved for future use |
RETIRED_REQUEST_ID | NUMBER | (15) | Yes | Reserved for future use |
PRIMARY_SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Primary set of books identification number for this reporting set of books |
PRIMARY_CURRENCY_CODE | VARCHAR2 | (15) | Yes | The currency code of the primary set of books |
SOURCE_RETIRED_STATUS | VARCHAR2 | (1) | Yes | Reserved for future use |
SOURCE_RETIRED_REQUEST_ID | NUMBER | (15) | Yes | Reserved for future use |
MRC_CONVERTED_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the set of books is converted to Multiple Reporting Currencies options |
ENABLED_FLAG | VARCHAR2 | (1) | Yes | Indicates if this set of books is enabled for transactions |
NBV_AMOUNT_THRESHOLD | NUMBER | Rounding information for depreciation based on currency and precision | ||
CONVERSION_STATUS | VARCHAR2 | (1) | Conversion status | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
MASS_REQUEST_ID | NUMBER | (15) | Concurrent request ID of a mass transaction locking any assets in this book | |
ALLOW_IMPAIRMENT_FLAG | VARCHAR2 | (1) | Indicates whether to allow asset impairments | |
GL_POSTING_ALLOWED_FLAG | VARCHAR2 | (3) | Indicates whether to allow journals to be created in General Ledger |
Cut, paste (and edit) the following text to query this object:
SELECT SET_OF_BOOKS_ID
, BOOK_TYPE_CODE
, CURRENCY_CODE
, DEPRN_STATUS
, DEPRN_REQUEST_ID
, LAST_PERIOD_COUNTER
, LAST_DEPRN_RUN_DATE
, CURRENT_FISCAL_YEAR
, RETIRED_STATUS
, RETIRED_REQUEST_ID
, PRIMARY_SET_OF_BOOKS_ID
, PRIMARY_CURRENCY_CODE
, SOURCE_RETIRED_STATUS
, SOURCE_RETIRED_REQUEST_ID
, MRC_CONVERTED_FLAG
, ENABLED_FLAG
, NBV_AMOUNT_THRESHOLD
, CONVERSION_STATUS
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, MASS_REQUEST_ID
, ALLOW_IMPAIRMENT_FLAG
, GL_POSTING_ALLOWED_FLAG
FROM FA.FA_MC_BOOK_CONTROLS;
FA.FA_MC_BOOK_CONTROLS does not reference any database object
FA.FA_MC_BOOK_CONTROLS is referenced by following:
|
|
|