TPRDCODIGO

273 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
TNUMSERIE.CODCOLIGADA FKTPRDCODIGO_TNUMSERIER
TLOTEPRD.CODCOLIGADA FKTPRDCODIGO_TLOTEPRDR
TIPO smallint 2 null
TCODIGO.TIPO FKTPRDCODIGO_TIPOR
CODIGO varchar 200 null
IDPRD int 4 null
TNUMSERIE.IDPRD FKTPRDCODIGO_TNUMSERIER
TPRODUTO.IDPRD FKTPRDCODIGO_PRODUTOR
DTCADASTRO datetime 16,3 √ null
OBSERVACAO varchar 80 √ null
CODUND varchar 5 √ null
TUND.CODUND FKTPRDCODIGO_TUNDR
PRECOVENDA smallint 2 √ null
INATIVO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
TIPOCODIGOBARRAS smallint 2 √ null
IDLOTE int 4 √ null
TLOTEPRD.IDLOTE FKTPRDCODIGO_TLOTEPRDR
NUMSERIE varchar 30 √ null
TNUMSERIE.NUMSERIE FKTPRDCODIGO_TNUMSERIER

Relationships

Close relationships within degrees of separation