SMISISASEREFEICAODISTRIBUICAO

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SMISISASEREFEICAO.CODCOLIGADA FKSMISISAEREFDIST_SMISISASEREFR
CODFILIAL smallint 2 null
SMISISASEREFEICAO.CODFILIAL FKSMISISAEREFDIST_SMISISASEREFR
ANOECONOMICO smallint 2 null
SMISISASEREFEICAO.ANOECONOMICO FKSMISISAEREFDIST_SMISISASEREFR
MESREFERENCIA smallint 2 null
SMISISASEREFEICAO.MESREFERENCIA FKSMISISAEREFDIST_SMISISASEREFR
CODESCALAO int 4 null
SMISIESCALAO.CODESCALAO FKSMISISASEREFDIST_SMISIESCALAR
CODCLASSE int 4 null
SMISICLASSE.CODCLASSE FKSMISISASEREFDIST_SMISICLASSER
NUMREFENCOMENDADAS int 4 null
NUMREFSERVIDAS int 4 null
NUMREFLIGEIRA 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)
PKSMISISASEREFEICAODISTRIBUICA Primary key Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CODFILIAL + ANOECONOMICO + MESREFERENCIA + CODESCALAO + CODCLASSE

Relationships

Close relationships within degrees of separation