ALTER TABLE BLC_ORDER_FULFILLMENT_ITEM ADD ATTRIBUTES CLOB;
ALTER TABLE BLC_ORDER_FULFILLMENT_ITEM ADD INTERNAL_ATTRIBUTES CLOB;
ALTER TABLE BLC_ORDER_PAYMENT ADD ADJUSTMENTS_TOTAL NUMBER(19, 5);
ALTER TABLE BLC_ORDER_PAYMENT ADD DISPLAY_ATTRIBUTES CLOB;
ALTER TABLE BLC_ORDER_PAYMENT ADD SINGLE_USE_PAYMENT_METHOD CHAR(1 CHAR) DEFAULT 'N' NOT NULL;
ALTER TABLE BLC_ORDER_PAYMENT ADD NAME VARCHAR2(255 CHAR);
ALTER TABLE BLC_ORDER_PAYMENT ADD FULFILLMENT_TOTAL NUMBER(19, 5);
ALTER TABLE BLC_ORDER_PAYMENT ADD SUBTOTAL NUMBER(19, 5);
ALTER TABLE BLC_ORDER_PAYMENT ADD TAX_TOTAL NUMBER(19, 5);
ALTER TABLE BLC_ORDER_PAYMENT_TRANSACTION ADD MANAGEMENT_STATE VARCHAR2(60 CHAR);
ALTER TABLE BLC_ORDER ADD VOUCHERS CLOB;
ALTER TABLE BLC_ORDER_ITEM ADD BRAND_ID VARCHAR2(36 CHAR);
ALTER TABLE BLC_ORDER_ITEM ADD CATEGORY_IDS CLOB;
ALTER TABLE BLC_ORDER_ITEM ADD DISCOUNTABLE CHAR(1 CHAR) DEFAULT 'Y' NOT NULL;
ALTER TABLE BLC_ORDER_ITEM ADD MERCHANDISING_CONTEXT VARCHAR2(255 CHAR);
ALTER TABLE BLC_ORDER_ITEM ADD MERCHANDISING_TYPE_ID VARCHAR2(36 CHAR);
ALTER TABLE BLC_ORDER_ITEM ADD PRICING_STRATEGY VARCHAR2(255 CHAR);
ALTER TABLE BLC_ORDER_ITEM ADD PRODUCT_TAGS CLOB;
ALTER TABLE BLC_ORDER_ITEM ADD TARGET_DEMOGRAPHIC_ID VARCHAR2(36 CHAR);
ALTER TABLE BLC_ORDER_ITEM ADD VENDOR_REF VARCHAR2(255 CHAR);