| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| SFT | Livro Fiscal por Item de NF | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| FT_FILIAL | C | 2 | 0 | Filial | R | S | |||||
| FT_ENTRADA | D | 8 | 0 | Data Entrada | @D | S | |||||
| FT_EMISSAO | D | 8 | 0 | Data Emissao | @D | S | |||||
| FT_NFISCAL | C | 9 | 0 | Doc. Fiscal | @! | S | |||||
| FT_SERIE | C | 3 | 0 | Serie NF | !!! | S | |||||
| FT_CLIEFOR | C | 6 | 0 | Cli/Forn. | @! | R | S | ||||
| FT_LOJA | C | 2 | 0 | Codigo loja | @! | S | |||||
| FT_ESTADO | C | 2 | 0 | Estado Ref | @! | 12 | S | ||||
| FT_CFOP | C | 5 | 0 | Cod. Fiscal | @! | MAFISREF ("LF_CFO","MT100",M->FT_CFO) | 13 | S | |||
| FT_CODISS | C | 9 | 0 | Cod. Servico | @9 | MAFISREF ("LF_CODISS","MT100",M->FT_CODISS) | 60 | S | |||
| FT_ALIQICM | N | 5 | 2 | Aliq. ICMS | @E 99.99 | MAFISREF ("LF_ALIQICMS","MT100",M->FT_ALIQICM) | S | ||||
| FT_VALCONT | N | 14 | 2 | Vlr Contabil | @E 99,999,999,999.99 | MAFISREF ("LF_VALCONT","MT100",M->FT_VALCONT) | S | ||||
| FT_BASEICM | N | 14 | 2 | Base ICMS | @E 99,999,999,999.99 | MAFISREF ("LF_BASEICM","MT100",M->FT_BASEICM) | S | ||||
| FT_VALICM | N | 14 | 2 | Valor ICMS | @E 99,999,999,999.99 | MAFISREF ("LF_VALICM","MT100",M->FT_VALICM) | S | ||||
| FT_ISENICM | N | 14 | 2 | Vlr Isen ICM | @E 99,999,999,999.99 | MAFISREF ("LF_ISENICM","MT100",M->FT_ISENICM) | S | ||||
| FT_OUTRICM | N | 14 | 2 | Vlr Out ICMS | @E 99,999,999,999.99 | MAFISREF ("LF_OUTRICM","MT100",M->FT_OUTRICM) | S | ||||
| FT_BASEIPI | N | 14 | 2 | Vlr Base IPI | @E 99,999,999,999.99 | MAFISREF ("LF_BASEIPI","MT100",M->FT_BASEIPI) | S | ||||
| FT_VALIPI | N | 14 | 2 | Valor IPI | @E 99,999,999,999.99 | MAFISREF ("LF_VALIPI","MT100",M->FT_VALIPI) | S | ||||
| FT_ISENIPI | N | 14 | 2 | Vlr Isen IPI | @E 99,999,999,999.99 | MAFISREF ("LF_ISENIPI","MT100",M->FT_ISENIPI) | S | ||||
| FT_OUTRIPI | N | 14 | 2 | Vlr Outr IPI | @E 99,999,999,999.99 | MAFISREF ("LF_OUTRIPI","MT100",M->FT_OUTRIPI) | S | ||||
| FT_BASERET | N | 14 | 2 | Vlr Base Ret | @E 99,999,999,999.99 | MAFISREF ("LF_BASERET","MT100",M->FT_BASERET) | S | ||||
| FT_ICMSRET | N | 14 | 2 | Vlr ICMS Ret | @E 99,999,999,999.99 | MAFISREF ("LF_ICMSRET","MT100",M->FT_ICMSRET) | S | ||||
| FT_OBSERV | C | 31 | 0 | Obs Liv. Fis | @! | MAFISREF ("LF_OBSERV","MT100",M->FT_OBSERV) | S | ||||
| FT_TIPO | C | 1 | 0 | Tipo Lanc | @! | MAFISREF ("LF_TIPO","MT100",M->FT_TIPO) | L=Nota em Lote;S=Nota com ISS;B=Beneficiamento;D=Devolucao | S | |||
| FT_ICMSCOM | N | 14 | 2 | Vlr ICMS Com | @E 99,999,999,999.99 | MAFISREF ("LF_ICMSCOMP","MT100",M->FT_ICMSCOM) | S | ||||
| FT_ICMSDIF | N | 14 | 2 | Vlr ICMS Dif | @E 99,999,999,999.99 | MAFISREF ("LF_ICMSDIF","MT100",M->FT_ICMSDIF) | S | ||||
| FT_TRFICM | N | 14 | 2 | Vlr ICMS Trf | @E 99,999,999,999.99 | MAFISREF ("LF_TRFICM","MT100",M->FT_TRFICM) | S | ||||
| FT_CRDEST | N | 14 | 2 | Vlr Cred Est | @E 99,999,999,999.99 | MAFISREF ("LF_CRDEST","MT100",M->FT_CRDEST) | S | ||||
| FT_IPIOBS | N | 14 | 2 | Vlr IPI Obs | @E 99,999,999,999.99 | MAFISREF ("LF_IPIOBS","MT100",M->FT_IPIOBS) | S | ||||
| FT_OBSICM | N | 14 | 2 | Vlr ICM Obs | @E 99,999,999,999.99 | MAFISREF ("LF_OBSICM","MT100",M->FT_OBSICM) | S | ||||
| FT_OBSSOL | N | 14 | 2 | Vlr Sol Obs | @E 99,999,999,999.99 | MAFISREF ("LF_OBSSOL","MT100",M->FT_OBSSOL) | S | ||||
| FT_SOLTRIB | N | 14 | 2 | ICMS Sol Tri | @E 99,999,999,999.99 | MAFISREF ("LF_SOLTRIB","MT100",M->FT_SOLTRIB) | S | ||||
| FT_ICMAUTO | N | 14 | 2 | ICMS Frt Aut | @E 99,999,999,999.99 | MAFISREF ("LF_ICMAUTO","MT100",M->FT_ICMAUTO) | S | ||||
| FT_BASIMP1 | N | 14 | 2 | Base Imp 1 | @E 99,999,999,999.99 | S | |||||
| FT_BASIMP2 | N | 14 | 2 | Base Imp 2 | @E 99,999,999,999.99 | S | |||||
| FT_BASIMP3 | N | 14 | 2 | Base Imp 3 | @E 99,999,999,999.99 | S | |||||
| FT_BASIMP4 | N | 14 | 2 | Base Imp 4 | @E 99,999,999,999.99 | S | |||||
| FT_BASIMP5 | N | 14 | 2 | Base Imp 5 | @E 99,999,999,999.99 | S | |||||
| FT_BASIMP6 | N | 14 | 2 | Base Imp 6 | @E 99,999,999,999.99 | S | |||||
| FT_ALQIMP1 | N | 5 | 2 | Aliq Imp 1 | @E 99.99 | S | |||||
| FT_ALQIMP2 | N | 5 | 2 | Aliq Imp 2 | @E 99.99 | S | |||||
| FT_ALQIMP3 | N | 5 | 2 | Aliq Imp 3 | @E 99.99 | S | |||||
| FT_ALQIMP4 | N | 5 | 2 | Aliq Imp 4 | @E 99.99 | S | |||||
| FT_ALQIMP5 | N | 5 | 2 | Aliq Imp 5 | @E 99.99 | S | |||||
| FT_ALQIMP6 | N | 5 | 2 | Aliq Imp 6 | @E 99.99 | S | |||||
| FT_VALIMP1 | N | 14 | 2 | Vlr Imp 1 | @E 99,999,999,999.99 | S | |||||
| FT_VALIMP2 | N | 14 | 2 | Vlr Imp 2 | @E 99,999,999,999.99 | S | |||||
| FT_VALIMP3 | N | 14 | 2 | Vlr Imp 3 | @E 99,999,999,999.99 | S | |||||
| FT_VALIMP4 | N | 14 | 2 | Vlr Imp 4 | @E 99,999,999,999.99 | S | |||||
| FT_VALIMP5 | N | 14 | 2 | Vlr Imp 5 | @E 99,999,999,999.99 | S | |||||
| FT_VALIMP6 | N | 14 | 2 | Vlr Imp 6 | @E 99,999,999,999.99 | S | |||||
| FT_CFOEXT | C | 2 | 0 | CFOP Ext. | @! | MAFISREF ("LF_CFOEXT","MT100",M->FT_CFOEXT) | S | ||||
| FT_RETIMP1 | N | 14 | 2 | Vlr Ret 1 | @E 99,999,999,999.99 | S | |||||
| FT_RETIMP2 | N | 14 | 2 | Vlr Ret 2 | @E 99,999,999,999.99 | S | |||||
| FT_RETIMP3 | N | 14 | 2 | Vlr Ret 3 | @E 99,999,999,999.99 | S | |||||
| FT_RETIMP4 | N | 14 | 2 | Vlr Ret 4 | @E 99,999,999,999.99 | S | |||||
| FT_RETIMP5 | N | 14 | 2 | Vlr Ret 5 | @E 99,999,999,999.99 | S | |||||
| FT_RETIMP6 | N | 14 | 2 | Vlr Ret 6 | @E 99,999,999,999.99 | S | |||||
| FT_DTCANC | D | 8 | 0 | Data Cancel | @D | S | |||||
| FT_ISSST | C | 1 | 0 | Pagto Imp. | @! | MAFISREF ("LF_ISSST","MT100",M->FT_ISSST) | 1=Dentro Municipio;2=Fora do Municipio | S | |||
| FT_NRLIVRO | C | 1 | 0 | Numero Livro | @! | MAFISREF ("LF_NFLIVRO","MT100",M->FT_NRLIVRO) | S | ||||
| FT_FORMULA | C | 3 | 0 | Formula | @! | MAFISREF ("LF_FORMULA","MT100",M->FT_FORMULA) | S | ||||
| FT_PDV | C | 10 | 0 | Numero PDV | @! | S | |||||
| FT_ESPECIE | C | 5 | 0 | Especie NF | @! | 42 | S | ||||
| FT_CREDST | C | 1 | 0 | Crd/Deb ST | @! | MAFISREF ("LF_CREDST","MT100",M->FT_CREDST) | 1=Credita;2=Nao se aplica;3=Debita | S | |||
| FT_CONTA | C | 20 | 0 | Conta Contab | @! | S | |||||
| FT_PRODUTO | C | 15 | 0 | Cod. Produto | @! | SB1 | R | S | |||
| FT_TIPOMOV | C | 1 | 0 | Tipo Mov. | @! | Pertence (" ES") | E=Entrada;S=Saida | S | |||
| FT_ITEM | C | 4 | 0 | Codigo Item | @! | S | |||||
| FT_ALIQIPI | N | 5 | 2 | Aliq IPI | @E 99.99 | MAFISREF("LF_ALIQIPI","MT100",M->FT_ALIQIPI) | S | ||||
| FT_FORMUL | C | 1 | 0 | Form.Proprio | @! | Pertence("SN ") | R | S=Sim;N=Nao | S | ||
| FT_CLASFIS | C | 3 | 0 | Sit.Tribut. | @! | MAFISREF ("LF_CLASFIS","MT100",M->FT_CLASFIS) | R | S | |||
| FT_CTIPI | C | 2 | 0 | Trib. IPI | @! | MAFISREF ("LF_CTIPI","MT100",M->FT_CTIPI) | R | S | |||
| FT_FRETE | N | 16 | 2 | Valor Frete | @E 9,999,999,999.99 | R | S | ||||
| FT_SEGURO | N | 16 | 2 | Vlr Seguro | @E 9,999,999,999.99 | R | S | ||||
| FT_DESPESA | N | 16 | 2 | Vlr Despesas | @E 9,999,999,999.99 | MAFISREF ("LF_DESPESA","MT100",M->FT_DESPESA) | R | S | |||
| FT_BASEIRR | N | 16 | 2 | Base IRRF | @E 9,999,999,999.99 | R | S | ||||
| FT_ALIQIRR | N | 6 | 2 | Aliq. IRRF | @E 999.99 | R | S | ||||
| FT_VALIRR | N | 16 | 2 | Valor IRRF | @E 9,999,999,999.99 | R | S | ||||
| FT_BASEINS | N | 16 | 2 | Base INSS | @E 9,999,999,999.99 | R | S | ||||
| FT_ALIQINS | N | 6 | 2 | Aliq. INSS | @E 999,99 | R | S | ||||
| FT_VALINS | N | 16 | 2 | Valor INSS | @E 9,999,999,999.99 | R | S | ||||
| FT_POSIPI | C | 10 | 0 | Cod. NCM | @! | MAFISREF("LF_POSIPI","MT100",M->FT_POSIPI) | SYD | R | S | ||
| FT_IDENTF3 | C | 6 | 0 | Ident. SF3 | @! | R | S | ||||
| FT_ESTOQUE | C | 1 | 0 | Mov. Estoque | @! | Pertence (" SN").AND.MAFISREF("LF_ESTOQUE","MT100",M->FT_ESTOQUE) | R | S=Sim;N=Nao | S | ||
| FT_DESPIPI | C | 1 | 0 | IPI Desp. Ac | @! | Pertence (" SN").AND.MAFISREF("LF_DESPIPI","MT100",M->FT_DESPIPI) | R | S=Sim;N=Nao | S | ||
| FT_ISENRET | N | 16 | 2 | Retido Isent | @E 9,999,999,999.99 | MAFISREF ("LF_ISENRET", "MT100", M->FT_ISENRET) | S | ||||
| FT_OUTRRET | N | 16 | 2 | Retido Outro | @E 9,999,999,999.99 | MAFISREF ("LF_OUTRRET","MT100",M->FT_OUTRRET) | S | ||||
| FT_QUANT | N | 16 | 2 | Quantidade | @E 9,999,999,999.99 | S | |||||
| FT_PRCUNIT | N | 16 | 2 | Preco Unit. | @E 9,999,999,999.99 | S | |||||
| FT_DESCONT | N | 16 | 2 | Vlr Desconto | @E 9,999,999,999.99 | S | |||||
| FT_TOTAL | N | 16 | 2 | Vlr Total | @E 9,999,999,999.99 | S | |||||
| FT_PESO | N | 10 | 3 | Peso | @E 99,999.999 | S | |||||
| FT_NFORI | C | 9 | 0 | NF Original | @! | S | |||||
| FT_SERORI | C | 3 | 0 | Serie NF Ori | !!! | S | |||||
| FT_ITEMORI | C | 4 | 0 | Item NF Orig | @! | MAFISREF("LF_ITEMORI","MT100",M->FT_ITEMORI) | S | ||||
| FT_BASEPIS | N | 16 | 2 | Base PIS | @E 9,999,999,999.99 | S | |||||
| FT_ALIQPIS | N | 6 | 2 | Aliq. PIS | @E 999.99 | S | |||||
| FT_VALPIS | N | 16 | 2 | Valor PIS | @E 9,999,999,999.99 | S | |||||
| FT_BASECOF | N | 16 | 2 | Base COFINS | @E 9,999,999,999.99 | S | |||||
| FT_ALIQCOF | N | 6 | 2 | Aliq. COFINS | @E 999.99 | S | |||||
| FT_VALCOF | N | 16 | 2 | Valor COFINS | @E 9,999,999,999.99 | S | |||||
| FT_BASECSL | N | 16 | 2 | Base CSLL | @E 9,999,999,999.99 | S | |||||
| FT_ALIQCSL | N | 6 | 2 | Aliq. CSLL | @E 9,999,999,999.99 | S | |||||
| FT_VALCSL | N | 16 | 2 | Valor CSLL | @E 9,999,999,999.99 | S | |||||
| FT_BASEPS3 | N | 16 | 2 | Bs. Pis ST | @E 9,999,999,999.99 | MAFISREF("LF_BASEPS3","MT100",M->FT_BASEPS3) | S | ||||
| FT_ALIQPS3 | N | 5 | 2 | Al. Pis ST | @E 999.99 | MAFISREF("LF_ALIQPS3","MT100",M->FT_ALIQPS3) | S | ||||
| FT_VALPS3 | N | 16 | 2 | Vl. Pis ST | @E 9,999,999,999.99 | MAFISREF("LF_VALPS3","MT100",M->FT_VALPS3) | S | ||||
| FT_BASECF3 | N | 16 | 2 | Bs. Cof ST | @E 9,999,999,999.99 | MAFISREF("LF_BASECF3","MT100",M->FT_BASECF3) | S | ||||
| FT_ALIQCF3 | N | 5 | 2 | Al. Cof ST | @E 999.99 | MaFisRef("LF_ALIQCF3","MT100",M->FT_ALIQCF3) | S | ||||
| FT_VALCF3 | N | 16 | 2 | Vl. Cof ST | @E 9,999,999,999.99 | MAFISREF("LF_VALCF3","MT100",M->FT_VALCF3) | S | ||||
| FT_NFELETR | C | 20 | 0 | NF Eletr. | @! | R | S | ||||
| FT_EMINFE | D | 8 | 0 | Emissao NF-e | @D | R | S | ||||
| FT_HORNFE | C | 8 | 0 | Hora NF-e | @R 99:99:99 | R | S | ||||
| FT_CODNFE | C | 50 | 0 | Cd.Ver. NF-e | @! | R | S | ||||
| FT_CREDNFE | N | 16 | 2 | Cred. Conced | @E 9,999,999,999,999.99 | R | S | ||||
| FT_ISSSUB | N | 16 | 2 | ISS Subempr. | @E 9,999,999,999,999.99 | MaFisRef("LF_ISSSUB","MT100",M->FT_ISSSUB) | R | S | |||
| FT_RECISS | C | 1 | 0 | ISS Retido | @! | MaFisRef("LF_RECISS","MT100",M->FT_RECISS) | R | S | |||
| FT_NUMRPS | C | 12 | 0 | Num. RPS | @! | R | S | ||||
| FT_CFPS | C | 6 | 0 | CFPS | @! | MaFisRef("LF_CFPS","MT100",M->FT_CFPS) | R | S | |||
| FT_CLIENT | C | 6 | 0 | Cliente Entr | @! | R | S | ||||
| FT_LOJENT | C | 2 | 0 | Loja Entrega | @! | R | S | ||||
| FT_ISSMAT | N | 14 | 2 | ISS Mat. | @E 99,999,999,999.99 | MaFisRef("LF_ISSMAT","MT100",M->FT_ISSMAT) | R | S | |||
| FT_RGESPST | C | 1 | 0 | Reg.Esp.ST | @! | R | S | ||||
| FT_VALFDS | N | 14 | 2 | Vl.Fundersul | @E 99,999,999,999.99 | R | S | ||||
| FT_PRFDSUL | N | 12 | 8 | Pr.Fundersul | @E 999.99999999 | R | S | ||||
| FT_UFERMS | N | 14 | 2 | UFERMS | @E 99,999,999,999.99 | R | S | ||||
| FT_ESTCRED | N | 16 | 2 | Vl.Es.Cr/Deb | @E 9,999,999,999,999.99 | MaFisRef("LF_ESTCRED","MT100",M->FT_ESTCRED) | S | ||||
| FT_ANTICMS | C | 1 | 0 | Antecip.ICMS | @! | S | |||||
| FT_BASETST | N | 14 | 2 | Base ST tran | @E 999,999,999.99 | R | S | ||||
| FT_ALIQTST | N | 5 | 2 | Aliq ST tran | @E 99.99 | R | S | ||||
| FT_VALTST | N | 14 | 2 | Val. ST tran | @E 999,999,999.99 | R | S | ||||
| FT_VALANTI | N | 14 | 2 | Val Ant.ICMS | @E 99,999,999,999.99 | R | S | ||||
| FT_CHVNFE | C | 44 | 0 | Chave Nfe | @! | S | |||||
| FT_CSTPIS | C | 2 | 0 | CST Pis | @! | R | S | ||||
| FT_CSTCOF | C | 2 | 0 | CST COF | @! | R | S | ||||
| FT_CODBCC | C | 2 | 0 | Cod.BC Cred. | @! | R | S | ||||
| FT_INDNTFR | C | 1 | 0 | Ind.Nat.Fret | @! | R | S | ||||
| FT_CPPRODE | N | 14 | 2 | Crd.PRODEPE | @E 99,999,999,999.99 | S | |||||
| FT_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 | ||||
| FT_CRPRRON | N | 14 | 2 | Cr Pr RON | @E 99,999,999,999.99 | S | |||||
| FT_ALIQSOL | N | 6 | 2 | Aliq ICMS So | @E 999.99 | S | |||||
| FT_ALQFECP | N | 5 | 2 | Aliq FECP | @E 99.99 | S | |||||
| FT_PAUTST | N | 14 | 2 | ICMS ST Paut | @E 99,999,999,999.99 | R | S | ||||
| FT_PAUTIC | N | 14 | 2 | ICMS Pauta | @E 99,999,999,999.99 | R | S | ||||
| FT_PAUTPIS | N | 12 | 2 | PIS Pauta | @E 999,999,999.99 | R | S | ||||
| FT_PAUTCOF | N | 12 | 2 | Cofins Pauta | @E 999,999,999.99 | R | S | ||||
| FT_PAUTIPI | N | 9 | 2 | IPI Pauta | @E 999,999.99 | R | S | ||||
| FT_BSEFET | N | 14 | 2 | Base Fethab | @E 99,999,999,999.99 | R | N | ||||
| FT_ALQFET | N | 5 | 2 | Aliq Fethab | @E 99.99 | R | N | ||||
| FT_VALFET | N | 14 | 2 | Val Fethab | @E 99,999,999,999.99 | R | N | ||||
| FT_BSEFAB | N | 14 | 2 | Base Fabov | @E 99,999,999,999.99 | R | N | ||||
| FT_ALQFAB | N | 5 | 2 | Aliq Fabov | @E 99.99 | R | N | ||||
| FT_VALFAB | N | 14 | 2 | Val Fabov | @E 99,999,999,999.99 | R | N | ||||
| FT_BSEFAC | N | 14 | 2 | Base Facs | @E 99,999,999,999.99 | R | N | ||||
| FT_ALQFAC | N | 5 | 2 | Aliq Facs | @E 99.99 | R | N | ||||
| FT_VALFAC | N | 14 | 2 | Val Facs | @E 99,999,999,999.99 | R | N | ||||
| FT_CRPREPR | N | 14 | 2 | Crd Pres PR | @E 99,999,999,999.99 | S | |||||
| FT_CRPRERO | N | 14 | 2 | Cr Pres RO | @E 99,999,999,999.99 | S | |||||
| FT_CPRESPR | N | 14 | 2 | Cr Pres PR | @E 99,999,999,999.99 | S | |||||
| FT_ALQFUM | N | 5 | 2 | Alq FUMACOP | @E 99.99 | R | S | ||||
| FT_ALSENAR | N | 5 | 2 | Aliq.Senar | @E 99.99 | R | S | ||||
| FT_CRPREPE | N | 14 | 2 | Cr Pr PE | @E 99,999,999,999.99 | S | |||||
| FT_CRDTRAN | N | 16 | 2 | Crd.Transp | @E 9,999,999,999,999.99 | MaFisRef("LF_CRDTRAN","MT100",M->FT_CRDTRAN) | R | N | |||
| FT_CRPRELE | N | 16 | 2 | Vlr Cr Pr El | @E 9,999,999,999,999.99 | MaFisRef("LF_CRPRELE","MT100",M->FT_CRPRELE) | S | ||||
| FT_CRPRSIM | N | 16 | 2 | Cr Pres Simp | @E 9,999,999,999,999.99 | R | S | ||||
| FT_CRDZFM | N | 16 | 2 | Cred. ZFM | @E 9,999,999,999,999.99 | MaFisRef("LF_CRDZFM","MT100",M->FT_CRDZFM) | R | S | |||
| FT_CSTISS | C | 2 | 0 | Sit.Trib.ISS | @! | R | S | ||||
| FT_CRPRESP | N | 14 | 2 | Cr Pres SP | @E 99,999,999,999.99 | R | S | ||||
| FT_TNATREC | C | 4 | 0 | Tab.Nat.Rec | @! | MAFISREF("LF_TABNTRE","MT100",M->FT_TNATREC) | R | S | |||
| FT_CNATREC | C | 3 | 0 | Cod.Nat.Rec. | @! | MAFISREF("LF_CODNTRE","MT100",M->FT_CNATREC) | R | S | |||
| FT_GRUPONC | C | 2 | 0 | Grp.Nat.Rec. | @! | MAFISREF("LF_GRPNTRE","MT100",M->FT_GRUPONC) | R | S | |||
| FT_DTFIMNT | D | 8 | 0 | Dt.Fim N. R | MAFISREF("LF_DATNTRE","MT100",M->FT_DTFIMNT) | R | S | ||||
| FT_VALFECP | N | 14 | 2 | Valor FECP | @E 99,999,999,999.99 | R | S | ||||
| FT_CRDPRES | N | 16 | 2 | Crd.Pres. | @E 9,999,999,999,999.99 | MaFisRef("LF_CRDPRES","MT100",M->FT_CRDPRES) | R | S | |||
| FT_MARGEM | N | 6 | 2 | Margem | @E 999.99 | R | S | ||||
| FT_VALFUM | N | 14 | 2 | Vlr FUMACOP | @E 99,999,999,999.99 | R | S | ||||
| FT_VLSENAR | N | 14 | 2 | Valor Senar | @E 99,999,999,999.99 | R | S | ||||
| FT_BSSENAR | N | 14 | 2 | Base Senar | @E 99,999,999,999.99 | R | S | ||||
| FT_CROUTSP | N | 16 | 2 | Crd. Out. | @E 9,999,999,999,999.99 | R | S | ||||
| FT_PR43080 | N | 6 | 2 | %Red.43080 | @E 999.99 | S | |||||
| FT_MOTICMS | C | 2 | 0 | Mot.Desone. | MaFisRef("LF_MOTICMS","MT100",M->FT_MOTICMS) | #cBoxMotICM() | S | ||||
| FT_VLINCMG | N | 14 | 2 | Vl.Inc.Leite | @E 99,999,999,999.99 | R | S | ||||
| FT_PRINCMG | N | 6 | 2 | Pr.Inc.Leite | @E 999.99 | R | S | ||||
| FT_VFECPRN | N | 14 | 2 | Vlr FECOP-RN | @E 99,999,999,999.99 | R | S | ||||
| FT_VFESTRN | N | 14 | 2 | V.FECOP-ST/R | @E 99,999,999,999.99 | R | S | ||||
| FT_ALFECRN | N | 5 | 2 | Ali.FECOP-RN | @E 99.99 | R | S | ||||
| FT_BRETPIS | N | 14 | 2 | Base Pis | @E 99,999,999,999.99 | MaFisRef("IT_BASEPIS","MT100",M->FT_BRETPIS) | S | ||||
| FT_BRETCOF | N | 14 | 2 | Base Cofins | @E 99,999,999,999.99 | MaFisRef("IT_BASECOF","MT100",M->FT_BRETCOF) | S | ||||
| FT_BRETCSL | N | 14 | 2 | Base CSLL | @E 99,999,999,999.99 | MaFisRef("IT_BASECSL","MT100",M->FT_BRETCSL) | S | ||||
| FT_VRETPIS | N | 14 | 2 | Valor Pis | @E 99,999,999,999.99 | MaFisRef("IT_VALPIS","MT100",M->FT_VRETPIS) | S | ||||
| FT_VRETCOF | N | 14 | 2 | Valor Cofins | @E 99,999,999,999.99 | MaFisRef("IT_VALCOF","MT100",M->FT_VRETCOF) | S | ||||
| FT_VRETCSL | N | 14 | 2 | Valor CSLL | @E 99,999,999,999.99 | MaFisRef("IT_VALCSL","MT100",M->FT_VRETCSL) | S | ||||
| FT_ARETPIS | N | 6 | 2 | Aliq. PIS | @E 999.99 | MaFisRef("IT_ALIQPIS","MT100",M->FT_ARETPIS) | S | ||||
| FT_ARETCOF | N | 6 | 2 | Aliq. Cofins | @E 999.99 | MaFisRef("IT_ALIQCOF","MT100",M->FT_ARETCOF) | S | ||||
| FT_ARETCSL | N | 6 | 2 | Aliq. CSLL | @E 999.99 | MaFisRef("IT_ALIQCSL","MT100",M->FT_ARETCSL) | S | ||||
| FT_AGREG | C | 1 | 0 | Agrega valor | @! | Pertence("SNIABCDEFGH ") | R | I=ICMS+Mer;A=ICMS;S=Sim;N=Nao;B=ICMS+Mer-EIC;C=ICMS-EIC;D=Ded ICMS Vl Ct;E=Ded ICMS Dup;F=Ded Vl Mer Dup;G=Vl Dup ICMS;H=ICMS ST | S | ||
| FT_DESCICM | N | 14 | 2 | Desc.ICMS | @E 99,999,999,999.99 | MaFisRef("IT_DEDICM","MT100",M->FT_DESCICM) | S | ||||
| FT_COEPSST | N | 8 | 4 | Coef.PIS ST | @E 999.9999 | R | S | ||||
| FT_COECFST | N | 8 | 4 | Coef.COF ST | @E 999.9999 | R | S | ||||
| FT_VFECPST | N | 14 | 2 | Valor FECP S | @E 99,999,999,999.99 | R | S | ||||
| FT_CROUTGO | N | 16 | 2 | Crd. Out. | @E 9,999,999,999,999.99 | MaFisRef("LF_CROUTGO","MT100",M->FT_CROUTGO) | R | S | |||
| FT_CREDPRE | N | 14 | 2 | Cr Pre RS | @E 99,999,999,999.99 | R | S | ||||
| FT_BSREIN | N | 14 | 2 | B.C.Reinteg | @E 99,999,999,999.99 | R | S | ||||
| FT_DS43080 | N | 14 | 2 | Desc.43080 | @E 99,999,999,999.99 | R | S | ||||
| FT_IDSA1 | C | 20 | 0 | ID Hist. SA1 | @! | MaFisRef("IT_IDSA1","MT100",M->FT_IDSA1) | R | S | |||
| FT_IDSA2 | C | 20 | 0 | ID Hist. SA2 | @! | MaFisRef("IT_IDSA2","MT100",M->FT_IDSA2) | R | S | |||
| FT_IDSB1 | C | 20 | 0 | ID Hist. SB1 | @! | MaFisRef("IT_IDSB1","MT100",M->FT_IDSB1) | R | S | |||
| FT_IDSB5 | C | 20 | 0 | ID Hist. SB5 | @! | MaFisRef("IT_IDSB5","MT100",M->FT_IDSB5) | R | S | |||
| FT_IDSBZ | C | 20 | 0 | ID Hist. SBZ | @! | MaFisRef("IT_IDSBZ","MT100",M->FT_IDSBZ) | R | S | |||
| FT_IDSED | C | 20 | 0 | ID Hist. SED | @! | MaFisRef("IT_IDSED","MT100",M->FT_IDSED) | R | S | |||
| FT_IDSF4 | C | 20 | 0 | ID Hist. SF4 | @! | MaFisRef("IT_IDSF4","MT100",M->FT_IDSF4) | R | S | |||
| FT_IDSF7 | C | 20 | 0 | ID Hist. SF7 | @! | MaFisRef("IT_IDSF7","MT100",M->FT_IDSF7) | R | S | |||
| FT_IDSFB | C | 20 | 0 | ID Hist. SFB | @! | MaFisRef("IT_IDSFB","MT100",M->FT_IDSFB) | R | S | |||
| FT_IDSFC | C | 20 | 0 | ID Hist. SFC | @! | MaFisRef("IT_IDSFC","MT100",M->FT_IDSFC) | R | S | |||
| FT_CRPRST | N | 16 | 2 | Cr Pr ST | @E 9,999,999,999,999.99 | MaFisRef("LF_CRPRST","MT100",M->FT_CRPRST) | R | S | |||
| FT_DESCZFR | N | 14 | 2 | Desc.ZFM | @E 99,999,999,999.99 | R | S | ||||
| FT_NORESP | C | 1 | 0 | Norma Esp. | @! | Pertence("12") | R | 1=Sim;2=Nao | S | ||
| FT_PRCUNIC | N | 14 | 2 | Vl.Uni.Cig | @E 99,999,999,999.99 | R | S | ||||
| FT_MALQCOF | N | 6 | 2 | Aliq. COF M. | @E 999.99 | R | S | ||||
| FT_MALQPIS | N | 6 | 2 | Aliq. PIS M. | @E 999.99 | R | S | ||||
| FT_MVALCOF | N | 14 | 2 | Val. COF M. | @E 99,999,999,999.99 | R | S | ||||
| FT_MVALPIS | N | 14 | 2 | Val. PIS M. | @E 99,999,999,999.99 | R | S | ||||
| FT_PRDFIS | C | 15 | 0 | Cod.Prd.Fis | @! | MaFisRef("IT_PRDFIS","MT100",M->FT_PRDFIS) | R | S | |||
| FT_NATOPER | C | 10 | 0 | Natureza Ope | @! | MaFisRef("IT_NATOPER","MT100","M->FT_NATOPER") | R | S | |||
| FT_IDCFC | C | 20 | 0 | ID HIst CFC | @! | MaFisRef("IT_IDCFC","MT100",M->FT_IDCFC) | R | S | |||
| FT_CV139 | C | 1 | 0 | Conv.139 | @! | Pertence(" 12") | R | 1=Sim;2=Nao | S | ||
| FT_VLCIDE | N | 14 | 2 | Vl.Cide | @E 99,999,999,999.99 | MaFisRef("IT_VALCIDE","MT100",M->FT_VLCIDE) | S | ||||
| FT_BASECID | N | 14 | 2 | Base Cide | @E 99,999,999,999.99 | MaFisRef("IT_BASECID","MT100",M->FT_BASECID) | S | ||||
| FT_ALQCIDE | N | 5 | 2 | Aliq.Cide | @E 99.99 | MaFisRef("IT_ALQCIDE","MT100",M->FT_ALQCIDE) | S | ||||
| FT_VALCPM | N | 14 | 2 | Vl.ISS CPM | @E 99,999,999,999.99 | MaFisRef("IT_VALCPM","MT100",M->FT_VALCPM) | S | ||||
| FT_BASECPM | N | 14 | 2 | Bs.ISS CPM | @E 99,999,999,999.99 | MaFisRef("IT_BASECPM","MT100",M->FT_BASECPM) | S | ||||
| FT_ALQCPM | N | 5 | 2 | Alq.ISS CPM | @E 99.99 | MaFisRef("IT_ALQCPM","MT100",M->FT_ALQCPM) | S | ||||
| FT_PDIA | C | 6 | 0 | Periodo DIA | @! | R | S | ||||
| FT_B1DIAT | C | 1 | 0 | Incent.DIAT | @! | MaFisRef("IT_B1DIAT","MT100",M->FT_B1DIAT) | R | 1=Sim;2=Nao | S | ||
| FT_VFECPMG | N | 14 | 2 | Vlr FECP-MG | @E 99,999,999,999.99 | R | S | ||||
| FT_VFESTMG | N | 14 | 2 | V.FECP-ST/MG | @E 99,999,999,999.99 | R | S | ||||
| FT_ALFECMG | N | 5 | 2 | Ali.FECP-MG | @E 99.99 | R | S | ||||
| FT_VREINT | N | 14 | 2 | V.Reintegra | @E 99,999,999,999.99 | S | |||||
| FT_VFECPMT | N | 14 | 2 | Vlr FECP-MT | @E 99,999,999,999.99 | R | S | ||||
| FT_VFESTMT | N | 14 | 2 | V.FECP-ST/MT | @E 99,999,999,999.99 | R | S | ||||
| FT_ALFECMT | N | 5 | 2 | Ali.FECP-MT | @E 99.99 | R | S | ||||
| FT_CRDPCTR | N | 14 | 2 | Crd.Pres.Car | @E 99,999,999,999.99 | R | S | ||||
| FT_VALFMD | N | 14 | 2 | Val Famad | @E 99,999,999,999.99 | MaFisRef("IT_VALFMD","MT100",M->FT_VALFMD) | S | ||||
| FT_ALQFMP | N | 5 | 2 | Aliq.Fumipeq | @E 99.99 | MaFisRef("IT_ALQFMP","MT100",M->FT_ALQFMP) | S | ||||
| FT_BASEFMD | N | 14 | 2 | Base Famad | @E 99,999,999,999.99 | MaFisRef("IT_BASEFMD","MT100",M->FT_BASEFMD) | S | ||||
| FT_ALQFMD | N | 5 | 2 | Aliq Famad | @E 99.99 | MaFisRef("IT_ALQFMD","MT100",M->FT_ALQFMD) | S | ||||
| FT_INDICE | N | 16 | 4 | Indicador | @E 99,999,999,999.9999 | MaFisRef("IT_INDICE","MT100",M->FT_INDICE) | R | S | |||
| FT_VALPEDG | N | 6 | 2 | Val. Pedag. | @E 999.99 | R | S | ||||
| FT_PERCINP | N | 5 | 2 | Perc.INSS.Pt | @E 99.99 | R | S | ||||
| FT_VALINP | N | 14 | 2 | Val.INSS.Pt | @E 99,999,999,999.99 | R | S | ||||
| FT_CNAE | C | 9 | 0 | CNAE | @ | R | S | ||||
| FT_BASEINP | N | 14 | 2 | Bas.INSS.Pt | @E 99,999,999,999.99 | R | S | ||||
| FT_VALFMP | N | 14 | 2 | VL.Fumipeq | @E 99,999,999,999.99 | MaFisRef("IT_VALFMP","MT100",M->FT_VALFMP) | S | ||||
| FT_TRIBMUN | C | 20 | 0 | C. Trib. Mun | @! | R | S | ||||
| FT_BASEFMP | N | 14 | 2 | Base Fumipeq | @E 99,999,999,999.99 | MaFisRef("IT_BASEFMP","MT100",M->FT_BASEFMP) | S | ||||
| FT_VALFASE | N | 14 | 2 | Vlr.FASE-MT | @E 99,999,999,999.99 | Positivo() | R | S | |||
| FT_LOJDEST | C | 2 | 0 | Loja Dest | @! | R | S | ||||
| FT_VALFUND | N | 14 | 2 | Vlr.FUNDESA | @E 99,999,999,999.99 | Positivo() | R | S | |||
| FT_VRDICMS | N | 16 | 2 | Val.Desc.ICM | @E 9,999,999,999,999.99 | R | S | ||||
| FT_ALIQCPB | N | 5 | 2 | Aliquota CPR | @E 99.99 | R | S | ||||
| FT_CLIDEST | C | 6 | 0 | Cliente Dest | @! | R | S | ||||
| FT_SDOCORI | C | 3 | 0 | Ser.Original | !!! | R | S | ||||
| FT_CEST | C | 9 | 0 | CEST | @R 99.999.99 | MAFISREF("IT_CEST","MT100",M->FT_CEST) | F0G | R | S | ||
| FT_TAFKEY | C | 100 | 0 | TAF KEY ST1 | @! | R | S | ||||
| FT_BASFUND | N | 14 | 2 | Base FUNDESA | @E 99,999,999,999.99 | Positivo() | R | S | |||
| FT_BASFASE | N | 15 | 2 | Base FASE-MT | @E 999,999,999,999.99 | Positivo() | R | S | |||
| FT_BASEDES | N | 14 | 2 | Base. Destin | @E 99,999,999,999.99 | R | S | ||||
| FT_VFCPDIF | N | 14 | 2 | Vlr FECP Dif | @E 99,999,999,999.99 | R | S | ||||
| FT_CSOSN | C | 3 | 0 | Cod Sit SN | @! | R | S | ||||
| FT_ALIFASE | N | 5 | 2 | Aliq.FASE-MT | @E 99.99 | R | S | ||||
| FT_ICMNDES | N | 14 | 2 | ICMS ST Ant. | @E 99,999,999,999.99 | MaFisRef("LF_ICMNDES","MT100",M->FT_ICMNDES) .And. Positivo() | S | ||||
| FT_ATIVCPB | C | 8 | 0 | Cod. Ativ. | @! | R | S | ||||
| FT_ALIIMA | N | 5 | 2 | Aliq.IMA-MT | @E 99.99 | R | S | ||||
| FT_DIFAL | N | 14 | 2 | Difal ICMS | @E 99,999,999,999.99 | R | S | ||||
| FT_SDOC | C | 3 | 0 | Serie Doc. | !!! | R | S | ||||
| FT_DESPICM | N | 15 | 2 | Vl Desp ICMS | @E 999,999,999,999.99 | R | S | ||||
| FT_BASNDES | N | 14 | 2 | B.ICMS ST An | @E 99,999,999,999.99 | MaFisRef("LF_BASNDES","MT100",M->FT_BASNDES) .And. Positivo() | R | S | |||
| FT_FTRICMS | N | 8 | 5 | Fat.Desc.ICM | @E 99.99999 | R | S | ||||
| FT_GRPCST | C | 3 | 0 | Enq. IPI | @! | Vazio() .or. ExistCpo("F08") | R | S | |||
| FT_SERSAT | C | 9 | 0 | Ser.SAT | @! | R | S | ||||
| FT_PDDES | N | 6 | 2 | Perc. Destin | @E 999.99 | R | S | ||||
| FT_BASECPB | N | 14 | 2 | Base CPRB | @E 99,999,999,999.99 | R | S | ||||
| FT_VALIMA | N | 14 | 2 | Vlr. IMA-MT | @E 99,999,999,999.99 | Positivo() | R | S | |||
| FT_VALCPB | N | 14 | 2 | Valor CPRB | @E 99,999,999,999.99 | R | S | ||||
| FT_ALIFUND | N | 5 | 2 | Aliq.FUNDESA | @E 99.99 | R | S | ||||
| FT_BSICMOR | N | 16 | 2 | BS.ICMS Ori. | @E 9,999,999,999,999.99 | R | S | ||||
| FT_BASIMA | N | 14 | 2 | Base IMA-MT | @E 99,999,999,999.99 | R | S | ||||
| FT_PDORI | N | 6 | 2 | Perc. Origem | @E 999.99 | R | S | ||||
| FT_NFISCAN | C | 9 | 0 | Nota Fiscal | @! | R | S | ||||
| FT_ALIQPRO | N | 5 | 2 | Aliq.PROT.GO | @E 99.99 | R | S | ||||
| FT_TES | C | 3 | 0 | Tipo E/S | @9 | R | S | ||||
| FT_PRCMEDP | N | 11 | 2 | Prc Medio P. | @E 99,999,999.99 | S | |||||
| FT_BASFEEF | N | 14 | 2 | Bas.FEEF.RJ | @E 99,999,999,999.99 | R | S | ||||
| FT_BASEPRO | N | 14 | 2 | Bas.PROT.GO | @E 99,999,999,999.99 | R | S | ||||
| FT_VOPDIF | N | 16 | 2 | Vlr.OP.Dif | @E 9,999,999,999,999.99 | Positivo() .And. MaFisRef("IT_VOPDIF","MT100",M->FT_VOPDIF) | R | S | |||
| FT_VALFEEF | N | 14 | 2 | Val.FEEF.RJ | @E 99,999,999,999.99 | R | S | ||||
| FT_ALQFEEF | N | 5 | 2 | Aliq.FEEF.RJ | @E 99.99 | R | S | ||||
| FT_VALPRO | N | 14 | 2 | Val.PROT.GO | @E 99,999,999,999.99 | R | S | ||||
| FT_CLIDVMC | C | 6 | 0 | Cliente Dev | @! | R | S | ||||
| FT_LOJDVMC | C | 2 | 0 | Loja Dev | @! | R | S | ||||
| FT_SECP20 | N | 14 | 2 | Val. Serv.20 | @E 99,999,999,999.99 | R | S | ||||
| FT_ALCP20 | N | 5 | 2 | Aliq.Cntr.20 | @E 99.99 | R | S | ||||
| FT_VLCP25 | N | 14 | 2 | Val IMP 25 | @E 99,999,999,999.99 | R | S | ||||
| FT_VLCP15 | N | 14 | 2 | Val IMP 15 | @E 99,999,999,999.99 | R | S | ||||
| FT_VLCP20 | N | 14 | 2 | Val IMP 20 | @E 99,999,999,999.99 | R | S | ||||
| FT_BSCP20 | N | 14 | 2 | Base Serv.20 | @E 99,999,999,999.99 | R | S | ||||
| FT_BSCP25 | N | 14 | 2 | Base Serv.25 | @E 99,999,999,999.99 | R | S | ||||
| FT_SECP25 | N | 14 | 2 | Val. Serv.25 | @E 99,999,999,999.99 | R | S | ||||
| FT_ALCP15 | N | 5 | 2 | Aliq.Cntr.15 | @E 99.99 | R | S | ||||
| FT_ALCP25 | N | 5 | 2 | Aliq.Cntr.25 | @E 99.99 | R | S | ||||
| FT_BSCP15 | N | 14 | 2 | Base Serv.15 | @E 99,999,999,999.99 | R | S | ||||
| FT_SECP15 | N | 14 | 2 | Val. Serv.15 | @E 99,999,999,999.99 | R | S | ||||
| FT_BFCPANT | N | 14 | 2 | Base FCP Ant | @E 99,999,999,999.99 | R | S | ||||
| FT_VFCPANT | N | 14 | 2 | Vlr. FCP Ant | @E 99,999,999,999.99 | R | S | ||||
| FT_ALQNDES | N | 6 | 2 | A.ICMS ST An | @E 999.99 | R | S | ||||
| FT_BSFCPST | N | 14 | 2 | Base FCP ST | @E 99,999,999,999.99 | R | S | ||||
| FT_BSFCCMP | N | 14 | 2 | Base FCP Cmp | @E 99,999,999,999.99 | R | S | ||||
| FT_ALFCCMP | N | 6 | 2 | FECP Comp. | @E 999.99 | R | S | ||||
| FT_ALFCPST | N | 6 | 2 | Aliq. FCP ST | @E 999.99 | R | S | ||||
| FT_BASFECP | N | 14 | 2 | Base FCP Pr. | @E 99,999,999,999.99 | R | S | ||||
| FT_FCPAUX | N | 7 | 4 | Ind.Fcp.Aux. | @E 99.9999 | R | S | ||||
| FT_AFCPANT | N | 6 | 2 | Aliq FCP Ant | @E 999.99 | R | S | ||||
| FT_COLVDIF | C | 1 | 0 | Col ICMS Dif | @! | R | 1=Outros;2=Isento | S | |||
| FT_IDTRIB | C | 36 | 0 | ID Tributos | @! | R | S | ||||
| FT_PSTANT | N | 5 | 2 | % Ret Ant. | @E 99.99 | R | S | ||||
| FT_BASECPR | N | 14 | 2 | BS CRED PRES | @E 99,999,999,999.99 | R | S | ||||
| FT_BFCANTS | N | 14 | 2 | Bc. FCP Ant | @E 99,999,999,999.99 | R | S | ||||
| FT_BICEFET | N | 14 | 2 | BC ICMS Efet | @E 99,999,999,999.99 | R | S | ||||
| FT_PICEFET | N | 5 | 2 | % ICMS Efet | @E 99.99 | R | S | ||||
| FT_INFITEM | C | 8 | 0 | Inf. item | @! | Vazio() .Or. ExistCpo('F2Y') | F2Y | R | S | ||
| FT_ALIQFUN | N | 6 | 2 | Alq FUNRURAL | @E 999.99 | R | S | ||||
| FT_VFCANTS | N | 14 | 2 | FCP Rec. Ant | @E 99,999,999,999.99 | R | S | ||||
| FT_BASEFUN | N | 14 | 2 | Bas.FUNRURAL | @E 99,999,999,999.99 | R | S | ||||
| FT_VALFUN | N | 14 | 2 | Vlr FUNRURAL | @E 99,999,999,999.99 | R | S | ||||
| FT_INDISEN | C | 1 | 0 | Ind Isen Prv | @! | Pertence('12') | R | 1=Sim;2=Nao | S | ||
| FT_BSTANT | N | 14 | 2 | Bc. Ret. Ant | @E 99,999,999,999.99 | R | S | ||||
| FT_VICEFET | N | 14 | 2 | ICMS Eeftivo | @E 99,999,999,999.99 | R | S | ||||
| FT_PFCANTS | N | 5 | 2 | Alq FCP Ant. | @E 99.99 | R | S | ||||
| FT_VSTANT | N | 14 | 2 | Vl Ret Ant | @E 99,999,999,999.99 | R | S | ||||
| FT_RICEFET | N | 5 | 2 | Red.ICMS Efe | @E 99.99 | R | S | ||||
| FT_VICPRST | N | 14 | 2 | ICMS Substit | @E 99,999,999,999.99 | R | S | ||||