
--if not exists(select 1 from UFSystem..sysobjects where name ='UA_AccountDatabase' and xtype ='U' ) 
--	raiserror ('需要11.1以上版本',16,1)

--go
   if exists (select 1 where OBJECT_ID('tempdb..#t6auth') is not null)
   drop table #t6auth 
   select cauth_id t6authid,cauth_id u8authid into #t6auth  from ufsystem..ua_auth_base where 1=0
--HR
	insert into #t6auth (t6authid,u8authid) values(N'WA04018',N'WA04018')-- T6权限 [WA04018  我的账表] 升级至V11.1权限[WA04018  我的账表]
--财务一部
	insert into #t6auth (t6authid,u8authid) values(N'AP060101',N'AP0601011')-- T6权限 [AP060101  发票查询] 升级至V11.1权限[AP0601011  采购发票查询列表]
	insert into #t6auth (t6authid,u8authid) values(N'AP06010101',N'AP060101')-- T6权限 [AP06010101  发票查询列表] 升级至V11.1权限[AP060101  采购发票查询列表]
	insert into #t6auth (t6authid,u8authid) values(N'AP06010102',N'AP0601012')-- T6权限 [AP06010102  发票查询列表打印] 升级至V11.1权限[AP0601012  采购发票查询列表打印]
	insert into #t6auth (t6authid,u8authid) values(N'AP06010103',N'AP0601013')-- T6权限 [AP06010103  发票查询列表输出] 升级至V11.1权限[AP0601013  采购发票查询列表输出]
	insert into #t6auth (t6authid,u8authid) values(N'AR060204',N'AR060204_01')-- T6权限 [AR060204  业务余额表] 升级至V11.1权限[AR060204_01  查询应收余额表]
	insert into #t6auth (t6authid,u8authid) values(N'AR06020401',N'AR060204')-- T6权限 [AR06020401  业务余额表查询] 升级至V11.1权限[AR060204  应收余额表]
	insert into #t6auth (t6authid,u8authid) values(N'AR06020402',N'AR060204_03')-- T6权限 [AR06020402  业务余额表打印] 升级至V11.1权限[AR060204_03  打印应收余额表]
	insert into #t6auth (t6authid,u8authid) values(N'AR06020403',N'AR060204_04')-- T6权限 [AR06020403  业务余额表输出] 升级至V11.1权限[AR060204_04  输出应收余额表]
	insert into #t6auth (t6authid,u8authid) values(N'AR060205',N'AR060205')-- T6权限 [AR060205  与总账对账] 升级至V11.1权限[AR060205  与总账对账]
	insert into #t6auth (t6authid,u8authid) values(N'AR060301',N'AR060301')-- T6权限 [AR060301  应收账龄分析] 升级至V11.1权限[AR060301  应收账龄分析]
	insert into #t6auth (t6authid,u8authid) values(N'AR060302',N'AR060302')-- T6权限 [AR060302  收款账龄分析] 升级至V11.1权限[AR060302  收账龄分析]
	insert into #t6auth (t6authid,u8authid) values(N'AR060303',N'AR060303')-- T6权限 [AR060303  欠款分析] 升级至V11.1权限[AR060303  欠款分析]
	insert into #t6auth (t6authid,u8authid) values(N'AR060305',N'AR060305')-- T6权限 [AR060305  收款预测] 升级至V11.1权限[AR060305  收款预测]
	insert into #t6auth (t6authid,u8authid) values(N'AR060401',N'AR060401')-- T6权限 [AR060401  科目明细账] 升级至V11.1权限[AR060401  科目明细账]
	insert into #t6auth (t6authid,u8authid) values(N'AR060402',N'AR060402')-- T6权限 [AR060402  科目余额表] 升级至V11.1权限[AR060402  科目余额表]
	insert into #t6auth (t6authid,u8authid) values(N'AR0605',N'AR0601')-- T6权限 [AR0605  我的账表] 升级至V11.1权限[AR0601  我的账表]
	insert into #t6auth (t6authid,u8authid) values(N'AR210',N'AR0503')-- T6权限 [AR210  选择收款] 升级至V11.1权限[AR0503  选择收款]
	insert into #t6auth (t6authid,u8authid) values(N'AR21102',N'AR21102')-- T6权限 [AR21102  应收单审核列表查询] 升级至V11.1权限[AR21102  应收单审核列表查询]
	insert into #t6auth (t6authid,u8authid) values(N'AR2110201',N'AR211301')-- T6权限 [AR2110201  应收单审核列表] 升级至V11.1权限[AR211301  应收单审核]
	insert into #t6auth (t6authid,u8authid) values(N'AR2110202',N'AR2113011')-- T6权限 [AR2110202  应收单审核列表打印] 升级至V11.1权限[AR2113011  应收单审核列表打印]
	insert into #t6auth (t6authid,u8authid) values(N'AR2110203',N'AR2113012')-- T6权限 [AR2110203  应收单审核列表输出] 升级至V11.1权限[AR2113012  应收单审核列表输出]
	insert into #t6auth (t6authid,u8authid) values(N'AR22102',N'AR22102')-- T6权限 [AR22102  收款单审核列表查询] 升级至V11.1权限[AR22102  收款单审核列表查询]
	insert into #t6auth (t6authid,u8authid) values(N'AR2210201',N'AR222')-- T6权限 [AR2210201  收款单审核列表] 升级至V11.1权限[AR222  收款单审核]
	insert into #t6auth (t6authid,u8authid) values(N'AR2210202',N'AR221041')-- T6权限 [AR2210202  收款单审核列表打印] 升级至V11.1权限[AR221041  收款单审核列表打印]
	insert into #t6auth (t6authid,u8authid) values(N'AR2210203',N'AR221042')-- T6权限 [AR2210203  收款单审核列表输出] 升级至V11.1权限[AR221042  收款单审核列表输出]
	insert into #t6auth (t6authid,u8authid) values(N'GL9901',N'GL001')-- T6权限 [GL9901  我的账表] 升级至V11.1权限[GL001  ]
	insert into #t6auth (t6authid,u8authid) values(N'IA001403',N'IA10012')-- T6权限 [IA001403  入库调整单输出] 升级至V11.1权限[IA10012  入库调整单输出]
	insert into #t6auth (t6authid,u8authid) values(N'IA001404',N'IA10011')-- T6权限 [IA001404  入库调整单打印] 升级至V11.1权限[IA10011  入库调整单打印、预览]
	insert into #t6auth (t6authid,u8authid) values(N'IA001406',N'IA1002')-- T6权限 [IA001406  入库调整单删除] 升级至V11.1权限[IA1002  入库调整单删除]
	insert into #t6auth (t6authid,u8authid) values(N'IA001407',N'IA02040202')-- T6权限 [IA001407  入库调整单列表打印] 升级至V11.1权限[IA02040202  入库调整单列表打印、预览]
	insert into #t6auth (t6authid,u8authid) values(N'IA001408',N'IA02040203')-- T6权限 [IA001408  入库调整单列表输出] 升级至V11.1权限[IA02040203  入库调整单列表输出]
	insert into #t6auth (t6authid,u8authid) values(N'IA001603',N'IA10062')-- T6权限 [IA001603  出库调整单输出] 升级至V11.1权限[IA10062  出库调整单输出]
	insert into #t6auth (t6authid,u8authid) values(N'IA001604',N'IA10061')-- T6权限 [IA001604  出库调整单打印] 升级至V11.1权限[IA10061  出库调整单打印、预览]
	insert into #t6auth (t6authid,u8authid) values(N'IA001606',N'IA1005')-- T6权限 [IA001606  出库调整单删除] 升级至V11.1权限[IA1005  出库调整单删除]
	insert into #t6auth (t6authid,u8authid) values(N'IA001607',N'IA02040302')-- T6权限 [IA001607  出库调整单列表打印] 升级至V11.1权限[IA02040302  出库调整单列表打印、预览]
	insert into #t6auth (t6authid,u8authid) values(N'IA001608',N'IA02040303')-- T6权限 [IA001608  出库调整单列表输出] 升级至V11.1权限[IA02040303  出库调整单列表输出]
	insert into #t6auth (t6authid,u8authid) values(N'IA001803',N'IA10072')-- T6权限 [IA001803  价格调整单输出] 升级至V11.1权限[IA10072  价格调整单输出]
	insert into #t6auth (t6authid,u8authid) values(N'IA001804',N'IA10071')-- T6权限 [IA001804  价格调整单打印] 升级至V11.1权限[IA10071  价格调整单打印、预览]
	insert into #t6auth (t6authid,u8authid) values(N'IA001805',N'IA02040602')-- T6权限 [IA001805  价格调整单列表打印] 升级至V11.1权限[IA02040602  价格调整单列表打印、预览]
	insert into #t6auth (t6authid,u8authid) values(N'IA001806',N'IA02040603')-- T6权限 [IA001806  价格调整单列表输出] 升级至V11.1权限[IA02040603  价格调整单列表输出]
	insert into #t6auth (t6authid,u8authid) values(N'IA0030',N'IA0030')-- T6权限 [IA0030  红字回冲单列表] 升级至V11.1权限[IA0030  红字回冲单列表]
	insert into #t6auth (t6authid,u8authid) values(N'IA003001',N'IA003002')-- T6权限 [IA003001  红字回冲单列表打印] 升级至V11.1权限[IA003002  红字回冲单列表打印、预览]
	insert into #t6auth (t6authid,u8authid) values(N'IA003002',N'IA003003')-- T6权限 [IA003002  红字回冲单列表输出] 升级至V11.1权限[IA003003  红字回冲单列表输出]
	insert into #t6auth (t6authid,u8authid) values(N'IA003003',N'IA003001')-- T6权限 [IA003003  红字回冲单列表查询] 升级至V11.1权限[IA003001  红字回冲单列表]
	insert into #t6auth (t6authid,u8authid) values(N'IA0031',N'IA0031')-- T6权限 [IA0031  蓝字回冲单列表] 升级至V11.1权限[IA0031  蓝字回冲单列表]
	insert into #t6auth (t6authid,u8authid) values(N'IA003101',N'IA003102')-- T6权限 [IA003101  蓝字回冲单列表打印] 升级至V11.1权限[IA003102  蓝字回冲单列表打印、预览]
	insert into #t6auth (t6authid,u8authid) values(N'IA003102',N'IA003103')-- T6权限 [IA003102  蓝字回冲单列表输出] 升级至V11.1权限[IA003103  蓝字回冲单列表输出]
	insert into #t6auth (t6authid,u8authid) values(N'IA003103',N'IA003101')-- T6权限 [IA003103  蓝字回冲单列表查询] 升级至V11.1权限[IA003101  蓝字回冲单列表]
	insert into #t6auth (t6authid,u8authid) values(N'IA020106',N'IA020102')-- T6权限 [IA020106  假退料单删除] 升级至V11.1权限[IA020102  假退料单录入]
	insert into #t6auth (t6authid,u8authid) values(N'IA020107',N'IA02040102')-- T6权限 [IA020107  假退料单列表打印] 升级至V11.1权限[IA02040102  假退料单列表打印、预览]
	insert into #t6auth (t6authid,u8authid) values(N'IA020108',N'IA02040103')-- T6权限 [IA020108  假退料单列表输出] 升级至V11.1权限[IA02040103  假退料单列表输出]
	insert into #t6auth (t6authid,u8authid) values(N'IA0399',N'IA0399')-- T6权限 [IA0399  清除凭证互斥] 升级至V11.1权限[IA0399  清除凭证互斥]
	insert into #t6auth (t6authid,u8authid) values(N'IA040205',N'IA040206')-- T6权限 [IA040205  跌价准备期初输出] 升级至V11.1权限[IA040206  跌价准备期初输出]
	insert into #t6auth (t6authid,u8authid) values(N'IA040206',N'IA040207')-- T6权限 [IA040206  跌价准备期初打印] 升级至V11.1权限[IA040207  跌价准备期初打印、预览]
	insert into #t6auth (t6authid,u8authid) values(N'IA040208',N'IA040205')-- T6权限 [IA040208  跌价准备期初删除] 升级至V11.1权限[IA040205  跌价准备期初删除]
	insert into #t6auth (t6authid,u8authid) values(N'IA040305',N'IA040306')-- T6权限 [IA040305  计提跌价准备输出] 升级至V11.1权限[IA040306  计提跌价准备输出]
	insert into #t6auth (t6authid,u8authid) values(N'IA040306',N'IA040307')-- T6权限 [IA040306  计提跌价准备打印] 升级至V11.1权限[IA040307  计提跌价准备打印、预览]
	insert into #t6auth (t6authid,u8authid) values(N'IA040308',N'IA040305')-- T6权限 [IA040308  计提跌价准备删除] 升级至V11.1权限[IA040305  跌价准备单删除]
	insert into #t6auth (t6authid,u8authid) values(N'IA05010501',N'IA050105_03')-- T6权限 [IA05010501  发出商品明细账打印] 升级至V11.1权限[IA050105_03  打印发出商品明细账]
	insert into #t6auth (t6authid,u8authid) values(N'IA05010502',N'IA050105_04')-- T6权限 [IA05010502  发出商品明细账输出] 升级至V11.1权限[IA050105_04  输出发出商品明细账]
	insert into #t6auth (t6authid,u8authid) values(N'IA05010503',N'IA050105_01')-- T6权限 [IA05010503  发出商品明细账查询] 升级至V11.1权限[IA050105_01  查询发出商品明细账]
	insert into #t6auth (t6authid,u8authid) values(N'IA05010601',N'IA050106_03')-- T6权限 [IA05010601  个别计价明细账打印] 升级至V11.1权限[IA050106_03  打印个别计价明细账]
	insert into #t6auth (t6authid,u8authid) values(N'IA05010602',N'IA050106_04')-- T6权限 [IA05010602  个别计价明细账输出] 升级至V11.1权限[IA050106_04  输出个别计价明细账]
	insert into #t6auth (t6authid,u8authid) values(N'IA05010603',N'IA050106_01')-- T6权限 [IA05010603  个别计价明细账查询] 升级至V11.1权限[IA050106_01  查询个别计价明细账]
	insert into #t6auth (t6authid,u8authid) values(N'IA0504',N'IA0505')-- T6权限 [IA0504  我的账表] 升级至V11.1权限[IA0505  我的账表]
	insert into #t6auth (t6authid,u8authid) values(N'IA300201',N'IA3002_03')-- T6权限 [IA300201  明细账打印] 升级至V11.1权限[IA3002_03  打印明细账]
	insert into #t6auth (t6authid,u8authid) values(N'IA300202',N'IA3002_04')-- T6权限 [IA300202  明细账输出] 升级至V11.1权限[IA3002_04  输出明细账]
	insert into #t6auth (t6authid,u8authid) values(N'IA300203',N'IA3002_01')-- T6权限 [IA300203  明细账查询] 升级至V11.1权限[IA3002_01  查询明细账]
	insert into #t6auth (t6authid,u8authid) values(N'IA300301',N'IA3003_03')-- T6权限 [IA300301  总账打印] 升级至V11.1权限[IA3003_03  打印总账]
	insert into #t6auth (t6authid,u8authid) values(N'IA300302',N'IA3003_04')-- T6权限 [IA300302  总账输出] 升级至V11.1权限[IA3003_04  输出总账]
	insert into #t6auth (t6authid,u8authid) values(N'IA300303',N'IA3003_01')-- T6权限 [IA300303  总账查询] 升级至V11.1权限[IA3003_01  查询总账]
	insert into #t6auth (t6authid,u8authid) values(N'IA300401',N'IA3004_03')-- T6权限 [IA300401  流水账打印] 升级至V11.1权限[IA3004_03  打印流水账]
	insert into #t6auth (t6authid,u8authid) values(N'IA300402',N'IA3004_04')-- T6权限 [IA300402  流水账输出] 升级至V11.1权限[IA3004_04  输出流水账]
	insert into #t6auth (t6authid,u8authid) values(N'IA300403',N'IA3004_01')-- T6权限 [IA300403  流水账查询] 升级至V11.1权限[IA3004_01  查询流水账]
	insert into #t6auth (t6authid,u8authid) values(N'IA300501',N'IA3005_03')-- T6权限 [IA300501  计价辅助数据打印] 升级至V11.1权限[IA3005_03  打印计价辅助数据]
	insert into #t6auth (t6authid,u8authid) values(N'IA300502',N'IA3005_04')-- T6权限 [IA300502  计价辅助数据输出] 升级至V11.1权限[IA3005_04  输出计价辅助数据]
	insert into #t6auth (t6authid,u8authid) values(N'IA300503',N'IA3005_01')-- T6权限 [IA300503  计价辅助数据查询] 升级至V11.1权限[IA3005_01  查询计价辅助数据]
	insert into #t6auth (t6authid,u8authid) values(N'IA300601',N'IA3006_03')-- T6权限 [IA300601  入库汇总表打印] 升级至V11.1权限[IA3006_03  打印入库汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'IA300602',N'IA3006_04')-- T6权限 [IA300602  入库汇总表输出] 升级至V11.1权限[IA3006_04  输出入库汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'IA300603',N'IA3006_01')-- T6权限 [IA300603  入库汇总表查询] 升级至V11.1权限[IA3006_01  查询入库汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'IA300801',N'IA3008_03')-- T6权限 [IA300801  出库汇总表打印] 升级至V11.1权限[IA3008_03  打印出库汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'IA300802',N'IA3008_04')-- T6权限 [IA300802  出库汇总表输出] 升级至V11.1权限[IA3008_04  输出出库汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'IA300803',N'IA3008_01')-- T6权限 [IA300803  出库汇总表查询] 升级至V11.1权限[IA3008_01  查询出库汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'IA301001',N'IA3010_03')-- T6权限 [IA301001  差异分摊表打印] 升级至V11.1权限[IA3010_03  打印差异分摊表]
	insert into #t6auth (t6authid,u8authid) values(N'IA301002',N'IA3010_04')-- T6权限 [IA301002  差异分摊表输出] 升级至V11.1权限[IA3010_04  输出差异分摊表]
	insert into #t6auth (t6authid,u8authid) values(N'IA301003',N'IA3010_01')-- T6权限 [IA301003  差异分摊表查询] 升级至V11.1权限[IA3010_01  查询差异分摊表]
	insert into #t6auth (t6authid,u8authid) values(N'IA301101',N'IA3011_03')-- T6权限 [IA301101  收发存汇总表打印] 升级至V11.1权限[IA3011_03  打印收发存汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'IA301102',N'IA3011_04')-- T6权限 [IA301102  收发存汇总表输出] 升级至V11.1权限[IA3011_04  输出收发存汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'IA301103',N'IA3011_01')-- T6权限 [IA301103  收发存汇总表查询] 升级至V11.1权限[IA3011_01  查询收发存汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'IA301201',N'IA3012_03')-- T6权限 [IA301201  存货周转率分析打印] 升级至V11.1权限[IA3012_03  打印存货周转率分析]
	insert into #t6auth (t6authid,u8authid) values(N'IA301203',N'IA3012_01')-- T6权限 [IA301203  存货周转率分析查询] 升级至V11.1权限[IA3012_01  查询存货周转率分析]
	insert into #t6auth (t6authid,u8authid) values(N'IA301301',N'IA3013_03')-- T6权限 [IA301301  ABC成本分析打印] 升级至V11.1权限[IA3013_03  打印:ABC成本分析]
	insert into #t6auth (t6authid,u8authid) values(N'IA301302',N'IA3013_04')-- T6权限 [IA301302  ABC成本分析输出] 升级至V11.1权限[IA3013_04  输出:ABC成本分析]
	insert into #t6auth (t6authid,u8authid) values(N'IA301303',N'IA3013_01')-- T6权限 [IA301303  ABC成本分析查询] 升级至V11.1权限[IA3013_01  查询:ABC成本分析]
	insert into #t6auth (t6authid,u8authid) values(N'IA301401',N'IA3014_03')-- T6权限 [IA301401  库存资金占用规划打印] 升级至V11.1权限[IA3014_03  打印库存资金占用规划]
	insert into #t6auth (t6authid,u8authid) values(N'IA301402',N'IA3014_04')-- T6权限 [IA301402  库存资金占用规划输出] 升级至V11.1权限[IA3014_04  输出库存资金占用规划]
	insert into #t6auth (t6authid,u8authid) values(N'IA301403',N'IA3014_01')-- T6权限 [IA301403  库存资金占用规划查询] 升级至V11.1权限[IA3014_01  查询库存资金占用规划]
	insert into #t6auth (t6authid,u8authid) values(N'IA301501',N'IA3015_03')-- T6权限 [IA301501  库存资金占用分析打印] 升级至V11.1权限[IA3015_03  打印库存资金占用分析]
	insert into #t6auth (t6authid,u8authid) values(N'IA301502',N'IA3015_04')-- T6权限 [IA301502  库存资金占用分析输出] 升级至V11.1权限[IA3015_04  输出库存资金占用分析]
	insert into #t6auth (t6authid,u8authid) values(N'IA301503',N'IA3015_01')-- T6权限 [IA301503  库存资金占用分析查询] 升级至V11.1权限[IA3015_01  查询库存资金占用分析]
	insert into #t6auth (t6authid,u8authid) values(N'IA301601',N'IA3016_03')-- T6权限 [IA301601  入库成本分析打印] 升级至V11.1权限[IA3016_03  打印入库成本分析]
	insert into #t6auth (t6authid,u8authid) values(N'IA301602',N'IA3016_04')-- T6权限 [IA301602  入库成本分析输出] 升级至V11.1权限[IA3016_04  输出入库成本分析]
	insert into #t6auth (t6authid,u8authid) values(N'IA301603',N'IA3016_01')-- T6权限 [IA301603  入库成本分析查询] 升级至V11.1权限[IA3016_01  查询入库成本分析]
	insert into #t6auth (t6authid,u8authid) values(N'IA301701',N'IA3017_03')-- T6权限 [IA301701  暂估材料/商品余额表打印] 升级至V11.1权限[IA3017_03  打印暂估材料/商品余额表]
	insert into #t6auth (t6authid,u8authid) values(N'IA301702',N'IA3017_04')-- T6权限 [IA301702  暂估材料/商品余额表输出] 升级至V11.1权限[IA3017_04  输出暂估材料/商品余额表]
	insert into #t6auth (t6authid,u8authid) values(N'IA301703',N'IA3017_01')-- T6权限 [IA301703  暂估材料/商品余额表查询] 升级至V11.1权限[IA3017_01  查询暂估材料/商品余额表]
	insert into #t6auth (t6authid,u8authid) values(N'IA0405',N'IA0405_01')-- T6权限 [IA0405  跌价准备余额表] 升级至V11.1权限[IA0405_01  查询跌价准备余额表]
	insert into #t6auth (t6authid,u8authid) values(N'IA0405',N'IA0405_02')-- T6权限 [IA0405  跌价准备余额表] 升级至V11.1权限[IA0405_02  设置跌价准备余额表]
	insert into #t6auth (t6authid,u8authid) values(N'IA0405',N'IA0405_03')-- T6权限 [IA0405  跌价准备余额表] 升级至V11.1权限[IA0405_03  打印跌价准备余额表]
	insert into #t6auth (t6authid,u8authid) values(N'IA0405',N'IA0405_04')-- T6权限 [IA0405  跌价准备余额表] 升级至V11.1权限[IA0405_04  输出跌价准备余额表]
	insert into #t6auth (t6authid,u8authid) values(N'NB0209',N'NB02002')-- T6权限 [NB0209  支付状态确认] 升级至V11.1权限[NB02002  支付状态确认]
	insert into #t6auth (t6authid,u8authid) values(N'NB0209',N'NB02001')-- T6权限 [NB0209  支付状态确认] 升级至V11.1权限[NB02001  支付状态确认]
	insert into #t6auth (t6authid,u8authid) values(N'NB0209',N'NB02')-- T6权限 [NB0209  支付状态确认] 升级至V11.1权限[NB02  支付状态确认]
