Transfer Pricing Details

The Transfer Pricing Details view object stores the calculated accounting transfer prices.

Data Store Key : FscmTopModelAM.ScmExtractAM.FosBiccExtractAM.FosPricingDetailExtractPVO

Primary Keys : PricingDetailPEOPricingDetailId

Initial Extract Date : PricingDetailPEOCreationDate

Incremental Extract Date : PricingDetailPEOLastUpdateDate

Attributes

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

Name	Description
PricingDetailPEOAgreementFtrId	Value that identifies the foreign key to the Financial Routes view object.
PricingDetailPEOAsOnEffectiveDate	Date used for the pricing calculation.
PricingDetailPEOBasis	Value that identifies the basis used in calculating the unit price. Will be populated with one of the following values to identify the basis: PRICELIST, COST_BASED, or SOURCE_DOCUMENT_PRICE, based on FOS_TRANSFER_PRICE_OPTIONS lookup.
PricingDetailPEOChargeId	Value that identifies the cost component ID that corresponds to the unit price. This value will be NULL if the unit price wasn't calculated by the Pricing application.
PricingDetailPEOConversionType	Value that identifies the conversion type used for currency exchange.
PricingDetailPEOCreatedBy	User who created the transfer pricing detail.
PricingDetailPEOCreationDate	Date when the transfer pricing detail was created.
PricingDetailPEOCurrencyCode	Value that identifies the currency code which corresponds to the unit price.
PricingDetailPEODocumentId	Value that identifies the source document identifier for which the unit price was calculated. For example, in procurement it would store the PO_LINE_LOCATION_ID, for distributed order orchestration it would store the FULFILLMENT_LINE_DETAIL_ID and for internal material transfers it would store the LINE_ID.
PricingDetailPEODocumentType	Value that identifies the type of the document for which the unit price was calculated. Valid values are contained within the FOS_IMT_DOCUMENT_TYPES, FOS_PROCUREMENT_DOCUMENT_TYPES, and FOS_SHIPMENT_DOCUMENT_TYPES lookup types.
PricingDetailPEOEnterpriseId	Value that identifies the enterprise that's used for multiple tenancy partitioning.
PricingDetailPEOEventDataId	Value that's used as an event identifier which is received in the payload of the event.
PricingDetailPEOEventDefinitionId	This is a foreign key reference for the event definition type from the Event Definitions view object.
PricingDetailPEOLastUpdateDate	Date when the transfer pricing detail was last updated.
PricingDetailPEOLastUpdateLogin	Session login associated with the user who last updated the transfer pricing detail.
PricingDetailPEOLastUpdatedBy	User who last updated the transfer pricing detail.
PricingDetailPEOObjectVersionNumber	Value that's used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
PricingDetailPEOPriceElementCode	Value that identifies the price element code that corresponds to the unit price.
PricingDetailPEOPriceType	Value that identifies the unit price calculated. Will be populated with one of the following values to identify the unit price type: ACCOUNTING, SELLER, or BUYER.
PricingDetailPEOPricingDetailId	Value that identifies the primary key of the transfer pricing details view object.
PricingDetailPEOPricingId	Value that identifies the foreign key to the Transfer Pricing Rules view object.
PricingDetailPEOReferenceInformation	Value that identifies the references from Pricing such as the Pricing Strategy identifier.
PricingDetailPEOSourceSystemId	Value that identifies the system that created the document for which the Transfer Pricing Details view object record is based.
PricingDetailPEOUnitOfMeasure	Value that identifies the unit of measure that corresponds to the unit price.
PricingDetailPEOUnitPrice	Value that identifies the net unit price or charge component value calculated for a given systems document ID and document type. This unit price can correspond to either an accounting transfer price or seller's assessable value, or the buyer's assessable value when the cost component code is equal to NetTransferPrice. When the cost component code is set to anything else, it indicates that the unit price is for a charge component.