Árvore de páginas

Versões comparadas

Chave

  • Esta linha foi adicionada.
  • Esta linha foi removida.
  • A formatação mudou.

...

02. Definição da Regra de Negócio

Cadastros

Diretrizes

Cadastro das Diretrizes a serem seguidas nos Programas Governamentais.

 

Programas


Indicadores


Sub-Função


Função


Ação


Processos


Função - Sub-Função


Ação - Função



03. Documentação Técnica para Criação do relatório e configuração com Exemplo de Utilização

Relatório PPA - Descrição dos Programas Governamentais - Metas e Custos


Modelo 




Relatório contendo X colunas (tReport)


Parâmetros do Relatório (Pergunte)

Exercício (Ano): AAAA

Conta Orçamentaria de: branco

Conta Orçamentaria ate:zzzzzzzzzzzzzzzzz

Config.Dot.Inicial: XXXX

Config.Dot.Atualizada: XXXX

Config.Desp.Empenhadas: XXXX

Config.Desp.Liquidadas: XXXX

Config.Desp.Pagas: XXXX

Config.Total Despesasl: XXXX

Divide por: [Não se Aplica | Centena | Milhar | Milhões ]



04. Configuração dos Processos de Lançamentos e Bloqueios

Configuração dos Processos de Lançamento

Planilha orçamentaria – (Dotação Inicial e Atualizada)

...

AKC_FILIAL

...

D MG 01

...

AKC_PROCES

...

000252

...

AKC_ATIVO

...

LBOK

...

AKC_SEQ

...

01

...

AKC_CO

...

AK2->AK2_CO                                                                                                                                                                                                                                              

...

AKC_DATA

...

AK2->AK2_PERIOD                                                                                                                                                                                                                                          

...

AKC_CLASSE

...

AK2->AK2_CLASSE                                                                                                                                                                                                                                          

...

AKC_TIPO

...

01

...

AKC_HIST

...

LANC. ORCAMENTO - DOTACAO INICIAL 2020                                                                                                                                                                                                                  

...

AKC_UM

...

                                                           

...

AKC_VALOR1

...

IF(Left(AK2→AK2_CO,1) $ '8' .AND. AK2->AK2_VERSAO='0001', AK2->AK2_VALOR,0)                                                                                                                                                                                                              

...

AKC_KEYREF

...

                                                           

...

AKC_OPER

...

                                                                                                                                                                                                                                                         

...

AKC_ITEM

...

01

...

AKC_TPSALD

...

OH                                                       

...

AKC_FILIAL

...

D MG 01

...

AKC_PROCES

...

000252

...

AKC_ATIVO

...

LBOK

...

AKC_SEQ

...

02

...

AKC_CO

...

AK2->AK2_CO                                                                                                                                                                                                                                              

...

AKC_DATA

...

AK2->AK2_PERIOD                                                                                                                                                                                                                                          

...

AKC_CLASSE

...

AK2->AK2_CLASSE                                                                                                                                                                                                                                           

...

AKC_TIPO

...

01

...

AKC_HIST

...

LANC. ORCAMENTO - DOTACAO ATUALIZADA 2020                                                                                                                                                                                                              

...

AKC_UM

...

                                                           

...

AKC_VALOR1

...

IF(Left(AK2→AK2_CO,1) $ '8' .AND. AK2->AK2_VERSAO<>'0001', AK2->AK2_VALOR,0)                                                                                                                                                                                              

...

AKC_KEYREF

...

                                                           

...

AKC_OPER

...

                                                                                                                                                                                                                                                          

...

AKC_ITEM

...

01

...

AKC_TPSALD

...

O1                                                       

Solicitação de Compras – (Despesas – Reserva)

 (produto com custo padrão)

Image Removed

Lançamento em movimentos orçamentários

Image Removed

...

AKC_FILIAL

...

D MG 01

...

AKC_PROCES

...

000051

...

AKC_ATIVO

...

LBOK

...

AKC_SEQ

...

01

...

AKC_CO

...

8111003

...

AKC_DATA

...

SC1->C1_EMISSAO                                                                                                                                                                                                                                          

...

AKC_CLASSE

...

000001                                                                                                                                                                                                                                                

...

AKC_TIPO

...

1

...

AKC_HIST

...

SOLICITACAO DE COMPRAS - (DESPESAS - RESERVAS)                                                                                                                                                                                                          

...

AKC_UM

...

                                                           

...

AKC_VALOR1

...

MCUSTPROD:=Posicione("SB1", 1, xFilial("SB1") +SC1->C1_PRODUTO, "B1_CUSTD"), SC1->C1_QUANT*MCUSTPROD                                                                                                                                                      

...

AKC_KEYREF

...

                                                           

...

AKC_OPER

...

                                                                                                                                                                                                                                                          

...

AKC_ITEM

...

01

...

AKC_TPSALD

...

DR                                                       

Pedido de Compras – (Despesas Empenhadas)

Image Removed

Image Removed

...

AKC_FILIAL

...

D MG 01

...

AKC_PROCES

...

000052

...

AKC_ATIVO

...

LBOK

...

AKC_SEQ

...

01

...

AKC_CO

...

8111003

...

AKC_DATA

...

SC7->C7_EMISSAO                                                                                                                                                                                                                                          

...

AKC_CLASSE

...

000001

...

AKC_TIPO

...

1

...

AKC_HIST

...

PEDIDO DE COMPRAS - (DESPESAS EMPENHADAS)                                                                                                                                                                                                               

...

AKC_UM

...

                                                           

...

AKC_VALOR1

...

SC7->C7_TOTAL                                                                                                                                                                                                                                             

...

AKC_KEYREF

...

                                                           

...

AKC_OPER

...

                                                                                                                                                                                                                                                         

...

AKC_ITEM

...

01

...

AKC_TPSALD

...

DE                                                       

...

Debito

...

AKC_FILIAL

...

D MG 01

...

AKC_PROCES

...

000052

...

AKC_ATIVO

...

LBOK

...

AKC_SEQ

...

02

...

AKC_CO

...

8111003

...

AKC_DATA

...

SC7->C7_EMISSAO                                                                                                                                                                                                                                          

...

AKC_CLASSE

...

000001

...

AKC_TIPO

...

2

...

AKC_HIST

...

PEDIDO DE COMPRAS - (DESPESAS - RESERVAS)                                                                                                                                                                                                               

...

AKC_UM

...

                                                            

...

AKC_VALOR1

...

SC7->C7_TOTAL                                                                                                                                                                                                                                             

...

AKC_KEYREF

...

                                                           

...

AKC_OPER

...

                                                                                                                                                                                                                                                         

...

AKC_ITEM

...

01

...

AKC_TPSALD

...

DR                                                       

Documento nota fiscal de entrada – (Despesas Liquidadas)

Image Removed

-

Image Removed

...

AKC_FILIAL

...

D MG 01

...

AKC_PROCES

...

000054

...

AKC_ATIVO

...

LBOK

...

AKC_SEQ

...

01

...

AKC_CO

...

8111003

...

AKC_DATA

...

SF1->F1_EMISSAO                                                                                                                                                                                                                                          

...

AKC_CLASSE

...

000001

...

AKC_TIPO

...

1

...

AKC_HIST

...

DOC NF ENTRADA - (DESPESAS LIQUIDADAS)                                                                                                                                                                                                                  

...

AKC_UM

...

                                                           

...

AKC_VALOR1

...

SD1->D1_TOTAL                                                                                                                                                                                                                                             

...

AKC_KEYREF

...

                                                           

...

AKC_OPER

...

                                                                                                                                                                                                                                                         

...

AKC_ITEM

...

01

...

AKC_TPSALD

...

DL                                                       

...

AKC_FILIAL

...

D MG 01

...

AKC_PROCES

...

000054

...

AKC_ATIVO

...

LBOK

...

AKC_SEQ

...

02

...

AKC_CO

...

8111003

...

AKC_DATA

...

SF1->F1_EMISSAO                                                                                                                                                                                                                                          

...

AKC_CLASSE

...

000001

...

AKC_TIPO

...

2

...

AKC_HIST

...

DOC NF ENTRADA - (DESPESAS EMPENHADAS)                                                                                                                                                                                                                  

