TTB4

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
TCNT.CODCOLIGADA FKTCNT_TTB4R
TCNTPAR.CODCOLIGADA FKTCNTPAR_TTB4R
TCONTORCAMENTARIO.CODCOLIGADA FKTCONTORCAMENTARIO_TTB4R
TFAB.CODCOLIGADA FKTFAB_TTB4R
TFITMMOV.CODCOLIGADA FKTFITMMOV_TTB4R
TFMOV.CODCOLIGADA FKTFMOV_TTB4R
TITMCNT.CODCOLIGADA FKTITMCNT_TTB4R
TITMMOV.CODCOLIGADA FKTITMMOV_TTB4R
TITMTMV.CODCOLIGADA FKTITMTMV_TTB4R
TMOV.CODCOLIGADA FKTMOV_TTB4R
TPRODUTODEF.CODCOLIGADA FKTPRDDEF_TTB4R
TTB4CFO.CODCOLIGADA FKTTB4CFO_TTB4R
TTB4COMPL.CODCOLIGADA FKTTB4COMPL_TTB4R
TTB4CONT.CODCOLIGADA FKTTB4CONT_TTB4R
TTMV.CODCOLIGADA FKTTMV_TTB4R
GCOLIGADA.CODCOLIGADA FKTTB4_GCOLIGADAR
CODTB4FAT varchar 10 null
TCNT.CODTB4FAT FKTCNT_TTB4R
TCNTPAR.CODTB4FAT FKTCNTPAR_TTB4R
TCONTORCAMENTARIO.CODTB4FAT FKTCONTORCAMENTARIO_TTB4R
TFAB.CODTB4FAT FKTFAB_TTB4R
TFITMMOV.CODTB4FAT FKTFITMMOV_TTB4R
TFMOV.CODTB4FAT FKTFMOV_TTB4R
TITMCNT.CODTB4FAT FKTITMCNT_TTB4R
TITMMOV.CODTB4FAT FKTITMMOV_TTB4R
TITMTMV.CODTB4FATIT FKTITMTMV_TTB4R
TMOV.CODTB4FAT FKTMOV_TTB4R
TPRODUTODEF.CODTB4FAT FKTPRDDEF_TTB4R
TTB4CFO.CODTB4FAT FKTTB4CFO_TTB4R
TTB4COMPL.CODTB4FAT FKTTB4COMPL_TTB4R
TTB4CONT.CODTB4FAT FKTTB4CONT_TTB4R
TTMV.CODTB4FATMOV FKTTMV_TTB4R
DESCRICAO varchar 100 √ null
COMISSAO RMDVALOR2 17,2 √ null
CAMPOLIVRE varchar 20 √ null
CODCOLCONTAGER DCODCOLIGADANULL 2 √ null
CGERENCIA.CODCOLIGADA FKTTB4_CGERENCIAR
CODCONTAGER DCODCONTA 40 √ null
CGERENCIA.CODCONTA FKTTB4_CGERENCIAR
INATIVO smallint 2 √ (0)
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)
PKTTB4 Primary key Asc/Asc CODCOLIGADA + CODTB4FAT

Relationships

Close relationships within degrees of separation