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 = 'MPRO_FARMACIA'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_MODO_LISTAR_IMPRESORAS'
SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'CORTED' ORDER BY Fr_ID
EXEC SP_RPT_CORTED_3 '01-0000625'
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-0000625'
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-0000625'
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-0000625'
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'CORTEC' ORDER BY Fr_ID
EXEC SP_RPT_CORTEC_2 '01-0000625'
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 = '2023-10-30 19:58:42',    Ca_Declarado = 'SI' WHERE    POS_Folio = '01-0000625'
UPDATE    Pos_Ventas SET    Oper_Ult_Modif = '0001',    Fecha_Ult_Modif = '2023-10-30 19:58:42',    POS_Declarado = 'SI' WHERE    POS_Folio = '01-0000625'
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-0000625', '0002', '2023-10-30', '01-0000625', '0001', '000001', '0001', 'DECLARACION AUTOMATICA', '0001', 1259.93, 1259.93, 0, '0001', '2023-10-30 19:58:42', '0001', '2023-10-30 19:58:42')
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-0000625', '0001', '2023-10-30', '01-0000625', '0001', '000001', '0001', 'DECLARACION AUTOMATICA', '0004', 450, 450, 0, '0001', '2023-10-30 19:58:42', '0001', '2023-10-30 19:58:42')
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-0000625'    LEFT JOIN POS_Declaracion ON POS_Declaracion.Fp_Cve_Forma_Pago = Forma_Pago.Fp_Cve_Forma_Pago AND POS_Declaracion.POS_Folio = '01-0000625' 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'
INSERT INTO POS_Declaracion(POS_Folio,Pd_ID,Fp_Cve_Forma_Pago,Pd_Importe, Oper_Alta, Fecha_Alta, Oper_Ult_Modif, Fecha_Ult_Modif ) VALUES ('01-0000625','0003','0004',450,'0001','2023-10-30 19:58:42','0001','2023-10-30 19:58:42') 
INSERT INTO POS_Declaracion(POS_Folio,Pd_ID,Fp_Cve_Forma_Pago,Pd_Importe, Oper_Alta, Fecha_Alta, Oper_Ult_Modif, Fecha_Ult_Modif ) VALUES ('01-0000625','0001','0001',1259.93,'0001','2023-10-30 19:58:42','0001','2023-10-30 19:58:42') 
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 = '2023-10-30 19:58:41',   POS_Declarado = 'SI',    POS_Fecha_Final = '2023-10-30 19:58:41',    POS_Transaccion_Final = '0000008571',    POS_Ventas = 17,    POS_Importe = ISNULL((SELECT SUM(POS_Importe_Real) FROM POS_Pagos WHERE POS_Folio = '01-0000625' AND POS_Pagos.POS_Tipo <> '0002'), 0) WHERE    POS_Folio = '01-0000625'
SELECT GetDate() as Fecha
UPDATE POS_Control_Cajas SET    Oper_Ult_Modif = '0001',   Fecha_Ult_Modif = '2023-10-30 19:58:41',   Ca_Declarado = 'SI' WHERE    POS_Folio = '01-0000625'