Dicionário Protheus
Início

Tabela SF3 no Protheus

Livros Fiscais

O que é a tabela SF3 no Protheus?

A tabela SF3 faz parte do sistema ERP Protheus da TOTVS e é utilizada para livros fiscais.

Ela pertence ao dicionário de dados do Protheus (SX2) e armazena informações essenciais utilizadas em processos como cadastros, movimentações e integrações do sistema.

A tabela SF3 possui diversos campos (SX3), cada um com regras específicas como tipo, tamanho e validações, além de índices (SIX) que otimizam a performance das consultas.

Nesta página você pode consultar a estrutura completa da tabela SF3, incluindo todos os campos e índices relacionados.

Propriedades da Tabela

Propriedade Valor
X2_CHAVE SF3
X2_PATH \DATA\
X2_ARQUIVO SF3990
X2_NOME Livros Fiscais
X2_NOMESPA Libros Fiscales
X2_NOMEENG Tax Records
X2_ROTINA -
X2_MODO E
X2_MODOUN E
X2_MODOEMP E
X2_DELET 0
X2_TTS -
X2_UNICO -
X2_PYME S
X2_MODULO 9
X2_DISPLAY -
X2_SYSOBJ MATA900
X2_USROBJ -
X2_POSLGT 1
X2_CLOB 2
X2_AUTREC 2
X2_TAMFIL 2
X2_TAMUN 0
X2_TAMEMP 0
X2_STAMP 2
X2_INSDT 2
D_E_L_E_T_ -
R_E_C_N_O_ 8212
R_E_C_D_E_L_ 0

Campos da Tabela SF3 (209 campos)

