--成组关系添加请检单配置
--牟润发0721

--更新CZ-YS-01
DELETE FROM t_im_bgsetentry WHERE FENTRYID = 1726015427248782336;
INSERT INTO t_im_bgsetentry(FID,FTYPE,FEISPRESET,FTEXT2LONG,FFORMID,FFILTERJSON_TAG,FENTRYID,FCFILTERJSON_TAG,FRELTYPE,FCFILTERJSON,FFILTERJSON,FFILTER,FSELFIELD,FRELFIELD,FSEQ,FGROUPBILLNAME,FCFILTER) VALUES (1668140785607938048,'2','1',' ','im_invinspectbill',' ',1726015427248782336,' ','A',' ',' ',' ',' ',' ',9,'库存请检单',' '); 
DELETE FROM T_IM_BGSETENTRY_L WHERE FPKID = '3E/5JWP0JY2+';
INSERT INTO T_IM_BGSETENTRY_L(FPKID,FLOCALEID,FENTRYID,FGROUPBILLNAME) VALUES ('3E/5JWP0JY2+','zh_CN',1726015427248782336,'库存请检单'); 
DELETE FROM T_IM_BGSETENTRY_L WHERE FPKID = '3E/5JWP0JY2/';
INSERT INTO T_IM_BGSETENTRY_L(FPKID,FLOCALEID,FENTRYID,FGROUPBILLNAME) VALUES ('3E/5JWP0JY2/','zh_TW',1726015427248782336,'庫存請檢單'); 


DELETE FROM T_IM_BGSET WHERE FID = 1726018586759261184;
INSERT INTO T_IM_BGSET(FID,FGROUPTYPE,FMASTERID,FSTATUS,FPRIORITY,FNUMBER,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FREMARK,FMODIFYTIME,FCREATORID) VALUES (1726018586759261184,'A',1726018586759261184,'A',200,'CZ-YS-020','请检可用-形态转换（成组号）',{ts'2023-07-10  00:00:00'},13466739,'1','1',' ',{ts'2023-07-10  00:00:00'},13466739); 
DELETE FROM T_IM_BGSET WHERE FID = 1726019418766450688;
INSERT INTO T_IM_BGSET(FID,FGROUPTYPE,FMASTERID,FSTATUS,FPRIORITY,FNUMBER,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FREMARK,FMODIFYTIME,FCREATORID) VALUES (1726019418766450688,'A',1726019418766450688,'A',210,'CZ-YS-021','请检可用-形态转换（分录）',{ts'2023-07-10  00:00:00'},13466739,'1','1',' ',{ts'2023-07-10  00:00:00'},13466739); 

DELETE FROM T_IM_BGSET_L WHERE FPKID = '3E/64XMZP62F';
INSERT INTO T_IM_BGSET_L(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1726018586759261184,'3E/64XMZP62F','zh_CN',' ','请检可用-形态转换（成组号）'); 
DELETE FROM T_IM_BGSET_L WHERE FPKID = '3E/64XMZP62G';
INSERT INTO T_IM_BGSET_L(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1726018586759261184,'3E/64XMZP62G','zh_TW',' ','請檢可用-形態轉換（成組號）'); 
DELETE FROM T_IM_BGSET_L WHERE FPKID = '3E/6A+EBMWVA';
INSERT INTO T_IM_BGSET_L(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1726019418766450688,'3E/6A+EBMWVA','zh_CN',' ','请检可用-形态转换（分录）'); 
DELETE FROM T_IM_BGSET_L WHERE FPKID = '3E/6A+EBMWVB';
INSERT INTO T_IM_BGSET_L(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1726019418766450688,'3E/6A+EBMWVB','zh_TW',' ','請檢可用-形態轉換（分錄）'); 


