--生产入库单引入模板
DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 747112668623683584;
INSERT INTO T_BAS_IMPORTTEMPLATE(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNAME,FNUMBER,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (747112668623683584,'1',747112668623683584,'C',' ','im_productinbill_IMPT_S','IMPT',{ts'2019-10-28  19:39:15'},275188253840125478,'1',{ts'2019-10-29  16:05:55'},' ',1,'im_productinbill'); 


DELETE FROM T_BAS_IMPORTTEMPLATE_L WHERE FPKID = '0ARAS7KJW7KR';
INSERT INTO T_BAS_IMPORTTEMPLATE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (747112668623683584,'0ARAS7KJW7KR','zh_CN','系统预置模板','生产入库单引入模板'); 
DELETE FROM T_BAS_IMPORTTEMPLATE_L WHERE FPKID = '0ARAS7KJW7KS';
INSERT INTO T_BAS_IMPORTTEMPLATE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (747112668623683584,'0ARAS7KJW7KS','zh_TW','係統預置模板','生產入庫單引入模板'); 



DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155120388099;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1','number',747728155111999488,747728155120388099,'outinvstatus','0',43,',number,name,',' ','出库库存状态'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155120386051;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1','number',747728155111999488,747728155120386051,'project','0',44,',number,name,',' ','项目号'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155120388100;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1',' ',747728155111999488,747728155120388100,'outownertype','0',45,' ',' ','出库货主类型'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155120386052;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1','number',747728155111999488,747728155120386052,'outowner','0',46,',number,name,',' ','出库货主'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155120388101;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1',' ',747728155111999488,747728155120388101,'outkeepertype','0',47,' ',' ','出库保管者类型'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155120386053;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1','number',747728155111999488,747728155120386053,'outkeeper','0',48,',number,name,',' ','出库保管者'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155120388102;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1','number',747728155111999488,747728155120388102,'invtype','0',49,',number,name,',' ','入库库存类型'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155120386054;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1','number',747728155111999488,747728155120386054,'invstatus','0',50,',number,name,',' ','入库库存状态'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155120388103;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1',' ',747728155111999488,747728155120388103,'ownertype','0',51,' ',' ','入库货主类型'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155120386055;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1','number',747728155111999488,747728155120386055,'owner','0',52,',number,name,',' ','入库货主'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155120388104;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1',' ',747728155111999488,747728155120388104,'keepertype','0',53,' ',' ','入库保管者类型'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155120386056;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1','number',747728155111999488,747728155120386056,'keeper','0',54,',number,name,',' ','入库保管者'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155120388105;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1',' ',747728155111999488,747728155120388105,'price','0',55,' ',' ','单价'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155120386057;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1',' ',747728155111999488,747728155120386057,'amount','0',56,' ',' ','金额'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155120388106;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1',' ',747728155111999488,747728155120388106,'srcbillentity','0',57,' ',' ','来源单据实体'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155120386058;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1',' ',747728155111999488,747728155120386058,'srcbillid','0',58,' ',' ','来源单据ID'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155120388107;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1',' ',747728155111999488,747728155120388107,'srcbillentryid','0',59,' ',' ','来源单据行ID'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155120386059;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1',' ',747728155111999488,747728155120386059,'srcbillnumber','0',60,' ',' ','来源单据编号'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155120388108;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'0','1',' ',747728155111999488,747728155120388108,'logisticsbill','0',61,' ',' ','物流单据'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155120386060;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1',' ',747728155111999488,747728155120386060,'srcbillentryseq','0',62,' ',' ','来源单据分录序号'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155120388109;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'0','1',' ',747728155111999488,747728155120388109,'returnqty','0',63,' ',' ','累计退库数量'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155120386061;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'0','1',' ',747728155111999488,747728155120386061,'remainreturnqty','0',64,' ',' ','剩余退库数量'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155120388110;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'0','1',' ',747728155111999488,747728155120388110,'returnbaseqty','0',65,' ',' ','累计退库数量(基本单位)'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155120386062;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'0','1',' ',747728155111999488,747728155120386062,'remainreturnbaseqty','0',66,' ',' ','剩余退库数量(基本单位)'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155120388111;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1',' ',747728155111999488,747728155120388111,'entrycomment','0',67,' ',' ','备注'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155120386063;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'0','0',' ',747728155078445056,747728155120386063,'subentryentity','0',68,' ',' ','子单据体'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155120388112;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'0','1',' ',747728155120386063,747728155120388112,'serialnumber','0',69,' ',' ','序列号'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155120386064;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'0','1','number',747728155120386063,747728155120386064,'serialid','0',70,'name',' ','序列号ID'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155128776704;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'0','1',' ',747728155120386063,747728155128776704,'serialcomment','0',71,' ',' ','备注'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155078445056;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'0','0',' ',0,747728155078445056,'im_productinbill','0',1,' ',' ','生产入库单'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155103608832;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'0','0',' ',747728155078445056,747728155103608832,'billhead','0',2,' ',' ','单据头'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155103610880;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'0','1','number',747728155103608832,747728155103610880,'creator','0',3,'name',' ','创建人'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155103608833;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'0','1',' ',747728155103608832,747728155103608833,'createtime','0',4,' ',' ','创建时间'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155103610881;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'0','1','number',747728155103608832,747728155103610881,'auditor','0',5,'name',' ','审核人'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155103608834;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'0','1',' ',747728155103608832,747728155103608834,'auditdate','0',6,' ',' ','审核时间'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155103610882;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1',' ',747728155103608832,747728155103610882,'billno','1',7,' ',' ','单据编号*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155103608835;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1','number',747728155103608832,747728155103608835,'biztype','1',8,',number,name,',' ','业务类型*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155103610883;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1','number',747728155103608832,747728155103610883,'billtype','1',9,',number,name,',' ','单据类型*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155103608836;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1','number',747728155103608832,747728155103608836,'invscheme','1',10,',number,name,',' ','库存事务*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155103610884;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1','number',747728155103608832,747728155103610884,'org','1',11,',number,name,',' ','库存组织*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155103608837;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1',' ',747728155103608832,747728155103608837,'biztime','1',12,' ',' ','业务日期*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155103610885;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1','number',747728155103608832,747728155103610885,'bizdept','0',13,',number,name,',' ','业务部门'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155103608838;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1','number',747728155103608832,747728155103608838,'dept','0',14,',number,name,',' ','库管部门'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155103610886;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1','number',747728155103608832,747728155103610886,'operator','0',15,',number,name,',' ','库管员'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155103608839;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1','number',747728155103608832,747728155103608839,'operatorgroup','0',16,',number,name,',' ','库存组'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155103610887;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'0','1',' ',747728155103608832,747728155103610887,'isvirtualbill','0',17,' ',' ','是否虚单'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155103608840;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1','number',747728155103608832,747728155103608840,'settlecurrency','0',18,',number,name,',' ','币别'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155103610888;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1',' ',747728155103608832,747728155103610888,'comment','0',19,' ',' ','备注'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155103608841;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1',' ',747728155103608832,747728155103608841,'billstatus','1',20,' ',' ','单据状态*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155111999488;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'0','0',' ',747728155078445056,747728155111999488,'billentry','0',21,' ',' ','单据体'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155111997440;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1','number',747728155111999488,747728155111997440,'maindept','0',22,',number,name,',' ','主制部门'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155111999489;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1','number',747728155111999488,747728155111999489,'material','1',23,',number,name,',' ','物料*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155111997441;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'0','1',' ',747728155111999488,747728155111997441,'materialmasterid','0',24,' ',' ','物料业务策略主内码'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155111999490;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1','number',747728155111999488,747728155111999490,'auxpty','0',25,',number,name,',' ','辅助属性'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155111997442;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1',' ',747728155111999488,747728155111997442,'lotnumber','0',26,' ',' ','批号'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155111999491;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1',' ',747728155111999488,747728155111999491,'producedate','0',27,' ',' ','生产日期'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155111997443;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1',' ',747728155111999488,747728155111997443,'expirydate','0',28,' ',' ','到期日期'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155111999492;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'0','1','number',747728155111999488,747728155111999492,'lot','0',29,'name',' ','批号ID'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155111997444;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1','number',747728155111999488,747728155111997444,'unit','1',30,',number,name,',' ','计量单位*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155111999493;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1',' ',747728155111999488,747728155111999493,'qty','1',31,' ',' ','数量*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155111997445;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'0','1','number',747728155111999488,747728155111997445,'baseunit','0',32,'name',' ','基本单位*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155111999494;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'0','1',' ',747728155111999488,747728155111999494,'baseqty','0',33,' ',' ','数量(基本单位)*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155111997446;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'0','1',' ',747728155111999488,747728155111997446,'qtyunit3rd','0',34,' ',' ','数量(次辅单位)'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155111999495;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'0','1','number',747728155111999488,747728155111999495,'unit3rd','0',35,'name',' ','次辅单位'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155111997447;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1','number',747728155111999488,747728155111997447,'unit2nd','0',36,',number,name,',' ','主辅单位'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155120388096;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'0','1',' ',747728155111999488,747728155120388096,'unit3rdrate','0',37,' ',' ','换算率(次辅)'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155120386048;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1',' ',747728155111999488,747728155120386048,'qtyunit2nd','0',38,' ',' ','数量(主辅单位)'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155120388097;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1','number',747728155111999488,747728155120388097,'warehouse','1',39,',number,name,',' ','仓库*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155120386049;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1','number',747728155111999488,747728155120386049,'location','0',40,',number,name,',' ','仓位'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155120388098;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'0','1',' ',747728155111999488,747728155120388098,'unit2ndrate','0',41,' ',' ','换算率(主辅单位)'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747728155120386050;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (747112668623683584,'1','1','number',747728155111999488,747728155120386050,'outinvtype','0',42,',number,name,',' ','出库库存类型'); 
