Pricing Services Data Model

Table of Contents

Data Diagram

Data Diagram

The following data shows the key tables used by the Pricing Service.

PriceList (BLC_PRICE_LIST)

The price list is the primary entity in the pricing service. It defines the key attributes and context rules for the price list.

Field	Description
ID	Unique Id for the Price List
CONTEXT_ID	Logical id of the price list shared between records being modified in sandboxes
NAME	Name of this price list
ACTIVE_START_DATE	Start date this price list is active
ACTIVE_END_DATE	End date this price list is active
TYPE	One of STANDARD, SALE, or CONTRACT
PRICE_CONTEXT_CRITERIA	Rule determining when this price list applies
USE_MODIFIER	Indicator if this Price List uses price modifiers
PRICE_MODIFIER_AMOUNT	Numeric operator when using price modifier
PRICE_MODIFIER_TYPE	One of PERCENTAGE, MULTIPLICATION, ADDITION, or SUBTRACTION
USE_TARGETS	Indicator if this price list is using user targets
PRIORITY	Lower priority within a type wins (nulls last)

Field

Description

Unique Id for the Price List

CONTEXT_ID

Logical id of the price list shared between records being modified in sandboxes

NAME

Name of this price list

ACTIVE_START_DATE

Start date this price list is active

ACTIVE_END_DATE

End date this price list is active

TYPE

One of STANDARD, SALE, or CONTRACT

PRICE_CONTEXT_CRITERIA

Rule determining when this price list applies

USE_MODIFIER

Indicator if this Price List uses price modifiers

PRICE_MODIFIER_AMOUNT

Numeric operator when using price modifier

PRICE_MODIFIER_TYPE

One of PERCENTAGE, MULTIPLICATION, ADDITION, or SUBTRACTION

USE_TARGETS

Indicator if this price list is using user targets

PRIORITY

Lower priority within a type wins (nulls last)

PriceData (BLC_PRICE_DATA)

When a price list contains separate entries for each SKU (or other price target) the values are stored in the BLC_PRICE_DATA table.

Field	Description
ID	Unique Id for the Price Data
CONTEXT_ID	Logical id of the price data
PRICE_LIST_ID	Ref to the containing price list
PRICE_LIST_NAME	Possibly stale copy of PriceList name for convenient display in admin grids
PRICEABLE_TARGET_TYPE	The type of target being priced (typically SKU)
PRICEABLE_CONTEXT_ID	The id for the item being priced
PRICE	The price for this record
ACTIVE_START_DATE	Start date this price data is active, blank is active
ACTIVE_END_DATE	End date this price data is active, blank is active
PRICE_DATA_TIERS	Structure to allow price based on quantity tiers

Field

Description

Unique Id for the Price Data

CONTEXT_ID

Logical id of the price data

PRICE_LIST_ID

Ref to the containing price list

PRICE_LIST_NAME

Possibly stale copy of PriceList name for convenient display in admin grids

PRICEABLE_TARGET_TYPE

The type of target being priced (typically SKU)

PRICEABLE_CONTEXT_ID

The id for the item being priced

PRICE

The price for this record

ACTIVE_START_DATE

Start date this price data is active, blank is active

ACTIVE_END_DATE

End date this price data is active, blank is active

PRICE_DATA_TIERS

Structure to allow price based on quantity tiers

UserTarget (BLC_PRICE_USER_TARGET)

Stores relationships between a price lists and specific qualifying user segments or accounts.

Field	Description
PRICE_LIST_ID	Key to parent price list
TARGET_VALE	Reference to the user target (typically id)
TARGET_TYPE	Type of user target (ACCOUNT or CUSTOMER_SEGMENT)

Field

Description

PRICE_LIST_ID

Key to parent price list

TARGET_VALE

Reference to the user target (typically id)

TARGET_TYPE

Type of user target (ACCOUNT or CUSTOMER_SEGMENT)

Broadleaf Common Data Features

Price list entities are Application Trackable and Sandbox Trackable - to allow application specific price lists and the ability to modify price lists using the preview and approval workflows.