XCOBRANCA

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDCOBRANCA int 4 null
XLOGCOBRANCA.IDCOBRANCA Implied ConstraintR
XLOGCOBRANCALANC.IDCOBRANCA Implied ConstraintR
CODCOLIGADA DCODCOLIGADA 2 null
GCOLIGADA.CODCOLIGADA FKXCOBRANCA_GCOLIGADAR
CONTRATO varchar 100 null
TIPOORIGEMCOBRANCA smallint 2 null
IDCARTEIRA int 4 √ null
XCOBRANCACARTEIRA.IDCARTEIRA FKXCOBRANCA_XCOBRANCACARTEIRAR
STATUS smallint 2 null
CODCOLCFO DCODCOLIGADA 2 null
FCFO.CODCOLIGADA FKXCOBRANCA_FCFOR
CODCFO varchar 25 null
FCFO.CODCFO FKXCOBRANCA_FCFOR
DATAABERTURA datetime 16,3 null
DATACOBRANCA datetime 16,3 √ null
DATAFECHAMENTO datetime 16,3 √ 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)
PKXCOBRANCA Primary key Asc IDCOBRANCA
IXXCOBRANCA01 Performance Asc/Asc/Asc CODCOLIGADA + CONTRATO + TIPOORIGEMCOBRANCA
IXXCOBRANCA02 Performance Asc/Asc CODCOLCFO + CODCFO

Relationships

Close relationships within degrees of separation