PLANCFINANC

13 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PLANCFINANCATIVO.CODCOLIGADA FKPLANCFINANCATIVO_PLANCFINANCR
FTB2.CODCOLIGADA FKPLANCFINANC_FTB2R
FTDO.CODCOLIGADA FKLANCFINANC_FTDOR
GCOLIGADA.CODCOLIGADA FKPLANCFINANC_GCOLIGADAR
FTB3.CODCOLIGADA FKPLANCFINANC_FTB3R
FTB1.CODCOLIGADA FKPLANCFINANC_FTB1R
FTB4.CODCOLIGADA FKPLANCFINANC_FTB4R
PRATEIO.CODCOLIGADA FKPLANCFINANC_PRATEIOR
GFORMULA.CODCOLIGADA FKPLANCFINANC_GFORMULAR
FTB5.CODCOLIGADA FKPLANCFINANC_FTB5R
CODLANC varchar 5 null
PLANCFINANCATIVO.CODLANC FKPLANCFINANCATIVO_PLANCFINANCR
LANFIN smallint 2 null
PCODLANFIN.CODCLIENTE FKPLANCFINANC_PCODLANFINR
CODTDO varchar 10 √ null
FTDO.CODTDO FKLANCFINANC_FTDOR
CODCOLCFO smallint 2 √ null
FCFO.CODCOLIGADA FKPLANCFINANC_FCFOR
CODCFO varchar 25 √ null
FCFO.CODCFO FKPLANCFINANC_FCFOR
DESCRICAO varchar 50 √ null
COMPLHISTORICO varchar 50 √ null
CODFORMCALC varchar 8 √ null
GFORMULA.CODIGO FKPLANCFINANC_GFORMULAR
APLICACAOFORMCALC varchar 1 √ null
GFORMULA.APLICACAO FKPLANCFINANC_GFORMULACHR
MOEDA varchar 10 √ null
GMOEDA.SIMBOLO FKPLANCFINANC_GMOEDAR
CODCOLCXA DCODCOLIGADANULL 2 √ null
FCXA.CODCOLIGADA FKPLANCFINANC_FCXAR
CODCXA varchar 10 √ null
FCXA.CODCXA FKPLANCFINANC_FCXAR
TIPOCONTABIL smallint 2 √ null
FORMCOMPLHIST varchar 8 √ null
GFORMULA.CODIGO FKPLANCFINANC_GFORMULACHR
CODRATEIO varchar 8 √ null
PRATEIO.CODIGO FKPLANCFINANC_PRATEIOR
PERCALCRATEIO smallint 2 √ (1)
CODTB1FLX varchar 25 √ null
FTB1.CODTB1FLX FKPLANCFINANC_FTB1R
CODTB2FLX varchar 25 √ null
FTB2.CODTB2FLX FKPLANCFINANC_FTB2R
CODTB3FLX varchar 25 √ null
FTB3.CODTB3FLX FKPLANCFINANC_FTB3R
CODTB4FLX varchar 25 √ null
FTB4.CODTB4FLX FKPLANCFINANC_FTB4R
CODTB5FLX varchar 25 √ null
FTB5.CODTB5FLX FKPLANCFINANC_FTB5R
ACRESCIMO RMDVALOR4 17,4 √ null
USARHISTORICOPADRAO DLOGICO 2 (1)
TIPOINDIVIDUAL smallint 2 (0)
ORIGEMFORNEC smallint 2 (0)
USARDATAPAGNOVENCIMENTO DLOGICO 2 (0)
ARREDTOTAL DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
CODCOLNATFINANCEIRA DCODCOLIGADANULL 2 √ null
TTBORCAMENTO.CODCOLIGADA FKPLANCFINANC_TTBORCAMENTOR
CODNATFINANCEIRA varchar 40 √ null
TTBORCAMENTO.CODTBORCAMENTO FKPLANCFINANC_TTBORCAMENTOR
SEGUERATEIOMOVENSINOIMP DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
DESCONSIDERARAUTONOMOS smallint 2 √ null

Indexes

Constraint Name Type Sort Column(s)
PKPLANCFINANC Primary key Asc/Asc CODCOLIGADA + CODLANC
PXPLANCFINANC Performance Asc/Asc CODCOLCFO + CODCFO

Relationships

Close relationships within degrees of separation