...

AKC_UM

...

                                                           

...

AKC_VALOR1

...

SD1->D1_TOTAL                                                                                                                                                                                                                                             

...

AKC_KEYREF

...

                                                           

...

AKC_OPER

...

                                                                                                                                                                                                                                                         

...

AKC_ITEM

...

01

...

AKC_TPSALD

...

DE                                                       

Ao entrar no sistema com a nota fiscal de entrada é gerado um título no contas a pagar.

Image Removed

Baixas a pagar – (Despesas Pagas)

Image Removed

Image Removed

...

AKC_PROCES

...

000005

...

AKC_ATIVO

...

LBOK

...

AKC_SEQ

...

02

...

AKC_CO

...

8111003

...

AKC_DATA

...

SE5->E5_DATA                                                                                                                                                                                                                                              

...

AKC_CLASSE

...

000001

...

AKC_TIPO

...

2

...

AKC_HIST

...

BAIXA DO TITULO A PAGAR - (DESPESAS LIQUIDADAS)                                                                                                                                                                                                         

...

AKC_UM

...

                                                           

...

AKC_VALOR1

...

SE5->E5_VALOR                                                                                                                                                                                                                                             

...

AKC_KEYREF

...

                                                            

...

AKC_OPER

...

                                                                                                                                                                                                                                                          

...

AKC_ITEM

...

01

...

AKC_TPSALD

...

DL                                                       

Bloqueios

Solicitação de Compras

Image Removed

...




...

AKI_FILIAL

...

D MG 01

...

AKI_PROCES

...

000051

...

AKI_ATIVO

...

LBOK

...

AKI_ITEM

...

01

...

AKI_SEQ

...

01

...

AKI_CO

...

8111003

...

AKI_DATA

...

DDATABASE                                                                                                                                                                                                                                                

...

AKI_CLASSE

...

000001

...

AKI_TIPO

...

1

...

AKI_HIST

...

BLOQUEIO SOLIC COMPRAS - (DESPESAS RESERVA)                                                                                                                                                                                                             

...

AKI_UM

...

                                                            

...

AKI_KEYREF

...

                                                           

...

AKI_OPER

...

                                                                                                                                                                                                                                                          

...

AKI_TPSALD

...

DR                                                       

...

AKI_VALOR1

...

MCUSTPROD:=Posicione("SB1", 1, xFilial("SB1") +GDFIELDGET("C1_PRODUTO"), "B1_CUSTD"), GDFIELDGET("C1_QUANT")*MCUSTPROD                                                                                                                                   

Pedido de Compras

Image Removed

...

AKI_FILIAL

...

D MG 01

...

AKI_PROCES

...

000052

...

AKI_ATIVO

...

LBOK

...

AKI_ITEM

...

01

...

AKI_SEQ

...

01

...

AKI_CO

...

8111003

...

AKI_DATA

...

DDATABASE                                                                                                                                                                                                                                                

...

AKI_CLASSE

...

000001

...

AKI_TIPO

...

1

...

AKI_HIST

...

BLOQUEIO PED COMPRAS - (DESPESAS EMPENHADAS)                                                                                                                                                                                                            

...

AKI_UM

...

                                                           

...

AKI_KEYREF

...

                                                           

...

AKI_OPER

...

                                                                                                                                                                                                                                                         

...

AKI_TPSALD

...

DE                                                       

...

AKI_VALOR1

...

GDFIELDGET("C7_TOTAL")                                                                                                                                                                                                                                    

...

AKI_FILIAL

...

D MG 01

...

AKI_PROCES

...

000052

...

AKI_ATIVO

...

LBOK

...

AKI_ITEM

...

01

...

AKI_SEQ

...

02

...

AKI_CO

...

8111003

...

AKI_DATA

...

DDATABASE                                                                                                                                                                                                                                                

...

AKI_CLASSE

...

000001

...

AKI_TIPO

...

2

...

AKI_HIST

...

BLOQUEIO PED COMPRAS - (DESPESAS RESERVAS)                                                                                                                                                                                                            

...

AKI_UM

...

                                                           

...

AKI_KEYREF

...

                                                           

...

AKI_OPER

...

                                                                                                                                                                                                                                                          

...

AKI_TPSALD

...

DR

...

AKI_VALOR1

...

GDFIELDGET("C7_TOTAL")                                                                                                                                                                                                                                   

Documento Nota Fiscal de Entrada

Image Removed

...

AKI_FILIAL

...

D MG 01

...

AKI_PROCES

...

000054

...

AKI_ATIVO

...

LBOK

...

AKI_ITEM

...

01

...

AKI_SEQ

...

01

...

AKI_CO

...

8111003

...

AKI_DATA

...

DDATABASE                                                                                                                                                                                                                                                 

...

AKI_CLASSE

...

000001

...

AKI_TIPO

...

1

...

AKI_HIST

...

BLOQ DOC NF ENTRADA - (DESPESAS LIQUIDADAS)                                                                                                                                                                                                             

...

AKI_UM

...

                                                           

...

AKI_KEYREF

...

                                                            

...

AKI_OPER

...

                                                                                                                                                                                                                                                          

...

AKI_TPSALD

...

DL                                                       

...

AKI_VALOR1

...

GDFIELDGET("D1_TOTAL")                                                                                                                                                                                                                                    

...

AKI_FILIAL

...

D MG 01

...

AKI_PROCES

...

000054

...

AKI_ATIVO

...

LBOK

...

AKI_ITEM

...

01

...

AKI_SEQ

...

02

...

AKI_CO

...

8111003

...

AKI_DATA

...

DDATABASE                                                                                                                                                                                                                                                 

...

AKI_CLASSE

...

000001

...

AKI_TIPO

...

2

...

AKI_HIST

...

BLOQ DOC NF ENTRADA - (DESPESAS EMPENHADAS)                                                                                                                                                                                                             

...

AKI_UM

...

                                                           

...

AKI_KEYREF

...

                                                           

...

AKI_OPER

...

                                                                                                                                                                                                                                                          

...

AKI_TPSALD

...

DE

...

AKI_VALOR1

...

GDFIELDGET("D1_TOTAL")                                                                                                                                                                                                                                    

Baixas a pagar

Image Removed

...

AKI_FILIAL

...

D MG 01

...

AKI_PROCES

...

000005

...

AKI_ATIVO

...

LBOK

...

AKI_ITEM

...

01

...

AKI_SEQ

...

01

...

AKI_CO

...

8111003

...

AKI_DATA

...

DDATABASE                                                                                                                                                                                                                                                 

...

AKI_CLASSE

...

000001

...

AKI_TIPO

...

1

...

AKI_HIST

...

BLOQ BAIXAS A PAGAR - (DESPESAS PAGAS)                                                                                                                                                                                                                  

...

AKI_UM

...

                                                           

...

AKI_KEYREF

...

                                                           

...

AKI_OPER

...

                                                                                                                                                                                                                                                          

...

AKI_TPSALD

...

DP                                                       

...

AKI_VALOR1

...

NVALPGTO

...

AKI_FILIAL

...

D MG 01

...

AKI_PROCES

...

000005

...

AKI_ATIVO

...

LBOK

...

AKI_ITEM

...

01

...

AKI_SEQ

...

02

...

AKI_CO

...

8111003

...

AKI_DATA

...

DDATABASE                                                                                                                                                                                                                                                 

...

AKI_CLASSE

...

000001

...

AKI_TIPO

...

2

...

AKI_HIST

...

BLOQ BAIXAS A PAGAR - (DESPESAS LIQUIDADAS)                                                                                                                                                                                                                  

...

AKI_UM

...

                                                           

...

AKI_KEYREF

...

                                                           

...

AKI_OPER

...

                                                                                                                                                                                                                                                          

...

AKI_TPSALD

...

DL

...

AKI_VALOR1

...

NVALPGTO

Observação Operacionalmente temos que equiparar ao lançamento, isto é, colocar o debito para anular a Reserva no caso do pedido de compra por exemplo, isto é, o bloqueio tem que ser um espelho do lançamento.

