SELECT 'IAGA7601154T3' AS RFCE, 'TRM180828UH2' AS RFCR, 'BB2CE3CF-DD9B-4E7C-9C40-999E60F796B0' AS UUID, '1489' AS Total, '-----BEGIN CERTIFICATE----- MIIF2zCCA8OgAwIBAgIUMDAwMDEwMDAwMDA1MTA1NjMxMTAwDQYJKoZIhvcNAQEL BQAwggGEMSAwHgYDVQQDDBdBVVRPUklEQUQgQ0VSVElGSUNBRE9SQTEuMCwGA1UE CgwlU0VSVklDSU8gREUgQURNSU5JU1RSQUNJT04gVFJJQlVUQVJJQTEaMBgGA1UE CwwRU0FULUlFUyBBdXRob3JpdHkxKjAoBgkqhkiG9w0BCQEWG2NvbnRhY3RvLnRl Y25pY29Ac2F0LmdvYi5teDEmMCQGA1UECQwdQVYuIEhJREFMR08gNzcsIENPTC4g R1VFUlJFUk8xDjAMBgNVBBEMBTA2MzAwMQswCQYDVQQGEwJNWDEZMBcGA1UECAwQ Q0lVREFEIERFIE1FWElDTzETMBEGA1UEBwwKQ1VBVUhURU1PQzEVMBMGA1UELRMM U0FUOTcwNzAxTk4zMVwwWgYJKoZIhvcNAQkCE01yZXNwb25zYWJsZTogQURNSU5J U1RSQUNJT04gQ0VOVFJBTCBERSBTRVJWSUNJT1MgVFJJQlVUQVJJT1MgQUwgQ09O VFJJQlVZRU5URTAeFw0yMTEyMjgyMTUyNTlaFw0yNTEyMjgyMTUyNTlaMIGpMR4w HAYDVQQDExVBUklFTCBJWkFCQUwgR0FTVEVMVU0xHjAcBgNVBCkTFUFSSUVMIEla QUJBTCBHQVNURUxVTTEeMBwGA1UEChMVQVJJRUwgSVpBQkFMIEdBU1RFTFVNMRYw FAYDVQQtEw1JQUdBNzYwMTE1NFQzMRswGQYDVQQFExJJQUdBNzYwMTE1SFNMWlNS MDMxEjAQBgNVBAsTCVBSSU5DSVBBTDCCASIwDQYJKoZIhvcNAQEBBQADggEPADCC AQoCggEBAMjS2yECKWM0wvi2EaE3t9PjFy+wKZURE1NlL38YBDuOeSmns10YmQ3L QF5gbbegXvRQs3oQX6sotRmw9QtaNsgW860AyQPpgJiip4sVAVGW27P7clKN0MCd YYijFp7249R9myjDy/IsjGHZ69//MWbos0voQUAkIfGvzh04ythad50EUFlTqil2 GIKds5wNUIYv3GqX/42sCao1pW0cu3LEGnpaMoT4UHbYDXhNfRThz5rtqAFQ3s3Z uAtjqQAdA2OowjsArHRxGKaJNzuhDfw7L4R8oDszfpftxu+K00feoPFH6jI33aKJ NjxMzUb081jH0jO4pNPXYrUiA7Y+IWUCAwEAAaMdMBswDAYDVR0TAQH/BAIwADAL BgNVHQ8EBAMCBsAwDQYJKoZIhvcNAQELBQADggIBAH/pdTfthiHr4dSpkc4apRlv LiTkZvCD8c2fnlp5QKSG0GqCpAk7psDrgLlS0pizdTvpGHaxA7OubAet/hRbVE/Q CBNfRGS+AohJfULgFqzRtQlLFe3ZAulYMtmiCL3dkC1nbzQYUTusDEXUIzxzNNY4 wotRhdclWdd50INoFDeV8JpAHotiQegFjWqZ5DYln4Y1a4ByojMHvlPrbQSZbdes Fc+kJXuNSoCGS+pyqdMJmUuHAcCGAISF9kXM4mXp7VBHpOtWtIKOxLDpX+6fr7YI ZUxzy3Wscqr7tQIYu608oOXJxDEQDb3T2u8HxYMC5TPSmAQFEhZHmfok19k6Q2MO rW4lKra3VcAMaaUxFaxGEGhfgx9QGpbWFr69Mo4tcSC7Y1kPjyyK1uHlUzWth3rg bENe1mkNh1Rv3B8g3nNKBjs/5jReI+SXFQNWQT2oM8mN+bI/Xa3zJYruE3MQXY+1 y1TFayvXRT++3TYKSRR3lMhsI9L8VE96mxWJmLvmNYZSHz5+l0pwYg/WEeTJuq0B xtRwHQ0+i1M+YojJqS5r4Uxxdkna4yjcklWjICuIvyrO5hRjj4EtlhoHM9UPYNqN zZYYfrkBs3AMoJVyIqvXyteZD3bY0utJql4bEQKac/rIdyi0Oyp/Z0oPgbCe/UCL f8I06HgaD/1CraLwezRo -----END CERTIFICATE-----' AS Cert, '-----BEGIN PRIVATE KEY----- MIIEvQIBADANBgkqhkiG9w0BAQEFAASCBKcwggSjAgEAAoIBAQDI0tshAiljNML4 thGhN7fT4xcvsCmVERNTZS9/GAQ7jnkpp7NdGJkNy0BeYG23oF70ULN6EF+rKLUZ sPULWjbIFvOtAMkD6YCYoqeLFQFRltuz+3JSjdDAnWGIoxae9uPUfZsow8vyLIxh 2evf/zFm6LNL6EFAJCHxr84dOMrYWnedBFBZU6opdhiCnbOcDVCGL9xql/+NrAmq NaVtHLtyxBp6WjKE+FB22A14TX0U4c+a7agBUN7N2bgLY6kAHQNjqMI7AKx0cRim iTc7oQ38Oy+EfKA7M36X7cbvitNH3qDxR+oyN92iiTY8TM1G9PNYx9IzuKTT12K1 IgO2PiFlAgMBAAECggEBAJaMS62hGzm90fP1OZ4sUOjNMxKS83lGhcBc+JBEhtfG 5NnvWC0QRZzro+OcUmP4G3b4ELQPFkkPiUQrPmg2Rx8U5bPqBMekAr1qIkPHiWeK ukVg2ME+gyICWZ2+9TRSTVV8nBahQYDZGJw6a/NOMdC93bun71KQQ8oVS2TosFgj ldXM1QHZ+Gx2HYChE0Xn3oRShZdsVrEv/Lk8tQV5/plC3Gl2cZxKjyikIvAXRg2p l1HT05t2kCSqqKly/Ii+ZcPZo/YzQSv7uvIaFxsfL/gdfvJACqkAU6gmLaODSzmZ fSYftUhfR8N0fCVCOkVim6aouIzuEjxYY1n7Do0p6AECgYEA49u91Fr7TnT+w3gd uwotFJvLo6vbFT6STswmYMK4/83/d+Jvk5Uqbxcu7DwmPzNFzDPMGrs5mWYoqm62 eTas155oDdDSLKES9JOSlXn7uutznzui8iCc6Ndd4xOxFVJhQfMCdYY0SvRJ9uGm 2btlpZ032feJhpy+M6g6/hK7zGUCgYEA4aBZ0ndXleqPeoXNVDsSGRDPPR9QEwRl mQM284jZM6uDdjpmw7sKRlxMWdUAeT8p36563Zg9ylfzg3SzveS/ZCtiiIqzRTWq 3ksxBtZHTCuWA9vD3Q6T5JD1Um5D8STUgqWKJVV7kuqggF0bEZeE1dF3USGAkKj9 ZvAl2XYnMQECgYBqig1ZZG0KwzN3zAsCsIBhmXL/BVT7uvUH+Pac2Y9MtFIWCP8o n19m8A0Vkg5EEMI696Eggpgs/JJZFkklpgXtD3kRtKkBCxNk3jd0wsOMI5k9Q9It qkgTqteQXF25XXpyLqDguK5suYp38Axm0/N0G23I8bARC+r3Flr2/2Vl7QKBgEHk 1tbEy+uYqXabBTCIX+y6IAw1zOkA67sYWUAew3B3stkgjUq0oXeTFSlXL+A5Nj2B c5isEb+6l//YYXYgDFVw5kICYADif5iUVSkuA3yXbiSKVlWFIGQsgbklQup2Wyoc to/Yu1JY+68BghpNKhpYJoSnSCj3capSkHtGKoQBAoGAFAOzR3/TL7yt5jaRcxHh KNMB41PFh7PHFFSDUbdhojux4cIVdW+aYDmqRHARuTE43RaouDLcakbXote64amP Jinn3jwz5FF2Kuy4DlA+sBdpy4c+JFpenIxL0O9f1CY8lQzlFpIZaQj+WsfL5KPo w/vitjUhROLvCP85RsQs5bM= -----END PRIVATE KEY-----' AS PrivateKey, 'MIIMGQIBAzCCC98GCSqGSIb3DQEHAaCCC9AEggvMMIILyDCCBn8GCSqGSIb3DQEHBqCCBnAwggZsAgEAMIIGZQYJKoZIhvcNAQcBMBwGCiqGSIb3DQEMAQYwDgQILSUA/t+iUIMCAggAgIIGODtRMzs43XyHTHqDQDXUQZe2N0ZPIm5v7wEzew0RzATw1LMdNfX71eVuDSft39gg+i/4zri9Hcxn3kFnIBVo3FZ3jlhPM0BYRfdGl7eQ+uZ3ICRaqBdHnCbAThXySPaVgwYS0VvVbcsmnZxCcNSWNuGrq4ou2CWqHb8wnEwTwU2XLDG0GoOUheJErHZ+cE3gNmf4rRpN7+rxShRf7IN4uFk28sz+2UmDuc+5FgEHoD5s4CFMgAdPGos8oSVxEI7VHWBLpYNGpAVvu8WMCFe6B3b2qyghLP/B2bBvdDi5CgzByDmBUHkb7m+mK0YHZk9LhPPegAn9V9Z1fxr5UkGPQsQo0yJ4PrPc308HQAQcbjiXvmI7cCvEWXGjDQOuHBZiWI5GMiW/UgDjIxhh+0Q1HABelzoeAyOLHdxIrcIn4dtAZEZ3QLDHQBExmd6Y59HZN93GpHmRBMw39W6pTJKuzv2zBMXVADL0GsjsQylZ+U01OvYprxh9pzGrEWjzF6sEmBMnO9MjVhKOMZy7ozUZzh0h5PLyrnwnpvpSRsR1TeRElh0c8vCB2LYZ2Vpd2KtyeygtDuwy77Jg6HcMcnIVSSvAeU06n36PFa5EkOaTa9VGPAXIPYWHr6lPhabDwNxTmyiGWv+tLdi4ynV+N+IkzWHfWHWeTiUPswEqPB6eQ/AT12CRe9NstNTPgTB4WJgh+JJH1LdxtUFsiNEBD5G0Cyx5nbUzmyeMOWeWO9H8BwCqE172bTzOBCyDL76eXhO1lAvp6SxeUXh2azy8uzOsonRh1eQA/4PDeIHGN3rNXPsXXJpFfD2q9o5FBvHPx8Gh4j1Vqc/mtm4u0QLt+FjLiimF8Hyo9JnmVvEBsFAiYEHQne3AOpJaDQ0YC7geW5IMMOcYBFk/8yz7Pmnr1ZvSgQGPw10TGz/WvC2aG5tW43rCujlDT2l0wDwfBFylFEzZOqQSLw4MkFvfJ5fAzAqwPYUrL7ketbDgWreV/lyKoK10XnMtJuv4WRIE5URQc27W2fr7nQrBF42t+1avcqjRrcwaXz//o+PktykeeZiFfmV7rcWM+9cB0jkU3ik/YxPb0gUDY3s9w81EC3gFepgXmE00ItM1LoU//DqjbqGE1OADkoYUAYsKbT2kQJiT/0VdDpxgtLXp5SrD2Xf2vgTlnxWQO825NGA7kWH5ZKQJL5L9ovWlskh+7+gOqTscG2pRBhsF9sSL+u8xzOSoOjSQh9bdelri34+RH5QkL+zDaL9G6Wv0tqgom5v64U6ntLVeyrifn8ePvdvFVfVnvVgFxiRSHlsAB7mDUJkM131BLKb2cT6LID1U1Q53mW5EbJKA797sjRJTWgaVtPsiLiQAjU4KAYUYTKIyWJCO7Ran4sWqa+tc7++fxQeWO1YJ8H34nXx6lx1pW9zCJtstzvRReG/dB7GJe3XoWnBO/z2QZ8nyYJXTsSIZRqmpsRO2rYzOE1QrnEhtqTj2rCiFVSyZhtQZD9e0t9DXMqx/2qQcrIeX9gtLxdLTugQSXfpn5R0FwS1OnV8Dim+Z/qP/fDHjQnAlZzMojE4vJ6gOdcHADyOcCU8YxrX/yEvKiYFKJ9jbY8eWihGxRcxku+WhugKn2exVAtWqxZCO0I1zkD90pL5XdXKfrDd1XHgM+rWcUyLFxlq6FWxElCSEgtsWLcpdPbBnAkJc4ms5HoYYHVYYasO9UmcwBDMfPXXSc0kviqOLK6ti7xpacyUYhcJHdwOb4wleOT2QJRkWTJIBQeAhACv3sLS/wtyke+SfkyT1Pc4CPitRxq2o75z4ak5nz7lZ2YOSUT8g806f3KbaqxcxdEOKcHsRZ/KSHqpOa3n6fixxjQ4FcqWx+BSxYv4iU2ZRgUYQf/rcwCyNmgN2/Wt6y3uAJnFAWcqKCP7uaaGa5fdLtQ/9cOKKW3StkEklGilR177pcn9ChJdWQPw5efQGoJKj9e3YTJGtbuuCJCyyhUbjGIzhatW5idc8RpeJw35JniRNnJYfe3CGgPyFh0cQjDzeuSNOuhDVXasvoHbcVbduTHBD+DEJmdeqBvqqeLpn0re3M+3vxEThsGvO4I8CWHo3ZqYZPZeCK42urC5OWETxtUwK7Wc3FeY2MIIFQQYJKoZIhvcNAQcBoIIFMgSCBS4wggUqMIIFJgYLKoZIhvcNAQwKAQKgggTuMIIE6jAcBgoqhkiG9w0BDAEDMA4ECLS7nP01WYvAAgIIAASCBMgBZ7cBS+sA0kAo8pp4ux98uOXyGwICzvgWL7PTprViGbi4emYNPujkO5BkhvldqfqLCHpWGlWaSCv3vNPdfFDp5NBNJm3VU4rLlGcexDF+FBQm/t2PRxRiA+FP+qn59f35IqDbSEsUVeAiIBwI5kFHesNnGOvW/FZuNCfPjGvCrcostq6laLf8XbEIFZu4CIIG+W4cVR/ZiQzb/SZrmrri+OXvnh7SN8cm+zKMD+QrI5QzLHXdkjutxTV6nbuYNyBCYDUWGU1xyPDzLJdGmDlRb7qw6zwHgvjBCfW83qf+nGMZhyT/6fvcwdK23QvDJh1gqjyHKzTUQMi8lpD2RpITvo4tBT+6xBa6TnVVTtJZBTnnewJO6n5Wt2iGh3d2oDrs4cxAryQoBR9ejrGWq4xaKkKnybvwStUTP20A/uVSe4lT2b4ZmbuyTGC8FYv2ldjHYuSMgsFFZSsiBA2ybahev1lffPtaT4Z0xh/N1MIta3L5b8Zlv1hWeeSkwrFrfbsj0YzxZhn2/QHYWmLspRSzx5GzNnzQPd7qEdvQEzYtgXtN3+TPybzgA1Vl5nyzlQVKcdG/9A/Ib8US+wh2HQOxZo0hujHp0AdBEtpp2na759sr9UYzckUZheGiymY7e9C72Lpw3tvvX3Y9d3AHZsYGXgkOJ/kWhGqz/JtkweaFUAJhUv9m89gQzid/MNtZHtihzczno1E9CY31HTKrb+uifrzB7yfdI7aoDKZn1y8tdHuoRj1d1ci6TBEdj0MPO9q+SMI9P4R5WLSuQF4skIS6CorjTF5YC93vUJ//rOiMUa56WA+Rr88ZMcek+wn8OM8i6XCGHsg5zo5ekTNs+X5eGtMekbYQep1G2dXDRj7p/QOvD+o6fRmUSz9eUpROlJVAyOf/J/ALxImcUEajYCIgH/2Ijd1vKGaqsScjxP6dBlq1dmJlqcLnvHN31e+8l2EkE59049EYdBNgIenQ+nsWeULJZCJW09KefhWfN3gSAvDddOH4KGpNChUc3NbjR5D8tHezEFeOIJYMe+eielW8vn4/X9u+U6aUHIkwEi1nUSyMirgvb5Q7wgB/n2WMlLl5RcY82nJm4dOWKvys4Y0SZ1OOentWjl0dBO3H/6YvuL07PxEXVfC37LZqZCHux2tJhKPJXpgiazAGhbcPinV6lFRtwPkR6guG7qXcgw7jeEWD7T7kRRkenoBBBr9WQvarwddHfkk/1Xg7PcNO2ZnGza1BpCuV/8NnrtDUDtKeiHYUC+4PWmJOxqeLHGof4EfqwtfLxMihGbadiDtM67R2eqN6/fWJZiZ5oWcB9PjQGqwIQpJsgzqgs9R6/r5XDhZM/uYJKRBpvT0LGeCj9ATD2VQXHc+msflCGQhQqVQo9joY2WyskYMPVMoNEvdIXMICSw96NF1lnBzQYUIbIJQxS+hBmbYAt2OkLJvHNAL7y9W0Jc2j0h5iBexsPfRcHjrT+XAmzNMCOMIQrsXUlyUBILwiMQQ8Zx882JBS+4OAp7WQ9WIujtEE8T9Pn06a/RQU+5BiPP34cB3O8vnENjcbAptRiT/qt40ZeyD9oidvwaDHlqpupOAD1ZHKvgzgx23DcAO2yFLGCLLxuxKN/sZXcbWsLpBQChkxJTAjBgkqhkiG9w0BCRUxFgQUGAJaWIbIoQ3wW0A5pu8kg/RbWm0wMTAhMAkGBSsOAwIaBQAEFEG00wnylPSwmXWHBdQFlEMbBSScBAjOjOjTJlK8xwICCAA=' AS Pfx, '01' AS Motivo, 'BB2CE3CF-DD9B-4E7C-9C40-999E60F796B0' 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-0001662' UPDATE Comprobante_Digital SET Cd_Motivo = '01', Cd_Folio_Sustitucion = 'BB2CE3CF-DD9B-4E7C-9C40-999E60F796B0', Fecha_Ult_Modif = '2025-07-31 18:08:18', Oper_Ult_Modif = 'ALEYDA' WHERE Cd_Tabla = 'FACTURA' AND Cd_Documento = '01-0001662' SELECT GetDate() as Fecha SELECT Fecha_Alta, Es_Cve_Estado, Cd_Timbre_UUID FROM Comprobante_Digital WHERE Cd_Tabla = 'FACTURA' AND Cd_Documento = '01-0001662' 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 INNER JOIN Sucursal ON Sucursal.Sc_Cve_Sucursal=Factura.Sc_Cve_Sucursal LEFT JOIN Condicion_Venta on Condicion_Venta.Cv_Cve_Condicion_Venta = Factura.Fc_Condicion_Venta WHERE ( Cliente.Cl_Razon_Social_1 LIKE '%5657%' OR Factura.Fc_Comentario LIKE '%5657%' OR Fc_Factura LIKE '%5657%' OR Vn_Descripcion LIKE '%5657%' ) /*Date2 AND Fc_Fecha BETWEEN #Date1 AND #Date2 */ /*Empresa AND Sucursal.Em_Cve_Empresa = #Empresa */ /*Sucursal AND Factura.Sc_Cve_sucursal = #Sucursal */ /*Vendedor AND Factura.Vn_Cve_Vendedor = #Vendedor */ /*Cliente AND Factura.Cl_Cve_Cliente = #Cliente */ /*Producto AND Factura.Pr_Cve_Producto = #Producto */ 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 = 'ALEYDA' 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_MODO_CONSULTA' 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-0001662' 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-0001662' 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 = 'ALEYDA' 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-0001662' 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-0001662' 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-0001662' SELECT TOP 1 Es_Cve_Estado FROM Venta WHERE Vn_Folio = '01-0015462' 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-0001662' SELECT * FROM Devolucion_Cliente WHERE Dc_Tabla = 'FACTURA' AND Dc_Documento = '01-0001662' 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-0001662' 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-0001662' SELECT Fc_Fecha AS Nombre FROM Factura WHERE Fc_Folio = '01-0001662' 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'