--供应链
	insert into #t6auth (t6authid,u8authid) values(N'PU0305',N'PU0305')-- T6权限 [PU0305  采购订单弃审] 升级至V11.1权限[PU0305  采购订单弃审]
	insert into #t6auth (t6authid,u8authid) values(N'PU030502',N'PU030502_01')-- T6权限 [PU030502  采购订单执行统计表查询] 升级至V11.1权限[PU030502_01  查询:采购订单执行统计表]
	insert into #t6auth (t6authid,u8authid) values(N'PU03050201',N'PU030502')-- T6权限 [PU03050201  采购订单执行统计表] 升级至V11.1权限[PU030502  采购订单执行统计表]
	insert into #t6auth (t6authid,u8authid) values(N'PU03050202',N'PU030502_03')-- T6权限 [PU03050202  采购订单执行统计表打印] 升级至V11.1权限[PU030502_03  打印:采购订单执行统计表]
	insert into #t6auth (t6authid,u8authid) values(N'PU03050203',N'PU030502_04')-- T6权限 [PU03050203  采购订单执行统计表输出] 升级至V11.1权限[PU030502_04  输出:采购订单执行统计表]
	insert into #t6auth (t6authid,u8authid) values(N'PU030503',N'PU030503_01')-- T6权限 [PU030503  采购订单预警和报警表查询] 升级至V11.1权限[PU030503_01  查询:采购订单预警和报警表]
	insert into #t6auth (t6authid,u8authid) values(N'PU03050301',N'PU030503')-- T6权限 [PU03050301  采购订单预警和报警表] 升级至V11.1权限[PU030503  采购订单预警和报警表]
	insert into #t6auth (t6authid,u8authid) values(N'PU03050302',N'PU030503_03')-- T6权限 [PU03050302  采购订单预警和报警表打印] 升级至V11.1权限[PU030503_03  打印:采购订单预警和报警表]
	insert into #t6auth (t6authid,u8authid) values(N'PU03050303',N'PU030503_04')-- T6权限 [PU03050303  采购订单预警和报警表输出] 升级至V11.1权限[PU030503_04  输出:采购订单预警和报警表]
	insert into #t6auth (t6authid,u8authid) values(N'PU030505',N'PU030505_01')-- T6权限 [PU030505  供应商催货函查询] 升级至V11.1权限[PU030505_01  查询供应商催货函]
	insert into #t6auth (t6authid,u8authid) values(N'PU03050501',N'PU030505')-- T6权限 [PU03050501  供应商催货函] 升级至V11.1权限[PU030505  供应商催货函]
	insert into #t6auth (t6authid,u8authid) values(N'PU03050502',N'PU030505_03')-- T6权限 [PU03050502  供应商催货函打印] 升级至V11.1权限[PU030505_03  打印供应商催货函]
	insert into #t6auth (t6authid,u8authid) values(N'PU03050503',N'PU030505_04')-- T6权限 [PU03050503  供应商催货函输出] 升级至V11.1权限[PU030505_04  输出供应商催货函]
	insert into #t6auth (t6authid,u8authid) values(N'PU0309',N'PU0309')-- T6权限 [PU0309  采购订单列表查询] 升级至V11.1权限[PU0309  采购订单列表查询]
	insert into #t6auth (t6authid,u8authid) values(N'PU030901',N'PU030901')-- T6权限 [PU030901  采购订单列表] 升级至V11.1权限[PU030901  采购订单列表]
	insert into #t6auth (t6authid,u8authid) values(N'PU030902',N'PU030902')-- T6权限 [PU030902  采购订单列表打印] 升级至V11.1权限[PU030902  采购订单列表打印]
	insert into #t6auth (t6authid,u8authid) values(N'PU030903',N'PU030903')-- T6权限 [PU030903  采购订单列表输出] 升级至V11.1权限[PU030903  采购订单列表输出]
	insert into #t6auth (t6authid,u8authid) values(N'PU0312',N'PU0319')-- T6权限 [PU0312  采购订单打印] 升级至V11.1权限[PU0319  采购订单打印]
	insert into #t6auth (t6authid,u8authid) values(N'PU0314',N'PU0320')-- T6权限 [PU0314  采购订单输出] 升级至V11.1权限[PU0320  采购订单输出]
	insert into #t6auth (t6authid,u8authid) values(N'PU0315',N'PU0318')-- T6权限 [PU0315  采购订单删除] 升级至V11.1权限[PU0318  采购订单删除]
	insert into #t6auth (t6authid,u8authid) values(N'PU040305',N'PU040305')-- T6权限 [PU040305  结算单列表查询] 升级至V11.1权限[PU040305  结算单列表查询]
	insert into #t6auth (t6authid,u8authid) values(N'PU04030501',N'PU04030501')-- T6权限 [PU04030501  结算单列表] 升级至V11.1权限[PU04030501  结算单列表]
	insert into #t6auth (t6authid,u8authid) values(N'PU04030502',N'PU04030502')-- T6权限 [PU04030502  结算单列表打印] 升级至V11.1权限[PU04030502  结算单列表打印]
	insert into #t6auth (t6authid,u8authid) values(N'PU04030503',N'PU04030503')-- T6权限 [PU04030503  结算单列表输出] 升级至V11.1权限[PU04030503  结算单列表输出]
	insert into #t6auth (t6authid,u8authid) values(N'PU0405',N'PU0405_01')-- T6权限 [PU0405  采购现存量查询] 升级至V11.1权限[PU0405_01  查询现存量查询]
	insert into #t6auth (t6authid,u8authid) values(N'PU040501',N'PU0405')-- T6权限 [PU040501  采购现存量] 升级至V11.1权限[PU0405  现存量查询]
	insert into #t6auth (t6authid,u8authid) values(N'PU040502',N'PU0405_03')-- T6权限 [PU040502  采购现存量查询打印] 升级至V11.1权限[PU0405_03  打印现存量查询]
	insert into #t6auth (t6authid,u8authid) values(N'PU040503',N'PU0405_04')-- T6权限 [PU040503  采购现存量查询输出] 升级至V11.1权限[PU0405_04  输出现存量查询]
	insert into #t6auth (t6authid,u8authid) values(N'PU04100106',N'PU041005')-- T6权限 [PU04100106  计划批量生请购单] 升级至V11.1权限[PU041005  MRP计划批量生成请购单]
	insert into #t6auth (t6authid,u8authid) values(N'PU04100112',N'PU04100113')-- T6权限 [PU04100112  请购单弃审] 升级至V11.1权限[PU04100113  请购单弃审]
	insert into #t6auth (t6authid,u8authid) values(N'PU04100113',N'PU04100112')-- T6权限 [PU04100113  请购单变更] 升级至V11.1权限[PU04100112  请购单变更]
	insert into #t6auth (t6authid,u8authid) values(N'PU04100114',N'PU04100114')-- T6权限 [PU04100114  请购单打印] 升级至V11.1权限[PU04100114  请购单打印]
	insert into #t6auth (t6authid,u8authid) values(N'PU04100116',N'PU04100115')-- T6权限 [PU04100116  请购单输出] 升级至V11.1权限[PU04100115  请购单输出]
	insert into #t6auth (t6authid,u8authid) values(N'PU04100117',N'PU04100111')-- T6权限 [PU04100117  请购单删除] 升级至V11.1权限[PU04100111  请购单删除]
	insert into #t6auth (t6authid,u8authid) values(N'PU041002',N'PU041002')-- T6权限 [PU041002  采购请购单列表查询] 升级至V11.1权限[PU041002  请购单列表查询]
	insert into #t6auth (t6authid,u8authid) values(N'PU04100201',N'PU04100201')-- T6权限 [PU04100201  采购请购单列表] 升级至V11.1权限[PU04100201  请购单列表]
	insert into #t6auth (t6authid,u8authid) values(N'PU04100202',N'PU04100202')-- T6权限 [PU04100202  采购请购单列表打印] 升级至V11.1权限[PU04100202  请购单列表打印]
	insert into #t6auth (t6authid,u8authid) values(N'PU04100203',N'PU04100203')-- T6权限 [PU04100203  采购请购单列表输出] 升级至V11.1权限[PU04100203  请购单列表输出]
	insert into #t6auth (t6authid,u8authid) values(N'PU041003',N'PU041003_01')-- T6权限 [PU041003  请购单执行统计表查询] 升级至V11.1权限[PU041003_01  查询:请购单执行统计表]
	insert into #t6auth (t6authid,u8authid) values(N'PU04100301',N'PU041003')-- T6权限 [PU04100301  请购单执行统计表] 升级至V11.1权限[PU041003  请购单执行统计表]
	insert into #t6auth (t6authid,u8authid) values(N'PU04100302',N'PU041003_03')-- T6权限 [PU04100302  请购单执行统计表打印] 升级至V11.1权限[PU041003_03  打印:请购单执行统计表]
	insert into #t6auth (t6authid,u8authid) values(N'PU04100303',N'PU041003_04')-- T6权限 [PU04100303  请购单执行统计表输出] 升级至V11.1权限[PU041003_04  输出:请购单执行统计表]
	insert into #t6auth (t6authid,u8authid) values(N'PU04200108',N'PU04200114')-- T6权限 [PU04200108  到货单打印] 升级至V11.1权限[PU04200114  到货单打印]
	insert into #t6auth (t6authid,u8authid) values(N'PU04200110',N'PU04200115')-- T6权限 [PU04200110  到货单输出] 升级至V11.1权限[PU04200115  到货单输出]
	insert into #t6auth (t6authid,u8authid) values(N'PU04200111',N'PU04200111')-- T6权限 [PU04200111  到货单删除] 升级至V11.1权限[PU04200111  到货单删除]
	insert into #t6auth (t6authid,u8authid) values(N'PU04200203',N'PU04200213')-- T6权限 [PU04200203  到货退回单打印] 升级至V11.1权限[PU04200213  采购退货单打印]
	insert into #t6auth (t6authid,u8authid) values(N'PU04200205',N'PU04200214')-- T6权限 [PU04200205  到货退回单输出] 升级至V11.1权限[PU04200214  采购退货单输出]
	insert into #t6auth (t6authid,u8authid) values(N'PU04200206',N'PU04200211')-- T6权限 [PU04200206  到货退回单删除] 升级至V11.1权限[PU04200211  退货单删除]
	insert into #t6auth (t6authid,u8authid) values(N'PU042003',N'PU042003')-- T6权限 [PU042003  到货单列表查询] 升级至V11.1权限[PU042003  到货单列表查询]
	insert into #t6auth (t6authid,u8authid) values(N'PU04200301',N'PU04200301')-- T6权限 [PU04200301  到货单列表] 升级至V11.1权限[PU04200301  到货单列表]
	insert into #t6auth (t6authid,u8authid) values(N'PU04200302',N'PU04200302')-- T6权限 [PU04200302  到货单列表打印] 升级至V11.1权限[PU04200302  到货单列表打印]
	insert into #t6auth (t6authid,u8authid) values(N'PU04200303',N'PU04200303')-- T6权限 [PU04200303  到货单列表输出] 升级至V11.1权限[PU04200303  到货单列表输出]
	insert into #t6auth (t6authid,u8authid) values(N'PU04300108',N'PU04300104')-- T6权限 [PU04300108  采购专用发票打印] 升级至V11.1权限[PU04300104  采购专用发票打印]
	insert into #t6auth (t6authid,u8authid) values(N'PU04300110',N'PU04300105')-- T6权限 [PU04300110  采购专用发票输出] 升级至V11.1权限[PU04300105  采购专用发票输出]
	insert into #t6auth (t6authid,u8authid) values(N'PU04300111',N'PU04300103')-- T6权限 [PU04300111  采购专用发票删除] 升级至V11.1权限[PU04300103  采购专用发票删除]
	insert into #t6auth (t6authid,u8authid) values(N'PU04300208',N'PU04300204')-- T6权限 [PU04300208  普通采购发票打印] 升级至V11.1权限[PU04300204  采购普通发票打印]
	insert into #t6auth (t6authid,u8authid) values(N'PU04300210',N'PU04300205')-- T6权限 [PU04300210  普通采购发票输出] 升级至V11.1权限[PU04300205  采购普通发票输出]
	insert into #t6auth (t6authid,u8authid) values(N'PU04300211',N'PU04300203')-- T6权限 [PU04300211  普通采购发票删除] 升级至V11.1权限[PU04300203  采购普通发票删除]
	insert into #t6auth (t6authid,u8authid) values(N'PU04300308',N'PU04300304')-- T6权限 [PU04300308  运费发票打印] 升级至V11.1权限[PU04300304  运费发票打印]
	insert into #t6auth (t6authid,u8authid) values(N'PU04300310',N'PU04300305')-- T6权限 [PU04300310  运费发票输出] 升级至V11.1权限[PU04300305  运费发票输出]
	insert into #t6auth (t6authid,u8authid) values(N'PU04300311',N'PU04300303')-- T6权限 [PU04300311  运费发票删除] 升级至V11.1权限[PU04300303  运费发票删除]
	insert into #t6auth (t6authid,u8authid) values(N'PU04300408',N'PU04300404')-- T6权限 [PU04300408  红字采购专用发票打印] 升级至V11.1权限[PU04300404  红字采购专用发票打印]
	insert into #t6auth (t6authid,u8authid) values(N'PU04300410',N'PU04300405')-- T6权限 [PU04300410  红字采购专用发票输出] 升级至V11.1权限[PU04300405  红字采购专用发票输出]
	insert into #t6auth (t6authid,u8authid) values(N'PU04300411',N'PU04300403')-- T6权限 [PU04300411  红字采购专用发票删除] 升级至V11.1权限[PU04300403  红字采购专用发票删除]
	insert into #t6auth (t6authid,u8authid) values(N'PU04300508',N'PU04300504')-- T6权限 [PU04300508  红字采购普通发票打印] 升级至V11.1权限[PU04300504  红字采购普通发票打印]
	insert into #t6auth (t6authid,u8authid) values(N'PU04300510',N'PU04300505')-- T6权限 [PU04300510  红字采购普通发票输出] 升级至V11.1权限[PU04300505  红字采购普通发票输出]
	insert into #t6auth (t6authid,u8authid) values(N'PU04300511',N'PU04300503')-- T6权限 [PU04300511  红字采购普通发票删除] 升级至V11.1权限[PU04300503  红字普通专用发票删除]
	insert into #t6auth (t6authid,u8authid) values(N'PU04300608',N'PU04300604')-- T6权限 [PU04300608  红字运费发票打印] 升级至V11.1权限[PU04300604  红字运费发票打印]
	insert into #t6auth (t6authid,u8authid) values(N'PU04300610',N'PU04300605')-- T6权限 [PU04300610  红字运费发票输出] 升级至V11.1权限[PU04300605  红字运费发票输出]
	insert into #t6auth (t6authid,u8authid) values(N'PU04300611',N'PU04300603')-- T6权限 [PU04300611  红字运费发票删除] 升级至V11.1权限[PU04300603  红字运费发票删除]
	insert into #t6auth (t6authid,u8authid) values(N'PU043010',N'PU043010')-- T6权限 [PU043010  采购发票列表查询] 升级至V11.1权限[PU043010  采购发票列表查询]
	insert into #t6auth (t6authid,u8authid) values(N'PU04301001',N'PU04301001')-- T6权限 [PU04301001  采购发票列表] 升级至V11.1权限[PU04301001  采购发票列表]
	insert into #t6auth (t6authid,u8authid) values(N'PU04301002',N'PU04301002')-- T6权限 [PU04301002  采购发票列表打印] 升级至V11.1权限[PU04301002  采购发票列表打印]
	insert into #t6auth (t6authid,u8authid) values(N'PU04301003',N'PU04301003')-- T6权限 [PU04301003  采购发票列表输出] 升级至V11.1权限[PU04301003  采购发票列表输出]
	insert into #t6auth (t6authid,u8authid) values(N'PU0501',N'PU0501')-- T6权限 [PU0501  我的账表] 升级至V11.1权限[PU0501  我的报表]
	insert into #t6auth (t6authid,u8authid) values(N'PU050301',N'PU050301_01')-- T6权限 [PU050301  采购明细表查询] 升级至V11.1权限[PU050301_01  查询采购明细表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05030101',N'PU050301')-- T6权限 [PU05030101  采购明细表] 升级至V11.1权限[PU050301  采购明细表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05030102',N'PU050301_03')-- T6权限 [PU05030102  采购明细表打印] 升级至V11.1权限[PU050301_03  打印采购明细表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05030103',N'PU050301_04')-- T6权限 [PU05030103  采购明细表输出] 升级至V11.1权限[PU050301_04  输出采购明细表]
	insert into #t6auth (t6authid,u8authid) values(N'PU050302',N'PU050302_01')-- T6权限 [PU050302  入库明细表查询] 升级至V11.1权限[PU050302_01  查询入库明细表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05030201',N'PU050302')-- T6权限 [PU05030201  入库明细表] 升级至V11.1权限[PU050302  入库明细表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05030202',N'PU050302_03')-- T6权限 [PU05030202  入库明细表打印] 升级至V11.1权限[PU050302_03  打印入库明细表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05030203',N'PU050302_04')-- T6权限 [PU05030203  入库明细表输出] 升级至V11.1权限[PU050302_04  输出入库明细表]
	insert into #t6auth (t6authid,u8authid) values(N'PU050303',N'PU050303_01')-- T6权限 [PU050303  结算明细表查询] 升级至V11.1权限[PU050303_01  查询结算明细表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05030301',N'PU050303')-- T6权限 [PU05030301  结算明细表] 升级至V11.1权限[PU050303  结算明细表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05030302',N'PU050303_03')-- T6权限 [PU05030302  结算明细表打印] 升级至V11.1权限[PU050303_03  打印结算明细表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05030303',N'PU050303_04')-- T6权限 [PU05030303  结算明细表输出] 升级至V11.1权限[PU050303_04  输出结算明细表]
	insert into #t6auth (t6authid,u8authid) values(N'PU050304',N'PU050304_01')-- T6权限 [PU050304  未完成业务明细表查询] 升级至V11.1权限[PU050304_01  查询:未完成业务明细表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05030401',N'PU050304')-- T6权限 [PU05030401  未完成业务明细表] 升级至V11.1权限[PU050304  未完成业务明细表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05030402',N'PU050304_03')-- T6权限 [PU05030402  未完成业务明细表打印] 升级至V11.1权限[PU050304_03  打印:未完成业务明细表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05030403',N'PU050304_04')-- T6权限 [PU05030403  未完成业务明细表输出] 升级至V11.1权限[PU050304_04  输出:未完成业务明细表]
	insert into #t6auth (t6authid,u8authid) values(N'PU050306',N'PU050306_01')-- T6权限 [PU050306  受托结算明细表查询] 升级至V11.1权限[PU050306_01  查询受托结算明细表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05030601',N'PU050306')-- T6权限 [PU05030601  受托结算明细表] 升级至V11.1权限[PU050306  受托结算明细表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05030602',N'PU050306_03')-- T6权限 [PU05030602  受托结算明细表打印] 升级至V11.1权限[PU050306_03  打印受托结算明细表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05030603',N'PU050306_04')-- T6权限 [PU05030603  受托结算明细表输出] 升级至V11.1权限[PU050306_04  输出受托结算明细表]
	insert into #t6auth (t6authid,u8authid) values(N'PU050307',N'PU050307_01')-- T6权限 [PU050307  采购综合统计表查询] 升级至V11.1权限[PU050307_01  查询采购综合统计表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05030701',N'PU050307')-- T6权限 [PU05030701  采购综合统计表] 升级至V11.1权限[PU050307  采购综合统计表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05030702',N'PU050307_03')-- T6权限 [PU05030702  采购综合统计表打印] 升级至V11.1权限[PU050307_03  打印采购综合统计表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05030703',N'PU050307_04')-- T6权限 [PU05030703  采购综合统计表输出] 升级至V11.1权限[PU050307_04  输出采购综合统计表]
	insert into #t6auth (t6authid,u8authid) values(N'PU050308',N'PU050308_01')-- T6权限 [PU050308  采购计划综合统计表查询] 升级至V11.1权限[PU050308_01  查询采购计划综合统计表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05030801',N'PU050308')-- T6权限 [PU05030801  采购计划综合统计表] 升级至V11.1权限[PU050308  采购计划综合统计表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05030802',N'PU050308_03')-- T6权限 [PU05030802  采购计划综合统计表打印] 升级至V11.1权限[PU050308_03  打印采购计划综合统计表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05030803',N'PU050308_04')-- T6权限 [PU05030803  采购计划综合统计表输出] 升级至V11.1权限[PU050308_04  输出采购计划综合统计表]
	insert into #t6auth (t6authid,u8authid) values(N'PU050309',N'PU050309_01')-- T6权限 [PU050309  费用明细表查询] 升级至V11.1权限[PU050309_01  查询费用明细表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05030901',N'PU050309')-- T6权限 [PU05030901  费用明细表] 升级至V11.1权限[PU050309  费用明细表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05030902',N'PU050309_03')-- T6权限 [PU05030902  费用明细表打印] 升级至V11.1权限[PU050309_03  打印费用明细表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05030903',N'PU050309_04')-- T6权限 [PU05030903  费用明细表输出] 升级至V11.1权限[PU050309_04  输出费用明细表]
	insert into #t6auth (t6authid,u8authid) values(N'PU050310',N'PU050310_01')-- T6权限 [PU050310  到货明细表查询] 升级至V11.1权限[PU050310_01  查询到货明细表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05031001',N'PU050310')-- T6权限 [PU05031001  到货明细表] 升级至V11.1权限[PU050310  到货明细表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05031002',N'PU050310_04')-- T6权限 [PU05031002  到货明细表打印] 升级至V11.1权限[PU050310_04  输出到货明细表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05031003',N'PU050310_05')-- T6权限 [PU05031003  到货明细表输出] 升级至V11.1权限[PU050310_05  发布到货明细表]
	insert into #t6auth (t6authid,u8authid) values(N'PU050401',N'PU050401_01')-- T6权限 [PU050401  代销商品台账查询] 升级至V11.1权限[PU050401_01  查询代销商品款台账]
	insert into #t6auth (t6authid,u8authid) values(N'PU05040101',N'PU050401')-- T6权限 [PU05040101  代销商品台账] 升级至V11.1权限[PU050401  代销商品款台账]
	insert into #t6auth (t6authid,u8authid) values(N'PU05040102',N'PU050401_03')-- T6权限 [PU05040102  代销商品台账打印] 升级至V11.1权限[PU050401_03  打印代销商品款台账]
	insert into #t6auth (t6authid,u8authid) values(N'PU05040103',N'PU050401_04')-- T6权限 [PU05040103  代销商品台账输出] 升级至V11.1权限[PU050401_04  输出代销商品款台账]
	insert into #t6auth (t6authid,u8authid) values(N'PU050402',N'PU050402_01')-- T6权限 [PU050402  在途货物余额表查询] 升级至V11.1权限[PU050402_01  查询在途货物余额表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05040201',N'PU050402')-- T6权限 [PU05040201  在途货物余额表] 升级至V11.1权限[PU050402  在途货物余额表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05040202',N'PU050402_03')-- T6权限 [PU05040202  在途货物余额表打印] 升级至V11.1权限[PU050402_03  打印在途货物余额表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05040203',N'PU050402_04')-- T6权限 [PU05040203  在途货物余额表输出] 升级至V11.1权限[PU050402_04  输出在途货物余额表]
	insert into #t6auth (t6authid,u8authid) values(N'PU050403',N'PU050403_01')-- T6权限 [PU050403  暂估入库余额表查询] 升级至V11.1权限[PU050403_01  查询:采购结算余额表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05040301',N'PU050403')-- T6权限 [PU05040301  暂估入库余额表] 升级至V11.1权限[PU050403  采购结算余额表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05040302',N'PU050403_03')-- T6权限 [PU05040302  暂估入库余额表打印] 升级至V11.1权限[PU050403_03  打印:采购结算余额表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05040303',N'PU050403_04')-- T6权限 [PU05040303  暂估入库余额表输出] 升级至V11.1权限[PU050403_04  输出:采购结算余额表]
	insert into #t6auth (t6authid,u8authid) values(N'PU050404',N'PU050404_01')-- T6权限 [PU050404  代销商品余额表查询] 升级至V11.1权限[PU050404_01  查询代销商品余额表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05040401',N'PU050404')-- T6权限 [PU05040401  代销商品余额表] 升级至V11.1权限[PU050404  代销商品余额表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05040402',N'PU050404_03')-- T6权限 [PU05040402  代销商品余额表打印] 升级至V11.1权限[PU050404_03  打印代销商品余额表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05040403',N'PU050404_04')-- T6权限 [PU05040403  代销商品余额表输出] 升级至V11.1权限[PU050404_04  输出代销商品余额表]
	insert into #t6auth (t6authid,u8authid) values(N'pu050405',N'PURPT003_01')-- T6权限 [pu050405  单据联查] 升级至V11.1权限[PURPT003_01  查询单据联查表]
	insert into #t6auth (t6authid,u8authid) values(N'PU050501',N'PU050501_01')-- T6权限 [PU050501  采购成本分析查询] 升级至V11.1权限[PU050501_01  查询采购成本分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU05050101',N'PU050501')-- T6权限 [PU05050101  采购成本分析] 升级至V11.1权限[PU050501  采购成本分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU05050102',N'PU050501_03')-- T6权限 [PU05050102  采购成本分析打印] 升级至V11.1权限[PU050501_03  打印采购成本分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU05050103',N'PU050501_04')-- T6权限 [PU05050103  采购成本分析输出] 升级至V11.1权限[PU050501_04  输出采购成本分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU050502',N'PU050502_01')-- T6权限 [PU050502  供应商价格对比分析查询] 升级至V11.1权限[PU050502_01  查询供应商价格对比分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU05050201',N'PU050502')-- T6权限 [PU05050201  供应商价格对比分析] 升级至V11.1权限[PU050502  供应商价格对比分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU05050202',N'PU050502_03')-- T6权限 [PU05050202  供应商价格对比分析打印] 升级至V11.1权限[PU050502_03  打印供应商价格对比分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU05050203',N'PU050502_04')-- T6权限 [PU05050203  供应商价格对比分析输出] 升级至V11.1权限[PU050502_04  输出供应商价格对比分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU050503',N'PU050503_01')-- T6权限 [PU050503  采购类型结构分析查询] 升级至V11.1权限[PU050503_01  查询采购类型结构分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU05050301',N'PU050503')-- T6权限 [PU05050301  采购类型结构分析] 升级至V11.1权限[PU050503  采购类型结构分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU05050302',N'PU050503_03')-- T6权限 [PU05050302  采购类型结构分析打印] 升级至V11.1权限[PU050503_03  打印采购类型结构分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU05050303',N'PU050503_04')-- T6权限 [PU05050303  采购类型结构分析输出] 升级至V11.1权限[PU050503_04  输出采购类型结构分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU050504',N'PU050504_01')-- T6权限 [PU050504  采购资金比重分析查询] 升级至V11.1权限[PU050504_01  查询采购资金比重分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU05050401',N'PU050504')-- T6权限 [PU05050401  采购资金比重分析] 升级至V11.1权限[PU050504  采购资金比重分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU05050402',N'PU050504_03')-- T6权限 [PU05050402  采购资金比重分析打印] 升级至V11.1权限[PU050504_03  打印采购资金比重分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU05050403',N'PU050504_04')-- T6权限 [PU05050403  采购资金比重分析输出] 升级至V11.1权限[PU050504_04  输出采购资金比重分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU050505',N'PU050505_01')-- T6权限 [PU050505  采购费用分析查询] 升级至V11.1权限[PU050505_01  查询采购费用分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU05050501',N'PU050505')-- T6权限 [PU05050501  采购费用分析] 升级至V11.1权限[PU050505  采购费用分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU05050502',N'PU050505_03')-- T6权限 [PU05050502  采购费用分析打印] 升级至V11.1权限[PU050505_03  打印采购费用分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU05050503',N'PU050505_04')-- T6权限 [PU05050503  采购费用分析输出] 升级至V11.1权限[PU050505_04  输出采购费用分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU050506',N'PU050506_01')-- T6权限 [PU050506  采购货龄综合分析查询] 升级至V11.1权限[PU050506_01  查询采购货龄综合分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU05050601',N'PU050506')-- T6权限 [PU05050601  采购货龄综合分析] 升级至V11.1权限[PU050506  采购货龄综合分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU05050602',N'PU050506_03')-- T6权限 [PU05050602  采购货龄综合分析打印] 升级至V11.1权限[PU050506_03  打印采购货龄综合分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU05050603',N'PU050506_04')-- T6权限 [PU05050603  采购货龄综合分析输出] 升级至V11.1权限[PU050506_04  输出采购货龄综合分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU050507',N'PU050507_01')-- T6权限 [PU050507  增值税发票处理状态明细表查询] 升级至V11.1权限[PU050507_01  查询增值税发票处理状态明细表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05050701',N'PU050507')-- T6权限 [PU05050701  增值税发票处理状态明细表] 升级至V11.1权限[PU050507  增值税发票处理状态明细表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05050702',N'PU050507_03')-- T6权限 [PU05050702  增值税发票处理状态明细表打印] 升级至V11.1权限[PU050507_03  打印增值税发票处理状态明细表]
	insert into #t6auth (t6authid,u8authid) values(N'PU05050703',N'PU050507_04')-- T6权限 [PU05050703  增值税发票处理状态明细表输出] 升级至V11.1权限[PU050507_04  输出增值税发票处理状态明细表]
	insert into #t6auth (t6authid,u8authid) values(N'PU050510',N'PU[__]69751227-2f36-4186-b13a-5d231cb5cc4b_001_01')-- T6权限 [PU050510  采购不合格品原因分析表查询] 升级至V11.1权限[PU[__]69751227-2f36-4186-b13a-5d231cb5cc4b_001_01  查询:采购不良品原因分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU05051001',N'PU[__]69751227-2f36-4186-b13a-5d231cb5cc4b_001')-- T6权限 [PU05051001  采购不合格品原因分析表] 升级至V11.1权限[PU[__]69751227-2f36-4186-b13a-5d231cb5cc4b_001  采购不良品原因分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU05051002',N'PU[__]69751227-2f36-4186-b13a-5d231cb5cc4b_001_03')-- T6权限 [PU05051002  采购不合格品原因分析表打印] 升级至V11.1权限[PU[__]69751227-2f36-4186-b13a-5d231cb5cc4b_001_03  打印:采购不良品原因分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU05051003',N'PU[__]69751227-2f36-4186-b13a-5d231cb5cc4b_001_04')-- T6权限 [PU05051003  采购不合格品原因分析表输出] 升级至V11.1权限[PU[__]69751227-2f36-4186-b13a-5d231cb5cc4b_001_04  输出:采购不良品原因分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU060103',N'PU060105')-- T6权限 [PU060103  供应商存货价格表打印] 升级至V11.1权限[PU060105  供应商存货价格表打印]
	insert into #t6auth (t6authid,u8authid) values(N'PU060104',N'PU060106')-- T6权限 [PU060104  供应商存货价格表输出] 升级至V11.1权限[PU060106  供应商存货价格表输出]
	insert into #t6auth (t6authid,u8authid) values(N'PU0604',N'PU0604_01')-- T6权限 [PU0604  供应商交货情况分析查询] 升级至V11.1权限[PU0604_01  查询供应商交货情况分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU060401',N'PU0604')-- T6权限 [PU060401  供应商交货情况分析] 升级至V11.1权限[PU0604  供应商交货情况分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU060402',N'PU0604_03')-- T6权限 [PU060402  供应商交货情况分析打印] 升级至V11.1权限[PU0604_03  打印供应商交货情况分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU060403',N'PU0604_04')-- T6权限 [PU060403  供应商交货情况分析输出] 升级至V11.1权限[PU0604_04  输出供应商交货情况分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU0605',N'PU0605_01')-- T6权限 [PU0605  供应商交货质量分析查询] 升级至V11.1权限[PU0605_01  查询:供应商交货质量分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU060501',N'PU0605')-- T6权限 [PU060501  供应商交货质量分析] 升级至V11.1权限[PU0605  供应商交货质量分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU060502',N'PU0605_03')-- T6权限 [PU060502  供应商交货质量分析打印] 升级至V11.1权限[PU0605_03  打印:供应商交货质量分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU060503',N'PU0605_04')-- T6权限 [PU060503  供应商交货质量分析输出] 升级至V11.1权限[PU0605_04  输出:供应商交货质量分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU0606',N'PU0606_01')-- T6权限 [PU0606  供应商ABC分析查询] 升级至V11.1权限[PU0606_01  查询供应商ABC分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU060601',N'PU0606')-- T6权限 [PU060601  供应商ABC分析] 升级至V11.1权限[PU0606  供应商ABC分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU060602',N'PU0606_03')-- T6权限 [PU060602  供应商ABC分析打印] 升级至V11.1权限[PU0606_03  打印供应商ABC分析]
	insert into #t6auth (t6authid,u8authid) values(N'PU060603',N'PU0606_04')-- T6权限 [PU060603  供应商ABC分析输出] 升级至V11.1权限[PU0606_04  输出供应商ABC分析]
	insert into #t6auth (t6authid,u8authid) values(N'SA020801',N'SA02080102')-- T6权限 [SA020801  期初发货单查询] 升级至V11.1权限[SA02080102  期初发货单查询]
	insert into #t6auth (t6authid,u8authid) values(N'SA02080101',N'SA020801')-- T6权限 [SA02080101  期初发货单] 升级至V11.1权限[SA020801  期初发货单]
	insert into #t6auth (t6authid,u8authid) values(N'SA02080102',N'SA02080111')-- T6权限 [SA02080102  期初发货单打印] 升级至V11.1权限[SA02080111  期初发货单打印]
	insert into #t6auth (t6authid,u8authid) values(N'SA02080104',N'SA02080112')-- T6权限 [SA02080104  期初发货单输出] 升级至V11.1权限[SA02080112  期初发货单输出]
	insert into #t6auth (t6authid,u8authid) values(N'SA02080105',N'SA02080104')-- T6权限 [SA02080105  期初发货单删除] 升级至V11.1权限[SA02080104  期初发货单删除]
	insert into #t6auth (t6authid,u8authid) values(N'SA02080106',N'SA02080103')-- T6权限 [SA02080106  期初发货单录入] 升级至V11.1权限[SA02080103  期初发货单录入]
	insert into #t6auth (t6authid,u8authid) values(N'SA02080107',N'SA02080105')-- T6权限 [SA02080107  期初发货单审核] 升级至V11.1权限[SA02080105  期初发货单审核]
	insert into #t6auth (t6authid,u8authid) values(N'SA02080108',N'SA02080106')-- T6权限 [SA02080108  期初发货单弃审] 升级至V11.1权限[SA02080106  期初发货单弃审]
	insert into #t6auth (t6authid,u8authid) values(N'SA02080109',N'SA02080108')-- T6权限 [SA02080109  期初发货单关闭] 升级至V11.1权限[SA02080108  期初发货单关闭]
	insert into #t6auth (t6authid,u8authid) values(N'SA02080110',N'SA02080109')-- T6权限 [SA02080110  期初发货单打开] 升级至V11.1权限[SA02080109  期初发货单打开]
	insert into #t6auth (t6authid,u8authid) values(N'SA020803',N'SA02080302')-- T6权限 [SA020803  期初委托代销发货单查询] 升级至V11.1权限[SA02080302  期初委托代销发货单查询]
	insert into #t6auth (t6authid,u8authid) values(N'SA02080301',N'SA020803')-- T6权限 [SA02080301  期初委托代销发货单] 升级至V11.1权限[SA020803  期初委托代销发货单]
	insert into #t6auth (t6authid,u8authid) values(N'SA02080302',N'SA02080307')-- T6权限 [SA02080302  期初委托代销发货单打印] 升级至V11.1权限[SA02080307  期初委托代销发货单打印]
	insert into #t6auth (t6authid,u8authid) values(N'SA02080304',N'SA02080308')-- T6权限 [SA02080304  期初委托代销发货单输出] 升级至V11.1权限[SA02080308  期初委托代销发货单输出]
	insert into #t6auth (t6authid,u8authid) values(N'SA02080305',N'SA02080304')-- T6权限 [SA02080305  期初委托代销发货单删除] 升级至V11.1权限[SA02080304  期初委托代销发货单删除]
	insert into #t6auth (t6authid,u8authid) values(N'SA02080306',N'SA02080303')-- T6权限 [SA02080306  期初委托代销发货单录入] 升级至V11.1权限[SA02080303  期初委托代销发货单录入]
	insert into #t6auth (t6authid,u8authid) values(N'SA02080307',N'SA02080305')-- T6权限 [SA02080307  期初委托代销发货单审核] 升级至V11.1权限[SA02080305  期初委托代销发货单审核]
	insert into #t6auth (t6authid,u8authid) values(N'SA02080308',N'SA02080306')-- T6权限 [SA02080308  期初委托代销发货单弃审] 升级至V11.1权限[SA02080306  期初委托代销发货单弃审]
	insert into #t6auth (t6authid,u8authid) values(N'SA03000110',N'SA03000110')-- T6权限 [SA03000110  销售报价单打印] 升级至V11.1权限[SA03000110  销售报价单打印]
	insert into #t6auth (t6authid,u8authid) values(N'SA03000111',N'SA03000109')-- T6权限 [SA03000111  销售报价单输出] 升级至V11.1权限[SA03000109  销售报价单输出]
	insert into #t6auth (t6authid,u8authid) values(N'SA03000113',N'SA03000108')-- T6权限 [SA03000113  销售报价单删除] 升级至V11.1权限[SA03000108  销售报价单删除]
	insert into #t6auth (t6authid,u8authid) values(N'SA03000114',N'SA03000111')-- T6权限 [SA03000114  销售报价单弃审] 升级至V11.1权限[SA03000111  销售报价单弃审]
	insert into #t6auth (t6authid,u8authid) values(N'SA03000115',N'SA03000112')-- T6权限 [SA03000115  销售报价单打开] 升级至V11.1权限[SA03000112  销售报价单打开]
	insert into #t6auth (t6authid,u8authid) values(N'SA030002',N'SA03000201')-- T6权限 [SA030002  销售报价单列表查询] 升级至V11.1权限[SA03000201  销售报价单列表]
	insert into #t6auth (t6authid,u8authid) values(N'SA03000201',N'SA030002')-- T6权限 [SA03000201  销售报价单列表] 升级至V11.1权限[SA030002  销售报价单列表]
	insert into #t6auth (t6authid,u8authid) values(N'SA03010112',N'SA03010118')-- T6权限 [SA03010112  销售订单打印] 升级至V11.1权限[SA03010118  销售订单打印]
	insert into #t6auth (t6authid,u8authid) values(N'SA03010114',N'SA03010117')-- T6权限 [SA03010114  销售订单输出] 升级至V11.1权限[SA03010117  销售订单输出]
	insert into #t6auth (t6authid,u8authid) values(N'SA03010115',N'SA03010116')-- T6权限 [SA03010115  销售订单删除] 升级至V11.1权限[SA03010116  销售订单删除]
	insert into #t6auth (t6authid,u8authid) values(N'SA03010116',N'SA03010113')-- T6权限 [SA03010116  销售订单弃审] 升级至V11.1权限[SA03010113  销售订单弃审]
	insert into #t6auth (t6authid,u8authid) values(N'SA03010117',N'SA03010119')-- T6权限 [SA03010117  销售订单打开] 升级至V11.1权限[SA03010119  销售订单打开]
	insert into #t6auth (t6authid,u8authid) values(N'SA03010117',N'SA03010205')-- T6权限 [SA03010117  销售订单打开] 升级至V11.1权限[SA03010205  订单批量打开]
	insert into #t6auth (t6authid,u8authid) values(N'SA030102',N'SA03010201')-- T6权限 [SA030102  销售订单列表查询] 升级至V11.1权限[SA03010201  销售订单列表]
	insert into #t6auth (t6authid,u8authid) values(N'SA03010201',N'SA030102')-- T6权限 [SA03010201  销售订单列表] 升级至V11.1权限[SA030102  销售订单列表]
	insert into #t6auth (t6authid,u8authid) values(N'SA03010202',N'SA03010210')-- T6权限 [SA03010202  销售订单列表打印] 升级至V11.1权限[SA03010210  订单列表打印]
	insert into #t6auth (t6authid,u8authid) values(N'SA03010203',N'SA03010211')-- T6权限 [SA03010203  销售订单列表输出] 升级至V11.1权限[SA03010211  订单列表输出]
	insert into #t6auth (t6authid,u8authid) values(N'SA030104',N'SA030104_01')-- T6权限 [SA030104  销售订货统计表查询] 升级至V11.1权限[SA030104_01  查询销售订货统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA03010401',N'SA030104')-- T6权限 [SA03010401  销售订货统计表] 升级至V11.1权限[SA030104  销售订货统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA03010402',N'SA030104_03')-- T6权限 [SA03010402  销售订货统计表打印] 升级至V11.1权限[SA030104_03  打印销售订货统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA03010403',N'SA030104_04')-- T6权限 [SA03010403  销售订货统计表输出] 升级至V11.1权限[SA030104_04  输出销售订货统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA030105',N'SA030105_01')-- T6权限 [SA030105  订单执行统计表查询] 升级至V11.1权限[SA030105_01  查询销售订单执行统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA03010501',N'SA030105')-- T6权限 [SA03010501  订单执行统计表] 升级至V11.1权限[SA030105  销售订单执行统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA03010502',N'SA030105_03')-- T6权限 [SA03010502  订单执行统计表打印] 升级至V11.1权限[SA030105_03  打印销售订单执行统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA03010503',N'SA030105_04')-- T6权限 [SA03010503  订单执行统计表输出] 升级至V11.1权限[SA030105_04  输出销售订单执行统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA030106',N'SA030106_01')-- T6权限 [SA030106  销售订单预警和报警查询] 升级至V11.1权限[SA030106_01  查询销售订单预警和报警]
	insert into #t6auth (t6authid,u8authid) values(N'SA03010601',N'SA030106')-- T6权限 [SA03010601  销售订单预警和报警] 升级至V11.1权限[SA030106  销售订单预警和报警]
	insert into #t6auth (t6authid,u8authid) values(N'SA03010602',N'SA030106_03')-- T6权限 [SA03010602  销售订单预警和报警打印] 升级至V11.1权限[SA030106_03  打印销售订单预警和报警]
	insert into #t6auth (t6authid,u8authid) values(N'SA03010603',N'SA030106_04')-- T6权限 [SA03010603  销售订单预警和报警输出] 升级至V11.1权限[SA030106_04  输出销售订单预警和报警]
	insert into #t6auth (t6authid,u8authid) values(N'SA03020111',N'SA03020111')-- T6权限 [SA03020111  发货单打印] 升级至V11.1权限[SA03020111  发货单打印]
	insert into #t6auth (t6authid,u8authid) values(N'SA03020113',N'SA03020112')-- T6权限 [SA03020113  发货单输出] 升级至V11.1权限[SA03020112  发货单输出]
	insert into #t6auth (t6authid,u8authid) values(N'SA03020114',N'SA03020110')-- T6权限 [SA03020114  发货单删除] 升级至V11.1权限[SA03020110  发货单删除]
	insert into #t6auth (t6authid,u8authid) values(N'SA03020115',N'SA03020106')-- T6权限 [SA03020115  发货单打开] 升级至V11.1权限[SA03020106  发货单打开]
	insert into #t6auth (t6authid,u8authid) values(N'SA03020211',N'SA03020211')-- T6权限 [SA03020211  退货单打印] 升级至V11.1权限[SA03020211  退货单打印]
	insert into #t6auth (t6authid,u8authid) values(N'SA03020213',N'SA03020212')-- T6权限 [SA03020213  退货单输出] 升级至V11.1权限[SA03020212  退货单输出]
	insert into #t6auth (t6authid,u8authid) values(N'SA03020214',N'SA03020210')-- T6权限 [SA03020214  退货单删除] 升级至V11.1权限[SA03020210  退货单删除]
	insert into #t6auth (t6authid,u8authid) values(N'SA03020215',N'SA03020206')-- T6权限 [SA03020215  退货单打开] 升级至V11.1权限[SA03020206  退货单打开]
	insert into #t6auth (t6authid,u8authid) values(N'SA030203',N'SA03020301')-- T6权限 [SA030203  发货单列表查询] 升级至V11.1权限[SA03020301  发货单列表]
	insert into #t6auth (t6authid,u8authid) values(N'SA03020301',N'SA030203')-- T6权限 [SA03020301  发货单列表] 升级至V11.1权限[SA030203  发货单列表]
	insert into #t6auth (t6authid,u8authid) values(N'SA03020302',N'SA03020302')-- T6权限 [SA03020302  发货单列表打印] 升级至V11.1权限[SA03020302  发货单列表打印]
	insert into #t6auth (t6authid,u8authid) values(N'SA03020303',N'SA03020303')-- T6权限 [SA03020303  发货单列表输出] 升级至V11.1权限[SA03020303  发货单列表输出]
	insert into #t6auth (t6authid,u8authid) values(N'SA030301',N'SA03030101')-- T6权限 [SA030301  销售发票列表查询] 升级至V11.1权限[SA03030101  销售发票列表]
	insert into #t6auth (t6authid,u8authid) values(N'SA03030101',N'SA030301')-- T6权限 [SA03030101  销售发票列表] 升级至V11.1权限[SA030301  销售发票列表]
	insert into #t6auth (t6authid,u8authid) values(N'SA03030102',N'SA03030102')-- T6权限 [SA03030102  销售发票列表打印] 升级至V11.1权限[SA03030102  销售发票列表打印]
	insert into #t6auth (t6authid,u8authid) values(N'SA03030103',N'SA03030103')-- T6权限 [SA03030103  销售发票列表输出] 升级至V11.1权限[SA03030103  销售发票列表输出]
	insert into #t6auth (t6authid,u8authid) values(N'SA03030211',N'SA03030211')-- T6权限 [SA03030211  销售专用发票打印] 升级至V11.1权限[SA03030211  销售专用发票打印]
	insert into #t6auth (t6authid,u8authid) values(N'SA03030213',N'SA03030212')-- T6权限 [SA03030213  销售专用发票输出] 升级至V11.1权限[SA03030212  销售专用发票输出]
	insert into #t6auth (t6authid,u8authid) values(N'SA03030214',N'SA03030206')-- T6权限 [SA03030214  销售专用发票删除] 升级至V11.1权限[SA03030206  销售专用发票删除]
	insert into #t6auth (t6authid,u8authid) values(N'SA03030311',N'SA03030311')-- T6权限 [SA03030311  销售普通发票打印] 升级至V11.1权限[SA03030311  销售普通发票打印]
	insert into #t6auth (t6authid,u8authid) values(N'SA03030313',N'SA03030312')-- T6权限 [SA03030313  销售普通发票输出] 升级至V11.1权限[SA03030312  销售普通发票输出]
	insert into #t6auth (t6authid,u8authid) values(N'SA03030314',N'SA03030306')-- T6权限 [SA03030314  销售普通发票删除] 升级至V11.1权限[SA03030306  销售普通发票删除]
	insert into #t6auth (t6authid,u8authid) values(N'SA03030411',N'SA03030411')-- T6权限 [SA03030411  红字销售专用发票打印] 升级至V11.1权限[SA03030411  红字销售专用发票打印]
	insert into #t6auth (t6authid,u8authid) values(N'SA03030413',N'SA03030412')-- T6权限 [SA03030413  红字销售专用发票输出] 升级至V11.1权限[SA03030412  红字销售专用发票输出]
	insert into #t6auth (t6authid,u8authid) values(N'SA03030414',N'SA03030406')-- T6权限 [SA03030414  红字销售专用发票删除] 升级至V11.1权限[SA03030406  红字销售专用发票删除]
	insert into #t6auth (t6authid,u8authid) values(N'SA03030511',N'SA03030511')-- T6权限 [SA03030511  红字销售普通发票打印] 升级至V11.1权限[SA03030511  红字销售普通发票打印]
	insert into #t6auth (t6authid,u8authid) values(N'SA03030513',N'SA03030506')-- T6权限 [SA03030513  红字销售普通发票删除] 升级至V11.1权限[SA03030506  红字销售普通发票删除]
	insert into #t6auth (t6authid,u8authid) values(N'SA03030514',N'SA03030512')-- T6权限 [SA03030514  红字销售普通发票输出] 升级至V11.1权限[SA03030512  红字销售普通发票输出]
	insert into #t6auth (t6authid,u8authid) values(N'SA03040106',N'SA03040109')-- T6权限 [SA03040106  委托代销发货单打印] 升级至V11.1权限[SA03040109  委托代销发货单打印]
	insert into #t6auth (t6authid,u8authid) values(N'SA03040108',N'SA03040110')-- T6权限 [SA03040108  委托代销发货单输出] 升级至V11.1权限[SA03040110  委托代销发货单输出]
	insert into #t6auth (t6authid,u8authid) values(N'SA03040206',N'SA03040209')-- T6权限 [SA03040206  委托代销退货单打印] 升级至V11.1权限[SA03040209  委托代销退货单打印]
	insert into #t6auth (t6authid,u8authid) values(N'SA03040208',N'SA03040210')-- T6权限 [SA03040208  委托代销退货单输出] 升级至V11.1权限[SA03040210  委托代销退货单输出]
	insert into #t6auth (t6authid,u8authid) values(N'SA03040306',N'SA03040309')-- T6权限 [SA03040306  委托代销结算单打印] 升级至V11.1权限[SA03040309  委托代销结算单打印]
	insert into #t6auth (t6authid,u8authid) values(N'SA03040308',N'SA03040310')-- T6权限 [SA03040308  委托代销结算单输出] 升级至V11.1权限[SA03040310  委托代销结算单输出]
	insert into #t6auth (t6authid,u8authid) values(N'SA03040406',N'SA03040409')-- T6权限 [SA03040406  委托代销结算退回单打印] 升级至V11.1权限[SA03040409  委托代销结算退回单打印]
	insert into #t6auth (t6authid,u8authid) values(N'SA03040408',N'SA03040410')-- T6权限 [SA03040408  委托代销结算退回单输出] 升级至V11.1权限[SA03040410  委托代销结算退回单输出]
	insert into #t6auth (t6authid,u8authid) values(N'SA030405',N'SA03040501')-- T6权限 [SA030405  委托代销发货单列表查询] 升级至V11.1权限[SA03040501  委托代销发货单列表]
	insert into #t6auth (t6authid,u8authid) values(N'SA03040501',N'SA030405')-- T6权限 [SA03040501  委托代销发货单列表] 升级至V11.1权限[SA030405  委托代销发货单列表]
	insert into #t6auth (t6authid,u8authid) values(N'SA03040502',N'SA03040506')-- T6权限 [SA03040502  委托代销发货单列表打印] 升级至V11.1权限[SA03040506  委托代销发货单列表打印]
	insert into #t6auth (t6authid,u8authid) values(N'SA03040503',N'SA03040507')-- T6权限 [SA03040503  委托代销发货单列表输出] 升级至V11.1权限[SA03040507  委托代销发货单列表输出]
	insert into #t6auth (t6authid,u8authid) values(N'SA030406',N'SA03040601')-- T6权限 [SA030406  委托代销结算单列表查询] 升级至V11.1权限[SA03040601  委托代销结算单列表]
	insert into #t6auth (t6authid,u8authid) values(N'SA03040601',N'SA030406')-- T6权限 [SA03040601  委托代销结算单列表] 升级至V11.1权限[SA030406  委托代销结算单列表]
	insert into #t6auth (t6authid,u8authid) values(N'SA03040602',N'SA03040606')-- T6权限 [SA03040602  委托代销结算单列表打印] 升级至V11.1权限[SA03040606  委托代销结算单列表打印]
	insert into #t6auth (t6authid,u8authid) values(N'SA03040603',N'SA03040607')-- T6权限 [SA03040603  委托代销结算单列表输出] 升级至V11.1权限[SA03040607  委托代销结算单列表输出]
	insert into #t6auth (t6authid,u8authid) values(N'SA03040707',N'SA03040710')-- T6权限 [SA03040707  委托代销调整单打印] 升级至V11.1权限[SA03040710  委托代销调整单打印]
	insert into #t6auth (t6authid,u8authid) values(N'SA03040709',N'SA03040711')-- T6权限 [SA03040709  委托代销调整单输出] 升级至V11.1权限[SA03040711  委托代销调整单输出]
	insert into #t6auth (t6authid,u8authid) values(N'SA03050105',N'SA03050108')-- T6权限 [SA03050105  销售调拨单打印] 升级至V11.1权限[SA03050108  销售调拨单打印]
	insert into #t6auth (t6authid,u8authid) values(N'SA03050107',N'SA03050109')-- T6权限 [SA03050107  销售调拨单输出] 升级至V11.1权限[SA03050109  销售调拨单输出]
	insert into #t6auth (t6authid,u8authid) values(N'SA03050108',N'SA03050110')-- T6权限 [SA03050108  销售调拨单删除] 升级至V11.1权限[SA03050110  销售调拨单删除]
	insert into #t6auth (t6authid,u8authid) values(N'SA03050205',N'SA03050208')-- T6权限 [SA03050205  红字销售调拨单打印] 升级至V11.1权限[SA03050208  红字销售调拨单打印]
	insert into #t6auth (t6authid,u8authid) values(N'SA03050207',N'SA03050209')-- T6权限 [SA03050207  红字销售调拨单输出] 升级至V11.1权限[SA03050209  红字销售调拨单输出]
	insert into #t6auth (t6authid,u8authid) values(N'SA03050208',N'SA03050210')-- T6权限 [SA03050208  红字销售调拨单删除] 升级至V11.1权限[SA03050210  红字销售调拨单删除]
	insert into #t6auth (t6authid,u8authid) values(N'SA030503',N'SA03050301')-- T6权限 [SA030503  销售调拨单列表查询] 升级至V11.1权限[SA03050301  销售调拨单列表]
	insert into #t6auth (t6authid,u8authid) values(N'SA03050301',N'SA030503')-- T6权限 [SA03050301  销售调拨单列表] 升级至V11.1权限[SA030503  销售调拨单列表]
	insert into #t6auth (t6authid,u8authid) values(N'SA03050302',N'SA03050306')-- T6权限 [SA03050302  销售调拨单列表打印] 升级至V11.1权限[SA03050306  销售调拨单列表打印]
	insert into #t6auth (t6authid,u8authid) values(N'SA03050303',N'SA03050307')-- T6权限 [SA03050303  销售调拨单列表输出] 升级至V11.1权限[SA03050307  销售调拨单列表输出]
	insert into #t6auth (t6authid,u8authid) values(N'SA03060105',N'SA03060108')-- T6权限 [SA03060105  零售日报打印] 升级至V11.1权限[SA03060108  零售日报打印]
	insert into #t6auth (t6authid,u8authid) values(N'SA03060107',N'SA03060109')-- T6权限 [SA03060107  零售日报输出] 升级至V11.1权限[SA03060109  零售日报输出]
	insert into #t6auth (t6authid,u8authid) values(N'SA03060108',N'SA03060110')-- T6权限 [SA03060108  零售日报删除] 升级至V11.1权限[SA03060110  零售日报删除]
	insert into #t6auth (t6authid,u8authid) values(N'SA03060205',N'SA03060208')-- T6权限 [SA03060205  红字零售日报打印] 升级至V11.1权限[SA03060208  红字零售日报打印]
	insert into #t6auth (t6authid,u8authid) values(N'SA03060207',N'SA03060209')-- T6权限 [SA03060207  红字零售日报输出] 升级至V11.1权限[SA03060209  红字零售日报输出]
	insert into #t6auth (t6authid,u8authid) values(N'SA03060208',N'SA03060210')-- T6权限 [SA03060208  红字零售日报删除] 升级至V11.1权限[SA03060210  红字零售日报删除]
	insert into #t6auth (t6authid,u8authid) values(N'SA03080104',N'SA03080107')-- T6权限 [SA03080104  代垫费用单打印] 升级至V11.1权限[SA03080107  代垫费用单打印]
	insert into #t6auth (t6authid,u8authid) values(N'SA03080106',N'SA03080108')-- T6权限 [SA03080106  代垫费用单输出] 升级至V11.1权限[SA03080108  代垫费用单输出]
	insert into #t6auth (t6authid,u8authid) values(N'SA03080107',N'SA03080109')-- T6权限 [SA03080107  代垫费用单删除] 升级至V11.1权限[SA03080109  代垫费用单删除]
	insert into #t6auth (t6authid,u8authid) values(N'SA03080108',N'SA03080110')-- T6权限 [SA03080108  代垫费用单弃审] 升级至V11.1权限[SA03080110  代垫费用单弃审]
	insert into #t6auth (t6authid,u8authid) values(N'SA030803',N'SA030803_01')-- T6权限 [SA030803  代垫费用统计表查询] 升级至V11.1权限[SA030803_01  查询代垫费用统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA03080301',N'SA030803')-- T6权限 [SA03080301  代垫费用统计表] 升级至V11.1权限[SA030803  代垫费用统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA03080302',N'SA030803_03')-- T6权限 [SA03080302  代垫费用统计表打印] 升级至V11.1权限[SA030803_03  打印代垫费用统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA03080303',N'SA030803_04')-- T6权限 [SA03080303  代垫费用统计表输出] 升级至V11.1权限[SA030803_04  输出代垫费用统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA03090104',N'SA03090109')-- T6权限 [SA03090104  销售支出单打印] 升级至V11.1权限[SA03090109  销售费用支出单打印]
	insert into #t6auth (t6authid,u8authid) values(N'SA03090106',N'SA03090110')-- T6权限 [SA03090106  销售支出单输出] 升级至V11.1权限[SA03090110  销售费用支出单输出]
	insert into #t6auth (t6authid,u8authid) values(N'SA03090107',N'SA03090111')-- T6权限 [SA03090107  销售支出单删除] 升级至V11.1权限[SA03090111  销售费用支出单删除]
	insert into #t6auth (t6authid,u8authid) values(N'SA030903',N'SA030903_01')-- T6权限 [SA030903  销售支出统计表查询] 升级至V11.1权限[SA030903_01  查询销售费用支出统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA03090301',N'SA030903')-- T6权限 [SA03090301  销售支出统计表] 升级至V11.1权限[SA030903  销售费用支出统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA03090302',N'SA030903_03')-- T6权限 [SA03090302  销售支出统计表打印] 升级至V11.1权限[SA030903_03  打印销售费用支出统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA03090303',N'SA030903_04')-- T6权限 [SA03090303  销售支出统计表输出] 升级至V11.1权限[SA030903_04  输出销售费用支出统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA031003',N'SA031003_01')-- T6权限 [SA031003  包装物租借统计表查询] 升级至V11.1权限[SA031003_01  查询包装物租借统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA03100301',N'SA031003')-- T6权限 [SA03100301  包装物租借统计表] 升级至V11.1权限[SA031003  包装物租借统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA03100302',N'SA031003_03')-- T6权限 [SA03100302  包装物租借统计表打印] 升级至V11.1权限[SA031003_03  打印包装物租借统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA03100303',N'SA031003_04')-- T6权限 [SA03100303  包装物租借统计表输出] 升级至V11.1权限[SA031003_04  输出包装物租借统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA031104',N'SA031104_01')-- T6权限 [SA031104  销售计划执行报告查询] 升级至V11.1权限[SA031104_01  查询销售计划执行报告]
	insert into #t6auth (t6authid,u8authid) values(N'SA03110401',N'SA031104')-- T6权限 [SA03110401  销售计划执行报告] 升级至V11.1权限[SA031104  销售计划执行报告]
	insert into #t6auth (t6authid,u8authid) values(N'SA03110402',N'SA031104_03')-- T6权限 [SA03110402  销售计划执行报告打印] 升级至V11.1权限[SA031104_03  打印销售计划执行报告]
	insert into #t6auth (t6authid,u8authid) values(N'SA03110403',N'SA031104_04')-- T6权限 [SA03110403  销售计划执行报告输出] 升级至V11.1权限[SA031104_04  输出销售计划执行报告]
	insert into #t6auth (t6authid,u8authid) values(N'SA0322',N'SA0322_01')-- T6权限 [SA0322  销售现存量查询] 升级至V11.1权限[SA0322_01  查询销售现存量查询]
	insert into #t6auth (t6authid,u8authid) values(N'SA032201',N'SA0322')-- T6权限 [SA032201  销售现存量] 升级至V11.1权限[SA0322  销售现存量查询]
	insert into #t6auth (t6authid,u8authid) values(N'SA032202',N'SA0322_03')-- T6权限 [SA032202  销售现存量打印] 升级至V11.1权限[SA0322_03  打印销售现存量查询]
	insert into #t6auth (t6authid,u8authid) values(N'SA032203',N'SA0322_04')-- T6权限 [SA032203  销售现存量输出] 升级至V11.1权限[SA0322_04  输出销售现存量查询]
	insert into #t6auth (t6authid,u8authid) values(N'SA0323',N'SA032302')-- T6权限 [SA0323  防伪税控] 升级至V11.1权限[SA032302  批量导出]
	insert into #t6auth (t6authid,u8authid) values(N'SA0324',N'SA0324')-- T6权限 [SA0324  预估毛利] 升级至V11.1权限[SA0324  预估毛利]
	insert into #t6auth (t6authid,u8authid) values(N'SA040201',N'SA040201_01')-- T6权限 [SA040201  销售收入明细账查询] 升级至V11.1权限[SA040201_01  查询销售收入明细账]
	insert into #t6auth (t6authid,u8authid) values(N'SA04020101',N'SA040201')-- T6权限 [SA04020101  销售收入明细账] 升级至V11.1权限[SA040201  销售收入明细账]
	insert into #t6auth (t6authid,u8authid) values(N'SA04020102',N'SA040201_03')-- T6权限 [SA04020102  销售收入明细账打印] 升级至V11.1权限[SA040201_03  打印销售收入明细账]
	insert into #t6auth (t6authid,u8authid) values(N'SA04020103',N'SA040201_04')-- T6权限 [SA04020103  销售收入明细账输出] 升级至V11.1权限[SA040201_04  输出销售收入明细账]
	insert into #t6auth (t6authid,u8authid) values(N'SA040202',N'SA040202_01')-- T6权限 [SA040202  销售成本明细账查询] 升级至V11.1权限[SA040202_01  查询销售成本明细账]
	insert into #t6auth (t6authid,u8authid) values(N'SA04020201',N'SA040202')-- T6权限 [SA04020201  销售成本明细账] 升级至V11.1权限[SA040202  销售成本明细账]
	insert into #t6auth (t6authid,u8authid) values(N'SA04020202',N'SA040202_03')-- T6权限 [SA04020202  销售成本明细账打印] 升级至V11.1权限[SA040202_03  打印销售成本明细账]
	insert into #t6auth (t6authid,u8authid) values(N'SA04020203',N'SA040202_04')-- T6权限 [SA04020203  销售成本明细账输出] 升级至V11.1权限[SA040202_04  输出销售成本明细账]
	insert into #t6auth (t6authid,u8authid) values(N'SA040203',N'SA040203_01')-- T6权限 [SA040203  销售明细账查询] 升级至V11.1权限[SA040203_01  查询销售明细账]
	insert into #t6auth (t6authid,u8authid) values(N'SA04020301',N'SA040203')-- T6权限 [SA04020301  销售明细账] 升级至V11.1权限[SA040203  销售明细账]
	insert into #t6auth (t6authid,u8authid) values(N'SA04020302',N'SA040203_03')-- T6权限 [SA04020302  销售明细账打印] 升级至V11.1权限[SA040203_03  打印销售明细账]
	insert into #t6auth (t6authid,u8authid) values(N'SA04020303',N'SA040203_04')-- T6权限 [SA04020303  销售明细账输出] 升级至V11.1权限[SA040203_04  输出销售明细账]
	insert into #t6auth (t6authid,u8authid) values(N'SA040204',N'SA040204_01')-- T6权限 [SA040204  发货结算勾对表查询] 升级至V11.1权限[SA040204_01  查询发货结算勾对表]
	insert into #t6auth (t6authid,u8authid) values(N'SA04020401',N'SA040204')-- T6权限 [SA04020401  发货结算勾对表] 升级至V11.1权限[SA040204  发货结算勾对表]
	insert into #t6auth (t6authid,u8authid) values(N'SA04020402',N'SA040204_03')-- T6权限 [SA04020402  发货结算勾对表打印] 升级至V11.1权限[SA040204_03  打印发货结算勾对表]
	insert into #t6auth (t6authid,u8authid) values(N'SA04020403',N'SA040204_04')-- T6权限 [SA04020403  发货结算勾对表输出] 升级至V11.1权限[SA040204_04  输出发货结算勾对表]
	insert into #t6auth (t6authid,u8authid) values(N'SA040205',N'SA040205_01')-- T6权限 [SA040205  委托代销明细账查询] 升级至V11.1权限[SA040205_01  查询委托代销明细账]
	insert into #t6auth (t6authid,u8authid) values(N'SA04020501',N'SA040205')-- T6权限 [SA04020501  委托代销明细账] 升级至V11.1权限[SA040205  委托代销明细账]
	insert into #t6auth (t6authid,u8authid) values(N'SA04020502',N'SA040205_03')-- T6权限 [SA04020502  委托代销明细账打印] 升级至V11.1权限[SA040205_03  打印委托代销明细账]
	insert into #t6auth (t6authid,u8authid) values(N'SA04020503',N'SA040205_04')-- T6权限 [SA04020503  委托代销明细账输出] 升级至V11.1权限[SA040205_04  输出委托代销明细账]
	insert into #t6auth (t6authid,u8authid) values(N'SA040206',N'SA040206_01')-- T6权限 [SA040206  发货明细表查询] 升级至V11.1权限[SA040206_01  查询发货明细表]
	insert into #t6auth (t6authid,u8authid) values(N'SA04020601',N'SA040206')-- T6权限 [SA04020601  发货明细表] 升级至V11.1权限[SA040206  发货明细表]
	insert into #t6auth (t6authid,u8authid) values(N'SA04020602',N'SA040206_03')-- T6权限 [SA04020602  发货明细表打印] 升级至V11.1权限[SA040206_03  打印发货明细表]
	insert into #t6auth (t6authid,u8authid) values(N'SA04020603',N'SA040206_04')-- T6权限 [SA04020603  发货明细表输出] 升级至V11.1权限[SA040206_04  输出发货明细表]
	insert into #t6auth (t6authid,u8authid) values(N'SA040207',N'SA040207_01')-- T6权限 [SA040207  销售明细表查询] 升级至V11.1权限[SA040207_01  查询销售明细表]
	insert into #t6auth (t6authid,u8authid) values(N'SA04020701',N'SA040207')-- T6权限 [SA04020701  销售明细表] 升级至V11.1权限[SA040207  销售明细表]
	insert into #t6auth (t6authid,u8authid) values(N'SA04020702',N'SA040207_03')-- T6权限 [SA04020702  销售明细表打印] 升级至V11.1权限[SA040207_03  打印销售明细表]
	insert into #t6auth (t6authid,u8authid) values(N'SA04020703',N'SA040207_04')-- T6权限 [SA04020703  销售明细表输出] 升级至V11.1权限[SA040207_04  输出销售明细表]
	insert into #t6auth (t6authid,u8authid) values(N'SA040401',N'SA040401_01')-- T6权限 [SA040401  销售统计表查询] 升级至V11.1权限[SA040401_01  查询销售统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA04040101',N'SA040401')-- T6权限 [SA04040101  销售统计表] 升级至V11.1权限[SA040401  销售统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA04040102',N'SA040401_03')-- T6权限 [SA04040102  销售统计表打印] 升级至V11.1权限[SA040401_03  打印销售统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA04040103',N'SA040401_04')-- T6权限 [SA04040103  销售统计表输出] 升级至V11.1权限[SA040401_04  输出销售统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA040403',N'SA040403_01')-- T6权限 [SA040403  发货统计表查询] 升级至V11.1权限[SA040403_01  查询发货统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA04040301',N'SA040403')-- T6权限 [SA04040301  发货统计表] 升级至V11.1权限[SA040403  发货统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA04040302',N'SA040403_03')-- T6权限 [SA04040302  发货统计表打印] 升级至V11.1权限[SA040403_03  打印发货统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA04040303',N'SA040403_04')-- T6权限 [SA04040303  发货统计表输出] 升级至V11.1权限[SA040403_04  输出发货统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA040405',N'SA040405_01')-- T6权限 [SA040405  发货单开票收款勾对表查询] 升级至V11.1权限[SA040405_01  查询发货单开票收款勾对表]
	insert into #t6auth (t6authid,u8authid) values(N'SA04040501',N'SA040405')-- T6权限 [SA04040501  发货单开票收款勾对表] 升级至V11.1权限[SA040405  发货单开票收款勾对表]
	insert into #t6auth (t6authid,u8authid) values(N'SA04040502',N'SA040405_03')-- T6权限 [SA04040502  发货单开票收款勾对表打印] 升级至V11.1权限[SA040405_03  打印发货单开票收款勾对表]
	insert into #t6auth (t6authid,u8authid) values(N'SA04040503',N'SA040405_04')-- T6权限 [SA04040503  发货单开票收款勾对表输出] 升级至V11.1权限[SA040405_04  输出发货单开票收款勾对表]
	insert into #t6auth (t6authid,u8authid) values(N'SA040406',N'SA040406_01')-- T6权限 [SA040406  销售综合统计表查询] 升级至V11.1权限[SA040406_01  查询销售综合统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA04040601',N'SA040406')-- T6权限 [SA04040601  销售综合统计表] 升级至V11.1权限[SA040406  销售综合统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA04040602',N'SA040406_03')-- T6权限 [SA04040602  销售综合统计表打印] 升级至V11.1权限[SA040406_03  打印销售综合统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA04040603',N'SA040406_04')-- T6权限 [SA04040603  销售综合统计表输出] 升级至V11.1权限[SA040406_04  输出销售综合统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA040407',N'SA040407_01')-- T6权限 [SA040407  发票日报查询] 升级至V11.1权限[SA040407_01  查询发票日报]
	insert into #t6auth (t6authid,u8authid) values(N'SA04040701',N'SA040407')-- T6权限 [SA04040701  发票日报] 升级至V11.1权限[SA040407  发票日报]
	insert into #t6auth (t6authid,u8authid) values(N'SA04040702',N'SA040407_03')-- T6权限 [SA04040702  发票日报打印] 升级至V11.1权限[SA040407_03  打印发票日报]
	insert into #t6auth (t6authid,u8authid) values(N'SA04040703',N'SA040407_04')-- T6权限 [SA04040703  发票日报输出] 升级至V11.1权限[SA040407_04  输出发票日报]
	insert into #t6auth (t6authid,u8authid) values(N'SA040408',N'SA040408_01')-- T6权限 [SA040408  发票使用明细表查询] 升级至V11.1权限[SA040408_01  查询销售发票使用明细表]
	insert into #t6auth (t6authid,u8authid) values(N'SA04040801',N'SA040408')-- T6权限 [SA04040801  发票使用明细表] 升级至V11.1权限[SA040408  销售发票使用明细表]
	insert into #t6auth (t6authid,u8authid) values(N'SA04040802',N'SA040408_03')-- T6权限 [SA04040802  发票使用明细表打印] 升级至V11.1权限[SA040408_03  打印销售发票使用明细表]
	insert into #t6auth (t6authid,u8authid) values(N'SA04040803',N'SA040408_04')-- T6权限 [SA04040803  发票使用明细表输出] 升级至V11.1权限[SA040408_04  输出销售发票使用明细表]
	insert into #t6auth (t6authid,u8authid) values(N'SA040409',N'SA040409_01')-- T6权限 [SA040409  委托代销统计表查询] 升级至V11.1权限[SA040409_01  查询委托代销统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA04040901',N'SA040409')-- T6权限 [SA04040901  委托代销统计表] 升级至V11.1权限[SA040409  委托代销统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA04040902',N'SA040409_03')-- T6权限 [SA04040902  委托代销统计表打印] 升级至V11.1权限[SA040409_03  打印委托代销统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA04040903',N'SA040409_04')-- T6权限 [SA04040903  委托代销统计表输出] 升级至V11.1权限[SA040409_04  输出委托代销统计表]
	insert into #t6auth (t6authid,u8authid) values(N'SA040410',N'SA040410_01')-- T6权限 [SA040410  信用余额表查询] 升级至V11.1权限[SA040410_01  查询信用余额表]
	insert into #t6auth (t6authid,u8authid) values(N'SA04041001',N'SA040410')-- T6权限 [SA04041001  信用余额表] 升级至V11.1权限[SA040410  信用余额表]
	insert into #t6auth (t6authid,u8authid) values(N'SA04041002',N'SA040410_03')-- T6权限 [SA04041002  信用余额表打印] 升级至V11.1权限[SA040410_03  打印信用余额表]
	insert into #t6auth (t6authid,u8authid) values(N'SA04041003',N'SA040410_04')-- T6权限 [SA04041003  信用余额表输出] 升级至V11.1权限[SA040410_04  输出信用余额表]
	insert into #t6auth (t6authid,u8authid) values(N'SA040501',N'SA040501_01')-- T6权限 [SA040501  销售增长分析查询] 升级至V11.1权限[SA040501_01  查询销售增长分析]
	insert into #t6auth (t6authid,u8authid) values(N'SA04050101',N'SA040501')-- T6权限 [SA04050101  销售增长分析] 升级至V11.1权限[SA040501  销售增长分析]
	insert into #t6auth (t6authid,u8authid) values(N'SA04050102',N'SA040501_03')-- T6权限 [SA04050102  销售增长分析打印] 升级至V11.1权限[SA040501_03  打印销售增长分析]
	insert into #t6auth (t6authid,u8authid) values(N'SA04050103',N'SA040501_04')-- T6权限 [SA04050103  销售增长分析输出] 升级至V11.1权限[SA040501_04  输出销售增长分析]
	insert into #t6auth (t6authid,u8authid) values(N'SA040502',N'SA040502_01')-- T6权限 [SA040502  货物流向分析查询] 升级至V11.1权限[SA040502_01  查询货物流向分析]
	insert into #t6auth (t6authid,u8authid) values(N'SA04050201',N'SA040502')-- T6权限 [SA04050201  货物流向分析] 升级至V11.1权限[SA040502  货物流向分析]
	insert into #t6auth (t6authid,u8authid) values(N'SA04050202',N'SA040502_03')-- T6权限 [SA04050202  货物流向分析打印] 升级至V11.1权限[SA040502_03  打印货物流向分析]
	insert into #t6auth (t6authid,u8authid) values(N'SA04050203',N'SA040502_04')-- T6权限 [SA04050203  货物流向分析输出] 升级至V11.1权限[SA040502_04  输出货物流向分析]
	insert into #t6auth (t6authid,u8authid) values(N'SA040503',N'SA040503_01')-- T6权限 [SA040503  销售结构分析查询] 升级至V11.1权限[SA040503_01  查询销售结构分析]
	insert into #t6auth (t6authid,u8authid) values(N'SA04050301',N'SA040503')-- T6权限 [SA04050301  销售结构分析] 升级至V11.1权限[SA040503  销售结构分析]
	insert into #t6auth (t6authid,u8authid) values(N'SA04050302',N'SA040503_03')-- T6权限 [SA04050302  销售结构分析打印] 升级至V11.1权限[SA040503_03  打印销售结构分析]
	insert into #t6auth (t6authid,u8authid) values(N'SA04050303',N'SA040503_04')-- T6权限 [SA04050303  销售结构分析输出] 升级至V11.1权限[SA040503_04  输出销售结构分析]
	insert into #t6auth (t6authid,u8authid) values(N'SA040504',N'SA040504_01')-- T6权限 [SA040504  销售毛利分析查询] 升级至V11.1权限[SA040504_01  查询销售毛利分析]
	insert into #t6auth (t6authid,u8authid) values(N'SA04050401',N'SA040504')-- T6权限 [SA04050401  销售毛利分析] 升级至V11.1权限[SA040504  销售毛利分析]
	insert into #t6auth (t6authid,u8authid) values(N'SA04050402',N'SA040504_03')-- T6权限 [SA04050402  销售毛利分析打印] 升级至V11.1权限[SA040504_03  打印销售毛利分析]
	insert into #t6auth (t6authid,u8authid) values(N'SA04050403',N'SA040504_04')-- T6权限 [SA04050403  销售毛利分析输出] 升级至V11.1权限[SA040504_04  输出销售毛利分析]
	insert into #t6auth (t6authid,u8authid) values(N'SA040505',N'SA040505_01')-- T6权限 [SA040505  市场分析查询] 升级至V11.1权限[SA040505_01  查询市场分析]
	insert into #t6auth (t6authid,u8authid) values(N'SA04050501',N'SA040505')-- T6权限 [SA04050501  市场分析] 升级至V11.1权限[SA040505  市场分析]
	insert into #t6auth (t6authid,u8authid) values(N'SA04050502',N'SA040505_03')-- T6权限 [SA04050502  市场分析打印] 升级至V11.1权限[SA040505_03  打印市场分析]
	insert into #t6auth (t6authid,u8authid) values(N'SA04050503',N'SA040505_04')-- T6权限 [SA04050503  市场分析输出] 升级至V11.1权限[SA040505_04  输出市场分析]
	insert into #t6auth (t6authid,u8authid) values(N'SA04050601',N'SA04050601_01')-- T6权限 [SA04050601  按发票查询] 升级至V11.1权限[SA04050601_01  查询货龄分析按发票]
	insert into #t6auth (t6authid,u8authid) values(N'SA0405060101',N'SA04050601')-- T6权限 [SA0405060101  按发票] 升级至V11.1权限[SA04050601  按发票货龄分析]
	insert into #t6auth (t6authid,u8authid) values(N'SA0405060102',N'SA04050601_03')-- T6权限 [SA0405060102  按发票打印] 升级至V11.1权限[SA04050601_03  打印货龄分析按发票]
	insert into #t6auth (t6authid,u8authid) values(N'SA0405060103',N'SA04050601_04')-- T6权限 [SA0405060103  按发票输出] 升级至V11.1权限[SA04050601_04  输出货龄分析按发票]
	insert into #t6auth (t6authid,u8authid) values(N'SA04050602',N'SA04050602_01')-- T6权限 [SA04050602  按收款查询] 升级至V11.1权限[SA04050602_01  查询按收款]
	insert into #t6auth (t6authid,u8authid) values(N'SA0405060201',N'SA04050602')-- T6权限 [SA0405060201  按收款] 升级至V11.1权限[SA04050602  按收款货龄分析]
	insert into #t6auth (t6authid,u8authid) values(N'SA0405060202',N'SA04050602_03')-- T6权限 [SA0405060202  按收款打印] 升级至V11.1权限[SA04050602_03  打印按收款]
	insert into #t6auth (t6authid,u8authid) values(N'SA0405060203',N'SA04050602_04')-- T6权限 [SA0405060203  按收款输出] 升级至V11.1权限[SA04050602_04  输出按收款]
	insert into #t6auth (t6authid,u8authid) values(N'SAM030106',N'SA03011100')-- T6权限 [SAM030106  销售订单跟踪] 升级至V11.1权限[SA03011100  订单跟踪明细表查询]
	insert into #t6auth (t6authid,u8authid) values(N'ST000108',N'ST000106')-- T6权限 [ST000108  期初结存删除] 升级至V11.1权限[ST000106  期初结存删除]
	insert into #t6auth (t6authid,u8authid) values(N'ST000307',N'ST000305')-- T6权限 [ST000307  期初不合格品单删除] 升级至V11.1权限[ST000305  期初不合格品删除]
	insert into #t6auth (t6authid,u8authid) values(N'ST010112',N'ST010121')-- T6权限 [ST010112  调拨单打印] 升级至V11.1权限[ST010121  调拨单打印]
	insert into #t6auth (t6authid,u8authid) values(N'ST010114',N'ST010122')-- T6权限 [ST010114  调拨单输出] 升级至V11.1权限[ST010122  调拨单输出]
	insert into #t6auth (t6authid,u8authid) values(N'ST010115',N'ST010107')-- T6权限 [ST010115  调拨单删除] 升级至V11.1权限[ST010107  调拨单删除]
	insert into #t6auth (t6authid,u8authid) values(N'ST010116',N'ST010123')-- T6权限 [ST010116  调拨单列表打印] 升级至V11.1权限[ST010123  调拨单列表打印]
	insert into #t6auth (t6authid,u8authid) values(N'ST010117',N'ST010124')-- T6权限 [ST010117  调拨单列表输出] 升级至V11.1权限[ST010124  调拨单列表输出]
	insert into #t6auth (t6authid,u8authid) values(N'ST010211',N'ST010221')-- T6权限 [ST010211  盘点单打印] 升级至V11.1权限[ST010221  盘点单打印]
	insert into #t6auth (t6authid,u8authid) values(N'ST010213',N'ST010222')-- T6权限 [ST010213  盘点单输出] 升级至V11.1权限[ST010222  盘点单输出]
	insert into #t6auth (t6authid,u8authid) values(N'ST010214',N'ST010206')-- T6权限 [ST010214  盘点单删除] 升级至V11.1权限[ST010206  盘点单删除]
	insert into #t6auth (t6authid,u8authid) values(N'ST010215',N'ST010223')-- T6权限 [ST010215  盘点单列表打印] 升级至V11.1权限[ST010223  盘点单列表打印]
	insert into #t6auth (t6authid,u8authid) values(N'ST010216',N'ST010224')-- T6权限 [ST010216  盘点单列表输出] 升级至V11.1权限[ST010224  盘点单列表输出]
	insert into #t6auth (t6authid,u8authid) values(N'ST010306',N'ST010307')-- T6权限 [ST010306  组装单打印] 升级至V11.1权限[ST010307  组装单打印]
	insert into #t6auth (t6authid,u8authid) values(N'ST010308',N'ST010308')-- T6权限 [ST010308  组装单输出] 升级至V11.1权限[ST010308  组装单输出]
	insert into #t6auth (t6authid,u8authid) values(N'ST010309',N'ST010306')-- T6权限 [ST010309  组装单删除] 升级至V11.1权限[ST010306  组装单删除]
	insert into #t6auth (t6authid,u8authid) values(N'ST010310',N'ST010309')-- T6权限 [ST010310  组装单列表打印] 升级至V11.1权限[ST010309  组装单列表打印]
	insert into #t6auth (t6authid,u8authid) values(N'ST010311',N'ST010310')-- T6权限 [ST010311  组装单列表输出] 升级至V11.1权限[ST010310  组装单列表输出]
	insert into #t6auth (t6authid,u8authid) values(N'ST010406',N'ST010407')-- T6权限 [ST010406  拆卸单打印] 升级至V11.1权限[ST010407  拆卸单打印]
	insert into #t6auth (t6authid,u8authid) values(N'ST010408',N'ST010408')-- T6权限 [ST010408  拆卸单输出] 升级至V11.1权限[ST010408  拆卸单输出]
	insert into #t6auth (t6authid,u8authid) values(N'ST010409',N'ST010406')-- T6权限 [ST010409  拆卸单删除] 升级至V11.1权限[ST010406  拆卸单删除]
	insert into #t6auth (t6authid,u8authid) values(N'ST010410',N'ST010409')-- T6权限 [ST010410  拆卸单列表打印] 升级至V11.1权限[ST010409  拆卸单列表打印]
	insert into #t6auth (t6authid,u8authid) values(N'ST010411',N'ST010410')-- T6权限 [ST010411  拆卸单列表输出] 升级至V11.1权限[ST010410  拆卸单列表输出]
	insert into #t6auth (t6authid,u8authid) values(N'ST010506',N'ST010507')-- T6权限 [ST010506  形态转换单打印] 升级至V11.1权限[ST010507  形态转换单打印]
	insert into #t6auth (t6authid,u8authid) values(N'ST010508',N'ST010508')-- T6权限 [ST010508  形态转换单输出] 升级至V11.1权限[ST010508  形态转换单输出]
	insert into #t6auth (t6authid,u8authid) values(N'ST010509',N'ST010506')-- T6权限 [ST010509  形态转换单删除] 升级至V11.1权限[ST010506  形态转换单删除]
	insert into #t6auth (t6authid,u8authid) values(N'ST010510',N'ST010509')-- T6权限 [ST010510  形态转换单列表打印] 升级至V11.1权限[ST010509  形态转换单列表打印]
	insert into #t6auth (t6authid,u8authid) values(N'ST010511',N'ST010510')-- T6权限 [ST010511  形态转换单列表输出] 升级至V11.1权限[ST010510  形态转换单列表输出]
	insert into #t6auth (t6authid,u8authid) values(N'ST010714',N'ST010712')-- T6权限 [ST010714  限额领料单打印] 升级至V11.1权限[ST010712  限额领料单打印]
	insert into #t6auth (t6authid,u8authid) values(N'ST010716',N'ST010713')-- T6权限 [ST010716  限额领料单输出] 升级至V11.1权限[ST010713  限额领料单输出]
	insert into #t6auth (t6authid,u8authid) values(N'ST010717',N'ST010711')-- T6权限 [ST010717  限额领料单删除] 升级至V11.1权限[ST010711  限额领料单删除]
	insert into #t6auth (t6authid,u8authid) values(N'ST010720',N'ST010714')-- T6权限 [ST010720  限额领料单列表打印] 升级至V11.1权限[ST010714  限额领料单列表打印]
	insert into #t6auth (t6authid,u8authid) values(N'ST010721',N'ST010715')-- T6权限 [ST010721  限额领料单列表输出] 升级至V11.1权限[ST010715  限额领料单列表输出]
	insert into #t6auth (t6authid,u8authid) values(N'ST010811',N'ST010811_01')-- T6权限 [ST010811  货位卡片查询] 升级至V11.1权限[ST010811_01  货位卡片查询]
	insert into #t6auth (t6authid,u8authid) values(N'ST01081101',N'ST010811')-- T6权限 [ST01081101  货位卡片] 升级至V11.1权限[ST010811  货位卡片]
	insert into #t6auth (t6authid,u8authid) values(N'ST01081102',N'ST010811_03')-- T6权限 [ST01081102  货位卡片打印] 升级至V11.1权限[ST010811_03  货位卡片打印]
	insert into #t6auth (t6authid,u8authid) values(N'ST01081103',N'ST010811_04')-- T6权限 [ST01081103  货位卡片输出] 升级至V11.1权限[ST010811_04  货位卡片输出]
	insert into #t6auth (t6authid,u8authid) values(N'ST010812',N'ST010812')-- T6权限 [ST010812  货位汇总表查询] 升级至V11.1权限[ST010812  货位收发存汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'ST01081201',N'ST010812_01')-- T6权限 [ST01081201  货位汇总表] 升级至V11.1权限[ST010812_01  查询货位汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'ST01081202',N'ST010812_03')-- T6权限 [ST01081202  货位汇总表打印] 升级至V11.1权限[ST010812_03  打印货位汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'ST01081203',N'ST010812_04')-- T6权限 [ST01081203  货位汇总表输出] 升级至V11.1权限[ST010812_04  输出货位汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'ST010814',N'ST010809')-- T6权限 [ST010814  货位调整单打印] 升级至V11.1权限[ST010809  货位调整单打印]
	insert into #t6auth (t6authid,u8authid) values(N'ST010816',N'ST010810')-- T6权限 [ST010816  货位调整单输出] 升级至V11.1权限[ST010810  货位调整单输出]
	insert into #t6auth (t6authid,u8authid) values(N'ST010818',N'ST010814')-- T6权限 [ST010818  货位调整单列表打印] 升级至V11.1权限[ST010814  货位调整单列表打印]
	insert into #t6auth (t6authid,u8authid) values(N'ST010819',N'ST010815')-- T6权限 [ST010819  货位调整单列表输出] 升级至V11.1权限[ST010815  货位调整单列表输出]
	insert into #t6auth (t6authid,u8authid) values(N'ST01090106',N'ST01090121')-- T6权限 [ST01090106  不合格品记录单打印] 升级至V11.1权限[ST01090121  不合格品记录单打印]
	insert into #t6auth (t6authid,u8authid) values(N'ST01090108',N'ST01090122')-- T6权限 [ST01090108  不合格品记录单输出] 升级至V11.1权限[ST01090122  不合格品记录单输出]
	insert into #t6auth (t6authid,u8authid) values(N'ST01090109',N'ST01090106')-- T6权限 [ST01090109  不合格品记录单删除] 升级至V11.1权限[ST01090106  不合格品记录单删除]
	insert into #t6auth (t6authid,u8authid) values(N'ST01090110',N'ST01090123')-- T6权限 [ST01090110  不合格品记录单列表打印] 升级至V11.1权限[ST01090123  不合格品记录单列表打印]
	insert into #t6auth (t6authid,u8authid) values(N'ST01090111',N'ST01090124')-- T6权限 [ST01090111  不合格品记录单列表输出] 升级至V11.1权限[ST01090124  不合格品记录单列表输出]
	insert into #t6auth (t6authid,u8authid) values(N'ST01090206',N'ST01090221')-- T6权限 [ST01090206  不合格品处理单打印] 升级至V11.1权限[ST01090221  不合格品处理单打印]
	insert into #t6auth (t6authid,u8authid) values(N'ST01090208',N'ST01090222')-- T6权限 [ST01090208  不合格品处理单输出] 升级至V11.1权限[ST01090222  不合格品处理单输出]
	insert into #t6auth (t6authid,u8authid) values(N'ST01090209',N'ST01090206')-- T6权限 [ST01090209  不合格品处理单删除] 升级至V11.1权限[ST01090206  不合格品处理单删除]
	insert into #t6auth (t6authid,u8authid) values(N'ST01090210',N'ST01090223')-- T6权限 [ST01090210  不合格品处理单列表打印] 升级至V11.1权限[ST01090223  不合格品处理单列表打印]
	insert into #t6auth (t6authid,u8authid) values(N'ST01090211',N'ST01090224')-- T6权限 [ST01090211  不合格品处理单列表输出] 升级至V11.1权限[ST01090224  不合格品处理单列表输出]
	insert into #t6auth (t6authid,u8authid) values(N'ST0119',N'ST011301')-- T6权限 [ST0119  调拨申请单] 升级至V11.1权限[ST011301  调拨申请单]
	insert into #t6auth (t6authid,u8authid) values(N'ST011901',N'ST01130101')-- T6权限 [ST011901  调拨申请单查询] 升级至V11.1权限[ST01130101  调拨申请单查询]
	insert into #t6auth (t6authid,u8authid) values(N'ST011902',N'ST01130102')-- T6权限 [ST011902  调拨申请单录入] 升级至V11.1权限[ST01130102  调拨申请单编辑]
	insert into #t6auth (t6authid,u8authid) values(N'ST011903',N'ST01130105')-- T6权限 [ST011903  调拨申请单审核] 升级至V11.1权限[ST01130105  调拨申请单审核]
	insert into #t6auth (t6authid,u8authid) values(N'ST011904',N'ST01130106')-- T6权限 [ST011904  调拨申请单弃审] 升级至V11.1权限[ST01130106  调拨申请单弃审]
	insert into #t6auth (t6authid,u8authid) values(N'ST011905',N'ST01130104')-- T6权限 [ST011905  调拨申请单关闭] 升级至V11.1权限[ST01130104  调拨申请单关闭]
	insert into #t6auth (t6authid,u8authid) values(N'ST011911',N'ST01130121')-- T6权限 [ST011911  调拨申请单打印] 升级至V11.1权限[ST01130121  调拨申请单打印]
	insert into #t6auth (t6authid,u8authid) values(N'ST011913',N'ST01130122')-- T6权限 [ST011913  调拨申请单输出] 升级至V11.1权限[ST01130122  调拨申请单输出]
	insert into #t6auth (t6authid,u8authid) values(N'ST011914',N'ST01130107')-- T6权限 [ST011914  调拨申请单删除] 升级至V11.1权限[ST01130107  调拨申请单删除]
	insert into #t6auth (t6authid,u8authid) values(N'ST011916',N'ST01130123')-- T6权限 [ST011916  调拨申请单列表打印] 升级至V11.1权限[ST01130123  调拨申请单列表打印]
	insert into #t6auth (t6authid,u8authid) values(N'ST011917',N'ST01130124')-- T6权限 [ST011917  调拨申请单列表输出] 升级至V11.1权限[ST01130124  调拨申请单列表输出]
	insert into #t6auth (t6authid,u8authid) values(N'ST020101',N'ST020101_01')-- T6权限 [ST020101  流水账查询] 升级至V11.1权限[ST020101_01  查询出入库流水账]
	insert into #t6auth (t6authid,u8authid) values(N'ST02010101',N'ST020101')-- T6权限 [ST02010101  流水账] 升级至V11.1权限[ST020101  出入库流水账]
	insert into #t6auth (t6authid,u8authid) values(N'ST02010102',N'ST020101_03')-- T6权限 [ST02010102  流水账打印] 升级至V11.1权限[ST020101_03  打印出入库流水账]
	insert into #t6auth (t6authid,u8authid) values(N'ST02010103',N'ST020101_04')-- T6权限 [ST02010103  流水账输出] 升级至V11.1权限[ST020101_04  输出出入库流水账]
	insert into #t6auth (t6authid,u8authid) values(N'ST020102',N'ST020102_01')-- T6权限 [ST020102  库存台帐查询] 升级至V11.1权限[ST020102_01  库存台账查询]
	insert into #t6auth (t6authid,u8authid) values(N'ST02010201',N'ST020102')-- T6权限 [ST02010201  库存台帐] 升级至V11.1权限[ST020102  库存台账]
	insert into #t6auth (t6authid,u8authid) values(N'ST02010202',N'ST020102_03')-- T6权限 [ST02010202  库存台帐打印] 升级至V11.1权限[ST020102_03  库存台账打印]
	insert into #t6auth (t6authid,u8authid) values(N'ST02010203',N'ST020102_04')-- T6权限 [ST02010203  库存台帐输出] 升级至V11.1权限[ST020102_04  库存台账输出]
	insert into #t6auth (t6authid,u8authid) values(N'ST020103',N'ST020103_01')-- T6权限 [ST020103  批次台账查询] 升级至V11.1权限[ST020103_01  批次台账查询]
	insert into #t6auth (t6authid,u8authid) values(N'ST02010301',N'ST020103')-- T6权限 [ST02010301  批次台账] 升级至V11.1权限[ST020103  批次台账]
	insert into #t6auth (t6authid,u8authid) values(N'ST02010302',N'ST020103_03')-- T6权限 [ST02010302  批次台账打印] 升级至V11.1权限[ST020103_03  批次台账打印]
	insert into #t6auth (t6authid,u8authid) values(N'ST02010303',N'ST020103_04')-- T6权限 [ST02010303  批次台账输出] 升级至V11.1权限[ST020103_04  批次台账输出]
	insert into #t6auth (t6authid,u8authid) values(N'ST020104',N'ST020104_01')-- T6权限 [ST020104  受托代销备查簿查询] 升级至V11.1权限[ST020104_01  受托代销备查簿查询]
	insert into #t6auth (t6authid,u8authid) values(N'ST02010401',N'ST020104')-- T6权限 [ST02010401  受托代销备查簿] 升级至V11.1权限[ST020104  受托代销备查簿]
	insert into #t6auth (t6authid,u8authid) values(N'ST02010402',N'ST020104_03')-- T6权限 [ST02010402  受托代销备查簿打印] 升级至V11.1权限[ST020104_03  受托代销备查簿打印]
	insert into #t6auth (t6authid,u8authid) values(N'ST02010403',N'ST020104_04')-- T6权限 [ST02010403  受托代销备查簿输出] 升级至V11.1权限[ST020104_04  受托代销备查簿输出]
	insert into #t6auth (t6authid,u8authid) values(N'ST020105',N'ST020104_01')-- T6权限 [ST020105  受托代销备查簿查询] 升级至V11.1权限[ST020104_01  受托代销备查簿查询]
	insert into #t6auth (t6authid,u8authid) values(N'ST02010501',N'ST020105')-- T6权限 [ST02010501  委托代销备查簿] 升级至V11.1权限[ST020105  委托代销备查簿]
	insert into #t6auth (t6authid,u8authid) values(N'ST02010502',N'ST020105_03')-- T6权限 [ST02010502  委托代销备查簿打印] 升级至V11.1权限[ST020105_03  委托代销备查簿打印]
	insert into #t6auth (t6authid,u8authid) values(N'ST02010503',N'ST020105_04')-- T6权限 [ST02010503  委托代销备查簿输出] 升级至V11.1权限[ST020105_04  委托代销备查簿输出]
	insert into #t6auth (t6authid,u8authid) values(N'ST020106',N'ST020106_01')-- T6权限 [ST020106  呆滞积压备查簿查询] 升级至V11.1权限[ST020106_01  呆滞积压备查簿查询]
	insert into #t6auth (t6authid,u8authid) values(N'ST02010601',N'ST020106')-- T6权限 [ST02010601  呆滞积压备查簿] 升级至V11.1权限[ST020106  呆滞积压备查簿]
	insert into #t6auth (t6authid,u8authid) values(N'ST02010602',N'ST020106_03')-- T6权限 [ST02010602  呆滞积压备查簿打印] 升级至V11.1权限[ST020106_03  呆滞积压备查簿打印]
	insert into #t6auth (t6authid,u8authid) values(N'ST02010603',N'ST020106_04')-- T6权限 [ST02010603  呆滞积压备查簿输出] 升级至V11.1权限[ST020106_04  呆滞积压备查簿输出]
	insert into #t6auth (t6authid,u8authid) values(N'ST020107',N'ST020107_01')-- T6权限 [ST020107  现存量查询] 升级至V11.1权限[ST020107_01  现存量查询]
	insert into #t6auth (t6authid,u8authid) values(N'ST02010701',N'ST020107')-- T6权限 [ST02010701  现存量] 升级至V11.1权限[ST020107  现存量查询]
	insert into #t6auth (t6authid,u8authid) values(N'ST02010702',N'ST020107_03')-- T6权限 [ST02010702  现存量打印] 升级至V11.1权限[ST020107_03  现存量打印]
	insert into #t6auth (t6authid,u8authid) values(N'ST02010703',N'ST020107_04')-- T6权限 [ST02010703  现存量输出] 升级至V11.1权限[ST020107_04  现存量输出]
	insert into #t6auth (t6authid,u8authid) values(N'ST020109',N'ST020109_01')-- T6权限 [ST020109  代管账查询] 升级至V11.1权限[ST020109_01  查询代管账]
	insert into #t6auth (t6authid,u8authid) values(N'ST02010901',N'ST020109')-- T6权限 [ST02010901  代管账] 升级至V11.1权限[ST020109  代管账]
	insert into #t6auth (t6authid,u8authid) values(N'ST02010902',N'ST020109_03')-- T6权限 [ST02010902  代管账打印] 升级至V11.1权限[ST020109_03  打印代管账]
	insert into #t6auth (t6authid,u8authid) values(N'ST02010903',N'ST020109_04')-- T6权限 [ST02010903  代管账输出] 升级至V11.1权限[ST020109_04  输出代管账]
	insert into #t6auth (t6authid,u8authid) values(N'ST020111',N'ST020111_01')-- T6权限 [ST020111  入库跟踪表查询] 升级至V11.1权限[ST020111_01  入库跟踪表查询]
	insert into #t6auth (t6authid,u8authid) values(N'ST02011101',N'ST020111')-- T6权限 [ST02011101  入库跟踪表] 升级至V11.1权限[ST020111  入库跟踪表]
	insert into #t6auth (t6authid,u8authid) values(N'ST02011102',N'ST020111_03')-- T6权限 [ST02011102  入库跟踪表打印] 升级至V11.1权限[ST020111_03  入库跟踪表打印]
	insert into #t6auth (t6authid,u8authid) values(N'ST02011103',N'ST020111_04')-- T6权限 [ST02011103  入库跟踪表输出] 升级至V11.1权限[ST020111_04  入库跟踪表输出]
	insert into #t6auth (t6authid,u8authid) values(N'ST020113',N'ST020113_01')-- T6权限 [ST020113  不合格品备查簿查询] 升级至V11.1权限[ST020113_01  不合格品备查簿查询]
	insert into #t6auth (t6authid,u8authid) values(N'ST02011301',N'ST020113')-- T6权限 [ST02011301  不合格品备查簿] 升级至V11.1权限[ST020113  不合格品备查簿]
	insert into #t6auth (t6authid,u8authid) values(N'ST02011302',N'ST020113_03')-- T6权限 [ST02011302  不合格品备查簿打印] 升级至V11.1权限[ST020113_03  不合格品备查簿打印]
	insert into #t6auth (t6authid,u8authid) values(N'ST02011303',N'ST020113_04')-- T6权限 [ST02011303  不合格品备查簿输出] 升级至V11.1权限[ST020113_04  不合格品备查簿输出]
	insert into #t6auth (t6authid,u8authid) values(N'ST020201',N'ST020201_01')-- T6权限 [ST020201  安全库存预警查询] 升级至V11.1权限[ST020201_01  查询安全库存预警]
	insert into #t6auth (t6authid,u8authid) values(N'ST02020101',N'ST020201')-- T6权限 [ST02020101  安全库存预警] 升级至V11.1权限[ST020201  安全库存预警]
	insert into #t6auth (t6authid,u8authid) values(N'ST02020102',N'ST020201_03')-- T6权限 [ST02020102  安全库存预警打印] 升级至V11.1权限[ST020201_03  打印安全库存预警]
	insert into #t6auth (t6authid,u8authid) values(N'ST02020103',N'ST020201_04')-- T6权限 [ST02020103  安全库存预警输出] 升级至V11.1权限[ST020201_04  输出安全库存预警]
	insert into #t6auth (t6authid,u8authid) values(N'ST020202',N'ST020202_01')-- T6权限 [ST020202  超储存货查询] 升级至V11.1权限[ST020202_01  查询超储存货查询]
	insert into #t6auth (t6authid,u8authid) values(N'ST02020201',N'ST020202')-- T6权限 [ST02020201  超储存货] 升级至V11.1权限[ST020202  超储存货查询]
	insert into #t6auth (t6authid,u8authid) values(N'ST02020202',N'ST020202_03')-- T6权限 [ST02020202  超储存货打印] 升级至V11.1权限[ST020202_03  打印超储存货查询]
	insert into #t6auth (t6authid,u8authid) values(N'ST02020203',N'ST020202_04')-- T6权限 [ST02020203  超储存货输出] 升级至V11.1权限[ST020202_04  输出超储存货查询]
	insert into #t6auth (t6authid,u8authid) values(N'ST020203',N'ST020203_01')-- T6权限 [ST020203  短缺存货查询] 升级至V11.1权限[ST020203_01  查询短缺存货查询]
	insert into #t6auth (t6authid,u8authid) values(N'ST02020301',N'ST020203')-- T6权限 [ST02020301  短缺存货] 升级至V11.1权限[ST020203  短缺存货查询]
	insert into #t6auth (t6authid,u8authid) values(N'ST02020302',N'ST020203_03')-- T6权限 [ST02020302  短缺存货打印] 升级至V11.1权限[ST020203_03  打印短缺存货查询]
	insert into #t6auth (t6authid,u8authid) values(N'ST02020303',N'ST020203_04')-- T6权限 [ST02020303  短缺存货输出] 升级至V11.1权限[ST020203_04  输出短缺存货查询]
	insert into #t6auth (t6authid,u8authid) values(N'ST020204',N'ST020204_01')-- T6权限 [ST020204  呆滞积压分析查询] 升级至V11.1权限[ST020204_01  查询呆滞积压存货分析]
	insert into #t6auth (t6authid,u8authid) values(N'ST02020401',N'ST020204')-- T6权限 [ST02020401  呆滞积压分析] 升级至V11.1权限[ST020204  呆滞积压存货分析]
	insert into #t6auth (t6authid,u8authid) values(N'ST02020402',N'ST020204_03')-- T6权限 [ST02020402  呆滞积压分析打印] 升级至V11.1权限[ST020204_03  打印呆滞积压存货分析]
	insert into #t6auth (t6authid,u8authid) values(N'ST02020403',N'ST020204_04')-- T6权限 [ST02020403  呆滞积压分析输出] 升级至V11.1权限[ST020204_04  输出呆滞积压存货分析]
	insert into #t6auth (t6authid,u8authid) values(N'ST020205',N'ST020205_01')-- T6权限 [ST020205  库龄分析查询] 升级至V11.1权限[ST020205_01  查询库龄分析]
	insert into #t6auth (t6authid,u8authid) values(N'ST02020501',N'ST020205')-- T6权限 [ST02020501  库龄分析] 升级至V11.1权限[ST020205  库龄分析]
	insert into #t6auth (t6authid,u8authid) values(N'ST02020502',N'ST020205_03')-- T6权限 [ST02020502  库龄分析打印] 升级至V11.1权限[ST020205_03  打印库龄分析]
	insert into #t6auth (t6authid,u8authid) values(N'ST02020503',N'ST020205_04')-- T6权限 [ST02020503  库龄分析输出] 升级至V11.1权限[ST020205_04  输出库龄分析]
	insert into #t6auth (t6authid,u8authid) values(N'ST020207',N'ST020207_01')-- T6权限 [ST020207  保质期预警查询] 升级至V11.1权限[ST020207_01  查询保质期预警]
	insert into #t6auth (t6authid,u8authid) values(N'ST02020701',N'ST020207')-- T6权限 [ST02020701  保质期预警] 升级至V11.1权限[ST020207  保质期预警]
	insert into #t6auth (t6authid,u8authid) values(N'ST02020702',N'ST020207_03')-- T6权限 [ST02020702  保质期预警打印] 升级至V11.1权限[ST020207_03  打印保质期预警]
	insert into #t6auth (t6authid,u8authid) values(N'ST02020703',N'ST020207_04')-- T6权限 [ST02020703  保质期预警输出] 升级至V11.1权限[ST020207_04  输出保质期预警]
	insert into #t6auth (t6authid,u8authid) values(N'ST020208',N'ST020208_01')-- T6权限 [ST020208  缺料表查询] 升级至V11.1权限[ST020208_01  缺料表查询]
	insert into #t6auth (t6authid,u8authid) values(N'ST02020801',N'ST020208')-- T6权限 [ST02020801  缺料表] 升级至V11.1权限[ST020208  缺料表]
	insert into #t6auth (t6authid,u8authid) values(N'ST02020802',N'ST020208_03')-- T6权限 [ST02020802  缺料表打印] 升级至V11.1权限[ST020208_03  缺料表打印]
	insert into #t6auth (t6authid,u8authid) values(N'ST02020803',N'ST020208_04')-- T6权限 [ST02020803  缺料表输出] 升级至V11.1权限[ST020208_04  缺料表输出]
	insert into #t6auth (t6authid,u8authid) values(N'ST020209',N'ST020209_01')-- T6权限 [ST020209  齐套分析查询] 升级至V11.1权限[ST020209_01  查询库存齐套分析]
	insert into #t6auth (t6authid,u8authid) values(N'ST02020901',N'ST020209')-- T6权限 [ST02020901  齐套分析] 升级至V11.1权限[ST020209  库存齐套分析]
	insert into #t6auth (t6authid,u8authid) values(N'ST02020902',N'ST020209_03')-- T6权限 [ST02020902  齐套分析打印] 升级至V11.1权限[ST020209_03  打印库存齐套分析]
	insert into #t6auth (t6authid,u8authid) values(N'ST02020903',N'ST020209_04')-- T6权限 [ST02020903  齐套分析输出] 升级至V11.1权限[ST020209_04  输出库存齐套分析]
	insert into #t6auth (t6authid,u8authid) values(N'ST020301',N'ST020301_01')-- T6权限 [ST020301  收发存汇总表查询] 升级至V11.1权限[ST020301_01  查询收发存汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'ST02030101',N'ST020301')-- T6权限 [ST02030101  收发存汇总表] 升级至V11.1权限[ST020301  收发存汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'ST02030102',N'ST020301_03')-- T6权限 [ST02030102  收发存汇总表打印] 升级至V11.1权限[ST020301_03  打印收发存汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'ST02030103',N'ST020301_04')-- T6权限 [ST02030103  收发存汇总表输出] 升级至V11.1权限[ST020301_04  输出收发存汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'ST020302',N'ST020302_01')-- T6权限 [ST020302  业务类型汇总表查询] 升级至V11.1权限[ST020302_01  查询业务类型汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'ST02030201',N'ST020302')-- T6权限 [ST02030201  业务类型汇总表] 升级至V11.1权限[ST020302  业务类型汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'ST02030202',N'ST020302_03')-- T6权限 [ST02030202  业务类型汇总表打印] 升级至V11.1权限[ST020302_03  打印业务类型汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'ST02030203',N'ST020302_04')-- T6权限 [ST02030203  业务类型汇总表输出] 升级至V11.1权限[ST020302_04  输出业务类型汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'ST020303',N'ST020303_01')-- T6权限 [ST020303  库存展望查询] 升级至V11.1权限[ST020303_01  库存展望查询]
	insert into #t6auth (t6authid,u8authid) values(N'ST02030301',N'ST020303')-- T6权限 [ST02030301  库存展望] 升级至V11.1权限[ST020303  库存展望]
	insert into #t6auth (t6authid,u8authid) values(N'ST02030302',N'ST020303_03')-- T6权限 [ST02030302  库存展望打印] 升级至V11.1权限[ST020303_03  库存展望打印]
	insert into #t6auth (t6authid,u8authid) values(N'ST02030303',N'ST020303_04')-- T6权限 [ST02030303  库存展望输出] 升级至V11.1权限[ST020303_04  库存展望输出]
	insert into #t6auth (t6authid,u8authid) values(N'ST020304',N'ST020304_01')-- T6权限 [ST020304  供应商库存查询] 升级至V11.1权限[ST020304_01  查询供货单位收发存汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'ST02030401',N'ST020304')-- T6权限 [ST02030401  供应商库存] 升级至V11.1权限[ST020304  供货单位收发存汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'ST02030402',N'ST020304_03')-- T6权限 [ST02030402  供应商库存打印] 升级至V11.1权限[ST020304_03  打印供货单位收发存汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'ST02030403',N'ST020304_04')-- T6权限 [ST02030403  供应商库存输出] 升级至V11.1权限[ST020304_04  输出供货单位收发存汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'ST020305',N'ST020305_01')-- T6权限 [ST020305  批次汇总表查询] 升级至V11.1权限[ST020305_01  查询批次存货汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'ST02030501',N'ST020305')-- T6权限 [ST02030501  批次汇总表] 升级至V11.1权限[ST020305  批次存货汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'ST02030502',N'ST020305_03')-- T6权限 [ST02030502  批次汇总表打印] 升级至V11.1权限[ST020305_03  打印批次存货汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'ST02030503',N'ST020305_04')-- T6权限 [ST02030503  批次汇总表输出] 升级至V11.1权限[ST020305_04  输出批次存货汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'ST020307',N'ST020307_01')-- T6权限 [ST020307  组装拆卸汇总表查询] 升级至V11.1权限[ST020307_01  查询组装拆卸汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'ST02030701',N'ST020307')-- T6权限 [ST02030701  组装拆卸汇总表] 升级至V11.1权限[ST020307  组装拆卸汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'ST02030702',N'ST020307_03')-- T6权限 [ST02030702  组装拆卸汇总表打印] 升级至V11.1权限[ST020307_03  打印组装拆卸汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'ST02030703',N'ST020307_04')-- T6权限 [ST02030703  组装拆卸汇总表输出] 升级至V11.1权限[ST020307_04  输出组装拆卸汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'ST020308',N'ST020308_01')-- T6权限 [ST020308  形态转换汇总表查询] 升级至V11.1权限[ST020308_01  形态转换汇总表查询]
	insert into #t6auth (t6authid,u8authid) values(N'ST02030801',N'ST020308')-- T6权限 [ST02030801  形态转换汇总表] 升级至V11.1权限[ST020308  形态转换汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'ST02030802',N'ST020308_03')-- T6权限 [ST02030802  形态转换汇总表打印] 升级至V11.1权限[ST020308_03  形态转换汇总表打印]
	insert into #t6auth (t6authid,u8authid) values(N'ST02030803',N'ST020308_04')-- T6权限 [ST02030803  形态转换汇总表输出] 升级至V11.1权限[ST020308_04  形态转换汇总表输出]
	insert into #t6auth (t6authid,u8authid) values(N'ST020309',N'ST020309_01')-- T6权限 [ST020309  存货分布表查询] 升级至V11.1权限[ST020309_01  查询存货分布表]
	insert into #t6auth (t6authid,u8authid) values(N'ST02030901',N'ST020309')-- T6权限 [ST02030901  存货分布表] 升级至V11.1权限[ST020309  存货分布表]
	insert into #t6auth (t6authid,u8authid) values(N'ST02030902',N'ST020309_03')-- T6权限 [ST02030902  存货分布表打印] 升级至V11.1权限[ST020309_03  打印存货分布表]
	insert into #t6auth (t6authid,u8authid) values(N'ST02030903',N'ST020309_04')-- T6权限 [ST02030903  存货分布表输出] 升级至V11.1权限[ST020309_04  输出存货分布表]
	insert into #t6auth (t6authid,u8authid) values(N'ST020310',N'ST020310_01')-- T6权限 [ST020310  限额领料汇总表查询] 升级至V11.1权限[ST020310_01  查询限额领料汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'ST02031001',N'ST020310')-- T6权限 [ST02031001  限额领料汇总表] 升级至V11.1权限[ST020310  限额领料汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'ST02031002',N'ST020310_03')-- T6权限 [ST02031002  限额领料汇总表打印] 升级至V11.1权限[ST020310_03  打印限额领料汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'ST02031003',N'ST020310_04')-- T6权限 [ST02031003  限额领料汇总表输出] 升级至V11.1权限[ST020310_04  输出限额领料汇总表]
	insert into #t6auth (t6authid,u8authid) values(N'ST0402',N'ST06')-- T6权限 [ST0402  我的账表] 升级至V11.1权限[ST06  我的报表]
