@Rmalves Posted April 11, 2019 Topic Count: 1 Topics Per Day: 0.00 Content Count: 2 Content Per Day: 0.00 Reputation: 0 Achievement Points: 21 Solved Content: 0 Days Won: 0 Status: Offline Age: 57 Report Posted April 11, 2019 Alguem tem Relatório de Provisão de Fe´rias/13 salario no Rm Report?
Filipeejc Posted April 15, 2019 Topic Count: 2 Topics Per Day: 0.00 Content Count: 35 Content Per Day: 0.01 Reputation: 11 Achievement Points: 212 Solved Content: 0 Days Won: 7 Status: Offline Age: 41 Report Posted April 15, 2019 Em 11/04/2019 at 12:44, @Rmalves disse: Alguem tem Relatório de Provisão de Fe´rias/13 salario no Rm Report? Bom dia, Tenho essa consulta SQL que gera o histórico de provisão. Veja se lhe atende. SELECT PFUNC.CHAPA, PFUNC.NOME, PSECAO.CODIGO, PSECAO.DESCRICAO, PFHSTPROV.VALPROVFER, PFHSTPROV.VALPROV13 FROM PFUNC LEFT OUTER JOIN PFHSTPROV ON PFUNC.CODCOLIGADA = PFHSTPROV.CODCOLIGADA AND PFUNC.CHAPA = PFHSTPROV.CHAPA LEFT OUTER JOIN PSECAO ON PFUNC.CODCOLIGADA = PSECAO.CODCOLIGADA AND PFUNC.CODSECAO = PSECAO.CODIGO WHERE PFHSTPROV.ANO=:ANO AND PFHSTPROV.MES=:MES Atenciosamente, Filipe Pimenta 1
Recommended Posts