Histórico da Página

IMPORTANTE:

• Correção no pacote dia 14/08/2023 - Corrigido o nome da tabela em ORACLE que estava incorreto para o banco movfis.
• Correção no pacote dia 16/08/2023 - Corrigido o tamanho do campo para o banco dthrpyc em Oracle.
• Correção no pacote dia 18/08/2023 - Removido do pacote os rename DUMP-NAME para o banco MGDIS, onde ocasionava erro na atualização do pacote.

BANCO: DTHRGST

Adicionada tabela nova "sped_dep_irf_autonomo"

...

Adicionado campo "cdn_empresa" OF "sped_dep_irf_autonomo" AS character

Adicionado campo "cdn_prestdor_serv" OF "sped_dep_irf_autonomo"

Adicionado campo "cod_id_feder" OF "sped_dep_irf_autonomo" AS character

Adicionado campo "dat_nascimento" OF "sped_dep_irf_autonomo" AS date

Adicionado campo "nom_depend" OF "sped_dep_irf_autonomo" AS character

Adicionado campo "log_ded_dep_irrf" OF "sped_dep_irf_autonomo"

...

Adicionado campo "des_depend" OF "sped_dep_irf_autonomo" AS character 

Adicionado campo "cod_usuar_ult_atualiz" OF "sped_dep_irf_autonomo" AS character

Adicionado campo "dat_ult_atualiz" OF "sped_dep_irf_autonomo" AS date

Adicionado campo "hra_ult_atualiz" OF "sped_dep_irf_autonomo" AS character

Adicionado campo "cod_livre_1" OF "sped_dep_irf_autonomo" AS character

Adicionado campo "cod_livre_2" OF "sped_dep_irf_autonomo" AS character

Adicionado campo "dat_livre_1" OF "sped_dep_irf_autonomo" AS date 

Adicionado campo "dat_livre_2" OF "sped_dep_irf_autonomo" AS date 

Adicionado campo "log_livre_1" OF "sped_dep_irf_autonomo"

...

Adicionado campo "val_livre_1" OF "sped_dep_irf_autonomo" AS decimal 

Adicionado campo "val_livre_2" OF "sped_dep_irf_autonomo" AS decimal

Adicionado campo "cdn_empres_centrdor" OF "sped_relat_irf_func" AS character

Adicionado campo "cdn_estab_centrdor" OF "sped_relat_irf_func" AS character

Adicionado campo "cod_id_feder" OF "sped_relat_irf_func" AS character

Adicionado campo "cod_perf_ref" OF "sped_relat_irf_func" AS character 

Adicionado campo "cod_identif_demonst" OF "sped_relat_irf_func" AS character

Adicionado campo "idi_tip_pagto" OF "sped_relat_irf_func"

Adicionado campo "cod_per_apur_pgto" OF "sped_relat_irf_func" AS character

Adicionado campo "cdn_tip_pagto" OF "sped_relat_irf_func"

Adicionado campo "dat_pagto" OF "sped_relat_irf_func" AS date 

Adicionado campo "cdn_categ_trab_sped" OF "sped_relat_irf_func"

Adicionado campo "val_calc" OF "sped_relat_irf_func" AS decimal

Adicionado campo "val_calc_governo" OF "sped_relat_irf_func" AS decimal

Adicionado campo "cod_usuar_ult_atualiz" OF "sped_relat_irf_func" AS character

Adicionado campo "dat_ult_atualiz" OF "sped_relat_irf_func" AS date

Adicionado campo "hra_ult_atualiz" OF "sped_relat_irf_func" AS character

Adicionado campo "cod_livre_1" OF "sped_relat_irf_func" AS character

Adicionado campo "cod_livre_2" OF "sped_relat_irf_func" AS character

Adicionado campo "dat_livre_1" OF "sped_relat_irf_func" AS date 

Adicionado campo "dat_livre_2" OF "sped_relat_irf_func" AS date 

Adicionado campo "log_livre_1" OF "sped_relat_irf_func"

...

Adicionado campo "val_livre_1" OF "sped_relat_irf_func" AS decimal

Adicionado campo "val_livre_2" OF "sped_relat_irf_func" AS decimal

Adicionado campo "cod_proces_justic" OF "sped_agent_risco" AS character

Adicionado campo "idi_mod_contrat_aprend" OF "sped_participan"

