Ajude o site desativando o bloqueador de anúncio
Cabeçalho

Tabela 2410 NJ0

Autor: Eurai Criado: 01/03/2025 Atualizado: 01/03/2025 Protheus
Postagem

Salve salve, blz?

 

 

Tabela NJ0. #NJ0

 

 

 

 

SX2 - TABELA

X2_CHAVE X2_PATH X2_ARQUIVO X2_NOME X2_NOMESPA X2_NOMEENG X2_ROTINA X2_MODO X2_MODOUN X2_MODOEMP X2_DELET X2_TTS X2_UNICO X2_PYME X2_MODULO X2_DISPLAY X2_SYSOBJ X2_USROBJ X2_POSLGT X2_CLOB X2_AUTREC X2_TAMFIL X2_TAMUN X2_TAMEMP X2_STAMP X2_INSDT
NJ0 DATA NJ0990 Entidades Entes Entities C C C 0 NJ0_FILIAL+NJ0_CODENT+NJ0_LOJENT S 67 OGA010 1 2 2 2 0 0

 

 

 

 

SX3 - CAMPOS

X3_ARQUIVO X3_ORDEM X3_CAMPO X3_TIPO X3_TAMANHO X3_DECIMAL X3_TITULO X3_DESCRIC X3_PICTURE X3_VALID X3_RELACAO X3_F3 X3_NIVEL X3_TRIGGER X3_BROWSE X3_VISUAL X3_CONTEXT X3_OBRIGAT X3_CBOX X3_PICTVAR X3_WHEN X3_INIBRW X3_GRPSXG X3_FOLDER
NJ0 01 NJ0_FILIAL C 2 0 Filial Filial 1 033
NJ0 02 NJ0_CGC C 14 0 CNPJ/CPF CNPJ/CPF da Entidade @! Vazio() .Or. CGC(M->NJ0_CGC) 1 S A R OGA010WHEN()
NJ0 03 NJ0_INSCR C 18 0 Ins. Estad. Inscricao Estadual @! 1 S A R OGA010WHEN()
NJ0 04 NJ0_CODENT C 6 0 Codigo Codigo da Entidade @! 1 S OGA010WHEN() 001
NJ0 05 NJ0_LOJENT C 2 0 Loja Loja da Entidade @! ExistChav('NJ0',M->NJ0_CODENT+M->NJ0_LOJENT) 1 S OGA010WHEN() 002
NJ0 06 NJ0_NOME C 40 0 Nome Nome da Entidade @! 1 S OGA010WHEN()
NJ0 07 NJ0_NOMLOJ C 20 0 Nome da Loja Nome da Loja @! 1 S A R OGA010WHEN()
NJ0 08 NJ0_ABREVI C 15 0 Nome Abrev. Nome abreviado @! 1 S A R
NJ0 09 NJ0_CLASSE C 1 0 Classe Classe da Entidade @! Pertence('123') '3' 1 S A R 1=Proprio;2=Cooperado;3=Terceiro
NJ0 10 NJ0_ITVDAP C 1 0 Incent. DAP Possui o Incentivo DAP @! Pertence('12') '2' 1 N A R 1=Sim;2=Nao
NJ0 11 NJ0_DTVDAP D 8 0 Dt.Vcto. DAP Data Vencimento DAP 1 S A R
NJ0 12 NJ0_NUMDAP C 30 0 Numero DAP Numero Cadastro DAP @! 1 S A R
NJ0 13 NJ0_CODCRP C 2 0 Emp/Fil Codigo da Empresa e Filia Vazio().Or.ExistCpo('SM0',cEmpAnt+FwFldGet('NJ0_CODCRP')) SM0 1 S N A R FwFldGet('NJ0_CLASSE')='1' 033
NJ0 14 NJ0_EMPCRP C 20 0 Emp.Crp. Nome da Empresa de Corres @! 1 N V V
NJ0 15 NJ0_FILCRP C 20 0 Fil.Crp. Nome da Filial de Corresp @! 1 N V V
NJ0 16 NJ0_ATIVO C 1 0 Cad. Ativo? Cadastro Ativo? @! Pertence('12') '1' 1 S A R 1=Ativo;2=Inativo
NJ0 17 NJ0_CODFOR C 6 0 Cod. Fornec. Codigo do Fornecedor @! FOR 1 N A R 001
NJ0 18 NJ0_LOJFOR C 2 0 Loja Fornec. Loja do Fornecedor @! Vazio().Or.ExistCpo('SA2',M->NJ0_CODFOR+M->NJ0_LOJFOR) 1 S N A R 002
NJ0 19 NJ0_NOMFOR C 50 0 Nome Fornec. Nome do Fornecedor @! IF(!INCLUI,POSICIONE('SA2',1,XFILIAL('SA2')+FWFLDGET('NJ0_CODFOR')+FWFLDGET('NJ0_LOJFOR'),'A2_NOME'),' ') 1 S V V POSICIONE('SA2',1,XFILIAL('SA2')+NJ0->NJ0_CODFOR+NJ0->NJ0_LOJFOR,'A2_NOME') 177
NJ0 20 NJ0_NLJFOR C 20 0 N.Lj.For. Nome da Loja do Fornecedo @! IF(!INCLUI,POSICIONE('SA2',1,XFILIAL('SA2')+FWFLDGET('NJ0_CODFOR')+FWFLDGET('NJ0_LOJFOR'),'A2_NREDUZ'),' ') 1 S V V POSICIONE('SA2',1,XFILIAL('SA2')+NJ0->NJ0_CODFOR+NJ0->NJ0_LOJFOR,'A2_NREDUZ')
NJ0 21 NJ0_CODCLI C 6 0 Cod. Cliente Codigo do Cliente @! SA1 1 N A R 001
NJ0 22 NJ0_LOJCLI C 2 0 Loja Cliente Loja do Cliente @! Vazio().Or.ExistCpo('SA1',M->NJ0_CODCLI+M->NJ0_LOJCLI) 1 S N A R 002
NJ0 23 NJ0_NOMCLI C 50 0 Nome Cliente Nome do Cliente @! IF(!INCLUI,POSICIONE('SA1',1,XFILIAL('SA1')+FWFLDGET('NJ0_CODCLI')+FWFLDGET('NJ0_LOJCLI'),'A1_NOME'),' ') 1 S V V POSICIONE('SA1',1,XFILIAL('SA1')+NJ0->NJ0_CODCLI+NJ0->NJ0_LOJCLI,'A1_NOME') 175
NJ0 24 NJ0_NLJCLI C 20 0 N.Lj.Cli. Nome da Loja do Cliente @! IF(!INCLUI,POSICIONE('SA1',1,XFILIAL('SA1')+FWFLDGET('NJ0_CODCLI')+FWFLDGET('NJ0_LOJCLI'),'A1_NREDUZ'),' ') 1 S V V POSICIONE('SA1',1,XFILIAL('SA1')+NJ0->NJ0_CODCLI+NJ0->NJ0_LOJCLI,'A1_NREDUZ')
NJ0 25 NJ0_DEPALF C 1 0 Dep Alfandeg Depósito Alfandegado Cert @! Pertence('12') '2' 1 S A R 1=Sim;2=Não
NJ0 26 NJ0_ID C 136 0 InternalId InternalID Integração PIM 1 N A R

 

 

 

 

