Tabela |
CNX |
Adiantamentos de Contrato |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
CNX_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
CNX_NUMERO |
C |
6 |
0 |
Num. Adiant. |
@! |
ExistChav("CNX") |
|
R |
|
|
S |
CNX_CONTRA |
C |
15 |
0 |
Cod Contrato |
@! |
ExistCpo("CN9") |
|
R |
|
|
S |
CNX_NUMMED |
C |
6 |
0 |
Num. Medicao |
@! |
ExistCpo("CND") |
|
R |
|
|
S |
CNX_FORNEC |
C |
6 |
0 |
Cod. Fornec |
@! |
ExistCpo("SA2") .And. VlCliForAd(FwFldGet('CN9_ESPCTR'),FwFldGet('CNX_FORNEC'),FwFldGet('CNX_LJFORN')) |
CNC001 |
R |
|
|
S |
CNX_LJFORN |
C |
2 |
0 |
Lj. Fornec |
@! |
VlCliForAd(FwFldGet('CN9_ESPCTR'),FwFldGet('CNX_FORNEC'),FwFldGet('CNX_LJFORN')) |
|
R |
|
|
S |
CNX_CLIENT |
C |
6 |
0 |
Cod. Cliente |
@! |
ExistCpo("SA1") .And. VlCliForAd(FwFldGet('CN9_ESPCTR'),FwFldGet('CNX_FORNEC'),FwFldGet('CNX_LJFORN')) |
CNC001 |
R |
|
|
S |
CNX_LOJACL |
C |
2 |
0 |
Lj. Cliente |
@! |
VlCliForAd(FwFldGet('CN9_ESPCTR'),FwFldGet('CNX_FORNEC'),FwFldGet('CNX_LJFORN')) |
|
R |
|
|
S |
CNX_BANCO |
C |
3 |
0 |
Banco |
@! |
CN300VldBc(a, b, c, d) |
SA6BCO |
R |
|
|
S |
CNX_AGENCI |
C |
5 |
0 |
Agencia |
@! |
CN300VldBc(a, b, c, d) |
|
|
|
|
S |
CNX_CONTA |
C |
10 |
0 |
Conta |
@! |
CN300VldBc(a, b, c, d) |
|
|
|
|
S |
CNX_VLADT |
N |
16 |
2 |
Vl. Adiant. |
@E 9,999,999,999,999.99 |
ValidValor(FwFldGet('CNX_VLADT')) |
|
R |
|
|
S |
CNX_DTADT |
D |
8 |
0 |
Dt. Adiant. |
|
|
|
R |
|
|
S |
CNX_PREFIX |
C |
3 |
0 |
Pref. Titulo |
@! |
|
|
R |
|
|
S |
CNX_NUMTIT |
C |
9 |
0 |
Num. Titulo |
@! |
|
|
R |
|
|
S |
CNX_SALDO |
N |
14 |
2 |
Saldo |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
CNX_REVGER |
C |
3 |
0 |
Rev. Gerador |
@! |
|
|
R |
|
|
S |