ExternalPricingKeyValue

Represents a single resolved pricing condition record in the Penny Perfect Pricing engine, a specific, priced combination of key attribute values (a “pricing condition”) produced when a Pricing Search Strategy resolves a Pricing Specification against a given context (account, product, unit of measure, date range, and so on). This object is available in API version 68.0 and later.

Supported Calls 

create(), delete(), describeLayout(), describeSObjects(), getDeleted(), getUpdated(), query(), retrieve(), undelete(), update(), upsert()

Special Access Rules 

Available only in orgs with the Manufacturing Cloud, Automotive Cloud, or Consumer Goods Cloud Penny Perfect Pricing feature enabled.

Fields 

AccountId 

Type: reference

Properties: Create, Filter, Group, Nillable, Sort, Update

Description: The account this pricing condition record applies to, when the condition is scoped to a specific customer account. This field is a relationship field.

Relationship Name: Account

Refers To: Account

BaseQuantity 

Type: double

Properties: Create, Filter, Nillable, Sort, Update

Description: The quantity denominator used when calculating the price for this condition (for example, price per 100 units). Corresponds to the “Denominator” concept in the pricing engine.

CurrencyIsoCode 

Type: picklist

Properties: Create, Defaulted on create, Filter, Group, Nillable, Restricted picklist, Sort, Update

Description: The ISO currency code for the monetary fields on this record. Possible values are: AED (UAE Dirham), USD (U.S. Dollar), and every other active currency ISO code configured for the org. The default value is USD.

DistributionCategory 

Type: picklist

Properties: Create, Filter, Group, Nillable, Restricted picklist, Sort, Update

Description: Indicates which entity this pricing condition is distributed or scoped to. Possible values are Account and All.

ExternalPricingKeyTypeId 

Type: reference

Properties: Create, Filter, Group, Sort, Update

Description: References the Expression Set (rules-engine runtime artifact) that represents the Pricing Key Type used to define this condition’s key attribute structure. This field is a relationship field.

Relationship Name: ExternalPricingKeyType

Refers To: ExpressionSet

ExternalPricingSpecId 

Type: reference

Properties: Create, Filter, Group, Sort, Update

Description: References the Expression Set (rules-engine runtime artifact) that represents the Pricing Specification (Pricing Condition Template) this condition record was generated from. This field is a relationship field.

Relationship Name: ExternalPricingSpec

Refers To: ExpressionSet

InternalOrganizationUnitId 

Type: reference

Properties: Create, Filter, Group, Nillable, Sort, Update

Description: The internal organization unit (business unit or org unit) that owns or scopes this pricing condition. This field is a relationship field.

Relationship Name: InternalOrganizationUnit

Refers To: InternalOrganizationUnit

KeyValue01 – KeyValue10 

Type: string

Properties: Create, Filter, Group, Nillable, Sort, Update

Description: Ten generic key-value slots holding the actual attribute values (for example, product code, customer group, region) that make up this condition’s unique pricing key, as defined by the associated Pricing Key Type.

LastReferencedDate 

Type: dateTime

Properties: Filter, Nillable, Sort

Description: The timestamp when the current user last accessed this record or a related record.

LastViewedDate 

Type: dateTime

Properties: Filter, Nillable, Sort

Description: The timestamp when the current user last viewed this record.

MergedKeyValue 

Type: textarea

Properties: None

Description: The concatenated/merged representation of all populated KeyValue fields, generated and used internally for fast key matching during price search.

Name 

Type: string

Properties: Autonumber, Defaulted on create, Filter, idLookup, Sort

Description: The autonumber name that uniquely identifies this pricing condition record.

OwnerId 

Type: reference

Properties: Create, Defaulted on create, Filter, Group, Sort, Update

Description: The user or queue that owns this record. This field is a polymorphic relationship field.

Relationship Name: Owner

Refers To: Group, User

PricingValue 

Type: double

Properties: Create, Filter, Nillable, Sort, Update

Description: The resolved price or pricing amount associated with this condition.

ProductReferenceRecordId 

Type: reference

Properties: Create, Filter, Group, Nillable, Sort, Update

Description: The product or product category this pricing condition applies to. This field is a relationship field.

Relationship Name: ProductReferenceRecord

Refers To: Product2, ProductCategory

ProductUnitofMeasureId 

Type: reference

Properties: Create, Filter, Group, Nillable, Sort, Update

Description: The unit of measure the pricing value is expressed in. This field is a relationship field.

Relationship Name: ProductUnitofMeasure

Refers To: UnitOfMeasure

SourceSystemIdentifier 

Type: string

Properties: Create, Filter, Group, Nillable, Sort, Update

Description: An external identifier used to correlate this record with the same pricing condition in an external or source system.

Status 

Type: picklist

Properties: Create, Filter, Group, Nillable, Restricted picklist, Sort, Update

Description: The lifecycle status of this pricing condition record. Possible values are Deleted, New, and Updated.

TierProductUnitofMeasureId 

Type: reference

Properties: Create, Filter, Group, Nillable, Sort, Update

Description: The unit of measure used for tiered/scale pricing on this condition, when scale pricing (via ExternalPricingKeyValTier) applies. This field is a relationship field.

Relationship Name: TierProductUnitofMeasure

Refers To: UnitOfMeasure

UniqueKeyHashValue 

Type: string

Properties: Filter, Group, Sort

Description: A hash of the merged key value, generated and used internally to enforce uniqueness and speed up lookups during price search.

UniqueKeyValue 

Type: textarea

Properties: None

Description: The full unique key string this condition record is indexed and matched by, generated and used internally.

ValidFrom 

Type: date

Properties: Create, Filter, Group, Nillable, Sort, Update

Description: The date this pricing condition becomes effective.

ValidTo 

Type: date

Properties: Create, Filter, Group, Nillable, Sort, Update

Description: The date this pricing condition expires.

Associated Objects 

This object has the following associated objects. If the API version isn’t specified, they’re available in the same API versions as this object. Otherwise, they’re available in the specified API version and later.