Plan de Menu-SistemaB2BIntranet2

8/6/2019 Plan de Menu-SistemaB2BIntranet2

1/83

Cdigo de Sistema: B2BINombre del Sistema: SISTEMA DE NEGOCIOS B2B

Descripcin:SISTEMA DE NEGOCIOS B2B INTRANET, para la comunicacin con los proveedoresURL Base:

b2bS

1

InformacinGeneral

/b2bI/

Nombre de Estilo del

Sistema:

Cdigos de Compaaaplicables:

Generar Todos los Scripts
http://localhost:8080/B2BWeb/http://localhost:8080/B2BWeb/


2/83

H

Sel. Set de Menu Nombre Set Menu IDB2BI MENU B2B INTRANET B2BI.01

B2BI B2BI.01.01B2BI B2BI.01.02B2BI B2BI.02

B2BI B2BI.02.01B2BI B2BI.02.02B2BI B2BI.03

B2BI B2BI.03.01

B2BI B2BI.03.02B2BI B2BI.03.03B2BI B2BI.03.04B2BI B2BI.04

B2BI B2BI.04.01B2BI B2BI.04.02B2BI B2BI.04.03B2BI B2BI.05

B2BI B2BI.05.01B2BI B2BI.05.02B2BI B2BI.05.03B2BI B2BI.05.04

B2BI B2BI.05.05B2BI B2BI.05.06B2BI B2BI.05.07B2BI B2BI.05.08B2BI B2BI.06

B2BI B2BI.06.01B2BI B2BI.07

B2BI B2BI.07.01x B2BI B2BI.08x B2BI B2BI.08.01x B2BI B2BI.08.02x B2BI B2BI.08.03

B2BI_H MENU INTERNO B2B INTRANET B2BI_H.0

B2BI_H B2BI_H.0.0B2BI_H B2BI_H.0.1B2BI_H B2BI_H_0.2

B2BI_H B2BI_H_0.3B2BI_H B2BI_H_0.4B2BI_H B2BI_H_0.5B2BI_H B2BI_H_0.6B2BI_H B2BI_H_0.7B2BI_H B2BI_H_0.8B2BI_H B2BI_H_0.9

B2BI_H B2BI_H_0.10B2BI_H B2BI_H_0.11


3/83

B2BI_H B2BI_H_0.12B2BI_H B2BI_H_0.13B2BI_H B2BI_H_0.14B2BI_H B2BI_H_0.15B2BI_H B2BI_H_0.17B2BI_H B2BI_H_0.18


4/83

JA DE CONTROL DE OPCIONES

MenusEtiquetaAdministracin

Administracin de ParmetrosAdministracin de ProveedoresPedidos

Tipos de PedidosEstados de PedidosParticipaciones de Mercado

Administracin de Competencias

Administracin de FrecuenciasAdministracin de PeriodosAdministracin datos ParticipacinWorkflow

Lista de CasosWorkflow de EmailsWorkflow de Tareas LocalesAdministracin de Espacios

Asignacin Finales GndolasCreacin Finales de GndolaPlanogramaPlanograma Local

Finales de Gndolas CompradorAccion de PeriodoAsigna de Ctalogos a UsuariosTipos de EspaciosReportes

Participacion de MercadoPronto Pago

Condiciones Pronto PagoProveedores

Revisin de TransaccionesEstudio de MercadoAdministracin CompetenciasPagina interna de B2B

Integracin con EmailIntegracin con WorklistAyuda

Edicin Condiciones Pronto PagoRegistro de los debitos de los proveedoresArticulos de Estudio de MercadoAlcance de Estudio de MercadoPrecios Estudio de MercadoLocales de Estudio de MercadoDatos Dinamicos

Areas de TrabajoComparacin Estudio Mercado


5/83

Competencias LocalesConfiguracin Estudio MercadoRegistro Estudio MercadoConfiguracin Prov. Est MerRegistrar Tarea SolicitudSeleccin Dias por mes


6/83

Sel.Tipo EMPRESA EMPRESADescripcion B2B - ROL PARTICIPACIOB2B - ROL PEDIDOSNombre B2B - PARTICIPACIONES B2B - PEDIDOSID B2BPAR B2BPED

URL/Target# x xparametrosGenerales.doadministrarProveedores.do# x

tiposPedidos.do xestadosPedidos.do x# x

administrarCompetencias.do x

administracionFrecuencias.do xperiodoParticipacion.do xadminDatosParticipacion.do x#

workList.doworkflowEmail.doworkflowTareasLocales.do#

espacio.docrearEspacio.doplanograma.doplanogramaLocal.do

espacioPublicitarioCompradores.doaccionPeriodo.dousuarioCatalogoEspacio.dotiposEspacios.do#

participacionMercado.do x#

condicionesProntoPago.do#

