SELECT    Cajero.Ca_Cve_Cajero,    Cajero.Ca_Descripcion,    Cajero.Ca_Nivel_Autorizacion,    Cajero.Vn_Cve_Vendedor,    Vendedor.Vn_Sucursal,    Cajero.Es_Cve_Estado    ,Ca_Password, Ca_PasswordN, Ca_Compartido FROM Cajero    INNER JOIN Vendedor ON Vendedor.Vn_Cve_Vendedor = Cajero.Vn_Cve_Vendedor WHERE    Cajero.Ca_Cve_Cajero = '0001' 
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'POS_VALIDAR_SUCURSAL_CAJERO'
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 = 'TIENDAMPRO'
SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'CORTDF' ORDER BY Fr_ID
EXEC SP_RPT_CORTDF_3 '01-0001821'
SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'CORTDF' ORDER BY Fr_ID
EXEC SP_RPT_CORTDF_1 '01-0001821'
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'CORTDF' ORDER BY Fr_ID
EXEC SP_RPT_CORTDF_2 '01-0001821'
SELECT TOP 1      Fr_Procedure1,      Fr_Procedure2,      Fr_Procedure3,      Fr_LineasDetalle,      Fr_Caida_Libre FROM      Formato WHERE      Fr_Cve_Formato = 'CORTDF'
SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'ZCORDV' ORDER BY Fr_ID
EXEC SP_RPT_ZCORDV_3 '01-0001821'
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'ZCORDV' ORDER BY Fr_ID
EXEC SP_RPT_ZCORDV_2 '01-0001821'
SELECT TOP 1      Fr_Procedure1,      Fr_Procedure2,      Fr_Procedure3,      Fr_LineasDetalle,      Fr_Caida_Libre FROM      Formato WHERE      Fr_Cve_Formato = 'ZCORDV'
SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'ZCORTF' ORDER BY Fr_ID
EXEC SP_RPT_ZCORTF_3 '01-0001821'
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 = 'ZCORTF' ORDER BY Fr_ID
EXEC SP_RPT_ZCORTF_1 '01-0001821'
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'ZCORTF' ORDER BY Fr_ID
EXEC SP_RPT_ZCORTF_2 '01-0001821'
SELECT TOP 1      Fr_Procedure1,      Fr_Procedure2,      Fr_Procedure3,      Fr_LineasDetalle,      Fr_Caida_Libre FROM      Formato WHERE      Fr_Cve_Formato = 'ZCORTF'
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 = '0004',    Fecha_Ult_Modif = '2022-02-21 16:01:38',    Ca_Declarado = 'SI' WHERE    POS_Folio = '01-0001821'
UPDATE    Pos_Ventas SET    Oper_Ult_Modif = '0004',    Fecha_Ult_Modif = '2022-02-21 16:01:38',    POS_Declarado = 'SI' WHERE    POS_Folio = '01-0001821'
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-0001824', '0001', '2022-02-21', '01-0001821', '0001', '000001', '0004', 'DECLARACION AUTOMATICA', '0004', 10, 10, 0, '0004', '2022-02-21 16:01:38', '0004', '2022-02-21 16:01:38')
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-0001821'    LEFT JOIN POS_Declaracion ON POS_Declaracion.Fp_Cve_Forma_Pago = Forma_Pago.Fp_Cve_Forma_Pago AND POS_Declaracion.POS_Folio = '01-0001821' 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-0001821','0004','0004',10,'0004','2022-02-21 16:01:38','0004','2022-02-21 16:01:38') 
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'