FDESCONTOPONTUAL

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SBOLSADESCPONTUAL.CODCOLIGADA FKSBOLSADESCPONTUAL_FDESCONTOPR
SPARCPLANODESCPONTUAL.CODCOLIGADA FKSPARCPLANODESCPONTUAL_FDESCOR
IDDESCONTO int 4 null
SBOLSADESCPONTUAL.IDDESCONTO FKSBOLSADESCPONTUAL_FDESCONTOPR
SPARCPLANODESCPONTUAL.IDDESCONTO FKSPARCPLANODESCPONTUAL_FDESCOR
DESCRICAO varchar 100 null
TIPODESCONTOCOND varchar 1 null
TIPOLIMITEDESCONTOCOND varchar 1 null
VALORDESCONTOCOND RMDVALOR4 17,4 null
DATALIMITEDESCONTOCOND DDATETIME 16,3 √ null
DIASLIMITEDESCONTOCOND smallint 2 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CODCOLAGRUPADESCPONTUAL DCODCOLIGADANULL 2 √ null
FAGRUPADESCONTOPONTUAL.CODCOLIGADA FKFDESCONTOPONTUAL_FAGRUPADESCR
IDAGRUPADESCPONTUAL int 4 √ null
FAGRUPADESCONTOPONTUAL.IDAGRUPADESCPONTUAL FKFDESCONTOPONTUAL_FAGRUPADESCR

Indexes

Constraint Name Type Sort Column(s)
PKFDESCONTOPONTUAL Primary key Asc/Asc CODCOLIGADA + IDDESCONTO

Relationships

Close relationships within degrees of separation