SIX - INDICES

INDICE ORDEM CHAVE DESCRICAO DESCSPA DESCENG PROPRI F3 NICKNAME SHOWPESQ IX_VIRTUAL IX_VIRCUST
NJ0 1 NJ0_FILIAL+NJ0_CODENT+NJ0_LOJENT Codigo + Loja Codigo + Tienda Code + Store S CODIGO S 2 3
NJ0 2 NJ0_FILIAL+NJ0_NOME Nome Nombre Name S NOME S 2 3
NJ0 3 NJ0_FILIAL+NJ0_CODFOR+NJ0_LOJFOR Cod. Fornec. + Loja Fornec. Cod. Prov. + Tienda Prov. Supplier Cod + Supplier Sto S FOR.+LJ+FO S 2 3
NJ0 4 NJ0_FILIAL+NJ0_CODCLI+NJ0_LOJCLI Cod. Cliente + Loja Cliente Cod. Cliente + Tienda Clien Customer Cod + Cust Store S CLI+LJ CLI S 2 3
NJ0 5 NJ0_FILIAL+NJ0_CODCRP Emp/Fil Emp/Suc Comp/Br S EMP./FIL. S 2 3
NJ0 6 NJ0_FILIAL+NJ0_CLASSE Classe Clase Class S CLASSE S 2 3
NJ0 7 NJ0_FILIAL+NJ0_ID InternalId InternalId InternalId S S 2 3

 

 

 

 

SX7 - GATILHOS

X7_CAMPO X7_SEQUENC X7_REGRA X7_CDOMIN X7_TIPO X7_SEEK X7_ALIAS X7_ORDEM X7_CHAVE X7_CONDIC X7_PROPRI
NJ0_CODCRP 001 Posicione("SM0",1,cEmpAnt+M->NJ0_EMPCRP,"M0_NOME") NJ0_EMPCRP P N 0 S
NJ0_CODCRP 002 Posicione("SM0",1,cEmpAnt+M->NJ0_FILCRP,"M0_FILIAL") NJ0_FILCRP P N 0 S
NJ0_LOJCLI 001 SA1->A1_NOME NJ0_NOMCLI P S SA1 1 xFilial('SA1')+M->NJ0_CODCLI+M->NJ0_LOJCLI S
NJ0_LOJCLI 002 SA1->A1_NREDUZ NJ0_NLJCLI P N SA1 1 S
NJ0_LOJFOR 001 SA2->A2_NOME NJ0_NOMFOR P S SA2 1 xFilial('SA2')+M->NJ0_CODFOR+M->NJ0_LOJFOR S
NJ0_LOJFOR 002 SA2->A2_NREDUZ NJ0_NLJFOR P N 0 S

 

 

 

 

