###Permisos de la herramienta conteo fisico ~~~ INSERT INTO sitem VALUES (567, '2015-06-12 13:39:21', 'B9D78D9054B249FEB47E238D43A17701', '2015-06-12 13:39:21', NULL, NULL, 0, '2015-06-12 13:39:21', NULL, 'Conteo fisico de inventarios', 'CF-00-00-000',NULL , 0,NULL , NULL); INSERT INTO sitem VALUES (568, '2015-06-12 13:39:21', 'B791635A56384CA298321B872F806456', '2015-06-12 13:39:21', NULL, NULL, 0, '2015-06-12 13:39:21', NULL, 'Acceso a la aplicacion de conteo fisico (solo lectura)', 'CF-00-00-001', 567, 0,NULL ,NULL); INSERT INTO sitem VALUES (569, '2015-06-12 13:39:21', '4CE94DA4CDA344479D5EBFE7F63D1392', '2015-06-12 13:39:21', NULL, NULL, 0, '2015-06-12 13:39:21', NULL, 'Crear nuevos conteos', 'CF-00-00-002', 567, 0, NULL, NULL); INSERT INTO sitem VALUES (570, '2015-06-12 13:39:21', 'C69AF1F1BA0E4390A2964F19BA998832', '2015-06-12 13:39:21', NULL, NULL, 0, '2015-06-12 13:39:21', NULL, 'Eliminar conteos existentes', 'CF-00-00-003', 567, 0, NULL, NULL); INSERT INTO sitem VALUES (571, '2015-06-12 13:39:21', '4510160B7D5B49078E4B354F4183B7D8', '2015-06-12 13:39:21', NULL, NULL, 0, '2015-06-12 13:39:21', NULL, 'Captura de existencia fisica', 'CF-00-00-004', 567, 0, NULL, NULL); INSERT INTO sitem VALUES (572, '2015-06-12 13:39:21', 'BE5220CCDED94ACEA98FD5A7762F6F8E', '2015-06-12 13:39:21', NULL, NULL, 0, '2015-06-12 13:39:21', NULL, 'Cerrar conteos abiertos', 'CF-00-00-005', 567, 0, NULL, NULL); INSERT INTO sitem VALUES (573, '2015-06-12 13:39:21', 'B1AD7326BEB44342B3DE1F1684C9BCCF', '2015-06-12 13:39:21', NULL, NULL, 0, '2015-06-12 13:39:21', NULL, 'Sincronizar inventario del sistema', 'CF-00-00-006', 567, 0, NULL, NULL); ~~~ ###Tablas de la herramienta conteo fisico ~~~ CREATE TABLE cfCaptura (Sys_PK INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (Sys_PK), Sys_TimeStamp DATETIME NOT NULL , Sys_GUID VARCHAR(32), Sys_DTCreated DATETIME , Sys_User VARCHAR(5), Sys_LastUser VARCHAR(5), Sys_Exported BOOL , Sys_DTExported DATETIME , Sys_Info VARCHAR(32), Cantidad FLOAT NOT NULL , IAlmacen INT NOT NULL , IProducto INT NOT NULL , Notas VARCHAR(255), Referencia VARCHAR(50) NOT NULL , Usuario VARCHAR(50) NOT NULL , IConteo INT NOT NULL ); CREATE TABLE cfConteo (Sys_PK INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (Sys_PK), Sys_TimeStamp DATETIME NOT NULL , Sys_GUID VARCHAR(32), Sys_DTCreated DATETIME , Sys_User VARCHAR(5), Sys_LastUser VARCHAR(5), Sys_Exported BOOL , Sys_DTExported DATETIME , Sys_Info VARCHAR(32), Cerrado BOOL , Conclusion DATE , Inicio DATE , Nombre VARCHAR(50), Notas VARCHAR(2048), Parcial BOOL , SaldoFisico DOUBLE , SaldoTeorico DOUBLE , Sincronizado BOOL ); CREATE TABLE cfExist (Sys_PK INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (Sys_PK), Sys_TimeStamp DATETIME NOT NULL , Sys_GUID VARCHAR(32), Sys_DTCreated DATETIME , Sys_User VARCHAR(5), Sys_LastUser VARCHAR(5), Sys_Exported BOOL , Sys_DTExported DATETIME , Sys_Info VARCHAR(32), CostoPromedio DOUBLE , Exist_Fisico FLOAT , Exist_Teorico FLOAT , IAlmacen INT NOT NULL , IProducto INT NOT NULL , IConteo INT NOT NULL ); ALTER TABLE cfCaptura ADD CONSTRAINT RLcfCapturaIConteo_cfConteoSys_PK FOREIGN KEY (IConteo ) REFERENCES cfConteo(Sys_PK); ALTER TABLE cfExist ADD CONSTRAINT RLcfExistIConteo_cfConteoSys_PK FOREIGN KEY (IConteo ) REFERENCES cfConteo(Sys_PK); CREATE UNIQUE INDEX IDX_CFEXIST1 ON cfExist (IAlmacen,IProducto,IConteo); ~~~ #####Verificar que las tablas cfConteo y cfExist tengan en la sys_pk el valor "autoincrementar"