Script que lista qualquer alteração por período

select codigo as CODIGO, descricao AS DESCRICAO, codncm AS NCM, cest AS CEST, cst AS CST_ICMS, aliquota AS ALIQ_ICMS, pis AS ALIQ_PIS, cofins AS ALIQ_COFINS, cstpis AS CST_PIS_COFINS_ENTRADA, cstpcfsai AS CST_PIS_COFINS_SAIDA, natupis AS NATUREZA_RECEITA from item where dtalt BETWEEN :d1 AND :d2 order by descricao asc

Script que lista os itens pelo período de entrada

select codigo as CODIGO, descricao AS DESCRICAO, codncm AS NCM, cest AS CEST, cst AS CST_ICMS, aliquota AS ALIQ_ICMS, pis AS ALIQ_PIS, cofins AS ALIQ_COFINS, cstpis AS CST_PIS_COFINS_ENTRADA, cstpcfsai AS CST_PIS_COFINS_SAIDA, natupis AS NATUREZA_RECEITA from item where ult_ent BETWEEN :d1 AND :d2 order by descricao asc

Script que lista os itens pela última venda

select codigo as CODIGO, descricao AS DESCRICAO, codncm AS NCM, cest AS CEST, cst AS CST_ICMS, aliquota AS ALIQ_ICMS, pis AS ALIQ_PIS, cofins AS ALIQ_COFINS, cstpis AS CST_PIS_COFINS_ENTRADA, cstpcfsai AS CST_PIS_COFINS_SAIDA, natupis AS NATUREZA_RECEITA from item where ult_vend BETWEEN :d1 AND :d2 order by descricao asc

Exemplo de script que usa mais de uma data na mesma consulta

select codigo as CODIGO, descricao AS DESCRICAO, codncm AS NCM, cest AS CEST, cst AS CST_ICMS, aliquota AS ALIQ_ICMS, pis AS ALIQ_PIS, cofins AS ALIQ_COFINS, cstpis AS CST_PIS_COFINS_ENTRADA, cstpcfsai AS CST_PIS_COFINS_SAIDA, natupis AS NATUREZA_RECEITA from item where (ult_ent BETWEEN :d1 AND :d2) or (ult_vend BETWEEN :d1 AND :d2) order by descricao asc