Documentation Home
Database Model Order Fulfillment
This version of the framework is no longer supported. View the latest documentation.

Order Fulfillment

Detailed ERD

Order Fulfillment

Tables

Table Related Entity Description
BLC_DYN_DISCRETE_ORDER_ITEM DynamicPriceDiscreteOrderItem Contains discrete order item information that is dynamically priced
BLC_FULFILLMENT_GROUP FulfillmentGroup Holds fulfillment information about an order
BLC_FULFILLMENT_GROUP_FEE FulfillmentGroupFee Contains fee information for a fulfillment group
BLC_FULFILLMENT_GROUP_ITEM FulfillmentGroupItem Contains information for items in a fulfillment group
BLC_FULFILLMENT_OPTION FulfillmentOption Holds information about a particular fulfillment implementation
BLC_FULFILLMENT_OPTION_FIXED FixedPriceFulfillmentOption Contains single-price data for order fulfillment
BLC_FULFILLMENT_OPT_BANDED_PRC BandedPriceFulfillmentOption Contains fulfillment option data by price band
BLC_FULFILLMENT_OPT_BANDED_WGT BandedWeightFulfillmentOption Contains fulfillment option data by weight band
BLC_FULFILLMENT_PRICE_BAND FulfillmentPriceBand Contains pricing bands based on retail price of a fulfillment group
BLC_FULFILLMENT_WEIGHT_BAND FulfillmentWeightBand Contains pricing bands based on weight of a fulfillment group
Table Related Entity Description
BLC_ADDRESS Address Contains address information, e.g. city, state, and postal code
BLC_ORDER Order Represents an order in Broadleaf
BLC_PERSONAL_MESSAGE PersonalMessage Contains personal message information (e.g. from, to, message body)
BLC_PHONE Phone Represents a phone number in broadleaf
BLC_ORDER_ITEM OrderItem An abstract representation of an item on an order
BLC_CURRENCY BroadleafCurrency Contains currency information, such as code and if it's default