TPARPRODUTO

3 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
CADCARACFISPROD smallint 2 √ null
CADCODAUXPROD smallint 2 √ null
CADCOMISPROD smallint 2 √ null
CADCONDPGTOPROD smallint 2 √ null
CADDESCCOMPRPROD smallint 2 √ null
CADDESCRAUXPROD smallint 2 √ null
CADDESCVENDAPROD smallint 2 √ null
CAMPODESCPRD varchar 1 √ null
CODIGOAUXUNICOPRD DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
CODUNIDADEPROD varchar 5 √ null
TUND.CODUND FKTPARPRODUTO_TUNDPRDR
COMPLULTNIVCODPRD DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
CONSISTEPRDINATIVO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
COPIARCODREDUZ smallint 2 √ null
DESCPRDCOMLIMITE smallint 2 √ null
LIMITEDESCPRD smallint 2 √ null
MASCCODPROD varchar 30 √ null
MASCCODREDUZPROD varchar 10 √ null
MASCHIERARQPROD smallint 2 √ null
MAXLINHASFILTROPRD int 4 √ null
NAOALTERARCODIGOPRD DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
NOMETABELAPROD varchar 25 √ null
TABCLASSIFGRPPRD smallint 2 √ null
TIPOHISTORICO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
TIPORESPPRD smallint 2 √ null
ULTIMOCODPRODINC varchar 20 √ null
ULTIMOCODREDINC varchar 10 √ null
USACODREDUZPROD varchar 1 √ null
USACONTATRABALHO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
USADADOSFISCPROD smallint 2 √ null
USANUMDECPROD DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
USAPESAVEL smallint 2 √ null
USAPRDCOMPOSTO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
USAPRDSIMILAR DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
USARELACPRODFORN DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
CAMPOCOMPVISAOPRD DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
MASCARANUMLOTE varchar 50 √ null
NUMEROLOTESEQ smallint 2 √ null
NUMLOTEREPETIDO smallint 2 √ null
PERMITELOTENUMSERIE int 4 √ null
USACODIGOEAN smallint 2 √ null
CODMOEPRECOPROD1 varchar 10 √ null
GMOEDA.SIMBOLO FKTPARPRODUTO_TMOE1R
CODMOEPRECOPROD2 varchar 10 √ null
GMOEDA.SIMBOLO FKTPARPRODUTO_TMOE2R
CODMOEPRECOPROD3 varchar 10 √ null
GMOEDA.SIMBOLO FKTPARPRODUTO_TMOE3R
CODMOEPRECOPROD4 varchar 10 √ null
GMOEDA.SIMBOLO FKTPARPRODUTO_TMOE4R
CODMOEPRECOPROD5 varchar 10 √ null
GMOEDA.SIMBOLO FKTPARPRODUTO_TMOE5R
NOMEDOPRECOPROD1 varchar 20 √ null
NOMEDOPRECOPROD2 varchar 20 √ null
NOMEDOPRECOPROD3 varchar 20 √ null
NOMEDOPRECOPROD4 varchar 20 √ null
NOMEDOPRECOPROD5 varchar 20 √ null
USAPRECOPROD1 smallint 2 √ null
USAPRECOPROD2 smallint 2 √ null
USAPRECOPROD3 smallint 2 √ null
USAPRECOPROD4 smallint 2 √ null
USAPRECOPROD5 smallint 2 √ null
NOMEPRATELEIRA varchar 20 √ null
SEPARADOR varchar 1 √ null
USAGRDNUMERADA smallint 2 √ null
GRADENUMERADA2D DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
NOMECAMPOLIVRE1PRD varchar 15 √ null
NOMECAMPOLIVRE2PRD varchar 15 √ null
NOMECAMPOLIVRE3PRD varchar 15 √ null
EDICAOPRDDATAEXTRA1 varchar 1 √ null
EDICAOPRDDATAEXTRA2 varchar 1 √ null
NOMEPRDDATAEXTRA1 varchar 20 √ null
NOMEPRDDATAEXTRA2 varchar 20 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
MASCGRUPOPRODUTOS varchar 25 √ null

Indexes

Constraint Name Type Sort Column(s)
PKTPARPRODUTO Primary key Asc CODCOLIGADA

Relationships

Close relationships within degrees of separation