SX9 - Relacionamento entre Tabelas

X9_DOM X9_IDENT X9_CDOM X9_EXPDOM X9_EXPCDOM X9_PROPRI X9_LIGDOM X9_LIGCDOM X9_CONDSQL X9_USEFIL X9_ENABLE X9_VINFIL X9_CHVFOR
NJ0 001 DX0 NJ0_CODENT+NJ0_LOJENT DX0_PRDTOR+DX0_LOJA S 1 N S S 2 2
NJ0 002 NJH NJ0_CODENT+NJ0_LOJENT NJH_CODENT+NJH_LOJENT S 1 N S S 2 2
NJ0 003 NN0 NJ0_CODENT NN0_CODENT S 1 N S S 2 2
NJ0 004 N7Q NJ0_CODENT+NJ0_LOJENT N7Q_ENTENT+N7Q_LOJENT S 1 1 S S 2 2
NJ0 005 N7Q NJ0_CODENT+NJ0_LOJENT N7Q_IMPORT+N7Q_IMLOJA S 1 1 S S 2 2
NJ0 006 N9A NJ0_CODENT+NJ0_LOJENT N9A_CODENT+N9A_LOJENT S 1 N S S 2 2
NJ0 007 N9A NJ0_CODENT+NJ0_LOJENT N9A_ENTENT+N9A_LJEENT S 1 N S S 2 2
NJ0 008 NJB NJ0_CODENT+NJ0_LOJENT NJB_CODENT+NJB_LOJENT S 1 N S S 2 2
NJ0 009 NNG NJ0_CODENT+NJ0_LOJENT NNG_CODFAV+NNG_LOJFAV S 1 N S S 2 2
NJ0 010 DXD NJ0_CODENT+NJ0_LOJENT DXD_PRDTOR+DXD_LJPRO S 1 N S S 2 2
NJ0 011 DXI NJ0_CODENT+NJ0_LOJENT DXI_PRDTOR+DXI_LJPRO S 1 N #DXI_PRDTOR<>' ' AND #DXI_LJPRO <>' ' S S 2 2
NJ0 012 DXL NJ0_CODENT+NJ0_LOJENT DXL_PRDTOR+DXL_LJPRO S 1 N S S 2 2
NJ0 013 NJM NJ0_CODENT+NJ0_LOJENT NJM_CODENT+NJM_LOJENT S 1 N S S 2 2
NJ0 014 NJP NJ0_CODENT+NJ0_LOJENT NJP_CODTER+NJP_LOJTER S 1 N S S 2 2
NJ0 015 NKS NJ0_CODENT+NJ0_LOJENT NKS_CODDEV+NKS_LOJDEV S 1 N S S 2 2
NJ0 016 NJB NJ0_CODENT+NJ0_LOJENT NJB_CODTER+NJB_LOJTER S 1 N S S 2 2
NJ0 017 NBO NJ0_CODENT+NJ0_LOJENT NBO_CLIENT+NBO_LOJA S 1 N S S 2 2
NJ0 018 DXM NJ0_CODENT+NJ0_LOJENT DXM_PRDTOR+DXM_LJPRO S 1 N S S 2 2
NJ0 019 NKG NJ0_CODENT+NJ0_LOJENT NKG_CODDEV+NKG_LOJDEV S 1 N S S 2 2
NJ0 020 NKG NJ0_CODENT+NJ0_LOJENT NKG_CODENT+NKG_LOJENT S 1 N S S 2 2
NJ0 021 NK2 NJ0_CODENT+NJ0_LOJENT NK2_CODENT+NK2_LOJENT S 1 N S S 2 2
NJ0 022 NN6 NJ0_CODENT+NJ0_LOJENT NN6_CODFAV+NN6_LOJFAV S 1 N S S 2 2
NJ0 023 NNY NJ0_CODENT+NJ0_LOJENT NNY_ENTDES+NNY_LOJDES S 1 N S S 2 2
NJ0 024 NNY NJ0_CODENT+NJ0_LOJENT NNY_ENTORI+NNY_LOJORI S 1 N S S 2 2
NJ0 025 NLO NJ0_CODENT+NJ0_LOJENT NLO_PRDTOR+NLO_LJPRO S 1 1 S S 2 2
NJ0 026 NKB NJ0_CODENT+NJ0_LOJENT NKB_ENTLOC+NKB_LOJLOC S 1 N S S 2 2
NJ0 027 NJJ NJ0_CODENT+NJ0_LOJENT NJJ_CODENT+NJJ_LOJENT S 1 N S S 2 2
NJ0 028 NJJ NJ0_CODENT+NJ0_LOJENT NJJ_ENTENT+NJJ_ENTLOJ S 1 N S S 2 2
NJ0 029 DXJ NJ0_CODENT+NJ0_LOJENT DXJ_PRDTOR+DXJ_LJPRO S 1 N S S 2 2
NJ0 030 N7A NJ0_CODENT+NJ0_LOJENT N7A_ENTDES+N7A_LOJDES S N N S S 2 2
NJ0 031 N7A NJ0_CODENT+NJ0_LOJENT N7A_ENTORI+N7A_LOJORI S N N S S 2 2
NJ0 032 N9C NJ0_CODENT+NJ0_LOJENT N9C_CODENT+N9C_LOJENT S 1 N S S 2 2
NJ0 033 N9N NJ0_CODENT+NJ0_LOJENT N9N_CODENT+N9N_LOJENT S 1 N S S 2 2
NJ0 034 N9B NJ0_CODENT+NJ0_LOJENT N9B_CODENT+N9B_LOJENT S 1 N S S 2 2
NJ0 035 N8O NJ0_CODENT+NJ0_LOJENT N8O_ENTDES+N8O_LOJDES S 1 N S S 2 2
NJ0 036 N71 NJ0_CODENT+NJ0_LOJENT N71_PRODUT+N71_LOJA S 1 N S S 2 2
NJ0 037 NN7 NJ0_CODENT+NJ0_LOJENT NN7_CODFAV +NN7_LOJFAV S 1 N S S 2 2
NJ0 038 NJF NJ0_CODENT+NJ0_LOJENT NJF_CODENT+NJF_LOJENT S 1 N S S 2 2
NJ0 039 NJR NJ0_CODENT+NJ0_LOJENT NJR_CODENT+NJR_LOJENT S 1 N S S 2 2
NJ0 040 NJR NJ0_CODENT+NJ0_LOJENT NJR_CODTER+NJR_LOJTER S 1 N S S 2 2
NJ0 041 NNO NJ0_CODENT+NJ0_LOJENT NNO_CODENT+NNO_LOJENT S 1 N S S 2 2
NJ0 042 NJ2 NJ0_CODENT+NJ0_LOJENT NJ2_CODTER+NJ2_LOJTER S 1 N S S 2 2
NJ0 043 NBT NJ0_CODENT+NJ0_LOJENT NBT_ENTDES+NBT_LOJDES S 1 1 S S 2 2
NJ0 044 NBT NJ0_CODENT NBT_ENTORI S 1 1 S N 2 2
NJ0 045 NLJ NJ0_CODENT NLJ_CODENT S N N S S 2 2
NJ0 046 NLG NJ0_CODENT+NJ0_LOJENT NLG_CODCLI+NLG_LOJCLI S 1 N S S 2 2
NJ0 047 N79 NJ0_CODENT+NJ0_LOJENT N79_CODENT+N79_LOJENT S 1 N S S 2 2
NJ0 048 NNM NJ0_CODENT+NJ0_LOJENT NNM_CODENT+NNM_LOJENT S 1 N S S 2 2
NJ0 049 DX8 NJ0_CODENT+NJ0_LOJENT DX8_CODIGO+DX8_LOJA S 1 N S S 2 2
NJ0 050 NN2 NJ0_CODENT+NJ0_LOJENT NN2_PRDTOR+NN2_LJPRO S 1 1 S S 2 2

 

 

 

 

SXG - Grupo de Campos

XG_GRUPO XG_DESCRI XG_DESSPA XG_DESENG XG_SIZEMAX XG_SIZEMIN XG_SIZE XG_PICTURE
001 Codigo Cliente/Fornecedor Codigo Cliente/Proveedor Customer/Supplier Code 20 6 6 @!
002 Loja Cliente/Fornecedor Tienda Cliente/Proveedor Customer/Supplier Unit 4 2 2 @!
033 Tamanho da Filial Tamano de la Sucursal Branch Size 12 2 2
175 Nome do Cliente Nombre del cliente Customer Name 254 50 50 @!
177 Nome do Fornecedor Nombre del proveedor Supplier Name 254 50 50 @!

 

 

 

 

 

 

 

 

 

 

Gostou? Compartilhe com seus amigos e deixe um comentário! ??

Um abraço, e até a próxima  

 

 

 

 

 

📰 Posts Relacionados

ASSINE A NEWSLETTER

Cadastrando...

PIX uDesenv

PIX QR Code para depósito

Clique para doar

Siga-nos

YouTube GitHub LinkedIn

Parceiros

Tudo em ADVPL - Blog parceiro

Blog ADVPL