-- 付款类型 增加 工资支付
DELETE From T_CAS_PaymentBillType Where FID = 332235621101756416;
INSERT INTO t_cas_paymentbilltype (FID, FNUMBER, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FISRETURNBG, FDESCRIPTION, FENABLE, FISPRESET, FSTATUS, FISPARTPAYMENT) VALUES ('332235621101756416', '997', '0', NULL, '0', NULL, '0', '工资支付', '1', '1', 'C', '0');

DELETE From T_CAS_PaymentBillType_L Where FID = 332235621101756416;
INSERT INTO t_cas_paymentbilltype_l (FPKID, FLOCALEID, FNAME, FID) VALUES ('11VRVBFBWR92', 'zh_CN', '工资支付', '332235621101756416');
INSERT INTO t_cas_paymentbilltype_l (FPKID, FLOCALEID, FNAME, FID) VALUES ('11VRVBFBWR93', 'zh_TW', '工資支付', '332235621101756416');

-- 收款类型历史数据升级
update T_CAS_ReceivingBillType set fbiztype = ' ' where FIsPreSet=0;
update T_CAS_ReceivingBillType set fbiztype = FNumber where FIsPreSet=1 and FNumber IN ('100','101','102','103','104','106','107','999');
-- 付款类型历史数据升级
update T_CAS_PaymentBillType set fbiztype = ' ' where FIsPreSet=0;
update T_CAS_PaymentBillType set fbiztype = FNumber where FIsPreSet=1 and FNumber IN ('201','202','203','204','205','210','211','212','997','999');

