Árvore de páginas

Versões comparadas

Chave

  • Esta linha foi adicionada.
  • Esta linha foi removida.
  • A formatação mudou.
Banco: cad2loc-psc.df
--------------------------------------------------------------------------------
Adicionado campo "cdn-emitente-sri" OF "ecu-empres"

--------------------------------------------------------------------------------

Banco: emsdca-psc.df
--------------------------------------------------------------------------------
Atualizado campo "cod-mensagem" OF "scp-gestor-status"
Adicionado índice "estab-codigo" ON "oe-item-estab"

--------------------------------------------------------------------------------

Banco: emsfin-psc.df
--------------------------------------------------------------------------------
Adicionado campo "log_reinf_retenc" OF "espec_docto_financ"

--------------------------------------------------------------------------------

Banco: emsfnd-psc.df
--------------------------------------------------------------------------------
Atualizado campo "dsl_pilha_prog" OF "smt_msg_historico"
Atualizado campo "des_tip_client" OF "smt_msg_historico"

--------------------------------------------------------------------------------

Banco: mgadm-psc.df
--------------------------------------------------------------------------------
Atualizado campo "cod-mensagem" OF "emitente"

--------------------------------------------------------------------------------

Banco: mgdis-psc.df
--------------------------------------------------------------------------------
Adicionada tabela nova "root"
Adicionada tabela nova "root-sku"
Adicionado campo "cod-root" OF "root" AS character
Adicionado campo "desc-root" OF "root" AS character
Adicionado campo "cod-root" OF "root-sku" AS character
Adicionado campo "cod-sku" OF "root-sku" AS character
Adicionado campo "desc-ecommerce" OF "item-dist" AS character
Adicionado índice "root_id1" ON "root"
Adicionado índice "desc-id2" ON "root"
Adicionado índice "root-id1" ON "root-sku"

--------------------------------------------------------------------------------

Banco: mgfis-psc.df
--------------------------------------------------------------------------------
Adicionado campo "des-destinatarios" OF "cpromis-calend-fisc" AS character

--------------------------------------------------------------------------------

Banco: mgind-psc.df
--------------------------------------------------------------------------------
Adicionado campo "observ-compar" OF "doc-orig-nfe" AS character

--------------------------------------------------------------------------------

Banco: mgscm-psc.df
--------------------------------------------------------------------------------
Atualizado campo "cod-mensagem" OF "wt-pedido-sfa"

--------------------------------------------------------------------------------

Banco: mov2loc-psc.df
--------------------------------------------------------------------------------
Adicionado campo "cdn-emitente-sri" OF "ecu-docto-estoq"

--------------------------------------------------------------------------------

Banco: movdis-psc.df
--------------------------------------------------------------------------------
Atualizado campo "cod-mensagem" OF "ped-venda"
Atualizado campo "desc-bloq-cr" OF "ped-venda"

--------------------------------------------------------------------------------

Banco: movfin-psc.df
--------------------------------------------------------------------------------
Adicionado campo "cod_autoriz_antecip" OF "ext_tit_acr" AS character
Adicionado campo "num_parc_cartcred_antecip" OF "ext_tit_acr"
Adicionado campo "cod_comprov_vda_antecip" OF "ext_tit_acr" AS character
Adicionado campo "ind_tip_espec_docto" OF "ext_tit_acr" AS character
Adicionado campo "val_perc_comis_antecip" OF "ext_tit_acr" AS decimal
Adicionado campo "val_comis_cartao_antecip" OF "ext_tit_acr" AS decimal
Adicionado campo "val_base_cartao_antecip" OF "ext_tit_acr" AS decimal
Adicionado campo "log_reinf_retenc" OF "ext_tit_ap"
Adicionado índice "extttcr_aut" ON "ext_tit_acr"
Adicionado índice "extttcr_comp" ON "ext_tit_acr"
Adicionado índice "extttcr_estaut" ON "ext_tit_acr"
Adicionado índice "extttcr_estvda" ON "ext_tit_acr"
Adicionado índice "ttcrcbrs_emp" ON "tit_acr_cobr_especial"
Adicionado índice "ttcrcbrs_empadm" ON "tit_acr_cobr_especial"
Adicionado índice "ttcrcbrs_empco" ON "tit_acr_cobr_especial"
Adicionado índice "ttcrcbrs_empdat" ON "tit_acr_cobr_especial"