Bloco de código
themeDJango
titleBase Dados para Exemplo
collapsetrue
---------------------------------------------------------------------------------------------------------
SELECT * FROM AK1T10 WHERE AK1_FILIAL = |D MG 01 | AND AK1_CODIGO = |DOTINIC2020   | AND D_E_L_E_T_ = | |

(1 linha afetada)

AK1_FILIAL AK1_CODIGO      AK1_VERSAO AK1_VERREV AK1_DESCRI                                                                       AK1_NMAX               AK1_TPPERI AK1_INIPER AK1_FIMPER AK1_TPREV AK1_STATUS AK1_MEMO                                                                                                                                                                                                                                                         AK1_CTRUSR AK1_FASE AK1_JUSTM                                                                                                                                                                                                                                                        AK1_CODJM D_E_L_E_T_ R_E_C_N_O_           R_E_C_D_E_L_
---------- --------------- ---------- ---------- -------------------------------------------------------------------------------- ---------------------- ---------- ---------- ---------- --------- ---------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------- -------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------- ---------- -------------------- --------------------
D MG 01    DOTINIC2020     0001                  DOTACAO ORCAMENTARIA INICIAL 2020                                                1                      3          20200101   20201231   1         1          NULL                                                                                                                                                                                                                                                             1          001      NULL                                                                                                                                                                                                                                                                                  24                   0

(1 linha afetada)


---------------------------------------------------------------------------------------------------------
SELECT * FROM AK3T10 WHERE AK3_FILIAL = |D MG 01 | AND AK3_ORCAME = |DOTINIC2020   | AND D_E_L_E_T_ = | |

(1 linha afetada)

AK3_FILIAL AK3_ORCAME      AK3_VERSAO AK3_CO       AK3_PAI      AK3_TIPO AK3_NIVEL AK3_DESCRI                                                   AK3_MEMO                                                                                                                                                                                                                                                         AK3_SEQ AK3_LOGLCK           D_E_L_E_T_ R_E_C_N_O_           R_E_C_D_E_L_
---------- --------------- ---------- ------------ ------------ -------- --------- ------------------------------------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------- -------------------- ---------- -------------------- --------------------
D MG 01    DOTINIC2020     0001       DOTINIC2020                        001       DOTACAO ORCAMENTARIA INICIAL 2020                            NULL                                                                                                                                                                                                                                                                                                     61                   0
D MG 01    DOTINIC2020     0001       8            DOTINIC2020  1        002       CONTABILDADE PUBLICA                                         NULL                                                                                                                                                                                                                                                                                                     62                   0
D MG 01    DOTINIC2020     0001       81           8            1        003       CONTABILIDADE PUBLICA NIVEL I                                NULL                                                                                                                                                                                                                                                                                                     63                   0
D MG 01    DOTINIC2020     0001       811          81           1        004       CONTABILIDADE PUBLICA NIVEL II                               NULL                                                                                                                                                                                                                                                                                                     64                   0
D MG 01    DOTINIC2020     0001       8111         811          1        005       CONTABILIDADE PUBLICA NIVEL III                              NULL                                                                                                                                                                                                                                                                                                     65                   0
D MG 01    DOTINIC2020     0001       8111001      8111         2        006       CONTAB.PUBLICA - DESP. ANALITICAS 8111001                    NULL                                                                                                                                                                                                                                                                                                     66                   0
D MG 01    DOTINIC2020     0001       8111002      8111         2        006       CONTAB.PUBLICA - DESP. ANALITICAS 8111002                    NULL                                                                                                                                                                                                                                                                                                     67                   0
D MG 01    DOTINIC2020     0001       8111003      8111         2        006       CONTAB.PUBLICA - DESP. ANALITICAS 8111003                    NULL                                                                                                                                                                                                                                                                                                     68                   0
D MG 01    DOTINIC2020     0001       8111004      8111         2        006       CONTAB.PUBLICA - DESP. ANALITICAS 8111004                    NULL                                                                                                                                                                                                                                                                                                     69                   0
D MG 01    DOTINIC2020     0001       8111005      8111         2        006       CONTAB.PUBLICA - DESP. ANALITICAS 8111005                    NULL                                                                                                                                                                                                                                                                                                     70                   0
D MG 01    DOTINIC2020     0001       8111006      8111         1        006       CONTAB.PUBLICA - DESP. ANALITICAS 8111006                    NULL                                                                                                                                                                                                                                                                                                     71                   0
D MG 01    DOTINIC2020     0001       8111007      8111         2        006       CONTAB.PUBLICA - DESP. ANALITICAS 8111007                    NULL                                                                                                                                                                                                                                                                                                     72                   0
D MG 01    DOTINIC2020     0001       8111008      8111         2        006       CONTAB.PUBLICA - DESP. ANALITICAS 8111008                    NULL                                                                                                                                                                                                                                                                                                     73                   0

(13 linhas afetadas)


---------------------------------------------------------------------------------------------------------
SELECT * FROM AK2T10 WHERE AK2_FILIAL = |D MG 01 | AND AK2_ORCAME = |DOTINIC2020   | AND D_E_L_E_T_ = | |

(1 linha afetada)

