Accrual Reconciliation Details

The Accrual Reconciliation Details view object contains accrual clearing event details.

Data Store Key : FscmTopModelAM.ScmExtractAM.CmrBiccExtractAM.CmrAccrReconcDtlsExtractPVO

Primary Keys : CmrAccrReconcDtlsPEOCmrAccrReconcDtlId

Initial Extract Date : CmrAccrReconcDtlsPEOCreationDate

Incremental Extract Date : CmrAccrReconcDtlsPEOLastUpdateDate

Attributes

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

Name	Description
CmrAccrReconcDtlsPEOAccountingEventId	Value that identifies the accounting event of purchase order transactions and is a foreign key column to table CMR_RCV_EVENTS.
CmrAccrReconcDtlsPEOAccrualClrId	Value that uniquely identifies the accrual clearing. It's populated only if the transaction is either an automatic or manual accrual clearing event from CMR.
CmrAccrReconcDtlsPEOCmrAccrReconcDtlId	Value that uniquely identifies the accrual reconciliation detail and surrogate key column.
CmrAccrReconcDtlsPEOCmrAccrReconcHeaderId	Value that identifies the CMR accrual reconciliation header. This is a foreign key column to CMR_ACCR_RECONC_HEADERS.
CmrAccrReconcDtlsPEOCmrRcvTransactionId	Value that identifies the receiving transaction.
CmrAccrReconcDtlsPEOCmrSubLedgerId	Value that identifies the distribution identifier of purchase order transactions and is a foreign key column to table CMR_RCV_DISTIRBUTIONS.
CmrAccrReconcDtlsPEOCreatedBy	User who created the row.
CmrAccrReconcDtlsPEOCreationDate	Date and time the row was created.
CmrAccrReconcDtlsPEOCurrencyCode	Value that identifies currency of the event.
CmrAccrReconcDtlsPEOCurrencyConversionDate	Date used to determine the exchange rates for the currency conversion.
CmrAccrReconcDtlsPEOCurrencyConversionRate	Value that identifies the optional user specified currency conversion rate.
CmrAccrReconcDtlsPEOCurrencyConversionType	Conversion type that should be used for the currency conversion.
CmrAccrReconcDtlsPEOEventAccountedAmt	Value that identifies the source event transaction accounted amount in functional currency.
CmrAccrReconcDtlsPEOEventCostId	Value that identifies the event cost of purchase order receipts and is a foreign key column to table CMR_RCV_EVENT_COSTS.
CmrAccrReconcDtlsPEOEventDistributionType	Value that identifies the distribution type of an event of purchase order transactions.
CmrAccrReconcDtlsPEOEventEnteredAmt	Value that identifies the source event transaction entered amount in the user specified currency. This will be different if the user transacts in a currency other than the functional currency.
CmrAccrReconcDtlsPEOEventQty	Value that identifies the source event transaction accounted quantity.
CmrAccrReconcDtlsPEOEventTransactionDate	Value that identifies the event transaction date on which this event is accounted and posted to SLA.
CmrAccrReconcDtlsPEOEventTransactionNumber	Value that identifies the event transaction number of purchase order transactions such as receipt, purchase order number, or invoice number.
CmrAccrReconcDtlsPEOEventTypeCode	Value that identifies the SLA event type as defined in CMR_RCV_EVENT_TYPES.
CmrAccrReconcDtlsPEOEventUomCode	Value that identifies the event unit of measure for the quantity.
CmrAccrReconcDtlsPEOInvoiceDistributionId	Value that identifies the invoice distribution. This is populated only if the invoice transaction is from account payables.
CmrAccrReconcDtlsPEOLastUpdateDate	Date and time the row was last updated.
CmrAccrReconcDtlsPEOLastUpdateLogin	Session login associated with the user who last updated the row.
CmrAccrReconcDtlsPEOLastUpdatedBy	User who last updated the row.
CmrAccrReconcDtlsPEOSlaAeHeaderId	Value that uniquely identifies the SLA header. This is a foreign key relationship to XLA_AE_HEADERS.
CmrAccrReconcDtlsPEOSlaAeLineNum	Value that identifies the SLA line number. This is a foreign key to XLA_AE_LINES.
CmrAccrReconcDtlsPEOSlaEventId	Value that uniquely identifies the SLA event purchase order transaction and is a foreign key column to XLA_EVENTS.
CmrAccrReconcDtlsPEOTradeEventId	Value that identifies the trade event on a purchase order with multiple nodes and is a foreign key column to the CMR_TRANSACTIONS table.
CmrAccrReconcDtlsPEOTransactionTypeCode	Value that identifies the receipt accounting transaction type code.