Tabela NJR no Protheus

A tabela NJR do Protheus está descrita no dicionário (SX2) como “Contratos”. Possui 150 campos e 7 índices e chave única NJR_FILIAL+NJR_CODCTR. Abaixo estão tipo, tamanho e descrição de cada campo, os índices e um exemplo de consulta SQL.

Propriedades da tabela

Código

NJR

Nome

Contratos

Nome (inglês)

Contracts

Compartilhamento por filial

Exclusivo

Compartilhamento por unidade

Exclusivo

Compartilhamento por empresa

Exclusivo

Chave única

NJR_FILIAL+NJR_CODCTR

Campos / índices

150 / 7

Perguntas frequentes sobre a tabela NJR

O que é a tabela NJR?

É a tabela “Contratos” do ERP TOTVS Protheus, com 150 campos definidos no dicionário SX3.

Qual é a chave única da tabela NJR?

A chave única é NJR_FILIAL+NJR_CODCTR.

Quais são os índices da tabela NJR?

A tabela tem 7 índices. O principal (ordem 1) usa a chave NJR_FILIAL+NJR_CODCTR.

Qual é o nome físico da tabela NJR no banco de dados?

No banco, o nome é o código da tabela seguido do código da empresa (no dicionário de referência desta consulta: NJR990). Em ADVPL, use RetSqlName("NJR") para obter o nome correto do ambiente.

Exemplo de consulta SQL da tabela NJR

Modelo gerado a partir da estrutura da tabela. Ajuste os filtros ao seu cenário.

SELECT
    NJR_FILIAL,
    NJR_CODCTR,
    NJR_ULTALT,
    NJR_DESCRI,
    NJR_TIPO,
    NJR_TIPMER,
    NJR_DATA,
    NJR_CTREXT,
    NJR_CODENT,
    NJR_LOJENT,
    NJR_NOMENT,
    NJR_NLJENT,
    NJR_CODTER,
    NJR_LOJTER,
    NJR_NOMTER,
    NJR_NLJTER,
    NJR_OPETRI,
    NJR_OPEFUT,
    NJR_CODOPE,
    NJR_CODSAF,
    NJR_TALHAO,
    NJR_CODPRO,
    NJR_DESPRO,
    NJR_UM1PRO,
    NJR_TABELA,
    NJR_DESTAB,
    NJR_CODRPC,
    NJR_OPEFIS,
    NJR_TESEST,
    NJR_TESFIN,
    NJR_TESQTE,
    NJR_TESRSI,
    NJR_TIPEMB,
    NJR_OBSADT,
    NJR_QTDINI,
    NJR_TOLENT,
    NJR_QTDCTR,
    NJR_AUTENT,
    NJR_AUTSAI,
    NJR_QTEEMB,
    NJR_QTEFCO,
    NJR_QTEFIS,
    NJR_VLEFIS,
    NJR_QTSEMB,
    NJR_QTSFCO,
    NJR_QTSFIS,
    NJR_VLSFIS,
    NJR_QSLEMB,
    NJR_QSLFCO,
    NJR_SLDFIS,
    NJR_SLDTOT,
    NJR_QTDRES,
    NJR_QTDQUE,
    NJR_TIPFIX,
    NJR_VLRBAS,
    NJR_MOEDA,
    NJR_TXMOED,
    NJR_VLRUNI,
    NJR_UMPRC,
    NJR_VLRTOT,
    NJR_PERCRD,
    NJR_CODIDX,
    NJR_TPFRET,
    NJR_CTRLLG,
    NJR_CTRLCD,
    NJR_MODELO,
    NJR_MODBAS,
    NJR_STSASS,
    NJR_STSFIS,
    NJR_STSFIN,
    NJR_STSEST,
    NJR_STATUS,
    NJR_CODTSE,
    NJR_DESTSE,
    NJR_MODAL,
    NJR_DESMOD,
    NJR_INSCPO,
    NJR_CTRPAR,
    NJR_USADO,
    NJR_TPEXC,
    NJR_DATREF,
    NJR_TKPFIS,
    NJR_CLASSP,
    NJR_CLASSQ,
    NJR_TIPALG,
    NJR_HVIUM,
    NJR_TIPUM,
    NJR_HVICAL,
    NJR_OUTUM,
    NJR_TIPCAL,
    NJR_HVIFAT,
    NJR_OUTCAL,
    NJR_TIPFAT,
    NJR_OUTFAT,
    NJR_HVIREG,
    NJR_HVITOL,
    NJR_QAPADR,
    NJR_TIPACE,
    NJR_CODNGC,
    NJR_VERSAO,
    NJR_MSGNFS,
    NJR_CODEMB,
    NJR_DESEMB,
    NJR_CONDPA,
    NJR_DESCPA,
    NJR_VIA,
    NJR_DESVIA,
    NJR_INCOTE,
    NJR_DESINC,
    NJR_BOLSA,
    NJR_DBOLSA,
    NJR_CODREM,
    NJR_DESREM,
    NJR_TPSEVO,
    NJR_CONDPG,
    NJR_DIASPG,
    NJR_DESPG,
    NJR_TIPOCL,
    NJR_CODFIN,
    NJR_DESFIN,
    NJR_RESFIX,
    NJR_CHKFIX,
    NJR_ITVDAP,
    NJR_TRANSF,
    NJR_CLVL,
    NJR_OPERAC,
    NJR_MOEDAR,
    NJR_DESMOR,
    NJR_DIASR,
    NJR_MOEDAF,
    NJR_DESMOF,
    NJR_DIASF,
    NJR_TOTNN7,
    NJR_TOTN9G,
    NJR_TOTN9K,
    NJR_TOTAFT,
    NJR_TOTARB,
    NJR_STSMIN,
    NJR_PROMIN,
    NJR_GENMOD,
    NJR_CONPES,
    NJR_BCOPRV,
    NJR_AGGPRV,
    NJR_CTAPRV,
    NJR_QTDUM2,
    NJR_UM2PRO,
    NJR_VENDED,
    NJR_CLASSF,
    NJR_INDPRE,
    NJR_CODA1U
