Tabela
SRV Verbas
Campo Tipo Tamanho Decimal Titulo Formato Validacao F3 Contexto Lista Condicao PYME
RV_FILIAL C 2 0 Filial S
RV_COD C 3 0 Codigo Verba @! NaoVazio() .and. ExistChav("SRV") .and. FreeForUse("SRV",M->RV_COD) .And. !Pertence("000") S
RV_DESC C 20 0 Descricao @S!15 S
RV_DESCDET C 50 0 Desc. Det. @! R S
RV_TIPOCOD C 1 0 Tipo do Cod. @! Pertence("1234").and.IF(M->RV_TIPOCOD<>"1".and.M->RV_OBRIGAT $ " N",.T.,IF(M->RV_TIPOCOD="1".and.M->RV_OBRIGAT $ " SN",.T.,.F.)) 1=Provento;2=Desconto;3=Base (Provento);4=Base (Desconto) S
RV_IMPRIPD C 1 0 Impr. Verba @! Pertence("12") R 1=Sim;2=Nao M->RV_TIPOCOD <> "1" .AND. M->RV_TIPOCOD <> "2" S
RV_PERC N 7 3 Percentual @E 999.999 POSITIVO() S
RV_CODCORR C 3 0 Cod.Corresp. @! VAZIO() .Or. (EXISTCPO("SRV",,1) .And. M->RV_COD # M->RV_CODCORR) VER S
RV_CODFOL C 4 0 Id.p/Calculo @! Vazio() .or. (Chk_CodFol() .and. ExistCpo( "RCN" ) .and. If(Empty( M->RV_CODFOL), FreeForUse("SRV", "ID"+M->RV_CODFOL), .T. )) RCN S
RV_TIPO C 1 0 Tipo Verba @! Pertence("HDV ") H=Horas;V=Valor;D=Dias S
RV_OBRIGAT C 1 0 Pagto.Obrig. @! Pertence("SN").and.IF(M->RV_TIPOCOD<>"1".and.M->RV_OBRIGAT="N",.T.,IF(M->RV_TIPOCOD="1".and.M->RV_OBRIGAT $ "SN",.T.,.F.)) S=Sim;N=Nao S
RV_QTDLANC C 1 0 Qtde.Lancto Pertence("123456789") S
RV_LCTODIA C 1 0 Lcto Diario @! Pertence("SN") R S=Sim;N=Nao S
RV_VLIMDE N 12 2 Valor De @E 999,999,999.99 R S
RV_VLIMATE N 12 2 Valor Ate @E 999,999,999.99 R S
RV_RLIMDE N 12 2 Ref. De @E 999,999,999.99 R S
RV_RLIMATE N 12 2 Ref. Ate @E 999,999,999.99 R S
RV_INSS C 1 0 INSS @! Pertence("SN") S=Sim;N=Nao S
RV_IR C 1 0 IR @! Pertence("SN") S=Sim;N=Nao S
RV_INSSFER C 1 0 INSS Fer. @! Pertence("12") R 1=Sim;2=Nao S
RV_FGTS C 1 0 FGTS @! Pertence("SN") S=Sim;N=Nao S
RV_INCORP C 1 0 Incorp. Sal. @! Pertence("SN") S=Sim;N=Nao S
RV_REF13 C 1 0 Ref. a 13o. @! Pertence("SN") S=Sim;N=Nao S
RV_REFFER C 1 0 Ref.a Ferias @! Pertence("SN") S=Sim;N=Nao S
RV_ADIANTA C 1 0 Ref. Adiant. @! Pertence("SN") S=Sim;N=Nao S
RV_PERICUL C 1 0 Periculosid. @! Pertence("SN") S=Sim;N=Nao S
RV_LEEINC C 1 0 Funcionarios 9 PERTENCE("12") R 1=Sim;2=Nao S
RV_LEEPRE C 1 0 Futuros 9 PERTENCE("12") R 1=Sim;2=Nao S
RV_INSALUB C 1 0 Insalubrid. @! Pertence("SN") S=Sim;N=Nao S
RV_PENSAO C 1 0 Pensao Alim. @! Pertence("SN") S=Sim;N=Nao S
RV_LEEAUS C 1 0 Ausencia 9 PERTENCE("12") R 1=Sim;2=Nao S
RV_LEEBEN C 1 0 Beneficiario 9 Pertence("12") R 1=Sim;2=Nao S
RV_DSRHE C 1 0 DSR H.Extra @! Pertence("SN") .AND. fCodDsrVld(M->RV_CODDSR) S=Sim;N=Nao S
RV_LEEFIX C 1 0 Fixos 9 PERTENCE("12") R 1=Sim;2=Nao S
RV_HE C 1 0 Hora Extra @! Pertence("SN") S=Sim;N=Nao S
RV_ADICTS C 1 0 Adic.T.Serv. @! Pertence("SN") S=Sim;N=Nao S
RV_SINDICA C 1 0 C. Sindical @! Pertence("SN") S=Sim;N=Nao S
RV_SALFAMI C 1 0 Sal. Familia @! Pertence("SN") S=Sim;N=Nao S
RV_SEGVIDA C 1 0 Seguro Vida @! Pertence("SN") S=Sim;N=Nao S
RV_DEDINSS C 1 0 Ded. G. INSS @! Pertence("SN") S=Sim;N=Nao S
RV_TAREFA C 3 0 Cod.Tarefa Vazio() .or. ChkTarefa(M->RV_TAREFA) S070 S
RV_PIS C 1 0 PIS @! Pertence("SN") S=Sim;N=Nao S
RV_ENCARCC C 1 0 Rateio C.Cto @! Pertence("SBN") S=Sim;N=Nao;B=Base S
RV_CUSTO C 1 0 Custo @! Pertence("SN") S=Sim;N=Nao S
RV_LCTOP C 3 0 Lcto. Padrao @! Vazio() .Or. (ExistCpo("CT5") .And. Entre("A00","Z99")) CT5 S
RV_MED13 C 2 0 Media 13o. @! fMed13AviVld(M->RV_MED13) S
RV_MEDFER C 2 0 Media Ferias @! CheckIns(M->RV_MEDFER) S
RV_MEDAVI C 2 0 Med.Av.Prev. @! fMed13AviVld(M->RV_MEDAVI) S
RV_GRAMED C 3 0 C.Agrup.Med. 999 Vazio() .Or. (EXISTCPO("SRV") .And. M->RV_COD # M->RV_GRAMED) S
RV_CONVCOL C 1 0 Conv.Colet. @! Pertence("SN") S=Sim;N=Nao S
RV_VALDISS C 1 0 Recal.lan.vl @! pertence("12") R 1=Sim;2=Nao S
RV_MEDREAJ C 1 0 Med.Reajust. @! Pertence("SN") S=Sim;N=Nao S
RV_RAIS C 60 0 RAIS @! CposInitWhen() .and. GP040VRAIS() SRVRAI S
RV_DIRF C 2 0 DIRF @! f040DIRFVld() 36 S
RV_COMPL_ C 1 0 Dissid. Ret. @! Pertence("SN") S=Sim;N=Nao S
RV_CODCOM_ C 3 0 Verba P.Diss @! VAZIO() .Or. (EXISTCPO("SRV") .And. M->RV_COD # M->RV_CODCOM_) VER S
RV_DSRPROF C 1 0 DSR Prof. @! Pertence("SN") S=Sim;N=Nao S
RV_HRSATIV C 1 0 Hs.Atividade @! Pertence("SN") S=Sim;N=Nao S
RV_CUSTEMP C 1 0 Ag.Custo PMS ! Pertence("12") 1=Sim;2=Nao S
RV_FECCOMP C 1 0 Fech Compete @! Pertence("12") R 1=Sim;2=Nao S
RV_COD13 C 3 0 Codigo 13o. @! ExistCpo("SRV") SRV R S
RV_CODFER C 3 0 Cod.Ferias @! ExistCpo("SRV") SRV R S
RV_CODMSEG C 3 0 V. Mes Segui @! Vazio() .or. ExistCpo("SRV") SRV R S
RV_DESMSEG C 20 0 Desc. Verba V S
RV_LANCPCO C 2 0 Lancto PCO @! Vazio() .or. ExistCpo("AKB",'000085'+M->RV_LANCPCO) AKB085 R S
RV_DESMEMO M 80 0 Expr. Filtro @! V S
RV_CODMEMO C 6 0 Cod. Expr @! R S
RV_GRPVERB C 10 0 Grupo Verba @! VAZIO() .Or. VldRVGrpPD(M->RV_GRPVERB) SRVGRP S
RV_CODDSR C 3 0 Verba DSR 999 Vazio() .Or. (EXISTCPO("SRV",,1) .And. M->RV_COD # M->RV_CODDSR) .AND. fCodDsrVld(M->RV_CODDSR) SRV R S
RV_CODBASE C 3 0 Cod.Base Cor @! VAZIO() .Or. (ExistCpo("SRV") .and. M->RV_COD # M->RV_CODBASE .and. fCodVld() ) SRV R S
RV_RRA C 1 0 RRA 9 Pertence("12") R 1=Sim;2=Nao S
RV_BASCAL C 1 0 Base Calculo @! Pertence("12") R 1=Salario Base;2=Salario Incorporado S
RV_NATUREZ C 4 0 Natureza 9999 fValNatur() S47 R S
RV_INCIRF C 2 0 Cd. Inc.IRRF 99 fValIRRF() SRVRF R !EMPTY(M->RV_NATUREZ) S
RV_INCFGTS C 2 0 Cd.Inc.FGTS 99 SRVFGT R !empty(M->RV_NATUREZ) S
RV_INCSIND C 2 0 Cd.Inc.Sind. 99 SRVSIN R !empty(M->RV_NATUREZ) S
RV_INCCP C 2 0 Cd.Inc.CP 99 fValINCCP() SRVCP R !empty(M->RV_NATUREZ) S
RV_TPPIRRF C 1 0 Tp.Proc.IRRF @! VAZIO() .OR. Pertence("AJ") R A=Administrativo;J=Judicial S
RV_NRPIRRF C 20 0 Nr.Proc.IRRF @! R S
RV_TPPFGTS C 1 0 Tp.Proc.FGTS @! VAZIO() .OR. Pertence ("AJ") R A=Administrativo;J=Judicial S
RV_NRPFGTS C 20 0 Nr.Proc.FGTS @! R S
RV_TPPSIND C 1 0 Tp.Proc.Sind @! VAZIO() .OR. Pertence ("AJ") R A=Administrativo;J=Judicial S
RV_NRPSIND C 20 0 Nr.Proc.Sind @! R S
RV_TPPROCP C 1 0 Tp.Proc.Prev @! VAZIO() .OR. Pertence("AJ") R A=Administrativo;J=Judicial S
RV_NRPROCP C 20 0 Nr.Proc.Prev @! R S
RV_EXPROCP C 1 0 Ex.Dec/Sente 9 VAZIO() .OR. PErtence ("12") R 1=Contrib. Patronais; 2=Contrib. Patronais + Segurados S
RV_FERSEG C 3 0 V. Dif. Fer. @! ExistCpo("SRV") SRV R S
RV_HOMOLOG C 3 0 V.Homolognet @! If(Empty(M->RV_HOMOLOG),.T.,If(M->RV_TIPOCOD=='1',ValidRCC('S020',M->RV_HOMOLOG,1,3),GPEM601V04(M->RV_TIPOCOD,1,M->RV_HOMOLOG))) S20RE R S
RV_EMPCONS C 1 0 Emp. Cons. @! Pertence("12") R 1=Sim;2=Nao S
RV_AGLTRCT C 1 0 Aglut. Media @! Pertence("1,2") R 1=Sim;2=Nao S
RV_ORIGEM C 1 0 Natureza @! Pertence("12") 1=Atrasado;2=Normal S
RV_CODREMU C 3 0 Cod Remuner @! VALIDRCC("S124",M->RV_CODREMU,1,3).OR.VAZIO() S124 S
RV_INSSJUB C 1 0 Tipo Contrib @! VAZIO() .Or. VldRVPrv(M->RV_INSSJUB) SRVPRV S
RV_BSEREMT C 1 0 Teto Const. @! Pertence("123") R 1=Considera para Teto Constitucional;2=Nao Considera para Teto Constitucional;3=Nao se aplica S
RV_INFDED C 1 0 Base Ded @! Pertence("SN") R S=Sim;N=Nao M->RV_TIPOCOD == '3' S
RV_REFABON C 1 0 Ref.Ab.Fer @! R 1=Sim;2=Nao S
RV_REFTAB C 1 0 Ref. Tabela @! Pertence("SN") R S=Sim;N=Nao S
RV_CODCRI C 2 0 Cod.Criterio 99 ExistCpo("RG9") R S
RV_COMPPRO C 1 0 Promoc. Ret. @! Pertence("12") R 1=Sim;2=Nao S
RV_CODPRTR C 3 0 Vb.Prom.Retr @! VAZIO() .Or. (EXISTCPO("SRV") .And. M->RV_COD # M->RV_CODPRTR) VER R S
RV_CODDIFE C 3 0 Cod.Dif.Fer @! ExistCpo("SRV") R S
RV_ACUMAUX C 80 0 Acumul.Aux. @! S112OP R S
RV_CODABO C 3 0 Verba Abono @! Vazio() .or. ExistCpo("SRV") SRV R S