== ALMACENES == {"CODALMACEN":"01","NOMBREALMACEN":"ALMACEN K1 "} {"CODALMACEN":"02","NOMBREALMACEN":"ALMACEN K2"} {"CODALMACEN":"03","NOMBREALMACEN":"ALMACEN K3"} {"CODALMACEN":"04","NOMBREALMACEN":"ALMACEN K4"} {"CODALMACEN":"05","NOMBREALMACEN":"ALMACEN K5"} {"CODALMACEN":"06","NOMBREALMACEN":"ALMACEN K6"} {"CODALMACEN":"07","NOMBREALMACEN":"ALMACEN K7"} {"CODALMACEN":"08","NOMBREALMACEN":"ALMACEN K8"} {"CODALMACEN":"09","NOMBREALMACEN":"ALMACEN K9"} {"CODALMACEN":"10","NOMBREALMACEN":"ALMACEN K10"} {"CODALMACEN":"11","NOMBREALMACEN":"CERRADA"} {"CODALMACEN":"12","NOMBREALMACEN":"ALMACEN K12"} {"CODALMACEN":"13","NOMBREALMACEN":"ALMACEN K13"} {"CODALMACEN":"14","NOMBREALMACEN":"ALMACEN K14"} {"CODALMACEN":"14D","NOMBREALMACEN":"ALM K14D CAFETERIA VIVES I TUT"} {"CODALMACEN":"15","NOMBREALMACEN":"ALMACEN K15"} {"CODALMACEN":"16","NOMBREALMACEN":"ALMACEN K16 "} {"CODALMACEN":"17","NOMBREALMACEN":"ALMACEN K17"} {"CODALMACEN":"99","NOMBREALMACEN":"ALMACEN CENTRAL KCH INVERSORY"} {"CODALMACEN":"A1","NOMBREALMACEN":"ALMACEN NAVE CENTRAL"} {"CODALMACEN":"A2","NOMBREALMACEN":"ALM. LONG 5 NAVE 83"} {"CODALMACEN":"A3","NOMBREALMACEN":"ALMACEN LONG 7 NAV 132"} {"CODALMACEN":"AD2","NOMBREALMACEN":"ALMACEN MUNTANER"} {"CODALMACEN":"AM1","NOMBREALMACEN":"MERMAS CENTRAL"} {"CODALMACEN":"C1","NOMBREALMACEN":"CASA TIO"} {"CODALMACEN":"D1","NOMBREALMACEN":"ALMACEN JACINTO BENAVENTE"} {"CODALMACEN":"D14","NOMBREALMACEN":"MERMAS KA14D"} {"CODALMACEN":"D2","NOMBREALMACEN":"ALMACEN + Q CARN"} {"CODALMACEN":"D3","NOMBREALMACEN":"ALMACEN ROSELLO"} {"CODALMACEN":"D4","NOMBREALMACEN":"ALMACEN ESCOLES PIES"} {"CODALMACEN":"D5","NOMBREALMACEN":"ALMACEN D5 BALMES 430"} {"CODALMACEN":"D8","NOMBREALMACEN":"ALMACEN D8 MUNTANER"} {"CODALMACEN":"D9","NOMBREALMACEN":"DYLAN 9 TRAVESERA"} {"CODALMACEN":"DA","NOMBREALMACEN":"DYLAN 10 VILADOMAT"} {"CODALMACEN":"DB","NOMBREALMACEN":"DYLAN BALMES 311"} {"CODALMACEN":"DC","NOMBREALMACEN":"ALMACEN PEREZ CABRERO 5"} {"CODALMACEN":"DD","NOMBREALMACEN":"ALMACEN D13"} {"CODALMACEN":"DE","NOMBREALMACEN":"DY14 PLAZA"} {"CODALMACEN":"DF","NOMBREALMACEN":"ALMACEN VIA AUGUSTA"} {"CODALMACEN":"DG","NOMBREALMACEN":"DYLAN MITRE 110"} {"CODALMACEN":"E1","NOMBREALMACEN":"ALMACEN PADUA"} {"CODALMACEN":"E2","NOMBREALMACEN":"ALMACEN PEREZ CABRERO"} {"CODALMACEN":"E3","NOMBREALMACEN":"ALMACEN BONANOVA"} {"CODALMACEN":"E4","NOMBREALMACEN":"ALMACEN PLAZA"} {"CODALMACEN":"L","NOMBREALMACEN":"Logistica"} {"CODALMACEN":"M01","NOMBREALMACEN":"MERMAS K1"} {"CODALMACEN":"M02","NOMBREALMACEN":"MERMAS K2 "} {"CODALMACEN":"M03","NOMBREALMACEN":"MERMAS K3"} {"CODALMACEN":"M04","NOMBREALMACEN":"MERMAS K4"} {"CODALMACEN":"M05","NOMBREALMACEN":"MERMAS K5 "} {"CODALMACEN":"M06","NOMBREALMACEN":"MERMAS K6"} {"CODALMACEN":"M07","NOMBREALMACEN":"MERMAS K7"} {"CODALMACEN":"M08","NOMBREALMACEN":"MERMAS K8"} {"CODALMACEN":"M09","NOMBREALMACEN":"MERMAS K9"} {"CODALMACEN":"M10","NOMBREALMACEN":"MERMAS K10"} {"CODALMACEN":"M11","NOMBREALMACEN":"MERMAS K11"} {"CODALMACEN":"M12","NOMBREALMACEN":"MERMAS K12"} {"CODALMACEN":"M13","NOMBREALMACEN":"MERMAS K13"} {"CODALMACEN":"M14","NOMBREALMACEN":"MERMAS K14"} {"CODALMACEN":"M16","NOMBREALMACEN":"MERMAS K16"} {"CODALMACEN":"MD1","NOMBREALMACEN":"MERMAS D1"} {"CODALMACEN":"MD2","NOMBREALMACEN":"MERMAS D2"} {"CODALMACEN":"MD4","NOMBREALMACEN":"MERMAS D4"} {"CODALMACEN":"MD5","NOMBREALMACEN":"MERMAS D5"} {"CODALMACEN":"P1","NOMBREALMACEN":"PISO MONTSENY"} {"CODALMACEN":"P2","NOMBREALMACEN":"PISO SEVERO OCHOA"} {"CODALMACEN":"P3","NOMBREALMACEN":"PISO MAS"} {"CODALMACEN":"P4","NOMBREALMACEN":"PISO IBERIA"} {"CODALMACEN":"P5","NOMBREALMACEN":"PISO ISABEL"} {"CODALMACEN":"R1","NOMBREALMACEN":"Tambo Arce "} {"CODALMACEN":"S1","NOMBREALMACEN":"Almacen Rosa Estrella"} {"CODALMACEN":"S2","NOMBREALMACEN":"PEREZ CABRERO #5"} {"CODALMACEN":"S3","NOMBREALMACEN":"LOCAL AV. TIBIDABO"} {"CODALMACEN":"T1","NOMBREALMACEN":"ALMACEN BONANOVA"} {"CODALMACEN":"T4","NOMBREALMACEN":"ALMACEN PLAZA"} {"CODALMACEN":"Z","NOMBREALMACEN":"OBRAS \/ MANTENIMIENTO "} {"CODALMACEN":"Z9","NOMBREALMACEN":"ALMACEN FRUTA\/VERDURA CORTADAS"} {"CODALMACEN":"ZD","NOMBREALMACEN":"OBRAS \/ MANTENIMIENTO (DYLAN)"} == COLUMNAS STOCKS == CODARTICULO int TALLA nvarchar COLOR nvarchar CODALMACEN nvarchar STOCK float PEDIDO float ASERVIR float PRESTADO float DEPOSITO float FABRICACION float MINIMO float FECHAMODIFICADO datetime MAXIMO float UBICACION nvarchar FECHAREGUL datetime STOCKREGUL float ENREPARACION float ENTRANSITO float MERMA float STOCKCONTABLE float STOCK2 float STOCKREGUL2 float == STOCK 148755 (crema berenjena) == {"CODARTICULO":"148755","TALLA":".","COLOR":".","CODALMACEN":"01","STOCK":"-1.0","PEDIDO":"0.0","ASERVIR":"0.0","PRESTADO":"0.0","DEPOSITO":"0.0","FABRICACION":"0.0","MINIMO":"0.0","FECHAMODIFICADO":"2024-05-25 13:53:33.413","MAXIMO":"0.0","UBICACION":"","FECHAREGUL":"1960-01-01 00:00:00.000","STOCKREGUL":"0.0","ENREPARACION":"0.0","ENTRANSITO":"0.0","MERMA":"0.0","STOCKCONTABLE":"0.0","STOCK2":"0.0","STOCKREGUL2":"0.0"} {"CODARTICULO":"148755","TALLA":".","COLOR":".","CODALMACEN":"03","STOCK":"-16.0","PEDIDO":"0.0","ASERVIR":"0.0","PRESTADO":"0.0","DEPOSITO":"0.0","FABRICACION":"0.0","MINIMO":"0.0","FECHAMODIFICADO":"2024-06-06 20:00:52.080","MAXIMO":"0.0","UBICACION":"","FECHAREGUL":"1960-01-01 00:00:00.000","STOCKREGUL":"0.0","ENREPARACION":"0.0","ENTRANSITO":"0.0","MERMA":"0.0","STOCKCONTABLE":"0.0","STOCK2":"0.0","STOCKREGUL2":"0.0"} {"CODARTICULO":"148755","TALLA":".","COLOR":".","CODALMACEN":"05","STOCK":"-6.0","PEDIDO":"0.0","ASERVIR":"0.0","PRESTADO":"0.0","DEPOSITO":"0.0","FABRICACION":"0.0","MINIMO":"0.0","FECHAMODIFICADO":"2024-07-17 19:22:00.963","MAXIMO":"0.0","UBICACION":"","FECHAREGUL":"1960-01-01 00:00:00.000","STOCKREGUL":"0.0","ENREPARACION":"0.0","ENTRANSITO":"0.0","MERMA":"0.0","STOCKCONTABLE":"0.0","STOCK2":"0.0","STOCKREGUL2":"0.0"} {"CODARTICULO":"148755","TALLA":".","COLOR":".","CODALMACEN":"06","STOCK":"-2.0","PEDIDO":"0.0","ASERVIR":"0.0","PRESTADO":"0.0","DEPOSITO":"0.0","FABRICACION":"0.0","MINIMO":"0.0","FECHAMODIFICADO":"2024-05-27 20:36:32.520","MAXIMO":"0.0","UBICACION":"","FECHAREGUL":"1960-01-01 00:00:00.000","STOCKREGUL":"0.0","ENREPARACION":"0.0","ENTRANSITO":"0.0","MERMA":"0.0","STOCKCONTABLE":"0.0","STOCK2":"0.0","STOCKREGUL2":"0.0"} {"CODARTICULO":"148755","TALLA":".","COLOR":".","CODALMACEN":"07","STOCK":"-6.0","PEDIDO":"0.0","ASERVIR":"0.0","PRESTADO":"0.0","DEPOSITO":"0.0","FABRICACION":"0.0","MINIMO":"0.0","FECHAMODIFICADO":"2024-07-16 13:28:47.490","MAXIMO":"0.0","UBICACION":"","FECHAREGUL":"1950-01-01 00:00:00.000","STOCKREGUL":"0.0","ENREPARACION":"0.0","ENTRANSITO":"0.0","MERMA":"0.0","STOCKCONTABLE":"0.0","STOCK2":"0.0","STOCKREGUL2":"0.0"} {"CODARTICULO":"148755","TALLA":".","COLOR":".","CODALMACEN":"08","STOCK":"0.0","PEDIDO":"0.0","ASERVIR":"0.0","PRESTADO":"0.0","DEPOSITO":"0.0","FABRICACION":"0.0","MINIMO":"0.0","FECHAMODIFICADO":"2024-04-19 12:11:32.670","MAXIMO":"0.0","UBICACION":"","FECHAREGUL":"1960-01-01 00:00:00.000","STOCKREGUL":"0.0","ENREPARACION":"0.0","ENTRANSITO":"0.0","MERMA":"0.0","STOCKCONTABLE":"0.0","STOCK2":"0.0","STOCKREGUL2":"0.0"} {"CODARTICULO":"148755","TALLA":".","COLOR":".","CODALMACEN":"09","STOCK":"3.0","PEDIDO":"0.0","ASERVIR":"0.0","PRESTADO":"0.0","DEPOSITO":"0.0","FABRICACION":"0.0","MINIMO":"0.0","FECHAMODIFICADO":"2024-06-27 11:14:26.160","MAXIMO":"0.0","UBICACION":"","FECHAREGUL":"1960-01-01 00:00:00.000","STOCKREGUL":"0.0","ENREPARACION":"0.0","ENTRANSITO":"0.0","MERMA":"0.0","STOCKCONTABLE":"0.0","STOCK2":"0.0","STOCKREGUL2":"0.0"} {"CODARTICULO":"148755","TALLA":".","COLOR":".","CODALMACEN":"10","STOCK":"-6.0","PEDIDO":"0.0","ASERVIR":"0.0","PRESTADO":"0.0","DEPOSITO":"0.0","FABRICACION":"0.0","MINIMO":"0.0","FECHAMODIFICADO":"2024-07-08 21:03:38.990","MAXIMO":"0.0","UBICACION":"","FECHAREGUL":"1960-01-01 00:00:00.000","STOCKREGUL":"0.0","ENREPARACION":"0.0","ENTRANSITO":"0.0","MERMA":"0.0","STOCKCONTABLE":"0.0","STOCK2":"0.0","STOCKREGUL2":"0.0"} {"CODARTICULO":"148755","TALLA":".","COLOR":".","CODALMACEN":"A1","STOCK":"162.0","PEDIDO":"0.0","ASERVIR":"0.0","PRESTADO":"0.0","DEPOSITO":"0.0","FABRICACION":"0.0","MINIMO":"0.0","FECHAMODIFICADO":"2024-05-21 13:04:57.150","MAXIMO":"0.0","UBICACION":"","FECHAREGUL":"1950-01-01 00:00:00.000","STOCKREGUL":"0.0","ENREPARACION":"0.0","ENTRANSITO":"0.0","MERMA":"0.0","STOCKCONTABLE":"0.0","STOCK2":"0.0","STOCKREGUL2":"0.0"} {"CODARTICULO":"148755","TALLA":".","COLOR":".","CODALMACEN":"M01","STOCK":"4.0","PEDIDO":"0.0","ASERVIR":"0.0","PRESTADO":"0.0","DEPOSITO":"0.0","FABRICACION":"0.0","MINIMO":"0.0","FECHAMODIFICADO":"2023-12-06 10:54:40.027","MAXIMO":"0.0","UBICACION":"","FECHAREGUL":"1950-01-01 00:00:00.000","STOCKREGUL":"0.0","ENREPARACION":"0.0","ENTRANSITO":"0.0","MERMA":"0.0","STOCKCONTABLE":"0.0","STOCK2":"0.0","STOCKREGUL2":"0.0"} {"CODARTICULO":"148755","TALLA":".","COLOR":".","CODALMACEN":"M03","STOCK":"5.0","PEDIDO":"0.0","ASERVIR":"0.0","PRESTADO":"0.0","DEPOSITO":"0.0","FABRICACION":"0.0","MINIMO":"0.0","FECHAMODIFICADO":"2024-01-27 14:38:59.200","MAXIMO":"0.0","UBICACION":"","FECHAREGUL":"1950-01-01 00:00:00.000","STOCKREGUL":"0.0","ENREPARACION":"0.0","ENTRANSITO":"0.0","MERMA":"0.0","STOCKCONTABLE":"0.0","STOCK2":"0.0","STOCKREGUL2":"0.0"} {"CODARTICULO":"148755","TALLA":".","COLOR":".","CODALMACEN":"M05","STOCK":"16.0","PEDIDO":"0.0","ASERVIR":"0.0","PRESTADO":"0.0","DEPOSITO":"0.0","FABRICACION":"0.0","MINIMO":"0.0","FECHAMODIFICADO":"2024-07-17 19:22:00.967","MAXIMO":"0.0","UBICACION":"","FECHAREGUL":"1950-01-01 00:00:00.000","STOCKREGUL":"0.0","ENREPARACION":"0.0","ENTRANSITO":"0.0","MERMA":"0.0","STOCKCONTABLE":"0.0","STOCK2":"0.0","STOCKREGUL2":"0.0"} {"CODARTICULO":"148755","TALLA":".","COLOR":".","CODALMACEN":"M07","STOCK":"13.0","PEDIDO":"0.0","ASERVIR":"0.0","PRESTADO":"0.0","DEPOSITO":"0.0","FABRICACION":"0.0","MINIMO":"0.0","FECHAMODIFICADO":"2024-07-16 13:28:47.490","MAXIMO":"0.0","UBICACION":"","FECHAREGUL":"1950-01-01 00:00:00.000","STOCKREGUL":"0.0","ENREPARACION":"0.0","ENTRANSITO":"0.0","MERMA":"0.0","STOCKCONTABLE":"0.0","STOCK2":"0.0","STOCKREGUL2":"0.0"} {"CODARTICULO":"148755","TALLA":".","COLOR":".","CODALMACEN":"M08","STOCK":"1.0","PEDIDO":"0.0","ASERVIR":"0.0","PRESTADO":"0.0","DEPOSITO":"0.0","FABRICACION":"0.0","MINIMO":"0.0","FECHAMODIFICADO":"2024-04-17 11:42:29.320","MAXIMO":"0.0","UBICACION":"","FECHAREGUL":"1950-01-01 00:00:00.000","STOCKREGUL":"0.0","ENREPARACION":"0.0","ENTRANSITO":"0.0","MERMA":"0.0","STOCKCONTABLE":"0.0","STOCK2":"0.0","STOCKREGUL2":"0.0"} {"CODARTICULO":"148755","TALLA":".","COLOR":".","CODALMACEN":"M09","STOCK":"1.0","PEDIDO":"0.0","ASERVIR":"0.0","PRESTADO":"0.0","DEPOSITO":"0.0","FABRICACION":"0.0","MINIMO":"0.0","FECHAMODIFICADO":"2024-06-27 11:14:26.170","MAXIMO":"0.0","UBICACION":"","FECHAREGUL":"1950-01-01 00:00:00.000","STOCKREGUL":"0.0","ENREPARACION":"0.0","ENTRANSITO":"0.0","MERMA":"0.0","STOCKCONTABLE":"0.0","STOCK2":"0.0","STOCKREGUL2":"0.0"} {"CODARTICULO":"148755","TALLA":".","COLOR":".","CODALMACEN":"M10","STOCK":"9.0","PEDIDO":"0.0","ASERVIR":"0.0","PRESTADO":"0.0","DEPOSITO":"0.0","FABRICACION":"0.0","MINIMO":"0.0","FECHAMODIFICADO":"2024-07-08 21:03:38.990","MAXIMO":"0.0","UBICACION":"","FECHAREGUL":"1950-01-01 00:00:00.000","STOCKREGUL":"0.0","ENREPARACION":"0.0","ENTRANSITO":"0.0","MERMA":"0.0","STOCKCONTABLE":"0.0","STOCK2":"0.0","STOCKREGUL2":"0.0"} == TABLAS con REGULARIZ / INVENTARIO == INVENTARIOS INVENTARIOSZONA NUMEROSSERIEREGUL REGULARIZACION TEMP_INVENTARIO_785572_395942 TEMP_INVENTARIO_923565_460108