Accrual Clearing Amounts

The Accrual Clearing Amounts view object contains accrual clearing events.

Data Store Key : FscmTopModelAM.ScmExtractAM.CmrBiccExtractAM.CmrAccrualClrAmtsExtractPVO

Primary Keys : CmrAccrualClrAmtsPEOAccrualClrId

Initial Extract Date : CmrAccrualClrAmtsPEOCreationDate

Incremental Extract Date : CmrAccrualClrAmtsPEOLastUpdateDate

Attributes

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

Name	Description
CmrAccrualClrAmtsPEOAccrualAccountId	Value that identifies the accrual account.
CmrAccrualClrAmtsPEOAccrualClrAmt	Value that identifies the accrual clearing amount in functional currency that's manually or automatically cleared by the user.
CmrAccrualClrAmtsPEOAccrualClrGroupId	Value that identifies the accrual clearing group used while performing accrual clearing.
CmrAccrualClrAmtsPEOAccrualClrId	Value that uniquely identifies the accrual clearing event.
CmrAccrualClrAmtsPEOAccrualClrMode	Value that identifies the accrual clearing mode. Valid values are auto accrual clearing or manual clearing.
CmrAccrualClrAmtsPEOAccrualClrReasonDesc	Value that identifies the user entered reason used while performing accrual clearing and reversal transactions.
CmrAccrualClrAmtsPEOAccrualClrRuleName	Value that identifies the auto accrual clearing rule name.
CmrAccrualClrAmtsPEOAccrualProcessedFlag	Value that indicates if the accounting event was generated for accrual clearing transactions.
CmrAccrualClrAmtsPEOApAccrualAmt	Value that identifies the net posted accrual amount by accounts payable in functional currency.
CmrAccrualClrAmtsPEOApAccrualAmtAccrual	Value that identifies the net posted accrual amount for accrual by accounts payable in functional currency.
CmrAccrualClrAmtsPEOApAccrualAmtNonrectax	Value that identifies the net posted accrual amount for nonrecoverable tax by accounts payable in functional currency.
CmrAccrualClrAmtsPEOApAccrualAmtRectax	Value that identifies the net posted accrual amount for recoverable tax by accounts payable in functional currency.
CmrAccrualClrAmtsPEOBillToBusinessUnitId	Value that identifies the bill to business unit. Indicates the invoicing business unit for supplier facing nodes in purchase order flows.
CmrAccrualClrAmtsPEOChartOfAccountsId	Value that identifies the key flexfield structure instance.
CmrAccrualClrAmtsPEOCmrAccrualAmt	Value that identifies the net posted accrual amount by CMR in functional currency.
CmrAccrualClrAmtsPEOCmrAccrualAmtAccrual	Value that identifies the net posted accrual amount for accrual by CMR in functional currency.
CmrAccrualClrAmtsPEOCmrAccrualAmtNonrectax	Value that identifies the net posted accrual amount for nonrecoverable tax by CMR in functional currency.
CmrAccrualClrAmtsPEOCmrAccrualAmtRectax	Value that identifies the net posted accrual amount for recoverable tax by CMR in functional currency.
CmrAccrualClrAmtsPEOCmrPoDistributionId	Value that identifies the entity in receipt accounting PO distributions. This value will exist for match to PO as well as match to receipt cases.
CmrAccrualClrAmtsPEOCmrPoLineLocationId	Value that identifies the purchase order line location.
CmrAccrualClrAmtsPEOCreatedBy	User who created the row.
CmrAccrualClrAmtsPEOCreationDate	Date and time the row was created.
CmrAccrualClrAmtsPEOCurrencyConversionDate	Value that identifies the currency conversion date for accrual clearing transactions.
CmrAccrualClrAmtsPEOCurrencyConversionRate	Value that identifies the currency conversion rate for accrual clearing transactions.
CmrAccrualClrAmtsPEODeliveryProcessedFlag	Value that indicates if the accounting event is generated for an expense adjustment transaction or due to clearing.
CmrAccrualClrAmtsPEODestinationTypeCode	Value that identifies the destination type for material. Valid values are INVENTORY or EXPENSE.
CmrAccrualClrAmtsPEOEnteredAmount	Value that identifies the amount in user entered transaction currency.
CmrAccrualClrAmtsPEOEnteredApAccrualAmt	Value that identifies the invoice accrual amount in purchase order currency.
CmrAccrualClrAmtsPEOEnteredApNonrectaxAmt	Value that identifies the entered invoice nonrecoverable tax amount.
CmrAccrualClrAmtsPEOEnteredCmrAccrualAmt	Value that identifies the accrual amount in purchase order currency.
CmrAccrualClrAmtsPEOEnteredCmrNonrectaxAmt	Value that identifies the entered nonrecoverable tax amount.
CmrAccrualClrAmtsPEOEventTypeCode	Value that identifies the SLA event type as defined in CMR_RCV_EVENT_TYPES.
CmrAccrualClrAmtsPEOInventoryItemId	Value that identifies the inventory item defined on the purchase order line.
CmrAccrualClrAmtsPEOInventoryOrganizationId	Value that identifies the inventory organization.
CmrAccrualClrAmtsPEOInvoiceQty	Value that identifies the invoice quantity as reported by accounts payable.
CmrAccrualClrAmtsPEOLastUpdateDate	Date and time the row was most recently updated.
CmrAccrualClrAmtsPEOLastUpdateLogin	Session login associated with the user who last updated the row.
CmrAccrualClrAmtsPEOLastUpdatedBy	User who last updated the row.
CmrAccrualClrAmtsPEOLatestAccountingEventId	Value that identifies the latest accounting event.
CmrAccrualClrAmtsPEOLatestCmrApInvoiceDistId	Value that identifies the latest receipt accounting invoice distribution.
CmrAccrualClrAmtsPEOLatestTxnDate	Value that identifies the maximum transaction date from receiving transactions, invoices, and retro prices events.
CmrAccrualClrAmtsPEOLeTimezoneCode	Value that identifies the time zone code of the legal entity.
CmrAccrualClrAmtsPEOReceivedQty	Value that identifies the net received quantity as reported in receipt accounting.
CmrAccrualClrAmtsPEOReversalAccrualClrId	Value that identifies the reversal accrual clearing identifier. This is populated for accrual reversal events.
CmrAccrualClrAmtsPEOSoldToBusinessUnitId	Value that identifies the business unit where the invoice is created and the accrual is accounted.
CmrAccrualClrAmtsPEOTransactionTypeCode	Value that identifies the receipt accounting transaction type code.