--- 库存请检单编码规则
DELETE FROM T_CR_CodeRule WHERE FID = '2YNNNTFPM4JD';
INSERT INTO T_CR_CodeRule(FFILTERCONDITION,FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FISUNIQUE,FMASTERID,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FISUPDATERECOVER,FENABLE,FISAPPORG,FISSERIALNUMBER,FISCHECKCODE,FID,FSPLITSIGN,FCTRLMODE,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID,FCONDITIONDESC) VALUES (' ',' ','2','1','0','0','2YNNNTFPM4JD','0',{ts'2022-12-16  00:00:00'},'im_invinspectbill','0','1','0','1','0','2YNNNTFPM4JD','-','1','0','C','KCQJ',' ','1',1155582543786049536,'0',{ts'2022-12-16  00:00:00'},0,' ');

DELETE FROM T_CR_CodeRule_L WHERE FPKID = '2YNNNTFPKA67';
INSERT INTO T_CR_CodeRule_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2YNNNTFPM4JD','2YNNNTFPKA67','zh_CN','库存请检单编码规则');
DELETE FROM T_CR_CodeRule_L WHERE FPKID = '2YNNT=XUXQZ1';
INSERT INTO T_CR_CodeRule_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2YNNNTFPM4JD','2YNNT=XUXQZ1','zh_TW','庫存請檢單編碼規則');

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2YOCDPZZ98==';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FISSPLITSIGN,FVALUEATRIBUTE,FADDCHAR) VALUES ('2YNNNTFPM4JD',1,'1',' ','0','2YOCDPZZ98==',1,'1','1',0,'1',8,'KCQJ','1',' ','0',' ',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2YOCDPZZ98=A';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FISSPLITSIGN,FVALUEATRIBUTE,FADDCHAR) VALUES ('2YNNNTFPM4JD',1,'2','-','1','2YOCDPZZ98=A',1,'1',' ',1,'1',8,'yyMMdd','1',' ','1','biztime',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2YOCDPZZ98=B';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FISVISABLE,FLENGTH,FFORMAT,FADDSTYLE,FSETTINGVALUE,FISSPLITSIGN,FVALUEATRIBUTE,FADDCHAR) VALUES ('2YNNNTFPM4JD',1,'16','-','0','2YOCDPZZ98=B',1,'1',' ',2,'1',6,' ','1',' ','1',' ',' ');

-- 单据类型
DELETE FROM T_BAS_BILLTYPE WHERE FID = 1576218547397342208;
INSERT INTO T_BAS_BILLTYPE(FID,FISSYSPRESET,FDOCUMENTSTATUS,FDEFWNREPORTTEMPLATE,FISDEFAULT,FDEFPRINTTEMPLATE,FCONTROLPRINTCOUNT,FMASTERID,FSTATUS,FBILLFORMID,FMAXPRINTCOUNT,FBILLCODERULEID,FBILLINITSETTING,FNUMBER,FCREATETIME,FLAYOUTSOLUTION,FPARASETTINGXML,FMODIFIERID,FENABLE,FMODIFYTIME,FPRINTAFTERAUDIT,FCREATORID) VALUES (1576218547397342208,'0','0',NULL,'1',' ','0',1576218547397342208,'C','im_invinspectbill',1,' ',' ','im_invinspectbill_BT_S',{ts'2022-12-15  00:00:00'},'2X5BXAG89SZW',NULL,1155582543786049536,'1',{ts'2022-12-16  00:00:00'},'1',1155582543786049536);

DELETE FROM T_BAS_BILLTYPE_l WHERE FPKID = '2YLHNKXFION2';
INSERT INTO T_BAS_BILLTYPE_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1576218547397342208,'2YLHNKXFION2','zh_CN',' ','标准库存请检单');
DELETE FROM T_BAS_BILLTYPE_l WHERE FPKID = '2YLHNKXFION3';
INSERT INTO T_BAS_BILLTYPE_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1576218547397342208,'2YLHNKXFION3','zh_TW',' ','標準庫存請檢單');

