Accrual Reconciliation Headers

The Accrual Reconciliation Headers view object contains accrual clearing amount differences for each purchase order distribution and account.

Data Store Key : FscmTopModelAM.ScmExtractAM.CmrBiccExtractAM.CmrAccrReconcHeadersExtractPVO

Primary Keys : CmrAccrReconcHeadersPEOCmrAccrReconcHeaderId

Initial Extract Date : CmrAccrReconcHeadersPEOCreationDate

Incremental Extract Date : CmrAccrReconcHeadersPEOLastUpdateDate

Attributes

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

Name	Description
CmrAccrReconcHeadersPEOAccrualAccountId	Value that uniquely identifies the accrual account.
CmrAccrReconcHeadersPEOAccrualClrAmt	Value that identifies the accrual clearing amount.
CmrAccrReconcHeadersPEOAccrualClrFlag	Value that identifies the accrual clearing status.
CmrAccrReconcHeadersPEOApAccrualAmt	Value that identifies the net posted accrual amount by accounts payable to SLA.
CmrAccrReconcHeadersPEOApAccrualAmtAccrual	Value that identifies the net posted accrual amount accrued by accounts payable to SLA.
CmrAccrReconcHeadersPEOApAccrualAmtNonrectax	Value that identifies the net posted accrual amount for nonrecoverable tax by accounts payable to SLA.
CmrAccrReconcHeadersPEOApAccrualAmtRectax	Value that identifies the net posted accrual amount for recoverable tax by accounts payable to SLA.
CmrAccrReconcHeadersPEOBillToBusinessUnitId	Value that uniquely identifies the bill to business unit where the invoice is created.
CmrAccrReconcHeadersPEOChartOfAccountsId	Value that identifies the key Flexfield structure instance defining column.
CmrAccrReconcHeadersPEOCmrAccrReconcHeaderId	Value that uniquely identifies the receipt accounting accrual reconciliation header.
CmrAccrReconcHeadersPEOCmrAccrualAmt	Value that identifies the net posted accrual amount by CMR to SLA.
CmrAccrReconcHeadersPEOCmrAccrualAmtAccrual	Value that identifies the net posted accrual amount for accrual by CMR to SLA.
CmrAccrReconcHeadersPEOCmrAccrualAmtNonrectax	Value that identifies the net posted accrual amount for nonrecoverable tax by CMR to SLA.
CmrAccrReconcHeadersPEOCmrAccrualAmtRectax	Value that identifies the net posted accrual amount for recoverable tax by CMR to SLA.
CmrAccrReconcHeadersPEOCmrPoDistributionId	Value that identifies the entity in receipt accounting PO distributions. This value will exist for match to PO, as well as a match to receipt cases.
CmrAccrReconcHeadersPEOCreatedBy	User who created the row.
CmrAccrReconcHeadersPEOCreationDate	Date and time the row was created.
CmrAccrReconcHeadersPEOCurrencyConversionDate	Value that identifies the currency conversion date of the transaction in purchase order currency to ledger currency.
CmrAccrReconcHeadersPEOCurrencyConversionRate	Value that identifies the currency conversion rate on the transaction in purchase order currency to ledger currency.
CmrAccrReconcHeadersPEODestinationTypeCode	Value that identifies the destination type for material. Valid values are INVENTORY or EXPENSE.
CmrAccrReconcHeadersPEOEnteredApAccrualAmt	Value that identifies the invoice accrual amount in purchase order currency.
CmrAccrReconcHeadersPEOEnteredApNonrectaxAmt	Value that identifies the invoice nonrecoverable tax amount.
CmrAccrReconcHeadersPEOEnteredApRectaxAmt	Value that identifies the invoice recoverable tax amount.
CmrAccrReconcHeadersPEOEnteredCmrAccrualAmt	Value that identifies the receipt accounting accrual amount in purchase order currency.
CmrAccrReconcHeadersPEOEnteredCmrNonrectaxAmt	Value that identifies the entered nonrecoverable tax amount.
CmrAccrReconcHeadersPEOEnteredCmrRectaxAmt	Value that identifies the entered recoverable tax amount.
CmrAccrReconcHeadersPEOEventEnteredAmt	Value that identifies the net posted amount in user entered transaction currency.
CmrAccrReconcHeadersPEOEventLatestTxnDate	Value that identifies the maximum transaction date from receiving transactions, invoices, and retro price events.
CmrAccrReconcHeadersPEOInventoryItemId	Value that uniquely identifies the inventory Item on the purchase order line.
CmrAccrReconcHeadersPEOInventoryOrganizationId	Value that uniquely identifies the inventory organization.
CmrAccrReconcHeadersPEOInvoiceQty	Value that identifies the invoice quantity as reported by accounts payable.
CmrAccrReconcHeadersPEOLastUpdateDate	Date and time the row was last updated.
CmrAccrReconcHeadersPEOLastUpdateLogin	Session login associated with the user who last updated the row.
CmrAccrReconcHeadersPEOLastUpdatedBy	User who last updated the row.
CmrAccrReconcHeadersPEOProcessRunId	Value that uniquely identifies the receipt accrual process run used to identify the process group.
CmrAccrReconcHeadersPEOReceivedQty	Value that identifies the net received quantity as reported by receipt accounting.
CmrAccrReconcHeadersPEOSoldToBusinessUnitId	Value that identifies the profit business unit of purchase order.