Tabela SE2 no Protheus

A tabela SE2 do Protheus está descrita no dicionário (SX2) como “Contas a Pagar”. Possui 247 campos e 17 índices e chave única E2_FILIAL+E2_PREFIXO+E2_NUM+E2_PARCELA+E2_TIPO+E2_FORNECE+E2_LOJA. Abaixo estão tipo, tamanho e descrição de cada campo, os índices e um exemplo de consulta SQL.

Propriedades da tabela

Código

SE2

Nome

Contas a Pagar

Nome (inglês)

Accounts Payable

Compartilhamento por filial

Exclusivo

Compartilhamento por unidade

Exclusivo

Compartilhamento por empresa

Exclusivo

Chave única

E2_FILIAL+E2_PREFIXO+E2_NUM+E2_PARCELA+E2_TIPO+E2_FORNECE+E2_LOJA

Campos / índices

247 / 17

Perguntas frequentes sobre a tabela SE2

O que é a tabela SE2?

É a tabela “Contas a Pagar” do ERP TOTVS Protheus, com 247 campos definidos no dicionário SX3.

Qual é a chave única da tabela SE2?

A chave única é E2_FILIAL+E2_PREFIXO+E2_NUM+E2_PARCELA+E2_TIPO+E2_FORNECE+E2_LOJA.

Quais são os índices da tabela SE2?

A tabela tem 17 índices. O principal (ordem 1) usa a chave E2_FILIAL+E2_PREFIXO+E2_NUM+E2_PARCELA+E2_TIPO+E2_FORNECE+E2_LOJA.

Qual é o nome físico da tabela SE2 no banco de dados?

No banco, o nome é o código da tabela seguido do código da empresa (no dicionário de referência desta consulta: SE2990). Em ADVPL, use RetSqlName("SE2") para obter o nome correto do ambiente.

Exemplo de consulta SQL da tabela SE2

Modelo gerado a partir da estrutura da tabela. Ajuste os filtros ao seu cenário.

