SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'POS_MODALIDAD_OPERACION'
SELECT GetDate() as Fecha
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'POS_MODALIDAD_OPERACION'
SELECT GetDate() as Fecha
SELECT 'CAJA NO.: ' + Convert(nVarChar(3), Cj_Numero) FROM Caja WHERE Cj_Cve_Caja = '000001'
SELECT Sc_Descripcion FROM Sucursal WHERE Sc_Cve_Sucursal = '0001'
SELECT Texto FROM EMPRESAS..Empresas WHERE Descripcion = 'MEDIKMAS1'
DELETE FROM Cupon_Pv_Venta WHERE Pos_Folio = '01-0000335' 
DELETE FROM Descuento_Pv_Venta WHERE Pos_Folio = '01-0000335' 
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_MODO_LISTAR_IMPRESORAS'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_MODO_LISTAR_IMPRESORAS'
SELECT Clave FROM Imagen_Objeto WHERE Objeto = 'MEMBRETE'
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 Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'CORTED' ORDER BY Fr_ID
EXEC SP_RPT_CORTED_3 '01-0000335'
SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'CORTED' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'CORTED' ORDER BY Fr_ID
EXEC SP_RPT_CORTED_2 '01-0000335'
SELECT TOP 1      Fr_Procedure1,      Fr_Procedure2,      Fr_Procedure3,      Fr_LineasDetalle,      Fr_Caida_Libre FROM      Formato WHERE      Fr_Cve_Formato = 'CORTED'
SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'CORTEC' ORDER BY Fr_ID
EXEC SP_RPT_CORTEC_3 '01-0000335'
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 * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'CORTEC' ORDER BY Fr_ID
EXEC SP_RPT_CORTEC_1 '01-0000335'
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'CORTEC' ORDER BY Fr_ID
EXEC SP_RPT_CORTEC_2 '01-0000335'
SELECT TOP 1      Fr_Procedure1,      Fr_Procedure2,      Fr_Procedure3,      Fr_LineasDetalle,      Fr_Caida_Libre FROM      Formato WHERE      Fr_Cve_Formato = 'CORTEC'
SELECT Fr_Grafico AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'CORTEC'
SELECT Cj_Formato_Corte_Caja as Formato FROM Caja WHERE Cj_Cve_Caja = '000001' 
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 = '2025-08-28 20:12:17',    Ca_Declarado = 'SI' WHERE    POS_Folio = '01-0000335'
UPDATE    Pos_Ventas SET    Oper_Ult_Modif = '0001',    Fecha_Ult_Modif = '2025-08-28 20:12:17',    POS_Declarado = 'SI' WHERE    POS_Folio = '01-0000335'
INSERT INTO POS_Recepcion_Valores (   Rv_Folio,    Rv_ID,    Rv_Fecha,    POS_Folio,    Sc_Cve_Sucursal,    Cj_Cve_Caja,    Ca_Cve_Cajero,    Rv_Comentario,    Fp_Cve_Forma_Pago,    Rv_Importe_Cobrado,    Rv_Importe_Recibido,    Rv_Importe_Diferencia,    Oper_Alta,    Fecha_Alta,    Oper_Ult_Modif,    Fecha_Ult_Modif) VALUES ('01-0000335', '0001', '2025-08-28', '01-0000335', '0001', '000001', '0001', 'DECLARACION AUTOMATICA', '0001', 1195.2, 1195.2, 0, '0001', '2025-08-28 20:12:17', '0001', '2025-08-28 20:12:17')
SELECT    Pos_Pagos.Cj_Cve_Caja,    Forma_Pago.Fp_Cve_Forma_Pago,    Forma_Pago.Fp_Descripcion,    isnull(SUM(Pos_Pagos.Pos_Importe),0) - isnull(SUM(Pos_Pagos.POS_Descuento_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-0000335'    LEFT JOIN POS_Declaracion ON POS_Declaracion.Fp_Cve_Forma_Pago = Forma_Pago.Fp_Cve_Forma_Pago AND POS_Declaracion.POS_Folio = '01-0000335' 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'