SELECT 'MOT970130AL3' AS RFCE, 'XAXX010101000' AS RFCR, 'CB483E8C-1664-4E9B-BEAD-D7B5C29B8DAD' AS UUID, '32300' AS Total, '-----BEGIN CERTIFICATE----- MIIGGjCCBAKgAwIBAgIUMDAwMDEwMDAwMDA0MTA2Mzk2MjAwDQYJKoZIhvcNAQEL BQAwggGyMTgwNgYDVQQDDC9BLkMuIGRlbCBTZXJ2aWNpbyBkZSBBZG1pbmlzdHJh Y2nDs24gVHJpYnV0YXJpYTEvMC0GA1UECgwmU2VydmljaW8gZGUgQWRtaW5pc3Ry YWNpw7NuIFRyaWJ1dGFyaWExODA2BgNVBAsML0FkbWluaXN0cmFjacOzbiBkZSBT ZWd1cmlkYWQgZGUgbGEgSW5mb3JtYWNpw7NuMR8wHQYJKoZIhvcNAQkBFhBhY29k c0BzYXQuZ29iLm14MSYwJAYDVQQJDB1Bdi4gSGlkYWxnbyA3NywgQ29sLiBHdWVy cmVybzEOMAwGA1UEEQwFMDYzMDAxCzAJBgNVBAYTAk1YMRkwFwYDVQQIDBBEaXN0 cml0byBGZWRlcmFsMRQwEgYDVQQHDAtDdWF1aHTDqW1vYzEVMBMGA1UELRMMU0FU OTcwNzAxTk4zMV0wWwYJKoZIhvcNAQkCDE5SZXNwb25zYWJsZTogQWRtaW5pc3Ry YWNpw7NuIENlbnRyYWwgZGUgU2VydmljaW9zIFRyaWJ1dGFyaW9zIGFsIENvbnRy aWJ1eWVudGUwHhcNMTgwNTAyMTQxODEyWhcNMjIwNTAyMTQxODEyWjCBujEdMBsG A1UEAxMUTU9UT1NVUkVTVEUgU0EgREUgQ1YxHTAbBgNVBCkTFE1PVE9TVVJFU1RF IFNBIERFIENWMR0wGwYDVQQKExRNT1RPU1VSRVNURSBTQSBERSBDVjElMCMGA1UE LRMcTU9UOTcwMTMwQUwzIC8gQ0VSTDY5MDYwNEhVMDEeMBwGA1UEBRMVIC8gQ0VS TDY5MDYwNEhZTk5WUzAxMRQwEgYDVQQLEwtNT1RPU1VSRVNURTCCASIwDQYJKoZI hvcNAQEBBQADggEPADCCAQoCggEBAIQtyLGticqPUyasGFEZp2o2lg7iU6+vq3MC BNCIzf6/iCQ3YiMu35WUyOxvwXcD1mxb6ofXzcA5608NMK4XWuOr1EOJFUSSTOjc yQzY29o64OigZYXaALELOAfOehbBLA1ecWsPPDHHpRis/VCSv5EV8fI/9Ueb8tb7 3ZFwbgAwTH5jZOxHN3Y83/UU4qVI78vv856lBGXE4O7EZYJ+wi5iLN6n32lJCpdM A5ubEP+GpKWbycS+EtscaJJynnzuYo5u5Osmw1ByDES37IaEjpj0UDyDG010QwJ8 nskB4SGeb/Rfe+0KsiYTe6gHC4uz4HUXPBGFmCZ5u13KxKDvk5MCAwEAAaMdMBsw DAYDVR0TAQH/BAIwADALBgNVHQ8EBAMCBsAwDQYJKoZIhvcNAQELBQADggIBAIwL elfhH2NPgIrUjxVdSjCRYBBjPMT6rV7Up5vNkrSOvRa99DTFeibRuHUPFYvds5Wh S42xiLx44oX9xTZhOgn7Tad9jWqhdLAu0aM6BixqNcAbQsDNMycseVg5chhLjTpa f2uXLb0ZyR3uTi5RGYUBmjGpHkLCKES0MXxGAiRQfbch2Kd7cDHlAqbPY975+UcL uYLOoIDLpVQ+StS2FiqrjkPDzyyKkEibsNl33mHFwDzwukcUhm3QZZCqdHWshH6O +9iGoy1VrXwkwhchHqu20+J5vqqTnifRfbzWu9N21Wp9fHreyab2F3phpaso/BMo SLRBkTP5V7DAuIz0psT9JhLvhMYW75VKG1GDeMkb7tjXP0C6lSPgfX1GUCsqKAe+ tmI4mjiY/nHJhurheCa/mH0VP9XJPdgdH8Cx1epGxlNgOjFQOMB4otY4XNRAj4Sa 4X9/CszLtfE84KrI3nIHwgry9HpuLObHUiKcs1Az6Z1UuR76FeIdKVTfv+EKBJkm UWjbj3wHm4Ku09Scutazt/ES/Ne5V1KeaorRFQF6cTuwyJRacckVNHflRn7kem1l jk4bNs41JV2Z8LfkORQcHLj2Sl9mVYajvX7hPNvJda0TTsJ0VK/lcfzKEtCCdPW3 UW2xLqJmiCOY6oz+cdXDcdo6heX6vDov4Urjyzm5 -----END CERTIFICATE-----' AS Cert, '-----BEGIN PRIVATE KEY----- MIIEvQIBADANBgkqhkiG9w0BAQEFAASCBKcwggSjAgEAAoIBAQCELcixrYnKj1Mm rBhRGadqNpYO4lOvr6tzAgTQiM3+v4gkN2IjLt+VlMjsb8F3A9ZsW+qH183AOetP DTCuF1rjq9RDiRVEkkzo3MkM2NvaOuDooGWF2gCxCzgHznoWwSwNXnFrDzwxx6UY rP1Qkr+RFfHyP/VHm/LW+92RcG4AMEx+Y2TsRzd2PN/1FOKlSO/L7/OepQRlxODu xGWCfsIuYizep99pSQqXTAObmxD/hqSlm8nEvhLbHGiScp587mKObuTrJsNQcgxE t+yGhI6Y9FA8gxtNdEMCfJ7JAeEhnm/0X3vtCrImE3uoBwuLs+B1FzwRhZgmebtd ysSg75OTAgMBAAECggEATXev6kK1QVyi9UVjsxSABEYdyHdpaMxihbMnMzka0jVb Cy7Se6BbNgXPhJMzJhe/sh5k5Fzcn87SVLB8WWwivtDURQiwyFGeddQAmWD36X0c l/p5xesxAJJ8skaXU4K/2M4DVyXEt8A0yLOKe5Cmadgcx0go72E9ADb5cuYb8kuE Wab+7TzM0qDdHTWnwlZGHv5Sx4ip2WK/+gQfMquRu9GqJ9b3LIH4+WtRDwAncYeI 5MBcgh8MFiwwpyZRgCTmnpJX9u4S85txzRMZbUZiTDRCJl67bFQaDW6DavFbCTDN j3QzWoT1gsJQ82vBk7hJa8WfLtxclFKnKri0d6nxwQKBgQDEEUtVRt+sX5i8HNYl BwZhqOloqdaNhde0oFyT4McqBbt1NqM8yhr3M4kjNOpjspA4gAzyfJ3pXg4L7pPM 5HBp6G4Y0Nme6Ay2ePBkpEdlKptBB22CSrk8NR6gtGQfyxOM+ONOYCM0H3nskrke ApaC/OjTrtZodL2SjyaG7jFOgwKBgQCslQ+vpJRwGWp2otBZgtBGd4+CNnyHoUkS ya3wboZ/b5wv3koycPHC9hucOugjuak9Xs0mT6/G0A8uzZmGmUoIdhAAyYWpYBNL NWmeWvtokhhJiN64VCp2MI0HJgGtD0g7ekRY2rVmAdsGGA8Y+yp5XlPl9oCP6wFU 2m0Pj6SZsQKBgQC6S/B3i8s13vOiMggr0Jv4qWV2ZIIPoNAPuZudiyPSwvWWbx71 wNeUcSxp/nqD1oQAm3Mx6MSmnA7euYdIVPqXNxl9jNxqh/SkYQ+RoSKRdsVkKamc 9mFBWvvKGP1V1EC0XzykGOb6PLo91j/8ytq2hZa4pFTnlZ0XJ9uks6i3/wKBgDWB 1aYwUbFbv+1eV1iZPTfL09ucRwnKEJzZmKslqV+TXApfUgPHjr1SjobmoJiK9JTJ crOBG095rGtnZUUc+54Z9KY51M4JspGr0r49GRt3yD3sSJk/xxZzwRXJS9W7GjsO kmg2Du28f4qpJO0q2iVdAIgY4A0+4F/NhOjBMVhRAoGAeucFuZwyWNUCxI5sgXM3 wqFmkGUjkj8aRGDNVD/XBJB5VbBNrMydqsf3FlJns1Ab4GmVaFjiKB6fubBoFUwd ItmtO+/fH890l85gWGvwL3W0u0fSvEsZk5xmjOH2ZAgGbgQNGd9XKGPrKQUzB+KU ExBK6EoRO7Pg8V0pDcKViHM= -----END PRIVATE KEY-----' AS PrivateKey, 'MIIMWQIBAzCCDB8GCSqGSIb3DQEHAaCCDBAEggwMMIIMCDCCBr8GCSqGSIb3DQEHBqCCBrAwggasAgEAMIIGpQYJKoZIhvcNAQcBMBwGCiqGSIb3DQEMAQYwDgQIVVSww6KIbFgCAggAgIIGeIIVJboDXGyvpGqqA8F8Mg2LAG52mGEOtSDHW/DMcLux/Xb06gXtLXNv0jaRTGe4KOIdGThe3LWzxsP36o6+TJracGkCeIBuvtarDotkHhfMqOm8JeYGYUP611xaHEZnmHJ9e+WrC180OaJ/7RxitGlEjzhuhFHubsklEqTm3WHEnNqyB+pR6jMvChXOplR5LRBxtTpoAI79hSvPay+6e4I+PqHyDjkxvQsFq3TJ32KZRI/Pj7cY8oW+bP3pE9TU75G57c3Kvgl08S2WgfkPe0wBF/CT25ZtOcM4+328fNRurXAYQFefi+OjXXkjg8mb/4uWFizfR4WtPblawYmwiI/iLuw0HfwrFhBztprQeBiCTgAPUTq3lycknoeML9ZOPg7K6RzhSsCzG9TnZJyJUazbpjg8tQkUCB8PM9AT74L8EB6SxIIJMAIRri5+bnd9+b9LrHNgQiuNHC1UFeWRi3v7U5QbOnvDG347BH41WR4Ozp7ss/WwpyFUSKhy+OuedP1ETJHSFXn7FyecHDsef4z0sh4jOOkG4lAGUR6ySo69PtELTzkOxCqCz0tKZDABGf2xdVLPvxHK+h/s1bescHtg33TAkoFroUyTsKxSvgSthhV8BUUWKTmA6VFvJY39FvoA17WUH6/c7zQxT5PT2B75L4Cnz7xEEOYgI6zMvk4H3KbFzx2culd1lU9l7TKmtKU0Trh1vrPoonh9a2zN2Z9Bj9O9gqSiK0W8+xrR3wWex1xA88uvau7iMT9kdFq+VnDYEDfCN4Gtf+8psINlMwpGOwdiNeRwvCFGuUh/C4d+qi2AeCccQIOcqolNB4jXYMHzANjxlwX4FEUrDb/qtdD9aj+6b07+UteiQ/A++INJ8LIonzIk9vPsP1OPF7df0WFL2URpFJBMpLcbr5vA3nV4pxvk5eDPEUj7pJ9027CUE5NiICizetYKKf2zl34LmxIwuPSaQuAy8rcNC19NPIphlY9o67naPtK/NA7rmbxN22zSsNXiPzAP0k5g8wlnjpIy10UqpMNifZuCLhSNluqOP7hWP7QGV3GvCilZ/Q5pqjpwogCJJg3LY0nfcedfZfNesQuTg5mL6moOVkkbICYOtbtj7aoFIu8cGBqyXrCtBv9FZdQQ7ew+yyDmFgypQCBwF7bD68xtJBVjYa7147Og/IJdKWYUpA7JtP+Z2wOYKMMAxqFulFegL5SWbVI6N2ZkZ7KcGJ7Wq1b3PVo2xcI/45LvGEsguqbs4meK7Knc8JvGJouKJD11WYuj9unZ/d0MLSt0B/cnozqWBMuKlsO9xC8e2aOlMiFwDUjpY3xNh4Eq57BuKxoxqOwbmSbjtWGuzXu56WCr5UBTVgtYPI3lVXNArgRq+Xq9kGcmWVGokZGq9X9QjJEqEFx8r2UmJOz9bcKwI6+tGNMlX32hkxMW52T6CIjV5Wdyle/H22QJVTG5hLIGNmLkCMIcsu7Se7bler883Up1rGiyBRV7KqRIWFfRe99lDmAz9db8YOfZK0RvxomtKrYWRnZEgC/AJ59AdaV1/viXL9J+3i2P8WFttTVdYygCjDVTgBtfVHqXoXoxHQGpdlBEFJlP6yVUV16QSrDNZF8vF+7kF9Fh7FXVA5cMDeFUs7K3xivdGxKygBr736ZPGUq5GF8QIKCHK4eLAr3Uqc81qzSRIhSLcoANETyR2UdPME+igHjnJakt+RpKIVttlrGt6sEgZPUjjdw4B/3brJ6eawF/JS7twd4MEqdBZKXPazzO307Sx1u2899pB9bGmwyR+h5el/Ttio317D9JsJDFCTiu12T6Ce9wyECtqUFj0S0IO67VEw87NkNikAPmCGtScwvOTSPOlPKmkXFHx43S7x75CfCuJOuM142PFLUbearmdqQlBI8c9JUND+V4otfoU2P4quI0Ix3armdA4MvWkqjAkCcsSpkvPik2m6mKJAv6p7/gkNCbCB0O9rwTBcOFTAXlllo3Kew4EMI46UyglMa/t5PHlFmwISDi3hfMfX8/D0tAH76fWsAjmyeFzkogWX06rcYsI5Re6J7VwO9x1eBQhz953FE8VaB70+jaNH9Z589C5W+q7kccU0aa4bxW44rizq1+aYY5CQmVXN+MYs39v06XoD8Vxs6VaoN3qJV0gQEg30wEs9rbllC6k7HWMe9MX0ktPJOvNTEVw7GMFPbO9UP2yiyAaNGK7WmmGjCCBUEGCSqGSIb3DQEHAaCCBTIEggUuMIIFKjCCBSYGCyqGSIb3DQEMCgECoIIE7jCCBOowHAYKKoZIhvcNAQwBAzAOBAiQcu7dNhfPQAICCAAEggTIt6mmHz39q9B42mxAvfyFCo+K57n3ndgoEW0DNPnQYlZtP3VnnaYNwcMVF8I+dWfQa7ySTuvIYsmVwtSSXDnaHSTWmXjTanoD4ADXNHy8fPbnvVAQB9rFHKv0tWWJ2puGRJsBPP/58CjZdRqoWUeM9R+hAFPkR/HvRZRUh299OVxlCTzz2V8NXJRRdEYIj1214NQdIqPs4/OUlGUe4etgG+wcAth6HoAN38sCjSNhQV0Pb5uXWtEBXRZf5j6UMvA97lBoLUitEjGREu4GqO86ny5sPXN0k9xLak7ncVEsH2ndyaIKUNL13e9AuIyHSIRVsqoHW+v5TuyOyg9u9eWWg5RKWrkQU4v6o7g7YUZRrX6NgsnaK+NJHb4gBxGMNJYWhl7PBFPfwrsn0iSndoW1OVeAZ+KdNxLruudsLd3Z+7CULhMAWNVCHGZAWBtVtsXrS4zuFrnabJZCRA5/HFZJ6WJBDNDTSvKiRTUSsV9qNpOnPww6VxsUYialW8kQO6NbjeyqgOEx9nI7O24hF6lp1u0AJLLbpa5nGwgqvPtAs/syMf5vZ9mL0/b5p8ZDad9765Bpwz5Az7J0nKLOn58SK48q6siQ3lctKSeEfkPJQTZYm8l0DIT+OqaGPn5ZEOW8S85t+qR8IRi32LPQpXzKn6O3+//fEplmsCSNGfxFJFT28nXXenQ/YfY6EPy2cA/lrVKL8qQC0pfWSbSUw/0RCuU2pZ3cHD9gVqWBbSk7FrbmgGXSb2oUI2bPdh4m7/tItpuK1ZzYGibEV6JxcYxz43JQ2hrSEDwD6UoxK6xwYHDiZA7pgSmH3ps2yVsnwVaKHhyf9Qx7/+2thN3A4chYxRHgWPZqkMUie8XUdqThbWdX13voANnRQDm2L682px7KwZGdg19yCamEX4IGqqW3ULeF5Ew9O+y5pcB91Ug8TWFoqZ7tGLdc0wxmXB4Kfedn42CzsEO6CJz5hwLx5f/D/GOCLCyYQP3Pt70VynkO/j+rncNEP1QcJxXU3Mxz+z7j1ypxMndr+1C9NuLgRty1AMiIraVNUid6c78Cf+u5N86Go5pMsnbCkyxRPCyXdrHAaqpMkdNMsqHdj5CjwcmDTinRlevn6ZOu8ImKAHnfxIRFQlLP/aTLHUf951hn2dXlo2lAsAm95s4AjPsVjH1556lJbiUn2COivKvu3VeDDOk7L6rfUVvAGBdEOhQ5hSe5mFgGEU4MohXEUXAs2YrA+rhjbmZd/xM6pAyul4WjgTNqCjjQ5MQcL4qJERZ+7zZD8ymKn0r7YODWfknhhpzmKh7Bio3JwdZsL6k7I0hytB9Y67sOEgwJgremQCB9TTyAYpamHSOg6YSSA/2zfwK4MM+wpRsM2uXWyFA72088TDQr1iP4u038UTu3BOEPH/w7nU+dzPQHR/KHpqR5k7RSOQvbp341V7kf1UTrX1siZswDu8sUhiEY1G5PbgXiUnfGAi+O3tHLCmZGTPVR+xIiVdD4TyqXM8PraRs8/mPxLwt9PuD1Wf6O6fhNe6KLYO+2iyFw4eHPNeuzgnm5iTW/vOCB9AzFaWC/6lRJXludn9Y8kOKGV8no7ZQX98gpELePY4Yp46W/Gjkss9Ki5QRn4KgEfLIsUE9mMSUwIwYJKoZIhvcNAQkVMRYEFOjVuwcvlwGOGmUBghs2Sp87BJFPMDEwITAJBgUrDgMCGgUABBTZZdgkUaGXd+XgpCMIyHnVgQwkdQQIxUHNeoqTqFACAggA' 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 Nota_Credito.Nc_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 Nota_Credito INNER JOIN Factura_Serie Factura_Serie ON Nota_Credito.Nc_Serie = Factura_Serie.Fs_Cve_Factura_Serie INNER JOIN Comprobante_Digital ON Cd_Tabla = 'NOTA_CREDITO' AND Cd_Documento = Nota_Credito.Nc_Folio WHERE Nota_Credito.Nc_Folio = '04-0000957' SELECT Nota_Credito.Es_Cve_Estado AS STDoc, ISNULL(Comprobante_Digital.Es_Cve_Estado,'NE') AS STComp, Nota_Credito.Nc_Tabla as Tabla, Nota_Credito.Nc_Documento as Documento FROM Nota_Credito LEFT JOIN Comprobante_Digital ON Cd_Tabla = 'NOTA_CREDITO' AND Cd_Documento = Nota_Credito.Nc_Folio WHERE Nota_Credito.Nc_Folio = '04-0000957' 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 = 'ND' AND Fs_Tipo IN ('02', '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', 'Nota_Credito', '04-0000957', 'BAJA', 'NC003', GETDATE(), 'JREJON') DELETE FROM Transaccion_Documento_Log WHERE Tdl_Tabla= 'Nota_Credito' AND Tdl_Documento = '04-0000957' AND Tdl_Tipo = 'BAJA' AND Tdl_Transaccion = 'NC003' SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND Perfil = '001' AND Menu = 'NC003' 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 = 'Nota_Credito' AND Transaccion_Documento_Log.Tdl_Documento = '04-0000957' 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 Cd_Documento AS Nombre FROM Comprobante_Digital WHERE Cd_Tabla = 'NOTA_CREDITO' AND Cd_Documento = '04-0000957' SELECT Fs_Tipo FROM Factura_Serie WHERE Fs_Cve_Factura_Serie = 'ND' AND Fs_Tipo IN ('02', '03','04') AND Es_Cve_Estado <> 'BA' SELECT * FROM Periodo_Operativo WHERE '2019-12-05' BETWEEN Pr_Fecha_Inicial AND Pr_Fecha_Final and Pr_Tipo = '00' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_VALIDAR_PERIODO_OPERATIVO' SELECT GetDate() as Fecha SELECT Mn_Descripcion FROM Moneda WHERE Mn_Cve_Moneda = 'MXN' SELECT Vn_Descripcion FROM Vendedor WHERE Vn_Cve_Vendedor = '0000000112' SELECT CASE De_Direccion_1 WHEN '' THEN De_Calle + ' ' + De_Numero_Interior + ' ' + De_Numero_Exterior +' '+ De_Cruzamiento_1 +' ' + De_Cruzamiento_2 ELSE De_Direccion_1 END AS Domicilio FROM Direccion_Entrega WHERE De_Tabla = 'CLIENTE' AND De_Documento = '0000011288' AND De_ID = '0001' SELECT Rt_Descripcion AS Nombre FROM Ruta WHERE Rt_Cve_Ruta = '0000' AND Es_Cve_Estado <> 'BA' SELECT Sg_Descripcion AS Nombre FROM Segmento WHERE Sg_Cve_Segmento = '0000' AND Es_Cve_Estado <> 'BA' SELECT * FROM Cliente WHERE Cl_Cve_Cliente = '0000011288' SELECT De_ID AS DIR_ENTREGA FROM Entrega_Documento WHERE Entrega_Documento.Ed_Tabla = 'NOTA_CREDITO' AND Entrega_Documento.Ed_Documento = '04-0000957' AND Entrega_Documento.De_Tabla = 'Cliente' AND Entrega_Documento.De_Documento = '0000011288'