SELECT 'CMU120109840' AS RFCE, 'XAXX010101000' AS RFCR, '601A952B-F4D4-4764-B64A-C44EA38624CE' AS UUID, '92055' AS Total, '-----BEGIN CERTIFICATE----- MIIGCzCCA/OgAwIBAgIUMDAwMDEwMDAwMDA1MDUzODg4MTIwDQYJKoZIhvcNAQEL BQAwggGEMSAwHgYDVQQDDBdBVVRPUklEQUQgQ0VSVElGSUNBRE9SQTEuMCwGA1UE CgwlU0VSVklDSU8gREUgQURNSU5JU1RSQUNJT04gVFJJQlVUQVJJQTEaMBgGA1UE CwwRU0FULUlFUyBBdXRob3JpdHkxKjAoBgkqhkiG9w0BCQEWG2NvbnRhY3RvLnRl Y25pY29Ac2F0LmdvYi5teDEmMCQGA1UECQwdQVYuIEhJREFMR08gNzcsIENPTC4g R1VFUlJFUk8xDjAMBgNVBBEMBTA2MzAwMQswCQYDVQQGEwJNWDEZMBcGA1UECAwQ Q0lVREFEIERFIE1FWElDTzETMBEGA1UEBwwKQ1VBVUhURU1PQzEVMBMGA1UELRMM U0FUOTcwNzAxTk4zMVwwWgYJKoZIhvcNAQkCE01yZXNwb25zYWJsZTogQURNSU5J U1RSQUNJT04gQ0VOVFJBTCBERSBTRVJWSUNJT1MgVFJJQlVUQVJJT1MgQUwgQ09O VFJJQlVZRU5URTAeFw0yMDEwMTQyMTUyNTZaFw0yNDEwMTQyMTUyNTZaMIHZMSkw JwYDVQQDEyBDT01FUkNJQUxJWkFET1JBIE1VTUxBUiBTQSBERSBDVjEpMCcGA1UE KRMgQ09NRVJDSUFMSVpBRE9SQSBNVU1MQVIgU0EgREUgQ1YxKTAnBgNVBAoTIENP TUVSQ0lBTElaQURPUkEgTVVNTEFSIFNBIERFIENWMSUwIwYDVQQtExxDTVUxMjAx MDk4NDAgLyBTSU5FNzMwNjE1TkI3MR4wHAYDVQQFExUgLyBTSU5FNzMwNjE1TUND TVJTMDUxDzANBgNVBAsTBk1BVFJJWjCCASIwDQYJKoZIhvcNAQEBBQADggEPADCC AQoCggEBAL0KCCfteNPvMqlXUJL2xqHix/paxavzWbQPVa+xJ3kML2bhohVq2fuI Y7dzZcooPV3XV89JgLtNM9Auk7A2w8lN9btEz87aHKFI1AaWY6QBrCjP0Wn2HYhT yCowPF2J31+zWkP9+uq6zVgsJA8DOLnGGXKcg0jPfBs+rmN6dyoxW10IxNNE5T6l 4GXNitclM7al6kyakcPmvIgwEZRAN8JKqMClrKrOYQEFQ5larx1q1oJPTefBNQZh tjpAV3yMXVxbbeMg85sqcSZ1OY33OHefzyfBf1qL6ggQk8PWdq13bQjq5Sqsi7tl upIQyJwSPfPUmqh1oDC99A2TJu3kyo8CAwEAAaMdMBswDAYDVR0TAQH/BAIwADAL BgNVHQ8EBAMCBsAwDQYJKoZIhvcNAQELBQADggIBACaVzUWatQTRT1Leqm4rbCfp gxrd9ojMd4B2M8Dh7MjxVpY3spPaxJQhzIpb4QDdGfu8i3u6yU8Bs1ifmJYHdCY5 A3kc5HhTl20CklCsJWV/VG/+57yyLrHKaNYqLoKVHhNCgmHbzmXJrmcWfuxIdjgb eaXRgpobcKD7DTodk1Z0n2Yvm1kewBGEmtMfAAM9YtXcmcOhbihdLttMrRO+tS4x vp8yf9fdhbOOLWz7YvFo9Fiy8WT2Z6V7FieDbR0Q3CCNy+Di0umKZV/+TcPrRnPa pqJxu0sRv6SlfeIeYtjfOf7ycvWioEeCawyfyb/BQNbMHOmyp+857RDoLNotxgP0 ZOB3PcpBtyMHrTrkaYw3Bvyj+47d/UJtXtmh5IM7kqGGAUyK3IuHvhdhzg5eVU6g wxl6novKOsZ9BcB8+AK5Ccs+avNKynt07/Oec7HXIX/vIBMf8CoRSVjPsWGJ0ifx 7idF/LVfjDnEau4+t+Z0Z5Ba54paNQV0xRh8VOc8+cazyj9oAHapzBHvgVCQ+4TY JycjoxTpgvrqoOGvsELmMtR7GTuDu4LtNSAVZTBdsPeJ/3SI2VYEAR7dLDLPnj4y /WljPGBuPX1tfsb0Q2PSqIn94RgpV6nXKBWryV2s2LD++hO8CXrwieGSAOeSpYgf Aw4N8JJJiNyRey2NVn3s -----END CERTIFICATE-----' AS Cert, '-----BEGIN PRIVATE KEY----- MIIEvgIBADANBgkqhkiG9w0BAQEFAASCBKgwggSkAgEAAoIBAQC9Cggn7XjT7zKp V1CS9sah4sf6WsWr81m0D1WvsSd5DC9m4aIVatn7iGO3c2XKKD1d11fPSYC7TTPQ LpOwNsPJTfW7RM/O2hyhSNQGlmOkAawoz9Fp9h2IU8gqMDxdid9fs1pD/frqus1Y LCQPAzi5xhlynINIz3wbPq5jencqMVtdCMTTROU+peBlzYrXJTO2pepMmpHD5ryI MBGUQDfCSqjApayqzmEBBUOZWq8dataCT03nwTUGYbY6QFd8jF1cW23jIPObKnEm dTmN9zh3n88nwX9ai+oIEJPD1natd20I6uUqrIu7ZbqSEMicEj3z1JqodaAwvfQN kybt5MqPAgMBAAECggEAC2WCbl3LrgM6q6je661C9lmEstwsFJy8KLXP9aKZfZu1 c99gdSgW8iob0OB9H33jjTfBTHbi8ufJmuBj+PikPwubJ+oTGSZfGX4Zgjgo06di KKe2uUukJibe52Q3D3CTbeKTK4wxR1txq8Ilfl40WkbOG/HBnG8dzUqvGsI0Uu/C F/hwodBilyYsKvpDEStyutEWaxI3Ax5UktejfJSzERPtxzJfDMUO8PoTPiNh72La E2i+1V8t/E1fYcN+AXRz5m2w3QTRhT3Tueei6d3NnoeSzqqEpwcIvqqlrfI6O8J9 JSEpD8XumptIpb5qmvwmMqtQefrw8TtLXPZkuZfU6QKBgQD4pL4Qsx0TfHafpkvY 37CQ3ES8PSFb/tmgiqX/dUvDrNIQAzgkYf6RetJrymzzrhh9tlFcfhGqyW/m8dJu 62sGrDAx67wYx6Nw0AY6q4QtsTj/WR1exJEt7lz6ukAp6V86TkPvmCmr5eNxfaX/ x97y7btKBf37XZz8KjelpheLPQKBgQDCodavDiRLV3wT5q3RGrwcMcxVYURVPOW8 FaD8h8dx1Jzj9RNz/q5EJo/fYBdCnAsLOMrOF7iF7jJt9DSlUIBNn+6iGaArv+/n ifxjJxWT/I6CKzXT5kd3HU36lA6syobv0mlkkXmVnD0Rvn8baja3HIyS1bEviXFn URGpEI+5uwKBgH8mb/PGRLY0Tc0yk1LigT5zBctlT2vmFZBdlqneZ9I2zG1X2Bvy 6OWoc3af27t5ahjPZSfxaEN4I3tsanpCdUbCQxskO9pILTKBjs3t6/gZytX50mUm DD/6xx2IpUtJhmMgpukdXSIEu5zL7lmw8jg0jjQ6gDlNE/x38mEJYLzZAoGBAIS9 zeZ8VaKQ2w3ToS5g9nSgPgTpHqqnquN5ON+iVxM6d3o9VnQg+Yd/aVZmedazCBEy PZcLtIybZQd6q0EoQykt75ncslHESQF4KYsSR/QzJpp+j+qiPpFtihZhThTo19jO f5TYZrzz3u6wJo5zBTgjn3gxh/Os4IwfTVUp92wrAoGBAKru3JAkRWKDADwGLVsG E+MihZqnbbcfhNFd83yiIekrbqNyREuIG8uiFuf86ClkVSmsW2vDwuIiMGCuReUa DFv1tKfChXz2BVhWfBB5Vl0+eQNFQLIf60anUIFRYkWBxOl7sPTttpsizM7o81Li NRAObSWhzcnAsYxZPItLpUU0 -----END PRIVATE KEY-----' AS PrivateKey, 'MIIMSQIBAzCCDA8GCSqGSIb3DQEHAaCCDAAEggv8MIIL+DCCBq8GCSqGSIb3DQEHBqCCBqAwggacAgEAMIIGlQYJKoZIhvcNAQcBMBwGCiqGSIb3DQEMAQYwDgQIfIg13KC2JeoCAggAgIIGaJ5i4DBeKxePM2Zi9mOe/OTgq0WeDy1k1eW9aDbL3Cf3JCNBGCUgp9JK1IGmBJjO+oO52TqIRrIVcwYkAB1dfqOoWK44EuW7e3y19dUvtCNBVMNIa/eQqkNqOo2LxnA7OW1hZpDDhhDRUbehHu5sBgwAjSTKB4IZjEROczgxVG0ljS+tuKhwmvZ16qw3hF/deoozLK9cxaEqIcMxab36/i9Oq5rCf4s0wsq7EbCY31qjUqupFBU7li7JkOBjXq2LLRgNj5x3eqQ8WTH/BlCM6bTsxwDut/zrNr/ZprbEfMUbRsleijSO+vXWSQglSg4dJHeeyc7ie3m5cq8POQC65ruM90ovoFurZ9jwRrJC3Q7d5Kgr579rjkU0dxVu0hpy0/vs0cGErsxko1lfjd+fFBY5uWHM+LcNP4uiXJ8iYShMiyzGTWrPxzI8IcfOHKZGnazQG8i639v/dPUpocQtzQhBJkcrmjER9BKzMpMtjeQlQOVRC/X40mwLnAGF6Ys/SqWiJhZfJCj3oXNOO0EQuEA5ivUkM+vyILAjQ/jldv+vPEzDV3SXdnPZyQ2TRNJ+k1WcI1qaLsfoPg0Bge3veiciLgnG2iqhf+CgTJ1ESU9IC6+HXK+aDLJgd5MEHZs8NLwD1+S4onZ8T/SolFLIL9eCGno0R/s30239kIjm4Ebc+YSG5+ZB8MC7QUFSnVmBR15tSm0VHY4+69HDa3x/9NAieluTPTmCOOBYS2AT8wNHSUnBL7TCotwkjNHNTht38qaXypOLTujFq0L4mZoXyVwIVI8XcdIQ86muHz5AuOT0AQqPDGBfvXIe21Ylnp5xPIKN292RLXQmDZ9lmFiuoocISYNahUfto4TEMJT6Bcv+rbv9iFle0cYmeU2IDD6prfmIbSOOgnfOAejQfBoMhr3vVHRNCI3qgUV3yUsjxjvUAeCIlasEM8ISbLFbUCHeO6Imvt8JzX4uKGJprn+Bf2DLLeZJxfsipIeUSgk7+PEbnS9WHOVbdXVO8k0uan32zto7qXSDhyPCAeloD+Acpvj4Kp9XrEx3i8X9TGNq8N8JC3hAZinU3PCw9ARZi3DEGwzKudlEjNsOuRkg4xRfqCct29/sbQ4s9Z95FVbtuwN/kmcPf+BTojkup6zKTJPxmBEx/1bQdLU3+DmkI3Obal47DqktGwR4esEtrfcATXqEpcVFrnu4gQ+r42HJOhKnjGQBFjVt1D6NFAr4JXad9PY2ReCvhNAxcaZvm8AseMHOcfKWTJYmTJ5lFTNaY3Ipya91OB/ecmY2gchLaytu7H9IFDWBbDcOACA6y9zZBK6hNgOPCCTYbPnWtp+FbZ3OR4dNyvxRz6+gg+g6gY/U4bvISkzyybQDwIV/wa1vZd0IpeKN5e+ItL7vSo8V41U14ckCXtGVZAA5Nea5JtmnTvJEcZRUmx+nJPS2vjl7xxW9bbYaH8+LWZqnvNy2cxl/MCkzTtkuwlfGwlJLvM/75sJOUWqaA0hzTHUEzA8zgk5DuWdttV4LKFj159iO3RWNBVypl4KnMs793Yc/13dFnOmofeKEGHmKyYPs3kZ80CqEP18+5Kaoo5hH7p/zHoT1gz3BvzR4pOI4XYy46OXs1Z+7xlPq8T0kpMMMnLSmdArJe5XAjF5cWTNIzaa1IWuEAcjLabB5HfYbZqsc91R4POtANHIMYIsWniSJmHdK1AlJ3spM9Mg82cITmZRGMELRxXVGWe5GIjDf93YZprLj1BLfU4zPN/CmefwmjyDdGJY7uZjSkcfrcRipsgieDLdRzlfBIMrX/znCB85oe5mJV4MSrSk9e4Z/t5ErreVtxspoCQdNuklZHyAoLqJilnVGAKcDsfsbuBeNMYlqy7CHBxG3A97SJD5r6ww1KIhVmIjs0gkgj67kovfZ/tGZqXUM4rwEi5622mmUfkdLiNPq5G4R6P4OW0mygWnqqvE4mLgbBvHhTnZAjoafjwszSg5FM6566ii+6wTY+H9t0GiAwh3ajQMMdQ562P9zECLtWiyyR6eN9DSirhh8wT8rnayTadekdTeq/q5zLCtUcFpE4A7aYeo08bPTTt4gR0ues6YFNETQz8KUD3iglFURkQlwob7QCVs6rbhxWEhRwUi1wCzouCunhd/bpBF8rZi6I367Bk/kvyCg8EI6Vo0k44MpPdg3Bz8/8F2lMIIFQQYJKoZIhvcNAQcBoIIFMgSCBS4wggUqMIIFJgYLKoZIhvcNAQwKAQKgggTuMIIE6jAcBgoqhkiG9w0BDAEDMA4ECOO2BDs5wWlRAgIIAASCBMgZhLt64Ou1cJlQ9458t9JbRHHVISzbxjPEW7aGrje+kvq5pSwCOzkNY3UAiXPQWxroKfiUxtujq9fjGKg5aj14JRJ0jKRIO2TSCb2EvWkQMYN4Aq618zghaWsFMZmJ4Dj9Zt6HViW1+lHdNb/0Hg8MM3vJMfPOIrgeMHqy2XmpsvOBUbgegP5KXk6vqXUxS7qHDxIPV8syZisXkf1CuEf42CZOCpzapLRAjtXWUnsHS38HPfl5yAbjXjSvJ20/W1I7NMI25e/xBKldNGSmz1upHc956AdJcgFqzHLhPaYslkuY9aZ6M4GVcuCUBUD2+HzwfZYWp/3tOHRYr6EsocwcuKXFqil6Vf84WnDqQUFhzI9CbamtT0S2JedIMu0cb9xYN7AuNB7ts/+n91Zm4xTGgCJ1G4JP3N7r9iQaJjx7L/Cyf8CzW/7pvVrRONrnm+OuyRvFWy5Tpdl29y8B0+ttzIUn4OKpnaJBWNmjgs6chGHVEDetu5+c4XK9rOhgTMJzOFrvdckHPqSTE1jO17lIE0INkEOuzx8a0BsTvAQUibWzy1/f/kQ+3s4Of2Tdt/17oLnZSTB6rZKPl4p3nZwlisc8Q6VJGIuHZEXpg5VVrgRZfqth1OnxkBlFZQUJgDG7ZJszh9aWx2OUY0/bEnhPRbRpRD3HQ8nyApn6+KM9hieY0LwLpjQIb/pUhOOg3RetjXm2s5LtGNmZ/8XbKTJg5aIDdJAecc4qQubm1dtxqlobFPmSLpfF9wZCMweDGvWktuNge8ysQPRM1h11CnHU3waZTmc0eHFfqLo0BxxzYlUjNUGcG5F05JC21YHojTjXJHDeFcdyyl88ma7VIwTZEKo065H7BGlGGj/vlSlOLJzu/XYCOz5qSeRoH6SnAsycStICOMcQWA85m/dhprcKVbs+cRPFKM5mVElKVriCtiM9w1Rkhqg6kprWI0G6fRnGsCvTLNogqxu4ozT8FREvVS9jhmHJHxO3TKTecp30lNaHA2NKOlLxd1GVVIDf7YPSSTkRi8psuLvIDZvMAX9yLtWnHmqV5YVS51Kr2ooTbSm85Y8JydWikg8IU67Jud+7TKNwOOmO9Nhq7Auz9HKNlvqZVjeJ5mn+eqN8gLMLZ3RCjezZrxU4ahTegYpGNI3LErk1f4kGlgSWNc1wH3+/bhAulVWz+Fy7lhviRfCAKrajkD/TAITRebK0Cz2yprgTGs495GRsaysD1cczwl5RFifSduvXTWCYuJz4Tk5CFBLzx/2iv8rb4LhQCjBPnnwjiWA16MMFp1c5NQVv9C/FmpaycWyAbqDRgvcfQHmLFpzcJqkxOKx1R4na7igDf0wVL4BYWOnuT9LXu52EP6a3qS3q8mtwbwyZfb7lucCvryAUxdM+sSt9xEbs15pQbJzuNiiXyg+qNkckEXukJNKaGywnGR5C92mxsA1amli20sDYGFqiVfP6Jfb+a0RcK1wWBlW78/LeRjMxM+cvpAT3BV/gB/uQta3Fre0W+gro77T+LfLjRBOdlZslp58wAjPboxlSc/3m/gECw/AFchsdPjvECtfb8pkFzAX74mJRcEALqfKSxtOM3zvWmh/AKxckzyNWB/aZMxjU0xEqA8OjLSbIi9vHw3YxJTAjBgkqhkiG9w0BCRUxFgQUxPWGqi7yIzWrXb1YV2iVsFJUGrQwMTAhMAkGBSsOAwIaBQAEFL6+iJXlzX5uKl6EL206bgD7PDSvBAhDWrgWmqFu9AICCAA=' AS Pfx, '01' AS Motivo, '2EC0D8EB-DD3D-4477-AE2F-7A8C92A43C59' AS FolioSustitucion SELECT St_ID, St_Servidor, St_Url, St_Url_33, St_Soap_Cancela, St_Soap_Cancela_Test, 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_Cancela_Test, Factura_Serie.Fs_Usuario_WS, Factura_Serie.Fs_Password_WS, Factura_Serie.Fs_Ruta_Archivo_Pfx, Factura_Serie.Fs_Password_Certificado_Digital, Factura_Serie.Fs_Pfx_B64, Factura_Serie.Fs_Cer_Openssl_B64, Factura_Serie.Fs_Key_Openssl_B64, Comprobante_Digital.Cd_Motivo, Comprobante_Digital.Cd_Folio_Sustitucion, Comprobante_Digital.Cd_RFC_Emisor, Comprobante_Digital.Cd_RFC_Receptor, Comprobante_Digital.Cd_Monto, 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-0001280' UPDATE Comprobante_Digital SET Cd_Motivo = '01', Cd_Folio_Sustitucion = '2EC0D8EB-DD3D-4477-AE2F-7A8C92A43C59', Fecha_Ult_Modif = '2022-06-29 14:21:05', Oper_Ult_Modif = 'PTOVTA' WHERE Cd_Tabla = 'FACTURA' AND Cd_Documento = '01-0001280' SELECT GetDate() as Fecha SELECT Fecha_Alta, Es_Cve_Estado, Cd_Timbre_UUID FROM Comprobante_Digital WHERE Cd_Tabla = 'FACTURA' AND Cd_Documento = '01-0001344' SELECT TOP 100 Fc_Folio as FOLIO, Fc_Fecha as FECHA, Fc_Factura as FACTURA, isnull(Condicion_Venta.Cv_Descripcion,'') as [CONDICION], Cl_Razon_Social_1 As CLIENTE, Vn_Descripcion as VENDEDOR, SUM(Factura.Fc_Precio_Neto_Importe) as IMPORTE, Factura.Es_Cve_Estado as ESTADO, Fc_Comentario as COMENTARIO FROM Factura INNER JOIN Cliente ON Factura.Cl_Cve_Cliente = Cliente.Cl_Cve_Cliente INNER JOIN Vendedor ON Factura.Vn_Cve_Vendedor = Vendedor.Vn_Cve_Vendedor LEFT JOIN Condicion_Venta on Condicion_Venta.Cv_Cve_Condicion_Venta = Factura.Fc_Condicion_Venta WHERE Cliente.Cl_Razon_Social_1 LIKE '%%' OR Factura.Fc_Comentario LIKE '%%' OR Fc_Factura LIKE '%%' OR Vn_Descripcion LIKE '%%' GROUP BY Fc_Folio, Fc_Fecha, Fc_Credito, Fc_Factura, Cl_Razon_Social_1, Vn_Descripcion, Factura.Es_Cve_Estado, Fc_Comentario, Condicion_Venta.Cv_Descripcion ORDER BY Fc_Fecha DESC, Fc_Folio DESC SELECT SQL FROM EMPRESAS..Consultas WHERE Clave = 'FACTURA' SELECT DISTINCT Texto,ID,Transaccion from Configuracion_Etiqueta where (Transaccion = '' or Transaccion = '%') ORDER BY Transaccion DESC SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_FORMATO_MONEDA' SELECT FontSize FROM EMPRESAS..Operadores WHERE Operador = 'PTOVTA' SELECT 'SI' EXISTE FROM EMPRESAS..sysobjects sysobjects INNER JOIN EMPRESAS..syscolumns syscolumns ON sysobjects.id = syscolumns.id WHERE sysobjects.name = 'Operadores' AND syscolumns.name = 'FontSize' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_Max_RegistrosConsulta' SELECT Fecha_Alta AS Nombre FROM Comprobante_Digital WHERE Cd_Tabla = 'FACTURA' AND Cd_Documento='01-0001280' SELECT CD1.Cd_Motivo, CD1.Cd_Folio_Sustitucion, CD1.Cd_Timbre_UUID, ISNULL(( SELECT TOP 1 cd.Cd_Documento FROM Comprobante_Digital cd Where cd.Cd_Timbre_UUID = CD1.Cd_Folio_Sustitucion ),'') AS Origen FROM Comprobante_Digital CD1 WHERE Cd_Tabla = 'FACTURA' AND Cd_Documento = '01-0001280' AND Cd_Motivo <> '' SELECT DISTINCT Texto,ID,Transaccion from Configuracion_Etiqueta where (Transaccion = '' or Transaccion = '%') ORDER BY Transaccion DESC SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_FORMATO_MONEDA' SELECT FontSize FROM EMPRESAS..Operadores WHERE Operador = 'PTOVTA' SELECT 'SI' EXISTE FROM EMPRESAS..sysobjects sysobjects INNER JOIN EMPRESAS..syscolumns syscolumns ON sysobjects.id = syscolumns.id WHERE sysobjects.name = 'Operadores' AND syscolumns.name = 'FontSize' SELECT Es_CvE_Estado AS Nombre FROM Comprobante_Digital WHERE Cd_Tabla = 'FACTURA' AND Cd_Documento = '01-0001280' SELECT Poliza_Control.Pl_Folio, CAST(Poliza.Pl_Tipo AS CHAR(2)) + ' - ' +CASE Poliza.Pl_Tipo WHEN 1 THEN 'INGRESOS' WHEN 2 THEN 'EGRESOS' WHEN 3 THEN 'DIARIO' ELSE '' END AS Pl_Tipo, Poliza.Pl_Numero FROM Poliza_Control INNER JOIN Poliza ON Poliza_Control.Pl_Folio = Poliza.Pl_Folio WHERE Poliza_Control.Pc_Tabla = 'FACTURA' AND Poliza_Control.Pc_Documento = '01-0001280' AND Poliza_Control.Es_Cve_Estado = 'AC' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_VALIDAR_PERIODO_OPERATIVO' SELECT Fc_Fecha AS Nombre FROM Factura WHERE Fc_Folio = '01-0001280' SELECT TOP 1 Es_Cve_Estado FROM Venta WHERE Vn_Folio = '01-0002868' SELECT Factura.Es_Cve_Estado AS STDoc, ISNULL(Comprobante_Digital.Es_Cve_Estado,'NE') AS STComp, Factura.Fc_Tabla as Tabla, Factura.Fc_Documento as Documento FROM Factura_Encabezado Factura LEFT JOIN Comprobante_Digital ON Cd_Tabla = 'FACTURA' AND Cd_Documento = Factura.Fc_Folio WHERE Factura.Fc_Folio = '01-0001280' SELECT * FROM Devolucion_Cliente WHERE Dc_Tabla = 'FACTURA' AND Dc_Documento = '01-0001280' AND Es_Cve_Estado <> 'CA' SELECT Poliza_Control.Pl_Folio, CAST(Poliza.Pl_Tipo AS CHAR(2)) + ' - ' +CASE Poliza.Pl_Tipo WHEN 1 THEN 'INGRESOS' WHEN 2 THEN 'EGRESOS' WHEN 3 THEN 'DIARIO' ELSE '' END AS Pl_Tipo, Poliza.Pl_Numero FROM Poliza_Control INNER JOIN Poliza ON Poliza_Control.Pl_Folio = Poliza.Pl_Folio WHERE Poliza_Control.Pc_Tabla = 'FACTURA' AND Poliza_Control.Pc_Documento = '01-0001280' AND Poliza_Control.Es_Cve_Estado = 'AC' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_VALIDAR_PERIODO_OPERATIVO' SELECT Es_Cve_Estado AS Nombre FROM Factura WHERE Fc_Folio = '01-0001280' SELECT Fc_Fecha AS Nombre FROM Factura WHERE Fc_Folio = '01-0001280' 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'