Tabela |
NV0 |
Hist. Exc Da Tab Honor - Part |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
NV0_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
R |
|
|
S |
NV0_COD |
C |
6 |
0 |
Codigo |
|
|
|
R |
|
|
S |
NV0_CCLIEN |
C |
6 |
0 |
Cod cliente |
@! |
|
|
R |
|
|
S |
NV0_CLOJA |
C |
2 |
0 |
Cod loja |
@! |
|
|
R |
|
|
S |
NV0_CCASO |
C |
6 |
0 |
Cod caso |
|
|
|
R |
|
|
S |
NV0_AMINI |
C |
6 |
0 |
Ano-Mes Ini |
@R 9999-99 |
JHISTVMIni("NV0") |
|
R |
|
|
S |
NV0_AMFIM |
C |
6 |
0 |
Ano-Mes Fim |
@R 9999-99 |
JHISTVMFim("NV0") |
|
R |
|
|
S |
NV0_SIGLA |
C |
5 |
0 |
Sigla part |
|
Vazio().Or.(ExistCpo('RD0',FWFLDGET('NV0_SIGLA'),9).And.JURRD0('NV0DETAIL','NV0_SIGLA','1',.T.)) |
RD0ATV |
V |
|
|
S |
NV0_CPART |
C |
6 |
0 |
Cod particip |
|
Vazio().Or.Iif(JurIsRest(),(ExistCpo('RD0',FWFLDGET('NV0_CPART'),1).And.JURRD0('NV0DETAIL','NV0_CPART','1')), .T.) |
RD0ATV |
R |
|
|
S |
NV0_DPART |
C |
40 |
0 |
Nome Partic |
|
|
|
V |
|
|
S |
NV0_DCAT1 |
C |
55 |
0 |
Cat original |
|
|
|
V |
|
|
S |
NV0_VALOR1 |
N |
16 |
2 |
Vlr original |
@E 9,999,999,999,999.99 |
|
|
V |
|
|
S |
NV0_EXCCAT |
C |
1 |
0 |
Acumulativo |
|
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
NV0_REGRA |
C |
1 |
0 |
Regra |
|
Pertence("1234").And.J70ValNeg("NV0_VALOR2").AND.J70CodCat("NV0") |
|
R |
1=Porcentagem;2=Soma;3=Fixo;4=Categoria |
|
S |
NV0_CCAT |
C |
5 |
0 |
Cod categ |
|
ExistCpo('NRN',M->NV0_CCAT,1).OR.J70CodCat("NV0_CCAT").Or.Vazio() |
NRN |
R |
|
FWFLDGET("NV0_REGRA") =='4' |
S |
NV0_DCAT |
C |
50 |
0 |
Desc Categ |
|
|
|
V |
|
FWFLDGET("NV0_REGRA") =='4' |
S |
NV0_VALOR2 |
N |
16 |
2 |
Vlr ajuste |
@E 9,999,999,999,999.99 |
J70ValNeg("NV0_VALOR2") |
|
R |
|
!FwFldGet("NV0_REGRA") == '4' |
S |
NV0_VALOR3 |
N |
16 |
2 |
Vlr ajustado |
@E 9,999,999,999,999.99 |
|
|
V |
|
|
S |