operacaotipocobranca


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idoperacaotipocobranca int8 19 null
operacaotipocobranca_aud.idoperacaotipocobranca Implied Constraint R
idoperacao int8 19 null
operacao.idoperacao fk_9krrmbd9cl6iprhbw97buxb8m R
idtipocobranca int8 19 √ null
tipocobranca.idtipocobranca fk_5w0r30cpm9cqwnhruwts6v170 R
valor numeric 18,6 null
percentualbasecalculo numeric 18,6 √ null
valorminimo numeric 18,6 √ null
valormaximo numeric 18,6 √ null
datainiciovigencia date 13 √ null
datafimvigencia date 13 √ null
idsegmento int8 19 √ null
segmento.idsegmento fk_t9d70ckfw4in07s379p73m7xv R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pkb5fe26b9 Primary key Asc idoperacaotipocobranca
idx17e7c7e9 Performance Asc idsegmento
idx64c2fac6 Performance Asc idtipocobranca
idxfff315b9 Performance Asc idoperacao
idxwsversao_b5fe26b9 Performance Desc wsversao
ucdcadf881 Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation