Reporting Adjustments

The Adjustments view object stores all information to create journal entries for transactions for the reporting currencies in the primary ledger.

Data Store Key : FscmTopModelAM.FinExtractAM.FaBiccExtractAM.ReportingAdjustmentExtractPVO

Primary Keys : ReportingAdjustmentSetOfBooksId, ReportingAdjustmentAdjustmentLineId, ReportingAdjustmentTransactionHeaderId

Initial Extract Date : ReportingAdjustmentCreationDate

Incremental Extract Date : ReportingAdjustmentLastUpdateDate

Attributes

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

Name Description
ReportingAdjustmentAdjustmentAmount The amount used to adjust the asset.
ReportingAdjustmentAdjustmentLineId The unique identifier of the asset accounting line.
ReportingAdjustmentAdjustmentType The type of account that the adjustment affects.
ReportingAdjustmentAnnualizedAdjustment The adjustment amount for a period multiplied by the number of periods in the fiscal year for retroactive transactions.
ReportingAdjustmentAssetId The unique identifier of the asset number.
ReportingAdjustmentAssetInvoiceId The unique identifier of the asset invoice.
ReportingAdjustmentBookTypeCode The name of the asset book.
ReportingAdjustmentCodeCombinationId The unique identifier of the account code combination to be used to account for the asset transaction line.
ReportingAdjustmentConvertedFlag Status indicating whether the transaction amounts have been converted to the reporting currency.
ReportingAdjustmentCreatedBy The user who created the adjustment.
ReportingAdjustmentCreationDate The date the adjustment was created.
ReportingAdjustmentDebitCreditFlag Indicates whether the line is Credit or Debit in the accounting entry for the asset transaction.
ReportingAdjustmentDeprnOverrideFlag Indicates the depreciation override amount for assets in the book.
ReportingAdjustmentDistributionId The unique identifier of the asset distribution line.
ReportingAdjustmentLastUpdateDate The date of the most recent change.
ReportingAdjustmentLastUpdateLogin The session login associated with the user who performed the adjustment.
ReportingAdjustmentLastUpdatedBy The user who last performed the adjustment.
ReportingAdjustmentObjectVersionNumber The number of times an adjustment was updated.
ReportingAdjustmentPeriodCounterAdjusted The period from which the adjustment transaction is effective.
ReportingAdjustmentPeriodCounterCreated The period from which the adjustment transaction is created.
ReportingAdjustmentSetOfBooksId Identifier of the accounting ledger.
ReportingAdjustmentSourceDestCode Indicates whether this line is on the source or destination side of a transaction.
ReportingAdjustmentSourceLineId The unique identifier for the source line information.
ReportingAdjustmentSourceTypeCode The type of adjustment transaction.
ReportingAdjustmentTrackMemberFlag Indicates whether the account information is created at the member level when the Track Member Account option is set.
ReportingAdjustmentTransactionHeaderId The unique identifier for the transaction.