Tabela SF4 no Protheus

A tabela SF4 do Protheus está descrita no dicionário (SX2) como “Tipos de Entrada e Saida”. Possui 287 campos e 4 índices e chave única F4_FILIAL+F4_CODIGO. Abaixo estão tipo, tamanho e descrição de cada campo, os índices e um exemplo de consulta SQL.

Propriedades da tabela

Código

SF4

Nome

Tipos de Entrada e Saida

Nome (inglês)

Types of Inflow and Outflow

Compartilhamento por filial

Exclusivo

Compartilhamento por unidade

Exclusivo

Compartilhamento por empresa

Exclusivo

Chave única

F4_FILIAL+F4_CODIGO

Campos / índices

287 / 4

Perguntas frequentes sobre a tabela SF4

O que é a tabela SF4?

É a tabela “Tipos de Entrada e Saida” do ERP TOTVS Protheus, com 287 campos definidos no dicionário SX3.

Qual é a chave única da tabela SF4?

A chave única é F4_FILIAL+F4_CODIGO.

Quais são os índices da tabela SF4?

A tabela tem 4 índices. O principal (ordem 1) usa a chave F4_FILIAL+F4_CODIGO.

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

Exemplo de consulta SQL da tabela SF4

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

SELECT
    F4_FCALCPR,
    F4_DEDDIF,
    F4_CRDICMA,
    F4_FILIAL,
    F4_CODIGO,
    F4_TIPO,
    F4_ICM,
    F4_IPI,
    F4_CREDICM,
    F4_CREDIPI,
    F4_DUPLIC,
    F4_ESTOQUE,
    F4_CF,
    F4_CFEXT,
    F4_TEXTO,
    F4_BASEICM,
    F4_BASEIPI,
    F4_PODER3,
    F4_LFICM,
    F4_LFIPI,
    F4_DESTACA,
    F4_INCIDE,
    F4_COMPL,
    F4_IPIFRET,
    F4_ISS,
    F4_LFISS,
    F4_NRLIVRO,
    F4_UPRC,
    F4_CONSUMO,
    F4_FORMULA,
    F4_AGREG,
    F4_INCSOL,
    F4_CIAP,
    F4_DESPIPI,
    F4_LIVRO,
    F4_ATUTEC,
    F4_ATUATF,
    F4_TPIPI,
    F4_STDESC,
    F4_BSICMST,
    F4_CREDST,
    F4_BASEISS,
    F4_DESPICM,
    F4_SITTRIB,
    F4_PISCOF,
    F4_PISCRED,
    F4_TESDV,
    F4_BASEPIS,
    F4_BASECOF,
    F4_IPILICM,
    F4_MOVPRJ,
    F4_ICMSDIF,
    F4_TESP3,
    F4_QTDZERO,
    F4_SLDNPT,
    F4_DEVZERO,
    F4_MSBLQL,
    F4_TIPOPER,
    F4_TRFICM,
    F4_TESENV,
    F4_OBSICM,
    F4_OBSSOL,
    F4_PICMDIF,
    F4_SELO,
    F4_ISSST,
    F4_FINALID,
    F4_PISFISC,
    F4_CONTSOC,
    F4_COP,
    F4_INDNTFR,
    F4_CODBCC,
    F4_AJUSTE,
    F4_CPPRODE,
    F4_TPPRODE,
    F4_CPRECTR,
    F4_IPIANT,
    F4_TPCPRES,
    F4_DESPCOF,
    F4_TPREG,
    F4_AFRMM,
    F4_BENSATF,
    F4_OPEMOV,
    F4_AGRRETC,
    F4_ALICRST,
    F4_IPIPC,
    F4_TRIBPRD,
    F4_CRPRST,
    F4_REGDSTA,
    F4_DSPRDIC,
    F4_CRDPRES,
    F4_CRPRELE,
    F4_PISBRUT,
    F4_COFDSZF,
    F4_BCRDPIS,
    F4_COFBRUT,
    F4_DESPPIS,
    F4_AGRPIS,
    F4_TRANFIL,
    F4_CTIPI,
    F4_CRDEST,
    F4_MKPCMP,
    F4_FRETAUT,
    F4_ICMSST,
    F4_BCRDCOF,
    F4_AGRCOF,
    F4_LFICMST,
    F4_PISDSZF,
    F4_RETISS,
    F4_OPANRE,
    F4_COPSIMP,
    F4_IPIPECR,
    F4_TXAPIPI,
    F4_TESE3,
    F4_RECDAC,
    F4_DICMFUN,
    F4_PARTICM,
    F4_TREGDMA,
    F4_NATOPER,
    F4_STREDU,
    F4_MALQCOF,
    F4_CONSIND,
    F4_CSBHISS,
    F4_MALQPIS,
    F4_TEMDOCS,
    F4_OPERSUC,
    F4_VDASOFT,
    F4_APSCFST,
    F4_CIAPTRB,
    F4_NORESP,
    F4_PISMIN,
    F4_IPIMIN,
    F4_COFMIN,
    F4_CFAMAD,
    F4_EFUTUR,
    F4_PERCATM,
    F4_TNATREC,
    F4_BSRDICM,
    F4_CRICMST,
    F4_CODDET,
    F4_RFETALG,
    F4_COMPONE,
    F4_CTBHISS,
    F4_ESTCRED,
    F4_IDHIST,
    F4_REGESP,
    F4_CNATREC,
    F4_GRPNATR,
    F4_DTFIMNT,
    F4_MOVFIS,
    F4_VENPRES,
    F4_TIPODUB,
    F4_CREDPRE,
    F4_BENDUB,
    F4_CODOBSE,
    F4_DESCOND,
    F4_CPRESPR,
    F4_IVAUTIL,
    F4_CRPRSIM,
    F4_EFDF100,
    F4_CSTPF1,
    F4_CSTCF1,
    F4_CFPS,
    F4_BSRURAL,
    F4_IPIOBS,
    F4_VARATAC,
    F4_NATOPNF,
    F4_ANTICMS,
    F4_DUPLIPI,
    F4_REDANT,
    F4_CFABOV,
    F4_STLIQ,
    F4_CV139,
    F4_TRAFILI,
    F4_IPIVFCF,
    F4_CRDACUM,
    F4_FTATUSC,
    F4_TPOP,
    F4_PERCMED,
    F4_DEVPARC,
    F4_DESTRUI,
    F4_OPERGAR,
    F4_CFACS,
    F4_RDBSICM,
    F4_TABGIAC,
    F4_BSICMRE,
    F4_ISEFECP,
    F4_APLIIVA,
    F4_NUMDUB,
    F4_PSCFST,
    F4_CRDTRAN,
    F4_APLIRED,
    F4_CREDACU,
    F4_OUTPERC,
    F4_ICMSTMT,
    F4_ISEFEMT,
    F4_INDVF,
    F4_AGRPEDG,
    F4_CROUTSP,
    F4_FORINFC,
    F4_CSOSN,
    F4_AGRDRED,
    F4_APLREDP,
    F4_IMPIND,
    F4_ATACVAR,
    F4_FEEF,
    F4_CODLEG,
    F4_BICMCMP,
    F4_FTRICMS,
    F4_PR35701,
    F4_FRETISS,
    F4_PCREDAC,
    F4_CIMAMT,
    F4_CFUNDES,
    F4_CFASE,
    F4_INFITEM,
    F4_TABGIAO,
    F4_TABGIAI,
    F4_CRLEIT,
    F4_RESSARC,
    F4_VLRZERO,
    F4_MSGLT,
    F4_CRPRERO,
    F4_PAGCOM,
    F4_INDDET,
    F4_INDISEN,
    F4_CODPAG,
    F4_BASCMP,
    F4_DIFAL,
    F4_DESCISS,
    F4_COMPRED,
    F4_CRPREPE,
    F4_DUPLIST,
    F4_CRICMS,
    F4_DBSTIRR,
    F4_MTRTBH,
    F4_BCPCST,
    F4_TIPOTES,
    F4_CSTISS,
    F4_APLREPC,
    F4_CINSS,
    F4_CSENAR,
    F4_ART274,
    F4_PRZESP,
    F4_RGESPST,
    F4_CALCCPB,
    F4_ISEFERN,
    F4_ISEFEMG,
    F4_TRANCQ,
    F4_TRFICST,
    F4_DIFALPC,
    F4_RGESPCI,
    F4_TPRSPL,
    F4_CRPRESP,
    F4_COLVDIF,
    F4_ESCRDPR,
    F4_DBSTCSL,
    F4_INOVAUT,
    F4_VLAGREG,
    F4_CLFDSUL,
    F4_CALCFET,
    F4_CSTPIS,
    F4_CSTCOF,
    F4_TRANSIT,
    F4_AGREGCP,
    F4_REFATAN,
    F4_CRPREPR,
    F4_ALSENAR,
    F4_INTBSIC,
    F4_CROUTGO,
    F4_CUSENTR,
    F4_BONIF,
    F4_MKPSOL,
    F4_CODINFC,
    F4_IPMMG,
    F4_IPMSP,
    F4_MOTICMS,
    F4_REDBCCE,
    F4_GRPCST,
    F4_CONTERC,
    F4_SOMAIPI,
    F4_CODLAN,
    F4_ENQLEG,
    F4_AGRISS,
    F4_ALIQPRO,
    F4_ALQFEEF,
    F4_STCONF,
    F4_PAUTICM
