| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| SD2 | Itens de Venda da NF | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| D2_FILIAL | C | 2 | 0 | Filial | S | ||||||
| D2_ITEM | C | 2 | 0 | Item | @! | S | |||||
| D2_COD | C | 15 | 0 | Produto | @! | vazio().or.(existcpo("SB1").and. MaFisRef("IT_PRODUTO","MT100",M->D2_COD).And.A920IniCpo()) | SB1 | S | |||
| D2_SEGUM | C | 2 | 0 | Segunda UM | @! | ExistCpo("SAH") | SAH | S | |||
| D2_UM | C | 2 | 0 | Unidade | ExistCpo("SAH") | SAH | S | ||||
| D2_QUANT | N | 11 | 2 | Quantidade | @E 99999999.99 | Positivo().and. A100SegUm().And.MaFisRef("IT_QUANT","MT100",M->D2_QUANT) | S | ||||
| D2_PRCVEN | N | 14 | 2 | Vlr.Unitario | @E 99,999,999,999.99 | Positivo().And.NaoVazio().And.MaFisRef("IT_PRCUNI","MT100",M->D2_PRCVEN) | S | ||||
| D2_TOTAL | N | 14 | 2 | Vlr.Total | @E 999,999,999.99 | Positivo().And.A920Total(M->D2_TOTAL) .and. MaFisRef("IT_VALMERC","MT100",M->D2_TOTAL) | S | ||||
| D2_VALIPI | N | 14 | 2 | Vlr.IPI | @E 99,999,999,999.99 | Positivo().And.MaFisRef("IT_VALIPI","MT100",M->D2_VALIPI) | S | ||||
| D2_VALICM | N | 14 | 2 | Vlr.ICMS | @E 99,999,999,999.99 | Positivo().And.MaFisRef("IT_VALICM","MT100",M->D2_VALICM) | S | ||||
| D2_TES | C | 3 | 0 | Tipo Saida | @9 | existcpo("SF4").And.MaAvalTes("S",M->D2_TES).And.MaFisRef("IT_TES","MT100",M->D2_TES) | SF4 | S | |||
| D2_CF | C | 5 | 0 | Cod. Fiscal | @9 | NaoVazio().and.AvalCFO("SD2",M->D2_CF) .and. MaFisRef("IT_CF","MT100",M->D2_CF) | 13 | S | |||
| D2_DESC | N | 5 | 2 | Desc.Item | @E 99.99 | Positivo() | S | ||||
| D2_IPI | N | 5 | 2 | Aliq. IPI | @E 99.99 | Positivo().And.MaFisRef("IT_ALIQIPI","MT100",M->D2_IPI) | S | ||||
| D2_PICM | N | 5 | 2 | Aliq. ICMS | @E 99.99 | Positivo().And.MaFisRef("IT_ALIQICM","MT100",M->D2_PICM) | S | ||||
| D2_VALCSL | N | 14 | 2 | Valor CSLL | @E 99,999,999,999.99 | MaFisRef("IT_VALCSL","MT100",M->D2_VALCSL) | S | ||||
| D2_CONTA | C | 20 | 0 | C Contabil | @! | Vazio() .Or. Ctb105Cta() | CT1 | S | |||
| D2_PESO | N | 10 | 3 | Peso total | @E 999999.999 | Positivo() | S | ||||
| D2_OP | C | 14 | 0 | Ord Producao | @9 | vazio().or.existcpo("SC2") | SC2 | S | |||
| D2_PEDIDO | C | 6 | 0 | No do Pedido | @! | SC7 | S | ||||
| D2_ITEMPV | C | 2 | 0 | Item do Ped. | @! | S | |||||
| D2_CLIENTE | C | 6 | 0 | Cliente | @! | S | |||||
| D2_LOJA | C | 2 | 0 | Loja | @! | S | |||||
| D2_LOCAL | C | 2 | 0 | Armazem | @! | ExistCpo("NNR") | NNR | S | |||
| D2_DOC | C | 9 | 0 | Num. Docto. | @! | S | |||||
| D2_SERIE | C | 3 | 0 | Serie | !!! | S | |||||
| D2_GRUPO | C | 4 | 0 | Grupo | @! | ExistCpo("SBM") | SBM | S | |||
| D2_TP | C | 2 | 0 | Tipo Produto | @! | S | |||||
| D2_EMISSAO | D | 8 | 0 | Emissao | S | ||||||
| D2_CUSTO1 | N | 14 | 2 | Custo | @E 999,999,999.99 | S | |||||
| D2_CUSTO2 | N | 14 | 2 | Custo Moeda2 | @E 999,999,999.99 | S | |||||
| D2_CUSTO3 | N | 14 | 2 | Custo Moeda3 | @E 999,999,999.99 | S | |||||
| D2_CUSTO4 | N | 14 | 2 | Custo Moeda4 | @E 999,999,999.99 | S | |||||
| D2_CUSTO5 | N | 14 | 2 | Custo Moeda5 | @E 999,999,999.99 | S | |||||
| D2_PRUNIT | N | 14 | 2 | Prc Tabela | @E 99,999,999,999.99 | Positivo() | S | ||||
| D2_QTSEGUM | N | 11 | 2 | Qtde 2a UM | @E 99,999,999.99 | Positivo() | S | ||||
| D2_NUMSEQ | C | 6 | 0 | Num.Sequenc. | @! | S | |||||
| D2_EST | C | 2 | 0 | Estado Dest. | @! | ExistCpo("SX5","12"+M->D2_EST) | S | ||||
| D2_DESCON | N | 12 | 2 | Desconto | @E 999,999,999.99 | Positivo() .AND. MaFisRef("IT_DESCONTO","MT100",M->D2_DESCON) | S | ||||
| D2_TIPO | C | 1 | 0 | Tipo de N.F. | S | ||||||
| D2_NFORI | C | 9 | 0 | N.F.Original | @! | MaFisRef("IT_NFORI","MT100",M->D2_NFORI) | S | ||||
| D2_SERIORI | C | 3 | 0 | Serie Orig. | !!! | MaFisRef("IT_SERORI","MT100",M->D2_SERIORI) | S | ||||
| D2_QTDEDEV | N | 11 | 2 | Qtde Devol. | @E 99,999,999.99 | S | |||||
| D2_VALDEV | N | 14 | 2 | Valor Devol. | @E 9,999,999,999.99 | S | |||||
| D2_ORIGLAN | C | 2 | 0 | Orig. Lancto | @! | S | |||||
| D2_BRICMS | N | 14 | 2 | Ret. ICMS | @E 99,999,999,999.99 | Positivo().And.MaFisRef("IT_BASESOL","MT100",M->D2_BRICMS) | S | ||||
| D2_BASEORI | N | 16 | 2 | B.Orig ICMS | @E 999,999,999,999.99 | S | |||||
| D2_BASEICM | N | 16 | 2 | Base ICMS | @E 9,999,999,999,999.99 | Positivo().And.MaFisRef("IT_BASEICM","MT100",M->D2_BASEICM) | S | ||||
| D2_VALACRS | N | 16 | 2 | Vlr.Acresc. | @E 999,999,999,999.99 | S | |||||
| D2_IDENTB6 | C | 6 | 0 | Ident. PD3 | S | ||||||
| D2_CODISS | C | 9 | 0 | Cod.Serv.ISS | @9 | MaFisRef("IT_CODISS","MT100",M->D2_CODISS) | 60 | S | |||
| D2_GRADE | C | 1 | 0 | Grade | @! | S | |||||
| D2_SEQCALC | C | 14 | 0 | Seq.Recalc. | S | ||||||
| D2_ICMSRET | N | 14 | 2 | ICMS Solid. | @E 99,999,999,999.99 | Positivo().And.MaFisRef("IT_VALSOL","MT100",M->D2_ICMSRET) | S | ||||
| D2_COMIS1 | N | 5 | 2 | Comissao 1 | @E 99.99 | positivo() .Or. Vazio() | S | ||||
| D2_COMIS2 | N | 5 | 2 | Comissao 2 | @E 99.99 | positivo() .Or. Vazio() | S | ||||
| D2_COMIS3 | N | 5 | 2 | Comissao 3 | @E 99.99 | positivo() .Or. Vazio() | S | ||||
| D2_COMIS4 | N | 5 | 2 | Comissao 4 | @E 99.99 | positivo() .Or. Vazio() | S | ||||
| D2_COMIS5 | N | 5 | 2 | Comissao 5 | @E 99.99 | positivo() .Or. Vazio() | S | ||||
| D2_LOTECTL | C | 10 | 0 | Lote | LocXVlot() | S | |||||
| D2_NUMLOTE | C | 6 | 0 | Sub-Lote | LocXVlot() | S | |||||
| D2_DTVALID | D | 8 | 0 | Valid. Lote | M->D2_DTVALID >= dDataBase | S | |||||
| D2_DESCZFR | N | 14 | 2 | Desc.Z.Franc | @E 99,999,999,999.99 | MaFisRef("IT_DESCZF","MT100",M->D2_DESCZFR) | S | ||||
| D2_PDV | C | 10 | 0 | Numero PDV | @! | S | |||||
| D2_NUMSERI | C | 20 | 0 | Num de Serie | @! | S | |||||
| D2_DTLCTCT | D | 8 | 0 | Dt. do Lanc. | S | ||||||
| D2_CUSFF1 | N | 14 | 2 | Custo FIFO 1 | @E 999,999,999.99 | S | |||||
| D2_CUSFF2 | N | 14 | 2 | Custo FIFO 2 | @E 999,999,999.99 | S | |||||
| D2_CUSFF3 | N | 14 | 2 | Custo FIFO 3 | @E 999,999,999.99 | S | |||||
| D2_CUSFF4 | N | 14 | 2 | Custo FIFO 4 | @E 999,999,999.99 | S | |||||
| D2_CUSFF5 | N | 14 | 2 | Custo FIFO 5 | @E 999,999,999.99 | S | |||||
| D2_CLASFIS | C | 3 | 0 | Sit.Tribut. | @! | MAFISREF("IT_CLASFIS","MT100",M->D2_CLASFIS) | S | ||||
| D2_BASIMP1 | N | 14 | 2 | Base Imp. 1 | @E 99,999,999,999.99 | MaFisRef("IT_BASEIV1","MT100",M->D2_BASIMP1) | S | ||||
| D2_REMITO | C | 9 | 0 | Remito | @! | S | |||||
| D2_SERIREM | C | 3 | 0 | Serie remito | !!! | S | |||||
| D2_BASIMP2 | N | 14 | 2 | Base Imp. 2 | @E 99,999,999,999.99 | MaFisRef("IT_BASEIV2","MT100",M->D2_BASIMP2) | S | ||||
| D2_BASIMP3 | N | 14 | 2 | Base Imp. 3 | @E 99,999,999,999.99 | MaFisRef("IT_BASEIV3","MT100",M->D2_BASIMP3) | S | ||||
| D2_ITEMREM | C | 2 | 0 | Item remito | S | ||||||
| D2_BASIMP4 | N | 14 | 2 | Base Imp. 4 | @E 99,999,999,999.99 | MaFisRef("IT_BASEIV4","MT100",M->D2_BASIMP4) | S | ||||
| D2_BASIMP5 | N | 14 | 2 | Base Imp. 5 | @E 99,999,999,999.99 | MaFisRef("IT_BASECF2","MT100",M->D2_BASIMP5) | S | ||||
| D2_BASIMP6 | N | 14 | 2 | Base Imp. 6 | @E 99,999,999,999.99 | MaFisRef("IT_BASEPS2","MT100",M->D2_BASIMP6) | S | ||||
| D2_VALIMP1 | N | 14 | 2 | Valor Imp. 1 | @E 99,999,999,999.99 | MaFisRef("IT_VALIV1","MT100",M->D2_VALIMP1) | S | ||||
| D2_VALIMP2 | N | 14 | 2 | Valor Imp. 2 | @E 99,999,999,999.99 | MaFisRef("IT_VALIV2","MT100",M->D2_VALIMP2) | S | ||||
| D2_VALIMP3 | N | 14 | 2 | Valor Imp. 3 | @E 99,999,999,999.99 | MaFisRef("IT_VALIV3","MT100",M->D2_VALIMP3) | S | ||||
| D2_VALIMP4 | N | 14 | 2 | Valor Imp. 4 | @E 99,999,999,999.99 | MaFisRef("IT_VALIV4","MT100",M->D2_VALIMP4) | S | ||||
| D2_VALIMP5 | N | 14 | 2 | Valor Imp. 5 | @E 99,999,999,999.99 | MaFisRef("IT_VALCF2","MT100",M->D2_VALIMP5) | S | ||||
| D2_VALIMP6 | N | 14 | 2 | Valor Imp. 6 | @E 99,999,999,999.99 | MaFisRef("IT_VALPS2","MT100",M->D2_VALIMP6) | S | ||||
| D2_ITEMORI | C | 4 | 0 | It.Doc. Orig | @! | Vazio() .Or. Iif(FindFunction("A920ItemOri"), A920ItemOri(), .T. ) | S | ||||
| D2_CODFAB | C | 6 | 0 | Fabricante | @! | SA1 | S | ||||
| D2_LOJAFA | C | 2 | 0 | Loja Fabric. | @! | S | |||||
| D2_ALQIMP1 | N | 6 | 2 | Aliq. Imp. 1 | @E 999.99 | MaFisRef("IT_ALIQIV1","MT100",M->D2_ALQIMP1) | S | ||||
| D2_ALQIMP2 | N | 6 | 2 | Aliq. Imp. 2 | @E 999.99 | MaFisRef("IT_ALIQIV2","MT100",M->D2_ALQIMP2) | S | ||||
| D2_ALQIMP3 | N | 6 | 2 | Aliq. Imp. 3 | @E 999.99 | MaFisRef("IT_ALIQIV3","MT100",M->D2_ALQIMP3) | S | ||||
| D2_ALQIMP4 | N | 6 | 2 | Aliq. Imp. 4 | @E 999.99 | MaFisRef("IT_ALIQIV4","MT100",M->D2_ALQIMP4) | S | ||||
| D2_ALQIMP5 | N | 6 | 2 | Aliq. Imp. 5 | @E 999.99 | MaFisRef("IT_ALIQCF2","MT100",M->D2_ALQIMP5) | S | ||||
| D2_ALQIMP6 | N | 6 | 2 | Aliq. Imp. 6 | @E 999.99 | MaFisRef("IT_ALIQPS2","MT100",M->D2_ALQIMP6) | S | ||||
| D2_ESPECIE | C | 5 | 0 | Especie | @! | S | |||||
| D2_CCUSTO | C | 9 | 0 | Centro Custo | @! | Vazio() .Or. Ctb105CC() | CTT | S | |||
| D2_ITEMCC | C | 9 | 0 | Item C.C. | @! | Vazio() .Or. Ctb105Item() | CTD | S | |||
| D2_LOCALIZ | C | 15 | 0 | Endereco | @! | SBE | S | ||||
| D2_ENVCNAB | D | 8 | 0 | Envio Cnab | S | ||||||
| D2_ALIQINS | N | 5 | 2 | Aliq. INSS | @E 99.99 | MaFisRef("IT_ALIQINS","MT100",M->D2_ALIQINS) | S | ||||
| D2_ABSCINS | N | 14 | 2 | Ab. INSS Sub | @E 999,999,999.99 | MaFisRef("IT_ABSCINS","MT100",M->D2_ABSCINS) | S | ||||
| D2_VCAT156 | N | 16 | 2 | V Tot CAT156 | @E 9,999,999,999,999.99 | S | |||||
| D2_VLIMPOR | N | 14 | 2 | Vl.Import | @E 99,999,999,999.99 | Positivo() | R | S | |||
| D2_PREEMB | C | 20 | 0 | Proc.Embarq. | @! | S | |||||
| D2_ALIQISS | N | 5 | 2 | Aliq. ISS | @E 99.99 | MaFisRef("IT_ALIQISS","MT100",M->D2_ALIQISS) | S | ||||
| D2_BASEIPI | N | 14 | 2 | Vlr.Base IPI | @E 99,999,999,999.99 | Positivo().And.MaFisRef("IT_BASEIPI","MT100",M->D2_BASEIPI) | S | ||||
| D2_BASEISS | N | 14 | 2 | Base de ISS | @E 999,999,999.99 | MaFisRef("IT_BASEISS","MT100",M->D2_BASEISS) | S | ||||
| D2_VALISS | N | 14 | 2 | Valor do ISS | @E 999,999,999.99 | MaFisRef("IT_VALISS","MT100",M->D2_VALISS) | S | ||||
| D2_SEGURO | N | 14 | 2 | Vlr. Seguro | @E 99,999,999.99 | MaFisRef("IT_SEGURO","MT100",M->D2_SEGURO) | S | ||||
| D2_VALFRE | N | 14 | 2 | Vlr. Frete | @E 999,999,999.99 | MaFisRef("IT_FRETE","MT100",M->D2_VALFRE) | S | ||||
| D2_TPDCENV | C | 1 | 0 | Tipo env ori | .F. | S | |||||
| D2_DESPESA | N | 14 | 2 | Vlr. Despesa | @E 99,999,999.99 | MaFisRef("IT_DESPESA","MT100",M->D2_DESPESA) | S | ||||
| D2_OK | C | 2 | 0 | Marca | S | ||||||
| D2_CLVL | C | 9 | 0 | Classe Valor | @! | Vazio() .Or. Ctb105ClVl() | CTH | CtbInUse() | S | ||
| D2_CODGRP | C | 4 | 0 | Grupo | @!!!! | VldAuxCod1("D2_CODGRP","D2_CODITE") | SBM | V | S | ||
| D2_CODITE | C | 27 | 0 | Cod. Produto | VldAuxCod2("D2_COD","D2_CODGRP") | B00 | V | S | |||
| D2_BASEINS | N | 14 | 2 | Base de INSS | @E 999,999,999.99 | MaFisRef("IT_BASEINS","MT100",M->D2_BASEINS) | S | ||||
| D2_ICMFRET | N | 14 | 2 | Icms Frete | @E 99,999,999.99 | S | |||||
| D2_SERVIC | C | 3 | 0 | Cod.Servico | @! | ExistCpo('DC5') | DC5 | S | |||
| D2_STSERV | C | 1 | 0 | Status Serv. | @! | Pertence('123') | 1=Servico Nao Executado;2=Servico Interrompido;3=Servico Executado | S | |||
| D2_VALINS | N | 14 | 2 | Vlr. do INSS | @E 999,999,999.99 | MaFisRef("IT_VALINS","MT100",M->D2_VALINS) | S | ||||
| D2_PROJPMS | C | 10 | 0 | Cod.Projeto | Vazio().Or.ExistCpo("AF8") | AF8 | S | ||||
| D2_EDTPMS | C | 12 | 0 | EDT | @! | Vazio() .Or. A410VldPrj() | AFC | PmsSetF3("AFC",9) | S | ||
| D2_TASKPMS | C | 12 | 0 | Cod.Tarefa | @! | Vazio().Or.A410VldPrj() | AF9 | PmsSetF3("AF9",9) | S | ||
| D2_LICITA | C | 6 | 0 | Cod.Licitac. | @! | Vazio().Or.ExistCpo("AH9") | AH9 | S | |||
| D2_VARPRUN | N | 9 | 2 | Var.Prc.Unit | @E 999,999.99 | S | |||||
| D2_FORMUL | C | 1 | 0 | Form. Prop. | ! | S | |||||
| D2_TIPODOC | C | 2 | 0 | Id. Doc. | S | ||||||
| D2_VAC | N | 14 | 2 | Ac. Creditar | @E 999,999,999.99 | S | |||||
| D2_TIPOREM | C | 1 | 0 | Tipo Envio | .F. | S | |||||
| D2_QTDEFAT | N | 16 | 4 | Quant.Fatur. | @E 999,999,999.999 | S | |||||
| D2_QTDAFAT | N | 16 | 4 | Quant. a Fat | @E 999,999,999.999 | S | |||||
| D2_SEQUEN | C | 2 | 0 | Sequencia | 99 | S | |||||
| D2_POTENCI | N | 6 | 2 | Potencia | @E 999.99 | S | |||||
| D2_TPESTR | C | 6 | 0 | Estr.Fisica | @! | ExistCpo("DC8") | DC8 | S | |||
| D2_VALBRUT | N | 14 | 2 | Vlr.Bruto | @E 99,999,999,999.99 | MaFisRef("IT_TOTAL","MT100",M->D2_VALBRUT) | S | ||||
| D2_REGWMS | C | 1 | 0 | Regra WMS | 9 | Pertence("123") | 1=Lote;2=Numero de Serie;3=Data | S | |||
| D2_DTDIGIT | D | 8 | 0 | Data Digit. | R | S | |||||
| D2_NUMCP | C | 6 | 0 | Comp. Fut. | Vazio() .Or. ExistCpo("NO1") | R | S | ||||
| D2_CUSRP1 | N | 14 | 2 | C Reposicao | @E 999,999,999.99 | S | |||||
| D2_CUSRP2 | N | 14 | 2 | C Repos.2a M | @E 999,999,999.99 | S | |||||
| D2_CUSRP3 | N | 14 | 2 | C Repos.3a M | @E 999,999,999.99 | S | |||||
| D2_CUSRP4 | N | 14 | 2 | C Repos.4a M | @E 999,999,999.99 | S | |||||
| D2_CUSRP5 | N | 14 | 2 | C Repos.5a M | @E 999,999,999.99 | S | |||||
| D2_SITTRIB | C | 5 | 0 | Aliquota | S | ||||||
| D2_NFCUP | C | 9 | 0 | Num. NF/CUP | @! | R | S | ||||
| D2_CFPS | C | 6 | 0 | Cod. CFPS | @9 | MaFisRef("IT_CFPS","MT100",M->D2_CFPS) | S | ||||
| D2_DESCICM | N | 14 | 2 | Ded.ICMS | @E 99,999,999,999.99 | MaFisRef("IT_DEDICM","MT100",M->D2_DESCICM) | R | S | |||
| D2_BASEPS3 | N | 14 | 2 | Bs. Pis ST | @E 99,999,999,999.99 | Positivo().And.MaFisRef("IT_BASEPS3","MT100",M->D2_BASEPS3) | S | ||||
| D2_ALIQPS3 | N | 5 | 2 | Al. Pis ST | @E 99.99 | Positivo().And.MaFisRef("IT_ALIQPS3","MT100",M->D2_ALIQPS3) | S | ||||
| D2_VALPS3 | N | 14 | 2 | Vl. Pis ST | @E 99,999,999,999.99 | Positivo().And.MaFisRef("IT_VALPS3","MT100",M->D2_VALPS3) | S | ||||
| D2_BASECF3 | N | 14 | 2 | Bs. Cof ST | @E 99,999,999,999.99 | Positivo().And.MaFisRef("IT_BASECF3","MT100",M->D2_BASECF3) | S | ||||
| D2_ALIQCF3 | N | 5 | 2 | Al. Cof ST | @E 99.99 | Positivo().And.MaFisRef("IT_ALIQCF3","MT100",M->D2_ALIQCF3) | S | ||||
| D2_VALCF3 | N | 14 | 2 | Vl. Cof ST | @E 99,999,999,999.99 | Positivo().And.MaFisRef("IT_VALCF3","MT100",M->D2_VALCF3) | S | ||||
| D2_IDCFC | C | 20 | 0 | ID Hist. CFC | @ | MaFisRef("IT_IDCFC","MT100",M->D2_IDCFC) | R | S | |||
| D2_TRT | C | 3 | 0 | Seq. Empenho | @! | Vazio() | R | .F. | S | ||
| D2_PRUNDA | N | 14 | 2 | Vlr Unit DA | @E 999,999,999.99 | S | |||||
| D2_VALFDS | N | 14 | 2 | Vl.Fundersul | @E 999,999,999.99 | MaFisRef("IT_VALFDS","MT100",M->D2_VALFDS) | R | S | |||
| D2_PRFDSUL | N | 12 | 8 | Pr.Fundersul | @E 999.9999999 | MaFisRef("IT_PRFDSUL","MT100",M->D2_PRFDSUL) | R | S | |||
| D2_UFERMS | N | 14 | 2 | UFERMS | @E 999,999,999.99 | MaFisRef("IT_UFERMS","MT100",M->D2_UFERMS) | R | S | |||
| D2_BASEIRR | N | 16 | 2 | Base IR | @E 9,999,999,999.99 | MaFisRef("IT_BASEIRR","MT100",M->D2_BASEIRR) | R | S | |||
| D2_CODROM | C | 6 | 0 | Cod Romaneio | @! | NPR | R | S | |||
| D2_ESTCRED | N | 16 | 2 | Vlr Est Deb | @E 9,999,999,999,999.99 | MaFisRef("IT_ESTCRED","MT100",M->D2_ESTCRED) | R | S | |||
| D2_BASETST | N | 14 | 2 | Base ST tran | @E 999,999,999.99 | Positivo() .And. MaFisRef("IT_BASETST","MT100",M->D2_BASETST) | R | S | |||
| D2_ALIQTST | N | 5 | 2 | Aliq ST tran | @E 99.99 | Positivo() .And. MaFisRef("IT_ALIQTST","MT100",M->D2_ALIQTST) | R | S | |||
| D2_VALTST | N | 14 | 2 | Val. ST tran | @E 999,999,999.99 | Positivo() .And. MaFisRef("IT_VALTST","MT100",M->D2_VALTST) | R | S | |||
| D2_ORDSEP | C | 6 | 0 | Ordem Sep. | R | N | |||||
| D2_DESCZFC | N | 14 | 2 | Val.Cof.ZFM | @E 99,999,999,999.99 | MaFisRef("IT_DESCZFCOF","MT100",M->D2_DESCZFC) | R | S | |||
| D2_DESCZFP | N | 14 | 2 | Val.Pis.ZFM | @E 99,999,999,999.99 | MaFisRef("IT_DESCZFPIS","MT100",M->D2_DESCZFP) | R | S | |||
| D2_ALQIRRF | N | 6 | 2 | Aliq. IRRF | @E 999.99 | MaFisRef("IT_ALIQIRR","MT100",M->D2_ALQIRRF) | S | ||||
| D2_ABATISS | N | 14 | 2 | Abatim. ISS | @E 99,999,999,999.99 | MaFisRef("IT_ABVLISS","MT100",M->D2_ABATISS) | R | S | |||
| D2_ABATMAT | N | 14 | 2 | Abat. Mat. | @E 99,999,999,999.99 | MaFisRef("IT_ABMATISS","MT100",M->D2_ABATMAT) | R | S | |||
| D2_TNATREC | C | 4 | 0 | Tab.Nat.Rec. | @! | MAFISREF("IT_TABNTRE","MT100",M->D2_TNATREC) | R | S | |||
| D2_CNATREC | C | 3 | 0 | Cod.Nat.Rec. | @! | MAFISREF("IT_CODNTRE","MT100",M->D2_CNATREC) | R | S | |||
| D2_GRUPONC | C | 2 | 0 | Grp.Nat.Rec. | @! | MAFISREF("IT_GRPNTRE","MT100",M->D2_GRUPONC) | R | S | |||
| D2_DTFIMNT | D | 8 | 0 | Dt.Fim N.R. | MAFISREF("IT_DATNTRE","MT100",M->D1_DTFIMNT) | R | S | ||||
| D2_ALIQINA | N | 5 | 2 | Aliq INSS Ad | @E 99.99 | MaFisRef("IT_ALIQINA","MT100",M->D2_ALIQINA) | R | S | |||
| D2_VALINA | N | 14 | 2 | Vlr INSS Ad | @E 99,999,999,999.99 | MaFisRef("IT_VALINA","MT100",M->D2_VALINA) | R | S | |||
| D2_BASEINA | N | 14 | 2 | Base INSS Ad | @E 99,999,999,999.99 | MaFisRef("IT_BASEINA","MT100",M->D2_BASEINA) | R | S | |||
| D2_ESTOQUE | C | 1 | 0 | Mov Estoque | @! | pertence("SN") | R | S=Sim;N=Nao | S | ||
| D2_FCICOD | C | 36 | 0 | Codigo FCI | @! | R | S | ||||
| D2_IDSB1 | C | 20 | 0 | ID Hist. SB1 | @! | MaFisRef("IT_IDSB1","MT100",M->D2_IDSB1) | R | S | |||
| D2_IDSB5 | C | 20 | 0 | ID Hist. SB5 | @! | MaFisRef("IT_IDSB5","MT100",M->D2_IDSB5) | R | S | |||
| D2_IDSBZ | C | 20 | 0 | ID Hist. SBZ | @! | MaFisRef("IT_IDSBZ","MT100",M->D2_IDSBZ) | R | S | |||
| D2_IDSF4 | C | 20 | 0 | ID Hist. SF4 | @! | MaFisRef("IT_IDSF4","MT100",M->D2_IDSF4) | R | S | |||
| D2_IDSF7 | C | 20 | 0 | ID Hist. SF7 | @! | MaFisRef("IT_IDSF7","MT100",M->D2_IDSF7) | R | S | |||
| D2_ALIQFAB | N | 5 | 2 | Aliq. Fabov | @E 99.99 | MaFisRef("IT_ALIQFAB","MT100",M->D2_ALIQFAB) | R | S | |||
| D2_ALIQFAC | N | 5 | 2 | Aliq. Facs | @E 99.99 | MaFisRef("IT_ALIQFAC","MT100",M->D2_ALIQFAC) | R | S | |||
| D2_VALFAB | N | 14 | 2 | Vlr. Fabov | @E 99,999,999,999.99 | MaFisRef("IT_VALFAB","MT100",M->D2_VALFAB) | R | S | |||
| D2_09CAT17 | N | 14 | 2 | Col.09 Cat17 | @E 99,999,999,999.99 | R | S | ||||
| D2_16CAT17 | N | 14 | 2 | Col.16 Cat17 | @E 99,999,999,999.99 | R | S | ||||
| D2_ABATINS | N | 14 | 2 | Abatim. INSS | @E 99,999,999,999.99 | MaFisRef("IT_ABVLINSS","MT100",M->D2_ABATINS) | R | S | |||
| D2_ALIQFET | N | 5 | 2 | Aliq. Fethab | @E 99.99 | MaFisRef("IT_ALIQFET","MT100",M->D2_ALIQFET) | R | S | |||
| D2_ALIQSOL | N | 6 | 2 | Alq ICMS Sol | @E 999.99 | MaFisRef("IT_ALIQSOL","MT100",M->D2_ALIQSOL) | S | ||||
| D2_BASEFAB | N | 14 | 2 | Base Fabov | @E 99,999,999,999.99 | MaFisRef("IT_BASEFAB","MT100",M->D2_BASEFAB) | R | S | |||
| D2_BASEFAC | N | 14 | 2 | Base Facs | @E 99,999,999,999.99 | MaFisRef("IT_BASEFAC","MT100",M->D2_BASEFAC) | R | S | |||
| D2_BASEFET | N | 14 | 2 | Base Fethab | @E 99,999,999,999.99 | MaFisRef("IT_BASEFET","MT100",M->D2_BASEFET) | R | S | |||
| D2_CRPRESC | N | 14 | 2 | Crd Pres SC | @E 99,999,999,999.99 | MaFisRef("IT_CRPRESC","MT100",M->D2_CRPRESC) | R | S | |||
| D2_OKISS | C | 10 | 0 | Amarrac. Iss | @! | R | S | ||||
| D2_VALFAC | N | 14 | 2 | Vlr. Facs | @E 99,999,999,999.99 | MaFisRef("IT_VALFAC","MT100",M->D2_VALFAC) | R | S | |||
| D2_VALFET | N | 14 | 2 | Vlr. Fethab | @E 99,999,999,999.99 | MaFisRef("IT_VALFET","MT100",M->D2_VALFET) | R | S | |||
| D2_VALIRRF | N | 14 | 2 | Valor IRRF | @E 99,999,999,999.99 | MaFisRef("IT_VALIRR","MT100",M->D2_VALIRRF) | S | ||||
| D2_BASEPIS | N | 14 | 2 | Base Pis | @E 99,999,999,999.99 | MaFisRef("IT_BASEPIS","MT100",M->D2_BASEPIS) | S | ||||
| D2_VALCOF | N | 14 | 2 | Valor Cofins | @E 99,999,999,999.99 | MaFisRef("IT_VALCOF","MT100",M->D2_VALCOF) | S | ||||
| D2_BASECSL | N | 14 | 2 | Base CSLL | @E 99,999,999,999.99 | MaFisRef("IT_BASECSL","MT100",M->D2_BASECSL) | S | ||||
| D2_BASECOF | N | 14 | 2 | Base Cofins | @E 99,999,999,999.99 | MaFisRef("IT_BASECOF","MT100",M->D2_BASECOF) | S | ||||
| D2_TOTIMP | N | 14 | 2 | Perc.Cg.Trb | @E 99,999,999,999.99 | R | S | ||||
| D2_CODLAN | C | 6 | 0 | Cod. CAT83 | @! | Vazio() .Or. ExistCpo('CDZ') | S | ||||
| D2_BASEFUN | N | 14 | 2 | Bas FUNRURAL | @E 99,999,999,999.99 | MaFisRef("IT_BASEFUN","MT100",M->D2_BASEFUN) | R | S | |||
| D2_ALIQFUN | N | 5 | 2 | Alq FUNRURAL | @E 99.99 | MaFisRef("IT_PERFUN","MT100",M->D2_ALIQFUN) | R | S | |||
| D2_VALFUN | N | 14 | 2 | Vlr FUNRURAL | @E 99,999,999,999.99 | MaFisRef("IT_FUNRURAL","MT100",M->D2_VALFUN) | R | S | |||
| D2_RATEIO | C | 1 | 0 | Rateio | @! | 1=Sim;2=Nao | S | ||||
| D2_VLSENAR | N | 14 | 2 | Valor Senar | @E 99,999,999,999.99 | MaFisRef("IT_VLSENAR","MT100",M->D2_VLSENAR) | R | S | |||
| D2_ALSENAR | N | 5 | 2 | Aliq.Senar | @E 99.99 | MaFisRef("IT_ALSENAR","MT100",M->D2_ALSENAR) | R | S | |||
| D2_BSSENAR | N | 14 | 2 | Base Seanr | @E 99,999,999,999.99 | MaFisRef("IT_BSSENAR","MT100",M->D2_BSSENAR) | R | S | |||
| D2_CODLPRE | C | 6 | 0 | Lista Pres. | @! | R | S | ||||
| D2_ITLPRE | C | 3 | 0 | Item L.Pres. | @! | R | S | ||||
| D2_CBASEAF | C | 14 | 0 | Imobilizado | @! | R | S | ||||
| D2_VLINCMG | N | 14 | 2 | Vl.Inc.Leite | @E 99,999,999,999.99 | MAFISREF("IT_VLINCMG","MT100",M->D2_VLINCMG) | S | ||||
| D2_PRINCMG | N | 6 | 2 | Pr.Inc.Leite | @E 999.99 | MAFISREF("IT_PRINCMG","MT100",M->D2_PRINCMG) | S | ||||
| D2_MARGEM | N | 6 | 2 | Solid. Saida | @E 999.99 | Mafisref("IT_MARGEM","MT100",M->D2_MARGEM) | R | S | |||
| D2_PRODFIN | C | 15 | 0 | Prod Final | @! | Vazio() .or. ExistCPO("SB1") | SB1 | S | |||
| D2_VREINT | N | 14 | 2 | V.Reintegra | @E 99,999,999,999.99 | 'MaFisRef("IT_VREINT","MT100",M->D2_VREINT)' | R | S | |||
| D2_BSREIN | N | 14 | 2 | B.C.Reinteg | @E 99,999,999,999.99 | 'MaFisRef("IT_BSREIN","MT100",M->D2_BSREIN)' | R | S | |||
| D2_REVISAO | C | 3 | 0 | Revisao | R | S | |||||
| D2_ALMTERC | C | 2 | 0 | Armz Terc. | @! | IsAlmTerc(M->D2_ALMTERC) | S | ||||
| D2_VALPIS | N | 14 | 2 | Valor Pis | @E 99,999,999,999.99 | MaFisRef("IT_VALPIS","MT100",M->D2_VALPIS) | S | ||||
| D2_ALQCSL | N | 6 | 2 | Aliq. CSLL | @E 999.99 | MaFisRef("IT_ALIQCSL","MT100",M->D2_ALQCSL) | S | ||||
| D2_ALQPIS | N | 6 | 2 | Aliq. Pis | @E 999.99 | MaFisRef("IT_ALIQPIS","MT100",M->D2_ALQPIS) | S | ||||
| D2_ALQCOF | N | 6 | 2 | Aliq. Cofins | @E 999.99 | MaFisRef("IT_ALIQCOF","MT100",M->D2_ALQCOF) | S | ||||
| D2_ITEMGAR | C | 2 | 0 | Item Gar Est | R | S | |||||
| D2_ORCGAR | C | 6 | 0 | Orca Gar Est | @! | R | S | ||||
| D2_SERMAN | C | 3 | 0 | Serie Manual | !!! | R | S | ||||
| D2_DFABRIC | D | 8 | 0 | Data Fabric. | M->D2_DFABRIC<=DDATABASE | S | |||||
| D2_VALFMD | N | 14 | 2 | Vlr. Famad | @E 99,999,999,999.99 | MaFisRef("IT_VALFMD","MT100",M->D2_VALFMD) | S | ||||
| D2_TOTFED | N | 14 | 2 | Crg.Trb.Fed | @E 99,999,999,999.99 | R | S | ||||
| D2_MSEXP | C | 8 | 0 | Ident.Exp. | R | S | |||||
| D2_VALFMP | N | 14 | 2 | Vl. FUMIPEQ | @E 99,999,999,999.99 | MaFisRef("IT_VALFMP","MT100",M->D2_VALFMP) | S | ||||
| D2_ALIQCPB | N | 5 | 2 | Aliquota CPR | @E 99.99 | Positivo() .And. MaFisRef("IT_ALIQCPB","MT100",M->D2_ALIQCPB) | S | ||||
| D2_HREXPO | C | 8 | 0 | Hr. Ult. Exp | R | S | |||||
| D2_FTRICMS | N | 8 | 5 | Fat.Desc.ICM | @E 99.99999 | MaFisRef("IT_FTRICMS","MT100",M->D2_FTRICMS) | R | S | |||
| D2_INDICE | N | 16 | 4 | Indicador | @E 99,999,999,999.9999 | MaFisRef("IT_INDICE","MT100",M->D2_INDICE) | R | S | |||
| D2_TOTEST | N | 14 | 2 | Crg.Trb.Est | @E 99,999,999,999.99 | R | S | ||||
| D2_ALQFMP | N | 5 | 2 | Aliq. FUMIPE | @E 99.99 | MaFisRef("IT_ALQFMP","MT100",M-> D2_ALQFMP) | S | ||||
| D2_ALQFMD | N | 5 | 2 | Aliq. Famad | @E 99.99 | MaFisRef("IT_ALQFMD","MT100",M->D2_ALQFMD) | S | ||||
| D2_TOTMUN | N | 14 | 2 | Crg.Trb.Mun | @E 99,999,999,999.99 | R | S | ||||
| D2_BASEFMD | N | 14 | 2 | Base Famad | @E 99,999,999,999.99 | MaFisRef("IT_BASEFMD","MT100",M->D2_BASEFMD) | S | ||||
| D2_VRDICMS | N | 16 | 2 | Val.Desc.ICM | @E 9,999,999,999,999.99 | MaFisRef("IT_VRDICMS","MT100",M->D2_VRDICMS) | R | S | |||
| D2_BASEFMP | N | 14 | 2 | Base FUMIPEQ | @E 99,999,999,999.99 | MaFisRef("IT_BASEFMP","MT100",M-> D2_BASEFMP) | S | ||||
| D2_VALCPB | N | 14 | 2 | Valor CPRB | @E 99,999,999,999.99 | Positivo() .And. MaFisRef("IT_VALCPB","MT100",M->D2_VALCPB) | S | ||||
| D2_GRPCST | C | 3 | 0 | Enq. IPI | @! | MaFisRef("IT_GRPCST","MT100",M->D2_GRPCST) | S | ||||
| D2_BASECPB | N | 14 | 2 | Base CPRB | @E 99,999,999,999.99 | Positivo() .And. MaFisRef("IT_BASECPB","MT100",M->D2_BASECPB) | S | ||||
| D2_VALFASE | N | 14 | 2 | Vlr.FASE-MT | @E 99,999,999,999.99 | MaFisRef("IT_VALFASE","MT100",M->D2_VALFASE) | R | S | |||
| D2_ALIQCMP | N | 6 | 2 | Aliq Comp. | @E 999.99 | MaFisRef("IT_ALIQCMP","MT100",M->D2_ALIQCMP) | R | S | |||
| D2_ICMSCOM | N | 14 | 2 | ICMS Comple. | @E 99,999,999,999.99 | MaFisRef("IT_VALCMP","MT100",M->D2_ICMSCOM) | R | S | |||
| D2_ALFCCMP | N | 6 | 2 | FECP Comp. | @E 999.99 | MaFisRef("IT_ALFCCMP","MT100",M->D2_ALFCCMP) | R | S | |||
| D2_PDORI | N | 6 | 2 | Perc. Origem | @E 999.99 | MaFisRef("IT_PDORI","MT100",M->D2_PDORI) | R | S | |||
| D2_BASEDES | N | 14 | 2 | Base. Destin | @E 99,999,999,999.99 | MaFisRef("IT_BASEDES","MT100",M->D2_BASEDES) | R | S | |||
| D2_ALIIMA | N | 5 | 2 | Aliq. IMA-MT | @E 99.99 | MaFisRef("IT_ALIIMA","MT100",M->D2_ALIIMA) | R | S | |||
| D2_NRECAGR | C | 5 | 0 | Num Rec Agro | @! | R | S | ||||
| D2_VALFUND | N | 14 | 2 | Vlr.FUNDESA | @E 99,999,999,999.99 | MaFisRef("IT_VALFUND","MT100",M->D2_VALFUND) | R | S | |||
| D2_SDOCREM | C | 3 | 0 | Serie Doc. | !!! | R | S | ||||
| D2_BASIMA | N | 14 | 2 | Base IMA-MT | @E 99,999,999,999.99 | MaFisRef("IT_BASIMA","MT100",M->D2_BASIMA) | R | S | |||
| D2_BASFASE | N | 14 | 2 | Base FASE-MT | @E 99,999,999,999.99 | MaFisRef("IT_BASFASE","MT100",M->D2_BASFASE) | R | S | |||
| D2_PDDES | N | 6 | 2 | Perc. Destin | @E 999.99 | MaFisRef("IT_PDDES","MT100",M->D2_PDDES) | R | S | |||
| D2_VFCPDIF | N | 14 | 2 | Valor FECP | @E 99,999,999,999.99 | MaFisRef("IT_VFCPDIF","MT100",M->D2_VFCPDIF) | R | S | |||
| D2_ALIFUND | N | 5 | 2 | Aliq.FUNDESA | @E 99.99 | MaFisRef("IT_ALIFUND","MT100",M->D2_ALIFUND) | R | S | |||
| D2_BASFUND | N | 14 | 2 | Base FUNDESA | @E 99,999,999,999.99 | MaFisRef("IT_BASFUND","MT100",M->D2_BASFUND) | R | S | |||
| D2_DIFAL | N | 14 | 2 | ICMS Difal | @E 99,999,999,999.99 | MaFisRef("IT_DIFAL","MT100",M->D2_DIFAL) | R | S | |||
| D2_VALIMA | N | 16 | 2 | Vlr. IMA-MT | @E 9,999,999,999,999.99 | MaFisRef("IT_VALIMA","MT100",M->D2_VALIMA) | R | S | |||
| D2_CSOSN | C | 3 | 0 | Cod Sit SN | @! | MaFisRef("IT_CSOSN","MT100",M->D2_CSOSN) | R | S | |||
| D2_SDOC | C | 3 | 0 | Serie Doc. | !!! | R | S | ||||
| D2_SDOCORI | C | 3 | 0 | Serie Orig. | !!! | R | S | ||||
| D2_ALIFASE | N | 5 | 2 | Aliq.FASE-MT | @E 99.99 | MaFisRef("IT_ALIFASE","MT100",M->D2_ALIFASE) | R | S | |||
| D2_SDOCMAN | C | 3 | 0 | Serie Manual | !!! | R | S | ||||
| D2_VALFECP | N | 14 | 2 | Vlr FCP Prop | @E 99,999,999,999.99 | MaFisRef("IT_VALFECP","MT100",M->D2_VALFECP) | R | S | |||
| D2_ALQFECP | N | 6 | 2 | Aliq. FECP | @E 999.99 | MaFisRef("IT_ALIQFECP","MT100",M->D2_ALQFECP) | R | S | |||
| D2_ALFCPST | N | 6 | 2 | Aliq. FCP ST | @E 999.99 | MaFisRef("IT_ALFCST","MT100",M->D2_ALFCPST) | R | S | |||
| D2_VOPDIF | N | 16 | 2 | Vlr.OP.Dif | @E 9,999,999,999,999.99 | Positivo().And.MaFisRef("IT_VOPDIF","MT100",M->D2_VOPDIF) | R | S | |||
| D2_ICMSDIF | N | 16 | 2 | Vlr.ICMS Dif | @E 9,999,999,999,999.99 | Positivo().And.MaFisRef("IT_ICMSDIF","MT100",M->D2_ICMSDIF) | R | S | |||
| D2_VFECPST | N | 14 | 2 | Vlr FCP ST | @E 99,999,999,999.99 | MaFisRef("IT_VFECPST","MT100",M->D2_VFECPST) | R | S | |||
| D2_VALFEEF | N | 14 | 2 | Val.FEEF.RJ | @E 99,999,999,999.99 | Positivo() .And. MaFisRef("IT_VALFEEF","MT100",M->D2_VALFEEF) | S | ||||
| D2_ALQFEEF | N | 5 | 2 | Aliq.FEEF.RJ | @E 99.99 | Positivo() .And. MaFisRef("IT_ALQFEEF","MT100",M->D2_ALQFEEF) | S | ||||
| D2_BASFEEF | N | 14 | 2 | Bas.FEEF.RJ | @E 99,999,999,999.99 | Positivo() .And. MaFisRef("IT_BASFEEF","MT100",M->D2_BASFEEF) | S | ||||
| D2_ALIQPRO | N | 5 | 2 | Aliq.PROT.GO | @E 99.99 | Positivo().And. MaFisRef("IT_ALIQPRO","MT100",M->D1_ALIQPRO) | S | ||||
| D2_VALPRO | N | 14 | 2 | Val.PROT.GO | @E 99,999,999,999.99 | Positivo().And. MaFisRef("IT_VALPRO","MT100",M->D1_VALPRO) | S | ||||
| D2_BASEPRO | N | 14 | 2 | Bas.PROT.GO | @E 99,999,999,999.99 | Positivo().And. MaFisRef("IT_BASEPRO","MT100",M->D1_BASEPRO) | S | ||||
| D2_CTAREC | C | 20 | 0 | Cta Receita | @! | Vazio() .Or. Ctb105Cta() | CT1 | R | S | ||
| D2_BASFECP | N | 14 | 2 | Base FCP Pr. | @E 99,999,999,999.99 | MaFisRef("IT_BASFECP","MT100",M->D2_BASFECP) | R | S | |||
| D2_BSFCPST | N | 14 | 2 | Base FCP ST | @E 99,999,999,999.99 | MaFisRef("IT_BSFCPST","MT100",M->D2_BSFCPST) | R | S | |||
| D2_DECVLU | N | 1 | 0 | Dec. VlUN | 9 | R | S | ||||
| D2_PAFMD5 | C | 32 | 0 | MD5 | R | S | |||||
| D2_TPREPAS | C | 6 | 0 | Tipo Repasse | @! | Vazio() .OR. ExistCpo("SX5","0G"+M->D2_TPREPAS) | 0G | R | S | ||
| D2_BSFCCMP | N | 14 | 2 | Base FCP Cmp | @E 99,999,999,999.99 | MaFisRef("IT_BSFCCMP","MT100",M->D2_BSFCCMP) | R | S | |||
| D2_FCPAUX | N | 7 | 4 | Ind.Fcp.Aux. | @E 99.9999 | MaFisRef("IT_FCPAUX","MT100",M->D2_FCPAUX) | R | S | |||
| D2_DECQTD | N | 1 | 0 | Dec. Qtde | 9 | R | S | ||||
| D2_BASECPM | N | 14 | 2 | Bs.ISS CPM | @E 99,999,999,999.99 | MaFisRef("IT_BASECPM","MT100",M->D2_BASECPM) | S | ||||
| D2_VALCPM | N | 14 | 2 | Vl.ISS CPM | @E 99,999,999,999.99 | MaFisRef("IT_VALCPM","MT100",M->D2_VALCPM) | S | ||||
| D2_ALQCPM | N | 5 | 2 | Alq.ISS CPM | @E 99.99 | MaFisRef("IT_ALQCPM","MT100",M->D2_ALQCPM) | S | ||||
| D2_IDTRIB | C | 36 | 0 | Id. Tributos | @! | R | S | ||||