Tabela
SE2 Contas a Pagar
Campo Tipo Tamanho Decimal Titulo Formato Validacao F3 Contexto Lista Condicao PYME
E2_FILIAL C 2 0 Filial S
E2_PREFIXO C 3 0 Prefixo @! FA050Num() S
E2_NUM C 9 0 No. Titulo @! FA050Num() R S
E2_PARCELA C 2 0 Parcela @! FA050Num() R S
E2_TIPO C 3 0 Tipo @! FA050Tipo() .and. FA050Num() .and. FA050Natur() 05 S
E2_NATUREZ C 10 0 Natureza @! FA050Natur().and.FinVldNat( .F., M->E2_NATUREZ, 2 ) SED S
E2_PORTADO C 3 0 Portador @! BCO S
E2_FORNECE C 6 0 Fornecedor @! ExistCpo("SA2",M->E2_FORNECE,,,,.F.).and. fa050num() .and. FreeForUse("SE2",M->E2_NUM+M->E2_FORNECE) FOR S
E2_LOJA C 2 0 Loja @! Iif(Vazio(), .T., ExistCpo("SA2",M->E2_FORNECE+M->E2_LOJA)) .and. fa050num() .and. FA050NATUR() S
E2_NOMFOR C 20 0 Nome Fornece @! S
E2_EMISSAO D 8 0 DT Emissao iif(Empty(m->e2_vencto),.T.,m->e2_emissao <= m->e2_vencto) S
E2_VENCTO D 8 0 Vencimento FA050Venc() S
E2_VENCREA D 8 0 Vencto Real m->e2_vencrea>=m->e2_vencto .AND. FA050Venc(2) S
E2_VALOR N 16 2 Vlr.Titulo @E 9,999,999,999,999.99 positivo().and.naovazio().and.FA050Nat2().and.fa050valor() S
E2_ISS N 14 2 ISS @E 999,999,999.99 positivo() .and. m->e2_iss < m->e2_valor .and. IIF(m->e2_tipo="PR" .and. m->e2_iss > 0,.F.,.T.) .and. fa050iss() M->E2_MULTNAT != "1" S
E2_IRRF N 14 2 IRRF @E 999,999,999.99 positivo() .and. m->e2_irrf < m->e2_valor .and. IIF(m->e2_tipo="PR" .and. m->e2_irrf>0,.F.,.T.) .and. fa050irr() M->E2_MULTNAT != "1" S
E2_NUMBCO C 15 0 Nš do Cheque @! S
E2_INDICE C 3 0 Reajuste @! S
E2_BAIXA D 8 0 DT Baixa S
E2_BCOPAG C 3 0 Bco de Pgto @! existcpo("SA6") BCO S
E2_EMIS1 D 8 0 DT Contab. S
E2_HIST C 40 0 Historico @! S
E2_LA C 1 0 Ident. Lanc. @! S
E2_LOTE C 4 0 Lote Contabl @! S
E2_MOTIVO C 20 0 Motivo @! S
E2_MOVIMEN D 8 0 Ult.Moviment S
E2_OP C 14 0 Ord Producao @9 vazio().or.existcpo("SC2") SC2 S
E2_SALDO N 16 2 Saldo @E 9,999,999,999,999.99 R S
E2_OK C 2 0 Ident.Baixa S
E2_DESCONT N 16 2 Desconto @E 9,999,999,999,999.99 S
E2_MULTA N 16 2 Multa @E 9,999,999,999,999.99 S
E2_JUROS N 16 2 Juros @E 9,999,999,999,999.99 S
E2_CORREC N 16 2 Correcao @E 9,999,999,999,999.99 S
E2_VALLIQ N 14 2 Val Liq Baix @E 9999,999,999.99 S
E2_VENCORI D 8 0 Vencto Orig S
E2_VALJUR N 14 2 Taxa Perman. @E 9999,999,999.99 positivo() .and. m->e2_valjur < m->e2_valor S
E2_PORCJUR N 5 2 Porc Juros @E 999.99 S
E2_MOEDA N 2 0 Moeda 99 fa050moed().and.Fa050Nat2().And.FA050VALOR() S
E2_NUMBOR C 6 0 Num Bordero @! S
E2_FATPREF C 3 0 Pref. Fatura @! S
E2_FATURA C 9 0 Num Fatura @! S
E2_PROJETO C 6 0 Projeto vazio().or.ExistCPO("SX5","52"+M->E2_PROJETO) 52 S
E2_CLASCON C 5 0 Classific. vazio().or.ExistCPO("SX5","51"+M->E2_CLASCON) 51 S
E2_RATEIO C 1 0 Rateio @! pertence("SN") .And. If(M->E2_RATEIO="S".And. GetMv("MV_MCONTAB")="CTB",(F050EscRat("511","FINA050",cLote),.T.),.T.) S=Sim;N=Nao F050RatDes(2) S
E2_DTVARIA D 8 0 Dt.Ult.Var. S
E2_VARURV N 16 2 Vl.Var.Acum. @E 9999,999,999.99 S
E2_VLCRUZ N 16 2 Vlr R$ @E 9,999,999,999,999.99 S
E2_DTFATUR D 8 0 Data Faturam S
E2_ACRESC N 16 2 Acrescimo @E 9,999,999,999,999.99 POSITIVO().AND.M->E2_DECRESC==0.AND.iiF(INCLUI,.T.,SE2->E2_SALDO>0).OR.FINVLACDC('P') !(MVPAGANT == M->E2_TIPO ) S
E2_TITORIG C 50 0 Tit. Origem @! S
E2_IMPCHEQ C 1 0 Imp.Cheque S
E2_PARCIR C 2 0 Parc. IRF @! S
E2_ARQRAT C 30 0 Arq Rateio @! S
E2_OCORREN C 2 0 Ocorr CNAB !! S
E2_ORIGEM C 8 0 Origem S
E2_IDENTEE C 6 0 Ident CEC @! S
E2_FLUXO C 1 0 Fluxo Caixa @! pertence("SN") S=Sim;N=Nao S
E2_PARCISS C 2 0 Parc ISS @! S
E2_ORDPAGO C 6 0 Ordem Pagto @! S
E2_DESDOBR C 1 0 Desdobramen. @! IIF(M->E2_DESDOBR=="S",F050dsdobr(),.T.) .And. M->E2_DESDOBR $ "SN" S=Sim;N=Nao F050RatDes(3) S
E2_INSS N 14 2 INSS @E 999,999,999.99 positivo() .and. M->E2_INSSE2_VALOR .and. iif(M->E2_INSS>0 .and. M->E2_TIPO == "PR ", .f. , .t.) .and. FA050INSS() M->E2_MULTNAT != "1" S
E2_PARCINS C 2 0 Parc. INSS @! S
E2_NUMLIQ C 6 0 No.Liquidac. @! S
E2_BCOCHQ C 3 0 Bco Cheque @! S
E2_AGECHQ C 5 0 Agencia Cheq @! S
E2_CTACHQ C 10 0 Cta Cheque @! S
E2_DATALIB D 8 0 Dt Liberacao S
E2_APROVA C 20 0 Aprovador @! S
E2_TIPOFAT C 3 0 Tipo Fatura @! S
E2_FLAGFAT C 1 0 Flag Faturas @! S
E2_ANOBASE C 4 0 Ano Base @! S
E2_MESBASE C 2 0 Mes Base @! S
E2_TXMOEDA N 11 4 Taxa moeda @E 999999.9999 positivo() WTxMoe(M->E2_MOEDA) S
E2_SDACRES N 16 2 Sld.Acresc. @E 9,999,999,999,999.99 S
E2_DECRESC N 16 2 Decrescimo @E 9,999,999,999,999.99 (M->E2_DECRESCE2_VALOR).AND.POSITIVO().AND.M->E2_ACRESC==0.AND.IIF(INCLUI,.T.,SE2->E2_SALDO>0).OR.FINVLACDC('P') !(MVPAGANT == M->E2_TIPO ) S
E2_SDDECRE N 16 2 Sld.Decresc. @E 9,999,999,999,999.99 S
E2_USUALIB C 25 0 Usuario S
E2_MULTNAT C 1 0 Mult. Natur. pertence("12") .And. Fa050MultNat() 1=Sim;2=Nao F050RatDes(1) S
E2_NUMTIT C 50 0 Tit IRRF Off @! S
E2_PROJPMS C 1 0 Rateio Proj. 1=Sim;2=Nao S
E2_PLLOTE C 10 0 Lote PLS @! S
E2_DIRF C 1 0 Gera Dirf ! pertence("12") 1=Sim;2=Nao S
E2_CODRET C 4 0 Cd. Retencao 9999 EXISTCPO("SX5","37"+M->E2_CODRET) .AND. Iif(FUNNAME() $ "FINA050|FINA750",FA050Natur(),.T.) 37 M->E2_DIRF=="1" S
E2_MODSPB C 1 0 Mod. Pagto. @! Pertence("123") .and. SPBTIPO("SE2") 1=TED;2=CIP;3=COMP SpbInUse() S
E2_IDCNAB C 10 0 Id. Cnab @! S
E2_PARCCSS C 2 0 Parc.CSS @! S
E2_RETENC N 16 2 Vl Retencao @E 9,999,999,999,999.99 Positivo() .and. M->E2_RETENC>E2_VALOR S
E2_CONTAD C 20 0 Cta.Contabil Vazio() .or. CTB105CTA() CT1 S
E2_CODORCA C 8 0 Cod. Orcam. S
E2_SEST N 14 2 SEST/SENAT @E 99,999,999,999.99 Positivo() .And. Fa050SEST() M->E2_MULTNAT != "1" S
E2_PARCSES C 2 0 Parc.SEST @! S
E2_FILDEB C 2 0 Fil.Debito S
E2_FILORIG C 2 0 Filial Orig. VldFilOrig(M->E2_FILORIG) S
E2_FORNISS C 6 0 Fornec ISS @! FOR S
E2_LOJAISS C 2 0 Lj Forn ISS @! S
E2_DEBITO C 20 0 Conta Deb. @! Vazio() .or. CTB105CTA() CT1 R S
E2_CCD C 9 0 C.Custo Deb. @! Vazio() .or. CTB105CC() CTT R S
E2_ITEMD C 9 0 Item Ctb.Deb @! Vazio() .or. CTB105ITEM() CTD R S
E2_CLVLDB C 9 0 Cl.Vlr. Deb. @! Vazio() .or. CTB105CLVL() CTH R S
E2_CREDIT C 20 0 Conta Cred. @! Vazio() .or. CTB105CTA() CT1 R S
E2_CCC C 9 0 C.Custo Cred @! Vazio() .or. CTB105CC() CTT R S
E2_ITEMC C 9 0 Item Ctb Crd @! Vazio() .or. CTB105ITEM() CTD R S
E2_CLVLCR C 9 0 Cl.Vlr. Cred @! Vazio() .or. CTB105CLVL() CTH R S
E2_COFINS N 14 2 COFINS @E 999,999,999.99 positivo() .and. m->e2_cofins < m->e2_valor .and. IIF(m->e2_tipo="PR" .and. m->e2_cofins>0,.F.,.T.) .and. fa050Cofins() S
E2_PIS N 14 2 PIS/PASEP @E 999,999,999.99 positivo() .and. m->e2_pis < m->e2_valor .and. IIF(m->e2_tipo="PR" .and. m->e2_pis>0,.F.,.T.) .and. fa050Pis() S
E2_CSLL N 14 2 CSLL @E 999,999,999.99 positivo() .and. m->e2_csll < m->e2_valor .and. IIF(m->e2_tipo="PR" .and. m->e2_csll>0,.F.,.T.) .and. fa050Csll() S
E2_PARCCOF C 2 0 Parc. COFINS @! S
E2_PARCPIS C 2 0 Parc. PIS @! S
E2_PARCSLL C 2 0 Parc. CSLL @! S
E2_TITPIS C 50 0 Titulo PIS S
E2_TITCOF C 50 0 Tit COFINS S
E2_TITCSL C 50 0 Titulo CSLL S
E2_TITINS C 50 0 Titulo INSS S
E2_VRETPIS N 14 2 Valor Rt.Pis @E 99,999,999,999.99 S
E2_VRETCOF N 14 2 Valor Rt.Cof @E 99,999,999,999.99 S
E2_VRETCSL N 14 2 Valor Rt CSL @E 99,999,999,999.99 S
E2_PRETPIS C 1 0 Pend.Rt.PIS S
E2_PRETCOF C 1 0 Pend.Rt.COF S
E2_PRETCSL C 1 0 Pend.Rt.CSLL S
E2_SEQBX C 2 0 Seq.Baixa @! S
E2_CODBAR C 44 0 Cod.Barras Vazio() .OR. VldCodBar(M->E2_CODBAR) R S
E2_LINDIG C 48 0 Linha Dig. Vazio() .OR. VldCodBar(M->E2_LINDIG) S
E2_BASEPIS N 16 2 Base PCC @E 9,999,999,999,999.99 positivo() .and. fa050nat2() R If(FindFunction('F050BSIMP'),F050BSIMP(1,2),.f.) S
E2_BASECSL N 16 2 Base Csll @E 9,999,999,999,999.99 positivo() .and. fa050nat2() R If(FindFunction('F050BSIMP'),F050BSIMP(1,4),.f.) S
E2_VRETISS N 14 2 Valor Rt.ISS @E 99,999,999,999.99 S
E2_VENCISS D 8 0 Venc.ISS R S
E2_VBASISS N 15 2 Vlr.Ac.Serv. @E 99,999,999,999.99 R S
E2_MDRTISS C 1 0 Mod.Ret.ISS @! Pertence("12") R 1=Normal;2=Por Base S
E2_VARIAC N 2 0 Variac. DCTF @E 99 R S
E2_PERIOD C 1 0 Period. DCTF @! Pertence("DSXQMBTUEA") S
E2_MDCONTR C 15 0 Num.Contrato @! R S
E2_MDREVIS C 3 0 Revisao cont @! R S
E2_MDPLANI C 6 0 Num. Planilh @! R S
E2_MDCRON C 6 0 Num. Cronogr @! R S
E2_MDPARCE C 2 0 Num. Parcela @! R S
E2_FRETISS C 1 0 Form Ret ISS @! PERTENCE("12") .and. FA050NAT2() R 1=Cons.Vlr.Min.;2=Sempre retem S
E2_TXMDCOR N 14 4 Tx Cor.Moeda @E 999,999,999.9999 S
E2_APLVLMN C 1 0 Aplic.Vl.Min @! pertence("12") 1=Sim;2=Nao S
E2_CLEARIN C 3 0 Cod.Clearing @! S
E2_HORASPB C 5 0 Hora SPB "99:99" S
E2_PRETIRF C 1 0 Pend.Ret IRF S
E2_SEFIP C 1 0 SEFIP S
E2_TRETISS C 1 0 Retencao ISS S
E2_VRETIRF N 14 2 Valor Rt. IR @E 99,999,999,999.99 S
E2_PLOPELT C 4 0 Operadora Lt @! R S
E2_CODRDA C 6 0 Cod. Rda @! S
E2_PARCFET C 2 0 Parc.FETHAB @! S
E2_FETHAB N 14 2 Vlr.FETHAB @E 99,999,999,999.99 S
E2_FORORI C 6 0 Forn.Orig. @! R S
E2_LOJORI C 2 0 Loja Orig @! R S
E2_STATUS C 1 0 Status S
E2_DTDIRF D 8 0 Dt Ger. Dirf S
E2_TITADT C 50 0 Titulo Adt R S
E2_TITPAI C 50 0 Titulo Pai R S
E2_INSSRET N 6 2 INSS Retido @E 999.99 Positivo() R S
E2_CODAGL C 6 0 Cod. Aglut. @! R S
E2_PROCPCC C 9 0 Processo PCC @! R S
E2_FORNPAI C 50 0 Forn.Pai PCC R S
E2_CODISS C 6 0 Cod.Aliq.ISS @9 ExistCpo( 'FIM', M->E2_CODISS ).AND.FA050Nat2().and.fa050valor() FIM R S
E2_USUASUS C 25 0 Usuario @! R S
E2_USUACAN C 25 0 Usuario @! R S
E2_DATASUS D 8 0 Dt Suspensao R S
E2_DATACAN D 8 0 Dt Cancel. R S
E2_LIMCAN D 8 0 Dt.Lim.Canc R S
E2_PREOP C 6 0 Pre-ordem @! R S
E2_BASEISS N 16 2 Base ISS @E 9,999,999,999,999.99 positivo() .and. fa050nat2() R If(FindFunction('F050BSIMP'),F050BSIMP(1,6),.f.) S
E2_FORBCO C 3 0 Banco For. @! FIL R S
E2_FORAGE C 5 0 Agencia For. @! R S
E2_FAGEDV C 1 0 DV Agencia @! R S
E2_FORCTA C 10 0 Conta For. @! R S
E2_FCTADV C 2 0 DV Conta @! R S
E2_NUMPRO C 10 0 Proc. Refer. @! Vazio().Or.ExistCpo('CCF') CCF R S
E2_INDPRO C 1 0 Tp. Processo @! Pertence("01239") R 0=Sefaz;1=Justica Federal;2=Justica Estadual;3=Secex/SRF;9=Outros S
E2_DATAAGE D 8 0 Data Agend. R S
E2_FATFOR C 6 0 Forn. Fatura @! R S
E2_FATLOJ C 2 0 Loja For Fat @! R S
E2_PARCAGL C 2 0 Parc.Aglut. @! S
E2_RETCNTR N 15 2 Retencao Ctr @E 999,999,999.99 R S
E2_MDDESC N 15 2 Desconto Ctr @E 999,999,999.99 R S
E2_MDBONI N 15 2 Bonific Ctr @E 999,999,999.99 R S
E2_MDMULT N 15 2 Multa Ctr @E 999,999,999.99 R S
E2_VRETINS N 14 2 Vlr Ret INSS @E 99,999,999,999.99 S
E2_PRETINS C 1 0 Pend.Rt.INSS S
E2_DIACTB C 2 0 Cod. Diario @! VldCodSeq() CVL CtbWDia() S
E2_NODIA C 10 0 Seq. Diario @! S
E2_CIDE N 14 2 Cide @E 999,999,999.99 Positivo() .And. FA050Cide() M->E2_MULTNAT != '1' S
E2_BASEIRF N 16 2 Base IRRF @E 9,999,999,999,999.99 positivo() .and. fa050nat2() R If(FindFunction('F050BSIMP'),F050BSIMP(1,1),.f.) S
E2_TEMDOCS C 1 0 Possui Docs @! Pertence("1|2|") R 1=Sim;2=Nao S
E2_CODAPRO C 6 0 Cod. Aprov. @! Vazio() .Or. IIF(FindFunction("FA050VldAp"),FA050VldAp(M->E2_CODAPRO,M->E2_MOEDA),.T.) FRP S
E2_STATLIB C 2 0 Status @! S
E2_IDMOV C 10 0 Id. Mov. @! R S
E2_PRINSS N 14 2 Prov INSS @E 99,999,999,999.99 R S
E2_TPESOC C 1 0 Tp de serv DZ R S
E2_CCUSTO C 9 0 C. de Custo @! Vazio() .or. CTB105CC() CTT R S
E2_FIMP C 1 0 Flag Imp NFe @! R S
E2_NFELETR C 20 0 NF Eletr. @! R S
E2_BASECOF N 16 2 Base Cof @E 9,999,999,999,999.99 positivo() .and. fa050nat2() R If(FindFunction('F050BSIMP'),F050BSIMP(1,3),.f.) S
E2_BASEINS N 16 2 Base INSS @E 9,999,999,999,999.99 positivo() .and. fa050nat2() R If(FindFunction('F050BSIMP'),F050BSIMP(1,5),.f.) S
E2_CODINS C 4 0 Cod Ret INSS 38 S
E2_PARCCID C 2 0 Parc. CIDE @! S
E2_PARIMP1 C 2 0 Parc.Imp.01 @! R S
E2_PARIMP2 C 2 0 Parc.Imp.02 @! R N
E2_PARIMP3 C 2 0 Parc.Imp.03 @! R N
E2_PARIMP4 C 2 0 Parc.Imp.05 @! R N
E2_PARIMP5 C 2 0 Parc.Imp.05 @! R N
E2_CODRCOF C 4 0 Cod.Ret Cof 37 S
E2_CODRCSL C 4 0 Cod.Ret CSL 37 S
E2_TIPOLIQ C 3 0 Tipo Liquida @! S
E2_CODRPIS C 4 0 Cod.Ret.PIS 37 S
E2_PRISS N 14 2 Prov ISS @E 99,999,999,999.99 R S
E2_IDDARF C 20 0 ID DARF @! S
E2_CODOPE C 2 0 Cod. Operad. @! Vazio().OR.TmsValField('M->E2_CODOPE',.T.,'E2_NOMOPE') DEG R S
E2_NOMOPE C 30 0 Nome Operad. @! V S
E2_MSIDENT C 10 0 Ident.Reg. R S
E2_AGLIMP C 9 0 Agl.Impostos @! S
E2_NUMSOL C 6 0 No. Solic. @! R S
E2_CNO C 6 0 Cod CNO Vazio() .Or. ExistCpo('SON') SON R S
E2_DTBORDE D 8 0 Dt. Bordero R S
E2_FABOV N 14 2 Vlr.FABOV @E 99,999,999,999.99 S
E2_FACS N 14 2 Vlr.FACS @E 99,999,999,999.99 S
E2_PARCFAB C 2 0 Parc.FABOV @! S
E2_PARCFAC C 2 0 Parc.FACS @! S
E2_DOCHAB C 6 0 DH @! R S
E2_FORMPAG C 2 0 Forma Pgto. @! If( !Empty(M->E2_FORMPAG) ,ExistCpo("SX5", "58" + M->E2_FORMPAG), .T. ) 58 R S
E2_ITEMCTA C 9 0 Item Contab. @! (Vazio() .OR. Ctb105Item()) CTD R CtbInUse() S
E2_FMPEQ N 16 2 Vl.FUMIPEQ @E 9,999,999,999,999.99 R S
E2_PARCFMP C 2 0 Parc.FUMIPEQ @! R S
E2_CLVL C 9 0 Classe Valor @! (Vazio() .OR. Ctb105Clvl()) CTH R CtbInUse() S
E2_PARCFAM C 2 0 Parc.FAMAD @! R S
E2_FAMAD N 16 2 Vl.FAMAD @E 9,999,999,999,999.99 R S
E2_RETINS C 4 0 Ret. INSS @! If ( Empty(M->E2_RETINS),.T.,ExistCPO("SX5","QM"+M->E2_RETINS)) QM S
E2_CNPJRET C 14 0 CNPJ Ret. @! S
E2_TPDESC C 1 0 Desc. F100 @! Pertence("CI") S
E2_DTAPUR D 8 0 Dt. Apuracao R M->E2_DIRF == "1" S
E2_NROREF C 15 0 Referencia @! R M->E2_DIRF == "1" S
E2_NOMERET C 60 0 Contribuinte @! R S
E2_TPINSC C 1 0 Tp.Inscricao @! R S
E2_MEDNUME C 6 0 Num. Medicao @! R S
E2_BTRISS N 14 2 ISS Bitribut @E 99,999,999,999.99 Positivo() .and. IIF(M->E2_TIPO="PR" .and. M->E2_ISSBTR > 0,.F.,.T.) R M->E2_MULTNAT != "1" S
E2_CODSERV C 9 0 Cod.Serv.ISS @9 ExistCpo("SX5","60"+AllTrim(M->E2_CODSERV)) .and. Fa050Nat2() 60 R S
E2_VRETBIS N 14 2 Vlr. Ret ISB @E 99,999,999,999.99 R S
E2_PARCIMA C 2 0 Parc. IMA @! R S
E2_IMA N 14 2 Valor IMA @E 99,999,999,999.99 R S