TTB3

3 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
TCNT.CODCOLIGADA FKTCNT_TTB3R
TCNTPAR.CODCOLIGADA FKTCNTPAR_TTB3R
TCONTORCAMENTARIO.CODCOLIGADA FKTCONTORCAMENTARIO_TTB3R
TFAB.CODCOLIGADA FKTFAB_TTB3R
TFITMMOV.CODCOLIGADA FKTFITMMOV_TTB3R
TFMOV.CODCOLIGADA FKTFMOV_TTB3R
TITMCNT.CODCOLIGADA FKTITMCNT_TTB3R
TITMMOV.CODCOLIGADA FKTITMMOV_TTB3R
TITMTMV.CODCOLIGADA FKTITMTMV_TTB3R
TMOV.CODCOLIGADA FKTMOV_TTB3R
TPRODUTODEF.CODCOLIGADA FKTPRDDEF_TTB3R
TTB3CFO.CODCOLIGADA FKTTB3CFO_TTB3R
TTB3COMPL.CODCOLIGADA FKTTB3COMPL_TTB3R
TTB3CONT.CODCOLIGADA FKTTB3CONT_TTB3R
TTMV.CODCOLIGADA FKTTMV_TTB3R
GCOLIGADA.CODCOLIGADA FKTTB3_GCOLIGADAR
CODTB3FAT varchar 10 null
TCNT.CODTB3FAT FKTCNT_TTB3R
TCNTPAR.CODTB3FAT FKTCNTPAR_TTB3R
TCONTORCAMENTARIO.CODTB3FAT FKTCONTORCAMENTARIO_TTB3R
TFAB.CODTB3FAT FKTFAB_TTB3R
TFITMMOV.CODTB3FAT FKTFITMMOV_TTB3R
TFMOV.CODTB3FAT FKTFMOV_TTB3R
TITMCNT.CODTB3FAT FKTITMCNT_TTB3R
TITMMOV.CODTB3FAT FKTITMMOV_TTB3R
TITMTMV.CODTB3FATIT FKTITMTMV_TTB3R
TMOV.CODTB3FAT FKTMOV_TTB3R
TPRODUTODEF.CODTB3FAT FKTPRDDEF_TTB3R
TTB3CFO.CODTB3FAT FKTTB3CFO_TTB3R
TTB3COMPL.CODTB3FAT FKTTB3COMPL_TTB3R
TTB3CONT.CODTB3FAT FKTTB3CONT_TTB3R
TTMV.CODTB3FATMOV FKTTMV_TTB3R
DESCRICAO varchar 100 √ null
COMISSAO RMDVALOR2 17,2 √ null
CAMPOLIVRE varchar 20 √ null
CODCOLCONTAGER DCODCOLIGADANULL 2 √ null
CGERENCIA.CODCOLIGADA FKTTB3_CGERENCIAR
CODCONTAGER DCODCONTA 40 √ null
CGERENCIA.CODCONTA FKTTB3_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)
PKTTB3 Primary key Asc/Asc CODCOLIGADA + CODTB3FAT

Relationships

Close relationships within degrees of separation