Receipt Accounting Distribution Entries

The Receipt Accounting Distribution Entries view object contains receipt accounting distribution subledger entries.

Data Store Key : FscmTopModelAM.ScmExtractAM.CmrBiccExtractAM.CmrRcvDistributionsExtractPVO

Primary Keys : CmrRcvDistributionsPEOCmrSubLedgerId

Initial Extract Date : CmrRcvDistributionsPEOCreationDate

Incremental Extract Date : CmrRcvDistributionsPEOLastUpdateDate

Attributes

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

Name Description
CmrRcvDistributionsPEOAccountedQty Value that identifies the accounted quantity in the source document unit of measure.
CmrRcvDistributionsPEOAccountingEventId Value that uniquely identifies the receiving accounting event and references CMR_RCV_EVENTS.ACCOUNTING_EVENT_ID.
CmrRcvDistributionsPEOAccountingLineType Value that identifies the accounting line type of the accounted transaction distribution line.
CmrRcvDistributionsPEOBalanceType Value that identifies the balance type. E is an Encumbrance entry.
CmrRcvDistributionsPEOCmrSubLedgerId Value that identifies the surrogate identifying the distribution line.
CmrRcvDistributionsPEOCodeCombinationId Value that uniquely identifies the account. Valid values are defined in the CMR_PURCHASE_ORDER_DTLS table.
CmrRcvDistributionsPEOCreatedBy User who created the row.
CmrRcvDistributionsPEOCreationDate Date and time the row was created.
CmrRcvDistributionsPEOEaEnteredCurrencyCode Value that identifies the currency code for encumbrance enabled orders.
CmrRcvDistributionsPEOEnteredCurrencyAmount Value that identifies the entered value in transaction currency.
CmrRcvDistributionsPEOEnteredCurrencyCode Value that identifies the transaction entered currency code.
CmrRcvDistributionsPEOEventCostId Value that uniquely identifies the event cost and references CMR_RCV_EVENT_COSTSS.EVENT_COST_ID.
CmrRcvDistributionsPEOEventId Value that uniquely identifies the SLA event. References XLA_EVENTS.EVENT_ID.
CmrRcvDistributionsPEOLastUpdateDate Date and time of the row was last updated.
CmrRcvDistributionsPEOLastUpdateLogin Session login associated with the user who last updated the row.
CmrRcvDistributionsPEOLastUpdatedBy User who most recently updated the row.
CmrRcvDistributionsPEOLedgerAmount Value that identifies the accounted value in ledger currency.
CmrRcvDistributionsPEOLedgerCurrencyCode Value that identifies the functional currency code and the ledger currency code of the profit center business unit.
CmrRcvDistributionsPEOLineNumber Value that identifies the accounted transaction distribution line number.
CmrRcvDistributionsPEOPjcTxnStatusCode Value that identifies project eligible transactions. Valid values are A, P, R and F. If A, then it's successfully interfaced to projects. If P, then it's interfaced to projects and waiting for project cost processing. If R, then it's rejected. If F, then it failed to interface.