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\":\"id\",\"field_name_en\":\"i22_id\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":10,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_date_create\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":20,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"创建人\",\"field_name_en\":\"i22_id_creater\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":30,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_flag_state\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":40,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_int_line\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":50,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_date_bill\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":60,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"业务员\",\"field_name_en\":\"i22_id_clerk\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":70,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_source_table\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":80,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"N\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"来源id\",\"field_name_en\":\"i22_id_source\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":90,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_bill_no\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":100,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_table\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":110,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_int_year\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":120,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_audit\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":130,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_date_audit\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":140,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"核算月\",\"field_name_en\":\"i22_int_month\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":150,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_dept\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":160,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_com\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":170,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"N\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"主表id\",\"field_name_en\":\"i22_id_main\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":180,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_flow\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":190,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_date_audit_act\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":200,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"原始号\",\"field_name_en\":\"i22_var_bill_ori\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":210,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_busi_no\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":220,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_item\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":230,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_item\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":240,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_code_item\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":250,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_serial\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":260,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_batch\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":270,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_dec_tag\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":280,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_dec_tare\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":290,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_unit\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":300,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_date_prod\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":310,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"有效期\",\"field_name_en\":\"i22_date_expire\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":320,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"供应商\",\"field_name_en\":\"i22_id_sup\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":330,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_wh\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":340,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_loc\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":350,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_container\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":360,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_int_bag_count\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":370,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_flag_half\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":380,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_flag_checked\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":390,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_flag_occu\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":400,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_flag_closed\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":410,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_terminal\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":420,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_flag_io\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":430,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_serial_ori\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":440,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_scale\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":450,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_flag_tag\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":460,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_flag_bag\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":470,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_dec_weight\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":480,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_dec_qty\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":490,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_source\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":500,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_pack\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":510,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_source_ori\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":520,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_remark\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":530,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_batch_prod\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":540,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_cata\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":550,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_dec_weight_ori\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":560,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_flag_erp\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":570,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_date_erp\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":580,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"id\",\"field_name_en\":\"c202_id\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":590,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_supp\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":590,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_date_create\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":600,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"供应商名称\",\"field_name_en\":\"i22_var_supp\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":600,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_id_creater\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":610,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"N\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"客户id\",\"field_name_en\":\"i22_id_customer\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":610,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_flag_state\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":620,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"var_store\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":620,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_source_item\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":620,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_int_line\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":630,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":630,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_dec_pack_gross\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":630,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_id_table\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":640,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_batch_semi\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":640,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_id_audit\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":650,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_box_pattern\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":650,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_date_audit\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":660,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"箱数\",\"field_name_en\":\"i22_dec_box_qty\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":660,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_id_dept\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":670,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_date_check\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":670,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"账套\",\"field_name_en\":\"c202_id_com\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":680,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_checker\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":680,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"N\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"主表id\",\"field_name_en\":\"c202_id_main\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":690,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_date_check_expire\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":690,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\" 编码\",\"field_name_en\":\"c202_id_supp\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":700,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_maker\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":700,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_var_spell\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":710,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_gravity\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":710,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_var_spell_short\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":720,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_var_supp\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":730,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c102_id_item_type\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":730,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_int_level\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":740,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_flag_leaf\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":750,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_id_flow\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":760,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_date_audit_act\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":770,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"员工\",\"field_name_en\":\"c202_id_clerk\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":780,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_flag_tax\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":790,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_var_addr\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":800,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_id_industry\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":810,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_int_aging\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":820,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_dec_debt\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":830,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_var_tax\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":840,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_var_bank\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":850,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_var_account\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":860,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_var_contactor\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":870,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_var_tel\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":880,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_flag_currency\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":890,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_flag_type\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":900,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_flag_class\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":910,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_flag_locked\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":920,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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 inv22.*,c102_var_store AS var_store,c102_id_item_type,i31_date_bill AS date_in \r\nFROM inv22 \r\nLEFT JOIN inv31 ON i22_var_serial = i31_id\r\nleft join ctlm202 as ctlm202_i22_id_sup on inv22.i22_id_sup=ctlm202_i22_id_sup.c202_id \r\nLEFT JOIN ctlm102 ON i22_id_item = c102_id\r\nwhere i22_flag_state=\"正常\"  and i22_var_source=\"分装\"', `s005_var_filter` = NULL, `s005_var_param` = NULL, `s005_var_proc` = NULL, `s005_prints` = NULL, `s005_var_conditon` = '[{\"id_cond\":\"q2\",\"var_label\":\"模糊查询\",\"var_value\":null,\"flag_type\":\"text\",\"flag_relate\":\"likeall\",\"var_fields\":\"i22_var_serial;i22_id_item;i22_var_item;c202_id_supp;i22_var_batch\",\"var_sql\":null,\"flag_required\":null}]', `s005_id_rpt` = 'rpt_i22_qry_whsplit', `s005_var_rpt` = '分装历史查询', `s005_date_last_edit` = '2025-11-14 18:00:07', `s005_var_fld_relate` = NULL, `s005_var_route` = NULL, `s005_flag_open_type` = NULL, `s005_var_sort` = 'i22_date_create desc' WHERE `s005_id` = '6291c703-9810-4853-aaef-d9e36cf7efbf';
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\":\"id\",\"field_name_en\":\"i22_id\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":10,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_date_create\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":20,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"创建人\",\"field_name_en\":\"i22_id_creater\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":30,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_flag_state\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":40,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_int_line\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":50,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_date_bill\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":60,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"业务员\",\"field_name_en\":\"i22_id_clerk\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":70,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_source_table\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":80,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"N\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"来源id\",\"field_name_en\":\"i22_id_source\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":90,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_bill_no\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":100,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_table\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":110,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_int_year\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":120,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_audit\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":130,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_date_audit\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":140,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"核算月\",\"field_name_en\":\"i22_int_month\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":150,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_dept\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":160,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_com\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":170,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"N\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"主表id\",\"field_name_en\":\"i22_id_main\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":180,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_flow\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":190,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_date_audit_act\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":200,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"原始号\",\"field_name_en\":\"i22_var_bill_ori\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":210,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_busi_no\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":220,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_item\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":230,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_item\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":240,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_code_item\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":250,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_serial\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":260,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_batch\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":270,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_dec_tag\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":280,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_dec_tare\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":290,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_unit\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":300,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_date_prod\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":310,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"有效期\",\"field_name_en\":\"i22_date_expire\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":320,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"供应商\",\"field_name_en\":\"i22_id_sup\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":330,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_wh\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":340,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_loc\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":350,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_container\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":360,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_int_bag_count\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":370,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_flag_half\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":380,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_flag_checked\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":390,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_flag_occu\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":400,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_flag_closed\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":410,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_terminal\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":420,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_flag_io\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":430,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_serial_ori\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":440,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_scale\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":450,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_flag_tag\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":460,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_flag_bag\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":470,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_dec_weight\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":480,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_dec_qty\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":490,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_source\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":500,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_pack\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":510,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_source_ori\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":520,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_remark\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":530,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_batch_prod\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":540,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_cata\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":550,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"N\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"id\",\"field_name_en\":\"c202_id\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":560,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_dec_weight_ori\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":560,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_date_create\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":570,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"\",\"field_name_en\":\"i22_flag_erp\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":570,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_id_creater\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":580,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_date_erp\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":580,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"状态\",\"field_name_en\":\"c202_flag_state\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":590,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_supp\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":590,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_int_line\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":600,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_supp\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":600,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_id_table\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":610,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"N\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"客户id\",\"field_name_en\":\"i22_id_customer\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":610,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_id_audit\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":620,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"var_store\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":620,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_source_item\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":620,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_date_audit\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":630,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"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\":630,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_dec_pack_gross\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":630,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_id_dept\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":640,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_batch_semi\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":640,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_id_com\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":650,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_box_pattern\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":650,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"N\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"主表id\",\"field_name_en\":\"c202_id_main\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":660,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_dec_box_qty\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":660,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_id_supp\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":670,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_date_check\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":670,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"中文拼音\",\"field_name_en\":\"c202_var_spell\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":680,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_checker\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":680,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_var_spell_short\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":690,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_date_check_expire\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":690,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"供应商名称\",\"field_name_en\":\"c202_var_supp\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":700,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_maker\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":700,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_int_level\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":710,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_gravity\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":710,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_flag_leaf\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":720,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_id_flow\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":730,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c102_id_item_type\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":730,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_date_audit_act\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":740,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"员工\",\"field_name_en\":\"c202_id_clerk\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":750,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_flag_tax\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":760,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_var_addr\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":770,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_id_industry\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":780,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_int_aging\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":790,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_dec_debt\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":800,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_var_tax\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":810,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_var_bank\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":820,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_var_account\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":830,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_var_contactor\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":840,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_var_tel\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":850,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_flag_currency\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":860,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_flag_type\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":870,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_flag_class\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":880,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_flag_locked\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":890,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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 inv22.*,c102_var_store AS var_store,c102_id_item_type,i31_date_bill AS date_in \r\nFROM inv22 \r\nLEFT JOIN inv31 ON i22_var_serial = i31_id\r\nleft join ctlm202 as ctlm202_i22_id_sup on inv22.i22_id_sup=ctlm202_i22_id_sup.c202_id \r\nLEFT JOIN ctlm102 ON i22_id_item = c102_id\r\nwhere i22_flag_state=\"正常\"  and(i22_var_source=\"生产领料\" or i22_var_source=\"调拨出库\"  or i22_var_source=\"抽检出库\"  or i22_var_source=\"销售出库\" or i22_var_source=\"生产退库\" or i22_var_source=\"其它出库\" or i22_var_source=\"采购退货\")', `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\":\"text\",\"flag_relate\":\"= \",\"var_fields\":\"i22_id_wh\",\"var_sql\":null,\"flag_required\":null},{\"id_cond\":\"q2\",\"var_label\":\"模糊查询\",\"var_value\":null,\"flag_type\":\"text\",\"flag_relate\":\"likeall\",\"var_fields\":\"i22_var_serial;i22_id_item;i22_var_item;c202_id_supp;c202_var_supp\",\"var_sql\":null,\"flag_required\":null}]', `s005_id_rpt` = 'rpt_i22_qry_whout', `s005_var_rpt` = '出库历史查询', `s005_date_last_edit` = '2025-11-14 17:39:17', `s005_var_fld_relate` = NULL, `s005_var_route` = NULL, `s005_flag_open_type` = NULL, `s005_var_sort` = 'i22_date_create desc' WHERE `s005_id` = '270bd12e-6081-41a4-9476-6e4131813512';
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\":\"id\",\"field_name_en\":\"i22_id\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":10,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_date_create\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":20,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"创建人\",\"field_name_en\":\"i22_id_creater\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":30,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_flag_state\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":40,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_int_line\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":50,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_date_bill\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":60,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"业务员\",\"field_name_en\":\"i22_id_clerk\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":70,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_source_table\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":80,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"N\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"来源id\",\"field_name_en\":\"i22_id_source\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":90,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_bill_no\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":100,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_table\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":110,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_int_year\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":120,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_audit\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":130,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_date_audit\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":140,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"核算月\",\"field_name_en\":\"i22_int_month\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":150,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_dept\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":160,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_com\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":170,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"N\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"主表id\",\"field_name_en\":\"i22_id_main\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":180,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_flow\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":190,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_date_audit_act\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":200,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"原始号\",\"field_name_en\":\"i22_var_bill_ori\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":210,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_busi_no\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":220,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_item\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":230,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_item\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":240,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_code_item\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":250,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_serial\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":260,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_batch\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":270,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_dec_tag\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":280,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_dec_tare\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":290,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_unit\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":300,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_date_prod\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":310,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"有效期\",\"field_name_en\":\"i22_date_expire\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":320,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"供应商\",\"field_name_en\":\"i22_id_sup\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":330,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_wh\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":340,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_loc\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":350,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_container\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":360,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_int_bag_count\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":370,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_flag_half\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":380,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_flag_checked\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":390,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_flag_occu\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":400,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_flag_closed\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":410,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_terminal\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":420,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_flag_io\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":430,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_serial_ori\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":440,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_scale\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":450,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_flag_tag\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":460,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_flag_bag\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":470,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_dec_weight\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":480,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_dec_qty\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":490,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_source\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":500,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_pack\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":510,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_source_ori\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":520,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_remark\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":530,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_batch_prod\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":540,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_cata\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":550,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"N\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"id\",\"field_name_en\":\"c202_id\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":560,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_dec_weight_ori\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":560,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_date_create\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":570,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"\",\"field_name_en\":\"i22_flag_erp\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":570,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_id_creater\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":580,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_date_erp\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":580,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"状态\",\"field_name_en\":\"c202_flag_state\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":590,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_id_supp\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":590,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_int_line\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":600,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_supp\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":600,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_id_table\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":610,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"N\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"客户id\",\"field_name_en\":\"i22_id_customer\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":610,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_id_audit\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":620,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"var_store\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":620,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_source_item\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":620,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_date_audit\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":630,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"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\":630,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_dec_pack_gross\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":630,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_id_dept\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":640,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_batch_semi\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":640,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_id_com\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":650,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_box_pattern\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":650,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"N\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"主表id\",\"field_name_en\":\"c202_id_main\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":660,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_dec_box_qty\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":660,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_id_supp\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":670,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_date_check\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":670,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"中文拼音\",\"field_name_en\":\"c202_var_spell\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":680,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_checker\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":680,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_var_spell_short\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":690,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_date_check_expire\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":690,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"供应商名称\",\"field_name_en\":\"c202_var_supp\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":700,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_maker\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":700,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_int_level\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":710,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"i22_var_gravity\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":710,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_flag_leaf\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":720,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_id_flow\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":730,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c102_id_item_type\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":730,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_date_audit_act\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":740,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"flag_date\":\"Y\",\"flag_sum\":null,\"var_format\":null,\"var_router\":null,\"var_table\":null,\"var_cond\":null,\"flag_fix\":null},{\"field_name_cn\":\"员工\",\"field_name_en\":\"c202_id_clerk\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":750,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_flag_tax\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":760,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_var_addr\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":770,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_id_industry\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":780,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_int_aging\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":790,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_dec_debt\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":800,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_var_tax\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":810,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_var_bank\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":820,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_var_account\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":830,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_var_contactor\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":840,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_var_tel\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":850,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_flag_currency\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":860,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_flag_type\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":870,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_flag_class\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":880,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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\":\"c202_flag_locked\",\"field_source\":\"\",\"flag_edit_field\":null,\"int_line\":890,\"flag_query\":\"N\",\"int_width\":120,\"flag_show\":\"N\",\"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 inv22.*,c102_var_store AS var_store,c102_id_item_type,i31_date_bill AS date_in \r\nFROM inv22\rLEFT JOIN inv31 ON i22_var_serial = i31_id\r\nleft join ctlm202 as ctlm202_i22_id_sup on inv22.i22_id_sup=ctlm202_i22_id_sup.c202_id \r\nLEFT JOIN ctlm102 ON i22_id_item = c102_id\r\nwhere i22_flag_state=\"正常\"  and ( i22_var_source=\"盘点\" or  i22_var_source=\"盘亏\" or  i22_var_source=\"盘盈\")', `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\":\"text\",\"flag_relate\":\"= \",\"var_fields\":\"i22_id_wh\",\"var_sql\":null,\"flag_required\":null},{\"id_cond\":\"q2\",\"var_label\":\"模糊查询\",\"var_value\":null,\"flag_type\":\"text\",\"flag_relate\":\"likeall\",\"var_fields\":\"i22_var_serial;i22_id_item;i22_var_item;c202_id_supp;c202_var_supp\",\"var_sql\":null,\"flag_required\":null}]', `s005_id_rpt` = 'rpt_i22_qry_whcheck', `s005_var_rpt` = '盘库历史查询', `s005_date_last_edit` = '2025-11-14 16:54:17', `s005_var_fld_relate` = NULL, `s005_var_route` = NULL, `s005_flag_open_type` = NULL, `s005_var_sort` = 'i22_date_create desc' WHERE `s005_id` = '692d4ba7-427d-4c61-ba6b-8051ccc685f0';
UPDATE `sys006` SET `s006_date_create` = '2020-03-31 16:59:47', `s006_id_creater` = 'c186b3da-1f9e-11e9-a0dc-02004c4f4f50', `s006_flag_state` = '正常', `s006_int_line` = 1, `s006_id_table` = NULL, `s006_id_audit` = NULL, `s006_date_audit` = '2020-03-31 16:59:47', `s006_id_dept` = '7bc6d0fd-cc68-11e9-9f24-00163e13f083', `s006_id_com` = '0e4ca95c-8c60-46f5-8c94-46ab44d9da28', `s006_id_main` = NULL, `s006_id_qry` = 'i21_qry_serial_app', `s006_var_qry` = 'app根据流水号查库存信息', `s006_var_sql` = ' select i21_id,i21_date_create,i21_id_creater,i21_flag_state,i21_int_line,i21_date_bill,i21_id_clerk,i21_id_source_table,i21_id_source,i21_bill_no,i21_id_table,i21_int_year,i21_id_audit,i21_date_audit,i21_int_month,i21_id_dept,i21_id_com,i21_id_main,i21_id_flow,i21_date_audit_act,i21_var_bill_ori,i21_var_busi_no,i21_id_item,ctlm102_i21_id_item.c102_var_item as ext_c102_var_item__i21_id_item,ctlm102_i21_id_item.c102_id_pack as ext_c102_id_pack__i21_id_item,ctlm102_i21_id_item.c102_id_prop as ext_c102_id_prop__i21_id_item,ctlm102_i21_id_item.c102_flag_out as ext_c102_flag_out__i21_id_item,ctlm102_i21_id_item.c102_flag_recycle as ext_c102_flag_recycle__i21_id_item,i21_var_item,i21_code_item,i21_var_serial,i21_var_batch,i21_dec_tag,i21_dec_tare,i21_dec_in,i21_dec_end,i21_dec_move,i21_id_unit,i21_date_prod,i21_date_expire,i21_id_sup,ctlm202_i21_id_sup.c202_var_supp as sel_i21_id_sup,i21_dec_in_qty,i21_dec_end_qty,i21_dec_move_qty,i21_id_wh,i21_id_loc,i21_id_container,i21_int_bag_count,i21_flag_half,i21_flag_checked,i21_flag_occu,i21_flag_closed,i21_id_terminal,i21_dec_out,i21_dec_out_qty,i21_flag_lock,i21_flag_tag,i21_id_pack,i21_var_batch_prod ,i21_var_cata,c102_flag_sale,i21_id_supp,i21_var_supp,i21_id_customer,c102_var_store,i21_date_recheck,ctlm102_i21_id_item.c102_id_item_type,i31_date_bill AS date_in\n from inv21\n left join ctlm102 as ctlm102_i21_id_item on i21_id_item=ctlm102_i21_id_item.c102_id\n left join ctlm202 as ctlm202_i21_id_sup on i21_id_sup=ctlm202_i21_id_sup.c202_id   \n LEFT JOIN inv31 ON i31_id = i21_var_serial \nwhere i21_var_serial=:var_serial and i21_id_wh=:id_wh and i21_flag_state=\"正常\"', `s006_var_param` = NULL, `s006_flag_ret` = 'json' WHERE `s006_id` = 'f65ad44c-732d-11ea-9371-20cf30ea973a';
UPDATE `sys006` SET `s006_date_create` = '2023-08-10 10:12:50', `s006_id_creater` = 'c186b3da-1f9e-11e9-a0dc-02004c4f4f50', `s006_flag_state` = '正常', `s006_int_line` = 1, `s006_id_table` = NULL, `s006_id_audit` = NULL, `s006_date_audit` = '2023-08-10 10:12:50', `s006_id_dept` = '7bc6d0fd-cc68-11e9-9f24-00163e13f083', `s006_id_com` = '0e4ca95c-8c60-46f5-8c94-46ab44d9da28', `s006_id_main` = NULL, `s006_id_qry` = 'getI31BySerial', `s006_var_qry` = '根据流水号获取i31数据', `s006_var_sql` = 'SELECT i31_id,i31_flag_state,i31_id_source_table AS i22_id_source_ori,i31_id_creater,i31_var_bill_ori,i31_var_busi_no,i31_id_item,i31_var_item,i31_var_serial,i31_var_batch,i31_dec_tag,i31_dec_tare,0 + CAST(i31_dec_end AS CHAR) AS i31_dec_end,i31_id_unit,i31_date_prod,i31_date_expire,IFNULL(i31_id_sup,\'\') i31_id_sup,c202_var_supp AS sel_i31_id_sup,i31_dec_in_qty,i31_dec_end_qty,i31_id_wh,i31_id_loc,i31_id_container,i31_flag_half,i31_flag_checked,i31_flag_lock,i31_var_batch_prod,IFNULL(i31_var_cata,\'\') i31_var_cata,IFNULL(i31_id_supp,\'\') i31_id_supp,IFNULL(i31_var_supp,\'\') i31_var_supp,i31_flag_inv,i31_dec_pack_gross,IFNULL(c102_var_store,\'\') c102_var_store,c102_var_spec,c102_id_item_type,IFNULL(i31_id_customer,\'\') i31_id_customer,c201_var_corr,i31_var_remark,i31_date_bill,i31_id_pack,i31_date_recheck \nFROM inv31\nLEFT JOIN ctlm102 ON i31_id_item = c102_id\nLEFT JOIN ctlm202 ON i31_id_sup = c202_id\nLEFT JOIN ctlm201 ON c201_id = i31_id_customer	\nWHERE i31_id = :serial', `s006_var_param` = NULL, `s006_flag_ret` = 'json' WHERE `s006_id` = '67f035b2-3723-11ee-889d-52540088346d';
DELIMITER //
DROP PROCEDURE if EXISTs `proc_deal_inv22_back_out`;//
DELIMITER ;

