Database Model
2.3 to 3.0 Model Changes
- In Customer
- New Fields in
BLC_ADDRESS: ADDRESS_LINE3 - New Fields in
BLC_CUSTOMER: TAX_EXEMPTION_CODE
- New Fields in
- In Admin
- New Fields in `BLC_ADMIN_SECTION': CEILING_ENTITY, DISPLAY_ORDER
- New Fields in `BLC_SITE': ARCHIVED, DEACTIVATED
- New Table:
BLC_CATALOG - New Table:
BLC_SITE_CATALOG
- In Common
- New Fields in
BLC_LOCALE: IS_TRANSLATABLE - New Table:
BLC_TRANSLATION - New Table:
BLC_MODULE_CONFIGURATION
- New Fields in
- In Category
- New Fields in
BLC_CATEGORY: TAX_CODE
- New Fields in
- In Product
- New Fields in
BLC_PRODUCT: TAX_CODE - New Fields in
BLC_PRODUCT_OPTION: ERROR_CODE, ERROR_MESSAGE, VALIDATION_TYPE, USE_IN_SKU_GENERATION, VALIDATION_STRING
- New Fields in
- In Sku
- New Fields in
BLC_SKU: TAX_CODE, CURRENCY_CODE
- New Fields in
- In Fulfillment
- New Fields in
BLC_FULFILLMENT_OPTION: TAX_CODE, TAXABLE
- New Fields in
- In Tax
- New Fields in
BLC_TAX_DETAIL: TAX_COUNTRY, JURISDICTION_NAME, TAX_REGION, TAX_NAME, MODULE_CONFIG_ID
- New Fields in
- In Offer
- New Fields in
BLC_OFFER: AUTOMATICALLY_ADDED
- New Fields in
- In Static Asset
- New Fields in
BLC_STATIC_ASSET: ALT_TEXT, STORAGE_TYPE, TITLE
- New Fields in
2.2 to 2.3 Model Changes
- In Customer
- New Fields in
BLC_ADDRESS: PHONE_FAX_ID, PHONE_PRIMARY_ID, PHONE_SECONDARY_ID - New Fields in
BLC_CUSTOMER_PAYMENT: IS_DEFAULT
- New Fields in
- In Fulfillment
- New Fields in
BLC_FULFILLMENT_GROUP: FULFILLMENT_GROUP_SEQUNCE - New Fields in
BLC_FULFILLMENT_GROUP_ITEM: PRORATED_ORDER_ADJ, TAXABLE_PRORATED_ORDER_ADJ, TOTAL_ITEM_AMOUNT, TOTAL_ITEM_TAXABLE_AMOUNT
- New Fields in
- In Offer
- New Fields in
BLC_OFFER: MARKETING_MESSASGE
- New Fields in
- In [[Order | Order]]
- New Table: BLC_ITEM_OFFER_QUALIFIER
- New Table: BLC_ORDER_ITEM_DTL_ADJ
- New Table: BLC_ORDER_ITEM_PRICE_DTL
- New Table: BLC_ORDER_PAYMENT_DETAILS
- New Fields in
BLC_ORDER_ITEM: DISCOUNTS_ALLOWED, RETAIL_PRICE_OVERRIDE, SALE_PRICE_OVERRIDE, TOTAL_TAX - New Fields in
BLC_ORDER_PAYMENT: CUSTOMER_PAYMENT_ID - New Fields in
BLC_PAYMENT_RESPONSE_ITEM: TRANSACTION_AMOUNT
2.1 to 2.2 Model Changes
- In Admin
- New Table: BLC_ADMIN_MODULE
- New Table: BLC_ADMIN_SECTION
- New Table: BLC_ADMIN_SECTION_PERMISSION_XREF
- In Common
- New Table: BLC_CURRENCY
- New Fields in
BLC_LOCALE: CURRENCY_CODE
- In Category
- New Fields in
BLC_CATEGORY: FULFILLMENT_TYPE, INVENTORY_TYPE
- New Fields in
- In Search
- New Fields in
BLC_FIELD: TRANSLATABLE
- New Fields in
- In Fulfillment
- New Fields in
BLC_FULFILLMENT_OPTION_FIXED: CURRENCY_CODE
- New Fields in
- In Order
- New Fields in
BLC_ORDER: LOCALE_CODE, CURRENCY_CODE
- New Fields in
- In Payment
- New Fields in
BLC_PAYMENT_RESPONSE_ITEM: CURRENCY_CODE - New Fields in
BLC_PAYMENT_LOG: CURRENCY_CODE
- New Fields in
- In Tax
- New Fields in
BLC_TAX_DETAIL: CURRENCY_CODE
- New Fields in
- In Sku
- New Fields in
BLC_SKU: FULFILLMENT_TYPE, INVENTORY_TYPE - New Fields in
BLC_SKU_FEE: CURRENCY_CODE
- New Fields in
- In Social
- New Table: BLC_UserConnection
- New Table: BLC_UserConnection
2.0 to 2.1 Model Changes
- In Customer
- New Table: BLC_CUSTOMER_PAYMENT
- In Search
- New Table: BLC_SEARCH_FACET_XREF
- New Fields in
BLC\_SEARCH\_FACET: REQUIRES_ALL_DEPENDENT