ALTER TABLE BLC_ORDER_FULFILLMENT ADD ADJUSTMENTS_TOTAL NUMBER(19, 5);
ALTER TABLE BLC_ORDER_FULFILLMENT_ITEM ADD PRORATED_ORDER_FFM_ADJ NUMBER(19, 5);
ALTER TABLE BLC_ORDER_FULFILLMENT ADD PRORATED_ORDER_FFM_ADJ NUMBER(19, 5);
ALTER TABLE BLC_ORDER_FULFILLMENT_ITEM ADD FULFILLMENT_REFUND_AMOUNT NUMBER(19, 5);
ALTER TABLE BLC_ORDER ADD CART_TYPE VARCHAR2(36 CHAR);
ALTER TABLE BLC_ORDER MODIFY CART_TYPE VARCHAR2(60 CHAR);
ALTER TABLE BLC_ORDER_FULFILL_ITEM_TAX_DETAIL ADD IS_VAT CHAR(1 CHAR) DEFAULT 'N' NOT NULL;
ALTER TABLE BLC_RETURN_CONFIRMATION ADD TOTAL_FAILED_TO_REFUND NUMBER(19, 5);
ALTER TABLE BLC_RETURN_CONFIRMATION ADD TOTAL_REFUND_AWAITING_RESULT NUMBER(19, 5);
ALTER TABLE BLC_RETURN_CONFIRMATION ADD TOTAL_REFUNDED NUMBER(19, 5);
ALTER TABLE BLC_RETURN_AUTH ADD TOTAL_FAILED_TO_REFUND NUMBER(19, 5);
ALTER TABLE BLC_RETURN_AUTH ADD TOTAL_REFUND_AWAITING_RESULT NUMBER(19, 5);