TTB5

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
TCNT.CODCOLIGADA FKTCNT_TTB5R
TCNTPAR.CODCOLIGADA FKTCNTPAR_TTB5R
TCONTORCAMENTARIO.CODCOLIGADA FKTCONTORCAMENTARIO_TTB5R
TFAB.CODCOLIGADA FKTFAB_TTB5R
TFITMMOV.CODCOLIGADA FKTFITMMOV_TTB5R
TFMOV.CODCOLIGADA FKTFMOV_TTB5R
TITMCNT.CODCOLIGADA FKTITMCNT_TTB5R
TITMMOV.CODCOLIGADA FKTITMMOV_TTB5R
TITMTMV.CODCOLIGADA FKTITMTMV_TTB5R
TMOV.CODCOLIGADA FKTMOV_TTB5R
TPRODUTODEF.CODCOLIGADA FKTPRDDEF_TTB5R
TTB5CFO.CODCOLIGADA FKTTB5CFO_TTB5R
TTB5COMPL.CODCOLIGADA FKTTB5COMPL_TTB5R
TTB5CONT.CODCOLIGADA FKTTB5CONT_TTB5R
TTMV.CODCOLIGADA FKTTMV_TTB5R
GCOLIGADA.CODCOLIGADA FKTTB5_GCOLIGADAR
CODTB5FAT varchar 10 null
TCNT.CODTB5FAT FKTCNT_TTB5R
TCNTPAR.CODTB5FAT FKTCNTPAR_TTB5R
TCONTORCAMENTARIO.CODTB5FAT FKTCONTORCAMENTARIO_TTB5R
TFAB.CODTB5FAT FKTFAB_TTB5R
TFITMMOV.CODTB5FAT FKTFITMMOV_TTB5R
TFMOV.CODTB5FAT FKTFMOV_TTB5R
TITMCNT.CODTB5FAT FKTITMCNT_TTB5R
TITMMOV.CODTB5FAT FKTITMMOV_TTB5R
TITMTMV.CODTB5FATIT FKTITMTMV_TTB5R
TMOV.CODTB5FAT FKTMOV_TTB5R
TPRODUTODEF.CODTB5FAT FKTPRDDEF_TTB5R
TTB5CFO.CODTB5FAT FKTTB5CFO_TTB5R
TTB5COMPL.CODTB5FAT FKTTB5COMPL_TTB5R
TTB5CONT.CODTB5FAT FKTTB5CONT_TTB5R
TTMV.CODTB5FATMOV FKTTMV_TTB5R
DESCRICAO varchar 100 √ null
COMISSAO RMDVALOR2 17,2 √ null
CAMPOLIVRE varchar 20 √ null
CODCOLCONTAGER DCODCOLIGADANULL 2 √ null
CGERENCIA.CODCOLIGADA FKTTB5_CGERENCIAR
CODCONTAGER DCODCONTA 40 √ null
CGERENCIA.CODCONTA FKTTB5_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)
PKTTB5 Primary key Asc/Asc CODCOLIGADA + CODTB5FAT

Relationships

Close relationships within degrees of separation