IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATE WHERE FID = 1479702448388965376) INSERT INTO T_BAS_IMPORTTEMPLATE(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (1479702448388965376,'1',1479702448388965376,'C','bd_materialcategory_IMPT_S','存货类别引入模板','IMPT',{ts'2018-08-08 18:08:08'},0,'1',null ,' ',1,'bd_materialcategory');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATE WHERE FID = 1479703387082588160) INSERT INTO T_BAS_IMPORTTEMPLATE(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (1479703387082588160,'1',1479703387082588160,'C','bd_materialcalinfo_IMPT_S','物料核算信息引入模板','IMPT',{ts'2018-08-08 18:08:08'},0,'1',null,' ',1,'bd_materialcalinfo');

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATE_L WHERE FPKID = '2MR30EHUYLFS') INSERT INTO T_BAS_IMPORTTEMPLATE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1479702448388965376,'2MR30EHUYLFS','zh_CN','系统预置模板','存货类别引入模板');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATE_L WHERE FPKID = '2MR30EHUYLFT') INSERT INTO T_BAS_IMPORTTEMPLATE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1479702448388965376,'2MR30EHUYLFT','zh_TW','係統預置模板','存貨類別引入模板');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATE_L WHERE FPKID = '2MR37997/J+K') INSERT INTO T_BAS_IMPORTTEMPLATE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1479703387082588160,'2MR37997/J+K','zh_CN','系统预置模板','物料核算信息引入模板');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATE_L WHERE FPKID = '2MR37997/J+L') INSERT INTO T_BAS_IMPORTTEMPLATE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1479703387082588160,'2MR37997/J+L','zh_TW','係統預置模板','物料核算信息引入模板');

IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1479700181929690112)INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1479702448388965376,'0','0',' ',0,1479700181929690112,'bd_materialcategory',1,'0',' ',' ',NULL);
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1479700181938077696)INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1479702448388965376,'0','0',' ',1479700181929690112,1479700181938077696,'billhead',2,'0',' ',' ',NULL);
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1479700181954855936)INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1479702448388965376,'0','1',' ',1479700181938077696,1479700181954855936,'id',3,'0',' ',' ',NULL);
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1479700181954854912)INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1479702448388965376,'1','1',' ',1479700181938077696,1479700181954854912,'number',4,'1',' ',' ',NULL);
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1479700181954855937)INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1479702448388965376,'1','1',' ',1479700181938077696,1479700181954855937,'name',5,'1',' ',' ',NULL);
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1479700181954854913)INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1479702448388965376,'1','1',' ',1479700181938077696,1479700181954854913,'remark',6,'0',' ',' ',NULL);
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1479700181954855938)INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1479702448388965376,'0','1',' ',1479700181938077696,1479700181954855938,'enable',7,'0',' ',' ',NULL);
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1479700181954854914)INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1479702448388965376,'0','1',' ',1479700181938077696,1479700181954854914,'ispreset',8,'0',' ',' ',NULL);
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1479700306609569792)INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1479703387082588160,'0','0',' ',0,1479700306609569792,'bd_materialcalinfo',1,'0',' ',' ',NULL);
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1479700306617959424)INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1479703387082588160,'1','1','number',1479700306609570816,1479700306617959424,'createorg',5,'1',' ','name',NULL);
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1479700306617958401)INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1479703387082588160,'1','1','number',1479700306609570816,1479700306617958401,'group',6,'1',' ','name',NULL);
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1479700306617959426)INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1479703387082588160,'0','1','number',1479700306609570816,1479700306617959426,'creator',9,'0',' ','name',NULL);
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1479700306617959427)INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1479703387082588160,'0','1','number',1479700306609570816,1479700306617959427,'modifier',11,'0',' ','name',NULL);
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1479700306617959428)INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1479703387082588160,'0','1','number',1479700306609570816,1479700306617959428,'auditor',13,'0',' ','name',NULL);
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1479700306617959429)INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1479703387082588160,'0','1','number',1479700306609570816,1479700306617959429,'disabler',15,'0',' ','name',NULL);
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1479700306617959430)INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1479703387082588160,'1','1','number',1479700306609570816,1479700306617959430,'masterid',4,'1',' ','name',NULL);
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1479700306617958407)INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1479703387082588160,'0','1','number',1479700306609570816,1479700306617958407,'useorg',17,'0',' ','name',NULL);
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1479700306617959432)INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1479703387082588160,'0','1','number',1479700306609570816,1479700306617959432,'org',20,'0',' ','name',NULL);
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1479700306609570816)INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1479703387082588160,'0','0',' ',1479700306609569792,1479700306609570816,'billhead',2,'0',' ',' ',NULL);
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1479700306617958400)INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1479703387082588160,'0','1',' ',1479700306609570816,1479700306617958400,'id',3,'0',' ',' ',NULL);
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1479700306617959425)INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1479703387082588160,'0','1',' ',1479700306609570816,1479700306617959425,'status',7,'0',' ',' ',NULL);
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1479700306617958402)INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1479703387082588160,'0','1',' ',1479700306609570816,1479700306617958402,'enable',8,'0',' ',' ',NULL);
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1479700306617958403)INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1479703387082588160,'0','1',' ',1479700306609570816,1479700306617958403,'createtime',10,'0',' ',' ',NULL);
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1479700306617958404)INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1479703387082588160,'0','1',' ',1479700306609570816,1479700306617958404,'modifytime',12,'0',' ',' ',NULL);
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1479700306617958405)INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1479703387082588160,'0','1',' ',1479700306609570816,1479700306617958405,'audittime',14,'0',' ',' ',NULL);
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1479700306617958406)INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1479703387082588160,'0','1',' ',1479700306609570816,1479700306617958406,'disabledate',16,'0',' ',' ',NULL);
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1479700306617959431)INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1479703387082588160,'0','1',' ',1479700306609570816,1479700306617959431,'number',18,'0',' ',' ',NULL);
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1479700306617958408)INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1479703387082588160,'0','1',' ',1479700306609570816,1479700306617958408,'name',19,'0',' ',' ',NULL);
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1480532191451548681)INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1479703387082588160,'0','1','number',1479700306609570816,1480532191451548681,'showcreateorg',21,'0',' ','name',NULL);
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1480532191451547657)INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1479703387082588160,'0','1',' ',1479700306609570816,1480532191451547657,'isautonew',22,'0',' ',' ',NULL);
