Tabela |
N01 |
Imovel |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
N01_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
N |
N01_COD |
C |
12 |
0 |
Codigo |
@! |
Existchav("N01",M->N01_COD+M->N01_FILHA,9) |
|
R |
|
|
N |
N01_FILHA |
C |
2 |
0 |
Constr.Filha |
|
Existchav("N01",M->N01_COD+M->N01_FILHA,9) |
|
R |
|
|
N |
N01_NUMERO |
C |
10 |
0 |
Numero |
|
|
|
R |
|
|
N |
N01_PATRIM |
C |
1 |
0 |
Patrimonio |
@! |
|
|
R |
1=Publico;2=Particular;3=Religioso |
|
N |
N01_PROPRI |
C |
6 |
0 |
Contribuinte |
@! |
Existcpo("SA1") |
SA1 |
R |
|
|
N |
N01_COMP8 |
C |
30 |
0 |
Nome |
@! |
|
|
R |
|
|
N |
N01_LOGRAD |
C |
6 |
0 |
Logradouro |
@! |
existcpo("N02") |
N02 |
R |
|
|
N |
N01_COMP7 |
C |
30 |
0 |
Desc.Lograd. |
@! |
|
|
R |
|
|
N |
N01_DISTRI |
C |
2 |
0 |
Distrito |
@! |
Existcpo("SX5","N1"+M->N01_DISTRI) |
N1 |
R |
|
|
N |
N01_COMP1 |
C |
30 |
0 |
Desc.Distrit |
@! |
|
|
R |
|
|
N |
N01_SETOR |
C |
2 |
0 |
Setor |
@! |
Existcpo("SX5","N2"+M->N01_SETOR) |
N2 |
R |
|
|
N |
N01_COMP2 |
C |
30 |
0 |
Desc.Setor |
@! |
|
|
R |
|
|
N |
N01_QUADRA |
C |
2 |
0 |
Quadra |
@! |
Existcpo("SX5","N3"+M->N01_QUADRA) |
N3 |
R |
|
|
N |
N01_COMP3 |
C |
30 |
0 |
Desc.Quadra |
@! |
|
|
R |
|
|
N |
N01_SETORF |
C |
2 |
0 |
Setor Fiscal |
@! |
Existcpo("SX5","N6"+M->N01_SETORF) |
N6 |
R |
|
|
N |
N01_COMP6 |
C |
30 |
0 |
Desc.S.Fisca |
@! |
|
|
R |
|
|
N |
N01_LOTE |
C |
2 |
0 |
Lote |
@! |
Existcpo("SX5","N4"+M->N01_LOTE) |
N4 |
R |
|
|
N |
N01_COMP4 |
C |
30 |
0 |
Desc.Lote |
@! |
|
|
R |
|
|
N |
N01_SUBLOT |
C |
2 |
0 |
SubLote |
@! |
Existcpo("SX5","N5"+M->N01_SUBLOT) |
N5 |
R |
|
|
N |
N01_COMP5 |
C |
30 |
0 |
Desc.SubLote |
@! |
|
|
R |
|
|
N |
N01_OCUPAC |
C |
2 |
0 |
Ocupacao |
@! |
Existcpo("SX5","N7"+M->N01_OCUPAC) |
N7 |
R |
|
|
N |
N01_COMP11 |
C |
30 |
0 |
Desc.Ocupac |
@! |
|
|
R |
|
|
N |
N01_IMPOST |
C |
1 |
0 |
Imposto |
@! |
|
|
R |
1=Predial;2=Territorial;3=Ambos |
|
N |
N01_UTILIZ |
C |
2 |
0 |
Util Imovel |
@! |
Existcpo("SX5","N8"+M->N01_UTILIZ) |
N8 |
R |
|
|
N |
N01_COMP9 |
C |
30 |
0 |
Desc.U.Imov. |
@! |
|
|
R |
|
|
N |
N01_LIMIT |
C |
1 |
0 |
Limitacao |
@! |
|
|
R |
1=Com/Cerca/Muro;2=Sem/Cerca/Muro |
|
N |
N01_USO |
C |
1 |
0 |
Uso |
@! |
|
|
R |
1=Nao Proprio;2=Proprio |
|
N |
N01_TRIBUT |
C |
1 |
0 |
Tributacao |
@! |
|
|
R |
1=N. Imune/Isento;2=Imune;3=Isento |
|
N |
N01_TOPOGR |
C |
1 |
0 |
Topografia |
@! |
|
|
R |
1=Plano;2=Aclive;3=Declive;4=Irrigado |
|
N |
N01_INFO |
C |
2 |
0 |
Informacoes |
@! |
Existcpo("SX5","N9"+M->N01_INFO) |
N9 |
R |
|
|
N |
N01_COMP10 |
C |
30 |
0 |
Desc.Inform. |
@! |
|
|
R |
|
|
N |
N01_PEDOL |
C |
1 |
0 |
Pedologia |
@! |
|
|
R |
1=Inundavel;2=Firme;3=Alagado;4=Combinacoo |
|
N |
N01_TESTAD |
N |
9 |
2 |
Testada |
999999.99 |
|
|
R |
|
|
N |
N01_FUNDO |
N |
9 |
2 |
Fundo |
999999.99 |
|
|
R |
|
|
N |
N01_PROFA |
N |
9 |
2 |
Profund A |
999999.99 |
|
|
R |
|
|
N |
N01_PROFB |
N |
9 |
2 |
Profund B |
999999.99 |
|
|
R |
|
|
N |
N01_PROF |
N |
9 |
2 |
Prof Media |
999999.99 |
|
|
R |
|
|
N |
N01_AREA |
N |
9 |
2 |
Area do Lote |
999999.99 |
|
|
R |
|
|
N |
N01_AREACO |
N |
9 |
2 |
Area Const |
999999.99 |
|
|
R |
|
|
N |
N01_TIPOCO |
C |
2 |
0 |
Tipo Const |
@! |
Existcpo("SX5","NA"+M->N01_TIPOCO) |
NA |
R |
|
|
N |
N01_COMP12 |
C |
30 |
0 |
Desc.Contruc |
@! |
|
|
R |
|
|
N |
N01_ALINHA |
C |
1 |
0 |
Alinhamento |
@! |
|
|
R |
1=Alinhado;2=Recuado |
|
N |
N01_POSIC |
C |
1 |
0 |
Posicao |
@! |
|
|
R |
1=Isolada;2=Conjugada;3=Germinada |
|
N |
N01_SITUAC |
C |
1 |
0 |
Sit da Const |
@! |
|
|
R |
1=Frente;2=Fundos |
|
N |
N01_ESTRUT |
C |
1 |
0 |
Estrutura |
@! |
|
|
R |
1=Alvenaria;2=Madeira;3=Metalica;4=Concreto |
|
N |
N01_COBERT |
C |
1 |
0 |
Cobertura |
@! |
|
|
R |
1=Zinco;2=Fibra Cim;3=Telha Barro;4=Lage;5=Especial |
|
N |
N01_PAREDE |
C |
1 |
0 |
Paredes |
@! |
|
|
R |
1=Sem;2=Taipa;3=Alvenaria;4=Concreto;5=Madeira |
|
N |
N01_FORRO |
C |
1 |
0 |
Forro |
@! |
|
|
R |
1=Sem;2=Tabua;3=Estoque;4=Laje;5=Chapas |
|
N |
N01_REVEST |
C |
1 |
0 |
Revestimento |
@! |
|
|
R |
1=Sem;2=Reboco;3=Metalico;4=Madeira;5=Especial |
|
N |
N01_INSTAL |
C |
1 |
0 |
Inst Sanit |
@! |
|
|
R |
1=Sem;2=Externa;3=Simples;4=Composta;5=Completa |
|
N |
N01_INSTEL |
C |
1 |
0 |
Instal Elet. |
@! |
|
|
R |
1=Sem;2=Aparente;3=Embutida |
|
N |
N01_PISO |
C |
1 |
0 |
Pisos |
@! |
|
|
R |
1=Terra Batida;2=Cimento;3=Ceramica;4=Tabuas;5=Tacos;6=M. Plasticos;7=Especial |
|
N |
N01_ESTCON |
C |
1 |
0 |
Estado Cons |
@! |
|
|
R |
1=Otimo;2=Bom;3=Regular;4=Ruim |
|
N |
N01_OPCION |
C |
1 |
0 |
Info Opcion |
@! |
|
|
R |
1=C/ Passeio;2=S/ Passeio;3=C/ Pavimentacoo;4=S/ Pavimentacoo |
|
N |
N01_IMOVEL |
C |
1 |
0 |
Util Imovel |
@! |
|
|
R |
1=Ocupado;2=Locado;3=Cedido;4=Desocupado |
|
N |
N01_DATA |
D |
8 |
0 |
Dt Construc. |
|
|
|
R |
|
|
N |
N01_VLRTER |
N |
11 |
2 |
Vlr Terreno |
@e 99999999.99 |
|
|
R |
|
|
N |
N01_VLRPRE |
N |
11 |
2 |
Vlr Predio |
@e 9999999.99 |
|
|
R |
|
|
N |
N01_TITULO |
C |
6 |
0 |
Titulo |
|
|
|
R |
|
|
N |
N01_PREFIX |
C |
3 |
0 |
Prefixo |
|
|
|
R |
|
|
N |
N01_DTEMIS |
D |
8 |
0 |
Dt Emissao |
|
|
|
R |
|
|
N |
N01_DTNOT |
D |
8 |
0 |
Dt Notificac |
|
|
|
R |
|
|
N |
N01_NOTIFI |
N |
1 |
0 |
N.de Notific |
9 |
|
|
R |
|
|
N |
N01_JANOTI |
C |
1 |
0 |
Ja Notificad |
! |
PERTENCE("SN") |
|
R |
|
|
N |
N01_ATIVO |
C |
1 |
0 |
Ativo/Inativ |
! |
|
|
R |
A=Ativo;I=Inativo |
|
N |
N01_CODPAI |
C |
12 |
0 |
Imovel Pai |
|
|
|
R |
|
|
N |
N01_IMPRES |
N |
1 |
0 |
Impr.Notific |
|
|
|
|
|
|
N |
N01_TPTERR |
C |
1 |
0 |
Tipo Terreno |
|
|
|
R |
1=Em edificacao;2=Edificado;3=Const.Condenada;4=Com Demolicao;5=Ruinas |
|
N |
N01_TERBAL |
C |
1 |
0 |
Terr. Baldio |
|
|
|
R |
1=Limpo;2=Sujo/Periferia;3=Sujo/Centro;4=Murado;5=Nao Murado;6=Cultivado/Arborizado |
|
N |
N01_AREATO |
N |
9 |
2 |
Area Total |
@E 9999,999.99 |
|
|
R |
|
|
N |
N01_PASSEI |
C |
1 |
0 |
Passeio |
9 |
|
|
R |
1=Sim;2=Nao |
|
N |
N01_PAV |
C |
1 |
0 |
Pavimentacao |
9 |
|
|
R |
1=Sim;2=Nao |
|
N |
N01_LIU |
C |
1 |
0 |
Limpeza Urb. |
9 |
|
|
|
1=Sim;2=Nao |
|
N |
N01_CLI |
C |
1 |
0 |
Coleta Lixo |
9 |
|
|
R |
1=Sim;2=Nao |
|
N |
N01_EGC |
C |
1 |
0 |
Esgoto Cloac |
9 |
|
|
R |
1=Sim;2=Nao |
|
N |
N01_ENE |
C |
1 |
0 |
Energia Publ |
9 |
|
|
R |
1=Sim;2=Nao |
|
N |
N01_AGU |
C |
1 |
0 |
Agua |
9 |
|
|
R |
1=Sim;2=Nao |
|
N |
N01_EGF |
C |
1 |
0 |
Esgoto Fluv. |
9 |
|
|
R |
1=Sim;2=Nao |
|
N |
N01_VLRALI |
N |
5 |
2 |
Vlr Aliquota |
@e 99.99 |
|
|
R |
|
|
N |