INSERT INTO hrsa_formula (id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1653993466778, '公式1', '备注', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{累计专项附加扣除.累计住房贷款利息}', 'addUpDeductions_addUpHousingLoanInterest', 1, 0, to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'))
 /
INSERT INTO hrsa_formula_var ( id ,  name ,  formula_id ,  field_id ,  field_name ,  field_type ,  source ,  order_index ,  creator ,  delete_type ,  create_time ,  update_time ) VALUES (1653993466787, '累计住房贷款利息', 1653993466778, 'addUpDeductions_addUpHousingLoanInterest', '{累计专项附加扣除.累计住房贷款利息}', 'number', 'addUpDeductions', 0, 1, 0, to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'))
 /
INSERT INTO hrsa_formula ( id ,  name ,  description ,  module ,  use_for ,  reference_type ,  return_type ,  validate_type ,  extend_param ,  formula ,  formulaRunScript ,  creator ,  delete_type ,  create_time ,  update_time ) VALUES (1653993837931, '公式1', '备注', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{累计专项附加扣除.累计住房租金}', 'addUpDeductions_addUpHousingRent', 1, 0, to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'))
 /
INSERT INTO hrsa_formula_var ( id ,  name ,  formula_id ,  field_id ,  field_name ,  field_type ,  source ,  order_index ,  creator ,  delete_type ,  create_time ,  update_time ) VALUES (1653993837947, '累计住房租金', 1653993837931, 'addUpDeductions_addUpHousingRent', '{累计专项附加扣除.累计住房租金}', 'number', 'addUpDeductions', 0, 1, 0, to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'))
 /
INSERT INTO hrsa_formula ( id ,  name ,  description ,  module ,  use_for ,  reference_type ,  return_type ,  validate_type ,  extend_param ,  formula ,  formulaRunScript ,  creator ,  delete_type ,  create_time ,  update_time ) VALUES (1653993954233, '公式1', '备注', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{累计专项附加扣除.累计继续教育}', 'addUpDeductions_addUpContinuingEducation', 1, 0, to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'))
 /
INSERT INTO hrsa_formula_var ( id ,  name ,  formula_id ,  field_id ,  field_name ,  field_type ,  source ,  order_index ,  creator ,  delete_type ,  create_time ,  update_time ) VALUES (1653993954257, '累计继续教育', 1653993954233, 'addUpDeductions_addUpContinuingEducation', '{累计专项附加扣除.累计继续教育}', 'number', 'addUpDeductions', 0, 1, 0, to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'))
 /
INSERT INTO hrsa_formula ( id ,  name ,  description ,  module ,  use_for ,  reference_type ,  return_type ,  validate_type ,  extend_param ,  formula ,  formulaRunScript ,  creator ,  delete_type ,  create_time ,  update_time ) VALUES (1653994061764, '公式1', '备注', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{累计专项附加扣除.累计赡养老人}', 'addUpDeductions_addUpSupportElderly', 1, 0,to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'),to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'))
 /
INSERT INTO hrsa_formula_var ( id ,  name ,  formula_id ,  field_id ,  field_name ,  field_type ,  source ,  order_index ,  creator ,  delete_type ,  create_time ,  update_time ) VALUES (1653994061780, '累计赡养老人', 1653994061764, 'addUpDeductions_addUpSupportElderly', '{累计专项附加扣除.累计赡养老人}', 'number', 'addUpDeductions', 0, 1, 0, to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'))
 /





update hrsa_sys_salary_item set formula_id = 1653993466778 where id  = 674853617092214800
 /
update hrsa_sys_salary_item set formula_id = 1653993837931 where id  = 674853617092214801
 /
update hrsa_sys_salary_item set formula_id = 1653993954233 where id  = 674853617092214802
 /
update hrsa_sys_salary_item set formula_id = 1653994061764 where id  = 674853617092214803
 /


update hrsa_salary_item set formula_id = 1653993466778 where sys_salary_item_id  = 674853617092214800
/
update hrsa_salary_item set formula_id = 1653993837931 where sys_salary_item_id  = 674853617092214801
/
update hrsa_salary_item set formula_id = 1653993954233 where sys_salary_item_id  = 674853617092214802
/
update hrsa_salary_item set formula_id = 1653994061764 where sys_salary_item_id  = 674853617092214803
/