Tabela |
BJM |
Estipulantes |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
BJM_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
BJM_APOLIC |
C |
12 |
0 |
Apolice |
@! |
ExistChav("BJM",M->BJM_APOLIC,1) |
|
|
|
|
S |
BJM_CODINT |
C |
4 |
0 |
Operadora |
@! |
PLSVLDINT(M->BJM_CODINT) .And. ExistChav("BJM",M->BJM_CODINT+M->BJM_CODIGO,2) |
B89PLS |
|
|
|
S |
BJM_DESINT |
C |
30 |
0 |
Descricao |
@! |
|
|
V |
|
|
S |
BJM_CODIGO |
C |
4 |
0 |
Codigo |
@! |
PLSZERO() .And. ExistChav("BJM",M->BJM_CODINT+M->BJM_CODIGO,1) |
|
|
|
|
S |
BJM_DESCRI |
C |
30 |
0 |
Razao Social |
@! |
|
|
|
|
|
S |
BJM_ENDCLI |
C |
1 |
0 |
End. Cliente |
@! |
|
|
|
0=Nao;1=Sim |
|
S |
BJM_CODCLI |
C |
6 |
0 |
Cod.Cliente |
@! |
ExistCpo("SA1",M->BJM_CODCLI+M->BJM_CODLOJ,1) |
SA1 |
|
|
|
S |
BJM_CODLOJ |
C |
2 |
0 |
Loja |
@! |
|
|
|
|
|
S |
BJM_CNPJ |
C |
20 |
0 |
CNPJ |
@R 999.999.999/9999-99 |
Vazio().Or.(Existchav("BJM",M->BJM_CNPJ,3,"BJM_CNPJ").AND.CGC(M->BJM_CNPJ)) |
|
|
|
|
S |
BJM_CEP |
C |
8 |
0 |
CEP |
@R 99999-999 |
|
B83PLS |
|
|
|
S |
BJM_EST |
C |
2 |
0 |
UF |
@! |
ExistCpo("SX5","12"+M->BJM_EST) |
12 |
|
|
|
S |
BJM_MUN |
C |
20 |
0 |
Municipio |
@! |
|
|
|
|
|
S |
BJM_BAIRRO |
C |
30 |
0 |
Bairro |
@! |
|
|
|
|
|
S |
BJM_END |
C |
40 |
0 |
Endereco |
@! |
|
|
|
|
|
S |
BJM_NR_END |
C |
6 |
0 |
Numero |
@! |
|
|
|
|
|
S |
BJM_COMEND |
C |
30 |
0 |
Complemento |
@! |
|
|
|
|
|
S |
BJM_TEL |
C |
30 |
0 |
Telefone |
@R (99)99999-9999 |
|
|
|
|
|
S |
BJM_FAX |
C |
15 |
0 |
FAX |
@! |
|
|
|
|
|
S |
BJM_INIVIG |
D |
8 |
0 |
Dt. Ini Vig. |
@D |
|
|
|
|
|
S |
BJM_ANIVER |
C |
4 |
0 |
Aniv.Apolic. |
@R 99/99 |
|
|
|
|
|
S |
BJM_REAJUS |
C |
4 |
0 |
Reaj. Moeda |
@R 99/99 |
|
|
|
|
|
S |
BJM_CONFUN |
C |
1 |
0 |
Contribut. |
@! |
|
|
|
0=Nao;1=Sim |
|
S |
BJM_NUMVID |
N |
10 |
0 |
Numero Vidas |
9999999999 |
|
|
|
|
|
S |
BJM_FATMOD |
C |
1 |
0 |
Fator Moder. |
@! |
|
|
|
0=Nao;1=Sim |
|
S |
BJM_DENTAL |
C |
1 |
0 |
Dental |
@! |
|
|
|
0=Nao;1=Sim |
|
S |
BJM_REMISA |
C |
1 |
0 |
Remissao |
@! |
|
|
|
0=Nao;1=Sim |
|
S |
BJM_TXCART |
C |
1 |
0 |
Taxa Cart. |
@! |
|
|
|
0=Nao;1=Sim |
|
S |
BJM_VLRUS |
N |
10 |
0 |
Valor de US |
@E 999,999.99 |
|
|
|
|
|
S |
BJM_CONREL |
C |
1 |
0 |
Conc.Relamp. |
@! |
|
|
R |
1=Sim;2=Nao |
|
S |
BJM_CONMAT |
C |
1 |
0 |
Conc.Matriz |
@! |
|
|
R |
1=Sim;2=Nao |
|
S |
BJM_CONCOM |
C |
6 |
0 |
Cons.Comerc. |
@! |
|
|
|
|
|
S |
BJM_NOCCOM |
C |
40 |
0 |
Nome Cons.CM |
@! |
|
|
V |
|
|
S |
BJM_CONPVE |
C |
6 |
0 |
Cons.Pos Vnd |
@! |
|
|
|
|
|
S |
BJM_NOCPVE |
C |
40 |
0 |
Nome Cons.PV |
@! |
|
|
V |
|
|
S |
BJM_CONTEC |
C |
6 |
0 |
Cons.Tecnico |
@! |
|
|
|
|
|
S |
BJM_NOCTEC |
C |
40 |
0 |
Nome Cons.TC |
@! |
|
|
V |
|
|
S |
BJM_SUPTEC |
C |
6 |
0 |
Superv. Tec. |
@! |
|
|
|
|
|
S |
BJM_MESREA |
C |
8 |
0 |
Meses Reav. |
@R 99/99/99/99 |
|
|
|
|
|
S |
BJM_LIMTEC |
N |
3 |
0 |
Limite tec. |
999 |
|
|
|
|
|
S |
BJM_COBERT |
M |
100 |
0 |
Observacao |
@! |
|
|
|
|
|
S |