--------------------------------------------------------------------------------

Banco: movfis-psc.df
--------------------------------------------------------------------------------
Atualizado campo "dat-inic-valid" OF "dwf-benef-fisc"
Atualizado campo "dat-fin-valid" OF "dwf-benef-fisc"
Atualizado campo "dat-inic-valid" OF "dwf-ctpe-trans-cont"
Atualizado campo "dat-fim-valid" OF "dwf-ctpe-trans-cont"
Atualizado campo "dat-inic-valid" OF "dwf-info-trans-cont"
Atualizado campo "dat-fim-valid" OF "dwf-info-trans-cont"
Adicionado campo "dat-inic-period" OF "dwf-benef-fisc" AS date
Adicionado campo "dat-fim-period" OF "dwf-benef-fisc" AS date
Adicionado campo "dat-inic-period" OF "dwf-ctpe-trans-cont" AS date
Adicionado campo "dat-fim-period" OF "dwf-ctpe-trans-cont" AS date
Adicionado campo "dat-inic-period" OF "dwf-info-trans-cont" AS date
Adicionado campo "dat-fim-period" OF "dwf-info-trans-cont" AS date
Renomeado índice "dwf-dt" TO "temp-0000000002" ON "dwf-benef-fisc"
Renomeado índice "dwf-dt" TO "temp-0000000004" ON "dwf-ctpe-trans-cont"
Renomeado índice "dwf-dt" TO "temp-0000000006" ON "dwf-info-trans-cont"
Adicionado índice "dwf-dt" ON "dwf-benef-fisc"
Adicionado índice "dwf-dt" ON "dwf-ctpe-trans-cont"
Adicionado índice "dwf-dt" ON "dwf-info-trans-cont"
Removido índice "temp-0000000002" ON "dwf-benef-fisc"
Removido índice "temp-0000000004" ON "dwf-ctpe-trans-cont"
Removido índice "temp-0000000006" ON "dwf-info-trans-cont"

--------------------------------------------------------------------------------

Banco: srcadger-psc.df
--------------------------------------------------------------------------------
Adicionada tabela nova "sib-divergencia-cnx"
Adicionado campo "idi-registro" OF "sib-divergencia-cnx"
Adicionado campo "idi-registro-benef" OF "sib-divergencia-cnx"
Adicionado campo "in-tipo" OF "sib-divergencia-cnx"
Adicionado campo "in-status" OF "sib-divergencia-cnx"
Adicionado campo "log-acatar-ft-multi" OF "pipresta"
Adicionado campo "cd-prest-cob-soc-uni" OF "preserv" AS character
Adicionado campo "dat-ult-atualiz" OF "sib-conferencia" AS date
Adicionado campo "hra-ult-atualiz" OF "sib-conferencia" AS character
Adicionado campo "cod-usuar-ult-atualiz" OF "sib-conferencia" AS character
Adicionado campo "blb-arquivo" OF "sib-conferencia" AS blob
  LOB-BYTES 1073741823
  LOB-SIZE "1G"
