ALTER TABLE BLC_ORDER_ITEM ADD TYPE VARCHAR2(60 CHAR);
ALTER TABLE BLC_ORDER_ITEM ADD PRORATED_ORDER_ADJUSTMENTS DECIMAL(19, 5);
ALTER TABLE BLC_ORDER ADD PAYMENT_DISTRIBUTION_DETAILS CLOB NULL;