XALGCONTRATOLOCENCERRACTB

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
XALGCONTRATOLOCENCERRAMENTO.CODCOLCONTLOC FKXALGCONTRATOLOCENCERRACTB_XAR
COPERACAO.CODCOLIGADA FKXALGCONTENCERRACTB_COPERACAOR
CODCONTLOC int 4 null
XALGCONTRATOLOCENCERRAMENTO.CODCONTLOC FKXALGCONTRATOLOCENCERRACTB_XAR
CODENCERRAMENTOCONTLOC int 4 null
XALGCONTRATOLOCENCERRAMENTO.CODENCERRAMENTOCONTLOC FKXALGCONTRATOLOCENCERRACTB_XAR
DATACOMPETENCIA DDATETIME 16,3 null
IDOPERACAO int 4 null
COPERACAO.IDOPERACAO FKXALGCONTENCERRACTB_COPERACAOR
IDEVENTOCONTABIL 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)
PKXALGCONTRATOLOCENCERRACTB Primary key Asc/Asc/Asc/Asc CODCOLIGADA + CODCONTLOC + CODENCERRAMENTOCONTLOC + DATACOMPETENCIA

Relationships

Close relationships within degrees of separation