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 account_hierarchy VARCHAR(65535);
ALTER TABLE blc_order ADD account_id VARCHAR(36);
ALTER TABLE blc_order_fulfill_item_tax_detail ADD is_vat CHAR(1) DEFAULT 'N' NOT NULL;
ALTER TABLE blc_order ADD approver_email VARCHAR(255);
ALTER TABLE blc_order ADD root_account_id VARCHAR(36);