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

Tabela 2410 NWU

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

Salve salve, blz?

 

 

Tabela NWU. #NWU

 

 

 

 

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
NWU DATA NWU990 CONCESSOES CONCESIONES CONCESSIONS E E E 0 NWU_FILIAL+NWU_COD S 76 1 1 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
NWU 01 NWU_FILIAL C 2 0 Filial Filial do Sistema 1 N A R 033
NWU 02 NWU_CAJURI C 10 0 Cod Ass Jur Codigo Assunto Juridico ExistCpo('NSZ',M->NWU_CAJURI,1) JA100CAJUR() 1 N V R 035
NWU 03 NWU_COD C 10 0 Codigo Codigo ExistChav('NWU',M->NWU_COD,1) GetSXENum("NWU","NWU_COD") 1 N V R
NWU 04 NWU_CGENER C 3 0 Cod. Genero Codigo genero Vazio().Or.(ExistCpo('NWV',M->NWU_CGENER,1).And.JA124GenVal(M->NWU_CGENER).AND.JurVldRest('NWV',M->NWU_CGENER)) NWV 1 S N A R
NWU 05 NWU_DGENER C 50 0 Desc Genero Descricao do genero IF(!INCLUI,POSICIONE("NWV",1,xFilial('NWV')+NWU->NWU_CGENER,"NWV_DESC"),'') 1 S V V POSICIONE("NWV",1,xFilial('NWV')+NWU->NWU_CGENER,"NWV_DESC")
NWU 06 NWU_CESPEC C 3 0 Cod. Especie Codigo da especie VAZIO().OR.(ExistCpo('NWX',M-> NWU_CESPEC,1).And.JA124EspVal(M->NWU_CGENER,M->NWU_CESPEC).AND.JurVldRest('NWX',M->NWU_CESPEC)) NWX 1 S N A R
NWU 07 NWU_DESPEC C 50 0 Desc Especie Descricao Especie IF(!INCLUI,POSICIONE("NWX",1,xFilial('NWX')+NWU->NWU_CESPEC,"NWX_DESC"),'') 1 S V V POSICIONE("NWX",1,xFilial('NWX')+NWU->NWU_CESPEC,"NWX_DESC")
NWU 08 NWU_ESTADO C 2 0 Nome Estado Nome de Estado @! ExistCpo("SX5","12"+M->NWU_ESTADO) .Or. Vazio() 12 1 S A R 010
NWU 09 NWU_CMUNIC C 5 0 Cod. Municip Codigo de Municipio ExistCpo("CC2",M->NWU_ESTADO+M->NWU_CMUNIC).Or. Vazio() CC2NWU 1 S S A R
NWU 10 NWU_DMUNIC C 60 0 Desc Municip Descricao Municipio IF(!INCLUI, POSICIONE( "CC2", 1, XFILIAL("CC2") +M->NWU_ESTADO+M->NWU_CMUNIC,"CC2_MUN"),'') 1 S V V POSICIONE( "CC2", 1, XFILIAL("CC2") +NWU->NWU_ESTADO+NWU->NWU_CMUNIC,"CC2_MUN")
NWU 11 NWU_CAREA C 3 0 Cod. Area Codigo Area (ExistCpo('NWY',M->NWU_CAREA ,1) .And.JurVldRest('NWY',M->NWU_CAREA)).Or. Vazio() NWY 1 S N A R
NWU 12 NWU_DAREA C 50 0 Desc. Area Descricao Area IF(!INCLUI,POSICIONE("NWY",1, xFilial('NWY')+NWU->NWU_CAREA,"NWY_DESC"),'') 1 S V V POSICIONE("NWY",1,xFilial('NWY')+NWU->NWU_CAREA,"NWY_DESC")
NWU 13 NWU_NUM C 15 0 Numero Numero do Contrato 1 S A R
NWU 14 NWU_PRAZOT C 3 0 Prazo Outorg Prazo Outorga 1 S V R
NWU 15 NWU_TPPRA C 1 0 Tipo Prazo Tipo Prazo PERTENCE("12") "1" 1 S V R 1=Anos;2=Meses
NWU 16 NWU_PRAZOR C 3 0 Prazo Renov Prazo Renovacao 1 S A R
NWU 17 NWU_PRAZOM C 3 0 Prazo Minimo Prazo Minimo 1 S A R
NWU 18 NWU_DTINIO D 8 0 Dt Ini Out Data de Inicio da Outorga 1 S S A R
NWU 19 NWU_DTVENO D 8 0 Dt Venc Out Data Vencimento Outorga 1 S S A R
NWU 20 NWU_DTINIP D 8 0 Dt Ini Pro Data Inicio Protocolo 1 S V R
NWU 21 NWU_DTFIMP D 8 0 Dt Fim Pro Data Final Protocolo 1 S V R
NWU 22 NWU_DTRENI D 8 0 Dt Ren Int Data Renovacao Interna 1 S A R
NWU 23 NWU_DTPROT D 8 0 Dt Protocolo Data Protocolo 1 S A R
NWU 24 NWU_DTSTAT D 8 0 Dt Status Data Status Ministerio 1 N A R
NWU 25 NWU_STATUS M 10 0 Status Minis Status Ministerio 1 N A R
NWU 26 NWU_DTSTSA D 8 0 Dt Status Ag Data Status Agencia 1 N A R
NWU 27 NWU_STATSA M 10 0 Status Agenc Status Agencia 1 N A R
NWU 28 NWU_DTSTSC D 8 0 Dt Status CC Data Status Casa Civil 1 N A R
NWU 29 NWU_STATSC M 10 0 Status Casa Status Casa Civil 1 N A R
NWU 30 NWU_DTSTSG D 8 0 Dt Status Co Data Status Congresso 1 N A
NWU 31 NWU_STTUSC M 10 0 Status Congr Status Congresso 1 N A R
NWU 32 NWU_CTPOUT C 3 0 Cód Tipo Out Código Tipo Outorga Vazio().OR.(ExistCpo('NYI',M->NWU_CTPOUT,1).And.JurVldRest('NYI',M->NWU_CTPOUT)) NYI 1 S N A R
NWU 33 NWU_DTPOUT C 50 0 Des Tipo Out Descrição Tipo Outorga IF(!INCLUI,POSICIONE('NYI',1,XFILIAL('NYI')+NWU->NWU_CTPOUT,'NYI_DESC'),'') 1 N V V

 

 

 

 