AK2_FILIAL AK2_ID AK2_ORCAME      AK2_VERSAO AK2_CO       AK2_PERIOD AK2_CC    AK2_ITCTB AK2_CLVLR AK2_CLASSE AK2_VALOR              AK2_DESCRI                                                   AK2_OPER   AK2_CHAVE                                                                                            AK2_MOEDA              AK2_DATAF AK2_DATAI AK2_FORMUL                                                                                                                                             AK2_FORM                                                                                                                                                                                                 AK2_UNIORC   AK2_ENT05 AK2_ENT06 AK2_ENT07 AK2_ENT08 AK2_ENT09 D_E_L_E_T_ R_E_C_N_O_           R_E_C_D_E_L_
---------- ------ --------------- ---------- ------------ ---------- --------- --------- --------- ---------- ---------------------- ------------------------------------------------------------ ---------- ---------------------------------------------------------------------------------------------------- ---------------------- --------- --------- ------------------------------------------------------------------------------------------------------------------------------------------------------ -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------ --------- --------- --------- --------- --------- ---------- -------------------- --------------------
D MG 01    0001   DOTINIC2020     0001       8111001      20200101                                 000001     100000                                                                                                                                                                                              1                      20200131  20200101                                                                                                                                                                                                                                                                                                                                                                                                                                            123                  0
D MG 01    0001   DOTINIC2020     0001       8111001      20200201                                 000001     100000                                                                                                                                                                                              1                      20200229  20200201                                                                                                                                                                                                                                                                                                                                                                                                                                            124                  0
D MG 01    0001   DOTINIC2020     0001       8111001      20200301                                 000001     100000                                                                                                                                                                                              1                      20200331  20200301                                                                                                                                                                                                                                                                                                                                                                                                                                            125                  0
D MG 01    0001   DOTINIC2020     0001       8111001      20200401                                 000001     100000                                                                                                                                                                                              1                      20200430  20200401                                                                                                                                                                                                                                                                                                                                                                                                                                            126                  0
D MG 01    0001   DOTINIC2020     0001       8111001      20200501                                 000001     100000                                                                                                                                                                                              1                      20200531  20200501                                                                                                                                                                                                                                                                                                                                                                                                                                            127                  0
D MG 01    0001   DOTINIC2020     0001       8111001      20200601                                 000001     100000                                                                                                                                                                                              1                      20200630  20200601                                                                                                                                                                                                                                                                                                                                                                                                                                            128                  0
D MG 01    0001   DOTINIC2020     0001       8111001      20200701                                 000001     100000                                                                                                                                                                                              1                      20200731  20200701                                                                                                                                                                                                                                                                                                                                                                                                                                            129                  0
D MG 01    0001   DOTINIC2020     0001       8111001      20200801                                 000001     100000                                                                                                                                                                                              1                      20200831  20200801                                                                                                                                                                                                                                                                                                                                                                                                                                            130                  0
D MG 01    0001   DOTINIC2020     0001       8111001      20200901                                 000001     100000                                                                                                                                                                                              1                      20200930  20200901                                                                                                                                                                                                                                                                                                                                                                                                                                            131                  0
D MG 01    0001   DOTINIC2020     0001       8111001      20201001                                 000001     100000                                                                                                                                                                                              1                      20201031  20201001                                                                                                                                                                                                                                                                                                                                                                                                                                            132                  0
D MG 01    0001   DOTINIC2020     0001       8111001      20201101                                 000001     100000                                                                                                                                                                                              1                      20201130  20201101                                                                                                                                                                                                                                                                                                                                                                                                                                            133                  0
D MG 01    0001   DOTINIC2020     0001       8111001      20201201                                 000001     100000                                                                                                                                                                                              1                      20201231  20201201                                                                                                                                                                                                                                                                                                                                                                                                                                            134                  0
D MG 01    0001   DOTINIC2020     0001       8111002      20200101                                 000001     80000                                                                                                                                                                                               1                      20200131  20200101                                                                                                                                                                                                                                                                                                                                                                                                                                            135                  0
D MG 01    0001   DOTINIC2020     0001       8111002      20200201                                 000001     80000                                                                                                                                                                                               1                      20200229  20200201                                                                                                                                                                                                                                                                                                                                                                                                                                            136                  0
D MG 01    0001   DOTINIC2020     0001       8111002      20200301                                 000001     80000                                                                                                                                                                                               1                      20200331  20200301                                                                                                                                                                                                                                                                                                                                                                                                                                            137                  0
D MG 01    0001   DOTINIC2020     0001       8111002      20200401                                 000001     80000                                                                                                                                                                                               1                      20200430  20200401                                                                                                                                                                                                                                                                                                                                                                                                                                            138                  0
D MG 01    0001   DOTINIC2020     0001       8111002      20200501                                 000001     80000                                                                                                                                                                                               1                      20200531  20200501                                                                                                                                                                                                                                                                                                                                                                                                                                            139                  0
D MG 01    0001   DOTINIC2020     0001       8111002      20200601                                 000001     80000                                                                                                                                                                                               1                      20200630  20200601                                                                                                                                                                                                                                                                                                                                                                                                                                            140                  0
D MG 01    0001   DOTINIC2020     0001       8111002      20200701                                 000001     80000                                                                                                                                                                                               1                      20200731  20200701                                                                                                                                                                                                                                                                                                                                                                                                                                            141                  0
D MG 01    0001   DOTINIC2020     0001       8111002      20200801                                 000001     80000                                                                                                                                                                                               1                      20200831  20200801                                                                                                                                                                                                                                                                                                                                                                                                                                            142                  0
D MG 01    0001   DOTINIC2020     0001       8111002      20200901                                 000001     80000                                                                                                                                                                                               1                      20200930  20200901                                                                                                                                                                                                                                                                                                                                                                                                                                            143                  0
D MG 01    0001   DOTINIC2020     0001       8111002      20201001                                 000001     80000                                                                                                                                                                                               1                      20201031  20201001                                                                                                                                                                                                                                                                                                                                                                                                                                            144                  0
D MG 01    0001   DOTINIC2020     0001       8111002      20201101                                 000001     80000                                                                                                                                                                                               1                      20201130  20201101                                                                                                                                                                                                                                                                                                                                                                                                                                            145                  0
D MG 01    0001   DOTINIC2020     0001       8111002      20201201                                 000001     80000                                                                                                                                                                                               1                      20201231  20201201                                                                                                                                                                                                                                                                                                                                                                                                                                            146                  0
D MG 01    0001   DOTINIC2020     0001       8111003      20200101                                 000001     300000                                                                                                                                                                                              1                      20200131  20200101                                                                                                                                                                                                                                                                                                                                                                                                                                            147                  0
D MG 01    0001   DOTINIC2020     0001       8111003      20200201                                 000001     300000                                                                                                                                                                                              1                      20200229  20200201                                                                                                                                                                                                                                                                                                                                                                                                                                            148                  0
D MG 01    0001   DOTINIC2020     0001       8111003      20200301                                 000001     300000                                                                                                                                                                                              1                      20200331  20200301                                                                                                                                                                                                                                                                                                                                                                                                                                            149                  0
D MG 01    0001   DOTINIC2020     0001       8111003      20200401                                 000001     300000                                                                                                                                                                                              1                      20200430  20200401                                                                                                                                                                                                                                                                                                                                                                                                                                            150                  0
D MG 01    0001   DOTINIC2020     0001       8111003      20200501                                 000001     300000                                                                                                                                                                                              1                      20200531  20200501                                                                                                                                                                                                                                                                                                                                                                                                                                            151                  0
D MG 01    0001   DOTINIC2020     0001       8111003      20200601                                 000001     300000                                                                                                                                                                                              1                      20200630  20200601                                                                                                                                                                                                                                                                                                                                                                                                                                            152                  0
D MG 01    0001   DOTINIC2020     0001       8111003      20200701                                 000001     300000                                                                                                                                                                                              1                      20200731  20200701                                                                                                                                                                                                                                                                                                                                                                                                                                            153                  0
D MG 01    0001   DOTINIC2020     0001       8111003      20200801                                 000001     300000                                                                                                                                                                                              1                      20200831  20200801                                                                                                                                                                                                                                                                                                                                                                                                                                            154                  0
D MG 01    0001   DOTINIC2020     0001       8111003      20200901                                 000001     300000                                                                                                                                                                                              1                      20200930  20200901                                                                                                                                                                                                                                                                                                                                                                                                                                            155                  0
D MG 01    0001   DOTINIC2020     0001       8111003      20201001                                 000001     300000                                                                                                                                                                                              1                      20201031  20201001                                                                                                                                                                                                                                                                                                                                                                                                                                            156                  0
D MG 01    0001   DOTINIC2020     0001       8111003      20201101                                 000001     300000                                                                                                                                                                                              1                      20201130  20201101                                                                                                                                                                                                                                                                                                                                                                                                                                            157                  0
D MG 01    0001   DOTINIC2020     0001       8111003      20201201                                 000001     300000                                                                                                                                                                                              1                      20201231  20201201                                                                                                                                                                                                                                                                                                                                                                                                                                            158                  0
D MG 01    0001   DOTINIC2020     0001       8111004      20200101                                 000001     400000                                                                                                                                                                                              1                      20200131  20200101                                                                                                                                                                                                                                                                                                                                                                                                                                            159                  0
D MG 01    0001   DOTINIC2020     0001       8111004      20200201                                 000001     400000                                                                                                                                                                                              1                      20200229  20200201                                                                                                                                                                                                                                                                                                                                                                                                                                            160                  0
D MG 01    0001   DOTINIC2020     0001       8111004      20200301                                 000001     400000                                                                                                                                                                                              1                      20200331  20200301                                                                                                                                                                                                                                                                                                                                                                                                                                            161                  0
D MG 01    0001   DOTINIC2020     0001       8111004      20200401                                 000001     400000                                                                                                                                                                                              1                      20200430  20200401                                                                                                                                                                                                                                                                                                                                                                                                                                            162                  0
D MG 01    0001   DOTINIC2020     0001       8111004      20200501                                 000001     400000                                                                                                                                                                                              1                      20200531  20200501                                                                                                                                                                                                                                                                                                                                                                                                                                            163                  0
D MG 01    0001   DOTINIC2020     0001       8111004      20200601                                 000001     400000                                                                                                                                                                                              1                      20200630  20200601                                                                                                                                                                                                                                                                                                                                                                                                                                            164                  0
D MG 01    0001   DOTINIC2020     0001       8111004      20200701                                 000001     400000                                                                                                                                                                                              1                      20200731  20200701                                                                                                                                                                                                                                                                                                                                                                                                                                            165                  0
D MG 01    0001   DOTINIC2020     0001       8111004      20200801                                 000001     400000                                                                                                                                                                                              1                      20200831  20200801                                                                                                                                                                                                                                                                                                                                                                                                                                            166                  0
D MG 01    0001   DOTINIC2020     0001       8111004      20200901                                 000001     400000                                                                                                                                                                                              1                      20200930  20200901                                                                                                                                                                                                                                                                                                                                                                                                                                            167                  0
D MG 01    0001   DOTINIC2020     0001       8111004      20201001                                 000001     400000                                                                                                                                                                                              1                      20201031  20201001                                                                                                                                                                                                                                                                                                                                                                                                                                            168                  0
D MG 01    0001   DOTINIC2020     0001       8111004      20201101                                 000001     400000                                                                                                                                                                                              1                      20201130  20201101                                                                                                                                                                                                                                                                                                                                                                                                                                            169                  0
D MG 01    0001   DOTINIC2020     0001       8111004      20201201                                 000001     400000                                                                                                                                                                                              1                      20201231  20201201                                                                                                                                                                                                                                                                                                                                                                                                                                            170                  0
D MG 01    0001   DOTINIC2020     0001       8111005      20200101                                 000001     500000                                                                                                                                                                                              1                      20200131  20200101                                                                                                                                                                                                                                                                                                                                                                                                                                            171                  0
D MG 01    0001   DOTINIC2020     0001       8111005      20200201                                 000001     500000                                                                                                                                                                                              1                      20200229  20200201                                                                                                                                                                                                                                                                                                                                                                                                                                            172                  0
D MG 01    0001   DOTINIC2020     0001       8111005      20200301                                 000001     500000                                                                                                                                                                                              1                      20200331  20200301                                                                                                                                                                                                                                                                                                                                                                                                                                            173                  0
D MG 01    0001   DOTINIC2020     0001       8111005      20200401                                 000001     500000                                                                                                                                                                                              1                      20200430  20200401                                                                                                                                                                                                                                                                                                                                                                                                                                            174                  0
D MG 01    0001   DOTINIC2020     0001       8111005      20200501                                 000001     500000                                                                                                                                                                                              1                      20200531  20200501                                                                                                                                                                                                                                                                                                                                                                                                                                            175                  0
D MG 01    0001   DOTINIC2020     0001       8111005      20200601                                 000001     500000                                                                                                                                                                                              1                      20200630  20200601                                                                                                                                                                                                                                                                                                                                                                                                                                            176                  0
D MG 01    0001   DOTINIC2020     0001       8111005      20200701                                 000001     500000                                                                                                                                                                                              1                      20200731  20200701                                                                                                                                                                                                                                                                                                                                                                                                                                            177                  0
D MG 01    0001   DOTINIC2020     0001       8111005      20200801                                 000001     500000                                                                                                                                                                                              1                      20200831  20200801                                                                                                                                                                                                                                                                                                                                                                                                                                            178                  0
D MG 01    0001   DOTINIC2020     0001       8111005      20200901                                 000001     500000                                                                                                                                                                                              1                      20200930  20200901                                                                                                                                                                                                                                                                                                                                                                                                                                            179                  0
D MG 01    0001   DOTINIC2020     0001       8111005      20201001                                 000001     500000                                                                                                                                                                                              1                      20201031  20201001                                                                                                                                                                                                                                                                                                                                                                                                                                            180                  0
D MG 01    0001   DOTINIC2020     0001       8111005      20201101                                 000001     500000                                                                                                                                                                                              1                      20201130  20201101                                                                                                                                                                                                                                                                                                                                                                                                                                            181                  0
D MG 01    0001   DOTINIC2020     0001       8111005      20201201                                 000001     500000                                                                                                                                                                                              1                      20201231  20201201                                                                                                                                                                                                                                                                                                                                                                                                                                            182                  0
D MG 01    0001   DOTINIC2020     0001       8111006      20200101                                 000001     60000                                                                                                                                                                                               1                      20200131  20200101                                                                                                                                                                                                                                                                                                                                                                                                                                            183                  0
D MG 01    0001   DOTINIC2020     0001       8111006      20200201                                 000001     60000                                                                                                                                                                                               1                      20200229  20200201                                                                                                                                                                                                                                                                                                                                                                                                                                            184                  0
D MG 01    0001   DOTINIC2020     0001       8111006      20200301                                 000001     60000                                                                                                                                                                                               1                      20200331  20200301                                                                                                                                                                                                                                                                                                                                                                                                                                            185                  0
D MG 01    0001   DOTINIC2020     0001       8111006      20200401                                 000001     60000                                                                                                                                                                                               1                      20200430  20200401                                                                                                                                                                                                                                                                                                                                                                                                                                            186                  0
D MG 01    0001   DOTINIC2020     0001       8111006      20200501                                 000001     60000                                                                                                                                                                                               1                      20200531  20200501                                                                                                                                                                                                                                                                                                                                                                                                                                            187                  0
D MG 01    0001   DOTINIC2020     0001       8111006      20200601                                 000001     60000                                                                                                                                                                                               1                      20200630  20200601                                                                                                                                                                                                                                                                                                                                                                                                                                            188                  0
D MG 01    0001   DOTINIC2020     0001       8111006      20200701                                 000001     60000                                                                                                                                                                                               1                      20200731  20200701                                                                                                                                                                                                                                                                                                                                                                                                                                            189                  0
D MG 01    0001   DOTINIC2020     0001       8111006      20200801                                 000001     60000                                                                                                                                                                                               1                      20200831  20200801                                                                                                                                                                                                                                                                                                                                                                                                                                            190                  0
D MG 01    0001   DOTINIC2020     0001       8111006      20200901                                 000001     60000                                                                                                                                                                                               1                      20200930  20200901                                                                                                                                                                                                                                                                                                                                                                                                                                            191                  0
D MG 01    0001   DOTINIC2020     0001       8111006      20201001                                 000001     60000                                                                                                                                                                                               1                      20201031  20201001                                                                                                                                                                                                                                                                                                                                                                                                                                            192                  0
D MG 01    0001   DOTINIC2020     0001       8111006      20201101                                 000001     60000                                                                                                                                                                                               1                      20201130  20201101                                                                                                                                                                                                                                                                                                                                                                                                                                            193                  0
D MG 01    0001   DOTINIC2020     0001       8111006      20201201                                 000001     60000                                                                                                                                                                                               1                      20201231  20201201                                                                                                                                                                                                                                                                                                                                                                                                                                            194                  0
D MG 01    0001   DOTINIC2020     0001       8111007      20200101                                 000001     7000000                                                                                                                                                                                             1                      20200131  20200101                                                                                                                                                                                                                                                                                                                                                                                                                                            195                  0
D MG 01    0001   DOTINIC2020     0001       8111007      20200201                                 000001     7000000                                                                                                                                                                                             1                      20200229  20200201                                                                                                                                                                                                                                                                                                                                                                                                                                            196                  0
D MG 01    0001   DOTINIC2020     0001       8111007      20200301                                 000001     7000000                                                                                                                                                                                             1                      20200331  20200301                                                                                                                                                                                                                                                                                                                                                                                                                                            197                  0
D MG 01    0001   DOTINIC2020     0001       8111007      20200401                                 000001     7000000                                                                                                                                                                                             1                      20200430  20200401                                                                                                                                                                                                                                                                                                                                                                                                                                            198                  0
D MG 01    0001   DOTINIC2020     0001       8111007      20200501                                 000001     7000000                                                                                                                                                                                             1                      20200531  20200501                                                                                                                                                                                                                                                                                                                                                                                                                                            199                  0
D MG 01    0001   DOTINIC2020     0001       8111007      20200601                                 000001     7000000                                                                                                                                                                                             1                      20200630  20200601                                                                                                                                                                                                                                                                                                                                                                                                                                            200                  0
D MG 01    0001   DOTINIC2020     0001       8111007      20200701                                 000001     7000000                                                                                                                                                                                             1                      20200731  20200701                                                                                                                                                                                                                                                                                                                                                                                                                                            201                  0
D MG 01    0001   DOTINIC2020     0001       8111007      20200801                                 000001     7000000                                                                                                                                                                                             1                      20200831  20200801                                                                                                                                                                                                                                                                                                                                                                                                                                            202                  0
D MG 01    0001   DOTINIC2020     0001       8111007      20200901                                 000001     7000000                                                                                                                                                                                             1                      20200930  20200901                                                                                                                                                                                                                                                                                                                                                                                                                                            203                  0
D MG 01    0001   DOTINIC2020     0001       8111007      20201001                                 000001     7000000                                                                                                                                                                                             1                      20201031  20201001                                                                                                                                                                                                                                                                                                                                                                                                                                            204                  0
D MG 01    0001   DOTINIC2020     0001       8111007      20201101                                 000001     7000000                                                                                                                                                                                             1                      20201130  20201101                                                                                                                                                                                                                                                                                                                                                                                                                                            205                  0
D MG 01    0001   DOTINIC2020     0001       8111007      20201201                                 000001     7000000                                                                                                                                                                                             1                      20201231  20201201                                                                                                                                                                                                                                                                                                                                                                                                                                            206                  0
D MG 01    0001   DOTINIC2020     0001       8111008      20200101                                 000001     8000000                                                                                                                                                                                             1                      20200131  20200101                                                                                                                                                                                                                                                                                                                                                                                                                                            207                  0
D MG 01    0001   DOTINIC2020     0001       8111008      20200201                                 000001     8000000                                                                                                                                                                                             1                      20200229  20200201                                                                                                                                                                                                                                                                                                                                                                                                                                            208                  0
D MG 01    0001   DOTINIC2020     0001       8111008      20200301                                 000001     8000000                                                                                                                                                                                             1                      20200331  20200301                                                                                                                                                                                                                                                                                                                                                                                                                                            209                  0
D MG 01    0001   DOTINIC2020     0001       8111008      20200401                                 000001     8000000                                                                                                                                                                                             1                      20200430  20200401                                                                                                                                                                                                                                                                                                                                                                                                                                            210                  0
D MG 01    0001   DOTINIC2020     0001       8111008      20200501                                 000001     8000000                                                                                                                                                                                             1                      20200531  20200501                                                                                                                                                                                                                                                                                                                                                                                                                                            211                  0
D MG 01    0001   DOTINIC2020     0001       8111008      20200601                                 000001     8000000                                                                                                                                                                                             1                      20200630  20200601                                                                                                                                                                                                                                                                                                                                                                                                                                            212                  0
D MG 01    0001   DOTINIC2020     0001       8111008      20200701                                 000001     8000000                                                                                                                                                                                             1                      20200731  20200701                                                                                                                                                                                                                                                                                                                                                                                                                                            213                  0
D MG 01    0001   DOTINIC2020     0001       8111008      20200801                                 000001     8000000                                                                                                                                                                                             1                      20200831  20200801                                                                                                                                                                                                                                                                                                                                                                                                                                            214                  0
D MG 01    0001   DOTINIC2020     0001       8111008      20200901                                 000001     8000000                                                                                                                                                                                             1                      20200930  20200901                                                                                                                                                                                                                                                                                                                                                                                                                                            215                  0
D MG 01    0001   DOTINIC2020     0001       8111008      20201001                                 000001     8000000                                                                                                                                                                                             1                      20201031  20201001                                                                                                                                                                                                                                                                                                                                                                                                                                            216                  0
D MG 01    0001   DOTINIC2020     0001       8111008      20201101                                 000001     8000000                                                                                                                                                                                             1                      20201130  20201101                                                                                                                                                                                                                                                                                                                                                                                                                                            217                  0
D MG 01    0001   DOTINIC2020     0001       8111008      20201201                                 000001     8000000                                                                                                                                                                                             1                      20201231  20201201                                                                                                                                                                                                                                                                                                                                                                                                                                            218                  0

