-- 商旅集成设置参数
DELETE FROM T_ER_TRIPSYNCSETTING WHERE FID = 942657351004110848;
INSERT INTO T_ER_TRIPSYNCSETTING(FID,FCREATETIME,FMODIFIERID,FENABLE,FVALUE,FMODIFYTIME,FMASTERID,FSTATUS,FCREATORID,FDESC,FNUMBER) VALUES (942657351004110848,{ts'2020-07-24  14:51:37'},13466739,'1','2',{ts'2020-07-24  14:51:53'},942657351004110848,'C',13466739,'携程火车订单按照结算数据T+2模式同步,获取距离当前日期n天前到当前时间前一天的结算单, n默认value为2。','ctrip_getTrainOrderT2_daycount'); 
DELETE FROM T_ER_TRIPSYNCSETTING WHERE FID = 942658995599097856;
INSERT INTO T_ER_TRIPSYNCSETTING(FID,FCREATETIME,FMODIFIERID,FENABLE,FVALUE,FMODIFYTIME,FMASTERID,FSTATUS,FCREATORID,FDESC,FNUMBER) VALUES (942658995599097856,{ts'2020-07-24  14:54:12'},13466739,'1','2',{ts'2020-07-24  14:55:09'},942658995599097856,'C',13466739,'携程机票订单按照结算数据T+2模式同步,获取距离当前日期n天前到当前时间前一天的结算单, n默认value为2。','ctrip_getPlaneOrderT2_daycount'); 
DELETE FROM T_ER_TRIPSYNCSETTING WHERE FID = 942662128417030144;
INSERT INTO T_ER_TRIPSYNCSETTING(FID,FCREATETIME,FMODIFIERID,FENABLE,FVALUE,FMODIFYTIME,FMASTERID,FSTATUS,FCREATORID,FDESC,FNUMBER) VALUES (942662128417030144,{ts'2020-07-17  14:59:34'},13466739,'1','true',{ts'2020-07-17  15:01:22'},942662128417030144,'C',13466739,'商旅同步订单和结算单是否进行必填校验，默认为true。true：进行必填校验，false：不进行必填校验。','trip_sync_orderbill_isverify_mustinput'); 
DELETE FROM T_ER_TRIPSYNCSETTING WHERE FID = 942663311688908800;
INSERT INTO T_ER_TRIPSYNCSETTING(FID,FCREATETIME,FMODIFIERID,FENABLE,FVALUE,FMODIFYTIME,FMASTERID,FSTATUS,FCREATORID,FDESC,FNUMBER) VALUES (942663311688908800,{ts'2020-07-24  15:02:57'},13466739,'1','false',{ts'2020-07-24  15:03:43'},942663311688908800,'C',13466739,'差旅壹号同步组织时，是否同步苍穹根组织。默认为 false，即不同步。差旅壹号测试账套只存在唯一一个根组织，无法新增，此时需要将参数改为true，进行根组织同步，苍穹根组织的上级即为差旅壹号根组织。','ttrip_is_sync_rootorg'); 
DELETE FROM T_ER_TRIPSYNCSETTING WHERE FID = 942663680192069632;
INSERT INTO T_ER_TRIPSYNCSETTING(FID,FCREATETIME,FMODIFIERID,FENABLE,FVALUE,FMODIFYTIME,FMASTERID,FSTATUS,FCREATORID,FDESC,FNUMBER) VALUES (942663680192069632,{ts'2020-07-24  15:03:59'},13466739,'1','10',{ts'2020-07-24  15:04:27'},942663680192069632,'C',13466739,'差旅壹号每次同步组织和人员的数量','ttrip_sync_org_user_size'); 
DELETE FROM T_ER_TRIPSYNCSETTING WHERE FID = 942663906038562816;
INSERT INTO T_ER_TRIPSYNCSETTING(FID,FCREATETIME,FMODIFIERID,FENABLE,FVALUE,FMODIFYTIME,FMASTERID,FSTATUS,FCREATORID,FDESC,FNUMBER) VALUES (942663906038562816,{ts'2020-07-24  15:04:40'},13466739,'1','500',{ts'2020-07-24  15:04:54'},942663906038562816,'C',13466739,'差旅壹号每次同步订单的数量','ttrip_sync_orderbill_size'); 
DELETE FROM T_ER_TRIPSYNCSETTING WHERE FID = 937410393167659008;
INSERT INTO T_ER_TRIPSYNCSETTING(FID,FCREATETIME,FMODIFIERID,FENABLE,FVALUE,FMODIFYTIME,FMASTERID,FSTATUS,FCREATORID,FDESC,FNUMBER) VALUES (937410393167659008,{ts'2020-07-17  09:04:46'},13466739,'1','false',{ts'2020-07-17  09:07:46'},937410393167659008,'C',13466739,'是否保存全部商旅集成日志，默认为false：只保存异常日志；可以改为true：保存全部日志','keep_all_log'); 
DELETE FROM t_er_tripsyncsetting WHERE FID = 943278985285216256;
INSERT INTO t_er_tripsyncsetting(FID,FCREATETIME,FMODIFIERID,FENABLE,FVALUE,FMODIFYTIME,FMASTERID,FSTATUS,FCREATORID,FDESC,FNUMBER) VALUES (943278985285216256,{ts'2020-07-17  11:26:45'},13466739,'1','30',{ts'2020-07-17  11:31:47'},943278985285216256,'C',13466739,'商旅集成日志保留天数，默认为30：删除30天前的日志，只保留30天内的日志。','keep_log_days'); 
