Reporting Book Controls

The Reporting Book Controls view object contains all information about assets in a reporting currencies book associated with the parent record in the BOOK_CONTROLS table. This table stores transactions in reporting currencies, and also stores transactions in tax books that use the secondary ledger with different currencies.

Data Store Key : FscmTopModelAM.FinExtractAM.FaBiccExtractAM.ReportingBookControlExtractPVO

Primary Keys : ReportingBookControlSetOfBooksId, ReportingBookControlBookTypeCode

Initial Extract Date : ReportingBookControlCreationDate

Incremental Extract Date : ReportingBookControlLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
ReportingBookControlBookTypeCode	The unique identifier for the asset book name.
ReportingBookControlConversionStatus	Indicates whether the information has been converted to the reporting currencies book.
ReportingBookControlCreatedBy	The user who created the reporting asset book.
ReportingBookControlCreationDate	The date the reporting asset book was created.
ReportingBookControlCurrencyCode	The asset book currency.
ReportingBookControlCurrentFiscalYear	Current accounting fiscal year.
ReportingBookControlDeprnRequestId	Indicates the request ID of the last run of the Create Accounting process.
ReportingBookControlDeprnStatus	Last condition of the Calculate Depreciation process.
ReportingBookControlEnabledFlag	Indicates whether the reporting currency and book association is active.
ReportingBookControlGlPostingAllowedFlag	Indicates whether the accounting entries can be posted to General Ledger.
ReportingBookControlLastDeprnRunDate	Date on which the Calculate Depreciation process was run last time for the book.
ReportingBookControlLastPeriodCounter	Identifier of the last period for which the Calculate Depreciation process was run.
ReportingBookControlLastUpdateDate	The date of the most recent change.
ReportingBookControlLastUpdateLogin	The session login associated with the user who last updated the row in the Reporting Book Controls table.
ReportingBookControlLastUpdatedBy	The user who last updated the row in Reporting Book Controls table.
ReportingBookControlMassRequestId	Indicates the request ID of the last run of the Mass Transaction process.
ReportingBookControlMrcConvertedFlag	Indicates whether the set of books is converted to Multiple Reporting Currencies.
ReportingBookControlNbvAmountThreshold	The net book value threshold amount for a book.
ReportingBookControlObjectVersionNumber	The number of times the Reporting Book Controls row has been updated.
ReportingBookControlPrimaryCurrencyCode	The currency code of the primary ledger.
ReportingBookControlPrimarySetOfBooksId	Identifier of the primary ledger associated with the reporting ledger for this row.
ReportingBookControlSetOfBooksId	Identifier of the accounting ledger.