FXCXHST

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
IDHISTORICO int 4 null
IDXCX int 4 null
PROCESSO smallint 2 null
DATAPROCESSO DDATETIME 16,3 null
DATAOPERACAO DDATETIME 16,3 null
NUMERODOCUMENTO varchar 20 √ null
TIPO smallint 2 √ null
TCODIGO.TIPO Implied ConstraintR
CODCCUSTO varchar 25 √ null
CODCOLCXA smallint 2 √ null
CODCOLNATFINANCEIRA smallint 2 √ null
CODCOLCXATRANSF smallint 2 √ null
CODCOLXCXTRANSF smallint 2 √ null
CODCXA varchar 10 √ null
CODCXATRANSF varchar 10 √ null
CODDEPARTAMENTO varchar 25 √ null
CODFILIAL smallint 2 √ null
CODNATFINANCEIRA varchar 40 √ null
COMPENSADO smallint 2 √ null
DATA DDATETIME 16,3 √ null
DATACANCELAMENTO DDATETIME 16,3 √ null
DATACOMPENSACAO DDATETIME 16,3 √ null
DATAESTORNO DDATETIME 16,3 √ null
DATARECONCILIACAO DDATETIME 16,3 √ null
DATAVENCIMENTO DDATETIME 16,3 √ null
ESTORNADO smallint 2 √ null
IDXCXTRANSF int 4 √ null
RECONCILIADO smallint 2 √ null
VALOR RMDVALOR4 17,4 √ null
IDFORMAPAGTO 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)
PKFXCXHST Primary key Asc/Asc CODCOLIGADA + IDHISTORICO
IX_FXCXHST Performance Asc/Asc CODCOLIGADA + IDXCX

Relationships

Close relationships within degrees of separation