SELECT 'AURL730623FV2' AS RFCE, 'SXO170925FE8' AS RFCR, 'C520877F-B4E5-4104-9A71-6D2FAA96F625' AS UUID, '1029.38' AS Total, '-----BEGIN CERTIFICATE----- MIIFzzCCA7egAwIBAgIUMDAwMDEwMDAwMDA1MTA3Mjc5OTAwDQYJKoZIhvcNAQEL BQAwggGEMSAwHgYDVQQDDBdBVVRPUklEQUQgQ0VSVElGSUNBRE9SQTEuMCwGA1UE CgwlU0VSVklDSU8gREUgQURNSU5JU1RSQUNJT04gVFJJQlVUQVJJQTEaMBgGA1UE CwwRU0FULUlFUyBBdXRob3JpdHkxKjAoBgkqhkiG9w0BCQEWG2NvbnRhY3RvLnRl Y25pY29Ac2F0LmdvYi5teDEmMCQGA1UECQwdQVYuIEhJREFMR08gNzcsIENPTC4g R1VFUlJFUk8xDjAMBgNVBBEMBTA2MzAwMQswCQYDVQQGEwJNWDEZMBcGA1UECAwQ Q0lVREFEIERFIE1FWElDTzETMBEGA1UEBwwKQ1VBVUhURU1PQzEVMBMGA1UELRMM U0FUOTcwNzAxTk4zMVwwWgYJKoZIhvcNAQkCE01yZXNwb25zYWJsZTogQURNSU5J U1RSQUNJT04gQ0VOVFJBTCBERSBTRVJWSUNJT1MgVFJJQlVUQVJJT1MgQUwgQ09O VFJJQlVZRU5URTAeFw0yMjAxMDYyMTMwNTVaFw0yNjAxMDYyMTMwNTVaMIGdMRgw FgYDVQQDEw9MRVlEWSBBWVVTTyBSVVoxGDAWBgNVBCkTD0xFWURZIEFZVVNPIFJV WjEYMBYGA1UEChMPTEVZRFkgQVlVU08gUlVaMRYwFAYDVQQtEw1BVVJMNzMwNjIz RlYyMRswGQYDVQQFExJBVVJMNzMwNjIzTUNDWVpZMDQxGDAWBgNVBAsTD0xFWURZ IEFZVVNPIFJVUzCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAKtJ3qxB 1MIkJzqjjEXzIYiRbfDlB8J3jOROE8PnmEFIbeEFNaaXfQRe6xBNciI/RoXSgQXl OZnRmqPKNzTZI7cENy6Tua9TjarQibB9iu8DVOMnuItO75wxFVGHk/HQyBKT3WD4 vl1nbF12NHpAO9l414pyNcckMRLcS/w7nvvWqpOb9b37vA4pAdNVm0TpVyx9bQK+ BYTZi3qiFL++vgtlWWcvN8Bfa6odQP8ySEm0IQaiOxwgwtbMpi/fSDXWNVNaTNKo yrUmeyMAVemO5Eh57pKZJy1cqRI5BFd7g0xXt258+prVlJk4xCYlt6VjZyfYZW6F Q4WfhFHqwTMb718CAwEAAaMdMBswDAYDVR0TAQH/BAIwADALBgNVHQ8EBAMCBsAw DQYJKoZIhvcNAQELBQADggIBAHWdL8pA3MBaYO54dHcZeooorWz209wQNDV9GiWv n2FMevtv7k+Sg94QpiKNKC48iuHdP4N3PsNkgk6zPG0fhHn+EtFFs1c0AwSa1SsP cXOgucvuBAc1RwdwYvp702VXPGVtrGTZJDktDe/LECS7MPrCE+FBCkJ0bEkGkqC5 1N/nm5EAg+kvxiknpgsHa+GjYEA7BFPpQuYiTVaV9BjvrUfKEC/ZQxoldICL+Fgh YBWLuo+mzpEHrjsF/KSJqlbK7oH3dJzMPgN2bTCXtR0x+zXQPIdODESeOky9+YQA NXxKIyytoXa7BicI1WGPv6HCkw0ljvP+TOdNtSrNMfAEC616ZTYnBbCvTPkHWIcJ ddi7dUQhVyMZrdQumlBGXa7BufZv4xEJK+HgPvhHtNG6eZ4mGf6AXn+99HW2FOuh mPl/QPHr1JQ17ZInhikchy21rP7QkAT120x2XAiNdbm2kCnJGxfL7nqf9EoOn8Fa a5MkDhcWfdSqehCGalvC0bamw/x2kTvL28X8j4myMvQEEcRg1oU4GgcPTRoGxgaG xQrUfxrYBYxHmmgVxgtqmiIZr/GEwNjfst94rwGy17gmECsUuyVDWX7Axyxug5rj LZmuGoZxVus+Wwsl6fG2BjKRVCMLxes5AGVWBdvSLlJbaBJxkzFoFyeZV3f01wgJ pAgs -----END CERTIFICATE-----' AS Cert, '-----BEGIN PRIVATE KEY----- MIIEvgIBADANBgkqhkiG9w0BAQEFAASCBKgwggSkAgEAAoIBAQCrSd6sQdTCJCc6 o4xF8yGIkW3w5QfCd4zkThPD55hBSG3hBTWml30EXusQTXIiP0aF0oEF5TmZ0Zqj yjc02SO3BDcuk7mvU42q0ImwfYrvA1TjJ7iLTu+cMRVRh5Px0MgSk91g+L5dZ2xd djR6QDvZeNeKcjXHJDES3Ev8O5771qqTm/W9+7wOKQHTVZtE6VcsfW0CvgWE2Yt6 ohS/vr4LZVlnLzfAX2uqHUD/MkhJtCEGojscIMLWzKYv30g11jVTWkzSqMq1Jnsj AFXpjuRIee6SmSctXKkSOQRXe4NMV7dufPqa1ZSZOMQmJbelY2cn2GVuhUOFn4RR 6sEzG+9fAgMBAAECggEAYaMI363ixgtvpRhGxDSz37HuNkuHIc2drSHoWFoySrwr jgG3NE/TvmMQoMlUjrr8yxlT3HVuYQS+njCNSX2gwxkPD2i7hnodHcojQkw9nsKK Z7Vjl10WbjT4TvH2XffBo/1PSpBfisSCW8AeZ7UnqG4ehtdVWj+CDZsvYQbnN+uV AwQSi1JOskLwFIznlXlGIDKaPl7H71mnXD3lGzwTgMXA/42xQinuLJuyrAFvCr89 zuaHsV+SONTZ2aVL8GDZFEVw2MSipAuc8sziqHjPzHFHhTkB+e2EXImDrpJ10NTr PHYcSjhhOyNzdWmOEQiLJ1UaeAIaCHPAJF/QrbzeCQKBgQDh6vaP/jDgtF576oV+ Uqupg5VhaEM1EkOe2Jk7BZ58Zh0zB3TVBQeaxOVva/IWalYT0oS8abNILYjNeVYZ h3hxLWBbZWv8e5z7QT6zZV2uBTxB87VE/IvlLNIjzDy9VzbuEsfUdEyShZBGoywJ FLfwlcyWfXzSYT662LMRoS9RYwKBgQDCGLdXUkPgjFG9e3aDBeALYd2F9Bf3pszI cawxAN9/0LTNdq/jcuveTzmQbz0TkzeXAWp35I+YW8QnVrEOBd1ApjBKtBsZx2+v YfPspAGt2V8aPc9PYjUDSLvpePfDDMknCk0D/nEU92Y/Pb3MggAn1uv9/7pzMbOO 0c3PSa9o1QKBgQDAPursI5nCTZqthidtFLqBeLiweEHgspcaYCUcxa5VG6wzVWAF Oc9705uOUmRi0MBJA/byQlxOynjEqUEsXkyOutdpTwgyhZpTcPUDQfoS8N+TG+kg OGxva9GypsT1NndG5nJoB0N11/SrN4VsgNX6A+9iDI0glaIE7AyNrwUOEwKBgQCp Nb7wQ2mlYu8Hz5Cb3Q1bHvBujUQvxJyWynKhLe+qkBpvXN8t3MxAPLUkc7W9UQSP gs58wydkXev9l5g3b2lZqQhEuAtASBvXu/9Y+An2s6AzUltfC3DH8irP+YOV6Zmb jWFi7/lJm/zpeTv0BAl6seV+w+iZ8GRnSASyh7yCGQKBgFvdV6bYre4bgT2HB9WW QN1wrOneHyVN13dBNy2cU6+4aVpfMH0iWtNvZVv8fReWpyIUMBqY+4PKAH9TmGza RPolyTi62FwAdAWmO/vbA5HRZzTk9W+MvC5hFaq/6YHFjUkXbQNJZzlqht49a8XD ONsS6NT4RqdKRjKbHkQPhxdz -----END PRIVATE KEY-----' AS PrivateKey, 'MIIMEQIBAzCCC9cGCSqGSIb3DQEHAaCCC8gEggvEMIILwDCCBncGCSqGSIb3DQEHBqCCBmgwggZkAgEAMIIGXQYJKoZIhvcNAQcBMBwGCiqGSIb3DQEMAQYwDgQIYgoliD7dOAUCAggAgIIGMArM/DYUALiuBIydXjcIOEHnnQLSvTW3ABwgfLTYDm6Kj6YhKpwMRuAVmVBgw19vyVrYOXYxF/7UyBGu22PmPrt+8yESLD6f10J8gUSCQRRjZW91a2BOro97o1lDxxISOUsjjiekfLhfZju7KPCZIHx/TsUz5mdP/DsHnJu2pJQFosdkIQDIdqI5h3tCLDSwjz6AIXWZmpsuO7K+4KmHdP+AdKOUNW7fhBbDe9q4GWKHrT8KLMTxGjBPfY1FT83owZHP/SfmjJhCV+AymgYGgK1DAjBneVBqT6hSJfrrlWvVq4OgFLasGxJfyVx9+iPNX2IW4CoGQYinLDt0oqkJCPbSWAY8vsKFdE3CTmkDmJ39DRcld9irZHrjnAHe6jxStTlgtfYytIytYRYOgWyumT/3SZEX1kn7l9rvCxmSj9iZ/FX+zUh8+p9o7pWJX+n2h7Q7rSXB3ivPmR1lMWeKr0Cbtdf7RNjcyNNCp83b71hb8e2gQCoK0agOrVCZjsX8kYapxwRTq+63MJISLaOAdE9bmSlk5yxs1LQimdzMUNQw/iHO9HRtR/9iEnuXImNvQfPfbLN//QS1oU3d2A+v4nbTECoyDgFl/RquyqJv5wCO6sdMfOpvfISskpPwOL/VuyK3HMpVCEZiPbvzEuAk43Q7pR0TFiREO+7H681S8qSzjScw4xfZupZqerx96waMT3HUckjMEUuUzvxc6jGivBfnN8xNrQ2Qn6mtUemDEFiq/OvXVmx8TYC7ftHyWqQclbacTonZrMVYWv15iwIJqMeUacnuyM9+KIckRZBDikRqVlQoP2ymwQTfl1Z+rR1PhygVt2z6ntGUkYhaDisdnw3pr1XNbPbWDlUGvO5J3V8+Fq8tLWYnWdsYPPix3ky+r20FVfJvPRC56dX/3IDqblkDmYBrl391rEllUH1+A4vwk7ZGw3PfJnwXISJc2Wr8wJm0no0KDog4oco+QKF7RZpN0xih1x/VYMsWHcmex7ohcQ2OK/JINj9DBm54YjDYdC3pe/MwYSNP/N3L+ooUlLagPIC9Wb+9m8mby8Ln8SCkiDdSPa1R5oLh7FyGKDuMfe7GjD83E8C7x4Sd95646rFWLn5vMyPyPYrJ3/qS+IoQgfqZTxYatBGq/AyxCbV1HkMTsUXE6ZUK54Z5El+3dJbg1tvnvWFw33564qqOdIp2lwQyTR+TqL+AOY+Pr+AaXWUKnWbo18bQhx/WeBzOu9vnve8TLHhPbivF9pqo5vor6gJ0y22qmjxr/omqQoV0ZsOVpXs4yXaF5VREJba1m0OEIUUdGfdjc6mxRKYZWyFH6eC7A8zrjBngQZdaQ3zTHzDF/CObV65PqEgBLr3bEiq7fsAL60cZ45JA9MqDxHj1V5J2l3XeWn+PQjqHTbJaVAjMQeIJdELpzy1EBEcTFX6O7ltIwLLtVjUaZ4ZmgzN5KmW18EYmEaJEAke3Irql7986fGTgel5idmmjiLFmLzcgdHol9rm2eaKpmvSj9S+ypYziXJWs3+XUoeNAP4YlO/6Fzw40qBVZQ5I54/nKjQMD4RffEDxw6CsSfSBcAge4p3oUriJdIwiNZ4P3kWzvPI1wjGPc+i0wwkbb5c/ByD5pZ3jLHvNzK6Ke8FMvRu4Y6whSA4cxLMBNyNpZzYdaWbaa8qxNCANt7VgRGeABG1ybcZJ4uhCWhBtx6YOuLAeIAuKhTM6ft51xJ4u+Qbnt3O7bhVE5d/mSyevCljIbOLrUKv8o9Vxw76GMBxgvKEL+/U3bMSI/vmYBie7q51AylKhs5sOQfrvUgwMZvjeGoHfpCycfdmTmXbXkVOlrMuY8r2DZLUybHY/r7RBJ8iiLojQ+pgvJmqurKkm5JBMaDL3L0cTaopi5Hv6Told//2RKBOEy3qg7Oxc2B96dU7UglY+Fhc9mQlN2f9r/fM/2nCA44NgMsCyBM0CNqE/NcBeSmpT+DBLi26LXiADqFsKqpwTlcAG9TG+74kuFJH49eEU9SUmwBGEnnwf7p4XCqH2DblGCYqHAOb0TlyqGD24aOpDWmu86GIqVqPe5efR3CQIXZqr6ZyAUnMhS/sxvcpgxsDFanx+3qZ+1UuZbH0uHezCCBUEGCSqGSIb3DQEHAaCCBTIEggUuMIIFKjCCBSYGCyqGSIb3DQEMCgECoIIE7jCCBOowHAYKKoZIhvcNAQwBAzAOBAjxiYmt0WI/EwICCAAEggTIBHsqaXqpwRU6MPr3V9qiMoAl1I4PIBHso6NhhygeSiVCfOYg2SCvmKxrVqS4Z2oFK+xOUHQyBiOoNNLta8yW//w2HhQNjnDRPIuoFldb7vU1z1XttCHpSHwC8cbYpUpVhel270Vk/1FPKltDp6oy+l58qlZdS15t1x1L5VG0XRZKDApP+RGXpznvLemGRAxgx4zUApIhkXayu5TkTJUQ7BYvXpbgjglZqmwpjOwaERalj0YrfLa5nfHJu7CuJ2jwayb15NvXN/VNPOQf1bn8knZLnvMPmeCzRyJAHpeWUv5TFV00+wtLpcDwojwMHuoAvYPb7CmTSM16WZguVrl2QDzuIB8at/TvzZcc/SRwBnElQG7/IAt/QSTCFSC3mLNEctu2otW8ylQi89ztVmmOlrTotSUDHIUNSh9q9sMIksCHDrEqlQhIiChiKjd6nDblUaYhJREHe1WxEF+z9HkY2TV2KPjAg6symB7Jgh/1AHts5gViHeC0INN0IaDO7H/hmu+Yr7gGL+2TGUXfCyUog/sYUSAqNaDwhZ4tyx8loUO+lozDpqezU0GIwzrlEIv21tM2wkvzz0weyouzASTI7z8hcG2qNq2FGeWeYf2kWHrQvLZmTp6bf7AFj/k/oxSJLkcywJ+22PPM1Wv3KDdr83LdCqSEuvCWYCBknJjQojXqX0Jn1ZhSXXYWOTeCd9SQHCkAyhWulLP3JlaHo/WzKumNZMU5Nv+QYvJ2BddLh1Qj+KtWW1DKFHO5KaohCiF5hmQlKk8fQKFUwlUePwtGMEm99kJrl27tZh7Or+8XA1p3HI09mJaD7DKO2uR7MNL0sZnYVAjwDOpu7Jw0tkxA6Zr1oxPY7he2d5OJzZzCkJ8b7l3y5/srbjhMtpFFwjDfmsj9wF6IBYx4rMWRMHFK7kSXwpmZutxrxk9cLKILn6cNLsjY8OhEqJ431lISHI+MadEak20G1t24orUbjPnhd0gQnn+uI8JCQ78zbKENrGjl8iJuOB8GWHUJFmuSF33Z3hn5ufFbCCfLZKbm7eKJpdii3l11C5ialQ/cGODA9mZixrt/uXaSdLbwdlF77L8Z4kE414l3mt5p8mtGMBSoqrjNRWRrEbVaTVD4JF6Cc3RRU1dUlbeTISOvKrW865M0K3dtMlkz1uUYrVtkukfVBqLrhCRWv8RG99LDlSCNhiudPirUtyYdsFGIpq/ps9CKVWCaISOnkGQryWd9L61Ufmm5JgmCLbPbndeCQ9e84RHcGjzJ1vV2TxY/AxHcvt+s3W4FNDieRwEb8Td51ajl8LF7wBSl390nqaK+TJNfYE8umAxluFQNilSQKg0dWL/Yaif9tJvplcfzNhzzwoMDcbXkuT3OeXLma8vlMkTDANCK37bTu8NMoa41wQgnLccbLsUfMXhX6JdMlEInmsNzJSNhKirIqIANAtg3z1wbeNch75EhUXGBHRBHa9mTaGKs/ZcVC8Bo8sJkBq44Rl1x2zO+AWQFTqWytUyxL1CerUqWqYazEaE4HGaFwMiZ0kMatekQco+IgwaLlbReqphIgNzLsxGQNlkzQj/JS5tPNgqgXxzZNDXF0miOiuafqSVv6zr6bIjvHy4ZMWjHPovJO7Nbb7h8nmf7MSUwIwYJKoZIhvcNAQkVMRYEFMd9npdIky+CS3TgvhpHnTd368YlMDEwITAJBgUrDgMCGgUABBRro5DGa59IlrXULFrdOHhNzodxlgQIkwMCwrTmrQECAggA' AS Pfx, '01' AS Motivo, 'C520877F-B4E5-4104-9A71-6D2FAA96F625' 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-0005950' UPDATE Comprobante_Digital SET Cd_Motivo = '01', Cd_Folio_Sustitucion = 'C520877F-B4E5-4104-9A71-6D2FAA96F625', Fecha_Ult_Modif = '2023-08-08 15:45:20', Oper_Ult_Modif = 'CONFIG' WHERE Cd_Tabla = 'FACTURA' AND Cd_Documento = '01-0005950' SELECT GetDate() as Fecha SELECT Fecha_Alta, Es_Cve_Estado, Cd_Timbre_UUID FROM Comprobante_Digital WHERE Cd_Tabla = 'FACTURA' AND Cd_Documento = '01-0005950' 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 '%%' OR Factura.Fc_Comentario LIKE '%%' OR Fc_Factura LIKE '%%' OR Vn_Descripcion LIKE '%%' ) /*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 = '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 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-0005950' 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-0005950' 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-0005950' 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-0005950' 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-0005950' SELECT TOP 1 Es_Cve_Estado FROM Venta WHERE Vn_Folio = '01-0005950' 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-0005950' SELECT * FROM Devolucion_Cliente WHERE Dc_Tabla = 'FACTURA' AND Dc_Documento = '01-0005950' 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-0005950' 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-0005950' SELECT Fc_Fecha AS Nombre FROM Factura WHERE Fc_Folio = '01-0005950' 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'