Tabela |
TFG |
MATERIAIS DE IMPLANTACAO |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
TFG_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
R |
|
|
S |
TFG_COD |
C |
6 |
0 |
Codigo |
@! |
NaoVazio() .AND. ExistChav('TFG') |
|
R |
|
|
S |
TFG_LOCAL |
C |
8 |
0 |
Local |
@! |
ExistCpo('ABS') |
ABS |
R |
|
|
S |
TFG_ITEM |
C |
2 |
0 |
Item |
@! |
|
|
R |
|
|
S |
TFG_PRODUT |
C |
15 |
0 |
Produto |
@! |
ExistCpo('SB1') .AND. ExistCpo('SB5') .And. At740VldPrd(2, M->TFG_PRODUT) |
TECPRD |
R |
|
|
S |
TFG_DESCRI |
C |
30 |
0 |
Descricao |
@! |
|
|
V |
|
|
S |
TFG_UM |
C |
2 |
0 |
Unidade |
@! |
|
|
R |
|
|
S |
TFG_QTDVEN |
N |
11 |
2 |
Quantidade |
@E 99,999,999.99 |
Positivo() .AND. FwFldGet("TFG_QTDVEN") > 0 |
|
R |
|
|
S |
TFG_PRCVEN |
N |
14 |
2 |
Vlr. Venda |
@E 99,999,999,999.99 |
Positivo() .AND. FWFldGet("TFG_PRCVEN") > 0 |
|
R |
|
|
S |
TFG_PERINI |
D |
8 |
0 |
Per. Inicio |
|
|
|
R |
|
|
S |
TFG_PERFIM |
D |
8 |
0 |
Per. Final |
|
|
|
R |
|
At740WhenR() |
S |
TFG_TOTAL |
N |
14 |
2 |
SubTotal |
@E 99,999,999,999.99 |
Positivo() |
|
V |
|
|
S |
TFG_DESCON |
N |
5 |
2 |
%Desconto |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
TFG_VALDES |
N |
14 |
2 |
Vlr.Desconto |
@E 99,999,999,999.99 |
Positivo() |
|
R |
|
|
S |
TFG_TES |
C |
3 |
0 |
Tipo Saida |
@! |
ExistCpo("SF4") .And. M->TFG_TES > '500' |
SF4 |
R |
|
|
S |
TFG_CODPAI |
C |
6 |
0 |
Codigo Pai |
@! |
|
|
R |
|
|
S |
TFG_SLD |
N |
11 |
2 |
Saldo |
@E 99,999,999.99 |
Positivo() |
|
R |
|
|
S |
TFG_CODSUB |
C |
6 |
0 |
Cod. Subst. |
@! |
|
|
R |
|
|
S |
TFG_TOTGER |
N |
14 |
2 |
Vlr.Total |
@E 99,999,999,999.99 |
Positivo() |
|
V |
|
|
S |
TFG_LUCRO |
N |
5 |
2 |
%Lucro |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
TFG_TXLUCR |
N |
14 |
2 |
Vlr. Lucro |
@E 99,999,999,999.99 |
Positivo() |
|
R |
|
|
S |
TFG_ADM |
N |
5 |
2 |
%Adm |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
TFG_TXADM |
N |
14 |
2 |
Vlr. Tx Adm |
@E 99,999,999,999.99 |
Positivo() |
|
R |
|
|
S |
TFG_COBCTR |
C |
1 |
0 |
Cob.Contrato |
@! |
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
TFG_VIDMES |
N |
3 |
0 |
Vida Util |
@E 999 |
Positivo() |
|
R |
|
|
S |
TFG_DPRMES |
N |
14 |
2 |
Depr. Mens. |
@E 99,999,999,999.99 |
Positivo() |
|
R |
|
|
S |
TFG_CHVTWO |
C |
21 |
0 |
Chv Facilita |
@! |
|
|
R |
|
|
S |
TFG_RESRET |
N |
11 |
2 |
Res. Elim. |
@E 99,999,999.99 |
|
|
R |
|
|
S |
TFG_VLATIV |
N |
14 |
2 |
Vl Ativo |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
TFG_ITCNB |
C |
3 |
0 |
Item CNB |
@! |
|
|
R |
|
|
S |
TFG_CONTRT |
C |
15 |
0 |
Contrato |
@! |
|
|
R |
|
|
S |
TFG_CONREV |
C |
3 |
0 |
Revisao |
@! |
|
|
R |
|
|
S |
TFG_TESPED |
C |
3 |
0 |
TES Pedido |
@! |
ExistCpo("SF4") .And. (FwFldGet("TFG_TESPED") > '500') |
SF4 |
R |
|
|
S |