TPRDCFO

119 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
TPRDCFOHIST.CODCOLIGADA FKTPRDCFOHIST_TPRDCFOR
TINSS.CODCOLIGADA FKTPRDCFO_TINSSR
TITMMOV.CODCOLIGADA FKTPRDCFO_TITMMOVR
IDPRD int 4 null
TPRDCFOHIST.IDPRD FKTPRDCFOHIST_TPRDCFOR
TPRODUTO.IDPRD FKTPRDCFO_TPRDR
CODCOLCFO DCODCOLIGADA 2 null
TPRDCFOHIST.CODCOLCFO FKTPRDCFOHIST_TPRDCFOR
FCFO.CODCOLIGADA FKTPRDCFO_FCFOR
CODCFO varchar 25 null
TPRDCFOHIST.CODCFO FKTPRDCFOHIST_TPRDCFOR
FCFO.CODCFO FKTPRDCFO_FCFOR
CODNOFORN varchar 20 √ null
PERCENTFORNECIMENTO RMDVALOR4 17,4 √ null
FATOREMBALAGEM RMDVALOR4 17,4 √ null
ATIVO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
VALOR RMDVALOR4 17,4 √ null
DT_VALIDADE DDATE 16,3 √ null
NUM_CONTRATO varchar 25 √ null
PATH_IMAGEM varchar 255 √ null
TEMPOFORNEC RMDVALOR4 17,4 √ null
IDMOV int 4 √ null
TITMMOV.IDMOV FKTPRDCFO_TITMMOVR
NSEQITMMOV int 4 √ null
TITMMOV.NSEQITMMOV FKTPRDCFO_TITMMOVR
DATAATUALIZACAO datetime 16,3 √ null
FORNECPRIORITARIO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
DESCONTO RMDVALOR4 17,4 √ null
CAMPOLIVRE varchar 100 √ null
CODMOEDAPRECO varchar 10 √ null
GMOEDA.SIMBOLO FKTPRDCFO_GMOEDAR
CODIGOIRRF varchar 10 √ null
FIRRF.CODRECEITA FKTPRDCFO_FIRRFR
DEDUCAOIRRF RMDVALOR4 17,4 √ null
CODIGOINSS varchar 10 √ null
TINSS.CODIGOINSS FKTPRDCFO_TINSSR
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)
PKTPRDCFO Primary key Asc/Asc/Asc/Asc CODCOLIGADA + IDPRD + CODCOLCFO + CODCFO
TXTPRDCFO Performance Asc/Asc CODCOLCFO + CODCFO
TXTPRDCFOITMMOV Performance Asc/Asc/Asc CODCOLIGADA + IDMOV + NSEQITMMOV

Relationships

Close relationships within degrees of separation