--其他入库单引入模板


DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 737376472146403328;
INSERT INTO T_BAS_IMPORTTEMPLATE(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNAME,FNUMBER,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (737376472146403328,'1',737376472146403328,'C',' ','im_otherinbill_IMPT_S','IMPT',{ts'2019-10-15  09:15:08'},1,'1',{ts'2019-10-15  09:18:02'},' ',1,'im_otherinbill'); 


DELETE FROM T_BAS_IMPORTTEMPLATE_L WHERE FPKID = '0=JOLQ5ZLCO/';
INSERT INTO T_BAS_IMPORTTEMPLATE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (737376472146403328,'0=JOLQ5ZLCO/','zh_CN','系统预置模板','其他入库单引入模板'); 
DELETE FROM T_BAS_IMPORTTEMPLATE_L WHERE FPKID = '0=JOLQ5ZLCO0';
INSERT INTO T_BAS_IMPORTTEMPLATE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (737376472146403328,'0=JOLQ5ZLCO0','zh_TW','係統預置模板','其他入庫單引入模板'); 


DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899586569;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'0','1',' ',747047639899586560,747047639899586569,'qtyunit3rd','0',41,' ',' ','数量(次辅单位)'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899588617;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'0','1',' ',747047639899586560,747047639899588617,'unit3rdrate','0',42,' ',' ','换算率(次辅单位)'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899586570;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1','number',747047639899586560,747047639899586570,'outinvstatus','0',43,',number,name,',' ','出库库存状态'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899588618;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1',' ',747047639899586560,747047639899588618,'outownertype','0',44,' ',' ','出库货主类型'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899586571;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1','number',747047639899586560,747047639899586571,'outowner','0',45,',number,name,',' ','出库货主'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899588619;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1',' ',747047639899586560,747047639899588619,'outkeepertype','0',46,' ',' ','出库保管者类型'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899586572;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1','number',747047639899586560,747047639899586572,'outkeeper','0',47,',number,name,',' ','出库保管者'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899588620;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1','number',747047639899586560,747047639899588620,'invtype','0',48,',number,name,',' ','入库库存类型'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899586573;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1','number',747047639899586560,747047639899586573,'invstatus','0',49,',number,name,',' ','入库库存状态'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899588621;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1',' ',747047639899586560,747047639899588621,'ownertype','0',50,' ',' ','入库货主类型'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899586574;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1','number',747047639899586560,747047639899586574,'owner','0',51,',number,name,',' ','入库货主'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899588622;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1',' ',747047639899586560,747047639899588622,'keepertype','0',52,' ',' ','入库保管者类型'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899586575;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1','number',747047639899586560,747047639899586575,'keeper','0',53,',number,name,',' ','入库保管者'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899588623;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1','number',747047639899586560,747047639899588623,'project','0',54,',number,name,',' ','项目号'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899586576;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1',' ',747047639899586560,747047639899586576,'price','0',55,' ',' ','单价'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899588624;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1',' ',747047639899586560,747047639899588624,'amount','0',56,' ',' ','金额'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899586577;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1',' ',747047639899586560,747047639899586577,'srcbillnumber','0',57,' ',' ','来源单据编号'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899588625;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1',' ',747047639899586560,747047639899588625,'entrycomment','0',58,' ',' ','备注'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899586578;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1',' ',747047639899586560,747047639899586578,'srcbillentity','0',59,' ',' ','来源单据实体'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899588626;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'0','1','number',747047639899586560,747047639899588626,'lot','0',60,'name',' ','批号ID'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899586579;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1',' ',747047639899586560,747047639899586579,'srcbillid','0',61,' ',' ','来源单据ID'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899588627;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1',' ',747047639899586560,747047639899588627,'srcbillentryid','0',62,' ',' ','来源单据行ID'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899586580;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1',' ',747047639899586560,747047639899586580,'srcbillentryseq','0',63,' ',' ','来源单据分录序号'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899588628;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'0','1',' ',747047639899586560,747047639899588628,'logisticsbill','0',64,' ',' ','物流单据'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639907975168;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'0','0',' ',747047639840866304,747047639907975168,'subentryentity','0',65,' ',' ','子单据体'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639907977216;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'0','1',' ',747047639907975168,747047639907977216,'serialnumber','0',66,' ',' ','序列号'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639907975169;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'0','1','number',747047639907975168,747047639907975169,'serialid','0',67,'name',' ','序列号ID'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639907977217;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'0','1',' ',747047639907975168,747047639907977217,'serialcomment','0',68,' ',' ','备注'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639840866304;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'0','0',' ',0,747047639840866304,'im_otherinbill','0',1,' ',' ','其他入库单'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639874422784;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'0','0',' ',747047639840866304,747047639874422784,'billhead','0',2,' ',' ','单据头'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639874420736;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'0','1','number',747047639874422784,747047639874420736,'creator','0',3,'name',' ','创建人'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639874422785;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'0','1',' ',747047639874422784,747047639874422785,'createtime','0',4,' ',' ','创建时间'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639874420737;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'0','1','number',747047639874422784,747047639874420737,'auditor','0',5,'name',' ','审核人'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639874422786;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'0','1',' ',747047639874422784,747047639874422786,'auditdate','0',6,' ',' ','审核时间'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639874420738;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1',' ',747047639874422784,747047639874420738,'billno','1',7,' ',' ','单据编号*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639874422787;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1','number',747047639874422784,747047639874422787,'biztype','1',8,',number,name,',' ','业务类型*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639874420739;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1','number',747047639874422784,747047639874420739,'billtype','1',9,',number,name,',' ','单据类型*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639874422788;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1','number',747047639874422784,747047639874422788,'invscheme','1',10,',number,name,',' ','库存事务*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639874420740;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1','number',747047639874422784,747047639874420740,'org','1',11,',number,name,',' ','库存组织*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639874422789;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1',' ',747047639874422784,747047639874422789,'biztime','1',12,' ',' ','业务日期*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639874420741;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1','number',747047639874422784,747047639874420741,'bizdept','0',13,',number,name,',' ','业务部门'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639874422790;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1','number',747047639874422784,747047639874422790,'supplier','0',14,',number,name,',' ','供应商'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639874420742;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1','number',747047639874422784,747047639874420742,'dept','0',15,',number,name,',' ','库管部门'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639874422791;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1','number',747047639874422784,747047639874422791,'operator','0',16,',number,name,',' ','库管员'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639874420743;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1','number',747047639874422784,747047639874420743,'operatorgroup','0',17,',number,name,',' ','库存组'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639874422792;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1','number',747047639874422784,747047639874422792,'customer','0',18,',number,name,',' ','客户'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639874420744;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1','number',747047639874422784,747047639874420744,'settlecurrency','0',19,',number,name,',' ','币别'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639874422793;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1',' ',747047639874422784,747047639874422793,'comment','0',20,' ',' ','备注'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639874420745;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1',' ',747047639874422784,747047639874420745,'billstatus','1',21,' ',' ','单据状态*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639874422794;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'0','1',' ',747047639874422784,747047639874422794,'isvirtualbill','0',22,' ',' ','是否虚单'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899586560;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'0','0',' ',747047639840866304,747047639899586560,'billentry','0',23,' ',' ','单据体'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899588608;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1','number',747047639899586560,747047639899588608,'material','1',24,',number,name,',' ','物料*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899586561;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'0','1',' ',747047639899586560,747047639899586561,'materialmasterid','0',25,' ',' ','物料业务策略主内码'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899588609;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1','number',747047639899586560,747047639899588609,'auxpty','0',26,',number,name,',' ','辅助属性'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899586562;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1',' ',747047639899586560,747047639899586562,'lotnumber','0',27,' ',' ','批号'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899588610;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1',' ',747047639899586560,747047639899588610,'producedate','0',28,' ',' ','生产日期'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899586563;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1',' ',747047639899586560,747047639899586563,'expirydate','0',29,' ',' ','到期日期'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899588611;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1','number',747047639899586560,747047639899588611,'unit','1',30,',number,name,',' ','计量单位*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899586564;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1',' ',747047639899586560,747047639899586564,'qty','1',31,' ',' ','数量*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899588612;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'0','1','number',747047639899586560,747047639899588612,'baseunit','0',32,',number,name,',' ','基本单位*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899586565;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'0','1',' ',747047639899586560,747047639899586565,'baseqty','0',33,' ',' ','数量(基本单位)*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899588613;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1','number',747047639899586560,747047639899588613,'unit2nd','0',34,',number,name,',' ','主辅单位'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899586566;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1',' ',747047639899586560,747047639899586566,'qtyunit2nd','0',35,' ',' ','数量(主辅单位)'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899588614;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1','number',747047639899586560,747047639899588614,'warehouse','1',36,',number,name,',' ','仓库*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899586567;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1','number',747047639899586560,747047639899586567,'location','0',37,',number,name,',' ','仓位'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899588615;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'1','1','number',747047639899586560,747047639899588615,'outinvtype','0',38,',number,name,',' ','出库库存类型'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899586568;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'0','1',' ',747047639899586560,747047639899586568,'unit2ndrate','0',39,' ',' ','换算率(主辅单位)'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 747047639899588616;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (737376472146403328,'0','1','number',747047639899586560,747047639899588616,'unit3rd','0',40,',number,name,',' ','次辅单位'); 
