Histórico da Página
...
def temp-table tt_movto_cta_corren_import no-undo
field tta_cod_cta_corren as corren as character format "x(10)" label "Conta Corrente" column-label "Cta Corrente"
field tta_dat_movto_cta_corren as corren as date format "99/99/9999" initial today label "Data Movimento" column-label "Data Movimento"
field tta_num_seq_movto_cta_corren as corren as integer format ">>>>9" initial 0 label "Sequência" column-label "Sequência"
field tta_ind_tip_movto_cta_corren as corren as character format "X(2)" initial "RE" label "Tipo Movimento" column-label "Tipo Movto"
field tta_cod_tip_trans_cx as cx as character format "x(8)" label "Tipo Transação Caixa" column-label "Tipo Transação Caixa"
field tta_ind_fluxo_movto_cta_corren as corren as character format "X(3)" initial "ENT" label "Fluxo Movimento" column-label "Fluxo Movto"
field tta_cod_cenar_ctbl as ctbl as character format "x(8)" label "Cenário Contábil" column-label "Cenário Contábil"
field tta_cod_histor_padr padr as character format "x(8)" label "Histórico Padrão" column-label "Histórico Padrão"
field tta_val_movto_cta_corren corren as decimal format ">>>>,>>>,>>9.99" decimals 2 initial 0 label "Valor Movimento" column-label "Valor Movimento"
field tta_cod_docto_movto_cta_bco as character format "x(20)" label "Documento Banco" column-label "Documento Banco"
field tta_cod_modul_dtsul as character format "xdtsul as character format "x(3)" label "Módulo" column-label "Módulo"
field ttv_ind_erro_valid as valid as character format "X(08)" initial "Não"
field tta_des_histor_padr padr as character format "x(40)" label "Descrição" column-label "Descrição Histórico Padrão"
...
field ttv_rec_movto_cta_corren as corren as recid format ">>>>>>9" initial ?
index tt_erro
ttv_ind_erro_valid ascendingvalid ascending
index tt_import_movto_cta_corren is primary unique
tta_cod_cta_corren ascendingcorren ascending
tta_dat_movto_cta_corren ascendingcorren ascending
tta_num_seq_movto_cta_corren ascendingcorren ascending
index tt_rec_movto
ttv_rec_movto_cta_corren ascendingcorren ascending
.
Tabela Temporária | Descrição | Entrada/Saída |
tt_aprop_ctbl_cmg_imp | Conterá as informações das apropriações contábeis dos movimentos a serem importados. | Entrada |
...
field tta_num_id_movto_cta_corren corren as integer format "9999999999" initial 0 label "ID Movto Conta" column-label "ID Movto Conta"
...
field tta_ind_finalid_aprop_ctbl_cmg cmg as character format "X(2)" initial "PR" label "Finalidade" column-label "Finalidade"
field tta_ind_natur_lancto_ctbl as ctbl as character format "X(02)" initial "DB" label "Natureza" column-label "Natureza"
field tta_ind_orig_aprop_ctbl_cmg cmg as character format "X(3)" label "Origem Apropriação" column-label "Origem Aprop"
field tta_cod_empresa empresa as character format "x(3)" label "Empresa" column-label "Empresa"
field tta_cod_estab estab as character format "x(3)" label "Estabelecimento" column-label "Estab"
field tta_cod_cenar_ctbl as ctbl as character format "x(8)" label "Cenário Contábil" column-label "Cenário Contábil"
field tta_cod_plano_cta_ctbl as ctbl as character format "x(8)" label "Plano Contas" column-label "Plano Contas"
field tta_cod_cta_ctbl as ctbl as character format "x(20)" label "Conta Contábil" column-label "Conta Contábil"
field tta_cod_unid_negoc as negoc as character format "x(3)" label "Unid Negócio" column-label "Un Neg"
field tta_cod_plano_ccusto ccusto as character format "x(8)" label "Plano Centros Custo" column-label "Plano Centros Custo"
field tta_cod_ccusto ccusto as Character format "x(11)" label "Centro Custo" column-label "Centro Custo"
field tta_cod_cta_corren corren as character format "x(10)" label "Conta Corrente" column-label "Cta Corrente"
field tta_cod_indic_econ econ as character format "x(8)" label "Moeda" column-label "Moeda"
field tta_val_movto_cta_corren as corren as decimal format ">>>>,>>>,>>9.99" decimals 2 initial 0 label "Valor Movimento" column-label "Valor Movimento"
field tta_log_ctbz_movto_cta_corren as corren as logical format "Sim/Não" initial no label "Contabilizado" column-label "Contabilizado"
field tta_log_mutuo_pagto pagto as logical format "Sim/Não" initial no label "Mútuo Pagamento" column-label "Mútuo Pagamento"
field tta_dat_transacao transacao as date format "99/99/9999" initial today label "Data Transação" column-label "Dat Transac"
field ttv_rec_movto_cta_corren as corren as recid format ">>>>>>9" initial ?
field ttv_rec_aprop_ctbl_cmg cmg as recid format ">>>>>>9" initial ?
index tt_id id is primary
ttv_rec_movto_cta_corren corren ascending
index tt_id_aprop
ttv_rec_aprop_ctbl_cmg ascendingcmg ascending
.
Tabela Temporária | Descrição | Entrada/Saída |
tt_val_aprop_ctbl_cmg_import | Conterá as informações dos rateios financeiros dos movimentos a serem importados. | Entrada |
...
field tta_cod_finalid_econ as econ as character format "x(10)" label "Finalidade" column-label "Finalidade"
...
field tta_val_cotac_indic_econ as econ as decimal format ">>>>,>>9.9999999999" decimals 10 initial 0 label "Cotação" column-label "Cotação"
...
field ttv_rec_aprop_ctbl_cmg as cmg as recid format ">>>>>>9" initial ?
field ttv_rec_val_aprop_ctbl_cmg as cmg as recid format ">>>>>>9" initial ?
...
ttv_rec_movto_cta_corren ascendingcorren ascending
tta_cod_finalid_econ econ ascending
index tt_id is id is primary
ttv_rec_movto_cta_corren ascendingcorren ascending
ttv_rec_aprop_ctbl_cmg cmg ascending
ttv_rec_val_aprop_ctbl_cmg ascending
...
field ttv_rec_movto_cta_corren as corren as recid format ">>>>>>9" initial ?
field tta_cod_estab as estab as character format "x(3)" label "Estabelecimento" column-label "Estab"
field tta_cod_unid_negoc as negoc as character format "x(3)" label "Unid Negócio" column-label "Un Neg"
field tta_cod_tip_fluxo_financ as financ as character format "x(12)" label "Tipo Fluxo Financ" column-label "Tipo Fluxo Financ"
field tta_val_movto_cta_corren as corren as decimal format ">>>>,>>>,>>9.99" decimals 2 initial 0 label "Valor Movimento" column-label "Valor Movimento"
index tt_codigo is codigo is primary
ttv_rec_movto_cta_corren ascending
...
field ttv_rec_movto_cta_corren as corren as recid format ">>>>>>9" initial ?
field ttv_num_mensagem as mensagem as integer format ">>>>,>>9" label "Número" column-label "Número Mensagem"
field ttv_des_mensagem as character format "x(50)" label "Mensagem" column-label "Mensagem"
field ttv_des_msg_erro erro as character format "x(60)" label "Mensagem Erro" column-label "Inconsistência"
field ttv_cod_parameters as parameters as character format "x(256)"
...