-- 物料采购信息引入模板更新，增加最大订单量、最小订单量、包装批量字段引入
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1939929628869132289)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1837734795103232000,0,' ',1939929628869132289,'0','0',' ',' ','1','1',' ',' ',1837726808007565312,'minbillqty',34,NULL,' ',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1939929628869380097)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1837734795103232000,0,' ',1939929628869380097,'0','0',' ',' ','1','1',' ',' ',1837726808007565312,'packingqty',35,NULL,' ',' '); 


IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1939929628869132290)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1837734795103232000,0,' ',1939929628869132290,'0','0',' ',' ','1','1',' ',' ',1837726808007565312,'maxbillqty',36,NULL,' ',' '); 