--基础档案
	insert into #t6auth (t6authid,u8authid) values(N'AS005E',N'AS005X')-- T6权限 [AS005E  供应商档案输出] 升级至V11.1权限[AS005X  供应商档案输出]
	insert into #t6auth (t6authid,u8authid) values(N'AS005P',N'AS005P')-- T6权限 [AS005P  供应商档案打印] 升级至V11.1权限[AS005P  供应商档案打印]
	insert into #t6auth (t6authid,u8authid) values(N'AS009E',N'AS009X')-- T6权限 [AS009E  存货档案输出] 升级至V11.1权限[AS009X  存货档案输出]
	insert into #t6auth (t6authid,u8authid) values(N'AS009P',N'AS009P')-- T6权限 [AS009P  存货档案打印] 升级至V11.1权限[AS009P  存货档案打印]
	insert into #t6auth (t6authid,u8authid) values(N'AS011E',N'AS011X')-- T6权限 [AS011E  客户档案输出] 升级至V11.1权限[AS011X  客户档案输出]
	insert into #t6auth (t6authid,u8authid) values(N'AS011P',N'AS011P')-- T6权限 [AS011P  客户档案打印] 升级至V11.1权限[AS011P  客户档案打印]
	insert into #t6auth (t6authid,u8authid) values(N'AS1204',N'AS1204')-- T6权限 [AS1204  客户存货对照表] 升级至V11.1权限[AS1204  客户存货对照表]
	insert into #t6auth (t6authid,u8authid) values(N'AS120401',N'AS1204E')-- T6权限 [AS120401  客户存货对照表编辑] 升级至V11.1权限[AS1204E  客户存货对照表编辑]
	insert into #t6auth (t6authid,u8authid) values(N'AS120402',N'AS1204Q')-- T6权限 [AS120402  客户存货对照表查询] 升级至V11.1权限[AS1204Q  客户存货对照表查询]