FROM NJR
WHERE
    D_E_L_E_T_ = ' '
    AND NJR_FILIAL = 'VALOR'
    AND NJR_CODCTR = 'VALOR'
    AND NJR_ULTALT = 'VALOR'
    AND NJR_DESCRI = 'VALOR'
    AND NJR_TIPO = 'VALOR'
    AND NJR_TIPMER = 'VALOR'
    AND NJR_DATA BETWEEN '20261001' AND '20261031'
    AND NJR_CTREXT = 'VALOR'
    AND NJR_CODENT = 'VALOR'
    AND NJR_LOJENT = 'VALOR'
    AND NJR_NOMENT = 'VALOR'
    AND NJR_NLJENT = 'VALOR'
    AND NJR_CODTER = 'VALOR'
    AND NJR_LOJTER = 'VALOR'
    AND NJR_NOMTER = 'VALOR'
    AND NJR_NLJTER = 'VALOR'
    AND NJR_OPETRI = 'VALOR'
    AND NJR_OPEFUT = 'VALOR'
    AND NJR_CODOPE = 'VALOR'
    AND NJR_CODSAF = 'VALOR'
    AND NJR_TALHAO = 'VALOR'
    AND NJR_CODPRO = 'VALOR'
    AND NJR_DESPRO = 'VALOR'
    AND NJR_UM1PRO = 'VALOR'
    AND NJR_TABELA = 'VALOR'
    AND NJR_DESTAB = 'VALOR'
    AND NJR_CODRPC = 'VALOR'
    AND NJR_OPEFIS = 'VALOR'
    AND NJR_TESEST = 'VALOR'
    AND NJR_TESFIN = 'VALOR'
    AND NJR_TESQTE = 'VALOR'
    AND NJR_TESRSI = 'VALOR'
    AND NJR_TIPEMB = 'VALOR'
    AND NJR_QTDINI = 0
    AND NJR_TOLENT = 0
    AND NJR_QTDCTR = 0
    AND NJR_AUTENT = 0
    AND NJR_AUTSAI = 0
    AND NJR_QTEEMB = 0
    AND NJR_QTEFCO = 0
    AND NJR_QTEFIS = 0
    AND NJR_VLEFIS = 0
    AND NJR_QTSEMB = 0
    AND NJR_QTSFCO = 0
    AND NJR_QTSFIS = 0
    AND NJR_VLSFIS = 0
    AND NJR_QSLEMB = 0
    AND NJR_QSLFCO = 0
    AND NJR_SLDFIS = 0
    AND NJR_SLDTOT = 0
    AND NJR_QTDRES = 0
    AND NJR_QTDQUE = 0
    AND NJR_TIPFIX = 'VALOR'
    AND NJR_VLRBAS = 0
    AND NJR_MOEDA = 0
    AND NJR_TXMOED = 0
    AND NJR_VLRUNI = 0
    AND NJR_UMPRC = 'VALOR'
    AND NJR_VLRTOT = 0
    AND NJR_PERCRD = 0
    AND NJR_CODIDX = 'VALOR'
    AND NJR_TPFRET = 'VALOR'
    AND NJR_CTRLLG = 'VALOR'
    AND NJR_CTRLCD = 'VALOR'
    AND NJR_MODELO = 'VALOR'
    AND NJR_MODBAS = 'VALOR'
    AND NJR_STSASS = 'VALOR'
    AND NJR_STSFIS = 'VALOR'
    AND NJR_STSFIN = 'VALOR'
    AND NJR_STSEST = 'VALOR'
    AND NJR_STATUS = 'VALOR'
    AND NJR_CODTSE = 'VALOR'
    AND NJR_DESTSE = 'VALOR'
    AND NJR_MODAL = 'VALOR'
    AND NJR_DESMOD = 'VALOR'
    AND NJR_INSCPO = 'VALOR'
    AND NJR_CTRPAR = 'VALOR'
    AND NJR_TPEXC = 'VALOR'
    AND NJR_DATREF BETWEEN '20261001' AND '20261031'
    AND NJR_TKPFIS = 'VALOR'
    AND NJR_CLASSP = 'VALOR'
    AND NJR_CLASSQ = 'VALOR'
    AND NJR_TIPALG = 'VALOR'
    AND NJR_HVIUM = 'VALOR'
    AND NJR_TIPUM = 'VALOR'
    AND NJR_HVICAL = 'VALOR'
    AND NJR_OUTUM = 'VALOR'
    AND NJR_TIPCAL = 'VALOR'
    AND NJR_HVIFAT = 0
    AND NJR_OUTCAL = 'VALOR'
    AND NJR_TIPFAT = 0
    AND NJR_OUTFAT = 0
    AND NJR_HVIREG = 'VALOR'
    AND NJR_HVITOL = 0
    AND NJR_QAPADR = 'VALOR'
    AND NJR_TIPACE = 'VALOR'
    AND NJR_CODNGC = 'VALOR'
    AND NJR_VERSAO = 'VALOR'
    AND NJR_MSGNFS = 'VALOR'
    AND NJR_CODEMB = 'VALOR'
    AND NJR_DESEMB = 'VALOR'
    AND NJR_CONDPA = 'VALOR'
    AND NJR_DESCPA = 'VALOR'
    AND NJR_VIA = 'VALOR'
    AND NJR_DESVIA = 'VALOR'
    AND NJR_INCOTE = 'VALOR'
    AND NJR_DESINC = 'VALOR'
    AND NJR_BOLSA = 'VALOR'
    AND NJR_DBOLSA = 'VALOR'
    AND NJR_CODREM = 'VALOR'
    AND NJR_DESREM = 'VALOR'
    AND NJR_TPSEVO = 'VALOR'
    AND NJR_CONDPG = 'VALOR'
    AND NJR_DIASPG = 0
    AND NJR_DESPG = 'VALOR'
    AND NJR_TIPOCL = 'VALOR'
    AND NJR_CODFIN = 'VALOR'
    AND NJR_DESFIN = 'VALOR'
    AND NJR_RESFIX = 'VALOR'
    AND NJR_CHKFIX = 'VALOR'
    AND NJR_ITVDAP = 'VALOR'
    AND NJR_TRANSF = 'VALOR'
    AND NJR_CLVL = 'VALOR'
    AND NJR_OPERAC = 'VALOR'
    AND NJR_MOEDAR = 0
    AND NJR_DESMOR = 'VALOR'
    AND NJR_DIASR = 0
    AND NJR_MOEDAF = 0
    AND NJR_DESMOF = 'VALOR'
    AND NJR_DIASF = 0
    AND NJR_TOTNN7 = 0
    AND NJR_TOTN9G = 0
    AND NJR_TOTN9K = 0
    AND NJR_TOTAFT = 0
    AND NJR_TOTARB = 0
    AND NJR_STSMIN = 'VALOR'
    AND NJR_PROMIN = 'VALOR'
    AND NJR_GENMOD = 'VALOR'
    AND NJR_CONPES = 'VALOR'
    AND NJR_BCOPRV = 'VALOR'
    AND NJR_AGGPRV = 'VALOR'
    AND NJR_CTAPRV = 'VALOR'
    AND NJR_QTDUM2 = 0
    AND NJR_UM2PRO = 'VALOR'
    AND NJR_VENDED = 'VALOR'
    AND NJR_CLASSF = 'VALOR'
    AND NJR_INDPRE = 'VALOR'
    AND NJR_CODA1U = 'VALOR'

Outras tabelas relacionadas

• NJ0 Entidades
• NJ2 Tipos de Reserva
• NJ3 REGRAS E FUNÇOES DE APROVAÇAO
• NJ4 VARIAVEIS DE USO NA APROVAÇAO
• NJ5 Programação de Entrega
• NJ6 LOTES SELECIONADOS
• NJ7 Moedas Protheus x Externas
• NJA Certificado
• NJB Controle de Reserva
• NJC Liquidação Cetificaçao da CP
• NJF Amostras Avulsas
• NJG Itens da Amostra Avulsa

Dicionário Protheus · atualizado em 13/10/2026. Voltar ao índice do dicionário.