(96 linhas afetadas)


------------------------------------------------------------------------------------------------
SELECT * FROM AK5T10 WHERE AK5_FILIAL = |D MG 01 | AND AK5_CODIGO LIKE |8%| AND D_E_L_E_T_ = | |

(1 linha afetada)

AK5_FILIAL AK5_CODIGO   AK5_DESCRI                                                   AK5_TIPO AK5_DEBCRE AK5_MASC AK5_DTINC AK5_DTINI AK5_COSUP    AK5_MSBLQL D_E_L_E_T_ R_E_C_N_O_           R_E_C_D_E_L_
---------- ------------ ------------------------------------------------------------ -------- ---------- -------- --------- --------- ------------ ---------- ---------- -------------------- --------------------
D MG 01    8            CONTABILDADE PUBLICA                                         1        1                   20171205  19800101               2                     416                  0
D MG 01    81           CONTABILIDADE PUBLICA NIVEL I                                1        1                   20171205  19800101  8            2                     417                  0
D MG 01    811          CONTABILIDADE PUBLICA NIVEL II                               1        1                   20171205  19800101  81           2                     418                  0
D MG 01    8111         CONTABILIDADE PUBLICA NIVEL III                              1        1                   20171205  19800101  811          2                     419                  0
D MG 01    8111001      CONTAB.PUBLICA - DESP. ANALITICAS 8111001                    2        2                   20171205  19800101  8111         2                     420                  0
D MG 01    8111002      CONTAB.PUBLICA - DESP. ANALITICAS 8111002                    2        1                   20171205  19800101  8111         2                     421                  0
D MG 01    8111003      CONTAB.PUBLICA - DESP. ANALITICAS 8111003                    2        1                   20171205  19800101  8111         2                     422                  0
D MG 01    8111004      CONTAB.PUBLICA - DESP. ANALITICAS 8111004                    2        1                   20171205  19800101  8111         2                     423                  0
D MG 01    8111005      CONTAB.PUBLICA - DESP. ANALITICAS 8111005                    2        1                   20171205  19800101  8111         2                     424                  0
D MG 01    8111006      CONTAB.PUBLICA - DESP. ANALITICAS 8111006                    2        1                   20171205  19800101  8111         2                     425                  0
D MG 01    8111007      CONTAB.PUBLICA - DESP. ANALITICAS 8111007                    2        1                   20171205  20160101  8111         2                     426                  0
D MG 01    8111008      CONTAB.PUBLICA - DESP. ANALITICAS 8111008                    2        1                   20171205  20160101  8111         2                     427                  0

