Price lookup in attribute-based pricing
The Attribute-based Pricing feature allows defining a price lookup formula on the Product Rate Plan Charge object to identify the correct charge definition based on context during order preview.
With the Attribute-based Pricing feature, you can define a price lookup formula on the Product Rate Plan Charge object, which will be used to identify the correct and relevant charge definition based on the context. The price lookup formula is used during order preview to map the lookup attributes from the Account and Subscription objects to the Product Charge Definition object and assign a charge definition to the subscription rate plan charge.
The following graphic shows where to define the lookup formula in the UI. To define the price lookup formula for a product rate plan charge, use the Formula field in the Charge Amount section on the product rate plan charge detail page when you are creating a product rate plan charge.
Price lookup formula
The price lookup formula is defined in the following syntax:
lookup("field_name_on_charge_definition" =fieldLookup("other_object_name", "field_name"))where:
-
field_name_on_charge_definitionis the field on the product charge definition object. -
other_object_nameis another object that can be supported by price lookup. -
field_nameis the field name on another object whose value will be mapped to the charge definition object.
You can define as many field lookups as you want and separate them by commas. For supported lookup fields by the formula, see Supported lookup fields.
When defining the lookup formula, keep the following things in mind to avoid syntax errors:
-
The field name used in the formula must exactly match the API field name.
-
For custom fields, remember to add the suffix
__c(two underscores and the letter "c") at the end of the API name. -
Use straight double quotes ("") to embrace the object and field names.
-
Use a comma and space as separators.
-
Remember to add a space before and after the equal sign (=).
Examples
The following formula defined for a product rate plan charge is a simple example. It indicates the state custom field on the Product Charge Definition object will be used to identify the target charge definition, and its value is mapped from the state field on the account object.
lookup("state__c" = fieldLookup("account", "state__c")) The following formula is a more complex one. In this example, the market , variant , soldToRegion , termType , termPeriodType , and term fields on the Product Charge Definition object are used to identify the target charge definition. The field values are mapped either from the Account object or from the Subscription object.
lookup("market__c" = fieldLookup("account", "market__c"), "variant__c" = fieldLookup("subscription", "variant__c"), "soldToRegion__c" = fieldLookup("subscription", "soldToRegion__c"), "termType" = fieldLookup("subscription", "termType"), "termPeriodType" = fieldLookup("subscription", "initialTermPeriodType"), "term" = fieldLookup("subscription", "initialTerm"))Based on the formula, the lookup function will map the lookup attributes from corresponding objects to the attributes for the charge definition to identify the target charge definition.
-
If the lookup function finds only one charge definition that matches all these lookup attributes, this charge definition will be assigned to the subscription rate plan charge.
-
If the lookup function finds no charge definition that matches all the lookup attributes, it returns an error.
-
If more than one charge definition matches the lookup attributes, the lookup function returns an error.
When the matching charge definition is successfully identified, it will be displayed in the subscription that you are creating. As shown in the following graphic of creating a subscription, the CD-00001210 charge definition is identified and applied.