XSITUACAOVENDA

14 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
COD_SIT_VENDA int 4 null
XDISTRATO.COD_SIT_VENDA FKXDISTRATO_XSITUACAOVENDAR
XHISTORICOVENDA.COD_SIT_VENDA Implied ConstraintR
XLOGVENDA.COD_SIT_VENDA Implied ConstraintR
XVENDA.COD_SIT_VENDA FKXVENDA_XSITUACAOVENDAR
DSC_SIT_VENDA varchar 30 √ null
COD_SIT_OPRL char 1 √ null
COD_PESS_ULT_MNT varchar 20 √ null
DAT_ULT_MNT datetime 16,3 √ null
DESCRICAO varchar 200 √ null
FLG_DEVOLUCAO varchar 1 √ null
FLG_CANCELA_BANCO varchar 1 √ null
COD_SIT_SUB_UNID int 4 √ null
XSITUACAOSUBUNIDADE.COD_SIT_SUB_UNID Implied ConstraintR
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)
PKXSITUACAOVENDA Primary key Asc COD_SIT_VENDA

Relationships

Close relationships within degrees of separation