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 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 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 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 = 'FARMACIAS'
SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'CORTED' ORDER BY Fr_ID
EXEC SP_RPT_CORTED_3 '01-0000273'
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-0000273'
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-0000273'
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-0000273'
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'CORTEC' ORDER BY Fr_ID
EXEC SP_RPT_CORTEC_2 '01-0000273'
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-12-14 20:04:35',    Ca_Declarado = 'SI' WHERE    POS_Folio = '01-0000273'
UPDATE    Pos_Ventas SET    Oper_Ult_Modif = '0001',    Fecha_Ult_Modif = '2019-12-14 20:04:35',    POS_Declarado = 'SI' WHERE    POS_Folio = '01-0000273'
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-0000273', '0001', '2019-12-14', '01-0000273', '0001', '000001', '0001', 'DECLARACION AUTOMATICA', '0001', 2112, 2112, 0, '0001', '2019-12-14 20:04:35', '0001', '2019-12-14 20:04:35')
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-0000273'    LEFT JOIN POS_Declaracion ON POS_Declaracion.Fp_Cve_Forma_Pago = Forma_Pago.Fp_Cve_Forma_Pago AND POS_Declaracion.POS_Folio = '01-0000273' 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'