DELETE FROM T_IM_BGSETENTRY WHERE FENTRYID = 1726018586901867521;
INSERT INTO T_IM_BGSETENTRY(FID,FTYPE,FEISPRESET,FTEXT2LONG,FFORMID,FFILTERJSON_TAG,FENTRYID,FCFILTERJSON_TAG,FRELTYPE,FCFILTERJSON,FFILTERJSON,FFILTER,FSELFIELD,FRELFIELD,FSEQ,FGROUPBILLNAME,FCFILTER) VALUES (1726018586759261184,'1','1',' ','im_adjustbill','{"filterRow":[{"id":"3EQE4N/=ME4C","leftBracket":"","compareType":"105","fieldName":"ownertype","rightBracket":"","logic":"0","value":[{"id":"3EQE4N/=METM","value":"bos_org"}],"baseDataIds":[]},{"id":"3EQE4N/=ME4D","leftBracket":"","compareType":"21","fieldName":"baseqty","rightBracket":"","logic":"0","value":[{"id":"3EQE4N/=METN","value":"0"}],"baseDataIds":[]},{"id":"3EQE4N/=ME4E","leftBracket":"","compareType":"105","fieldName":"ischargeoff","rightBracket":"","logic":"0","value":[{"id":"3EQE4N/=METO","value":"0"}],"baseDataIds":[]},{"id":"3EQE4N/=ME4F","leftBracket":"","compareType":"9","fieldName":"groupseq","rightBracket":"","logic":"0","value":[{"id":"3EQE4N/=METP","value":""}],"baseDataIds":[]}],"forList":false}',1726018586901867521,' ',' ',' ',' ','转换前物料明细.出库货主类型 等于 核算组织   and    转换前物料明细.基本数量 大于 0   and    冲销 等于 否   and    转换前物料明细.成组行号 不为空','id as dest_bizbillid,billentry.id as dest_bizentryid,billno as dest_billno,bookdate as dest_bookdate,biztime as dest_bizdate,billentry.material.masterid as dest_material,billentry.owner as dest_owner,billentry.baseqty as dest_baseqty,''im_adjustbill'' as dest_formid,''0'' as dest_islastentry,billentry.groupnumber,billentry.groupseq,billentry.owner','billentry.groupnumber,billentry.groupseq,billentry.owner',2,'形态转换单',' '); 
DELETE FROM T_IM_BGSETENTRY WHERE FENTRYID = 1726019420066684928;
INSERT INTO T_IM_BGSETENTRY(FID,FTYPE,FEISPRESET,FTEXT2LONG,FFORMID,FFILTERJSON_TAG,FENTRYID,FCFILTERJSON_TAG,FRELTYPE,FCFILTERJSON,FFILTERJSON,FFILTER,FSELFIELD,FRELFIELD,FSEQ,FGROUPBILLNAME,FCFILTER) VALUES (1726019418766450688,'0','1','id,billentry.id','im_invinspectbill','{"filterRow":[{"id":"3E/5WK+ZYS1I","leftBracket":"","compareType":"105","fieldName":"outownertype","rightBracket":"","logic":"0","value":[{"id":"3E/5WK+ZYSQS","value":"bos_org"}],"baseDataIds":[]},{"id":"3E/5WK+ZYS1J","leftBracket":"","compareType":"21","fieldName":"baseqty","rightBracket":"","logic":"0","value":[{"id":"3E/5WK+ZYSQT","value":"0"}],"baseDataIds":[]},{"id":"3E/5WK+ZYS1K","leftBracket":"","compareType":"105","fieldName":"ischargeoff","rightBracket":"","logic":"0","value":[{"id":"3E/5WK+ZYSQU","value":"0"}],"baseDataIds":[]},{"id":"3E/5WK+ZYS1L","leftBracket":"","compareType":"105","fieldName":"logisticsbill","rightBracket":"","logic":"0","value":[{"id":"3E/5WK+ZYSQV","value":"0"}],"baseDataIds":[]}],"forList":false}',1726019420066684928,' ',' ',' ',' ','物料明细.出库货主类型 等于 核算组织   and    物料明细.基本数量 大于 0   and    冲销 等于 否   and    物料明细.物流单据 等于 否','id as src_bizbillid,billentry.id as src_bizentryid,billno as src_billno,bookdate as src_bookdate,biztime as src_bizdate,billentry.material.masterid as src_material, case when billentry.owner is not null and billentry.owner <> 0L then billentry.owner else billentry.outowner end  as src_owner,billentry.baseqty as src_baseqty,''im_invinspectbill'' as src_formid,''0'' as src_islastentry,TOCHAR(id) as id,TOCHAR(billentry.id) as billentry.id,billentry.outowner','id,billentry.id,billentry.outowner',1,'库存请检单',' '); 
DELETE FROM T_IM_BGSETENTRY WHERE FENTRYID = 1726018586901867520;
INSERT INTO T_IM_BGSETENTRY(FID,FTYPE,FEISPRESET,FTEXT2LONG,FFORMID,FFILTERJSON_TAG,FENTRYID,FCFILTERJSON_TAG,FRELTYPE,FCFILTERJSON,FFILTERJSON,FFILTER,FSELFIELD,FRELFIELD,FSEQ,FGROUPBILLNAME,FCFILTER) VALUES (1726018586759261184,'0','1',' ','im_invinspectbill','{"filterRow":[{"id":"3E/5WK+ZYS1I","leftBracket":"","compareType":"105","fieldName":"outownertype","rightBracket":"","logic":"0","value":[{"id":"3E/5WK+ZYSQS","value":"bos_org"}],"baseDataIds":[]},{"id":"3E/5WK+ZYS1J","leftBracket":"","compareType":"21","fieldName":"baseqty","rightBracket":"","logic":"0","value":[{"id":"3E/5WK+ZYSQT","value":"0"}],"baseDataIds":[]},{"id":"3E/5WK+ZYS1K","leftBracket":"","compareType":"105","fieldName":"ischargeoff","rightBracket":"","logic":"0","value":[{"id":"3E/5WK+ZYSQU","value":"0"}],"baseDataIds":[]},{"id":"3E/5WK+ZYS1L","leftBracket":"","compareType":"105","fieldName":"logisticsbill","rightBracket":"","logic":"0","value":[{"id":"3E/5WK+ZYSQV","value":"0"}],"baseDataIds":[]}],"forList":false}',1726018586901867520,' ',' ',' ',' ','物料明细.出库货主类型 等于 核算组织   and    物料明细.基本数量 大于 0   and    冲销 等于 否   and    物料明细.物流单据 等于 否','id as src_bizbillid,billentry.id as src_bizentryid,billno as src_billno,bookdate as src_bookdate,biztime as src_bizdate,billentry.material.masterid as src_material, case when billentry.owner is not null and billentry.owner <> 0L then billentry.owner else billentry.outowner end  as src_owner,billentry.baseqty as src_baseqty,''im_invinspectbill'' as src_formid,''0'' as src_islastentry,billentry.groupnumber,billentry.groupseq,billentry.outowner','billentry.groupnumber,billentry.groupseq,billentry.outowner',1,'库存请检单',' '); 
DELETE FROM T_IM_BGSETENTRY WHERE FENTRYID = 1726019420066684929;
INSERT INTO T_IM_BGSETENTRY(FID,FTYPE,FEISPRESET,FTEXT2LONG,FFORMID,FFILTERJSON_TAG,FENTRYID,FCFILTERJSON_TAG,FRELTYPE,FCFILTERJSON,FFILTERJSON,FFILTER,FSELFIELD,FRELFIELD,FSEQ,FGROUPBILLNAME,FCFILTER) VALUES (1726019418766450688,'1','1',' ','im_adjustbill','{"filterRow":[{"id":"3EQEB6DI9PX=","leftBracket":"","compareType":"105","fieldName":"ownertype","rightBracket":"","logic":"0","value":[{"id":"3EQEB6DI9P80","value":"bos_org"}],"baseDataIds":[]},{"id":"3EQEB6DI9PXA","leftBracket":"","compareType":"21","fieldName":"baseqty","rightBracket":"","logic":"0","value":[{"id":"3EQEB6DI9P81","value":"0"}],"baseDataIds":[]},{"id":"3EQEB6DI9PXB","leftBracket":"","compareType":"105","fieldName":"ischargeoff","rightBracket":"","logic":"0","value":[{"id":"3EQEB6DI9P82","value":"0"}],"baseDataIds":[]},{"id":"3EQEB6DI9PXC","leftBracket":"","compareType":"9","fieldName":"groupseq","rightBracket":"","logic":"0","value":[{"id":"3EQEB6DI9P83","value":""}],"baseDataIds":[]}],"forList":false}',1726019420066684929,' ',' ',' ',' ','转换前物料明细.出库货主类型 等于 核算组织   and    转换前物料明细.基本数量 大于 0   and    冲销 等于 否   and    转换前物料明细.成组行号 不为空','id as dest_bizbillid,billentry.id as dest_bizentryid,billno as dest_billno,bookdate as dest_bookdate,biztime as dest_bizdate,billentry.material.masterid as dest_material,billentry.owner as dest_owner,billentry.baseqty as dest_baseqty,''im_adjustbill'' as dest_formid,''0'' as dest_islastentry,billentry.groupnumber,billentry.groupseq,billentry.owner','billentry.groupnumber,billentry.groupseq,billentry.owner',2,'形态转换单',' '); 
 


