--导入模板预置

--初始库存单
DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 736661381474038784;
INSERT INTO T_BAS_IMPORTTEMPLATE(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNAME,FNUMBER,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (736661381474038784,'1',736661381474038784,'C',' ','im_initbill_IMPT_S','IMPT',{ts'2019-10-10  15:49:51'},275188253840125478,'1',{ts'2019-10-19  11:27:20'},' ',1,'im_initbill'); 



DELETE FROM T_BAS_IMPORTTEMPLATE_L WHERE FPKID = '0=G9+WSCD3IW';
INSERT INTO T_BAS_IMPORTTEMPLATE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (736661381474038784,'0=G9+WSCD3IW','zh_CN','系统预置模板','初始库存单引入模板'); 
DELETE FROM T_BAS_IMPORTTEMPLATE_L WHERE FPKID = '0=XX+P1XYP4L';
INSERT INTO T_BAS_IMPORTTEMPLATE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (736661381474038784,'0=XX+P1XYP4L','zh_TW','係統預置模板','初始庫存單引入模板'); 

DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067475970;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1',' ',740493715059093504,740493715067475970,'producedate','0',22,' ',' ','生产日期'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067482114;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1',' ',740493715059093504,740493715067482114,'expirydate','0',23,' ',' ','到期日期'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067475971;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1','number',740493715059093504,740493715067475971,'unit','1',24,'number,name',' ','计量单位*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067482115;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1',' ',740493715059093504,740493715067482115,'qty','1',25,' ',' ','期初数量*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067475972;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'0','1',' ',740493715059093504,740493715067475972,'ystartqty','0',26,' ',' ','年初数量'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067482116;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1',' ',740493715059093504,740493715067482116,'yreceiveqty','0',27,' ',' ','年收入数量'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067475973;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1',' ',740493715059093504,740493715067475973,'ysendqty','0',28,' ',' ','年发出数量'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067482117;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'0','1','number',740493715059093504,740493715067482117,'baseunit','0',29,'number,name',' ','基本单位*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067475974;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'0','1',' ',740493715059093504,740493715067475974,'baseqty','0',30,' ',' ','期初数量(基本单位)*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067482118;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'0','1',' ',740493715059093504,740493715067482118,'ystartbaseqty','0',31,' ',' ','年初数量(基本单位)'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067475975;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'0','1',' ',740493715059093504,740493715067475975,'yreceivebaseqty','0',32,' ',' ','年收入数量(基本单位)'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067482119;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'0','1',' ',740493715059093504,740493715067482119,'ysendbaseqty','0',33,' ',' ','年发出数量(基本单位)'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067475976;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1','number',740493715059093504,740493715067475976,'unit2nd','0',34,'number,name',' ','主辅单位'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067482120;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'0','1',' ',740493715059093504,740493715067482120,'unit2ndrate','0',35,' ',' ','换算率(主辅单位)'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067475977;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1',' ',740493715059093504,740493715067475977,'qtyunit2nd','0',36,' ',' ','期初数量(主辅单位)'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067482121;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'0','1',' ',740493715059093504,740493715067482121,'ystartqtyunit2nd','0',37,' ',' ','年初数量(主辅单位)'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067475978;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1',' ',740493715059093504,740493715067475978,'yreceiveqtyunit2nd','0',38,' ',' ','年收入数量(主辅单位)'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067482122;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1',' ',740493715059093504,740493715067482122,'ysendqtyunit2nd','0',39,' ',' ','年发出数量(主辅单位)'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067475979;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1','number',740493715059093504,740493715067475979,'warehouse','1',40,'number,name',' ','仓库*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067482123;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1','number',740493715059093504,740493715067482123,'location','0',41,'number,name',' ','仓位'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067475980;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'0','1',' ',740493715059093504,740493715067475980,'stockindate','0',42,' ',' ','入库日期'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067482124;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'0','1','number',740493715059093504,740493715067482124,'lot','0',43,'name',' ','批号ID'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067475981;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'0','1','number',740493715059093504,740493715067475981,'unit3rd','0',44,'number,name',' ','次辅单位'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067475988;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1',' ',740493715059093504,740493715067475988,'srcbillentity','0',58,' ',' ','来源单据实体'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067482132;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1',' ',740493715059093504,740493715067482132,'srcbillid','0',59,' ',' ','来源单据ID'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067475989;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1',' ',740493715059093504,740493715067475989,'srcbillentryid','0',60,' ',' ','来源单据行ID'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067482133;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1',' ',740493715059093504,740493715067482133,'srcbillnumber','0',61,' ',' ','来源单据编号'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067475990;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1',' ',740493715059093504,740493715067475990,'srcbillentryseq','0',62,' ',' ','来源单据分录序号'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067482134;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1',' ',740493715059093504,740493715067482134,'entrycomment','0',63,' ',' ','备注'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715084253184;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'0','0',' ',740493714958430208,740493715084253184,'subentryentity','0',64,' ',' ','子单据体'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715084259328;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'0','1',' ',740493715084253184,740493715084259328,'serialnumber','0',65,' ',' ','序列号'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715084253185;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'0','1','number',740493715084253184,740493715084253185,'serialid','0',66,'name',' ','序列号ID'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715084259329;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'0','1',' ',740493715084253184,740493715084259329,'serialcomment','0',67,' ',' ','备注'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493714958430208;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'0','0',' ',0,740493714958430208,'im_initbill','0',1,' ',' ','初始库存单'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715033921536;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'0','0',' ',740493714958430208,740493715033921536,'billhead','0',2,' ',' ','单据头'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715033927680;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'0','1','number',740493715033921536,740493715033927680,'creator','0',3,'name',' ','创建人'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715033921537;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'0','1',' ',740493715033921536,740493715033921537,'createtime','0',4,' ',' ','创建时间'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715033927681;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'0','1','number',740493715033921536,740493715033927681,'auditor','0',5,'name',' ','审核人'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715033921538;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'0','1',' ',740493715033921536,740493715033921538,'auditdate','0',6,' ',' ','审核时间'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715033927682;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1','number',740493715033921536,740493715033927682,'billtype','1',7,'number,name',' ','单据类型*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715033921539;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1',' ',740493715033921536,740493715033921539,'billno','1',8,' ',' ','单据编号*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715033927683;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1','number',740493715033921536,740493715033927683,'org','1',9,'number,name',' ','库存组织*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715033921540;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1','number',740493715033921536,740493715033921540,'dept','0',10,'number,name',' ','库管部门'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715033927684;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1',' ',740493715033921536,740493715033927684,'biztime','1',11,' ',' ','业务日期*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715033921541;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'0','1','number',740493715033921536,740493715033921541,'headwarehouse','0',12,'number,name',' ','仓库'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715033927685;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1','number',740493715033921536,740493715033927685,'biztype','0',13,'number,name',' ','业务类型'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715033921542;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1','number',740493715033921536,740493715033921542,'invscheme','0',14,'number,name',' ','库存事务'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715033927686;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1',' ',740493715033921536,740493715033927686,'comment','0',15,' ',' ','备注'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715033921543;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1',' ',740493715033921536,740493715033921543,'billstatus','1',16,' ',' ','单据状态*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715059093504;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'0','0',' ',740493714958430208,740493715059093504,'billentry','0',17,' ',' ','单据体'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067475968;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1','number',740493715059093504,740493715067475968,'material','1',18,'number,name',' ','物料*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067475969;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1','number',740493715059093504,740493715067475969,'auxpty','0',20,'name',' ','辅助属性'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067482112;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'0','1',' ',740493715059093504,740493715067482112,'materialmasterid','0',19,' ',' ','物料业务策略主内码'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067482113;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1',' ',740493715059093504,740493715067482113,'lotnumber','0',21,' ',' ','批号'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067482125;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'0','1',' ',740493715059093504,740493715067482125,'unit3rdrate','0',45,' ',' ','换算率(次辅单位)'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067475982;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'0','1',' ',740493715059093504,740493715067475982,'qtyunit3rd','0',46,' ',' ','期初数量(次辅单位)'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067482126;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'0','1',' ',740493715059093504,740493715067482126,'ystartqtyunit3rd','0',47,' ',' ','年初数量(次辅单位)'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067475983;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'0','1',' ',740493715059093504,740493715067475983,'yreceiveqtyunit3rd','0',48,' ',' ','年收入(次辅单位)'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067482127;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1','number',740493715059093504,740493715067482127,'outinvtype','0',49,'number,name',' ','出库库存类型'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067475984;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1',' ',740493715059093504,740493715067475984,'ysendqtyunit3rd','0',50,' ',' ','年发出(次辅单位)'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067482128;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1','number',740493715059093504,740493715067482128,'invtype','1',51,'number,name',' ','入库库存类型*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067475985;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1','number',740493715059093504,740493715067475985,'invstatus','1',52,'number,name',' ','入库库存状态*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067482129;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1',' ',740493715059093504,740493715067482129,'ownertype','1',53,' ',' ','入库货主类型*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067475986;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1','number',740493715059093504,740493715067475986,'owner','1',54,'number,name',' ','入库货主*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067482130;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1',' ',740493715059093504,740493715067482130,'keepertype','1',55,' ',' ','入库保管者类型*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067475987;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1','number',740493715059093504,740493715067475987,'keeper','1',56,'number,name',' ','入库保管者*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 740493715067482131;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (736661381474038784,'1','1','number',740493715059093504,740493715067482131,'project','0',57,'number,name',' ','项目号'); 
