TTB2

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
TCNT.CODCOLIGADA FKTCNT_TTB2R
TCNTPAR.CODCOLIGADA FKTCNTPAR_TTB2R
TCONTORCAMENTARIO.CODCOLIGADA FKTCONTORCAMENTARIO_TTB2R
TFAB.CODCOLIGADA FKTFAB_TTB2R
TFITMMOV.CODCOLIGADA FKTFITMMOV_TTB2R
TFMOV.CODCOLIGADA FKTFMOV_TTB2R
TITMCNT.CODCOLIGADA FKTITMCNT_TTB2R
TITMMOV.CODCOLIGADA FKTITMMOV_TTB2R
TITMTMV.CODCOLIGADA FKTITMTMV_TTB2R
TMOV.CODCOLIGADA FKTMOV_TTB2R
TPRODUTODEF.CODCOLIGADA FKTPRDDEF_TTB2R
TTB2CFO.CODCOLIGADA FKTTB2CFO_TTB2R
TTB2COMPL.CODCOLIGADA FKTTB2COMPL_TTB2R
TTB2CONT.CODCOLIGADA FKTTB2CONT_TTB2R
TTMV.CODCOLIGADA FKTTMV_TTB2R
GCOLIGADA.CODCOLIGADA FKTTB2_GCOLIGADAR
CODTB2FAT varchar 10 null
TCNT.CODTB2FAT FKTCNT_TTB2R
TCNTPAR.CODTB2FAT FKTCNTPAR_TTB2R
TCONTORCAMENTARIO.CODTB2FAT FKTCONTORCAMENTARIO_TTB2R
TFAB.CODTB2FAT FKTFAB_TTB2R
TFITMMOV.CODTB2FAT FKTFITMMOV_TTB2R
TFMOV.CODTB2FAT FKTFMOV_TTB2R
TITMCNT.CODTB2FAT FKTITMCNT_TTB2R
TITMMOV.CODTB2FAT FKTITMMOV_TTB2R
TITMTMV.CODTB2FATIT FKTITMTMV_TTB2R
TMOV.CODTB2FAT FKTMOV_TTB2R
TPRODUTODEF.CODTB2FAT FKTPRDDEF_TTB2R
TTB2CFO.CODTB2FAT FKTTB2CFO_TTB2R
TTB2COMPL.CODTB2FAT FKTTB2COMPL_TTB2R
TTB2CONT.CODTB2FAT FKTTB2CONT_TTB2R
TTMV.CODTB2FATMOV FKTTMV_TTB2R
DESCRICAO varchar 100 √ null
COMISSAO RMDVALOR2 17,2 √ null
CAMPOLIVRE varchar 20 √ null
CODCOLCONTAGER DCODCOLIGADANULL 2 √ null
CGERENCIA.CODCOLIGADA FKTTB2_CGERENCIAR
CODCONTAGER DCODCONTA 40 √ null
CGERENCIA.CODCONTA FKTTB2_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)
PKTTB2 Primary key Asc/Asc CODCOLIGADA + CODTB2FAT

Relationships

Close relationships within degrees of separation