PCONVENIOPARAM

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFMOVCONVENIO.CODCOLIGADA FKPFMOVCONVENIO_PCONVENIOPARAMR
PCONVENIOSERVICO.CODCOLIGADA FKPCONVENIOPARAM_PCONVENIOSERVR
GCOLIGADA.CODCOLIGADA FKPCONVENIOPARAM_GCOLIGADAR
PEVENTO.CODCOLIGADA FKPCONVENIOPARAM_PEVENTOR
GFILIAL.CODCOLIGADA FKPCONVENIOPARAM_GFILIALR
PCONVENIO.CODCOLIGADA FKPCONVENIOPARAM_PCONVENIOR
IDPARAMCONVENIO int 4 null
PFMOVCONVENIO.IDPARAMCONVENIO FKPFMOVCONVENIO_PCONVENIOPARAMR
CODFILIAL smallint 2 null
GFILIAL.CODFILIAL FKPCONVENIOPARAM_GFILIALR
CODCONVENIO varchar 5 null
PCONVENIO.CODCONVENIO FKPCONVENIOPARAM_PCONVENIOR
CODCONVENIOSERVICO varchar 5 null
PCONVENIOSERVICO.CODCONVENIOSERVICO FKPCONVENIOPARAM_PCONVENIOSERVR
CODEVENTO varchar 4 √ null
PEVENTO.CODIGO FKPCONVENIOPARAM_PEVENTOR
CODTABCALC varchar 6 √ null
PERCENTUALEMPRESA RMDVALOR2 17,2 √ null
NUMEROPARCELAS int 4 √ null
FORMAPARCELAMENTO smallint 2 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)
PKPCONVENIOPARAM Primary key Asc/Asc CODCOLIGADA + IDPARAMCONVENIO
IX_U_PCONVENIOPARAM Must be unique Asc/Asc/Asc/Asc CODCOLIGADA + CODFILIAL + CODCONVENIO + CODCONVENIOSERVICO

Relationships

Close relationships within degrees of separation