-- 预置数据资产引入模板数据
-- 引入模板表
DELETE FROM t_bas_importtemplate WHERE FID = 1803104211660394496;
INSERT INTO t_bas_importtemplate(FID,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCOMMENT,FSTATUS,FCREATORID,FNUMBER,FNAME,FBIZOBJECT) VALUES (1803104211660394496,{ts'2023-10-24  00:00:00'},1642682378034341888,'1',{ts'2023-11-08  00:00:00'},' ','C',1642682378034341888,'fa_dataasset_card_IMPT_S','数据资产引入模板','fa_dataasset_card');

-- 引入模板多语言表
DELETE FROM t_bas_importtemplate_l WHERE FPKID = '3NGH9JXMFZRP';
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1803104211660394496,'3NGH9JXMFZRP','zh_CN',' ','数据资产引入模板');
DELETE FROM t_bas_importtemplate_l WHERE FPKID = '3NGH9JXMFZRQ';
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1803104211660394496,'3NGH9JXMFZRQ','zh_TW',' ','數據資產引入模板');

-- 引入模板分录表
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408399976457;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'0','1',' ',1803093408391581696,1803093408399976457,'createtime',24,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408399976458;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'0','1',' ',1803093408391581696,1803093408399976458,'modifytime',26,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408399976459;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'0','1',' ',1803093408391581696,1803093408399976459,'auditdate',28,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1808750901415313410;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'0','1',' ',1803093408391581696,1808750901415313410,'lastmodifytime',29,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408953624578;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'0','1',' ',1803093408945229824,1803093408953624578,'modifydatefield',40,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408953624581;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'1','1',' ',1803093408945229824,1803093408953624581,'detailmdftime',42,'1',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408399970316;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'1','1',' ',1803093408391581696,1803093408399970316,'remark',9,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408399970304;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'1','1',' ',1803093408391581696,1803093408399970304,'assetname',10,'1',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408399970308;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'1','1',' ',1803093408391581696,1803093408399970308,'model',11,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408399976449;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'0','1',' ',1803093408391581696,1803093408399976449,'assetqty',13,'1',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408399976450;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'1','1',' ',1803093408391581696,1803093408399976450,'frequency',17,'1',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408399970305;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'0','1',' ',1803093408391581696,1803093408399970305,'scaleqty',21,'1',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408399976452;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'0','1',' ',1803093408391581696,1803093408399976452,'billstatus',22,'1',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1808750901415065603;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'0','1',' ',1803093408391581696,1808750901415065603,'initqty',30,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1818243598261800960;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'0','1',' ',1803093408391581696,1818243598261800960,'bizstatus',31,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408945229824;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'0','0',' ',1803093408391587840,1803093408945229824,'entryentity',32,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408953624576;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'0','1',' ',1803093408945229824,1803093408953624576,'entryentity.id',33,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408953618434;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'1','1',' ',1803093408945229824,1803093408953618434,'detailname',34,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408953624577;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'1','1',' ',1803093408945229824,1803093408953624577,'detailqty',35,'1',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408399976460;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'1','1','number',1803093408391581696,1803093408399976460,'org',5,'1',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408399970315;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'1','1','number',1803093408391581696,1803093408399970315,'accountorg',6,'1',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408399970309;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'1','1','number',1803093408391581696,1803093408399970309,'qtyunit',12,'1',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408399976454;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'1','1','number',1803093408391581696,1803093408399976454,'scaleunit',14,'1',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408399976453;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'1','1','number',1803093408391581696,1803093408399976453,'storeplace',15,'1',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408399970310;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'1','1','number',1803093408391581696,1803093408399970310,'sourcetype',16,'1',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408399976455;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'1','1','number',1803093408391581696,1803093408399976455,'keepdept',18,'0',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408399970311;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'1','1','number',1803093408391581696,1803093408399970311,'keeper',19,'0',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408399976456;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'1','1','number',1803093408391581696,1803093408399976456,'supplier',20,'0',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408399970312;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'0','1','number',1803093408391581696,1803093408399970312,'creator',23,'0',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408399970314;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'0','1','number',1803093408391581696,1803093408399970314,'auditor',27,'0',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408953624579;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'1','1','number',1803093408945229824,1803093408953624579,'detailsupplier',36,'0',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408953618433;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'0','1','number',1803093408945229824,1803093408953618433,'modifierfield',39,'0',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408953618436;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'0','1','number',1803093408945229824,1803093408953618436,'detailmodifer',41,'0',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408953618435;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'0','1',' ',1803093408945229824,1803093408953618435,'detailstatus',37,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408953624580;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'1','1',' ',1803093408945229824,1803093408953624580,'detailremark',38,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1808750901675112450;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'0','1',' ',1803093408945229824,1808750901675112450,'detailid',43,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1808750901675360258;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'0','1',' ',1803093408945229824,1808750901675360258,'detailmdftimetext',44,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408399970313;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'0','1','number',1803093408391581696,1803093408399970313,'modifier',25,'0',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408391587840;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'0','0',' ',0,1803093408391587840,'fa_dataasset_card',1,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408391581696;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'0','0',' ',1803093408391587840,1803093408391581696,'billhead',2,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408399976448;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'0','1',' ',1803093408391581696,1803093408399976448,'id',3,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408399976451;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'1','1',' ',1803093408391581696,1803093408399976451,'billno',4,'1',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408399970306;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'1','1',' ',1803093408391581696,1803093408399970306,'registdate',7,'1',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1803093408399970307;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1803104211660394496,'1','1',' ',1803093408391581696,1803093408399970307,'content',8,'1',' ',' ',NULL);