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