Tabela SE1 no Protheus

A tabela SE1 do Protheus está descrita no dicionário (SX2) como “Contas a Receber”. Possui 277 campos e 28 índices e chave única E1_FILIAL+E1_PREFIXO+E1_NUM+E1_PARCELA+E1_TIPO. Abaixo estão tipo, tamanho e descrição de cada campo, os índices e um exemplo de consulta SQL.

Propriedades da tabela

Código

SE1

Nome

Contas a Receber

Nome (inglês)

Accounts Receivable

Compartilhamento por filial

Exclusivo

Compartilhamento por unidade

Exclusivo

Compartilhamento por empresa

Exclusivo

Chave única

E1_FILIAL+E1_PREFIXO+E1_NUM+E1_PARCELA+E1_TIPO

Campos / índices

277 / 28

Perguntas frequentes sobre a tabela SE1

O que é a tabela SE1?

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

Qual é a chave única da tabela SE1?

A chave única é E1_FILIAL+E1_PREFIXO+E1_NUM+E1_PARCELA+E1_TIPO.

Quais são os índices da tabela SE1?

A tabela tem 28 índices. O principal (ordem 1) usa a chave E1_FILIAL+E1_PREFIXO+E1_NUM+E1_PARCELA+E1_TIPO.

Qual é o nome físico da tabela SE1 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: SE1990). Em ADVPL, use RetSqlName("SE1") para obter o nome correto do ambiente.

Exemplo de consulta SQL da tabela SE1

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

