ALTER TABLE `erp_direct_invoice` ADD `receipt_type_id` INT NOT NULL COMMENT 'primary key of master_fin_reciept_type' AFTER `branch_id`, ADD `ledger_id` INT NOT NULL COMMENT 'primary key of finance_legder' AFTER `receipt_type_id`, ADD `received_amount` DECIMAL(15,3) NOT NULL AFTER `ledger_id`, ADD `discount_amount` DECIMAL(15,3) NOT NULL AFTER `received_amount`;
ALTER TABLE `erp_direct_invoice` ADD `old_balance` DECIMAL(15,3) NOT NULL AFTER `discount_amount`;