PPARAM

3 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
GCOLIGADA.CODCOLIGADA FKPPARAM_GCOLIGADAR
PCODEMPRT.CODCOLIGADA FKPPARAM_PCODEMPRTR
PEVENTO.CODCOLIGADA FKPPARAM_PEVENTOPROVEMPR
GFORMULA.CODCOLIGADA FKPPARAM_GFORMULAFPR
MESCAIXA smallint 2 √ null
ANOCAIXA int 4 √ null
MESCOMP smallint 2 √ null
ANOCOMP int 4 √ null
PERIODO smallint 2 √ null
DIAPAGAMENTO smallint 2 √ null
PERSEMANAL varchar 32 √ null
PERQUINZENAL varchar 32 √ null
PERMENSAL varchar 32 √ null
TAMCHAPA smallint 2 √ null
CODFORDIGITO varchar 8 √ null
GFORMULA.CODIGO FKPPARAM_GFORMULADCR
VERSAOARQ int 4 √ null
SALFAMILIAPROP smallint 2 √ null
SALNOMINALSALFAMILIA smallint 2 √ null
SALFAMILIAAFASTPREV smallint 2 √ null
SALNOMINALVALETRANSP smallint 2 √ null
GUARDAALTERACOES smallint 2 √ null
GERALOGACAO smallint 2 √ null
DIGITOVERIFCHAPA smallint 2 √ null
CONTROLEINCLUSAOEVENTO smallint 2 √ null
CONTROLEINCLUSAOFORMULA smallint 2 √ null
CONTROLEINCLUSAOSECAO smallint 2 √ null
CONTROLEINCLUSAOFUNCAO smallint 2 √ null
EDITASALMESHORISTA smallint 2 √ null
DIFMEDIAPROP smallint 2 √ null
DEDUZINSSINTEGRAL smallint 2 √ null
SEMPREDESCINSSFERIAS smallint 2 √ null
PAGAADIANTFERIAS smallint 2 √ null
UMTERCOSEM30DIAS smallint 2 √ null
MANTEMPERAQUISMENOS1ANO smallint 2 √ null
CONSIDERAFALTASPROV smallint 2 √ null
LANCASALDOFGTSRESCISAO smallint 2 √ null
LANCAAVISORESCISAO smallint 2 √ null
LANCASALDOSALRESCISAO smallint 2 √ null
EVTSALDOSALARIO varchar 4 √ null
PEVENTO.CODIGO FKPPARAM_PEVENTOR
SOMAAVOSAVISOAPOSCALC smallint 2 √ null
TEMPPAGA13 smallint 2 √ null
TEMPPAGASALFAMILIA smallint 2 √ null
TEMPPAGAFGTS22 smallint 2 √ null
BITRIBUTACAO smallint 2 √ null
SALATUAL1APARC13 smallint 2 √ null
AVOSATEDEZ1APARC13 smallint 2 √ null
AVOSATEMESATUALPARC13 smallint 2 √ null
BACKUPJAFEITO smallint 2 √ null
BACKUPOBRIGATORIO smallint 2 √ null
RECALCULAR smallint 2 √ null
ADIANTAMENTOPAGO smallint 2 √ null
ADIANTAMENTODESC smallint 2 √ null
MESCOMERCIALADMISSAO smallint 2 √ null
IMPRIMEDURANTECALC smallint 2 √ null
LIMITAHORASNORMAIS smallint 2 √ null
UTILIZACEI smallint 2 √ null
PROPORCIONALIZAEV smallint 2 √ null
QUEBRAMESTRE varchar 35 √ null
CHAVEATIVA varchar 10 √ null
CODIGOQUEBRACGC varchar 35 √ null
CODQUEBRACEI varchar 35 √ null
CODFORMULA13 varchar 8 √ null
GFORMULA.CODIGO FKPPARAM_GFORMULA13R
CODFORFERIAS varchar 8 √ null
GFORMULA.CODIGO FKPPARAM_GFORMULAFER
CODFORFERIASPROP varchar 8 √ null
GFORMULA.CODIGO FKPPARAM_GFORMULAFPR
MASCARAQUEBRA varchar 35 √ null
ULTMODCALCULODATA datetime 16,3 √ null
ULTMODCALCULOHORA datetime 16,3 √ null
APLICACAO varchar 1 √ ('P')
GFORMULA.APLICACAO FKPPARAM_GFOREVTSALDOSALR
DESCINSSTETOFERIAS smallint 2 √ (0)
FORDIASFERIAS varchar 8 √ null
GFORMULA.CODIGO FKPPARAM_GFORMULADIASR
FORFERIASFALTA varchar 8 √ null
GFORMULA.CODIGO FKPPARAM_GFORFERIASFALTASR
USALIMITEFUNC smallint 2 √ (0)
USALIMITESEC smallint 2 √ (0)
PERMITEINCLUSAOFUNC smallint 2 √ (0)
PERMITEINCLUSAOSEC smallint 2 √ (0)
MASCARASECAO varchar 35 √ null
FOREVTSALDOSALARIO varchar 8 √ null
GFORMULA.CODIGO FKPPARAM_GFOREVTSALDOSALR
CODFIXOSRESCISAO varchar 40 √ null
REMOVEZERADOS DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
USACENTROCUSTO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
VISAOSALARIOOK DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
SOPERMITEINCLUSAOFUNCVITAE DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
NUMBANCOFGTSDEFAULT varchar 3 √ null
GBANCO.NUMBANCO FKPPARAM_GBANCOR
SISTEMACONTROLAFICHAREG DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
USALANCAEMPRESTIMOFERIAS DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
TIPOEMPRESTIMOFERIAS varchar 10 √ null
PCODEMPRT.CODCLIENTE FKPPARAM_PCODEMPRTR
MINPARCELASDESCEMPRESTFERIAS smallint 2 √ null
MAXPARCELASDESCEMPRESTFERIAS smallint 2 √ null
EVTDESCEMPRESTIMO varchar 4 √ null
PEVENTO.CODIGO FKPPARAM_PEVENTODESCEMPR
PERIODICIDADEDESCEMPFERIAS smallint 2 √ null
NOMEPAISIDENTFUNC smallint 2 √ (0)
QUIOSQUEPERMITEALTEND smallint 2 √ (0)
QUIOSQUEPERMITEALTBCOPAGTO smallint 2 √ (0)
QUIOSQUEPERMITEALTFERIAS smallint 2 √ (0)
ANOCOMPCONSULTAQUIOSQUE smallint 2 √ null
MESCOMPCONSULTAQUIOSQUE smallint 2 √ null
NROPERIODOCONSULTAQUIOSQUE smallint 2 √ null
ENVSOMENTEMESATUAL smallint 2 √ (1)
MESCOMPSEFIP smallint 2 √ null
ANOCOMPSEFIP int 4 √ null
USATOMADOR DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
CODFORFATOR varchar 8 √ null
GFORMULA.CODIGO FKPPARAM_GFORMULAFATORPROPR
EVTPROVEMPRESTIMO varchar 4 √ null
PEVENTO.CODIGO FKPPARAM_PEVENTOPROVEMPR
MASCARACEP varchar 9 √ null
MASCARATELEFONE varchar 15 √ null
MASCARACHAPA varchar 16 √ null
CODTOMADOREMPRESA varchar 25 √ null
FCFO.CODCFO FKPPARAM_FCFOR
ARREDCONFORMESEFIP DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
CALCSALMATCONFSEFIP DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
LANCASALMATERSEFIP DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
ENDDIRETOWEB DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
BANCODIRETOWEB DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
DIASALTBCO int 4 √ null
DTAPAGTOFERIASWEB datetime 16,3 √ null
DIASDTAPAGTOFERIAS int 4 √ null
VISUALDEMONSTRPAGTOWEB DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
VISUALRECIBOFERIASWEB DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
CONSISTEDUPLICIDADECPF smallint 2 √ (0)
INSSDISCRIMRECFERIAS smallint 2 √ (0)
NROENTREAAFASTAMENTO smallint 2 √ null
MOSTRAALERTACHAPA DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
DTFECHAMENTOFOLHA datetime 16,3 √ null
MOSTAREVENTOSZERADOS DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
USAPROVISAO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
USAAASDISCRIMINADO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
PATHIMPORTACAO varchar 100 √ null
LANCCC145 DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
DESCFUNCAOVISAOFUNC DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
BUSCASALARIOFAIXA DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
PATHLOGQUIOSQUE varchar 100 √ null
CRIALOGQUIOSQUE smallint 2 √ null
CODCOLTOMADOR DCODCOLIGADANULL 2 √ null
FCFO.CODCOLIGADA FKPPARAM_FCFOR
NROPERIODOSEFIP int 4 √ null
COPIADADOSDEPENDENTES smallint 2 √ null
FATCALCSALPROF RMDVALOR2 17,2 √ null
EXIBDESCRPERIODO smallint 2 √ (0)
REPROGSALCC smallint 2 √ (0)
CLPROPORCIONAL smallint 2 √ null
PROVADICFER smallint 2 √ (0)
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PKPPARAM Primary key Asc CODCOLIGADA

Relationships

Close relationships within degrees of separation