TPRDCONT

28 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
TPRDRAT.CODCOLIGADA FKTPRDRAT_TPRDCONTR
CHISTP.CODCOLIGADA FKTPRDCONT_CHISTPR
GCCUSTO.CODCOLIGADA FKTPRDCONT_GCCUSTOR
GDEPTO.CODCOLIGADA FKTPRDCONT_GDEPTOR
GCOLIGADA.CODCOLIGADA FKTPRDCONT_GCOLIGADAR
GFILIAL.CODCOLIGADA FKTPRDCONT_GFILIALR
IDPRDCONT int 4 null
TPRDRAT.IDPRDCONT FKTPRDRAT_TPRDCONTR
TIPO smallint 2 null
TCODIGO.TIPO Implied ConstraintR
PERCENTUAL RMDVALOR4 17,4 √ null
CODFILIAL smallint 2 √ null
GDEPTO.CODFILIAL FKTPRDCONT_GDEPTOR
GFILIAL.CODFILIAL FKTPRDCONT_GFILIALR
CODDEPARTAMENTO varchar 25 √ null
GDEPTO.CODDEPARTAMENTO FKTPRDCONT_GDEPTOR
CODCCUSTO varchar 25 √ null
GCCUSTO.CODCCUSTO FKTPRDCONT_GCCUSTOR
CODHISTP varchar 10 √ null
CHISTP.CODHISTP FKTPRDCONT_CHISTPR
COMPLHISTORICO varchar 250 √ null
IDPRD int 4 null
TPRODUTO.IDPRD FKTPRDCONT_TPRDR
CODCOLCONTA DCODCOLIGADA 2 null
CCONTA.CODCOLIGADA FKTPRDCONT_CCONTAR
CODCONTA DCODCONTA 40 null
CCONTA.CODCONTA FKTPRDCONT_CCONTAR
CLASSCONTA varchar 10 √ null
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)
PKTPRDCONT Primary key Asc/Asc IDPRDCONT + CODCOLIGADA
TXPRDCONT_CODCONTA Performance Asc/Asc/Asc/Asc/Asc CODCONTA + TIPO + IDPRD + CODCOLCONTA + CODCOLIGADA

Relationships

Close relationships within degrees of separation