SPARCPLANO

156 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SPARCPLANODESCONTOCOND.CODCOLIGADA FKSPARCPLANODESCONCOND_SPARCPLR
SPARCPLANODESCPONTUAL.CODCOLIGADA FKSPARCPLANODESCP_SPARCPLANOR
SPLANOPGTO.CODCOLIGADA FKSPARCPLANO_SPLANOPGTOR
SSERVICO.CODCOLIGADA FKSPARCPLANO_SSERVICOR
IDPERLET int 4 null
SPARCPLANODESCONTOCOND.IDPERLET FKSPARCPLANODESCONCOND_SPARCPLR
SPARCPLANODESCPONTUAL.IDPERLET FKSPARCPLANODESCP_SPARCPLANOR
SPLANOPGTO.IDPERLET FKSPARCPLANO_SPLANOPGTOR
CODSERVICO varchar 10 null
SPARCPLANODESCONTOCOND.CODSERVICO FKSPARCPLANODESCONCOND_SPARCPLR
SPARCPLANODESCPONTUAL.CODSERVICO FKSPARCPLANODESCP_SPARCPLANOR
SSERVICO.CODSERVICO FKSPARCPLANO_SSERVICOR
CODPLANOPGTO varchar 10 null
SPARCPLANODESCONTOCOND.CODPLANOPGTO FKSPARCPLANODESCONCOND_SPARCPLR
SPARCPLANODESCPONTUAL.CODPLANOPGTO FKSPARCPLANODESCP_SPARCPLANOR
SPLANOPGTO.CODPLANOPGTO FKSPARCPLANO_SPLANOPGTOR
PARCELA smallint 2 null
SPARCPLANODESCONTOCOND.PARCELA FKSPARCPLANODESCONCOND_SPARCPLR
SPARCPLANODESCPONTUAL.PARCELA FKSPARCPLANODESCP_SPARCPLANOR
COTA smallint 2 null
SPARCPLANODESCONTOCOND.COTA FKSPARCPLANODESCONCOND_SPARCPLR
SPARCPLANODESCPONTUAL.COTA FKSPARCPLANODESCP_SPARCPLANOR
CODBOLSA varchar 10 √ null
VALOR RMDVALOR4 17,4 null
DTVENCIMENTO datetime 16,3 null
DESCONTO RMDVALOR4 17,4 √ null
TIPODESC varchar 1 √ ('P')
VALORAUTOMATICO varchar 1 √ ('N')
DTCOMPETENCIA datetime 16,3 √ null
TIPOPARCELA varchar 1 √ ('P')
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
DTVENCIMENTOFLEXIVEL varchar 1 √ ('N')

Indexes

Constraint Name Type Sort Column(s)
PKSPARCPLANO Primary key Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + IDPERLET + CODSERVICO + CODPLANOPGTO + COTA + PARCELA

Relationships

Close relationships within degrees of separation