Transfer Pricing Rules

The Transfer Pricing Rules view object stores the details of the pricing options used to determine the accounting transfer price.

Data Store Key : FscmTopModelAM.ScmExtractAM.FosBiccExtractAM.FosPricingOptionExtractPVO

Primary Keys : PricingOptionDPEOEffectiveStartDate, PricingOptionDPEOPricingId, PricingOptionDPEOEffectiveEndDate

Initial Extract Date : PricingOptionDPEOCreationDate

Incremental Extract Date : PricingOptionDPEOLastUpdateDate

Attributes

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

Name	Description
PricingOptionDPEOCreatedBy	User who created the transfer pricing rule.
PricingOptionDPEOCreationDate	Date when the transfer pricing rule was created.
PricingOptionDPEOEffectiveEndDate	Date Effective Entity: indicates the date at the end of the date range within which the row is effective.
PricingOptionDPEOEffectiveStartDate	Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.
PricingOptionDPEOEnterpriseId	Identifier of Enterprise, used for multiple tenancy partitioning.
PricingOptionDPEOLastUpdateDate	Date when the transfer pricing rule was last updated.
PricingOptionDPEOLastUpdateLogin	Session login associated to the user who last updated the transfer pricing rule.
PricingOptionDPEOLastUpdatedBy	User who last updated the transfer pricing rule.
PricingOptionDPEOObjectVersionNumber	Number of times the transfer pricing rule has been updated.
PricingOptionDPEOPricingId	This is the primary key of the transfer pricing rules view object.
PricingOptionDPEOPricingOptionDescription	A brief description of the pricing option.
PricingOptionDPEOPricingOptionName	The unique name given to a pricing option.
PricingOptionDPEOSeedDataSource	Value that identifies the source of the seed data record. A value of BULK_SEED_DATA_SCRIP indicates that the record was bulk loaded. Otherwise, it specifies the name of the seed data file.
PricingOptionDPEOTpItemCostBasisFlag	Contains one of the following values: Y or N. If Y, then the item cost basis radio button is selected and item cost is chosen as basis to calculate transfer price. The default value is N.
PricingOptionDPEOTpItemCostMarkupValue	Value that identifies the mark up value on item cost.
PricingOptionDPEOTransferPriceCostBasisMarkupType	Value that identifies the markup type selected by the user on transaction cost in the Accounting Transfer Price tab.
PricingOptionDPEOTransferPriceCostBasisMarkupValue	Contains one of the following values: Y or N. If Y, then the transaction source document price basis checkbox is checked and source document is chosen as basis to calculate transfer price on the Accounting Transfer Price tab. The default value is N.
PricingOptionDPEOTransferPriceSourceDocMarkupType	Value that identifies the markup type selected by the user on source document price in the Accounting Transfer Price tab.
PricingOptionDPEOTransferPriceSourceDocumentMarkupValue	Value that identifies standard markup value on source document price if standard markup is chosen as markup type in the Accounting Transfer Price tab.
PricingOptionDPEOTransferPriceSourceDocumentPriceBasisFlag	Contains one of the following values: Y or N. If Y, then the transaction source document price basis checkbox is checked and source document is chosen as a basis to calculate the transfer price in the Accounting Transfer Price tab. The default value is N.
PricingOptionDPEOTransferPriceTransactionCostBasisFlag	Contains one of the following values: Y or N. If Y, then the transaction cost basis checkbox is checked and cost is chosen as basis to calculate transfer price in the Accounting Transfer Price tab. Its default value is N.