PCONTABILIZACAO

38 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
CODLOTE int 4 null
CODLOTESALDUS int 4 null
DESCRICAO varchar 100 √ null
DATAGERACAO DDATETIME 16,3 √ null
DATAINICIAL DDATETIME 16,3 √ null
DATAFINAL DDATETIME 16,3 √ null
STATUS smallint 2 √ null
TOTALDEBITOS RMDVALOR2 17,2 √ null
TOTALCREDITOS RMDVALOR2 17,2 √ null
VALORSOMA RMDVALOR2 17,2 √ null
USUARIOATUAL varchar 20 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
UUID varchar 255 √ null
HCFILAMENSAGEM.UUID Implied ConstraintR
STATUSINTEGRACAO smallint 2 ((0))

Indexes

Constraint Name Type Sort Column(s)
PKPCONTABILIZACAO Primary key Asc/Asc CODCOLIGADA + CODLOTE

Relationships

Close relationships within degrees of separation