SELECT 'RECHAZADO' as Texto SELECT 'http://timbrado.soferp.com/WSTimbrarCFD/Timbrado.asmx' AS svrUrl SELECT '' AS XML SELECT St_ID, St_Servidor, St_Url, St_Url_33, St_Soap_Envio, St_Soap_Envio_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 Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_URL' SELECT Ccp_Folio, Ccpf_Id, Ccpf_Parte_Transporte AS ParteTransporte FROM Complemento_Carta_Porte_Figura WHERE Ccp_Folio = '14-0000636' AND Ccpf_Id = 0001 AND Ccpf_Tipo_Figura in ('02','03') SELECT * FROM Complemento_Fiscal_Nodo WHERE Cfn_Padre = '0020' AND Cf_Cve_Complemento_Fiscal = 'CP20' ORDER BY Cfn_ID ASC SELECT * FROM Complemento_Fiscal_Nodo_Campo WHERE Cf_Cve_Complemento_Fiscal = 'CP20' AND Cfn_ID = '0020' ORDER BY Cfnc_ID ASC SELECT Ccp_Folio, Ccpf_Id, Ccpf_Tipo_Figura AS TipoFigura, Ccpf_RFC as RFCFigura, Ccpf_Num_Licencia AS NumLicencia, Ccpf_Nombre as NombreFigura, Ccpf_Num_Reg_Id_Trib as NumRegIdTribFigura, ISNULL(Pais.Ps_Iso_3166_1_Alpha_3, Ccpf_Residencia_Fiscal) AS ResidenciaFiscalFigura FROM Complemento_Carta_Porte_Figura LEFT JOIN Pais ON Pais.Ps_Cve_Pais = Complemento_Carta_Porte_Figura.Ccpf_Residencia_Fiscal WHERE Ccp_Folio = '14-0000636' SELECT * FROM Complemento_Fiscal_Nodo WHERE Cfn_Padre = '0019' AND Cf_Cve_Complemento_Fiscal = 'CP20' ORDER BY Cfn_ID ASC SELECT * FROM Complemento_Fiscal_Nodo_Campo WHERE Cf_Cve_Complemento_Fiscal = 'CP20' AND Cfn_ID = '0019' ORDER BY Cfnc_ID ASC SELECT '' WHERE 1 = 0 SELECT '' WHERE 1 = 0 SELECT '' WHERE 1 = 0 SELECT ccpar.ccp_Folio, ccpar.cpar_subtipo_remolque AS SubTipoRem, ccpar.cpar_placa AS Placa FROM Complemento_Carta_Porte_Autotransporte_R ccpar WHERE ccpar.Ccp_Folio='14-0000636' SELECT * FROM Complemento_Fiscal_Nodo WHERE Cfn_Padre = '0013' AND Cf_Cve_Complemento_Fiscal = 'CP20' ORDER BY Cfn_ID ASC SELECT * FROM Complemento_Fiscal_Nodo_Campo WHERE Cf_Cve_Complemento_Fiscal = 'CP20' AND Cfn_ID = '0013' ORDER BY Cfnc_ID ASC SELECT ccpa.Ccpa_Aseguradora_RC AS AseguraRespCivil, ccpa.Ccpa_Poliza_RC AS PolizaRespCivil, ccpa.Ccpa_Aseguradora_MA AS AseguraMedAmbiente, ccpa.Ccpa_Poliza_MA AS PolizaMedAmbiente, ccpa.Ccpa_Aseguradora_C AS AseguraCarga, ccpa.Ccpa_Poliza_C AS PolizaCarga, ccpa.Ccpa_prima_seguro AS PrimaSeguro FROM Complemento_Carta_Porte_Autotransporte ccpa WHERE ccpa.Ccp_Folio = '14-0000636' SELECT * FROM Complemento_Fiscal_Nodo WHERE Cfn_Padre = '0012' AND Cf_Cve_Complemento_Fiscal = 'CP20' ORDER BY Cfn_ID ASC SELECT * FROM Complemento_Fiscal_Nodo_Campo WHERE Cf_Cve_Complemento_Fiscal = 'CP20' AND Cfn_ID = '0012' ORDER BY Cfnc_ID ASC SELECT ccpa.Ccpa_Config_Vehicular AS ConfigVehicular, ccpa.Ccpa_Placa_VM AS PlacaVM, ccpa.Ccpa_Anio_Modelo AS AnioModeloVM FROM Complemento_Carta_Porte_Autotransporte ccpa WHERE ccpa.Ccp_Folio = '14-0000636' SELECT * FROM Complemento_Fiscal_Nodo WHERE Cfn_Padre = '0011' AND Cf_Cve_Complemento_Fiscal = 'CP20' ORDER BY Cfn_ID ASC SELECT * FROM Complemento_Fiscal_Nodo_Campo WHERE Cf_Cve_Complemento_Fiscal = 'CP20' AND Cfn_ID = '0011' ORDER BY Cfnc_ID ASC SELECT cppa.Ccp_Folio, cppa.Ccpa_Tipo_Permiso_SCT AS PermisoSCT, cppa.Ccpa_Num_Permiso_SCT AS NumPermisoSCT FROM Complemento_Carta_Porte_Autotransporte cppa WHERE Ccp_Folio = '14-0000636' SELECT Cpmd_Unidad_Peso AS UnidadPesoMerc, Cpmd_Peso_Bruto AS PesoBruto, Cpmd_Peso_Tara AS PesoTara, Cpmd_Numero_Piezas AS NumPiezas FROM Complemento_carta_porte_mercancia_D WHERE Ccp_Folio='14-0000636' SELECT Cpmc_Cantidad AS Cantidad, Cpmc_Id_Destino AS IDDestino, Cpmc_Id_Origen AS IDOrigen FROM Complemento_carta_porte_mercancia_C WHERE Ccp_Folio='14-0000636' SELECT cpmg_Numero AS NumeroGuiaIdentificacion, Cpmg_Descripcion AS DescripcionGuiaIdentificacion, Cpmg_Peso AS PesoGuiaIdentificacion FROM Complemento_carta_porte_mercancia_g WHERE Ccp_Folio='14-0000636' SELECT Cpmp_Pedimento AS Pedimento FROM Complemento_carta_porte_mercancia_p WHERE Ccp_Folio='14-0000636' SELECT * FROM Complemento_Fiscal_Nodo WHERE Cfn_Padre = '0006' AND Cf_Cve_Complemento_Fiscal = 'CP20' ORDER BY Cfn_ID ASC SELECT * FROM Complemento_Fiscal_Nodo_Campo WHERE Cf_Cve_Complemento_Fiscal = 'CP20' AND Cfn_ID = '0006' ORDER BY Cfnc_ID ASC SELECT Cpmd_Unidad_Peso AS UnidadPesoMerc, Cpmd_Peso_Bruto AS PesoBruto, Cpmd_Peso_Tara AS PesoTara, Cpmd_Numero_Piezas AS NumPiezas FROM Complemento_carta_porte_mercancia_D WHERE Ccp_Folio='14-0000636' SELECT Cpmc_Cantidad AS Cantidad, Cpmc_Id_Destino AS IDDestino, Cpmc_Id_Origen AS IDOrigen FROM Complemento_carta_porte_mercancia_C WHERE Ccp_Folio='14-0000636' SELECT cpmg_Numero AS NumeroGuiaIdentificacion, Cpmg_Descripcion AS DescripcionGuiaIdentificacion, Cpmg_Peso AS PesoGuiaIdentificacion FROM Complemento_carta_porte_mercancia_g WHERE Ccp_Folio='14-0000636' SELECT Cpmp_Pedimento AS Pedimento FROM Complemento_carta_porte_mercancia_p WHERE Ccp_Folio='14-0000636' SELECT * FROM Complemento_Fiscal_Nodo WHERE Cfn_Padre = '0006' AND Cf_Cve_Complemento_Fiscal = 'CP20' ORDER BY Cfn_ID ASC SELECT * FROM Complemento_Fiscal_Nodo_Campo WHERE Cf_Cve_Complemento_Fiscal = 'CP20' AND Cfn_ID = '0006' ORDER BY Cfnc_ID ASC SELECT Cpmd_Unidad_Peso AS UnidadPesoMerc, Cpmd_Peso_Bruto AS PesoBruto, Cpmd_Peso_Tara AS PesoTara, Cpmd_Numero_Piezas AS NumPiezas FROM Complemento_carta_porte_mercancia_D WHERE Ccp_Folio='14-0000636' SELECT Cpmc_Cantidad AS Cantidad, Cpmc_Id_Destino AS IDDestino, Cpmc_Id_Origen AS IDOrigen FROM Complemento_carta_porte_mercancia_C WHERE Ccp_Folio='14-0000636' SELECT cpmg_Numero AS NumeroGuiaIdentificacion, Cpmg_Descripcion AS DescripcionGuiaIdentificacion, Cpmg_Peso AS PesoGuiaIdentificacion FROM Complemento_carta_porte_mercancia_g WHERE Ccp_Folio='14-0000636' SELECT Cpmp_Pedimento AS Pedimento FROM Complemento_carta_porte_mercancia_p WHERE Ccp_Folio='14-0000636' SELECT * FROM Complemento_Fiscal_Nodo WHERE Cfn_Padre = '0006' AND Cf_Cve_Complemento_Fiscal = 'CP20' ORDER BY Cfn_ID ASC SELECT * FROM Complemento_Fiscal_Nodo_Campo WHERE Cf_Cve_Complemento_Fiscal = 'CP20' AND Cfn_ID = '0006' ORDER BY Cfnc_ID ASC SELECT Cpmd_Unidad_Peso AS UnidadPesoMerc, Cpmd_Peso_Bruto AS PesoBruto, Cpmd_Peso_Tara AS PesoTara, Cpmd_Numero_Piezas AS NumPiezas FROM Complemento_carta_porte_mercancia_D WHERE Ccp_Folio='14-0000636' SELECT Cpmc_Cantidad AS Cantidad, Cpmc_Id_Destino AS IDDestino, Cpmc_Id_Origen AS IDOrigen FROM Complemento_carta_porte_mercancia_C WHERE Ccp_Folio='14-0000636' SELECT cpmg_Numero AS NumeroGuiaIdentificacion, Cpmg_Descripcion AS DescripcionGuiaIdentificacion, Cpmg_Peso AS PesoGuiaIdentificacion FROM Complemento_carta_porte_mercancia_g WHERE Ccp_Folio='14-0000636' SELECT Cpmp_Pedimento AS Pedimento FROM Complemento_carta_porte_mercancia_p WHERE Ccp_Folio='14-0000636' SELECT * FROM Complemento_Fiscal_Nodo WHERE Cfn_Padre = '0006' AND Cf_Cve_Complemento_Fiscal = 'CP20' ORDER BY Cfn_ID ASC SELECT * FROM Complemento_Fiscal_Nodo_Campo WHERE Cf_Cve_Complemento_Fiscal = 'CP20' AND Cfn_ID = '0006' ORDER BY Cfnc_ID ASC SELECT Cpmd_Unidad_Peso AS UnidadPesoMerc, Cpmd_Peso_Bruto AS PesoBruto, Cpmd_Peso_Tara AS PesoTara, Cpmd_Numero_Piezas AS NumPiezas FROM Complemento_carta_porte_mercancia_D WHERE Ccp_Folio='14-0000636' SELECT Cpmc_Cantidad AS Cantidad, Cpmc_Id_Destino AS IDDestino, Cpmc_Id_Origen AS IDOrigen FROM Complemento_carta_porte_mercancia_C WHERE Ccp_Folio='14-0000636'