CCONTAHISTORICO

8 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
CCONTA.CODCOLIGADA FKCCONTA_CCONTAHISTORICOR
CODCONTA DCODCONTA 40 null
CCONTA.CODCONTA FKCCONTA_CCONTAHISTORICOR
DATA datetime 16,3 null
REDUZIDO varchar 20 √ null
DESCRICAO varchar 100 √ null
ANALITICA smallint 2 √ null
NATUREZA smallint 2 √ null
USUARIOINCLU varchar 20 √ null
USUARIOALTER varchar 20 √ null
CODCOLCONTAESTORNO DCODCOLIGADANULL 2 √ null
CCONTA.CODCOLIGADA FKCCONTAESTORN_CCONTAHISTORICOR
CONTAESTORNO DCODCONTA 40 √ null
CCONTA.CODCONTA FKCCONTAESTORN_CCONTAHISTORICOR
NATSPED varchar 3 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
DATAULTCONCILIACAO datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PKCCONTAHISTORICO Primary key Asc/Asc/Asc CODCOLIGADA + CODCONTA + DATA

Relationships

Close relationships within degrees of separation