Adicionado campo "cod-livre-2" OF "sib-conferencia" AS character
Adicionado campo "cod-livre-3" OF "sib-conferencia" AS character
Adicionado campo "cod-livre-4" OF "sib-conferencia" AS character
Adicionado campo "cod-livre-5" OF "sib-conferencia" AS character
Adicionado campo "cod-livre-6" OF "sib-conferencia" AS character
Adicionado campo "cod-livre-7" OF "sib-conferencia" AS character
Adicionado campo "cod-livre-8" OF "sib-conferencia" AS character
Adicionado campo "cod-livre-9" OF "sib-conferencia" AS character
Adicionado campo "cod-livre-10" OF "sib-conferencia" AS character
Adicionado campo "num-livre-1" OF "sib-conferencia"
Adicionado campo "num-livre-2" OF "sib-conferencia"
Adicionado campo "num-livre-3" OF "sib-conferencia"
Adicionado campo "num-livre-4" OF "sib-conferencia"
Adicionado campo "num-livre-5" OF "sib-conferencia"
Adicionado campo "num-livre-6" OF "sib-conferencia"
Adicionado campo "num-livre-7" OF "sib-conferencia"
Adicionado campo "num-livre-8" OF "sib-conferencia"
Adicionado campo "num-livre-9" OF "sib-conferencia"
Adicionado campo "num-livre-10" OF "sib-conferencia"
Adicionado campo "val-livre-1" OF "sib-conferencia" AS decimal
Adicionado campo "val-livre-2" OF "sib-conferencia" AS decimal
Adicionado campo "val-livre-3" OF "sib-conferencia" AS decimal
Adicionado campo "val-livre-4" OF "sib-conferencia" AS decimal
Adicionado campo "val-livre-5" OF "sib-conferencia" AS decimal
Adicionado campo "val-livre-6" OF "sib-conferencia" AS decimal
Adicionado campo "val-livre-7" OF "sib-conferencia" AS decimal
Adicionado campo "val-livre-8" OF "sib-conferencia" AS decimal
Adicionado campo "val-livre-9" OF "sib-conferencia" AS decimal
Adicionado campo "val-livre-10" OF "sib-conferencia" AS decimal
Adicionado campo "log-livre-1" OF "sib-conferencia"
Adicionado campo "log-livre-2" OF "sib-conferencia"
Adicionado campo "log-livre-3" OF "sib-conferencia"
Adicionado campo "log-livre-4" OF "sib-conferencia"
Adicionado campo "log-livre-5" OF "sib-conferencia"
Adicionado campo "log-livre-6" OF "sib-conferencia"
Adicionado campo "log-livre-7" OF "sib-conferencia"
Adicionado campo "log-livre-8" OF "sib-conferencia"
Adicionado campo "log-livre-9" OF "sib-conferencia"
Adicionado campo "log-livre-10" OF "sib-conferencia"
Adicionado campo "dat-livre-1" OF "sib-conferencia" AS date
Adicionado campo "dat-livre-2" OF "sib-conferencia" AS date
Adicionado campo "dat-livre-3" OF "sib-conferencia" AS date
Adicionado campo "dat-livre-4" OF "sib-conferencia" AS date
Adicionado campo "dat-livre-5" OF "sib-conferencia" AS date
Adicionado campo "dat-livre-6" OF "sib-conferencia" AS date
Adicionado campo "dat-livre-7" OF "sib-conferencia" AS date
Adicionado campo "dat-livre-8" OF "sib-conferencia" AS date
Adicionado campo "dat-livre-9" OF "sib-conferencia" AS date
Adicionado campo "dat-livre-10" OF "sib-conferencia" AS date
Adicionado campo "cod-livre-1" OF "sib-conferencia" AS character
Adicionado campo "hra-ult-atualiz" OF "sib-conferencia-benef" AS character
Adicionado campo "cod-usuar-ult-atualiz" OF "sib-conferencia-benef" AS character
Adicionado campo "cod-livre-1" OF "sib-conferencia-benef" AS character
Adicionado campo "cod-livre-2" OF "sib-conferencia-benef" AS character
Adicionado campo "cod-livre-3" OF "sib-conferencia-benef" AS character
Adicionado campo "cod-livre-4" OF "sib-conferencia-benef" AS character
Adicionado campo "cod-livre-5" OF "sib-conferencia-benef" AS character
Adicionado campo "cod-livre-6" OF "sib-conferencia-benef" AS character
Adicionado campo "cod-livre-7" OF "sib-conferencia-benef" AS character
Adicionado campo "cod-livre-8" OF "sib-conferencia-benef" AS character
Adicionado campo "cod-livre-9" OF "sib-conferencia-benef" AS character
Adicionado campo "cod-livre-10" OF "sib-conferencia-benef" AS character
Adicionado campo "num-livre-1" OF "sib-conferencia-benef"
Adicionado campo "num-livre-2" OF "sib-conferencia-benef"
Adicionado campo "num-livre-3" OF "sib-conferencia-benef"
Adicionado campo "num-livre-4" OF "sib-conferencia-benef"
Adicionado campo "num-livre-5" OF "sib-conferencia-benef"
Adicionado campo "num-livre-6" OF "sib-conferencia-benef"
Adicionado campo "num-livre-7" OF "sib-conferencia-benef"
Adicionado campo "num-livre-8" OF "sib-conferencia-benef"
Adicionado campo "num-livre-9" OF "sib-conferencia-benef"
Adicionado campo "num-livre-10" OF "sib-conferencia-benef"
Adicionado campo "val-livre-1" OF "sib-conferencia-benef" AS decimal
Adicionado campo "val-livre-2" OF "sib-conferencia-benef" AS decimal
Adicionado campo "val-livre-3" OF "sib-conferencia-benef" AS decimal
Adicionado campo "val-livre-4" OF "sib-conferencia-benef" AS decimal
Adicionado campo "val-livre-5" OF "sib-conferencia-benef" AS decimal
Adicionado campo "val-livre-6" OF "sib-conferencia-benef" AS decimal
Adicionado campo "val-livre-7" OF "sib-conferencia-benef" AS decimal
Adicionado campo "val-livre-8" OF "sib-conferencia-benef" AS decimal
Adicionado campo "val-livre-9" OF "sib-conferencia-benef" AS decimal
Adicionado campo "val-livre-10" OF "sib-conferencia-benef" AS decimal
Adicionado campo "log-livre-1" OF "sib-conferencia-benef"
Adicionado campo "log-livre-2" OF "sib-conferencia-benef"
Adicionado campo "log-livre-3" OF "sib-conferencia-benef"
Adicionado campo "log-livre-4" OF "sib-conferencia-benef"
Adicionado campo "log-livre-5" OF "sib-conferencia-benef"
Adicionado campo "log-livre-6" OF "sib-conferencia-benef"
Adicionado campo "log-livre-7" OF "sib-conferencia-benef"
Adicionado campo "log-livre-8" OF "sib-conferencia-benef"
Adicionado campo "log-livre-9" OF "sib-conferencia-benef"
Adicionado campo "log-livre-10" OF "sib-conferencia-benef"
Adicionado campo "dat-livre-1" OF "sib-conferencia-benef" AS date
Adicionado campo "dat-livre-2" OF "sib-conferencia-benef" AS date
Adicionado campo "dat-livre-3" OF "sib-conferencia-benef" AS date
Adicionado campo "dat-livre-4" OF "sib-conferencia-benef" AS date
Adicionado campo "dat-livre-5" OF "sib-conferencia-benef" AS date
Adicionado campo "dat-livre-6" OF "sib-conferencia-benef" AS date
Adicionado campo "dat-livre-7" OF "sib-conferencia-benef" AS date
Adicionado campo "dat-livre-8" OF "sib-conferencia-benef" AS date
Adicionado campo "dat-livre-9" OF "sib-conferencia-benef" AS date
Adicionado campo "dat-livre-10" OF "sib-conferencia-benef" AS date
Adicionado campo "dat-ult-atualiz" OF "sib-conferencia-benef" AS date
Adicionado campo "lg-escal-via-acesso" OF "tabprepr"
Adicionado índice "sibdivergcnx-id" ON "sib-divergencia-cnx"
Adicionado índice "sibdivergcnx-tipo" ON "sib-divergencia-cnx"

