TMOTIVOREFMOV

89 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
TTMVEXT.CODCOLIGADA FKTTMVEXT_TMOTIVOREFMOVR
TTMV.CODCOLIGADA FKTMOTIVOREFMOV_TTMVR
IDMOTIVOREF int 4 null
TTMVEXT.IDMOTIVOREF FKTTMVEXT_TMOTIVOREFMOVR
DESCRICAO varchar 100 √ null
ORIGEMREF int 4 √ null
PERMITENMOV smallint 2 √ null
COPIARITENS smallint 2 √ null
CONSISTEQTDEITENS smallint 2 √ null
CONSISTECFO smallint 2 √ null
CODTMOVDEFAULT varchar 10 √ null
TTMV.CODTMV FKTMOTIVOREFMOV_TTMVR
PERMITEINCITEM 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)
PKTMOTIVOREFMOV Primary key Asc/Asc CODCOLIGADA + IDMOTIVOREF

Relationships

Close relationships within degrees of separation