Adicionado campo "cod_id_feder_ent_qualific" OF "sped_participan" AS character

Adicionado índice "spddirrfa" ON "sped_dep_irf_autonomo"

Adicionado índice "spdrltirff_ix2" ON "sped_relat_irf_func"

BANCO: DTHRPYC

Adicionado campo "val_deduc_inss_mtpl_vinc" OF "aux_calc_irf" AS decimal

Adicionado campo "val_deduc_inss_mtpl_vinc_ant" OF "aux_calc_irf" AS decimal

Adicionado campo "val_base_1" OF "aux_calc_irf" AS decimal

Adicionado campo "val_deduc_1" OF "aux_calc_irf" AS decimal

Adicionado campo "val_base_1_ant" OF "aux_calc_irf" AS decimal

Adicionado campo "val_deduc_1_ant" OF "aux_calc_irf" AS decimal

Adicionado campo "val_deduc_inss_mtpl_vinc" OF "aux_calc_rescis" AS decimal

Adicionado campo "val_deduc_inss_mtpl_vinc_ant" OF "aux_calc_rescis" AS decimal

Adicionado campo "val_base_1" OF "aux_calc_rescis" AS decimal

Adicionado campo "val_deduc_1" OF "aux_calc_rescis" AS decimal

Adicionado campo "val_base_1_ant" OF "aux_calc_rescis" AS decimal

Adicionado campo "val_deduc_1_ant" OF "aux_calc_rescis" AS decimal

Adicionado campo "des_depend" OF "depend_func" AS character

Adicionado campo "idi_deduc_utiliz_ir_normal" OF "det_rescis"

...

Adicionado campo "val_deduc_inss_mtpl_vinc" OF "inform_dirf" AS decimal

Adicionado campo "val_base_1" OF "inform_dirf" AS decimal

Adicionado campo "val_deduc_1" OF "inform_dirf" AS decimal

Adicionado campo "idi_deduc_utiliz_ir_normal" OF "movto_calcul_func"

...

Adicionado campo "val_deduc_inss_mtpl_vinc_ant" OF "movto_ferias_calcul" AS decimal

Adicionado campo "val_base_1" OF "movto_ferias_calcul" AS decimal

Adicionado campo "val_deduc_1" OF "movto_ferias_calcul" AS decimal

Adicionado campo "val_deduc_inss_mtpl_vinc" OF "movto_ferias_calcul" AS decimal

Adicionado campo "val_base_1_ant" OF "movto_ferias_calcul" AS decimal

Adicionado campo "val_deduc_1_ant" OF "movto_ferias_calcul" AS decimal

Adicionado campo "idi_deduc_utiliz_ir_ferias" OF "reg_det_ferias"

BANCO: EMSFIN

Adicionado campo "cod_tip_trans_cx_impto_iof" OF "param_integr_mais_negoc" AS character

BANCO: MGDIS

Atualizado campo "peso-liquido" OF "ws-docto-itens"

...

Adicionado campo "val-exc-icms-bc-pis-cofins" OF "ri-bem" AS decimal

Adicionado campo "volume" OF "ws-docto-itens" AS decimal

Adicionado campo "idi-sit-docto" OF "ws-docto-itens"

BANCO: MGMNT

Adicionada tabela nova "checklist-etapas"

...

Adicionado campo "descricao" OF "checklist-etapas" AS character

Adicionado campo "data-criacao" OF "checklist-etapas" AS datetime-tz 

Adicionado campo "sequencial" OF "checklist-etapas"

Adicionado campo "char-1" OF "checklist-etapas" AS character

Adicionado campo "char-2" OF "checklist-etapas" AS character

Adicionado campo "dec-1" OF "checklist-etapas" AS decimal 

Adicionado campo "dec-2" OF "checklist-etapas" AS decimal 

Adicionado campo "int-1" OF "checklist-etapas"

...

Adicionado campo "data-1" OF "checklist-etapas" AS date

Adicionado campo "data-2" OF "checklist-etapas" AS date

Adicionado campo "id" OF "checklist-eventos"

...

Adicionado campo "descricao" OF "checklist-eventos" AS character

Adicionado campo "char-1" OF "checklist-eventos" AS character 

Adicionado campo "char-2" OF "checklist-eventos" AS character 

Adicionado campo "dec-1" OF "checklist-eventos" AS decimal 

