ALTER TABLE `inv_master_products` ADD `pdt_vzos` TINYINT NOT NULL AFTER `pdt_id`, ADD `pdt_vzid` INT NULL AFTER `pdt_vzos`;
ALTER TABLE `inv_products` ADD `pt_vzos` TINYINT NOT NULL AFTER `pt_id`, ADD `pt_vzid` INT NULL AFTER `pt_vzos`;

ALTER TABLE `inv_product_sales_order` ADD `ips_vzid` INT NULL AFTER `ips_id`;
ALTER TABLE `inv_product_sales_order` ADD `ips_billed` INT NOT NULL AFTER `ips_sale_mode`;

ALTER TABLE `inv_product_sale_details` ADD `ipsd_vzid` INT NULL AFTER `ipsd_id`;
ALTER TABLE `inv_ivc_product_sale_details` ADD `ipsd_vzid` INT NULL AFTER `ipsd_id`;

ALTER TABLE `inv_product_sale` ADD `ips_vzid` INT NULL AFTER `ips_id`;

ALTER TABLE `inv_products` ADD `pt_v_cost` DECIMAL(11,2) NULL AFTER `pt_ref_id`, ADD `pt_v_in_cost` DECIMAL(11,2) NULL AFTER `pt_v_cost`;
ALTER TABLE `inv_products` ADD `pt_v_price` DECIMAL(11,2) NULL AFTER `pt_v_in_cost`, ADD `pt_v_in_price` DECIMAL(11,2) NULL AFTER `pt_v_price`;


