ALTER TABLE blc_order_fulfillment ADD adjustments_total DECIMAL(19, 5) NULL;
ALTER TABLE blc_order_fulfillment_item ADD prorated_order_ffm_adj DECIMAL(19, 5) NULL;
ALTER TABLE blc_order_fulfillment ADD prorated_order_ffm_adj DECIMAL(19, 5) NULL;
ALTER TABLE blc_order_fulfillment_item ADD fulfillment_refund_amount DECIMAL(19, 5) NULL;
ALTER TABLE blc_order ADD cart_type VARCHAR(36) NULL;
ALTER TABLE blc_order MODIFY cart_type VARCHAR(60);
ALTER TABLE blc_order_fulfill_item_tax_detail ADD is_vat CHAR(1) DEFAULT 'N' NOT NULL;
ALTER TABLE blc_return_confirmation ADD total_failed_to_refund DECIMAL(19, 5) NULL;
ALTER TABLE blc_return_confirmation ADD total_refund_awaiting_result DECIMAL(19, 5) NULL;
ALTER TABLE blc_return_confirmation ADD total_refunded DECIMAL(19, 5) NULL;
ALTER TABLE blc_return_auth ADD total_failed_to_refund DECIMAL(19, 5) NULL;
ALTER TABLE blc_return_auth ADD total_refund_awaiting_result DECIMAL(19, 5) NULL;