PricingRules
Defines rules for applying pricing logic across different products or conditions.
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | String | True |
Unique identifier for the pricing rule. |
| Pricing Rule Type | String | True |
The type of pricing rule, such as discount or promotional rule. |
| Global ID | String | True |
A globally unique identifier for the pricing rule used across systems. |
| Link | String | False |
A URL or link to more detailed information regarding the pricing rule. |
| Pricing Rule Name | String | False |
The name of the pricing rule. |
| Status | String | False |
The current status of the pricing rule, such as active or inactive. |
| Created By | String | True |
The identifier of the person or system that created the pricing rule. |
| Created Date | Datetime | True |
The date and time when the pricing rule was created. |
| Last Modified By | String | True |
The identifier of the person or system that last modified the pricing rule. |
| Last Modified Date | Datetime | True |
The date and time when the pricing rule was last modified. |
| Account Group | String | False |
The account group associated with the pricing rule. |
| Active | Bool | False |
Indicates whether the pricing rule is active or inactive. |
| Chain Rule Operator | String | False |
The operator used in a chain rule, if applicable (for example, AND or OR). |
| Chain Rule | Bool | False |
Indicates whether the pricing rule is part of a chain rule. |
| Comparison Type | String | False |
The type of comparison used in the pricing rule, such as equal or greater than. |
| Cross_Product_Rule | Bool | False |
Indicates whether the pricing rule applies across multiple products. |
| Delivery End Date | Date | False |
The end date for the delivery under the pricing rule. |
| Delivery Order | Bool | False |
Indicates whether the delivery is part of the pricing rule. |
| Delivery Start Date | Date | False |
The start date for the delivery under the pricing rule. |
| Discount Override Max | Double | False |
The maximum allowed override for the discount under the pricing rule. |
| Discount Override | Double | False |
The amount by which the discount can be overridden. |
| End Date | Date | False |
The date when the pricing rule ends. |
| External Id | String | False |
An external identifier for the pricing rule. |
| Free Goods Max | Decimal | False |
The maximum value of free goods under the pricing rule. |
| Free Goods Percentage Max | Double | False |
The maximum percentage of free goods allowed under the pricing rule. |
| Free Goods Percentage | Double | False |
The percentage of free goods granted under the pricing rule. |
| Free Goods | Decimal | False |
The total amount of free goods granted under the pricing rule. |
| Limit Bound | Bool | False |
Indicates whether the pricing rule has a limit bound. |
| List Price | Decimal | False |
The list price of the product under the pricing rule. |
| List Price Corp | Decimal | True |
The corporate list price of the product under the pricing rule. |
| Local Currency | String | False |
The local currency used for the pricing rule. |
| Minimum Delivery Time Frame | Decimal | False |
The minimum delivery time frame allowed under the pricing rule. |
| Net Price Min | Decimal | False |
The minimum net price allowed under the pricing rule. |
| Net Price Min Corp | Decimal | True |
The minimum corporate net price allowed under the pricing rule. |
| Net Price | Decimal | False |
The net price under the pricing rule. |
| Net Price Corp | Decimal | True |
The corporate net price under the pricing rule. |
| Payment Max | String | False |
The maximum payment allowed under the pricing rule. |
| Payment | String | False |
The payment terms under the pricing rule. |
| Price Book | String | False |
The price book associated with the pricing rule. |
| Pricing Group | String | False |
The pricing group associated with the pricing rule. |
| Product Comparison Type | String | False |
The type of product comparison used in the pricing rule. |
| Product Maximum | Decimal | False |
The maximum allowed price for the product under the pricing rule. |
| Product Minimum | Decimal | False |
The minimum allowed price for the product under the pricing rule. |
| Maximum Quantity | Decimal | False |
The maximum quantity allowed under the pricing rule. |
| Minimum Quantity | Decimal | False |
The minimum quantity required for the pricing rule. |
| Rule Description | String | False |
A description of the pricing rule. |
| Start Date | Date | False |
The date when the pricing rule starts. |
| Suggested Retail Price | Decimal | False |
The suggested retail price of the product under the pricing rule. |
| Suggested Retail Price Corp | Decimal | True |
The corporate suggested retail price under the pricing rule. |
| Suggestion Text | String | False |
Text describing the pricing suggestion under the rule. |
| Suggestion Threshold | Decimal | False |
The threshold at which the pricing suggestion is applied. |
| Account | String | False |
The account associated with the pricing rule. |
| Comparison_Product | String | False |
The product used for comparison in the pricing rule. |
| Contract | String | False |
The contract associated with the pricing rule. |
| Order Campaign | String | False |
The order campaign linked to the pricing rule. |
| Product | String | False |
The product associated with the pricing rule. |
| Owner | String | False |
The owner of the pricing rule. |
| Discount | Double | True |
The discount applied under the pricing rule. |
| Legacy CRM Id | String | False |
The identifier used in the legacy CRM system for tracking this pricing rule. |
| Include All Preferred Deliveries | Bool | False |
Indicates whether all preferred deliveries are included in the pricing rule. |
| Preferred Delivery End Date | Date | False |
The end date for preferred delivery under the pricing rule. |
| Preferred Delivery Start Date | Date | False |
The start date for preferred delivery under the pricing rule. |
| Pricing Rule Key | String | False |
A unique key identifying the pricing rule. |