SELECT
    E1_FILIAL,
    E1_PREFIXO,
    E1_NUM,
    E1_PARCELA,
    E1_TIPO,
    E1_NATUREZ,
    E1_PORTADO,
    E1_AGEDEP,
    E1_CLIENTE,
    E1_LOJA,
    E1_NOMCLI,
    E1_EMISSAO,
    E1_VENCTO,
    E1_VENCREA,
    E1_VALOR,
    E1_BASEIRF,
    E1_ISS,
    E1_IRRF,
    E1_NUMBCO,
    E1_INDICE,
    E1_BAIXA,
    E1_NUMBOR,
    E1_DATABOR,
    E1_EMIS1,
    E1_HIST,
    E1_LA,
    E1_LOTE,
    E1_MOTIVO,
    E1_MOVIMEN,
    E1_OP,
    E1_SITUACA,
    E1_CONTRAT,
    E1_SALDO,
    E1_SUPERVI,
    E1_VEND1,
    E1_VEND2,
    E1_VEND3,
    E1_VEND4,
    E1_VEND5,
    E1_COMIS1,
    E1_COMIS2,
    E1_COMIS3,
    E1_COMIS4,
    E1_DESCONT,
    E1_COMIS5,
    E1_MULTA,
    E1_JUROS,
    E1_CORREC,
    E1_VALLIQ,
    E1_VENCORI,
    E1_CONTA,
    E1_VALJUR,
    E1_PORCJUR,
    E1_MOEDA,
    E1_BASCOM1,
    E1_BASCOM2,
    E1_BASCOM3,
    E1_BASCOM4,
    E1_BASCOM5,
    E1_FATPREF,
    E1_FATURA,
    E1_OK,
    E1_PROJETO,
    E1_CLASCON,
    E1_VALCOM1,
    E1_VALCOM2,
    E1_VALCOM3,
    E1_VALCOM4,
    E1_VALCOM5,
    E1_OCORREN,
    E1_INSTR1,
    E1_INSTR2,
    E1_PEDIDO,
    E1_DTVARIA,
    E1_VARURV,
    E1_VLCRUZ,
    E1_DTFATUR,
    E1_NUMNOTA,
    E1_SERIE,
    E1_STATUS,
    E1_ORIGEM,
    E1_IDENTEE,
    E1_NUMCART,
    E1_FLUXO,
    E1_DESCFIN,
    E1_DIADESC,
    E1_TIPODES,
    E1_CARTAO,
    E1_CARTVAL,
    E1_CARTAUT,
    E1_ADM,
    E1_VLRREAL,
    E1_TRANSF,
    E1_BCOCHQ,
    E1_AGECHQ,
    E1_CTACHQ,
    E1_NUMLIQ,
    E1_ORDPAGO,
    E1_RECIBO,
    E1_INSS,
    E1_FILORIG,
    E1_DTACRED,
    E1_TIPOFAT,
    E1_TIPOLIQ,
    E1_CSLL,
    E1_COFINS,
    E1_PIS,
    E1_FLAGFAT,
    E1_MESBASE,
    E1_ANOBASE,
    E1_PLNUCOB,
    E1_CODINT,
    E1_CODEMP,
    E1_MATRIC,
    E1_TXMOEDA,
    E1_ACRESC,
    E1_SDACRES,
    E1_DECRESC,
    E1_SDDECRE,
    E1_MULTNAT,
    E1_MSFIL,
    E1_MSEMP,
    E1_PROJPMS,
    E1_DESDOBR,
    E1_NRDOC,
    E1_MODSPB,
    E1_EMITCHQ,
    E1_IDCNAB,
    E1_PLCOEMP,
    E1_PLTPCOE,
    E1_CODCOR,
    E1_PARCCSS,
    E1_CODORCA,
    E1_CODIMOV,
    E1_FILDEB,
    E1_NUMSOL,
    E1_NUMRA,
    E1_INSCRIC,
    E1_SERREC,
    E1_DATAEDI,
    E1_CODBAR,
    E1_CHQDEV,
    E1_CODDIG,
    E1_LIDESCF,
    E1_VLBOLSA,
    E1_NUMCRD,
    E1_VLFIES,
    E1_DEBITO,
    E1_CCD,
    E1_ITEMD,
    E1_CLVLDB,
    E1_CREDIT,
    E1_CCC,
    E1_ITEMC,
    E1_CLVLCR,
    E1_DESCON1,
    E1_DESCON2,
    E1_DTDESC3,
    E1_DTDESC1,
    E1_DTDESC2,
    E1_VLMULTA,
    E1_DESCON3,
    E1_MOTNEG,
    E1_SABTPIS,
    E1_SABTCOF,
    E1_SABTCSL,
    E1_FORNISS,
    E1_PARTOT,
    E1_SITFAT,
    E1_BASEPIS,
    E1_BASECOF,
    E1_BASECSL,
    E1_VRETISS,
    E1_PARCIRF,
    E1_SCORGP,
    E1_FRETISS,
    E1_TXMDCOR,
    E1_SATBIRF,
    E1_TIPREG,
    E1_CONEMP,
    E1_VERCON,
    E1_SUBCON,
    E1_VERSUB,
    E1_PLLOTE,
    E1_PLOPELT,
    E1_CODRDA,
    E1_FORMREC,
    E1_BCOCLI,
    E1_AGECLI,
    E1_CTACLI,
    E1_PARCFET,
    E1_FETHAB,
    E1_MDCRON,
    E1_MDCONTR,
    E1_MEDNUME,
    E1_MDPLANI,
    E1_MDPARCE,
    E1_MDREVIS,
    E1_NUMMOV,
    E1_PREFORI,
    E1_IDMOV,
    E1_PARCIMA,
    E1_IMA,
    E1_BOLETO,
    E1_NUMPRO,
    E1_INDPRO,
    E1_PRINSS,
    E1_PARCFAB,
    E1_PARCFAC,
    E1_PARTPDP,
    E1_CODRET,
    E1_TPDESC,
    E1_TPDP,
    E1_VLMINIS,
    E1_ITEMCTA,
    E1_DOCTEF,
    E1_BASEINS,
    E1_RETCNTR,
    E1_CDRETIR,
    E1_CDRETCS,
    E1_TITPAI,
    E1_PARCFMP,
    E1_PARCFAM,
    E1_FMPEQ,
    E1_FAMAD,
    E1_MULTDIA,
    E1_RATFIN,
    E1_JURFAT,
    E1_MDMULT,
    E1_MDBONI,
    E1_MDDESC,
    E1_NFELETR,
    E1_DESCJUR,
    E1_FABOV,
    E1_FACS,
    E1_CCUSTO,
    E1_CLVL,
    E1_NODIA,
    E1_RELATO,
    E1_NUMCON,
    E1_TCONHTL,
    E1_PRODUTO,
    E1_PERLET,
    E1_VRETIRF,
    E1_SDOCREC,
    E1_LTCXA,
    E1_NOPER,
    E1_CHAVENF,
    E1_SDOC,
    E1_SABTIRF,
    E1_DIACTB,
    E1_IDLAN,
    E1_CNO,
    E1_CODISS,
    E1_NSUTEF,
    E1_APLVLMN,
    E1_CTRBCO,
    E1_PROCEL,
    E1_BTRISS,
    E1_NUMINSC,
    E1_IDBOLET,
    E1_SERVICO,
    E1_VLBOLP,
    E1_IDAPLIC,
    E1_CODIRRF,
    E1_PRISS,
    E1_VRETBIS,
    E1_CONHTL,
    E1_CODSERV,
    E1_TURMA,
    E1_SEQBX,
    E1_TPESOC,
    E1_BASEISS,
    E1_EC05DB,
    E1_EC05CR,
    E1_EC06DB,
    E1_EC06CR