revisionTransacciones.doestudioMercado.doadministracionCompetencia.do#indice.do x xlogin.doayuda.do x x

edicionCondicionProntoPago.doproveedores.doarticuloEstudioMercado.doalcanceEstudioMercado.doprecioEstudioMercado.dolocalesEstudioMercado.dodatosDinamicos.do

areaTrabajoEstudioMercado.docomparacionEstudioMercado.do


7/83

competenciasLocales.doconfiguracionEstudioMercado.doregistroEstudioMercado.doconfiguracionProveedorEstudioMercado.doregistrarTarea.dodiaXmes.do


8/83

WORKFLOW WORKFLOWB2B - ADMINISTRADOR WORKF B2B - USUARIO WORKFLO

B2B - ADM - WORKFLOW B2B - USR - WORKFLOWB2BADMWORKFLOW B2BUSRWORKFLOW

x x

x x

x x

x x


9/83


10/83

INTERNOB2B - ADMINISTRADOR B2B INTRANET

B2B - ADMINISTRADOR INTRANETB2BIADM

x

xX

x

xxxx

xxxx

xxx

x


11/83


12/83

EMPRESAB2B - USUARIO PROVEEDOR AUTORIZADO PARA CONFIGURAR LOS ESPACIOS DE LOCALE

B2B - ESPACIOSB2BESPACIOS

x

xx

x

xxxx

x

x


13/83


14/83

EMPRESA INTERNOB2B - ROL PARA ACCEDER AL WORKFLOW DE EMAI B2B - ROL PARA ACCEDER A LA LISTA DE CAS

B2B - WORKFLOW DE EMAILS B2B - LISTA DE CASOSB2BWORKFLOWEMAIL B2BWORKLIST

x x

x xxx

x xx xx x


15/83


16/83

EMPRESAB2B - ROL PARA ACCEDER AL WORKFLOW DE EMAILS2B - WORKFLOW DE EMAILS COMPRADOR PROVEEDO

B2BWORKFLOWEMAILCOMPRAS

X


17/83


18/83

EMPRESAB2B - ROL PARA ADMINISTRAR LOS ESPACIOS

B2B - ADMINISTRACIN DE ESPACIOSB2BADMINESPACIOS

X

XX


19/83


20/83

INTERNOB2B - ROL PARA LA ADMINISTRACIN DE CONDICIONES DE PRONTO PAGO

B2B - FINANCIEROB2BFINANCIERO

XX

X


21/83


22/83

x xINTERNO INTERNO

B2B - ROL PARA ESTUDIO DE MERCADO B2B - ROL PARA LOCALESB2B - WORKFLOW DE ESTUDIO DE MERCADO B2B - ROL PARA LOCALES

B2BWORKFLOWESTUDIODEMERCADO B2BREGISTROESTUDIOMERCADO

x

x

x


23/83


24/83

xINTERNO

B2B - ROL PARA SOLICITANTES ESTUDIO MERCADOB2B - ROL PARA SOLICITANTES ESTUDIO MERCADO

B2BSOLICITANTEESTUDIOMERCADO

x

x

xxxxx

xx


25/83

xx


26/83

xINTERNO

B2B - ROL PARA CONFIGURADORES ESTUDIO MERCADOB2B - ROL PARA CONFIGURADORES ESTUDIO MERCADO

B2BCONFIGURADORESTUDIOMERCADO

x

x


27/83

x

xx


28/83

xINTERNO

B2B- ROL PARA CONFIGURADORES PROVEEDORES ESTUDIO MERCADOB2B- ROL PARA CONFIGURADORES PROVEEDORES ESTUDIO MERCADO

B2BCONFIGURADORESPROVEEDORESESTUDIOMERCADO


29/83

x


30/83

xINTERNO

B2B - ROL PARA COMPETENCIAS DE ESTUDIO DE MERCADOB2B - ROL PARA COMPETENCIAS DE ESTUDIO DE MERCADO

B2BCOMPETENCIASESTUDIOMERCADO

x


31/83

x


32/83

Listado de Usuarios

ID username Nombre Completo Password

FRM0 smxadmin Administrador - de Corporativos CORP Smxadmin1

B2B0 b2badmin Administrador - de Corporativos B2B B2badmin

B2B1 b2btarpro Administrador Tareas Programadas B2B B2badmin1

KFLOW100 OliverKFLOW207 abenitez

KFLOW208 rguerron

KFLOW205 kalbuja

SISPE4 admin101

B2B - ROL PARA LOCALES B2B - ROL PARA LOCALESB2B - WORKFLOW DE ESTUDIO DE MERCADO B2B - ROL PARA ESTUDIO DE MERCADO

SISPE4 admin101 B2B - FINANCIERO

B2B - ADMINISTRACIN DE ESPACIOS

