Tabela
SF3 Livros Fiscais
Campo Tipo Tamanho Decimal Titulo Formato Validacao F3 Contexto Lista Condicao PYME
F3_REPROC C 1 0 Perm.Reproc. @! pertence("SN") S=Sim;N=Nao S
F3_ENTRADA D 8 0 DT Entrada FisChkDt(M->F3_ENTRADA) S
F3_NFISCAL C 9 0 Nota Fiscal @! A900VerCpo() S
F3_SERIE C 3 0 Serie N.F. !!! A900VerCpo() S
F3_CLIEFOR C 6 0 Clien/Fornec @! A900VerCpo() S
F3_LOJA C 2 0 Loja @! A900VerCpo() S
F3_CFO C 5 0 Cod. Fiscal @9 NaoVazio() .and. EXISTCPO("SX5","13"+M->F3_CFO) 13 S
F3_CODISS C 9 0 Cod.Serv.ISS @9 A900VerCpo() .And. (Vazio() .OR. EXISTCPO("SX5","60"+M->F3_CODISS)) 60 S
F3_ESTADO C 2 0 Estado Ref. @! ExistCpo("SX5","12"+M->F3_ESTADO) .and. A900VerCpo() S
F3_EMISSAO D 8 0 Emissao N.F. A900VerCpo() S
F3_CONTA C 20 0 Conta Contab @! S
F3_ALIQICM N 5 2 Aliq. ICMS @E 99.99 A900VerCpo() S
F3_VALCONT N 14 2 Vlr.Contabil @E 99,999,999,999.99 S
F3_BASEICM N 14 2 Base p/ICMS @E 99,999,999,999.99 S
F3_VALICM N 14 2 ICMS Tribut. @E 99,999,999,999.99 S
F3_ISENICM N 14 2 ICMS Isento @E 99,999,999,999.99 S
F3_OUTRICM N 14 2 ICMS Outros @E 99,999,999,999.99 S
F3_BASEIPI N 14 2 Base de IPI @E 99,999,999,999.99 S
F3_VALIPI N 14 2 IPI Tribut. @E 99,999,999,999.99 S
F3_ISENIPI N 14 2 IPI Isento @E 99,999,999,999.99 S
F3_OUTRIPI N 14 2 IPI Outros @E 99,999,999,999.99 S
F3_OBSERV C 40 0 Observacoes @! S
F3_VALOBSE N 14 2 Desconto @E 99,999,999,999.99 S
F3_ICMSRET N 14 2 ICMS Retido @E 99,999,999,999.99 S
F3_TIPO C 1 0 Tipo @! A900VerCpo() L=Nota Em Lote;S=Nota com ISS;B=Beneficiamento;D=Devolucao;C=Complemento;P=Comp. IPI;I=Comp. ICMS S
F3_LANCAM C 6 0 N. Lancam. @! A900VerCpo() S
F3_DOCOR C 9 0 Doc.Original @! A900VerCpo() S
F3_ICMSCOM N 14 2 ICMS Complem @E 99,999,999,999.99 S
F3_IPIOBS N 14 2 IPI na Obs @E 99,999,999,999.99 S
F3_NRLIVRO C 1 0 Nr do Livro @! Pertence(" 1234567890") S
F3_ICMAUTO N 14 2 Icms autonom @E 99,999,999,999.99 S
F3_BASERET N 14 2 Bs Icms Ret @E 99,999,999,999.99 S
F3_FORMUL C 1 0 Form.Proprio @! Pertence("SN ") S=Sim;N=Nao S
F3_ESPECIE C 5 0 Espec.Docum. @! Vazio().or.ExistCpo("SX5","42"+M->F3_ESPECIE) 42 S
F3_FORMULA C 3 0 Formula @! S
F3_DESPESA N 14 2 Desp.Acesso. @E 999,999,999,999.99 S
F3_PDV C 10 0 Nro. PDV @! S
F3_BASIMP1 N 14 2 Base Imp. 1 @E 99,999,999,999.99 S
F3_BASIMP2 N 14 2 Base Imp. 2 @E 99,999,999,999.99 S
F3_BASIMP3 N 14 2 Base Imp. 3 @E 99,999,999,999.99 S
F3_BASIMP4 N 14 2 Base Imp. 4 @E 99,999,999,999.99 S
F3_BASIMP5 N 14 2 Base Imp. 5 @E 99,999,999,999.99 S
F3_BASIMP6 N 14 2 Base Imp. 6 @E 99,999,999,999.99 S
F3_ALQIMP1 N 6 2 Aliq. Imp. 1 @E 999.99 S
F3_ALQIMP2 N 6 2 Aliq. Imp. 2 @E 999.99 S
F3_ALQIMP3 N 6 2 Aliq. Imp. 3 @E 999.99 S
F3_ALQIMP4 N 6 2 Aliq. Imp. 4 @E 999.99 S
F3_ALQIMP5 N 6 2 Aliq. Imp. 5 @E 999.99 S
F3_ALQIMP6 N 6 2 Aliq. Imp. 6 @E 999.99 S
F3_VALIMP1 N 14 2 Valor Imp. 1 @E 99,999,999,999.99 S
F3_VALIMP2 N 14 2 Valor Imp. 2 @E 99,999,999,999.99 S
F3_VALIMP3 N 14 2 Valor Imp. 3 @E 99,999,999,999.99 S
F3_VALIMP4 N 14 2 Valor Imp. 4 @E 99,999,999,999.99 S
F3_VALIMP5 N 14 2 Valor Imp. 5 @E 99,999,999,999.99 S
F3_VALIMP6 N 14 2 Valor Imp. 6 @E 99,999,999,999.99 S
F3_RETIMP1 N 14 2 Reten.Imp. 1 @E 99,999,999,999.99 S
F3_RETIMP2 N 14 2 Reten.Imp. 2 @E 99,999,999,999.99 S
F3_RETIMP3 N 14 2 Reten.Imp. 3 @E 99,999,999,999.99 S
F3_RETIMP4 N 14 2 Reten.Imp. 4 @E 99,999,999,999.99 S
F3_RETIMP5 N 14 2 Reten.Imp. 5 @E 99,999,999,999.99 S
F3_RETIMP6 N 14 2 Reten.Imp. 6 @E 99,999,999,999.99 S
F3_DTLANC D 8 0 Dt. lancto. S
F3_FILIAL C 2 0 Filial S
F3_DTCANC D 8 0 Dt. Cancel. S
F3_DOCPRE C 12 0 N§ Doc.Pre. ExistChav("SF3",M->F3_DOCPRE,7) S
F3_ISSST C 1 0 Pgto Imposto @! R 1=Dentro Municipio;2=Fora Municipio;3=Isencao;4=Imune;5=Exigibilidade Susp. Judicial;6=Exigibilidade Susp. Proc. Adm. S
F3_CRDPRES N 14 2 Crd. Pres. @E 999,999,999.99 N
F3_CREDST C 1 0 Cred/Deb ST @! S
F3_CRPRELE N 16 2 Vlr Cr Pr El @E 9,999,999,999.99 R S
F3_MDCAT79 C 32 0 Md5 Cat79 @! S
F3_CRDPCTR N 14 2 Crd.Pres.Car @E 99,999,999,999.99 R S
F3_NFEMP C 74 0 Nota de Emp. R S
F3_ICMSDIF N 14 2 ICM Diferido @E 99,999,999,999.99 S
F3_TRFICM N 14 2 Trf.Deb/Crd. @e 999,999,999.99 Positivo() S
F3_OBSICM N 12 2 Icm Observ. @E 99,999,999.99 Positivo() S
F3_OBSSOL N 12 2 Solid. Obs. @E 99,999,999.99 Positivo() S
F3_SOLTRIB N 12 2 ICM.Sol.Trib @E 99,999,999.99 Positivo() S
F3_CFOEXT C 3 0 CFOP Est. @! R S
F3_SIMPLES N 14 2 Simples @E 99999999999.99 S
F3_CRDZFM N 14 2 Cred. ZFM @E 99,999,999,999.99 S
F3_RECISS C 1 0 Recolhe ISS S
F3_IDENTFT C 6 0 Ident. SFT R S
F3_CRPRST N 16 2 Cr Pr ST @E 9,999,999,999.99 R S
F3_CPPRODE N 14 2 Crd.PRODEPE @E 99,999,999,999.99 S
F3_TPPRODE C 1 0 Tipo PRODEPE pertence(" 0123456789") 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. S
F3_CNAE C 9 0 CNAE @! R S
F3_CRDTRAN N 14 2 Crd.Transp. @E 999,999,999.99 S
F3_ECF C 1 0 Gerado p/ECF @! 1=Sim;2=Nao S
F3_DESCZFR N 14 2 Desc.ZFM @E 999,999,999.99 S
F3_BASEPS3 N 14 2 Bs. Pis ST @E 999,999,999.99 Positivo().And.MaFisRef("LF_BASEPS3","MT100",M->F3_BASEPS3) S
F3_ALIQPS3 N 5 2 Al. Pis ST @E 99.99 Positivo().And.MaFisRef("LF_ALIQPS3","MT100",M->F3_ALIQPS3) S
F3_VALPS3 N 14 2 Vl. Pis ST @E 999,999,999.99 Positivo().And.MaFisRef("LF_VALPS3","MT100",M->F3_VALPS3) S
F3_BASECF3 N 14 2 Bs. Cof ST @E 999,999,999.99 Positivo().And.MaFisRef("LF_BASECF3","MT100",M->F3_BASECF3) S
F3_ALIQCF3 N 5 2 Al. Cof ST @E 99.99 Positivo().And.MaFisRef("LF_ALIQCF3","MT100",M->F3_ALIQCF3) S
F3_VALCF3 N 14 2 Vl. Cof ST @E 999,999,999.99 Positivo().And.MaFisRef("LF_VALCF3","MT100",M->F3_VALCF3) S
F3_EMINFE D 8 0 Emissao NF-e @d R S
F3_NUMINI C 6 0 Num.DF Inic. 999999 S
F3_NUMFIM C 6 0 Num.DF Final 999999 S
F3_CFPS C 6 0 Cod. CFPS 999999 S
F3_CRDEST N 14 2 Credito Est. @E 99,999,999,999.99 S
F3_CREDACU C 1 0 Cr Acum ICMS @! S
F3_ISSSUB N 14 2 Iss Subempr. @E 99,999,999,999.99 R S
F3_CREDNFE N 16 2 Cred. Conced @E 9,999,999,999,999.99 R S
F3_ESTCRED N 16 2 Vl.Es.Cr/Deb @E 9,999,999,999.99 MaFisRef("LF_ESTCRED","MT100",M->F3_ESTCRED) R S
F3_CRPRERO N 14 2 Crd Pres RO @E 9,999,999,999.99 R N
F3_NUMRPS C 12 0 Num. RPS @! R S
F3_VALFET N 14 2 Valor Fethab @E 999,999,999.99 N
F3_VALFAB N 14 2 Valor Fabov @E 999,999,999.99 N
F3_VALFAC N 14 2 Valor Facs @E 999,999,999.99 N
F3_CPRESPR N 14 2 Cr Pres PR @E 9,999,999,999.99 S
F3_VFECPST N 14 2 Vlr FECP ST @E 99,999,999,999.99 R S
F3_NFELETR C 20 0 NF Eletr. @! R S
F3_HORNFE C 8 0 Hora NF-e @R 99:99:99 R S
F3_CRPRSIM N 16 2 Cr Pres Simp @E 9,999,999,999,999.99 R S
F3_VALFECP N 14 2 Valor FECP @E 99,999,999,999.99 S
F3_ANTICMS C 1 0 Antecip.ICMS @! S
F3_CODRSEF C 3 0 Retorno SEFA @! S
F3_CROUTGO N 14 2 Crd Out GO @E 99,999,999,999.99 R S
F3_VFECPMT N 14 2 Vlr FECP-MT @E 99,999,999,999.99 S
F3_VFESTMT N 14 2 V.FECP-ST/MT @E 99,999,999,999.99 S
F3_CHVNFE C 44 0 Chave NFe @! R S
F3_VALTPDP N 14 2 Valor TPDP @E 99,999,999,999.99 R S
F3_VALANTI N 14 2 Val Ant.ICMS @E 99,999,999,999.99 S
F3_CODNFE C 50 0 Cd.Ver. NF-e @! R S
F3_ALIQIPI N 5 2 Aliq IPI @E 99.99 S
F3_CSTISS C 2 0 Sit.Trib.ISS @! Vazio() .Or. ExistCpo('SX5','S9'+M->F3_CSTISS) R S
F3_VALCPM N 14 2 Vl.ISS CPM @E 99,999,999,999.99 MaFisRef("LF_VALCPM","MT100",M->F3_VALCPM) S
F3_BASECPM N 14 2 Bs.ISS CPM @E 99,999,999,999.99 MaFisRef("LF_BASECPM","MT100",M->F3_BASECPM) S
F3_ALQCPM N 5 2 Alq.ISS CPM @E 99.99 MaFisRef("LF_ALQCPM","MT100",M->F3_ALQCPM) S
F3_DESCRET C 250 0 Desc retorno @! R N
F3_VFECPMG N 14 2 Vlr FECP-MG @E 99,999,999,999.99 R S
F3_VFESTMG N 14 2 V.FECP-ST/MG @E 99,999,999,999.99 R S
F3_CODRET C 10 0 Cod retorno R N
F3_CREDPRE N 14 2 Cr Pre RS @E 99,999,999,999.99 R S
F3_CRPREPR N 14 2 Crd Pres PR @E 99,999,999,999.99 R S
F3_VLSENAR N 14 2 Valor Senar @E 99,999,999,999.99 MaFisRef("LF_VLSENAR","MT100",M->F3_VLSENAR) R S
F3_VALFUM N 14 2 Vlr FUMACOP @E 99,999,999,999.99 R S
F3_CRPREPE N 14 2 Crd Pres PE @E 9,999,999,999.99 S
F3_OK C 2 0 Iden.Selecao S
F3_CRPRESP N 14 2 Cr Pres SP @E 9,999,999,999.99 R S
F3_CLIENT C 6 0 Cliente Entr @! R S
F3_LOJENT C 2 0 Loja Entrega @! R S
F3_CAT102 C 1 0 Port. CAT102 R S
F3_BASETST N 14 2 Base ST tran @E 999,999,999.99 Positivo() .And. MaFisRef("LF_BASETST","MT100",M->F3_BASETST) R S
F3_VALTST N 14 2 Val. ST tran @E 999,999,999.99 Positivo() .And. MaFisRef("LF_VALTST","MT100",M->F3_VALTST) R S
F3_VLINCMG N 14 2 Vl.Inc.Leite @E 99,999,999,999.99 R S
F3_DS43080 N 14 2 Desc.43080 @E 99,999,999,999.99 S
F3_VL43080 N 14 2 Vl.43080 @E 99,999,999,999.99 S
F3_VFECPRN N 14 2 Vlr FECOP-RN @E 99,999,999,999.99 R S
F3_VFESTRN N 14 2 V.FECOP-ST/R @E 99,999,999,999.99 R S
F3_ISSMAT N 14 2 ISS Mat. @E 99,999,999,999.99 R S
F3_VALFDS N 14 2 Vl.Fundersul @E 99,999,999,999.99 MaFisRef("LF_VALFDS","MT100",M->F3_VALFDS) R S
F3_CROUTSP N 14 2 Cr Out SP @E 99,999,999,999.99 R S
F3_VREINT N 14 2 V.Reintegra @E 99,999,999,999.99 R S
F3_BSREIN N 14 2 B.C.Reinteg @E 99,999,999,999.99 R S
F3_CLASCO C 2 0 Classe cons. 99 R S
F3_CSTPIS C 2 0 CST PIS @! R S
F3_ABATISS N 14 2 ISS Subempr. @E 99,999,999,999.99 R S
F3_CSTCOF C 2 0 CST COF @! R S
F3_CODBCC C 2 0 Cod. BCC @! R S
F3_ALQFMP N 5 2 Aliq.Fumipeq @E 99.99 MaFisRef("LF_ALQFMP","MT100",M->F3_ALQFMP) S
F3_TRIBMUN C 20 0 C. Trib. Mun @! R S
F3_VALPEDG N 6 2 Val. Pedag. @E 999.99 R S
F3_PERCINP N 5 2 Perc.INSS.Pt @E 99.99 R S
F3_PROTOC C 15 0 Protocolo @! R S
F3_BASEFMP N 14 2 Base Fumipeq @E 99,999,999,999.99 MaFisRef("LF_BASEFMP","MT100",M->F3_BASEFMP) S
F3_VALFMD N 14 4 Valor Famad @E 999,999,999.9999 MaFisRef("LF_VALFMD","MT100",M->F3_VALFMD) R S
F3_VALFMP N 14 2 Vl.Fumipeq @E 99,999,999,999.99 MaFisRef("LF_VALFMP","MT100",M->F3_VALFMP) S
F3_SDOC C 3 0 Serie Doc. !!! R S
F3_VFCPDIF N 14 2 Vlr FECP Dif @E 99,999,999,999.99 R S
F3_ICMNDES N 14 2 ICMS ST Ant. @E 99,999,999,999.99 MaFisRef("LF_ICMNDES","MT100",M->F3_ICMNDES) .And. Positivo() R S
F3_VALFUND N 14 2 Vlr.FUNDESA @E 99,999,999,999.99 Positivo() R S
F3_SERSAT C 9 0 Ser.SAT @! R S
F3_VALII N 14 2 Vlr. Import. @E 99,999,999,999.99 R S
F3_BASECPB N 14 2 Base CPRB @E 99,999,999,999.99 R S
F3_MOTICMS C 1 0 Mot.Desone. @! R 1=Taxi;2=Defic. Fisico;3=Prod.Agro.;4=Frotista/Locadora;5=Diplom./Consular;6=Util e Moto;07=SUFRAMA;8=Venda Org.Publico;9=Outros S
F3_GRUPONC C 2 0 Grp.Nat.Rec. @! R S
F3_TNATREC C 4 0 Tab.Nat.Rec @! R S
F3_CNATREC C 3 0 Cod.Nat.Rec. @! R S
F3_DTFIMNT D 8 0 Dt.Fim N. R R S
F3_BSICMOR N 16 2 BS.ICMS Ori. @E 9,999,999,999,999.99 R S
F3_CLIDEST C 6 0 Cliente Dest @! MaFisRef("LF_CLIDEST","MT100",M->F3_CLIDEST) R S
F3_INDNTFR C 1 0 Ind.Nat.Fret @! R S
F3_VALCPB N 14 2 Valor CPRB @E 99,999,999,999.99 R S
F3_DIFAL N 14 2 Difal ICMS @E 99,999,999,999.99 R S
F3_VALFASE N 14 2 Vlr.FASE-MT @E 99,999,999,999.99 Positivo() R S
F3_MALQCOF N 6 2 Aliq. COF M. @E 999.99 R S
F3_ALIQCPB N 5 2 Aliquota CPR @E 99.99 R S
F3_BASEDES N 14 2 Base. Destin @E 99,999,999,999.99 R S
F3_SDOCMAN C 3 0 Serie Manual !!! R S
F3_MVALCOF N 14 2 Val. COF M. @E 99,999,999,999.99 R S
F3_BASNDES N 14 2 B.ICMS ST An @E 99,999,999,999.99 MaFisRef("LF_BASNDES","MT100",M->F3_BASNDES) .And. Positivo() R S
F3_BASEINP N 14 2 Bas.INSS.Pt @E 99,999,999,999.99 R S
F3_VALIMA N 14 2 Vlr. IMA-MT @E 99,999,999,999.99 Positivo() R S
F3_LOJDEST C 2 0 Loja Dest @! MaFisRef("LF_LOJDEST","MT100",M->F3_LOJDEST) R S
F3_ATIVCPB C 8 0 Cod. Ativ. @! R S
F3_VALINP N 14 2 Val.INSS.Pt @E 99,999,999,999.99 R S
F3_NFISCAN C 9 0 Nota Fiscal @! R S
F3_CLIDVMC C 6 0 Cliente Dev @! R S
F3_LOJDVMC C 2 0 Loja Dev @! R S
F3_VFCPANT N 14 2 Vlr. FCP Ant @E 99,999,999,999.99 MaFisRef("LF_VFCPANT","MT100",M->F3_VFCPANT) R S
F3_BASFECP N 14 2 Base FCP Pr. @E 99,999,999,999.99 MaFisRef("LF_BASFECP","MT100",M->F3_BASFECP) R S
F3_BSFCCMP N 14 2 Base FCP Cmp @E 99,999,999,999.99 MaFisRef("LF_BSFCCMP","MT100",M->F3_BSFCCMP) R S
F3_BFCPANT N 14 2 Base FCP Ant @E 99,999,999,999.99 MaFisRef("LF_BFCPANT","MT100",M->F3_BFCPANT) R S
F3_BSFCPST N 14 2 Base FCP ST @E 99,999,999,999.99 MaFisRef("LF_BSFCPST","MT100",M->F3_BSFCPST) R S
F3_BASECPR N 14 2 BS CRED PRES @E 99,999,999,999.99 R N
F3_BASEFUN N 14 2 Bas.FUNRURAL @E 99,999,999,999.99 R S
F3_VALFUN N 14 2 Vlr FUNRURAL @E 99,999,999,999.99 R S