Adicionado campo "dec-2" OF "checklist-eventos" AS decimal 

Adicionado campo "int-1" OF "checklist-eventos"

...

Adicionado campo "data-1" OF "checklist-eventos" AS date

Adicionado campo "data-2" OF "checklist-eventos" AS date

Adicionado campo "id" OF "checklist-integracao"

...

Adicionado campo "chave-primaria" OF "checklist-integracao" AS character

Adicionado campo "chave-sec" OF "checklist-integracao" AS character 

Adicionado campo "origem" OF "checklist-integracao" AS character 

Adicionado campo "chave-terc" OF "checklist-integracao" AS character

Adicionado campo "char-1" OF "checklist-integracao" AS character 

Adicionado campo "char-2" OF "checklist-integracao" AS character 

Adicionado campo "dec-1" OF "checklist-integracao" AS decimal 

Adicionado campo "dec-2" OF "checklist-integracao" AS decimal 

Adicionado campo "int-1" OF "checklist-integracao"

...

Adicionado campo "data-1" OF "checklist-integracao" AS date

Adicionado campo "data-2" OF "checklist-integracao" AS date

Adicionado campo "id" OF "checklist-modelos"

Adicionado campo "descricao" OF "checklist-modelos" AS character

Adicionado campo "data-criacao" OF "checklist-modelos" AS datetime-tz

Adicionado campo "cod-usuar" OF "checklist-modelos" AS character 

Adicionado campo "char-1" OF "checklist-modelos" AS character 

Adicionado campo "char-2" OF "checklist-modelos" AS character 

Adicionado campo "dec-1" OF "checklist-modelos" AS decimal 

Adicionado campo "dec-2" OF "checklist-modelos" AS decimal 

Adicionado campo "int-1" OF "checklist-modelos"

...

Adicionado campo "data-1" OF "checklist-modelos" AS date

Adicionado campo "data-2" OF "checklist-modelos" AS date

Adicionado campo "status-modelo" OF "checklist-modelos"

...

Adicionado campo "descricao" OF "checklist-perguntas" AS character

Adicionado campo "data-criacao" OF "checklist-perguntas" AS datetime-tz

Adicionado campo "tipo-campo" OF "checklist-perguntas"

...

Adicionado campo "char-1" OF "checklist-perguntas" AS character

Adicionado campo "char-2" OF "checklist-perguntas" AS character

Adicionado campo "dec-1" OF "checklist-perguntas" AS decimal 

Adicionado campo "dec-2" OF "checklist-perguntas" AS decimal 

Adicionado campo "int-1" OF "checklist-perguntas"

...

Adicionado campo "data-1" OF "checklist-perguntas" AS date

Adicionado campo "data-2" OF "checklist-perguntas" AS date

Adicionado campo "opcao" OF "checklist-perguntas" AS character

Adicionado campo "id" OF "checklist-respostas"

...

Adicionado campo "resposta" OF "checklist-respostas" AS character

Adicionado campo "data-criacao" OF "checklist-respostas" AS datetime-tz 

Adicionado campo "tipo-campo" OF "checklist-respostas"

...

Adicionado campo "observacao" OF "checklist-respostas" AS character 

Adicionado campo "evidencia" OF "checklist-respostas" AS blob 

Adicionado campo "status-resposta" OF "checklist-respostas"

Adicionado campo "char-1" OF "checklist-respostas" AS character

Adicionado campo "char-2" OF "checklist-respostas" AS character

Adicionado campo "dec-1" OF "checklist-respostas" AS decimal 

Adicionado campo "dec-2" OF "checklist-respostas" AS decimal 

Adicionado campo "int-1" OF "checklist-respostas"

...

Adicionado campo "data-1" OF "checklist-respostas" AS date

Adicionado campo "data-2" OF "checklist-respostas" AS date

Adicionado campo "opcao" OF "checklist-respostas" AS character

Adicionado campo "valor-pontuacao" OF "checklist-respostas" AS character

Adicionado índice "index-id" ON "checklist-etapas"

...

Adicionado índice "index-id" ON "checklist-respostas"

BANCO: MGUNI

Adicionado campo "cod-valor-padrao" OF "passo-tipo-param" AS character

BANCO: MOVFIS

Atualizado campo "idi-isen-imun" OF "dwf-reinf-pagto-benef-pj"

...