XALGCONTRATOADMADIT

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLCONTADM DCODCOLIGADA 2 null
XALGCONTRATOADMADITBENE.CODCOLCONTADM FKXALGCONTADMATBEN_XALGCONTRATR
XALGCONTRATOADMADITIMOVEIS.CODCOLCONTADM FKXALGCONTADMADIT_XALGCONTDITR
XALGCONTRATOADMADITPROC.CODCOLCONTADM FKXALGCONTDMADITP_XALGCONTADMR
XALGCONTRATOADMADITPROP.CODCOLCONTADM FKXALGCONTADITPROP_XALGCONTRATR
XALGCONTRATOADMADITREAJUSTE.CODCOLCONTADM FKXALGCONTADMADITREAJ_XALGCONTR
XALGCONTRATOADM.CODCOLCONTADM FKXALGCONTADMADIT_XALGCONTADMR
CODCONTADM int 4 null
XALGCONTRATOADMADITBENE.CODCONTADM FKXALGCONTADMATBEN_XALGCONTRATR
XALGCONTRATOADMADITIMOVEIS.CODCONTADM FKXALGCONTADMADIT_XALGCONTDITR
XALGCONTRATOADMADITPROC.CODCONTADM FKXALGCONTDMADITP_XALGCONTADMR
XALGCONTRATOADMADITPROP.CODCONTADM FKXALGCONTADITPROP_XALGCONTRATR
XALGCONTRATOADMADITREAJUSTE.CODCONTADM FKXALGCONTADMADITREAJ_XALGCONTR
XALGCONTRATOADM.CODCONTRATOADM FKXALGCONTADMADIT_XALGCONTADMR
CODADITIVOCONTADM int 4 null
XALGCONTRATOADMADITBENE.CODADITIVOCONTADM FKXALGCONTADMATBEN_XALGCONTRATR
XALGCONTRATOADMADITIMOVEIS.CODADITIVOCONTADM FKXALGCONTADMADIT_XALGCONTDITR
XALGCONTRATOADMADITPROC.CODADITIVOCONTADM FKXALGCONTDMADITP_XALGCONTADMR
XALGCONTRATOADMADITPROP.CODADITIVOCONTADM FKXALGCONTADITPROP_XALGCONTRATR
XALGCONTRATOADMADITREAJUSTE.CODADITIVOCONTADM FKXALGCONTADMADITREAJ_XALGCONTR
TIPOADITIVOCONTADM smallint 2 √ null
SITUACAOADITIVOCONTADM smallint 2 √ null
DATAADITIVOCONTADM DDATE 16,3 √ null
DATAEFETIVACAOADITIVOCONTADM DDATE 16,3 √ null
OBSERVACAOCONTADMADITIVO varchar 2147483647 √ null
TAXACONTADMANTERIOR RMDVALOR4 17,4 √ null
NOVATAXACONTADM RMDVALOR4 17,4 √ null
CARENCIATAXAADMANTERIOR smallint 2 √ null
NOVACARENCIATAXAADM smallint 2 √ null
TAXAINTERMEDIACAOANTERIOR RMDVALOR4 17,4 √ null
NOVATAXAINTERMEDIACAO RMDVALOR4 17,4 √ null
APLICACAOTAXAINTERMEDIACAOANT smallint 2 √ null
NOVAAPLICACAOTAXAINTERMEDIACAO smallint 2 √ null
DTVALIDADEVIGENCONTADMANTERIOR DDATE 16,3 √ null
NOVADTVALIDADEVIGENCONTADM DDATE 16,3 √ 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)
PKXALGCONTRATOADMADIT Primary key Asc/Asc/Asc CODCOLCONTADM + CODCONTADM + CODADITIVOCONTADM

Relationships

Close relationships within degrees of separation