
-- 领料出库单预置校验器脚本
DELETE FROM T_IM_VALIDATORCFG WHERE fid = 1236902106594541568;
INSERT INTO T_IM_VALIDATORCFG(fid,fvalidatebill,fmasterid,fstatus,fname,fnumber,fcreatetime,fquoteplugin,fmodifierid,fenable,fispreset,fmodifytime,floadplugin,fcreatorid) VALUES (1236902106594541568,'im_materialreqoutbill',1236902106594541568,'C',' ','im_materialreqoutbill',{ts'2021-09-03  00:00:00'},1183172751180012544,275188253840125478,'1','0',{ts'2021-09-03  00:00:00'},' ',275188253840125478); 

DELETE FROM t_im_validatorcfg_l WHERE fpkid = '1VXWM18C=1=L';
INSERT INTO t_im_validatorcfg_l(fid,fpkid,flocaleid,fname) VALUES (1236902106594541568,'1VXWM18C=1=L','zh_CN',' '); 
DELETE FROM t_im_validatorcfg_l WHERE fpkid = '1VXWM18C=1=M';
INSERT INTO t_im_validatorcfg_l(fid,fpkid,flocaleid,fname) VALUES (1236902106594541568,'1VXWM18C=1=M','zh_TW',' '); 



DELETE FROM t_im_validatorcfgentry WHERE fentryid = 1236902106628097024;
INSERT INTO t_im_validatorcfgentry(fid,fquoteentryid,fisquote,fop,fentryid,fseq,fisenable,fdescription,fimplclass) VALUES (1236902106594541568,1183991205164417024,'1','save',1236902106628097024,1,'1','库存单据业务日期校验器','kd.scmc.im.validator.tpl.BillBizDateValidator'); 
DELETE FROM t_im_validatorcfgentry WHERE fentryid = 1236902106628097025;
INSERT INTO t_im_validatorcfgentry(fid,fquoteentryid,fisquote,fop,fentryid,fseq,fisenable,fdescription,fimplclass) VALUES (1236902106594541568,1183991205164417025,'1','save',1236902106628097025,2,'1','仓库物料校验','kd.scmc.im.validator.tpl.WarehouseMaterialValidator'); 
DELETE FROM t_im_validatorcfgentry WHERE fentryid = 1236902106628097026;
INSERT INTO t_im_validatorcfgentry(fid,fquoteentryid,fisquote,fop,fentryid,fseq,fisenable,fdescription,fimplclass) VALUES (1236902106594541568,1183991205164417026,'1','save',1236902106628097026,3,'1','导入校验','kd.scmc.im.validator.improt.BillTplImprotValidator'); 
DELETE FROM t_im_validatorcfgentry WHERE fentryid = 1236902106628097027;
INSERT INTO t_im_validatorcfgentry(fid,fquoteentryid,fisquote,fop,fentryid,fseq,fisenable,fdescription,fimplclass) VALUES (1236902106594541568,1183991205164417027,'1','save',1236902106628097027,4,'1','库存单据导入详情校验器','kd.scmc.im.validator.improt.InvBillImptDetailsValidator'); 
DELETE FROM t_im_validatorcfgentry WHERE fentryid = 1236902106628097028;
INSERT INTO t_im_validatorcfgentry(fid,fquoteentryid,fisquote,fop,fentryid,fseq,fisenable,fdescription,fimplclass) VALUES (1236902106594541568,1183992364285493248,'1','submit',1236902106628097028,5,'1','库存单据业务日期校验器','kd.scmc.im.validator.tpl.BillBizDateValidator'); 
DELETE FROM t_im_validatorcfgentry WHERE fentryid = 1236902106628097029;
INSERT INTO t_im_validatorcfgentry(fid,fquoteentryid,fisquote,fop,fentryid,fseq,fisenable,fdescription,fimplclass) VALUES (1236902106594541568,1183993505572388864,'1','submit',1236902106628097029,6,'1','仓库初始化校验器','kd.scmc.im.validator.general.WarehouseUnFinishInitValidator'); 
DELETE FROM t_im_validatorcfgentry WHERE fentryid = 1236902106628097030;
INSERT INTO t_im_validatorcfgentry(fid,fquoteentryid,fisquote,fop,fentryid,fseq,fisenable,fdescription,fimplclass) VALUES (1236902106594541568,1183993505572388865,'1','submit',1236902106628097030,7,'1','业务员必录校验器','kd.scmc.im.validator.tpl.OperatorSubmitValidator'); 
DELETE FROM t_im_validatorcfgentry WHERE fentryid = 1236902106628097031;
INSERT INTO t_im_validatorcfgentry(fid,fquoteentryid,fisquote,fop,fentryid,fseq,fisenable,fdescription,fimplclass) VALUES (1236902106594541568,1183993505572388866,'1','submit',1236902106628097031,8,'1','存货已关账校验器','kd.scmc.im.validator.tpl.BillTplCalCloseCheckValidator'); 
DELETE FROM t_im_validatorcfgentry WHERE fentryid = 1236902106628097032;
INSERT INTO t_im_validatorcfgentry(fid,fquoteentryid,fisquote,fop,fentryid,fseq,fisenable,fdescription,fimplclass) VALUES (1236902106594541568,1183993505572388867,'1','submit',1236902106628097032,9,'1','关账日期校验器','kd.scmc.im.validator.acc.close.CloseDateValidator'); 
DELETE FROM t_im_validatorcfgentry WHERE fentryid = 1236902106628097033;
INSERT INTO t_im_validatorcfgentry(fid,fquoteentryid,fisquote,fop,fentryid,fseq,fisenable,fdescription,fimplclass) VALUES (1236902106594541568,1183994782545003520,'1','submit',1236902106628097033,10,'1','仓库启用日期校验器','kd.scmc.im.validator.general.StartDateValidator'); 
DELETE FROM t_im_validatorcfgentry WHERE fentryid = 1236902106628097034;
INSERT INTO t_im_validatorcfgentry(fid,fquoteentryid,fisquote,fop,fentryid,fseq,fisenable,fdescription,fimplclass) VALUES (1236902106594541568,1183994782545003522,'1','submit',1236902106628097034,11,'1','仓库物料校验器','kd.scmc.im.validator.tpl.WarehouseMaterialValidator'); 
DELETE FROM t_im_validatorcfgentry WHERE fentryid = 1236902106628097035;
INSERT INTO t_im_validatorcfgentry(fid,fquoteentryid,fisquote,fop,fentryid,fseq,fisenable,fdescription,fimplclass) VALUES (1236902106594541568,1183994782545003523,'1','submit',1236902106628097035,12,'1','仓库业务员校验器','kd.scmc.im.validator.tpl.WarehouseOperatorValidator'); 
DELETE FROM t_im_validatorcfgentry WHERE fentryid = 1236902106628097036;
INSERT INTO t_im_validatorcfgentry(fid,fquoteentryid,fisquote,fop,fentryid,fseq,fisenable,fdescription,fimplclass) VALUES (1236902106594541568,1183994782545003524,'1','submit',1236902106628097036,13,'1','库存事务及分录事务字段校验','kd.scmc.im.validator.tpl.BillInvSchemeValidator'); 
DELETE FROM t_im_validatorcfgentry WHERE fentryid = 1236902106628097037;
INSERT INTO t_im_validatorcfgentry(fid,fquoteentryid,fisquote,fop,fentryid,fseq,fisenable,fdescription,fimplclass) VALUES (1236902106594541568,1183995979758764032,'1','submit',1236902106628097037,14,'1','单据序列号保存时唯一性校验','kd.scmc.im.validator.tpl.SerialNumberSaveValidator'); 
DELETE FROM t_im_validatorcfgentry WHERE fentryid = 1236902106628097038;
INSERT INTO t_im_validatorcfgentry(fid,fquoteentryid,fisquote,fop,fentryid,fseq,fisenable,fdescription,fimplclass) VALUES (1236902106594541568,1183995979758764033,'1','submit',1236902106628097038,15,'1','批号编码是否为空校验器','kd.scmc.im.validator.tpl.LotNumSaveValidator'); 
DELETE FROM t_im_validatorcfgentry WHERE fentryid = 1236902106628097039;
INSERT INTO t_im_validatorcfgentry(fid,fquoteentryid,fisquote,fop,fentryid,fseq,fisenable,fdescription,fimplclass) VALUES (1236902106594541568,1183995979758764034,'1','submit',1236902106628097039,16,'1','保质期日期（生产日期，到期日期）是否为空校验','kd.scmc.im.validator.tpl.ShelfLifeDateValidator'); 
DELETE FROM t_im_validatorcfgentry WHERE fentryid = 1236902106628097040;
INSERT INTO t_im_validatorcfgentry(fid,fquoteentryid,fisquote,fop,fentryid,fseq,fisenable,fdescription,fimplclass) VALUES (1236902106594541568,1183995979758764035,'1','submit',1236902106628097040,17,'1','辅助属性必录校验','kd.scmc.im.validator.tpl.AuxptyMustInputValidator'); 
DELETE FROM t_im_validatorcfgentry WHERE fentryid = 1236902106628097041;
INSERT INTO t_im_validatorcfgentry(fid,fquoteentryid,fisquote,fop,fentryid,fseq,fisenable,fdescription,fimplclass) VALUES (1236902106594541568,1184014548890469376,'1','audit',1236902106628097041,18,'1','存货已关账校验器','kd.scmc.im.validator.tpl.BillTplCalCloseCheckValidator'); 
DELETE FROM t_im_validatorcfgentry WHERE fentryid = 1236902106628097042;
INSERT INTO t_im_validatorcfgentry(fid,fquoteentryid,fisquote,fop,fentryid,fseq,fisenable,fdescription,fimplclass) VALUES (1236902106594541568,1184014948263723008,'1','audit',1236902106628097042,19,'1','关账日期校验器','kd.scmc.im.validator.acc.close.CloseDateValidator'); 
DELETE FROM t_im_validatorcfgentry WHERE fentryid = 1236902106628097043;
INSERT INTO t_im_validatorcfgentry(fid,fquoteentryid,fisquote,fop,fentryid,fseq,fisenable,fdescription,fimplclass) VALUES (1236902106594541568,1186071739910851584,'1','unsubmit',1236902106628097043,20,'1','关账日期校验器','kd.scmc.im.validator.acc.close.CloseDateValidator'); 
DELETE FROM t_im_validatorcfgentry WHERE fentryid = 1236902106628097044;
INSERT INTO t_im_validatorcfgentry(fid,fquoteentryid,fisquote,fop,fentryid,fseq,fisenable,fdescription,fimplclass) VALUES (1236902106594541568,1186073588600671232,'1','unaudit',1236902106628097044,21,'1','下游单据和手工核销校验器','kd.scmc.im.validator.tpl.BillTplIsPushValidator'); 
DELETE FROM t_im_validatorcfgentry WHERE fentryid = 1236902106628097045;
INSERT INTO t_im_validatorcfgentry(fid,fquoteentryid,fisquote,fop,fentryid,fseq,fisenable,fdescription,fimplclass) VALUES (1236902106594541568,1186073588609059840,'1','unaudit',1236902106628097045,22,'1','存货已关账校验器','kd.scmc.im.validator.tpl.BillTplCalCloseCheckValidator'); 
DELETE FROM t_im_validatorcfgentry WHERE fentryid = 1236902106628097046;
INSERT INTO t_im_validatorcfgentry(fid,fquoteentryid,fisquote,fop,fentryid,fseq,fisenable,fdescription,fimplclass) VALUES (1236902106594541568,1186073588609059841,'1','unaudit',1236902106628097046,23,'1','库存单据反审核校验器','kd.scmc.im.validator.tpl.BillTplUnAuditValidator'); 
DELETE FROM t_im_validatorcfgentry WHERE fentryid = 1236902106628097047;
INSERT INTO t_im_validatorcfgentry(fid,fquoteentryid,fisquote,fop,fentryid,fseq,fisenable,fdescription,fimplclass) VALUES (1236902106594541568,1186073588609059842,'1','unaudit',1236902106628097047,24,'1','关账日期校验器','kd.scmc.im.validator.acc.close.CloseDateValidator'); 