SIX - INDICES

INDICE ORDEM CHAVE DESCRICAO DESCSPA DESCENG PROPRI F3 NICKNAME SHOWPESQ IX_VIRTUAL IX_VIRCUST
NWU 1 NWU_FILIAL+NWU_COD Codigo Codigo Code S S 2 3
NWU 2 NWU_FILIAL+NWU_CAJURI+NWU_COD Cod Ass Jur + Codigo Cod As Jur + Codigo Legal Sub.Cd + Code 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
NWU_CAREA 001 NWY->NWY_DESC NWU_DAREA P S NWY 1 xFilial('NWY')+M->NWU_CAREA S
NWU_CESPEC 001 NWX->NWX_DESC NWU_DESPEC P S NWX 1 xFilial('NWX')+M->NWU_CESPEC S
NWU_CGENER 001 NWV->NWV_DESC NWU_DGENER P S NWV 1 xFilial('NWV')+M->NWU_CGENER S
NWU_CGENER 002 NWV->NWV_PRAZO NWU_PRAZOT P S NWV 1 xFilial('NWV')+M->NWU_CGENER S
NWU_CGENER 003 NWV->NWV_TIPO NWU_TPPRA P S NWV 1 xFilial('NWV')+M->NWU_CGENER S
NWU_CMUNIC 001 CC2->CC2_MUN NWU_DMUNIC P S CC2 1 xFilial('CC2')+M->NWU_ESTADO+M->NWU_CMUNIC S
NWU_CTPOUT 001 NYI->NYI_DESC NWU_DTPOUT P S NYI 1 xFilial('NYI')+M->NWU_CTPOUT S
NWU_DTINIO 001 JA124VencOut() NWU_DTVENO P N 0 S
NWU_DTVENO 001 JA124IniPro() NWU_DTINIP P N 0 S
NWU_DTVENO 002 JA124FimPro() NWU_DTFIMP P N 0 S
NWU_DTVENO 003 JA124RenInt() NWU_DTRENI 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
NWU 001 NT4 NWU_COD NT4_CCONCE S 1 N S N 2 2
NWU 002 NT4 NWU_CAJURI+NWU_COD NT4_CAJURI+NT4_CCONCE S 1 N S S 2 2

 

 

 

 

SXG - Grupo de Campos

XG_GRUPO XG_DESCRI XG_DESSPA XG_DESENG XG_SIZEMAX XG_SIZEMIN XG_SIZE XG_PICTURE
010 Estado Estado State 5 2 2 @!
033 Tamanho da Filial Tamano de la Sucursal Branch Size 12 2 2
035 Assunto Juridico Asunto Juridico Legal Subject 15 10 10

 

 

 

 

 

 

 

 

 

 

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