SELECT 'http://t2.mproerp.com/WSTimbrarCFD33/Timbrado.asmx' AS SvrCancel SELECT ' BIML biml*590 BIML5908312N9 CMC9504188D2 9F33945F-072E-4A26-82C1-B6FB95E82A39 1542.8 ' AS Envio SELECT St_ID, St_Servidor, St_Url_33, St_Soap_Consulta_Estatus, St_Namespace, Es_Cve_Estado FROM EMPRESAS..Servidor_Timbrado WHERE St_Ping >= 0 AND Es_Cve_Estado <> 'BA' ORDER BY St_Ping ASC SELECT Factura.Fc_Serie as Serie, Factura_Serie.Fs_Tipo, Factura_Serie.Fs_Usuario_WS, Factura_Serie.Fs_Password_WS, Comprobante_Digital.Cd_RFC_Emisor, Comprobante_Digital.Cd_RFC_Receptor, Comprobante_Digital.Cd_Monto, Comprobante_Digital.Cd_Id_Cancelacion, Comprobante_Digital.Cd_Timbre_UUID FROM Factura_Encabezado Factura INNER JOIN Factura_Serie Factura_Serie ON Factura.Fc_Serie = Factura_Serie.Fs_Cve_Factura_Serie INNER JOIN Comprobante_Digital ON Cd_Tabla = 'FACTURA' AND Cd_Documento = Factura.Fc_Folio WHERE Factura.Fc_Folio = '01-0019083' SELECT Es_Cve_Estado AS Nombre FROM Comprobante_Digital WHERE Cd_Documento = '01-0019083' AND Cd_Tabla = 'FACTURA' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_ENVIAR_MAIL_CANCELACION' *** BEGIN TRANSACION *** SELECT Es_CvE_Estado AS Nombre FROM Comprobante_Digital WHERE Cd_Tabla = 'FACTURA' AND Cd_Documento = '01-0019083' SELECT 'http://t2.mproerp.com/WSTimbrarCFD33/Timbrado.asmx' AS SvrCancel SELECT ' BIML biml*590 BIML5908312N9 CMC9504188D2 CCA7B11B-724D-4455-8607-20918D4E0A06 3608.09 ' AS Envio SELECT St_ID, St_Servidor, St_Url_33, St_Soap_Consulta_Estatus, St_Namespace, Es_Cve_Estado FROM EMPRESAS..Servidor_Timbrado WHERE St_Ping >= 0 AND Es_Cve_Estado <> 'BA' ORDER BY St_Ping ASC SELECT Factura.Fc_Serie as Serie, Factura_Serie.Fs_Tipo, Factura_Serie.Fs_Usuario_WS, Factura_Serie.Fs_Password_WS, Comprobante_Digital.Cd_RFC_Emisor, Comprobante_Digital.Cd_RFC_Receptor, Comprobante_Digital.Cd_Monto, Comprobante_Digital.Cd_Id_Cancelacion, Comprobante_Digital.Cd_Timbre_UUID FROM Factura_Encabezado Factura INNER JOIN Factura_Serie Factura_Serie ON Factura.Fc_Serie = Factura_Serie.Fs_Cve_Factura_Serie INNER JOIN Comprobante_Digital ON Cd_Tabla = 'FACTURA' AND Cd_Documento = Factura.Fc_Folio WHERE Factura.Fc_Folio = '01-0021423' SELECT Es_Cve_Estado AS Nombre FROM Comprobante_Digital WHERE Cd_Documento = '01-0021423' AND Cd_Tabla = 'FACTURA' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_ENVIAR_MAIL_CANCELACION' *** BEGIN TRANSACION *** SELECT Es_CvE_Estado AS Nombre FROM Comprobante_Digital WHERE Cd_Tabla = 'FACTURA' AND Cd_Documento = '01-0021423' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_CAMPO_NUMERO_IDENTIFICACION' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_TABLA_SOLICITA_DOCUMENTO_RELACIONADO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_CFDI_EGRESO_CONCEPTO_UNICO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_PRODUCTO_CUENTA_PREDIAL' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_CAMPO_NUM_CUENTA_PREDIAL' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_METODO_PAGO_CLAVE_DEFAULT' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_ACTIVA_METODO_PAGO_CLAVE' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_DIAS_VENCIMIENTO_CERTIFICADO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'VEN_PRODUCTO_ANTICIPO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_IMPUESTO_IEPS_TASA' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_IMPUESTO_IEPS_CONCEPTO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_DIRECCION_RECEPTOR_CON_CRUZAMIENTO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_DESCRIPCION_AMPLIADA' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_DIRECCION_FISCAL' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_FORMATO_IMPORTE_MXN' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_FORMATO_CANTIDAD_NOMINA12' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_FORMATO_IMPORTE_NOMINA12' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_FORMATO_IMPUESTO_LOCAL_CFDI' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_FORMATO_CANTIDAD_CFDI' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_FORMATO_PRECIO_CFDI' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_FORMATO_IMPUESTO_CFDI' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_FORMATO_IMPORTE_CFDI' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_DIRECCION_RECEPTOR_CON_CRUZAMIENTO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_URL_SERVIDOR_TIMBRADO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_DESCRIPCION_AMPLIADA' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_DIRECCION_FISCAL' SELECT 0 as SEL, CD.Cd_Tabla As Tabla, FC.Fc_Folio Documento, FC.Fc_Fecha AS Fecha, FC.Fc_Factura AS Factura, CD.Cd_Monto AS Importe, FC.Es_Cve_Estado AS Estado, cd.Cd_RFC_Emisor AS RFCE, cd.Cd_RFC_Receptor AS RFCR, CD.Cd_Timbre_UUID as UUID, CD.Es_Cve_Estado AS [C.D.], CASE CD.Es_Cve_Estado WHEN 'AC' THEN 0 WHEN 'PXC' THEN 0 WHEN 'CA' THEN -1 WHEN 'NA' THEN -1 ELSE 0 END AS CANCELADO, ISNULL((SELECT TOP 1 Tdl_Transaccion FROM Transaccion_Documento_Log WHERE Tdl_Tabla = 'FACTURA' AND Tdl_Documento = FC.Fc_Folio AND Tdl_Tipo = 'ALTA' ),'') AS [T. Alta] FROM Factura_Encabezado FC INNER JOIN Comprobante_Digital CD ON cd.Cd_Documento = FC.Fc_Folio AND CD.CD_Tabla = 'FACTURA' WHERE FC.Fc_Serie IN ( SELECT Fs_Cve_Factura_Serie FROM Factura_Serie WHERE Fs_Tipo = '04' ) AND FC.Es_Cve_Estado = 'PXC' AND FC.Cl_Cve_Cliente LIKE '%' AND FC.Sc_Cve_Sucursal LIKE '%' AND Fc_Fecha BETWEEN '2024-01-01' AND '2025-08-26' UNION ALL SELECT 0 as SEL, CD.Cd_Tabla As Tabla, PP.Cxc_Folio + PP.Pc_ID AS Documento, PP.Pp_Fecha AS Fecha, PP.Pp_Folio_Fiscal AS [Folio Fiscal], PP.Pp_Total AS Importe, PP.Es_Cve_Estado AS Estado, cd.Cd_RFC_Emisor AS RFCE, cd.Cd_RFC_Receptor AS RFCR, CD.Cd_Timbre_UUID as UUID, CD.Es_Cve_Estado AS [C.D.], CASE CD.Es_Cve_Estado WHEN 'AC' THEN 0 WHEN 'PXC' THEN 0 WHEN 'CA' THEN -1 WHEN 'NA' THEN -1 ELSE 0 END AS CANCELADO, '' AS [T. Alta] FROM Pago_Parcial PP INNER JOIN Comprobante_Digital CD ON cd.Cd_Documento = PP.Cxc_Folio + PP.Pc_ID AND CD.Cd_Tabla = 'COMPROBANTE_PAGO' WHERE PP.Pp_Serie IN ( SELECT Fs_Cve_Factura_Serie FROM Factura_Serie WHERE Fs_Tipo = '04' ) AND PP.Es_Cve_Estado = 'PXC' AND PP.Cl_Cve_Cliente LIKE '%' AND PP.Sc_Cve_Sucursal LIKE '%' AND Pp_Fecha BETWEEN '2024-01-01' AND '2025-08-26' UNION ALL SELECT 0 as SEL, CD.Cd_Tabla As Tabla, PP.Pp_Folio AS Documento, PP.Pp_Fecha AS Fecha, PP.Pp_Folio_Fiscal AS [Folio Fiscal], PP.Pp_Total AS Importe, PP.Es_Cve_Estado AS Estado, cd.Cd_RFC_Emisor AS RFCE, cd.Cd_RFC_Receptor AS RFCR, CD.Cd_Timbre_UUID as UUID, CD.Es_Cve_Estado AS [C.D.], CASE CD.Es_Cve_Estado WHEN 'AC' THEN 0 WHEN 'PXC' THEN 0 WHEN 'CA' THEN -1 WHEN 'NA' THEN -1 ELSE 0 END AS CANCELADO, '' AS [T. Alta] FROM Pago_Parcial PP INNER JOIN Comprobante_Digital CD ON cd.Cd_Documento = PP.Pp_Folio AND CD.Cd_Tabla = 'COMPROBANTE_PAGO' WHERE PP.Pp_Serie IN ( SELECT Fs_Cve_Factura_Serie FROM Factura_Serie WHERE Fs_Tipo = '04' ) AND PP.Es_Cve_Estado = 'PXC' AND PP.Cl_Cve_Cliente LIKE '%' AND PP.Sc_Cve_Sucursal LIKE '%' AND Pp_Fecha BETWEEN '2024-01-01' AND '2025-08-26' UNION ALL SELECT 0 AS SEL, CD.Cd_Tabla As Tabla, NM.Nm_Folio AS Documento, NM.Nm_Fecha AS Fecha, NM.Nm_Serie_Folio AS [Folio Fiscal], cd.Cd_Monto AS Importe, NM.Es_Cve_Estado AS Estado, cd.Cd_RFC_Emisor AS RFCE, cd.Cd_RFC_Receptor AS RFCR, CD.Cd_Timbre_UUID AS UUID, CD.Es_Cve_Estado AS [C.D.], CASE CD.Es_Cve_Estado WHEN 'AC' THEN 0 WHEN 'PXC' THEN 0 WHEN 'CA' THEN -1 WHEN 'NA' THEN -1 ELSE 0 END AS CANCELADO, '' AS [T. Alta] FROM Nomina NM INNER JOIN Comprobante_Digital CD ON CD.Cd_Documento = NM.Nm_Folio AND CD.Cd_Tabla = 'NOMINA' WHERE NM.Nm_Serie IN ( SELECT Fs_Cve_Factura_Serie FROM Factura_Serie WHERE Fs_Tipo = '04' ) AND NM.Es_Cve_Estado = 'PXC' AND NM.Em_Cve_Empleado LIKE '%' AND NM.Sc_Cve_Sucursal LIKE '%' AND Nm_Fecha BETWEEN '2024-01-01' AND '2025-08-26' GROUP BY CD.Cd_Tabla, NM.Nm_Folio, NM.Nm_Fecha, NM.Nm_Serie_Folio, CD.Cd_Monto, NM.Es_Cve_Estado, cd.Cd_RFC_Emisor, cd.Cd_RFC_Receptor, CD.Cd_Timbre_UUID, CD.Es_Cve_Estado UNION ALL SELECT 0 as SEL, CD.Cd_Tabla As Tabla, NC.Nc_Folio Documento, NC.Nc_Fecha AS Fecha, NC.Nc_Referencia AS Referencia, CD.Cd_Monto AS Importe, NC.Es_Cve_Estado AS Estado, cd.Cd_RFC_Emisor AS RFCE, cd.Cd_RFC_Receptor AS RFCR, CD.Cd_Timbre_UUID as UUID, CD.Es_Cve_Estado AS [C.D.], CASE CD.Es_Cve_Estado WHEN 'AC' THEN 0 WHEN 'PXC' THEN 0 WHEN 'CA' THEN -1 WHEN 'NA' THEN -1 ELSE 0 END AS CANCELADO, ISNULL((SELECT TOP 1 Tdl_Transaccion FROM Transaccion_Documento_Log WHERE Tdl_Tabla = 'Nota_Credito' AND Tdl_Documento = NC.Nc_Folio AND Tdl_Tipo = 'ALTA' ),'') AS [T. Alta] FROM Nota_Credito NC INNER JOIN Comprobante_Digital CD ON CD.Cd_Documento = NC.Nc_Folio AND CD.Cd_Tabla = 'Nota_Credito' WHERE NC.Nc_Serie IN ( SELECT Fs_Cve_Factura_Serie FROM Factura_Serie WHERE Fs_Tipo = '04' ) AND NC.Es_Cve_Estado = 'PXC' AND NC.Cl_Cve_Cliente LIKE '%' AND NC.Sc_Cve_Sucursal LIKE '%' AND Nc_Fecha BETWEEN '2024-01-01' AND '2025-08-26' GROUP BY CD.Cd_Tabla, NC.Nc_Folio, NC.Nc_Fecha, NC.Nc_Referencia, NC.Es_Cve_Estado,CD.Cd_Monto,CD.Es_Cve_Estado, cd.Cd_RFC_Emisor, cd.Cd_RFC_Receptor, CD.Cd_Timbre_UUID UNION ALL SELECT 0 as SEL, CD.Cd_Tabla As Tabla, TR.Tr_Folio Documento, TR.Tr_Fecha AS Fecha, TR.Tr_Factura AS Factura, CD.Cd_Monto AS Importe, TR.Es_Cve_Estado AS Estado, CD.Cd_RFC_Emisor AS RFCE, CD.Cd_RFC_Receptor AS RFCR, CD.Cd_Timbre_UUID as UUID, CD.Es_Cve_Estado AS [C.D.], CASE CD.Es_Cve_Estado WHEN 'AC' THEN 0 WHEN 'PXC' THEN 0 WHEN 'CA' THEN -1 WHEN 'NA' THEN -1 ELSE 0 END AS CANCELADO, ISNULL((SELECT TOP 1 Tdl_Transaccion FROM Transaccion_Documento_Log WHERE Tdl_Tabla = 'TRASLADO' AND Tdl_Documento = TR.Tr_Folio AND Tdl_Tipo = 'ALTA' ),'') AS [T. Alta] FROM Traslado TR INNER JOIN Comprobante_Digital CD ON CD.Cd_Documento = TR.Tr_Folio AND CD.CD_Tabla = 'TRASLADO' WHERE TR.Tr_Serie IN ( SELECT Fs_Cve_Factura_Serie FROM Factura_Serie WHERE Fs_Tipo = '04' ) AND TR.Es_Cve_Estado = 'PXC' AND ISNULL(TR.Tr_Cliente,'') LIKE '%' AND TR.Sc_Cve_Sucursal LIKE '%' AND TR.Tr_Fecha BETWEEN '2024-01-01' AND '2025-08-26' ORDER BY Tabla, Fecha DESC, Documento DESC SELECT Sc_Descripcion FROM Sucursal WHERE Sc_Cve_Sucursal = '%' and Es_Cve_Estado <> 'BA' SELECT Em_Apellido_Paterno + ' ' + Em_Apellido_Materno + ' ' + Em_Nombre from Empleado WHERE Em_Cve_Empleado = '%' SELECT Cl_Descripcion from cliente where cl_cve_cliente='%' SELECT Accesos FROM EMPRESAS..EasyAccess WHERE Empresa = '01' AND Operador = 'CONTABILIDAD' AND Transaccion = 'UT066' AND Personalizado = 'SI' SELECT Restriccion FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND Perfil = '001' AND Menu = 'UT066' SELECT GetDate() as Fecha SELECT GetDate() as Fecha