CREATE TABLE `hr_pay_calculation_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `calculation_id` int(11) NOT NULL,
  `staff_id` int(11) NOT NULL,
  `basic_salary` decimal(10,2) NOT NULL,
  `back_pay` decimal(10,2) NOT NULL,
  `formula` text COLLATE utf8_general_ci,
  `ot_amount` decimal(10,2) NOT NULL,
  `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,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2663 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
