ALTER TABLE `acc_journal` ADD `aj_apra_id` INT NULL AFTER `aj_rd_id`;
ALTER TABLE `acc_transactions` ADD `at_apra_id` INT NULL AFTER `at_chitty_id`;
CREATE TABLE `acc_pay_receiv_able` (
`apra_id` int(11) NOT NULL,
`apra_type` tinyint(4) DEFAULT NULL,
`apra_seg_id` int(11) DEFAULT NULL,
`apra_service_id` int(11) DEFAULT NULL,
`apra_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`apra_date` date NOT NULL,
`apra_amount` decimal(11,2) NOT NULL,
`apra_amnt_paid` decimal(11,2) DEFAULT NULL,
`apra_journal` int(11) DEFAULT NULL,
`apra_party_type` int(11) DEFAULT NULL,
`apra_party` int(11) DEFAULT NULL,
`apra_status` tinyint(4) DEFAULT NULL,
`apra_notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
ALTER TABLE `acc_pay_receiv_able`
ADD PRIMARY KEY (`apra_id`);
ALTER TABLE `acc_pay_receiv_able`
MODIFY `apra_id` int(11) NOT NULL AUTO_INCREMENT;