Tabela
SF1 Cabecalho das NF de Entrada
Campo Tipo Tamanho Decimal Titulo Formato Validacao F3 Contexto Lista Condicao PYME
F1_FILIAL C 2 0 Filial R S
F1_DOC C 9 0 Numero @! S
F1_SERIE C 3 0 Serie !!! S
F1_FORNECE C 6 0 Fornecedor @! FOR S
F1_LOJA C 2 0 Loja @! S
F1_COND C 3 0 Cond. Pagto SE4 S
F1_DUPL C 9 0 Num. Titulo @! S
F1_EMISSAO D 8 0 DT Emissao S
F1_EST C 2 0 Estado @! ExistCpo("SX5","12"+M->F1_EST).And.MaFisRef("NF_UFORIGEM","MT100",M->F1_EST) S
F1_FRETE N 15 2 Vlr.Frete @E 999,999,999.99 MaFisRef("NF_FRETE","MT100",M->F1_FRETE) S
F1_DESPESA N 15 2 Vlr.Despesas @E 999,999,999.99 MaFisRef("NF_DESPESA","MT100",M->F1_DESPESA) S
F1_BASEICM N 14 2 Base p/ICMS @E 999,999,999.99 MaFisRef("NF_BASEICM","MT100",M->F1_BASEICM) S
F1_VALICM N 14 2 Vlr.ICMS @E 999,999,999.99 MaFisRef("NF_VALICM","MT100",M->F1_VALICM) S
F1_BASEIPI N 14 2 Base p/IPI @E 999,999,999.99 MaFisRef("NF_BASEIPI","MT100",M->F1_BASEIPI) S
F1_VALIPI N 14 2 Vlr.IPI @E 999,999,999.99 MaFisRef("NF_VALIPI","MT100",M->F1_VALIPI) S
F1_VALMERC N 14 2 Vlr.Mercad @E 999,999,999.99 MaFisRef("NF_VALMERC","MT100",M->F1_VALMERC) S
F1_VALBRUT N 14 2 Vlr.Bruto @E 999,999,999.99 MaFisRef("NF_TOTAL","MT100",M->F1_VALBRUT) S
F1_TIPO C 1 0 Tipo da Nota @! pertence("NDIPBC") S
F1_DESCONT N 14 2 Descontos @E 999,999,999.99 MaFisRef("NF_DESCONTO","MT100",M->F1_DESCONT) S
F1_DTDIGIT D 8 0 Dt.Digitacao S
F1_CPROVA C 14 0 Arq.C.Prova S
F1_NUMTRIB C 9 0 Rl. SF1xSE2 @! S
F1_BRICMS N 14 2 Base ICM Sol @E 999,999,999.99 MaFisRef("NF_BASESOL","MT100",M->F1_BRICMS) S
F1_ICMSRET N 14 2 ICMS Solid. @E 999,999,999.99 MaFisRef("NF_VALSOL","MT100",M->F1_ICMSRET) S
F1_BASEFD N 14 2 Base Fr. Des @E 999,999,999.99 S
F1_DTLANC D 8 0 Dt.Lancto S
F1_OK C 2 0 Ok S
F1_ORIGLAN C 2 0 Orig.Lancto. S
F1_TX C 1 0 Transmissao ! S
F1_CONTSOC N 14 2 Vl.Cont.Soc. @E 999,999,999.99 MaFisRef("NF_FUNRURAL","MT100",M->F1_CONTSOC) S
F1_IRRF N 14 2 Imp. Renda @E 999,999,999.99 MaFisRef("NF_VALIRR","MT100",M->F1_IRRF) S
F1_FORMUL C 1 0 Form. Prop. ! Vazio().Or.Pertence("SN ") S
F1_NFORIG C 9 0 Doc.Despesa @! S
F1_SERORIG C 3 0 Ser.despesa S
F1_ESPECIE C 5 0 Espec.Docum. @! Vazio() .or. ExistCpo("SX5","42"+M->F1_ESPECIE) 42 S
F1_IMPORT C 1 0 Flag Import S
F1_II N 14 2 Vlr.Imp.Impo @E 99,999,999,999.99 MaFisRef("NF_VALII","MT100",M->F1_II) S
F1_REMITO C 9 0 N§ Remito @! S
F1_BASIMP2 N 14 2 Base Imp. 2 @E 99,999,999,999.99 MaFisRef("NF_BASEIV2","MT100",M->F1_BASIMP2) S
F1_BASIMP3 N 14 2 Base Imp. 3 @E 99,999,999,999.99 MaFisRef("NF_BASEIV3","MT100",M->F1_BASIMP3) S
F1_BASIMP4 N 14 2 Base Imp. 4 @E 99,999,999,999.99 MaFisRef("NF_BASEIV4","MT100",M->F1_BASIMP4) S
F1_BASIMP5 N 14 2 Base Imp. 5 @E 99,999,999,999.99 MaFisRef("NF_BASECF2","MT100",M->F1_BASIMP5) S
F1_BASIMP6 N 14 2 Base Imp. 6 @E 99,999,999,999.99 MaFisRef("NF_BASEPS2","MT100",M->F1_BASIMP6) S
F1_VALIMP1 N 14 2 Valor Imp. 1 @E 99,999,999,999.99 MaFisRef("NF_VALIV1","MT100",M->F1_VALIMP1) S
F1_VALIMP2 N 14 2 Valor Imp. 2 @E 99,999,999,999.99 MaFisRef("NF_VALIV2","MT100",M->F1_VALIMP2) S
F1_VALIMP3 N 14 2 Valor Imp. 3 @E 99,999,999,999.99 MaFisRef("NF_VALIV3","MT100",M->F1_VALIMP3) S
F1_VALIMP4 N 14 2 Valor Imp. 4 @E 99,999,999,999.99 MaFisRef("NF_VALIV4","MT100",M->F1_VALIMP4) S
F1_VALIMP5 N 14 2 Valor Imp. 5 @E 99,999,999,999.99 MaFisRef("NF_VALCF2","MT100",M->F1_VALIMP5) S
F1_VALIMP6 N 14 2 Valor Imp. 6 @E 99,999,999,999.99 MaFisRef("NF_VALPS2","MT100",M->F1_VALIMP6) S
F1_ORDPAGO C 6 0 Ordem Pagto @! S
F1_HORA C 8 0 Hora 99:99:99 S
F1_INSS N 14 2 Valor INSS @E 999,999,999.99 MaFisRef("NF_VALINS","MT100",M->F1_INSS) S
F1_ISS N 14 2 Valor ISS @E 999,999,999.99 MaFisRef("NF_VALISS","MT100",M->F1_ISS) S
F1_BASIMP1 N 14 2 Base Imp. 1 @E 99,999,999,999.99 MaFisRef("NF_BASEIV1","MT100",M->F1_BASIMP1) S
F1_HAWB C 17 0 No. Conhec. @! S
F1_TIPO_NF C 1 0 Tipo Docto. @! S
F1_IPI N 15 2 Aliq. IPI @E 99.99 S
F1_ICMS N 15 2 ICMS @E 999,999,999,999.99 S
F1_PESOL N 11 4 Peso Liquido @E 999,999.9999 S
F1_FOB_R N 15 2 FOB @E 999,999,999,999.99 S
F1_SEGURO N 15 2 Vlr.Seguro @E 999,999,999,999.99 MaFisRef("NF_SEGURO","MT100",M->F1_SEGURO) S
F1_CIF N 15 2 C.I.F. @E 999,999,999,999.99 S
F1_MOEDA N 2 0 Moeda @E 99 MaFisRef("NF_MOEDA","MT100",M->F1_MOEDA) S
F1_PREFIXO C 3 0 Prefixo @! S
F1_STATUS C 1 0 Status @! S
F1_VALEMB N 14 2 Vl.Embalagem @E 99,999,999.99 MaFisRef("NF_VALEMB","MT100",M->F1_VALEMB) S
F1_RECBMTO D 8 0 Dt. Receb. S
F1_CTR_NFC C 12 0 Contr. N.F.C @! S
F1_APROV C 6 0 Gr Aprovacao R .F. N
F1_TXMOEDA N 11 4 Taxa Moeda @E 999999.9999 S
F1_PEDVEND C 6 0 Ped. vendas S
F1_TIPODOC C 2 0 Id. Doc. MAFISREF("NF_TIPODOC","MT100",M->F1_TIPODOC) S
F1_TIPOREM C 1 0 Tipo Remito @! Pertence("0A") 0=Compra;A=Consignacao S
F1_GNR C 6 0 GNRE S
F1_ORIGEM C 8 0 Origem @! R S
F1_PLACA C 8 0 Placa @! R S
F1_VALPIS N 12 2 Valor do PIS @e 999,999,999.99 MaFisRef("NF_VALPIS","MT100",M->F1_VALPIS) R S
F1_VALCOFI N 12 2 Vlr.COFINS @e 999,999,999.99 MaFisRef("NF_VALCOF","MT100",M->F1_VALCOF) R S
F1_VALCSLL N 12 2 Vlr.CSLL @e 999,999,999.99 MaFisRef("NF_VALCSL","MT100",M->F1_VALCSLL) R S
F1_BASEPS3 N 14 2 Bs. Pis ST @E 999,999,999.99 Positivo().And.MaFisRef("NF_BASEPS3","MT100",M->F1_BASEPS3) S
F1_VALPS3 N 14 2 Vl. Pis ST @E 999.999.999,99 Positivo().And.MaFisRef("NF_VALPS3","MT100",M->F1_VALPS3) S
F1_BASECF3 N 14 2 Bs. Cof ST @E 999,999,999.99 Positivo().And.MaFisRef("NF_BASECF3","MT100",M->F1_BASECF3) S
F1_VALCF3 N 14 2 Vl. Cof ST @E 999,999,999.99 Positivo().And.MaFisRef("NF_VALCF3","MT100",M->F1_VALCF3) S
F1_NFELETR C 20 0 NF Eletr. @! R S
F1_EMINFE D 8 0 Emissao NF-e @d R S
F1_HORNFE C 8 0 Hora NF-e @R 99:99:99 R S
F1_CODNFE C 50 0 Cd.Ver. NF-e @! R S
F1_CREDNFE N 16 2 Cred. Conced @E 9,999,999,999,999.99 R S
F1_VNAGREG N 16 2 Val.N.Agreg. @E 9,999,999,999,999.99 MaFisRef("NF_VNAGREG","MT100",M->F1_VNAGREG) R S
F1_NUMRPS C 12 0 Num. RPS @! R S
F1_VALIRF N 14 2 IRRF Ret @E 999,999,999.99 R S
F1_NUMMOV C 2 0 Movimento R S
F1_CHVNFE C 44 0 Chave NFe @! R S
F1_RECISS C 1 0 Rec Iss @! MAFISREF("NF_RECISS","MT100",M->F1_RECISS) R 1=Sim;2=Nao S
F1_FILORIG C 2 0 Filial Orig R S
F1_NODIA C 10 0 Seq. Diario @! N
F1_ESTCRED N 16 2 Vlr Est Cred @E 9,999,999,999,999.99 MaFisRef("NF_ESTCRED","MT100",M->F1_ESTCRED) R S
F1_DIACTB C 2 0 Cod Diario @! ExistCPO("CVL") CVL N
F1_NUMRA C 6 0 Cod Func @! S
F1_BASEINS N 14 2 Base de INSS @E 99,999,999,999.99 MaFisRef("NF_BASEINS","MT100",M->F1_BASEINS) R S
F1_VALFDS N 14 2 Vl.Fundersul @E 999,999,999.99 MaFisRef("NF_VALFDS","MT100",M->F1_VALFDS) R S
F1_TRANSP C 6 0 Transp. @! Vazio() .Or. ExistCPO('SA4',M->F1_TRANSP,1) SA4 R N
F1_PLIQUI N 14 5 Peso Liquido @E 99,999,999.99999 R N
F1_PBRUTO N 11 4 Peso Bruto @E 999999.9999 R N
F1_ESPECI1 C 10 0 Especie 1 @! R N
F1_VOLUME1 N 6 0 Volume 1 @E 999999 R N
F1_ESPECI2 C 10 0 Especie 2 @! R N
F1_VOLUME2 N 6 0 Volume 2 @E 999999 R N
F1_ESPECI3 C 10 0 Especie 3 @! R N
F1_VOLUME3 N 6 0 Volume 3 @E 999999 R N
F1_ESPECI4 C 10 0 Especie 4 @! R N
F1_VOLUME4 N 6 0 Volume 4 @ 999999 R N
F1_MOTIVO C 14 0 Motivo Devol @! S
F1_VLCIDE N 14 2 Vl.Cide @E 99,999,999,999.99 MaFisRef("NF_VALCIDE","MT100",M->F1_VLCIDE) S
F1_BASECID N 14 2 Base Cide @E 99,999,999,999.99 MaFisRef("NF_BASECID","MT100",M->F1_BASECID) S
F1_ESTPRES C 2 0 UF Prestacao @! MaFisRef("NF_UFPREISS","MT100",M->F1_ESTPRES) R S
F1_MODAL C 2 0 Modal. trans @! MaFisRef("NF_MODAL","MT100",M->F1_MODAL) 01=Rodoviario;02=Aereo;03=Aquaviario;04=Ferroviario;05=Dutoviario;06=Multimodal S
F1_NUMAIDF C 7 0 N. AIDF @! R S
F1_ANOAIDF C 4 0 Ano AIDF @! R S
F1_VALINA N 14 2 Vlr INSS Ad @E 99,999,999,999.99 MaFisRef("NF_VALINA","MT100",M->F1_VALINA) R S
F1_BASEINA N 14 2 Base INSS Ad @E 99,999,999,999.99 MaFisRef("NF_BASEINA","MT100",M->F1_BASEINA) R S
F1_MENNOTA C 60 0 Mens.p/Nota @S45 texto() .Or. Vazio() S
F1_FIMP C 1 0 Flag Imp NFe @! R S
F1_RECOPI C 1 0 Flag. RECOPI @! S
F1_VALPEDG N 14 2 Vlr.Pedagio @E 99,999,999,999.99 Positivo() .And. MaFisAlt("NF_VALPEDG",M->F1_VALPEDG) N
F1_VALFET N 14 2 Vl.Fethab @E 99,999,999,999.99 MaFisRef("NF_VALFET","MT100",M->F1_VALFET) R N
F1_VALFAB N 14 2 Vl.Fabov @E 99,999,999,999.99 MaFisRef("NF_VALFAB","MT100",M->F1_VALFAB) R N
F1_VALFAC N 14 2 Vl.Facs @E 99,999,999,999.99 MaFisRef("NF_VALFAC","MT100",M->F1_VALFAC) R N
F1_FORRET C 6 0 For Retirada @! SA2 N
F1_LOJARET C 2 0 Loja Retirad @! N
F1_CLIORI C 6 0 Cliente Orig @! S
F1_LOJAORI C 2 0 Lj.Cli.Orig @! S
F1_FORENT C 6 0 For Entrega @! SA2 N
F1_LOJAENT C 2 0 Loja Entrega @! N
F1_VLSENAR N 14 2 Vl.Senar @E 99,999,999,999.99 MaFisRef("NF_VLSENAR","MT100",M->D1_VLSENAR) S
F1_BASECPM N 14 2 Bs.ISS CPM @E 99,999,999,999.99 MaFisRef("NF_BASECPM","MT100",M->F1_BASECPM) S
F1_VLCPM N 14 2 Vl.ISS CPM @E 99,999,999,999.99 MaFisRef("NF_VALCPM","MT100",M->F1_VLCPM) S
F1_IDSA1 C 20 0 ID Hist. SA1 @! MaFisRef("NF_IDSA1","MT100",M->F1_IDSA1) R S
F1_IDSA2 C 20 0 ID Hist. SA2 @! MaFisRef("NF_IDSA2","MT100",M->F1_IDSA2) R S
F1_IDSED C 20 0 ID Hist. SED @! MaFisRef("NF_IDSED","MT100",M->F1_IDSED) R S
F1_BASCOFI N 14 2 Base COFINS @E 99,999,999,999.99 MaFisRef("NF_BASECOF","MT100",M->F1_BASCOFI) S
F1_BASPIS N 14 2 Base PIS @E 99,999,999,999.99 MaFisRef("NF_BASEPIS","MT100",M->F1_BASPIS) S
F1_TPCTE C 1 0 Tipo de CT-e @! Pertence(" NCAS") R N=Normal;C=Complem.Valores;A=Anula.Valores;S=Substituto S
F1_DOCFOL C 9 0 Doc.Folha S
F1_VERBAFO C 9 0 Verba Folha S
F1_BASEFUN N 14 2 Bas.FUNRURAL @E 99,999,999,999.99 MaFisRef("NF_BASEFUN","MT100",M->F1_BASEFUN) R S
F1_TPFRETE C 1 0 Tipo de fret @! R S
F1_MSIDENT C 10 0 Ident.Reg. R S
F1_MENPAD C 3 0 Mens.Padrao @! vazio() .or. existcpo("SM4") SM4 S
F1_BASCSLL N 14 2 Base CSLL @E 99,999,999,999.99 MaFisRef("NF_BASECSL","MT100",M->F1_BASCSLL) S
F1_QTDCONF N 2 0 Qtd conferen 99 R N
F1_STATCON C 1 0 Stat conf R 0=Nao Conferido;1=Conferido;2=Divergente;3=Em Conferencia N
F1_CODRGS C 1 0 Status RGS R N
F1_DAUTNFE D 8 0 Data de Auto R S
F1_EVENFLG C 1 0 Flag CCe R N
F1_FLAGRGS C 4 0 Flag RGS R N
F1_HAUTNFE C 5 0 Hora de Auto R N
F1_IDCCE C 54 0 Id CC-e R S
F1_IDRGS C 54 0 Id RGS R S
F1_INCISS C 5 0 Mun. Incid. @99999 CC2 S
F1_VALIMA N 14 2 Vlr. IMA-MT @E 99,999,999,999.99 MaFisRef("NF_VALIMA","MT100",M->F1_VALIMA) R S
F1_CLIDEST C 6 0 Cliente Dest @! MaFisRef("NF_CLIDEST","MT100",M->F1_CLIDEST) SA1 R S
F1_VALFUND N 14 2 Vlr.FUNDESA @E 99,999,999,999.99 MaFisRef("NF_VALFUND","MT100",M->F1_VALFUND) R S
F1_VALFASE N 14 2 Vlr.FASE-MT @E 99,999,999,999.99 MaFisRef("NF_VALFASE","MT100",M->F1_VALFASE) R S
F1_LOJDEST C 2 0 Loja Dest @! MaFisRef("NF_LOJDEST","MT100",M->F1_LOJDEST) R S
F1_TPCOMPL C 1 0 Tipo Compl. @! R 1=Preco; 2=Quantidade; 3=Frete S
F1_SIMPNAC C 1 0 Opt Simp Nac @! MaFisRef("NF_SIMPNAC","MT100",M->F1_SIMPNAC) R 1=Sim;2=Nao S
F1_VALFMP N 14 2 Vl.FUMIPEQ @E 99,999,999,999.99 MaFisRef("NF_VALFMP","MT100",M-> F1_VALFMP) S
F1_BASEFMP N 14 2 Base FUMIPEQ @E 99,999,999,999.99 MaFisRef("NF_BASEFMP","MT100",M->F1_BASEFMP) S
F1_MOTRET C 6 0 Codigo ExistCpo("DHI") DHI R S
F1_SERMDF C 3 0 Serie MDFe @! R S
F1_DTCPISS D 8 0 Dt. Comp ISS S
F1_SDOC C 3 0 Serie Doc. !!! R S
F1_IDRECOP C 6 0 Id Recopi @! R S
F1_VEICUL2 C 8 0 Veiculo 2 @! DA3 R S
F1_SDOCORI C 3 0 Ser.despesa !!! R S
F1_NUMMDF C 9 0 Numero MDFe @! R S
F1_HISTRET M 10 0 Historico R S
F1_VEICUL1 C 8 0 Veiculo 1 @! DA3 R S
F1_VEICUL3 C 8 0 Veiculo 3 @! DA3 R S
F1_SDOCMAN C 3 0 Serie Manual !!! R S
F1_VALFMD N 14 2 Vl.Famad @E 99,999,999,999.99 MaFisRef("NF_VALFMD","MT100",M->F1_VALFMD) R S
F1_ESTDES C 2 0 Estado Dest. @! MaFisRef("NF_UFCDEST","MT100",M->F1_ESTDES) R S
F1_VERBAIS C 9 0 Verba Isen. @! R S
F1_DOCISEN C 9 0 Doc.Fol.Isen @! R S
F1_BOMDES C 4 0 Bombeio/Desc @! R S
F1_DEVMERC C 1 0 Dev.merc.n.r @! Pertence(" SN") R S=Sim;N=Nao S
F1_SUBSERI C 3 0 Subserie !!! R S
F1_UFDESTR C 2 0 UF Dest Tran @! Vazio() .or. (ExistCpo("SX5","12"+M->F1_UFDESTR) .And. MaFisRef("NF_UFDEST","MT100",M->F1_UFDESTR)) 12 R S
F1_UFORITR C 2 0 UF Ori Trans @! Vazio() .Or. (ExistCpo("SX5","12"+M->F1_UFORITR) .And. MaFisRef("NF_UFORIGEM","MT100",M->F1_UFORITR)) 12 R S
F1_MUDESTR C 5 0 Mun Dest Tra @! A103MUFCTE("DEST") CTEDES R S
F1_MUORITR C 5 0 Mun Ori Tran @! A103MUFCTE("ORIG") CTEORI R S
F1_BFCPANT N 14 2 Base FCP Ant @E 99,999,999,999.99 MaFisRef("NF_BFCPANT","MT100",M->F1_BFCPANT) R S
F1_VFCPANT N 14 2 Vlr. FCP Ant @E 99,999,999,999.99 MaFisRef("NF_VFCPANT","MT100",M->F1_VFCPANT) R S
F1_BSFCCMP N 14 2 Base FCP Cmp @E 99,999,999,999.99 MaFisRef("NF_BSFCCMP","MT100",M->F1_BSFCCMP) R S
F1_BASFECP N 14 2 Base FCP Pr. @E 99,999,999,999.99 MaFisRef("NF_BASFECP","MT100",M->F1_BASFECP) R S
F1_BSFCPST N 14 2 Base FCP ST @E 99,999,999,999.99 MaFisRef("NF_BSFCPST","MT100",M->F1_BSFCPST) R S
F1_CODROM C 10 0 Romaneio @! R S
F1_IDNF C 36 0 ID da NF @! R S