VLOTEEPI

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
VEPI.CODCOLIGADA FKVEPI_VLOTEEPIR
VCATALOGOEPI.CODCOLIGADA FKVLOTEEPI_VCATALOGOEPIR
PSECAO.CODCOLIGADA FKVLOTEEPI_PSECAOR
TMOV.CODCOLIGADA FK_VLOTEEPI_TMOVR
GFILIAL.CODCOLIGADA FKVLOTEEPI_GFILIALR
CODEPI varchar 10 null
VEPI.CODEPI FKVEPI_VLOTEEPIR
VCATALOGOEPI.CODEPI FKVLOTEEPI_VCATALOGOEPIR
IDLOTE numeric 21 null
VEPI.IDLOTE FKVEPI_VLOTEEPIR
CA varchar 255 √ null
DTAQUISICAO DDATETIME 16,3 √ null
DTVALIDADE DDATETIME 16,3 √ null
DTDURABILIDADE DDATETIME 16,3 √ null
DTVALIDADECA DDATETIME 16,3 √ null
DURABILIDADE int 4 √ null
CRI varchar 30 √ null
CRF varchar 30 √ null
FABRICANTE varchar 100 √ null
OBSERVACOES varchar 4000 √ null
HIGIENIZADO DLOGICO 2 √ null
INVALIDO DLOGICO 2 √ null
CODFILIAL smallint 2 √ null
GFILIAL.CODFILIAL FKVLOTEEPI_GFILIALR
CODSECAO varchar 35 √ null
PSECAO.CODIGO FKVLOTEEPI_PSECAOR
QUANTIDADE int 4 √ null
IDMOV int 4 √ null
TMOV.IDMOV FK_VLOTEEPI_TMOVR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
VALORUNITARIO RMDVALOR2 17,2 √ null

Indexes

Constraint Name Type Sort Column(s)
PKVLOTEEPI Primary key Asc/Asc/Asc CODCOLIGADA + CODEPI + IDLOTE

Relationships

Close relationships within degrees of separation