01. VISÃO GERAL
Este documento tem por objetivo detalhar as temp-tables utilizadas na chamada da CPC cpc-bosaubillet.
03. TABELAS UTILIZADAS
- A seguir são detalhadas as tabelas de produto disponíveis nos parâmetros da CPC:
CPC cpc-bosaubillet
h-tmpBilletClientInfo
define temp-table tmpBilletClientInfo no-undo
field cd-cliente like contrat.cd-contratante
field cd-prestador like preserv.cd-prestador
field nm-cliente like contrat.nm-contratante
field nr-cgc-cpf like contrat.nr-cgc-cpf
field en-rua like contrat.en-rua
field en-complemento like endereco.ds-complemento
field en-referencia like endereco.char-1
field en-bairro like contrat.en-bairro
field en-cep like contrat.en-cep
field en-uf like contrat.en-uf
field nm-cidade like dzcidade.nm-cidade
field nr-telefone-contrat as char
field nr-insc-estadual as char
field in-tipo-pessoa as char
field in-forma-envio like contrat.u-int-2
field nm-emp-razao-social as char
field nr-estab-cnpj as char
index tmpBilletClientInfo01
cd-cliente.
h-tmpBilletEvent
define temp-table tmpBilletEvent no-undo
field id-nota-aux as int
field cd-evento like fatueven.cd-evento
field cd-imposto as int
field ds-evento like evenfatu.ds-evento
field lg-cred-deb like fatueven.lg-cred-deb
field vl-evento like fatueven.vl-evento
field lg-evento-nota as logical
index tmpBilletEvent01 is primary
id-nota-aux
cd-imposto
cd-evento
index tmpBilletEvent02
id-nota-aux
cd-evento.
h-tmpBilletEventMerge
h-b-tmpBilletEventMerge
define temp-table tmpBilletEventMerge no-undo like tmpBilletEvent
field cd-evento-soma as int
field notaserv-recid as int
field in-classif-evento as int
field vl-aliquota like fatueven.vl-evento.
h-tmpBilletTotalizers
define temp-table tmpBilletTotalizers no-undo
field cod-totalizador-boleto as char
field des-totalizador-boleto as char.
h-tmpInvoiceBillet
define temp-table tmpInvoiceBillet no-undo
field id-fatura-aux as int
field cd-contratante like fatura.cd-contratante
field nr-fatura like fatura.nr-fatura
field in-tipo-fatura like fatura.in-tipo-fatura
field nr-titulo-acr like fatura.nr-titulo-acr
field cd-parcela like fatura.parcela
field cd-especie like fatura.cd-especie
field aa-referencia like fatura.aa-referencia
field mm-referencia like fatura.mm-referencia
field vl-total like fatura.vl-total
field dt-emissao like fatura.dt-emissao
field dt-vencimento like fatura.dt-vencimento
field dt-pagamento as date
field dt-competencia as char
field dt-processamento-fat as date
field lg-debito-automatico as log
field lg-debito-producao as log
field lg-fatura-paga as log
field lg-simulacao as log
field qtd-meses-inadim as int
field cod-usuario as char
field cod-senha as char
field nm-arquivo as char
field cod-campo-custom1 as char
index tmpInvoiceBillet01
id-fatura-aux
cd-contratante.
h-tmpBilletMoviment
define temp-table tmpBilletMoviment no-undo
field id-nota-aux as int
field cd-carteira-inteira like car-ide.cd-carteira-inteira
field nm-usuario like usuario.nm-usuario
field dt-realizacao like mov-insu.dt-realizacao
field nm-prestador like preserv.nm-prestador
field nr-documento as char
field ds-servico as char /* ds-insumo ou ds-procedimento */
field qt-servico as int /* qt-insumo ou qt-procedimento */
field vl-evento like fateveco.vl-evento
field nr-rowid-mov as char
field cd-tipo-insumo like mov-insu.cd-tipo-insumo
field cd-pacote like mov-insu.cd-pacote
field in-tipo-nota like notaserv.in-tipo-nota
field char-20 like preserv.char-20
field char-4 like moviproc.char-4
field cd-unidade-prestadora like moviproc.cd-unidade-prestadora
index tmpBilletMoviment01
is primary id-nota-aux
index tmpBilletMoviment02
id-nota-aux
cd-carteira-inteira
nr-documento
cd-pacote
index tmpBilletMoviment03
id-nota-aux
cd-carteira-inteira
nr-documento
cd-tipo-insumo
index tmpBilletMoviment04
id-nota-aux
nr-rowid-mov.
h-tmpCollectingBank
def temp-table tmpCollectingBank no-undo
field cod-portador like portad_bco.cod_portador
field cod-cart-bcia like portad_bco.cod_cart_bcia
field nom-pessoa like portador.nom_pessoa
field des-cart-bcia like cart_bcia.des_cart_bcia.
h-tmpBillet
define temp-table tmpBillet no-undo
field id-fatura-aux as int
field id-nota-aux as int
field cd-modalidade like notaserv.cd-modalidade
field nr-ter-adesao like notaserv.nr-ter-adesao
field cd-convenio like propost.cd-convenio
field in-tipo-nota like notaserv.in-tipo-nota
field vl-total like notaserv.vl-total
field cdn-plano-ans as char
field cd-plano like pla-sau.cd-plano
field nm-plano as char
field cd-tipo-plano like ti-pl-sa.cd-tipo-plano
field nm-tipo-plano as char
field dt-inicio-contrato like ter-ade.dt-inicio
field cd-contrat-origem like propost.cd-contrat-origem
field nm-contratante-origem like contrat.nm-contratante
field cdn-lotac like lotac.cdn-lotac
field des-lotac like lotac.des-lotac
index tmpBillet01
id-fatura-aux
id-nota-aux.
h-tmpBearer
define temp-table tmpBearer no-undo
field bearerCode as character
field bearerDescription as character.
h-tmpModality
define temp-table tmpModality no-undo
field modalityCode as character
field modalityDescription as character.
h-tmpBilletIRDemonstrative
define temp-table tmpBilletIRDemonstrative no-undo
field cd-contratante like contrat.cd-contratante
field nm-usuario as char
field cd-cpf-usuario as char
field dt-nascimento as date
field vl-pago as dec
index tmpBilletIRDemonstrative01
cd-contratante.
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas