SELECT Pr_Cve_Producto FROM Producto_Talla_Color WHERE Pr_Cve_Producto = 'F01011503' AND Tl_Cve_Talla = '00' AND Cl_Cve_Color = '00' SELECT * FROM sysobjects WHERE name = 'z_serie' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'COM_PEDIMENTO_GLOBAL' SELECT * FROM Serie WHERE Pr_Cve_Producto = 'F01011503' AND Sr_Cve_Serie in ('CEP9193260014','CEP9193260015','CEP9193260016','CEP9193260017','CEP9193260018','CEP9193260019','CEP9193260020','CEP9193260021','CEP9193260022','CEP9193260023','CEP9193260024','CEP9193260025','CEP9193260026','CEP9193260027','CEP9193260028','CEP9193260029','CEP9193260030','CEP9193260031','CEP9193260032','CEP9193260033','CEP9193260034','CEP9193260035','CEP9193260036','CEP9193260037','CEP9193260038','CEP9193260039','CEP9193260040','CEP9193260041','CEP9193260042','CEP9193260043','CEP9193260044','CEP9193260045','CEP9193260046','CEP9193260047','CEP9193260048','CEP9193260049','CEP9193260050','CEP9193260051','CEP9193260052','CEP9193260053','CEP9193260054','CEP9193260055','CEP9193260056','CEP9193260057','CEP9193260058','CEP9193260059','CEP9193260060','CEP9193260061','CEP9193260062','CEP9193260063','CEP9193260064','CEP9193260065','CEP9193260066','CEP9193260067','CEP9193260068','CEP9193260069','CEP9193260070','CEP9193260071','CEP9193260072','CEP9193260073','CEP9193260074','CEP9193260075','CEP9193260076','CEP9193260077','CEP9193260078','CEP9193260079','CEP9193260080','CEP9193260081','CEP9193260082','CEP9193260083','CEP9193260084','CEP9193260085','CEP9193260086','CEP9193260087','CEP9193260088','CEP9193260089','CEP9193260090','CEP9193260091','CEP9193260092','CEP9193260093','CEP9193260094','CEP9193260095','CEP9193260096','CEP9193260097','CEP9193260098','CEP9193260099','CEP9193260100','CEP9193260101','CEP9193260102','CEP9193260103','CEP9193260104','CEP9193260105','CEP9193260106','CEP9193260107','CEP9193260108','CEP9193260109','CEP9193260110','CEP9193260111','CEP9193260112','CEP9193260113','CEP9193260114','CEP9193260115','CEP9193260116','CEP9193260117','CEP9193260118','CEP9193260119','CEP9193260120','CEP9193260121','CEP9193260122','CEP9193260123','CEP9193260124','CEP9193260125','CEP9193260126','CEP9193260127','CEP9193260128','CEP9193260129','CEP9193260130','CEP9193260131','CEP9193260132','CEP9193260133','CEP9193260134','CEP9193260135','CEP9193260136','CEP9193260137','CEP9193260138','CEP9193260139','CEP9193260140','CEP9193260141','CEP9193260142','CEP9193260143','CEP9193260144','CEP9193260145','CEP9193260146','CEP9193260147','CEP9193260148','CEP9193260149','CEP9193260150','CEP9193260151','CEP9193260152','CEP9193260153','CEP9193260154','CEP9193260155','CEP9193260156','CEP9193260157','CEP9193260158','CEP9193260159','CEP9193260160','CEP9193260161','CEP9193260162','CEP9193260163','CEP9193260164','CEP9193260165','CEP9193260166','CEP9193260167','CEP9193260168','CEP9193260169','CEP9193260170','CEP9193260171','CEP9193260172','CEP9193260173','CEP9193260174','CEP9193260175','CEP9193260176','CEP9193260177','CEP9193260178','CEP9193260179','CEP9193260180','CEP9193260181','CEP9193260182','CEP9193260183','CEP9193260184','CEP9193260185','CEP9193260186','CEP9193260187','CEP9193260188','CEP9193260189','CEP9193260190','CEP9193260191','CEP9193260192','CEP9193260193','CEP9193260194','CEP9193260195','CEP9193260196','CEP9193260197','CEP9193260198','CEP9193260199','CEP9193260200','CEP9193260201','CEP9193260202','CEP9193260203','CEP9193260204','CEP9193260205','CEP9193260206','CEP9193260207','CEP9193260208','CEP9193260209','CEP9193260210','CEP9193260211','CEP9193260212','CEP9193260213','CEP9193260214','CEP9193260215','CEP9193260216','CEP9193260217','CEP9193260218','CEP9193260219','CEP9193260220','CEP9193260221','CEP9193260222','CEP9193260223','CEP9193260224','CEP9193260225','CEP9193260226','CEP9193260227','CEP9193260228','CEP9193260229','CEP9193260230','CEP9193260231','CEP9193260232','CEP9193260233','CEP9193260234','CEP9193260235','CEP9193260236','CEP9193260237','CEP9193260238','CEP9193260239','CEP9193260240','CEP9193260241','CEP9193260242','CEP9193260243','CEP9193260244','CEP9193260245','CEP9193260246','CEP9193260247','CEP9193260248','CEP9193260249','CEP9193260250','CEP9193260251','CEP9193260252','CEP9193260253','CEP9193260254','CEP9193260255','CEP9193260256','CEP9193260257','CEP9193260258','CEP9193260259','CEP9193260260','CEP9193260261','CEP9193260262','CEP9193260263','CEP9193260264','CEP9193260265','CEP9193260266','CEP9193260267','CEP9193260268','CEP9193260269','CEP9193260270','CEP9193260271','CEP9193260272','CEP9193260273','CEP9193260274','CEP9193260275','CEP9193260276','CEP9193260277','CEP9193260278','CEP9193260279','CEP9193260280','CEP9193260281','CEP9193260282','CEP9193260283','CEP9193260284','CEP9193260285','CEP9193260286','CEP9193260287','CEP9193260288','CEP9193260289','CEP9193260290','CEP9193260291','CEP9193260292','CEP9193260293','CEP9193260294','CEP9193260295','CEP9193260296','CEP9193260297','CEP9193260298','CEP9193260299','CEP9193260300','CEP9193260301','CEP9193260302','CEP9193260303','CEP9193260304','CEP9193260305','CEP9193260306','CEP9193260307','CEP9193260308','CEP9193260309','CEP9193260310','CEP9193260311','CEP9193260312','CEP9193260313','CEP9193260314','CEP9193260315','CEP9193260316','CEP9193260317','CEP9193260318','CEP9193260319','CEP9193260320','CEP9193260321','CEP9193260322','CEP9193260323','CEP9193260324','CEP9193260325','CEP9193260326','CEP9193260327','CEP9193260328','CEP9193260329','CEP9193260330','CEP9193260331','CEP9193260332','CEP9193260333','CEP9193260334','CEP9193260335','CEP9193260336','CEP9193260337','CEP9193260338','CEP9193260339','CEP9193260340','CEP9193260341','CEP9193260342','CEP9193260343','CEP9193260344','CEP9193260345','CEP9193260346','CEP9193260347','CEP9193260348','CEP9193260349','CEP9193260350','CEP9193260351','CEP9193260352','CEP9193260353','CEP9193260354','CEP9193260355','CEP9193260356','CEP9193260357','CEP9193260358','CEP9193260359','CEP9193260360','CEP9193260361','CEP9193260362','CEP9193260363','CEP9193260364','CEP9193260365','CEP9193260366','CEP9193260367','CEP9193260368','CEP9193260369','CEP9193260370','CEP9193260371','CEP9193260372','CEP9193260373','CEP9193260374','CEP9193260375','CEP9193260376','CEP9193260377','CEP9193260378','CEP9193260379','CEP9193260380','CEP9193260381','CEP9193260382','CEP9193260383','CEP9193260384','CEP9193260385','CEP9193260386','CEP9193260387','CEP9193260388','CEP9193260389','CEP9193260390','CEP9193260391','CEP9193260392','CEP9193260393','CEP9193260394','CEP9193260395','CEP9193260396','CEP9193260397','CEP9193260398','CEP9193260399','CEP9193260400','CEP9193260401','CEP9193260402','CEP9193260403','CEP9193260404','CEP9193260405','CEP9193260406','CEP9193260407','CEP9193260408','CEP9193260409','CEP9193260410','CEP9193260411','CEP9193260412','CEP9193260413','CEP9193260414','CEP9193260415','CEP9193260416','CEP9193260417','CEP9193260418','CEP9193260419','CEP9193260420','CEP9193260421','CEP9193260422','CEP9193260423','CEP9193260424','CEP9193260425','CEP9193260426','CEP9193260427','CEP9193260428','CEP9193260429','CEP9193260430','CEP9193260431','CEP9193260432','CEP9193260433','CEP9193260434','CEP9193260435','CEP9193260436','CEP9193260437','CEP9193260438','CEP9193260439','CEP9193260440','CEP9193260441','CEP9193260442','CEP9193260443','CEP9193260444','CEP9193260445','CEP9193260446','CEP9193260447','CEP9193260448','CEP9193260449','CEP9193260450','CEP9193260451','CEP9193260452','CEP9193260453','CEP9193260454','CEP9193260455','CEP9193260456','CEP9193260457','CEP9193260458','CEP9193260459','CEP9193260460','CEP9193260461','CEP9193260462','CEP9193260463','CEP9193260464','CEP9193260465','CEP9193260466','CEP9193260467','CEP9193260468','CEP9193260469','CEP9193260470','CEP9193260471','CEP9193260472','CEP9193260473','CEP9193260474','CEP9193260475','CEP9193260476','CEP9193260477','CEP9193260478','CEP9193260479','CEP9193260480','CEP9193260481','CEP9193260482','CEP9193260483','CEP9193260484','CEP9193260485','CEP9193260486','CEP9193260487','CEP9193260488','CEP9193260489','CEP9193260490','CEP9193260491','CEP9193260492','CEP9193260493','CEP9193260494','CEP9193260495','CEP9193260496','CEP9193260497','CEP9193260498','CEP9193260499','CEP9193260500','CEP9193260501','CEP9193260502','CEP9193260503','CEP9193260504','CEP9193260505','CEP9193260506','CEP9193260507','CEP9193260508','CEP9193260509','CEP9193260510','CEP9193260511','CEP9193260512','CEP9193260513','CEP9193260514','CEP9193260515','CEP9193260516','CEP9193260517','CEP9193260518','CEP9193260519','CEP9193260520','CEP9193260521','CEP9193260522','CEP9193260523','CEP9193260524','CEP9193260525','CEP9193260526','CEP9193260527','CEP9193260528','CEP9193260529','CEP9193260530','CEP9193260531','CEP9193260532','CEP9193260533','CEP9193260534','CEP9193260535','CEP9193260536','CEP9193260537','CEP9193260538','CEP9193260539','CEP9193260540','CEP9193260541','CEP9193260542','CEP9193260543','CEP9193260544','CEP9193260545','CEP9193260546','CEP9193260547','CEP9193260548','CEP9193260549','CEP9193260550','CEP9193260551','CEP9193260552','CEP9193260553','CEP9193260554','CEP9193260555','CEP9193260556','CEP9193260557','CEP9193260558','CEP9193260559','CEP9193260560','CEP9193260561','CEP9193260562','CEP9193260563','CEP9193260564','CEP9193260565','CEP9193260566','CEP9193260567','CEP9193260568','CEP9193260569','CEP9193260570','CEP9193260571','CEP9193260572','CEP9193260573','CEP9193260574','CEP9193260575','CEP9193260576','CEP9193260577','CEP9193260578','CEP9193260579','CEP9193260580','CEP9193260581','CEP9193260582','CEP9193260583','CEP90') AND Es_Cve_Estado = 'APT' INSERT INTO Venta (Vn_Folio, Vn_ID, Vn_Fecha, Vn_Tabla, Vn_Documento, Vn_Referencia, Fc_Factura, Vn_Comentario, Vn_Fecha_Vencimiento, Sc_Cve_Sucursal, Al_Cve_Almacen, Vn_Descuento_Global_Cuenta_Contable, Vn_Descuento_Global_Factor, Vn_Descuento_Global_Importe, Cl_Cve_Cliente, Vn_Cve_Vendedor, Vn_Concepto, Vn_Sucursal_Inventario, Vn_Almacen_Inventario, Pr_Cve_Producto, Tl_Cve_Talla, Cl_Cve_Color, Vn_Ubicacion, Vn_Cuota_Fija,Vn_Cantidad_1, Vn_Unidad_1, Vn_Cantidad_Control_1, Vn_Unidad_Control_1, Vn_Cantidad_Control_2, Vn_Unidad_Control_2, Vn_Cantidad_Costo, Vn_Unidad_Costo, Vn_Costo, Vn_Costo_Importe, Pr_Folio, Vn_Precio_Lista, Vn_Precio_Lista_Importe, Vn_Descuento_Factor, Vn_Descuento_Importe, Vn_Precio_Descontado, Vn_Precio_Descontado_Importe, Vn_Impuesto_Factor, Vn_Impuesto_Importe, Vn_Precio_Neto, Vn_Precio_Neto_Importe, Mn_Cve_Moneda, Vn_Tipo_Cambio, Vk_Id, Vn_Sin_Cargo, Lt_Cve_Lote, Lt_Fecha_Caducidad, Lt_Pedimento, Lt_Fecha_Pedimento, Oper_Alta, Fecha_Alta, Oper_Ult_Modif, Fecha_Ult_Modif, Vn_Inventario_Pendiente) VALUES ('04-0000423', '0001', '2019-09-05', 'COTIZACION', '04-0000267', '857', '', 'ZKMX20190709-021/1', '2019-09-05', '0004', '0001', '', 0, 0, '0000000027', '0000000008', 'Time & Attendance device / with customization in .bin format / no ZKTeco logo on internal spare par', '0004', '0001', 'F01011503', '00', '00', '', 0,600, 'PZ', 600, 'PZ', 600, 'PZ', 600, 'PZ', 717.12, 430272, '', 42, 25200, 0, 0, 42, 25200, 0.16, 4032, 48.72, 29232, 'USD', 20.0039, '', 'NO', '', '1899-12-30', '', '1899-12-30', 'ALMACEN', '2019-09-05 16:50:38', 'ALMACEN', '2019-09-05 16:50:38', 'NO') SELECT Un_Descripcion AS Nombre FROM Unidad WHERE Un_Cve_Unidad = 'PZ' AND Es_Cve_Estado <> 'BA' SELECT Pr_Cve_Producto FROM Producto_Talla_Color WHERE Pr_Cve_Producto = 'F01011503' AND Tl_Cve_Talla = '00' AND Cl_Cve_Color = '00' SELECT Al_Descripcion AS Nombre FROM Almacen WHERE Al_Cve_Almacen = '0001' AND Sc_Cve_Sucursal = '0004' AND Es_Cve_Estado <> 'BA' SELECT Tipo_Movimiento.Tm_Anulacion, Tipo_Movimiento.Tm_Cve_Tipo_Movimiento, Tipo_Movimiento.Tm_Tipo FROM Tipo_Movimiento WHERE Tipo_Movimiento.Tm_Cve_Tipo_Movimiento = '700' AND Es_Cve_Estado <> 'BA' SELECT Al_Controlar_Ubicacion as bRes FROM Almacen WHERE Sc_Cve_Sucursal = '0004' AND Al_Cve_Almacen = '0001' SELECT Al_Controlar_Serie as bRes FROM Almacen WHERE Sc_Cve_Sucursal = '0004' AND Al_Cve_Almacen = '0001' SELECT Al_Controlar_Lote as bRes FROM Almacen WHERE Sc_Cve_Sucursal = '0004' AND Al_Cve_Almacen = '0001' SELECT Al_Controlar_Color as bRes FROM Almacen WHERE Sc_Cve_Sucursal = '0004' AND Al_Cve_Almacen = '0001' SELECT Al_Controlar_Talla as bRes FROM Almacen WHERE Sc_Cve_Sucursal = '0004' AND Al_Cve_Almacen = '0001' SELECT Al_Sucursal_Inventario, Al_Almacen_Inventario FROM Almacen WHERE Sc_Cve_Sucursal = '0004' AND Al_Cve_Almacen = '0001' SELECT Sc_Servidor_Id AS Nombre FROM Sucursal WHERE Sc_Cve_Sucursal = '0004' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'MOV_SALIDA_VENTA' SELECT GetDate() as Fecha SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'MOV_VALIDAR_EXISTENCIA_KIT' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'MOV_SALIDA_AJUSTE' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'MOV_ENTRADA_AJUSTE' INSERT INTO Venta_Encabezado (Vn_Folio, Vn_Fecha, Vn_Tabla, Vn_Documento, Vn_Referencia, Fc_Factura, Vn_Comentario, Vn_Fecha_Vencimiento, Sc_Cve_Sucursal, Al_Cve_Almacen, Vn_Descuento_Global_Factor, Vn_Descuento_Global_Importe, Cl_Cve_Cliente, Vn_Cve_Vendedor, Mn_Cve_Moneda, Vn_Tipo_Cambio, Vn_Moneda_Original, Vn_Tipo_Cambio_Original, Vn_Sin_Cargo, Fc_Folio,Vn_Credito,Vn_Condicion_Venta,Vn_Aplicado,Vn_Pedido,Vn_Precio_Lista_Importe,Vn_Descuento_Importe,Vn_Precio_Descontado_Importe,Vn_Impuesto_Importe,Vn_Precio_Neto_Importe,Oper_Alta, Fecha_Alta, Oper_Ult_Modif, Fecha_Ult_Modif, Vn_Inventario_Pendiente, Vn_Folio_Web ) VALUES ('04-0000423', '2019-09-05', 'COTIZACION', '04-0000267', '857', '', 'ZKMX20190709-021/1', '2019-09-05', '0004', '0001', 0, 0, '0000000027', '0000000008', 'USD', 20.0039, 'USD', 20.0039, 'NO', '','NO','','NO','',0,0,0,0,0,'ALMACEN', '2019-09-05 16:50:38', 'ALMACEN', '2019-09-05 16:50:38', 'NO','04-0000423') SELECT GetDate() as Fecha SELECT Sc_Prefijo_General as Campo FROM Sucursal WHERE Sc_Cve_Sucursal = '0004' SELECT Fl_Folio FROM Folio_Sucursal WHERE Sc_Cve_Sucursal = '0004' AND Fl_Tabla = 'VENTA' UPDATE Folio_Sucursal SET Fl_Folio = Fl_Folio + 1 WHERE Sc_Cve_Sucursal = '0004' AND Fl_Tabla = 'VENTA' SELECT Fl_Folio FROM Folio_Sucursal WHERE Sc_Cve_Sucursal = '0004' AND Fl_Tabla = 'VENTA' SELECT Sc_Descripcion AS Nombre FROM Sucursal WHERE Sc_Cve_Sucursal = '0004' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_FOLIO_X_SUCURSAL' SELECT Cl_Bloqueado AS Nombre FROM Cliente WHERE Cl_Cve_Cliente = '0000000027' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'VEN_VALIDAR_CLIENTE_BLOQUEADO' SELECT Cl_Descripcion AS Nombre FROM Cliente WHERE Cl_Cve_Cliente = '0000000027' AND Es_Cve_Estado <> 'BA' SELECT Vn_Descripcion AS Nombre FROM Vendedor WHERE Vn_Cve_Vendedor = '0000000008' AND Es_Cve_Estado <> 'BA' SELECT Al_Descripcion AS Nombre FROM Almacen WHERE Al_Cve_Almacen = '0001' AND Sc_Cve_Sucursal = '0004' AND Es_Cve_Estado <> 'BA' SELECT Mn_Descripcion AS Nombre FROM Moneda WHERE Mn_Cve_Moneda = 'USD' AND Es_Cve_Estado <> 'BA' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_VALIDAR_PERIODO_OPERATIVO' SELECT Impuesto.Im_Cve_Impuesto, Impuesto.Im_Tasa, Impuesto.Im_Cuenta_Contable, Impuesto.Im_Forma_Aplicacion, Impuesto.Im_Tasa_Variable FROM Impuesto INNER JOIN Impuesto_Grupo_Impuesto ON Impuesto.Im_Cve_Impuesto = Impuesto_Grupo_Impuesto.Im_Cve_Impuesto WHERE Impuesto.Es_Cve_Estado = 'AC' AND Impuesto_Grupo_Impuesto.Gi_Cve_Grupo_Impuesto = '0010' AND Impuesto_Grupo_Impuesto.Pr_Cve_Producto = 'F01011503' ORDER BY Impuesto_Grupo_Impuesto.Orden_Aplicacion SELECT Cl_Grupo_Impuesto FROM Cliente WHERE Cl_Cve_Cliente = '0000000027' SELECT Impuesto.Im_Cve_Impuesto, Impuesto.Im_Tasa, Impuesto.Im_Cuenta_Contable, Impuesto.Im_Forma_Aplicacion, Impuesto.Im_Tasa_Variable FROM Impuesto INNER JOIN Impuesto_Grupo_Impuesto ON Impuesto.Im_Cve_Impuesto = Impuesto_Grupo_Impuesto.Im_Cve_Impuesto WHERE Impuesto.Es_Cve_Estado = 'AC' AND Impuesto_Grupo_Impuesto.Gi_Cve_Grupo_Impuesto = '0010' AND Impuesto_Grupo_Impuesto.Pr_Cve_Producto = 'F01011503' ORDER BY Impuesto_Grupo_Impuesto.Orden_Aplicacion SELECT Cl_Grupo_Impuesto FROM Cliente WHERE Cl_Cve_Cliente = '0000000027' SELECT AVG(Sr_Costo) as Sr_Costo FROM Serie WHERE Pr_Cve_Producto = 'F01011503' AND Sr_Cve_Serie in ('CEP9193260014','CEP9193260015','CEP9193260016','CEP9193260017','CEP9193260018','CEP9193260019','CEP9193260020','CEP9193260021','CEP9193260022','CEP9193260023','CEP9193260024','CEP9193260025','CEP9193260026','CEP9193260027','CEP9193260028','CEP9193260029','CEP9193260030','CEP9193260031','CEP9193260032','CEP9193260033','CEP9193260034','CEP9193260035','CEP9193260036','CEP9193260037','CEP9193260038','CEP9193260039','CEP9193260040','CEP9193260041','CEP9193260042','CEP9193260043','CEP9193260044','CEP9193260045','CEP9193260046','CEP9193260047','CEP9193260048','CEP9193260049','CEP9193260050','CEP9193260051','CEP9193260052','CEP9193260053','CEP9193260054','CEP9193260055','CEP9193260056','CEP9193260057','CEP9193260058','CEP9193260059','CEP9193260060','CEP9193260061','CEP9193260062','CEP9193260063','CEP9193260064','CEP9193260065','CEP9193260066','CEP9193260067','CEP9193260068','CEP9193260069','CEP9193260070','CEP9193260071','CEP9193260072','CEP9193260073','CEP9193260074','CEP9193260075','CEP9193260076','CEP9193260077','CEP9193260078','CEP9193260079','CEP9193260080','CEP9193260081','CEP9193260082','CEP9193260083','CEP9193260084','CEP9193260085','CEP9193260086','CEP9193260087','CEP9193260088','CEP9193260089','CEP9193260090','CEP9193260091','CEP9193260092','CEP9193260093','CEP9193260094','CEP9193260095','CEP9193260096','CEP9193260097','CEP9193260098','CEP9193260099','CEP9193260100','CEP9193260101','CEP9193260102','CEP9193260103','CEP9193260104','CEP9193260105','CEP9193260106','CEP9193260107','CEP9193260108','CEP9193260109','CEP9193260110','CEP9193260111','CEP9193260112','CEP9193260113','CEP9193260114','CEP9193260115','CEP9193260116','CEP9193260117','CEP9193260118','CEP9193260119','CEP9193260120','CEP9193260121','CEP9193260122','CEP9193260123','CEP9193260124','CEP9193260125','CEP9193260126','CEP9193260127','CEP9193260128','CEP9193260129','CEP9193260130','CEP9193260131','CEP9193260132','CEP9193260133','CEP9193260134','CEP9193260135','CEP9193260136','CEP9193260137','CEP9193260138','CEP9193260139','CEP9193260140','CEP9193260141','CEP9193260142','CEP9193260143','CEP9193260144','CEP9193260145','CEP9193260146','CEP9193260147','CEP9193260148','CEP9193260149','CEP9193260150','CEP9193260151','CEP9193260152','CEP9193260153','CEP9193260154','CEP9193260155','CEP9193260156','CEP9193260157','CEP9193260158','CEP9193260159','CEP9193260160','CEP9193260161','CEP9193260162','CEP9193260163','CEP9193260164','CEP9193260165','CEP9193260166','CEP9193260167','CEP9193260168','CEP9193260169','CEP9193260170','CEP9193260171','CEP9193260172','CEP9193260173','CEP9193260174','CEP9193260175','CEP9193260176','CEP9193260177','CEP9193260178','CEP9193260179','CEP9193260180','CEP9193260181','CEP9193260182','CEP9193260183','CEP9193260184','CEP9193260185','CEP9193260186','CEP9193260187','CEP9193260188','CEP9193260189','CEP9193260190','CEP9193260191','CEP9193260192','CEP9193260193','CEP9193260194','CEP9193260195','CEP9193260196','CEP9193260197','CEP9193260198','CEP9193260199','CEP9193260200','CEP9193260201','CEP9193260202','CEP9193260203','CEP9193260204','CEP9193260205','CEP9193260206','CEP9193260207','CEP9193260208','CEP9193260209','CEP9193260210','CEP9193260211','CEP9193260212','CEP9193260213','CEP9193260214','CEP9193260215','CEP9193260216','CEP9193260217','CEP9193260218','CEP9193260219','CEP9193260220','CEP9193260221','CEP9193260222','CEP9193260223','CEP9193260224','CEP9193260225','CEP9193260226','CEP9193260227','CEP9193260228','CEP9193260229','CEP9193260230','CEP9193260231','CEP9193260232','CEP9193260233','CEP9193260234','CEP9193260235','CEP9193260236','CEP9193260237','CEP9193260238','CEP9193260239','CEP9193260240','CEP9193260241','CEP9193260242','CEP9193260243','CEP9193260244','CEP9193260245','CEP9193260246','CEP9193260247','CEP9193260248','CEP9193260249','CEP9193260250','CEP9193260251','CEP9193260252','CEP9193260253','CEP9193260254','CEP9193260255','CEP9193260256','CEP9193260257','CEP9193260258','CEP9193260259','CEP9193260260','CEP9193260261','CEP9193260262','CEP9193260263','CEP9193260264','CEP9193260265','CEP9193260266','CEP9193260267','CEP9193260268','CEP9193260269','CEP9193260270','CEP9193260271','CEP9193260272','CEP9193260273','CEP9193260274','CEP9193260275','CEP9193260276','CEP9193260277','CEP9193260278','CEP9193260279','CEP9193260280','CEP9193260281','CEP9193260282','CEP9193260283','CEP9193260284','CEP9193260285','CEP9193260286','CEP9193260287','CEP9193260288','CEP9193260289','CEP9193260290','CEP9193260291','CEP9193260292','CEP9193260293','CEP9193260294','CEP9193260295','CEP9193260296','CEP9193260297','CEP9193260298','CEP9193260299','CEP9193260300','CEP9193260301','CEP9193260302','CEP9193260303','CEP9193260304','CEP9193260305','CEP9193260306','CEP9193260307','CEP9193260308','CEP9193260309','CEP9193260310','CEP9193260311','CEP9193260312','CEP9193260313','CEP9193260314','CEP9193260315','CEP9193260316','CEP9193260317','CEP9193260318','CEP9193260319','CEP9193260320','CEP9193260321','CEP9193260322','CEP9193260323','CEP9193260324','CEP9193260325','CEP9193260326','CEP9193260327','CEP9193260328','CEP9193260329','CEP9193260330','CEP9193260331','CEP9193260332','CEP9193260333','CEP9193260334','CEP9193260335','CEP9193260336','CEP9193260337','CEP9193260338','CEP9193260339','CEP9193260340','CEP9193260341','CEP9193260342','CEP9193260343','CEP9193260344','CEP9193260345','CEP9193260346','CEP9193260347','CEP9193260348','CEP9193260349','CEP9193260350','CEP9193260351','CEP9193260352','CEP9193260353','CEP9193260354','CEP9193260355','CEP9193260356','CEP9193260357','CEP9193260358','CEP9193260359','CEP9193260360','CEP9193260361','CEP9193260362','CEP9193260363','CEP9193260364','CEP9193260365','CEP9193260366','CEP9193260367','CEP9193260368','CEP9193260369','CEP9193260370','CEP9193260371','CEP9193260372','CEP9193260373','CEP9193260374','CEP9193260375','CEP9193260376','CEP9193260377','CEP9193260378','CEP9193260379','CEP9193260380','CEP9193260381','CEP9193260382','CEP9193260383','CEP9193260384','CEP9193260385','CEP9193260386','CEP9193260387','CEP9193260388','CEP9193260389','CEP9193260390','CEP9193260391','CEP9193260392','CEP9193260393','CEP9193260394','CEP9193260395','CEP9193260396','CEP9193260397','CEP9193260398','CEP9193260399','CEP9193260400','CEP9193260401','CEP9193260402','CEP9193260403','CEP9193260404','CEP9193260405','CEP9193260406','CEP9193260407','CEP9193260408','CEP9193260409','CEP9193260410','CEP9193260411','CEP9193260412','CEP9193260413','CEP9193260414','CEP9193260415','CEP9193260416','CEP9193260417','CEP9193260418','CEP9193260419','CEP9193260420','CEP9193260421','CEP9193260422','CEP9193260423','CEP9193260424','CEP9193260425','CEP9193260426','CEP9193260427','CEP9193260428','CEP9193260429','CEP9193260430','CEP9193260431','CEP9193260432','CEP9193260433','CEP9193260434','CEP9193260435','CEP9193260436','CEP9193260437','CEP9193260438','CEP9193260439','CEP9193260440','CEP9193260441','CEP9193260442','CEP9193260443','CEP9193260444','CEP9193260445','CEP9193260446','CEP9193260447','CEP9193260448','CEP9193260449','CEP9193260450','CEP9193260451','CEP9193260452','CEP9193260453','CEP9193260454','CEP9193260455','CEP9193260456','CEP9193260457','CEP9193260458','CEP9193260459','CEP9193260460','CEP9193260461','CEP9193260462','CEP9193260463','CEP9193260464','CEP9193260465','CEP9193260466','CEP9193260467','CEP9193260468','CEP9193260469','CEP9193260470','CEP9193260471','CEP9193260472','CEP9193260473','CEP9193260474','CEP9193260475','CEP9193260476','CEP9193260477','CEP9193260478','CEP9193260479','CEP9193260480','CEP9193260481','CEP9193260482','CEP9193260483','CEP9193260484','CEP9193260485','CEP9193260486','CEP9193260487','CEP9193260488','CEP9193260489','CEP9193260490','CEP9193260491','CEP9193260492','CEP9193260493','CEP9193260494','CEP9193260495','CEP9193260496','CEP9193260497','CEP9193260498','CEP9193260499','CEP9193260500','CEP9193260501','CEP9193260502','CEP9193260503','CEP9193260504','CEP9193260505','CEP9193260506','CEP9193260507','CEP9193260508','CEP9193260509','CEP9193260510','CEP9193260511','CEP9193260512','CEP9193260513','CEP9193260514','CEP9193260515','CEP9193260516','CEP9193260517','CEP9193260518','CEP9193260519','CEP9193260520','CEP9193260521','CEP9193260522','CEP9193260523','CEP9193260524','CEP9193260525','CEP9193260526','CEP9193260527','CEP9193260528','CEP9193260529','CEP9193260530','CEP9193260531','CEP9193260532','CEP9193260533','CEP9193260534','CEP9193260535','CEP9193260536','CEP9193260537','CEP9193260538','CEP9193260539','CEP9193260540','CEP9193260541','CEP9193260542','CEP9193260543','CEP9193260544','CEP9193260545','CEP9193260546','CEP9193260547','CEP9193260548','CEP9193260549','CEP9193260550','CEP9193260551','CEP9193260552','CEP9193260553','CEP9193260554','CEP9193260555','CEP9193260556','CEP9193260557','CEP9193260558','CEP9193260559','CEP9193260560','CEP9193260561','CEP9193260562','CEP9193260563','CEP9193260564','CEP9193260565','CEP9193260566','CEP9193260567','CEP9193260568','CEP9193260569','CEP9193260570','CEP9193260571','CEP9193260572','CEP9193260573','CEP9193260574','CEP9193260575','CEP9193260576','CEP9193260577','CEP9193260578','CEP9193260579','CEP9193260580','CEP9193260581','CEP9193260582','CEP9193260583','CEP90') SELECT Pr_Tipo_Costeo FROM Producto WHERE Pr_Cve_Producto = 'F01011503' SELECT Producto.Pr_Tipo_Producto, Producto.Pr_Tipo_Costeo, Producto.Pr_Unidad_Control_1, Producto.Pr_Unidad_Control_2, Producto.Pr_Unidad_Costo FROM Producto WHERE Producto.Pr_Cve_Producto = 'F01011503' SELECT Al_Controlar_Ubicacion as bRes FROM Almacen WHERE Sc_Cve_Sucursal = '0004' AND Al_Cve_Almacen = '0001' SELECT Al_Controlar_Serie as bRes FROM Almacen WHERE Sc_Cve_Sucursal = '0004' AND Al_Cve_Almacen = '0001' SELECT Al_Controlar_Lote as bRes FROM Almacen WHERE Sc_Cve_Sucursal = '0004' AND Al_Cve_Almacen = '0001' SELECT Al_Controlar_Color as bRes FROM Almacen WHERE Sc_Cve_Sucursal = '0004' AND Al_Cve_Almacen = '0001' SELECT Al_Controlar_Talla as bRes FROM Almacen WHERE Sc_Cve_Sucursal = '0004' AND Al_Cve_Almacen = '0001' SELECT Un_Unidad_Cubicada AS Nombre FROM Unidad WHERE Un_Cve_Unidad = 'PZ' SELECT Al_Controlar_Ubicacion as bRes FROM Almacen WHERE Sc_Cve_Sucursal = '0004' AND Al_Cve_Almacen = '0001'