DELETE FROM t_bas_billtypeparameter WHERE FFORMID = 'im_invinspectbill' and FBILLTYPEID = 1576218547397342208;
INSERT INTO t_bas_billtypeparameter(FFORMID,FBILLTYPEID,FDATA) VALUES ('im_invinspectbill',1576218547397342208,'{"_Type_":"bd_billtypeparameter","entryentity":[{"_Type_":"entryentity","biztypenumber":{"number":"210","masterid":422876630176775168,"_Type_":"bd_biztype","multilanguagetext":[{"_Type_":"locale","pkid":"04L7BOJGZ+RY","name":"物料类销售","description":"","localeid":"zh_CN"},{"_Type_":"locale","pkid":"04L7BOJGZ+RZ","name":"物料類銷售","description":"","localeid":"zh_TW"}],"ispreset":true,"name":{"zh_TW":"物料類銷售","zh_CN":"物料类销售"},"id":422876630176775168},"ispreset":true,"biztypenumber_id":422876630176775168,"id":0,"isdefault":true,"seq":1},{"_Type_":"entryentity","biztypenumber":{"number":"2101","masterid":688855385217756160,"_Type_":"bd_biztype","multilanguagetext":[{"_Type_":"locale","pkid":"04L7ND932ZX3","name":"物料类销售退货","description":"","localeid":"zh_CN"},{"_Type_":"locale","pkid":"04L7ND932ZX4","name":"物料類銷售退貨","description":"","localeid":"zh_TW"}],"ispreset":true,"name":{"zh_TW":"物料類銷售退貨","zh_CN":"物料类销售退货"},"id":688855385217756160},"ispreset":true,"biztypenumber_id":688855385217756160,"id":0,"isdefault":false,"seq":2}]}');


--收发类型 410
DELETE FROM t_sbd_transceivertype WHERE FID = 1575990703282992128;
INSERT INTO t_sbd_transceivertype(FID,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FBIZDIRECTION,FENABLE,FMODIFIERID,FTRANSCEIVER,FISPRESET,FMODIFYTIME,FFORWARDTYPE,FCREATORID,FDISABLERID) VALUES (1575990703282992128,NULL,' ',1575990703282992128,'C','410','可用转待检',{ts'2022-12-15  00:00:00'},'0','1',1155582543786049536,'2','1',{ts'2022-12-15  00:00:00'},0,1155582543786049536,0);

DELETE FROM t_sbd_transceivertype_l WHERE FPKID = '2YKE2=GTRYRK';
INSERT INTO t_sbd_transceivertype_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1575990703282992128,'2YKE2=GTRYRK','zh_CN',' ','可用转待检');
DELETE FROM t_sbd_transceivertype_l WHERE FPKID = '2YKE2=GTRYRL';
INSERT INTO t_sbd_transceivertype_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1575990703282992128,'2YKE2=GTRYRL','zh_TW',' ','可用轉待檢');

--收发类型420
DELETE FROM t_sbd_transceivertype WHERE FID = 1576001318999415808;
INSERT INTO t_sbd_transceivertype(FID,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FBIZDIRECTION,FENABLE,FMODIFIERID,FTRANSCEIVER,FISPRESET,FMODIFYTIME,FFORWARDTYPE,FCREATORID,FDISABLERID) VALUES (1576001318999415808,NULL,' ',1576001318999415808,'C','420','待检转可用、不良',{ts'2022-12-15  00:00:00'},'1','1',1155582543786049536,'2','1',{ts'2022-12-15  00:00:00'},1575990703282992128,1155582543786049536,0);

DELETE FROM t_sbd_transceivertype_l WHERE FPKID = '2YKG1N8BPB=V';
INSERT INTO t_sbd_transceivertype_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1576001318999415808,'2YKG1N8BPB=V','zh_CN',' ','待检转可用、不良');
DELETE FROM t_sbd_transceivertype_l WHERE FPKID = '2YKG1N8BPB=W';
INSERT INTO t_sbd_transceivertype_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1576001318999415808,'2YKG1N8BPB=W','zh_TW',' ','待檢轉可用、不良');
