Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select
- PROD.PRO_ST_ALTERNATIVO as idprod_erp,
- PROD.PRO_ST_ALTERNATIVO as codigo,
- PROD.PRO_ST_DESCRICAO as nome,
- NULL as comissao,
- PREC.PRT_RE_PRECO as preco_tabela,
- '0' as preco_minimo,
- IPI.NCM_RE_ALIQIPI as ipi,
- 'P' as tipo_ipi,
- PROD.PCD_ST_CODIGO as st,
- NULL as grade_cores,
- NULL as grade_tamanhos,
- '0' as moeda,
- PROD.UNIP_ST_UNIDADE as unidade,
- NULL as saldo_estoque,
- PROD.PRO_ST_NARRATIVA as observacoes,
- 'N' as excluido,
- 'true' as ativo,
- PROD.GRU_IN_CODIGO as categoria_id,
- IPI.NCM_ST_EXTENSO as codigo_ncm,
- NULL as multiplo,
- PROD.PRO_RE_PELIQUIDO as peso_bruto,
- PROD.PRO_DT_ALTERACAO as ultima_alteracao
- from MGADM.EST_PRODUTOS PROD
- join MGVEN.VEN_PRECOPRODUTO PREC ON PREC.PRO_IN_CODIGO = PROD.PRO_IN_CODIGO AND PREC.TPP_IN_CODIGO = '31'
- left join MGTRF.TRF_NCM IPI on IPI.NCM_IN_CODIGO = PROD.NCM_IN_CODIGO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement