TREDUCAOZTRB

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
TREDUCAOZ.CODCOLIGADA FKTREDUCAOZTRB_TREDUCAOZR
DCFOP.CODCOLIGADA FKTREDUCAOZTRB_DCFOPR
DTRIBUTO.CODCOLIGADA FKTREDUCAOZTRB_DTRIBUTOR
IDREDUCAOZ int 4 null
TREDUCAOZ.IDREDUCAOZ FKTREDUCAOZTRB_TREDUCAOZR
CODTRB varchar 10 null
DTRIBUTO.CODTRB FKTREDUCAOZTRB_DTRIBUTOR
IDNAT int 4 null
DCFOP.IDNAT FKTREDUCAOZTRB_DCFOPR
ALIQUOTA RMDVALOR2 17,2 null
VALORTOTAL RMDVALOR2 17,2 √ null
VALORIMPOSTO RMDVALOR2 17,2 √ null
ACRESCIMOS RMDVALOR2 17,2 √ null
DESCONTOS RMDVALOR2 17,2 √ null
CANCELAMENTOS RMDVALOR2 17,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)
PKTREDUCAOZTRB Primary key Asc/Asc/Asc/Asc/Asc CODCOLIGADA + IDREDUCAOZ + CODTRB + IDNAT + ALIQUOTA

Relationships

Close relationships within degrees of separation