SITEMCONTABILPROTHEUS

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
AINTERVALOPLANEJADOFUNRATEIO.CODCOLIGADA FKAINTERVPLANFUNRAT_SITEMCONTAR
AMOVFUN.CODCOLIGADA FKAMOVFUN_SITEMCONTABILPROTHEUR
AMOVFUNAM.CODCOLIGADA FKAMOVFUNAM_SITEMCONTABILPROTHR
AMOVFUNDIA.CODCOLIGADA FKAMOVFUNDIA_SITEMCONTABILPROTR
AMOVFUNDIAAM.CODCOLIGADA FKAMOVFUNDIAAM_SITEMCONTABILPRR
AOCORRENCIACALCULADA.CODCOLIGADA FKAOCORRENCIACALCULADA_SITEMCOR
AOCORRENCIACALCULADAAM.CODCOLIGADA FKSCLASSEVALORPROTHEUS_SITEMCOR
FCFODEF.CODCOLIGADA FKFCFODEF_SITEMCONTABPROTHEUSR
FLANRATCCU.CODCOLIGADA FKFLANRATCCU_SITEMCONTABILR
LUNIDADEPARAMPROTHEUS.CODCOLIGADA FKLUNIDPARAMPROTH_SITEMCONTPROR
PCONTAS.CODCOLIGADA FKPCONTAS_SITEMCONTABILPROTHEUR
PEVENTO.CODCOLIGADA FKPEVENTO_SITEMCONTABILPROTHEUR
PFMOVENSINO.CODCOLIGADA FKPFMOVENSINO_SITEMCONTABILPROR
PFMOVTEMP.CODCOLIGADA FKPFMOVTEMP_SITEMCONTABILPROTHR
PFUNC.CODCOLIGADA FKPFUNC_SITEMCONTABILPROTHEUSR
PPARTIDA.CODCOLIGADA FKPPARTIDA_SITEMCONTABILPROTHER
PRATFINANCEIRO.CODCOLIGADA FKPRATFINANCEIRO_SITEMCONTABILR
PSECAO.CODCOLIGADA FKPSECAO_SITEMCONTABILPROTHEUSR
SHABILITACAOFILIALINTPROTHEUS.CODCOLIGADA FKSHABFILIALINTPROTH_SITEMCONTR
SPSPROCSELINTPROTHEUS.CODCOLIGADA FKSPSPROCSELINTPROTH_SITEMCONTR
XALGCONTRATOLOCRATEIO.CODCOLITEMCONTABIL FKXALGCONTRATOLOCRATEIO_SITEMCR
XALGIMOVEL.CODCOLITEMCONTABIL FKXALGIMOVEL_SITEMCONTABILPROTR
XEMPREENDIMENTO.CODCOLIGADA FKXEMPREEND_SITEMCONTABILPROTHEUSR
IDITEMCONTABIL int 4 null
AINTERVALOPLANEJADOFUNRATEIO.IDITEMCONTABIL FKAINTERVPLANFUNRAT_SITEMCONTAR
AMOVFUN.IDITEMCONTABIL FKAMOVFUN_SITEMCONTABILPROTHEUR
AMOVFUNAM.IDITEMCONTABIL FKAMOVFUNAM_SITEMCONTABILPROTHR
AMOVFUNDIA.IDITEMCONTABIL FKAMOVFUNDIA_SITEMCONTABILPROTR
AMOVFUNDIAAM.IDITEMCONTABIL FKAMOVFUNDIAAM_SITEMCONTABILPRR
AOCORRENCIACALCULADA.IDITEMCONTABIL FKAOCORRENCIACALCULADA_SITEMCOR
AOCORRENCIACALCULADAAM.IDITEMCONTABIL FKSCLASSEVALORPROTHEUS_SITEMCOR
FCFODEF.IDITEMCONTABIL FKFCFODEF_SITEMCONTABPROTHEUSR
FLANRATCCU.IDITEMCONTABIL FKFLANRATCCU_SITEMCONTABILR
LUNIDADEPARAMPROTHEUS.IDITEMCONTABILPROTHEUS FKLUNIDPARAMPROTH_SITEMCONTPROR
PCONTAS.IDITEMCONTABIL FKPCONTAS_SITEMCONTABILPROTHEUR
PEVENTO.IDITEMCONTABIL FKPEVENTO_SITEMCONTABILPROTHEUR
PFMOVENSINO.IDITEMCONTABIL FKPFMOVENSINO_SITEMCONTABILPROR
PFMOVTEMP.IDITEMCONTABIL FKPFMOVTEMP_SITEMCONTABILPROTHR
PFUNC.IDITEMCONTABIL FKPFUNC_SITEMCONTABILPROTHEUSR
PPARTIDA.IDITEMCONTABIL FKPPARTIDA_SITEMCONTABILPROTHER
PRATFINANCEIRO.IDITEMCONTABIL FKPRATFINANCEIRO_SITEMCONTABILR
PSECAO.IDITEMCONTABIL FKPSECAO_SITEMCONTABILPROTHEUSR
SHABILITACAOFILIALINTPROTHEUS.IDITEMCONTABILPROTHEUS FKSHABFILIALINTPROTH_SITEMCONTR
SPSPROCSELINTPROTHEUS.IDITEMCONTABILPROTHEUS FKSPSPROCSELINTPROTH_SITEMCONTR
XALGCONTRATOLOCRATEIO.IDITEMCONTABIL FKXALGCONTRATOLOCRATEIO_SITEMCR
XALGIMOVEL.IDITEMCONTABIL FKXALGIMOVEL_SITEMCONTABILPROTR
XEMPREENDIMENTO.IDITEMCONTABIL FKXEMPREEND_SITEMCONTABILPROTHEUSR
ITEMCONTABIL varchar 20 null
CODFILIAL smallint 2 √ null
DESCRICAO varchar 100 √ 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)
PKSITEMCONTABILPROTHEUS Primary key Asc/Asc CODCOLIGADA + IDITEMCONTABIL

Relationships

Close relationships within degrees of separation