Tabela |
NWM |
LANCAMENTO TABELADO EM LOTE |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
NWM_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
N |
NWM_COD |
C |
6 |
0 |
Codigo |
|
ExistChav('NWM',FWFLDGET("NWM_COD"),1) |
|
R |
|
|
N |
NWM_CGRUPO |
C |
6 |
0 |
Cod Grupo |
@! |
Vazio() .Or. J109ValCpo() |
ACY |
R |
|
INCLUI |
N |
NWM_DGRUPO |
C |
30 |
0 |
Desc Grupo |
@! |
|
|
V |
|
|
N |
NWM_CCLIEN |
C |
6 |
0 |
Cod Cliente |
@! |
Vazio() .Or. J109ValCpo() |
SA1NUH |
R |
|
INCLUI |
N |
NWM_CLOJA |
C |
2 |
0 |
Cod Loja |
@! |
Vazio() .Or. J109ValCpo() |
|
R |
|
INCLUI |
N |
NWM_DCLIEN |
C |
40 |
0 |
Desc Cliente |
|
|
|
V |
|
|
N |
NWM_CCONTR |
C |
6 |
0 |
Contr Refere |
|
(Vazio() .Or. ExistCpo('NT0',FWFLDGET("NWM_CCONTR"),1)) .And. J109ValCpo() |
JURNT0 |
R |
|
|
N |
NWM_DCONTR |
C |
30 |
0 |
Desc Contrat |
|
|
|
V |
|
|
N |
NWM_QUANT |
N |
4 |
0 |
Qtd Servicos |
@E 9999 |
POSITIVO() |
|
R |
|
|
N |
NWM_CTPSRV |
C |
20 |
0 |
Cod Tp Serv |
|
(ExistCpo("NRD", FWFLDGET("NWM_CTPSRV"), 1) ) .And. J109ValCpo() |
NRD |
R |
|
|
S |
NWM_DTPSRV |
C |
200 |
0 |
Desc Tp Serv |
@S50 |
|
|
V |
|
|
S |
NWM_DESCRI |
M |
10 |
0 |
Descricao |
|
|
|
R |
|
|
N |
NWM_FORMUL |
C |
3 |
0 |
Form Preench |
|
|
SM4 |
R |
|
|
S |
NWM_CMOEDA |
C |
2 |
0 |
Cod Moeda |
|
Vazio().OR.ExistCpo('CTO',FWFLDGET("NWM_CMOEDA"),1) |
JURCTO |
R |
|
|
S |
NWM_DMOEDA |
C |
10 |
0 |
Desc Moeda |
|
|
|
V |
|
|
S |
NWM_VLBASE |
N |
9 |
2 |
Valor Base |
@E 999,999.99 |
|
|
R |
|
|
N |
NWM_DTBASE |
D |
8 |
0 |
Data Base |
|
|
|
R |
|
|
N |
NWM_TPCORR |
C |
1 |
0 |
Tp Correcao |
|
Pertence("12") |
|
R |
1=Nao Corrigir;2=Indice |
|
N |
NWM_CINDIC |
C |
2 |
0 |
Cod Indice |
|
Vazio() .Or. ExistCpo('NW5',FWFLDGET("NWM_CINDIC"),1) |
NW5 |
R |
|
M->NWM_TPCORR == '2' |
N |
NWM_DINDIC |
C |
10 |
0 |
Desc Indice |
|
|
|
V |
|
M->NWM_TPCORR == '2' |
N |
NWM_VLATUA |
N |
9 |
2 |
Vl Atua |
@E 999,999.99 |
|
|
R |
|
|
N |
NWM_SIGLA |
C |
5 |
0 |
Sigla part |
|
Vazio().Or.(ExistCpo('RD0',FWFLDGET('NWM_SIGLA'),9).And.JURRD0('NWMMASTER','NWM_SIGLA','1',.T.)) |
RD0ATV |
V |
|
|
S |
NWM_CPART |
C |
6 |
0 |
Cod Part |
|
Vazio().Or.Iif(JurIsRest(),(ExistCpo('RD0',FWFLDGET('NWM_CPART'),1).And.JURRD0('NWMMASTER','NWM_CPART','1')), .T.) |
|
R |
|
|
N |
NWM_DPART |
C |
30 |
0 |
Desc Part |
|
|
|
V |
|
|
N |
NWM_AMINI |
C |
6 |
0 |
Ano Mes Inic |
@R 9999-99 |
JVldAnoMes(FwFldGet("NWM_AMINI")) |
|
R |
|
|
N |
NWM_AMFIM |
C |
6 |
0 |
Ano Mes Fim |
@R 9999-99 |
JVldAnoMes(FwFldGet("NWM_AMFIM")) |
|
R |
|
|
N |
NWM_DIAGER |
C |
2 |
0 |
Dia Geracao |
|
Vazio() .Or. Val(FwFldGet("NWM_DIAGER")) > 0 .And. Val(FwFldGet("NWM_DIAGER")) <= 31 |
|
R |
|
|
N |
NWM_PERCOB |
C |
2 |
0 |
Period Cobra |
|
Vazio() .Or.VAl(FwFldGet("NWM_PERCOB")) > 0 .And. VAl(FwFldGet("NWM_PERCOB")) <= 12 |
|
R |
|
|
N |
NWM_SIGLA2 |
C |
5 |
0 |
Sigla alt |
|
|
|
V |
|
|
S |
NWM_ALTPAR |
C |
6 |
0 |
Part Altera |
|
Vazio() .Or. ExistCpo("RD0",FWFLDGET("NWM_ALTPAR"),1) |
|
R |
|
|
N |
NWM_ALTPAD |
C |
30 |
0 |
Des Part Alt |
|
|
|
V |
|
|
N |
NWM_ALTDT |
D |
8 |
0 |
Dt Alteracao |
|
|
|
R |
|
|
N |
NWM_PERCOR |
C |
2 |
0 |
Period Corre |
|
Vazio() .Or. VAl(FwFldGet("NWM_PERCOR")) > 0 .And. VAl(FwFldGet("NWM_PERCOR")) <= 12 |
|
R |
|
M->NWM_TPCORR == '2' |
N |
NWM_ALTHR |
C |
8 |
0 |
Hr Alteracao |
@R 99:99:99 |
|
|
R |
|
|
N |