
DELETE FROM t_bas_importtemplateentry WHERE FID = 1057892893475223552;
DELETE FROM t_bas_importtemplate WHERE FID = 1057892893475223552;
INSERT INTO t_bas_importtemplate(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FTEMPLATETYPE,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FAPPLYSCOPE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (1057892893475223552,'1',1057892893475223552,'C','bcm_annaccount_import_IMPT_S','IMPT','閹圭喓娉紒鎾规祮鐎电厧鍙嗛幗鍛婃緲',{ts'2020-12-30  00:00:00'},13466739,'1','0',{ts'2021-11-10  00:00:00'},' ',13466739,'bcm_annaccount_import');

DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1062225568856066048;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'0','0',' ',0,1062225568856066048,'bcm_annaccount_import',1,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1062225569007062016;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'0','0',' ',1062225568856066048,1062225569007062016,'billhead',2,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1062225569032226816;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'0','1',' ',1062225569007062016,1062225569032226816,'id',3,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1062225569057393664;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'1','1','number',1062225569007062016,1062225569057393664,'model',4,'1',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1086869210941889536;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'1','1',' ',1062225569007062016,1086869210941889536,'dseq',5,'1',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1286161300665201666;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'1','1',' ',1062225569007062016,1286161300665201666,'isopen',6,'1',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1783978415846611968;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'0','0',' ',1062225568856066048,1783978415846611968,'applyentityentry',7,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1783978415871778816;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'0','1',' ',1783978415846611968,1783978415871778816,'applyentityentry.id',8,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1783978415980829696;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'1','1',' ',1783978415846611968,1783978415980829696,'entityapplytype',9,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1783978415880166400;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'1','1',' ',1783978415846611968,1783978415880166400,'entitynumber',10,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1783978415888556032;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'1','1',' ',1783978415846611968,1783978415888556032,'entityscope',11,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1783978416148602880;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'0','0',' ',1062225568856066048,1783978416148602880,'applysceneentry',12,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1783978416182156288;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'0','1',' ',1783978416148602880,1783978416182156288,'applysceneentry.id',13,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1783978416207323136;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'1','1',' ',1783978416148602880,1783978416207323136,'sceneapplytype',14,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1783978416182157312;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'1','1',' ',1783978416148602880,1783978416182157312,'scenenumber',15,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1783978416198933504;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'1','1',' ',1783978416148602880,1783978416198933504,'scenescope',16,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1062225569149667328;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'0','0',' ',1062225568856066048,1062225569149667328,'annualaccountbefore',17,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1062225569166445568;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'0','1',' ',1062225569149667328,1062225569166445568,'annualaccountbefore.id',18,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1062225569183221760;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'1','1','number',1062225569149667328,1062225569183221760,'dimension',19,'0',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1062225569200000000;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'1','1',' ',1062225569149667328,1062225569200000000,'dimmembernum',20,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1062225569216776192;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'1','1',' ',1062225569149667328,1062225569216776192,'scope',21,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1783982956541402114;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'0','1',' ',1062225569149667328,1783982956541402114,'applytype',22,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1062225569342605312;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'0','0',' ',1062225568856066048,1062225569342605312,'annualaccountafter',23,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1062225569409715200;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'0','1',' ',1062225569342605312,1062225569409715200,'annualaccountafter.id',24,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1062225569434880000;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'1','1','number',1062225569342605312,1062225569434880000,'account',25,'0',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1062225569460046848;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'1','1','number',1062225569342605312,1062225569460046848,'changetype',26,'0',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1062225569476823040;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'1','1','number',1062225569342605312,1062225569476823040,'multigaap',27,'0',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1062225569501989888;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'1','1','number',1062225569342605312,1062225569501989888,'dim1',28,'0',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1062225569518766080;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'1','1','number',1062225569342605312,1062225569518766080,'dim2',29,'0',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1062225569543932928;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'1','1','number',1062225569342605312,1062225569543932928,'dim3',30,'0',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1062225569560709120;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'1','1','number',1062225569342605312,1062225569560709120,'dim4',31,'0',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1062225569577487360;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'1','1','number',1062225569342605312,1062225569577487360,'dim5',32,'0',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1062225569585874944;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'1','1','number',1062225569342605312,1062225569585874944,'dim6',33,'0',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1695682237137176576;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'1','1','number',1062225569342605312,1695682237137176576,'internalcompany',34,'0',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1695682400840859648;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'1','1','number',1062225569342605312,1695682400840859648,'mycompany',35,'0',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1695682451214452736;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'1','1','number',1062225569342605312,1695682451214452736,'datasort',36,'0',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1783982956566567942;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1057892893475223552,'1','1','number',1062225569342605312,1783982956566567942,'audittrail',37,'0',' ','name',NULL);