FROM SF4
WHERE
    D_E_L_E_T_ = ' '
    AND F4_FCALCPR = 'VALOR'
    AND F4_DEDDIF = 'VALOR'
    AND F4_CRDICMA = 'VALOR'
    AND F4_FILIAL = 'VALOR'
    AND F4_CODIGO = 'VALOR'
    AND F4_TIPO = 'VALOR'
    AND F4_ICM = 'VALOR'
    AND F4_IPI = 'VALOR'
    AND F4_CREDICM = 'VALOR'
    AND F4_CREDIPI = 'VALOR'
    AND F4_DUPLIC = 'VALOR'
    AND F4_ESTOQUE = 'VALOR'
    AND F4_CF = 'VALOR'
    AND F4_CFEXT = 'VALOR'
    AND F4_TEXTO = 'VALOR'
    AND F4_BASEICM = 0
    AND F4_BASEIPI = 0
    AND F4_PODER3 = 'VALOR'
    AND F4_LFICM = 'VALOR'
    AND F4_LFIPI = 'VALOR'
    AND F4_DESTACA = 'VALOR'
    AND F4_INCIDE = 'VALOR'
    AND F4_COMPL = 'VALOR'
    AND F4_IPIFRET = 'VALOR'
    AND F4_ISS = 'VALOR'
    AND F4_LFISS = 'VALOR'
    AND F4_NRLIVRO = 'VALOR'
    AND F4_UPRC = 'VALOR'
    AND F4_CONSUMO = 'VALOR'
    AND F4_FORMULA = 'VALOR'
    AND F4_AGREG = 'VALOR'
    AND F4_INCSOL = 'VALOR'
    AND F4_CIAP = 'VALOR'
    AND F4_DESPIPI = 'VALOR'
    AND F4_LIVRO = 'VALOR'
    AND F4_ATUTEC = 'VALOR'
    AND F4_ATUATF = 'VALOR'
    AND F4_TPIPI = 'VALOR'
    AND F4_STDESC = 'VALOR'
    AND F4_BSICMST = 0
    AND F4_CREDST = 'VALOR'
    AND F4_BASEISS = 0
    AND F4_DESPICM = 'VALOR'
    AND F4_SITTRIB = 'VALOR'
    AND F4_PISCOF = 'VALOR'
    AND F4_PISCRED = 'VALOR'
    AND F4_TESDV = 'VALOR'
    AND F4_BASEPIS = 0
    AND F4_BASECOF = 0
    AND F4_IPILICM = 'VALOR'
    AND F4_MOVPRJ = 'VALOR'
    AND F4_ICMSDIF = 'VALOR'
    AND F4_TESP3 = 'VALOR'
    AND F4_QTDZERO = 'VALOR'
    AND F4_SLDNPT = 'VALOR'
    AND F4_DEVZERO = 'VALOR'
    AND F4_MSBLQL = 'VALOR'
    AND F4_TIPOPER = 'VALOR'
    AND F4_TRFICM = 'VALOR'
    AND F4_TESENV = 'VALOR'
    AND F4_OBSICM = 'VALOR'
    AND F4_OBSSOL = 'VALOR'
    AND F4_PICMDIF = 0
    AND F4_SELO = 'VALOR'
    AND F4_ISSST = 'VALOR'
    AND F4_FINALID = 'VALOR'
    AND F4_PISFISC = 'VALOR'
    AND F4_CONTSOC = 'VALOR'
    AND F4_COP = 'VALOR'
    AND F4_INDNTFR = 'VALOR'
    AND F4_CODBCC = 'VALOR'
    AND F4_AJUSTE = 'VALOR'
    AND F4_CPPRODE = 0
    AND F4_TPPRODE = 'VALOR'
    AND F4_CPRECTR = 'VALOR'
    AND F4_IPIANT = 'VALOR'
    AND F4_TPCPRES = 'VALOR'
    AND F4_DESPCOF = 'VALOR'
    AND F4_TPREG = 'VALOR'
    AND F4_AFRMM = 'VALOR'
    AND F4_BENSATF = 'VALOR'
    AND F4_OPEMOV = 'VALOR'
    AND F4_AGRRETC = 'VALOR'
    AND F4_ALICRST = 0
    AND F4_IPIPC = 'VALOR'
    AND F4_TRIBPRD = 'VALOR'
    AND F4_CRPRST = 0
    AND F4_REGDSTA = 'VALOR'
    AND F4_DSPRDIC = 'VALOR'
    AND F4_CRDPRES = 0
    AND F4_CRPRELE = 0
    AND F4_PISBRUT = 'VALOR'
    AND F4_COFDSZF = 'VALOR'
    AND F4_BCRDPIS = 0
    AND F4_COFBRUT = 'VALOR'
    AND F4_DESPPIS = 'VALOR'
    AND F4_AGRPIS = 'VALOR'
    AND F4_TRANFIL = 'VALOR'
    AND F4_CTIPI = 'VALOR'
    AND F4_CRDEST = 'VALOR'
    AND F4_MKPCMP = 'VALOR'
    AND F4_FRETAUT = 'VALOR'
    AND F4_ICMSST = 'VALOR'
    AND F4_BCRDCOF = 0
    AND F4_AGRCOF = 'VALOR'
    AND F4_LFICMST = 'VALOR'
    AND F4_PISDSZF = 'VALOR'
    AND F4_RETISS = 'VALOR'
    AND F4_OPANRE = 'VALOR'
    AND F4_COPSIMP = 'VALOR'
    AND F4_IPIPECR = 0
    AND F4_TXAPIPI = 'VALOR'
    AND F4_TESE3 = 'VALOR'
    AND F4_RECDAC = 'VALOR'
    AND F4_DICMFUN = 'VALOR'
    AND F4_PARTICM = 'VALOR'
    AND F4_TREGDMA = 'VALOR'
    AND F4_NATOPER = 'VALOR'
    AND F4_STREDU = 'VALOR'
    AND F4_MALQCOF = 0
    AND F4_CONSIND = 'VALOR'
    AND F4_CSBHISS = 'VALOR'
    AND F4_MALQPIS = 0
    AND F4_TEMDOCS = 'VALOR'
    AND F4_OPERSUC = 'VALOR'
    AND F4_VDASOFT = 'VALOR'
    AND F4_APSCFST = 'VALOR'
    AND F4_CIAPTRB = 'VALOR'
    AND F4_NORESP = 'VALOR'
    AND F4_PISMIN = 'VALOR'
    AND F4_IPIMIN = 'VALOR'
    AND F4_COFMIN = 'VALOR'
    AND F4_CFAMAD = 'VALOR'
    AND F4_EFUTUR = 'VALOR'
    AND F4_PERCATM = 0
    AND F4_TNATREC = 'VALOR'
    AND F4_BSRDICM = 'VALOR'
    AND F4_CRICMST = 'VALOR'
    AND F4_CODDET = 'VALOR'
    AND F4_RFETALG = 'VALOR'
    AND F4_COMPONE = 'VALOR'
    AND F4_CTBHISS = 'VALOR'
    AND F4_ESTCRED = 0
    AND F4_IDHIST = 'VALOR'
    AND F4_REGESP = 'VALOR'
    AND F4_CNATREC = 'VALOR'
    AND F4_GRPNATR = 'VALOR'
    AND F4_DTFIMNT BETWEEN '20261001' AND '20261031'
    AND F4_MOVFIS = 'VALOR'
    AND F4_VENPRES = 'VALOR'
    AND F4_TIPODUB = 'VALOR'
    AND F4_CREDPRE = 0
    AND F4_BENDUB = 'VALOR'
    AND F4_CODOBSE = 'VALOR'
    AND F4_DESCOND = 'VALOR'
    AND F4_CPRESPR = 0
    AND F4_IVAUTIL = 0
    AND F4_CRPRSIM = 0
    AND F4_EFDF100 = 'VALOR'
    AND F4_CSTPF1 = 'VALOR'
    AND F4_CSTCF1 = 'VALOR'
    AND F4_CFPS = 'VALOR'
    AND F4_BSRURAL = 'VALOR'
    AND F4_IPIOBS = 'VALOR'
    AND F4_VARATAC = 'VALOR'
    AND F4_NATOPNF = 'VALOR'
    AND F4_ANTICMS = 'VALOR'
    AND F4_DUPLIPI = 'VALOR'
    AND F4_REDANT = 0
    AND F4_CFABOV = 'VALOR'
    AND F4_STLIQ = 'VALOR'
    AND F4_CV139 = 'VALOR'
    AND F4_TRAFILI = 'VALOR'
    AND F4_IPIVFCF = 'VALOR'
    AND F4_CRDACUM = 'VALOR'
    AND F4_FTATUSC = 'VALOR'
    AND F4_TPOP = 'VALOR'
    AND F4_PERCMED = 0
    AND F4_DEVPARC = 'VALOR'
    AND F4_DESTRUI = 'VALOR'
    AND F4_OPERGAR = 'VALOR'
    AND F4_CFACS = 'VALOR'
    AND F4_RDBSICM = 'VALOR'
    AND F4_TABGIAC = 'VALOR'
    AND F4_BSICMRE = 'VALOR'
    AND F4_ISEFECP = 'VALOR'
    AND F4_APLIIVA = 'VALOR'
    AND F4_NUMDUB = 'VALOR'
    AND F4_PSCFST = 'VALOR'
    AND F4_CRDTRAN = 0
    AND F4_APLIRED = 'VALOR'
    AND F4_CREDACU = 'VALOR'
    AND F4_OUTPERC = 0
    AND F4_ICMSTMT = 'VALOR'
    AND F4_ISEFEMT = 'VALOR'
    AND F4_INDVF = 'VALOR'
    AND F4_AGRPEDG = 'VALOR'
    AND F4_CROUTSP = 0
    AND F4_FORINFC = 'VALOR'
    AND F4_CSOSN = 'VALOR'
    AND F4_AGRDRED = 'VALOR'
    AND F4_APLREDP = 'VALOR'
    AND F4_IMPIND = 'VALOR'
    AND F4_ATACVAR = 'VALOR'
    AND F4_FEEF = 'VALOR'
    AND F4_CODLEG = 'VALOR'
    AND F4_BICMCMP = 'VALOR'
    AND F4_FTRICMS = 0
    AND F4_PR35701 = 0
    AND F4_FRETISS = 'VALOR'
    AND F4_PCREDAC = 0
    AND F4_CIMAMT = 'VALOR'
    AND F4_CFUNDES = 'VALOR'
    AND F4_CFASE = 'VALOR'
    AND F4_INFITEM = 'VALOR'
    AND F4_TABGIAO = 'VALOR'
    AND F4_TABGIAI = 'VALOR'
    AND F4_CRLEIT = 'VALOR'
    AND F4_RESSARC = 'VALOR'
    AND F4_VLRZERO = 'VALOR'
    AND F4_MSGLT = 'VALOR'
    AND F4_CRPRERO = 0
    AND F4_PAGCOM = 'VALOR'
    AND F4_INDDET = 'VALOR'
    AND F4_INDISEN = 'VALOR'
    AND F4_CODPAG = 'VALOR'
    AND F4_BASCMP = 0
    AND F4_DIFAL = 'VALOR'
    AND F4_DESCISS = 'VALOR'
    AND F4_COMPRED = 'VALOR'
    AND F4_CRPREPE = 0
    AND F4_DUPLIST = 'VALOR'
    AND F4_CRICMS = 'VALOR'
    AND F4_DBSTIRR = 'VALOR'
    AND F4_MTRTBH = 'VALOR'
    AND F4_BCPCST = 'VALOR'
    AND F4_TIPOTES = 'VALOR'
    AND F4_CSTISS = 'VALOR'
    AND F4_APLREPC = 'VALOR'
    AND F4_CINSS = 'VALOR'
    AND F4_CSENAR = 'VALOR'
    AND F4_ART274 = 'VALOR'
    AND F4_PRZESP = 'VALOR'
    AND F4_RGESPST = 'VALOR'
    AND F4_CALCCPB = 'VALOR'
    AND F4_ISEFERN = 'VALOR'
    AND F4_ISEFEMG = 'VALOR'
    AND F4_TRANCQ = 'VALOR'
    AND F4_TRFICST = 'VALOR'
    AND F4_DIFALPC = 'VALOR'
    AND F4_RGESPCI = 'VALOR'
    AND F4_TPRSPL = 'VALOR'
    AND F4_CRPRESP = 0
    AND F4_COLVDIF = 'VALOR'
    AND F4_ESCRDPR = 'VALOR'
    AND F4_DBSTCSL = 'VALOR'
    AND F4_INOVAUT = 'VALOR'
    AND F4_VLAGREG = 'VALOR'
    AND F4_CLFDSUL = 'VALOR'
    AND F4_CALCFET = 'VALOR'
    AND F4_CSTPIS = 'VALOR'
    AND F4_CSTCOF = 'VALOR'
    AND F4_TRANSIT = 'VALOR'
    AND F4_AGREGCP = 'VALOR'
    AND F4_REFATAN = 'VALOR'
    AND F4_CRPREPR = 0
    AND F4_ALSENAR = 0
    AND F4_INTBSIC = 'VALOR'
    AND F4_CROUTGO = 0
    AND F4_CUSENTR = 'VALOR'
    AND F4_BONIF = 'VALOR'
    AND F4_MKPSOL = 'VALOR'
    AND F4_CODINFC = 'VALOR'
    AND F4_IPMMG = 'VALOR'
    AND F4_IPMSP = 'VALOR'
    AND F4_MOTICMS = 'VALOR'
    AND F4_REDBCCE = 0
    AND F4_GRPCST = 'VALOR'
    AND F4_CONTERC = 'VALOR'
    AND F4_SOMAIPI = 'VALOR'
    AND F4_CODLAN = 'VALOR'
    AND F4_ENQLEG = 'VALOR'
    AND F4_AGRISS = 'VALOR'
    AND F4_ALIQPRO = 0
    AND F4_ALQFEEF = 0
    AND F4_STCONF = 'VALOR'
    AND F4_PAUTICM = 'VALOR'

Outras tabelas relacionadas

• SF1 Cabeçalho das NF de Entrada
• SF2 Cabeçalho das NF de Saída
• SF3 Livros Fiscais
• SF5 Tipos de Movimentação
• SF6 Guias de Recolhimento
• SF7 Grupo de Tributação
• SF8 Amarração NF Orig x NF Imp/Fre
• SF9 Manutenção CIAP
• SFA Estorno Mensal CIAP
• SFB Impostos Variáveis
• SFC Amarração Tes x Impostos
• SFE Retenções de Impostos

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