XVENDACONT

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
NUM_VENDA int 4 null
XVENDA.NUM_VENDA FKXVENDACONT_XVENDAR
TIPO_CONT varchar 10 null
MES_ANO datetime 16,3 null
NUM_SEQ int 4 null
CODCOLIGADA DCODCOLIGADA 2 null
DEB_CRED varchar 8 √ null
VALOR RMDVALOR4 17,4 √ null
CODFILIAL smallint 2 null
CODDEPARTAMENTO varchar 25 √ null
CODCUSTO varchar 25 √ null
CODHISTP varchar 10 √ null
COMPLHISTORICO varchar 250 √ null
CODCOLCONTA smallint 2 null
CODCONTA varchar 40 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)
PKXVENDACONT Primary key Asc/Asc/Asc/Asc/Asc NUM_VENDA + TIPO_CONT + MES_ANO + NUM_SEQ + CODCOLIGADA

Relationships

Close relationships within degrees of separation