Usuario: DUI [CCUCH] Fecha: 21-Feb-2007 05:44:21 p.m.
F. Caja | Enero a Diciembre 2007 | Montos en Nuevos Soles | CP 01442010 a 01442010 | CC 00000 a 998106 | Rep#9
| cuenta | DescCuenta | abonos | cargos | saldos |
| 62130 | Remuneracion Basica | 0.00 | 10,712.18 | -10,712.18 |
| 62140 | Bonificaciones | 0.00 | 10,072.19 | -10,072.19 |
| 62160 | Otras Remuneraciones | 0.00 | 21,279.10 | -21,279.10 |
| 62540 | Gratificaciones | 0.00 | 500.00 | -500.00 |
| 62620 | Vacaciones | 0.00 | 748.38 | -748.38 |
| 62710 | ESSALUD- Prestaciones de Salud 9% | 0.00 | 3,745.31 | -3,745.31 |
| 62711 | EPS Entidad Prestadora de Salud 2.25% | 0.00 | 101.00 | -101.00 |
| 62730 | Seguro Complementario de Riesgo | 0.00 | 39.13 | -39.13 |
| 62740 | Seguro de Vida Ley 4916 | 0.00 | 81.81 | -81.81 |
| 62750 | Seguro Sul America | 0.00 | 29.56 | -29.56 |
| 62990 | Cargas de Personal Diversas | 0.00 | 523.20 | -523.20 |
| 63040 | Movilidad Local | 0.00 | 15.00 | -15.00 |
| 63402 | Mantenimiento y Reparacion Equipo de Computo | 0.00 | 4.00 | -4.00 |
| 65990 | Gastos Varios | 0.00 | 335.00 | -335.00 |
| 67601 | Perdida Por Diferencia en Cambio - UPCH | 0.00 | 5.32 | -5.32 |
| 68601 | Provision de Cts Personal | 0.00 | 4,047.09 | -4,047.09 |
| 68901 | Provision de Gratific. | 0.00 | 7,670.07 | -7,670.07 |
| 0.00 | 59,908.34 | -59,908.34 |
SELECT QS.cuenta, MAX(TB.cdsc_ctalo) AS DescCuenta, SUM(QS.abono) AS abonos, SUM(QS.cargo) AS cargos, SUM(QS.abono-QS.cargo) AS saldos FROM ( SELECT CJ.ccod_per AS mes, CJ.ccod_ccosto AS centro, CASE WHEN LEFT(CJ.ccod_ctalo,1)='9' THEN CP.CCTA_DEB1 ELSE CJ.ccod_ctalo END AS cuenta, CJ.negreso_mn AS cargo, CJ.ningreso_mn AS abono, CJ.creferencia as origen, CP.cdsc_ctalo as desc_cuenta FROM SERVERDGA.dateasy.dbo.ce_centraljr CJ LEFT JOIN SERVERDGA.dateasy.dbo.co_ctplactalo CP ON CJ.ccod_ctalo = CP.ccod_ctalo AND CJ.ccod_cia = CP.ccod_cia WHERE CJ.ccod_cia= 'PRU' AND CJ.ccod_eje = '2007' AND CJ.ccod_per BETWEEN 'MES001' AND 'MES012' AND CJ.creferencia NOT IN ('','ALMACEN','APERTURA','PROVISION') AND LEFT(ccod_ccosto,8) BETWEEN '01442010' AND '01442010' AND (( LEFT(CJ.ccod_ctalo,1)<>'9' AND LEFT(CJ.ccod_ctalo,2) NOT IN ('16','10','28','49','60','74','79') AND LEFT(CJ.ccod_ctalo,3) NOT IN ('423','421','467','468','469','703') AND LEFT(CJ.ccod_ctalo,5)<>'33801' AND LEFT(CJ.ccod_ctalo,6)<>'776001' ) OR ( LEFT(CJ.ccod_ctalo,1)='9' AND LEFT(CP.CCTA_DEB1,2) NOT IN ('16','10','28','49','60','74','79') AND LEFT(CP.CCTA_DEB1,3) NOT IN ('423','421','467','468','469','703') AND LEFT(CP.CCTA_DEB1,5)<>'33801' AND LEFT(CP.CCTA_DEB1,6)<>'776001' )) ) QS LEFT JOIN SERVERDGA.dateasy.dbo.co_ctplactalo TB ON TB.ccod_ctalo=QS.cuenta WHERE TB.ccod_cia='PRU' GROUP BY QS.cuenta ORDER BY QS.cuenta