X3_ARQUIVO X3_ORDEM X3_CAMPO X3_TIPO X3_TAMANHO X3_DECIMAL X3_TITULO X3_TITSPA X3_TITENG X3_DESCRIC X3_DESCSPA X3_DESCENG X3_PICTURE X3_VALID X3_USADO X3_RELACAO X3_F3 X3_NIVEL X3_RESERV X3_CHECK X3_TRIGGER X3_PROPRI X3_BROWSE X3_VISUAL X3_CONTEXT X3_OBRIGAT X3_VLDUSER X3_CBOX X3_CBOXSPA X3_CBOXENG X3_PICTVAR X3_WHEN X3_INIBRW X3_GRPSXG X3_FOLDER X3_PYME X3_CONDSQL X3_CHKSQL X3_IDXSRV X3_ORTOGRA X3_IDXFLD X3_TELA X3_PICBRV X3_AGRUP X3_POSLGT X3_MODAL X3_CHKSUM X3_ADDSUM D_E_L_E_T_ R_E_C_N_O_ R_E_C_D_E_L_
SF3 01 F3_CLIDVMC C 6 0 Cliente Dev Cliente Deu Ret cust Cliente Dev Cliente Deu. Ret customer @! - x x x x x x x x x x x x x x x - - 1 x - - - - V R - - - - - - - - 001 - S - - N - N - - - 1 2 - - - 133869 0
SF3 02 F3_LOJDVMC C 2 0 Loja Dev Tienda Deu Ret store Loja Dev Tienda Deu. Ret store @! - x x x x x x x x x x x x x x x - - 1 x - - - - V R - - - - - - - - 002 - S - - N - N - - - 1 2 - - - 133870 0
SF3 03 F3_BASECPR N 14 2 BS CRED PRES BS CRED ESTI DEEM CRED BS BASE CREDITO PRESUMIDO BASE CRÉDITO ESTIMADO DEEMED CREDIT BASE @E 99,999,999,999.99 - x x x x x x x x x x x x x x x - - 1 - - - - N A R - - - - - - - - - - N - - N - N - - - 1 2 - - - 133871 0
SF3 04 F3_REPROC C 1 0 Perm.Reproc. Perm.Reproc. Allow Reproc Permitir Reprocessamento Permitir Reprocesamiento Allow Reprocessing @! pertence("SN") x x x x x x x x x x x x x x x x "S" - 1 x x - - - N - - - - S=Sim;N=Nao S=Si;N=No S=Yes;N=No - - - - - S - - N N N - - - 1 2 - - - 133872 0
SF3 05 F3_ENTRADA D 8 0 DT Entrada Fch Entrada Inflow Date Data de Entrada Contabil Fecha de Entrada Contable Accounting Entry Date - FisChkDt(M->F3_ENTRADA) x x x x x x x x x x x x x x x x - - 1 x xx - - - S - - - - - - - - - - - - S - - N N N - - - 1 1 - - - 133873 0
SF3 06 F3_NFISCAL C 9 0 Nota Fiscal Factura Invoice Numero da Nota Fiscal Numero de la Factura Invoice Number @! A900VerCpo() x x x x x x x x x x x x x x x x - - 1 xx - - - S - - - - - - - - - - 018 - S - - N N N - - - 1 1 - - - 133874 0
SF3 07 F3_SERIE C 3 0 Serie N.F. Serie Fact. Inv.Series Serie da Nota Fiscal Serie de la Factura Invoice Series !!! A900VerCpo() x x x x x x x x x x x x x x x x - - 1 x x - - - S - - - - - - - - - - 094 - S - - N N N - - - 1 2 - - - 133875 0
SF3 08 F3_CLIEFOR C 6 0 Clien/Fornec Clien/Provee Cust./Sup. Cliente ou Fornecedor Cliente o Proveedor Customer or Supplier @! A900VerCpo() x x x x x x x x x x x x x x x x - - 1 xx - - - S - - - - - - - - - - 001 - S - - N N N - - - 1 1 - - - 133876 0
SF3 09 F3_LOJA C 2 0 Loja Tienda Unit Loja do Cliente/Fornec. Tienda Cliente/Proveedor Unit of Customer/Supplier @! A900VerCpo() x x x x x x x x x x x x x x x x - - 1 xx - - - S - - - - - - - - - - 002 - S - - N N N - - - 1 1 - - - 133877 0
SF3 10 F3_CFO C 5 0 Cod. Fiscal Cod. Fiscal Fiscal Code Codigo Fiscal da Operacao Codigo Fiscal Operacion Operation Fiscal Code @9 NaoVazio() .and. EXISTCPO("SX5","13"+M->F3_CFO) x x x x x x x x x x x x x x x x - 13 1 xx - - - N - - - - - - - - - - - - S - - N N N - - - 1 1 - - - 133878 0
SF3 11 F3_CODISS C 9 0 Cod.Serv.ISS Cod.Serv.ISS ISS serv cd Código de Serviço do ISS Codigo de Servicio de ISS ISS Service Code @9 A900VerCpo() .And. (Vazio() .OR. EXISTCPO("SX5","60"+M->F3_CODISS)) x x x x x x x x x x x x x x x x - 60 1 x x x - - - N - - - - - - - - - - 023 - S - - N N N - - - 1 2 - - - 133879 0
SF3 12 F3_ESTADO C 2 0 Estado Ref. Estado Ref. State Estado de Referencia Estado de Referencia State of Reference @! ExistCpo("SX5","12"+M->F3_ESTADO) .and. A900VerCpo() x x x x x x x x x x x x x x x x - - 1 x xx - - - N - - - - - - - - - - 010 - S - - N N N - - - 1 1 - - - 133880 0
SF3 13 F3_EMISSAO D 8 0 Emissao N.F. Emision Fact Invoice Iss. Data de Emissao da N.F. Fecha de Emision Factura Date of Isssue of Invoice - A900VerCpo() x x x x x x x x x x x x x x x x - - 1 x xx - - - N - - - - - - - - - - - - S - - N N N - - - 1 1 - - - 133881 0
SF3 14 F3_CONTA C 20 0 Conta Contab Cta.Contable Accounting Conta Contabil Cuenta Contable Ledger Account @! ExistCpo('CT1') .Or. Vazio() x x x x x x x x x x x x x x x x - CT1 1 x x - - - N - - - - - - - - - - 003 - S - - N N N - - - 1 2 - - - 133882 0
SF3 15 F3_ALIQICM N 5 2 Aliq. ICMS Alic. ICMS V.A.T. Aliquota de ICMS Alicuota del ICMS ICMS Tax Rate @E 99.99 A900VerCpo() x x x x x x x x x x x x x x x x - - 1 xxxxxx x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133883 0
SF3 16 F3_VALCONT N 14 2 Vlr.Contabil Vlr.Contable Accnt.Value Valor Contabil Valor Contable Accounting Value @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133884 0
SF3 17 F3_BASEICM N 14 2 Base p/ICMS Base p/ ICMS ICMS T.Base Base de ICMS Base de ICMS ICMS Tax Base @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133885 0
SF3 18 F3_VALICM N 14 2 ICMS Tribut. ICMS Tribut. ICMS levied ICMS Tributado ICMS Tributado ICMS levied @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133886 0
SF3 19 F3_ISENICM N 14 2 ICMS Isento ICMS Exento ICMS exempt ICMS Isento ICMS Exento ICMS Exempted @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133887 0
SF3 20 F3_OUTRICM N 14 2 ICMS Outros ICMS Otros ICMS Other ICMS Outros ICMS Otros ICMS Others @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133888 0
SF3 21 F3_BASEIPI N 14 2 Base de IPI Base de IPI IPI Basis Base de IPI Base de IPI IPI Basis @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133889 0
SF3 22 F3_VALIPI N 14 2 IPI Tribut. IPI Tribut. Taxed IPI IPI Tributado IPI Tributado Taxed IPI @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133890 0
SF3 23 F3_ISENIPI N 14 2 IPI Isento IPI Exento IPI Exempt IPI Isento IPI Exento IPI Exempt @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133891 0
SF3 24 F3_OUTRIPI N 14 2 IPI Outros IPI Otros IPI Others IPI Outros IPI Otros IPI Others @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133892 0
SF3 25 F3_OBSERV C 40 0 Observacoes Observac. Notes Mensagem no Livro Fiscal Mensaje en Libro Fiscal Message on Tax Record @! - x x x x x x x x x x x x x x x x - - 1 x x x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133893 0
SF3 26 F3_VALOBSE N 14 2 Desconto Descuento Discount Desconto na Nota Fiscal Descuento en la Factura Invoice Discount @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133894 0
SF3 27 F3_ICMSRET N 14 2 ICMS Retido ICMS Retenid ICMSWithheld ICMS Retido ICMS Retenido ICMS withheld @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133895 0
SF3 28 F3_TIPO C 1 0 Tipo Tipo Type Tipo de Lancamento Tipo de Asiento Type of Entry @! A900VerCpo() x x x x x x x x x x x x x x x x - - 1 x x - - - N - - - - L=Nota Em Lote;S=Nota com ISS;B=Beneficiamento;D=Devolucao;C=Complemento;P=Comp. IPI;I=Comp. ICMS L=Nota En Lote;S=Nota con ISS;B=Beneficiacion;D=Devolucion;C=Complemento;P=Comp. IPI;I=Comp. ICMS L=inv in lot;S=inv with ISS;B=Benefic;D=Return;C=Complement;P=ICMS Compl - - - - - S - - N N N - - - 1 2 - - - 133896 0
SF3 29 F3_LANCAM C 6 0 N. Lancam. Num.Registro Entry Number Numero do Lancamento Numero del Registro Entry Number @! A900VerCpo() x x x x x x x x x x x x x x x x - - 1 x x x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133897 0
SF3 30 F3_DOCOR C 9 0 Doc.Original Doc.Original Original Doc Documento Original Documento Original Original Document @! A900VerCpo() x x x x x x x x x x x x x x x - - 1 x - - - N - - - - - - - - - - 018 - S - - N N N - - - 1 2 - - - 133898 0
SF3 31 F3_ICMSCOM N 14 2 ICMS Complem ICMS Comple. Compl. ICMS ICMS Complementar ICMS Complementar Complementary ICMS @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133899 0
SF3 32 F3_IPIOBS N 14 2 IPI na Obs IPI en Obs IPI on Note IPI a ser impresso na OBS IPI a imprimir en la OBS. IPI to print on NOTE @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133900 0
SF3 33 F3_NRLIVRO C 1 0 Nr do Livro Num.de Libro Book Number Numero do Livro Numero del Libro Book Number @! Pertence(" 1234567890") x x x x x x x x x x x x x x x x - - 1 x x x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133901 0
SF3 34 F3_ICMAUTO N 14 2 Icms autonom ICMS autonom Indep.VAT Icms sobre frete autonomo ICMS Sobre Flete Autonom. ICMS on independ. freight @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133902 0
SF3 35 F3_BASERET N 14 2 Bs Icms Ret Bs ICMs Ret. ICMS Bs.Wthh Base do ICMS Retido Base del ICMS Retenido Withheld ICMS Base @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133903 0
SF3 36 F3_FORMUL C 1 0 Form.Proprio Form. Propio Proper Form Flag de Formul.Proprio Flag de Planilla Propia Flag of Proper Form @! Pertence("SN ") x x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - S=Sim;N=Nao S=Si;N=No S=Yes;N=No - - - - - S - - N N N - - - 1 2 - - - 133904 0
SF3 37 F3_ESPECIE C 5 0 Espec.Docum. Especie Doc. Document Ty. Espécie do Documento Especie del Documento Type of Document @! Vazio().or.ExistCpo("SX5","42"+M->F3_ESPECIE) x x x x x x x x x x x x x x x x - 42 1 xx - - - - - - - - - - - - - - - - S - - N N N - - - 1 1 - - - 133905 0
SF3 38 F3_FORMULA C 3 0 Formula Formula Formula Fórmula p/uso L.Fiscal F¾rmula pa.uso Lib.Fiscal Formula for Fiscal Books @! - x x x x x x x x x x x x x x x x - - 1 xxxx x x - - - - - - - Vazio().or.ExistCpo("SM4",M->F3_FORMULA) - - - - - - - - S - - N N N - - - 1 2 - - - 133906 0
SF3 39 F3_DESPESA N 14 2 Desp.Acesso. Gasto Acces. Extra Expen. Despesas Acessorias Gastos Miscelaneas Extra Expenses @E 999,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 xxxx x x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133907 0
SF3 40 F3_PDV C 10 0 Nro. PDV Num. del PDV POS Number Nro. PDV - ECF Num. PDV - ECF POS-ECF number @! - x x x x x x x x x x x x x x x x x - - 1 x x - - - - - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133908 0
SF3 41 F3_BASIMP1 N 14 2 Base Imp. 1 Base Imp. 1 Tax Base 1 Base de Calculo Imposto 1 Base Calculo Impuesto 1 Tax Calculation Basis 1 @E 99,999,999,999.99 - x x x x x x x x x xx xx x x x x x x x x - - 1 x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133909 0
SF3 42 F3_BASIMP2 N 14 2 Base Imp. 2 Base Imp. 2 Tax Base 2 Base de Calculo Imposto 2 Base Calculo Impuesto 2 Tax Calculation Basis 2 @E 99,999,999,999.99 - x x x x x x x x x xx xx x x x x x x x x - - 1 x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133910 0
SF3 43 F3_BASIMP3 N 14 2 Base Imp. 3 Base Imp. 3 Tax Base 3 Base de Calculo Imposto 3 Base Calculo Impuesto 3 Tax Calculation Basis 3 @E 99,999,999,999.99 - x x x x x x x x x xx xx x x x x x x x x - - 1 x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133911 0
SF3 44 F3_BASIMP4 N 14 2 Base Imp. 4 Base Imp. 4 Tax Base 4 Base de Calculo Imposto 4 Base Calculo Impuesto 4 Tax Calculation Basis 4 @E 99,999,999,999.99 - x x x x x x x x x xx xx x x x x x x x x - - 1 x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133912 0
SF3 45 F3_BASIMP5 N 14 2 Base Imp. 5 Base Imp. 5 Tax Base 5 Base de Calculo Imposto 5 Base Calculo Impuesto 5 Tax Calculation Basis 5 @E 99,999,999,999.99 - x x x x x x x x x xx xx x x x x x x x x - - 1 x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133913 0
SF3 46 F3_BASIMP6 N 14 2 Base Imp. 6 Base Imp. 6 Tax Base 6 Base de Calculo Imposto 6 Base Calculo Impuesto 6 Tax Calculation Basis 6 @E 99,999,999,999.99 - x x x x x x x x x xx xx x x x x x x x x - - 1 x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133914 0
SF3 47 F3_ALQIMP1 N 6 2 Aliq. Imp. 1 Alic. Imp. 1 Tax Rate 1 Aliquota do Imposto 1 Alicuota del Impuesto 1 Income Tax Rate 1 @E 999.99 - x x x x x x x x x xx xx x x x x x x x x - - 1 xxxx x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133915 0
SF3 48 F3_ALQIMP2 N 6 2 Aliq. Imp. 2 Alic. Imp. 2 Tax Rate 2 Aliquota do Imposto 2 Alicuota del Impuesto 2 Income Tax Rate 2 @E 999.99 - x x x x x x x x x xx xx x x x x x x x x - - 1 xxxx x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133916 0
SF3 49 F3_ALQIMP3 N 6 2 Aliq. Imp. 3 Alic. Imp. 3 Tax Rate 3 Aliquota do Imposto 3 Alicuota del Impuesto 3 Income Tax Rate 3 @E 999.99 - x x x x x x x x x xx xx x x x x x x x x - - 1 xxxx x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133917 0
SF3 50 F3_ALQIMP4 N 6 2 Aliq. Imp. 4 Alic. Imp. 4 Tax Rate 4 Aliquota do Imposto 4 Alicuota del Impuesto 4 Income Tax Rate 4 @E 999.99 - x x x x x x x x x xx xx x x x x x x x x - - 1 xxxx x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133918 0
SF3 51 F3_ALQIMP5 N 6 2 Aliq. Imp. 5 Alic. Imp. 5 Tax Rate 5 Aliquota do Imposto 5 Alicuota del Impuesto 5 Income Tax Rate 5 @E 999.99 - x x x x x x x x x xx xx x x x x x x x x - - 1 xxxx x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133919 0
SF3 52 F3_ALQIMP6 N 6 2 Aliq. Imp. 6 Alic. Imp. 6 Tax Rate 6 Aliquota do Imposto 6 Alicuota del Impuesto 6 Income Tax Rate 6 @E 999.99 - x x x x x x x x x xx xx x x x x x x x x - - 1 xxxx x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133920 0
SF3 53 F3_VALIMP1 N 14 2 Valor Imp. 1 Valor Imp. 1 Tax Value 1 Valor do Imposto 1 Valor del Impuesto 1 Tax Value 1 @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133921 0
SF3 54 F3_VALIMP2 N 14 2 Valor Imp. 2 Valor Imp. 2 Tax Value 2 Valor do Imposto 2 Valor del Impuesto 2 Tax Value 2 @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133922 0
SF3 55 F3_VALIMP3 N 14 2 Valor Imp. 3 Valor Imp. 3 Tax Value 3 Valor do Imposto 3 Valor del Impuesto 3 Tax Value 3 @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133923 0
SF3 56 F3_VALIMP4 N 14 2 Valor Imp. 4 Valor Imp. 4 Tax Value 4 Valor do Imposto 4 Valor del Impuesto 4 Tax Value 4 @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133924 0
SF3 57 F3_VALIMP5 N 14 2 Valor Imp. 5 Valor Imp. 5 Tax Value 5 Valor do Imposto 5 Valor del Impuesto 5 Tax Value 5 @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133925 0
SF3 58 F3_VALIMP6 N 14 2 Valor Imp. 6 Valor Imp. 6 Tax Value 6 Valor do Imposto 6 Valor del Impuesto 6 Tax Value 6 @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133926 0
SF3 59 F3_RETIMP1 N 14 2 Reten.Imp. 1 Reten.Imp. 1 W.Hold Tax 1 Valor Retencao do Imp. 1 Valor Retencion del Impue Withholding Tax Value 1 @E 99,999,999,999.99 - x x x x x x x x x xx xx x x x x x x x x - - 1 x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133927 0
SF3 60 F3_RETIMP2 N 14 2 Reten.Imp. 2 Reten.Imp. 2 W.Hold Tax 2 Valor Retencao do Imp. 2 Retencion del Impuesto 2 Withholding Tax Value 2 @E 99,999,999,999.99 - x x x x x x x x x xx xx x x x x x x x x - - 1 x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133928 0
SF3 61 F3_RETIMP3 N 14 2 Reten.Imp. 3 Reten.Imp. 3 W.Hold Tax 3 Valor Retencao do Imp. 3 Retencion del Impuesto 3 Withholding Tax Value 3 @E 99,999,999,999.99 - x x x x x x x x x xx xx x x x x x x x x - - 1 x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133929 0
SF3 62 F3_RETIMP4 N 14 2 Reten.Imp. 4 Reten.Imp. 4 W.Hold Tax 4 Valor Retencao do Imp. 4 Retencion del Impuesto 4 Withholding Tax Value 4 @E 99,999,999,999.99 - x x x x x x x x x xx xx x x x x x x x x - - 1 x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133930 0
SF3 63 F3_RETIMP5 N 14 2 Reten.Imp. 5 Reten.Imp. 5 W.Hold Tax 5 Valor Retencao do Imp. 5 Retencion del Impuesto 5 Withholding Tax Value 5 @E 99,999,999,999.99 - x x x x x x x x x xx xx x x x x x x x x - - 1 x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133931 0
SF3 64 F3_RETIMP6 N 14 2 Reten.Imp. 6 Reten.Imp. 6 W.Hold Tax 6 Valor Retencao do Imp. 6 Retencion del Impuesto 6 Withholding Tax Value 6 @E 99,999,999,999.99 - x x x x x x x x x xx xx x x x x x x x x - - 1 x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133932 0
SF3 65 F3_DTLANC D 8 0 Dt. lancto. Fch Asiento Entry Date Data do lancto contabil Fecha de Asiento Contable Accounting Entry Date - - x x x x x x x x x x x x x x x x - - 1 x x x - - - N V - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133933 0
SF3 66 F3_FILIAL C 2 0 Filial Sucursal Branch Filial do Sistema Sucursal del Sistema System Branch - - x x x x x x x x x x x x x x x - - 1 - - - - N - - - - - - - - - - 033 - S - - N N N - - - 1 2 - - - 133934 0
SF3 67 F3_DTCANC D 8 0 Dt. Cancel. Fch. Anulac. Cancel. Date Data do Cancelamento Fecha de Anulaci¾n Calcellation Date - - x x x x x x x x x x x x x x x x - - 1 x x - - - N V - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133935 0
SF3 68 F3_DOCPRE C 12 0 N§ Doc.Pre. Nro.Doc.Pre. Pre.Doc.Num. N§ Doc. Pre Impresso Nro. Pre Impreso Pre-Printed Document No. - ExistChav("SF3",M->F3_DOCPRE,7) x x x x x x x x x x x x x x x - - 1 xxxxxx - - - S - - - - - - - - - - - - S - - N N N - - - 1 1 - - - 133936 0
SF3 69 F3_ISSST C 1 0 Pgto Imposto Pag Impuesto Tax Paym. Pagamento Imposto Pago Impuesto Tax Payment @! - x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - 1=Dentro Municipio;2=Fora Municipio;3=Isenção;4=Imune;5=Exigibilidade Susp. Judicial;6=Exigibilidade Susp. Proc. Adm. 1=Dentro Municipio;2=Fuera Municipio;3=Exencion;4=Inmune;5=Exigibilidad Susp. Judicial;6=Exigibilidad Susp. Proc. Adm. 1=In the city;2=Outside the city;3=Exemption;4=Immune;5=Demandability Judicial Susp.;6=Demandability Susp. Adm. Proc. - - - - - S - - N N N - - - 1 2 - - - 133937 0
SF3 70 F3_CRDPCTR N 14 2 Crd.Pres.Car Crd.Pres.Car T. B.Pres Cr Crd.Pres.Carga Tributaria Crd.Pres.Carga Tributaria Tax Burden Pres. Crd. @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 xxx - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 133938 0
SF3 71 F3_CRPRELE N 16 2 Vlr Cr Pr El Vl.Cr.Pr.El. Cr Val In El Vlr Crd Pres Eletronicos Vlr Crd Pres Electronicos Crd Val Inst Eletronics @E 9,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 xxxx x - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 133939 0
SF3 72 F3_CREDST C 1 0 Cred/Deb ST Cred/Deb ST Cred/Deb TS Cred/Deb Subst.Tributária Cred/Deb Sust.Tributaria Cred/Deb Tax Substitution @! - x x x x x x x x x x x x x x x x - - 1 xx x - - - S - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133940 0
SF3 73 F3_MDCAT79 C 32 0 Md5 Cat79 Md5 Cat79 Md5 Cat79 Aut Md5 Cat79 Aut Md5 Cat79 Aut Md5 Cat79 @! - x x x x x x x x x x x x x x x x - - 1 x xx x - - - S - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133941 0
SF3 74 F3_CRDPRES N 14 2 Crd. Pres. Crd. Pres. Pres.Crd. Credito Presumido Credito Presumido Presumed Credit @E 999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 xx - - - - - - - - - - - - - - - - N - - N N N - - - 1 2 - - - 133942 0
SF3 75 F3_NFEMP C 74 0 Nota de Emp. Fact.Reserva Alloc.Note Nota de Empenho Factura de Reserva Allocation Note - - x x x x x x x x x x x x x x x x - - 1 x x - - - - - R - - - - - - - - - - S - - N N N - - - 1 2 - - - 133943 0
SF3 76 F3_ICMSDIF N 14 2 ICM Diferido ICM Diferido Def. ICMS ICMS Diferido ICM diferido Deferred ICMS @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 xx x x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133944 0
SF3 77 F3_TRFICM N 14 2 Trf.Deb/Crd. Trans.Deb/Cr Deb./Cr.Tr. Transf. Debito e Credito Tranf. Debito y Credito Debt and Credit Transfer @e 999,999,999.99 Positivo() x x x x x x x x x x x x x x x x - - 1 xxxx - - - - - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133945 0
SF3 78 F3_OBSICM N 12 2 Icm Observ. ICMS Obser. ICM in Notes Icms na observacao ICMS en la observacion ICMS in Notes @E 99,999,999.99 Positivo() x x x x x x x x x x x x x x x - - 1 xxxx x - - - - - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133946 0
SF3 79 F3_OBSSOL N 12 2 Solid. Obs. Solid. Obs. Solid.in Not Solidario na observacao Solidario en la observac. Solidary in Note @E 99,999,999.99 Positivo() x x x x x x x x x x x x x x x - - 1 xxxx x - - - - - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133947 0
SF3 80 F3_SOLTRIB N 12 2 ICM.Sol.Trib ICM.Sol.Trib Taxed ICM Sl ICMS solidario tributado ICMS solidario tributado Taxed solidary ICMS @E 99,999,999.99 Positivo() x x x x x x x x x x x x x x x - - 1 xxxx x - - - - - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133948 0
SF3 81 F3_CFOEXT C 3 0 CFOP Est. CFOP Est. Ext. CFOP CFOP Estendido CFOP Extendido Extended CFOP @! - x x x x x x x x x x x x x x x x - - 1 x - - - - A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 133949 0
SF3 82 F3_SIMPLES N 14 2 Simples Simples Simples Vlr do ICMS do SIMPLES/SC Vlr do ICMS do SIMPLES/SC ICMS value of SIMPLES/SC @E 99999999999.99 - x x x x x x x x x x x x x x x x - - 1 x - - - - - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133950 0
SF3 83 F3_CRDZFM N 14 2 Cred. ZFM Cred. ZFM ZFM Cred Cred. Zona Franca Manaus Cred. Zona Franca Manaus Cred.Manaus FreeTradeZone @E 99,999,999,999.99 - x x x x x x x x x x x x x x x - - 1 - - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133951 0
SF3 84 F3_RECISS C 1 0 Recolhe ISS Paga ISS Collect ISS Indica se recolhe ISS Indica si paga ISS Indicates if collects ISS - - x x x x x x x x x x x x x x x x - - 1 x - - - - - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133952 0
SF3 85 F3_IDENTFT C 6 0 Ident. SFT Ident. SFT SFT Ident. Identificação SFT Identificac. SFT SFT Identification - - x x x x x x x x x x x x x x x x - - 1 x - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 133953 0
SF3 86 F3_CRPRST N 16 2 Cr Pr ST Cr Pr ST Pr Cr ST Cred Pres ST Transporte Cred Pres ST Transporte Presumed Cred. ST Transp. @E 9,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 133954 0
SF3 87 F3_CPPRODE N 14 2 Crd.PRODEPE Crd.PRODEPE PRODEPE Cred Crédito Pres. PRODEPE Crédito Pres. PRODEPE Pres. Credit PRODEPE @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x - - - S A - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133955 0
SF3 88 F3_TPPRODE C 1 0 Tipo PRODEPE Tipo PRODEPE PRODEPE Type Tipo Crd.Pres PRODEPE Tipo Crd.Pres PRODEPE Tp. Pres. Credit PRODEPE - pertence(" 0123456789") x x x x x x x x x x x x x x x x - - 1 x - - - S A - - - 0=N Incentivado;1=Ind-Crd.Pres;2=Ind-Fin.Parcelas;3=Ind-Crd.Pres.Inter;4=Dist-Crd.Pres Entrada;5=Dist-Crd.Pres Saida;6=Import. 0=N Incentivado;1=Ind-Crd.Pres;2=Ind-Fin.Cuotas;3=Ind-Crd.Pres.Inter;4=Dist-Crd.Pres Entrada;5=Dist-Crd.Pres Salida;6=Import. 0=Not Incent;1=Ind-Crd.Pres;2=Ind-Fin.Install;3=Ind-Crd.Pres.Inter;4=Dist-Crd.Pres Entry;5=Dist-Crd.Pres Exit;6=Import. - - - - - S - - N N N - - - 1 2 - - - 133956 0
SF3 89 F3_CSTPIS C 2 0 CST PIS CST PIS PIS CST CST PIS CST PIS CST PIS @! - x x x x x x x x x x x x x x x - - 1 - - - - N A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 133957 0
SF3 90 F3_ABATISS N 14 2 ISS Subempr. ISS SubConst Subcontr ISS ISS da Subempreitada ISS da SubConstructora Subcontract ISS @E 99,999,999,999.99 - x x x x x x x x x x x x x x x - - 1 - - - - N A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 133958 0
SF3 91 F3_CSTCOF C 2 0 CST COF CST COF CST COF CST COF CST COF CST COF @! - x x x x x x x x x x x x x x x - - 1 - - - - N A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 133959 0
SF3 92 F3_CODBCC C 2 0 Cod. BCC Cód. BCC BCC Code Cód Base de Crédito Cód Base de crédito Credit Base Code @! - x x x x x x x x x x x x x x x - - 1 - - - - N A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 133960 0
SF3 93 F3_DESCFIS N 14 2 Desc Fiscal Desc Fiscal Tax Disc Desconto Fiscal Descto Fiscal Tax Discount @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 xxxxxx xx - - - - - - - - - - - - - - - - S - - N - N - - - 1 1 - - - 133961 0
SF3 94 F3_HORNFE C 8 0 Hora NF-e Hora eFact NF-e Time Hora da emissão da NF-e Hora emision eFact NF-e Issue Time @R 99:99:99 - x x x x x x x x x x x x x x x - - 1 - - - - S A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 133962 0
SF3 95 F3_ALQCPM N 6 2 Alq.ISS CPM Alic.ISS CPM CPM ISS Rate Aliquota ISS CPM Alicuota ISS CPM CPM ISS Rate @E 999.99 MaFisRef("LF_ALQCPM","MT100",M->F3_ALQCPM) x x x x x x x x x x x x x x x x - - 1 xxx xx - - - S - - - - - - - - - - - - S - - N - N - - - 1 2 - - - 133963 0
SF3 96 F3_CREDACU C 1 0 Cr Acum ICMS Cr Acum ICMS AccICMS Cred Credito Acumulado de ICMS Credito Acumulado de ICMS Accumulated ICMS Credit @! - x x x x x x x x x x x x x x x x - - 1 x xx x - - - - - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133964 0
SF3 97 F3_BASECPM N 14 2 Bs.ISS CPM Bs.ISS CPM CPM ISS Bs Base ISS CPM Base ISS CPM CPM ISS Basis @E 99,999,999,999.99 MaFisRef("LF_BASECPM","MT100",M->F3_BASECPM) x x x x x x x x x x x x x x x x - - 1 x - - - - - - - - - - - - - - - - S - - N - N - - - 1 2 - - - 133965 0
SF3 98 F3_CRDEST N 14 2 Credito Est. Credito Est. Credit Inc. Valor do Crédito Estímulo Valor Credito Estimulo Value of Credit Incentive @E 99,999,999,999.99 - x x x x x x x x x x x x x x x - - 1 - - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133966 0
SF3 99 F3_VALCPM N 14 2 Vl.ISS CPM Vl.ISS CPM CPM ISS Vl Valor ISS CPM Valor ISS CPM CPM ISS Value @E 99,999,999,999.99 MaFisRef("LF_VALCPM","MT100",M->F3_VALCPM) x x x x x x x x x x x x x x x x - - 1 x - - - S - - - - - - - - - - - - S - - N - N - - - 1 2 - - - 133967 0
SF3 A0 F3_CRDTRAN N 14 2 Crd.Transp. Crd.Transp. Transp. Crd. Cred. Pres. Transporte Cred. Pres. Transporte Cred. Pres. Transport @E 999,999,999.99 - x x x x x x x x x x x x x x x - - 1 - - - - S - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133968 0
SF3 A1 F3_PROTOC C 17 0 Protocolo Protocolo Protocol Num. Protocolo da NFe Nº Protocolo e-Fact e-Inv Protocol Number @! - x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 133969 0
SF3 A2 F3_CODRSEF C 3 0 Retorno SEFA Retorno SEFA SEFAZ return Codigo de retorno SEFAZ Codigo de retorno SEFAZ SEFAZ return code @! - x x x x x x x x x x x x x x x x - - 1 x xx x - - - N - - - - - - - - - - 184 - S - - N N N - - - 1 2 - - - 133970 0
SF3 A3 F3_VALFET N 14 2 Valor Fethab Valor Fethab Fethab Value Valor do Fethab Valor de Fethab Fethab Value @E 999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x - - - - - - - - - - - - - - - - N - - N N N - - - 1 2 - - - 133971 0
SF3 A4 F3_VALFAB N 14 2 Valor Fabov Valor Fabov Fabov Value Valor do Fabov Valor de Fabov Fabov Value @E 999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x - - - - - - - - - - - - - - - - N - - N N N - - - 1 2 - - - 133972 0
SF3 A5 F3_VALFAC N 14 2 Valor Facs Valor Facs Facs Value Valor do Facs Valor de Facs Facs Value @E 999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x - - - - - - - - - - - - - - - - N - - N N N - - - 1 2 - - - 133973 0
SF3 A6 F3_CODNFE C 50 0 Cd.Ver. NF-e Cd.Ver. F E NF-e ChkCode Código verificação NF-e Codigo verificacion F. E. NF-e check code @! - x x x x x x x x x x x x x x x - - 1 - - - - S A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 133974 0
SF3 A7 F3_VALANTI N 14 2 Val Ant.ICMS Val Ant.ICMS ICMS Adv.Vl. Valor Antecipação ICMS Valor Anticipo ICMS ICMS Advance Value @E 99,999,999,999.99 - x x x x x x x x x x x x x x x - - 1 x xx x - - - - - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133975 0
SF3 A8 F3_ISSSUB N 14 2 Iss Subempr. ISS SubconT SubcntrctISS ISS da Subempreitada ISS Subcontratos por Terc ISS of Subcontract @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x xx x - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 133976 0
SF3 A9 F3_VALCF3 N 14 2 Vl. Cof ST Vl. Cof ST COF ST Amnt. Valor Cofins ST Valor Cofins ST COFINST ST amount @E 999,999,999.99 Positivo().And.MaFisRef("LF_VALCF3","MT100",M->F3_VALCF3) x x x x x x x x x x x x x x x - - 1 - - - - S - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133977 0
SF3 B0 F3_NFELETR C 20 0 NF Eletr. Fact Electr. Elect. Inv. Nota Fiscal Eletrônica Factura Electronica Electronic Invoice @! - x x x x x x x x x x x x x x x x - - 1 x xx x - - - S A R - - - - - - - - 124 - S - - N N N - - - 1 2 - - - 133978 0
SF3 B1 F3_VALPS3 N 14 2 Vl. Pis ST Vl. Pis ST PIS ST Amnt. Valor Pis ST Valor Pis ST PIS ST amount @E 999,999,999.99 Positivo().And.MaFisRef("LF_VALPS3","MT100",M->F3_VALPS3) x x x x x x x x x x x x x x x - - 1 - - - - S - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133979 0
SF3 B2 F3_CFPS C 6 0 Cod. CFPS Cod. CFPS CFPS Code Código CFPS Código CFPS CFPS Code 999999 - x x x x x x x x x x x x x x x x - - 1 x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133980 0
SF3 B3 F3_ESTCRED N 16 2 Vl.Es.Cr/Deb Vl.Dev.Cr/De Cr/Deb Rev.C Valor Estorno Cred/Deb Valor Devolucion Cred/Deb Cred/Deb Reversal Code @E 9,999,999,999.99 MaFisRef("LF_ESTCRED","MT100",M->F3_ESTCRED) x x x x x x x x x x x x x x x x - - 1 xxxx x - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 133981 0
SF3 B4 F3_BASECF3 N 14 2 Bs. Cof ST Bs. Cof ST COF ST base Base Cofins ST Base Cofins ST COFINS ST tax base @E 999,999,999.99 Positivo().And.MaFisRef("LF_BASECF3","MT100",M->F3_BASECF3) x x x x x x x x x x x x x x x - - 1 - - - - S - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133982 0
SF3 B5 F3_CSTISS C 2 0 Sit.Trib.ISS Sit.Trib.ISS ISS Tax St. Situacao Trib. do ISS Situac.Trib. del ISS ISS Tax Status @! Vazio() .Or. ExistCpo('SX5','S9'+M->F3_CSTISS) x x x x x x x x x x x x x x x x - - 1 x - - - N A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 133983 0
SF3 B6 F3_CROUTGO N 14 2 Crd Out GO Crd Otor GO GO Gr. Crd. Cred Outorgado GO Credito otorgado GO GO Grantee Cred. @E 99,999,999,999.99 - x x x x x x x x x x x x x x x - - 1 - - - - N A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 133984 0
SF3 B7 F3_VALPEDG N 14 2 Val. Pedag. Val. Peaje Toll Value Valor do Pedagio Valor del peaje Value of Toll @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 xxxx xx - - - N A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 133985 0
SF3 B8 F3_NUMRPS C 20 0 Num. RPS Nº RPS RPS number Número do RPS Numero de RPS RPS number @! - x x x x x x x x x x x x x x x - - 1 x x - - - S A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 133986 0
SF3 B9 F3_CNAE C 9 0 CNAE CNAE CNAE Cod. Atividade do lancto. Cod. Actividad asiento Code of Entry Activity @! - x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 133987 0
SF3 C0 F3_VALFECP N 14 2 Valor FECP Valor FECP FECP Value Valor do FECP Valor del FECP FECP Value @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x xx x - - - - - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133988 0
SF3 C1 F3_VFECPMT N 14 2 Vlr FECP-MT Val FECP-MT FECP-MT Vl Valor do FECP-MT Valor del FECP-MT FECP-MT Value @E 99,999,999,999.99 - x x x x x x x x x x x x x x x - - 1 - - - - S A - - - - - - - - - - - S - - S - N - - - 1 2 - - - 133989 0
SF3 C2 F3_VFESTMT N 14 2 V.FECP-ST/MT V.FECP-ST/MT FECP-ST/MT V Valor do FECP ST/MT Valor del FECP ST/MT FECP ST/MT Value @E 99,999,999,999.99 - x x x x x x x x x x x x x x x - - 1 - - - - S A - - - - - - - - - - - S - - S - N - - - 1 2 - - - 133990 0
SF3 C3 F3_ECF C 1 0 Gerado p/ECF Gener. p/ECF Gnrtd by ECF Gerado por ECF Generado por ECF Generated by ECF @! - x x x x x x x x x x x x x x x - - 1 - - - - - - - - - 1=Sim;2=Não 1=Si;2=No 1=Yes;2=No - - - - - S - - N N N - - - 1 2 - - - 133991 0
SF3 C4 F3_CRPRSIM N 16 2 Cr Pres Simp Cr Est Simp Simp Pres Cr Crd Pres Simples Crd Est Simples Simple Pres Credit @E 9,999,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x xx x - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 133992 0
SF3 C5 F3_DESCZFR N 14 2 Desc.ZFM Desc.ZFM ZFM Desc Desc. Zona Franca Manaus Desc. Zona Franca Manaus Desc.Manaus Free Trade Z. @E 999,999,999.99 - x x x x x x x x x x x x x x x - - 1 - - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133993 0
SF3 C6 F3_CREDNFE N 16 2 Créd. Conced Cred. Conced GrantedCred. Crédito concedido NF-e Credito concedido e-Fact e-Invoice Credit granted @E 9,999,999,999,999.99 - x x x x x x x x x x x x x x x - - 1 - - - - S A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 133994 0
SF3 C7 F3_CRPRERO N 14 2 Crd Pres RO Crd Pres RO RO Pres Crd Credito Pres. Rondonia Credito Pres. Rondonia Rondonia Pres. Credit @E 9,999,999,999.99 - x x x x x x x x x x x x x x x - - 1 - - - - N A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 133995 0
SF3 C8 F3_ANTICMS C 1 0 Antecip.ICMS Antic.ICMS ICMS Antecip Antecipação Tribut. ICMS Anticipo Tribut. ICMS ICMS Tax Anticipation @! - x x x x x x x x x x x x x x x - - 1 x xx x - - - - - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133996 0
SF3 C9 F3_NFISCAN C 9 0 Nota Fiscal Factura Invoice Nota Fiscal Cancelamento Factura Anulación Cancelation Invoice @! - x x x x x x x x x x x x x x x x - - 1 x x - - - N A R - - - - - - - - 018 - S - - N - N - - - 1 2 - - - 133997 0
SF3 D0 F3_ALIQPS3 N 6 2 Al. Pis ST Al. Pis ST PIS ST Tx Rt Aliquota Pis ST Alicuota Pis ST PIS ST tax rate @E 999.99 Positivo().And.MaFisRef("LF_ALIQPS3","MT100",M->F3_ALIQPS3) x x x x x x x x x x x x x x x - - 1 xxx - - - S - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 133998 0
SF3 D1 F3_ALIQIPI N 6 2 Aliq IPI Alic IPI Excise Tx % Aliq IPI Alic IPI Excise Tax Percentage @E 999.99 - x x x x x x x x x x x x x x x x - - 1 xxx - - - S A - - - - - - - - - - - S - - N - N - - - 1 2 - - - 133999 0
SF3 D2 F3_EMINFE D 8 0 Emissão NF-e Emision F E. Issue NF-e Emissão da NF Eletrônica Emision de la Fac Electr. Issue e-invoice @d - x x x x x x x x x x x x x x x - - 1 - - - - S A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 134000 0
SF3 D3 F3_NUMINI C 6 0 Num.DF Inic. Nº DF Inic. Init. TD Nbr Num. Doc. Fiscal Inicial Nº Doc. Fiscal Inicial Initial tax doc. number 999999 - x x x x x x x x x x x x x x x - - 1 x xx x - - - - - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 134001 0
SF3 D4 F3_VALTPDP N 14 2 Valor TPDP Valor TPDP TPDP Value Valor TPDP Valor TPDP TPDP Value @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x - - - N A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134002 0
SF3 D5 F3_TRIBMUN C 20 0 C. Trib. Mun C. Trib. Mun City Tax Cod Código de Trib. Municipal Código de Trib. Municipal City Tax Code @! - x x x x x x x x x x x x x x x x - - 1 x x xx x - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134003 0
SF3 D6 F3_VALFMD N 14 4 Valor Famad Valor Famad Famad Value Valor do Famad Valor del Famad Famad Value @E 999,999,999.9999 MaFisRef("LF_VALFMD","MT100",M->F3_VALFMD) x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134004 0
SF3 D7 F3_CPRESPR N 14 2 Cr Pres PR Cr Estim PR PR Pres Cr Cred Presumido Paraná Cred Estimado Parana Paraná Presumed Cred @E 9,999,999,999.99 - x x x x x x x x x x x x x x x - - 1 - - - - S A - - - - - - - - - - - S - - S N N - - - 1 2 - - - 134005 0
SF3 D8 F3_VALFMP N 14 2 Vl.Fumipeq Val.Fumipeq Fumipeq Vl Valor Fumipeq Valor Fumipeq Fumipeq Value @E 99,999,999,999.99 MaFisRef("LF_VALFMP","MT100",M->F3_VALFMP) x x x x x x x x x x x x x x x x - - 1 x - - - S A - - - - - - - - - - - S - - N - N - - - 1 2 - - - 134006 0
SF3 D9 F3_NUMFIM C 6 0 Num.DF Final Nº DF Final Final TD Nbr Num. Doc. Fiscal Final Nº Doc. Fiscal Final Final tax document number 999999 - x x x x x x x x x x x x x x x - - 1 x xx x - - - - - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 134007 0
SF3 E0 F3_CHVNFE C 44 0 Chave NFe Clave eFact NFe Key Chave da NFe SEFAZ Clave de la eFact y SEFAZ SEFAZ NFe Key @! - x x x x x x x x x x x x x x x x - - 1 x - - - N A R - - - - - - - - 183 - S - - N N N - - - 1 2 - - - 134008 0
SF3 E1 F3_BASEFMP N 14 2 Base Fumipeq Base Fumipeq Fumipeq Base Base Fumipeq Base Fumipeq Fumipeq Base @E 99,999,999,999.99 MaFisRef("LF_BASEFMP","MT100",M->F3_BASEFMP) x x x x x x x x x x x x x x x x - - 1 x - - - S A - - - - - - - - - - - S - - N - N - - - 1 2 - - - 134009 0
SF3 E2 F3_ALQFMP N 6 2 Aliq.Fumipeq Alic.Fumipeq Fumipeq Rate Aliquota Fumipeq Alicuota Fumipeq Fumipeq Rate @E 999.99 MaFisRef("LF_ALQFMP","MT100",M->F3_ALQFMP) x x x x x x x x x x x x x x x x - - 1 xxx xx - - - S A - - - - - - - - - - - S - - N - N - - - 1 2 - - - 134010 0
SF3 E3 F3_PERCINP N 5 2 Perc.INSS.Pt Porc.INSS.Pt EmplyrINSS% Percent. do INSS Patronal Porcent. de INSS Patronal Employer INSS Percentage @E 99.99 - x x x x x x x x x x x x x x x x - - 1 xxxx x - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134011 0
SF3 E4 F3_BASEPS3 N 14 2 Bs. Pis ST Bs. Pis ST PIS ST base Base Pis ST Base Pis ST PIS ST base @E 999,999,999.99 Positivo().And.MaFisRef("LF_BASEPS3","MT100",M->F3_BASEPS3) x x x x x x x x x x x x x x x - - 1 - - - - S - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 134012 0
SF3 E5 F3_ALIQCF3 N 6 2 Al. Cof ST Al. Cof ST PIS ST Tx Rt Aliquota Cofins ST Alicuota Cofins ST COFINS ST tax rate @E 999.99 Positivo().And.MaFisRef("LF_ALIQCF3","MT100",M->F3_ALIQCF3) x x x x x x x x x x x x x x x - - 1 xxx - - - S - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 134013 0
SF3 E6 F3_VFECPST N 14 2 Vlr FECP ST Vlr FECP ST FECP ST Vl. Valor do FECP ST Valor del FECP ST FECP ST Value @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 134014 0
SF3 E7 F3_DESCRET C 250 0 Desc retorno Desc retorno Return Desc Desc do retorno da Nfse Desc retorno de Factse Nfse Return Desc @! - x x x x x x x x x x x x x x x - - 1 - - - - N V R - - - - - - - - - - N - - N - N - - - 1 2 - - - 134015 0
SF3 E8 F3_CRPRESP N 14 2 Cr Pres SP Cr Est. SP SP Pres Cr Cred Presumido SP Cred Estimado SP Presumed Cred SP @E 9,999,999,999.99 - x x x x x x x x x x x x x x x - - 1 - - - - S A R - - - - - - - - - - S - - S N N - - - 1 2 - - - 134016 0
SF3 E9 F3_VALIMA N 14 2 Vlr. IMA-MT Val. IMA-MT IMA-MT Val Valor do IMA-MT Valor del IMA-MT IMA-MT Value @E 99,999,999,999.99 Positivo() x x x x x x x x x x x x x x x x - - 1 x xx - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134017 0
SF3 F0 F3_VFECPMG N 14 2 Vlr FECP-MG Vlr FECP-MG FECP-MG Vl Vlr FECP-MG Vlr FECP-MG FECP-MG Value @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134018 0
SF3 F1 F3_CLIDEST C 6 0 Cliente Dest Cliente Dest TargetClient Cliente de Destino Cliente de destino Target Client @! MaFisRef("LF_CLIDEST","MT100",M->F3_CLIDEST) x x x x x x x x x x x x x x x x - - 1 x xx - - - S A R - - - - - - - - 001 - S - - N - N - - - 1 2 - - - 134019 0
SF3 F2 F3_CRPREPR N 14 2 Crd Pres PR Crd Pres PR AssumdCredPR Crédito Presumido Paraná Crédito Presumido Paraná Paraná Assumed Credit @E 99,999,999,999.99 - x x x x x x x x x x x x x x x - - 1 x xx x - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 134020 0
SF3 F3 F3_OK C 2 0 Iden.Selecao Iden.Selecc. Selection Id Identificador de Selecao Ident. de Seleccion Selection Identifier - - x x x x x x x x x x x x x x x x - - 1 x - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 134021 0
SF3 F4 F3_VALFASE N 14 2 Vlr.FASE-MT Val.FASE-MT FASE-MT Val Valor do FASE-MT Valor del FASE-MT FASE-MT Value @E 99,999,999,999.99 Positivo() x x x x x x x x x x x x x x x x - - 1 x xx - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134022 0
SF3 F5 F3_CREDPRE N 14 2 Cr Pre RS Cr Pre RS Pre Cr RS Credito Presumido RS Credito Presumido RS RS Presumed Credit @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134023 0
SF3 F6 F3_LOJDEST C 2 0 Loja Dest Tda Dest Dest Store Loja Cliente de Destino Tda. Cliente de destino Destination Client Store @! MaFisRef("LF_LOJDEST","MT100",M->F3_LOJDEST) x x x x x x x x x x x x x x x x - - 1 x xx - - - S A R - - - - - - - - 002 - S - - N - N - - - 1 2 - - - 134024 0
SF3 F7 F3_CROUTSP N 14 2 Cr Out SP Cr Oto SP SP GrantCred Cred Outorgado SP Cred Otorgado SP SP Granted Credit @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 134025 0
SF3 F8 F3_VALINP N 14 2 Val.INSS.Pt Vlr.INSS.Pt EmplyrINSS V Valor do INSS Patronal Valor de INSS Patronal Employer INSS Value @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 xxxx x - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134026 0
SF3 F9 F3_VALFUM N 14 2 Vlr FUMACOP Vlr FUMACOP FUMACOP Vl. Valor do FUMACOP Valor del FUMACOP FUMACOP Value @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 xx x - - - S A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 134027 0
SF3 G0 F3_VFCPDIF N 14 2 Vlr FECP Dif Val FECP Dif Dest FU Vl FECP da UF de destino FECP de UF de destino FECP of Target State @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x xx - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134028 0
SF3 G1 F3_ISSMAT N 14 2 ISS Mat. ISS Mat. Material ISS Material Aplicado Material Aplicado Applied Material @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x xx x - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 134029 0
SF3 G2 F3_CLASCO C 2 0 Classe cons. Clase cons. Cons. Class Classe de consumo Clase de consumo Consumption Class 99 - x x x x x x x x x x x x x x x x - - 1 x x - - - N A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134030 0
SF3 G3 F3_DIFAL N 14 2 Difal ICMS Difal ICMS ICMS Difal Difal Origem/Destino Difal Origen/Destino Origin/Destination Difal @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x xx - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134031 0
SF3 G4 F3_BASEDES N 14 2 Base. Destin Base. Destin Target Basis Base Difal Destino Base Difal Destino Target Difal Basis @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x xx - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134032 0
SF3 G5 F3_BASEINP N 14 2 Bas.INSS.Pt Bas.INSS.Pt EmplyrINSS B Base do INSS Patronal Base del INSS Patronal Employer INSS Basis @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 xxxx x - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134033 0
SF3 G6 F3_LOJENT C 2 0 Loja Entrega Tda Entrega Deliv. Store Loja Entrega Tda Entrega Delivery Store @! - x x x x x x x x x x x x x x x x - - 1 x x x x - - - N A R - - - - - - - - 002 - S - - N N N - - - 1 2 - - - 134034 0
SF3 G7 F3_CLIENT C 6 0 Cliente Entr Cliente Entr Deliv.Cust. Cliente Entrega Cliente Entrega Delivery Customer @! - x x x x x x x x x x x x x x x x - - 1 x x x x - - - N A R - - - - - - - - 001 - S - - N N N - - - 1 2 - - - 134035 0
SF3 G8 F3_VLINCMG N 14 2 Vl.Inc.Leite Vl.Inc.Leche MilkIncValue Vl.Incentivo Prod.Leite Vl.Incentivo Prod.Leche Milk Prodctn Incentv Valu @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 134036 0
SF3 G9 F3_VALFDS N 14 2 Vl.Fundersul Vl.Fundersul FundrsulValu Valor do Fundersul Valor del Fundersul Fundersul Value @E 99,999,999,999.99 MaFisRef("LF_VALFDS","MT100",M->F3_VALFDS) x x x x x x x x x x x x x x x x - - 1 x xx x - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 134037 0
SF3 H0 F3_VFCPANT N 14 2 Vlr. FCP Ant Val. FCP Ant Prev FCP Valor do FCP Rec. Ant. Valor del FCP Rec. Ant. Prev Rec FCP Value @E 99,999,999,999.99 MaFisRef("LF_VFCPANT","MT100",M->F3_VFCPANT) x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134038 0
SF3 H1 F3_BSFCPST N 14 2 Base FCP ST Base FCP ST FCP ST base Base FCP ST Base FCP ST FCP ST base @E 99,999,999,999.99 MaFisRef("LF_BSFCPST","MT100",M->F3_BSFCPST) x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134039 0
SF3 H2 F3_CAT102 C 1 0 Port. CAT102 Port. CAT102 CAT102 Decr. Portaria CAT 102 Porteria CAT 102 Decree CAT 102 - - x x x x x x x x x x x x x x x '0' - 1 - - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 134040 0
SF3 H3 F3_CRPREPE N 14 2 Crd Pres PE Crd Pres PE PE Pres Crd Crédito Presumido Pernamb Credito Presumido Pernamb Pernambuco Presum. Credit @E 9,999,999,999.99 - x x x x x x x x x x x x x x x - - 1 - - - - - - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 134041 0
SF3 H4 F3_BSFCCMP N 14 2 Base FCP Cmp Base FCP Cmp Comp FCP bs Base FCP Complementar Base FCP Complementario Complementary FCP base @E 99,999,999,999.99 MaFisRef("LF_BSFCCMP","MT100",M->F3_BSFCCMP) x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134042 0
SF3 H5 F3_BFCPANT N 14 2 Base FCP Ant Base FCP Ant Prev FCP Base FCP Rec. Ant. Base FCP Rec. Ant. Previous Rec FCP Base @E 99,999,999,999.99 MaFisRef("LF_BFCPANT","MT100",M->F3_BFCPANT) x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134043 0
SF3 H6 F3_BASFECP N 14 2 Base FCP Pr. Base FCP Pr. Own FCP Base FCP Próprio Base FCP Propio Own FCP Base @E 99,999,999,999.99 MaFisRef("LF_BASFECP","MT100",M->F3_BASFECP) x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134044 0
SF3 H7 F3_GRUPONC C 2 0 Grp.Nat.Rec. Grup.Mod.Ing Inc Nat Grp Grupo Natureza da Receita Grupo modalidad ingreso Income Nature Group @! - x x x x x x x x x x x x x x x - - 1 - - - - N A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134045 0
SF3 H8 F3_INDNTFR C 1 0 Ind.Nat.Fret Ind.Mod.Flet Fr Nat Ind Ind.Nat.Frete Ind.Mod.Flete Freight Nature Ind @! - x x x x x x x x x x x x x x x - - 1 - - - - N A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134046 0
SF3 H9 F3_MALQCOF N 6 2 Aliq. COF M. Alíc. COF M. Inc COF Rat Aliquota COFINS Majorada Alícuota COFINS aumentada Increased COFINS Rate @E 999.99 - x x x x x x x x x x x x x x x - - 1 xxx - - - N A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134047 0
SF3 I0 F3_DTFIMNT D 8 0 Dt.Fim N. R Fch.Fin M. I Inc Nat End Data Fim Nat. Receita Fch. Fin. Modal. Ingreso Income Nature End Date - - x x x x x x x x x x x x x x x - - 1 - - - - N A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134048 0
SF3 I1 F3_MOTICMS C 1 0 Mot.Desone. Mot.Exenc. Exemp Reas Mot.Desone. ICMS Mot.Exención ICMS ICMS Exempt Reason @! - x x x x x x x x x x x x x x x - - 1 - - - - N A R - - 1=Táxi;2=Defic. Fisico;3=Prod.Agro.;4=Frotista/Locadora;5=Diplom./Consular;6=Util e Moto;07=SUFRAMA;8=Venda Org.Publico;9=Outros 1=Taxi;2=Minusválido;3=Prod.Agro.;4=PropFl/Arrendadora;5=Diplom./Consular;6=Util y Moto;07=SUFRAMA;8=Venta Org.Público;9=Otro 1=Taxi;2=Phys Disab;3=Agro. Prod;4=Fleet/Rental;5=Diplom./Consul;6=Useful and Moto;07=SUFRAMA;8=Publ Org Sales;9=Others - - - - - S - - N - N - - - 1 2 - - - 134049 0
SF3 I2 F3_MVALCOF N 14 2 Val. COF M. Val. COF M. Inc COF Vl Valor COFINS Majorada Valor COFINS aumentada Increased COFINS Value @E 99,999,999,999.99 - x x x x x x x x x x x x x x x - - 1 - - - - N A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134050 0
SF3 I3 F3_CNATREC C 3 0 Cod.Nat.Rec. Cód.Mod.Ing. Inv Nat Code Cod. Natureza da Receita Cód. Modalidad de ingreso Income Nature Code @! - x x x x x x x x x x x x x x x - - 1 - - - - N A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134051 0
SF3 I4 F3_BSICMOR N 16 2 BS.ICMS Ori. BS.ICMS Ori. Ori ICMS Bs Valor Original Base ICMS Valor original base ICMS ICMS Orig Base Value @E 9,999,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134052 0
SF3 I5 F3_TNATREC C 4 0 Tab.Nat.Rec Tab.Mod. Ing Inc Nat Tab Tabela Nat. da Receita Tabla Modal. de Ingresos Income Nature Table @! - x x x x x x x x x x x x x x x - - 1 - - - - N A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134053 0
SF3 I6 F3_VALII N 14 2 Vlr. Import. Val. Import. Import Vl Vlr. Imposto Importação Val. Impuesto importación Import Tax Vl @E 99,999,999,999.99 - x x x x x x x x x x x x x x x - - 1 - - - - N A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134054 0
SF3 I7 F3_VL43080 N 14 2 Vl.43080 Vl.43080 43080 Vl. Vl.ICMS s/ Debito Vl.ICMS s/ Debito ICMS Vl. w/o Debit @E 99,999,999,999.99 - x x x x x x x x x x x x x x x - - 1 - - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 134055 0
SF3 I8 F3_SERSAT C 9 0 Sér.SAT Ser.SAT SAT Series Série do SAT Serie del SAT SAT Series @! - x x x x x x x x x x x x x x x x - - 1 xx x - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134056 0
SF3 I9 F3_VLSENAR N 14 2 Valor Senar Valor Senar Senar Value Valor do Senar Valor del Senar Senar Value @E 99,999,999,999.99 MaFisRef("LF_VLSENAR","MT100",M->F3_VLSENAR) x x x x x x x x x x x x x x x - - 1 - - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 134057 0
SF3 J0 F3_DS43080 N 14 2 Desc.43080 Desc.43080 43080 Desc. Vl.Desc.43080 Vl.Desc.43080 43080 Vl. Desc. @E 99,999,999,999.99 - x x x x x x x x x x x x x x x - - 1 - - - - N - - - - - - - - - - - - S - - N N N - - - 1 2 - - - 134058 0
SF3 J1 F3_VALFUND N 14 2 Vlr.FUNDESA Val.FUNDESA FUNDESA Val Valor do FUNDESA Valor del FUNDESA FUNDESA Value @E 99,999,999,999.99 Positivo() x x x x x x x x x x x x x x x x - - 1 x xx - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134059 0
SF3 J2 F3_ALIQCPB N 6 2 Alíquota CPR Alícuota CPR CPR Rate Alíquota da CPRB Alícuota de la CPRB CPRB Rate @E 999.99 - x x x x x x x x x x x x x x x x - - 1 xxx - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134060 0
SF3 J3 F3_SDOCMAN C 3 0 Série Manual Serie Manual Manual Inv. Série Doc. Manual Serie Doc. Manual Manual Invoice Series !!! - x x x x x x x x x x x x x x x - - 1 xx x - - - N V R - - - - - - - - 095 - S - - N - N - - - 1 2 - - - 134061 0
SF3 J4 F3_VALTST N 14 2 Val. ST tran Val. ST tran T.Syt.Value Valor ICMS ST transporte Valor ICMS ST transporte Transport S.ICMS Value @E 999,999,999.99 Positivo() .And. MaFisRef("LF_VALTST","MT100",M->F3_VALTST) x x x x x x x x x x x x x x x x - - 1 xxxx x - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 134062 0
SF3 J5 F3_ATIVCPB C 8 0 Cód. Ativ. Cód. Activ. Activity Cod Cód. Atividade da CPRB Cód. Actividad de la CPRB CPRB Activity Code @! - x x x x x x x x x x x x x x x x - - 1 x x - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134063 0
SF3 J6 F3_VALFUN N 14 2 Vlr FUNRURAL Val FUNRURAL FUNRURAL Vl. Valor do FUNRURAL Valor del FUNRURAL FUNRURAL Value @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134064 0
SF3 J7 F3_VFESTMG N 14 2 V.FECP-ST/MG V.FECP-ST/MG FECP-ST/MG V Valor do FECP ST/MG Valor del FECP ST/MG FECP ST/MG Value @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134065 0
SF3 J8 F3_BASEFUN N 14 2 Bas.FUNRURAL Bas.FUNRURAL FUNRURAL Bas Base de Calculo FUNRURAL Base de cálculo FUNRURAL FUNRURAL Calculation Base @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134066 0
SF3 J9 F3_BASECPB N 14 2 Base CPRB Base CPRB CPRB Base Base da CPRB Base de la CPRB CPRB Base @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134067 0
SF3 K0 F3_BASNDES N 14 2 B.ICMS ST An B.ICMS ST An Prev ST ICMS Base ICMS ST Recolh. Ant. Base ICMS ST Pago Ant. Prev Collect ST ICMS Base @E 99,999,999,999.99 MaFisRef("LF_BASNDES","MT100",M->F3_BASNDES) .And. Positivo() x x x x x x x x x x x x x x x x - - 1 x - - - N A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134068 0
SF3 K1 F3_VFECPRN N 14 2 Vlr FECOP-RN Val FECOP-RN FECOP-RN Val Valor do FECOP-RN Valor del FECOP-RN FECOP-RN Value @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 134069 0
SF3 K2 F3_VFESTRN N 14 2 V.FECOP-ST/R V.FECOP-ST/R FECOP-ST/R V Valor do FECOP ST/RN Valor del FECOP ST/RN FECOP ST/RN Value @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 134070 0
SF3 K3 F3_BASETST N 14 2 Base ST tran Base ST tran T.Sys.Basis Base ICMS ST transporte Base ICMS ST transporte Transport S.ICMS Basis @E 999,999,999.99 Positivo() .And. MaFisRef("LF_BASETST","MT100",M->F3_BASETST) x x x x x x x x x x x x x x x x - - 1 xxxx x - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 134071 0
SF3 K4 F3_CODRET C 10 0 Cod retorno Cod retorno Return Code Codigo de retorno da Nfse Codigo retorno de Factse Nfse Return Code - - x x x x x x x x x x x x x x x x - - 1 x - - - N V R - - - - - - - - - - N - - N - N - - - 1 2 - - - 134072 0
SF3 K5 F3_ICMNDES N 14 2 ICMS ST Ant. ICMS ST Ant. Prev ST ICMS Valor ICMS ST Anterior Valor ICMS ST Anterior Prev ST ICMS Value @E 99,999,999,999.99 MaFisRef("LF_ICMNDES","MT100",M->F3_ICMNDES) .And. Positivo() x x x x x x x x x x x x x x x x - - 1 x - - - N A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134073 0
SF3 K6 F3_VREINT N 14 2 V.Reintegra V.Reintegra Reintegra V. Valor Reintegra Valor Reintegra Reintegra Value @E 99,999,999,999.99 - x x x x x x x x x x x x x x x - - 1 - - - - S A R - - - - - - - - - - S - - S - N - - - 1 2 - - - 134074 0
SF3 K7 F3_VALCPB N 14 2 Valor CPRB Valor CPRB Value CPRB Valor da CPRB Valor de la CPRB CPRB Value @E 99,999,999,999.99 - x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 134075 0
SF3 K8 F3_BSREIN N 14 2 B.C.Reinteg B.C.Reinteg Reinteg.C.B. Base Calc.Reintegra Base Calc.Reintegra Reintegration Calc. Base @E 99,999,999,999.99 - x x x x x x x x x x x x x x x - - 1 - - - - S A R - - - - - - - - - - S - - S - N - - - 1 2 - - - 134076 0
SF3 K9 F3_SDOC C 3 0 Série Doc. Serie Doc. Series Doc. Série do Documento Fiscal Serie de Documento Fiscal Invoice Series !!! - x x x x x x x x x x x x x x x - - 1 xx x - - - N V R - - - - - - - - 095 - S - - N - N - - - 1 2 - - - 134077 0