SELECT
    E2_FILIAL,
    E2_PREFIXO,
    E2_NUM,
    E2_PARCELA,
    E2_TIPO,
    E2_NATUREZ,
    E2_PORTADO,
    E2_FORNECE,
    E2_LOJA,
    E2_NOMFOR,
    E2_EMISSAO,
    E2_VENCTO,
    E2_VENCREA,
    E2_VALOR,
    E2_ISS,
    E2_IRRF,
    E2_NUMBCO,
    E2_INDICE,
    E2_BAIXA,
    E2_BCOPAG,
    E2_EMIS1,
    E2_HIST,
    E2_LA,
    E2_LOTE,
    E2_MOTIVO,
    E2_MOVIMEN,
    E2_OP,
    E2_SALDO,
    E2_OK,
    E2_DESCONT,
    E2_MULTA,
    E2_JUROS,
    E2_CORREC,
    E2_VALLIQ,
    E2_VENCORI,
    E2_VALJUR,
    E2_PORCJUR,
    E2_MOEDA,
    E2_NUMBOR,
    E2_FATPREF,
    E2_FATURA,
    E2_PROJETO,
    E2_CLASCON,
    E2_RATEIO,
    E2_DTVARIA,
    E2_VARURV,
    E2_VLCRUZ,
    E2_DTFATUR,
    E2_ACRESC,
    E2_TITORIG,
    E2_IMPCHEQ,
    E2_PARCIR,
    E2_ARQRAT,
    E2_OCORREN,
    E2_ORIGEM,
    E2_IDENTEE,
    E2_FLUXO,
    E2_PARCISS,
    E2_ORDPAGO,
    E2_DESDOBR,
    E2_INSS,
    E2_PARCINS,
    E2_NUMLIQ,
    E2_BCOCHQ,
    E2_AGECHQ,
    E2_CTACHQ,
    E2_DATALIB,
    E2_APROVA,
    E2_TIPOFAT,
    E2_FLAGFAT,
    E2_ANOBASE,
    E2_MESBASE,
    E2_TXMOEDA,
    E2_SDACRES,
    E2_DECRESC,
    E2_SDDECRE,
    E2_USUALIB,
    E2_MULTNAT,
    E2_NUMTIT,
    E2_PROJPMS,
    E2_PLLOTE,
    E2_DIRF,
    E2_CODRET,
    E2_MODSPB,
    E2_IDCNAB,
    E2_PARCCSS,
    E2_RETENC,
    E2_CONTAD,
    E2_CODORCA,
    E2_SEST,
    E2_DOCHAB,
    E2_PARCSES,
    E2_FILDEB,
    E2_FILORIG,
    E2_FORNISS,
    E2_LOJAISS,
    E2_DEBITO,
    E2_CCD,
    E2_ITEMD,
    E2_CLVLDB,
    E2_CREDIT,
    E2_CCC,
    E2_ITEMC,
    E2_CLVLCR,
    E2_COFINS,
    E2_PIS,
    E2_CSLL,
    E2_PARCCOF,
    E2_PARCPIS,
    E2_PARCSLL,
    E2_TITPIS,
    E2_TITCOF,
    E2_TITCSL,
    E2_TITINS,
    E2_VRETPIS,
    E2_VRETCOF,
    E2_VRETCSL,
    E2_PRETPIS,
    E2_PRETCOF,
    E2_PRETCSL,
    E2_SEQBX,
    E2_CODBAR,
    E2_LINDIG,
    E2_BASEPIS,
    E2_BASECSL,
    E2_VRETISS,
    E2_VENCISS,
    E2_VBASISS,
    E2_MDRTISS,
    E2_VARIAC,
    E2_PERIOD,
    E2_MDCONTR,
    E2_MDREVIS,
    E2_MDPLANI,
    E2_MDCRON,
    E2_MDPARCE,
    E2_FRETISS,
    E2_TXMDCOR,
    E2_APLVLMN,
    E2_CLEARIN,
    E2_HORASPB,
    E2_PRETIRF,
    E2_SEFIP,
    E2_TRETISS,
    E2_VRETIRF,
    E2_PLOPELT,
    E2_CODRDA,
    E2_PARCFET,
    E2_FETHAB,
    E2_FORORI,
    E2_LOJORI,
    E2_STATUS,
    E2_DTDIRF,
    E2_TITADT,
    E2_TITPAI,
    E2_INSSRET,
    E2_CODAGL,
    E2_PROCPCC,
    E2_FORNPAI,
    E2_CODISS,
    E2_USUASUS,
    E2_USUACAN,
    E2_DATASUS,
    E2_DATACAN,
    E2_LIMCAN,
    E2_FORBCO,
    E2_FORAGE,
    E2_FAGEDV,
    E2_FORCTA,
    E2_FCTADV,
    E2_PREOP,
    E2_DTAPUR,
    E2_NROREF,
    E2_NOMERET,
    E2_TPINSC,
    E2_PARCIMA,
    E2_IMA,
    E2_BASEISS,
    E2_NUMPRO,
    E2_INDPRO,
    E2_CCUSTO,
    E2_VRETINS,
    E2_IDMOV,
    E2_CIDE,
    E2_PRETINS,
    E2_BASEIRF,
    E2_NFELETR,
    E2_FIMP,
    E2_PARCAGL,
    E2_TPESOC,
    E2_MDMULT,
    E2_MDBONI,
    E2_FATFOR,
    E2_FATLOJ,
    E2_MDDESC,
    E2_RETCNTR,
    E2_STATLIB,
    E2_BASECOF,
    E2_CODAPRO,
    E2_TEMDOCS,
    E2_NODIA,
    E2_DIACTB,
    E2_FAMAD,
    E2_FMPEQ,
    E2_PARCFAM,
    E2_PARCFMP,
    E2_DATAAGE,
    E2_FORMPAG,
    E2_CLVL,
    E2_ITEMCTA,
    E2_RETINS,
    E2_PRINSS,
    E2_MEDNUME,
    E2_BASEINS,
    E2_TIPOLIQ,
    E2_TPDESC,
    E2_PARCFAC,
    E2_NUMSOL,
    E2_PRISS,
    E2_DTBORDE,
    E2_BTRISS,
    E2_CODINS,
    E2_PARCFAB,
    E2_CNO,
    E2_CODSERV,
    E2_VRETBIS,
    E2_PARIMP1,
    E2_PARIMP2,
    E2_CNPJRET,
    E2_FACS,
    E2_PARIMP3,
    E2_IDDARF,
    E2_FABOV,
    E2_MSIDENT,
    E2_NOMOPE,
    E2_PARIMP4,
    E2_PARIMP5,
    E2_CODOPE,
    E2_CODRCSL,
    E2_PARCCID,
    E2_CODRPIS,
    E2_CODRCOF,
    E2_AGLIMP,
    E2_EC05DB,
    E2_EC05CR,
    E2_EC06DB,
    E2_EC06CR
