SPARCPLANODESCPONTUAL

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SPARCPLANO.CODCOLIGADA FKSPARCPLANODESCP_SPARCPLANOR
FDESCONTOPONTUAL.CODCOLIGADA FKSPARCPLANODESCPONTUAL_FDESCOR
IDPERLET int 4 null
SPARCPLANO.IDPERLET FKSPARCPLANODESCP_SPARCPLANOR
CODSERVICO varchar 10 null
SPARCPLANO.CODSERVICO FKSPARCPLANODESCP_SPARCPLANOR
CODPLANOPGTO varchar 10 null
SPARCPLANO.CODPLANOPGTO FKSPARCPLANODESCP_SPARCPLANOR
COTA smallint 2 null
SPARCPLANO.COTA FKSPARCPLANODESCP_SPARCPLANOR
PARCELA smallint 2 null
SPARCPLANO.PARCELA FKSPARCPLANODESCP_SPARCPLANOR
IDDESCONTO int 4 null
FDESCONTOPONTUAL.IDDESCONTO FKSPARCPLANODESCPONTUAL_FDESCOR
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)
PKSPARCPLANODESCPONTUAL Primary key Asc/Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + IDPERLET + CODSERVICO + CODPLANOPGTO + PARCELA + COTA + IDDESCONTO

Relationships

Close relationships within degrees of separation