Índices da Tabela SF3 (12 índices)

INDICE ORDEM CHAVE DESCRICAO DESCSPA DESCENG PROPRI F3 NICKNAME SHOWPESQ IX_VIRTUAL IX_VIRCUST D_E_L_E_T_ R_E_C_N_O_ R_E_C_D_E_L_
SF3 1 F3_FILIAL+DTOS(F3_ENTRADA)+F3_NFISCAL+F3_SERIE+F3_CLIEFOR+F3_LOJA+F3_CFO+STR(F3_ALIQICM,5,2) DT Entrada + Nota Fiscal + Serie N.F. + Clien/Fornec + Loja + Cod. Fis Fch Entrada + Factura + Serie Fact. + Clien/Provee + Tienda + Cod. Fis Inflow Date + Invoice + Inv.Series + Cust./Sup. + Unit + Fiscal Code + S XXX+XXX+XXX+XXX+XXX+13 - S 2 3 - 19297 0
SF3 2 F3_FILIAL+F3_ESTADO Estado Ref. Estado Ref. State S 12 - S 2 3 - 19298 0
SF3 3 F3_FILIAL+F3_CFO Cod. Fiscal Cod. Fiscal Fiscal Code S 13 - S 2 3 - 19299 0
SF3 4 F3_FILIAL+F3_CLIEFOR+F3_LOJA+F3_NFISCAL+F3_SERIE Clien/Fornec + Loja + Nota Fiscal + Serie N.F. Clien/Provee + Tienda + Factura + Serie Fact. Cust./Sup. + Unit + Invoice + Inv.Series S - - S 2 3 - 19300 0
SF3 5 F3_FILIAL+F3_SERIE+F3_NFISCAL+F3_CLIEFOR+F3_LOJA+F3_IDENTFT+DTOS(F3_ENTRADA)+F3_ESPECIE Serie N.F. + Nota Fiscal + Clien/Fornec + Loja + Ident. SFT + DT Entra Serie Fact. + Factura + Clien/Provee + Tienda + Ident. SFT + Fch Entra Inv.Series + Invoice + Cust./Sup. + Unit + SFT Ident. + Inflow Date + S - - S 2 3 - 19301 0
SF3 6 F3_FILIAL+F3_NFISCAL+F3_SERIE Nota Fiscal + Serie N.F. Factura + Serie Fact. Invoice + Inv.Series S - - S 2 3 - 19302 0
SF3 7 F3_FILIAL+F3_DOCPRE N§ Doc.Pre. Nro.Doc.Pre. Pre.Doc.Num. S - - S 2 3 - 19303 0
SF3 8 F3_FILIAL+F3_NFELETR+DTOS(F3_EMINFE)+F3_CLIEFOR+F3_LOJA NF Eletr. + Emissão NF-e + Clien/Fornec + Loja Fact Electr. + Emision F E. + Clien/Provee + Tienda Elect. Inv. + Issue NF-e + Cust./Sup. + Unit S - - S 2 3 - 19304 0
SF3 9 F3_FILIAL+DTOS(F3_ENTRADA)+F3_NFISCAL+F3_SDOC+F3_CLIEFOR+F3_LOJA+F3_CFO+STR(F3_ALIQICM,5,2) DT Entrada + Nota Fiscal + Série Doc. + Clien/Fornec + Loja + Cod. Fis Fch Entrada + Factura + Serie Doc. + Clien/Provee + Tienda + Cod. Fisc Inflow Date + Invoice + Series Doc. + Cust./Sup. + Unit + Fiscal Code S XXX+XXX+XXX+XXX+XXX+13 - N 2 3 - 19305 0
SF3 A F3_FILIAL+F3_CLIEFOR+F3_LOJA+F3_NFISCAL+F3_SDOC Clien/Fornec + Loja + Nota Fiscal + Série Doc. Clien/Provee + Tienda + Factura + Serie Doc. Cust./Sup. + Unit + Invoice + Series Doc. S - - N 2 3 - 19306 0
SF3 B F3_FILIAL+F3_SDOC+F3_NFISCAL+F3_CLIEFOR+F3_LOJA+F3_IDENTFT+DTOS(F3_ENTRADA)+F3_ESPECIE Série Doc. + Nota Fiscal + Clien/Fornec + Loja + Ident. SFT + DT Entra Serie Doc. + Factura + Clien/Provee + Tienda + Ident. SFT + Fch Entrad Series Doc. + Invoice + Cust./Sup. + Unit + SFT Ident. + Inflow Date + S - - N 2 3 - 19307 0
SF3 C F3_FILIAL+F3_NFISCAL+F3_SDOC Nota Fiscal + Série Doc. Factura + Serie Doc. Invoice + Series Doc. S - - N 2 3 - 19308 0

