Tabela |
NV4 |
Lancamento Tabelado |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
NV4_FILIAL |
C |
2 |
0 |
Filial |
|
J202RTKT("NV4") |
|
R |
|
|
N |
NV4_TKRET |
L |
1 |
0 |
Marcar ? |
|
J202RTKT("NV4") |
|
V |
|
!Empty(FwFldGet("NV4_CPREFT")) |
N |
NV4_COD |
C |
6 |
0 |
Codigo |
|
ExistChav('NV4',M->NV4_COD,1) |
|
R |
|
|
N |
NV4_DTLANC |
D |
8 |
0 |
Dt Lanc |
|
|
|
R |
|
FwFldGet('NV4_SITUAC') == '1' |
N |
NV4_CGRUPO |
C |
6 |
0 |
Cod Grupo |
@! |
Vazio() .Or. J027ValCpo() |
ACY |
R |
|
FwFldGet('NV4_SITUAC') == '1' |
N |
NV4_DGRUPO |
C |
30 |
0 |
Grupo |
@! |
|
|
V |
|
|
N |
NV4_CCLIEN |
C |
6 |
0 |
Cod Cliente |
@! |
Vazio() .Or. J027ValCpo() |
SA1NUH |
R |
|
FwFldGet('NV4_SITUAC') == '1' |
N |
NV4_CLOJA |
C |
2 |
0 |
Cod Loja |
@! |
Vazio() .Or. J027ValCpo() |
|
R |
|
FwFldGet('NV4_SITUAC') == '1' |
N |
NV4_DCLIEN |
C |
40 |
0 |
Nome Cliente |
|
|
|
V |
|
|
N |
NV4_CCASO |
C |
6 |
0 |
Cod Caso |
|
Vazio() .Or. J027ValCpo() |
NVELOJ |
R |
|
FwFldGet('NV4_SITUAC') == '1'.AND.JA027VLCLC('NV4_CCASO') |
N |
NV4_DCASO |
C |
200 |
0 |
Desc Caso |
@S100 |
|
|
V |
|
|
N |
NV4_SIGLA |
C |
5 |
0 |
Sigla part |
|
Vazio().OR.JurVldPart("NV4_SIGLA") |
RD0ATV |
V |
|
FwFldGet('NV4_SITUAC') == '1' |
S |
NV4_CPART |
C |
6 |
0 |
Cod Part |
|
Vazio().Or.Iif(JurIsRest(),JurVldPart("NV4_CPART"), .T.) |
|
R |
|
FwFldGet('NV4_SITUAC') == '1' |
N |
NV4_DPART |
C |
30 |
0 |
Participante |
|
|
|
V |
|
|
N |
NV4_CTPSRV |
C |
20 |
0 |
Cod Tp Serv |
|
Vazio() .OR. J027ValCpo() |
NRD |
R |
|
FwFldGet('NV4_SITUAC') == '1'.AND.JA027VLCLC('NV4_CTPSRV') |
N |
NV4_DTPSRV |
C |
200 |
0 |
Desc Tp Serv |
@S100 |
|
|
V |
|
|
N |
NV4_QUANT |
N |
4 |
0 |
Qtd Servicos |
@E 9999 |
POSITIVO() .AND. J027ValCpo() |
|
R |
|
FwFldGet('NV4_SITUAC') == '1' |
N |
NV4_CMOEH |
C |
2 |
0 |
Cod. Moeda |
|
J027ValCpo() |
JURCTO |
R |
|
FwFldGet("NV4_SITUAC") == "1".AND.JA027VLCLC("NV4_CMOEH") |
N |
NV4_DMOEH |
C |
10 |
0 |
Desc Moeda |
|
|
|
V |
|
|
N |
NV4_VLHFAT |
N |
16 |
2 |
Vlr Hon Fat |
@E 9,999,999,999,999.99 |
JA202VAL( 'NV4_VLHFAT' ) |
|
R |
|
FwFldGet('NV4_SITUAC') == '1' |
N |
NV4_VLHTAB |
N |
16 |
2 |
Vlr Hon Tab |
@E 9,999,999,999,999.99 |
|
|
R |
|
FwFldGet('NV4_SITUAC') == '1' |
N |
NV4_CMOED |
C |
2 |
0 |
Cod Moe Taxa |
|
J027ValCpo() |
JURCTO |
R |
|
FwFldGet("NV4_SITUAC") == "1".AND.JA027VLCLC("NV4_CMOED") |
N |
NV4_DMOED |
C |
10 |
0 |
Des Moe Taxa |
|
|
|
V |
|
|
N |
NV4_VLDFAT |
N |
16 |
2 |
Vlr Taxa Fat |
@E 9,999,999,999,999.99 |
|
|
R |
|
FwFldGet('NV4_SITUAC') == '1' |
N |
NV4_VLDTAB |
N |
16 |
2 |
Vlr Taxa Tab |
@E 9,999,999,999,999.99 |
|
|
R |
|
FwFldGet('NV4_SITUAC') == '1' |
N |
NV4_DESCRI |
M |
10 |
0 |
Desc Lanc |
|
|
|
R |
|
|
N |
NV4_CONC |
C |
1 |
0 |
Concluido? |
|
Pertence("12") |
|
R |
1=Sim;2=Nao |
FwFldGet('NV4_SITUAC') == '1' |
N |
NV4_DTCONC |
D |
8 |
0 |
Dt Conclusao |
|
Vazio() .OR. (JurVldPart("NV4_DTCONC") .AND. J027ValCpo()) |
|
R |
|
FwFldGet('NV4_SITUAC') == '1'.and.FwFldGet('NV4_CONC') =='1' |
N |
NV4_COBRAR |
C |
1 |
0 |
Cobrar? |
|
Pertence("12") |
|
R |
1=Sim;2=Nao |
FwFldGet('NV4_SITUAC') == '1' |
N |
NV4_SITUAC |
C |
1 |
0 |
Situacao |
|
Pertence("12") |
|
R |
1=Pendente;2=Concluido |
|
N |
NV4_DTINC |
D |
8 |
0 |
Dt Inclusao |
|
|
|
R |
|
FwFldGet('NV4_SITUAC') == '1' |
N |
NV4_HRINC |
C |
8 |
0 |
Hr Inclusao |
@R 99:99:99 |
|
|
R |
|
FwFldGet('NV4_SITUAC') == '1' |
N |
NV4_FINANC |
C |
1 |
0 |
Gerar CP? |
|
Pertence("12") |
|
R |
1=Sim;2=Nao |
FwFldGet("NV4_SITUAC") == "1".AND.J027CPW() |
N |
NV4_ANOMES |
C |
6 |
0 |
Ano-Mes |
@R 9999-99 |
|
|
R |
|
FwFldGet('NV4_SITUAC') == '1' |
N |
NV4_CPREFT |
C |
8 |
0 |
Cod Pre-Fat |
|
|
|
R |
|
FwFldGet('NV4_SITUAC') == '1' |
N |
NV4_OK |
C |
2 |
0 |
Marca OK |
|
|
|
R |
|
FwFldGet('NV4_SITUAC') == '1' |
N |
NV4_COTAC1 |
N |
8 |
5 |
Cotacao 1 |
@E 99.99999 |
|
|
R |
|
FwFldGet('NV4_SITUAC') == '1' |
N |
NV4_COTAC2 |
N |
8 |
5 |
Cotacao 2 |
@E 99.99999 |
|
|
R |
|
FwFldGet('NV4_SITUAC') == '1' |
N |
NV4_CLOTE |
C |
6 |
0 |
Codigo Lote |
|
|
|
R |
|
|
N |
NV4_ACAOLD |
C |
1 |
0 |
Acoes LD |
|
Vazio().Or.Pertence("12345") |
|
R |
1=Retirar;2=Transferir;3=WO;4=Lancamento indevido;5=Transferir e retirar |
|
S |
NV4_CCLILD |
C |
6 |
0 |
Cl Transf LD |
@! |
Vazio() .Or. J027ValCpo() |
|
R |
|
|
S |
NV4_CLJLD |
C |
2 |
0 |
Lj Transf LD |
@! |
Vazio() .Or. J027ValCpo() |
|
R |
|
|
S |
NV4_CCSLD |
C |
6 |
0 |
Caso Tsf LD |
|
Vazio() .Or. J027ValCpo() |
|
R |
|
|
S |
NV4_PARTLD |
C |
6 |
0 |
Part Acao LD |
|
Vazio().Or.ExistCpo('RD0',FWFLDGET('NV4_PARTLD'),1) |
|
R |
|
|
S |
NV4_CMOTWO |
C |
3 |
0 |
Cd Mot WO LD |
|
Vazio().Or.JurVldMot("4",.T.,.F.,"NXVEMI") |
|
R |
|
|
S |
NV4_OBSWO |
M |
10 |
0 |
Observ WO LD |
|
|
|
R |
|
|
S |
NV4_CDWOLD |
C |
50 |
0 |
Cod WO no LD |
|
|
|
R |
|
|
S |
NV4_COTAC |
N |
8 |
5 |
Cotacao |
@E 99.99999 |
|
|
R |
|
|
S |