SELECT 'RECHAZADO' as Texto SELECT ' <?xml version="1.0" encoding="utf-8"?><cfdi:Comprobante xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:cfdi="http://www.sat.gob.mx/cfd/3" xmlns:nomina12="http://www.sat.gob.mx/nomina12" xsi:schemaLocation="http://www.sat.gob.mx/cfd/3 http://www.sat.gob.mx/sitio_internet/cfd/3/cfdv33.xsd http://www.sat.gob.mx/nomina12 http://www.sat.gob.mx/sitio_internet/cfd/nomina/nomina12.xsd" Version="3.3" Serie="NOM" Folio="11" Fecha="2021-09-09T17:54:47" Sello="gPcEXHb6320s2XyNE8+qOCwX62/22rHxOM8YtI5gMbh0uxoNwQG5MQOMELM9/F1a2aeI8ut0vd+1Jo7otB3n7OxuDQZxgyTFuKATg+5xDfnPWUlwq/9wxiCItIN/ERmLraFrjkdu0bs4+mAVADKG4tGAqRd6kmyToJ6T617LuNNEteeOk0TPRunn9Jp4k8OWUU0NUYbu1h57c2n92X2d/oriq08FGbMj7YmmkabfL+DmGp9XH0PcuH2NHqmWM2cUQMHpMmE2GMA5bOxt6Rys1U26AuxTu0+UgjM0rkMwORaNg5dPbB8tYxyHsVPogXx2qwNLMRnC1PhzMfj/Z7+QkQ==" FormaPago="99" NoCertificado="00001000000409151575" Certificado="MIIGDTCCA/WgAwIBAgIUMDAwMDEwMDAwMDA0MDkxNTE1NzUwDQYJKoZIhvcNAQELBQAwggGyMTgwNgYDVQQDDC9BLkMuIGRlbCBTZXJ2aWNpbyBkZSBBZG1pbmlzdHJhY2nDs24gVHJpYnV0YXJpYTEvMC0GA1UECgwmU2VydmljaW8gZGUgQWRtaW5pc3RyYWNpw7NuIFRyaWJ1dGFyaWExODA2BgNVBAsML0FkbWluaXN0cmFjacOzbiBkZSBTZWd1cmlkYWQgZGUgbGEgSW5mb3JtYWNpw7NuMR8wHQYJKoZIhvcNAQkBFhBhY29kc0BzYXQuZ29iLm14MSYwJAYDVQQJDB1Bdi4gSGlkYWxnbyA3NywgQ29sLiBHdWVycmVybzEOMAwGA1UEEQwFMDYzMDAxCzAJBgNVBAYTAk1YMRkwFwYDVQQIDBBEaXN0cml0byBGZWRlcmFsMRQwEgYDVQQHDAtDdWF1aHTDqW1vYzEVMBMGA1UELRMMU0FUOTcwNzAxTk4zMV0wWwYJKoZIhvcNAQkCDE5SZXNwb25zYWJsZTogQWRtaW5pc3RyYWNpw7NuIENlbnRyYWwgZGUgU2VydmljaW9zIFRyaWJ1dGFyaW9zIGFsIENvbnRyaWJ1eWVudGUwHhcNMTgwMTI0MDIwOTU2WhcNMjIwMTI0MDIwOTU2WjCBrTEgMB4GA1UEAxMXQVhFTCBEQVZJRCBKQVNTTyBBQlVSVE8xIDAeBgNVBCkTF0FYRUwgREFWSUQgSkFTU08gQUJVUlRPMSAwHgYDVQQKExdBWEVMIERBVklEIEpBU1NPIEFCVVJUTzEWMBQGA1UELRMNSkFBQTYzMTIxOFZFMTEbMBkGA1UEBRMSSkFBQTYzMTIxOEhERlNCWDAxMRAwDgYDVQQLEwdNYXRyaXoxMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAhxuwu52V0p2nrKbswv4w5ywp7z7f05bi3zNfPk6AarrMtric47xvAg2HYuQzwnzUwDlhK7/zLC9c+s5EBeDdUVQtfS6Z2M/fKav6Gd+3GAHVcdZVVhe7IUULvidtLbPcRtdAq7Jp6tp4abAV7zw59Mv6Vl7ydad2lXgo9bQTtl6Ny1HYU+pyLZqUkbdvRSKG4yGlaGLFicWLG3RNuEPlAb/HKv3xHt/crZfmue5DhQ4GFY6Kf+VVKvN+rhPSruFtJrTVedKLXuSM5NOZEfSrjmF+lX/KhT4EcCDThwF2L+QFwAnjRPjAXMseqdYzRzW5SmuU0Z5wP/PTWF/0yfjEEwIDAQABox0wGzAMBgNVHRMBAf8EAjAAMAsGA1UdDwQEAwIGwDANBgkqhkiG9w0BAQsFAAOCAgEAi8wV8GLLMNgD4BuFNq7RRXcemPFS8wHnTw36x6dQ+/7Iy9lGDPTp5dnN3V6dCuqMCJYUSag0CXkjYCPpNfWuJsngkpcuNtl2vmYlXGmTcMnK0bPrEDiSzjF5ZNeVxgQZoe4/NgGw1gF2PYa41KTkiATBlclU+GdmySSP9Tqz8L7d1M9Mvh2zjBJQa/VQsUAm/lhA8RwDm+a30vwWsiiXaO1+XFnXQp8ibouk2nq6ZO2P012gIZ/CuW/t9tzjQA4o8OOj0bGSlWH582/0xWVykFH4FYaQkTeyIqewy6rQ+F9yZQILGMcHc70bP8YZfbM2Xnib+oWJ0XvJXvzny3kh8JqF140UQzrrNCivdM3XAGGfgptmP+g1yQGFz6awu4o/EYTgsdDiBCnHLaFYkUaQKyRErxS/rUmAmI6TL5V7wQ4zssPcZO4mW77O5qbU85Euv4PHniRuTARfAy/MqZnJS8hoskW9nqt7aJPdf2TYfvx4I8dBQ3Sa0bL3dnn5nWYJDOEcuYEhwJpLtvB70m3gwubXVy2QHpaLN8V2ryygam2op2AsI979EKNsKn+Hszj0NLn+gwlufid0ck6puamLaUh3Ylfm0dNfC+urAj8GQ+MAup02YD5IjIOIG9Li873T5GBRj0cfjyDN+CUd14hijs6ix/QudE/MkjQgaMJ4Mb0=" SubTotal="1999.97" Descuento="52.35" Moneda="MXN" Total="1947.62" TipoDeComprobante="N" MetodoPago="PUE" LugarExpedicion="02000"><cfdi:Emisor Rfc="JAAA631218VE1" Nombre="AXEL DAVID JASSO ABURTO" RegimenFiscal="612"/><cfdi:Receptor Rfc="OOSJ7108179A9" Nombre="JUVENTINO OYOLA SANCHEZ" UsoCFDI="P01"/><cfdi:Conceptos><cfdi:Concepto ClaveProdServ="84111505" Cantidad="1" ClaveUnidad="ACT" Descripcion="Pago de nómina" ValorUnitario="1999.9700" Importe="1999.9700" Descuento="52.3500"/></cfdi:Conceptos><cfdi:Complemento><nomina12:Nomina Version="1.2" TipoNomina="O" FechaPago="2021-08-20" FechaInicialPago="2021-08-16" FechaFinalPago="2021-08-22" NumDiasPagados="7" TotalPercepciones="1999.97" TotalDeducciones="52.35"><nomina12:Emisor RegistroPatronal="Y5060046108"/><nomina12:Receptor Curp="OOSJ710817HMCYNV09" NumSeguridadSocial="16867104057" FechaInicioRelLaboral="2021-08-05" Antigüedad="P2W" TipoContrato="01" Sindicalizado="No" TipoJornada="01" TipoRegimen="02" NumEmpleado="0000000004" Departamento="Mantenimiento Industrial" Puesto="Ayudante General" RiesgoPuesto="4" PeriodicidadPago="02" SalarioBaseCotApor="285.71" SalarioDiarioIntegrado="298.62" ClaveEntFed="MEX"/><nomina12:Percepciones TotalSueldos="1999.97" TotalGravado="1999.97" TotalExento="0.00"><nomina12:Percepcion TipoPercepcion="001" Clave="0001" Concepto="SUELDO" ImporteGravado="1999.97" ImporteExento="0.00"/></nomina12:Percepciones><nomina12:Deducciones TotalOtrasDeducciones="52.35"><nomina12:Deduccion TipoDeduccion="001" Clave="0052" Concepto="IMSS" Importe="52.35"/></nomina12:Deducciones><nomina12:OtrosPagos><nomina12:OtroPago TipoOtroPago="002" Clave="0002" Concepto="Subsidio para el empleo (efectivamente entregado al trabajador)" Importe="0.00"><nomina12:SubsidioAlEmpleo SubsidioCausado="0.00"/></nomina12:OtroPago></nomina12:OtrosPagos></nomina12:Nomina></cfdi:Complemento></cfdi:Comprobante> brian00@21 Jose2021 ' 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' EXEC sp_Get_Incapacidades '01-0000011' SELECT 0 AS SALDO, YEAR(GETDATE()) AS ANIO, 0 AS REMANENTE WHERE 1 = 0 SELECT * FROM Complemento_Fiscal_Nodo WHERE Cfn_Padre = '0016' AND Cf_Cve_Complemento_Fiscal = 'NO12' ORDER BY Cfn_ID ASC SELECT * FROM Complemento_Fiscal_Nodo_Campo WHERE Cf_Cve_Complemento_Fiscal = 'NO12' AND Cfn_ID = '0016' ORDER BY Cfnc_ID ASC SELECT dbo.Subsidio(SUM(Nomina.Nm_Importe), dbo.DiasLaborados( Nomina.Em_Cve_Empleado, Nomina_Caratula.Nmc_Nomina_Periodo, Nomina_Caratula.Nc_Cve_Nomina_Configuracion), YEAR( dbo.FechaI(Nomina_Caratula.Nmc_Nomina_Periodo) ),'NO') AS SUBSIDIO FROM Nomina INNER JOIN Nomina_Caratula ON Nomina.Nmc_Folio = Nomina_Caratula.Nmc_Folio WHERE Nomina.Nm_Folio = '01-0000011' AND Nomina.Nc_Cve_Nomina_Concepto = '0103' AND '002' = '002' GROUP BY Nomina.Em_Cve_Empleado, Nomina_Caratula.Nmc_Nomina_Periodo, Nomina_Caratula.Nc_Cve_Nomina_Configuracion --BUSCA EL CONCEPTO BASEGRAVADA SELECT * FROM Complemento_Fiscal_Nodo WHERE Cfn_Padre = '0015' AND Cf_Cve_Complemento_Fiscal = 'NO12' ORDER BY Cfn_ID ASC SELECT * FROM Complemento_Fiscal_Nodo_Campo WHERE Cf_Cve_Complemento_Fiscal = 'NO12' AND Cfn_ID = '0015' ORDER BY Cfnc_ID ASC SELECT Nomina_Concepto.Nc_Codigo AS TIPOPERCEPCION, LEFT(Nomina_Concepto.Nc_Descripcion,100) AS CONCEPTO, Nomina_Concepto.Nc_Cve_Nomina_Concepto AS CLAVE, ISNULL(SUM(ROUND(Nomina.Nm_Importe,2)), 0)AS IMPORTE FROM Nomina INNER JOIN Nomina_Concepto ON Nomina.Nc_Cve_Nomina_Concepto = Nomina_Concepto.Nc_Cve_Nomina_Concepto WHERE Nomina.Nm_Folio = '01-0000011' AND Nomina_Concepto.Nc_Tipo = '0001' AND Nomina_Concepto.Nc_Otro_Pago = 'SI' GROUP BY Nomina_Concepto.Nc_Codigo, LEFT(Nomina_Concepto.Nc_Descripcion,100), Nomina_Concepto.Nc_Cve_Nomina_Concepto UNION ALL SELECT '002' AS TIPOPERCEPCION, 'Subsidio para el empleo (efectivamente entregado al trabajador)' AS CONCEPTO, '0002' AS CLAVE, dbo.Sumar_Subsicio_Timbre('01-0000011') AS IMPORTE WHERE (SELECT ISNULL(SUM(ROUND(Nomina.Nm_Importe,2)), 0) FROM Nomina INNER JOIN Nomina_Concepto ON Nomina.Nc_Cve_Nomina_Concepto = Nomina_Concepto.Nc_Cve_Nomina_Concepto WHERE Nomina.Nm_Folio = '01-0000011' AND Nomina_Concepto.Nc_Tipo = '0001' AND Nomina_Concepto.Nc_Otro_Pago = 'SI' AND Nomina_Concepto.Nc_Codigo = '002') <= 0 AND (SELECT TOP 1 Empleado_Regimen.Er_Codigo FROM Nomina INNER JOIN Empleado ON Nomina.Em_Cve_Empleado = Empleado.Em_Cve_Empleado LEFT JOIN Empleado_Regimen ON EMPLEADO_REGIMEN.Er_Cve_Empleado_Regimen = Empleado.Em_Regimen WHERE Nm_Folio = '01-0000011') = '02' SELECT * FROM Complemento_Fiscal_Nodo WHERE Cfn_Padre = '0014' AND Cf_Cve_Complemento_Fiscal = 'NO12' ORDER BY Cfn_ID ASC SELECT * FROM Complemento_Fiscal_Nodo_Campo WHERE Cf_Cve_Complemento_Fiscal = 'NO12' AND Cfn_ID = '0014' ORDER BY Cfnc_ID ASC SELECT TOP 1 Op.CODIGO FROM ( SELECT Nomina_Concepto.Nc_Codigo AS CODIGO FROM Nomina INNER JOIN Nomina_Concepto ON Nomina.Nc_Cve_Nomina_Concepto = Nomina_Concepto.Nc_Cve_Nomina_Concepto WHERE Nomina.Nm_Folio = '01-0000011' AND Nomina_Concepto.Nc_Tipo = '0001' AND Nomina_Concepto.Nc_Otro_Pago = 'SI' UNION ALL --Si no exixte el 002 y tiene regimen 02 - Sueldos SELECT '002' AS CODIGO WHERE ( SELECT COUNT(Nomina_Concepto.Nc_Codigo) FROM Nomina INNER JOIN Nomina_Concepto ON Nomina.Nc_Cve_Nomina_Concepto = Nomina_Concepto.Nc_Cve_Nomina_Concepto WHERE Nomina.Nm_Folio = '01-0000011' AND Nomina_Concepto.Nc_Tipo = '0001' AND Nomina_Concepto.Nc_Otro_Pago = 'SI' AND Nomina_Concepto.Nc_Codigo = '002') <= 0 AND (SELECT top 1 Empleado_Regimen.Er_Codigo FROM Nomina INNER JOIN Empleado ON Nomina.Em_Cve_Empleado = Empleado.Em_Cve_Empleado LEFT JOIN Empleado_Regimen ON EMPLEADO_REGIMEN.Er_Cve_Empleado_Regimen = Empleado.Em_Regimen WHERE Nm_Folio = '01-0000011') = '02' ) AS Op SELECT * FROM Complemento_Fiscal_Nodo WHERE Cfn_Padre = '0013' AND Cf_Cve_Complemento_Fiscal = 'NO12' ORDER BY Cfn_ID ASC SELECT * FROM Complemento_Fiscal_Nodo_Campo WHERE Cf_Cve_Complemento_Fiscal = 'NO12' AND Cfn_ID = '0013' ORDER BY Cfnc_ID ASC SELECT Nomina_Concepto.Nc_Codigo AS TIPODEDUCCION, Nomina_Concepto.Nc_Cve_Nomina_Concepto AS CLAVE, LEFT(Nomina_Concepto.Nc_Descripcion,100) AS CONCEPTO, ISNULL(SUM(ROUND(Nomina.Nm_Importe,2)),0) AS IMPORTE FROM Nomina INNER JOIN Nomina_Concepto ON Nomina.Nc_Cve_Nomina_Concepto = Nomina_Concepto.Nc_Cve_Nomina_Concepto WHERE Nomina.Nm_Folio = '01-0000011' AND Nomina_Concepto.Nc_Tipo = '0002' GROUP BY Nomina_Concepto.Nc_Codigo, LEFT(Nomina_Concepto.Nc_Descripcion,100), Nomina_Concepto.Nc_Cve_Nomina_Concepto HAVING SUM(ROUND(Nomina.Nm_Importe,2)) > 0 SELECT * FROM Complemento_Fiscal_Nodo WHERE Cfn_Padre = '0012' AND Cf_Cve_Complemento_Fiscal = 'NO12' ORDER BY Cfn_ID ASC SELECT * FROM Complemento_Fiscal_Nodo_Campo WHERE Cf_Cve_Complemento_Fiscal = 'NO12' AND Cfn_ID = '0012' ORDER BY Cfnc_ID ASC SELECT CASE X.TOTALIMPUESTORETENIDO WHEN 0 THEN '' ELSE CAST(X.TOTALIMPUESTORETENIDO AS NVARCHAR(50)) END AS TOTALIMPUESTORETENIDO, CASE X.TOTALOTRASRETENCIONES WHEN 0 THEN '' ELSE CAST(X.TOTALOTRASRETENCIONES AS NVARCHAR(50)) END AS TOTALOTRASRETENCIONES FROM ( SELECT ISNULL(SUM(CASE Nomina_Concepto.Nc_Codigo WHEN '002' THEN 0 ELSE ROUND(Nomina.Nm_Importe,2) END), 0) AS TOTALOTRASRETENCIONES, ISNULL(SUM(CASE Nomina_Concepto.Nc_Codigo WHEN '002' THEN ROUND(Nomina.Nm_Importe,2) ELSE 0 END), 0) AS TOTALIMPUESTORETENIDO FROM Nomina INNER JOIN Nomina_Concepto ON Nomina_Concepto.Nc_Cve_Nomina_Concepto = Nomina.Nc_Cve_Nomina_Concepto WHERE Nomina.Nm_Folio = '01-0000011' AND dbo.Nomina_Concepto.Nc_Tipo = '0002' HAVING ISNULL(SUM(CASE Nomina_Concepto.Nc_Codigo WHEN '002' THEN 0 ELSE Nomina.Nm_Importe END), 0) <> 0 OR ISNULL(SUM(CASE Nomina_Concepto.Nc_Codigo WHEN '002' THEN Nomina.Nm_Importe ELSE 0 END), 0) <> 0 ) AS X SELECT '' WHERE 1 = 0 SELECT '' WHERE 1 = 0 SELECT dbo.DiasHorasExtras( Nomina.Em_Cve_Empleado, Nomina_Caratula.Nmc_Nomina_Periodo, Nomina_Concepto.Nc_Tipo_Hora_Extra, Nomina_Caratula.Nc_Cve_Nomina_Configuracion) AS DIAS, Nomina_Concepto.Nc_Tipo_Hora_Extra AS TIPOHORA, ROUND(SUM(Nomina.Nm_Cantidad),0) AS HORAS, SUM(ROUND(Nomina.Nm_Importe,2)) AS IMPORTE FROM Nomina INNER JOIN Nomina_Caratula ON Nomina.Nmc_Folio = Nomina_Caratula.Nmc_Folio INNER JOIN Nomina_Concepto ON Nomina.Nc_Cve_Nomina_Concepto = Nomina_Concepto.Nc_Cve_Nomina_Concepto WHERE Nomina.Nm_Folio = '01-0000011' AND Nomina_Concepto.Nc_Cve_Nomina_Concepto = '0001' AND Nomina_Concepto.Nc_Tipo = '0001' AND Nomina_Concepto.Nc_Codigo IN ('019') AND Nomina_Concepto.Nc_Tipo_Hora_Extra <> '' GROUP BY Nomina_Concepto.Nc_Tipo_Hora_Extra, Nomina.Em_Cve_Empleado, Nomina_Caratula.Nmc_Nomina_Periodo, Nomina_Caratula.Nc_Cve_Nomina_Configuracion SELECT 0 AS VALORMERCADO, 0 AS PRECIOALOTORGARSE WHERE 1 = 0 SELECT * FROM Complemento_Fiscal_Nodo WHERE Cfn_Padre = '0007' AND Cf_Cve_Complemento_Fiscal = 'NO12' ORDER BY Cfn_ID ASC SELECT * FROM Complemento_Fiscal_Nodo_Campo WHERE Cf_Cve_Complemento_Fiscal = 'NO12' AND Cfn_ID = '0007' ORDER BY Cfnc_ID ASC SELECT Nomina_Concepto.Nc_Codigo AS TIPOPERCEPCION, LEFT(Nomina_Concepto.Nc_Descripcion,100) AS CONCEPTO, Nomina_Concepto.Nc_Cve_Nomina_Concepto AS CLAVE, ISNULL(SUM(CASE nomina_concepto.Nc_ISR WHEN 'SI' THEN ROUND(nomina.Nm_Importe,2) ELSE 0 END), 0) + CASE WHEN Nomina_Concepto.Nc_Cve_Nomina_Concepto IN ('') THEN 0 ELSE dbo.ImporteGravadoComplemento(Nomina_Concepto.Nc_Codigo,'01-0000011') END AS GRAVADO, ISNULL(SUM(CASE nomina_concepto.Nc_ISR WHEN 'NO' THEN ROUND(nomina.Nm_Importe,2) ELSE 0 END), 0) - CASE WHEN Nomina_Concepto.Nc_Cve_Nomina_Concepto IN ('') THEN 0 ELSE dbo.ImporteGravadoComplemento(Nomina_Concepto.Nc_Codigo,'01-0000011') END AS EXCENTO FROM Nomina INNER JOIN Nomina_Concepto ON Nomina.Nc_Cve_Nomina_Concepto = Nomina_Concepto.Nc_Cve_Nomina_Concepto WHERE Nomina.Nm_Folio = '01-0000011' AND Nomina_Concepto.Nc_Tipo = '0001' AND Nomina_Concepto.Nc_Otro_Pago = 'NO' -- AND Nomina_Concepto.Nc_Codigo NOT IN ('022','023','025','039','044') --JUBILACION, INDEMNIZACION GROUP BY Nomina_Concepto.Nc_Codigo, LEFT(Nomina_Concepto.Nc_Descripcion,100), Nomina_Concepto.Nc_Cve_Nomina_Concepto SELECT * FROM Complemento_Fiscal_Nodo WHERE Cfn_Padre = '0006' AND Cf_Cve_Complemento_Fiscal = 'NO12' ORDER BY Cfn_ID ASC SELECT * FROM Complemento_Fiscal_Nodo_Campo WHERE Cf_Cve_Complemento_Fiscal = 'NO12' AND Cfn_ID = '0006' ORDER BY Cfnc_ID ASC SELECT SUMAS.TOTALSUELDOS, CASE SUMAS.TOTALSEPARACION WHEN 0 THEN '' ELSE CAST(SUMAS.TOTALSEPARACION AS NVARCHAR(50)) END AS TOTALSEPARACION, CASE SUMAS.TOTALJUBILACION WHEN 0 THEN '' ELSE CAST(SUMAS.TOTALJUBILACION AS NVARCHAR(50)) END AS TOTALJUBILACION, SUMAS.TOTALGRAVADO, SUMAS.TOTALEXCENTO FROM ( SELECT ISNULL(SUM(CASE WHEN Nomina_Concepto.Nc_Codigo NOT IN ('022','023','025','039','044') THEN ROUND(Nomina.Nm_Importe,2) ELSE 0 END),0) AS TOTALSUELDOS, ISNULL(SUM(CASE WHEN Nomina_Concepto.Nc_Codigo IN ('022','023','025') THEN ROUND(Nomina.Nm_Importe,2) ELSE 0 END),0) AS TOTALSEPARACION, ISNULL(SUM(CASE WHEN Nomina_Concepto.Nc_Codigo IN ('039','044') THEN ROUND(Nomina.Nm_Importe,2) ELSE 0 END),0) AS TOTALJUBILACION, ISNULL(SUM(CASE WHEN Nomina_concepto.Nc_ISR = 'SI' AND Nomina_Concepto.Nc_Codigo NOT IN ('022','023','025','039','044') THEN ROUND(Nomina.Nm_Importe,2) ELSE 0 END + CASE WHEN Nomina_Concepto.Nc_Cve_Nomina_Concepto IN ('') THEN 0 ELSE dbo.ImporteGravadoComplemento(Nomina_Concepto.Nc_Codigo,'01-0000011') END ), 0) AS TOTALGRAVADO, ISNULL(SUM(CASE WHEN Nomina_concepto.Nc_ISR = 'NO' AND Nomina_Concepto.Nc_Codigo NOT IN ('022','023','025','039','044') THEN ROUND(Nomina.Nm_Importe,2) ELSE 0 END - CASE WHEN Nomina_Concepto.Nc_Cve_Nomina_Concepto IN ('') THEN 0 ELSE dbo.ImporteGravadoComplemento(Nomina_Concepto.Nc_Codigo,'01-0000011') END ), 0) AS TOTALEXCENTO FROM Nomina INNER JOIN Nomina_Concepto ON Nomina_Concepto.Nc_Cve_Nomina_Concepto = nomina.Nc_Cve_Nomina_Concepto WHERE Nomina.Nm_Folio = '01-0000011' AND Nomina_Concepto.Nc_Tipo = '0001' AND Nomina_Concepto.Nc_Otro_Pago = 'NO' ) SUMAS SELECT '' AS RFCLABORA, '' AS PORCENTAJETIEMPO WHERE 1 = 0 SELECT * FROM Complemento_Fiscal_Nodo WHERE Cfn_Padre = '0004' AND Cf_Cve_Complemento_Fiscal = 'NO12' ORDER BY Cfn_ID ASC SELECT * FROM Complemento_Fiscal_Nodo_Campo WHERE Cf_Cve_Complemento_Fiscal = 'NO12' AND Cfn_ID = '0004' ORDER BY Cfnc_ID ASC SELECT top 1 Empleado.Em_CURP AS CURP, Empleado.Em_Num_IMSS AS NSS, ISNULL(Empleado.Em_Ingreso_Imss, Em_Fecha_Ingreso) AS FECHAINGRESO, 'P' + CAST( (DATEDIFF(DAY, ISNULL(Empleado.Em_Ingreso_Imss, Em_Fecha_Ingreso), Nomina_Periodo.Np_Fecha_Final) + 1) / 7 AS NVARCHAR(10)) + 'W' AS ANTIGUEDAD, ISNULL(Nomina_Tipo_Contrato.Ntc_Codigo_Sat,'') AS TIPOCONTRATO, CASE Empleado.Em_Sindicalizado WHEN 'NO' THEN 'No' ELSE 'Sí' END AS SINDICALIZADO, Empleado.Em_Tipo_Jornada AS TIPOJORNADA, Empleado_Regimen.Er_Codigo AS TIPOREGIMEN, Empleado.Em_Cve_Empleado AS NUMEMPLEADO, Departamento_Empleado.De_Descripcion AS DEPARTAMENTO, Puesto_Empleado.Pe_Descripcion AS PUESTO, Puesto_Empleado.Pe_Riesgo_Puesto AS RIESGOPUESTO, Nomina_Configuracion.Nc_Periodicidad_Pago AS PERIOCIDADPAGO, CASE Empleado_Configuracion.Ec_Forma_Pago WHEN 'TRANSFERENCIA' THEN CASE WHEN LEN(ISNULL(Empleado_Configuracion.Ec_Cuenta, '')) = 18 THEN '' ELSE ISNULL(Banco.Bn_Codigo,'') END ELSE '' END AS BANCO, CASE Empleado_Configuracion.Ec_Forma_Pago WHEN 'TRANSFERENCIA' THEN ISNULL(Empleado_Configuracion.Ec_Cuenta, '') ELSE '' END AS CUENTABANCARIA, Empleado_Configuracion.Ec_Sueldo AS SALARIOBASECOT, Empleado_Configuracion.Ec_Sueldo_Integrado AS SALARIODIARIOINTEGRADO, Entidad_Federativa.Ef_Codigo_Sat AS ENTIDADFEDERATIVA FROM Nomina INNER JOIN Sucursal ON Nomina.Sc_Cve_Sucursal = Sucursal.Sc_Cve_Sucursal INNER JOIN Empresa ON Sucursal.Em_Cve_Empresa = Empresa.Em_Cve_Empresa INNER JOIN Empleado ON Nomina.Em_Cve_Empleado = Empleado.Em_Cve_Empleado INNER JOIN Nomina_Tipo_Contrato ON Nomina_Tipo_Contrato.Ntc_Cve_Nomina_Tipo_Contrato = Empleado.Ntc_Cve_Nomina_Tipo_Contrato INNER JOIN Nomina_Caratula ON Nomina.Nmc_Folio = Nomina_Caratula.Nmc_Folio INNER JOIN Nomina_Configuracion ON Nomina_Caratula.Nc_Cve_Nomina_Configuracion = Nomina_Configuracion.Nc_Cve_Nomina_Configuracion LEFT JOIN Empleado_Configuracion ON Nomina.Em_Cve_Empleado = Empleado_Configuracion.Em_Cve_Empleado AND Empleado_Configuracion.Nc_Cve_Nomina_Configuracion = Nomina_Configuracion.Nc_Cve_Nomina_Configuracion LEFT JOIN Banco ON Banco.Bn_Cve_Banco = Empleado_Configuracion.Ec_Banco INNER JOIN Departamento_Empleado ON Empleado.De_Cve_Departamento_Empleado = Departamento_Empleado.De_Cve_Departamento_Empleado INNER JOIN Puesto_Empleado ON Empleado.Pe_Cve_Puesto_Empleado = Puesto_Empleado.Pe_Cve_Puesto_Empleado INNER JOIN Empleado_Regimen ON Empleado.Em_Regimen = Empleado_Regimen.Er_Cve_Empleado_Regimen INNER JOIN Entidad_Federativa ON Entidad_Federativa.Ef_Cve_Entidad_Federativa = Empleado.Em_Entidad_Federativa INNER JOIN Nomina_Periodo ON Nomina_Periodo.Np_Cve_Nomina_Periodo = Nomina_Caratula.Nmc_Nomina_Periodo WHERE Nomina.Nm_Folio = '01-0000011' SELECT '' AS ORIGENRECURSO, 0 AS RECURSOPROPIO WHERE 1 = 0 SELECT * FROM Complemento_Fiscal_Nodo WHERE Cfn_Padre = '0002' AND Cf_Cve_Complemento_Fiscal = 'NO12' ORDER BY Cfn_ID ASC SELECT * FROM Complemento_Fiscal_Nodo_Campo WHERE Cf_Cve_Complemento_Fiscal = 'NO12' AND Cfn_ID = '0002' ORDER BY Cfnc_ID ASC SELECT top 1 '' AS CURP, CASE WHEN ISNULL(Nomina_Tipo_Contrato.Ntc_Codigo_Sat,'') IN ('01','02','03','04','05','06','07','08') THEN ISNULL(Registro_Patronal.Rp_Descripcion, Empresa.Em_RegiSTRo_Patronal) ELSE '' END AS REGISTROPATRONAL, '' AS RFCPATRONORIGEN FROM Nomina INNER JOIN Sucursal ON Nomina.Sc_Cve_Sucursal = Sucursal.Sc_Cve_Sucursal INNER JOIN Empresa ON Sucursal.Em_Cve_Empresa = Empresa.Em_Cve_Empresa INNER JOIN Empleado ON Nomina.Em_Cve_Empleado = Empleado.Em_Cve_Empleado LEFT JOIN Nomina_Tipo_Contrato ON Empleado.Ntc_Cve_Nomina_Tipo_Contrato = Nomina_Tipo_Contrato.Ntc_Cve_Nomina_Tipo_Contrato LEFT JOIN Registro_Patronal_Sucursal ON Registro_Patronal_Sucursal.Sc_Cve_Sucursal = Sucursal.Sc_Cve_Sucursal LEFT JOIN Registro_Patronal ON Registro_Patronal.Rp_Cve_Registro_Patronal = Registro_Patronal_Sucursal.Rp_Cve_Registro_Patronal WHERE Nomina.Nm_Folio = '01-0000011' SELECT * FROM Complemento_Fiscal_Nodo WHERE Cfn_Padre = '0001' AND Cf_Cve_Complemento_Fiscal = 'NO12' ORDER BY Cfn_ID ASC SELECT * FROM Complemento_Fiscal_Nodo_Campo WHERE Cf_Cve_Complemento_Fiscal = 'NO12' AND Cfn_ID = '0001' ORDER BY Cfnc_ID ASC SELECT top 1 Nomina_Configuracion.Nc_Tipo_Nomina_Sat AS TIPONOMINA, Nomina_Caratula.Nmc_Fecha_Pago AS FECHAPAGO, Nomina_Periodo.Np_Fecha_Inicial AS FECHAINICIAL, Nomina_Periodo.Np_Fecha_Final AS FECHAFINAL, Nomina_Periodo.Np_Dias_Pago AS DIASPAGADOS, CASE T.TPERCEPCIONES WHEN 0 THEN '' ELSE CAST(T.TPERCEPCIONES AS NVARCHAR(50)) END AS TPERCEPCIONES, CASE T.TDEDUCCIONES WHEN 0 THEN '' ELSE CAST(T.TDEDUCCIONES AS NVARCHAR(50)) END TDEDUCCIONES, CASE T.TOTROSPAGOS WHEN 0 THEN '' ELSE CAST(T.TOTROSPAGOS AS NVARCHAR(50)) END TOTROSPAGOS FROM Nomina INNER JOIN Nomina_Caratula ON Nomina.Nmc_Folio = Nomina_Caratula.Nmc_Folio INNER JOIN Nomina_Periodo ON Nomina_Periodo.Np_Cve_Nomina_Periodo = Nomina_Caratula.Nmc_Nomina_Periodo INNER JOIN Nomina_Configuracion ON Nomina_Caratula.Nc_Cve_Nomina_Configuracion = Nomina_Configuracion.Nc_Cve_Nomina_Configuracion INNER JOIN ( SELECT n2.Nm_Folio, ISNULL(SUM(CASE WHEN Nomina_Concepto.Nc_Tipo = '0001' AND Nomina_Concepto.Nc_Otro_Pago = 'NO' THEN ROUND(n2.Nm_Importe,2) ELSE 0 END ),0) AS TPERCEPCIONES, --TOTALIMPUESTORETENIDO + TOTALOTRASRETENCIONES ROUND(ISNULL(SUM(CASE WHEN Nomina_Concepto.Nc_Tipo = '0002' AND Nomina_Concepto.Nc_Codigo = '0002' THEN ROUND(n2.Nm_Importe,2) ELSE 0 END ),0),2) + ROUND(ISNULL(SUM(CASE WHEN Nomina_Concepto.Nc_Tipo = '0002' AND Nomina_Concepto.Nc_Codigo <> '0002' THEN ROUND(n2.Nm_Importe,2) ELSE 0 END ),0),2) AS TDEDUCCIONES, ISNULL(SUM( CASE WHEN Nomina_Concepto.Nc_Tipo = '0001' AND Nomina_Concepto.Nc_Otro_Pago = 'SI' THEN ROUND(n2.Nm_Importe,2) ELSE 0 END),0) + dbo.Sumar_Subsicio_Timbre('01-0000011') AS TOTROSPAGOS FROM Nomina AS n2 INNER JOIN Nomina_Concepto ON Nomina_Concepto.Nc_Cve_Nomina_Concepto = n2.Nc_Cve_Nomina_Concepto GROUP BY n2.Nm_Folio ) T ON T.Nm_Folio = Nomina.Nm_Folio WHERE Nomina.Nm_Folio = '01-0000011' SELECT Complemento_Fiscal_Nodo.*, Complemento_Fiscal.Cf_Sql_Encabezado, Complemento_Fiscal.Cf_Sql_Detalle, Complemento_Fiscal.Cf_Sql_Pie, Complemento_Fiscal.Cf_Tipo FROM Complemento_Fiscal_Nodo INNER JOIN Complemento_Fiscal on Complemento_Fiscal.Cf_Cve_Complemento_Fiscal = Complemento_Fiscal_Nodo.Cf_Cve_Complemento_Fiscal WHERE Complemento_Fiscal_Nodo.Cfn_Padre = '0000' AND Complemento_Fiscal_Nodo.Cf_Cve_Complemento_Fiscal = 'NO12' ORDER BY Cfn_ID ASC SELECT 1 WHERE 1=2 SELECT 1 WHERE 1=2 SELECT '0001' as ID, '01' as TipoProducto, '0000000000' as Producto, '' as Complemento, '84111505' AS ClaveProdServ, 'Pago de nómina' as Concepto, '' as Unidad, 'ACT' as ClaveUnidad, 1 as Cantidad, ISNULL(ROUND(SUM(CASE Nomina_Concepto.Nc_Tipo WHEN '0001' THEN ROUND(Nomina.Nm_Importe,2) ELSE 0 END) + dbo.Sumar_Subsicio_Timbre('01-0000011') ,6),0) as Precio, ISNULL(ROUND(SUM(CASE Nomina_Concepto.Nc_Tipo WHEN '0001' THEN ROUND(Nomina.Nm_Importe,2) ELSE 0 END) + dbo.Sumar_Subsicio_Timbre('01-0000011') ,6),0) as Importe, ISNULL(ROUND(SUM(CASE Nomina_Concepto.Nc_Tipo WHEN '0002' THEN ROUND(Nomina.Nm_Importe,2) ELSE 0 END),6),0) as Descuento, '' as noIdentificacion FROM Nomina_Caratula INNER JOIN Nomina_Configuracion ON Nomina_Caratula.Nc_Cve_Nomina_Configuracion = Nomina_Configuracion.Nc_Cve_Nomina_Configuracion INNER JOIN Nomina ON Nomina_Caratula.Nmc_Folio = Nomina.Nmc_Folio INNER JOIN Nomina_Concepto ON Nomina.Nc_Cve_Nomina_Concepto = Nomina_Concepto.Nc_Cve_Nomina_Concepto WHERE Nomina.Nm_Folio = '01-0000011' GROUP BY Nomina_Configuracion.Nc_Tipo_Nomina, Nomina_Configuracion.Nc_Descripcion 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_ORDENAR_PRODUCTOS' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_MODO_CONCEPTO_NOMINA'