Perguntas frequentes

Para que serve a tabela SF3 no Protheus?

Ela é utilizada para livros fiscais dentro do sistema ERP Protheus.

Como consultar os campos da tabela SF3?

Nesta página você pode visualizar todos os campos, incluindo tipo, tamanho e validações.

O que são os índices da tabela SF3?

Os índices são estruturas que melhoram a performance de busca e acesso aos dados dentro do Protheus.

Exemplo de consulta SQL da tabela SF3

Modelo de query gerado automaticamente com base na estrutura da tabela. 

SELECT
    F3_CLIDVMC,
    F3_LOJDVMC,
    F3_BASECPR,
    F3_REPROC,
    F3_ENTRADA,
    F3_NFISCAL,
    F3_SERIE,
    F3_CLIEFOR,
    F3_LOJA,
    F3_CFO,
    F3_CODISS,
    F3_ESTADO,
    F3_EMISSAO,
    F3_CONTA,
    F3_ALIQICM,
    F3_VALCONT,
    F3_BASEICM,
    F3_VALICM,
    F3_ISENICM,
    F3_OUTRICM,
    F3_BASEIPI,
    F3_VALIPI,
    F3_ISENIPI,
    F3_OUTRIPI,
    F3_OBSERV,
    F3_VALOBSE,
    F3_ICMSRET,
    F3_TIPO,
    F3_LANCAM,
    F3_DOCOR,
    F3_ICMSCOM,
    F3_IPIOBS,
    F3_NRLIVRO,
    F3_ICMAUTO,
    F3_BASERET,
    F3_FORMUL,
    F3_ESPECIE,
    F3_FORMULA,
    F3_DESPESA,
    F3_PDV,
    F3_BASIMP1,
    F3_BASIMP2,
    F3_BASIMP3,
    F3_BASIMP4,
    F3_BASIMP5,
    F3_BASIMP6,
    F3_ALQIMP1,
    F3_ALQIMP2,
    F3_ALQIMP3,
    F3_ALQIMP4,
    F3_ALQIMP5,
    F3_ALQIMP6,
    F3_VALIMP1,
    F3_VALIMP2,
    F3_VALIMP3,
    F3_VALIMP4,
    F3_VALIMP5,
    F3_VALIMP6,
    F3_RETIMP1,
    F3_RETIMP2,
    F3_RETIMP3,
    F3_RETIMP4,
    F3_RETIMP5,
    F3_RETIMP6,
    F3_DTLANC,
    F3_FILIAL,
    F3_DTCANC,
    F3_DOCPRE,
    F3_ISSST,
    F3_CRDPCTR,
    F3_CRPRELE,
    F3_CREDST,
    F3_MDCAT79,
    F3_CRDPRES,
    F3_NFEMP,
    F3_ICMSDIF,
    F3_TRFICM,
    F3_OBSICM,
    F3_OBSSOL,
    F3_SOLTRIB,
    F3_CFOEXT,
    F3_SIMPLES,
    F3_CRDZFM,
    F3_RECISS,
    F3_IDENTFT,
    F3_CRPRST,
    F3_CPPRODE,
    F3_TPPRODE,
    F3_CSTPIS,
    F3_ABATISS,
    F3_CSTCOF,
    F3_CODBCC,
    F3_DESCFIS,
    F3_HORNFE,
    F3_ALQCPM,
    F3_CREDACU,
    F3_BASECPM,
    F3_CRDEST,
    F3_VALCPM,
    F3_CRDTRAN,
    F3_PROTOC,
    F3_CODRSEF,
    F3_VALFET,
    F3_VALFAB,
    F3_VALFAC,
    F3_CODNFE,
    F3_VALANTI,
    F3_ISSSUB,
    F3_VALCF3,
    F3_NFELETR,
    F3_VALPS3,
    F3_CFPS,
    F3_ESTCRED,
    F3_BASECF3,
    F3_CSTISS,
    F3_CROUTGO,
    F3_VALPEDG,
    F3_NUMRPS,
    F3_CNAE,
    F3_VALFECP,
    F3_VFECPMT,
    F3_VFESTMT,
    F3_ECF,
    F3_CRPRSIM,
    F3_DESCZFR,
    F3_CREDNFE,
    F3_CRPRERO,
    F3_ANTICMS,
    F3_NFISCAN,
    F3_ALIQPS3,
    F3_ALIQIPI,
    F3_EMINFE,
    F3_NUMINI,
    F3_VALTPDP,
    F3_TRIBMUN,
    F3_VALFMD,
    F3_CPRESPR,
    F3_VALFMP,
    F3_NUMFIM,
    F3_CHVNFE,
    F3_BASEFMP,
    F3_ALQFMP,
    F3_PERCINP,
    F3_BASEPS3,
    F3_ALIQCF3,
    F3_VFECPST,
    F3_DESCRET,
    F3_CRPRESP,
    F3_VALIMA,
    F3_VFECPMG,
    F3_CLIDEST,
    F3_CRPREPR,
    F3_OK,
    F3_VALFASE,
    F3_CREDPRE,
    F3_LOJDEST,
    F3_CROUTSP,
    F3_VALINP,
    F3_VALFUM,
    F3_VFCPDIF,
    F3_ISSMAT,
    F3_CLASCO,
    F3_DIFAL,
    F3_BASEDES,
    F3_BASEINP,
    F3_LOJENT,
    F3_CLIENT,
    F3_VLINCMG,
    F3_VALFDS,
    F3_VFCPANT,
    F3_BSFCPST,
    F3_CAT102,
    F3_CRPREPE,
    F3_BSFCCMP,
    F3_BFCPANT,
    F3_BASFECP,
    F3_GRUPONC,
    F3_INDNTFR,
    F3_MALQCOF,
    F3_DTFIMNT,
    F3_MOTICMS,
    F3_MVALCOF,
    F3_CNATREC,
    F3_BSICMOR,
    F3_TNATREC,
    F3_VALII,
    F3_VL43080,
    F3_SERSAT,
    F3_VLSENAR,
    F3_DS43080,
    F3_VALFUND,
    F3_ALIQCPB,
    F3_SDOCMAN,
    F3_VALTST,
    F3_ATIVCPB,
    F3_VALFUN,
    F3_VFESTMG,
    F3_BASEFUN,
    F3_BASECPB,
    F3_BASNDES,
    F3_VFECPRN,
    F3_VFESTRN,
    F3_BASETST,
    F3_CODRET,
    F3_ICMNDES,
    F3_VREINT,
    F3_VALCPB,
    F3_BSREIN,
    F3_SDOC
