Tabela |
TFH |
MATERIAIS DE CONSUMO |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
TFH_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
R |
|
|
S |
TFH_COD |
C |
6 |
0 |
Codigo |
@! |
NaoVazio() .AND. ExistChav('TFH') |
|
R |
|
|
S |
TFH_LOCAL |
C |
8 |
0 |
Local |
@! |
ExistCpo("ABS") |
ABS |
R |
|
|
S |
TFH_ITEM |
C |
2 |
0 |
Item |
@! |
|
|
R |
|
|
S |
TFH_PRODUT |
C |
15 |
0 |
Produto |
@! |
ExistCpo('SB1') .AND. ExistCpo('SB5') .And. At740VldPrd(3, M->TFH_PRODUT) |
TECPRD |
R |
|
|
S |
TFH_DESCRI |
C |
30 |
0 |
Descricao |
@! |
|
|
V |
|
|
S |
TFH_UM |
C |
2 |
0 |
Unidade |
@! |
|
|
R |
|
|
S |
TFH_QTDVEN |
N |
11 |
2 |
Quantidade |
@E 99,999,999.99 |
Positivo() .AND. FwFldGet("TFH_QTDVEN") > 0 |
|
R |
|
|
S |
TFH_PRCVEN |
N |
14 |
2 |
Vlr. Venda |
@E 99,999,999,999.99 |
Positivo() .AND. FwFldGet("TFH_PRCVEN") > 0 |
|
R |
|
|
S |
TFH_PERINI |
D |
8 |
0 |
Per. Inicio |
|
|
|
R |
|
|
S |
TFH_PERFIM |
D |
8 |
0 |
Per. Final |
|
|
|
R |
|
At740WhenR() |
S |
TFH_TOTAL |
N |
14 |
2 |
SubTotal |
@E 99,999,999,999.99 |
|
|
V |
|
|
S |
TFH_DESCON |
N |
5 |
2 |
%Desconto |
@E 99.99 |
|
|
R |
|
|
S |
TFH_VALDES |
N |
14 |
2 |
Vlr.Desconto |
@E 99,999,999,999.99 |
Positivo() |
|
R |
|
|
S |
TFH_TES |
C |
3 |
0 |
Tipo Saida |
@! |
ExistCpo("SF4") .And. M->TFH_TES > '500' |
SF4 |
R |
|
|
S |
TFH_CODPAI |
C |
6 |
0 |
Codigo Pai |
@! |
|
|
R |
|
|
S |
TFH_SLD |
N |
11 |
2 |
Saldo |
@E 99,999,999.99 |
Positivo() |
|
R |
|
|
S |
TFH_CODSUB |
C |
6 |
0 |
Cod. Subst |
@! |
|
|
R |
|
|
S |
TFH_TOTGER |
N |
14 |
2 |
Vlr.Total |
@E 99,999,999,999.99 |
Positivo() |
|
V |
|
|
S |
TFH_LUCRO |
N |
5 |
2 |
%Lucro |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
TFH_TXLUCR |
N |
14 |
2 |
Vlr. Lucro |
@E 99,999,999,999.99 |
Positivo() |
|
R |
|
|
S |
TFH_ADM |
N |
5 |
2 |
%Adm |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
TFH_TXADM |
N |
14 |
2 |
Vlr. Tx Adm |
@E 99,999,999,999.99 |
Positivo() |
|
R |
|
|
S |
TFH_COBCTR |
C |
1 |
0 |
Cob.Contrato |
@! |
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
TFH_VIDMES |
N |
3 |
0 |
Vida Util |
@E 999 |
Positivo() |
|
R |
|
|
S |
TFH_DPRMES |
N |
14 |
2 |
Depr. Mens. |
@E 99,999,999,999.99 |
Positivo() |
|
R |
|
|
S |
TFH_CHVTWO |
C |
21 |
0 |
Chv Facilita |
@! |
|
|
R |
|
|
S |
TFH_ITCNB |
C |
3 |
0 |
Item CNB |
@! |
|
|
R |
|
|
S |
TFH_CONTRT |
C |
15 |
0 |
Contrato |
@! |
|
|
R |
|
|
S |
TFH_CONREV |
C |
3 |
0 |
Revisao |
@! |
|
|
R |
|
|
S |
TFH_TESPED |
C |
3 |
0 |
TES Pedido |
@! |
ExistCpo("SF4") .And. (FwFldGet("TFH_TESPED") > '500') |
SF4 |
R |
|
|
S |