TGRPPONTOVENDA

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
TFESTOQUE.CODCOLIGADA FKTFESTOQUE_TGRPPONTOVENDAR
TPONTOVENDA.CODCOLIGADA FKTPONTOVENDA_TGRPPONTOVENDAR
TSALDO.CODCOLIGADA FKTSALDO_TGRPPONTOVENDAR
GCOLIGADA.CODCOLIGADA FKTGRPPONTOVENDA_GCOLIGADAR
TLOC.CODCOLIGADA FKTGRPPONTOVENDA_TLOCR
GRUPO varchar 10 null
TFESTOQUE.GRUPO FKTFESTOQUE_TGRPPONTOVENDAR
TPONTOVENDA.GRUPO FKTPONTOVENDA_TGRPPONTOVENDAR
TSALDO.GRUPO FKTSALDO_TGRPPONTOVENDAR
DESCRICAO varchar 40 √ null
DIRETORIOENTRADA varchar 60 √ null
DIRETORIOSAIDA varchar 60 √ null
EXPORTARPONTOVENDA DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
IDFILTROCFO int 4 √ null
IDFILTROPRD int 4 √ null
IDFILTROMOV int 4 √ null
IDFILTROLAN int 4 √ null
CODFILIAL smallint 2 √ null
TLOC.CODFILIAL FKTGRPPONTOVENDA_TLOCR
CODLOC varchar 15 √ null
TLOC.CODLOC FKTGRPPONTOVENDA_TLOCR
MODOSERVER smallint 2 √ null
PRIORIDADE smallint 2 √ 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)
PKTGRPPONTOVENDA Primary key Asc/Asc CODCOLIGADA + GRUPO

Relationships

Close relationships within degrees of separation