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

Tabela 2410 N01

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

Salve salve, blz?

 

 

Tabela N01. #N01

 

 

 

 

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
N01 DATA N01990 Imóvel Inmueble Real Estate C E E 0 N01_FILIAL+N01_COD+N01_FILHA S 54 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
N01 01 N01_FILIAL C 2 0 Filial Filial do Sistema 1 N 033 1
N01 02 N01_COD C 12 0 Codigo Codigo da Propriedade @! Existchav("N01",M->N01_COD+M->N01_FILHA,9) GSPFNVCOD1("N01","N01_COD",9,"") 1 S A R 1
N01 03 N01_FILHA C 2 0 Constr.Filha Construção Suplementar Existchav("N01",M->N01_COD+M->N01_FILHA,9) "00" 1 S V R 1
N01 04 N01_NUMERO C 10 0 Numero Numero do Imovel 1 S A R 1
N01 05 N01_PATRIM C 1 0 Patrimonio Patrimonio @! "2" 1 S A R 1=Publico;2=Particular;3=Religioso 1
N01 06 N01_PROPRI C 6 0 Contribuinte Contribuinte @! Existcpo("SA1") SA1 1 S S A R 1
N01 30 N01_TOPOGR C 1 0 Topografia Topografia @! "1" 1 S A R 1=Plano;2=Aclive;3=Declive;4=Irrigado 2
N01 29 N01_TRIBUT C 1 0 Tributacão Tributacão @! "1" 1 S A R 1=N. Imune/Isento;2=Imune;3=Isento 2
N01 28 N01_USO C 1 0 Uso Uso @! "1" 1 S A R 1=Nao Proprio;2=Proprio 2
N01 27 N01_LIMIT C 1 0 Limitacão Limitacão @! "1" 1 S A R 1=Com/Cerca/Muro;2=Sem/Cerca/Muro 2
N01 26 N01_COMP9 C 30 0 Desc.U.Imov. Compl Utilizacão Imovel @! 1 N V R 2
N01 25 N01_UTILIZ C 2 0 Util Imovel Utilizacao do Imovel @! Existcpo("SX5","N8"+M->N01_UTILIZ) N8 1 S S A R 2
N01 24 N01_IMPOST C 1 0 Imposto Imposto @! "1" 1 S A R 1=Predial;2=Territorial;3=Ambos 1
N01 23 N01_COMP11 C 30 0 Desc.Ocupac Complemento Ocupacão @! 1 N V R 1
N01 22 N01_OCUPAC C 2 0 Ocupacão Ocupacão @! Existcpo("SX5","N7"+M->N01_OCUPAC) N7 1 S S A R 1
N01 21 N01_COMP5 C 30 0 Desc.SubLote Complemento do Sub Lote @! 1 N V R 1
N01 20 N01_SUBLOT C 2 0 SubLote Sublote @! Existcpo("SX5","N5"+M->N01_SUBLOT) N5 1 S S A R 1
N01 19 N01_COMP4 C 30 0 Desc.Lote Complemento do Lote @! 1 N V R 1
N01 18 N01_LOTE C 2 0 Lote Lote @! Existcpo("SX5","N4"+M->N01_LOTE) N4 1 S S A R 1
N01 17 N01_COMP6 C 30 0 Desc.S.Fisca Complemento Setor Fiscal @! 1 N V R 1
N01 16 N01_SETORF C 2 0 Setor Fiscal Setor Fiscal @! Existcpo("SX5","N6"+M->N01_SETORF) N6 1 S S A R 1
N01 15 N01_COMP3 C 30 0 Desc.Quadra Complemento do Quadra @! 1 N V R 1
N01 14 N01_QUADRA C 2 0 Quadra Quadra @! Existcpo("SX5","N3"+M->N01_QUADRA) N3 1 S S A R 1
N01 13 N01_COMP2 C 30 0 Desc.Setor Complemento setor @! 1 N V R 1
N01 12 N01_SETOR C 2 0 Setor Setor @! Existcpo("SX5","N2"+M->N01_SETOR) N2 1 S S A R 1
N01 11 N01_COMP1 C 30 0 Desc.Distrit Complemento do Distrito @! 1 N V R POSICIONE("SX5",1,XFILIAL("SX5")+"N1"+N01->N01_DISTRI,"X5_DESCRI") 1
N01 10 N01_DISTRI C 2 0 Distrito Distrito @! Existcpo("SX5","N1"+M->N01_DISTRI) N1 1 S S A R 1
N01 09 N01_COMP7 C 30 0 Desc.Lograd. Complemento Logradouro @! 1 S V R POSICIONE("N02",1,XFILIAL("N02")+N01->N01_LOGRAD,"N02_DESCRI") 1
N01 08 N01_LOGRAD C 6 0 Logradouro Logradouro @! existcpo("N02") N02 1 S S A R 1
N01 07 N01_COMP8 C 30 0 Nome Nome do Proprientario @! 1 N V R 1
N01 57 N01_DATA D 8 0 Dt Construc. Data da Construcao 1 S A R 4
N01 56 N01_IMOVEL C 1 0 Util Imovel Utilizacão do Imovel @! "1" 1 S A R 1=Ocupado;2=Locado;3=Cedido;4=Desocupado 4
N01 55 N01_OPCION C 1 0 Info Opcion Informacões Opcionais @! "1" 1 S A R 1=C/ Passeio;2=S/ Passeio;3=C/ Pavimentacõo;4=S/ Pavimentacõo 4
N01 80 N01_VLRALI N 5 2 Vlr Aliquota Valor da Aliquota Imposto @e 99.99 1 N A R 3
N01 71 N01_AREATO N 9 2 Area Total Area Total Construida @E 9999,999.99 1 N A R 3
N01 59 N01_VLRPRE N 11 2 Vlr Predio Valor do Predio @e 9999999.99 1 N A R 3
N01 58 N01_VLRTER N 11 2 Vlr Terreno Valor do Terreno @e 99999999.99 1 N A R 3
N01 72 N01_PASSEI C 1 0 Passeio Passeio 9 "2" 1 N A R 1=Sim;2=Nao 2
N01 70 N01_TERBAL C 1 0 Terr. Baldio Terreno Baldio "2" 1 N A R 1=Limpo;2=Sujo/Periferia;3=Sujo/Centro;4=Murado;5=Nao Murado;6=Cultivado/Arborizado 2
N01 69 N01_TPTERR C 1 0 Tipo Terreno Tipo Terreno 1 N A R 1=Em edificacao;2=Edificado;3=Const.Condenada;4=Com Demolicao;5=Ruinas 2
N01 67 N01_CODPAI C 12 0 Imovel Pai Codigo do Imovel Pai 1 S V R 1
N01 66 N01_ATIVO C 1 0 Ativo/Inativ Flag de Ativo ou Inativo ! "A" 1 S A R A=Ativo;I=Inativo 1
N01 65 N01_JANOTI C 1 0 Ja Notificad Flag de ja notificado ! PERTENCE("SN") "N" 1 N V R 1
N01 64 N01_NOTIFI N 1 0 N.de Notific Numero de Notificacoes 9 1 N V R 1
N01 63 N01_DTNOT D 8 0 Dt Notificac Data da Notificacao Divid 1 N V R 1
N01 62 N01_DTEMIS D 8 0 Dt Emissao Data de Emissao IPTU 1 N V R 1
N01 61 N01_PREFIX C 3 0 Prefixo Prefixo Faturado 1 N V R 1
N01 60 N01_TITULO C 6 0 Titulo Titulo faturado 1 N V R 1
N01 79 N01_EGF C 1 0 Esgoto Fluv. Esgoto Fluvial 9 "2" 1 N A R 1=Sim;2=Nao
N01 78 N01_AGU C 1 0 Agua Abastecimento de Agua 9 "2" 1 N A R 1=Sim;2=Nao
N01 77 N01_ENE C 1 0 Energia Publ Energia Publica 9 "2" 1 N A R 1=Sim;2=Nao
N01 76 N01_EGC C 1 0 Esgoto Cloac Esgoto Cloacal 9 "2" 1 N A R 1=Sim;2=Nao
N01 75 N01_CLI C 1 0 Coleta Lixo Coleta de Lixo 9 "2" 1 N A R 1=Sim;2=Nao
N01 74 N01_LIU C 1 0 Limpeza Urb. Limpeza Urbana 9 "2" 1 N A 1=Sim;2=Nao
N01 73 N01_PAV C 1 0 Pavimentacao Pavimentacao 9 "2" 1 N A R 1=Sim;2=Nao
N01 68 N01_IMPRES N 1 0 Impr.Notific Impressao da Notificacao 0 1
N01 54 N01_ESTCON C 1 0 Estado Cons Estado de Conservacão @! "1" 1 S A R 1=Otimo;2=Bom;3=Regular;4=Ruim 4
N01 53 N01_PISO C 1 0 Pisos Tipo de Piso @! "1" 1 S A R 1=Terra Batida;2=Cimento;3=Ceramica;4=Tabuas;5=Tacos;6=M. Plasticos;7=Especial 4
N01 52 N01_INSTEL C 1 0 Instal Elet. Instalacão Eletrica @! "1" 1 S A R 1=Sem;2=Aparente;3=Embutida 4
N01 51 N01_INSTAL C 1 0 Inst Sanit Instalacão Sanitaria @! "1" 1 S A R 1=Sem;2=Externa;3=Simples;4=Composta;5=Completa 4
N01 50 N01_REVEST C 1 0 Revestimento Revestimento @! "1" 1 S A R 1=Sem;2=Reboco;3=Metalico;4=Madeira;5=Especial 4
N01 49 N01_FORRO C 1 0 Forro Tipo de Forro da Casa @! "1" 1 S A R 1=Sem;2=Tabua;3=Estoque;4=Laje;5=Chapas 4
N01 48 N01_PAREDE C 1 0 Paredes Paredes @! "1" 1 S A R 1=Sem;2=Taipa;3=Alvenaria;4=Concreto;5=Madeira 4
N01 47 N01_COBERT C 1 0 Cobertura Cobertura @! "1" 1 S A R 1=Zinco;2=Fibra Cim;3=Telha Barro;4=Lage;5=Especial 4
N01 46 N01_ESTRUT C 1 0 Estrutura Estrutura @! "1" 1 S A R 1=Alvenaria;2=Madeira;3=Metalica;4=Concreto 4
N01 45 N01_SITUAC C 1 0 Sit da Const Situacão da Construcão @! "1" 1 S A R 1=Frente;2=Fundos 4
N01 44 N01_POSIC C 1 0 Posicão Posicionamento @! "1" 1 S A R 1=Isolada;2=Conjugada;3=Germinada 4
N01 43 N01_ALINHA C 1 0 Alinhamento Alinhamento @! "1" 1 S A R 1=Alinhado;2=Recuado 4
N01 42 N01_COMP12 C 30 0 Desc.Contruc complemento do tipo const @! 1 N V R POSICIONE("SX5",1,XFILIAL("SX5")+"NA"+N01->N01_TIPOCO,"X5_DESCRI") 4
N01 41 N01_TIPOCO C 2 0 Tipo Const Tipo de Construcão @! Existcpo("SX5","NA"+M->N01_TIPOCO) NA 1 S S A R 4
N01 40 N01_AREACO N 9 2 Area Const Area Construida 999999.99 1 S N A R 3
N01 39 N01_AREA N 9 2 Area do Lote Area do Lote 999999.99 1 S N A R 3
N01 38 N01_PROF N 9 2 Prof Media Profundidade Media 999999.99 1 N A R 3
N01 37 N01_PROFB N 9 2 Profund B Profundidade B 999999.99 1 S N A R 3
N01 36 N01_PROFA N 9 2 Profund A Profundidade A 999999.99 1 S N A R 3
N01 35 N01_FUNDO N 9 2 Fundo Fundo 999999.99 1 S N A R 3
N01 34 N01_TESTAD N 9 2 Testada Testada 999999.99 1 S N A R 3
N01 33 N01_PEDOL C 1 0 Pedologia Pedologia @! "1" 1 S A R 1=Inundavel;2=Firme;3=Alagado;4=Combinacõo 2
N01 32 N01_COMP10 C 30 0 Desc.Inform. Complemento Informacão @! 1 S V R POSICIONE("SX5",1,XFILIAL("SX5")+"N9"+N01->N01_INFO,"X5_DESCRI") 2
N01 31 N01_INFO C 2 0 Informacões Informacões Sobre o terre @! Existcpo("SX5","N9"+M->N01_INFO) N9 1 S S A R 2

 

 

 

 

