
UPDATE Seg_DoorGroup SET [Name] = 'Clientes' WHERE [No] = 14
GO

UPDATE Seg_DoorGroup SET [Name] = 'Configuracion' WHERE [No] = 1
GO


UPDATE Seg_Door SET DGrpNo = 14  WHERE DGrpNo = 13
GO

UPDATE Seg_Door SET DGrpNo = 1 WHERE [No] IN (248,251) --lotes de cbtes, lotes tipos  (Configuracion)
GO


UPDATE Seg_Door SET [Description] = 'Nueva Recaud. Cobranza x Lote' WHERE [No] = 250


UPDATE Seg_Door SET [Description] = 'Nomina de Pagos / Informe' WHERE [No] = 282

UPDATE Seg_Door SET DGrpNo = 14 WHERE [No] IN (519,492,409,245,246,720,278,247,630,510,86,243,244) 
      --credencials, pase grupo ,subgrupo, cont_tipos ,contratos ,cupos  , hab abm contratos
	  --,contrato nuevo , permite carga cont.c/deuda ,cupones de descuento ,
	  --estados cli,tipos cli,realcion    (Clientes)

UPDATE Seg_Door SET DGrpNo = 5 WHERE [No] IN (441,250,442,482,188,87,338,282,88,163,147,89) 
    --lotes tar  ,coblote ,nuevo lote tar, Flijo de Fondoes ,recibo varios        
	--adm op,import pagos,nomina pagos, nueva op, op s/prov,rpt op,rpt op
	--(Teso)



UPDATE Seg_Door SET DGrpNo = 8 WHERE [No] IN (249,481,477,478,498,446,137,333,211) 
        --NUeva Fact Lote , creditos,creditos, creditos,refin pla.ventas,planes pago ,vendedores,promot ,cond vta       (Ventas)


UPDATE Seg_Door SET DGrpNo = 18 WHERE [No] IN (624,622,623,625,626,633) 
    --Req. de Pryectos          (Logistica)


	
DELETE Seg_DoorGroup WHERE [No] = 13
GO

DELETE Seg_DoorGroup WHERE [No] = 11
GO

