CREATE TABLE `hr_pay_cheque` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `year_id` int(11) NOT NULL,
  `schedule_id` int(11) NOT NULL,
  `staff_id` int(11) NOT NULL,
  `basic_salary` decimal(10,2) NOT NULL,
  `formula` text COLLATE utf8_general_ci,
  `deduct_amount` decimal(10,2) NOT NULL,
  `actual_amount` decimal(10,2) NOT NULL,
  `mpf_er` decimal(10,2) NOT NULL,
  `mpf_ee` decimal(10,2) NOT NULL,
  `pf_er` decimal(10,2) NOT NULL,
  `pf_ee` decimal(10,2) NOT NULL,
  `actual_salary` decimal(10,2) NOT NULL,
  `remark` text COLLATE utf8_general_ci,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
