AEVEPCOL

215 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PEVENTO.CODCOLIGADA FKAEVEPCOL_PEVENTOR
AEVECALC.CODCOLIGADA FKAEVEPCOL_AEVECALCR
GFORMULA.CODCOLIGADA FKAEVEPCOL_GFORMULAR
APARCOL.CODCOLIGADA FKAEVEPCOL_APARCOLR
CODPARCOL varchar 4 null
APARCOL.CODIGO FKAEVEPCOL_APARCOLR
CODEVEPTO varchar 4 null
AEVECALC.CODEVENTO FKAEVEPCOL_AEVECALCR
CODEVEREL varchar 4 null
PEVENTO.CODIGO FKAEVEPCOL_PEVENTOR
COMPEXTRA smallint 2 √ null
CODEVEDIF varchar 4 √ null
CODEVEDIF2 varchar 4 √ null
CODEVEBANCO varchar 4 √ null
CONSPERCENT smallint 2 √ null
CODFORMUL varchar 8 √ null
GFORMULA.CODIGO FKAEVEPCOL_GFORMULAR
APLICACAO varchar 1 √ null
GFORMULA.APLICACAO FKAEVEPCOL_GFORMULAR
ATITUDE smallint 2 √ ((1))
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
COMPENSAR smallint 2 √ ((1))
TIPOFAIXA smallint 2 √ null
INICIOFAIXA int 4 √ null
FIMFAIXA int 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PKAEVEPCOL Primary key Asc/Asc/Asc CODCOLIGADA + CODPARCOL + CODEVEPTO

Relationships

Close relationships within degrees of separation