TPRDLOCINFO

271 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
TPRDCONSUMO.CODCOLIGADA FKTPRDCONSUMO_TPRDLOCINFOR
TPRDCUSTO.CODCOLIGADA FKTPRDCUSTO_TPRDLOCINFOR
TPRDSUGESTAO.CODCOLIGADA FKTPRDSUGESTAO_TPRDLOCINFOR
TLOC.CODCOLIGADA FKTPRDLOCINFO_TLOCR
GFILIAL.CODCOLIGADA FKTPRDLOCINFO_GFILIALR
IDPRD int 4 null
TPRDCONSUMO.IDPRD FKTPRDCONSUMO_TPRDLOCINFOR
TPRDCUSTO.IDPRD FKTPRDCUSTO_TPRDLOCINFOR
TPRDSUGESTAO.IDPRD FKTPRDSUGESTAO_TPRDLOCINFOR
TPRODUTO.IDPRD FKTPRDLOCINFO_TPRDR
IDPRDLOCINFO DINTEGER 4 null
TPRDCONSUMO.IDPRDLOCINFO FKTPRDCONSUMO_TPRDLOCINFOR
TPRDCUSTO.IDPRDLOCINFO FKTPRDCUSTO_TPRDLOCINFOR
TPRDSUGESTAO.IDPRDLOCINFO FKTPRDSUGESTAO_TPRDLOCINFOR
CODFILIAL smallint 2 √ null
TLOC.CODFILIAL FKTPRDLOCINFO_TLOCR
GFILIAL.CODFILIAL FKTPRDLOCINFO_GFILIALR
CODLOC varchar 15 √ null
TLOC.CODLOC FKTPRDLOCINFO_TLOCR
SALDFISMIN RMDVALOR4 17,4 √ null
SALDOFISMAX RMDVALOR4 17,4 √ null
PONTOREPOSICAO RMDVALOR4 17,4 √ null
CONSTEORICO RMDVALOR4 17,4 √ null
TEMPOESTQMIN RMDVALOR4 17,4 √ null
TEMPOCOMPRA RMDVALOR4 17,4 √ null
TEMPOFORNEC RMDVALOR4 17,4 √ null
TEMPORECEB RMDVALOR4 17,4 √ null
TEMPOREPOSICAO RMDVALOR4 17,4 √ null
TEMPOCONTQUALIDADE RMDVALOR4 17,4 √ null
ULTINVENTARIO datetime 16,3 √ null
CLASSEABC char 1 √ null
TEMPOESTQMAX RMDVALOR4 17,4 √ null
CONSDIAPRATICO RMDVALOR4 17,4 √ null
TIPOACEITAMOVIMENTO smallint 2 √ null
BASEPOLO smallint 2 √ null
LOTEECONCOMPRAS RMDVALOR4 17,4 √ 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)
PKTPRDLOCINFO Primary key Asc/Asc/Asc CODCOLIGADA + IDPRD + IDPRDLOCINFO
TXLOCALESTOQUE Must be unique Asc/Asc/Asc/Asc CODCOLIGADA + IDPRD + CODFILIAL + CODLOC

Relationships

Close relationships within degrees of separation