XMOV

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDXMOV int 4 null
XATENDIMENTOMOV.IDXMOV FKXATENDIMENTOMOV_XMOVR
ORIGEM smallint 2 null
CODCOLMOV DCODCOLIGADA 2 null
TMOV.CODCOLIGADA FKXMOV_TMOVR
IDMOV int 4 null
TMOV.IDMOV FKXMOV_TMOVR
NUMVENDA int 4 √ null
XVENDA.NUM_VENDA FKXMOV_XVENDAR
IDSOLICITACAO int 4 √ null
XSOLICITACAOGARANTIA.IDSOLICITACAO FKXMOV_XSOLICITACAOGARANTIAR
IDETAPA int 4 √ null
XETAPAGARANTIA.CODETAPA FKXMOV_XETAPAGARANTIAR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime2 16,7 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime2 16,7 √ null
CODCOLCONTADM DCODCOLIGADANULL 2 √ null
XALGCONTRATOADM.CODCOLCONTADM FKXMOV_XALGCONTRATOADMR
CODCONTRATOADM int 4 √ null
XALGCONTRATOADM.CODCONTRATOADM FKXMOV_XALGCONTRATOADMR
CODDESPESA int 4 √ null
XCONDDESPESADIRETA.CODDESPESA Implied ConstraintR
IDPARCELA int 4 √ null
CODCOLCONTLOC DCODCOLIGADANULL 2 √ null
XALGCONTRATOLOC.CODCOLCONTLOC FKXMOV_XALGCONTRATOLOCR
CODCONTLOC int 4 √ null
XALGCONTRATOLOC.CODCONTLOC FKXMOV_XALGCONTRATOLOCR
DATAINICIOGERACAO datetime 16,3 √ null
DATAFIMGERACAO datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PKXMOV Primary key Asc IDXMOV

Relationships

Close relationships within degrees of separation