go
--升级权限


if exists (select 1 where OBJECT_ID('tempdb..#UA_HoldAuth_ex') is not null)
   drop table #UA_HoldAuth_ex 
if exists (select 1 where OBJECT_ID('tempdb..#UA_HoldAuth_U8') is not null)
   drop table #UA_HoldAuth_U8 
if exists (select 1 where OBJECT_ID('tempdb..#ua_user_ex') is not null)
   drop table #ua_user_ex
--需要考虑年
--
	
	select cacc_id,iYear,cUser_Id,cAuth_Id,iIsUser  into #UA_HoldAuth_ex from ufsystem..UA_HoldAuth where 1=0
	select cacc_id,iYear,cUser_Id,cAuth_Id,iIsUser  into #UA_HoldAuth_U8 from ufsystem..UA_HoldAuth where 1=0
	select cUser_Id,cUser_Name ,cUser_Id as cUser_IdNew into #ua_user_ex from ufsystem..ua_user where 1=0
	
	declare @dbt6names varchar(255)
	DECLARE c_dblist CURSOR FOR 
    select name from master..sysdatabases where 
				name like 'UFDATA[_]'+substring ('@t6db',8,3)+'[_]____[_]CONVERTT6TOU852PUJI20_TEMPDB_T6'
			order by name

    OPEN c_dblist;
    FETCH NEXT FROM c_dblist INTO @dbt6names;
    WHILE @@FETCH_STATUS = 0
    BEGIN

        exec( '
        
        if exists (select 1 from '+@dbt6names+'..sysobjects where name=''UA_HoldAuth_ex'' and xtype =''U'')
        
        exec (''insert into #UA_HoldAuth_ex (cacc_id,iYear,cUser_Id,cAuth_Id,iIsUser )
				select cacc_id,iYear,cUser_Id,cAuth_Id,iIsUser from '+@dbt6names+'..UA_HoldAuth_ex where iyear =@iyear'')
				')
		exec( '
        
        if exists (select 1 from '+@dbt6names+'..sysobjects where name=''ua_user_ex '' and xtype =''U'')
        
        exec (''insert into #ua_user_ex (cUser_Id,cUser_Name,cUser_IdNew)
				select cUser_Id,cUser_Name,cUser_Id from '+@dbt6names+'..ua_user_ex  '')
				')
        FETCH NEXT FROM c_dblist INTO @dbt6names
    END

    CLOSE c_dblist;
    DEALLOCATE c_dblist
	
	--处理下新旧用户对照
--		select cUser_Id,cUser_Name ,cUser_Id as cUser_IdNew into #ua_user_ex from ufsystem..ua_user
	update a set a.cUser_IdNew=b.cUser_Id
			from #ua_user_ex  a inner join ufsystem..UA_User b 
				on b.cUser_Id =a.cUser_Id+REPLICATE ('$',len(b.cUser_Id)-len(a.cUser_Id)) 
					and b.cUser_Name =a.cUser_Name +REPLICATE ('$',len(b.cUser_Name)-len(a.cUser_Name)) 
	update a set a.cUser_Id =b.cUser_Idnew  from  #UA_HoldAuth_ex a inner join #ua_user_ex b on a.cUser_Id =b.cUser_Id 
	
	--增补丢失的权限
	insert into UFSystem..UA_HoldAuth 
		(cAcc_Id,iYear,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType,cRepellent,cRepellentModule,cNotRepellent)
		
	select distinct  '@cacc_id' cacc_id,@iyear iyear,
			a.cuser_id,b.u8authid,a.iisuser,c.csub_id,c.cAuthType,c.cRepellent,c.cRepellentModule,c.cNotRepellent
		from #UA_HoldAuth_ex a inner join #t6auth b on a.cAuth_Id=b.t6authid 
				inner join ufsystem..ua_auth_base c on b.u8authid =c.cAuth_Id  
		left join ufsystem..UA_HoldAuth d on 
				a.cUser_Id=d.cUser_Id and d.cAcc_Id ='@cacc_id' and d.iYear =@iyear 
				and b.u8authid =d.cAuth_Id 
		where d.cAuth_Id is null
	--删除不应该有的权限
	
delete a from UFSystem..UA_HoldAuth a inner join #t6auth b on a.cAuth_Id=b.U8authid  and a.cAcc_Id ='@cacc_id'
				
			   left join #UA_HoldAuth_ex c on b.t6authid =c.cAuth_Id and a.cUser_Id=c.cUser_Id  and c.iYear =@iyear
			   where  a.cAcc_Id ='@cacc_id' and a.iYear =@iyear and c.cAuth_Id is null
delete a from UFSystem..UA_HoldAuth a left join ufsystem..ua_auth_base b on 
			a.cAuth_Id=b.cAuth_Id
			where b.cAuth_Id is null and a.cAcc_Id =@cacc_id and a.iYear=@iyear 

go				

	
if exists (select 1 where OBJECT_ID('tempdb..#UA_HoldAuth_ex') is not null)
   drop table #UA_HoldAuth_ex 
if exists (select 1 where OBJECT_ID('tempdb..#UA_HoldAuth_U8') is not null)
   drop table #UA_HoldAuth_U8 
if exists (select 1 where OBJECT_ID('tempdb..#ua_user_ex') is not null)
   drop table #ua_user_ex
    if exists (select 1 where OBJECT_ID('tempdb..#t6auth') is not null)
   drop table #t6auth 
go

	
	