ALTER TABLE `billing_bills` ADD `type_id` INT NOT NULL AFTER `type`, ADD INDEX(`type_id`);
ALTER TABLE `billing_folios` ADD `type_id` INT NOT NULL AFTER `type`, ADD INDEX(`type_id`);
ALTER TABLE `billing_invoices` ADD `type_id` INT NOT NULL AFTER `type`, ADD INDEX(`type_id`);
ALTER TABLE `billing_returns` ADD `type_id` INT NOT NULL AFTER `type`, ADD INDEX(`type_id`);
ALTER TABLE `inventory_adjustments` ADD `type_id` INT NOT NULL AFTER `type`, ADD INDEX(`type_id`);
ALTER TABLE `inventory_requisitions` ADD `type_id` INT NOT NULL AFTER `type`, ADD INDEX(`type_id`);
ALTER TABLE `procurement_grns` ADD `type_id` INT NOT NULL AFTER `type`, ADD INDEX(`type_id`);
ALTER TABLE `procurement_orders` ADD `type_id` INT NOT NULL AFTER `type`, ADD INDEX(`type_id`);
ALTER TABLE `procurement_requests` ADD `type_id` INT NOT NULL AFTER `type`, ADD INDEX(`type_id`);
ALTER TABLE `procurement_requisitions` ADD `type_id` INT NOT NULL AFTER `type`, ADD INDEX(`type_id`);