PORCAMENTOBENEFICIOS

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODIGO int 4 null
PORCAMENTOBENEFICIOSACALCULAR.CODBENEFICIO FKPORCAMENTOBENEFICALC_PORCAMER
CODCOLIGADA DCODCOLIGADA 2 null
PORCAMENTOBENEFICIOSACALCULAR.CODCOLIGADA FKPORCAMENTOBENEFICALC_PORCAMER
PORCAMENTO.CODCOLIGADA FKPORCAMENTOBENEFICIOS_PORCAMER
CODORCAMENTO varchar 20 null
PORCAMENTOBENEFICIOSACALCULAR.CODORCAMENTO FKPORCAMENTOBENEFICALC_PORCAMER
PORCAMENTO.CODIGO FKPORCAMENTOBENEFICIOS_PORCAMER
REVISAO int 4 null
PORCAMENTOBENEFICIOSACALCULAR.REVISAO FKPORCAMENTOBENEFICALC_PORCAMER
PORCAMENTO.REVISAO FKPORCAMENTOBENEFICIOS_PORCAMER
MESCOMP smallint 2 √ null
ANOCOMP smallint 2 √ null
DATALIMITE DDATETIME 16,3 null
QUEBRASECAO varchar 35 √ null
SELCHAPA varchar 16 √ null
SELPERFIL varchar 10 √ null
SELSECAO varchar 35 √ null
SELFUNCAO varchar 10 √ null
SELTIPORECEBIMENTO varchar 8 √ null
SELTIPOFUNCIONARIO varchar 18 √ 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)
PKPORCAMENTOBENEFICIOS Primary key Asc/Asc/Asc/Asc CODIGO + CODCOLIGADA + CODORCAMENTO + REVISAO

Relationships

Close relationships within degrees of separation