DELIMITER //
CREATE PROCEDURE `proc_deal_inv22_back_out`(IN var_serial VARCHAR(60),in ids varchar(60),in types varchar(60),in var_source varchar(60),out int_result int)
begin
    #退库出库
    set int_result = 0;
		
		DELETE FROM inv21 WHERE i21_var_serial = var_serial;
		#i31_var_cata记录选择的退回仓库
		UPDATE inv31,inv22 
		SET i31_flag_inv = 'back',
		i31_var_remark = i22_var_remark,
		i31_id_loc = '',
		i31_dec_end = i22_dec_weight,
		i31_dec_tag = i22_dec_tag,
		i31_dec_pack_gross = i22_dec_pack_gross,
		i31_var_cata = i22_var_cata,
		i31_id_source_table = i22_id_source_ori,
		i31_dec_end_qty = i22_dec_qty
		WHERE i31_id = var_serial
		AND i22_id = ids;
end//
DELIMITER ;

DELIMITER //
DROP PROCEDURE if EXISTs `proc_deal_pr012_process_copy`;//
DELIMITER;

DELIMITER //
CREATE PROCEDURE `proc_deal_pr012_process_copy`(IN ids VARCHAR(60),IN mcode VARCHAR(60),IN varcode VARCHAR(60))
BEGIN
	#Routine body goes here...

 DECLARE result_code varchar(1) DEFAULT '0';
	
	DECLARE msg text;
	declare str_result VARCHAR(60) DEFAULT 0;
	DECLARE str_id VARCHAR(60);
	declare count1 INTEGER DEFAULT 0;
  DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET result_code = '1';
      START TRANSACTION; 
			
	if varcode='' Then
	select pr01_id into str_id from prod01 where pr01_id_item=mcode and pr01_flag_state='正常' ORDER BY pr01_date_create desc LIMIT 1;
	select count(1) into count1 from prod01 where pr01_id_item=mcode and pr01_flag_state='正常' ORDER BY pr01_date_create desc LIMIT 1;

	ELSE
	select pr01_id into str_id from prod01 where pr01_var_code=varcode and pr01_id_item=mcode and pr01_flag_state='正常' ORDER BY pr01_date_create desc LIMIT 1;
	select count(1) into count1 from prod01 where pr01_var_code=varcode and pr01_id_item=mcode and pr01_flag_state='正常' ORDER BY pr01_date_create desc LIMIT 1;
	end if;
	
	if count1>0 THEN
	#select pr012_var_desc,pr012_var_items,pr012_var_process,pr012_var_group,pr012_flag_check,pr012_flag_phase,pr012_flag_can,pr012_var_title,pr012_flag_time,pr012_var_phase from prod012 where pr012_id_main=str_id;
	
	
	DELETE from prod012 where pr012_id_main=ids;
	
	INSERT INTO prod012(pr012_id,pr012_date_create,pr012_id_creater,pr012_flag_state,pr012_int_line,
	pr012_date_bill,pr012_id_clerk,pr012_id_source_table,pr012_id_source,pr012_bill_no,
	pr012_id_table,pr012_int_year,pr012_id_audit,pr012_date_audit,pr012_int_month,
	pr012_id_dept,pr012_id_com,pr012_id_main,pr012_id_flow,pr012_date_audit_act,
	pr012_dec_times,pr012_var_control1,pr012_var_control2,pr012_var_control3,pr012_var_control4,
	pr012_var_control5,pr012_var_control6,pr012_var_desc,pr012_var_group,pr012_var_items,
	pr012_flag_check,pr012_var_process,pr012_flag_phase,pr012_flag_can,pr012_var_title,
	pr012_flag_time,pr012_var_phase,pr012_flag_type,pr012_var_dura,pr012_var_PH,
	pr012_var_conductivity,pr012_var_speed,pr012_var_temp,pr012_var_wait_dura,pr012_var_min_dura,
	pr012_var_max_dura,pr012_var_min_temp,pr012_var_max_temp,pr012_var_min_speed,pr012_var_max_speed,
	pr012_var_min_ph,pr012_var_max_ph,pr012_var_min_cond,pr012_var_max_cond,pr012_var_min_temp_dura,
	pr012_var_max_temp_dura,pr012_var_min_speed_dura,pr012_var_max_speed_dura,pr012_var_min_homogeneity_dura,pr012_var_max_homogeneity_dura,
	pr012_var_custom,pr012_var_remark,pr012_flag_custom)
	select 
	UUID(),NOW(),pr012_id_creater,'录入',pr012_int_line,
	NOW(),pr012_id_clerk,pr012_id_source_table,pr012_id_source,pr012_bill_no,
	pr012_id_table,pr012_int_year,pr012_id_audit,NOW(),pr012_int_month,
	pr012_id_dept,pr012_id_com,ids,pr012_id_flow,NOW(),
	pr012_dec_times,pr012_var_control1,pr012_var_control2,pr012_var_control3,pr012_var_control4,
	pr012_var_control5,pr012_var_control6,pr012_var_desc,pr012_var_group,pr012_var_items,
	pr012_flag_check,pr012_var_process,pr012_flag_phase,pr012_flag_can,pr012_var_title,
	pr012_flag_time,pr012_var_phase,pr012_flag_type,pr012_var_dura,pr012_var_PH,
	pr012_var_conductivity,pr012_var_speed,pr012_var_temp,pr012_var_wait_dura,pr012_var_min_dura,
	pr012_var_max_dura,pr012_var_min_temp,pr012_var_max_temp,pr012_var_min_speed,pr012_var_max_speed,
	pr012_var_min_ph,pr012_var_max_ph,pr012_var_min_cond,pr012_var_max_cond,pr012_var_min_temp_dura,
	pr012_var_max_temp_dura,pr012_var_min_speed_dura,pr012_var_max_speed_dura,pr012_var_min_homogeneity_dura,pr012_var_max_homogeneity_dura,
	pr012_var_custom,pr012_var_remark,pr012_flag_custom
	from prod012 where pr012_id_main = str_id;
end if;

#select concat(0,'|更新成功');
#select msg;
	if result_code = '1' then
    rollback;
        #select concat(result_code,'|更新失败') as result_code;
    
    set str_result = concat(result_code,'|更新失败') ;
    
    else
        commit;
        #select concat(result_code,'|更新成功') as result_code ;
    
    set str_result =concat(result_code,'|更新成功');
    end if;        
select result_code;
END//
DELIMITER ;