DELETE FROM T_BD_MATCHOUT_RULE WHERE FID = 1483907974299687936;
INSERT INTO T_BD_MATCHOUT_RULE(FID,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FENABLE,FMODIFIERID,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1483907974299687936,1483907974299687936,'C','CKGZ-001','按批号先进先出',{ts'2022-08-10  00:00:00'},'1',1155774599271726080,'1',{ts'2022-08-10  00:00:00'},1155774599271726080); 
DELETE FROM T_BD_MATCHOUT_RULE_L WHERE FPKID = '2N98U/RLKT91';
INSERT INTO T_BD_MATCHOUT_RULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1483907974299687936,'2N98U/RLKT91','zh_CN','按批号先进先出'); 
DELETE FROM T_BD_MATCHOUT_RULE_L WHERE FPKID = '2N98U/RLKT92';
INSERT INTO T_BD_MATCHOUT_RULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1483907974299687936,'2N98U/RLKT92','zh_TW','按批號先進先出'); 
DELETE FROM T_BD_MATCHOUT_ORDER WHERE FENTRYID = 1483907974475847680;
INSERT INTO T_BD_MATCHOUT_ORDER(FID,FTYPE,FCUSTOMORDER,FSOURCE,FENTRYID,FSEQ,FSRCCOL,FSRCCOLNAME) VALUES (1483907974299687936,'asc',' ','im_lotintrack',1483907974475847680,1,'biztime','业务日期'); 
DELETE FROM T_BD_MATCHOUT_ORDER WHERE FENTRYID = 1483907974475847681;
INSERT INTO T_BD_MATCHOUT_ORDER(FID,FTYPE,FCUSTOMORDER,FSOURCE,FENTRYID,FSEQ,FSRCCOL,FSRCCOLNAME) VALUES (1483907974299687936,'asc',' ','im_lotintrack',1483907974475847681,2,'createtime','创建时间'); 
DELETE FROM T_BD_MATCHOUT_ORDER WHERE FENTRYID = 1483907974475847682;
INSERT INTO T_BD_MATCHOUT_ORDER(FID,FTYPE,FCUSTOMORDER,FSOURCE,FENTRYID,FSEQ,FSRCCOL,FSRCCOLNAME) VALUES (1483907974299687936,'asc',' ','im_lotintrack',1483907974475847682,3,'lotnumber','批号'); 

DELETE FROM T_BD_MATCHOUT_RULE WHERE FID = 1483908554707474432;
INSERT INTO T_BD_MATCHOUT_RULE(FID,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FENABLE,FMODIFIERID,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1483908554707474432,1483908554707474432,'C','CKGZ-002','按批号后进先出',{ts'2022-08-10  00:00:00'},'1',1155774599271726080,'1',{ts'2022-08-10  00:00:00'},1155774599271726080); 
DELETE FROM T_BD_MATCHOUT_RULE_L WHERE FPKID = '2N98Y8NSR=F3';
INSERT INTO T_BD_MATCHOUT_RULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1483908554707474432,'2N98Y8NSR=F3','zh_CN','按批号后进先出'); 
DELETE FROM T_BD_MATCHOUT_RULE_L WHERE FPKID = '2N98Y8NSR=F4';
INSERT INTO T_BD_MATCHOUT_RULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1483908554707474432,'2N98Y8NSR=F4','zh_TW','按批號後進先出'); 
DELETE FROM T_BD_MATCHOUT_ORDER WHERE FENTRYID = 1483908554724252672;
INSERT INTO T_BD_MATCHOUT_ORDER(FID,FTYPE,FCUSTOMORDER,FSOURCE,FENTRYID,FSEQ,FSRCCOL,FSRCCOLNAME) VALUES (1483908554707474432,'desc',' ','im_lotintrack',1483908554724252672,1,'biztime','业务日期'); 
DELETE FROM T_BD_MATCHOUT_ORDER WHERE FENTRYID = 1483908554724252673;
INSERT INTO T_BD_MATCHOUT_ORDER(FID,FTYPE,FCUSTOMORDER,FSOURCE,FENTRYID,FSEQ,FSRCCOL,FSRCCOLNAME) VALUES (1483908554707474432,'desc',' ','im_lotintrack',1483908554724252673,2,'createtime','创建时间'); 
DELETE FROM T_BD_MATCHOUT_ORDER WHERE FENTRYID = 1483908554724252674;
INSERT INTO T_BD_MATCHOUT_ORDER(FID,FTYPE,FCUSTOMORDER,FSOURCE,FENTRYID,FSEQ,FSRCCOL,FSRCCOLNAME) VALUES (1483908554707474432,'desc',' ','im_lotintrack',1483908554724252674,3,'lotnumber','批号'); 

DELETE FROM T_BD_MATCHOUT_RULE WHERE FID = 1483909150080539648;
INSERT INTO T_BD_MATCHOUT_RULE(FID,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FENABLE,FMODIFIERID,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1483909150080539648,1483909150080539648,'C','CKGZ-003','按批号顺序',{ts'2022-08-10  00:00:00'},'1',1155774599271726080,'1',{ts'2022-08-10  00:00:00'},1155774599271726080); 
DELETE FROM T_BD_MATCHOUT_RULE_L WHERE FPKID = '2N990KVLNE==';
INSERT INTO T_BD_MATCHOUT_RULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1483909150080539648,'2N990KVLNE==','zh_CN','按批号顺序'); 
DELETE FROM T_BD_MATCHOUT_RULE_L WHERE FPKID = '2N990KVLNE=A';
INSERT INTO T_BD_MATCHOUT_RULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1483909150080539648,'2N990KVLNE=A','zh_TW','按批號順序'); 
DELETE FROM T_BD_MATCHOUT_ORDER WHERE FENTRYID = 1483909150097315840;
INSERT INTO T_BD_MATCHOUT_ORDER(FID,FTYPE,FCUSTOMORDER,FSOURCE,FENTRYID,FSEQ,FSRCCOL,FSRCCOLNAME) VALUES (1483909150080539648,'asc',' ','im_inv_realbalance',1483909150097315840,1,'lotnum','批号'); 

DELETE FROM T_BD_MATCHOUT_RULE WHERE FID = 1483909655292845056;
INSERT INTO T_BD_MATCHOUT_RULE(FID,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FENABLE,FMODIFIERID,FISPRESET,FMODIFYTIME,FCREATORID) VALUES (1483909655292845056,1483909655292845056,'C','CKGZ-004','按近效期',{ts'2022-08-10  00:00:00'},'1',1155774599271726080,'1',{ts'2022-08-10  00:00:00'},1155774599271726080); 
DELETE FROM T_BD_MATCHOUT_RULE_L WHERE FPKID = '2N9949F4+//E';
INSERT INTO T_BD_MATCHOUT_RULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1483909655292845056,'2N9949F4+//E','zh_CN','按近效期'); 
DELETE FROM T_BD_MATCHOUT_RULE_L WHERE FPKID = '2N9949F4+//F';
INSERT INTO T_BD_MATCHOUT_RULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1483909655292845056,'2N9949F4+//F','zh_TW','按近效期'); 
DELETE FROM T_BD_MATCHOUT_ORDER WHERE FENTRYID = 1483909655309621248;
INSERT INTO T_BD_MATCHOUT_ORDER(FID,FTYPE,FCUSTOMORDER,FSOURCE,FENTRYID,FSEQ,FSRCCOL,FSRCCOLNAME) VALUES (1483909655292845056,'asc',' ','im_lotintrack',1483909655309621248,1,'expirydate','到期日期'); 

