antissoft / lvqianmeiye_ERP

大客卡金异常监控阈值配置.sql 1.33 KB
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 
-- 大客卡金异常监控阈值（默认 50000 元）
INSERT INTO `base_sysconfig` (`F_Id`, `F_Name`, `F_Key`, `F_Value`, `F_Category`)
SELECT '197007301800000001', '大额开单监控阈值', 'largeAmountBillingThreshold', '50000', 'SysConfig'
WHERE NOT EXISTS (SELECT 1 FROM `base_sysconfig` WHERE `F_Category` = 'SysConfig' AND LOWER(`F_Key`) = 'largeamountbillingthreshold');

INSERT INTO `base_sysconfig` (`F_Id`, `F_Name`, `F_Key`, `F_Value`, `F_Category`)
SELECT '197007301800000002', '大额耗卡监控阈值', 'largeAmountConsumeThreshold', '50000', 'SysConfig'
WHERE NOT EXISTS (SELECT 1 FROM `base_sysconfig` WHERE `F_Category` = 'SysConfig' AND LOWER(`F_Key`) = 'largeamountconsumethreshold');

INSERT INTO `base_sysconfig` (`F_Id`, `F_Name`, `F_Key`, `F_Value`, `F_Category`)
SELECT '197007301800000003', '大额退卡监控阈值', 'largeAmountRefundThreshold', '50000', 'SysConfig'
WHERE NOT EXISTS (SELECT 1 FROM `base_sysconfig` WHERE `F_Category` = 'SysConfig' AND LOWER(`F_Key`) = 'largeamountrefundthreshold');

INSERT INTO `base_sysconfig` (`F_Id`, `F_Name`, `F_Key`, `F_Value`, `F_Category`)
SELECT '197007301800000004', '大额转卡监控阈值', 'largeAmountTransferThreshold', '50000', 'SysConfig'
WHERE NOT EXISTS (SELECT 1 FROM `base_sysconfig` WHERE `F_Category` = 'SysConfig' AND LOWER(`F_Key`) = 'largeamounttransferthreshold');