| Instrução SQL: | &sql Select codItem->id,
codItem->codCentroCusto->mascaraEdt as mascaraCCusto,
codItem->codCentroCusto->nome as nomeCCusto,
codEstrutura->mascaraEdt as codEstrutura,
codEstrutura as idEstrutura,
codEstrutura->descricao as descEstrutura,
codItem->codFornecedor->codigo as codFornecedor,
codItem->codFornecedor->nome as nomeFornecedor,
%EXTERNAL(dataBaixa) as dataBaixa,
%EXTERNAL(dataIncorporacao) as dataIncorporacao,
%EXTERNAL(dataInicioDepreciacao) as dataInicioDepreciacao,
%EXTERNAL(dataInicioUso) as dataInicioUso,
codItem->itemGerencial,
%EXTERNAL(quantidadeOriginal) as quantidadeOriginal,
%EXTERNAL(quantidadeAtual) as quantidadeAtual,
$$EdtVlr^CSWUTI(vlrCorrOrig,numDecMoeda) as vlrCorrOrig,
$$EdtVlr^CSWUTI(vlrDeprAtual,numDecMoeda) as vlrDeprAtual,
$$EdtVlr^CSWUTI(vlrOrig,numDecMoeda) as vlrOrig,
$$EdtVlr^CSWUTI(vlrOrigIndex,numDecIndexDepr) as vlrOrigIndex,
$$EdtVlr^CSWUTI(vlrAtual,numDecMoeda) as vlrAtual,
$$EdtVlr^CSWUTI(vlrCorrDeprAtual,numDecMoeda) as vlrCorrDeprAtual,
$$EdtVlr^CSWUTI(vlrAtualIndex,numDecIndexDepr) as vlrAtualIndex,
$$EdtVlr^CSWUTI(vlrCorrOrigIndex,numDecIndexCorr) as vlrCorrOrigIndex,
$$EdtVlr^CSWUTI(vlrDeprAtualIndex,numDecIndexDepr) as vlrDeprAtualIndex,
$$EdtVlr^CSWUTI(vlrCorrDeprAtualIndex,numDecIndexDepr) as vlrCorrDeprAtualIndex,
codItem->codigoBarras,
codItem->numeroDocumento,
codItem->observacao,
codItem->serieDocumento,
codItem->tipoDocumento,
$$EdtVlr^CSWUTI(vlrIndexCorr,numDecIndexCorr) as vlrIndexCorr,
$$EdtVlr^CSWUTI(vlrIndexDepr,numDecIndexDepr) as vlrIndexDepr,
%EXTERNAL(codItem->tipoItem) as tipoItem,
codItem->tipoItem as tpItem
from Pat.ItemMoeda
where codEstrutura->configuracao = |tmp.empresa|
and codItem->codigoRdz= '|tmp.codigoRdz|'
and (codMoeda->codMoeda = '|tmp.moeda|' or
codMoeda->codMoeda=codItem->codEmpresa->codMoedaAtiva->codMoeda) |