SELECT ' HREP hre14 HRE140120QQ6 ORM060102QRA c-1422d8b284e78172b24d263ac7bfad3ae21d0338 759.29 ' 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-0003404' SELECT Es_Cve_Estado AS Nombre FROM Comprobante_Digital WHERE Cd_Documento = '01-0003404' 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-0003404' 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_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 IN ('PXC','CA') AND FC.Cl_Cve_Cliente LIKE '0000000125' AND FC.Sc_Cve_Sucursal LIKE '%' AND Fc_Fecha BETWEEN '2018-04-01' AND '2019-03-08' 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 IN ('PXC','CA') AND PP.Cl_Cve_Cliente LIKE '0000000125' AND PP.Sc_Cve_Sucursal LIKE '%' AND Pp_Fecha BETWEEN '2018-04-01' AND '2019-03-08' 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 IN ('PXC','CA') AND PP.Cl_Cve_Cliente LIKE '0000000125' AND PP.Sc_Cve_Sucursal LIKE '%' AND Pp_Fecha BETWEEN '2018-04-01' AND '2019-03-08' 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 IN ('PXC','CA') AND NM.Em_Cve_Empleado LIKE '%' AND NM.Sc_Cve_Sucursal LIKE '%' AND Nm_Fecha BETWEEN '2018-04-01' AND '2019-03-08' 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 IN ('PXC','CA') AND NC.Cl_Cve_Cliente LIKE '0000000125' AND NC.Sc_Cve_Sucursal LIKE '%' AND Nc_Fecha BETWEEN '2018-04-01' AND '2019-03-08' 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 ORDER BY Tabla, Fecha DESC, Documento DESC SELECT Em_Apellido_Paterno + ' ' + Em_Apellido_Materno + ' ' + Em_Nombre from Empleado WHERE Em_Cve_Empleado = '%' SELECT Cl_Descripcion from cliente where cl_cve_cliente='0000000125' SELECT GetDate() as Fecha SELECT ' HREP hre14 HRE140120QQ6 ODC940303IX0 c-21dffa08c7487b5d3f229851a6aa8230423b8bda 720 ' 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-0007567' SELECT Es_Cve_Estado AS Nombre FROM Comprobante_Digital WHERE Cd_Documento = '01-0007567' 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-0007567' 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'