SELECT SQL FROM EMPRESAS..Consultas WHERE Clave = 'PRODUCTO_POS'
SELECT SQL FROM EMPRESAS..Consultas WHERE Clave = 'PRODUCTO_POS'
SELECT SQL FROM EMPRESAS..Consultas WHERE Clave = 'PRODUCTO_POS'
SELECT SQL FROM EMPRESAS..Consultas WHERE Clave = 'PRODUCTO_POS'
SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'FTTK02' ORDER BY Fr_ID
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'EMP_RFC'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'EMP_RAZON_SOCIAL'
SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'FTTK02' ORDER BY Fr_ID
EXEC SP_RPT_FTTK02_1 '0001'
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'FTTK02' ORDER BY Fr_ID
EXEC SP_RPT_FTTK02_2 '0001'
SELECT TOP 1      Fr_Procedure1,      Fr_Procedure2,      Fr_Procedure3,      Fr_LineasDetalle,      Fr_Caida_Libre FROM      Formato WHERE      Fr_Cve_Formato = 'FTTK02'
SELECT Mn_Impresion_Letras, Mn_Impresion_Moneda FROM Moneda WHERE Mn_Cve_Moneda = 'MXN'
SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'VNTK01' ORDER BY Fr_ID
EXEC SP_RPT_VNTK01_3 '01-0015006'
SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'FTTK01' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'FTTK01' ORDER BY Fr_ID
EXEC SP_RPT_FTTK01_1 '0001'
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'FTTK01' ORDER BY Fr_ID
EXEC SP_RPT_FTTK01_2 '0001'
SELECT TOP 1      Fr_Procedure1,      Fr_Procedure2,      Fr_Procedure3,      Fr_LineasDetalle,      Fr_Caida_Libre FROM      Formato WHERE      Fr_Cve_Formato = 'FTTK01'
SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'VNTK01' ORDER BY Fr_ID
EXEC SP_RPT_VNTK01_1 '01-0015006'
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'VNTK01' ORDER BY Fr_ID
EXEC SP_RPT_VNTK01_2 '01-0015006'
SELECT TOP 1      Fr_Procedure1,      Fr_Procedure2,      Fr_Procedure3,      Fr_LineasDetalle,      Fr_Caida_Libre FROM      Formato WHERE      Fr_Cve_Formato = 'VNTK01'
SELECT Vn_Credito AS Nombre FROM Venta_Encabezado WHERE Vn_Folio = '01-0015006'
SELECT Cl_Descripcion AS Nombre FROM CLIENTE WHERE Cl_Cve_cliente = '0000000001'
*** COMMIT ***
SELECT    Obj.name AS Nombre,    Obj.type AS Tipo,    Obj.type_desc AS nTiop,    Modu.definition AS Consulta FROM LACASADELBEBE.sys.objects Obj    INNER JOIN LACASADELBEBE.sys.sql_modules Modu ON Obj.object_id = Modu.object_id WHERE    (Obj.name IN (SELECT Ats_Sp FROM Afectar_Tabla_Sp WHERE At_Tabla = 'VENTA' AND    Es_Cve_Estado <> 'BA') ) AND    Obj.type = 'P' ORDER BY Obj.name ASC 
SELECT @@VERSION AS xVersion 
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_VERSION_SQL_AFECTAR'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_HISTORIAL_SEGUIMIENTO'
SELECT Cl_Cve_Cliente AS Nombre FROM Venta WHERE Vn_Folio = '01-0015006'
SELECT Vn_Fecha AS Nombre FROM Venta WHERE Vn_Folio = '01-0015006'
SELECT    Poliza_Configuracion.Pc_Cve_Poliza_Configuracion,    Poliza_Configuracion.Pc_Descripcion,    Poliza_Configuracion.Pc_Tabla FROM Poliza_Configuracion    INNER JOIN Poliza_Configuracion_Tabla ON Poliza_Configuracion.Pc_Tabla = Poliza_Configuracion_Tabla.Pc_Tabla WHERE    Poliza_Configuracion_Tabla.Pc_Tabla = 'VENTA' AND    Poliza_Configuracion.Es_Cve_Estado <> 'BA' AND Poliza_Configuracion_Tabla.Pc_Contabiliza_Linea = 'SI' 
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_TABLA_GRABA_COMPROBANTE'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'CON_CENTRO_COSTO_OBLIGATORIO'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'CON_PERIODO_ACTUAL'
SELECT GetDate() as Fecha
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'CON_EJERCICIO_ACTUAL'
SELECT GetDate() as Fecha
UPDATE Venta_Encabezado SET    Vn_Descuento_Global_Importe = 0,   Vn_Precio_Lista_Importe = 99.137931,   Vn_Descuento_Importe = 0,   Vn_Precio_Descontado_Importe = 99.137931,   Vn_Impuesto_Importe = 15.86206896,   Vn_Precio_Neto_Importe = 114.99999996,    Vn_Folio_Web = (       SELECT           LEFT(RIGHT(CL.Cl_R_F_C, 3), 2) +            CAST(CAST( LEFT(RIGHT(VE.Vn_Folio, 7), 3) as numeric(18,0)) as nvarchar) +            LEFT(RIGHT('0' + CAST(DAY(VE.Vn_Fecha) AS NVARCHAR(2)), 2), 1) +            LEFT(RIGHT(CL.Cl_R_F_C, 7), 2) +            LEFT(VE.Vn_Folio, 2) +            RIGHT('0' + CAST(MONTH(VE.Vn_Fecha) AS NVARCHAR(2)), 2) +            RIGHT(LEFT(CL.Cl_R_F_C, 3), 2) +            CAST(CAST(RIGHT(VE.Vn_Folio, 3) as numeric(18,0)) as nvarchar) +            RIGHT(LEFT(VE.Vn_Condicion_Venta, 2), 1) +            RIGHT(RIGHT('0' + CAST(DAY(VE.Vn_Fecha) AS NVARCHAR(2)), 2), 1)        FROM Venta_Encabezado VE            INNER JOIN Sucursal SU ON VE.Sc_Cve_Sucursal = SU.Sc_Cve_Sucursal           INNER JOIN Cliente CL ON VE.Cl_Cve_Cliente = CL.Cl_Cve_Cliente       WHERE VE.Vn_Folio = Venta_Encabezado.Vn_Folio) WHERE    Vn_Folio = '01-0015006' 
INSERT INTO Venta_Total_Impuesto(Vn_Folio,Vt_ID,Vt_Impuesto,Vt_SubTotal_Importe,Vt_Impuesto_Importe,Vt_Total_Importe ) VALUES ('01-0015006','0001','0013',99.137931,15.86206896,114.99999996)
SELECT    isnull(SUM(isnull(Venta_Impuesto.Vi_Base,0)),0) as Base,    isnull(SUM(isnull(Venta_Impuesto.Im_Importe,0)),0) as Importe,    ISNULL(Impuesto.Im_Cve_Impuesto,'') as Impuesto,    ISNULL(Impuesto.Im_Tasa,0) / 100 as Tasa FROM Venta    LEFT JOIN Venta_Impuesto on Venta.Vn_Folio = Venta_Impuesto.Vn_Folio and Venta.Vn_ID = Venta_Impuesto.Vn_ID    LEFT JOIN Impuesto on Impuesto.Im_Cve_Impuesto = Venta_Impuesto.Im_Cve_Impuesto WHERE Venta.Vn_Folio = '01-0015006' GROUP BY    Impuesto.Im_Cve_Impuesto,    Impuesto.Im_Tasa,    Impuesto.Im_Descripcion ORDER BY Tasa DESC 
SELECT    ISNULL(SUM(Vn_Precio_Lista_Importe),0) as Vn_Precio_Lista_Importe,    ISNULL(SUM(Vn_Descuento_Importe),0) as Vn_Descuento_Importe,   ISNULL(SUM(Vn_Precio_Descontado_Importe),0) as Vn_Precio_Descontado_Importe,    ISNULL(SUM(Vn_Descuento_Global_Importe),0) as Vn_Descuento_Global_Importe FROM Venta WHERE Vn_Folio = '01-0015006' 
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'VEN_MODO_TOTALIZA_IMPUESTO'
UPDATE Venta_Encabezado SET Vn_Condicion_Venta = 'CONT' WHERE Vn_Folio = '01-0015006'
UPDATE Venta SET Vn_Condicion_Venta = 'CONT' WHERE Vn_Folio = '01-0015006'
INSERT INTO POS_Pagos (   Cj_Cve_Caja,    Ca_Cve_Cajero,    Cj_Transaccion,    POS_ID,    POS_Folio,   Vn_Folio,   Fp_Cve_Forma_Pago,    POS_Importe,    POS_Referencia,    POS_Fecha_Transaccion,    Rv_Folio,    POS_Chofer,    POS_Tipo,    POS_Multiplicador,    POS_Importe_Real,    POS_Comision_Factor,    POS_Comision_Importe,    Oper_Alta,    Fecha_Alta,    Oper_Ult_Modif,    Fecha_Ult_Modif )VALUES('000001', '0001', '0000015006', '0000', '01-0000385','01-0015006','0001', 115, '', '2020-02-10', '', '', '0000',1, 115, 0, 0, '0001','2020-02-10 18:08:12','0001','2020-02-10 18:08:12' )