Tabela |
SNN |
Planejamento de Aquisicoes |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
NN_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
R |
|
|
S |
NN_CODIGO |
C |
10 |
0 |
Codigo |
@! |
EXISTCHAV("SNN",M->NN_CODIGO+M->NN_ITEM) |
|
R |
|
INCLUI |
S |
NN_ITEM |
C |
4 |
0 |
Item |
@! |
EXISTCHAV('SNN', M->NN_CODIGO + M->NN_ITEM) |
|
R |
|
INCLUI |
S |
NN_AQUISIC |
D |
8 |
0 |
Dt.Aquisicao |
|
DataValida() |
|
R |
|
|
S |
NN_DESCRIC |
C |
40 |
0 |
Descr.Bem |
@! |
|
|
R |
|
|
S |
NN_QUANTD |
N |
11 |
3 |
Quantidade |
@E 9,999,999.999 |
|
|
R |
|
|
S |
NN_GRUPO |
C |
4 |
0 |
Grupo |
@! |
(Vazio() .Or. ExistCpo("SNG")) .And. AF310GRUPO(.T.) |
SNG |
R |
|
|
S |
NN_DTPREVI |
D |
8 |
0 |
Dt. Aq Previ |
|
DataValida() |
|
R |
|
|
S |
NN_CODEFTV |
C |
10 |
0 |
Codigo Efet. |
@! |
|
|
R |
|
|
S |
NN_ITMEFTV |
C |
4 |
0 |
Item efet. |
@! |
|
|
R |
|
|
S |
NN_VORIG1 |
N |
16 |
2 |
Val Orig M1 |
@E 9,999,999,999,999.99 |
IIf(aCols[n][1] != '05',POSITIVO(),.T.) .AND. AF310ACONV() |
|
R |
|
|
S |
NN_TXDEPR1 |
N |
9 |
4 |
Tx.An.Depr.1 |
@E 9,999.9999 |
POSITIVO() .and. IF(FINDFUNCTION("AF310ATAXA"), AF310ATAXA(),.T.) |
|
R |
|
|
S |
NN_VORIG2 |
N |
16 |
4 |
Val Orig M2 |
@E 99,999,999,999.9999 |
POSITIVO() |
|
|
|
|
S |
NN_TXDEPR2 |
N |
9 |
4 |
Tx.An.Depr.2 |
@E 9,999.9999 |
POSITIVO() |
|
R |
|
|
S |
NN_VORIG3 |
N |
16 |
4 |
Val Orig M3 |
@E 99,999,999,999.9999 |
POSITIVO() |
|
|
|
|
S |
NN_TXDEPR3 |
N |
9 |
4 |
Tx.An.Depr.3 |
@E 9,999.9999 |
POSITIVO() |
|
|
|
|
S |
NN_VORIG4 |
N |
16 |
4 |
Val Orig M4 |
@E 99,999,999,999.9999 |
POSITIVO() |
|
|
|
|
S |
NN_TXDEPR4 |
N |
9 |
4 |
Tx.An.Depr.4 |
@E 9,999.9999 |
POSITIVO() |
|
|
|
|
S |
NN_VORIG5 |
N |
16 |
4 |
Val Orig M5 |
@E 99,999,999,999.9999 |
POSITIVO() |
|
|
|
|
S |
NN_TXDEPR5 |
N |
9 |
4 |
Tx.An.Depr.5 |
@E 9,999.9999 |
POSITIVO() |
|
|
|
|
S |
NN_CCONTAB |
C |
20 |
0 |
Conta |
@! |
ValClaSint(M->NN_CCONTAB, "CT1",1,"CT1_CLASSE") |
CT1 |
R |
|
|
S |
NN_CUSTBEM |
C |
9 |
0 |
C Custo Bem |
@! |
ValClaSint(M->NN_CUSTBEM, "CTT",1,"CTT_CLASSE") |
CTT |
R |
|
CtbMovSaldo("CTT") |
S |
NN_SUBCCON |
C |
9 |
0 |
Item do Bem |
@! |
ValClaSint(M->NN_SUBCCON, "CTD",1,"CTD_CLASSE") |
CTD |
R |
|
CtbMovSaldo("CTD") |
S |
NN_CLVLCON |
C |
9 |
0 |
Cl Vlr Bem |
@! |
ValClaSint(M->NN_CLVLCON, "CTH",1,"CTH_CLASSE") |
CTH |
R |
|
CtbMovSaldo("CTH") |
S |
NN_CDEPREC |
C |
20 |
0 |
Cta Desp Dep |
@! |
ValClaSint(M->NN_CDEPREC, "CT1",1,"CT1_CLASSE") |
CT1 |
R |
|
|
S |
NN_CCDESP |
C |
9 |
0 |
Cc Des Depr |
@! |
ValClaSint(M->NN_CCDESP, "CTT",1,"CTT_CLASSE") |
CTT |
R |
|
CtbMovSaldo("CTT") |
S |
NN_SUBCDEP |
C |
9 |
0 |
Item Ds.Dep. |
@! |
ValClaSint(M->NN_SUBCDEP, "CTD",1,"CTD_CLASSE") |
CTD |
R |
|
CtbMovSaldo("CTD") |
S |
NN_CLVLDEP |
C |
9 |
0 |
Clvl Des.Dep |
@! |
ValClaSint(M->NN_CLVLDEP, "CTH",1,"CTH_CLASSE") |
CTH |
|
|
CtbMovSaldo("CTH") |
S |
NN_CCDEPR |
C |
20 |
0 |
Cta Dep Acum |
@! |
ValClaSint(M->NN_CCDEPR, "CT1",1,"CT1_CLASSE") |
CT1 |
R |
|
|
S |
NN_CCCDEP |
C |
9 |
0 |
Cc Depr Ac |
@! |
ValClaSint(M->NN_CCCDEP, "CTT",1,"CTT_CLASSE") |
CTT |
R |
|
CtbMovSaldo("CTT") |
S |
NN_SUBCCDE |
C |
9 |
0 |
Item Dep.Ac. |
@! |
ValClaSint(M->NN_SUBCCDE, "CTD",1,"CTD_CLASSE") |
CTD |
R |
|
CtbMovSaldo("CTD") |
S |
NN_CLVLCDE |
C |
9 |
0 |
Clvl Dep.Acu |
@! |
ValClaSint(M->NN_CLVLCDE, "CTH",1,"CTH_CLASSE") |
CTH |
R |
|
CtbMovSaldo("CTH") |
S |
NN_OK |
C |
2 |
0 |
Flag Marca |
|
|
|
R |
|
|
S |