FROM SE2
WHERE
    D_E_L_E_T_ = ' '
    AND E2_FILIAL = 'VALOR'
    AND E2_PREFIXO = 'VALOR'
    AND E2_NUM = 'VALOR'
    AND E2_PARCELA = 'VALOR'
    AND E2_TIPO = 'VALOR'
    AND E2_NATUREZ = 'VALOR'
    AND E2_PORTADO = 'VALOR'
    AND E2_FORNECE = 'VALOR'
    AND E2_LOJA = 'VALOR'
    AND E2_NOMFOR = 'VALOR'
    AND E2_EMISSAO BETWEEN '20261001' AND '20261031'
    AND E2_VENCTO BETWEEN '20261001' AND '20261031'
    AND E2_VENCREA BETWEEN '20261001' AND '20261031'
    AND E2_VALOR = 0
    AND E2_ISS = 0
    AND E2_IRRF = 0
    AND E2_NUMBCO = 'VALOR'
    AND E2_INDICE = 'VALOR'
    AND E2_BAIXA BETWEEN '20261001' AND '20261031'
    AND E2_BCOPAG = 'VALOR'
    AND E2_EMIS1 BETWEEN '20261001' AND '20261031'
    AND E2_HIST = 'VALOR'
    AND E2_LA = 'VALOR'
    AND E2_LOTE = 'VALOR'
    AND E2_MOTIVO = 'VALOR'
    AND E2_MOVIMEN BETWEEN '20261001' AND '20261031'
    AND E2_OP = 'VALOR'
    AND E2_SALDO = 0
    AND E2_OK = 'VALOR'
    AND E2_DESCONT = 0
    AND E2_MULTA = 0
    AND E2_JUROS = 0
    AND E2_CORREC = 0
    AND E2_VALLIQ = 0
    AND E2_VENCORI BETWEEN '20261001' AND '20261031'
    AND E2_VALJUR = 0
    AND E2_PORCJUR = 0
    AND E2_MOEDA = 0
    AND E2_NUMBOR = 'VALOR'
    AND E2_FATPREF = 'VALOR'
    AND E2_FATURA = 'VALOR'
    AND E2_PROJETO = 'VALOR'
    AND E2_CLASCON = 'VALOR'
    AND E2_RATEIO = 'VALOR'
    AND E2_DTVARIA BETWEEN '20261001' AND '20261031'
    AND E2_VARURV = 0
    AND E2_VLCRUZ = 0
    AND E2_DTFATUR BETWEEN '20261001' AND '20261031'
    AND E2_ACRESC = 0
    AND E2_TITORIG = 'VALOR'
    AND E2_IMPCHEQ = 'VALOR'
    AND E2_PARCIR = 'VALOR'
    AND E2_ARQRAT = 'VALOR'
    AND E2_OCORREN = 'VALOR'
    AND E2_ORIGEM = 'VALOR'
    AND E2_IDENTEE = 'VALOR'
    AND E2_FLUXO = 'VALOR'
    AND E2_PARCISS = 'VALOR'
    AND E2_ORDPAGO = 'VALOR'
    AND E2_DESDOBR = 'VALOR'
    AND E2_INSS = 0
    AND E2_PARCINS = 'VALOR'
    AND E2_NUMLIQ = 'VALOR'
    AND E2_BCOCHQ = 'VALOR'
    AND E2_AGECHQ = 'VALOR'
    AND E2_CTACHQ = 'VALOR'
    AND E2_DATALIB BETWEEN '20261001' AND '20261031'
    AND E2_APROVA = 'VALOR'
    AND E2_TIPOFAT = 'VALOR'
    AND E2_FLAGFAT = 'VALOR'
    AND E2_ANOBASE = 'VALOR'
    AND E2_MESBASE = 'VALOR'
    AND E2_TXMOEDA = 0
    AND E2_SDACRES = 0
    AND E2_DECRESC = 0
    AND E2_SDDECRE = 0
    AND E2_USUALIB = 'VALOR'
    AND E2_MULTNAT = 'VALOR'
    AND E2_NUMTIT = 'VALOR'
    AND E2_PROJPMS = 'VALOR'
    AND E2_PLLOTE = 'VALOR'
    AND E2_DIRF = 'VALOR'
    AND E2_CODRET = 'VALOR'
    AND E2_MODSPB = 'VALOR'
    AND E2_IDCNAB = 'VALOR'
    AND E2_PARCCSS = 'VALOR'
    AND E2_RETENC = 0
    AND E2_CONTAD = 'VALOR'
    AND E2_CODORCA = 'VALOR'
    AND E2_SEST = 0
    AND E2_DOCHAB = 'VALOR'
    AND E2_PARCSES = 'VALOR'
    AND E2_FILDEB = 'VALOR'
    AND E2_FILORIG = 'VALOR'
    AND E2_FORNISS = 'VALOR'
    AND E2_LOJAISS = 'VALOR'
    AND E2_DEBITO = 'VALOR'
    AND E2_CCD = 'VALOR'
    AND E2_ITEMD = 'VALOR'
    AND E2_CLVLDB = 'VALOR'
    AND E2_CREDIT = 'VALOR'
    AND E2_CCC = 'VALOR'
    AND E2_ITEMC = 'VALOR'
    AND E2_CLVLCR = 'VALOR'
    AND E2_COFINS = 0
    AND E2_PIS = 0
    AND E2_CSLL = 0
    AND E2_PARCCOF = 'VALOR'
    AND E2_PARCPIS = 'VALOR'
    AND E2_PARCSLL = 'VALOR'
    AND E2_TITPIS = 'VALOR'
    AND E2_TITCOF = 'VALOR'
    AND E2_TITCSL = 'VALOR'
    AND E2_TITINS = 'VALOR'
    AND E2_VRETPIS = 0
    AND E2_VRETCOF = 0
    AND E2_VRETCSL = 0
    AND E2_PRETPIS = 'VALOR'
    AND E2_PRETCOF = 'VALOR'
    AND E2_PRETCSL = 'VALOR'
    AND E2_SEQBX = 'VALOR'
    AND E2_CODBAR = 'VALOR'
    AND E2_LINDIG = 'VALOR'
    AND E2_BASEPIS = 0
    AND E2_BASECSL = 0
    AND E2_VRETISS = 0
    AND E2_VENCISS BETWEEN '20261001' AND '20261031'
    AND E2_VBASISS = 0
    AND E2_MDRTISS = 'VALOR'
    AND E2_VARIAC = 0
    AND E2_PERIOD = 'VALOR'
    AND E2_MDCONTR = 'VALOR'
    AND E2_MDREVIS = 'VALOR'
    AND E2_MDPLANI = 'VALOR'
    AND E2_MDCRON = 'VALOR'
    AND E2_MDPARCE = 'VALOR'
    AND E2_FRETISS = 'VALOR'
    AND E2_TXMDCOR = 0
    AND E2_APLVLMN = 'VALOR'
    AND E2_CLEARIN = 'VALOR'
    AND E2_HORASPB = 'VALOR'
    AND E2_PRETIRF = 'VALOR'
    AND E2_SEFIP = 'VALOR'
    AND E2_TRETISS = 'VALOR'
    AND E2_VRETIRF = 0
    AND E2_PLOPELT = 'VALOR'
    AND E2_CODRDA = 'VALOR'
    AND E2_PARCFET = 'VALOR'
    AND E2_FETHAB = 0
    AND E2_FORORI = 'VALOR'
    AND E2_LOJORI = 'VALOR'
    AND E2_STATUS = 'VALOR'
    AND E2_DTDIRF BETWEEN '20261001' AND '20261031'
    AND E2_TITADT = 'VALOR'
    AND E2_TITPAI = 'VALOR'
    AND E2_INSSRET = 0
    AND E2_CODAGL = 'VALOR'
    AND E2_PROCPCC = 'VALOR'
    AND E2_FORNPAI = 'VALOR'
    AND E2_CODISS = 'VALOR'
    AND E2_USUASUS = 'VALOR'
    AND E2_USUACAN = 'VALOR'
    AND E2_DATASUS BETWEEN '20261001' AND '20261031'
    AND E2_DATACAN BETWEEN '20261001' AND '20261031'
    AND E2_LIMCAN BETWEEN '20261001' AND '20261031'
    AND E2_FORBCO = 'VALOR'
    AND E2_FORAGE = 'VALOR'
    AND E2_FAGEDV = 'VALOR'
    AND E2_FORCTA = 'VALOR'
    AND E2_FCTADV = 'VALOR'
    AND E2_PREOP = 'VALOR'
    AND E2_DTAPUR BETWEEN '20261001' AND '20261031'
    AND E2_NROREF = 'VALOR'
    AND E2_NOMERET = 'VALOR'
    AND E2_TPINSC = 'VALOR'
    AND E2_PARCIMA = 'VALOR'
    AND E2_IMA = 0
    AND E2_BASEISS = 0
    AND E2_NUMPRO = 'VALOR'
    AND E2_INDPRO = 'VALOR'
    AND E2_CCUSTO = 'VALOR'
    AND E2_VRETINS = 0
    AND E2_IDMOV = 'VALOR'
    AND E2_CIDE = 0
    AND E2_PRETINS = 'VALOR'
    AND E2_BASEIRF = 0
    AND E2_NFELETR = 'VALOR'
    AND E2_FIMP = 'VALOR'
    AND E2_PARCAGL = 'VALOR'
    AND E2_TPESOC = 'VALOR'
    AND E2_MDMULT = 0
    AND E2_MDBONI = 0
    AND E2_FATFOR = 'VALOR'
    AND E2_FATLOJ = 'VALOR'
    AND E2_MDDESC = 0
    AND E2_RETCNTR = 0
    AND E2_STATLIB = 'VALOR'
    AND E2_BASECOF = 0
    AND E2_CODAPRO = 'VALOR'
    AND E2_TEMDOCS = 'VALOR'
    AND E2_NODIA = 'VALOR'
    AND E2_DIACTB = 'VALOR'
    AND E2_FAMAD = 0
    AND E2_FMPEQ = 0
    AND E2_PARCFAM = 'VALOR'
    AND E2_PARCFMP = 'VALOR'
    AND E2_DATAAGE BETWEEN '20261001' AND '20261031'
    AND E2_FORMPAG = 'VALOR'
    AND E2_CLVL = 'VALOR'
    AND E2_ITEMCTA = 'VALOR'
    AND E2_RETINS = 'VALOR'
    AND E2_PRINSS = 0
    AND E2_MEDNUME = 'VALOR'
    AND E2_BASEINS = 0
    AND E2_TIPOLIQ = 'VALOR'
    AND E2_TPDESC = 'VALOR'
    AND E2_PARCFAC = 'VALOR'
    AND E2_NUMSOL = 'VALOR'
    AND E2_PRISS = 0
    AND E2_DTBORDE BETWEEN '20261001' AND '20261031'
    AND E2_BTRISS = 0
    AND E2_CODINS = 'VALOR'
    AND E2_PARCFAB = 'VALOR'
    AND E2_CNO = 'VALOR'
    AND E2_CODSERV = 'VALOR'
    AND E2_VRETBIS = 0
    AND E2_PARIMP1 = 'VALOR'
    AND E2_PARIMP2 = 'VALOR'
    AND E2_CNPJRET = 'VALOR'
    AND E2_FACS = 0
    AND E2_PARIMP3 = 'VALOR'
    AND E2_IDDARF = 'VALOR'
    AND E2_FABOV = 0
    AND E2_MSIDENT = 'VALOR'
    AND E2_NOMOPE = 'VALOR'
    AND E2_PARIMP4 = 'VALOR'
    AND E2_PARIMP5 = 'VALOR'
    AND E2_CODOPE = 'VALOR'
    AND E2_CODRCSL = 'VALOR'
    AND E2_PARCCID = 'VALOR'
    AND E2_CODRPIS = 'VALOR'
    AND E2_CODRCOF = 'VALOR'
    AND E2_AGLIMP = 'VALOR'
    AND E2_EC05DB = 'VALOR'
    AND E2_EC05CR = 'VALOR'
    AND E2_EC06DB = 'VALOR'
    AND E2_EC06CR = 'VALOR'

Outras tabelas relacionadas

• SE0 Cotações Diarias por Contrato
• SE1 Contas a Receber
• SE3 Comissões de Vendas
• SE4 Condições de Pagamento
• SE5 Movimentação Bancaria
• SE6 Solicitação de Transferência
• SE7 Orçamentos
• SE8 Saldos Bancários
• SE9 Contratos Bancários
• SEA Títulos Enviados ao Banco
• SEB Ocorrências da Transm Bancária
• SEC Desmembramento de Cond Pagto

Dicionário Protheus · atualizado em 13/10/2026. Voltar ao índice do dicionário.