DELETE from T_BAS_IMPORTTEMPLATE WHERE fid = '685961620031242240';

Insert into T_BAS_IMPORTTEMPLATE (FID,FCREATETIME,FMODIFYTIME,FMODIFIERID,FNUMBER,FNAME,FBIZOBJECT,FSTATUS,FCREATORID,FENABLE,FCOMMENT,FMASTERID,FTEMPLATETYPE,FENABLEIMPORT) values (685961620031242240,{ts'2018-08-08 18:08:08'},{ts'2018-08-08 18:08:08'},1,'pbd_goodsclass_IMPT_S',' ','pbd_goodsclass','C',1,'1',' ',685961620031242240,'IMPT','1');

DELETE from T_BAS_IMPORTTEMPLATE_L WHERE fid = '685961620031242240';
Insert into T_BAS_IMPORTTEMPLATE_L (FPKID,FID,FLOCALEID,FNAME,FCOMMENT) values ('048BZKCROF3R',685961620031242240,'zh_CN','商品分类引入预置模板',' ');
Insert into T_BAS_IMPORTTEMPLATE_L (FPKID,FID,FLOCALEID,FNAME,FCOMMENT) values ('048BZKCROF3S',685961620031242240,'zh_TW','商品分類引入預置模板',' ');

DELETE from T_BAS_IMPORTTEMPLATEENTRY WHERE fid = '685961620031242240';
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685961620031242240,685960663100784640,0,1,'pbd_goodsclass','商品分类','0',' ','0','0',' ',' ');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685961620031242240,685960663117404160,685960663100784640,2,'billhead','单据头','0',' ','0','0',' ',' ');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685961620031242240,685960663117561856,685960663117404160,3,'creator','创建人','0',' ','0','1','number','name');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685961620031242240,685960663117404161,685960663117404160,4,'createtime','创建时间','0',' ','0','1',' ',' ');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685961620031242240,685960663117561857,685960663117404160,5,'disabler','禁用人','0',' ','0','1','number','name');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685961620031242240,685960663117404162,685960663117404160,6,'disabledate','禁用时间','0',' ','0','1',' ',' ');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685961620031242240,685960663117561858,685960663117404160,7,'status','数据状态','0',' ','0','1',' ',' ');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685961620031242240,685960663117404163,685960663117404160,8,'enable','可用状态','0',' ','0','1',' ',' ');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685961620031242240,685960663117561859,685960663117404160,9,'isleaf','是否叶子','0',' ','0','1',' ',' ');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685961620031242240,685960663117404164,685960663117404160,10,'level','级次','0',' ','0','1',' ',' ');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685961620031242240,685960663117561860,685960663117404160,11,'longnumber','长编码','0',' ','0','1',' ',' ');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685961620031242240,685960663117404165,685960663117404160,12,'material','对应ERP物料','0',' ','0','1','number','name');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685961620031242240,685960663117561861,685960663117404160,13,'purtype','对应采购类型','0',' ','0','1','number','name');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685961620031242240,685960663117404166,685960663117404160,14,'parent','上级分类','0',' ','1','1','name','name');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685961620031242240,685960663117561862,685960663117404160,15,'source','分类来源','0',' ','0','1',' ',' ');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685961620031242240,685960663117404167,685960663117404160,16,'description','备注','0',' ','1','1',' ',' ');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685961620031242240,685960663117561863,685960663117404160,17,'isonhomepage','商城首页展示','0',' ','0','1',' ',' ');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685961620031242240,685960663117404168,685960663117404160,18,'number','编码*','1',' ','1','1',' ',' ');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685961620031242240,685960663117561864,685960663117404160,19,'name','名称*','1',' ','1','1',' ',' ');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685961620031242240,685960663117404169,685960663117404160,20,'fullname','全称','0',' ','0','1',' ',' ');
