Tabela |
NT9 |
Envolvidos |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
NT9_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
R |
|
|
N |
NT9_CAJURI |
C |
10 |
0 |
Cod Ass Jur |
|
ExistCpo('NSZ',M->NT9_CAJURI,1).Or.Vazio() |
|
R |
|
|
N |
NT9_COD |
C |
10 |
0 |
Codigo |
|
ExistChav('NT9',M->NZS_COD+M->NT9_COD,1) |
|
R |
|
|
N |
NT9_ENTIDA |
C |
3 |
0 |
Entidade Or |
|
J105ValEnt() |
NT9ENT |
R |
|
|
S |
NT9_CODENT |
C |
18 |
0 |
Cod. Entida |
|
|
|
R |
|
|
S |
NT9_TIPOCL |
C |
1 |
0 |
Cliente? |
|
Pertence("12") |
|
R |
1=Sim;2=Nao |
FwFldGet('NT9_TFORNE') == '2' |
N |
NT9_PRINCI |
C |
1 |
0 |
Principal? |
|
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
N |
NT9_TFORNE |
C |
1 |
0 |
Fornecedor? |
|
Pertence('12').Or.Vazio() |
|
R |
1=Sim;2=Nao |
FwFldGet('NT9_TIPOCL') == '2' |
S |
NT9_DENTID |
C |
20 |
0 |
Desc Entidad |
@S20 |
|
|
V |
|
|
N |
NT9_TIPOEN |
C |
1 |
0 |
Polo |
|
Pertence("123456") |
|
R |
1=Polo Ativo;2=Polo Passivo;3=Terceiro Interessado;4=Sociedade Envolvida;5=Participacao Societaria;6=Administracao |
|
N |
NT9_ISENTO |
C |
1 |
0 |
Isento Anuid |
|
PERTENCE("12") |
|
R |
1=Sim;2=Nao |
|
N |
NT9_CTPENV |
C |
2 |
0 |
Cod Tipo Env |
|
ExistCpo('NQA',M->NT9_CTPENV,1).And.JURA105TE2().And.JurVldRest('NQA',M->NT9_CTPENV) |
NQANT9 |
R |
|
|
N |
NT9_DTPENV |
C |
50 |
0 |
Tipo Envolv |
@S30 |
|
|
V |
|
|
N |
NT9_CEMPCL |
C |
6 |
0 |
Cliente |
@! |
Vazio() .Or. (J063VldNT9("NT9_CEMPCL") .And.JA105VLCLI()) |
SA1NT9 |
R |
|
J105NT9Cli() |
N |
NT9_LOJACL |
C |
2 |
0 |
Loja |
@! |
Vazio() .Or. J063VldNT9("NT9_LOJACL") |
|
R |
|
J105NT9Cli() |
N |
NT9_NOME |
C |
100 |
0 |
Nome |
@S50 |
|
|
R |
|
|
N |
NT9_CFORNE |
C |
6 |
0 |
Cod Forneced |
@! |
Vazio() .OR. ExistCpo('SA2', M->NT9_CFORNE,,,, .F.) |
JURSA2 |
R |
|
J105NT9For() |
S |
NT9_LFORNE |
C |
2 |
0 |
Loja Fornece |
@! |
Vazio() .OR. ExistCpo('SA2', FwFldGet('NT9_CFORNE') +FwFldGet('NT9_LFORNE'),1,,, .F.) |
|
R |
|
J105NT9For() |
S |
NT9_RESP |
C |
1 |
0 |
Resp Vlr En? |
|
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
N |
NT9_DTNASC |
D |
8 |
0 |
Dt Nasc |
|
|
|
R |
|
|
N |
NT9_TIPOP |
C |
1 |
0 |
Tipo Pessoa |
|
Pertence("12") |
|
R |
1=Fisica;2=Juridica |
|
N |
NT9_CGC |
C |
14 |
0 |
CNPJ/CPF |
|
Vazio().OR.(CGC(M->NT9_CGC).AND.JURA105FUN()) |
|
R |
|
|
N |
NT9_DTADM |
D |
8 |
0 |
Dt Admissao |
|
|
|
R |
|
|
N |
NT9_DTDEMI |
D |
8 |
0 |
Dt Demissao |
|
|
|
R |
|
|
N |
NT9_CADVPC |
C |
3 |
0 |
Cod Adv Pt C |
|
(ExistCpo('NRS',M->NT9_CADVPC,1).And.JurVldRest('NRS',M->NT9_CADVPC)).OR.Vazio() |
NRS |
R |
|
|
N |
NT9_DADVPC |
C |
200 |
0 |
Des Adv Pt C |
@S50 |
|
|
V |
|
|
N |
NT9_NUMAP |
C |
30 |
0 |
Num Apolice |
|
|
|
R |
|
|
N |
NT9_DDD |
C |
3 |
0 |
DDD |
999 |
|
|
R |
|
|
N |
NT9_TELEFO |
C |
20 |
0 |
Telefone |
|
|
|
R |
|
|
N |
NT9_EMAIL |
C |
50 |
0 |
E-mail Envia |
|
|
|
R |
|
|
N |
NT9_CTPS |
C |
20 |
0 |
Cart.Profis. |
@R 999.999 |
|
|
R |
|
|
N |
NT9_SERIE |
C |
5 |
0 |
Serie Cart. |
99999 |
|
|
R |
|
|
N |
NT9_PIS |
C |
15 |
0 |
Numero PIS |
|
|
|
R |
|
|
N |
NT9_CCRGDP |
C |
5 |
0 |
Cod Cargo F |
|
Vazio().OR.( ExistCpo('SQ3',M->NT9_CCRGDP,1)) |
SQ3_01 |
R |
|
|
N |
NT9_DCRGDP |
C |
30 |
0 |
Des Cargo F |
|
|
|
V |
|
|
N |
NT9_CFUNDP |
C |
5 |
0 |
Cod Funcao F |
|
ExistCpo('SRJ',M->NT9_CFUNDP,1).OR.Vazio() |
JURSRJ |
R |
|
|
N |
NT9_DFUNDP |
C |
20 |
0 |
Desc Funcao |
|
|
|
V |
|
|
N |
NT9_CLTDP |
C |
5 |
0 |
Cod Loc Tr F |
|
ExistCpo('NS7',M->NT9_CLTDP,1).OR.Vazio() |
NS7 |
R |
|
|
N |
NT9_DLTDP |
C |
100 |
0 |
Des Loc Tr F |
|
|
|
V |
|
|
N |
NT9_OBSERV |
M |
10 |
0 |
Observacao |
|
|
|
R |
|
|
N |
NT9_CCGECL |
C |
4 |
0 |
Cod Cargo |
|
(ExistCpo('NRP',M->NT9_CCGECL,1).AND.JA105VNRP()).OR.Vazio() |
NRP1 |
R |
|
|
N |
NT9_DCGECL |
C |
50 |
0 |
Desc Cargo |
|
|
|
V |
|
|
N |
NT9_CFUNCL |
C |
4 |
0 |
Cod Funcao |
|
VAZIO().OR.(ExistCpo('NS6',M->NT9_CFUNCL,1).AND.JA105VNS6().AND.JurVldRest('NS6',M->NT9_CFUNCL)) |
NS61 |
R |
|
|
N |
NT9_DFUNCL |
C |
50 |
0 |
Des Loc Trab |
|
|
|
V |
|
|
N |
NT9_CLOCTR |
C |
5 |
0 |
Cod Loc T Cl |
|
VAZIO().OR.(ExistCpo('NTB',M->NT9_CLOCTR,1).AND.JURA105NTB().AND.JurVldRest('NTB',M->NT9_CLOCTR)) |
NTB |
R |
|
|
N |
NT9_DLOCTR |
C |
50 |
0 |
Des Loc T Cl |
|
|
|
V |
|
|
N |
NT9_DDDCLI |
C |
3 |
0 |
DDD Cliente |
|
|
|
R |
|
|
N |
NT9_TELECL |
C |
15 |
0 |
Tel Cliente |
|
|
|
R |
|
|
N |
NT9_ENDECL |
C |
80 |
0 |
End Cliente |
|
|
|
R |
|
|
N |
NT9_BAIRRO |
C |
30 |
0 |
Bairro |
|
|
|
R |
|
|
S |
NT9_ESTADO |
C |
2 |
0 |
UF |
|
Vazio() .OR. ExistCpo("SX5","12"+M->NT9_ESTADO) |
JUR12 |
R |
|
|
S |
NT9_CMUNIC |
C |
5 |
0 |
Cod. Munic. |
|
Vazio() .OR. (J063VldNT9("NT9_CMUNIC") ) |
CC2NT9 |
R |
|
|
S |
NT9_DMUNIC |
C |
60 |
0 |
Desc. Munic. |
|
|
|
V |
|
|
S |
NT9_CEP |
C |
8 |
0 |
CEP |
@R 99999-999 |
|
|
R |
|
|
S |
NT9_EMAICL |
C |
30 |
0 |
E-mail Clien |
|
|
|
R |
|
|
N |
NT9_CNOMEA |
C |
1 |
0 |
Nome Con PA |
|
|
|
R |
|
|
S |
NT9_CNOMEP |
C |
1 |
0 |
Nome Con PP |
|
|
|
R |
|
|
S |
NT9_DTSAID |
D |
8 |
0 |
Data Saida |
|
|
|
R |
|
|
S |
NT9_CNOMET |
C |
1 |
0 |
Nome Con TI |
|
|
|
R |
|
|
S |
NT9_RG |
C |
15 |
0 |
RG |
|
|
|
R |
|
|
S |
NT9_INSCR |
C |
18 |
0 |
Ins Estadual |
|
|
|
R |
|
|
S |
NT9_INSCRM |
C |
18 |
0 |
Ins Municip. |
|
|
|
R |
|
|
S |
NT9_NIRE |
C |
11 |
0 |
NIRE |
|
|
|
R |
|
|
S |
NT9_CNACIO |
C |
2 |
0 |
Nacionalidad |
|
|
JUR34 |
R |
|
|
S |
NT9_DNACIO |
C |
60 |
0 |
Desc Naciona |
|
|
|
V |
|
|
S |
NT9_CESTCV |
C |
1 |
0 |
Estado Civil |
|
VAZIO() .OR. EXISTCPO("SX5","33"+M->NT9_CESTCV) |
JUR33 |
R |
|
|
S |
NT9_DESTCV |
C |
30 |
0 |
Desc Est Civ |
|
|
|
V |
|
|
S |
NT9_CNEGOC |
C |
3 |
0 |
Cod Negociac |
|
(ExistCpo('NXT',M->NT9_CNEGOC,1).And.JurVldRest('NXT',M->NT9_CNEGOC)) .OR. Vazio() |
NXT |
R |
|
|
S |
NT9_DNEGOC |
C |
50 |
0 |
Desc Negocia |
|
|
|
V |
|
|
S |
NT9_DATA |
D |
8 |
0 |
Data |
|
|
|
R |
|
|
S |
NT9_CMOEDA |
C |
2 |
0 |
Cod Moeda |
|
(ExistCpo('CTO',M->NT9_CMOEDA,1).AND.(JAVLDCAMPO('NT9DETAIL', 'NT9_CMOEDA', 'CTO', 'CTO_BLOQ', '2' ))).OR.Vazio() |
JURCTO |
R |
|
|
S |
NT9_DMOEDA |
C |
10 |
0 |
Desc Moeda |
|
|
|
V |
|
|
S |
NT9_PRECO |
N |
12 |
2 |
Preco |
@E 999,999,999.99 |
Positivo() |
|
R |
|
|
S |
NT9_QTPARC |
C |
3 |
0 |
Qtde Parcela |
|
|
|
R |
|
|
S |
NT9_DTENTR |
D |
8 |
0 |
Data Entrada |
|
|
|
R |
|
|
S |
NT9_CSITUA |
C |
3 |
0 |
Cod Situacao |
|
(ExistCpo("NXU",M->NT9_CSITUA,1).And.JurVldRest('NXU',M->NT9_CSITUA)).Or.Vazio() |
NXU |
R |
|
|
S |
NT9_DSITUA |
C |
50 |
0 |
Desc Situaca |
|
|
|
V |
|
|
S |
NT9_PERCAC |
N |
3 |
0 |
% Acoes/Quot |
@E 999 |
|
|
R |
|
|
S |
NT9_OAB |
C |
15 |
0 |
Num. da OAB |
|
|
|
R |
|
|
S |
NT9_ATOENT |
C |
30 |
0 |
Ato Entrada |
|
|
|
R |
|
|
S |
NT9_ATOSAI |
C |
30 |
0 |
Ato Saida |
|
|
|
R |
|
|
S |
NT9_TIPOQ |
C |
1 |
0 |
Tp Quot/Ac |
|
Vazio().Or.Pertence('12') |
|
R |
1=Ordinarias;2=Preferenciais |
|
S |
NT9_VLRUSA |
N |
16 |
2 |
Vlr Ult Sal |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
N |
NT9_PRATPR |
N |
5 |
2 |
% Rateio Pro |
@E 99.99 |
Entre(0,100) |
|
R |
|
|
S |
NT9_MATRIC |
C |
10 |
0 |
Matricula |
|
|
|
R |
|
|
S |
NT9_CDPENV |
C |
2 |
0 |
Cod Depto. |
|
Vazio().Or.ExistCpo("SX5","JZ"+M->NT9_CDPENV) |
JURJZ |
R |
|
|
S |
NT9_DDPENV |
C |
30 |
0 |
Departamento |
|
|
|
V |
|
|
S |