-- 批号属性预制数据
DELETE FROM t_bd_lotcodeitem WHERE FID = 1297107357486279680;
INSERT INTO t_bd_lotcodeitem(FID,FTYPE,FISSYSPRESET,FCREATEORGID,FDISABLEDATE,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FISNULLGENLOT,FDISABLERID) VALUES (1297107357486279680,'A','0',0,NULL,1297107357486279680,'C','GZH_SYS_001',{ts'2021-11-25  00:00:00'},'1',1164445317291206656,{ts'2021-11-25  00:00:00'},1164445317291206656,'0',0);

DELETE FROM t_bd_lotcodeitem_l WHERE FPKID = '21A=Y3K2KL2L';
INSERT INTO t_bd_lotcodeitem_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1297107357486279680,'21A=Y3K2KL2L','zh_CN',' ','跟踪号-单据编号');
DELETE FROM t_bd_lotcodeitem_l WHERE FPKID = '21A=Y3K2KL2M';
INSERT INTO t_bd_lotcodeitem_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1297107357486279680,'21A=Y3K2KL2M','zh_TW',' ','跟蹤號-單據編號');

DELETE FROM t_bd_lotcodeitementry WHERE FENTRYID = 1297107357578554368;
INSERT INTO t_bd_lotcodeitementry(FID,FAPPBILLID,FBILLFIELDID,FENTRYENTITYID,FENTRYID,FSEQ,FBILLFIELDNAME) VALUES (1297107357486279680,'sm_salorder','billno',' ',1297107357578554368,1,'单据头.单据编号');
DELETE FROM t_bd_lotcodeitementry WHERE FENTRYID = 1297107357578554369;
INSERT INTO t_bd_lotcodeitementry(FID,FAPPBILLID,FBILLFIELDID,FENTRYENTITYID,FENTRYID,FSEQ,FBILLFIELDNAME) VALUES (1297107357486279680,'conm_salcontract','billno',' ',1297107357578554369,2,'单据头.合同编号');


DELETE FROM t_bd_lotcodeitem WHERE FID = 1297112445663448064;
INSERT INTO t_bd_lotcodeitem(FID,FTYPE,FISSYSPRESET,FCREATEORGID,FDISABLEDATE,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FISNULLGENLOT,FDISABLERID) VALUES (1297112445663448064,'C','0',0,NULL,1297112445663448064,'C','GZH_SYS_002',{ts'2021-11-25  00:00:00'},'1',1164445317291206656,{ts'2021-11-25  00:00:00'},1164445317291206656,'0',0);

DELETE FROM t_bd_lotcodeitem_l WHERE FPKID = '21AAW6JWNEY3';
INSERT INTO t_bd_lotcodeitem_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1297112445663448064,'21AAW6JWNEY3','zh_CN',' ','跟踪号-行号');
DELETE FROM t_bd_lotcodeitem_l WHERE FPKID = '21AAW6JWNEY4';
INSERT INTO t_bd_lotcodeitem_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1297112445663448064,'21AAW6JWNEY4','zh_TW',' ','跟蹤號-行號');

DELETE FROM t_bd_lotcodeitementry WHERE FENTRYID = 1297112445663448065;
INSERT INTO t_bd_lotcodeitementry(FID,FAPPBILLID,FBILLFIELDID,FENTRYENTITYID,FENTRYID,FSEQ,FBILLFIELDNAME) VALUES (1297112445663448064,'sm_salorder','billentry','sm_salorder',1297112445663448065,1,'物料明细');
DELETE FROM t_bd_lotcodeitementry WHERE FENTRYID = 1297112445663448066;
INSERT INTO t_bd_lotcodeitementry(FID,FAPPBILLID,FBILLFIELDID,FENTRYENTITYID,FENTRYID,FSEQ,FBILLFIELDNAME) VALUES (1297112445663448064,'conm_salcontract','billentry','conm_salcontract',1297112445663448066,2,'物料明细');

-- 批号规则预制数据
DELETE FROM t_bd_lotcoderule WHERE FID = 1297115335580847104;
INSERT INTO t_bd_lotcoderule(FID,FSPLITSIGN,FEXAMPLE,FUSEINTRACKNUMBER,FMASTERID,FCREATETIME,FDESCRIPTION,FUSEINLOT,FMATNUMONLY,FUSEINSERIAL,FNUMBER,FNAME,FDISABLEDATE,FSTATUS,FMODIFIERID,FCREATORID,FENABLE,FMODIFYTIME,FDISABLERID,FCREATEORGID) VALUES (1297115335580847104,'-','跟踪号-单据编号-跟踪号-行号','1',1297115335580847104,{ts'2021-11-25  00:00:00'},' ','0','0','0','GZH_SYS_001','跟踪号规则',NULL,'C',1164445317291206656,1164445317291206656,'1',{ts'2021-11-25  00:00:00'},0,0);

DELETE FROM t_bd_lotcoderule_l WHERE FPKID = '21ABE8VNV3XD';
INSERT INTO t_bd_lotcoderule_l(FID,FLOCALEID,FPKID,FDESCRIPTION,FNAME,FEXAMPLE) VALUES (1297115335580847104,'zh_CN','21ABE8VNV3XD',' ','跟踪号规则','跟踪号-单据编号-跟踪号-行号');
DELETE FROM t_bd_lotcoderule_l WHERE FPKID = '21ABE8VNV3XE';
INSERT INTO t_bd_lotcoderule_l(FID,FLOCALEID,FPKID,FDESCRIPTION,FNAME,FEXAMPLE) VALUES (1297115335580847104,'zh_TW','21ABE8VNV3XE',' ','跟蹤號規則','跟蹤號-單據編號-跟蹤號-行號');
DELETE FROM t_bd_lotcoderule_l WHERE FPKID = '21ABE8VNV3XF';
INSERT INTO t_bd_lotcoderule_l(FID,FLOCALEID,FPKID,FDESCRIPTION,FNAME,FEXAMPLE) VALUES (1297115335580847104,'en_US','21ABE8VNV3XF',' ',' ','-');

DELETE FROM t_bd_lotcoderuleentry WHERE FENTRYID = 1297115335614401536;
INSERT INTO t_bd_lotcoderuleentry(FID,FFORMAT,FLENGTH,FISNUMACCORD,FFORMATVALUE,FADDCHAR,FADDSTYLE,FENTRYID,FSEQ,FSTEP,FLOTPROP,FSETTINGVALUE,FATTUSINGMODE,FCUTSTYLE,FSPLITSIGN) VALUES (1297115335580847104,'正常',0,'1','B',' ',' ',1297115335614401536,1,0,1297107357486279680,' ','A',' ','-');
DELETE FROM t_bd_lotcoderuleentry WHERE FENTRYID = 1297115335614401537;
INSERT INTO t_bd_lotcoderuleentry(FID,FFORMAT,FLENGTH,FISNUMACCORD,FFORMATVALUE,FADDCHAR,FADDSTYLE,FENTRYID,FSEQ,FSTEP,FLOTPROP,FSETTINGVALUE,FATTUSINGMODE,FCUTSTYLE,FSPLITSIGN) VALUES (1297115335580847104,'正常',5,'1','B','0','0',1297115335614401537,2,0,1297112445663448064,' ','B',' ','-');
