TITMMOVBEM

8 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
ILOCAL.CODCOLIGADA FKTITMMOVBEM_ILOCALR
TITMMOV.CODCOLIGADA FKTITMMOVBEM_TITMMOVR
IPATRIMONIO.CODCOLIGADA FKTITMMOVBEM_IPATRIMONIOR
IDMOV int 4 null
TITMMOV.IDMOV FKTITMMOVBEM_TITMMOVR
NSEQITMMOV int 4 null
TITMMOV.NSEQITMMOV FKTITMMOVBEM_TITMMOVR
CODBEM DCODBEM 25 null
CODLOCAL varchar 40 √ null
ILOCAL.CODLOCAL FKTITMMOVBEM_ILOCALR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
IDPATRIMONIO int 4 ((1))
IPATRIMONIO.IDPATRIMONIO FKTITMMOVBEM_IPATRIMONIOR

Indexes

Constraint Name Type Sort Column(s)
PKTITMMOVBEM Primary key Asc/Asc/Asc/Asc CODCOLIGADA + IDMOV + NSEQITMMOV + IDPATRIMONIO
T$TITMMOVBEM_TITMMOV Performance Asc/Asc/Asc CODCOLIGADA + IDMOV + NSEQITMMOV

Relationships

Close relationships within degrees of separation