TVOLUMEVENDA

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
GCOLIGADA.CODCOLIGADA FKTVOLUMEVENDA_GCOLIGADAR
TBICOBOMBA.CODCOLIGADA FKTVOLUMEVENDA_TBICOBOMBAR
TLOC.CODCOLIGADA FKTVOLUMEVENDA_TLOCR
GFILIAL.CODCOLIGADA FKTVOLUMEVENDA_GFILIALR
IDVOLVENDA int 4 null
CODFILIAL smallint 2 null
TLOC.CODFILIAL FKTVOLUMEVENDA_TLOCR
GFILIAL.CODFILIAL FKTVOLUMEVENDA_GFILIALR
CODLOC varchar 15 null
TLOC.CODLOC FKTVOLUMEVENDA_TLOCR
IDPRD int 4 null
TPRODUTO.IDPRD FKTVOLUMEVENDA_TPRODUTOR
IDBOMBA int 4 null
TBICOBOMBA.IDBOMBA FKTVOLUMEVENDA_TBICOBOMBAR
DATA DDATETIME 16,3 √ null
IDBICO int 4 null
TBICOBOMBA.IDBICO FKTVOLUMEVENDA_TBICOBOMBAR
NRINTERV varchar 255 √ null
MOTINTERV varchar 50 √ null
NOMINTERV varchar 30 √ null
CNPJINTERV varchar 14 √ null
CPFINTERV varchar 11 √ null
VALFECHA RMDVALOR3 17,3 √ null
VALABERT RMDVALOR3 17,3 √ null
VOLAFERI 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)
PKTVOLUMEVENDA Primary key Asc/Asc CODCOLIGADA + IDVOLVENDA

Relationships

Close relationships within degrees of separation