Consulta Padrao: NJR005 - Ctr.Compra Sem Troca



Consulta Padrao(SXB): NJR005 - Ctr.Compra Sem Troca
XB_ALIASXB_TIPOXB_SEQXB_COLUNAXB_DESCRIXB_CONTEM
NJR005101DBCtr.Compra Sem TrocaNJR
NJR00520101Codigo
NJR00540101CodigoNJR_CODCTR
NJR00540102DescricaoNJR_DESCRI
NJR00540103Nom.Ent.Posicione('NJ0',1,xFilial('NJ0')+NJR->NJR_CODENT+NJR->NJR_LOJENT,'NJ0_NOME')
NJR00540104Nom.Loj.Posicione('NJ0',1,xFilial('NJ0')+NJR->NJR_CODENT+NJR->NJR_LOJENT,'NJ0_NOMLOJ')
NJR005501NJR->NJR_CODCTR
NJR005601NJR->NJR_TIPO == '1' .and. ! NJR->NJR_USADO = .T. .and. NJR->(NJR_CODENT+NJR_LOJENT) == POSICIONE('NJ0', 4, xFilial('NJ0')+M->(ADA_CODCLI+ADA_LOJCLI),'NJ0_CODENT')+POSICIONE('NJ0', 4, xFilial('NJ0')+M->(ADA_CODCLI+ADA_LOJCLI),'NJ0_LOJENT')