CRATEIOLCHIST

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
CCONTRATHIST.CODCOLIGADA FKCCONTRATHIST_CRATEIOLCHISTR
CRATEIOLCMULTIMOEDAHIST.CODCOLIGADA FKCRATEIOLCMULTIMOEDAHIST_CRAR
CPARTIDAHIST.CODCOLIGADA FKCRATEIOLCHIST_CPARTIDAHISTR
IDEXERCICIO int 4 null
CCONTRATHIST.IDEXERCICIO FKCCONTRATHIST_CRATEIOLCHISTR
CRATEIOLCMULTIMOEDAHIST.IDEXERCICIO FKCRATEIOLCMULTIMOEDAHIST_CRAR
CPARTIDAHIST.IDEXERCICIO FKCRATEIOLCHIST_CPARTIDAHISTR
IDPARTIDA int 4 null
CPARTIDAHIST.IDPARTIDA FKCRATEIOLCHIST_CPARTIDAHISTR
IDRATEIO int 4 null
CCONTRATHIST.IDRATEIO FKCCONTRATHIST_CRATEIOLCHISTR
CRATEIOLCMULTIMOEDAHIST.IDRATEIO FKCRATEIOLCMULTIMOEDAHIST_CRAR
LCTREF int 4 null
DATA DDATETIME 16,3 √ null
CODCONTA DCODCONTA 40 null
CCONTA.CODCONTA FKCRATEIOLCHIST_CCONTAR
CODGERENCIAL DCODCONTA 40 null
CGERENCIA.CODCONTA FKCRATEIOLCHIST_CGERENCIAR
VLRDEBITO RMDVALOR2 17,2 √ null
VLRCREDITO RMDVALOR2 17,2 √ null
CODCOLCONTA DCODCOLIGADA 2 null
CCONTA.CODCOLIGADA FKCRATEIOLCHIST_CCONTAR
CODCOLGERENCIAL DCODCOLIGADA 2 null
CGERENCIA.CODCOLIGADA FKCRATEIOLCHIST_CGERENCIAR
CODLOTE 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)
PKCRATEIOLCHIST Primary key Asc/Asc/Asc CODCOLIGADA + IDEXERCICIO + IDRATEIO
UQCRATEIOLCHIST Must be unique Asc/Asc CODCOLIGADA + IDRATEIO

Relationships

Close relationships within degrees of separation