B2B - ROL PARA COMPETENCIAS DE ESTUDIODE MERCADO

B2B - ROL PARA COMPETENCIAS DEESTUDIO DE MERCADO

B2B- ROL PARA CONFIGURADORES

PROVEEDORES ESTUDIO MERCADO

B2B- ROL PARA CONFIGURADORES

PROVEEDORES ESTUDIO MERCADOB2B - ROL PARA CONFIGURADORES ESTUDIOMERCADO

B2B - ROL PARA CONFIGURADORESESTUDIO MERCADO

B2B - ROL PARA SOLICITANTES ESTUDIOMERCADO

B2B - ROL PARA SOLICITANTES ESTUDIOMERCADO

B2B - ROL PARA LA ADMINISTRACIN DECONDICIONES DE PRONTO PAGO

B2B - ROL PARA ADMINISTRAR LOSESPACIOS


33/83

B2B - LISTA DE CASOS

B2B - WORKFLOW DE EMAILS

B2B - ESPACIOS

B2B - ADMINISTRADOR INTRANET B2B - ADMINISTRADOR B2B INTRANETB2B - USR - WORKFLOW B2B - USUARIO WORKFLOWB2B - ADM - WORKFLOW B2B - ADMINISTRADOR WORKFLOWB2B - PEDIDOS B2B - ROL PEDIDOSB2B - PARTICIPACIONES B2B - ROL PARTICIPACIONES

B2B - WORKFLOW DE EMAILS COMPRADORPROVEEDOR

B2B - ROL PARA ACCEDER AL WORKFLOWDE EMAILS ENTRE COMPRADOR YPROVEEDOR

B2B - ROL PARA ACCEDER A LA LISTA DECASOS

B2B - ROL PARA ACCEDER AL WORKFLOWDE EMAILS

B2B - USUARIO PROVEEDOR AUTORIZADOPARA CONFIGURAR LOS ESPACIOS DELOCALES


34/83

ID

Roles

NombreDescripTipo

Pregunta Secreta Respuesta E-Mail

Administrador - CORP Smxadmin1 EINTERNO

D

Administrador - B2B B2badmin EINTERNO

D

Administrador Tareas Programadas B2B B2badmin1 EINTERNO

D

EE

E

E

E

Status

(Enabled/Disabled)

Tipo (EXTERNO/EMPRESA /INTERNO)

Password Encriptado

(Enabled/Disabled)

Caducid

Passwo

smxadmin@s

b2badmin@s

b2btp@super

Actualizar Listado de Roles
mailto:[email protected]:[email protected]:[email protected]:[email protected]:[email protected]:[email protected]


35/83


36/83

B2BCOMPETENCIASESTUDIOMERCADO B2BCONFIGURADORESPROVEEDORESESTUDIOMERCADO

B2B - ROL PARA COMPETENCIAS DE ESTUDIO DE MERCADO B2B- ROL PARA CONFIGURADORES PROVEEDORES ESTUDIO MERCB2B - ROL PARA COMPETENCIAS DE ESTUDIO DE MERCADO B2B- ROL PARA CONFIGURADORES PROVEEDORES ESTUDIO MERCINTERNO INTERNO

x


37/83


38/83

B2BCONFIGURADORESTUDIOMERCADO B2BSOLICITANTEESTUDIOMERCADO

B2B - ROL PARA CONFIGURADORES ESTUDIO MERCADO B2B - ROL PARA SOLICITANTES ESTUDIO MERCADO B2B - ROL PARA LB2B - ROL PARA CONFIGURADORES ESTUDIO MERCADO B2B - ROL PARA SOLICITANTES ESTUDIO MERCADO B2B - ROL PARA LINTERNO INTERNO INTERNO

x

B2BREGISTROESRCADO


39/83


40/83


41/83


42/83

B2BADMINESPACIOS B2BWORKFLOWEMAILCOMPRAS

B2B - ADMINISTRACIN DE ESPACIOS B2B - WORKFLOW DE EMAILS COMPRADOR PROVEEDORB2B - ROL PARA ADMINISTRAR LOS ESPACIOS B2B - ROL PARA ACCEDER AL WORKFLOW DE EMAILS ENTRE COMPRADOR Y PROVEMPRESA EMPRESA


43/83


44/83

B2BWORKLIST B2BWORKFLOWEMAIL

LISTA DE CASOS WORKFLOW DE EMAILSROL PARA ACCEDER A LA LISTA DE CASOS ROL PARA ACCEDER AL WORKFLOW DE EMAILSINTERNO EMPRESA

x x

x xx x

x x

x

x


45/83


46/83

B2BESPACIOS B2BIADM

ESPACIOS ADMINISTRADOR - B2B INTRANETUSUARIO PROVEEDOR AUTORIZADO PARA CONFIGURAR LOS ESPACIOS DE LOCALES ADMINISTRADOR B2B INTRANETEMPRESA INTERNO

