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="MA" Folio="40617" Fecha="2018-05-07T12:31:42" Sello="k0qfQA9O5Kd9CV2IbA7fhW/j/BJc1q/IhcYAeCUUB2X5n4Ao/XYxypfUoq7vgZ9YxF+BLp0W5ujVUQoesi7XwJGxTCpvBXvnlzrS8AX/CJxNMxsKzm+CGj3ZKlESL/ExT7Gl3ruQlycEeu/Fpzf2/W0e8EvNOaDA8mAd1KUp905iGoc8M4lDZcUlJKr4fo0EOBSg0y2WUJ3cBVFJMcj4iBEmwEbKwfcpxG3BRIAC5XlNSms+dEL0A4EEVwtdwlbJEC8HPQNYtP7/IBd9H3z6CUqhLwNljwHroaMDAUhU12/5Jeu9Qp0I/iD6RrG0zODBwriCc6wfp7cLHTNcdNDmRA==" FormaPago="99" NoCertificado="00001000000404253137" Certificado="MIIGXTCCBEWgAwIBAgIUMDAwMDEwMDAwMDA0MDQyNTMxMzcwDQYJKoZIhvcNAQELBQAwggGyMTgwNgYDVQQDDC9BLkMuIGRlbCBTZXJ2aWNpbyBkZSBBZG1pbmlzdHJhY2nDs24gVHJpYnV0YXJpYTEvMC0GA1UECgwmU2VydmljaW8gZGUgQWRtaW5pc3RyYWNpw7NuIFRyaWJ1dGFyaWExODA2BgNVBAsML0FkbWluaXN0cmFjacOzbiBkZSBTZWd1cmlkYWQgZGUgbGEgSW5mb3JtYWNpw7NuMR8wHQYJKoZIhvcNAQkBFhBhY29kc0BzYXQuZ29iLm14MSYwJAYDVQQJDB1Bdi4gSGlkYWxnbyA3NywgQ29sLiBHdWVycmVybzEOMAwGA1UEEQwFMDYzMDAxCzAJBgNVBAYTAk1YMRkwFwYDVQQIDBBEaXN0cml0byBGZWRlcmFsMRQwEgYDVQQHDAtDdWF1aHTDqW1vYzEVMBMGA1UELRMMU0FUOTcwNzAxTk4zMV0wWwYJKoZIhvcNAQkCDE5SZXNwb25zYWJsZTogQWRtaW5pc3RyYWNpw7NuIENlbnRyYWwgZGUgU2VydmljaW9zIFRyaWJ1dGFyaW9zIGFsIENvbnRyaWJ1eWVudGUwHhcNMTYxMTE1MTgxNDM4WhcNMjAxMTE1MTgxNDM4WjCB/TE0MDIGA1UEAxMrQ0VMVUxBUkVTIFkgQUNDRVNPUklPUyBERUwgU1VSRVNURSBTQSBERSBDVjE0MDIGA1UEKRMrQ0VMVUxBUkVTIFkgQUNDRVNPUklPUyBERUwgU1VSRVNURSBTQSBERSBDVjE0MDIGA1UEChMrQ0VMVUxBUkVTIFkgQUNDRVNPUklPUyBERUwgU1VSRVNURSBTQSBERSBDVjElMCMGA1UELRMcQ0FTMDAwNTIyUkM3IC8gT09SRzc2MTIxNEpONjEeMBwGA1UEBRMVIC8gT09SRzc2MTIxNEhWWlNESjA1MRIwEAYDVQQLEwlDRUxVTEFSRVMwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQCa0xSzrhCnDjDxVMJb/TdteDeKVKU2+ro+wxcmmxxgOiAP1JEFFWq5+EFXTF0muyKwdBxAkv+vqSBAyXVVrHAQVp1zgApO9SJ4mOvecefV9EFUDN2PXDABcTGaavLmhDR+3wZub8KdGiEBZB88QoeTIerKiji+k+7X63dn5v7Ss0VSlv4HHSMbZAW3ib3m3hAOV7ktvEc2St5epVYAWryV2WIxy50272sOEAt5/tpX1TYTSfrBIBIQgG69BF7REE8QOdB7WGimqtJcIIw0dOhgvenA2s1BeDCbhM2M5MZN4+Lz/f11evpkvjJaavuLHt1dLa0XrlG314IZGtvsI5fTAgMBAAGjHTAbMAwGA1UdEwEB/wQCMAAwCwYDVR0PBAQDAgbAMA0GCSqGSIb3DQEBCwUAA4ICAQBXbc8Z3LD9W89DrusgFhp8sNUKMRNnSLWiM99RALUpfdyKmJeKvSyPt/j8O7bBcO+m3JMknrZmehgyWefqqOfgmOxO/X3C90N4/0gUtskcBUFaMmuJpfHGLtvyZpSE/JeMr+ci5GtO2ApOfbBRel/dIx+b8GAvvfcRwUX+d+ouC7qMyEcqAliAfMAbS76Qbrj3RQxfbuwie/hjB13FxmrBJ/Ty+mpBYRWRrg2nBCGC4uKPK+52SsHgYtJpthNaBurBttsTAt5T5+/Iel9uicLhijJBRVaLk1k4jqDTQVu/SnBWOA1X4kJO+rRm1cV9fcByMmbpjJCmfl2FSmpthvpGSGG9/zXk6mCYcXxB7lOFPFmb61UMdfsbHJnd9OUXJzhuSG5jFnbkisl9whvpYp5BdmqMRB62dk+GMtxlnd8XtoG/BudtHeUG0GAAPyxFWauz9bhUIy7lj1mhrKCZ5FV4mdLGOoHHhIrSiGoVJlfZmpi0qEP09L+akc6ZZPNVkofjumzfyhcNvQg2lP35pjcpCSGbMo0p6Qsnd789PNtkf0Q82j14wx7u8hONB4Tknt3JJXqNWPCi6YEgevBNFXcWc4g6B3bHj47bM02Ll1xYzNK2ggl4upYxBNzdkCuyunrecJfOcQfnWSEFxiVGqEMmXnzgFlxOt64ZYNprEU2QMg==" SubTotal="6690.00" Descuento="102.02" Moneda="MXN" Total="6587.98" TipoDeComprobante="N" MetodoPago="PUE" LugarExpedicion="97125"><cfdi:Emisor Rfc="CAS000522RC7" Nombre="CELULARES Y ACCESORIOS DEL SURESTE, S.A. DE C.V." RegimenFiscal="601"/><cfdi:Receptor Rfc="OOGB760801N28" Nombre="BEATRIZ OROZCO GUZMAN" UsoCFDI="P01"/><cfdi:Conceptos><cfdi:Concepto ClaveProdServ="84111505" Cantidad="1" ClaveUnidad="ACT" Descripcion="Pago de nómina" ValorUnitario="6690.00" Importe="6690.00" Descuento="102.02"/></cfdi:Conceptos><cfdi:Complemento><nomina12:Nomina Version="1.2" TipoNomina="E" FechaPago="2018-05-07" FechaInicialPago="2018-05-07" FechaFinalPago="2018-05-07" NumDiasPagados="1" TotalPercepciones="6690.00" TotalDeducciones="102.02"><nomina12:Emisor RegistroPatronal="G6285361100"/><nomina12:Receptor Curp="OOGB760801MOCRZT12" NumSeguridadSocial="24977600196" FechaInicioRelLaboral="2010-04-16" Antigüedad="P420W" TipoContrato="01" Sindicalizado="No" TipoJornada="03" TipoRegimen="02" NumEmpleado="0000000567" Departamento="RECURSOS HUMANOS" Puesto="INSTRUCTOR DE CAPACITACION" RiesgoPuesto="4" PeriodicidadPago="99" SalarioBaseCotApor="300.00" SalarioDiarioIntegrado="300.00" ClaveEntFed="YUC"/><nomina12:Percepciones TotalSueldos="6690.00" TotalSeparacionIndemnizacion="0.00" TotalJubilacionPensionRetiro="0.00" TotalGravado="5905.78" TotalExento="784.22"><nomina12:Percepcion TipoPercepcion="038" Clave="0010" Concepto="GRATIFICACION" ImporteGravado="4608.45" ImporteExento="0.00"/><nomina12:Percepcion TipoPercepcion="001" Clave="0028" Concepto="VACACIONES" ImporteGravado="1297.33" ImporteExento="0.00"/><nomina12:Percepcion TipoPercepcion="002" Clave="0097" Concepto="AGUINALDO" ImporteGravado="0.00" ImporteExento="460.26"/><nomina12:Percepcion TipoPercepcion="021" Clave="0107" Concepto="PRIMA VACACIONAL" ImporteGravado="0.00" ImporteExento="323.96"/><nomina12:SeparacionIndemnizacion TotalPagado="0.00" NumAñosServicio="8" UltimoSueldoMensOrd="9000.00" IngresoAcumulable="0.00" IngresoNoAcumulable="0.00"/></nomina12:Percepciones><nomina12:Deducciones TotalImpuestosRetenidos="102.02"><nomina12:Deduccion TipoDeduccion="010" Clave="0053" Concepto="INFONAVIT" Importe="0.00"/><nomina12:Deduccion TipoDeduccion="002" Clave="0076" Concepto="ISR" Importe="102.02"/></nomina12:Deducciones></nomina12:Nomina></cfdi:Complemento></cfdi:Comprobante> GTI gti*140 ' 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-0042525' SELECT TOP 1 Nomina_Concepto.Nc_CodigoFROM Nomina INNER JOIN Nomina_Concepto ON Nomina.Nc_Cve_Nomina_Concepto = Nomina_Concepto.Nc_Cve_Nomina_Concepto WHERE Nomina.Nm_Folio = '01-0042525' AND Nomina_Concepto.Nc_Tipo = '0001' AND Nomina.Nm_Importe > 0 AND Nomina_Concepto.Nc_Otro_Pago = 'SI' SELECT * FROM Complemento_Fiscal_Nodo WHERE Cfn_Padre = '0013' AND Cf_Cve_Complemento_Fiscal = 'FI12' ORDER BY Cfn_ID ASC SELECT * FROM Complemento_Fiscal_Nodo_Campo WHERE Cf_Cve_Complemento_Fiscal = 'FI12' AND Cfn_ID = '0013' ORDER BY Cfnc_ID ASC SELECT * FROM Complemento_Fiscal_Nodo WHERE Cfn_Padre = '0013' AND Cf_Cve_Complemento_Fiscal = 'FI12' ORDER BY Cfn_ID ASC SELECT * FROM Complemento_Fiscal_Nodo_Campo WHERE Cf_Cve_Complemento_Fiscal = 'FI12' 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 IMPORTEFROM Nomina INNER JOIN Nomina_Concepto ON Nomina.Nc_Cve_Nomina_Concepto = Nomina_Concepto.Nc_Cve_Nomina_ConceptoWHERE Nomina.Nm_Folio = '01-0042525' AND Nomina_Concepto.Nc_Tipo = '0002'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 = '0012' AND Cf_Cve_Complemento_Fiscal = 'FI12' ORDER BY Cfn_ID ASC SELECT * FROM Complemento_Fiscal_Nodo_Campo WHERE Cf_Cve_Complemento_Fiscal = 'FI12' 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 TOTALOTRASRETENCIONESFROM (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 TOTALIMPUESTORETENIDOFROM Nomina INNER JOIN Nomina_Concepto ON Nomina_Concepto.Nc_Cve_Nomina_Concepto = Nomina.Nc_Cve_Nomina_Concepto WHERE Nomina.Nm_Folio = '01-0042525' 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 * FROM Complemento_Fiscal_Nodo WHERE Cfn_Padre = '0011' AND Cf_Cve_Complemento_Fiscal = 'FI12' ORDER BY Cfn_ID ASC SELECT * FROM Complemento_Fiscal_Nodo_Campo WHERE Cf_Cve_Complemento_Fiscal = 'FI12' AND Cfn_ID = '0011' ORDER BY Cfnc_ID ASC SELECT ISNULL(SUM(CASE WHEN Nomina_Concepto.Nc_Codigo IN ('022','023','025') THEN ROUND(Nomina.Nm_Importe,2) ELSE 0 END),0) AS TOTALPAGADO, CASE WHEN CAST(ROUND(((DATEDIFF(DAY,ISNULL(Empleado.Em_Ingreso_Imss, Empleado.Em_Fecha_Ingreso), Nomina.Nm_Fecha_Baja) / 30.4) / 12),0) AS INT) = 0 THEN 1 else CAST(ROUND(((DATEDIFF(DAY,ISNULL(Empleado.Em_Ingreso_Imss, Empleado.Em_Fecha_Ingreso), Nomina.Nm_Fecha_Baja) / 30.4) / 12),0) AS INT) end AS ANIOSSERVICIO, Empleado.Em_Sueldo_Mensual AS SUELDOMENSUAL, CASE WHEN ISNULL(SUM( CASE WHEN Nomina_Concepto.Nc_Codigo IN ('022','023','025') THEN CASE WHEN Nomina_concepto.Nc_ISR = 'SI' 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-0042525') END END ), 0) > Empleado.Em_Sueldo_Mensual THEN Empleado.Em_Sueldo_Mensual ELSE ISNULL(SUM( CASE WHEN Nomina_Concepto.Nc_Codigo IN ('022','023','025') THEN CASE WHEN Nomina_concepto.Nc_ISR = 'SI' 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-0042525') END END ), 0) END AS INGRESOACUMULABLE, CASE WHEN ISNULL(SUM( CASE WHEN Nomina_Concepto.Nc_Codigo IN ('022','023','025') THEN CASE WHEN Nomina_concepto.Nc_ISR = 'SI' 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-0042525') END END ), 0) - Empleado.Em_Sueldo_Mensual < 0 THEN 0 ELSE ISNULL(SUM( CASE WHEN Nomina_Concepto.Nc_Codigo IN ('022','023','025') THEN CASE WHEN Nomina_concepto.Nc_ISR = 'SI' 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-0042525') END END ), 0) - Empleado.Em_Sueldo_Mensual END AS INGRESONOACUMULABLEFROM Nomina INNER JOIN Empleado ON Empleado.Em_Cve_Empleado = Nomina.Em_Cve_Empleado INNER JOIN Nomina_Concepto ON Nomina_Concepto.Nc_Cve_Nomina_Concepto = nomina.Nc_Cve_Nomina_Concepto WHERE Nomina.Nm_Folio = '01-0042525' AND Nomina_Concepto.Nc_Tipo = '0001' AND Nomina_Concepto.Nc_Otro_Pago = 'NO'GROUP BYEmpleado.Em_Ingreso_Imss,Empleado.Em_Fecha_Ingreso,Nomina.Nm_Fecha_Baja,Empleado.Em_Sueldo_Mensual 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 IMPORTEFROM 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_ConceptoWHERE Nomina.Nm_Folio = '01-0042525' AND Nomina_Concepto.Nc_Cve_Nomina_Concepto = '0107' 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 PRECIOALOTORGARSEWHERE 1 = 0 SELECT * FROM Complemento_Fiscal_Nodo WHERE Cfn_Padre = '0007' AND Cf_Cve_Complemento_Fiscal = 'FI12' ORDER BY Cfn_ID ASC SELECT * FROM Complemento_Fiscal_Nodo_Campo WHERE Cf_Cve_Complemento_Fiscal = 'FI12' AND Cfn_ID = '0007' ORDER BY Cfnc_ID ASC 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 IMPORTEFROM 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_ConceptoWHERE Nomina.Nm_Folio = '01-0042525' AND Nomina_Concepto.Nc_Cve_Nomina_Concepto = '0097' 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 PRECIOALOTORGARSEWHERE 1 = 0 SELECT * FROM Complemento_Fiscal_Nodo WHERE Cfn_Padre = '0007' AND Cf_Cve_Complemento_Fiscal = 'FI12' ORDER BY Cfn_ID ASC SELECT * FROM Complemento_Fiscal_Nodo_Campo WHERE Cf_Cve_Complemento_Fiscal = 'FI12' AND Cfn_ID = '0007' ORDER BY Cfnc_ID ASC 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 IMPORTEFROM 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_ConceptoWHERE Nomina.Nm_Folio = '01-0042525' AND Nomina_Concepto.Nc_Cve_Nomina_Concepto = '0028' 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 PRECIOALOTORGARSEWHERE 1 = 0 SELECT * FROM Complemento_Fiscal_Nodo WHERE Cfn_Padre = '0007' AND Cf_Cve_Complemento_Fiscal = 'FI12' ORDER BY Cfn_ID ASC SELECT * FROM Complemento_Fiscal_Nodo_Campo WHERE Cf_Cve_Complemento_Fiscal = 'FI12' AND Cfn_ID = '0007' ORDER BY Cfnc_ID ASC 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 IMPORTEFROM 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_ConceptoWHERE Nomina.Nm_Folio = '01-0042525' AND Nomina_Concepto.Nc_Cve_Nomina_Concepto = '0010' 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 PRECIOALOTORGARSEWHERE 1 = 0 SELECT * FROM Complemento_Fiscal_Nodo WHERE Cfn_Padre = '0007' AND Cf_Cve_Complemento_Fiscal = 'FI12' ORDER BY Cfn_ID ASC SELECT * FROM Complemento_Fiscal_Nodo_Campo WHERE Cf_Cve_Complemento_Fiscal = 'FI12' 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-0042525') 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-0042525') 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-0042525' AND Nomina_Concepto.Nc_Tipo = '0001' AND Nomina_Concepto.Nc_Otro_Pago = 'NO' AND Nomina.Nm_Importe > 0 -- AND Nomina_Concepto.Nc_Codigo NOT IN ('022','023','025','039','044') --JUBILACION, INDEMNIZACIONGROUP 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 = 'FI12' ORDER BY Cfn_ID ASC SELECT * FROM Complemento_Fiscal_Nodo_Campo WHERE Cf_Cve_Complemento_Fiscal = 'FI12' AND Cfn_ID = '0006' ORDER BY Cfnc_ID ASC 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-0042525') 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-0042525') END ), 0) AS TOTALEXCENTOFROM Nomina INNER JOIN Nomina_Concepto ON Nomina_Concepto.Nc_Cve_Nomina_Concepto = nomina.Nc_Cve_Nomina_Concepto WHERE Nomina.Nm_Folio = '01-0042525' AND Nomina_Concepto.Nc_Tipo = '0001' AND Nomina_Concepto.Nc_Otro_Pago = 'NO' SELECT '' AS RFCLABORA,'' AS PORCENTAJETIEMPOWHERE 1 = 0 SELECT * FROM Complemento_Fiscal_Nodo WHERE Cfn_Padre = '0004' AND Cf_Cve_Complemento_Fiscal = 'FI12' ORDER BY Cfn_ID ASC SELECT * FROM Complemento_Fiscal_Nodo_Campo WHERE Cf_Cve_Complemento_Fiscal = 'FI12' 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_Caratula.Nmc_Fecha_Pago) + 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 ISNULL(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 ISNULL(Empleado_Configuracion.Ec_Forma_Pago,'') WHEN 'TRANSFERENCIA' THEN ISNULL(Empleado_Configuracion.Ec_Cuenta, '') ELSE '' END AS CUENTABANCARIA, ISNULL(Empleado_Configuracion.Ec_Sueldo, Empleado.Em_Sueldo_Nominal) AS SALARIOBASECOT, ISNULL(Empleado_Configuracion.Ec_Sueldo_Integrado, Empleado.Em_Sueldo_Integrado) AS SALARIODIARIOINTEGRADO, Entidad_Federativa.Ef_Codigo_Sat AS ENTIDADFEDERATIVAFROM 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_FederativaWHERE Nomina.Nm_Folio = '01-0042525' SELECT '' AS ORIGENRECURSO,0 AS RECURSOPROPIOWHERE 1 = 0 SELECT * FROM Complemento_Fiscal_Nodo WHERE Cfn_Padre = '0002' AND Cf_Cve_Complemento_Fiscal = 'FI12' ORDER BY Cfn_ID ASC SELECT * FROM Complemento_Fiscal_Nodo_Campo WHERE Cf_Cve_Complemento_Fiscal = 'FI12' 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 Empresa.Em_RegiSTRo_Patronal ELSE '' END AS REGISTROPATRONAL, '' AS RFCPATRONORIGENFROM 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 WHERE Nomina.Nm_Folio = '01-0042525' SELECT * FROM Complemento_Fiscal_Nodo WHERE Cfn_Padre = '0001' AND Cf_Cve_Complemento_Fiscal = 'FI12' ORDER BY Cfn_ID ASC SELECT * FROM Complemento_Fiscal_Nodo_Campo WHERE Cf_Cve_Complemento_Fiscal = 'FI12' 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_Caratula.Nmc_Fecha_Pago AS FECHAINICIAL, Nomina_Caratula.Nmc_Fecha_Pago AS FECHAFINAL, 1 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 TOTROSPAGOSFROM Nomina 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 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) 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-0042525' 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 = 'FI12' ORDER BY Cfn_ID ASC