DPERIODOCONTRIBPREV

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDPERCONTRIBPREV int 4 null
DEVENTOREINFPERCONPREV.IDPERCONTRIBPREV FKDEVENTOREINFPERCONPREV_DPERIR
CODCOLIGADA DCODCOLIGADA 2 null
DEVENTOREINFPERCONPREV.CODCOLIGADA FKDEVENTOREINFPERCONPREV_DPERIR
DPERIODO.CODCOLIGADA FKDPERIODOCONTRIBPREV_DPERIODOR
IDPER int 4 √ null
DPERIODO.IDPER FKDPERIODOCONTRIBPREV_DPERIODOR
CODFILIAL int 4 √ null
CODATIVECONOMIC varchar 8 √ null
ALIQUOTA RMDVALOR4 17,4 √ null
CODRECEITA varchar 6 √ null
VALORRECEITAS RMDVALOR2 17,2 √ null
VALOREXCLUSOES RMDVALOR2 17,2 √ null
BASECALCULO RMDVALOR2 17,2 √ null
VALORCONTRIBUICAO RMDVALOR2 17,2 √ null
AJUSTEACRESCIMO RMDVALOR2 17,2 √ null
AJUSTEREDUCAO RMDVALOR2 17,2 √ null
CAMPOLIVRE1 varchar 255 √ null
CAMPOLIVRE2 varchar 255 √ null
VALORLIVRE1 RMDVALOR2 17,2 √ null
VALORLIVRE2 RMDVALOR2 17,2 √ null
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)
PKDPERIODOCONTRIBPREV Primary key Asc/Asc IDPERCONTRIBPREV + CODCOLIGADA

Relationships

Close relationships within degrees of separation