PFINANCEIRO

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFITEMLAN.CODCOLIGADA FKPFITEMLAN_PFINANCEIROR
PRATFINANCEIRO.CODCOLIGADA FKPRATFINANCEIRO_PFINANCEIROR
FTB2.CODCOLIGADA FKPFINANCEIRO_FTB2R
GCCUSTO.CODCOLIGADA FKPFINANCEIRO_GCCUSTOR
PSECAO.CODCOLIGADA FKPFINANCEIRO_PSECAOR
FTDO.CODCOLIGADA FKPFINANCEIRO_FTDOR
GCOLIGADA.CODCOLIGADA FKPFINANCEIRO_GCOLIGADAR
FTB3.CODCOLIGADA FKPFINANCEIRO_FTB3R
FTB1.CODCOLIGADA FKPFINANCEIRO_FTB1R
FTB4.CODCOLIGADA FKPFINANCEIRO_FTB4R
GFILIAL.CODCOLIGADA FKPFINANCEIRO_GFILIALR
FTB5.CODCOLIGADA FKPFINANCEIRO_FTB5R
IDFINANC int 4 null
PFITEMLAN.IDFINANC FKPFITEMLAN_PFINANCEIROR
PRATFINANCEIRO.IDFINANC FKPRATFINANCEIRO_PFINANCEIROR
NUMERODOCUMENTO varchar 40 √ null
DATACRIACAO DDATETIME 16,3 √ null
CODTDO varchar 10 √ null
FTDO.CODTDO FKPFINANCEIRO_FTDOR
CODCOLCFO DCODCOLIGADANULL 2 √ null
GCOLIGADA.CODCOLIGADA FKPFINANCEIRO_GCOLCFOR
FCFO.CODCOLIGADA FKPFINANCEIRO_FCFOR
CODCFO varchar 25 √ null
FCFO.CODCFO FKPFINANCEIRO_FCFOR
DATAEMISSAO DDATETIME 16,3 √ null
DATAVENCIMENTO DDATETIME 16,3 √ null
VALORORIGINAL RMDVALOR4 17,4 √ null
DATAPREVISAOAIXA DDATETIME 16,3 √ null
CODRECEITA varchar 10 √ null
FIRRF.CODRECEITA Implied ConstraintR
CODMOEDA varchar 10 √ null
GMOEDA.SIMBOLO FKPFINANCEIRO_GMOEDAR
CODFILIAL smallint 2 √ null
GFILIAL.CODFILIAL FKPFINANCEIRO_GFILIALR
CODCCUSTO varchar 25 √ null
GCCUSTO.CODCCUSTO FKPFINANCEIRO_GCCUSTOR
CHAPA DCHAPANULL 16 √ null
CODCOLCXA DCODCOLIGADANULL 2 √ null
GCOLIGADA.CODCOLIGADA FKPFINANCEIRO_GCOLCXAR
FCXA.CODCOLIGADA FKPFINANCEIRO_FCXAR
CODCXA varchar 10 √ null
FCXA.CODCXA FKPFINANCEIRO_FCXAR
DATACONTABILIZACAO DDATETIME 16,3 √ null
CODTB1FLX varchar 25 √ null
FTB1.CODTB1FLX FKPFINANCEIRO_FTB1R
CODTB2FLX varchar 25 √ null
FTB2.CODTB2FLX FKPFINANCEIRO_FTB2R
CODTB3FLX varchar 25 √ null
FTB3.CODTB3FLX FKPFINANCEIRO_FTB3R
CODTB4FLX varchar 25 √ null
FTB4.CODTB4FLX FKPFINANCEIRO_FTB4R
CODTB5FLX varchar 25 √ null
FTB5.CODTB5FLX FKPFINANCEIRO_FTB5R
MESCOMP datetime 16,3 √ null
HISTORICO varchar 255 √ null
CODSECAO varchar 35 √ null
PSECAO.CODIGO FKPFINANCEIRO_PSECAOR
TIPOLAN smallint 2 √ null
UUID varchar 255 √ null
HCFILAMENSAGEM.UUID Implied ConstraintR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CODCOLTOMADOR DCODCOLIGADANULL 2 √ null
FCFOCEI.CODCOLIGADA FKPFINANCEIRO_FCFOCEIR
FCFO.CODCOLIGADA FKPFINANCEIRO_FCFO2R
CODTOMADOR varchar 25 √ null
FCFO.CODCFO FKPFINANCEIRO_FCFO2R
FCFOCEI.CODCFO FKPFINANCEIRO_FCFOCEIR
IDCEITOMADOR int 4 √ null
FCFOCEI.IDCEI FKPFINANCEIRO_FCFOCEIR
STATUSINTEGRACAO smallint 2 ((0))
CODCOLNATFINANCEIRA DCODCOLIGADANULL 2 √ null
TTBORCAMENTO.CODCOLIGADA FKPFINANCEIRO_TTBORCAMENTOR
CODNATFINANCEIRA varchar 40 √ null
TTBORCAMENTO.CODTBORCAMENTO FKPFINANCEIRO_TTBORCAMENTOR

Indexes

Constraint Name Type Sort Column(s)
PKPFINANCEIRO Primary key Asc/Asc CODCOLIGADA + IDFINANC

Relationships

Close relationships within degrees of separation