CHISTP

71 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
CAGMOLDE.CODCOLIGADA FKCAGMOLDE_CHISTPR
CCONTA.CODCOLHISTP FKCHISTP_CCONTAR
CEPESTRUTMOLDE.CODCOLIGADA FKCEPCMOLDE_CHISTPR
CEPGRUPOSCONTAORIGEM.CODCOLORIGEM FKCEPGRUPOSCONTAORIGEM_CHISTPR
CLCMOLDE.CODCOLIGADA FKLCMOLDE_CHISTPR
CPARTIDA.CODCOLIGADA FKCPARTIDA_CHISTPR
CPARTIDAHIST.CODCOLIGADA FKCPARTIDAHIST_CHISTPR
CTGCMOLDE.CODCOLIGADA FKCTGCMOLDE_CHISTPR
DHISTPDIPJ.CODCOLIGADA FKDHISTPDIPJ_CHISTPR
DITMEVCTRBHISTP.CODCOLIGADA FKDITMEVCTRBHISTP_CHISTPR
DNATCONT.CODCOLIGADA FKDNATCONT_CHISTPR
DTRBCONT.CODCOLIGADA FKDTRBCONT_CHISTPR
FCFOCONT.CODCOLIGADA FKFCFOCONT_CHISTPR
FCXACONT.CODCOLPROP FKFCXACONT_CHISTPR
FFATCONT.CODCOLIGADA FKFFATCONT_CHISTPR
FLANCONTOLD.CODCOLIGADA FKFLANCONTOLD_CHISTPR
FPARCONT.CODCOLIGADA FKFPARCONT_CHISTPR
FTB1CONT.CODCOLIGADA FKFTB1CONT_CHISTPR
FTB2CONT.CODCOLIGADA FKFTB2CONT_CHISTPR
FTB3CONT.CODCOLIGADA FKFTB3CONT_CHISTPR
FTB4CONT.CODCOLIGADA FKFTB4CONT_CHISTPR
FTB5CONT.CODCOLIGADA FKFTB5CONT_CHISTPR
FTDOCONT.CODCOLIGADA FKFTDOCONT_CHISTPR
FTIPOAPLFINCONT.CODCOLIGADA FKFTIPOAPLFINCONT_CHISTPR
FXCXCONTOLD.CODCOLIGADA FKFXCXCONTOLD_CHISTPR
IBEMDEFAULTCONT.CODCOLIGADA FKIBEMDEFAULTCONT_CHISTPR
ICENARIOCALCULOCONTA.CODCOLIGADA FKICENARIOCALCULOCONTA_CHISTPR
IGRPCONTDEFAULTCONT.CODCOLIGADA FKIGRPCONTDEFAULTCONT_CHISTPR
IGRUPOPATRIMONIOCONTA.CODCOLIGADA FKIGRUPOPATRIMONIOCONTA_CHISTPR
ILOCALCONT.CODCOLIGADA FKILOCALCONT_CHISTPR
IMOTIVOBAIXACONTA.CODCOLIGADA FKIMOTIVOBAIXACONTA_CHISTPR
IMTBXCONT.CODCOLIGADA FKIMTBXCONT_CHISTPR
IPARTIDAOPERACAO.CODCOLIGADA FKIPARTIDAOPERACAO_CHISTPR
IPATRIMONIOCONTA.CODCOLIGADA FKIPATRIMONIOCONTA_CHISTPR
PENCARGO.CODCOLIGADA FKPENCARGO_CHISTPR
PEVENTO.CODCOLIGADA FKPEVENTO_CHISTPR
SBOLSACONT.CODCOLIGADA FKSBOLSACONT_CHISTPR
SHABILITACAOFILIALCONT.CODCOLIGADA FKSHABILITACAOFILCONT_CHISTPR
SSERVICOCONT.CODCOLIGADA FKSSERVICOCONT_CHISTPR
TCCUSTOCONT.CODCOLIGADA FKTCCUSTOCONT_CHISTPR
TDEPCONT.CODCOLIGADA FKTDEPCONT_CHISTPR
TFILCONT.CODCOLIGADA FKTFILCONT_CHISTPR
TFORMAPAGTOCONT.CODCOLIGADA FLTFORMAPAGTOCONT_CHISTPR
TITMEVC.CODCOLIGADA FKTITMEVC_CHISTPR
TLOCCONT.CODCOLIGADA FKTLOCCONT_CHISTPR
TPRDCONT.CODCOLIGADA FKTPRDCONT_CHISTPR
TRPRCONT.CODCOLIGADA FKTRPRCONT_CHISTPR
TTB1CONT.CODCOLIGADA FKTTB1CONT_CHISTPR
TTB2CONT.CODCOLIGADA FKTTB2CONT_CHISTPR
TTB3CONT.CODCOLIGADA FKTTB3CONT_CHISTPR
TTB4CONT.CODCOLIGADA FKTTB4CONT_CHISTPR
TTB5CONT.CODCOLIGADA FKTTB5CONT_CHISTPR
TTBORCAMENTOCONT.CODCOLIGADA FKTTBORCAMENTOCONT_CHISTPR
TTRACONT.CODCOLIGADA FKTTRACONT_CHISTPR
XAPURACAO963CONTA.CODCOLHISTP FKXAPURACAO963CONTA_CHISTPR
XREGRA963.CODCOLHISTABATIMENTO FKXREGRA963_CHISTPABATR
XREGRA963.CODCOLHISTDISTRATO FKXREGRA963_CHISTPDISTRATOR
XREGRA963.CODCOLHISTRECEITA FKXREGRA963_CHISTPRECEITAR
XREGRA963.CODCOLHISTVENDA FKXREGRA963_CHISTPR
XSUBUNIDADECONT.CODCOLIGADA FKXSUBUNIDADECONT_CHISTPR
XVENDACONTA.CODCOLHISTP FKXVENDACONTA_CHISTPR
GCOLIGADA.CODCOLIGADA FKCHISTP_GCOLIGADAR
CODHISTP varchar 10 null
CAGMOLDE.CODHISTP FKCAGMOLDE_CHISTPR
CCONTA.CODHISTP FKCHISTP_CCONTAR
CEPESTRUTMOLDE.CODHISTP FKCEPCMOLDE_CHISTPR
CEPGRUPOSCONTAORIGEM.CODHISTP FKCEPGRUPOSCONTAORIGEM_CHISTPR
CLCMOLDE.CODHISTP FKLCMOLDE_CHISTPR
CPARTIDA.CODHISTP FKCPARTIDA_CHISTPR
CPARTIDAHIST.CODHISTP FKCPARTIDAHIST_CHISTPR
CTGCMOLDE.CODHISTP FKCTGCMOLDE_CHISTPR
DHISTPDIPJ.CODHISTP FKDHISTPDIPJ_CHISTPR
DITMEVCTRBHISTP.CODHISTP FKDITMEVCTRBHISTP_CHISTPR
DNATCONT.CODHISTP FKDNATCONT_CHISTPR
DTRBCONT.CODHISTP FKDTRBCONT_CHISTPR
FCFOCONT.CODHISTP FKFCFOCONT_CHISTPR
FCXACONT.CODHISTP FKFCXACONT_CHISTPR
FFATCONT.CODHISTP FKFFATCONT_CHISTPR
FLANCONTOLD.CODHISTP FKFLANCONTOLD_CHISTPR
FPARCONT.CODHISTP FKFPARCONT_CHISTPR
FTB1CONT.CODHISTP FKFTB1CONT_CHISTPR
FTB2CONT.CODHISTP FKFTB2CONT_CHISTPR
FTB3CONT.CODHISTP FKFTB3CONT_CHISTPR
FTB4CONT.CODHISTP FKFTB4CONT_CHISTPR
FTB5CONT.CODHISTP FKFTB5CONT_CHISTPR
FTDOCONT.CODHISTP FKFTDOCONT_CHISTPR
FTIPOAPLFINCONT.CODHISTP FKFTIPOAPLFINCONT_CHISTPR
FXCXCONTOLD.CODHISTP FKFXCXCONTOLD_CHISTPR
IBEMDEFAULTCONT.CODHISTP FKIBEMDEFAULTCONT_CHISTPR
ICENARIOCALCULOCONTA.CODHISTP FKICENARIOCALCULOCONTA_CHISTPR
IGRPCONTDEFAULTCONT.CODHISTP FKIGRPCONTDEFAULTCONT_CHISTPR
IGRUPOPATRIMONIOCONTA.CODHISTP FKIGRUPOPATRIMONIOCONTA_CHISTPR
ILOCALCONT.CODHISTP FKILOCALCONT_CHISTPR
IMOTIVOBAIXACONTA.CODHISTP FKIMOTIVOBAIXACONTA_CHISTPR
IMTBXCONT.CODHISTP FKIMTBXCONT_CHISTPR
IPARTIDAOPERACAO.CODHISTORICOPADRAO FKIPARTIDAOPERACAO_CHISTPR
IPATRIMONIOCONTA.CODHISTP FKIPATRIMONIOCONTA_CHISTPR
PENCARGO.NROHISTPADRAO FKPENCARGO_CHISTPR
PEVENTO.NROHISTPADRAO FKPEVENTO_CHISTPR
SBOLSACONT.CODHISTP FKSBOLSACONT_CHISTPR
SHABILITACAOFILIALCONT.CODHISTP FKSHABILITACAOFILCONT_CHISTPR
SSERVICOCONT.CODHISTP FKSSERVICOCONT_CHISTPR
TCCUSTOCONT.CODHISTP FKTCCUSTOCONT_CHISTPR
TDEPCONT.CODHISTP FKTDEPCONT_CHISTPR
TFILCONT.CODHISTP FKTFILCONT_CHISTPR
TFORMAPAGTOCONT.CODHISTP FLTFORMAPAGTOCONT_CHISTPR
TITMEVC.CODHISTP FKTITMEVC_CHISTPR
TLOCCONT.CODHISTP FKTLOCCONT_CHISTPR
TPRDCONT.CODHISTP FKTPRDCONT_CHISTPR
TRPRCONT.CODHISTP FKTRPRCONT_CHISTPR
TTB1CONT.CODHISTP FKTTB1CONT_CHISTPR
TTB2CONT.CODHISTP FKTTB2CONT_CHISTPR
TTB3CONT.CODHISTP FKTTB3CONT_CHISTPR
TTB4CONT.CODHISTP FKTTB4CONT_CHISTPR
TTB5CONT.CODHISTP FKTTB5CONT_CHISTPR
TTBORCAMENTOCONT.CODHISTP FKTTBORCAMENTOCONT_CHISTPR
TTRACONT.CODHISTP FKTTRACONT_CHISTPR
XAPURACAO963CONTA.CODHISTP FKXAPURACAO963CONTA_CHISTPR
XREGRA963.CODHISTABATIMENTO FKXREGRA963_CHISTPABATR
XREGRA963.CODHISTDISTRATO FKXREGRA963_CHISTPDISTRATOR
XREGRA963.CODHISTRECEITA FKXREGRA963_CHISTPRECEITAR
XREGRA963.CODHISTVENDA FKXREGRA963_CHISTPR
XSUBUNIDADECONT.CODHISTP FKXSUBUNIDADECONT_CHISTPR
XVENDACONTA.CODHISTP FKXVENDACONTA_CHISTPR
DESCRICAO varchar 180 √ null
COMPOBRIG smallint 2 √ null
COMPDESNEC smallint 2 √ null
HISTFECHA smallint 2 √ null
ID int identity 4 √ 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)
PKHISTP Primary key Asc/Asc CODCOLIGADA + CODHISTP
CXHISTPCOLDESCR Performance Asc/Asc CODCOLIGADA + DESCRICAO
CXHISTPID Must be unique Asc ID

Relationships

Close relationships within degrees of separation