x x

x xx x

x x


47/83


48/83

B2BUSRWORKFLOW B2BADMWORKFLOW B2BPED B2BPAR

B2B - USR - WORKFLOW B2B - ADM - WORKFLOW PEDIDOS PARTICIPACIONESUSUARIO WORKFLOW ADMINISTRADOR WORKFLOW ROL PEDIDOS ROL PARTICIPACIONESWORKFLOW WORKFLOW EMPRESA EMPRESA

x x x x

x x x xx x x x

x x x x


49/83


50/83


51/83


52/83

INSERT INTO KSEMPTSYSTEM(sysid,sysnom,sysdes,systar,sysstylename)VALUES('B2BI','SISTEMA DE N


53/83

GOCIOS B2B','SISTEMA DE NEGOCIOS B2B INTRANET, para la comunicacin con los proveedores ','/b2bI


54/83

/','b2bS');


55/83

INSERT INTO KSEMPTCOMSYS(sysid,comid)values('B2BI' , '1');


56/83

INSERT INTO KSSEGTROLE ( ROLEID, ROLENOM, ROLEDES, ROLEENABLED, ROLEIDPADRE, USERRINSERT INTO KSSEGTROLE ( ROLEID, ROLENOM, ROLEDES, ROLEENABLED, ROLEIDPADRE, USERRINSERT INTO KSSEGTROLE ( ROLEID, ROLENOM, ROLEDES, ROLEENABLED, ROLEIDPADRE, USERRINSERT INTO KSSEGTROLE ( ROLEID, ROLENOM, ROLEDES, ROLEENABLED, ROLEIDPADRE, USERRINSERT INTO KSSEGTROLE ( ROLEID, ROLENOM, ROLEDES, ROLEENABLED, ROLEIDPADRE, USERRINSERT INTO KSSEGTROLE ( ROLEID, ROLENOM, ROLEDES, ROLEENABLED, ROLEIDPADRE, USERR


57/83

OLTYPEID )VALUES( 'B2BWORKFLOWESTUDIODEMERCADO' , 'B2B - WORKFLOW DE ESTUDIO DE MEOLTYPEID )VALUES( 'B2BREGISTROESTUDIOMERCADO ' , 'B2B - ROL PARA LOCALES' , 'B2B - ROL PAOLTYPEID )VALUES( 'B2BSOLICITANTEESTUDIOMERCADO' , 'B2B - ROL PARA SOLICITANTES ESTUDIOLTYPEID )VALUES( 'B2BCONFIGURADORESTUDIOMERCADO' , 'B2B - ROL PARA CONFIGURADORESOLTYPEID )VALUES( 'B2BCONFIGURADORESPROVEEDORESESTUDIOMERCADO' , 'B2B- ROL PARA COLTYPEID )VALUES( 'B2BCOMPETENCIASESTUDIOMERCADO' , 'B2B - ROL PARA COMPETENCIAS DE


58/83

RCADO' , 'B2B - ROL PARA ESTUDIO DE MERCADO' , '1', NULL, 'INTERNO');RA LOCALES' , '1', NULL, 'INTERNO');O MERCADO' , 'B2B - ROL PARA SOLICITANTES ESTUDIO MERCADO' , '1', NULL, 'INTERNO');ESTUDIO MERCADO' , 'B2B - ROL PARA CONFIGURADORES ESTUDIO MERCADO' , '1', NULL, 'INTERN

ONFIGURADORES PROVEEDORES ESTUDIO MERCADO' , 'B2B- ROL PARA CONFIGURADORES PROVESTUDIO DE MERCADO' , 'B2B - ROL PARA COMPETENCIAS DE ESTUDIO DE MERCADO' , '1', NULL, 'I


59/83

O');EDORES ESTUDIO MERCADO' , '1', NULL, 'INTERNO');

NTERNO');


60/83

INSERT INTO KSEMPTROLCOMSYS(roleid,sysid,comid)values('B2BWORKFLOWESTUDIODEMERCADO' ,INSERT INTO KSEMPTROLCOMSYS(roleid,sysid,comid)values('B2BREGISTROESTUDIOMERCADO ' , 'B2INSERT INTO KSEMPTROLCOMSYS(roleid,sysid,comid)values('B2BSOLICITANTEESTUDIOMERCADO' , 'INSERT INTO KSEMPTROLCOMSYS(roleid,sysid,comid)values('B2BCONFIGURADORESTUDIOMERCADOINSERT INTO KSEMPTROLCOMSYS(roleid,sysid,comid)values('B2BCONFIGURADORESPROVEEDORESEINSERT INTO KSEMPTROLCOMSYS(roleid,sysid,comid)values('B2BCOMPETENCIASESTUDIOMERCADO'

INSERT INTO KSEMPTROLCOMSYS(roleid,sysid,comid)values('B2BWORKFLOWEMAIL' , 'B2BI' , '1');INSERT INTO KSEMPTROLCOMSYS(roleid,sysid,comid)values('B2BWORKLIST' , 'B2BI' , '1');INSERT INTO KSEMPTROLCOMSYS(roleid,sysid,comid)values('B2BWORKFLOWEMAILCOMPRAS' , 'B2BI'INSERT INTO KSEMPTROLCOMSYS(roleid,sysid,comid)values('B2BADMINESPACIOS' , 'B2BI' , '1');INSERT INTO KSEMPTROLCOMSYS(roleid,sysid,comid)values('B2BFINANCIERO' , 'B2BI' , '1');INSERT INTO KSEMPTROLCOMSYS(roleid,sysid,comid)values('B2BWORKFLOWESTUDIODEMERCADO' ,INSERT INTO KSEMPTROLCOMSYS(roleid,sysid,comid)values('B2BREGISTROESTUDIOMERCADO ' , 'B2


61/83

'B2BI' , '1');I' , '1');2BI' , '1');' , 'B2BI' , '1');STUDIOMERCADO' , 'B2BI' , '1');, 'B2BI' , '1');

, '1');

'B2BI' , '1');I' , '1');


62/83

INSERT INTO KSSEGTACCITESET ( ACCITESETID , ACCITESETNOM , ACCITESETDES , ACCITESETSTATUS , SYSID )VALUES( 'B2BI' , 'MINSERT INTO KSSEGTACCITESET ( ACCITESETID , ACCITESETNOM , ACCITESETDES , ACCITESETSTATUS , SYSID )VALUES( 'B2BI_H' ,


63/83

B2B INTRANET' , 'MENU B2B INTRANET' , '1' , 'B2BI' );U INTERNO B2B INTRANET' , 'MENU INTERNO B2B INTRANET' , '1' , 'B2BI' );


64/83

INSERT INTO KSSEGTACCITE ( ACCITEID , ACCITENOM , ACCITEDES , ACCITEORD , ACCITEPADID ,


65/83

CCITESETID , ACCITESTATUS , ACCITETAR , TARTYPID ,ACCESSITEMPANELSTYLE,ACCESSITEMPA


66/83

NELORDER )VALUES( 'B2BI.08.03' , 'Administracin Competencias' , 'Administracin Competencias' , 3 , 'B2


67/83

I.08' , 'B2BI' , '1' , 'administracionCompetencia.do' , 'URL', NULL , NULL );


68/83

DELETE FROM KSSEGTROLACCITE WHERE ROLEID='B2BWORKFLOWESTUDIODEMERCADO' AND ADELETE FROM KSSEGTROLACCITE WHERE ROLEID='B2BREGISTROESTUDIOMERCADO ' AND ACCITDELETE FROM KSSEGTROLACCITE WHERE ROLEID='B2BSOLICITANTEESTUDIOMERCADO' AND ACCDELETE FROM KSSEGTROLACCITE WHERE ROLEID='B2BCONFIGURADORESTUDIOMERCADO' ANDDELETE FROM KSSEGTROLACCITE WHERE ROLEID='B2BCONFIGURADORESPROVEEDORESESTUDIINSERT INTO KSSEGTROLACCITE ( ROLEID , ACCITEID )VALUES( 'B2BCOMPETENCIASESTUDIOMER


69/83

CITEID='B2BI.08.03';EID='B2BI.08.03';ITEID='B2BI.08.03';CCITEID='B2BI.08.03';

OMERCADO' AND ACCITEID='B2BI.08.03';ADO' , 'B2BI.08.03' );


70/83

INSERT INTO KSSEGTUSER(USERID, USERNOM, USERCOMNOM, USERPWD, USERSECQUE, USERSINSERT INTO KSSEGTUSER(USERID, USERNOM, USERCOMNOM, USERPWD, USERSECQUE, USERSINSERT INTO KSSEGTUSER(USERID, USERNOM, USERCOMNOM, USERPWD, USERSECQUE, USERSINSERT INTO KSSEGTUSER(USERID, USERNOM, USERCOMNOM, USERPWD, USERSECQUE, USERSINSERT INTO KSSEGTUSER(USERID, USERNOM, USERCOMNOM, USERPWD, USERSECQUE, USERSINSERT INTO KSSEGTUSER(USERID, USERNOM, USERCOMNOM, USERPWD, USERSECQUE, USERS

INSERT INTO KSSEGTUSER(USERID, USERNOM, USERCOMNOM, USERPWD, USERSECQUE, USERSINSERT INTO KSSEGTUSER(USERID, USERNOM, USERCOMNOM, USERPWD, USERSECQUE, USERS


71/83

CQUEANS, USEREMAIL, USERSTATUS, USERROLTYPEID, USERPASSWORDENCRYPTED, USERPASCQUEANS, USEREMAIL, USERSTATUS, USERROLTYPEID, USERPASSWORDENCRYPTED, USERPASCQUEANS, USEREMAIL, USERSTATUS, USERROLTYPEID, USERPASSWORDENCRYPTED, USERPASCQUEANS, USEREMAIL, USERSTATUS, USERROLTYPEID, USERPASSWORDENCRYPTED, USERPASCQUEANS, USEREMAIL, USERSTATUS, USERROLTYPEID, USERPASSWORDENCRYPTED, USERPASCQUEANS, USEREMAIL, USERSTATUS, USERROLTYPEID, USERPASSWORDENCRYPTED, USERPAS

CQUEANS, USEREMAIL, USERSTATUS, USERROLTYPEID, USERPASSWORDENCRYPTED, USERPASCQUEANS, USEREMAIL, USERSTATUS, USERROLTYPEID, USERPASSWORDENCRYPTED, USERPAS


72/83

WORDCADUCITYDATE)VALUES( 'FRM0' , 'smxadmin' , 'Administrador - de Corporativos CORP' , 'SmxadmiWORDCADUCITYDATE)VALUES( 'B2B0' , 'b2badmin' , 'Administrador - de Corporativos B2B' , 'B2badmin' , 'WORDCADUCITYDATE)VALUES( 'B2B1' , 'b2btarpro' , 'Administrador Tareas Programadas B2B' , 'B2badmiWORDCADUCITYDATE)VALUES( 'KFLOW100' , 'Oliver' , '' , '' , '' , '' , '' , '' , '' , 'E' , NULL );WORDCADUCITYDATE)VALUES( 'KFLOW207' , 'abenitez' , '' , '' , '' , '' , '' , '' , '' , 'E' , NULL );WORDCADUCITYDATE)VALUES( 'KFLOW208' , 'rguerron' , 'B2B - ROL PARA COMPETENCIAS DE ESTU

WORDCADUCITYDATE)VALUES( 'KFLOW205' , 'kalbuja' , 'B2B- ROL PARA CONFIGURADORES PROVEWORDCADUCITYDATE)VALUES( 'SISPE4' , 'admin101' , 'B2B - ROL PARA CONFIGURADORES ESTUDI


73/83

n1' , 'Administrador - CORP' , 'Smxadmin1' , '[email protected]' , 'E' , 'INTERNO' , 'D' , NULL );'Administrador - B2B' , 'B2badmin' , '[email protected]' , 'E' , 'INTERNO' , 'D' , NULL );n1' , 'Administrador Tareas Programadas B2B' , 'B2badmin1' , '[email protected]' , 'E' , 'INTERNO' , 'D' ,

IO DE MERCADO' , 'B2B - ROL PARA COMPETENCIAS DE ESTUDIO DE MERCADO' , '' , '' , '' , '' , '' , 'E' , N

DORES ESTUDIO MERCADO' , 'B2B- ROL PARA CONFIGURADORES PROVEEDORES ESTUDIO MERCMERCADO' , 'B2B - ROL PARA CONFIGURADORES ESTUDIO MERCADO' , '' , '' , '' , '' , '' , 'E' , NULL );


74/83

ULL );

ULL );

DO' , '' , '' , '' , '' , '' , 'E' , NULL );


75/83

DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BCOMPETENCIASESTUDIOMERCADELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BCONFIGURADORESPROVEEDORDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BCONFIGURADORESTUDIOMERCADELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BSOLICITANTEESTUDIOMERCADO'DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BREGISTROESTUDIOMERCADO ' ADELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BWORKFLOWESTUDIODEMERCADDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BFINANCIERO' AND USERID='FRM0'DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BADMINESPACIOS' AND USERID='FDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BWORKFLOWEMAILCOMPRAS' ANINSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BWORKLIST' , 'FRM0' );INSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BWORKFLOWEMAIL' , 'FINSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BESPACIOS' , 'FRM0' );INSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BIADM' , 'FRM0' );INSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BUSRWORKFLOW' , 'FRMINSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BADMWORKFLOW' , 'FRMINSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BPED' , 'FRM0' );INSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BPAR' , 'FRM0' );

DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BCOMPETENCIASESTUDIOMERCADELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BCONFIGURADORESPROVEEDORDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BCONFIGURADORESTUDIOMERCADELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BSOLICITANTEESTUDIOMERCADO'DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BREGISTROESTUDIOMERCADO ' ADELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BWORKFLOWESTUDIODEMERCADDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BFINANCIERO' AND USERID='B2B0';DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BADMINESPACIOS' AND USERID='BDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BWORKFLOWEMAILCOMPRAS' ANDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BWORKLIST' AND USERID='B2B0';DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BWORKFLOWEMAIL' AND USERID='DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BESPACIOS' AND USERID='B2B0';

DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BIADM' AND USERID='B2B0';DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BUSRWORKFLOW' AND USERID='BDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BADMWORKFLOW' AND USERID='BDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BPED' AND USERID='B2B0';DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BPAR' AND USERID='B2B0';DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BCOMPETENCIASESTUDIOMERCADELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BCONFIGURADORESPROVEEDORDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BCONFIGURADORESTUDIOMERCADELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BSOLICITANTEESTUDIOMERCADO'DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BREGISTROESTUDIOMERCADO ' ADELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BWORKFLOWESTUDIODEMERCADDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BFINANCIERO' AND USERID='B2B1';

DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BADMINESPACIOS' AND USERID='BDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BWORKFLOWEMAILCOMPRAS' ANDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BWORKLIST' AND USERID='B2B1';DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BWORKFLOWEMAIL' AND USERID='DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BESPACIOS' AND USERID='B2B1';DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BIADM' AND USERID='B2B1';DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BUSRWORKFLOW' AND USERID='BDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BADMWORKFLOW' AND USERID='BDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BPED' AND USERID='B2B1';DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BPAR' AND USERID='B2B1';DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BCOMPETENCIASESTUDIOMERCA

DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BCONFIGURADORESPROVEEDORDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BCONFIGURADORESTUDIOMERCA


76/83

DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BSOLICITANTEESTUDIOMERCADO'DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BREGISTROESTUDIOMERCADO ' AINSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BWORKFLOWESTUDIODDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BFINANCIERO' AND USERID='KFLODELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BADMINESPACIOS' AND USERID='KDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BWORKFLOWEMAILCOMPRAS' ANINSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BWORKLIST' , 'KFLOW10INSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BWORKFLOWEMAIL' , 'KFINSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BESPACIOS' , 'KFLOW10INSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BIADM' , 'KFLOW100' );INSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BUSRWORKFLOW' , 'KFLINSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BADMWORKFLOW' , 'KFLINSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BPED' , 'KFLOW100' );INSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BPAR' , 'KFLOW100' );DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BCOMPETENCIASESTUDIOMERCADELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BCONFIGURADORESPROVEEDORDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BCONFIGURADORESTUDIOMERCA

DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BSOLICITANTEESTUDIOMERCADO'DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BREGISTROESTUDIOMERCADO ' AINSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BWORKFLOWESTUDIODDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BFINANCIERO' AND USERID='KFLODELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BADMINESPACIOS' AND USERID='KDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BWORKFLOWEMAILCOMPRAS' ANINSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BWORKLIST' , 'KFLOW20INSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BWORKFLOWEMAIL' , 'KFINSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BESPACIOS' , 'KFLOW20INSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BIADM' , 'KFLOW207' );INSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BUSRWORKFLOW' , 'KFLINSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BADMWORKFLOW' , 'KFL

INSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BPED' , 'KFLOW207' );INSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BPAR' , 'KFLOW207' );DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BCOMPETENCIASESTUDIOMERCAINSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BCONFIGURADORESPRDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BCONFIGURADORESTUDIOMERCADELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BSOLICITANTEESTUDIOMERCADO'DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BREGISTROESTUDIOMERCADO ' ADELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BWORKFLOWESTUDIODEMERCADDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BFINANCIERO' AND USERID='KFLODELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BADMINESPACIOS' AND USERID='KDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BWORKFLOWEMAILCOMPRAS' ANDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BWORKLIST' AND USERID='KFLOW

DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BWORKFLOWEMAIL' AND USERID='DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BESPACIOS' AND USERID='KFLOWDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BIADM' AND USERID='KFLOW208';DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BUSRWORKFLOW' AND USERID='KDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BADMWORKFLOW' AND USERID='KDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BPED' AND USERID='KFLOW208';DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BPAR' AND USERID='KFLOW208';DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BCOMPETENCIASESTUDIOMERCADELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BCONFIGURADORESPROVEEDORDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BCONFIGURADORESTUDIOMERCAINSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BSOLICITANTEESTUDIO

DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BREGISTROESTUDIOMERCADO ' ADELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BWORKFLOWESTUDIODEMERCAD


77/83

DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BFINANCIERO' AND USERID='KFLODELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BADMINESPACIOS' AND USERID='KDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BWORKFLOWEMAILCOMPRAS' ANINSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BWORKLIST' , 'KFLOW20INSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BWORKFLOWEMAIL' , 'KFINSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BESPACIOS' , 'KFLOW20INSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BIADM' , 'KFLOW205' );INSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BUSRWORKFLOW' , 'KFLINSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BADMWORKFLOW' , 'KFLINSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BPED' , 'KFLOW205' );INSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BPAR' , 'KFLOW205' );DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BCOMPETENCIASESTUDIOMERCADELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BCONFIGURADORESPROVEEDORDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BCONFIGURADORESTUDIOMERCADELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BSOLICITANTEESTUDIOMERCADO'DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BREGISTROESTUDIOMERCADO ' ADELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BWORKFLOWESTUDIODEMERCAD

DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BFINANCIERO' AND USERID='SISPEDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BADMINESPACIOS' AND USERID='SDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BWORKFLOWEMAILCOMPRAS' ANINSERT INTO KSSEGTUSEROL ( ROLEID , USERID )VALUES( 'B2BWORKLIST' , 'SISPE4' );DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BWORKFLOWEMAIL' AND USERID='DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BESPACIOS' AND USERID='SISPE4';DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BIADM' AND USERID='SISPE4';DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BUSRWORKFLOW' AND USERID='SIDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BADMWORKFLOW' AND USERID='SIDELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BPED' AND USERID='SISPE4';DELETE FROM KSSEGTUSEROL WHERE ROLEID='B2BPAR' AND USERID='SISPE4';


78/83

O' AND USERID='FRM0';SESTUDIOMERCADO' AND USERID='FRM0';O' AND USERID='FRM0';

AND USERID='FRM0';D USERID='FRM0';' AND USERID='FRM0';

;RM0';USERID='FRM0';

M0' );

0' );0' );

O' AND USERID='B2B0';SESTUDIOMERCADO' AND USERID='B2B0';O' AND USERID='B2B0';

AND USERID='B2B0';D USERID='B2B0';' AND USERID='B2B0';

2B0';USERID='B2B0';

B2B0';

B0';B0';

O' AND USERID='B2B1';SESTUDIOMERCADO' AND USERID='B2B1';O' AND USERID='B2B1';

AND USERID='B2B1';D USERID='B2B1';' AND USERID='B2B1';

2B1';USERID='B2B1';

B2B1';

B1';B1';

O' AND USERID='KFLOW100';

SESTUDIOMERCADO' AND USERID='KFLOW100';O' AND USERID='KFLOW100';


79/83

AND USERID='KFLOW100';D USERID='KFLOW100';MERCADO' , 'KFLOW100' );100';

FLOW100';USERID='KFLOW100';' );LOW100' );' );

W100' );OW100' );

