--主表
DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 1015137271785077760;
DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 1015137995990278144;
--删分录
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FID = 1015137271785077760;
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FID = 1015137995990278144;
--删多语言
DELETE FROM T_BAS_IMPORTTEMPLATE_L WHERE FPKID = '15OE/ZI2QFRW';
DELETE FROM T_BAS_IMPORTTEMPLATE_L WHERE FPKID = '15OE/ZI2QFRX';
DELETE FROM T_BAS_IMPORTTEMPLATE_L WHERE FPKID = '15OE56RJP=V5';
DELETE FROM T_BAS_IMPORTTEMPLATE_L WHERE FPKID = '15OE56RJP=V6';


DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 1300066976433053696;
INSERT INTO T_BAS_IMPORTTEMPLATE(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FTEMPLATETYPE,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (1300066976433053696,'1',1300066976433053696,'C','mds_quotadata_IMPT_SYS_PRE','IMPT','配额引入预制模板',{ts'2021-11-29  00:00:00'},1155582473783010304,'1',{ts'2021-12-06  00:00:00'},' ',1155582473783010304,'mds_quotadata');

--分录
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1300066651357612032;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1300066976433053696,'0','0',' ',0,1300066651357612032,'mds_quotadata',1,'0',' ',' ',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1300066651391166469;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1300066976433053696,'1','1','number',1300066651374493696,1300066651391166469,'material',5,'1',' ','number',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1300066651391166466;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1300066976433053696,'0','1','number',1300066651374493696,1300066651391166466,'creator',8,'0',' ','name',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1300066651391166467;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1300066976433053696,'0','1','number',1300066651374493696,1300066651391166467,'modifier',10,'0',' ','name',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1300066651391166468;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1300066976433053696,'1','1','number',1300066651374493696,1300066651391166468,'createorg',12,'1',' ','number',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1300066651391270919;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1300066976433053696,'0','1','number',1300066651374493696,1300066651391270919,'useorg',18,'0',' ','name',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1300066651424825344;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1300066976433053696,'0','1','number',1300066651374493696,1300066651424825344,'org',19,'0',' ','name',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1300066651483441153;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1300066976433053696,'1','1','number',1300066651483545600,1300066651483441153,'allocateorg',23,'1',' ','number',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1300066651374493696;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1300066976433053696,'0','0',' ',1300066651357612032,1300066651374493696,'billhead',2,'0',' ',' ',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1300066651391166464;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1300066976433053696,'0','1',' ',1300066651374493696,1300066651391166464,'id',3,'0',' ',' ',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1300066651391270912;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1300066976433053696,'1','1',' ',1300066651374493696,1300066651391270912,'quotatype',4,'1',' ',' ',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1300066651391166465;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1300066976433053696,'1','1',' ',1300066651374493696,1300066651391166465,'effectdate',6,'1',' ',' ',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1300066651391270913;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1300066976433053696,'1','1',' ',1300066651374493696,1300066651391270913,'losedate',7,'1',' ',' ',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1300066651391270914;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1300066976433053696,'0','1',' ',1300066651374493696,1300066651391270914,'createtime',9,'0',' ',' ',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1300066651391270915;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1300066976433053696,'0','1',' ',1300066651374493696,1300066651391270915,'modifytime',11,'0',' ',' ',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1300066651391270916;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1300066976433053696,'0','1',' ',1300066651374493696,1300066651391270916,'number',13,'0',' ',' ',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1300066651391270917;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1300066976433053696,'0','1',' ',1300066651374493696,1300066651391270917,'name',14,'0',' ',' ',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1300066651391166470;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1300066976433053696,'0','1',' ',1300066651374493696,1300066651391166470,'materialname',15,'0',' ',' ',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1300066651391270918;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1300066976433053696,'0','1',' ',1300066651374493696,1300066651391270918,'status',16,'0',' ',' ',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1300066651391166471;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1300066976433053696,'0','1',' ',1300066651374493696,1300066651391166471,'enable',17,'0',' ',' ',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1300066651483545600;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1300066976433053696,'0','0',' ',1300066651357612032,1300066651483545600,'entryentity',20,'0',' ',' ',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1300066651483441152;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1300066976433053696,'0','1',' ',1300066651483545600,1300066651483441152,'entryentity.id',21,'0',' ',' ',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1300066651483545601;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1300066976433053696,'1','1',' ',1300066651483545600,1300066651483545601,'quotamod',22,'1',' ',' ',NULL);

--多语言表
DELETE FROM T_BAS_IMPORTTEMPLATE_L WHERE FPKID = '21OGXTTRUHMA';
INSERT INTO T_BAS_IMPORTTEMPLATE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1300066976433053696,'21OGXTTRUHMA','zh_CN',' ','配额引入预制模板');
