/**付款计划导入模板 **/
DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 1269506001506209792;

DELETE FROM t_bas_importtemplate_l WHERE FPKID = '1ZY1QHTBF40+';
DELETE FROM t_bas_importtemplate_l WHERE FPKID = '1ZY1QHTBF40/';

DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1270326637510170624;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1270326637552000000;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1270326637552113664;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1270326637560388608;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1270326637560502272;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1270326637568777216;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1270326637577279488;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1270326637577165824;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1270326637585668096;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1270326637593943040;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1270326637594056704;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1270326637602331648;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1270326637602445312;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1270326637610720256;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1270326637610833920;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1270326637619108864;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1270326637619222528;

/***
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1269506001506209792,'1','1',' ',1270326637552000000,1270326637619222528,'real_unpay',17,'0',' ',' ',NULL);

INSERT INTO T_BAS_IMPORTTEMPLATE(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FTEMPLATETYPE,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FAPPLYSCOPE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (1269506001506209792,'1',1269506001506209792,'C','fa_lease_pay_plan_IMPT_S','IMPT','付款计划引入模板',{ts'2021-10-18  00:00:00'},1244720647309918208,'1','0',{ts'2021-10-20  00:00:00'},' ',1244720647309918208,'fa_lease_pay_plan');

INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1269506001506209792,'1ZY1QHTBF40+','zh_CN',' ','付款计划引入模板');
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1269506001506209792,'1ZY1QHTBF40/','zh_TW',' ','付款計劃引入模板');


INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1269506001506209792,'0','0',' ',0,1270326637510170624,'fa_lease_pay_plan',1,'0',' ',' ',NULL);
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1269506001506209792,'0','0',' ',1270326637510170624,1270326637552000000,'billhead',2,'0',' ',' ',NULL);
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1269506001506209792,'1','1',' ',1270326637552000000,1270326637552113664,'id',3,'1',' ',' ',NULL);
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1269506001506209792,'1','1','number',1270326637552000000,1270326637560388608,'lease',4,'0',' ','name',NULL);
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1269506001506209792,'0','1','number',1270326637552000000,1270326637560502272,'plan_currency',5,'0',' ','name',NULL);
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1269506001506209792,'1','1',' ',1270326637552000000,1270326637568777216,'plannumber',6,'0',' ',' ',NULL);
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1269506001506209792,'0','1','number',1270326637552000000,1270326637577279488,'plan_payitem',7,'0',' ','name',NULL);
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1269506001506209792,'0','1',' ',1270326637552000000,1270326637577165824,'plan_startdate',8,'0',' ',' ',NULL);
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1269506001506209792,'0','1',' ',1270326637552000000,1270326637585668096,'plan_enddate',9,'0',' ',' ',NULL);
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1269506001506209792,'0','1',' ',1270326637552000000,1270326637593943040,'planpaydate',10,'0',' ',' ',NULL);
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1269506001506209792,'0','1',' ',1270326637552000000,1270326637594056704,'plan_invoicetype',11,'0',' ',' ',NULL);
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1269506001506209792,'0','1',' ',1270326637552000000,1270326637602331648,'plan_deductible',12,'0',' ',' ',NULL);
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1269506001506209792,'0','1',' ',1270326637552000000,1270326637602445312,'plan_taxrate',13,'0',' ',' ',NULL);
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1269506001506209792,'0','1',' ',1270326637552000000,1270326637610720256,'rentnotax',14,'0',' ',' ',NULL);
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1269506001506209792,'0','1',' ',1270326637552000000,1270326637610833920,'tax',15,'0',' ',' ',NULL);
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1269506001506209792,'1','1',' ',1270326637552000000,1270326637619108864,'realpayamount',16,'0',' ',' ',NULL);
***/
