TTB1

18 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
TCNT.CODCOLIGADA FKTCNT_TTB1R
TCNTPAR.CODCOLIGADA FKTCNTPAR_TTB1R
TCONTORCAMENTARIO.CODCOLIGADA FKTCONTORCAMENTARIO_TTB1R
TFAB.CODCOLIGADA FKTFAB_TTB1R
TFITMMOV.CODCOLIGADA FKTFITMMOV_TTB1R
TFMOV.CODCOLIGADA FKTFMOV_TTB1R
TITMCNT.CODCOLIGADA FKTITMCNT_TTB1R
TITMMOV.CODCOLIGADA FKTITMMOV_TTB1R
TITMTMV.CODCOLIGADA FKTITMTMV_TTB1R
TMOV.CODCOLIGADA FKTMOV_TTB1R
TPRODUTODEF.CODCOLIGADA FKTPRDDEF_TTB1R
TTB1CFO.CODCOLIGADA FKTTB1CFO_TTB1R
TTB1COMPL.CODCOLIGADA FKTTB1COMPL_TTB1R
TTB1CONT.CODCOLIGADA FKTTB1CONT_TTB1R
TTMV.CODCOLIGADA FKTTMV_TTB1R
GCOLIGADA.CODCOLIGADA FKTTB1_GCOLIGADAR
CODTB1FAT varchar 10 null
TCNT.CODTB1FAT FKTCNT_TTB1R
TCNTPAR.CODTB1FAT FKTCNTPAR_TTB1R
TCONTORCAMENTARIO.CODTB1FAT FKTCONTORCAMENTARIO_TTB1R
TFAB.CODTB1FAT FKTFAB_TTB1R
TFITMMOV.CODTB1FAT FKTFITMMOV_TTB1R
TFMOV.CODTB1FAT FKTFMOV_TTB1R
TITMCNT.CODTB1FAT FKTITMCNT_TTB1R
TITMMOV.CODTB1FAT FKTITMMOV_TTB1R
TITMTMV.CODTB1FATIT FKTITMTMV_TTB1R
TMOV.CODTB1FAT FKTMOV_TTB1R
TPRODUTODEF.CODTB1FAT FKTPRDDEF_TTB1R
TTB1CFO.CODTB1FAT FKTTB1CFO_TTB1R
TTB1COMPL.CODTB1FAT FKTTB1COMPL_TTB1R
TTB1CONT.CODTB1FAT FKTTB1CONT_TTB1R
TTMV.CODTB1FATMOV FKTTMV_TTB1R
DESCRICAO varchar 100 √ null
COMISSAO RMDVALOR2 17,2 √ null
CAMPOLIVRE varchar 20 √ null
CODCOLCONTAGER DCODCOLIGADANULL 2 √ null
CGERENCIA.CODCOLIGADA FKTTB1_CGERENCIAR
CODCONTAGER DCODCONTA 40 √ null
CGERENCIA.CODCONTA FKTTB1_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)
PKTTB1 Primary key Asc/Asc CODCOLIGADA + CODTB1FAT

Relationships

Close relationships within degrees of separation