SIX - INDICES

INDICE ORDEM CHAVE DESCRICAO DESCSPA DESCENG PROPRI F3 NICKNAME SHOWPESQ IX_VIRTUAL IX_VIRCUST
N01 1 N01_FILIAL+N01_DISTRI+N01_SETOR+N01_QUADRA+N01_LOTE+N01_SUBLOT+N01_SETORF Distrito + Setor + Quadra + Lote + SubLote + Setor Fiscal Distrito + Sector + Cuadra + Lote + Sublote + Sector Fisc. Area + Sector + Block + Lot + Sublot + Fiscal Sec. S S 2 3
N01 2 N01_FILIAL+N01_SETOR Setor Sector Sector S S 2 3
N01 3 N01_FILIAL+N01_QUADRA Quadra Cuadra Block S S 2 3
N01 4 N01_FILIAL+N01_LOTE Lote Lote Lot S S 2 3
N01 5 N01_FILIAL+N01_SUBLOT SubLote Sublote Sublot S S 2 3
N01 6 N01_FILIAL+N01_SETORF Setor Fiscal Sector Fisc. Fiscal Sec. S S 2 3
N01 7 N01_FILIAL+N01_LOGRAD Logradouro Direccion Address S S 2 3
N01 8 N01_FILIAL+N01_PROPRI Contribuinte Contribuyent Tax Payer S CLI S 2 3
N01 9 N01_FILIAL+N01_COD+N01_FILHA Codigo + Constr.Filha Codigo + Const.Supl. Code + Supl. Build. S S 2 3
N01 A N01_FILIAL+N01_CODPAI+N01_COD Imovel Pai + Codigo Inmueble Pri + Codigo Main R.St. + 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
N01_AREA 001 M->N01_AREA*N02->N02_VLRTER N01_VLRTER P S N02 1 XFILIAL("N02")+M->N01_LOGRAD S
N01_AREACO 001 M->N01_AREACO*N02->N02_VLRCON N01_VLRPRE P S N02 1 XFILIAL("N02")+M->N01_LOGRAD S
N01_DISTRI 001 SX5->X5_DESCRI N01_COMP1 P S SX5 1 XFILIAL("SX5")+"N1"+M->N01_DISTRI S
N01_FUNDO 001 ((M->N01_TESTAD+M->N01_FUNDO)/2)*M->N01_PROF N01_AREA P N N01 1 XFILIAL("N01")+M->N01_FUNDO S
N01_FUNDO 002 N02->N02_VLRTER * M->N01_AREA N01_VLRTER P S N02 1 XFILIAL("N02") + M->N01_LOGRAD S
N01_INFO 001 SX5->X5_DESCRI N01_COMP10 P S SX5 1 XFILIAL("SX5")+"N9"+M->N01_INFO S
N01_LOGRAD 001 N02->N02_DESCRI N01_COMP7 P S N02 1 XFILIAL("N02")+M->N01_LOGRAD S
N01_LOGRAD 002 N02->N02_DISTRI N01_DISTRI P S N02 1 XFILIAL("N02")+M->N01_LOGRAD S
N01_LOGRAD 003 N02->N02_SETOR N01_SETOR P S N02 1 XFILIAL("N02")+M->N01_LOGRAD S
N01_LOGRAD 004 N02->N02_QUADRA N01_QUADRA P S N02 1 XFILIAL("N02")+M->N01_LOGRAD S
N01_LOGRAD 005 N02->N02_SFI N01_SETORF P S N02 1 XFILIAL("N02")+M->N01_LOGRAD S
N01_LOGRAD 006 SX5->X5_DESCRI N01_COMP1 P S SX5 1 XFILIAL("SX5")+"N1"+M->N01_DISTRI S
N01_LOGRAD 007 SX5->X5_DESCRI N01_COMP2 P S SX5 1 XFILIAL("SX5")+"N2"+M->N01_SETOR S
N01_LOGRAD 008 SX5->X5_DESCRI N01_COMP3 P S SX5 1 XFILIAL("SX5")+"N3"+M->N01_QUADRA S
N01_LOGRAD 009 SX5->X5_DESCRI N01_COMP6 P S SX5 1 XFILIAL("SX5")+"N1"+M->N01_SETORF S
N01_LOTE 001 SX5->X5_DESCRI N01_COMP4 P S SX5 1 XFILIAL("SX5")+"N4"+M->N01_LOTE S
N01_OCUPAC 001 SX5->X5_DESCRI N01_COMP11 P S SX5 1 XFILIAL("SX5")+"N7"+M->N01_OCUPAC S
N01_PROFA 001 (M->N01_PROFA+M->N01_PROFB)/2 N01_PROF P N N01 1 XFILIAL("N01")+M->N01_PROFA S
N01_PROFA 002 ((M->N01_TESTAD+M->N01_FUNDO)/2)*M->N01_PROF N01_AREA P N N01 1 XFILIAL("N01")+M->N01_PROFA S
N01_PROFA 003 N02->N02_VLRTER * M->N01_AREA N01_VLRTER P S N02 1 XFILIAL("N02") + M->N01_LOGRAD S
N01_PROFB 001 (M->N01_PROFA+M->N01_PROFB)/2 N01_PROF P N N01 1 XFILIAL("N01")+M->N01_PROFB S
N01_PROFB 002 ((M->N01_TESTAD+M->N01_FUNDO)/2)*M->N01_PROF N01_AREA P N N01 1 XFILIAL("N01")+M->N01_PROFB S
N01_PROFB 003 N02->N02_VLRTER * M->N01_AREA N01_VLRTER P S N02 1 XFILIAL("N02") + M->N01_LOGRAD S
N01_PROPRI 001 SA1->A1_NOME N01_COMP8 P S SA1 1 XFILIAL("SA1")+M->N01_PROPRI S
N01_QUADRA 001 SX5->X5_DESCRI N01_COMP3 P S SX5 1 XFILIAL("SX5")+"N3"+M->N01_QUADRA S
N01_SETOR 001 SX5->X5_DESCRI N01_COMP2 P S SX5 1 XFILIAL("SX5")+"N2"+M->N01_SETOR S
N01_SETORF 001 SX5->X5_DESCRI N01_COMP6 P S SX5 1 XFILIAL("SX5")+"N6"+M->N01_SETORF S
N01_SUBLOT 001 SX5->X5_DESCRI N01_COMP5 P S SX5 1 XFILIAL("SX5")+"N5"+M->N01_SUBLOT S
N01_TESTAD 001 ((M->N01_TESTAD+M->N01_FUNDO)/2)*M->N01_PROF N01_AREA P N N01 1 XFILIAL("N01")+M->N01_TESTAD S
N01_TESTAD 002 N02->N02_VLRTER * M->N01_AREA N01_VLRTER P S N02 1 XFILIAL("N02") + M->N01_LOGRAD S
N01_TIPOCO 001 SX5->X5_DESCRI N01_COMP12 P S SX5 1 XFILIAL("SX5")+"NA"+M->N01_TIPOCO S
N01_UTILIZ 001 SX5->X5_DESCRI N01_COMP9 P S SX5 1 XFILIAL("SX5") + "N8" + M->N01_UTILIZ 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
N01 001 N33 N01_COD N33_IMOVEL S 1 1 S S 2 2
N01 002 N00 N01_COD N00_COD S 1 1 S S 2 2
N01 003 N00 N01_FILHA N00_FILHA S 1 1 S S 2 2
N01 004 SE1 N01_COD E1_CODIMOV S 1 N S S 2 2
N01 005 N04 N01_COD N04_CODPRO 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
033 Tamanho da Filial Tamano de la Sucursal Branch Size 12 2 2

 

 

 

 

 

 

 

 

 

 

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