SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'CORTEC' ORDER BY Fr_ID
EXEC SP_RPT_CORTEC_3 '01-0000206'
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'CORTEC' ORDER BY Fr_ID
EXEC SP_RPT_CORTEC_2 '01-0000206'
SELECT TOP 1      Fr_Procedure1,      Fr_Procedure2,      Fr_Procedure3,      Fr_LineasDetalle,      Fr_Caida_Libre FROM      Formato WHERE      Fr_Cve_Formato = 'CORTEC'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FTO_IMP_CORTE_CAJA'
*** COMMIT ***
UPDATE    POS_Control_Cajas SET    Oper_Ult_Modif = '0001',    Fecha_Ult_Modif = '2019-11-11 09:47:57',    Ca_Declarado = 'SI' WHERE    POS_Folio = '01-0000206'
UPDATE    Pos_Ventas SET    Oper_Ult_Modif = '0001',    Fecha_Ult_Modif = '2019-11-11 09:47:57',    POS_Declarado = 'SI' WHERE    POS_Folio = '01-0000206'
SELECT    Pos_Pagos.Cj_Cve_Caja,    Forma_Pago.Fp_Cve_Forma_Pago,    Forma_Pago.Fp_Descripcion,    isnull(SUM(Pos_Pagos.Pos_Importe),0) as POS_Importe,    isnull(POS_Declaracion.Pd_Importe,0) as POS_Declarado FROM Forma_Pago    LEFT JOIN Pos_Pagos ON Pos_Pagos.Fp_Cve_Forma_Pago = Forma_Pago.Fp_Cve_Forma_Pago AND POS_Pagos.POS_Folio = '01-0000206'    LEFT JOIN POS_Declaracion ON POS_Declaracion.Fp_Cve_Forma_Pago = Forma_Pago.Fp_Cve_Forma_Pago AND POS_Declaracion.POS_Folio = '01-0000206' GROUP BY    POS_Declaracion.Pd_Importe,   Pos_Pagos.Cj_Cve_Caja,    Forma_Pago.Fp_Cve_Forma_Pago,    Forma_Pago.Fp_Descripcion 
SELECT Sc_Prefijo_General as Campo FROM Sucursal WHERE Sc_Cve_Sucursal = '0001'
SELECT Fl_Folio FROM Folio_Sucursal WHERE Sc_Cve_Sucursal = '0001' AND Fl_Tabla = 'POS_Recepcion_Valores'
UPDATE Folio_Sucursal SET Fl_Folio = Fl_Folio + 1 WHERE Sc_Cve_Sucursal = '0001' AND Fl_Tabla = 'POS_Recepcion_Valores'
SELECT Fl_Folio FROM Folio_Sucursal WHERE Sc_Cve_Sucursal = '0001' AND Fl_Tabla = 'POS_Recepcion_Valores'
SELECT Sc_Descripcion AS Nombre FROM Sucursal WHERE Sc_Cve_Sucursal = '0001'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_FOLIO_X_SUCURSAL'
SELECT GetDate() as Fecha
SELECT GetDate() as Fecha
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'POS_GENERAR_RECIBO_CAJA_AL_DECLARAR'
UPDATE POS_Ventas SET    Oper_Ult_Modif = '0001',   Fecha_Ult_Modif = '2019-11-11 09:47:56',   POS_Declarado = 'SI',    POS_Fecha_Final = '2019-11-11 09:47:56',    POS_Transaccion_Final = '0000001057',    POS_Ventas = 0,    POS_Importe = ISNULL((SELECT SUM(POS_Importe_Real) FROM POS_Pagos WHERE POS_Folio = '01-0000206' AND POS_Pagos.POS_Tipo <> '0002'), 0) WHERE    POS_Folio = '01-0000206'
SELECT GetDate() as Fecha
UPDATE POS_Control_Cajas SET    Oper_Ult_Modif = '0001',   Fecha_Ult_Modif = '2019-11-11 09:47:56',   Ca_Declarado = 'SI' WHERE    POS_Folio = '01-0000206'
UPDATE POS_Control_Cajas SET    Oper_Ult_Modif = '0001',   Fecha_Ult_Modif = '2019-11-11 09:47:56',   Cj_Cortada = 'SI' WHERE    POS_Folio = '01-0000206'
SELECT COUNT(DISTINCT(Cj_Transaccion)) AS Ventas FROM POS_Pagos WHERE    POS_Folio = '01-0000206' 
SELECT GetDate() as Fecha
*** BEGIN TRANSACION ***
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_PREFIJO_FOLIOS_EMPRESA'
SELECT Fl_Folio FROM Folio WHERE Fl_Tabla = 'CAJA:000001'
SELECT     Forma_Pago.Fp_Descripcion,     SUM(POS_Pagos.POS_Importe) as POS_Importe FROM     POS_Pagos INNER JOIN Forma_Pago ON POS_Pagos.Fp_Cve_Forma_Pago = Forma_Pago.Fp_Cve_Forma_Pago WHERE     Cj_Cve_Caja = '000001' AND     Cj_Transaccion >= '0000001058' GROUP BY     Forma_Pago.Fp_Descripcion
SELECT     Forma_Pago.Fp_Descripcion,     SUM(ABS(POS_Pagos.POS_Importe)) as POS_Importe FROM     POS_Pagos INNER JOIN Forma_Pago ON POS_Pagos.Fp_Cve_Forma_Pago = Forma_Pago.Fp_Cve_Forma_Pago WHERE POS_Tipo = '0002' AND     Cj_Cve_Caja = '000001' AND     Cj_Transaccion >= '0000001058' GROUP BY     Forma_Pago.Fp_Descripcion 
SELECT     Forma_Pago.Fp_Descripcion,     SUM(POS_Pagos.POS_Importe) as POS_Importe FROM     POS_Pagos INNER JOIN Forma_Pago ON POS_Pagos.Fp_Cve_Forma_Pago = Forma_Pago.Fp_Cve_Forma_Pago WHERE POS_Tipo <> '0002' AND     Cj_Cve_Caja = '000001' AND     Cj_Transaccion >= '0000001058' GROUP BY     Forma_Pago.Fp_Descripcion 
SELECT    POS_Folio,    POS_Transaccion_Inicial,    POS_Fecha_Inicial FROM    POS_Ventas WHERE    POS_Folio = '01-0000206' AND    Cj_Cve_Caja = '000001' AND    Ca_Cve_Cajero = '0001' 
SELECT GetDate() as Fecha
SELECT DISTINCT Vn_Folio FROM Venta INNER JOIN Producto ON Venta.Pr_Cve_Producto = Producto.Pr_Cve_Producto WHERE Venta.Vn_Inventario_Pendiente = 'SI' AND   Vn_Referencia = '01-0000206' AND     Venta.Es_Cve_Estado <> 'CA' AND     Producto.Pr_Tipo_Producto NOT IN ('99', '06') 
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'POS_MODO_DESCARGAR_VENTA_PENDIENTE_CORTE'
SELECT    Forma_Pago.Fp_Cve_Forma_Pago,    Forma_Pago.Fp_Tipo,    Forma_Pago.Fp_Descripcion,    ISNULL(SUM(POS_PAGOS.POS_IMPORTE),0) as IMPORTE,    ISNULL((POS_PAGOS.POS_Multiplicador),1) as MULT FROM    Forma_Pago    LEFT JOIN POS_Pagos on POS_Pagos.Fp_Cve_Forma_Pago = Forma_Pago.Fp_Cve_Forma_Pago and POS_Pagos.POS_Folio = '01-0000206' WHERE Fp_Permitir_Punto_Venta = 'SI'    AND Forma_Pago.Es_Cve_Estado <> 'BA' GROUP BY    Forma_Pago.Fp_Cve_Forma_Pago,    Forma_Pago.Fp_Tipo,    Forma_Pago.Fp_Descripcion    ,ISNULL((POS_PAGOS.POS_Multiplicador),1) ORDER BY Forma_Pago.Fp_Cve_Forma_Pago 
SELECT DISTINCT Texto,ID,Transaccion from  Configuracion_Etiqueta where (Transaccion = '' or Transaccion = '%') ORDER BY Transaccion DESC 
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_FORMATO_MONEDA'
SELECT FontSize FROM EMPRESAS..Operadores WHERE Operador = '0001'
SELECT 'SI' EXISTE FROM EMPRESAS..sysobjects sysobjects INNER JOIN EMPRESAS..syscolumns syscolumns ON sysobjects.id = syscolumns.id WHERE sysobjects.name = 'Operadores' AND syscolumns.name = 'FontSize' 
SELECT * FROM Cajero WHERE    Ca_Cve_Cajero = '0002' and    Es_Cve_Estado <> 'BA' 
SELECT DISTINCT Texto,ID,Transaccion from  Configuracion_Etiqueta where (Transaccion = '' or Transaccion = '%') ORDER BY Transaccion DESC 
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_FORMATO_MONEDA'
SELECT FontSize FROM EMPRESAS..Operadores WHERE Operador = '0001'
SELECT 'SI' EXISTE FROM EMPRESAS..sysobjects sysobjects INNER JOIN EMPRESAS..syscolumns syscolumns ON sysobjects.id = syscolumns.id WHERE sysobjects.name = 'Operadores' AND syscolumns.name = 'FontSize' 
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_URL'
SELECT GetDate() as Fecha
SELECT Imagen FROM EMPRESAS..Imagen_Objeto WHERE Objeto = 'COMMUNITY_USER' AND    Clave = 'marianaruizgayosso@gmail.com'   AND Id = '0000' 
INSERT INTO EMPRESAS..Imagen_Objeto(    Objeto,    Id,    Clave,    Imagen    ,Modificado ) VALUES (   'COMMUNITY_USER',    '0000',    'marianaruizgayosso@gmail.com',    null    ,'2019-11-11 09:47:12' ) 
SELECT GetDate() as Fecha