SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'CC0020' ORDER BY Fr_ID EXEC SP_RPT_CC0020_3 '01-0000002' SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'CC0020' ORDER BY Fr_ID EXEC SP_RPT_CC0020_2 '01-0000002' SELECT TOP 1 Fr_Procedure1, Fr_Procedure2, Fr_Procedure3, Fr_LineasDetalle, Fr_Caida_Libre FROM Formato WHERE Fr_Cve_Formato = 'CC0020' SELECT Fr_Grafico AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'CC0020' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FTO_IMP_DEPURACION_CXC' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_PRINTER_ESC_P' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_REDIMENSIONAR_IMAGEN' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_VISTA_PREVIA_IMPRESION_MULTIPLE' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FIN_MONEDA_LOCAL' SELECT GetDate() as Fecha SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_REGISTRAR_ALTA_LOG' *** COMMIT *** SELECT Obj.name AS Nombre, Obj.type AS Tipo, Obj.type_desc AS nTiop, Modu.definition AS Consulta FROM BAJAGOURMENT.sys.objects Obj INNER JOIN BAJAGOURMENT.sys.sql_modules Modu ON Obj.object_id = Modu.object_id WHERE (Obj.name IN (SELECT Ats_Sp FROM Afectar_Tabla_Sp WHERE At_Tabla = 'PAGO_CXC' AND Es_Cve_Estado <> 'BA') ) AND Obj.type = 'P' ORDER BY Obj.name ASC SELECT @@VERSION AS xVersion SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_VERSION_SQL_AFECTAR' INSERT INTO Pago_Cxc_Comprobante( Cxc_Folio, Pc_Id, Pcc_Id, Pcc_Tipo_Comprobante, Pcc_Numero_Factura, Pcc_Tax_Id, Pcc_Serie, Pcc_Serie_Folio, Pcc_Timbre_UUID, Pcc_RFC_Emisor, Pcc_RFC_Receptor, Pcc_Metodo_Pago, Pcc_Monto, Pcc_Moneda, Pcc_Tipo_Cambio )VALUES('01-0000597', '0003', '0001', '04', '', '', 'D', '332', '67E0B661-E8E9-586B-1DC3-5E4DA527B652', 'DIS171005I48', 'TCA150715FI6', ' ', 3889.632, 'MXN', 0) SELECT IsNull(MAX(Pcc_Id),0) as MaxID FROM Pago_Cxc_Comprobante WHERE ISNUMERIC(Pcc_Id) = 1 AND Cxc_Folio = '01-0000597' AND Pc_Id = '0003' SELECT Cd_Tipo_Comprobante, Cd_Factura, Cd_Tax_Id, Cd_Serie, Cd_Serie_Folio, Cd_Timbre_UUID, Cd_RFC_Emisor, Cd_RFC_Receptor, Cd_Monto, Cd_Moneda, ISNULL(Forma_Pago.Fp_Metodo_Pago_SAT,'') as Metodo_Pago, Cd_Tipo_Cambio FROM Comprobante_Digital LEFT JOIN Forma_Pago ON Forma_Pago.Fp_Cve_Forma_Pago = Comprobante_Digital.Cd_Forma_Pago WHERE Cd_Tabla = 'FACTURA' AND LEFT(Cd_Documento,10) = '01-0000308' SELECT Fc_Folio FROM Venta_Encabezado WHERE Vn_Folio = '01-0000308' SELECT Cxc_Tabla, Cxc_Documento, Es_Cve_Estado FROM Cuenta_X_Cobrar WHERE Cxc_Folio = '01-0000597' SELECT Poliza_Configuracion.Pc_Cve_Poliza_Configuracion, Poliza_Configuracion.Pc_Descripcion, Poliza_Configuracion.Pc_Tabla FROM Poliza_Configuracion INNER JOIN Poliza_Configuracion_Tabla ON Poliza_Configuracion.Pc_Tabla = Poliza_Configuracion_Tabla.Pc_Tabla WHERE Poliza_Configuracion_Tabla.Pc_Tabla = 'PAGO_CXC' AND Poliza_Configuracion.Es_Cve_Estado <> 'BA' AND Poliza_Configuracion_Tabla.Pc_Contabiliza_Linea = 'SI' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_TABLA_GRABA_COMPROBANTE' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'CON_CENTRO_COSTO_OBLIGATORIO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'CON_PERIODO_ACTUAL' SELECT GetDate() as Fecha SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'CON_EJERCICIO_ACTUAL' SELECT GetDate() as Fecha SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_GENERAR_COMPROBANTE_PAGO_PARCIAL' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'CXC_FORMAS_PAGO_GENERAN_COMPROBANTE' UPDATE Grupo_Comercial SET Oper_Ult_Modif = 'GDIAZ', Fecha_Ult_Modif = '2018-08-01 17:39:11', Gc_Saldo = Gc_Saldo - 0 WHERE Gc_Cve_Grupo_Comercial = '0000000000' SELECT GetDate() as Fecha UPDATE Cadena_Comercial SET Oper_Ult_Modif = 'GDIAZ', Fecha_Ult_Modif = '2018-08-01 17:39:11', Cc_Saldo = Cc_Saldo - 0 WHERE Cc_Cve_Cadena_Comercial = '0000000000' SELECT GetDate() as Fecha UPDATE Cliente SET Oper_Ult_Modif = 'GDIAZ', Fecha_Ult_Modif = '2018-08-01 17:39:10', Cl_Saldo = Cl_Saldo - 0 WHERE Cl_Cve_Cliente = '0000000036' SELECT GetDate() as Fecha SELECT * FROM Cuenta_X_Cobrar_Impuesto WHERE Cxc_Folio = '01-0000597' INSERT INTO Pago_CXC ( CxC_Folio, Pc_ID, Pc_Fecha, PC_Tabla, Pc_Documento, Pc_Documento_ID, Pc_Referencia, Pc_Banco, Pc_Cuenta_Bancaria, Pc_Comentario, Pc_Importe, Pc_Tipo_Cambio, Pc_Tipo_Cambio_Documento, Fp_Cve_Forma_Pago, Fp_Cuenta_Contable, Pc_Cve_Banco, Oper_Alta, Fecha_Alta, Oper_Ult_Modif, Fecha_Ult_Modif) VALUES ('01-0000597', '0003', '2018-08-01', 'DEPURACION_CXC', '01-0000002', '', '', '', '', 'DEPURACION SALDOS', 0, 1, 1, 'DM', '', '', 'GDIAZ', '2018-08-01 17:39:10', 'GDIAZ', '2018-08-01 17:39:10') SELECT GetDate() as Fecha SELECT GetDate() as Fecha SELECT Fp_Cuenta_Contable AS Nombre FROM Forma_Pago WHERE Fp_Cve_Forma_Pago = 'DM' SELECT IsNull(MAX(Pc_ID),0) as MaxID FROM Pago_CXC WHERE ISNUMERIC(Pc_ID) = 1 AND Cxc_Folio = '01-0000597' UPDATE Cuenta_X_Cobrar SET Cxc_Precio_Descontado_Pago = Cxc_Precio_Descontado_Pago + 0, Cxc_Precio_Descontado_Saldo = Cxc_Precio_Descontado_Saldo - 0, Cxc_Impuesto_Pago = Cxc_Impuesto_Pago + 0, Cxc_Impuesto_Saldo = Cxc_Impuesto_Saldo - 0, Cxc_Precio_Neto_Pago = Cxc_Precio_Neto_Pago + 0, Cxc_Precio_Neto_Saldo = Cxc_Precio_Neto_Saldo - 0, Oper_Ult_Modif = 'GDIAZ', Fecha_Ult_Modif = '2018-08-01 17:39:10' WHERE Cxc_Folio = '01-0000597' SELECT GetDate() as Fecha SELECT Cuenta_X_Cobrar.*, Cliente.Cc_Cve_Cadena_Comercial, Cliente.Gc_Cve_Grupo_Comercial FROM Cuenta_X_Cobrar INNER JOIN Cliente ON Cuenta_X_Cobrar.Cl_Cve_Cliente = Cliente.Cl_Cve_Cliente WHERE Cxc_Folio = '01-0000597' SELECT Fp_Cve_Forma_Pago AS Nombre FROM FORMA_PAGO WHERE Fp_Cve_Forma_Pago = 'DM' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_VALIDAR_PERIODO_OPERATIVO' SELECT GetDate() as Fecha SELECT Obj.name AS Nombre, Obj.type AS Tipo, Obj.type_desc AS nTiop, Modu.definition AS Consulta FROM BAJAGOURMENT.sys.objects Obj INNER JOIN BAJAGOURMENT.sys.sql_modules Modu ON Obj.object_id = Modu.object_id WHERE (Obj.name IN (SELECT Ats_Sp FROM Afectar_Tabla_Sp WHERE At_Tabla = 'PAGO_CXC' AND Es_Cve_Estado <> 'BA') ) AND Obj.type = 'P' ORDER BY Obj.name ASC