Tabela
VP1 Participantes
Campo Tipo Tamanho Decimal Titulo Formato Validacao F3 Contexto Lista Condicao PYME
VP1_FILIAL C 2 0 Filial S
VP1_CODGRU C 5 0 Grupo 99999 FG_STRZERO("M->VP1_CODGRU",5).and.FG_Seek("VP3","M->VP1_CODGRU",1,.f.) VP3 S
VP1_NUMCOT C 4 0 Nro da Cota 9999 FG_STRZERO("M->VP1_NUMCOT",4).and.EXISTCHAV("VP1",M->VP1_CODGRU+M->VP1_NUMCOT,1,"EXINUMCOT") S
VP1_CODCLI C 6 0 Cliente @! FG_VALIDA(Nil,"SA1T1M->VP1_CODCLI*","M->VP1_NOMCLI:=A1_NOME") VSA S
VP1_LOJA C 2 0 Loja @! FG_Seek("SA1","M->VP1_CODCLI+M->VP1_LOJA",1,.f.,"VP1_NOMCLI","A1_NOME") Inclui S
VP1_NOMCLI C 40 0 Nome Cliente @!S24 S
VP1_CODBEM C 4 0 Bem 9999 Vazio() .or. FG_VALIDA("M->VP1_CODBEM","VP6TM->VP1_CODBEM*","VP1_DESBEM:=VP6->VP6_DESBEM,VP1_VALCRE:=VP6->VP6_VALBEM") VP6 S
VP1_DESBEM C 20 0 Descricao @!S24 S
VP1_DATADE D 8 0 Dt Adesao @D M->VP1_DATADE >= POSICIONE("VP3",1,M->VP1_FILIAL+M->VP1_CODGRU,"VP3_DATABE") S
VP1_QTDPAR N 3 0 Qtd Parcelas 999 Positivo().and.FG_VALIDA(Nil,Nil,"M->VP1_PERIDE:=100/M->VP1_QTDPAR") S
VP1_DIAPGT N 2 0 Dia p/ Pagto 99 Positivo() .and. M->VP1_DIAPGT < 31 S
VP1_PERIDE N 8 4 % Ideal @E 999.9999 S
VP1_PERLAN N 8 4 % Lance @E 999.9999 S
VP1_DESCBP N 12 2 Vl Desp Cobr @E 999,999,999.99 Positivo() S
VP1_OUTDES N 12 2 Vl Outr Desp @E 999,999,999.99 Positivo() S
VP1_PARATU N 3 0 Parc Pagas @! S
VP1_PERPAG N 8 0 Perc Pago @E 999.9999 S
VP1_VALCRE N 12 2 Vlr Credito @E 999,999,999.99 Positivo() VP1_STATUS=="2" S
VP1_STATUS C 1 0 Status @! PERTENCE("1234") 1=Normal;2=Contemplado;3=Congelado;4=Cancelado S
VP1_DATCON D 8 0 Dt Contempl @D !NaoVazio().OR.M->VP1_DATCON >= POSICIONE("VP3",1,M->VP1_FILIAL+M->VP1_CODGRU,"VP3_DATABE") VP1_STATUS=="2" S
VP1_CHASSI C 25 0 Chassi @! VP1_STATUS=="2" S
VP1_DATENT D 8 0 Dt Entrega @D VP1_STATUS=="2" S
VP1_DATCOG D 8 0 Dt Congelato @D VP1_STATUS=="3" S
VP1_DATCAN D 8 0 Dt Cancelmto @D VP1_STATUS=="4" S
VP1_OBSER1 C 60 0 Observacao 1 @! S
VP1_OBSER2 C 60 0 Observacao 2 @! S