TMEN

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
TITMMOV.CODCOLIGADA FKTITMMOV_TMENR
TITMTMV.CODCOLIGADA FKTITMTMV_TMENR
TMOV.CODCOLIGADA FKTMOV_TMENFRETER
TNATMEN.CODCOLIGADA PKTNATMEN_TMENDESPESAR
TTMV.CODCOLIGADA FKTTMV_TMENMOV2R
GCOLIGADA.CODCOLIGADA FKTMEN_GCOLR
CODMEN varchar 5 null
TITMMOV.CODMEN FKTITMMOV_TMENR
TITMTMV.CODMENIT FKTITMTMV_TMENR
TMOV.CODMEN FKTMOV_TMENR
TMOV.CODMEN2 FKTMOV_TMEN2R
TMOV.CODMENDESCONTO FKTMOV_TMENDESCONTOR
TMOV.CODMENDESPESA FKTMOV_TMENDESPESAR
TMOV.CODMENFRETE FKTMOV_TMENFRETER
TNATMEN.CODMEN PKTNATMEN_TMENR
TNATMEN.CODMEN2 PKTNATMEN_TMEN2R
TNATMEN.CODMENDESCONTO PKTNATMEN_TMENDESCONTOR
TNATMEN.CODMENDESPESA PKTNATMEN_TMENDESPESAR
TNATMEN.CODMENFRETE PKTNATMEN_TMENFRETER
TTMV.CODMENDESCMOV FKTTMV_TMENDESCMOVR
TTMV.CODMENDESPMOV FKTTMV_TMENDESPMOVR
TTMV.CODMENFRETECIF FKTTMV_TMENCIFR
TTMV.CODMENFRETEFOB FKTTMV_TMENFOBR
TTMV.CODMENFRETETERCEIRO FKTTMV_TMENR
TTMV.CODMENMOV1 FKTTMV_TMENMOV1R
TTMV.CODMENMOV2 FKTTMV_TMENMOV2R
DESCRICAO varchar 100 √ null
DESCRICAOMEMO MEMO 2147483647 √ null
CODCLASSEMEN DTCODIGO 15 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
ASSUNTO varchar 100 √ null

Indexes

Constraint Name Type Sort Column(s)
PKTMEN Primary key Asc/Asc CODCOLIGADA + CODMEN
TXMENCOD Performance Asc CODMEN

Relationships

Close relationships within degrees of separation