SELECT Es_CvE_Estado AS Nombre FROM Comprobante_Digital WHERE Cd_Tabla = 'FACTURA' AND Cd_Documento = 'M-0036559'
*** COMMIT ***
SELECT Pe_HTML AS Nombre FROM Plantilla_Email WHERE Pe_Cve_Plantilla_Email = ''
SELECT Pe_Texto FROM Plantilla_Email WHERE Pe_Cve_Plantilla_Email = ''
SELECT Pe_Texto FROM Plantilla_Email WHERE Pe_Cve_Plantilla_Email = ''
SELECT    Empresa.Em_Razon_Social,    Sucursal.Sc_Plantilla_Mail_CFD_Cancelado,    Sucursal.Sc_Bcc_Mail_CFD,    Factura.Fc_Factura as FolioDoc,   Factura.Fc_Folio as Folio,    Cliente.cl_cve_cliente,   Factura.sc_cve_sucursal,   Cliente.Cl_Contacto_1,   Cliente.Cl_Email_Contacto_1,   Cliente.Cl_Contacto_2,   Cliente.Cl_Email_Contacto_2,   Comprobante_Digital.Cd_Tipo_Comprobante,   Comprobante_Digital.Cd_ACK_Cancelacion AS Cd_XML,    Vendedor.Vn_Email,    Vendedor.Vn_Email_Contacto FROM    Factura    INNER JOIN Sucursal ON Factura.Sc_Cve_Sucursal = Sucursal.Sc_Cve_Sucursal    INNER JOIN Empresa ON Sucursal.Em_Cve_Empresa = Empresa.Em_Cve_Empresa    INNER JOIN Cliente ON Factura.Cl_Cve_Cliente = Cliente.Cl_Cve_Cliente    INNER JOIN Vendedor ON Factura.Vn_Cve_Vendedor = Vendedor.Vn_Cve_Vendedor    INNER JOIN Comprobante_Digital ON Comprobante_Digital.Cd_Tabla = 'FACTURA' AND Comprobante_Digital.Cd_Documento = Factura.Fc_Folio WHERE    Factura.Fc_ID = '0001' AND    Factura.Fc_Folio IN ('M-0036559') 
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_ENVIAR_AUTOMATICAMENTE'
UPDATE Comprobante_Digital SET    Cd_ACK_Cancelacion = '<?xml version="1.0"?><CancelaCFDResult xmlns="http://cancelacfd.sat.gob.mx" xmlns:default="http://www.w3.org/2000/09/xmldsig#" Fecha="2019-12-10T16:34:48.9639866" RfcEmisor="VTE910208TC2"><Folios><UUID>FC7FEEFA-6A48-4733-A0B7-27CC3BD65600</UUID><EstatusUUID>201</EstatusUUID></Folios><default:Signature xmlns="http://www.w3.org/2000/09/xmldsig#" Id="SelloSAT"><default:SignedInfo><default:CanonicalizationMethod Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n-20010315"/><default:SignatureMethod Algorithm="http://www.w3.org/2001/04/xmldsig-more#hmac-sha512"/><default:Reference URI=""><default:Transforms><default:Transform Algorithm="http://www.w3.org/TR/1999/REC-xpath-19991116"><default:XPath>not(ancestor-or-self::*[local-name()='+CHAR(39)+'Signature'+CHAR(39)+'])</default:XPath></default:Transform></default:Transforms><default:DigestMethod Algorithm="http://www.w3.org/2001/04/xmlenc#sha512"/><default:DigestValue>CUL+0hrh/miz/IXGJH7Xrqvj/sOMu9mFxsbCzVkF8OnDazmRHu5gBssgvyB/4sKpRnZfLBb5kmpkZtWAzVoUrg==</default:DigestValue></default:Reference></default:SignedInfo><default:SignatureValue>wOpmCCEUoRF7hlzhRtKAUdKShCZ5HetH/0rYyFJVP02HbnDjJubu8DEO23ssKzfEvZmnBZqfHqXvzEoVEHnQQw==</default:SignatureValue><default:KeyInfo><default:KeyName>00001088888800000031</default:KeyName><default:KeyValue><default:RSAKeyValue><default:Modulus>ujwIJaMKWWmawqDpHx/OS10pXzEh2SQhY02y64v9Q0+I+0dGlIrjFJeGrsHqAT3JoYnh38Dxwta98t/7++dh2hOgiZEwRignWRIlOgM1MefBHEyY+hi4vHpZgPKq/hJVfHf9nOvlb5UgIHMTCEwrDp3qk9O5XtTEycnWwiqleG0c1J9sfbRxC0gYBHsNTH85OEtSXYMkiWNYNnFbIc7B0sgp2y18jUxUCNFBMMTV0tz2sxRF+V4hblaPjI75RWmvs9E4lD7MVmW3z7LIlSajuSL8eOqoerSkQhPBABIeQenEPQwRTt3ej3XpVaBsOmagIPZZI3RvOVh+5mcXDE5txQ==</default:Modulus><default:Exponent>AQAB</default:Exponent></default:RSAKeyValue></default:KeyValue></default:KeyInfo></default:Signature></CancelaCFDResult>',   Es_Cve_Estado = 'CA',    Fecha_Baja = '2019-12-10 16:42:58',   Oper_Baja = 'MISAEL',   Fecha_Ult_Modif = '2019-12-10 16:42:58',   Oper_Ult_Modif = 'MISAEL' WHERE    Cd_Tabla= 'FACTURA' AND    Cd_Documento = 'M-0036559' 
SELECT GetDate() as Fecha
SELECT GetDate() as Fecha
SELECT '<soap:Body xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">	<Consulta_CFDI_Estatus xmlns="http://cfdi.farsystems.com.mx/">		<Usuario>VATE</Usuario>		<Password>vate*224</Password>		<RFCE>VTE910208TC2</RFCE>		<RFCR>XAXX010101000</RFCR>		<UUID>FC7FEEFA-6A48-4733-A0B7-27CC3BD65600</UUID>		<Total>5690.63</Total>	</Consulta_CFDI_Estatus></soap:Body>' 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 = 'M-0036559' 
SELECT Es_Cve_Estado AS Nombre FROM Comprobante_Digital WHERE Cd_Documento = 'M-0036559' 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 = 'M-0036559'
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 Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_URL_SAT_WS'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_URL_SAT_WS'
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 '2019-09-01' AND '2019-12-10'  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 '2019-09-01' AND '2019-12-10'  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 '2019-09-01' AND '2019-12-10'  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 '2019-09-01' AND '2019-12-10' 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 '2019-09-01' AND '2019-12-10'  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 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 '2019-12-01' AND '2019-12-10'  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 '2019-12-01' AND '2019-12-10'  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 '2019-12-01' AND '2019-12-10'  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 '2019-12-01' AND '2019-12-10' 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 '2019-12-01' AND '2019-12-10'  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 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 '2019-12-01' AND '2019-12-10'  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 '2019-12-01' AND '2019-12-10'  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 '2019-12-01' AND '2019-12-10'  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 '2019-12-01' AND '2019-12-10' 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 '2019-12-01' AND '2019-12-10'  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 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 '2019-12-01' AND '2019-12-10'  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 '2019-12-01' AND '2019-12-10'  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 '2019-12-01' AND '2019-12-10'  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 '2019-12-01' AND '2019-12-10' 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 '2019-12-01' AND '2019-12-10'  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 top 25     Modulos.Clave,     Modulos.Descripcion,     Menus.EasyAccess,     EasyAccess.Transaccion,     EasyAccess.Accesos FROM     EMPRESAS..EasyAccess EasyAccess     INNER JOIN EMPRESAS..Operadores Operadores ON EasyAccess.Operador = Operadores.Operador     INNER JOIN EMPRESAS..Permisos Permisos ON EasyAccess.Empresa = Permisos.Empresa AND EasyAccess.Transaccion = Permisos.Menu AND Operadores.Perfil = Permisos.Perfil AND Permisos.Estado = 'AC'     INNER JOIN EMPRESAS..Menus Menus ON EasyAccess.Transaccion = Menus.Clave     INNER JOIN EMPRESAS..Modulos Modulos ON Menus.Modulo = Modulos.Clave WHERE     EasyAccess.Personalizado = 'SI' AND     EasyAccess.Bloqueado = 'NO' AND     EasyAccess.Operador = 'MISAEL' AND     EasyAccess.Empresa = '01' ORDER BY     EasyAccess.Accesos Desc 
SELECT * FROM Transaccion_Documento_Log  WHERE Tdl_Tabla= 'Factura' AND   Tdl_Documento = 'M-0036559' AND   Tdl_Tipo = 'ALTA' AND   Tdl_Transaccion = 'FA005'