...
Esta API será executada por um programa da Equipe Fiscal e retornará duas tabelas temporárias, sendo uma com os movimentos Movimentos extraídos e a outra com as informações dos participantesParticipantes , depois o mesmo programa do Fiscal irá chamar o Faturamento para identificar na Nota qual valor é ISS ou ICMS.
...
Atributo | Tipo | Formato | Descrição |
tta_cod_empresa | character | x(3) | Empresa |
tta_num_id_tit_acr | integer | 999999999 | Token Cta Receber |
tta_num_id_movto_tit_acr | integer | 999999999 | Token Movto Tit ACR |
| ttv_cod_estab_ems2 | character | x(5) | Estabelecimento EMS2 |
| ttv_cod_ser_docto_fat | character | x(5) | Série Faturamento |
| tta_cod_nota_fisc_faturam | character | x(16) | Nota Fiscal |
| tta_cod_parcela_faturam | character | x(2) | Parcela Nota |
| tta_cod_proces_export | character | x(12) | Processo Exportação |
| ttv_cod_estab_ems5 | character | x(5) | Estabelecimento |
| tta_cod_espec_docto | |||
| tta_cod_ser_docto | |||
| tta_cod_tit_acr | |||
field as character format "x(3)" label "Espécie Documento" column-label "Espécie"
field as character format "x(5)" label "Série Documento" column-label "Série"
field as character format "x(16)" label "Título" column-label "Título"
field tta_cod_parcela as character format "x(02)" label "Parcela" column-label "Parcela"
field tta_cdn_cliente as Integer format ">>>,>>>,>>9" initial 0 label "Cliente" column-label "Cliente"
field tta_ind_trans_acr_abrev as character format "X(04)" label "Trans Abrev" column-label "Trans Abrev"
field ttv_dat_pagto_eletron_movto as date format "99/99/9999"
field tta_val_movto_tit_acr as decimal format "->>>,>>>,>>9.99" decimals 2 initial 0 label "Vl Movimento" column-label "Vl Movimento"
field tta_val_desconto as decimal format "->>>,>>>,>>>,>>9.99" decimals 2 initial 0 label "Valor Desconto" column-label "Valor Desconto"
field tta_val_abat_tit_acr as decimal format ">>>>,>>>,>>9.99" decimals 2 initial 0 label "Vl Abatimento" column-label "Vl Abatimento"
field tta_val_juros as decimal format ">>>>,>>>,>>9.99" decimals 2 initial 0 label "Valor Juros" column-label "Valor Juros"
field tta_val_multa_tit_acr as decimal format ">>>>,>>>,>>9.99" decimals 2 initial 0 label "Vl Multa" column-label "Vl Multa"
field tta_val_despes_bcia as decimal format "->>>,>>>,>>9.99" decimals 2 initial 0 label "Vl Desp Banc" column-label "Vl Desp Banc"
field tta_cod_portador as character format "x(5)" label "Portador" column-label "Portador"
field tta_cod_cart_bcia as character format "x(3)" label "Carteira" column-label "Carteira"
field ttv_val_brut_icms as decimal format "->>,>>>,>>>,>>9.99" decimals 2 label "Valor ICMS"
field ttv_val_brut_iss as decimal format "->>,>>>,>>>,>>9.99" decimals 2 label "Bruto ISS"
field ttv_val_brut_outros as decimal format "->>,>>>,>>>,>>9.99" decimals 2 label "Valor Bruto Outros"
field ttv_cod_particip_instit_financ as character format "x(30)" label "C¢d. Participante"
field ttv_cod_particip_interm as character format "x(20)"
field tta_ind_orig_tit_acr as character format "X(8)" initial "ACREMS50" label "Origem Tit Cta Rec" column-label "Origem Tit Cta Rec"
field ttv_log_autom_acr as logical format "Sim/NÆo" initial yes
field ttv_num_id_movto_tit_acr_ren as integer format "999999999" initial 0 label "Token Movto Tit ACR" column-label "Token Movto Tit ACR"
index tt_dwf_pagto_eletr is primary unique
def temp-table tt_dwf_pagto_eletr_movto no-undo
field tta_cod_empresa as character format "x(3)" label "Empresa" column-label "Empresa"
field tta_num_id_tit_acr as integer format "999999999" initial 0 label "Token Cta Receber" column-label "Token Cta Receber"
field tta_num_id_movto_tit_acr as integer format "999999999" initial 0 label "Token Movto Tit ACR" column-label "Token Movto Tit ACR"
field ttv_cod_estab_ems2 as character format "x(5)"
field ttv_cod_ser_docto_fat as character format "x(5)" label "Série Faturamento" column-label "Série"
field tta_cod_nota_fisc_faturam as character format "x(16)" label "Nota Fiscal" column-label "Nota Fiscal"
field tta_cod_parcela_faturam as character format "x(2)" label "Parcela Nota" column-label "Parcela"
field tta_cod_proces_export as character format "x(12)" label "Processo Exportação" column-label "Processo Exportação"
field ttv_cod_estab_ems5 as character format "x(5)" label "Estabelecimento" column-label "Estabelecimento"
field tta_cod_espec_docto as character format "x(3)" label "Espécie Documento" column-label "Espécie"
field tta_cod_ser_docto as character format "x(5)" label "Série Documento" column-label "Série"
field tta_cod_tit_acr as character format "x(16)" label "Título" column-label "Título"
field tta_cod_parcela as character format "x(02)" label "Parcela" column-label "Parcela"
field tta_cdn_cliente as Integer format ">>>,>>>,>>9" initial 0 label "Cliente" column-label "Cliente"
field tta_ind_trans_acr_abrev as character format "X(04)" label "Trans Abrev" column-label "Trans Abrev"
field ttv_dat_pagto_eletron_movto as date format "99/99/9999"
field tta_val_movto_tit_acr as decimal format "->>>,>>>,>>9.99" decimals 2 initial 0 label "Vl Movimento" column-label "Vl Movimento"
field tta_val_desconto as decimal format "->>>,>>>,>>>,>>9.99" decimals 2 initial 0 label "Valor Desconto" column-label "Valor Desconto"
field tta_val_abat_tit_acr as decimal format ">>>>,>>>,>>9.99" decimals 2 initial 0 label "Vl Abatimento" column-label "Vl Abatimento"
field tta_val_juros as decimal format ">>>>,>>>,>>9.99" decimals 2 initial 0 label "Valor Juros" column-label "Valor Juros"
field tta_val_multa_tit_acr as decimal format ">>>>,>>>,>>9.99" decimals 2 initial 0 label "Vl Multa" column-label "Vl Multa"
field tta_val_despes_bcia as decimal format "->>>,>>>,>>9.99" decimals 2 initial 0 label "Vl Desp Banc" column-label "Vl Desp Banc"
field tta_cod_portador as character format "x(5)" label "Portador" column-label "Portador"
field tta_cod_cart_bcia as character format "x(3)" label "Carteira" column-label "Carteira"
field ttv_val_brut_icms as decimal format "->>,>>>,>>>,>>9.99" decimals 2 label "Valor ICMS"
field ttv_val_brut_iss as decimal format "->>,>>>,>>>,>>9.99" decimals 2 label "Bruto ISS"
field ttv_val_brut_outros as decimal format "->>,>>>,>>>,>>9.99" decimals 2 label "Valor Bruto Outros"
field ttv_cod_particip_instit_financ as character format "x(30)" label "C¢d. Participante"
field ttv_cod_particip_interm as character format "x(20)"
field tta_ind_orig_tit_acr as character format "X(8)" initial "ACREMS50" label "Origem Tit Cta Rec" column-label "Origem Tit Cta Rec"
field ttv_log_autom_acr as logical format "Sim/NÆo" initial yes
field ttv_num_id_movto_tit_acr_ren as integer format "999999999" initial 0 label "Token Movto Tit ACR" column-label "Token Movto Tit ACR"
index tt_dwf_pagto_eletr is primary unique
ttv_cod_estab_ems2 ascending
ttv_cod_ser_docto_fat ascending
tta_cod_nota_fisc_faturam ascending
tta_cod_parcela_faturam ascending
tta_cod_proces_export ascending
ttv_dat_pagto_eletron_movto ascending
ttv_cod_particip_instit_financ ascending
ttv_cod_particip_interm ascending
ttv_cod_estab_ems5 ascending
tta_cod_portador ascending
tta_cod_cart_bcia ascending
tta_num_id_tit_acr ascending
tta_num_id_movto_tit_acr ascending
ttv_num_id_movto_tit_acr_ren ascending
index tt_dwf_particip
ttv_cod_particip_instit_financ ascending
ttv_dat_pagto_eletron_movto ascending
index tt_dwf_titulo
ttv_cod_estab_ems5 ascending
tta_cod_espec_docto ascending
tta_cod_ser_docto ascending
tta_cod_tit_acr ascending
tta_cod_parcela ascending
.
...
