FAPLFIN

168 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
FAPLFIN.CODCOLIGADA FKFAPLFIN_FAPLFINR
FAPLFINCONTA.CODCOLIGADA FKFAPLFINCONTA_FAPLFINR
FAPLFINMOV.CODCOLIGADA FKFAPLFINMOV_FAPLFINR
FAPLFINREND.CODCOLIGADA FKFAPLFINREND_FAPLFINR
FAPLFINRENDMOV.CODCOLIGADA FKFAPLFINRENDMOV_FAPLFINR
FXCX.CODCOLIGADA FKFXCX_FAPLFINR
FTIPOAPLFIN.CODCOLIGADA FKFAPLFIN_FTIPOAPLFINR
FAPLFIN.CODCOLIGADA FKFAPLFIN_FAPLFINR
IDAPLFIN int 4 null
FAPLFIN.IDAPLPAI FKFAPLFIN_FAPLFINR
FAPLFINCONTA.IDAPLFIN FKFAPLFINCONTA_FAPLFINR
FAPLFINMOV.IDAPLFIN FKFAPLFINMOV_FAPLFINR
FAPLFINREND.IDAPLFIN FKFAPLFINREND_FAPLFINR
FAPLFINRENDMOV.IDAPLFIN FKFAPLFINRENDMOV_FAPLFINR
FXCX.IDAPLFIN FKFXCX_FAPLFINR
IDTIPOAPLFIN int 4 null
FTIPOAPLFIN.IDTIPOAPLFIN FKFAPLFIN_FTIPOAPLFINR
DATAAPLICACAO datetime 16,3 √ null
DATARESGATE datetime 16,3 √ null
VALOR RMDVALOR4 17,4 √ null
PERIODICIDADE int 4 √ null
TAXAFIXA RMDVALOR4 17,4 √ null
VALORTAXAFIXA RMDVALOR4 17,4 √ null
CREDITOAUTOMATICO smallint 2 √ null
NUMCASASDECIMAIS int 4 √ null
PERCINDEX RMDVALOR4 17,4 √ null
DATAVENCIMENTO datetime 16,3 √ null
IDAPLPAI int 4 √ null
FAPLFIN.IDAPLFIN FKFAPLFIN_FAPLFINR
STATUSEXPORTACAO smallint 2 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
FATOR numeric 21,4 √ null
IOFVIRTUAL smallint 2 √ ((0))
COLIGADAISENTAIMPOSTOS smallint 2 √ null
COLIGADAISENTAIR smallint 2 √ null
BASECALCULO RMDVALOR4 17,4 √ null

Indexes

Constraint Name Type Sort Column(s)
PKFAPLFIN Primary key Asc/Asc CODCOLIGADA + IDAPLFIN

Relationships

Close relationships within degrees of separation