(12 linhas afetadas)


-------------------------------------------------------------------------------------------------------------
SELECT * FROM AK6T10 WHERE AK6_FILIAL = |D MG 01 | AND AK6_CODIGO IN (|000001|,|000002|) AND D_E_L_E_T_ = | |

(1 linha afetada)

AK6_FILIAL AK6_CODIGO AK6_DESCRI                                                   AK6_ENTIDA AK6_INDICE             AK6_VISUAL                                                                                                                         AK6_OBRIGA AK6_OPERPA AK6_UM                                                                                               AK6_OPER AK6_DECIMA             AK6_FORMAT AK6_SYMBOL AK6_CUSTOM           AK6_MEMO                                                                                                                                                                                                                                                         D_E_L_E_T_ R_E_C_N_O_           R_E_C_D_E_L_
---------- ---------- ------------------------------------------------------------ ---------- ---------------------- ---------------------------------------------------------------------------------------------------------------------------------- ---------- ---------- ---------------------------------------------------------------------------------------------------- -------- ---------------------- ---------- ---------- -------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------- -------------------- --------------------
D MG 01    000001     DESPESAS                                                                0                                                                                                                                                         2                                                                                                                          2        2                      1                                          NULL                                                                                                                                                                                                                                                                        1                    0
D MG 01    000002     RECEITAS                                                                0                                                                                                                                                         2                                                                                                                          2        2                      1                                          NULL                                                                                                                                                                                                                                                                        2                    0

(2 linhas afetadas)


-------------------------------------------------------------------------------------------------------------------------
SELECT * FROM AL2T10 WHERE AL2_FILIAL = |D MG 01 | AND AL2_TPSALD IN (|DR|,|DE|,|DL|,|DP|,|OH|,|O1|) AND D_E_L_E_T_ = | |

(1 linha afetada)

AL2_FILIAL AL2_TPSALD AL2_DESCRI                               D_E_L_E_T_ R_E_C_N_O_           R_E_C_D_E_L_
---------- ---------- ---------------------------------------- ---------- -------------------- --------------------
D MG 01    O1         DOTACAO   ATUALIZADA                                10                   0
D MG 01    OH         DOTACAO INICIAL                                     11                   0
D MG 01    DE         DESP.ESAS EMPENHADAS                                12                   0
D MG 01    DL         DESPESAS LIQUIDADAS                                 13                   0
D MG 01    DP         DESPESAS PAGAS                                      14                   0
D MG 01    DR         DESPESAS - RESERVA                                  15                   0

