DELETE FROM t_bas_importtemplate WHERE FID = 830481377224241152;
INSERT INTO t_bas_importtemplate(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES 
(830481377224241152,'1',830481377224241152,'C','bd_suppliersite_IMPT_S',' ','IMPT',{ts'2020-02-20  20:15:54'},403700558952663057,'1',{ts'2020-02-20  20:28:36'},' ',1,'bd_suppliersite'); 

DELETE FROM t_bas_importtemplate_l WHERE FID = 830481377224241152;
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (830481377224241152,'0L+QVKESFZ2F','zh_CN','系统预置模板 ','供应商地点引入模版'); 
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (830481377224241152,'0L+QVKESFZ2G','zh_TW','係統預置模板 ','供應商地點引入模版'); 

DELETE FROM t_bas_importtemplateentry WHERE FID = 830481377224241152;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'0','0',' ',0,830486119144974336,'bd_suppliersite',1,'0',' ',' ',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'0','0',' ',830486119144974336,830486119178514432,'billhead',2,'0',' ',' ',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'1','1',' ',830486119178514432,830486119178528768,'number',3,'1',' ',' ',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'1','1',' ',830486119178514432,830486119178514433,'name',4,'1',' ',' ',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'1','1',' ',830486119178514432,830486119178528769,'bizfunction',5,'1',' ',' ',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'1','1','number',830486119178514432,830486119178514434,'createorg',6,'1',' ','name',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'1','1','number',830486119178514432,830486119178528770,'useorg',7,'1',' ','name',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'1','1','number',830486119178514432,830486119178514435,'supplier',8,'1',' ','name',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'0','1','number',830486119178514432,830486119178528771,'address',9,'0',' ','name',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'0','1','number',830486119178514432,830486119178514436,'paymentcurrency',10,'0',' ','name',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'0','1','number',830486119178514432,830486119178528772,'settlementtypeid',11,'0',' ','name',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'0','1','number',830486119178514432,830486119178514437,'paycond',12,'0',' ','name',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'0','1',' ',830486119178514432,830486119178528773,'invoicetype',13,'0',' ',' ',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'0','1',' ',830486119178514432,830486119178514438,'paymentunit',14,'0',' ',' ',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'0','1',' ',830486119178514432,830486119178528774,'matchingrule',15,'0',' ',' ',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'0','1','number',830486119178514432,830486119178514439,'billaddress',16,'0',' ','name',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'0','1','number',830486119178514432,830486119178528775,'invoiceaddress',17,'0',' ','name',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'0','1',' ',830486119178514432,830486119178514440,'createtime',18,'0',' ',' ',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'0','1','number',830486119178514432,830486119178528776,'org',19,'0',' ','name',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'0','1',' ',830486119178514432,830486119178514441,'supmasterid',20,'0',' ',' ',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'0','1',' ',830486119178514432,830486119178528777,'disabledate',21,'0',' ',' ',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'0','1','number',830486119178514432,830486119178514442,'disabler',22,'0',' ','name',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'0','1','number',830486119178514432,830486119178528778,'settlementcyid',23,'0',' ','name',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'0','1','number',830486119178514432,830486119178514443,'taxrate',24,'0',' ','name',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'0','1','number',830486119178514432,830486119178528779,'receiveraddress',25,'0',' ','name',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'0','1',' ',830486119178514432,830486119178514444,'freighttype',26,'0',' ',' ',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'0','1','number',830486119178514432,830486119178528780,'priceclause',27,'0',' ','name',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'0','1','number',830486119178514432,830486119178514445,'scstype',28,'0',' ','name',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'0','1',' ',830486119178514432,830486119178528781,'ratetype',29,'0',' ',' ',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'1','1',' ',830486119178514432,830486119178514446,'status',30,'0',' ',' ',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'1','1',' ',830486119178514432,830486119178528782,'enable',31,'0',' ',' ',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'0','1',' ',830486119178514432,830486119178514447,'supplier_status',32,'0',' ',' ',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'1','1',' ',830486119178514432,830486119178528783,'ctrlstrategy',33,'0',' ',' ',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'1','1','number',830486119178514432,830486119178514448,'creator',34,'0',' ','name',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'0','1',' ',830486119178514432,830486119178528784,'picturefield',35,'0',' ',' ',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'0','0',' ',830486119144974336,830486119186903040,'entry_bank',36,'0',' ',' ',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'1','1',' ',830486119186903040,830486119186917376,'bankaccount',37,'1',' ',' ',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'1','1',' ',830486119186903040,830486119186903041,'accountname',38,'1',' ',' ',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'1','1','number',830486119186903040,830486119186917377,'bank',39,'1',' ','name',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'1','1','number',830486119186903040,830486119186903042,'currency',40,'1',' ','name',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'0','1',' ',830486119186903040,830486119186917378,'isdefault_bank',41,'0',' ',' ',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'0','1',' ',830486119186903040,830486119186903043,'bankaccounttype',42,'0',' ',' ',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'0','1','number',830486119186903040,830486119186917379,'settlment',43,'0',' ','name',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'0','1',' ',830486119186903040,830486119186903044,'commissionbearer',44,'0',' ',' ',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'0','1',' ',830486119186903040,830486119186917380,'liquidationparam',45,'0',' ',' ',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'0','1',' ',830486119186903040,830486119186903045,'agentbankaccount',46,'0',' ',' ',null); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (830481377224241152,'0','1','number',830486119186903040,830486119186917381,'agentbank',47,'0',' ','name',null); 
