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