IMPORTANTE:
Correção do pacote dia 22/03/2024 - Efetuado ajuste no CAX do Progress onde algumas tabelas apresentavam erros de diferença incorretamente.
Banco: dthrgst-psc.df -------------------------------------------------------------------------------- Adicionada tabela nova "feedz_integration_errors" TABLE-TRIGGER "CREATE" NO-OVERRIDE PROCEDURE "database/tggt/tcp/tcgt00481.p" CRC "?" TABLE-TRIGGER "DELETE" NO-OVERRIDE PROCEDURE "database/tggt/tdp/tdgt00481.p" CRC "?" TABLE-TRIGGER "WRITE" NO-OVERRIDE PROCEDURE "database/tggt/twp/twgt00481.p" CRC "?" Adicionada tabela nova "feedz_integration_processes" Adicionado campo "process_id" OF "feedz_integration_errors" AS character Adicionado campo "integration_id" OF "feedz_integration_errors" AS character Adicionado campo "error_message" OF "feedz_integration_errors" AS character Adicionado campo "hra_ult_atualiz" OF "feedz_integration_errors" AS character Adicionado campo "dat_ult_atualiz" OF "feedz_integration_errors" AS date Adicionado campo "cod_usuar_ult_atualiz" OF "feedz_integration_errors" AS character Adicionado campo "process_id" OF "feedz_integration_processes" AS character Adicionado campo "status_id" OF "feedz_integration_processes" Adicionado campo "service_id" OF "feedz_integration_processes" Adicionado campo "start_date" OF "feedz_integration_processes" AS datetime-tz Adicionado campo "stop_date" OF "feedz_integration_processes" AS datetime-tz Adicionado campo "environment_id" OF "feedz_integration_processes" Adicionado campo "integration_key" OF "feedz_integration_processes" AS character Adicionado campo "entities_json_data" OF "feedz_integration_processes" AS blob LOB-BYTES 104857600 LOB-SIZE "100M" Adicionado campo "hra_ult_atualiz" OF "feedz_integration_processes" AS character Adicionado campo "dat_ult_atualiz" OF "feedz_integration_processes" AS date Adicionado campo "cod_usuar_ult_atualiz" OF "feedz_integration_processes" AS character Adicionado índice "fdzerr_idx" ON "feedz_integration_errors" Adicionado índice "fdzprc_idx" ON "feedz_integration_processes" -------------------------------------------------------------------------------- Banco: emsfin-psc.df -------------------------------------------------------------------------------- Adicionado campo "val_ajust_min" OF "param_mktplace" AS decimal Adicionado campo "val_ajust_max" OF "param_mktplace" AS decimal Adicionado campo "cod_servid_exec_rpw" OF "param_mktplace" AS character Adicionado campo "des_param_agenda" OF "param_mktplace" AS character -------------------------------------------------------------------------------- Banco: mgadm-psc.df -------------------------------------------------------------------------------- Adicionado campo "log-desconsid-ad-dup-venc" OF "dist-emitente" -------------------------------------------------------------------------------- Banco: mgdis-psc.df -------------------------------------------------------------------------------- Atualizado campo "dec-1" OF "ri-bem" Atualizado campo "dec-2" OF "ri-bem" -------------------------------------------------------------------------------- Banco: movdis-psc.df -------------------------------------------------------------------------------- Atualizado campo "aliq-pis" OF "it-doc-fisc" Atualizado campo "aliq-cofins" OF "it-doc-fisc" -------------------------------------------------------------------------------- Banco: movfin-psc.df -------------------------------------------------------------------------------- Atualizado campo "val_perc_movto_bem_pat" OF "movto_bem_pat" Adicionada tabela nova "diverg_mktplace" Adicionada tabela nova "ext_tit_acr_ecom" Adicionada tabela nova "ext_tit_acr_ecom_pend" Adicionada tabela nova "movto_mktplace_tit_acr" Adicionada tabela nova "pend_diverg_mktplace" Adicionado campo "num_movto_mktplace" OF "diverg_mktplace" Adicionado campo "num_diverg_mktplace" OF "diverg_mktplace" Adicionado campo "ind_tip_diverg" OF "diverg_mktplace" AS character Adicionado campo "dat_diverg" OF "diverg_mktplace" AS date Adicionado campo "val_mktplace" OF "diverg_mktplace" AS decimal Adicionado campo "val_erp" OF "diverg_mktplace" AS decimal Adicionado campo "dat_mktplace" OF "diverg_mktplace" AS date Adicionado campo "dat_erp" OF "diverg_mktplace" AS date Adicionado campo "des_mktplace" OF "diverg_mktplace" AS character Adicionado campo "des_erp" OF "diverg_mktplace" AS character Adicionado campo "des_observacao" OF "diverg_mktplace" AS character Adicionado campo "log_ajust" OF "diverg_mktplace" Adicionado campo "ind_status_diverg" OF "diverg_mktplace" AS character Adicionado campo "cod_usuar_atualiz" OF "diverg_mktplace" AS character Adicionado campo "dat_ult_atualiz" OF "diverg_mktplace" AS date Adicionado campo "hra_ult_atualiz" OF "diverg_mktplace" AS character Adicionado campo "cod_livre_1" OF "diverg_mktplace" AS character Adicionado campo "cod_livre_2" OF "diverg_mktplace" AS character Adicionado campo "log_livre_1" OF "diverg_mktplace" Adicionado campo "log_livre_2" OF "diverg_mktplace" Adicionado campo "num_livre_1" OF "diverg_mktplace" Adicionado campo "num_livre_2" OF "diverg_mktplace" Adicionado campo "val_livre_1" OF "diverg_mktplace" AS decimal Adicionado campo "val_livre_2" OF "diverg_mktplace" AS decimal Adicionado campo "dat_livre_1" OF "diverg_mktplace" AS date Adicionado campo "dat_livre_2" OF "diverg_mktplace" AS date Adicionado campo "cod_estab" OF "ext_tit_acr_ecom" AS character Adicionado campo "num_id_tit_acr" OF "ext_tit_acr_ecom" Adicionado campo "cod_ped_vda" OF "ext_tit_acr_ecom" AS character Adicionado campo "cod_ped_vda_ecom" OF "ext_tit_acr_ecom" AS character Adicionado campo "cod_empresa" OF "ext_tit_acr_ecom" AS character Adicionado campo "cdn_mktplace" OF "ext_tit_acr_ecom" Adicionado campo "cdn_repres" OF "ext_tit_acr_ecom" Adicionado campo "val_base_comis" OF "ext_tit_acr_ecom" AS decimal Adicionado campo "val_perc_comis" OF "ext_tit_acr_ecom" AS decimal Adicionado campo "val_comis" OF "ext_tit_acr_ecom" AS decimal Adicionado campo "val_base_frete" OF "ext_tit_acr_ecom" AS decimal Adicionado campo "val_perc_frete" OF "ext_tit_acr_ecom" AS decimal Adicionado campo "val_frete" OF "ext_tit_acr_ecom" AS decimal Adicionado campo "dsl_historico" OF "ext_tit_acr_ecom" AS character Adicionado campo "cod_livre_1" OF "ext_tit_acr_ecom" AS character Adicionado campo "cod_livre_2" OF "ext_tit_acr_ecom" AS character Adicionado campo "log_livre_1" OF "ext_tit_acr_ecom" Adicionado campo "log_livre_2" OF "ext_tit_acr_ecom" Adicionado campo "num_livre_1" OF "ext_tit_acr_ecom" Adicionado campo "num_livre_2" OF "ext_tit_acr_ecom" Adicionado campo "val_livre_1" OF "ext_tit_acr_ecom" AS decimal Adicionado campo "val_livre_2" OF "ext_tit_acr_ecom" AS decimal Adicionado campo "dat_livre_1" OF "ext_tit_acr_ecom" AS date Adicionado campo "dat_livre_2" OF "ext_tit_acr_ecom" AS date Adicionado campo "cod_estab" OF "ext_tit_acr_ecom_pend" AS character Adicionado campo "cod_refer" OF "ext_tit_acr_ecom_pend" AS character Adicionado campo "num_seq_refer" OF "ext_tit_acr_ecom_pend" Adicionado campo "cod_ped_vda" OF "ext_tit_acr_ecom_pend" AS character Adicionado campo "cod_ped_vda_ecom" OF "ext_tit_acr_ecom_pend" AS character Adicionado campo "cod_empresa" OF "ext_tit_acr_ecom_pend" AS character Adicionado campo "cdn_mktplace" OF "ext_tit_acr_ecom_pend" Adicionado campo "cdn_repres" OF "ext_tit_acr_ecom_pend" Adicionado campo "val_base_comis" OF "ext_tit_acr_ecom_pend" AS decimal Adicionado campo "val_perc_comis" OF "ext_tit_acr_ecom_pend" AS decimal Adicionado campo "val_comis" OF "ext_tit_acr_ecom_pend" AS decimal Adicionado campo "val_base_frete" OF "ext_tit_acr_ecom_pend" AS decimal Adicionado campo "val_perc_frete" OF "ext_tit_acr_ecom_pend" AS decimal Adicionado campo "val_frete" OF "ext_tit_acr_ecom_pend" AS decimal Adicionado campo "dsl_historico" OF "ext_tit_acr_ecom_pend" AS character Adicionado campo "cod_livre_1" OF "ext_tit_acr_ecom_pend" AS character Adicionado campo "cod_livre_2" OF "ext_tit_acr_ecom_pend" AS character Adicionado campo "log_livre_1" OF "ext_tit_acr_ecom_pend" Adicionado campo "log_livre_2" OF "ext_tit_acr_ecom_pend" Adicionado campo "num_livre_1" OF "ext_tit_acr_ecom_pend" Adicionado campo "num_livre_2" OF "ext_tit_acr_ecom_pend" Adicionado campo "val_livre_1" OF "ext_tit_acr_ecom_pend" AS decimal Adicionado campo "val_livre_2" OF "ext_tit_acr_ecom_pend" AS decimal Adicionado campo "dat_livre_1" OF "ext_tit_acr_ecom_pend" AS date Adicionado campo "dat_livre_2" OF "ext_tit_acr_ecom_pend" AS date Adicionado campo "num_movto_mktplace" OF "movto_mktplace_tit_acr" Adicionado campo "cod_estab" OF "movto_mktplace_tit_acr" AS character Adicionado campo "num_id_tit_acr" OF "movto_mktplace_tit_acr" Adicionado campo "cod_ped_vda" OF "movto_mktplace_tit_acr" AS character Adicionado campo "cod_ped_vda_ecom" OF "movto_mktplace_tit_acr" AS character Adicionado campo "val_perc_particip_ped_vda" OF "movto_mktplace_tit_acr" AS decimal Adicionado campo "val_origin_ped_vda" OF "movto_mktplace_tit_acr" AS decimal Adicionado campo "val_sdo_ped_vda" OF "movto_mktplace_tit_acr" AS decimal Adicionado campo "cod_empresa" OF "movto_mktplace_tit_acr" AS character Adicionado campo "cdn_mktplace" OF "movto_mktplace_tit_acr" Adicionado campo "cdn_repres" OF "movto_mktplace_tit_acr" Adicionado campo "val_base_comis" OF "movto_mktplace_tit_acr" AS decimal Adicionado campo "val_perc_comis" OF "movto_mktplace_tit_acr" AS decimal Adicionado campo "val_comis" OF "movto_mktplace_tit_acr" AS decimal Adicionado campo "val_base_frete" OF "movto_mktplace_tit_acr" AS decimal Adicionado campo "val_perc_frete" OF "movto_mktplace_tit_acr" AS decimal Adicionado campo "val_frete" OF "movto_mktplace_tit_acr" AS decimal Adicionado campo "dsl_historico" OF "movto_mktplace_tit_acr" AS character Adicionado campo "cod_livre_1" OF "movto_mktplace_tit_acr" AS character Adicionado campo "cod_livre_2" OF "movto_mktplace_tit_acr" AS character Adicionado campo "log_livre_1" OF "movto_mktplace_tit_acr" Adicionado campo "log_livre_2" OF "movto_mktplace_tit_acr" Adicionado campo "num_livre_1" OF "movto_mktplace_tit_acr" Adicionado campo "num_livre_2" OF "movto_mktplace_tit_acr" Adicionado campo "val_livre_1" OF "movto_mktplace_tit_acr" AS decimal Adicionado campo "val_livre_2" OF "movto_mktplace_tit_acr" AS decimal Adicionado campo "dat_livre_1" OF "movto_mktplace_tit_acr" AS date Adicionado campo "dat_livre_2" OF "movto_mktplace_tit_acr" AS date Adicionado campo "num_movto_mktplace" OF "pend_diverg_mktplace" Adicionado campo "num_diverg_mktplace" OF "pend_diverg_mktplace" Adicionado campo "dat_pend" OF "pend_diverg_mktplace" AS date Adicionado campo "ind_tip_orig_pend" OF "pend_diverg_mktplace" AS character Adicionado campo "val_diferenca" OF "pend_diverg_mktplace" AS decimal Adicionado campo "ind_status_pend" OF "pend_diverg_mktplace" AS character Adicionado campo "des_observacao" OF "pend_diverg_mktplace" AS character Adicionado campo "cod_usuar_atualiz" OF "pend_diverg_mktplace" AS character Adicionado campo "dat_ult_atualiz" OF "pend_diverg_mktplace" AS date Adicionado campo "hra_ult_atualiz" OF "pend_diverg_mktplace" AS character Adicionado campo "cod_livre_1" OF "pend_diverg_mktplace" AS character Adicionado campo "cod_livre_2" OF "pend_diverg_mktplace" AS character Adicionado campo "log_livre_1" OF "pend_diverg_mktplace" Adicionado campo "log_livre_2" OF "pend_diverg_mktplace" Adicionado campo "num_livre_1" OF "pend_diverg_mktplace" Adicionado campo "num_livre_2" OF "pend_diverg_mktplace" Adicionado campo "val_livre_1" OF "pend_diverg_mktplace" AS decimal Adicionado campo "val_livre_2" OF "pend_diverg_mktplace" AS decimal Adicionado campo "dat_livre_1" OF "pend_diverg_mktplace" AS date Adicionado campo "dat_livre_2" OF "pend_diverg_mktplace" AS date Adicionado campo "val_tot_sdo_tit_acr" OF "concil_cartao_cr" AS decimal Adicionado campo "val_tot_comis_prev" OF "concil_cartao_cr" AS decimal Adicionado campo "val_tot_sdo_tit_acr" OF "concil_mktplace_arq" AS decimal Adicionado campo "val_tot_comis_prev" OF "concil_mktplace_arq" AS decimal Adicionado campo "val_tot_frete_prev" OF "concil_mktplace_arq" AS decimal Adicionado campo "val_sdo_tit_acr" OF "lancto_concil_cartao_cr" AS decimal Adicionado campo "val_comis_prev" OF "lancto_concil_cartao_cr" AS decimal Adicionado campo "val_comis_prev" OF "movto_mktplace" AS decimal Adicionado campo "val_frete_prev" OF "movto_mktplace" AS decimal Adicionado campo "val_sdo_tit_acr" OF "movto_mktplace" AS decimal Adicionado campo "ind_status_diverg" OF "movto_mktplace" AS character Adicionado campo "cod_trans_entreg" OF "pos_faturam_techfin" AS character Adicionado campo "log_dat_entreg" OF "pos_faturam_techfin" Adicionado índice "dvrgmktp_id" ON "diverg_mktplace" Adicionado índice "dvrgmktp_dat" ON "diverg_mktplace" Adicionado índice "dvrgmktp_dat_stat" ON "diverg_mktplace" Adicionado índice "dvrgmktp_status" ON "diverg_mktplace" Adicionado índice "dvrgmktp_tip" ON "diverg_mktplace" Adicionado índice "extttcrc_id" ON "ext_tit_acr_ecom" Adicionado índice "ext_tit_emp_id" ON "ext_tit_acr_ecom" Adicionado índice "ext_tit_ped" ON "ext_tit_acr_ecom" Adicionado índice "extttcra_id" ON "ext_tit_acr_ecom_pend" Adicionado índice "mvtmktpa_id" ON "movto_mktplace_tit_acr" Adicionado índice "mvtmktpa_tit_acr" ON "movto_mktplace_tit_acr" Adicionado índice "pnddvrgm_id" ON "pend_diverg_mktplace" Adicionado índice "pnddvrgm_dat" ON "pend_diverg_mktplace" Adicionado índice "pnddvrgm_orig" ON "pend_diverg_mktplace" Adicionado índice "pnddvrgm_orig_dat" ON "pend_diverg_mktplace" Adicionado índice "pnddvrgm_status" ON "pend_diverg_mktplace" Adicionado índice "ilnctcnca_dat_sit" ON "lancto_concil_cartao_cr" Adicionado índice "inctcnca_admdra" ON "lancto_concil_cartao_cr" Adicionado índice "inctcnca_admdra_band" ON "lancto_concil_cartao_cr" Adicionado índice "inctcnca_dat_div" ON "lancto_concil_cartao_cr" Adicionado índice "inctcnca_dat_tip" ON "lancto_concil_cartao_cr" Adicionado índice "inctcnca_diverg_lancto" ON "lancto_concil_cartao_cr" Adicionado índice "inctcnca_sit_lan" ON "lancto_concil_cartao_cr" Adicionado índice "nctcnca_diverg_dat" ON "lancto_concil_cartao_cr" Adicionado índice "mvtmktpl_div" ON "movto_mktplace" Adicionado índice "mvtmktpl_empcdn" ON "movto_mktplace" Adicionado índice "mvtmktpl_empdt" ON "movto_mktplace" Adicionado índice "mvtmktpl_sitdt" ON "movto_mktplace" Adicionado índice "psftrmtc_entreg" ON "pos_faturam_techfin" -------------------------------------------------------------------------------- Banco: movfis-psc.df -------------------------------------------------------------------------------- Atualizado campo "cod-motivo-dapi" OF "dwf-apurac-impto-ajust" Atualizado campo "val-ajust-apurac" OF "dwf-apurac-impto-ajust" Atualizado campo "cod-ajust-sdo" OF "dwf-apurac-impto-ajust" Atualizado campo "cod-ajust-sped" OF "dwf-apurac-impto-ajust" Atualizado campo "num-orig" OF "dwf-apurac-impto-ajust" Atualizado campo "cod-docto" OF "dwf-apurac-impto-ajust" Atualizado campo "log-automatico" OF "dwf-apurac-impto-ajust" Atualizado campo "val-ajust-apurac" OF "dwf-apurac-impto-recolh" Atualizado campo "cod-impto" OF "dwf-apurac-impto-recolh" Atualizado campo "nume-guia" OF "dwf-apurac-impto-recolh" Atualizado campo "cod-org-arrecadac" OF "dwf-apurac-impto-recolh" Atualizado campo "dec-num-guia" OF "dwf-apurac-impto-recolh" Atualizado campo "log-automatico" OF "dwf-apurac-impto-recolh" Atualizado campo "cod-mes-referencia" OF "dwf-apurac-impto-recolh" Atualizado campo "val-aliq-pis" OF "dwf-cr-sobre-dpr-amort" Atualizado campo "val-aliq-cofins" OF "dwf-cr-sobre-dpr-amort" Adicionada tabela nova "dwf-benef-fisc" Adicionada tabela nova "dwf-cta-lucro-exp" Adicionada tabela nova "dwf-ctpe-trans-cont" Adicionada tabela nova "dwf-entid-trans-cont" Adicionada tabela nova "dwf-info-ajust-comp" Adicionada tabela nova "dwf-info-trans-cont" Adicionada tabela nova "dwf-preco-transf" Adicionada tabela nova "dwf-relac-met" Adicionado campo "cod-empresa" OF "dwf-benef-fisc" AS character Adicionado campo "dat-inic-valid" OF "dwf-benef-fisc" AS date Adicionado campo "num-seq-reg" OF "dwf-benef-fisc" Adicionado campo "dat-fin-valid" OF "dwf-benef-fisc" AS date Adicionado campo "ind-tp-benef" OF "dwf-benef-fisc" AS character Adicionado campo "ato-decl" OF "dwf-benef-fisc" AS character Adicionado campo "cod-cnpj-incorp" OF "dwf-benef-fisc" AS character Adicionado campo "Id-obra-018" OF "dwf-benef-fisc" AS character Adicionado campo "Id-obra-020" OF "dwf-benef-fisc" AS character Adicionado campo "id-obra-eei" OF "dwf-benef-fisc" AS character Adicionado campo "cod-port-cebas" OF "dwf-benef-fisc" AS character Adicionado campo "dt-port-cebas" OF "dwf-benef-fisc" AS date Adicionado campo "dt-ini-port-cebas" OF "dwf-benef-fisc" AS date Adicionado campo "dt-fin-port-cebas" OF "dwf-benef-fisc" AS date Adicionado campo "cod-empresa" OF "dwf-cta-lucro-exp" AS character Adicionado campo "num-exerc-ctbl" OF "dwf-cta-lucro-exp" Adicionado campo "num-period-ctbl" OF "dwf-cta-lucro-exp" Adicionado campo "cod-cta-ctbl" OF "dwf-cta-lucro-exp" AS character Adicionado campo "cod-ccusto" OF "dwf-cta-lucro-exp" AS character Adicionado campo "val-sdo-exp" OF "dwf-cta-lucro-exp" AS decimal Adicionado campo "ind-sdo-ctbl" OF "dwf-cta-lucro-exp" AS character Adicionado campo "cod-empresa" OF "dwf-ctpe-trans-cont" AS character Adicionado campo "num-seq-reg" OF "dwf-ctpe-trans-cont" Adicionado campo "dat-inic-valid" OF "dwf-ctpe-trans-cont" AS date Adicionado campo "dat-fim-valid" OF "dwf-ctpe-trans-cont" AS date Adicionado campo "cod-entid" OF "dwf-ctpe-trans-cont" AS character Adicionado campo "nome-entid" OF "dwf-ctpe-trans-cont" AS character Adicionado campo "cod-empresa" OF "dwf-entid-trans-cont" AS character Adicionado campo "num-seq-reg-pai" OF "dwf-entid-trans-cont" Adicionado campo "cod-tp-reg" OF "dwf-entid-trans-cont" Adicionado campo "desc-tp-reg" OF "dwf-entid-trans-cont" AS character Adicionado campo "val-entid-trans" OF "dwf-entid-trans-cont" AS decimal Adicionado campo "cod-empresa" OF "dwf-info-ajust-comp" AS character Adicionado campo "cod-cta-ctbl" OF "dwf-info-ajust-comp" AS character Adicionado campo "cod-ccusto" OF "dwf-info-ajust-comp" AS character Adicionado campo "num-seq-reg-pai" OF "dwf-info-ajust-comp" Adicionado campo "val-sdo-util" OF "dwf-info-ajust-comp" AS decimal Adicionado campo "ind-val-util" OF "dwf-info-ajust-comp" AS character Adicionado campo "cod-empresa" OF "dwf-info-trans-cont" AS character Adicionado campo "num-seq-reg" OF "dwf-info-trans-cont" Adicionado campo "dat-inic-valid" OF "dwf-info-trans-cont" AS date Adicionado campo "dat-fim-valid" OF "dwf-info-trans-cont" AS date Adicionado campo "cod-ident-cont" OF "dwf-info-trans-cont" AS character Adicionado campo "cod-tip-trans" OF "dwf-info-trans-cont" AS character Adicionado campo "nome-entid-cont" OF "dwf-info-trans-cont" AS character Adicionado campo "cod-pais" OF "dwf-info-trans-cont" AS character Adicionado campo "cod-ncm" OF "dwf-info-trans-cont" AS character Adicionado campo "cod-tip-dem" OF "dwf-info-trans-cont" AS character Adicionado campo "desc-bsdi" OF "dwf-info-trans-cont" AS character Adicionado campo "val-trans-cont" OF "dwf-info-trans-cont" AS decimal Adicionado campo "ind-ajustes" OF "dwf-info-trans-cont" AS character Adicionado campo "val-espont" OF "dwf-info-trans-cont" AS decimal Adicionado campo "val-compens" OF "dwf-info-trans-cont" AS decimal Adicionado campo "ind-ajuste-compens" OF "dwf-info-trans-cont" AS character Adicionado campo "cod-metodo" OF "dwf-info-trans-cont" AS character Adicionado campo "desc-metodo" OF "dwf-info-trans-cont" AS character Adicionado campo "ind-comp-intenc" OF "dwf-info-trans-cont" AS character Adicionado campo "ind-sinerg" OF "dwf-info-trans-cont" AS character Adicionado campo "ind-trans-comb" OF "dwf-info-trans-cont" AS character Adicionado campo "ind-dados-multip" OF "dwf-info-trans-cont" AS character Adicionado campo "ind-simplific" OF "dwf-info-trans-cont" AS character Adicionado campo "cod-empresa" OF "dwf-preco-transf" AS character Adicionado campo "num-exerc-ctbl" OF "dwf-preco-transf" Adicionado campo "num-period-ctbl" OF "dwf-preco-transf" Adicionado campo "Cod-tp-reg" OF "dwf-preco-transf" AS character Adicionado campo "cod-desc-reg" OF "dwf-preco-transf" AS character Adicionado campo "val-tp-preco" OF "dwf-preco-transf" AS decimal Adicionado campo "cod-empresa" OF "dwf-relac-met" AS character Adicionado campo "cod-tp-reg" OF "dwf-relac-met" AS character Adicionado campo "num-seq-reg-pai" OF "dwf-relac-met" Adicionado campo "desc-tp-reg" OF "dwf-relac-met" AS character Adicionado campo "val-sdo-util" OF "dwf-relac-met" AS decimal Adicionado campo "log-fcp" OF "dwf-apurac-impto-ajust" Adicionado índice "dwf-ben" ON "dwf-benef-fisc" Adicionado índice "dwf-dt" ON "dwf-benef-fisc" Adicionado índice "dwf-cta" ON "dwf-cta-lucro-exp" Adicionado índice "dwf-dt" ON "dwf-cta-lucro-exp" Adicionado índice "dwf-trans" ON "dwf-ctpe-trans-cont" Adicionado índice "dwf-dt" ON "dwf-ctpe-trans-cont" Adicionado índice "dwf-trans" ON "dwf-entid-trans-cont" Adicionado índice "dwf-comp" ON "dwf-info-ajust-comp" Adicionado índice "dwf-info" ON "dwf-info-trans-cont" Adicionado índice "dwf-dt" ON "dwf-info-trans-cont" Adicionado índice "dwf-transf" ON "dwf-preco-transf" Adicionado índice "dwf-dt" ON "dwf-preco-transf" Adicionado índice "dwf-met" ON "dwf-relac-met" -------------------------------------------------------------------------------- Banco: srcadger-psc.df -------------------------------------------------------------------------------- Atualizado campo "des-observacao" OF "histor-obs-guia" Adicionada tabela nova "sib-conferencia" Adicionada tabela nova "sib-conferencia-benef" Adicionado campo "idi-registro" OF "sib-conferencia" Adicionado campo "idi-status" OF "sib-conferencia" Adicionado campo "nm-arquivo" OF "sib-conferencia" AS character Adicionado campo "ds-versao" OF "sib-conferencia" AS character Adicionado campo "tp-transacao" OF "sib-conferencia" AS character Adicionado campo "nr-seq-transacao" OF "sib-conferencia" Adicionado campo "id-registro-ans-origem" OF "sib-conferencia" AS character Adicionado campo "nr-cnpj-origem" OF "sib-conferencia" AS character Adicionado campo "id-registro-ans-destino" OF "sib-conferencia" AS character Adicionado campo "nr-cnpj-destino" OF "sib-conferencia" AS character Adicionado campo "ds-nome-aplicativo" OF "sib-conferencia" AS character Adicionado campo "ds-versao-aplicativo" OF "sib-conferencia" AS character Adicionado campo "ds-fabricante-aplicativo" OF "sib-conferencia" AS character Adicionado campo "dt-transacao" OF "sib-conferencia" AS character Adicionado campo "idi-registro" OF "sib-conferencia-benef" Adicionado campo "idi-registro-conferencia" OF "sib-conferencia-benef" Adicionado campo "nm-arquivo" OF "sib-conferencia-benef" AS character Adicionado campo "cd-cco" OF "sib-conferencia-benef" AS character Adicionado campo "cd-situacao" OF "sib-conferencia-benef" AS character Adicionado campo "dt-atualizacao" OF "sib-conferencia-benef" AS date Adicionado campo "cd-cpf" OF "sib-conferencia-benef" AS character Adicionado campo "cd-dn" OF "sib-conferencia-benef" AS character Adicionado campo "cd-pispasep" OF "sib-conferencia-benef" AS character Adicionado campo "cd-cns" OF "sib-conferencia-benef" AS character Adicionado campo "nm-nome" OF "sib-conferencia-benef" AS character Adicionado campo "dt-nascimento" OF "sib-conferencia-benef" AS date Adicionado campo "nm-nome-mae" OF "sib-conferencia-benef" AS character Adicionado campo "ds-logradouro" OF "sib-conferencia-benef" AS character Adicionado campo "in-numero" OF "sib-conferencia-benef" AS character Adicionado campo "ds-complemento" OF "sib-conferencia-benef" AS character Adicionado campo "ds-bairro" OF "sib-conferencia-benef" AS character Adicionado campo "cd-municipio" OF "sib-conferencia-benef" AS character Adicionado campo "cd-municipio-residencia" OF "sib-conferencia-benef" AS character Adicionado campo "cd-cep" OF "sib-conferencia-benef" AS character Adicionado campo "in-tipo-endereco" OF "sib-conferencia-benef" AS character Adicionado campo "in-reside-exterior" OF "sib-conferencia-benef" Adicionado campo "cd-sexo" OF "sib-conferencia-benef" Adicionado campo "cd-beneficiario" OF "sib-conferencia-benef" AS character Adicionado campo "in-relacao-dependencia" OF "sib-conferencia-benef" Adicionado campo "cd-cco-titular" OF "sib-conferencia-benef" AS character Adicionado campo "dt-contratacao" OF "sib-conferencia-benef" AS date Adicionado campo "dt-reativacao" OF "sib-conferencia-benef" AS date Adicionado campo "dt-cancelamento" OF "sib-conferencia-benef" AS date Adicionado campo "cd-motivo-cancelamento" OF "sib-conferencia-benef" Adicionado campo "cd-plano-ans" OF "sib-conferencia-benef" AS character Adicionado campo "cd-plano-portabilidade" OF "sib-conferencia-benef" AS character Adicionado campo "cd-plano-operadora" OF "sib-conferencia-benef" AS character Adicionado campo "in-cobertura-parcial-temp" OF "sib-conferencia-benef" Adicionado campo "in-itens-excluidos-cobertura" OF "sib-conferencia-benef" Adicionado campo "cd-cnpj-empresa-contr" OF "sib-conferencia-benef" AS character Adicionado campo "cd-cei-empresa-contr" OF "sib-conferencia-benef" AS character Adicionado campo "cd-hash" OF "sib-conferencia-benef" AS character Adicionado campo "cd-sit-transferencia" OF "sib-conferencia-benef" AS character Adicionado índice "sibconf-id" ON "sib-conferencia" Adicionado índice "sibconf-arquivo" ON "sib-conferencia" Adicionado índice "sibconf-status" ON "sib-conferencia" Adicionado índice "sibconfbenef-id" ON "sib-conferencia-benef" Adicionado índice "sibbenefconf-pai-cco" ON "sib-conferencia-benef" Adicionado índice "sibconfbenef-arq" ON "sib-conferencia-benef" Adicionado índice "sibconfbenef-cco" ON "sib-conferencia-benef" Adicionado índice "sibconfbenef-pai" ON "sib-conferencia-benef" -------------------------------------------------------------------------------- Banco: srmovcon-psc.df -------------------------------------------------------------------------------- Atualizado campo "ds-observacao-interna" OF "guiautor" -------------------------------------------------------------------------------- Banco: movfin-psc.df -------------------------------------------------------------------------------- Renomeado índice "lnctcnca_diverg_lancto" TO "temp-0000000001" ON "lancto_concil_cartao_cr" Removido índice "temp-0000000001" ON "lancto_concil_cartao_cr"
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas