XDISTRATO

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
NUMVENDA int 4 null
XVENDA.NUM_VENDA FKXDISTRATO_XVENDAR
DATABASEDISTRATO datetime 16,3 √ null
MEMOCALC varchar 2147483647 √ null
CODCOLOPERACAO DCODCOLIGADANULL 2 √ null
CODEVENTO smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKXDISTRATO_TEVENTOSCONTR
CODCOLEVENT DCODCOLIGADANULL 2 √ null
TEVENTOSCONT.CODCOLIGADA FKXDISTRATO_TEVENTOSCONTR
COD_SIT_VENDA int 4 √ null
XSITUACAOVENDA.COD_SIT_VENDA FKXDISTRATO_XSITUACAOVENDAR
OBS_HIST varchar 4000 √ null
CODCOLFRM DCODCOLIGADANULL 2 √ null
GFORMULA.CODCOLIGADA FKXDISTRATO_GFORMULAR
APLICACAOFRM varchar 1 √ null
GFORMULA.APLICACAO FKXDISTRATO_GFORMULAR
CODFRM varchar 8 √ null
GFORMULA.CODIGO FKXDISTRATO_GFORMULAR
COD_SIT_DISTRATO int 4 √ null
XSITUACAODISTRATO.COD_SIT_DISTRATO FKXDISTRATO_XSITUACAODISTRATOR
VR_TOT_DISTRATO RMDVALOR4 17,4 √ null
CODCOLIGADA DCODCOLIGADA 2 √ null
COPERACAO.CODCOLIGADA FKXDISTRATO_COPERACAOR
IDOPERACAO int 4 √ null
COPERACAO.IDOPERACAO FKXDISTRATO_COPERACAOR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CODTIPODISTRATO int 4 √ null
XTIPODISTRATO.CODTIPODISTRATO FKXDISTRATO_XTIPODISTRATOR
CODMOTIVODISTRATO int 4 √ null
XMOTIVODISTRATO.CODMOTIVODISTRATO FKXDISTRATO_XMOTIVODISTRATOR
VERSAO int 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PKXDISTRATO Primary key Asc NUMVENDA
IDX_XDISTRATO_COPERACAO Performance Asc/Asc CODCOLIGADA + IDOPERACAO

Relationships

Close relationships within degrees of separation