Tabela
SC7 Ped.Compra / Aut.Entrega
Campo Tipo Tamanho Decimal Titulo Formato Validacao F3 Contexto Lista Condicao PYME
C7_FILIAL C 2 0 Filial R S
C7_TIPO N 1 0 Tipo 9 Pertence("1,2") S
C7_ITEM C 4 0 Item @! S
C7_PRODUTO C 15 0 Produto @! A093PROD().And.A120COD().And.MaFisRef("IT_PRODUTO","MT120",M->C7_PRODUTO).And.A120Tabela() .And. A120Produto(M->C7_PRODUTO) SB1 S
C7_UM C 2 0 Unidade ExistCpo("SAH") SAH S
C7_SEGUM C 2 0 Segunda UM @! ExistCpo("SAH") SAH S
C7_QUANT N 12 2 Quantidade @E 999999999.99 A120QTDGRA().AND.Positivo().And.A120Quant(M->C7_QUANT).And.MaFisRef("IT_QUANT","MT120",M->C7_QUANT).And.a120Tabela() S
C7_CODTAB C 3 0 Tab.Preco MaVldTabCom(M->cA120Forn,M->cA120Loj,M->C7_CODTAB,M->cCondicao,,M->dA120Emis).And.A120Tabela() AIA S
C7_PRECO N 14 2 Prc Unitario @E 99,999,999,999.99 Positivo().and.A120Preco(M->C7_PRECO) .And. MaFisRef("IT_PRCUNI","MT120",M->C7_PRECO) .AND. MTA121TROP(n) S
C7_TOTAL N 14 2 Vlr.Total @E 999,999,999.99 A120Total(M->C7_TOTAL).And.MaFisRef("IT_VALMERC","MT120",M->C7_TOTAL) S
C7_QTSEGUM N 11 2 Qtd. 2a UM @E 99999999.99 A120QtdGra().and.(Positivo().or.Vazio()).and.A100Segum().And.a120Tabela() S
C7_IPI N 5 2 Aliq. IPI @E 99.99 MaFisRef("IT_ALIQIPI","MT120",M->C7_IPI) S
C7_NUMSC C 6 0 Numero da SC @! SC1 S
C7_ITEMSC C 4 0 Item da SC @! S
C7_DINICOM D 8 0 Dt. Ini. Com R S
C7_DINITRA D 8 0 Dt. Ini. Tra R S
C7_DINICQ D 8 0 Dt. Ini. CQ R S
C7_DATPRF D 8 0 Dt. Entrega A120QtdGra() S
C7_LOCAL C 2 0 Armazem @! ExistCpo("NNR") NNR S
C7_OBS C 30 0 Observacoes @! S
C7_FORNECE C 6 0 Fornecedor @! FOR S
C7_CC C 9 0 Centro Custo @! Vazio() .Or. Ctb105CC() CTT S
C7_CONTA C 20 0 Cta Contabil @! Vazio() .Or. Ctb105Cta() CT1 S
C7_ITEMCTA C 9 0 Item Conta @! Vazio() .Or. Ctb105Item() CTD S
C7_LOJA C 2 0 Loja @! S
C7_COND C 3 0 Cond. Pagto @! NaoVazio() .And. ExistCpo("SE4") SE4 S
C7_CONTATO C 15 0 Contato @! S
C7_FILENT C 2 0 Filial Entr. A120FilEnt(M->C7_FILENT) SM0_01 S
C7_DESC1 N 5 2 Desconto 1 @E 99.99 S
C7_DESC2 N 5 2 Desconto 2 @E 99.99 S
C7_DESC3 N 5 2 Desconto 3 @E 99.99 S
C7_EMISSAO D 8 0 DT Emissao NaoVazio(M->C7_EMISSAO) S
C7_NUM C 6 0 Numero PC @! NaoVazio(M->C7_NUM).AND.!ChkChaveSC7(M->C7_NUM,.T.) S
C7_QUJE N 12 2 Qtd.Entregue @E 999999999.99 S
C7_REAJUST C 3 0 Reajuste @! SM4 S
C7_FRETE N 14 2 Vlr.Frete @E 999,999,999.99 Positivo() S
C7_EMITIDO C 1 0 Ja' emitiu ! S
C7_DESCRI C 30 0 Descricao @! S
C7_TPFRETE C 1 0 Tipo Frete X S
C7_QTDREEM N 2 0 Reemissao 99 S
C7_CODLIB C 10 0 Liberacao @! S
C7_RESIDUO C 1 0 Resid. Elim. @! Pertence("S ") S
C7_NUMCOT C 6 0 Num.Cotacao @! .F. S
C7_MSG C 3 0 Mensagem @! SM4 S
C7_TX C 2 0 Transmissao !! S
C7_CONTROL C 1 0 Controle S
C7_IPIBRUT C 1 0 Cons. Desc. @! S
C7_ENCER C 1 0 Ped. Encerr. ! S
C7_OP C 14 0 OP. @! A120VldOP() SC2 S
C7_VLDESC N 14 2 Vl. Desconto @E 999,999,999.99 Positivo().And.A120ZeraDesc().And.MaFisRef("IT_DESCONTO","MT120",M->C7_VLDESC) S
C7_SEQUEN C 4 0 Sequencia @! S
C7_NUMIMP C 6 0 Num.Purch.Or S
C7_ORIGEM C 8 0 Rotina Gerad S
C7_QTDACLA N 12 2 Qtd.a Classi @E 999999999.99 S
C7_VALEMB N 16 2 Vlr Embalag. @E 999,999,999.99 Positivo().And.MaFisRef("IT_VALEMB","MT120",M->C7_VALEMB) S
C7_FLUXO C 1 0 Fluxo Caixa @! Pertence("SN") S=Sim;N=Nao S
C7_TPOP C 1 0 Tipo Op @! Pertence("FP") F=Firme;P=Prevista inclui S
C7_APROV C 6 0 Grupo Aprov. @! S
C7_CONAPRO C 1 0 Controle Ap. @! S
C7_GRUPCOM C 6 0 Gr. Compras @! S
C7_USER C 6 0 Cod. Usuario @! S
C7_STATME C 1 0 Status do ME @! Pertence(" 3456") S
C7_OK C 2 0 Ok S
C7_RESREM C 1 0 Elim. Reman. @! R N
C7_QTDSOL N 12 2 Qtde da SC @! 9,999,999.99 S
C7_VALIPI N 14 2 Vlr.IPI @E 999,999,999.99 Positivo().And.MaFisRef("IT_VALIPI","MT120",M->C7_VALIPI) S
C7_VALICM N 14 2 Vlr.ICMS @E 999,999,999.99 Positivo().And.MaFisRef("IT_VALICM","MT120",M->C7_VALICM) S
C7_OPER C 2 0 Tip.Operacao ExistCpo("SX5","DJ"+M->C7_OPER) .And. MaFisRef("IT_TPOPER","MT120",M->C7_OPER) DJ V S
C7_TES C 3 0 Tipo Entrada @! ( Vazio().Or.ExistCpo("SF4") ) .And. (MaAvalTes("E",M->C7_TES).And.MaFisRef("IT_TES","MT120",M->C7_TES)) SF4 S
C7_DESC N 5 2 % Desc.Item @E 99.99 Positivo() S
C7_PICM N 5 2 Aliq.ICMS @E 99.99 Positivo().And.VldAliqIcm(M->C7_PICM).And.MaFisRef("IT_ALIQICM","MT120",M->C7_PICM) S
C7_BASEICM N 14 2 Base Icms @E 999,999,999.99 Positivo().And.MaFisRef("IT_BASEICM","MT120",M->C7_BASEICM) S
C7_BASEIPI N 14 2 Vlr.Base IPI @E 999,999,999.99 Positivo().And.MaFisRef("IT_BASEIPI","MT120",M->C7_BASEIPI) S
C7_SEGURO N 14 2 Vlr.Seguro @E 999,999,999.99 Positivo().And.MaFisRef("IT_SEGURO","MT120",M->C7_SEGURO) S
C7_DESPESA N 14 2 Vlr.Despesas @E 999,999,999.99 Positivo().And.MaFisRef("IT_DESPESA","MT120",M->C7_DESPESA) S
C7_VALFRE N 14 2 Vlr.Frete @E 999,999,999.99 Positivo().And.MaFisRef("IT_FRETE","MT120",M->C7_VALFRE) S
C7_MOEDA N 2 0 Moeda 99 S
C7_TXMOEDA N 11 4 Taxa Moeda @E 999999.9999 Positivo() S
C7_PENDEN C 1 0 Pendente @! S=Sim;N=Nao S
C7_CLVL C 9 0 Classe Valor @! Vazio() .Or. CTB105CLVL() CTH CtbInUse() S
C7_BASEIR N 14 2 Base IRRF @E 999,999,999.99 MaFisRef("IT_BASEIRR","MT120",M->C7_BASEIR) S
C7_ALIQIR N 5 2 Aliq. IRRF @E 999.99 MaFisRef("IT_ALIQIRR","MT120",M->C7_ALIQIR) S
C7_VALIR N 14 2 Valor IRRF @E 999,999,999.99 MaFisRef("IT_VALIRR","MT120",M->C7_VALIR) S
C7_ICMCOMP N 14 2 ICMS Compl. @e 999,999,999.99 MAFISREF("IT_VALCMP","MT120",M->C7_ICMCOMP) S
C7_CODGRP C 4 0 Grupo @!!!! VldAuxCod1("C7_CODGRP","C7_CODITE") SBM V S
C7_ICMSRET N 14 2 ICMS Retido @e 999,999,999.99 MAFISREF("IT_VALSOL","MT120",M->C7_ICMSRET) S
C7_CODITE C 27 0 Cod. Produto VldAuxCod2("C7_PRODUTO","C7_CODGRP") B00 V S
C7_VALSOL N 14 2 Val. ICMS So @E 999,999,999.99 Positivo().And.MaFisRef("IT_VALSOL","MT120",M->C7_VALSOL) S
C7_ESTOQUE C 1 0 Atual.Estoq N
C7_SOLICIT C 30 0 Solicitante @! R S
C7_SEQMRP C 6 0 Seq MRP @! S
C7_CODORCA C 8 0 Cod. Orcam. N13 S
C7_DTLANC D 8 0 Dt. Contab. S
C7_CODCRED C 6 0 Cod.Credor @! ExistCpo( "SA2" ) S
C7_TIPOEMP C 1 0 Tipo empenho @! Pertence("12345") 1=Dispensada;2=Tomada de Preco;3=Concorrencia;4=Carta Convite;5=Outra S
C7_ESPEMP C 1 0 Esp.Empenho @! Pertence("123") 1=Ordinario;2=Global;3=Estimativo S
C7_CONTRA C 15 0 Num.Contrato @! S
C7_CONTREV C 3 0 Rev.Contrato @! S
C7_PLANILH C 6 0 Num.Planilha @! S
C7_MEDICAO C 6 0 Num.Medicao @! S
C7_ITEMED C 10 0 Item Medicao @! S
C7_POLREPR C 1 0 Politica Rep @! R N=Manual;S=C/ Periodo Firme;E=S/ Perido Firme;M=Customizada SuperGetMv("MV_APS",.F.,"")=="DRUMMER" S
C7_FREPPCC C 2 0 Tipo Frete @! R CC=Collect;PP=Prepaid S
C7_PERREPR N 3 0 Periodo Repr 999 Positivo() R GDFIELDGET("C7_POLREPR") # "N" S
C7_DT_IMP D 8 0 Dt Import. @D R S
C7_GRADE C 1 0 Grade Grade Pertence("S N") S=Sim;N=Nao S
C7_AGENTE C 3 0 Ag.Embarc. @! ExistCpo("DB8",M->C7_AGENTE) DB8 R S
C7_ITEMGRD C 3 0 Item grade @! S
C7_FORWARD C 3 0 Cod Forward. @! Vazio().Or.ExistCpo("DB8",M->C7_FORWARD) DB8 R S
C7_TIPO_EM C 3 0 Via Transp. @! ExistCpo("DBF",M->C7_TIPO_EM) DBF R S
C7_ORIGIMP C 3 0 Origem @! ExistCpo("DBD",M->C7_ORIGIMP,2) DBD R S
C7_DEST C 3 0 Destino @! ExistCpo("DBD",M->C7_DEST,2) DBD R S
C7_COMPRA C 3 0 Cod.Comprad. @! ExistCpo("SY1",M->C7_COMPRA,1) SY1 R S
C7_PESO_B N 13 3 Peso Bruto @E 999,999,999.999 Positivo() R S
C7_INCOTER C 3 0 Incoterm @! ExistCpo("DB6",M->C7_INCOTER) DB6 R S
C7_IMPORT C 3 0 Importador @! ExistCpo("DB7",M->C7_IMPORT) DB7 R S
C7_CONSIG C 3 0 Cod.Consig. @! Vazio().Or.ExistCpo("DB7",M->C7_CONSIG) DB7 R S
C7_CONF_PE D 8 0 Dt Conf Ped @D R S
C7_DESP C 3 0 Despachante @! Vazio().Or.ExistCpo("DB9",M->C7_DESP) DB9 R S
C7_EXPORTA C 6 0 Exportador @! FOR R S
C7_LOJAEXP C 2 0 Exp. Loja @! R S
C7_CONTAIN C 1 0 Modal. CNTR @! Vazio().Or.Pertence("1234 ") R 1=House to House;2=House to Pier;3=Pier to House;4=Pier to Pier S
C7_MT3 N 8 2 Vol. Cubado @E 99,999.99 Positivo().And.A123Peso(M->C7_MT3) R S
C7_CONTA20 N 4 0 Contain. 20' @E 9999 Positivo() R S
C7_CONTA40 N 4 0 Contain. 40' @E 9999 Positivo() R S
C7_CON40HC N 4 0 Cont. 40' hc @E 9999 Positivo() R S
C7_ARMAZEM C 7 0 Armazem 9999999 Vazio().Or.ExistCpo("DBE",M->C7_ARMAZEM) DBEADU R S
C7_FABRICA C 6 0 Fabricante @! R S
C7_LOJFABR C 2 0 Fabric. Loja @! R S
C7_DT_EMB D 8 0 Dt Embarque @D A123DtEmb(M->C7_DT_EMB) R S
C7_TEC C 10 0 Pos.IPI/NCM @R 9999.99.99 R S
C7_EX_NCM C 3 0 Ex-NCM @R 999 R S
C7_EX_NBM C 3 0 Ex-NBM @! R S
C7_BASESOL N 14 2 Bs. ICMS Sol @E 999,999,999.99 Positivo().And.MaFisRef("IT_BASESOL","MT120",M->C7_BASESOL) R S
C7_DIACTB C 2 0 Cod Diario @! ExistCPO("CVL") CVL S
C7_NODIA C 10 0 Seq. Diario @! S
C7_CODED C 15 0 Cod. Edital @! S
C7_PO_EIC C 15 0 Num. PO @! R S
C7_NUMPR C 15 0 Nr. Processo @! S
C7_FILCEN C 2 0 Fil.Central. S
C7_ACCPROC C 1 0 ACC? Pertence('12') R 1=Sim;2=Nao INCLUI S
C7_NUMSA C 6 0 Nr. S.A. @! R S
C7_REVISAO C 3 0 Rev.Estrutur @! A201Mov(GDFieldGet("C7_PRODUTO"),M->C7_REVISAO) R S
C7_RATEIO C 1 0 Rateio @! A120Rateio(M->C7_RATEIO) 1=Sim;2=Nao S
C7_ACCNUM C 50 0 Ped. ACC R N
C7_ACCITEM C 50 0 Item ACC R N
C7_BASECSL N 14 2 Base CSLL @E 99,999,999,999.99 MaFisRef("IT_BASECSL","MT120",M->C7_BASECSL) R S
C7_ALIQINS N 5 2 Aliq. INSS @E 99.99 MaFisRef("IT_ALIQINS","MT120",M->C7_ALIQINS) R S
C7_VALINS N 14 2 Vlr. do INSS @E 99,999,999,999.99 MaFisRef("IT_VALINS","MT120",M->C7_VALINS) R S
C7_ALQCSL N 6 2 Aliq. CSLL @E 999.99 MaFisRef("IT_ALIQCSL","MT120",M->C7_ALQCSL) R S
C7_ALIQISS N 5 2 Aliq. ISS @E 99.99 MaFisRef("IT_ALIQISS","MT120",M->C7_ALIQISS) R S
C7_VALISS N 14 2 Valor do ISS @E 99,999,999,999.99 MaFisRef("IT_VALISS","MT120",M->C7_VALISS) R S
C7_TPCOLAB C 3 0 TP Colab. @! R S
C7_IDTSS C 15 0 ID TSS @! R S
C7_GCPIT C 6 0 Item Ed @! R S
C7_GCPLT C 8 0 Lote Ed @! R S
C7_BASEINS N 14 2 Base de INSS @E 99,999,999,999.99 MaFisRef("IT_BASEINS","MT120",M->C7_BASEINS) R S
C7_VALCSL N 14 2 Valor CSLL @E 99,999,999,999.99 MaFisRef("IT_VALCSL","MT120",M->C7_VALCSL) R S
C7_LOTPLS C 10 0 Lote Pls @! R S
C7_CODRDA C 6 0 Cod.RDA.Pag. @! R S
C7_BASEISS N 14 2 Base de ISS @E 99,999,999,999.99 MaFisRef("IT_BASEISS","MT120",M->C7_BASEISS) S
C7_DIREITO M 10 0 Direito @! R S
C7_PLOPELT C 4 0 Operadora Lt @! S
C7_FISCORI C 2 0 Fil. Origem R S
C7_OBRIGA M 10 0 Obrigacao @! R S
C7_BASIMP5 N 14 2 Base Imp. 5 @E 99,999,999,999.99 MaFisRef("IT_BASECF2","MT120",M->C7_BASIMP5) S
C7_BASIMP6 N 14 2 Base Imp. 6 @E 99,999,999,999.99 MaFisRef("IT_BASEPS2","MT120",M->C7_BASIMP6) S
C7_VALIMP5 N 14 2 Valor Imp. 5 @E 99,999,999,999.99 MaFisRef("IT_VALCF2","MT120",M->C7_VALIMP5) S
C7_VALIMP6 N 14 2 Valor Imp. 6 @E 99,999,999,999.99 MaFisRef("IT_VALPS2","MT120",M->C7_VALIMP6) S
C7_TIPCLEG C 13 0 Legenda @BMPS2 V S
C7_OBSM M 50 0 Observacoes @! R S
C7_TIPCOM C 3 0 Tipo Compra @! R S
C7_FILEDT C 2 0 Fil Edital R S
C7_CODNE C 12 0 Cod Nota Emp @! CX1 R S
C7_ITEMNE C 3 0 Item Nt Emp @! R S
C7_DRPIMP C 3 0 DRP Neogrid? @! V S
C7_RETENCA N 14 2 Retencao @E 99,999,999,999.99 R S
C7_QUJEFAT N 14 2 Vlr Aten Fat @E 99,999,999,999.99 R S
C7_QUJERET N 14 2 Vlr Aten Ret @E 99,999,999,999.99 R S
C7_DEDUCAO N 14 2 Deducao @E 99,999,999,999.99 R S
C7_QUJEDED N 14 2 Vlr Aten Ded @E 99,999,999,999.99 R S
C7_FATDIRE N 14 2 Fat Direto @E 99,999,999,999.99 R S
C7_TRANSP C 6 0 Cod. Transp. @! R S
C7_FRETCON N 14 2 Vl.Fret.Con. @E 99,999,999,999.99 Positivo() R S
C7_TRANSLJ C 2 0 Loja Transp. @! R S
C7_IDTRIB C 36 0 Id. Tributos @! R S