Documentation

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