(6 linhas afetadas)


-----------------------------------------------------------------
SELECT * FROM AL1T10 WHERE AL1_CONFIG = |81| AND D_E_L_E_T_ = | |

(1 linha afetada)

AL1_FILIAL AL1_CONFIG AL1_DESCRI                               AL1_CONCDE                                                                                                                                             AL1_CHAVER                                                                                                               AL1_TPATU AL1_MEMO                                                                                                                                                                                                                                                         AL1_STATUS D_E_L_E_T_ R_E_C_N_O_           R_E_C_D_E_L_
---------- ---------- ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------ --------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------- ---------- -------------------- --------------------
D MG 01    81         CONTABILIDADE PUBLICA                    CO+TP.SALDO                                                                                                                                            AKD->AKD_CO+AKD->AKD_TPSALD                                                                                              1         NULL                                                                                                                                                                                                                                                             1                     6                    0

(1 linha afetada)


--------------------------------------------------------------
SELECT * FROM AKWT10 WHERE AKW_COD = |81| AND D_E_L_E_T_ = | |

(1 linha afetada)

AKW_FILIAL AKW_COD AKW_NIVEL AKW_DESCRI                     AKW_CHAVER                                                   AKW_TAMANH             AKW_CONCDE                                                                                                                                             AKW_CONCCH                                                                                                                                             AKW_ALIAS AKW_F3 AKW_CODREL                                                                                           AKW_RELAC                                                    AKW_CNDSIN                                                                                           AKW_DESCRE                                                                                           AKW_ATUSIN                                                                                           AKW_RECDES                                                                                           AKW_OBRIGA D_E_L_E_T_ R_E_C_N_O_           R_E_C_D_E_L_
---------- ------- --------- ------------------------------ ------------------------------------------------------------ ---------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------------------------ --------- ------ ---------------------------------------------------------------------------------------------------- ------------------------------------------------------------ ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------- ---------- -------------------- --------------------
D MG 01    81      01        CO                             AKD->AKD_CO                                                  12                     CO                                                                                                                                                     AKD->AKD_CO                                                                                                                                            AK5       AK5    PcoRetCO(AK5->AK5_CODIGO,AK5->AK5_MASC)                                                              AK5->AK5_CODIGO                                              AK5->AK5_TIPO=='1'                                                                                   AK5->AK5_DESCRI                                                                                      Posicione('AK5',1,xFilial('AK5')+AUXCHAVE,'AK5_COSUP')                                                                                                                                                    1                     16                   0
D MG 01    81      02        TP.SALDO                       AKD->AKD_TPSALD                                              2                      CO+TP.SALDO                                                                                                                                            AKD->AKD_CO+AKD->AKD_TPSALD                                                                                                                            AL2       AL2A                                                                                                        AL2->AL2_TPSALD                                                                                                                                                   AL2->AL2_DESCRI                                                                                                                                                                                                                                                                                                1                     17                   0

(2 linhas afetadas)


--------------------------------------------------------------------
SELECT * FROM AL3T10 WHERE AL3_CODIGO LIKE |8%| AND D_E_L_E_T_ = | |

(1 linha afetada)

AL3_FILIAL AL3_CODIGO AL3_CONFIG AL3_DESCRI                               AL3_MEMO                                                                                                                                                                                                                                                         D_E_L_E_T_ R_E_C_N_O_           R_E_C_D_E_L_
---------- ---------- ---------- ---------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------- -------------------- --------------------
D MG 01    8101       81         DOTACAO INICIAL                          NULL                                                                                                                                                                                                                                                                        12                   0
D MG 01    8102       81         DOTACAO ATUALIZADA                       NULL                                                                                                                                                                                                                                                                        13                   0
D MG 01    8103       81         DESPESAS - RESERVAS                      NULL                                                                                                                                                                                                                                                                        14                   0
D MG 01    8104       81         DESPESAS EMPENHADAS                      NULL                                                                                                                                                                                                                                                                        15                   0
D MG 01    8105       81         DESPESAS LIQUIDADAS                      NULL                                                                                                                                                                                                                                                                        16                   0
D MG 01    8106       81         DESPESAS PAGAS                           NULL                                                                                                                                                                                                                                                                        17                   0
D MG 01    8107       81         TOTAL DESPESAS                           NULL                                                                                                                                                                                                                                                                        18                   0

(7 linhas afetadas)


-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SELECT AL4_FILIAL, AL4_CODIGO, AL4_CONFIG, AL4_NIVEL, AL4_DETALH, AL4_EXPRIN, AL4_EXPRFI, AL4_TPFAIX, AL4_VALID,CAST(AL4_FILTER AS varchar(250)) AL4_FILTER FROM AL4T10 WHERE AL4_CODIGO LIKE |8%| AND D_E_L_E_T_ = | |

(1 linha afetada)

AL4_FILIAL AL4_CODIGO AL4_CONFIG AL4_NIVEL AL4_DETALH AL4_EXPRIN                                                   AL4_EXPRFI                                                   AL4_TPFAIX AL4_VALID                                                    AL4_FILTER
---------- ---------- ---------- --------- ---------- ------------------------------------------------------------ ------------------------------------------------------------ ---------- ------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
D MG 01    8101       81         02        1          OH                                                           OH                                                           2                                                                       NULL
D MG 01    8102       81         02        1          O1                                                           O1                                                           2                                                                       NULL
D MG 01    8103       81         02        1          DR                                                           DR                                                           2                                                                       NULL
D MG 01    8104       81         02        1          DE                                                           DE                                                           2                                                                       NULL
D MG 01    8105       81         02        1          DL                                                           DL                                                           2                                                                       NULL
D MG 01    8106       81         02        1          DP                                                           DP                                                           2                                                                        
D MG 01    8107       81         02        1                                                                       ZZ                                                           2                                                                       AL2_TPSALD== "DR" .OR. AL2_TPSALD== "DE" .OR. AL2_TPSALD== "DL" .OR. AL2_TPSALD== "DP" 

(7 linhas afetadas)


---------------------------------------------------------------
SELECT * FROM AKJT10 WHERE AKJ_COD = |811| AND D_E_L_E_T_ = | |

(1 linha afetada)

AKJ_FILIAL AKJ_COD AKJ_DESCRI                     AKJ_PRVCFG AKJ_REACFG AKJ_TPSLD AKJ_MOEDPR             AKJ_MOEDRZ             AKJ_BLOCK                                                                                                                                                                                                                                                        AKJ_NIVPR AKJ_NIVRE AKJ_SLDPER AKJ_QTDBLQ             AKJ_CALCVL AKJ_CONFIG AKJ_PRCMRG             AKJ_TIPMSG AKJ_GRPUSR D_E_L_E_T_ R_E_C_N_O_           R_E_C_D_E_L_
---------- ------- ------------------------------ ---------- ---------- --------- ---------------------- ---------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------- --------- ---------- ---------------------- ---------- ---------- ---------------------- ---------- ---------- ---------- -------------------- --------------------
D MG 01    811     BLOQ CONT PUBLICA DOT X DESPES 8101       8107       3         1                      1                      NULL                                                                                                                                                                                                                                                             01        01        2          4                      1          81         0                      1                                5                    0

(1 linha afetada)


------------------------------------------------------------------------------------------------
SELECT * FROM AKCT10 WHERE AKC_FILIAL = |D MG 01 | AND AKC_CO = |"8111003"| AND D_E_L_E_T_ = | |

(1 linha afetada)

