SELECT 'HMS7112185G6' AS RFCE, 'GCS0705287R9' AS RFCR, 'C8E77E27-A19D-4AF4-931B-46590BE5D059' AS UUID, '2600' AS Total, '-----BEGIN CERTIFICATE----- MIIGDjCCA/agAwIBAgIUMDAwMDEwMDAwMDA1MTQ5NzEyOTAwDQYJKoZIhvcNAQEL BQAwggGEMSAwHgYDVQQDDBdBVVRPUklEQUQgQ0VSVElGSUNBRE9SQTEuMCwGA1UE CgwlU0VSVklDSU8gREUgQURNSU5JU1RSQUNJT04gVFJJQlVUQVJJQTEaMBgGA1UE CwwRU0FULUlFUyBBdXRob3JpdHkxKjAoBgkqhkiG9w0BCQEWG2NvbnRhY3RvLnRl Y25pY29Ac2F0LmdvYi5teDEmMCQGA1UECQwdQVYuIEhJREFMR08gNzcsIENPTC4g R1VFUlJFUk8xDjAMBgNVBBEMBTA2MzAwMQswCQYDVQQGEwJNWDEZMBcGA1UECAwQ Q0lVREFEIERFIE1FWElDTzETMBEGA1UEBwwKQ1VBVUhURU1PQzEVMBMGA1UELRMM U0FUOTcwNzAxTk4zMVwwWgYJKoZIhvcNAQkCE01yZXNwb25zYWJsZTogQURNSU5J U1RSQUNJT04gQ0VOVFJBTCBERSBTRVJWSUNJT1MgVFJJQlVUQVJJT1MgQUwgQ09O VFJJQlVZRU5URTAeFw0yMjA5MDcxNjE3MjlaFw0yNjA5MDcxNjE3MjlaMIHcMSsw KQYDVQQDEyJIT1RFTEVTIERFIE1FWElDTyBFTiBFTCBTVVJFU1RFIFNBMSswKQYD VQQpEyJIT1RFTEVTIERFIE1FWElDTyBFTiBFTCBTVVJFU1RFIFNBMSswKQYDVQQK EyJIT1RFTEVTIERFIE1FWElDTyBFTiBFTCBTVVJFU1RFIFNBMSUwIwYDVQQtExxI TVM3MTEyMTg1RzYgLyBDRVZBNjQxMDE0OE1BMR4wHAYDVQQFExUgLyBDRVZBNjQx MDE0TVNMSkxOMDcxDDAKBgNVBAsTA1NBVDCCASIwDQYJKoZIhvcNAQEBBQADggEP ADCCAQoCggEBANrf/iDKzsjZldbs/be/In/D1IdbW/SdkAtoDiMEKOnLCPUj4S4Q hUyR7fxdU9e81XhPFR6S2RC9YAf/8nh36/OA95gCmPu7z9FTQeB9LeSGsrGVGhMT 2L3P3lCSzzodqA4KjRwcGWTY5j4v2WYA2Y6VdT3fBACJoMgfIjCkoftmb/1ggGbo 0RUCnozwBxj5P80lHsd0Hhlqo8xwHtYPuR1nGS5fDgIDfXpfeq3X+pscLK55gFR7 /SudcEHN2H1Hc/XYDUMb0UKnYc51Gkr2sey/l1NC4z59Ow2dQGYSzMmx70saW07g s75se+kv+oB5Df6Y6JBbP86UPO6w5y2xUDkCAwEAAaMdMBswDAYDVR0TAQH/BAIw ADALBgNVHQ8EBAMCBsAwDQYJKoZIhvcNAQELBQADggIBAD/YNRcjLgx5pUjZuAPq 49g/q4kq/GzK0XaJBnmsPYXnoei97MVM2AqPuz+fi7Bh1fDakdYAGGdYnBRYP0Ge au9CGTXONKIU2C1MXf4BLJPOVerHNynu7eNiOpQ878Ri8/+CIihmKvXdlENEqI91 Y7VBIc+P1Ga1/sc3vluLgem6uodHqBfqHqGMGjJpiBi+Xb2qQ23t6htRtOiGw77C CdNyKLdGPI9WBsSLTkV/Sa697JSmoxj5Z3t4sxes/Se8wEdCSLRTY7RP1/lvI8qB BhGWadl1cXrAT7IApsRRjFf1GJHICuU+wCnxt+yLuzKPM9iyjoDAUcwp6P0B9kIF dkRBaRFjIyKRCDqvVr+2TH/VB5+eRTgoWpsSAT/2Rc5sEQzO0Mnf5MA4xnmY5Ytx 1myxtTTUOYVT+q2hWZtercey2qqFQaXVdGOEXFMhgRlUU4L2zxom+PZ4eOpypzK9 AhNLbGbbU7A4sm2zeAypUPg2TYmZtsUl9toWSHHcuFt5OoXcYvl/y4pmChrUCfwp bgMZ81HDQfP7M7VcA5itWEtwcTFhRpGyNifN136XXbTt1GnMu12/qXYFkDzHPEn0 Xsoqoq1i9S5/STI1nyGz+1L0uN/mgTsOHVpghQEwVJA0ZSzGZMwkhiyqxCsEj9UQ HRgX9Livf8/Q+Lc4gHxDLj/e -----END CERTIFICATE-----' AS Cert, '-----BEGIN PRIVATE KEY----- MIIEvQIBADANBgkqhkiG9w0BAQEFAASCBKcwggSjAgEAAoIBAQDa3/4gys7I2ZXW 7P23vyJ/w9SHW1v0nZALaA4jBCjpywj1I+EuEIVMke38XVPXvNV4TxUektkQvWAH //J4d+vzgPeYApj7u8/RU0HgfS3khrKxlRoTE9i9z95Qks86HagOCo0cHBlk2OY+ L9lmANmOlXU93wQAiaDIHyIwpKH7Zm/9YIBm6NEVAp6M8AcY+T/NJR7HdB4ZaqPM cB7WD7kdZxkuXw4CA316X3qt1/qbHCyueYBUe/0rnXBBzdh9R3P12A1DG9FCp2HO dRpK9rHsv5dTQuM+fTsNnUBmEszJse9LGltO4LO+bHvpL/qAeQ3+mOiQWz/OlDzu sOctsVA5AgMBAAECggEAEzF/RHrkZUKHXECOAzX0nYWbtn7xcmL6xbVLQBDWUaIn V+/ciECUn+FQIEhC2PFLOvCcZoD0Hf6tVCZCqgPCIilWDPN1XOXcVHvblAcGJjsV onLzxWaBJCv9T81/9JWzLgAI3cUtCOXoUt25T7OVYGaE0HclD7MB8Wqhgeh99+Cb Pq6xMv5nXkru0V5aolipbuuiFbEgCXkHmAN5ZzCZVTLmA2iZuOObphYaeIgEWYMI 2xqsEctEi+rq+ObSm+J9ALzEIhCIrdrT6txuWs1S3/T9dTY8ynOMNllKxcKhfGew QZF3Hg1dVN/r93gG3skm2oqErstsD3EwNP/3dB6SAQKBgQDvuQb0PF060HbE3W61 tz/Kz/fCggIooZPZtVZAWdJr5Urxj9h4AX8ljbICafLg/QKlZcWLHc9dBtYVHHmf 7+zFMNFTh8LlvrDNNbiLP7EtLg/qAAvGJzkvXPewjhghQgBqwlGXK2IQ39QLti8R kWRcGIJYQZDE8aOJt9tJfIJG+QKBgQDpvJRaJ/q16IDA8x3ktJCeepzmnQ5HfkuJ 8YvuIrQ2pNV/ObzV/cj2m3uwL3i6OSTILgqieQgERcQQin/w+z4Ll2DBtoG8DsmO PZT+QzCYxxEUFNJDgKTmxFAp7CPc+S+vJwU6Sx5EsNYj4FQPbdrY2EM7eu4qu5Ch 1VFXfENjQQKBgQDN3a7sJb7GmGm2rJa7tRAygqC5yF5EOGY5K3JTtw9umy3d/vMe M+LWBDZfvk7XClCwa5LW4pXGxO0qmhaU1D0YJtFNE6S7GiTJRh4ib2MfcpQ2Fy4F UH/afdM0KwLr5Lto81GQKbCA30dBe4Y2Zw6xzFZ7pmrFxuHzjhHirOtQOQKBgDKi JG0HXhtL+6BQyjgCGZYLL7QRb8dzB4AhcFOs9ucjfBBsfIjKyl8JvZikH/4PZPVs a+dYWrE6P8fpiN+2PXGbYF12YNJRTb5ffsg52+wsq3lzLT1sP8yx2D/MpNQ4sui5 hjtjjHIK8MiizvLstEznRGE9NxzQtvsnz9Ao3hxBAoGAF2zOrRIDUv1j8tytCWwD N13qr0E5e67tgnPRPpuoBfE0ZHBWH8MZUkR67SpeaDksQT8K8nJFVGIqHCpT69ug dB4TUPkn5X3MVUBKmV5UTUzwhFcfBcRsH0eWnEjaHmnIzjVqLqsA3yhdnSwkF/BL L/VTst2dAAFcvdBAYPR/ajM= -----END PRIVATE KEY-----' AS PrivateKey, 'MIIMUQIBAzCCDBcGCSqGSIb3DQEHAaCCDAgEggwEMIIMADCCBrcGCSqGSIb3DQEHBqCCBqgwggakAgEAMIIGnQYJKoZIhvcNAQcBMBwGCiqGSIb3DQEMAQYwDgQIoeljh0KCujQCAggAgIIGcB1lPVX+E7O/qsEbhsJZhPd5C3oWtODK4P/JzUiGEQAsFK9p5TLQPfaFEhlA4XNa7AGI9aniIRJyoEHNSI324YNmyDJvf39mvoE/sXHhus1noQNfuhzh/WrK8reG89KV4bC/FWpzipFQCyZHyxPjsv78xeEJtGUZTeoNJxLWISJXH8RSbK6HvgSih1/ZH9w5btwg3XaOWQpHkjsTtxFZ3vWYCSA1ic6iL2I8b1Of59ZKfwMMqrvVQyI5Rf8TiAbsIN0tvDbubPrOro0TgaQpURs6WNvNRz26GgLF6FU7Tbf5dxKjbgwdOR7wQsOa7YU6lf3JioPwur7Mjy2jj3eAQNsC1d4rOO43oy8eZy5PNkLDRu0ISFoxTI1jpu+a5Y1WOGRn12A+AQ5wtUFW8IwI8+SJx88zEyzr91FDDmSOHbk3yKlunhJnJlK3Y7twIpS0j0jDeWCCdYiSnz3+CdnOwDe8Ppn+M8/7lMhxdMZ/2fnbNGk33Xf1Gr0XVEVEY7a0N7Ac5kFgtdXoN1XFgd6Mk0t4QSI0LZaVJRqneilCHolbE69SjEqvjvw4BYW2UxZhzYpP8sygtVqdGemGhEchCwtJwysenLYKkbiTMnfArbrMGUsyydua2bzfhIOtYCO/Hm7oOkrQAUOnb6xU+qAPeNR55TZhC7d8sXW2ybnWcGLX/gJD/FXLezd0CxPQPEsoZHBfvB1tZBxrjW9LR+KUn1AdGoeY8pce3+aBriul4pFXCvOKCBzklMHWiKU0qm5gbChNZdDO9ZE9YEqG8OIkxOSq+6jkggfx9l0dtbx6pvMlLWpQknGJYSFyUmOb7VaX1NM3Val5smrRhbhOERilz6Obv33h7AfFXQ7GTr136bhEwDw32rbfJDsjzcvSqO9kzp2xF00PwEdzgWiOIQ7VQrqmZtdCFV9ysSiCzKCwdd5V6/l/UDW2B+QjqEa1y1ZWDMZuV1PrrFm/MHmZzgvercy4rrkd8S1GHm3qSDLCKmwCglPELp9lFUnUpeGqjyjb6ocmHt+jNGaepRo/Z+OkVcvgRYl10oZK5PcfsjoclGNvh7l7L6NsMdHLXZPzgrhSabypwP8KE2+pS9QJvIUgKMqN1WfXAENgnra3R8LTci5NPRma2/9LHkV/YOrze4tGy9tIMH19wbRbHorDGWFqTgkdOErr+NIkKAiRz1DOMrm1pK1N5cGuT1lCs5TGpM5zSFHEgXaNnlxfMW6+dcTOe5UYzMLZJEgjpnXLN1M2cZBexpLz47qZFpCopEyCdobZm/rBET1UUdvrBNzO0kyO+Xou+c2sq+1FBKIhQbrgRBCbwGHzo7HIz+0Kve8RtjSKcJ/W4N/LZvovHF7XmEEvR+nwzxOeKW7AA45VZH0OseXAhAKrZerYshT/c4URVNMmcLXUStF2jT4qOzX+dX37nqC0/3O7Nu8MvVvMjFzG7g7LSX4+VI82hqtJG1FG+Ip4eOjU+ZL+SqEsKt12HWA6qRi4EZc+UgCxNvInWScbiisqVcBCbrPNkslqOuFdalT7X9j1x8ye2JjD7bD+P21+fKrciB8lJz5YTJ9lwYl6zx/dmQ7VUjiedLqbbiugY56ePLblhJXTl0QvHc9baI93Xm3Ox+El1FhSsqVXqRdbzFC1CtjigRYAcGwq9AjCkNN5tEtt1ZA3XgtT17n+HsrvwuXY4w1LlKLKAwiDPBD3sJ4/6yBWo+0aOqZKGIPT44bRbibUbQIJHxWCTqODTNOfulClFnw3A2QiemR9GlR3SbrMJMLgNF8ejgkU/k34if4vGPhuXdu1gfttwPDZ00yVZl35W0MwpOczhLrBzt9XxcsMFj7+ouAwAOmbjnPNXd0NLbrT0sHpOlqHl0xUbInL89tItPMTTvpBw5x5TVkFT6pJI1wWFMSFbJhkwGImORL0hsMkkoHpUYkltD1pDsPVcN+v9/db+X86weR+tMWpZfigmOCAR/L4TnOz3bUeKBevtC8TeXNtGZiSEOBr0RfxUU6izsuWBptMq9rhgTle3BEMrYaO/IfLvpNbKI981htRSAjOtQs9v3VpTVl3hm32qf3GG+bTY9/IsS37gAVzyR86KXYz1rqxapasW4UlIw7/OQFrHvOOe0UucjvsvXxCBHWONkz/I9IoG9zhffoohi+gR0tNClGNMSuvXAi9LhdVqXY0/SxczTuRFp+oS0sM45QwggVBBgkqhkiG9w0BBwGgggUyBIIFLjCCBSowggUmBgsqhkiG9w0BDAoBAqCCBO4wggTqMBwGCiqGSIb3DQEMAQMwDgQIR5RMBJWs1SICAggABIIEyKs0VNENUQc0MagNatB4tk6aVGxEoGVmbrYdo1YJQneF5zh1a2Yn3Vlq8JTVgTTJriSPZeOPULPej2x6adaC/zOECNbE5W0135pgpBdM4rkW4CA04gwYZM1aOtMqrXghNlmEI+aMM2Lqx4mBVQoxVUCKCSDtPaowuaW8Rjbpo9kfnvNDrjdiG8m7p9D/GtjDX8lHAYVhOC5L7ZFHfVgGE6SWbW6YjHsjg9HAxoHGdYdozglzoM5LYyc2KhHXktbFA5XnPTaJ5VPe0RwjRTzd0/caZRwrdACIo4vPF5WAcNbOT9SOMkrJ6IHnun4FA83Dm+36KarqmsvSQc5n5YTMkEM/gojLlPPa4yulJwY53qPkqr3BosPpzk/Gy+0mtTxv5yzByZwPmsOoKrUiJWPRmc8rqfV8ZG9NKzpxCELHSZuSXOpK1pX1ATpXPtblq3wYh3j2EPlC0NwoCcbtGl/NT0J54d4MnJmvCPimvbO0f6J8QyTQY4Huh2IgZ/lHKZMDxgEp+RIdVwXKgjWTP+RzU0+AO9iUNPwQusyu08qQN843L5xnoZlrZa5OSkxRSpQ6jxme7MPT9iKSKnFdQamKuuby7+s2zqUS7m4zqvT7eWM2Qak7nEr73MH0yJPtKM8m6NHtpWYRk0gX6EB5pw5mK4s763TGilv13G8nYHswuQ+7WaMjzdBS6cTwLGlSGDn8E6/4923x2xpymc6IlekJmVgWYn1mY4B9UeaawnoN8UtQuW5a3P7P5MaBnOjFGSj6QhmkMWdo/Ytmd2bYadsE0U5r8SUd/VNJBPadGsWmN5Hv5lbrXA/S5QpWrn7fMfICio0Ve0rIjTEflW/KyKfFI1Swl86AwqyUbs+3ywzQhJL+t5Cfih0kMeTEzgUvrnYPlRDmNve5ZnyiEVHtkvBc9y2XyDfO1qhCReISiqycchoEreqUo7XRYMrmLJgyu1i7T3qG/VbktNfSiBkFLz//btVF6l5VvuC1KF3AAYnaT4vh6J8vtKTTQtxtmzIsPEmZ8ZujBdkBMHTSczPQrecfqoUMj9maC//3OU3ri5M9mqxyDtPZzNlDCrgd8R8uPrrlFp6bCYAqDoxaDwnDIdkip9ZtQY3tpMyjhf5X9k5KkjQcFeqCPKB1dtgtLFzqHkORRRM7chpwxdmWA1f4cpPNwGDQ3I7AIU6dnSehZb5Mn0JVw7sa0coY6mIhJg5yE27yiwd/YEJmreq+YfZJE7TBPc4L3eMiJ0r8q8oyh8Q1/eDnJ/wBRqgAHNzgTDyqp6Mf3IlNNgFeOSB/TLSH14pZX4Y5chViHc1PChZZwmD22ncqTo+EI3ZI8/ZL8SQqTlTKwcbFBLH+vpCT3HSkGcWpTg3zT50tlsxIG3MzRq1w9vqHAXrc7+IVLq5oDEJ11/wPhZYpTEFtUxYvgn8O8723kQacVzcalPGWs3nfkiJrus+Q6v+1YcHohPX/uBFxhHveNuC/ykFc61glw5OnF5cvxVrZY3yNpBizwFmNc9L4CT6iztppxUrdweYC4XYM+q6zz2NouBP2rg7B9KcPApupRr0Xz+frmtfouPJbwN4tc6Tm/FYjHroir7BJW6SDyAdiyUMzMiEa0E+ozI7oGYku+QWngY6nOIuZIzElMCMGCSqGSIb3DQEJFTEWBBRxfspbAJOxTG2d8EuqWZcnzkvC7DAxMCEwCQYFKw4DAhoFAAQUU9ObwokTuBuVy5v5Hf9trsEmFlEECIT61cZo8/+NAgIIAA==' 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 = '02-0000528' UPDATE Comprobante_Digital SET Cd_Motivo = '02', Cd_Folio_Sustitucion = '', Fecha_Ult_Modif = '2023-02-02 12:23:51', Oper_Ult_Modif = 'CONFIG' WHERE Cd_Tabla = 'FACTURA' AND Cd_Documento = '02-0000528' SELECT GetDate() as Fecha SELECT Fecha_Alta AS Nombre FROM Comprobante_Digital WHERE Cd_Tabla = 'FACTURA' AND Cd_Documento='02-0000528' 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 = '02-0000528' 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 = '02-0000528' 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 = '02-0000528' 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 = '02-0000528' SELECT TOP 1 Es_Cve_Estado FROM Venta WHERE Vn_Folio = '02-0000535' 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 = '02-0000528' SELECT * FROM Devolucion_Cliente WHERE Dc_Tabla = 'FACTURA' AND Dc_Documento = '02-0000528' 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 = '02-0000528' 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 = '02-0000528' SELECT Fc_Fecha AS Nombre FROM Factura WHERE Fc_Folio = '02-0000528' 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 Fs_Tipo FROM Factura_Serie WHERE Fs_Cve_Factura_Serie = 'B' 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', '02-0000528', 'BAJA', 'FA001', GETDATE(), 'CONFIG') DELETE FROM Transaccion_Documento_Log WHERE Tdl_Tabla= 'Factura' AND Tdl_Documento = '02-0000528' AND Tdl_Tipo = 'BAJA' AND Tdl_Transaccion = 'FA001'