SELECT 'LLI150423AB7' AS RFCE, 'INE140404NI0' AS RFCR, '08B1076A-8AD4-4555-A8DE-E6740C546CC1' AS UUID, '257488' AS Total, '-----BEGIN CERTIFICATE----- MIIGJjCCBA6gAwIBAgIUMDAwMDEwMDAwMDA3MDA4MzU4MDkwDQYJKoZIhvcNAQEL BQAwggGVMTUwMwYDVQQDDCxBQyBERUwgU0VSVklDSU8gREUgQURNSU5JU1RSQUNJ T04gVFJJQlVUQVJJQTEuMCwGA1UECgwlU0VSVklDSU8gREUgQURNSU5JU1RSQUNJ T04gVFJJQlVUQVJJQTEaMBgGA1UECwwRU0FULUlFUyBBdXRob3JpdHkxMjAwBgkq hkiG9w0BCQEWI3NlcnZpY2lvc2FsY29udHJpYnV5ZW50ZUBzYXQuZ29iLm14MSYw JAYDVQQJDB1Bdi4gSGlkYWxnbyA3NywgQ29sLiBHdWVycmVybzEOMAwGA1UEEQwF MDYzMDAxCzAJBgNVBAYTAk1YMQ0wCwYDVQQIDARDRE1YMRMwEQYDVQQHDApDVUFV SFRFTU9DMRUwEwYDVQQtEwxTQVQ5NzA3MDFOTjMxXDBaBgkqhkiG9w0BCQITTXJl c3BvbnNhYmxlOiBBRE1JTklTVFJBQ0lPTiBDRU5UUkFMIERFIFNFUlZJQ0lPUyBU UklCVVRBUklPUyBBTCBDT05UUklCVVlFTlRFMB4XDTIzMDcwMzIzMjUwNVoXDTI3 MDcwMzIzMjUwNVowgeMxJTAjBgNVBAMTHExJVEVSQUxJQSBMSUJSRVJJQVMgU0Eg REUgQ1YxJTAjBgNVBCkTHExJVEVSQUxJQSBMSUJSRVJJQVMgU0EgREUgQ1YxJTAj BgNVBAoTHExJVEVSQUxJQSBMSUJSRVJJQVMgU0EgREUgQ1YxJTAjBgNVBC0THExM STE1MDQyM0FCNyAvIEdVUEE3NDA3MDNSSEExHjAcBgNVBAUTFSAvIEdVUEE3NDA3 MDNNQVNSQ0wwNDElMCMGA1UECxMcTElURVJBTElBIExJQlJFUklBUyBTQSBERSBD VjCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAIepWLhW7WMXx+YV09Zu sjgtQ4O8g1U7tmKGWeB6IPmtj+Cg2ubRr25SGKySG6/B4X+1cqkQh9mLUj7HzjrI /p6ZH+Yj0RvkWIFPGtoRFbrgQykWtaElJzeBMOy7Wfu4D34lUfbXlORcdsFb69A8 qdNaLW32oCe9XoW8wlzUouO1X/ZmxTccIZaeiHUUhcubjDpisoO9ilcTJA1/2uT2 tqxc6okZLez+1Kyi1lE3TlbvdRpdp7oO+xzLs2HIskq1v6OZBRe9GvggxqMz+jgI NbzFOGw54KCfKKfR1PcAKRc4N4TtelP+QD1FObP6BAvCMGroPIuNEOa3RyCSsxv7 ttECAwEAAaMdMBswDAYDVR0TAQH/BAIwADALBgNVHQ8EBAMCBsAwDQYJKoZIhvcN AQELBQADggIBAJ52Vzi4nRIzD7GSVJE5VaMYUcmYHttG9HeXgsfEClWm6HuCWOg2 vMbnCu/WPVFLfnKr/cSh5WUk/Wav8vX46A7XapbrRk5uabuDlOgXFLSHouJ1bYsZ XBXvnqd7qy9FDB5MU15uLY0ucrG5qBm13jUkxI4f9s0eaFLFK2rrzdkK6iSz4Fsc qPIouTPZnBNHmvKpdSOilSOPE4ra/iZpdL7GILRbpGCWJNxdggqU4H0SVapAf5rY 2cGppLKx5HRcNprFGAZ2tKr3f5D8HJt7U0ksaIF0/KL3xLWz7LUDoHH44N3XGIhR cZVNKj3/bvf5jbYCOOYYc/sMPwnE6UngvO+fBlGQN70HdycvgfaijbMzIwFZ1dRr CiHBC23dM7PNU6qtF1ksg0T9FsUr0nc/G5aSzdKHVara0KocyvEI9DUkFpFARRGZ EsmSgassigd+v/Z5DiCEm25HpEcjCybnw6uaQBPmpt5eOMGI+JC0MB6baWp6E0RQ UA98SNYKh3cYH/QC6GAQlrMbiaMu0BxDO4aCwjrsw9Y5lAXuHqft98M6Wdh6rpxO LjquGy35wHY3eRA5DvvrgIJMnE0aIP0V/p4NstSNMWvFs/MahoJoNjvQNUbYbcde on3Op2WVgMyGWuAO6c7Yym9Pre+c42kkSzzhwhkXRtDgUqrRv2NZtqxj -----END CERTIFICATE-----' AS Cert, '-----BEGIN PRIVATE KEY----- MIIEvQIBADANBgkqhkiG9w0BAQEFAASCBKcwggSjAgEAAoIBAQCHqVi4Vu1jF8fm FdPWbrI4LUODvINVO7ZihlngeiD5rY/goNrm0a9uUhiskhuvweF/tXKpEIfZi1I+ x846yP6emR/mI9Eb5FiBTxraERW64EMpFrWhJSc3gTDsu1n7uA9+JVH215TkXHbB W+vQPKnTWi1t9qAnvV6FvMJc1KLjtV/2ZsU3HCGWnoh1FIXLm4w6YrKDvYpXEyQN f9rk9rasXOqJGS3s/tSsotZRN05W73UaXae6Dvscy7NhyLJKtb+jmQUXvRr4IMaj M/o4CDW8xThsOeCgnyin0dT3ACkXODeE7XpT/kA9RTmz+gQLwjBq6DyLjRDmt0cg krMb+7bRAgMBAAECggEARJCHoat1kUa8poJTraYG9zORUuydKB/k30jt9fFj5y0c cbh6ynwiAU0G4Xl6+sqv0N8BE4eiUYYDzG0pwzZA0iGsKKHjlwhC3x/+/0XxSKD9 8K9knwxrFLd75boPEZUGZ4gvM+Xjf8Nn1fRCa92tK4ABQ/mJGmywcEFlrotdxF3v n/9G62JjFLO3PyEVkH1pc0PzC9eWDyjMlrQpSuSY4YzBtVvZE7+4kcwAp9h55B58 wTbWSkC3pskvxiOU4GzKvSSw9Uwgheb6+zZySQ5BH0vZoOjdfoFIUGMobLRNHSSd c9go2yzzcK9iexj19MUGgc2xexFyKvQv+/GlbQCUwQKBgQDlq3yMyyrEtDmjch1B +OKi4p2hPKJA3RHB6wa2i9IFjWfl0p+VkqrsnbGXyGLn2KMnXetFlGDXT9VJn+bh 6CPZCZeZjymXfl5ZJimZsgiS1T6ziThV96EURyIATJf7+iXNG7lBleFxpbeJTunB hli4beQ4DUG+FZFnjlY3wD0lCQKBgQCXNtYaYe6D2iQwkbiuAxDhfDU1orAHJndb cgUGZhj8Ct9yBxD3qM6m/lwXS/T2tSNzSuIpIaFbcaIIqIdrD5K/62rFJg6UhG/O 3JiBV/g3IVRCbc2b4nsWCrtHSsX1YMM427dng7khzYBq3utqmM25Yf2RztgR/iJl VvmUK6H9iQKBgQDZaxrwShDFv/tkkE3EO3GJU1B35+eN0fnSgsSLIRgEK5Y0ycxL E1p9vtb1YjzHUJ07Ujy8VLfMfIXkOdye9VyiRONf+lgcUwPMD0WIezKElhzSZ0+O imrRwHkeoWOrpWYNonYg8VtHc+KouKyviJgKl/VZXqti4BYTW3qhMnpvyQKBgDzL AxDgRnAkB2CvdTwgZ2z/7rR9j5+QS3QsRvDnoyvRgzvos12eNFbW9Fc5Zma5NGNp u7slliWZbbdlaewU+r7F+ssAHeR/yiO0dGur3lLrx2BdnMgLKckWz2w+F5ArMtFt JDMttgRtBi/xJ1xXyn25c6RnMF8reNCdQwHa+OlhAoGAJGIATZBHsEkSatYXKoEP GxZJxSTGR9KO41DHYytyupL49B19BlCTHGJC+4aTLLc5Zm14DkWr9YRCoSlLfEqT tNoHR34naxFMHcSv/bi8E1KH8c0SiIokbCkCUjTbk3gFbOTis3J5qvqvp+CPuvRc hSPy9hFVjhbXE6VBU1/KUxI= -----END PRIVATE KEY-----' AS PrivateKey, 'MIIMaQIBAzCCDC8GCSqGSIb3DQEHAaCCDCAEggwcMIIMGDCCBs8GCSqGSIb3DQEHBqCCBsAwgga8AgEAMIIGtQYJKoZIhvcNAQcBMBwGCiqGSIb3DQEMAQYwDgQIGlLgIyyLTWYCAggAgIIGiIoUX5PPRHnGT42Pe6K4XVoMpSKn5MeTnOAa1F9tLRjWTUFR5KJnG4kLvUoqG4l4++ufZJEG0pzrf02xdIW4S+RL0RmCgoYAjpwyYy4CBBIRBadZpbuNprWY7/J9D8h9unCQ8anl5YjmcToBTsZQWRBKT6AMwNrukN+5xKjsOpL8HD30r4TWSbW8u+GmKFd2FaD5fORMayN4cPCIekM48lCQp1PMJZMJV91eZ8pFIw5JJSfubrnUFYsz6/22tCRPuWnVd3F3y/IOsPLtRGxqp5x6e9ksrYsS9RrqXnIPQ0cEFRG2R5J3749Qb46oX1tQT/XkD89oyeb8PzCtGnUc+F6y2r3SegrEkD+cugfQRv1jMoOa2YmToe6b2JfmQPrWO2HGB/h6hX5+wprDZFFecjQxKnPN3tPHwGAWjbazTqwRxWmrYS1o9eqOfof09K7WzUVykGrsyPJgK2jnWKxz/UjkZtYhQifhWDbdEhlAtEpzArfkowcKDbwbfln1ZEQaYbcB6VZgKPs7t5MRy3/AIa/gotaomCIJghRMLVPdACQOCpRl1fWjXijZ4BwDjmvt9mMzPFH+sROjkiNbuqsk8jt5MttR8aC0FTkzK9WvJmkMd2dTurtURTra332y6+Lbo/QblNLWjSC6Id2mNio3fDgE7B/BDyZSCCXHUSM45us05TjLPkJgf6YgUnyqIFNtrEznR3Hb49T8GIib4N9hEGYMBUk/AZDArgQ44kTD6gBwvBl6nvrwzte/fLtIMlwY5VhDL3IPugB0TqG9gA4BCbg2B2eRMeLVCbseT0+Nk6i6oEeAY5WKY0htBrN2f9u3Rj4REKYc21AqhjsSDhv4tnmJQsA4BsBqHrp839BgYC10DVyrp7VFbL0DluNjC42d1rwCZljkglhOIkJE7S457JL24XVCvr+po71MypDDqss3oPjG3Rr2nerHkOXLsPq1Tj0vxX3/+ViObl2FWQBr8R6Un/FDCgld3ZiiwGoq18lcnkDeJzF53wM1IAUhgmAFFhDCi+gQ4HUlsGKWg3My74nCX4acXsyGuBEROeTMxzNyUxBDQMJ1+HhfaDiOV6/+Tz347D6TBo+XO4Rg6wUjGhYJx1/ni8agOf7rMmW9QIaCKUA6QHyFAn5I077zVjVtyefUZULDYlCdMqgHXxMFCpz258+YpEOOSnmdNfevgh532U/9huRiV++sLhkz+IpLsIlJvS9qeX6QM+DjfpQUbkm/P/S8UJ4wDJ7v8VN0Rc2/GF70kSOF4G5fLJLmj/JiAoPd7LFkaoDCjMdt8gweI+holq9iGKg8Hi5yJ727I/JhT6id7W3GOe3Tvr2Miq1KTAtYpAMoXON88ooJINZQP2e+/8OLhy3KNBs1Q6a/RjfchgURSEcw8MpuQQMpsPPVeBswvsNaKyfVoOlPfZrwQ4GjLuMldBnQv/Ti4QCPLYRljDOuQtP/adxiNFntDOiLb1qd31On7++Dm/bnliz4PUKH11fTZtH63MKht1ax9P1ikcH1BLb99NbmnTITQLvvzxejixwbKO79ZF7uEXwjF1lFNE1/zkZa8gLTkcmwHZc0OrvVCtrihCz3O2+UZeKoPdDKd6H3ZKDwpf2DcUhO1oCVVhqOxMvl/dGnDf54q7CV5hG7ekiOdJ8lYwC57FhfEAQzCiLLtrtB+S9jqSU9lJqiM0WOPAl+dFfloGGUIOUqgejExB42IvEJyhGmfjBwLhiBrogBM+BWR/BOie8EcpTn+B/b0z/gEfTXNMso+kiQkOUppX8/HBxMTmWoNhA9Ba4c/Ku+XMGxmnTMs+Syyx4fisZ+fxiP3Y2VSBuK/H25N8XSoekz1LebN5nUrulL4kedjNQhtZKAPDh0d2fCFHQhKfZ5nKqEH01heeOX6SXyuZYkk4sWdxoR2p6ML93Wmhv5X/30LpAXfYocRM+bnUY1jATc2rPcl6ajd6wIMn8mRzC6uXMMAfGRQgK5pcH9NwKrxniCZ6D4i1NHgmhmXqxHZa88Motr+5HzgKS0yln7VQgwPGRdwd1uylHHfFGZhumfTPa4ZCk75d6Uc5oT5Gchdqr6ujnpiYWnnOjXYfrJGOYGNrAYp71fgD99vNW17XIsDFSWT0QjgSUKCCOHgnEoeFvwB8ud5jpM2WRfjDinSoakr2SNjJq+9x8KQIwWwz9xCm/aicsOba8NiIccpvRnlxQ6GUG2yqo5cY5YUs1LD5STXogDnrEwggVBBgkqhkiG9w0BBwGgggUyBIIFLjCCBSowggUmBgsqhkiG9w0BDAoBAqCCBO4wggTqMBwGCiqGSIb3DQEMAQMwDgQIEKIl1EO++rMCAggABIIEyAy160TtpcYEbYcRBAClZLqYZH0vyxdEXp69nz3CLY/lLHYy0c9BU8T/qW96Zot8qgNneQ5GXA3KOtEwVpgsEFmOXH0tbNCXS4KSiKAbaTpxBXYPxlHWfj5t6I0kiJ4ISpO8YMcEx1lPSyUvb9+pGBANjppYf7Al+ZhXjgMbo3EkeOSzwBacCvndzw+4aGjGQ1f+xUgF77MZJWwSAzxa6RfDjoi9SaBSjxuqETDg4prL0Sq6KC/guyANYtq3jIMu4V/w91cG7fAYjSgEsDUuIqoHWcZCuiWZdlBULnejal2ukNVhScyPW+hqp196G5V8wRdwiU/9o4/MG+5t3CWewE1pj1QZ79TjKyjOX+xsk/5J/JTYoqd+yIPT6p33UYxO4hUrCxEz/nGPh8JcKCaKpx1hB+xB6X1aXTxS16/QSo4fOCy2InzQu5SIZTB9WddaxkJ4YKDy+ILkOI2EKdDqHFhx5Cd9XfTJigajYm+BZ+hyJKOKY4b9sW7CsCu20+U89Jg11oYjTsuN0X7MdHbsDTSPYou5f1P1abuIdU8Bp4ZtEyBmV4avprE2n1RATTUgIXCj71eDy7yWEgD9SlqSO5Lwnj7o+t2sYlbSfWRxV4QvgsYtWlosgLZs7Z2P98kwhxNYq70zQv0YSKXe05gfGqEByVhmFfg9OgsMWAjTf727UgGv/X7KgiwJ0jZ9TU+O3LqrMqfgwBxUA6Iw9EtRjpVbEt4GGgHBTC54u3TvHJmALcubIOL1AWIcxk8Fer67aQ5ScZElm04/DrLnQWYMt3h8DbFAeUailGEjpIf9rsoiSv5rJNkK+Co+S2mimJCa3oCILNdSn6zYmnfj5rfc+q4JJonwAR8jROuSG8Zy4obaX/Z9izUMHWkKiObeC2Z4Otwo4nZuRSlGQwzL4JyesWqz6Br/hcEkVgwyWDRyyZtSoLpPHSiHHT/E9bKZWHOjnmx36f0+odXwFVw7sPFx+SsxLCHzIY6gzbvKrciEalfknHGuHacKcED7revc+eUIlvP4KYAkPTELZnyXj1cdg2EychvX5oOifvRUHLeAb15gAdBxRBOTymwXZl0dZY6Ih2mh4xWZqMKXNraY5BZa/afhg7LFtTVWibXQkJuataD/GRsIdMTQOKQuj7MymWfilDitNU3wL0lbdQgl6bOeoVfH8mbUH2ZROlN9CKg77JCciBAn9qFPScAhdhzLNSmjD7y9ixWkMfWtJX6EGig9yWZarNOoNKcpk0uNKLV/5dW3CjwGYL0QF5bJZ3lGY8vbNQjMoYOB588xjvhOqFvmxdbh/+BKILXhGc31Rl7JyJbDiNM9JDnALeqA4Y3RKBTNYBMoLd3tfgJIOOGqiDAzKqdC6MFK0VCnzjLbkq5QfeYcjdAPFqPZ9sqgXIjeZ5UmvdmdnX4DaA1A2RDZM2yCBDdqtV1PnzK+iRePWu+4NWV24TAUtPiCBtRkBUgqk0vhSEp+0cFqTX709kuy1lpK2Jgd64PfRzjIzOZQi9ZX2Q5C7USFU9aeNnwR+GvlgBd55eYFjuq1gIQmB9WkuNCPtnOiWMtRm3C/su7GDYe3B+Ce+GnL7ZFjS6Qlle4gI1i278P6OMrVt/+VUJ6Xb53w9BJNgnjxXuN51jElMCMGCSqGSIb3DQEJFTEWBBRSc7mCJBHimGDgVZV6yEDPhsy2ZzAxMCEwCQYFKw4DAhoFAAQUBAjouDXBfUadjWsnqcR03rIvJD0ECCHBkzgr7qRvAgIIAA==' AS Pfx, '02' AS Motivo, '' 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-0001026' UPDATE Comprobante_Digital SET Cd_Motivo = '02', Cd_Folio_Sustitucion = '', Fecha_Ult_Modif = '2025-11-12 17:52:49', Oper_Ult_Modif = 'CONFIG' WHERE Cd_Tabla = 'FACTURA' AND Cd_Documento = '01-0001026' SELECT GetDate() as Fecha SELECT Fecha_Alta AS Nombre FROM Comprobante_Digital WHERE Cd_Tabla = 'FACTURA' AND Cd_Documento='01-0001026' 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-0001026' 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 = 'CONFIG' 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-0001026' 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-0001026' 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-0001026' SELECT TOP 1 Es_Cve_Estado FROM Venta WHERE Vn_Folio = '01-0008522' 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-0001026' SELECT * FROM Devolucion_Cliente WHERE Dc_Tabla = 'FACTURA' AND Dc_Documento = '01-0001026' 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-0001026' 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-0001026' SELECT Fc_Fecha AS Nombre FROM Factura WHERE Fc_Folio = '01-0001026' 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 Fs_Tipo FROM Factura_Serie WHERE Fs_Cve_Factura_Serie = 'Z' AND Fs_Tipo IN ('01', '03','04') AND Es_Cve_Estado <> 'BA' INSERT INTO Transaccion_Documento_Log ( Tdl_Modulo, Tdl_Tabla, Tdl_Documento, Tdl_Tipo, Tdl_Transaccion, Tdl_Fecha, Tdl_Operador ) VALUES ( 'VENTAS', 'Factura', '01-0001026', 'BAJA', 'FA001', GETDATE(), 'CONFIG')