AKC_FILIAL AKC_PROCES AKC_ATIVO AKC_SEQ AKC_CO                                                                                                                                                                                                                                                     AKC_DATA                                                                                                                                                                                                                                                   AKC_CLASSE                                                                                                                                                                                                                                                 AKC_TIPO AKC_HIST                                                                                                                                                                                                                                                   AKC_UM                                                       AKC_VALOR1                                                                                                                                                                                                                                                 AKC_KEYREF                                                   AKC_OPER                                                                                                                                                                                                                                                   AKC_ITEM AKC_TPSALD                                                   AKC_VALOR2                                                                                                                                                                                                                                                 AKC_VALOR3                                                                                                                                                                                                                                                 AKC_VALOR4                                                                                                                                                                                                                                                 AKC_VALOR5                                                                                                                                                                                                                                                 AKC_CODPLA                                                   AKC_VERSAO                                                   AKC_CC                                                                                                                                                                                                                                                     AKC_ITCTB                                                                                                                                                                                                                                                  AKC_CLVLR                                                                                                                                                                                                                                                  AKC_EXEPRE                                                   AKC_UNIORC                                                   AKC_ENT05                                                    AKC_ENT06                                                    AKC_ENT07                                                    AKC_ENT08                                                    AKC_ENT09                                                    D_E_L_E_T_ R_E_C_N_O_           R_E_C_D_E_L_
---------- ---------- --------- ------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ------------------------------------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------ ------------------------------------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------ ---------- -------------------- --------------------
D MG 01    000051     LBOK      01      "8111003"                                                                                                                                                                                                                                                  SC1->C1_EMISSAO                                                                                                                                                                                                                                            "000001"                                                                                                                                                                                                                                                   "1"      "SOLICITACAO DE COMPRAS - (DESPESAS - RESERVAS)"                                                                                                                                                                                                                                                                        MCUSTPROD:=Posicione("SB1", 1, xFilial("SB1") +SC1->C1_PRODUTO, "B1_CUSTD"), SC1->C1_QUANT*MCUSTPROD                                                                                                                                                                                                                                                                                                                                                                                                                                                                               38                   0
D MG 01    000052     LBOK      01      "8111003"                                                                                                                                                                                                                                                  SC7->C7_EMISSAO                                                                                                                                                                                                                                            "000001"                                                                                                                                                                                                                                                   "1"      "PEDIDO DE COMPRAS - (DESPESAS EMPENHADAS)"                                                                                                                                                                                                                                                                             SC7->C7_TOTAL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      39                   0
D MG 01    000052     LBOK      02      "8111003"                                                                                                                                                                                                                                                  SC7->C7_EMISSAO                                                                                                                                                                                                                                            "000001"                                                                                                                                                                                                                                                   "2"      "PEDIDO DE COMPRAS - (DESPESAS - RESERVAS)"                                                                                                                                                                                                                                                                             SC7->C7_TOTAL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      40                   0
D MG 01    000054     LBOK      02      "8111003"                                                                                                                                                                                                                                                  SF1->F1_EMISSAO                                                                                                                                                                                                                                            "000001"                                                                                                                                                                                                                                                   "1"      "DOC NF ENTRADA - (DESPESAS LIQUIDADAS)"                                                                                                                                                                                                                                                                                SD1->D1_TOTAL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      41                   0
D MG 01    000054     LBOK      03      "8111003"                                                                                                                                                                                                                                                  SF1->F1_EMISSAO                                                                                                                                                                                                                                            "000001"                                                                                                                                                                                                                                                   "2"      "DOC NF ENTRADA - (DESPESAS EMPENHADAS)"                                                                                                                                                                                                                                                                                SD1->D1_TOTAL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      42                   0
D MG 01    000005     LBOK      01      "8111003"                                                                                                                                                                                                                                                  SE5->E5_DATA                                                                                                                                                                                                                                               "000001"                                                                                                                                                                                                                                                   "1"      "BAIXA DO TITULOS A PAGAR - (DESPESAS PAGAS)"                                                                                                                                                                                                                                                                           SE5->E5_VALOR                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      43                   0
D MG 01    000005     LBOK      02      "8111003"                                                                                                                                                                                                                                                  SE5->E5_DATA                                                                                                                                                                                                                                               "000001"                                                                                                                                                                                                                                                   "2"      "BAIXA DO TITULO A PAGAR - (DESPESAS LIQUIDADAS)"                                                                                                                                                                                                                                                                       SE5->E5_VALOR                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      44                   0

(7 linhas afetadas)


------------------------------------------------------------------------------------------------
SELECT * FROM AKIT10 WHERE AKI_FILIAL = |D MG 01 | AND AKI_CO = |"8111003"| AND D_E_L_E_T_ = | |

(1 linha afetada)

AKI_FILIAL AKI_PROCES AKI_ATIVO AKI_ITEM AKI_SEQ AKI_CO                                                                                                                                                                                                                                                     AKI_DATA                                                                                                                                                                                                                                                   AKI_CLASSE                                                                                                                                                                                                                                                 AKI_TIPO AKI_HIST                                                                                                                                                                                                                                                   AKI_UM                                                       AKI_KEYREF                                                   AKI_OPER                                                                                                                                                                                                                                                   AKI_TPSALD                                                   AKI_VALOR1                                                                                                                                                                                                                                                 AKI_VALOR2                                                                                                                                                                                                                                                 AKI_VALOR3                                                                                                                                                                                                                                                 AKI_VALOR4                                                                                                                                                                                                                                                 AKI_CODPLA                                                   AKI_VALOR5                                                                                                                                                                                                                                                 AKI_VERSAO                                                   AKI_CC                                                                                                                                                                                                                                                     AKI_ITCTB                                                                                                                                                                                                                                                  AKI_CLVLR                                                                                                                                                                                                                                                  AKI_EXEPRE                                                   AKI_UNIORC                                                   AKI_ENT05                                                    AKI_ENT06                                                    AKI_ENT07                                                    AKI_ENT08                                                    AKI_ENT09                                                    D_E_L_E_T_ R_E_C_N_O_           R_E_C_D_E_L_
---------- ---------- --------- -------- ------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------ ------------------------------------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------ ------------------------------------------------------------ ---------- -------------------- --------------------
D MG 01    000051     LBOK      01       01      "8111003"                                                                                                                                                                                                                                                  DDATABASE                                                                                                                                                                                                                                                  "000001"                                                                                                                                                                                                                                                   "1"      "BLOQUEIO SOLIC COMPRAS - (DESPESAS RESERVA)"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   10                   0
D MG 01    000052     LBOK      01       01      "8111003"                                                                                                                                                                                                                                                  DDATABASE                                                                                                                                                                                                                                                  "000001"                                                                                                                                                                                                                                                   "1"      "BLOQUEIO PED COMPRAS - (DESPESAS EMPENHADAS)"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  11                   0
D MG 01    000054     LBOK      01       01      "8111003"                                                                                                                                                                                                                                                  DDATABASE                                                                                                                                                                                                                                                  "000001"                                                                                                                                                                                                                                                   "1"      "BLOQ DOC NF ENTRADA - (DESPESAS LIQUIDADAS)"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   12                   0
D MG 01    000005     LBOK      01       01      "8111003"                                                                                                                                                                                                                                                  DDATABASE                                                                                                                                                                                                                                                  "000001"                                                                                                                                                                                                                                                   "1"      "BLOQ BAIXAS A PAGAR - (DESPESAS PAGAS)"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        13                   0

(4 linhas afetadas)


----------------------------------------------------------------------------------------------
SELECT * FROM AKHT10 WHERE AKH_FILIAL = |D MG 01 | AND AKH_CODBLQ = |811| AND D_E_L_E_T_ = | |

(1 linha afetada)

AKH_FILIAL AKH_PROCES AKH_ATIVO AKH_SEQ AKH_ITEM AKH_CODBLQ D_E_L_E_T_ R_E_C_N_O_           R_E_C_D_E_L_
---------- ---------- --------- ------- -------- ---------- ---------- -------------------- --------------------
D MG 01    000051     LBOK      01      01       811                   9                    0
D MG 01    000052     LBOK      01      01       811                   10                   0
D MG 01    000054     LBOK      01      01       811                   11                   0
D MG 01    000005     LBOK      01      01       811                   12                   0

(4 linhas afetadas)


HTML
<!-- esconder o menu --> 


<style>
div.theme-default .ia-splitter #main {
    margin-left: 0px;
}
.ia-fixed-sidebar, .ia-splitter-left {
    display: none;
}
#main {
    padding-left: 10px;
    padding-right: 10px;
    overflow-x: hidden;
}

.aui-header-primary .aui-nav,  .aui-page-panel {
    margin-left: 0px !important;
}
.aui-header-primary .aui-nav {
    margin-left: 0px !important;
}
</style>

...