-- T_FA_BILLPARAM_TYPE 预制数据
DELETE FROM T_FA_BILLPARAM_TYPE WHERE FID = 1702982055106720768;
INSERT INTO T_FA_BILLPARAM_TYPE(FID,FBIZAPPID,FDESCRIPTION,FBIZCLOUDID,FNUMBER,FNAME) VALUES (1702982055106720768,'83bfebc800001aac',' ','83bfebc8000002ac','report.batch','报表分批'); 
DELETE FROM T_FA_BILLPARAM_TYPE WHERE FID = 1702996507008975872;
INSERT INTO T_FA_BILLPARAM_TYPE(FID,FBIZAPPID,FDESCRIPTION,FBIZCLOUDID,FNUMBER,FNAME) VALUES (1702996507008975872,'83bfebc800001aac',' ','83bfebc8000002ac','oldTerminalLeaseIdForReportQuery','历史终止合同ID'); 
DELETE FROM T_FA_BILLPARAM_TYPE WHERE FID = 1702997363485852672;
INSERT INTO T_FA_BILLPARAM_TYPE(FID,FBIZAPPID,FDESCRIPTION,FBIZCLOUDID,FNUMBER,FNAME) VALUES (1702997363485852672,'83bfebc800001aac',' ','83bfebc8000002ac','HAS_VALUE_DEPRE_IS_NETAMOUNT_LARGE_PRERESIDUALVAL','启用有可提折旧额为净额大于残值'); 
DELETE FROM T_FA_BILLPARAM_TYPE WHERE FID = 1702998285494535168;
INSERT INTO T_FA_BILLPARAM_TYPE(FID,FBIZAPPID,FDESCRIPTION,FBIZCLOUDID,FNUMBER,FNAME) VALUES (1702998285494535168,'83bfebc800001aac',' ','83bfebc8000002ac','showTerminationData','摊销与计息是否展示终止摊销期间之后的数据'); 
DELETE FROM T_FA_BILLPARAM_TYPE WHERE FID = 1703113502363011072;
INSERT INTO T_FA_BILLPARAM_TYPE(FID,FBIZAPPID,FDESCRIPTION,FBIZCLOUDID,FNUMBER,FNAME) VALUES (1703113502363011072,'83bfebc800001aac',' ','83bfebc8000002ac','START_BUSY_RECORD_PERIOD','启用卡片变动记录开始期间'); 
DELETE FROM T_FA_BILLPARAM_TYPE WHERE FID = 1703086120940001280;
INSERT INTO T_FA_BILLPARAM_TYPE(FID,FBIZAPPID,FDESCRIPTION,FBIZCLOUDID,FNUMBER,FNAME) VALUES (1703086120940001280,'83bfebc800001aac','true:开启；false:关闭','83bfebc8000002ac','enableplatformthreadpool','开启平台线程池方案'); 
DELETE FROM T_FA_BILLPARAM_TYPE WHERE FID = 1703114890014935040;
INSERT INTO T_FA_BILLPARAM_TYPE(FID,FBIZAPPID,FDESCRIPTION,FBIZCLOUDID,FNUMBER,FNAME) VALUES (1703114890014935040,'83bfebc800001aac','变更单-是否开启折旧、分摊的简化处理；1.开启：true；2.关闭：false','83bfebc8000002ac','changebill.depresplit.simplification','变更单折旧简化处理'); 


-- 更新t_fa_billparam表数据
UPDATE T_FA_BILLPARAM SET FPARAMTYPEID = 1702982055106720768 WHERE FPARAM = 'report.batch';

UPDATE T_FA_BILLPARAM SET FPARAMTYPEID = 1702996507008975872 WHERE FPARAM = 'oldTerminalLeaseIdForReportQuery';

UPDATE T_FA_BILLPARAM SET FPARAMTYPEID = 1702997363485852672 WHERE FPARAM = 'HAS_VALUE_DEPRE_IS_NETAMOUNT_LARGE_PRERESIDUALVAL';

UPDATE T_FA_BILLPARAM SET FPARAMTYPEID = 1702998285494535168 WHERE FPARAM = 'showTerminationData';

UPDATE T_FA_BILLPARAM SET FPARAMTYPEID = 1703113502363011072 WHERE FPARAM = 'START_BUSY_RECORD_PERIOD';

UPDATE T_FA_BILLPARAM SET FPARAMTYPEID = 1703086120940001280 WHERE FPARAM = 'enableplatformthreadpool';

UPDATE T_FA_BILLPARAM SET FPARAMTYPEID = 1703114890014935040 WHERE FPARAM = 'changebill.depresplit.simplification';


-- 更新t_fa_billparam表的云id和应用id
UPDATE T_FA_BILLPARAM SET FBIZCLOUDID = '83bfebc8000002ac',FBIZAPPID = '83bfebc800001aac' WHERE FPARAM IN ('report.batch', 'oldTerminalLeaseIdForReportQuery', 'HAS_VALUE_DEPRE_IS_NETAMOUNT_LARGE_PRERESIDUALVAL', 'showTerminationData', 'START_BUSY_RECORD_PERIOD', 'enableplatformthreadpool', 'changebill.depresplit.simplification');