FBAN

21 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODBANCO varchar 3 null
NOMEREDUZIDO varchar 15 √ null
NOME varchar 40 √ null
CODCXARETORNO varchar 10 √ null
FCXA.CODCXA FKFBAN_FCXAR
POSINICHAVELAN int 4 √ null
POSFIMCHAVELAN int 4 √ null
POSINIDATABAIXA int 4 √ null
POSFIMDATABAIXA int 4 √ null
POSINIVALORBAIXA int 4 √ null
POSFIMVALORBAIXA int 4 √ null
POSINIERROS int 4 √ null
POSFIMERROS int 4 √ null
TAMERRO int 4 √ null
POSININOSSONUM int 4 √ null
POSFIMNOSSONUM int 4 √ null
POSINICODRETORNO int 4 √ null
POSFIMCODRETORNO int 4 √ null
CODBAIXA varchar 40 √ null
CODREGISTRADO varchar 3 √ null
CODRECUSADO varchar 40 √ null
POSCODBANCO int 4 √ null
CODCOLCXA DCODCOLIGADA 2 null
FCXA.CODCOLIGADA FKFBAN_FCXAR
CODCOLIGADA DCODCOLIGADA 2 null
CNABCOMANDOINCLUSAO smallint 2 √ null
POSINICHAVELAN2 smallint 2 √ null
POSFIMCHAVELAN2 smallint 2 √ null
POSINIDESCONTO smallint 2 √ null
POSFIMDESCONTO smallint 2 √ null
POSINIJUROS smallint 2 √ null
POSFIMJUROS smallint 2 √ null
POSINIMULTA smallint 2 √ null
POSFIMMULTA smallint 2 √ 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)
PKFBAN Primary key Asc/Asc CODCOLIGADA + CODBANCO

Relationships

Close relationships within degrees of separation