Trade Event Average Costs

The Trade Event Average Costs view object contains the average cost of trade receipt accrual transactions.

Data Store Key : FscmTopModelAM.ScmExtractAM.CmrBiccExtractAM.CmrTradeEventAvgCostExtractPVO

Primary Keys : CmrTradeEventAvgCostPEOTradeEventAvgCostId

Initial Extract Date : CmrTradeEventAvgCostPEOCreationDate

Incremental Extract Date : CmrTradeEventAvgCostPEOLastUpdateDate

Attributes

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

Name	Description
CmrTradeEventAvgCostPEOActiveFlag	Value that identifies if the record is active. The most recent active record will be set to Y.
CmrTradeEventAvgCostPEOBusinessUnitId	Value that identifies the profit center business unit for nonsupplier nodes in advanced flows.
CmrTradeEventAvgCostPEOCreatedBy	User who created the row.
CmrTradeEventAvgCostPEOCreationDate	Date and time the row was created.
CmrTradeEventAvgCostPEOCurrencyConversionRate	Value that identifies the trade event currency conversion rate used to calculate the ledger amount.
CmrTradeEventAvgCostPEODooFullfillLineId	Value that identifies the reference to the sales order fulfillment line. It's used in drop shipment cases.
CmrTradeEventAvgCostPEOEffectiveDate	Value that identifies the average cost recalculate date based on the new cost.
CmrTradeEventAvgCostPEOExtendedAmount	Value that identifies the transfer value in transactional unit of measure interfaced by Oracle Fusion Supply Chain Financial Orchestration.
CmrTradeEventAvgCostPEOExternalSystemReference	Value that identifies the external system reference of the transaction.
CmrTradeEventAvgCostPEOInterOrgShipmentInvTxnId	Value that identifies the transaction ID for interorganization shipping.
CmrTradeEventAvgCostPEOLastUpdateDate	Date and time the row was most recently updated.
CmrTradeEventAvgCostPEOLastUpdateLogin	Value that indicates the session login associated to the user who last updated the row.
CmrTradeEventAvgCostPEOLastUpdatedBy	User who last updated the row.
CmrTradeEventAvgCostPEONewAverageCost	Value that identifies the latest average cost in functional currency at the document identifier level.
CmrTradeEventAvgCostPEONewOnhandQty	Value that identifies the source document net new on-hand quantity.
CmrTradeEventAvgCostPEOOwnershipChangeEventType	Value that identifies the event type associated with the ownership change transaction.
CmrTradeEventAvgCostPEOOwnershipChangeTxnId	Value that identifies the transaction that triggered the ownership change. Valid values include ASN, Customer Clearance, Supplier Acceptance, and Transfer to Regular Transaction.
CmrTradeEventAvgCostPEOPoLineLocationId	Value that identifies the purchase order line location. This acts as a document identifier for purchase order flows in complex flows.
CmrTradeEventAvgCostPEOPrimaryUomCode	Value that identifies the primary unit of measure code from trade events.
CmrTradeEventAvgCostPEOPriorAverageCost	Value that identifies the unit cost at the source document of the prior active cost record.
CmrTradeEventAvgCostPEOPriorOnhandQty	Value that identifies the on-hand quantity at source document of prior active cost record.
CmrTradeEventAvgCostPEOPriorTradeEventAvgCostId	Value that identifies the average cost of the prior trade event.
CmrTradeEventAvgCostPEOTradeEventAvgCostId	Value that identifies the average cost of the trade event.
CmrTradeEventAvgCostPEOTradeInventoryOrgId	Value that identifies the trade inventory organization where the financial obligation is created with advanced flow set ups.
CmrTradeEventAvgCostPEOTransactionCost	Value that identifies the trade event transaction cost in the entered currency code.
CmrTradeEventAvgCostPEOTransferPricingUnitCost	Value that identifies the unit cost in the transfer price unit of measure code for trade events.
CmrTradeEventAvgCostPEOTransferPricingUomCode	Value that identifies the unit of measure code of the transfer price unit cost.
CmrTradeEventAvgCostPEOTxnCurrencyCode	Value that identifies the trade event source transaction currency code.