XALGCONTRATOLOCHISTVALOR

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLCONTLOC DCODCOLIGADA 2 null
XALGCONTRATOLOCADITEXCLIMOVEL.CODCOLCONTLOC FKXALGCONTRATOLOCIMOVEL_HISTR
XALGCONTRATOLOCADITVALOR.CODCOLCONTLOC FKXALGCONTRATOLOCADITVR_XALGCOR
XALGCONTRATOLOCHISTVRIMOVEL.CODCOLCONTLOC FKXALGCONTRATOLOCHIST_XALGCHISR
XALGCONTRATOLOCREAJUSTE.CODCOLIGADA FKXALGCONTRATOLOCREAJUS_XALGCOR
XALGCONTRATOLOC.CODCOLCONTLOC FKXALGCONTRATOLOCHISTVAL_XALGCR
CODCONTLOC int 4 null
XALGCONTRATOLOCADITEXCLIMOVEL.CODCONTLOC FKXALGCONTRATOLOCIMOVEL_HISTR
XALGCONTRATOLOCADITVALOR.CODCONTLOC FKXALGCONTRATOLOCADITVR_XALGCOR
XALGCONTRATOLOCHISTVRIMOVEL.CODCONTLOC FKXALGCONTRATOLOCHIST_XALGCHISR
XALGCONTRATOLOCREAJUSTE.CODCONTLOC FKXALGCONTRATOLOCREAJUS_XALGCOR
XALGCONTRATOLOC.CODCONTLOC FKXALGCONTRATOLOCHISTVAL_XALGCR
IDHISTORICOVALOR int 4 null
XALGCONTRATOLOCADITEXCLIMOVEL.IDHISTORICOEXCLUSAOIMOVEL FKXALGCONTRATOLOCIMOVEL_HISTR
XALGCONTRATOLOCADITVALOR.IDHISTORICOVALOR FKXALGCONTRATOLOCADITVR_XALGCOR
XALGCONTRATOLOCHISTVRIMOVEL.IDHISTORICOVALOR FKXALGCONTRATOLOCHIST_XALGCHISR
XALGCONTRATOLOCREAJUSTE.IDHISTORICOVALOR FKXALGCONTRATOLOCREAJUS_XALGCOR
DATAINICIAL DDATETIME 16,3 null
DATAFINAL DDATETIME 16,3 √ null
IDPROCESSO int 4 null
VRFINALCONTLOC RMDVALOR4 17,4 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
VRDESCONTOCONTLOC RMDVALOR2 17,2 √ null
PERCDESCONTOCONTLOC RMDVALOR4 17,4 √ null
TIPODESCONTO smallint 2 √ null
VRMETROQUADRADO RMDVALOR4 17,4 √ null
AREALOCADA RMDVALOR4 17,4 √ null
VALORCTOMINIMO RMDVALOR4 17,4 √ null

Indexes

Constraint Name Type Sort Column(s)
PKXALGCONTRATOLOCHISTVALOR Primary key Asc/Asc/Asc CODCOLCONTLOC + CODCONTLOC + IDHISTORICOVALOR

Relationships

Close relationships within degrees of separation