Tabela
N02 Logradouros
Campo Tipo Tamanho Decimal Titulo Formato Validacao F3 Contexto Lista Condicao PYME
N02_FILIAL C 2 0 Filial N
N02_COD C 6 0 Codigo @! Existchav("N02",M->N02_COD,1) R N
N02_DESCRI C 40 0 Descricao @! R N
N02_DISTRI C 2 0 Distrito @! Existcpo("SX5","N1"+M->N02_DISTRI) N1 R N
N02_COMP1 C 30 0 Desc. Distr. @! R N
N02_BAI C 2 0 Bairro @! Existcpo("SX5","NB"+M->N02_BAI) NB R N
N02_COMP2 C 30 0 Desc. Bairro @! R N
N02_SETOR C 2 0 Setor @! Existcpo("SX5","N2"+M->N02_SETOR) N2 R N
N02_COMP3 C 30 0 Desc. Setor @! R N
N02_QUADRA C 2 0 Quadra @! Existcpo("SX5","N3"+M->N02_QUADRA) N3 R N
N02_CLI C 1 0 Coleta Lixo @! S=Sim;N=Nao N
N02_COMP4 C 30 0 Desc. Quadra @! R N
N02_SFI C 2 0 Setor Fiscal @! Existcpo("SX5","N6"+M->N02_SFI) N6 R N
N02_COMP5 C 30 0 Desc. S.Fisc @! R N
N02_VLRCON N 11 2 Vlr m¦ Const 9999999.99 R N
N02_VLRTER N 11 2 Vlr m¦ Ter 9999999.99 R N
N02_CEP C 9 0 Cep 99999-999 R N
N02_AGU C 1 0 Agua @! R S=Sim;N=Nao N
N02_EGC C 1 0 Esg. Cloacal @! R S=Sim;N=Nao N
N02_EGF C 1 0 Esg. Fluvial @! R S=Sim;N=Nao N
N02_ENE C 1 0 Energia Elet @! R S=Sim;N=Nao N
N02_ILU C 1 0 Iluminacao @! R S=Sim;N=Nao N
N02_LIU C 1 0 Limp. Urbana @! R S=Sim;N=Nao N
N02_MFI C 1 0 Meio Fio @! R S=Sim;N=Nao N
N02_PAV C 1 0 Pavimentacao @! R S=Sim;N=Nao N
N02_LOCX C 9 0 Carteziano X @! R N
N02_LOCY C 9 0 Carteziano Y @! R N
N02_LOCZ C 9 0 Carteziano Z @! R N
N02_NUMINI C 7 0 Num Inicial R S
N02_NUMFIM C 7 0 Num.Final M->N02_NUMFIM >= M->N02_NUMINI R S