XVENDACONTA

4 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDVENDACONTA int 4 null
CODCOLIGADA DCODCOLIGADA 2 null
NUMVENDA int 4 null
XVENDA.NUM_VENDA FKXVENDACONTA_XVENDAR
CODCOLCONTA DCODCOLIGADA 2 null
CCONTA.CODCOLIGADA FKXVENDACONTA_CCONTAR
CODCONTA DCODCONTA 40 null
CCONTA.CODCONTA FKXVENDACONTA_CCONTAR
VALOR RMDVALOR2 17,2 √ null
CODCOLFILIAL DCODCOLIGADA 2 null
GFILIAL.CODCOLIGADA FKXVENDACONTA_GFILIALR
CODFILIAL smallint 2 null
GFILIAL.CODFILIAL FKXVENDACONTA_GFILIALR
TIPOCONTA smallint 2 √ null
DATA datetime 16,3 √ null
COMPLHISTORICO varchar 250 √ null
CODCOLHISTP DCODCOLIGADANULL 2 √ null
CHISTP.CODCOLIGADA FKXVENDACONTA_CHISTPR
CODHISTP varchar 10 √ null
CHISTP.CODHISTP FKXVENDACONTA_CHISTPR
TIPOCONTABILIDADE smallint 2 √ null
CODEVENTO int 4 √ null
NUMEROITMEVC int 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)
PKXVENDACONTA Primary key Asc/Asc IDVENDACONTA + CODCOLIGADA

Relationships

Close relationships within degrees of separation