O' AND USERID='KFLOW207';SESTUDIOMERCADO' AND USERID='KFLOW207';O' AND USERID='KFLOW207';

AND USERID='KFLOW207';D USERID='KFLOW207';MERCADO' , 'KFLOW207' );207';

FLOW207';USERID='KFLOW207';' );LOW207' );' );

W207' );OW207' );

O' AND USERID='KFLOW208';VEEDORESESTUDIOMERCADO' , 'KFLOW208' );O' AND USERID='KFLOW208';

AND USERID='KFLOW208';D USERID='KFLOW208';' AND USERID='KFLOW208';208';

FLOW208';USERID='KFLOW208';08';

KFLOW208';08';

LOW208';LOW208';

O' AND USERID='KFLOW205';SESTUDIOMERCADO' AND USERID='KFLOW205';O' AND USERID='KFLOW205';ERCADO' , 'KFLOW205' );

D USERID='KFLOW205';' AND USERID='KFLOW205';


80/83


81/83

INSERT INTO KSSEGTCTXACCITE ( CTXID , ACCITEID , TARGET )VALUES( 'struts' , 'B2BI.08.03' , 'admini


82/83

stracionCompetencia.do' );


83/83

INSERT INTO KSEMPTUSECOMSYS(userid,sysid,comid)values('FRM0' , 'B2BI' , '1');INSERT INTO KSEMPTUSECOMSYS(userid,sysid,comid)values('B2B0' , 'B2BI' , '1');INSERT INTO KSEMPTUSECOMSYS(userid,sysid,comid)values('B2B1' , 'B2BI' , '1');INSERT INTO KSEMPTUSECOMSYS(userid,sysid,comid)values('KFLOW100' , 'B2BI' , '1');INSERT INTO KSEMPTUSECOMSYS(userid,sysid,comid)values('KFLOW207' , 'B2BI' , '1');INSERT INTO KSEMPTUSECOMSYS(userid,sysid,comid)values('KFLOW208' , 'B2BI' , '1');

INSERT INTO KSEMPTUSECOMSYS(userid,sysid,comid)values('KFLOW205' , 'B2BI' , '1');INSERT INTO KSEMPTUSECOMSYS(userid,sysid,comid)values('SISPE4' , 'B2BI' , '1');

Plan de Menu-SistemaB2BIntranet2

Documents

Transcript of Plan de Menu-SistemaB2BIntranet2