FROM SE1
WHERE
    D_E_L_E_T_ = ' '
    AND E1_FILIAL = 'VALOR'
    AND E1_PREFIXO = 'VALOR'
    AND E1_NUM = 'VALOR'
    AND E1_PARCELA = 'VALOR'
    AND E1_TIPO = 'VALOR'
    AND E1_NATUREZ = 'VALOR'
    AND E1_PORTADO = 'VALOR'
    AND E1_AGEDEP = 'VALOR'
    AND E1_CLIENTE = 'VALOR'
    AND E1_LOJA = 'VALOR'
    AND E1_NOMCLI = 'VALOR'
    AND E1_EMISSAO BETWEEN '20261001' AND '20261031'
    AND E1_VENCTO BETWEEN '20261001' AND '20261031'
    AND E1_VENCREA BETWEEN '20261001' AND '20261031'
    AND E1_VALOR = 0
    AND E1_BASEIRF = 0
    AND E1_ISS = 0
    AND E1_IRRF = 0
    AND E1_NUMBCO = 'VALOR'
    AND E1_INDICE = 'VALOR'
    AND E1_BAIXA BETWEEN '20261001' AND '20261031'
    AND E1_NUMBOR = 'VALOR'
    AND E1_DATABOR BETWEEN '20261001' AND '20261031'
    AND E1_EMIS1 BETWEEN '20261001' AND '20261031'
    AND E1_HIST = 'VALOR'
    AND E1_LA = 'VALOR'
    AND E1_LOTE = 'VALOR'
    AND E1_MOTIVO = 'VALOR'
    AND E1_MOVIMEN BETWEEN '20261001' AND '20261031'
    AND E1_OP = 'VALOR'
    AND E1_SITUACA = 'VALOR'
    AND E1_CONTRAT = 'VALOR'
    AND E1_SALDO = 0
    AND E1_SUPERVI = 'VALOR'
    AND E1_VEND1 = 'VALOR'
    AND E1_VEND2 = 'VALOR'
    AND E1_VEND3 = 'VALOR'
    AND E1_VEND4 = 'VALOR'
    AND E1_VEND5 = 'VALOR'
    AND E1_COMIS1 = 0
    AND E1_COMIS2 = 0
    AND E1_COMIS3 = 0
    AND E1_COMIS4 = 0
    AND E1_DESCONT = 0
    AND E1_COMIS5 = 0
    AND E1_MULTA = 0
    AND E1_JUROS = 0
    AND E1_CORREC = 0
    AND E1_VALLIQ = 0
    AND E1_VENCORI BETWEEN '20261001' AND '20261031'
    AND E1_CONTA = 'VALOR'
    AND E1_VALJUR = 0
    AND E1_PORCJUR = 0
    AND E1_MOEDA = 0
    AND E1_BASCOM1 = 0
    AND E1_BASCOM2 = 0
    AND E1_BASCOM3 = 0
    AND E1_BASCOM4 = 0
    AND E1_BASCOM5 = 0
    AND E1_FATPREF = 'VALOR'
    AND E1_FATURA = 'VALOR'
    AND E1_OK = 'VALOR'
    AND E1_PROJETO = 'VALOR'
    AND E1_CLASCON = 'VALOR'
    AND E1_VALCOM1 = 0
    AND E1_VALCOM2 = 0
    AND E1_VALCOM3 = 0
    AND E1_VALCOM4 = 0
    AND E1_VALCOM5 = 0
    AND E1_OCORREN = 'VALOR'
    AND E1_INSTR1 = 'VALOR'
    AND E1_INSTR2 = 'VALOR'
    AND E1_PEDIDO = 'VALOR'
    AND E1_DTVARIA BETWEEN '20261001' AND '20261031'
    AND E1_VARURV = 0
    AND E1_VLCRUZ = 0
    AND E1_DTFATUR BETWEEN '20261001' AND '20261031'
    AND E1_NUMNOTA = 'VALOR'
    AND E1_SERIE = 'VALOR'
    AND E1_STATUS = 'VALOR'
    AND E1_ORIGEM = 'VALOR'
    AND E1_IDENTEE = 'VALOR'
    AND E1_NUMCART = 'VALOR'
    AND E1_FLUXO = 'VALOR'
    AND E1_DESCFIN = 0
    AND E1_DIADESC = 0
    AND E1_TIPODES = 'VALOR'
    AND E1_CARTAO = 'VALOR'
    AND E1_CARTVAL BETWEEN '20261001' AND '20261031'
    AND E1_CARTAUT = 'VALOR'
    AND E1_ADM = 'VALOR'
    AND E1_VLRREAL = 0
    AND E1_TRANSF = 'VALOR'
    AND E1_BCOCHQ = 'VALOR'
    AND E1_AGECHQ = 'VALOR'
    AND E1_CTACHQ = 'VALOR'
    AND E1_NUMLIQ = 'VALOR'
    AND E1_ORDPAGO = 'VALOR'
    AND E1_RECIBO = 'VALOR'
    AND E1_INSS = 0
    AND E1_FILORIG = 'VALOR'
    AND E1_DTACRED BETWEEN '20261001' AND '20261031'
    AND E1_TIPOFAT = 'VALOR'
    AND E1_TIPOLIQ = 'VALOR'
    AND E1_CSLL = 0
    AND E1_COFINS = 0
    AND E1_PIS = 0
    AND E1_FLAGFAT = 'VALOR'
    AND E1_MESBASE = 'VALOR'
    AND E1_ANOBASE = 'VALOR'
    AND E1_PLNUCOB = 'VALOR'
    AND E1_CODINT = 'VALOR'
    AND E1_CODEMP = 'VALOR'
    AND E1_MATRIC = 'VALOR'
    AND E1_TXMOEDA = 0
    AND E1_ACRESC = 0
    AND E1_SDACRES = 0
    AND E1_DECRESC = 0
    AND E1_SDDECRE = 0
    AND E1_MULTNAT = 'VALOR'
    AND E1_MSFIL = 'VALOR'
    AND E1_MSEMP = 'VALOR'
    AND E1_PROJPMS = 'VALOR'
    AND E1_DESDOBR = 'VALOR'
    AND E1_NRDOC = 'VALOR'
    AND E1_MODSPB = 'VALOR'
    AND E1_EMITCHQ = 'VALOR'
    AND E1_IDCNAB = 'VALOR'
    AND E1_PLCOEMP = 'VALOR'
    AND E1_PLTPCOE = 'VALOR'
    AND E1_CODCOR = 'VALOR'
    AND E1_PARCCSS = 'VALOR'
    AND E1_CODORCA = 'VALOR'
    AND E1_CODIMOV = 'VALOR'
    AND E1_FILDEB = 'VALOR'
    AND E1_NUMSOL = 'VALOR'
    AND E1_NUMRA = 'VALOR'
    AND E1_INSCRIC = 'VALOR'
    AND E1_SERREC = 'VALOR'
    AND E1_DATAEDI BETWEEN '20261001' AND '20261031'
    AND E1_CODBAR = 'VALOR'
    AND E1_CHQDEV = 'VALOR'
    AND E1_CODDIG = 'VALOR'
    AND E1_LIDESCF BETWEEN '20261001' AND '20261031'
    AND E1_VLBOLSA = 0
    AND E1_NUMCRD = 'VALOR'
    AND E1_VLFIES = 0
    AND E1_DEBITO = 'VALOR'
    AND E1_CCD = 'VALOR'
    AND E1_ITEMD = 'VALOR'
    AND E1_CLVLDB = 'VALOR'
    AND E1_CREDIT = 'VALOR'
    AND E1_CCC = 'VALOR'
    AND E1_ITEMC = 'VALOR'
    AND E1_CLVLCR = 'VALOR'
    AND E1_DESCON1 = 0
    AND E1_DESCON2 = 0
    AND E1_DTDESC3 BETWEEN '20261001' AND '20261031'
    AND E1_DTDESC1 BETWEEN '20261001' AND '20261031'
    AND E1_DTDESC2 BETWEEN '20261001' AND '20261031'
    AND E1_VLMULTA = 0
    AND E1_DESCON3 = 0
    AND E1_MOTNEG = 'VALOR'
    AND E1_SABTPIS = 0
    AND E1_SABTCOF = 0
    AND E1_SABTCSL = 0
    AND E1_FORNISS = 'VALOR'
    AND E1_PARTOT = 'VALOR'
    AND E1_SITFAT = 'VALOR'
    AND E1_BASEPIS = 0
    AND E1_BASECOF = 0
    AND E1_BASECSL = 0
    AND E1_VRETISS = 0
    AND E1_PARCIRF = 'VALOR'
    AND E1_SCORGP = 'VALOR'
    AND E1_FRETISS = 'VALOR'
    AND E1_TXMDCOR = 0
    AND E1_SATBIRF = 0
    AND E1_TIPREG = 'VALOR'
    AND E1_CONEMP = 'VALOR'
    AND E1_VERCON = 'VALOR'
    AND E1_SUBCON = 'VALOR'
    AND E1_VERSUB = 'VALOR'
    AND E1_PLLOTE = 'VALOR'
    AND E1_PLOPELT = 'VALOR'
    AND E1_CODRDA = 'VALOR'
    AND E1_FORMREC = 'VALOR'
    AND E1_BCOCLI = 'VALOR'
    AND E1_AGECLI = 'VALOR'
    AND E1_CTACLI = 'VALOR'
    AND E1_PARCFET = 'VALOR'
    AND E1_FETHAB = 0
    AND E1_MDCRON = 'VALOR'
    AND E1_MDCONTR = 'VALOR'
    AND E1_MEDNUME = 'VALOR'
    AND E1_MDPLANI = 'VALOR'
    AND E1_MDPARCE = 'VALOR'
    AND E1_MDREVIS = 'VALOR'
    AND E1_NUMMOV = 'VALOR'
    AND E1_PREFORI = 'VALOR'
    AND E1_IDMOV = 'VALOR'
    AND E1_PARCIMA = 'VALOR'
    AND E1_IMA = 0
    AND E1_BOLETO = 'VALOR'
    AND E1_NUMPRO = 'VALOR'
    AND E1_INDPRO = 'VALOR'
    AND E1_PRINSS = 0
    AND E1_PARCFAB = 'VALOR'
    AND E1_PARCFAC = 'VALOR'
    AND E1_PARTPDP = 'VALOR'
    AND E1_CODRET = 'VALOR'
    AND E1_TPDESC = 'VALOR'
    AND E1_TPDP = 0
    AND E1_VLMINIS = 'VALOR'
    AND E1_ITEMCTA = 'VALOR'
    AND E1_DOCTEF = 'VALOR'
    AND E1_BASEINS = 0
    AND E1_RETCNTR = 0
    AND E1_CDRETIR = 'VALOR'
    AND E1_CDRETCS = 'VALOR'
    AND E1_TITPAI = 'VALOR'
    AND E1_PARCFMP = 'VALOR'
    AND E1_PARCFAM = 'VALOR'
    AND E1_FMPEQ = 0
    AND E1_FAMAD = 0
    AND E1_MULTDIA = 0
    AND E1_RATFIN = 'VALOR'
    AND E1_JURFAT = 'VALOR'
    AND E1_MDMULT = 0
    AND E1_MDBONI = 0
    AND E1_MDDESC = 0
    AND E1_NFELETR = 'VALOR'
    AND E1_DESCJUR = 0
    AND E1_FABOV = 0
    AND E1_FACS = 0
    AND E1_CCUSTO = 'VALOR'
    AND E1_CLVL = 'VALOR'
    AND E1_NODIA = 'VALOR'
    AND E1_RELATO = 'VALOR'
    AND E1_NUMCON = 'VALOR'
    AND E1_TCONHTL = 'VALOR'
    AND E1_PRODUTO = 'VALOR'
    AND E1_PERLET = 'VALOR'
    AND E1_VRETIRF = 0
    AND E1_SDOCREC = 'VALOR'
    AND E1_LTCXA = 'VALOR'
    AND E1_NOPER = 0
    AND E1_CHAVENF = 'VALOR'
    AND E1_SDOC = 'VALOR'
    AND E1_SABTIRF = 0
    AND E1_DIACTB = 'VALOR'
    AND E1_IDLAN = 0
    AND E1_CNO = 'VALOR'
    AND E1_CODISS = 'VALOR'
    AND E1_NSUTEF = 'VALOR'
    AND E1_APLVLMN = 'VALOR'
    AND E1_CTRBCO = 'VALOR'
    AND E1_PROCEL = 0
    AND E1_BTRISS = 0
    AND E1_NUMINSC = 0
    AND E1_IDBOLET = 0
    AND E1_SERVICO = 'VALOR'
    AND E1_VLBOLP = 0
    AND E1_IDAPLIC = 0
    AND E1_CODIRRF = 'VALOR'
    AND E1_PRISS = 0
    AND E1_VRETBIS = 0
    AND E1_CONHTL = 'VALOR'
    AND E1_CODSERV = 'VALOR'
    AND E1_TURMA = 'VALOR'
    AND E1_SEQBX = 'VALOR'
    AND E1_TPESOC = 'VALOR'
    AND E1_BASEISS = 0
    AND E1_EC05DB = 'VALOR'
    AND E1_EC05CR = 'VALOR'
    AND E1_EC06DB = 'VALOR'
    AND E1_EC06CR = 'VALOR'

Outras tabelas relacionadas

• SE0 Cotações Diarias por Contrato
• SE2 Contas a Pagar
• 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.