ALTER TABLE prod022 MODIFY pr022_dec_min_w DECIMAL(20,7) COMMENT '下误差';
ALTER TABLE prod022 MODIFY pr022_dec_max_w DECIMAL(20,7) COMMENT '上误差';
ALTER TABLE prod022_hst MODIFY pr022hst_dec_min_w DECIMAL(20,7) COMMENT '下误差';
ALTER TABLE prod022_hst MODIFY pr022hst_dec_max_w DECIMAL(20,7) COMMENT '上误差';
UPDATE `sys005` SET `s005_date_create` = NULL, `s005_id_creater` = '', `s005_flag_state` = '', `s005_int_line` = 0, `s005_id_table` = '', `s005_id_audit` = '', `s005_date_audit` = NULL, `s005_id_dept` = '', `s005_id_com` = '', `s005_id_main` = '', `s005_fields` = '[{\"field_name_cn\":\"物料编码\",\"field_name_en\":\"i21_id_item\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":10,\"flag_query\":\"N\",\"int_width\":150,\"flag_show\":\"Y\",\"flag_date\":\"N\",\"flag_sum\":\"N\",\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"物料名称\",\"field_name_en\":\"i21_var_item\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":20,\"flag_query\":\"N\",\"int_width\":350,\"flag_show\":\"Y\",\"flag_date\":\"N\",\"flag_sum\":\"N\",\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"批号\",\"field_name_en\":\"i21_var_batch\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":23,\"flag_query\":\"N\",\"int_width\":150,\"flag_show\":\"Y\",\"flag_date\":\"N\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"厂家批号\",\"field_name_en\":\"i21_var_batch_prod\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":26,\"flag_query\":\"N\",\"int_width\":150,\"flag_show\":\"Y\",\"flag_date\":\"N\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"仓库\",\"field_name_en\":\"c103_var_wh\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":30,\"flag_query\":\"N\",\"int_width\":150,\"flag_show\":\"Y\",\"flag_date\":\"N\",\"flag_sum\":\"N\",\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"货位\",\"field_name_en\":\"i21_id_loc\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":33,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"Y\",\"flag_date\":\"N\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"总量\",\"field_name_en\":\"inv_weight\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":40,\"flag_query\":\"N\",\"int_width\":150,\"flag_show\":\"Y\",\"flag_date\":\"N\",\"flag_sum\":\"Y\",\"var_format\":\"number\",\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"单位\",\"field_name_en\":\"i21_id_unit\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":50,\"flag_query\":\"N\",\"int_width\":80,\"flag_show\":\"Y\",\"flag_date\":\"N\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"入库日期\",\"field_name_en\":\"date_in\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":60,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"Y\",\"flag_date\":\"N\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"生产日期\",\"field_name_en\":\"date_prod\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":80,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"Y\",\"flag_date\":\"N\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"有效日期\",\"field_name_en\":\"date_expire\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":90,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"Y\",\"flag_date\":\"N\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"客户\",\"field_name_en\":\"c201_var_corr\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":100,\"flag_query\":\"N\",\"int_width\":200,\"flag_show\":\"Y\",\"flag_date\":\"N\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null}]', `s005_var_sql` = 'SELECT i21_id_item,i21_var_item,c103_var_wh,ifnull(sum(i21_dec_end),0) AS inv_weight,i21_id_unit,c201_var_corr,DATE_FORMAT(i31_date_create,\'%Y-%m-%d\') AS date_in,DATE_FORMAT(i31_date_prod,\'%Y-%m-%d\') AS date_prod,DATE_FORMAT(i31_date_expire,\'%Y-%m-%d\') AS date_expire,i21_var_batch,i21_var_batch_prod,i21_id_loc\r\nFROM inv21 LEFT JOIN ctlm201 ON i21_id_customer = c201_id,ctlm103,inv31\r\nWHERE c103_id_wh = i21_id_wh\r\nAND i21_var_serial = i31_id \r\nGROUP BY i21_id_item,c103_var_wh,i21_var_item,i21_id_unit,i21_var_batch,i21_var_batch_prod,i21_id_loc,c201_var_corr,DATE_FORMAT(i31_date_create,\'%Y-%m-%d\'),DATE_FORMAT(i31_date_prod,\'%Y-%m-%d\'),DATE_FORMAT(i31_date_expire,\'%Y-%m-%d\')', `s005_var_filter` = NULL, `s005_var_param` = NULL, `s005_var_proc` = NULL, `s005_prints` = NULL, `s005_var_conditon` = '[{\"id_cond\":\"q1\",\"var_label\":\"入库日期(开始)\",\"var_value\":null,\"flag_type\":\"date\",\"flag_relate\":\">= \",\"var_fields\":\"date_in\",\"var_sql\":null,\"flag_required\":null},{\"id_cond\":\"q2\",\"var_label\":\"入库日期(截止)\",\"var_value\":null,\"flag_type\":\"date\",\"flag_relate\":\"<=\",\"var_fields\":\"date_in\",\"var_sql\":null,\"flag_required\":null},{\"id_cond\":\"q3\",\"var_label\":\"查询条件\",\"var_value\":null,\"flag_type\":\"text\",\"flag_relate\":\"likeall\",\"var_fields\":\"i21_id_item;i21_var_item;c103_var_wh;c201_var_corr;i21_var_batch\",\"var_sql\":null,\"flag_required\":null}]', `s005_id_rpt` = 'rpt_i21_wh', `s005_var_rpt` = '库存物料情况', `s005_date_last_edit` = '2026-04-18 10:30:53', `s005_var_fld_relate` = NULL, `s005_var_route` = NULL, `s005_flag_open_type` = NULL, `s005_var_sort` = 'i21_id_item,date_in' WHERE `s005_id` = '6763ad47-6322-4bb5-8269-321c3a90702d';
INSERT INTO `ver01`(`id`, `version`, `apk_name`, `generate_date`, `note`) VALUES (25, 'ifs.pda.6.4.x.zeson.260427.1', 'ZESON26042701.apk', '2026-04-27 18:03:27', NULL);