--------------------------------------------------------------------------------

Banco: srmovcon-psc.df
--------------------------------------------------------------------------------
Adicionada tabela nova "movimen-proced-cirurgic"
Adicionado campo "id-unico" OF "movimen-proced-cirurgic"
Adicionado campo "id-ato-cirurgico" OF "movimen-proced-cirurgic"
Adicionado campo "cd-unidade" OF "movimen-proced-cirurgic"
Adicionado campo "cd-unidade-prestadora" OF "movimen-proced-cirurgic"
Adicionado campo "cd-transacao" OF "movimen-proced-cirurgic"
Adicionado campo "nr-serie-doc-original" OF "movimen-proced-cirurgic" AS character
Adicionado campo "nr-doc-original" OF "movimen-proced-cirurgic"
Adicionado campo "nr-doc-sistema" OF "movimen-proced-cirurgic"
Adicionado campo "nr-processo" OF "movimen-proced-cirurgic"
Adicionado campo "nr-seq-digitacao" OF "movimen-proced-cirurgic"
Adicionado campo "cd-procedimento" OF "movimen-proced-cirurgic"
Adicionado campo "in-ato-cirurgico" OF "movimen-proced-cirurgic"
Adicionado campo "qt-moeda-honorarios" OF "movimen-proced-cirurgic" AS decimal
Adicionado campo "cd-via-acesso" OF "movimen-proced-cirurgic"
Adicionado campo "cd-unidade-carteira" OF "movimen-proced-cirurgic"
Adicionado campo "cd-carteira-usuario" OF "movimen-proced-cirurgic" AS decimal
Adicionado campo "hr-realizacao" OF "movimen-proced-cirurgic" AS character
Adicionado campo "lg-calc-automatico" OF "movimen-proced-cirurgic"
Adicionado campo "ft-ato-cirurgico-pag" OF "movimen-proced-cirurgic" AS decimal
Adicionado campo "ft-ato-cirurgico-cob" OF "movimen-proced-cirurgic" AS decimal
Adicionado campo "dt-realizacao" OF "movimen-proced-cirurgic" AS date
Adicionado campo "dat-ult-atualiz" OF "movimen-proced-cirurgic" AS date
Adicionado campo "hra-ult-atualiz" OF "movimen-proced-cirurgic" AS character
Adicionado campo "cod-usuar-ult-atualiz" OF "movimen-proced-cirurgic" AS character
Adicionado campo "dt-base-ato-cirurgico" OF "movimen-proced-cirurgic" AS date
Adicionado campo "hr-base-ato-cirurgico" OF "movimen-proced-cirurgic" AS character
Adicionado campo "qt-moeda-honorarios-cob" OF "movimen-proced-cirurgic" AS decimal
Adicionado índice "idx-movto" ON "movimen-proced-cirurgic"
Adicionado índice "idx-id" ON "movimen-proced-cirurgic"
Adicionado índice "mvmprcir-03" ON "movimen-proced-cirurgic"
Adicionado índice "mvmprcir-04" ON "movimen-proced-cirurgic"

--------------------------------------------------------------------------------

Banco: wmovdis-psc.df
--------------------------------------------------------------------------------
Atualizado campo "cod-mensagem" OF "wt-ped-venda"

--------------------------------------------------------------------------------

Banco: movfis-psc.df
--------------------------------------------------------------------------------
Renomeado índice "dwf-ben" TO "temp-0000000001" ON "dwf-benef-fisc"
Renomeado índice "dwf-trans" TO "temp-0000000003" ON "dwf-ctpe-trans-cont"
Renomeado índice "dwf-info" TO "temp-0000000005" ON "dwf-info-trans-cont"
Adicionado índice "dwf-ben" ON "dwf-benef-fisc"
Adicionado índice "dwf-trans" ON "dwf-ctpe-trans-cont"
Adicionado índice "dwf-info" ON "dwf-info-trans-cont"
Removido índice "temp-0000000001" ON "dwf-benef-fisc"
Removido índice "temp-0000000003" ON "dwf-ctpe-trans-cont"
Removido índice "temp-0000000005" ON "dwf-info-trans-cont"