DELETE FROM T_IM_BGSETENTRY_L WHERE FPKID = '3E/64XMZP62H';
INSERT INTO T_IM_BGSETENTRY_L(FPKID,FLOCALEID,FENTRYID,FGROUPBILLNAME) VALUES ('3E/64XMZP62H','zh_CN',1726018586901867520,'库存请检单'); 
DELETE FROM T_IM_BGSETENTRY_L WHERE FPKID = '3E/64XMZP62I';
INSERT INTO T_IM_BGSETENTRY_L(FPKID,FLOCALEID,FENTRYID,FGROUPBILLNAME) VALUES ('3E/64XMZP62I','zh_TW',1726018586901867520,'庫存請檢單'); 
DELETE FROM T_IM_BGSETENTRY_L WHERE FPKID = '3E/64XMZP62J';
INSERT INTO T_IM_BGSETENTRY_L(FPKID,FLOCALEID,FENTRYID,FGROUPBILLNAME) VALUES ('3E/64XMZP62J','zh_CN',1726018586901867521,'形态转换单'); 
DELETE FROM T_IM_BGSETENTRY_L WHERE FPKID = '3E/64XMZP62K';
INSERT INTO T_IM_BGSETENTRY_L(FPKID,FLOCALEID,FENTRYID,FGROUPBILLNAME) VALUES ('3E/64XMZP62K','zh_TW',1726018586901867521,'形態轉換單'); 
DELETE FROM T_IM_BGSETENTRY_L WHERE FPKID = '3E/6A+EBMWVC';
INSERT INTO T_IM_BGSETENTRY_L(FPKID,FLOCALEID,FENTRYID,FGROUPBILLNAME) VALUES ('3E/6A+EBMWVC','zh_TW',1726019420066684928,'庫存請檢單'); 
DELETE FROM T_IM_BGSETENTRY_L WHERE FPKID = '3E/6A+EBMWVD';
INSERT INTO T_IM_BGSETENTRY_L(FPKID,FLOCALEID,FENTRYID,FGROUPBILLNAME) VALUES ('3E/6A+EBMWVD','zh_CN',1726019420066684928,'库存请检单'); 
DELETE FROM T_IM_BGSETENTRY_L WHERE FPKID = '3E/6A+EBMWVE';
INSERT INTO T_IM_BGSETENTRY_L(FPKID,FLOCALEID,FENTRYID,FGROUPBILLNAME) VALUES ('3E/6A+EBMWVE','zh_TW',1726019420066684929,'形態轉換單'); 
DELETE FROM T_IM_BGSETENTRY_L WHERE FPKID = '3E/6A+EBMWVF';
INSERT INTO T_IM_BGSETENTRY_L(FPKID,FLOCALEID,FENTRYID,FGROUPBILLNAME) VALUES ('3E/6A+EBMWVF','zh_CN',1726019420066684929,'形态转换单'); 


