SELECT 'BIML5908312N9' AS RFCE, 'CMC9504188D2' AS RFCR, '9F33945F-072E-4A26-82C1-B6FB95E82A39' AS UUID, '1542.8' AS Total, '-----BEGIN CERTIFICATE----- MIIF5DCCA8ygAwIBAgIUMDAwMDEwMDAwMDA1MDkwNjA5NjYwDQYJKoZIhvcNAQEL BQAwggGEMSAwHgYDVQQDDBdBVVRPUklEQUQgQ0VSVElGSUNBRE9SQTEuMCwGA1UE CgwlU0VSVklDSU8gREUgQURNSU5JU1RSQUNJT04gVFJJQlVUQVJJQTEaMBgGA1UE CwwRU0FULUlFUyBBdXRob3JpdHkxKjAoBgkqhkiG9w0BCQEWG2NvbnRhY3RvLnRl Y25pY29Ac2F0LmdvYi5teDEmMCQGA1UECQwdQVYuIEhJREFMR08gNzcsIENPTC4g R1VFUlJFUk8xDjAMBgNVBBEMBTA2MzAwMQswCQYDVQQGEwJNWDEZMBcGA1UECAwQ Q0lVREFEIERFIE1FWElDTzETMBEGA1UEBwwKQ1VBVUhURU1PQzEVMBMGA1UELRMM U0FUOTcwNzAxTk4zMVwwWgYJKoZIhvcNAQkCE01yZXNwb25zYWJsZTogQURNSU5J U1RSQUNJT04gQ0VOVFJBTCBERSBTRVJWSUNJT1MgVFJJQlVUQVJJT1MgQUwgQ09O VFJJQlVZRU5URTAeFw0yMTA5MjEwNjExNTBaFw0yNTA5MjEwNjExNTBaMIGyMSIw IAYDVQQDFBlMVUlTIFJBTU9OIEJSSUNF0U8gTUVOREVaMSIwIAYDVQQpFBlMVUlT IFJBTU9OIEJSSUNF0U8gTUVOREVaMSIwIAYDVQQKFBlMVUlTIFJBTU9OIEJSSUNF 0U8gTUVOREVaMRYwFAYDVQQtEw1CSU1MNTkwODMxMk45MRswGQYDVQQFExJCSU1M NTkwODMxSFlOUk5TMDcxDzANBgNVBAsTBk1BVFJJWjCCASIwDQYJKoZIhvcNAQEB BQADggEPADCCAQoCggEBAIgPQrfq/qjyXRtPq1/lu4YoM9CES9HuDL3oT04Sjcyx vxjNC1pbdCHpoqC41M/vQaO+ySAW7FdhZSszhfk2NHhSlRtd3iDIuAmc+48LhDpi 7JU4p2l+Y4wWp9nIGJKQY3z6D9cKP18T1yuzJACT3lBRPKPK3uhqnzks34xQabKf GnQLubfasqKT+6ce/U6rM9jmy0gFi16LrA/TpNf5HnLfzb9iVfSaloKCJK63xWsi on4sGUAkvTHjnxRmhaE4Cjpwh2IJRyNBaT7I7QsggrDvsNiMc/W/wZMGVJgC9T76 ergE77ry1JHhCBJVACT+uNnbWabxf+XA5x9WdFal9T0CAwEAAaMdMBswDAYDVR0T AQH/BAIwADALBgNVHQ8EBAMCBsAwDQYJKoZIhvcNAQELBQADggIBAJvqBBgOT4nK EKZBt+kPRZc+2yqK5Ei/W9SLLUDx5RPS+IQQc8tFL7eyTDo/Wv6oCVOcdA94lCdf VAEEg4NZXnZrUJ5tau8ejUPQgh4M40eJDIrOmdgESPyh1ZIMp1e75QqXy0isv1jK rjM7LkOZrc7uWsHDXSdMVTlG3/wB+kRN7rlEUaXLw3isIjZ8wbzY5FRKo7xDHQSR pl6EpcKbaXnmfz9VD9spwYh2sr1hjb1VrhnGx21qxxqymglvxERhh2eF7DzF5682 LQgco3eRhBxhdsyLjU23jN3Vn6ADS44WGjb9RR3XOOcgbi9lvnHVh03+C/uJ/W21 j+7rvFbaTE/YmvQsNX3kPAo7BCwPGiGgz7lZJiu3Cs8ywNXTjta54meLVPPwZ3DX MjCwvxeljSsHlso3o/JHtsADTJzFIxOfKp/+uMZbgrkJFDKBQxYMywZyI4asGb6L UYg1ArAlXnQX/GXwT6tBPNxNO1I33mLwVdp1huYt7Y8Ledw0KDmmkvUbaZSCD5g4 T+4OHuGubZu5tVAcl6wmaNAwvLBKu//zF5eRuezjTKsewxJsjH3R+4txbqiei9VH 4Dzz6P6MsMuDb5xX30k9t1wARbUCzI9BhCv7TjwO+lfrfADYiFnBMbkGta55zAAQ p8NzQI7eWvFSWjXnvOkijvvKe8MwW8SQ -----END CERTIFICATE-----' AS Cert, '-----BEGIN PRIVATE KEY----- MIIEvgIBADANBgkqhkiG9w0BAQEFAASCBKgwggSkAgEAAoIBAQCID0K36v6o8l0b T6tf5buGKDPQhEvR7gy96E9OEo3Msb8YzQtaW3Qh6aKguNTP70GjvskgFuxXYWUr M4X5NjR4UpUbXd4gyLgJnPuPC4Q6YuyVOKdpfmOMFqfZyBiSkGN8+g/XCj9fE9cr syQAk95QUTyjyt7oap85LN+MUGmynxp0C7m32rKik/unHv1OqzPY5stIBYtei6wP 06TX+R5y382/YlX0mpaCgiSut8VrIqJ+LBlAJL0x458UZoWhOAo6cIdiCUcjQWk+ yO0LIIKw77DYjHP1v8GTBlSYAvU++nq4BO+68tSR4QgSVQAk/rjZ21mm8X/lwOcf VnRWpfU9AgMBAAECggEBAIgOMpp1rEhHa+GGromL0hSamQ23bZY0pJs29i7NEO0T BVQInoSxlRTga9aqXWy9BPd4Lekf4yCR7TfhIuSNVrTHaAFgwWIpNRev2kI1svkr uQaTC53LXEJW2WxG0oOlTUdJS5Ou1KX/0hgJ4EOPmizYv3nOwU7KaAQlojnOo5OQ Wh0dhoiC9Vwi038XCJnEZTdUuwpMTG/1fi9o4VMNWZaeLXYMIygmQDYdrWNoZNsV 0DvA8cNE6a/ZfCidw/UR3jt0WaWsYovg3BsdwxEYt87xClbDrlkzkIBS5U6F224f 1FFLh/YEyXxy1GPZTltjZ98KUiM4mL15qBicY6YWDmUCgYEA22lBtFEITcLPjQl8 vskEZ9D2cQA1qQO6CnXHcZ7oIZTih3aAJkQrfM1uwfYoBYxEoOqB5t7Z9p4RA1Ho vlIkFrkAnPPBra8+6468d/rFwKmbJ2ZIHXlW0zMw4ys47fhb7mHOSTLsVG9x07B0 KB6NJLBtvmK2ylufT3ztquuGWJsCgYEAnr+yFqjaKQhwZ6ewwONcKsGVIY2P0V5+ tyI6qquZwsLLZwLJUGNGZC//+iQRYx0GlGqr2969lxHf7c215fRcxXzvUNOn9pwc Pc3StKe+kIN6LFAZLzRfvKLATrY8JsTCyAlSgGJTmu5Nr2muLZ8VaYrQy3ngLzmI 4XduIi3+qwcCgYBOZdC1VlLqPhadJWuuW/M4CSFVhSanSo6aGDV4crgs7571mjD1 +1uyj1Do+0SXnuQSv1hFHxGwnhAkKItKHd2JRPdkHXDx13FbB7huAmvQiInIzTIt XeLZOixYr2P7G8f1aHsmCo0JKnz4j88hWrFCD8xWv7zil1RYOaJOdTOeywKBgCZk A4R5VzD/KnfW1OcA1OQ+JnuTyYj/ijNtorRthWTVSO1jfh3jtD08YnIy0MWgWlwA JAmrJzxmhTn0Op4e52SXHyTz2rXH8Qh9QwyPWIWIVj5rLHv+9Xwf+9PNPGS/xr8r ifkkTkW0hbL7IrVDuKDqgi4DDlU9W73y7P51ExZ3AoGBAIaritSCKRYtXkFPpaKV p8wINKsDq8DS6YWAAFW2WUdSm2X9uJl/E1L+tNHguOGpcAjjfYoNwNQGHUTqaOhQ a9SrYlot+C0H6AjtLRTBQ9B/0HLKANjfM3pBz0cYH7or4+yljDg5U8sU2vw1x0Nw T2CttKnh0bD4gkbZzfXXUDf6 -----END PRIVATE KEY-----' AS PrivateKey, 'MIIMKQIBAzCCC+8GCSqGSIb3DQEHAaCCC+AEggvcMIIL2DCCBo8GCSqGSIb3DQEHBqCCBoAwggZ8AgEAMIIGdQYJKoZIhvcNAQcBMBwGCiqGSIb3DQEMAQYwDgQIKYCCET9q8+sCAggAgIIGSLZ11t76wg+3Vb29rUDo97OxugI6wuy2StsTW9XKqo21ng3pve9i4R2e9dBELvd+3AqTcJbhGp9U+n2B7KCXf4/fAQ6bOph+1VcxRTg3MCacit/yv3VyC7aZAnf9Wpfx2qzJG+llVE2Iiq6nIZtUpgUk9d4yRomrezUCIVV9DUNyY/X7nAI2FybJ25V0QAYoVQ6gp9yiF0zYGVMFKLDyKPhDDfhPiDcvkB3HQKJe0GorWYXqSWPLiJW6Juqwa0xkthmUFSJwxySCRCNs10rBYZcSVms0hZIMcrEBEEl+8obZHhDuSqx2f2ABSbIdypStquNVq+F7d7H9s7OzKQI8WfORkX6Ya9Y/DNi1HsuN0FJzfG0apNxYVCg9gIPugVdjI4AcziRZNvWmcdB1KMhcg1a6OubKdsx2BowX9/7sOSdchItOwDGSFZmi/7XSkE+Jf2Z/HzHt7GJlZkHpzc21iwXjy4+NtfhD/I8zlJfJOw9RQ3Lfmo8zIwHyR9cbMnBkC9pmdi68hlTmLMInQcrNGbfYzK6huqLcXaUMhmVhybyR9KOZWi+WuElYoPkJYwsnJncBreWfpMXQef5sMcCYx++uUyS3yEbVy0CTBH8FDdGby9A1mrdFM+qR2L58LVHbDbtLqK/OuVFfexm61PCU51wA1rSN5oXreni5Nac/EiB2TI/Rqpzx5NGFY1JItQV4A+NZwuuEsAUbH1yQSTqF2Jdzni9AJk/pF2M817XejL1AZhEHWNc2WqkRwS92Q08B+ApVshbsAfNsHDF8N/EDTcVEerbl+Xr4GfEy7bUWKN76qNbeiUBm9jRxAr9QFKr8GczhlyMVUNgvDU7t6Fn0nRyi0MTQsR9JBFGE/DRb3tVnJVzgyLRKXAK+4EZmQp4RBV88ZStDjiV2kPky9709zJ5ekjskEKNIAih6aUAFbsT0Sq0+SMhokPjwQbdIKjf1eMp0TAEJizDkuiLMjBi/jsQydz5cp8hOLHlD/KhVTbz11y9qj8z5uWMkscrxM3pC11RPj7uAOweCGJ0wu8TWd+jnW8ecozH3b3xSn809ejVUDJl544BKe7rpo3BvAk9d8A40X50nQiEta+PhUnXcKRh7+IC16/yWghR4E+CfN6yAf0ejF61Rd52ai4Yc6QTR8ZlMEOw1q337BPhSaF8ZfY49kma4noeHfn9Kq13y5zoY67gwF42NzD0CPaaAchsWbO/Z65MpZOGcrV1kEl9UXNpBJflCxK69lQpIlYW3v6EVCIMiAm8is8UOueD9tTqpDGbd3karAt9rS3PE030fFDVt7ANvDxO9ww7QqR6X9AdQv3GTJgreFUtq9PQPdo64c1eaTmHIVdx2cNItPJzFJmTSEq+iFvC9wRF4MtLibdpfbQhkjDcHiPX1URoILIGf3yR2ligbSO1N5pP4n9kn/VsItFiEoVJlxqzFSZeioFJsoTazTzEZUVc7L79VSIJ8cfJA1s/yMQvLwcchLbUhUPenidftGoGGDnoJmnZXn8B1s2ghVhkbd9Q7dBT0bSIROhdl33ymfgCmJJNSwddlPGyLJG1GCy/LowebuIploF7L4J3ThO9S2DWL0ZeGeJoUflsh+vFBPU0OVCh+5BmBBakDQNPapqpvKjjQ37P1pnXYZi8RiV7F9OaH4sW9lz5KAXbekJfvZJvHQF4s/Ko/Ym4aicVmPF9kxl+V2oilasRhKSo5An3wNGFzo4BRR5JOVHRBKB/SMRXcNryJYpTYl8E2beV4R/EYzKa9c1CkfjK+ANN9yJH/bh9IPNP9uMusA0C53FXxclx2S8ZqEowgrzYOppnVkYu4ubpC1raAwjX1cNPsAHBdKduU74J5T2bxQRq3yY1qhvHMg1GYUrb6D7qvepTVRzs98X1IYWkqjS2KaQLMKNRe+1GU6XWYdykd/g/EnAAe9Q+Xgy3WtKXrv5pBN+RyzoLKXYuZBzKvI/EI9Civh651SWla3DAMFyP9E27bljRA0+sZO7peFGlO22K8SiskzP5OLElrzPowIEZM9lyZe9iytuM5WKeFXo21a2yqGlPVKnks4i3QBCJOmNOZ2Q1zvYM9oK29bVPKAM0V4j4/OEjEzeVzFi9UuMDl78gp7Ovf6+Nh4JqHRgY5iDP2dTiFi4qTXTCCBUEGCSqGSIb3DQEHAaCCBTIEggUuMIIFKjCCBSYGCyqGSIb3DQEMCgECoIIE7jCCBOowHAYKKoZIhvcNAQwBAzAOBAiWqr+POJkIbAICCAAEggTI8BROZV1gWdzaYT/p4V/fvonJgsw789aciKad8AhJRlTdmbpVO9WwIE3SPUt5j77AsAh2W2J3pIBntgFEgYLfMosrghLua4dS8BAcLSe6mxn0i4vpIOiBNR1xnekV/skdY9MNFy1JcJYXM2OJqRWrEs8lcxO7O/P4OHTVc7biVLDMX+10hGd4BPLS684OGfn+MLpFyvoziMT3P/1gkYvtNDUc7ZItN1A7IPuhLl97eKGKxiMg4dZN6DILrpjioQ9DRaCo+sugZzezjz6VYa6eIwPrSOHlouDCtA596MnlOHMgXU8aGdZE/IZBCce8+uilX9HdoFlzU7xHn4fW8Uv0VWFVef7ED5Ix5y9InsFuFTL1b4MuvHtRWxs0MoiullQbZv3jlrNGnc/hTWmBJ0N2AZ7S4l6Fo0ZiGwL6kPHUVEZsuC2wz7LRPuUwDWNyQj1JCsdSQH8xzJ3T7IsnPJtMAMT4e2c4+eauqnAjTFEtt2ch65w/E8kIq47wGkSxd7H7CsJYvgKGtr07yPu+TW21x5fEI6+AlQi1lj3sZNPVpNnhdRLBIfjU7Mt2aKcveVU1d1J7sPLv5VwNFeIsHPrqoOcdzH6HbJ+LHuRnwiJJs1TSy8pD3xIx/5DilMa2w19B55UDGGz6rmY8g4x2vwdCwzysOgqJEPoJkIjx/axXOmUSPxhl88x7LH45c4eFJDODFyEpEaGo5VrtlCUHG3MSzv5gsxt1HR83XzkyAa4ZaE3TSFyDl/IDQzniSxs16/aNzR0BP5J1dvmJVWZYCIjOfgKDzIRv+RjAX2kEs2nFYYfD6UKsVorLydTzTO67MEnEH+walhaZVKQwImquDvQ+o6hfcieJ+y6nFy9I8cAsicV/YJQIHbh4hMNOcj/0ZSfq3Gla0XFRoPijOnhSuKMX01rZ8L1Fk/5Mbv0ydYJQauaTp177rwHfZ375+9NlhaNLcPVB/IvejhMbOJ2UVtY8R3yNs+x5NkUKTbW7+anC5BNVYzcFfRXx/SkqhsPAqxx932qd66w0j8ikOy7wSO7bqD4dKgGsdN+PnE+EIhdyiGug9e1PwPUSpa18e0EzYiqBMeRUMOlpVL5yJswXS2PK9/xvvoFVXyZ8amqHsda5BDyLu3WeuG9bxCeDmb5nP6poBFmUsrJ0rOCkj0cFcYhHCKsFCG3YZhNvSWU51BtjSygtiXyBMq8VzIYmFTV3CSyNfyw2qdMIQ6rA7zSKJ0rTRTBPGBusQCHGlxRBNnBjAwiW5mnXhoDeU2qiFlZNAci2Vm27H/0R255E7Fxc2BplCAT8efnpkcpHBc0XjSJ52E4NR8w+hxLZSPT7Z78DvzXKE8trAuG3lNwy/3rz8zOIKwgRyC3x5gxdcGkqpRhYeNaALMu3MLB9rs+ot8aJE7LgFvvVwCB9S1fZqb2FUuIMwHvsFgw6+yKmp2E3lN1kBaU73wApqJrC6xcQlo/MYN9APC/kdePrUxDpWz0BDNfqUAToBhUo3GtL0ht/GEync7p5cC9KaKkEFcHHGVgdQsjYnk9FxLcwn8yHgHU+Xb3wTIwlwU48UwRxGheDbEp/XSZUttLynde3MdmT8DE+cCrl2ChSiHaPR0x8/B4GR27E2ZzIBJ5EY0xLMSUwIwYJKoZIhvcNAQkVMRYEFOTa/G6+YDTLncu7Q8rfqVxrHoWiMDEwITAJBgUrDgMCGgUABBQQxwsWoiQSu+Aqhn1B2mTWwZ2WeAQIe0NIcZzVJ0gCAggA' 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-0019083' UPDATE Comprobante_Digital SET Cd_Motivo = '02', Cd_Folio_Sustitucion = '', Fecha_Ult_Modif = '2025-08-19 12:08:43', Oper_Ult_Modif = 'CONTABILIDAD' WHERE Cd_Tabla = 'FACTURA' AND Cd_Documento = '01-0019083' SELECT GetDate() as Fecha SELECT Fecha_Alta AS Nombre FROM Comprobante_Digital WHERE Cd_Tabla = 'FACTURA' AND Cd_Documento='01-0019083' 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-0019083' 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 = 'CONTABILIDAD' 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-0019083' 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-0019083' 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-0019083' SELECT TOP 1 Es_Cve_Estado FROM Venta WHERE Vn_Folio = '01-0019097' 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-0019083' SELECT * FROM Devolucion_Cliente WHERE Dc_Tabla = 'FACTURA' AND Dc_Documento = '01-0019083' 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-0019083' 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-0019083' SELECT Fc_Fecha AS Nombre FROM Factura WHERE Fc_Folio = '01-0019083' 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 = 'F' 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-0019083', 'BAJA', 'FA001', GETDATE(), 'CONTABILIDAD')