FRECONCIL

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
FRECONCILRELAC.CODCOLRECONCIL FKFRECONCILRELAC_FRECONCILR
IDRECONCIL int 4 null
FRECONCILRELAC.IDRECONCIL FKFRECONCILRELAC_FRECONCILR
NUMBANCO varchar 3 √ null
GAGENCIA.NUMBANCO FKFRECONCIL_GAGENCIAR
FCONTA.NUMBANCO FKFRECONCIL_FCONTAR
GBANCO.NUMBANCO FKFRECONCIL_GBANCOR
CODCOLCXA DCODCOLIGADA 2 null
FCXA.CODCOLIGADA FKFRECONCIL_FCXAR
CODCXA varchar 10 √ null
FCXA.CODCXA FKFRECONCIL_FCXAR
RECONCILIADO smallint 2 √ null
DATA datetime 16,3 √ null
CATEGORIA smallint 2 √ null
NUMERODOCUMENTO varchar 40 √ null
VALOR RMDVALOR4 17,4 √ null
HISTORICO varchar 255 √ null
CODAGENCIA varchar 6 √ null
FCONTA.NUMAGENCIA FKFRECONCIL_FCONTAR
GAGENCIA.NUMAGENCIA FKFRECONCIL_GAGENCIAR
CODCONTA varchar 15 √ null
FCONTA.NROCONTA FKFRECONCIL_FCONTAR
CODCOLCONTA DCODCOLIGADA 2 null
FCONTA.CODCOLIGADA FKFRECONCIL_FCONTAR
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)
PKFRECONCIL Primary key Asc/Asc CODCOLIGADA + IDRECONCIL

Relationships

Close relationships within degrees of separation