AEVECALC

113 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
ABANCOHORFUNDETALHE.CODCOLIGADA FKABANCOHORFUNDETALHE_AEVECALCR
AEVENTOTIPOOCORRENCIA.CODCOLIGADA FKAEVENTOTIPOOCOR_AEVECALCR
AEVEPCOL.CODCOLIGADA FKAEVEPCOL_AEVECALCR
ASALDOBANCOHORFUNDETALHE.CODCOLIGADA FKASALDOBANCHORFUNDET_AEVECALCR
CODEVENTO varchar 4 null
ABANCOHORFUNDETALHE.CODEVENTO FKABANCOHORFUNDETALHE_AEVECALCR
AEVENTOTIPOOCORRENCIA.CODEVENTO FKAEVENTOTIPOOCOR_AEVECALCR
AEVEPCOL.CODEVEPTO FKAEVEPCOL_AEVECALCR
ASALDOBANCOHORFUNDETALHE.CODEVENTO FKASALDOBANCHORFUNDET_AEVECALCR
DESCRICAO varchar 50 √ null
CODCALC varchar 4 √ null
AEVENTO.CODCLIENTE FKAEVECALC_AEVENTOR
EVECALCFORM smallint 2 √ null
FORMULA varchar 8 √ null
PRIORIDADE smallint 2 √ null
ID int identity 4 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
TIPOEVENTO smallint 2 √ null

Indexes

Constraint Name Type Sort Column(s)
PKAEVECALC Primary key Asc/Asc CODCOLIGADA + CODEVENTO
AXEVECALCID Must be unique Asc ID

Relationships

Close relationships within degrees of separation