FREMDEBAUT

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
FLANREMESSA.CODCOLIGADA FKFLANREMESSA_FREMDEBAUTR
FCONVENIO.CODCOLIGADA FKFREMDEBAUT_FCONVENIOR
GFILIAL.CODCOLIGADA FKFREMDEBAUT_GFILIALR
IDREMDEBAUT int 4 null
FLANREMESSA.IDREMDEBAUT FKFLANREMESSA_FREMDEBAUTR
IDRELATORIO int 4 √ null
RRELAT.ID FKFREMDEBAUT_RRELATR
NUMREMESSA int 4 √ null
CODCONVENIO varchar 20 √ null
CODAGENCIA varchar 6 √ null
DVAGENCIA varchar 1 √ null
NROCONTA varchar 12 √ null
DVCONTA varchar 1 √ null
DVAGENCIACONTA varchar 1 √ null
NOMEEMPRESA varchar 30 √ null
NUMBANCO varchar 3 √ null
GBANCO.NUMBANCO FKFREMDEBAUT_GBANCOR
CODFILIAL smallint 2 √ null
GFILIAL.CODFILIAL FKFREMDEBAUT_GFILIALR
CODCOLRELAT smallint 2 √ null
RRELAT.CODCOLIGADA FKFREMDEBAUT_RRELATR
ATIVO smallint 2 √ ((1))
CODCOLCONTA smallint 2 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
IDCONVENIO int 4 √ null
FCONVENIO.IDCONVENIO FKFREMDEBAUT_FCONVENIOR

Indexes

Constraint Name Type Sort Column(s)
PKFREMDEBAUT Primary key Asc/Asc CODCOLIGADA + IDREMDEBAUT

Relationships

Close relationships within degrees of separation