SELECT 'LTC970709SG1' AS RFCE, 'MERJ660314IW8' AS RFCR, 'E214B5E0-2555-79F5-3A57-869EFFAB2EF2' AS UUID, '300' AS Total, '-----BEGIN CERTIFICATE----- MIIGPzCCBCegAwIBAgIUMDAwMDEwMDAwMDA0MDc1NDY5MzQwDQYJKoZIhvcNAQEL BQAwggGyMTgwNgYDVQQDDC9BLkMuIGRlbCBTZXJ2aWNpbyBkZSBBZG1pbmlzdHJh Y2nDs24gVHJpYnV0YXJpYTEvMC0GA1UECgwmU2VydmljaW8gZGUgQWRtaW5pc3Ry YWNpw7NuIFRyaWJ1dGFyaWExODA2BgNVBAsML0FkbWluaXN0cmFjacOzbiBkZSBT ZWd1cmlkYWQgZGUgbGEgSW5mb3JtYWNpw7NuMR8wHQYJKoZIhvcNAQkBFhBhY29k c0BzYXQuZ29iLm14MSYwJAYDVQQJDB1Bdi4gSGlkYWxnbyA3NywgQ29sLiBHdWVy cmVybzEOMAwGA1UEEQwFMDYzMDAxCzAJBgNVBAYTAk1YMRkwFwYDVQQIDBBEaXN0 cml0byBGZWRlcmFsMRQwEgYDVQQHDAtDdWF1aHTDqW1vYzEVMBMGA1UELRMMU0FU OTcwNzAxTk4zMV0wWwYJKoZIhvcNAQkCDE5SZXNwb25zYWJsZTogQWRtaW5pc3Ry YWNpw7NuIENlbnRyYWwgZGUgU2VydmljaW9zIFRyaWJ1dGFyaW9zIGFsIENvbnRy aWJ1eWVudGUwHhcNMTcwOTE1MTYzMjQyWhcNMjEwOTE1MTYzMjQyWjCB3zErMCkG A1UEAxMiTExBTlRBUyBUT1JORUwgREVMIENBUklCRSBTQSBERSBDVjErMCkGA1UE KRMiTExBTlRBUyBUT1JORUwgREVMIENBUklCRSBTQSBERSBDVjErMCkGA1UEChMi TExBTlRBUyBUT1JORUwgREVMIENBUklCRSBTQSBERSBDVjElMCMGA1UELRMcTFRD OTcwNzA5U0cxIC8gUkVTUzYzMTExN1RONzEeMBwGA1UEBRMVIC8gUkVTUzYzMTEx N01DSFlUTjA0MQ8wDQYDVQQLEwZVTklEQUQwggEiMA0GCSqGSIb3DQEBAQUAA4IB DwAwggEKAoIBAQC86rL2RZAGTR3LHHKrexmqwccDPbBs2N9uGwly65oRTD4eCLwz 02LivhVW1hi77k2ePZ72x/RHPv7OufxF+vvAynrn0pAbBJMPUhHUT8OXqd4syUpf 0qWc0iN/lNn2w8AyqTzDMLdcquJ6ZGuj/1vWBf0wtCv2PXq+rmA0GYSkVJLN9XkN EN8eJcRozq++QTyqh4jE/5rosTyNMxOTOioEEwlHBZ3srjYk6VwxpMqu7NkfocAi 1eJwlcJCcdC4IPggMrQg4Hzq4QDHCdolSopDBOffQs7EI8WXybH+b6YlsnM0h2en njihZZ83ThJT39x0xKeFsEz4cwKPxDXgtOqLAgMBAAGjHTAbMAwGA1UdEwEB/wQC MAAwCwYDVR0PBAQDAgbAMA0GCSqGSIb3DQEBCwUAA4ICAQBmcCOUOY0UYBaSjNEt hutyb3R+bk/TFl4jqyRUiwwyyHKHhlr8Oee740hBFia1kBe8suqUovOTSQr4cvqi uAWiNFKmzU2R9tenoA0fqDrtdlXM4DFdjsFsx/qAwm/q8BpxZueABLWznvzrHtZq zYXCC6qdLPzmvGMVHZzRN97rcJDLOiXlN68DpEl+T2Dwz6JyPUndqDxySKqAWMj6 fXR46Ya+OxjDqoh534JlckCITB79CeMeXUhKb6hFlyelAzO77YYlXX/fb8AEMlf5 5QkPBpQ98EK5pKvjrGaQUw/xsWIEJdxvQqHy6wr5lS3Zw4HfWXUiDKmyiGB26Q6C yz9zaeLKMAjCGj+6LTm+NMaLw/Exi6UYsLteRpvQ+bUnAGR5axhi6uNovqSzvOGV H+zIhZMUwPf4dxTLQ7GfKfoflzZzQTO+mkPyVfY/lIlDoYnPHXVNLPuQC+5w4jYq 04NV7+9t6ru8IsSNF5miK7Ua9mwmIGiKf7MGtFeBZfaxgX8VVJYS66JBZXe+ypjc wPNbYpGOctBEj3bIBjjm8hl0MBvXBJWa4XI8KhvueH2pDp7UfZSltEsQKhHq7+kY XHvLEWdcLpCwQK+cvD6Oi+Iw/FC2Ux5OGZFc5PpfUQCRij/zCjkoAEnY90dIy8q3 F3JhbRAlbVk7QJl/dr7DLbRyrg== -----END CERTIFICATE-----' AS Cert, '-----BEGIN PRIVATE KEY----- MIIEvwIBADANBgkqhkiG9w0BAQEFAASCBKkwggSlAgEAAoIBAQC86rL2RZAGTR3L HHKrexmqwccDPbBs2N9uGwly65oRTD4eCLwz02LivhVW1hi77k2ePZ72x/RHPv7O ufxF+vvAynrn0pAbBJMPUhHUT8OXqd4syUpf0qWc0iN/lNn2w8AyqTzDMLdcquJ6 ZGuj/1vWBf0wtCv2PXq+rmA0GYSkVJLN9XkNEN8eJcRozq++QTyqh4jE/5rosTyN MxOTOioEEwlHBZ3srjYk6VwxpMqu7NkfocAi1eJwlcJCcdC4IPggMrQg4Hzq4QDH CdolSopDBOffQs7EI8WXybH+b6YlsnM0h2ennjihZZ83ThJT39x0xKeFsEz4cwKP xDXgtOqLAgMBAAECggEAD1gUvxH5V7mtwNCHs8vk0sy4aFf7W2vmAeBqTQ47zkne Bbx55M+3iWkc/JeZHLKHVWH15l9pRNwmAA51Ig33oroPb4LXt4oQk777ub3cyhW+ +O5EfzHxx6H9xiAF8BgIJVU/nS74xasPiBdd8s0L3X9RCEKqC28E6DXrlG+6KUqd VDfbmlQ+Y1Nsti76wAQKiY2UpW0PZ1GIm9BAdTZ8dVxSyoBLfim1OMx7YFDQLEqC DCRa5NBCJ8Bk/ZcLgjja/Pg+/DqNLqHcLNXaIOI9D8HrHwfOu7J8MwarNSQAWRwV FmPKPBHdZNfnvyVbl+Nn0zedRO3YIn1g0tUYsoXliQKBgQDztJfRGv8i6kv3c+q1 JxyjNxQCmoyopzq0myHJ/QGXV4B+FeMAx7MJIYjMWCo9yxsakLjKNrc9h27UNHvu vyyP5mbZo+fiba0KssLl8KxD5MQ/PdTdqVZG3w4C0QGa3eUda8IkcodpzBOW+U7E t+GISqPUrN0KtwVh26BeeFWytQKBgQDGcoWIrRAdFTl0xcYqDwBPgNDEZegDaCII 6i/cldbEaOpzZO1sTtAEit6zsE1Fax7q6r+lmT9x+sacld6+wWO7lGSA3iRAmBXE myEO6PM1xrZAm4R19j3MLNYf0iOSg15sOJfVIPs6bofqkPP3ON+cay1aQFD4qC2+ tCTTbywwPwKBgQCQ/d3hI62tyTWfKJD4bCeml2tJTUfoQ24y66UDtopOz1l8Kmtf GHDVOuVXphCjqQYcHQREEp+cdMokaIFffs/1YT/JtrGMTnJITiiUg0cKMb3sXk4Z /th829JLLKxGxkO86FKeOqGD+U2iYftSIJCG9NlZ++qaqF8EZJWZ/wAFjQKBgQCJ QpkeSiYFF7MgE9PXL30VgJHl5l6uTI6N//2O440jWTYhDsQxz+mN2sfjHaS0yT0f W7OnRPJfUgeiMv9Yjcb/7cn+YKhOjWMxE+OvvmzK22EgGvFp7iIcYT7Rz7WPF5Jt 5E8QublLVzxngE9exlXUiUVbUXUwKJNLfqqiHBlCXQKBgQDBuVuxp+e6o+zBqEsK 89VuMw+q5c+9uTRBUstR/LAL4+wUrt8YV5BY1PhibQqkzItdBI1rSs0sSk+DQFQ4 Zt5MGcomzATQ2+d9/8RhtlHiKxp9sxrMmQtDnveSEfBEZfJTbCpGOIeGokyg7hTO WFn/Cn0YWhN1IQy2XU4duhjvQA== -----END PRIVATE KEY-----' AS PrivateKey, 'MIIMgQIBAzCCDEcGCSqGSIb3DQEHAaCCDDgEggw0MIIMMDCCBucGCSqGSIb3DQEHBqCCBtgwggbUAgEAMIIGzQYJKoZIhvcNAQcBMBwGCiqGSIb3DQEMAQYwDgQIcetHbQepk2ECAggAgIIGoEKVjzHZ+9BAWnkxszcTjMGMPHcjlsYrWRHmxrWL37JrYAbgdg6qhJ8FhtPO84fcCe79yw/L+MqIb+Ky72HyWmPyG6Xu/fEtI029SxBZRewBThotJAKm0MJ23tUZjafqGzgJerbkcIHvgNvOLC7FMlJwtVr1dT9zFK8ixk9mXmVNZuj4h0pwnuLXymbT5acNK4EB10U3hlUGWXhX8huBTofEtuKl7o6ppD8caI6JiSoktYgOj8+7uMIngc8XdeNSYGU93FCeUdSmhllV/GRkaGmz99hx8V+uT/O09LFyGXxp7EX7IbGNbzBKf7x+fWyWLCZ0jdoMnZG4IRBdRYjWQ/J5wv9gAVAt42jBn6sn1huNg98g7Ud0ja2FcZSp0+XApHv8qEL8J0frYp1fPqkNPVE/cMEZhgu+ODiNjIH2jzqKmU1DjKFkxTvIk54+5O7UDL/Yoms0oMIOWQATWeix5/4UiQjOTwZbnu9DZE09Ygtq0Xz3dKQFD64b2tekTYnlTp6OqomH+2M8HWpB9BoN59Ja5ph15OrODtIC5HLalya0GbE3X4bP9kW4ztCkXaNmJopirKugBO20KnQUs8Cdoj9fzmrvAZbaXgSRg4t81Ah9UZaTjh1+hQrAxsZeaTKawYFn6Nj5YQEfRqjgvB9qNCMdD63E77a3I7YJXpp7xTcjFf7Oww3F9t/50AU9+V98u2t5sg3EDRIeAM9I1+Q30UchftOdaxs1yAb9qMzF36r5wl1+zdkf/hCbR729aGgZq1qtb0Xoj+8cD8A8GQUgS6/5C05Z+1QKWTXfI2vkFj4TfcRMVf8C0pdBQcDFDnZ76CBno4L/NDBOGKrD8vHKFScXk8N8e+xKYNQmq4s8a8kYRXDC/pGjoEudErgWpGmtbBgEkeGnzdfu0L1Z5xM+Hg2g4jPlduBS9raCC741cpXGSRFVYmpTIIpvJQy04D1oJExw/uTC5tuEyMOjfHWy1aRqdPfR0nlhLgU1OEy4jv5wRx46QbAIwJ0Fcjp+8tFphMmBUuNM6JpY/mgZqu2KkJZXLTo4XzWZgpBfwBgP3mZnn2I6lejsnBENMGB5Rzi6/ledJVZtIBKAH+LsCV0J1DI6KAtELYtf6+eX4fLb24YNmdPu/KKUDPXj3d0ovI7ktPCW+Kh7jaBH/iiptKlA0t457frV6srB2iI6kJ/9daUg/sIJHFMqXH09gJu2ge7YVzq4cJXEg5GobQXzZ8yEnkzqvdo64oW15Jp9FRdhYWDIxPx7OBVspZUvj+hJkRNXbZejoOeK5E9iBFiufbPd0pecYpceId7JLZA8ymSWz/1mEzCITTilRLT5XrHZs0D/2FtDjkWdRPHK+0JFCCk9PPrRFNSoSgGnf5aMiK4KsfwYUapS0ytEvWEM7wtiIa/JcZe/2bFkQuRoEf5GejllhCoEtNyxCV7FnDy2KH3ioC2i+H8qK8fn1b4KDxPQff3lDXwFvkP7NWr4gRtPIODbbhfpMudnve4sb71NGdBt/fuyxAvXJriXhdedKs2ss83VlDQmGmg8mo7pQScYySAOOcoMSZsTPTnbdBKlZhequSIeVJLVGHbFQ9yQEq6apl/wKyroL/epLgX+I2b/yDRsxuBYfsH9aw14L89q2Z9LrTM6R/4Z0/Vx7B5vUEwQRPJ2/qDddNjDmlVsRwTaQ7MvZAC6IYT2vLb0F2FSdGNs6dqGygtroJ4bL/q73V8fVMFcmC8h1nS8oedILpPkC2JIS9QW9HTwQEog0AP22RlYkb48azAgT5I+1Za5tRA/kWD5EYpnT9AL4jnfi9ox+C6A3NLOFeoq4yB99jzZ+sfgv64+m6AaQTqZAA97f2v7VOZWoCXB9/D3V0mQIs2uQbiow+rHB6JkXs+w2sCiwld9oYYhHq1SOg+vuuG7pxki21fzOaLWdCz90/N4ChRwhasaNqIv/CDFOz3SvsEphLgKbVl96PR7QEAza3P1ejiqg858TUv3ZWbaD0MwEWwX/unyXakTyg0ret23EKjGGh/42u9yEHXSAlSsoS0bA5oITKblBP40ck9UFm5CLIfeL3qBar6Tm8Jys36MEapGFO885GXt2f/PNk91TvFh+WUncHBdatW3dyJ4bpN0UqSJAdgyhOL9tbSdrA/ISCcACjBt4MpQnNfqEpKiqgCTZMKWEbersJXrbY9PhZY5y34VZJmVRhqnTygqvcQXkZjLVztwpKnaS3obfbCcgCKg2t8RsEh3JvXm6hnEZXmwLQBAt5ZZONkwggVBBgkqhkiG9w0BBwGgggUyBIIFLjCCBSowggUmBgsqhkiG9w0BDAoBAqCCBO4wggTqMBwGCiqGSIb3DQEMAQMwDgQI9jZq5IvbIYUCAggABIIEyL3GZwmak1MOYpxtL9KhZQorj9EtHP5L2ekzZB5wJwfNps7sDPQk0gBuIJHLiF111di7ITivIdUtjBhUwate7hxtELwIRTdvcqj1yBTObDwMNKw8ZeqWruYh7vgTZOixzOsjm7ElNZvo0m/4k4aUoLiQ6ToR+qfk1vojIl/ffBk+i06mWSB1OXKvqEIeHiK9FMf1X3HtO8uPc1MVc3fuyfhlaOg2zqUY3DEhBzipUZkryVXReT4TH5Ts++ernLuxNtSXvWQAQUvCTbHdp++9NZXWbPdvzPy8XBFcxiMfrZdoyeJJWtCaHumuwL60mNzE6X6UNsUyKmn2vywYAvxbXFzjdRLDusretfkJiKfhVSDOC8Ai+2eUXrRo5C65DnP7Lz5oWKYM0GR+PmMQEAHOl0PjA4jwwmnymVV27LiUoRK0oQsqhHdqUmYQOXIeKghYoDOWM27yR8uxSdNcqVBwK1LaHPLjv02ymZJtsxEF9q41QQn9Oxahfp8z6XC6beQaUMByRp9qkHKQrGdzrBJDs1nqtOzBVbHF6OnRvY0SvoXpyDRJ9QPkDWrTc/kiyUOe+cw0HxbWFFp+Qye2CfZObLUgUqJBa7yuNxz7lH94go2iMSf19sgC6Shq+cukn9madUfNDsfdb0MNl+STSEhqr6R7Bnytd1bC3QRTJD6MioeEoG9/LP7RWW1f5CdXYHZOVvYYNO8cErrzLLf4qcX5DnkiHayRINAr+F0Pe/K23U7BWiLaCgsHE6FtvMFVcUAHZNryIgav3DskHFalWcAiX3HPJMCiIAGH4wcOq55Y1DZx38nhyCoH04DW+jhSj5wKLytyxWRy4W8YggvTXXetlH8XGXSO2tsU0zniryDR63l+wn8eyIlA2D3/+A4gtGcF6mMuZ324/nX/01566/MdKyhsDBDcFHB0w8mZBfrOo18t0U8yZgiI+s4f2X3AH3qfGExu4QzZ/su4hXqX5mxxFfQLOJ0u7UQ3EvY80PHUenQZM5d/1f2rmZfihDi9EjtcqcqcurQFbGnZJD3whu6uX6eua9t8aArZ2XsSOdQneFeFKrtUolnwHM9bnjuZWYmfh12je5oTpXwXTsSJWsxK0itSlr9w3S4Bz4nI2ssWcokfoxHXZuKJIp/VHL/hjuXjy68BB4gB5c/q88/ygdsa4iotFXASzV7L3cOSiqHefmKeAzKsX2L6wuTV9xCpZwzLYn8aYqix+BLjEsbd06oEtptSc8NjtV6IjihSU75VFRdVK2SfPo5mAsSMsmdq63wtSoFQw116GGGP47DJ3OswE3G8V49ENn+ekejtjzjillVlnZ06ZDj5F/YeK41fUtTbOelmU1/0POmI0Cqdqn4xw+yuBLdB+PvTaw1m3wqh9DpAtRqPvicaaOv+/v6MgeflFIAJMjYPGiYxaFsEt1sfxI52dMVezBAPyN6rBSOtWyNedozk7ZqWB5wZGvNDQrV7n3/SU7TREMVukl16A63UiIM4MVFSpCcRKyu9hDnA53ozgT1hheaGpdtnSoXhrOshdT1zRUEF3rftRlsIQCHF3jCfKSLD3qCXN9VMfEkEuHJT9CARsVzXzGJtfNzc38ovkcHg7F8u4Pwk3IWvh6vKEM9qf2Crxr/MXDElMCMGCSqGSIb3DQEJFTEWBBTqOueX2z5O77qQ5qUF3fKp30m6UjAxMCEwCQYFKw4DAhoFAAQUFJjpqj3T7JrcFP2oEpbgopG5cuIECO4O9Bk2xryjAgIIAA==' AS Pfx 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_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-0014832' SELECT TOP 1 Es_Cve_Estado FROM Venta WHERE Vn_Folio = '01-0014835' SELECT Factura.Es_Cve_Estado AS STDoc, Comprobante_Digital.Es_Cve_Estado AS STComp, Factura.Fc_Tabla as Tabla, Factura.Fc_Documento as Documento FROM Factura_Encabezado Factura INNER JOIN Comprobante_Digital ON Cd_Tabla = 'FACTURA' AND Cd_Documento = Factura.Fc_Folio WHERE Factura.Fc_Folio = '01-0014832' 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 = 'A' 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-0014832', 'BAJA', 'FA001', GETDATE(), 'CONFIG') DELETE FROM Transaccion_Documento_Log WHERE Tdl_Tabla= 'Factura' AND Tdl_Documento = '01-0014832' AND Tdl_Tipo = 'BAJA' AND Tdl_Transaccion = 'FA001' SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND Perfil = '001' AND Menu = 'FA001' AND Restriccion = 'COMBAJA' SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'COMBAJA' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'VEN_COMENTARIO_CANCELACION' SELECT TOP 1 Tdl_Tabla, Tdl_Fecha, Tdl_Transaccion FROM Transaccion_Documento_Log WHERE Tdl_Tipo = 'ALTA' AND Tdl_Tabla = 'Factura' AND Transaccion_Documento_Log.Tdl_Documento = '01-0014832' ORDER BY Transaccion_Documento_Log.Tdl_Fecha DESC SELECT NULL FROM sysobjects WHERE sysobjects.Name = 'Transaccion_Documento_Log' AND type = 'U' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_MODO_VALIDA_BAJA' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_VALIDAR_PERIODO_OPERATIVO' SELECT COUNT( DISTINCT Pd_Cve_Plantilla_Documento) as Docs FROM Plantilla_Documento WHERE Pd_Cve_Plantilla_Documento IN (SELECT Pd_Cve_Plantilla_Documento FROM Plantilla_Documento_Transaccion WHERE Pdt_Transaccion = 'FA001') SELECT Ct_Cve_Categoria AS Nombre FROM Producto WHERE Pr_Cve_Producto = '0000000526' SELECT Cd_Documento AS Nombre FROM Comprobante_Digital WHERE Cd_Tabla = 'Factura' AND Cd_Documento = '01-0014832' SELECT Fs_Tipo FROM Factura_Serie WHERE Fs_Cve_Factura_Serie = 'A' AND Fs_Tipo IN ('01', '03','04') AND Es_Cve_Estado <> 'BA' SELECT Py_Descripcion AS Nombre FROM Proyecto WHERE Py_Cve_Proyecto = '' SELECT Py_Cve_Proyecto as Proyecto FROM Documento_Proyecto WHERE Dp_Tabla = 'Factura' AND Dp_Documento = '01-0014832' AND Dp_ID = '0001' SELECT Pr_Tipo_Producto AS Nombre FROM Producto WHERE Pr_Cve_Producto = '0000000526' SELECT * FROM Documento_Descripcion_Extendida WHERE Dd_Tabla='Factura' AND Dd_Documento = '01-0014832' AND Dd_Documento_ID = '0001' ORDER BY Dd_Documento_ID, Dd_ID SELECT Cl_Descripcion AS Nombre FROM Color WHERE Cl_Cve_Color = '00' SELECT Tl_Descripcion AS Nombre FROM Talla WHERE Tl_Cve_Talla = '00'