ALTER TABLE daily_back_check_rcd ADD COLUMN item_code VARCHAR(60) COMMENT '物料编码';
ALTER TABLE daily_back_check_rcd ADD COLUMN item_batch VARCHAR(60) COMMENT '物料批号';
UPDATE daily_back_check_rcd,inv31 SET item_code = i31_id_item,item_batch = i31_var_batch WHERE serial_no = i31_id;
ALTER TABLE daily_back_check_rcd ADD INDEX idx_item_batch(item_code,item_batch);
INSERT INTO `sys004`(`s004_id`, `s004_date_create`, `s004_id_creater`, `s004_flag_state`, `s004_int_line`, `s004_id_table`, `s004_id_audit`, `s004_date_audit`, `s004_id_dept`, `s004_id_com`, `s004_id_main`, `s004_id_menu`, `s004_var_menu`, `s004_var_title`, `s004_var_component`, `s004_var_filter`, `s004_flag_hidden`, `s004_var_icon`, `s004_flag_cach`, `s004_var_param`, `s004_flag_type`, `s004_busi_type`, `s004_id_obj_table`, `s004_var_path`, `s004_int_level`, `s004_id_mould`, `s004_var_compnent`, `s004_int_lines`, `s004_id_flow`, `s004_var_group`) VALUES ('fb89f43d-695e-11f1-b2f0-000c29bcdadf', '2026-06-16 16:40:24', 'c186b3da-1f9e-11e9-a0dc-02004c4f4f50', '正常', 1, 'task_settle', NULL, NULL, '7bc6d0fd-cc68-11e9-9f24-00163e13f083', '0e4ca95c-8c60-46f5-8c94-46ab44d9da28', '5b969c15-758b-11e9-8216-00163e13f083', NULL, 'task_settle_qry', '任务损耗查询', 'custom/task_settle_qry', NULL, 'N', NULL, NULL, NULL, NULL, NULL, NULL, 'task_settle_qry111', NULL, '111', '', 65, NULL, NULL);
UPDATE `sys004` SET `s004_date_create` = '2023-07-05 13:40:26', `s004_id_creater` = 'c186b3da-1f9e-11e9-a0dc-02004c4f4f50', `s004_flag_state` = '正常', `s004_int_line` = 1, `s004_id_table` = 'pr02', `s004_id_audit` = NULL, `s004_date_audit` = NULL, `s004_id_dept` = '7bc6d0fd-cc68-11e9-9f24-00163e13f083', `s004_id_com` = '0e4ca95c-8c60-46f5-8c94-46ab44d9da28', `s004_id_main` = '5b969c15-758b-11e9-8216-00163e13f083', `s004_id_menu` = NULL, `s004_var_menu` = 'gridqry_bill_hang_up', `s004_var_title` = '任务挂起', `s004_var_component` = 'gridqry/gridqry_bill_hang_up', `s004_var_filter` = NULL, `s004_flag_hidden` = 'N', `s004_var_icon` = NULL, `s004_flag_cach` = NULL, `s004_var_param` = NULL, `s004_flag_type` = NULL, `s004_busi_type` = NULL, `s004_id_obj_table` = NULL, `s004_var_path` = 'pr02_qry117', `s004_int_level` = NULL, `s004_id_mould` = '117', `s004_var_compnent` = '', `s004_int_lines` = 68, `s004_id_flow` = NULL, `s004_var_group` = NULL WHERE `s004_id` = '71cd9320-1af6-11ee-889d-52540088346d';
INSERT INTO `ver01`(`id`, `version`, `apk_name`, `generate_date`, `note`) VALUES (35, 'ifs.pda.6.4.x.zeson.260624.1', 'ZESON26062401.apk', '2026-06-24 15:41:29', NULL);
