Tabela
SF2 Cabecalho das NF de Saida
Campo Tipo Tamanho Decimal Titulo Formato Validacao F3 Contexto Lista Condicao PYME
F2_DOC C 9 0 Numero @! ExistChav("SF2") S
F2_SERIE C 3 0 Serie Docto. !!! S
F2_CLIENTE C 6 0 Cliente @! SA1 S
F2_LOJA C 2 0 Loja @! Iif(cPaisLoc == "BRA" ,.T., Vazio() .or. VldF2Loj()) S
F2_COND C 3 0 Cond. Pagto @! existcpo("SE4") SE4 S
F2_DUPL C 9 0 Num. Titulo @! S
F2_EMISSAO D 8 0 DT Emissao S
F2_EST C 2 0 Estado @! ExistCpo("SX5","12"+M->F2_EST).And.MaFisRef("NF_UFDEST","MT100",M->F2_UF) S
F2_FRETE N 14 2 Vlr.Frete @E 999,999,999.99 MaFisRef("NF_FRETE","MT100",M->F2_FRETE) S
F2_SEGURO N 14 2 Vlr.Seguro @E 999,999,999.99 MaFisRef("NF_SEGURO","MT100",M->F2_SEGURO) S
F2_ICMFRET N 14 2 ICMS Frete @E 999,999,999.99 MaFisRef("NF_ICMFRETE","MT100",M->F2_ICMFRET) S
F2_TIPOCLI C 1 0 Tipo Consumi @! S
F2_VALBRUT N 14 2 Vlr.Bruto @E 999,999,999.99 MaFisRef("NF_TOTAL","MT100",M->F2_VALBRUT) S
F2_VALICM N 14 2 Vlr.ICMS @E 999,999,999.99 MaFisRef("NF_VALICM","MT100",M->F2_VALICM) S
F2_BASEICM N 14 2 Base p/ICMS @E 999,999,999.99 MaFisRef("NF_BASEICM","MT100",M->F2_BASEICM) S
F2_VALIPI N 14 2 Vlr.IPI @E 999,999,999.99 MaFisRef("NF_VALIPI","MT100",M->F2_VALIPI) S
F2_BASEIPI N 14 2 Base p/IPI @E 999,999,999.99 MaFisRef("NF_BASEIPI","MT100",M->F2_BASEIPI) S
F2_VALMERC N 14 2 Vlr.Mercad @E 999,999,999.99 S
F2_NFORI C 9 0 Docto. Orig. @! S
F2_DESCONT N 14 2 Descontos @E 999,999,999.99 MaFisRef("NF_DESCONTO","MT100",M->F2_DESCONT) S
F2_SERIORI C 3 0 Ser.Original !!! S
F2_TIPO C 1 0 Tipo da nota @! Pertence("NCPIDB") S
F2_ESPECI1 C 10 0 Especie 1 @! S
F2_ESPECI2 C 10 0 Especie 2 @! S
F2_ESPECI3 C 10 0 Especie 3 @! S
F2_ESPECI4 C 10 0 Especie 4 @! S
F2_VOLUME1 N 6 0 Volume 1 999999 S
F2_VOLUME2 N 6 0 Volume 2 999999 S
F2_VOLUME3 N 6 0 Volume 3 999999 S
F2_VOLUME4 N 6 0 Volume 4 999999 S
F2_ICMSRET N 14 2 ICMS Retido @E 999,999,999.99 MaFisRef("NF_VALSOL","MT100",M->F2_ICMSRET) S
F2_PLIQUI N 11 4 Peso Liquido @E 999999.9999 S
F2_PBRUTO N 11 4 Peso Bruto @E 999999.9999 S
F2_TRANSP C 6 0 Transp. @! SA4 S
F2_REDESP C 6 0 Redespacho @! SA4 S
F2_VEND1 C 6 0 Vendedor 1 @! Vazio() .or. ExistCpo("SA3",M->F2_VEND1) SA3 S
F2_VEND2 C 6 0 Vendedor 2 @! Vazio() .or. ExistCpo("SA3",M->F2_VEND2) SA3 S
F2_VEND3 C 6 0 Vendedor 3 @! Vazio() .or. ExistCpo("SA3",M->F2_VEND3) SA3 S
F2_VEND4 C 6 0 Vendedor 4 @! Vazio() .or. ExistCpo("SA3",M->F2_VEND4) SA3 S
F2_VEND5 C 6 0 Vendedor 5 @! Vazio() .or. ExistCpo("SA3",M->F2_VEND5) SA3 S
F2_OK C 4 0 Nota a Impr. S
F2_FIMP C 1 0 Flag de Imp. S
F2_DTLANC D 8 0 Dt. do Lanc. S
F2_DTREAJ D 8 0 Dt. Reajuste S
F2_REAJUST C 3 0 Cod.Reajuste S
F2_DTBASE0 D 8 0 Data Base 0 S
F2_FATORB0 N 14 4 Fator Base 0 @E 999,999,999.9999 S
F2_DTBASE1 D 8 0 Data Base 1 S
F2_FATORB1 N 14 4 Fator Base 1 @E 999,999,999.9999 S
F2_VARIAC N 10 4 Variacao @E 99,999.9999 S
F2_FILIAL C 2 0 Filial S
F2_BASEISS N 14 2 Base ISS @E 99,999,999,999.99 MaFisRef("NF_BASEISS","MT100",M->F2_BASEISS) S
F2_VALISS N 14 2 Valor ISS @E 99,999,999,999.99 MaFisRef("NF_VALISS","MT100",M->F2_VALISS) S
F2_VALFAT N 16 2 Valor Fatura @E 99,999,999,999.99 S
F2_CONTSOC N 14 2 Vl.Contr.Soc @E 999,999,999.99 MaFisRef("NF_FUNRURAL","MT100",M->F2_CONTSOC) S
F2_BRICMS N 14 2 Base ICM Sol @E 999,999,999.99 MaFisRef("NF_BASESOL","MT100",M->F2_BRICMS) S
F2_FRETAUT N 14 2 Vl.Frete Aut @E 999,999,999.99 MaFisRef("NF_AUTONOMO","MT100",M->F2_FRETAUT) S
F2_ICMAUTO N 14 2 Vl.Icm Frete @E 999,999,999.99 MaFisRef("NF_VALICA","MT100",M->F2_ICMAUTO) S
F2_DESPESA N 14 2 Vl. Despesa @E 999,999,999.99 MaFisRef("NF_DESPESA","MT100",M->F2_DESPESA) S
F2_NEXTSER C 3 0 Prox. Serie !!! S
F2_NEXTDOC C 9 0 Prox Nota @! S
F2_ESPECIE C 5 0 Espec.Docum. @! Vazio().or.ExistCpo("SX5","42"+M->F2_ESPECIE) 42 S
F2_PDV C 10 0 Numero PDV @! S
F2_MAPA C 10 0 Numero MAPA @! S
F2_ECF C 1 0 Serie ECF @! S
F2_PREFIXO C 3 0 Prefixo @! S
F2_BASIMP1 N 14 2 Base Imp. 1 @E 99,999,999,999.99 MaFisRef("NF_BASEIV1","MT100",M->F2_BASIMP1) S
F2_BASIMP2 N 14 2 Base Imp. 2 @E 99,999,999,999.99 MaFisRef("NF_BASEIV2","MT100",M->F2_BASIMP2) S
F2_BASIMP3 N 14 2 Base Imp. 3 @E 99,999,999,999.99 MaFisRef("NF_BASEIV3","MT100",M->F2_BASIMP3) S
F2_BASIMP4 N 14 2 Base Imp. 4 @E 99,999,999,999.99 MaFisRef("NF_BASEIV4","MT100",M->F2_BASIMP4) S
F2_BASIMP5 N 14 2 Base Imp. 5 @E 99,999,999,999.99 MaFisRef("NF_BASECF2","MT100",M->F2_BASIMP5) S
F2_BASIMP6 N 14 2 Base Imp. 6 @E 99,999,999,999.99 MaFisRef("NF_BASEPS2","MT100",M->F2_BASIMP6) S
F2_VALIMP1 N 14 2 Valor Imp. 1 @E 99,999,999,999.99 MaFisRef("NF_VALIV1","MT100",M->F2_VALIMP1) S
F2_VALIMP2 N 14 2 Valor Imp. 2 @E 99,999,999,999.99 MaFisRef("NF_VALIV2","MT100",M->F2_VALIMP2) S
F2_VALIMP3 N 14 2 Valor Imp. 3 @E 99,999,999,999.99 MaFisRef("NF_VALIV3","MT100",M->F2_VALIMP3) S
F2_VALIMP4 N 14 2 Valor Imp. 4 @E 99,999,999,999.99 MaFisRef("NF_VALIV4","MT100",M->F2_VALIMP4) S
F2_VALIMP5 N 14 2 Valor Imp. 5 @E 99,999,999,999.99 MaFisRef("NF_VALCF2","MT100",M->F2_VALIMP5) S
F2_VALIMP6 N 14 2 Valor Imp. 6 @E 99,999,999,999.99 MaFisRef("NF_VALPS2","MT100",M->F2_VALIMP6) S
F2_ORDPAGO C 6 0 Ordem Pagto S
F2_NFCUPOM C 12 0 NF de Cupom @! S
F2_VALINSS N 14 2 Valor INSS @E 999,999,999.99 MaFisRef("NF_VALINS","MT100",M->F2_VALINS) S
F2_HORA C 5 0 Hora 99:99 S
F2_MOEDA N 2 0 Moeda 99 MaFisRef("NF_MOEDA","MT100",M->F2_MOEDA) S
F2_REGIAO C 3 0 Regiao S
F2_VALCSLL N 14 2 Valor CSLL @E 999,999,999.99 MaFisRef("NF_VALCSL","MT100",M->F2_VALCSLL) S
F2_VALCOFI N 14 2 Valor COFINS @E 999,999,999.99 MaFisRef("NF_VALCOF","MT100",M->F2_VALCOFI) S
F2_VALPIS N 14 2 Valor PIS @E 999,999,999.99 MaFisRef("NF_VALPIS","MT100",M->F2_VALPIS) S
F2_LOTE C 1 0 Doc. em Lote @! S
F2_TXMOEDA N 11 4 Taxa Moeda @E 999999.9999 S
F2_CLEOK C 4 0 Flag CLe R S
F2_CHVCLE C 14 0 Chave CLe R S
F2_IDCLE C 12 0 ID_CLE R S
F2_VALIRRF N 14 2 Valor IRRF @e 999,999,999.99 MaFisRef("NF_VALIRR","MT100",M->F2_VALIRRF) S
F2_CARGA C 6 0 Carga @! S
F2_RECFAUT C 1 0 Pag.Fret.Aut @! MaFisRef("NF_RECFAUT","MT100",M->F2_RECFAUT) R 1=Emitente;2=Transportador S
F2_SEQCAR C 2 0 Seq. Carga @! S
F2_BASEINS N 14 2 Base de INSS @E 99,999,999.99 MaFisRef("NF_BASEINS","MT100",M->F2_BASEINS) S
F2_PEDPEND C 6 0 Ped. Ent Fut @! S
F2_DESCCAB N 16 2 Indenizacao @E 9,999,999,999,999.99 S
F2_DTENTR D 8 0 Data Entrega S
F2_FORMUL C 1 0 Form. Prop. ! Vazio().Or.Pertence("SN ") S
F2_TIPODOC C 2 0 Id. Doc. MAFISREF("NF_TIPODOC","MT100",M->F2_TIPODOC) S
F2_NFEACRS C 9 0 NFE Acresc. @! S
F2_TIPOREM C 1 0 Tipo Remis. @! Pertence("0A") .AND. Iif (FindFunction("A410LiqPro"),A410LiqPro(),.T.) 0=Venda;A=Consignacao S
F2_SEQENT C 6 0 Seq. Entrega S
F2_GRPDEP C 5 0 Grupo Almox @! Vazio() .Or. ExistCpo("SX5","74"+M->F2_GRPDEP) 74 V S
F2_ICMSDIF N 14 2 Icms. Dif. @E 99,999,999,999.99 Positivo().And.MafisRef("NF_ICMSDIF","MT460",M->F2_ICMSDIF) S
F2_VALACRS N 14 2 Vl.Acres.Fin @E 99,999,999,999.99 S
F2_RECISS C 1 0 Recolhe ISS MaFisRef("NF_RECISS","MT100",M->F2_RECISS) S
F2_EMINFE D 8 0 Emissao NF-e @D R S
F2_TIPORET C 1 0 Retorno @! Pertence("1|2| ") 1=Automatico;2=Manual S
F2_BASEPS3 N 14 2 Bs. Pis ST @E 999,999,999.99 Positivo().And.MaFisRef("NF_BASEPS3","MT100",M->F2_BASEPS3) S
F2_VALPS3 N 14 2 Vl. Pis ST @E 999,999,999.99 Positivo().And.MaFisRef("NF_VALPS3","MT100",M->F2_VALPS3) S
F2_BASECF3 N 14 2 Bs. Cof ST @E 999,999,999.99 Positivo().And.MaFisRef("NF_BASECF3","MT100",M->F2_BASECF3) S
F2_VALCF3 N 14 2 Vl. COF ST @E 999,999,999.99 Positivo().And.MaFisRef("NF_VALCF3","MT100",M->F2_VALCF3) S
F2_FILDEST C 2 0 Filial Dest R S
F2_HAWB C 17 0 Processo @! R S
F2_VEICUL2 C 8 0 Veiculo 2 @! DA3 S
F2_ORDSEP C 6 0 Ordem Sep. R N
F2_BASPIS N 14 2 Base PIS @E 999,999,999.99 MaFisRef("NF_BASEPIS","MT100",M->F2_BASPIS) S
F2_VALTST N 14 2 Val. ST tran @E 999,999,999.99 Positivo() .And. MaFisRef("NF_VALTST","MT100",M->F2_VALTST) R S
F2_BASEIRR N 16 2 Base IR @E 9,999,999,999.99 MaFisRef("NF_BASEIRR","MT100",M->F2_BASEIRR) R S
F2_ESTCRED N 16 2 Vlr Est Deb @E 9,999,999,999,999.99 MaFisRef("NF_ESTCRED","MT100",M->F2_ESTCRED) R S
F2_NODIA C 10 0 Seq.Diario @! R S
F2_DIACTB C 2 0 Cod.Diario @! ExistCPO("CVL") CVL R S
F2_FLAGDEV C 1 0 Flag. dev. @! R S
F2_CGCCLI C 16 0 CPF/CNPJ @R 99.999.999/9999-99 R S
F2_CREDNFE N 16 2 Cred. Conced @E 9,999,999,999,999.99 R S
F2_NUMORC C 6 0 No Orcamento @! R S
F2_IDSA1 C 20 0 ID Hist. SA1 @! MaFisRef("NF_IDSA1","MT100",M->F2_IDSA1) R S
F2_IDSA2 C 20 0 ID Hist. SA2 @! MaFisRef("NF_IDSA2","MT100",M->F2_IDSA2) R S
F2_IDSED C 20 0 ID Hist. SED @! MaFisRef("NF_IDSED","MT100",M->F2_IDSED) R S
F2_CHVNFE C 44 0 Chave NFe @! R S
F2_VEICUL1 C 8 0 Veiculo 1 @! DA3 S
F2_TPFRETE C 1 0 Tipo de fret @! R S
F2_RECOPI C 1 0 Flag RECOPI @! S
F2_STATUS C 3 0 Status NFE R S
F2_CODNFE C 50 0 Cd.Ver. NF-e @! R S
F2_TIPIMP C 1 0 Cons.Cg.Trb @! R S
F2_FORMDES C 1 0 Form. Dest. @! S
F2_NFELETR C 20 0 NF Eletr. @! R S
F2_VALFAC N 14 2 Vl.Facs @E 99,999,999,999.99 MaFisRef("NF_VALFAC","MT100",M->F2_VALFAC) R S
F2_VALFET N 14 2 Vl.Fethab @E 99,999,999,999.99 MaFisRef("NF_VALFET","MT100",M->F2_VALFET) R S
F2_VALINA N 14 2 Vlr INSS Ad @E 99,999,999,999.99 MaFisRef("NF_VALINA","MT100",M->F2_VALINA) R S
F2_HORNFE C 8 0 Hora NF-e @R 99:99:99 R S
F2_BASEINA N 14 2 Base INSS Ad @E 99,999,999,999.99 MaFisRef("NF_BASEINA","MT100",M->F2_BASEINA) R S
F2_BSREIN N 14 2 B.C.Reinteg @E 99,999,999,999.99 'MaFisRef("NF_BSREIN","MT100",M->F2_BSREIN)' R S
F2_CODRGS C 1 0 Status RGS R S
F2_DAUTNFE D 8 0 Data de Auto R N
F2_EVENFLG C 1 0 Flag CCe R N
F2_FLAGRGS C 4 0 Flag RGS R N
F2_HAUTNFE C 5 0 Hora de Auto R N
F2_IDCCE C 54 0 Id CC-e R N
F2_IDRGS C 54 0 Id RGS R N
F2_CNO C 6 0 Cod CNO Vazio() .Or. ExistCpo('SON',M->F2_CNO ) SON R S
F2_VALFAB N 14 2 Vl.Fabov @E 99,999,999,999.99 MaFisRef("NF_VALFAB","MT100",M->F2_VALFAB) R S
F2_VREINT N 14 2 V.Reintegra @E 99,999,999,999.99 'MaFisRef("NF_VREINT","MT100",M->F2_VREINT)' R S
F2_TOTIMP N 14 2 Tot.Cg.Trb. @E 99,999,999,999.99 R S
F2_SERMDF C 3 0 Serie MDFe !!! R S
F2_NUMMDF C 9 0 Numero MDFe @! R S
F2_VLSENAR N 14 2 Valor Senar @E 99,999,999,999.99 MaFisRef("NF_VLSENAR","MT100",M->F2_VLSENAR) S
F2_DESCZFR N 14 2 Desc.ZFM @E 99,999,999,999.99 MaFisRef("NF_DESCZF","MT100",M->F2_DESCZFR) R S
F2_NFSUBST C 9 0 Nf Subst. @! R S
F2_SERSUBS C 3 0 Serie Subst. !!! R S
F2_BASEFUN N 14 2 Bas.FUNRURAL @E 99,999,999,999.99 MaFisRef("NF_BASEFUN","MT100",M->F2_BASEFUN) R S
F2_NTFECP C 12 0 Cod.NT Fecp @! S
F2_FORDES C 6 0 Forn. Dest. @! S
F2_LOJADES C 2 0 Loja Dest. @! S
F2_DTTXREF D 8 0 Dt.R.Cambial R S
F2_TXREF N 11 4 Taxa Cambial @E 999,999.9999 S
F2_BASETST N 14 2 Base ST tran @E 999,999,999.99 Positivo() .And. MaFisRef("NF_BASETST","MT100",M->F2_BASETST) R S
F2_PREFORI C 3 0 Pref Origem @! R S
F2_BASCOFI N 14 2 Base COFINS @E 999,999,999.99 MaFisRef("NF_BASECOF","MT100",M->F2_BASCOFI) S
F2_BASCSLL N 14 2 Base CSLL @E 999,999,999.99 MaFisRef("NF_BASECSL","MT100",M->F2_BASCSLL) S
F2_REFTAXA N 11 4 Ref.Taxa @E 999999.9999 Positivo() R S
F2_REFMOED N 2 0 Ref.Moeda 99 R S
F2_NFICMST C 12 0 Cod.NF IcmSt @! R S
F2_VEICUL3 C 8 0 Veiculo 3 @! DA3 S
F2_CLIENT C 6 0 Cliente Entr @! R S
F2_LOJENT C 2 0 Loja Entrega @! R S
F2_VALFDS N 14 2 Vl.Fundersul @E 99,999,999,999.99 MaFisRef("NF_VALFDS","MT100",M->F2_VALFDS) R S
F2_DTDIGIT D 8 0 Data digit. R S
F2_VLR_FRT N 12 2 Frete Pauta @E 999,999,999.99 MaFisRef("NF_VLR_FRT","MT100",M->F2_VLR_FRT) R S
F2_TOTFED N 14 2 Crg.Trb.Fed @E 99,999,999,999.99 R S
F2_BASEFMP N 14 2 Base FUMIPEQ @E 99,999,999,999.99 MaFisRef("NF_BASEFMP","MT100",M->F2_BASEFMP) S
F2_IDRECOP C 6 0 Id Recopi @! R S
F2_MENNOTA C 60 0 Mens.p/Nota Vazio() .OR. Texto() R S
F2_VALFMD N 14 2 Vl.Famad @E 99,999,999,999.99 MaFisRef("NF_VALFMD","MT100",M->F2_VALFMD) S
F2_TPCOMPL C 1 0 Tipo Compl. @! R 1=Preco; 2=Quantidade S
F2_TOTMUN N 14 2 Crg.Trb.Mun @E 99,999,999,999.99 R S
F2_VALFMP N 14 2 Vl.FUMIPEQ @E 99,999,999,999.99 MaFisRef("NF_VALFMP","MT100",M-> F2_VALFMP) S
F2_LTRAN C 41 0 Fonte Lei Tr @! R S
F2_TOTEST N 14 2 Crg.Trb.Est @E 99,999,999,999.99 R S
F2_VALFUND N 14 2 Vlr.FUNDESA @E 99,999,999,999.99 MaFisRef("NF_VALFUND","MT100",M->F2_VALFUND) R S
F2_VALFASE N 14 2 Vlr.FASE-MT @E 99,999,999,999.99 MaFisRef("NF_VALFASE","MT100",M->F2_VALFASE) R S
F2_VALIMA N 14 2 Vlr. IMA-MT @E 99,999,999,999.99 MaFisRef("NF_VALIMA","MT100",M->F2_VALIMA) R S
F2_SDOCMAN C 3 0 Serie Manual !!! R S
F2_SDOCMDF C 3 0 Serie MDFe !!! R S
F2_GNRFECP C 12 0 GNRE FECP @! R S
F2_SDOC C 3 0 Serie Doc. !!! R S
F2_SDOCNXT C 3 0 Prox. Serie !!! R S
F2_GNRDIF C 12 0 GNRE DIFAL @! R S
F2_SDOCORI C 3 0 Ser.Original !!! R S
F2_SDOCSUB C 3 0 Serie Subst. !!! R S
F2_DTESERV D 8 0 Dt.Exec.Serv R S
F2_SERSAT C 9 0 Serie SAT @! S
F2_X_FBSTS C 1 0 App Status R
F2_X_LC N 14 2 Lim.Credito @E 99,999,999,999.99 R
F2_X_RISCO C 1 0 Risco Fat. R
F2_X_FBDT C 10 0 Data Status R
F2_X_FBHR C 5 0 Hora Status R
F2_X_FBMTV C 1 0 Motivo Sts R
F2_ESTPRES C 2 0 UF. Prest. @! Vazio() .or. ExistCpo("SX5","12"+M->F2_ESTPRES) 12 R S
F2_MUNPRES C 7 0 Mun.Prest. @! CC2SC5 R S
F2_FRTCFOP C 5 0 Frete CFOP @! S
F2_BSFCPST N 14 2 Base FCP ST @E 99,999,999,999.99 MaFisRef("NF_BSFCPST","MT100",M->F2_BSFCPST) R S
F2_BASFECP N 14 2 Base FCP Pr. @E 99,999,999,999.99 MaFisRef("NF_BASFECP","MT100",M->F2_BASFECP) R S
F2_PAFMD5 C 32 0 MD5 R S
F2_LOJARET C 2 0 Lj. Retirada @! S
F2_CMUNOR C 5 0 Mun.Origem @99999 R S
F2_CMUNDE C 5 0 Mun. Dest. @99999 R S
F2_CLIRET C 6 0 Cli.Retirada @! S
F2_UFORIG C 2 0 UF Origem @! MaFisRef("NF_UFORIGEM","MT100",M->F2_UFORIG) R S
F2_BSFCCMP N 14 2 Base FCP Cmp @E 99,999,999,999.99 MaFisRef("NF_BSFCCMP","MT100",M->F2_BSFCCMP) R S
F2_UFDEST C 2 0 UF Destino @! MaFisRef("NF_UFDEST","MT100",M->F2_UFDEST) R S
F2_BASECPM N 14 2 Bs.ISS CPM @E 99,999,999,999.99 MaFisRef("NF_BASECPM","MT100",M->F2_BASECPM) S
F2_VLCPM N 14 2 Vl.ISS CPM @E 99,999,999,999.99 MaFisRef("NF_VALCPM","MT100",M->F2_VLCPM) S
F2_IDNF C 36 0 ID da NF @! R S