FROM SF3
WHERE
    D_E_L_E_T_ = ' '
    AND F3_CLIDVMC = 'VALOR'
    AND F3_LOJDVMC = 'VALOR'
    AND F3_BASECPR = 0
    AND F3_REPROC = 'VALOR'
    AND F3_ENTRADA BETWEEN '20260401' AND '20260430'
    AND F3_NFISCAL = 'VALOR'
    AND F3_SERIE = 'VALOR'
    AND F3_CLIEFOR = 'VALOR'
    AND F3_LOJA = 'VALOR'
    AND F3_CFO = 'VALOR'
    AND F3_CODISS = 'VALOR'
    AND F3_ESTADO = 'VALOR'
    AND F3_EMISSAO BETWEEN '20260401' AND '20260430'
    AND F3_CONTA = 'VALOR'
    AND F3_ALIQICM = 0
    AND F3_VALCONT = 0
    AND F3_BASEICM = 0
    AND F3_VALICM = 0
    AND F3_ISENICM = 0
    AND F3_OUTRICM = 0
    AND F3_BASEIPI = 0
    AND F3_VALIPI = 0
    AND F3_ISENIPI = 0
    AND F3_OUTRIPI = 0
    AND F3_OBSERV = 'VALOR'
    AND F3_VALOBSE = 0
    AND F3_ICMSRET = 0
    AND F3_TIPO = 'VALOR'
    AND F3_LANCAM = 'VALOR'
    AND F3_DOCOR = 'VALOR'
    AND F3_ICMSCOM = 0
    AND F3_IPIOBS = 0
    AND F3_NRLIVRO = 'VALOR'
    AND F3_ICMAUTO = 0
    AND F3_BASERET = 0
    AND F3_FORMUL = 'VALOR'
    AND F3_ESPECIE = 'VALOR'
    AND F3_FORMULA = 'VALOR'
    AND F3_DESPESA = 0
    AND F3_PDV = 'VALOR'
    AND F3_BASIMP1 = 0
    AND F3_BASIMP2 = 0
    AND F3_BASIMP3 = 0
    AND F3_BASIMP4 = 0
    AND F3_BASIMP5 = 0
    AND F3_BASIMP6 = 0
    AND F3_ALQIMP1 = 0
    AND F3_ALQIMP2 = 0
    AND F3_ALQIMP3 = 0
    AND F3_ALQIMP4 = 0
    AND F3_ALQIMP5 = 0
    AND F3_ALQIMP6 = 0
    AND F3_VALIMP1 = 0
    AND F3_VALIMP2 = 0
    AND F3_VALIMP3 = 0
    AND F3_VALIMP4 = 0
    AND F3_VALIMP5 = 0
    AND F3_VALIMP6 = 0
    AND F3_RETIMP1 = 0
    AND F3_RETIMP2 = 0
    AND F3_RETIMP3 = 0
    AND F3_RETIMP4 = 0
    AND F3_RETIMP5 = 0
    AND F3_RETIMP6 = 0
    AND F3_DTLANC BETWEEN '20260401' AND '20260430'
    AND F3_FILIAL = 'VALOR'
    AND F3_DTCANC BETWEEN '20260401' AND '20260430'
    AND F3_DOCPRE = 'VALOR'
    AND F3_ISSST = 'VALOR'
    AND F3_CRDPCTR = 0
    AND F3_CRPRELE = 0
    AND F3_CREDST = 'VALOR'
    AND F3_MDCAT79 = 'VALOR'
    AND F3_CRDPRES = 0
    AND F3_NFEMP = 'VALOR'
    AND F3_ICMSDIF = 0
    AND F3_TRFICM = 0
    AND F3_OBSICM = 0
    AND F3_OBSSOL = 0
    AND F3_SOLTRIB = 0
    AND F3_CFOEXT = 'VALOR'
    AND F3_SIMPLES = 0
    AND F3_CRDZFM = 0
    AND F3_RECISS = 'VALOR'
    AND F3_IDENTFT = 'VALOR'
    AND F3_CRPRST = 0
    AND F3_CPPRODE = 0
    AND F3_TPPRODE = 'VALOR'
    AND F3_CSTPIS = 'VALOR'
    AND F3_ABATISS = 0
    AND F3_CSTCOF = 'VALOR'
    AND F3_CODBCC = 'VALOR'
    AND F3_DESCFIS = 0
    AND F3_HORNFE = 'VALOR'
    AND F3_ALQCPM = 0
    AND F3_CREDACU = 'VALOR'
    AND F3_BASECPM = 0
    AND F3_CRDEST = 0
    AND F3_VALCPM = 0
    AND F3_CRDTRAN = 0
    AND F3_PROTOC = 'VALOR'
    AND F3_CODRSEF = 'VALOR'
    AND F3_VALFET = 0
    AND F3_VALFAB = 0
    AND F3_VALFAC = 0
    AND F3_CODNFE = 'VALOR'
    AND F3_VALANTI = 0
    AND F3_ISSSUB = 0
    AND F3_VALCF3 = 0
    AND F3_NFELETR = 'VALOR'
    AND F3_VALPS3 = 0
    AND F3_CFPS = 'VALOR'
    AND F3_ESTCRED = 0
    AND F3_BASECF3 = 0
    AND F3_CSTISS = 'VALOR'
    AND F3_CROUTGO = 0
    AND F3_VALPEDG = 0
    AND F3_NUMRPS = 'VALOR'
    AND F3_CNAE = 'VALOR'
    AND F3_VALFECP = 0
    AND F3_VFECPMT = 0
    AND F3_VFESTMT = 0
    AND F3_ECF = 'VALOR'
    AND F3_CRPRSIM = 0
    AND F3_DESCZFR = 0
    AND F3_CREDNFE = 0
    AND F3_CRPRERO = 0
    AND F3_ANTICMS = 'VALOR'
    AND F3_NFISCAN = 'VALOR'
    AND F3_ALIQPS3 = 0
    AND F3_ALIQIPI = 0
    AND F3_EMINFE BETWEEN '20260401' AND '20260430'
    AND F3_NUMINI = 'VALOR'
    AND F3_VALTPDP = 0
    AND F3_TRIBMUN = 'VALOR'
    AND F3_VALFMD = 0
    AND F3_CPRESPR = 0
    AND F3_VALFMP = 0
    AND F3_NUMFIM = 'VALOR'
    AND F3_CHVNFE = 'VALOR'
    AND F3_BASEFMP = 0
    AND F3_ALQFMP = 0
    AND F3_PERCINP = 0
    AND F3_BASEPS3 = 0
    AND F3_ALIQCF3 = 0
    AND F3_VFECPST = 0
    AND F3_DESCRET = 'VALOR'
    AND F3_CRPRESP = 0
    AND F3_VALIMA = 0
    AND F3_VFECPMG = 0
    AND F3_CLIDEST = 'VALOR'
    AND F3_CRPREPR = 0
    AND F3_OK = 'VALOR'
    AND F3_VALFASE = 0
    AND F3_CREDPRE = 0
    AND F3_LOJDEST = 'VALOR'
    AND F3_CROUTSP = 0
    AND F3_VALINP = 0
    AND F3_VALFUM = 0
    AND F3_VFCPDIF = 0
    AND F3_ISSMAT = 0
    AND F3_CLASCO = 'VALOR'
    AND F3_DIFAL = 0
    AND F3_BASEDES = 0
    AND F3_BASEINP = 0
    AND F3_LOJENT = 'VALOR'
    AND F3_CLIENT = 'VALOR'
    AND F3_VLINCMG = 0
    AND F3_VALFDS = 0
    AND F3_VFCPANT = 0
    AND F3_BSFCPST = 0
    AND F3_CAT102 = 'VALOR'
    AND F3_CRPREPE = 0
    AND F3_BSFCCMP = 0
    AND F3_BFCPANT = 0
    AND F3_BASFECP = 0
    AND F3_GRUPONC = 'VALOR'
    AND F3_INDNTFR = 'VALOR'
    AND F3_MALQCOF = 0
    AND F3_DTFIMNT BETWEEN '20260401' AND '20260430'
    AND F3_MOTICMS = 'VALOR'
    AND F3_MVALCOF = 0
    AND F3_CNATREC = 'VALOR'
    AND F3_BSICMOR = 0
    AND F3_TNATREC = 'VALOR'
    AND F3_VALII = 0
    AND F3_VL43080 = 0
    AND F3_SERSAT = 'VALOR'
    AND F3_VLSENAR = 0
    AND F3_DS43080 = 0
    AND F3_VALFUND = 0
    AND F3_ALIQCPB = 0
    AND F3_SDOCMAN = 'VALOR'
    AND F3_VALTST = 0
    AND F3_ATIVCPB = 'VALOR'
    AND F3_VALFUN = 0
    AND F3_VFESTMG = 0
    AND F3_BASEFUN = 0
    AND F3_BASECPB = 0
    AND F3_BASNDES = 0
    AND F3_VFECPRN = 0
    AND F3_VFESTRN = 0
    AND F3_BASETST = 0
    AND F3_CODRET = 'VALOR'
    AND F3_ICMNDES = 0
    AND F3_VREINT = 0
    AND F3_VALCPB = 0
    AND F3_BSREIN = 0
    AND F3_SDOC = 'VALOR'