FTRBLAN

44 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
FADIANTAMENTORETENCAO.CODCOLIGADA FKFADIANTAMENTORET_FTRBLAN2R
FLAN.CODCOLIGADA FKFTRBLAN_FLANR
DTRIBUTO.CODCOLIGADA FKFTRBLAN_DTRIBUTOR
IDTRBLAN int 4 null
FADIANTAMENTORETENCAO.IDTRBLAN FKFADIANTAMENTORET_FTRBLAN1R
FADIANTAMENTORETENCAO.IDTRBLANVINCULADO FKFADIANTAMENTORET_FTRBLAN2R
IDLAN int 4 null
FLAN.IDLAN FKFTRBLAN_FLANR
CODTRB varchar 10 null
DTRIBUTO.CODTRB FKFTRBLAN_DTRIBUTOR
BASEDECALCULO RMDVALOR4 17,4 null
ALIQUOTA RMDVALOR4 17,4 null
VALOR RMDVALOR4 17,4 null
CODRETENCAO varchar 10 null
EDITADO smallint 2 null
RECCREATEDBY varchar 50 null
RECCREATEDON datetime 16,3 null
RECMODIFIEDBY varchar 50 null
RECMODIFIEDON datetime 16,3 null
CST varchar 3 null
BASECALCULOORIGINAL RMDVALOR4 17,4 null
IDNATRENDIMENTO int 4 null
DNATUREZARENDIMENTO.IDNATRENDIMENTO FKFTRBLAN_DNATUREZARENDIMENTOR

Indexes

Constraint Name Type Sort Column(s)
PKFTRBLAN Primary key Asc/Asc CODCOLIGADA + IDTRBLAN
F$FTRBLAN_FLAN Performance Asc/Asc IDLAN + CODCOLIGADA

Relationships