ALTER TABLE blc_order_fulfillment ADD adjustments_total numeric(19, 5);
ALTER TABLE blc_order_fulfillment_item ADD prorated_order_ffm_adj numeric(19, 5);
ALTER TABLE blc_order_fulfillment ADD prorated_order_ffm_adj numeric(19, 5);
ALTER TABLE blc_order_fulfillment_item ADD fulfillment_refund_amount numeric(19, 5);
ALTER TABLE blc_order ADD cart_type VARCHAR(36);
ALTER TABLE blc_order ALTER COLUMN cart_type TYPE VARCHAR(60) USING (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 numeric(19, 5);
ALTER TABLE blc_return_confirmation ADD total_refund_awaiting_result numeric(19, 5);
ALTER TABLE blc_return_confirmation ADD total_refunded numeric(19, 5);
ALTER TABLE blc_return_auth ADD total_failed_to_refund numeric(19, 5);
ALTER TABLE blc_return_auth ADD total_refund_awaiting_result numeric(19, 5);