DELETE FROM T_IM_BGSETRENTRY WHERE FENTRYID = 1726018586901867522;
INSERT INTO T_IM_BGSETRENTRY(FID,FFIELDKEY0,FFIELDKEY1,FENTRYID,FFIELDKEY2,FFIELDKEY3,FFIELDKEY4,FFIELDNAME4,FFIELDNAME3,FFIELDNAME2,FFIELDNAME1,FFIELDNAME0,FSEQ) VALUES (1726018586759261184,'groupnumber','groupnumber',1726018586901867522,' ',' ',' ',' ',' ',' ','转换前物料明细.成组号','物料明细.成组号',1); 
DELETE FROM T_IM_BGSETRENTRY WHERE FENTRYID = 1726018586901867523;
INSERT INTO T_IM_BGSETRENTRY(FID,FFIELDKEY0,FFIELDKEY1,FENTRYID,FFIELDKEY2,FFIELDKEY3,FFIELDKEY4,FFIELDNAME4,FFIELDNAME3,FFIELDNAME2,FFIELDNAME1,FFIELDNAME0,FSEQ) VALUES (1726018586759261184,'groupseq','groupseq',1726018586901867523,' ',' ',' ',' ',' ',' ','转换前物料明细.成组行号','物料明细.成组行号',2); 
DELETE FROM T_IM_BGSETRENTRY WHERE FENTRYID = 1726018586901867524;
INSERT INTO T_IM_BGSETRENTRY(FID,FFIELDKEY0,FFIELDKEY1,FENTRYID,FFIELDKEY2,FFIELDKEY3,FFIELDKEY4,FFIELDNAME4,FFIELDNAME3,FFIELDNAME2,FFIELDNAME1,FFIELDNAME0,FSEQ) VALUES (1726018586759261184,'outowner','owner',1726018586901867524,' ',' ',' ',' ',' ',' ','转换前物料明细.出库货主','物料明细.出库货主',3); 
DELETE FROM T_IM_BGSETRENTRY WHERE FENTRYID = 1726019420066684930;
INSERT INTO T_IM_BGSETRENTRY(FID,FFIELDKEY0,FFIELDKEY1,FENTRYID,FFIELDKEY2,FFIELDKEY3,FFIELDKEY4,FFIELDNAME4,FFIELDNAME3,FFIELDNAME2,FFIELDNAME1,FFIELDNAME0,FSEQ) VALUES (1726019418766450688,'billentry.id','groupseq',1726019420066684930,' ',' ',' ',' ',' ',' ','转换前物料明细.成组行号','物料明细.id',1); 
DELETE FROM T_IM_BGSETRENTRY WHERE FENTRYID = 1726019420066684931;
INSERT INTO T_IM_BGSETRENTRY(FID,FFIELDKEY0,FFIELDKEY1,FENTRYID,FFIELDKEY2,FFIELDKEY3,FFIELDKEY4,FFIELDNAME4,FFIELDNAME3,FFIELDNAME2,FFIELDNAME1,FFIELDNAME0,FSEQ) VALUES (1726019418766450688,'outowner','owner',1726019420066684931,' ',' ',' ',' ',' ',' ','转换前物料明细.出库货主','物料明细.出库货主',2); 