DELETE FROM t_im_validatorcfgentry_l WHERE fpkid = '1VXVUGTW/L0/';
INSERT INTO t_im_validatorcfgentry_l(fpkid,flocaleid,fentryid,fdescription) VALUES ('1VXVUGTW/L0/','zh_CN',1236902106628097024,'库存单据业务日期校验器'); 
DELETE FROM t_im_validatorcfgentry_l WHERE fpkid = '1VXVUGTW/L00';
INSERT INTO t_im_validatorcfgentry_l(fpkid,flocaleid,fentryid,fdescription) VALUES ('1VXVUGTW/L00','zh_CN',1236902106628097025,'仓库物料校验'); 
DELETE FROM t_im_validatorcfgentry_l WHERE fpkid = '1VXVUGTW/L01';
INSERT INTO t_im_validatorcfgentry_l(fpkid,flocaleid,fentryid,fdescription) VALUES ('1VXVUGTW/L01','zh_CN',1236902106628097026,'导入校验'); 
DELETE FROM t_im_validatorcfgentry_l WHERE fpkid = '1VXVUGTW/L02';
INSERT INTO t_im_validatorcfgentry_l(fpkid,flocaleid,fentryid,fdescription) VALUES ('1VXVUGTW/L02','zh_CN',1236902106628097027,'库存单据导入详情校验器'); 
DELETE FROM t_im_validatorcfgentry_l WHERE fpkid = '1VXVUGTW/L03';
INSERT INTO t_im_validatorcfgentry_l(fpkid,flocaleid,fentryid,fdescription) VALUES ('1VXVUGTW/L03','zh_CN',1236902106628097028,'库存单据业务日期校验器'); 
DELETE FROM t_im_validatorcfgentry_l WHERE fpkid = '1VXVUGTW/L04';
INSERT INTO t_im_validatorcfgentry_l(fpkid,flocaleid,fentryid,fdescription) VALUES ('1VXVUGTW/L04','zh_CN',1236902106628097029,'仓库初始化校验器'); 
DELETE FROM t_im_validatorcfgentry_l WHERE fpkid = '1VXVUGTW/L05';
INSERT INTO t_im_validatorcfgentry_l(fpkid,flocaleid,fentryid,fdescription) VALUES ('1VXVUGTW/L05','zh_CN',1236902106628097030,'业务员必录校验器'); 
DELETE FROM t_im_validatorcfgentry_l WHERE fpkid = '1VXVUGTW/L06';
INSERT INTO t_im_validatorcfgentry_l(fpkid,flocaleid,fentryid,fdescription) VALUES ('1VXVUGTW/L06','zh_CN',1236902106628097031,'存货已关账校验器'); 
DELETE FROM t_im_validatorcfgentry_l WHERE fpkid = '1VXVUGTW/L07';
INSERT INTO t_im_validatorcfgentry_l(fpkid,flocaleid,fentryid,fdescription) VALUES ('1VXVUGTW/L07','zh_CN',1236902106628097032,'关账日期校验器'); 
DELETE FROM t_im_validatorcfgentry_l WHERE fpkid = '1VXVUGTW/L08';
INSERT INTO t_im_validatorcfgentry_l(fpkid,flocaleid,fentryid,fdescription) VALUES ('1VXVUGTW/L08','zh_CN',1236902106628097033,'仓库启用日期校验器'); 
DELETE FROM t_im_validatorcfgentry_l WHERE fpkid = '1VXVUGTW/L09';
INSERT INTO t_im_validatorcfgentry_l(fpkid,flocaleid,fentryid,fdescription) VALUES ('1VXVUGTW/L09','zh_CN',1236902106628097034,'仓库物料校验器'); 
DELETE FROM t_im_validatorcfgentry_l WHERE fpkid = '1VXVUGTW/L0=';
INSERT INTO t_im_validatorcfgentry_l(fpkid,flocaleid,fentryid,fdescription) VALUES ('1VXVUGTW/L0=','zh_CN',1236902106628097035,'仓库业务员校验器'); 
DELETE FROM t_im_validatorcfgentry_l WHERE fpkid = '1VXVUGTW/L0A';
INSERT INTO t_im_validatorcfgentry_l(fpkid,flocaleid,fentryid,fdescription) VALUES ('1VXVUGTW/L0A','zh_CN',1236902106628097036,'库存事务及分录事务字段校验'); 
DELETE FROM t_im_validatorcfgentry_l WHERE fpkid = '1VXVUGTW/L0B';
INSERT INTO t_im_validatorcfgentry_l(fpkid,flocaleid,fentryid,fdescription) VALUES ('1VXVUGTW/L0B','zh_CN',1236902106628097037,'单据序列号保存时唯一性校验'); 
DELETE FROM t_im_validatorcfgentry_l WHERE fpkid = '1VXVUGTW/L0C';
INSERT INTO t_im_validatorcfgentry_l(fpkid,flocaleid,fentryid,fdescription) VALUES ('1VXVUGTW/L0C','zh_CN',1236902106628097038,'批号编码是否为空校验器'); 
DELETE FROM t_im_validatorcfgentry_l WHERE fpkid = '1VXVUGTW/L0D';
INSERT INTO t_im_validatorcfgentry_l(fpkid,flocaleid,fentryid,fdescription) VALUES ('1VXVUGTW/L0D','zh_CN',1236902106628097039,'保质期日期（生产日期，到期日期）是否为空校验'); 
DELETE FROM t_im_validatorcfgentry_l WHERE fpkid = '1VXVUGTW/L0E';
INSERT INTO t_im_validatorcfgentry_l(fpkid,flocaleid,fentryid,fdescription) VALUES ('1VXVUGTW/L0E','zh_CN',1236902106628097040,'辅助属性必录校验'); 
DELETE FROM t_im_validatorcfgentry_l WHERE fpkid = '1VXVUGTW/L0F';
INSERT INTO t_im_validatorcfgentry_l(fpkid,flocaleid,fentryid,fdescription) VALUES ('1VXVUGTW/L0F','zh_CN',1236902106628097041,'存货已关账校验器'); 
DELETE FROM t_im_validatorcfgentry_l WHERE fpkid = '1VXVUGTW/L0G';
INSERT INTO t_im_validatorcfgentry_l(fpkid,flocaleid,fentryid,fdescription) VALUES ('1VXVUGTW/L0G','zh_CN',1236902106628097042,'关账日期校验器'); 
DELETE FROM t_im_validatorcfgentry_l WHERE fpkid = '1VXVUGTW/L0H';
INSERT INTO t_im_validatorcfgentry_l(fpkid,flocaleid,fentryid,fdescription) VALUES ('1VXVUGTW/L0H','zh_CN',1236902106628097043,'关账日期校验器'); 
DELETE FROM t_im_validatorcfgentry_l WHERE fpkid = '1VXVUGTW/L0I';
INSERT INTO t_im_validatorcfgentry_l(fpkid,flocaleid,fentryid,fdescription) VALUES ('1VXVUGTW/L0I','zh_CN',1236902106628097044,'下游单据和手工核销校验器'); 
DELETE FROM t_im_validatorcfgentry_l WHERE fpkid = '1VXVUGTW/L0J';
INSERT INTO t_im_validatorcfgentry_l(fpkid,flocaleid,fentryid,fdescription) VALUES ('1VXVUGTW/L0J','zh_CN',1236902106628097045,'存货已关账校验器'); 
DELETE FROM t_im_validatorcfgentry_l WHERE fpkid = '1VXVUGTW/L0K';
INSERT INTO t_im_validatorcfgentry_l(fpkid,flocaleid,fentryid,fdescription) VALUES ('1VXVUGTW/L0K','zh_CN',1236902106628097046,'库存单据反审核校验器'); 
DELETE FROM t_im_validatorcfgentry_l WHERE fpkid = '1VXVUGTW/L0L';
INSERT INTO t_im_validatorcfgentry_l(fpkid,flocaleid,fentryid,fdescription) VALUES ('1VXVUGTW/L0L','zh_CN',1236902106628097047,'关账日期校验器'); 

