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

Order Detail

Detailed ERD

Order Detail

Tables

Table Related Entity Description
BLC_BUNDLE_ORDER_ITEM BundleOrderItem Contains a group of discrete order items
BLC_BUND_ITEM_FEE_PRICE BundleOrderItemFeePrice Contains fee information for a bundle order item
BLC_DISCRETE_ORDER_ITEM DiscreteOrderItem Contains product, sku, and pricing information for an item on an order
BLC_DISC_ITEM_FEE_PRICE DiscreteOrderItemFeePrice Contains fee information for a discrete order item
BLC_DYN_DISCRETE_ORDER_ITEM DynamicPriceDiscreteOrderItem Contains discrete order item information that is dynamically priced
BLC_FG_ADJUSTMENT FulfillmentGroupAdjustment Contains offer information and amount applied to a fulfillment group
BLC_GIFTWRAP_ORDER_ITEM GiftWrapOrderItem Declares which discrete order items are gift-wrapped
BLC_ORDER Order Represents an order in Broadleaf
BLC_ORDER_ADJUSTMENT OrderAdjustment.java Contains offer information and amount applied to an order
BLC_ORDER_ATTRIBUTE OrderAttribute Contains arbitrary data about an order
BLC_ORDER_ITEM OrderItem An abstract representation of an item on an order
BLC_ORDER_ITEM_ADD_ATTR n/a Contains arbitrary data about a discrete order item
BLC_ORDER_ITEM_ADJUSTMENT OrderItemAdjustment Contains offer information and amount applied to an order item
BLC_ORDER_ITEM_ATTRIBUTE OrderItemAttribute Contains arbitrary data about an order item
BLC_ITEM_OFFER_QUALIFIER OrderItemQualifier Contains data about order item qualifies
BLC_ORDER_ITEM_PRICE_DTL OrderItemPriceDetailImpl Contains order item price detail information
BLC_ORDER_ITEM_DTL_ADJ OrderItemPriceDetailAdjustmentImpl Contains order item price detail adjustment information
BLC_PERSONAL_MESSAGE PersonalMessage Contains personal message information (e.g. from, to, message body)
BLC_ORDER_MULTISHIP_OPTION OrderMultishipOption Represents a given set of options for an OrderItem in an Order in the multiship context
BLC_ORDER_OFFER_CODE_XREF n/a Cross-reference from orders to offers
Table Related Entity Description
BLC_ADDRESS Address Contains address information, e.g. city, state, and postal code
BLC_CATEGORY Category Represents a category
BLC_CUSTOMER Customer Represents a customer in Broadleaf
BLC_FULFILLMENT_OPTION FulfillmentOption Holds information about a particular fulfillment implementation
BLC_FULFILLMENT_GROUP FulfillmentGroup Holds fulfillment information about an order
BLC_OFFER Offer Contains adjustment information and rules
BLC_PRODUCT Product Contains product information
BLC_PRODUCT_BUNDLE ProductBundle Contains data about a product bundle, e.g. bundle pricing
BLC_SKU Sku Contains information about an item that can be sold
BLC_SKU_BUNDLE_ITEM SkuBundleItem Contains bundle item metadata
BLC_CURRENCY BroadleafCurrency Contains currency information, such as code and if it's default
BLC_LOCALE Locale Contains locale information, such as code and if it's default