| Tabela |
| NYP |
Acordos |
| Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
| NYP_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
| NYP_CAJURI |
C |
10 |
0 |
Cod Ass Jur |
|
ExistCpo('NSZ',M-> NYP_CAJURI,1) |
|
R |
|
|
S |
| NYP_COD |
C |
10 |
0 |
Codigo |
|
ExistChav('NYP', M->NYP_CAJURI+M->NYP_COD,1) |
|
R |
|
|
S |
| NYP_DATA |
D |
8 |
0 |
Data |
|
|
|
R |
|
|
S |
| NYP_CMOEDA |
C |
2 |
0 |
Moeda |
|
Vazio().Or.(ExistCpo('CTO',M->NYP_CMOEDA,1).AND.(JAVLDCAMPO('NYPDETAIL','NYP_CMOEDA','CTO','CTO_BLOQ','2'))) |
JURCTO |
R |
|
|
S |
| NYP_DMOEDA |
C |
10 |
0 |
Simb Moeda |
|
|
|
V |
|
|
S |
| NYP_VALOR |
N |
12 |
2 |
Valor |
@E 999,999,999.99 |
Positivo() |
|
R |
|
|
S |
| NYP_CONDPG |
C |
3 |
0 |
Cond Pgto |
|
Vazio().Or. ExistCpo("SE4") |
SE4 |
R |
|
|
S |
| NYP_QTPARC |
N |
3 |
0 |
Qtde Parcela |
@E 999 |
|
|
R |
|
|
S |
| NYP_CBANCO |
C |
3 |
0 |
Cod Banco |
@! |
Vazio().or.ExistCpo("SA6",M->NYP_CBANCO,1) |
SA6 |
R |
|
|
S |
| NYP_CAGENC |
C |
5 |
0 |
Cod Agencia |
@! |
Vazio().OR.ExistCpo("SA6",FWFLDGET("NYP_CBANCO")+FWFLDGET("NYP_CAGENC"),1) |
|
R |
|
|
S |
| NYP_CCONTA |
C |
10 |
0 |
Cod Conta |
@! |
Vazio().OR.ExistCpo("SA6",FWFLDGET("NYP_CBANCO")+FWFLDGET("NYP_CAGENC")+FWFLDGET("NYP_CCONTA"),1) |
|
R |
|
|
S |
| NYP_DBANCO |
C |
40 |
0 |
Nome Banco |
|
|
|
V |
|
|
S |
| NYP_DAGENC |
C |
40 |
0 |
Nome Agencia |
|
|
|
V |
|
|
S |
| NYP_DATALI |
D |
8 |
0 |
Data Limite |
|
|
|
R |
|
|
S |
| NYP_TIPO |
C |
1 |
0 |
Tipo |
|
Vazio().Or.Pertence('12') |
|
R |
1=Proposta;2=Contra Proposta |
|
S |
| NYP_REALIZ |
C |
1 |
0 |
Realizado? |
|
Vazio().Or.Pertence('12') |
|
R |
1=Sim;2=Nao |
|
S |
| NYP_OBSERV |
M |
10 |
0 |
Observacao |
|
|
|
R |
|
|
S |
| NYP_CCONT |
C |
6 |
0 |
Cod Contato |
|
ExistCpo("SU5",M->NYP_CCONT) .And. (Posicione('SU5',1,xFilial('SU5')+M->NYP_CCONT,'U5_ATIVO') == "1") |
SU5JUR |
R |
|
|
S |
| NYP_DCONT |
C |
30 |
0 |
Nome Contato |
|
|
|
V |
|
|
S |
| NYP_FONE |
C |
15 |
0 |
Telefone |
|
|
|
R |
|
|
S |
| NYP_EMAIL |
C |
40 |
0 |
E-mail |
|
|
|
R |
|
|
S |
| NYP_CSTATU |
C |
3 |
0 |
Cod Status |
|
Vazio().Or.(ExistCpo('NYQ',M->NYP_CSTATU,1) .And.JurVldRest('NYQ',M->NYP_CSTATU)) |
NYQ |
R |
|
|
S |
| NYP_DSTATU |
C |
40 |
0 |
Desc Status |
|
|
|
V |
|
|
S |
| NYP_DATAIN |
D |
8 |
0 |
Dt Inclusao |
|
|
|
R |
|
|
S |
| NYP_USUIN |
C |
15 |
0 |
Usu Inclusao |
|
|
|
R |
|
|
S |
| NYP_DATAAL |
C |
8 |
0 |
Dt alteracao |
|
|
|
R |
|
|
S |
| NYP_USUAL |
C |
15 |
0 |
Usu Alteraca |
|
|
|
R |
|
|
S |
| NYP_DATALT |
D |
8 |
0 |
Dt.Alteracao |
|
|
|
|
|
|
S |
