| Tabela |
| SE1 |
Contas a Receber |
| Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
| E1_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
| E1_PREFIXO |
C |
3 |
0 |
Prefixo |
@! |
FA040Num() |
|
|
|
|
S |
| E1_NUM |
C |
9 |
0 |
No. Titulo |
@! |
FA040Num() .AND. FREEFORUSE("SE1",M->E1_NUM) |
|
R |
|
|
S |
| E1_PARCELA |
C |
2 |
0 |
Parcela |
@! |
F040VERPAR() |
|
|
|
|
S |
| E1_TIPO |
C |
3 |
0 |
Tipo |
@! |
FA040Tipo() .And. FA040Num() .And. FA040Natur() |
05 |
|
|
|
S |
| E1_NATUREZ |
C |
10 |
0 |
Natureza |
@! |
FA040Natur().and.FinVldNat( .F., M->E1_NATUREZ, 1 ) |
SED |
|
|
|
S |
| E1_PORTADO |
C |
3 |
0 |
Portador |
@! |
existcpo("SA6") |
BCO |
|
|
|
S |
| E1_AGEDEP |
C |
5 |
0 |
Depositaria |
@! |
existcpo("SA6",M->E1_PORTADO+M->E1_AGEDEP) |
|
|
|
|
S |
| E1_CLIENTE |
C |
6 |
0 |
Cliente |
@! |
existcpo("SA1",M->E1_CLIENTE,,,,.F.) .and. fa040Num() .And. FA040Natur() |
SA1 |
|
|
|
S |
| E1_LOJA |
C |
2 |
0 |
Loja |
@! |
existcpo("SA1",M->E1_CLIENTE+M->E1_LOJA) .And. Fa040Num() .And. FA040Natur() |
|
|
|
|
S |
| E1_NOMCLI |
C |
20 |
0 |
Nome Cliente |
@! |
|
|
|
|
|
S |
| E1_EMISSAO |
D |
8 |
0 |
DT Emissao |
|
iif(empty(m->e1_vencto),.T.,m->e1_emissao <= m->e1_vencto) .and. F040VLDSBPR() |
|
|
|
|
S |
| E1_VENCTO |
D |
8 |
0 |
Vencimento |
|
FA040Venc() |
|
|
|
|
S |
| E1_VENCREA |
D |
8 |
0 |
Vencto real |
|
m->e1_vencrea>=m->e1_vencto .AND. F040VCREA() |
|
|
|
|
S |
| E1_VALOR |
N |
16 |
2 |
Vlr.Titulo |
@E 9,999,999,999,999.99 |
positivo().and.naovazio().and.fa040natur().and.fa040valor() |
|
|
|
|
S |
| E1_BASEIRF |
N |
16 |
2 |
Base Imposto |
@E 9,999,999,999,999.99 |
positivo() .and. fa040natur() |
|
R |
|
If(FindFunction('F040BSIMP'),F040BSIMP(),.f.) |
S |
| E1_IRRF |
N |
14 |
2 |
IRRF |
@E 999,999,999.99 |
positivo().and.m->e1_irrfe1_valor.and.IIF(m->e1_tipo="PR".and.m->e1_irrf > 0,.F.,.T.) .and. fa040valor() |
|
|
|
M->E1_MULTNAT != "1" |
S |
| E1_ISS |
N |
14 |
2 |
ISS |
@E 999,999,999.99 |
positivo() .and. m->e1_iss < m->e1_valor .and. IIF(m->e1_tipo="PR" .and. m->e1_iss > 0,.F.,.T.) .and. fa040valor() |
|
|
|
M->E1_MULTNAT != "1" |
S |
| E1_NUMBCO |
C |
15 |
0 |
Nš no Banco |
@! |
|
|
|
|
|
S |
| E1_INDICE |
C |
3 |
0 |
Reajuste |
@! |
|
|
|
|
|
S |
| E1_BAIXA |
D |
8 |
0 |
DT Baixa |
|
|
|
|
|
|
S |
| E1_NUMBOR |
C |
6 |
0 |
Num. Bordero |
@! |
|
|
|
|
|
S |
| E1_DATABOR |
D |
8 |
0 |
DT Bordero |
|
|
|
|
|
|
S |
| E1_EMIS1 |
D |
8 |
0 |
DT Contab. |
|
|
|
|
|
|
S |
| E1_HIST |
C |
40 |
0 |
Historico |
@! |
|
|
|
|
|
S |
| E1_LA |
C |
1 |
0 |
Ident. Lanc. |
@! |
|
|
|
|
|
S |
| E1_LOTE |
C |
4 |
0 |
Lote Contabl |
@! |
|
|
|
|
|
S |
| E1_MOTIVO |
C |
20 |
0 |
Motivo |
@! |
|
|
|
|
|
S |
| E1_MOVIMEN |
D |
8 |
0 |
Ult.Moviment |
|
|
|
|
|
|
S |
| E1_OP |
C |
14 |
0 |
Ord Producao |
@9 |
vazio().or.existcpo("SC2") |
SC2 |
|
|
|
S |
| E1_SITUACA |
C |
1 |
0 |
Situacao |
|
|
FRV |
|
0=Carteira;1=Cob.Simples;2=Descontada;3=Caucionada;4=Vinculada;5=Advogado;6=Judicial |
|
S |
| E1_CONTRAT |
C |
15 |
0 |
Contrato |
@S3 |
|
|
|
|
|
S |
| E1_SALDO |
N |
16 |
2 |
Saldo |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
| E1_SUPERVI |
C |
6 |
0 |
Supervisor |
@! |
existcpo("SA3") |
SA3 |
|
|
|
S |
| E1_VEND1 |
C |
6 |
0 |
Vendedor 1 |
@! |
vazio() .or. existcpo("SA3") |
SA3 |
|
|
|
S |
| E1_VEND2 |
C |
6 |
0 |
Vendedor 2 |
@! |
vazio() .or. existcpo("SA3") |
SA3 |
|
|
|
S |
| E1_VEND3 |
C |
6 |
0 |
Vendedor 3 |
@! |
vazio() .or. existcpo("SA3") |
SA3 |
|
|
|
S |
| E1_VEND4 |
C |
6 |
0 |
Vendedor 4 |
@! |
vazio() .or. existcpo("SA3") |
SA3 |
|
|
|
S |
| E1_VEND5 |
C |
6 |
0 |
Vendedor 5 |
@! |
vazio() .or. existcpo("SA3") |
SA3 |
|
|
|
S |
| E1_COMIS1 |
N |
6 |
2 |
% Comissao 1 |
@E 999.99 |
positivo() .and. FA040Comis() |
|
|
|
|
S |
| E1_COMIS2 |
N |
6 |
2 |
% Comissao 2 |
@E 999.99 |
positivo() .and. FA040Comis() |
|
|
|
|
S |
| E1_COMIS3 |
N |
6 |
2 |
% Comissao 3 |
@E 999.99 |
positivo() .and. FA040Comis() |
|
|
|
|
S |
| E1_COMIS4 |
N |
6 |
2 |
% Comissao 4 |
@E 999.99 |
positivo() .and. FA040Comis() |
|
|
|
|
S |
| E1_DESCONT |
N |
16 |
2 |
Desconto |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
| E1_COMIS5 |
N |
6 |
2 |
% Comissao 5 |
@E 999.99 |
positivo() .and. FA040Comis() |
|
|
|
|
S |
| E1_MULTA |
N |
16 |
2 |
Multa |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
| E1_JUROS |
N |
16 |
2 |
Juros |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
| E1_CORREC |
N |
16 |
2 |
Correcao |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
| E1_VALLIQ |
N |
16 |
2 |
Vlr.Liq Baix |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
| E1_VENCORI |
D |
8 |
0 |
Vencto Orig |
|
|
|
|
|
|
S |
| E1_CONTA |
C |
10 |
0 |
Num da Conta |
@! |
existcpo("SA6",m->e1_portado+m->e1_agedep+m->e1_conta) |
|
|
|
|
S |
| E1_VALJUR |
N |
14 |
2 |
Taxa Perman. |
@E 9999,999,999.99 |
positivo() .and. m->e1_valjur < m->e1_valor |
|
|
|
|
S |
| E1_PORCJUR |
N |
5 |
2 |
Porc Juros |
@E 99.99 |
|
|
|
|
|
S |
| E1_MOEDA |
N |
2 |
0 |
Moeda |
99 |
Fa040moed().and.fa040Irf().And.FA040VALOR() |
|
|
|
|
S |
| E1_BASCOM1 |
N |
16 |
2 |
Base Comis 1 |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
| E1_BASCOM2 |
N |
16 |
2 |
Base Comis 2 |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
| E1_BASCOM3 |
N |
16 |
2 |
Base Comis 3 |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
| E1_BASCOM4 |
N |
16 |
2 |
Base Comis 4 |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
| E1_BASCOM5 |
N |
16 |
2 |
Base Comis 5 |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
| E1_FATPREF |
C |
3 |
0 |
Pref. Fatura |
@! |
|
|
|
|
|
S |
| E1_FATURA |
C |
9 |
0 |
Fatura |
@! |
|
|
|
|
|
S |
| E1_OK |
C |
2 |
0 |
Iden.Selecao |
|
|
|
|
|
|
S |
| E1_PROJETO |
C |
6 |
0 |
Projeto |
|
vazio() .or. ExistCPO("SX5","52"+M->E1_PROJETO) |
52 |
|
|
|
S |
| E1_CLASCON |
C |
5 |
0 |
Classific. |
|
vazio() .or. ExistCPO("SX5","51"+M->E1_CLASCON) |
51 |
|
|
|
S |
| E1_VALCOM1 |
N |
16 |
2 |
Vlr. comis.1 |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
| E1_VALCOM2 |
N |
16 |
2 |
Vlr. comis.2 |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
| E1_VALCOM3 |
N |
16 |
2 |
Vlr. comis.3 |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
| E1_VALCOM4 |
N |
16 |
2 |
Vlr. comis.4 |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
| E1_VALCOM5 |
N |
16 |
2 |
Vlr. comis.5 |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
| E1_OCORREN |
C |
2 |
0 |
Cod Ocorrenc |
@! |
|
|
|
|
|
S |
| E1_INSTR1 |
C |
2 |
0 |
Inst.Primar. |
@! |
|
|
|
|
|
S |
| E1_INSTR2 |
C |
2 |
0 |
Instr.Secund |
@! |
|
|
|
|
|
S |
| E1_PEDIDO |
C |
6 |
0 |
No. Pedido |
@! |
|
|
|
|
|
S |
| E1_DTVARIA |
D |
8 |
0 |
Dt UIt.Var. |
|
|
|
|
|
|
S |
| E1_VARURV |
N |
16 |
2 |
Vlr.Variacao |
@E 999,999,999.99 |
|
|
|
|
|
S |
| E1_VLCRUZ |
N |
16 |
2 |
Vlr R$ |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
| E1_DTFATUR |
D |
8 |
0 |
Data Faturam |
|
|
|
|
|
|
S |
| E1_NUMNOTA |
C |
9 |
0 |
Nota Fiscal |
@! |
|
|
|
|
|
S |
| E1_SERIE |
C |
3 |
0 |
Serie |
|
|
|
|
|
|
S |
| E1_STATUS |
C |
1 |
0 |
Status |
! |
|
|
|
|
|
S |
| E1_ORIGEM |
C |
8 |
0 |
Origem |
|
|
|
|
|
|
S |
| E1_IDENTEE |
C |
6 |
0 |
Ident CEC |
@! |
|
|
|
|
|
S |
| E1_NUMCART |
C |
19 |
0 |
Num do Carta |
@! |
|
|
|
|
|
S |
| E1_FLUXO |
C |
1 |
0 |
Fluxo Caixa |
@! |
pertence("SN") |
|
|
S=Sim;N=Nao |
|
S |
| E1_DESCFIN |
N |
5 |
2 |
Desc Financ. |
@E 99.99 |
|
|
|
|
|
S |
| E1_DIADESC |
N |
2 |
0 |
Dias p/ Desc |
99 |
|
|
|
|
|
S |
| E1_TIPODES |
C |
1 |
0 |
Tipo Descont |
|
|
|
|
1=Fixo;2=Proporcional |
|
S |
| E1_CARTAO |
C |
16 |
0 |
Nro. Cartao |
9999999999999999 |
|
|
|
|
|
S |
| E1_CARTVAL |
D |
8 |
0 |
Validade |
|
|
|
|
|
|
S |
| E1_CARTAUT |
C |
6 |
0 |
Autorizacao |
@! |
|
|
|
|
|
S |
| E1_ADM |
C |
3 |
0 |
Administ. |
|
|
|
|
|
|
S |
| E1_VLRREAL |
N |
16 |
2 |
Valor Real |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
| E1_TRANSF |
C |
15 |
0 |
Doc.Transf. |
@! |
|
|
|
|
|
S |
| E1_BCOCHQ |
C |
3 |
0 |
Bco. Cheque |
@! |
|
|
|
|
|
S |
| E1_AGECHQ |
C |
5 |
0 |
Agenc.Cheque |
@! |
|
|
|
|
|
S |
| E1_CTACHQ |
C |
10 |
0 |
Conta Cheque |
@! |
|
|
|
|
|
S |
| E1_NUMLIQ |
C |
6 |
0 |
N.Liquidacao |
@! |
|
|
|
|
|
S |
| E1_ORDPAGO |
C |
6 |
0 |
Ordem Pagto |
@! |
|
|
|
|
|
S |
| E1_RECIBO |
C |
6 |
0 |
No. Recibo |
@! |
|
|
|
|
|
S |
| E1_INSS |
N |
14 |
2 |
INSS |
@E 999,999,999.99 |
positivo() .and. m->e1_valor > m->e1_inss .and. IIF(m->e1_tipo == "PR " .and. m->e1_inss > 0 , .F. ,.T.) .and. fa040valor() |
|
|
|
M->E1_MULTNAT != "1" |
S |
| E1_FILORIG |
C |
2 |
0 |
Filial Orig |
|
VldFilOrig(M->E1_FILORIG) |
|
|
|
|
S |
| E1_DTACRED |
D |
8 |
0 |
Data p/ Comp |
|
|
|
|
|
|
S |
| E1_TIPOFAT |
C |
3 |
0 |
Tipo Fatura |
@! |
|
|
|
|
|
S |
| E1_TIPOLIQ |
C |
3 |
0 |
Tipo Liquida |
@! |
|
|
|
|
|
S |
| E1_CSLL |
N |
14 |
2 |
CSLL |
@E 999,999,999.99 |
positivo() .and. m->e1_valor > m->e1_csll .and. IIF(m->e1_tipo == "PR " .and. m->e1_csll > 0 , .F. ,.T.) .and. fa040valor() |
|
|
|
M->E1_MULTNAT != "1" |
S |
| E1_COFINS |
N |
14 |
2 |
COFINS |
@E 999,999,999.99 |
positivo() .and. m->e1_valor > m->e1_cofins .and. IIF(m->e1_tipo == "PR " .and. m->e1_cofins > 0 , .F. ,.T.) .and. fa040valor() |
|
|
|
M->E1_MULTNAT != "1" |
S |
| E1_PIS |
N |
14 |
2 |
PIS/PASEP |
@E 999,999,999.99 |
positivo() .and. m->e1_valor > m->e1_pis .and. IIF(m->e1_tipo == "PR " .and. m->e1_pis > 0 , .F. ,.T.) .and. fa040valor() |
|
|
|
M->E1_MULTNAT != "1" |
S |
| E1_FLAGFAT |
C |
1 |
0 |
Flag Fatura |
@! |
|
|
|
|
|
S |
| E1_MESBASE |
C |
2 |
0 |
Mes Base |
@! |
|
|
|
|
|
S |
| E1_ANOBASE |
C |
4 |
0 |
Ano Base |
@! |
|
|
|
|
|
S |
| E1_PLNUCOB |
C |
12 |
0 |
Num.Cobranca |
@! |
|
|
|
|
|
S |
| E1_CODINT |
C |
4 |
0 |
Instituicao |
@! |
|
|
|
|
|
S |
| E1_CODEMP |
C |
4 |
0 |
Empresa/Grup |
@! |
|
|
|
|
|
S |
| E1_MATRIC |
C |
6 |
0 |
Matricula |
@! |
|
|
|
|
|
S |
| E1_TXMOEDA |
N |
11 |
4 |
Taxa moeda |
@E 999999.9999 |
positivo() .AND. FA040VALOR() |
|
|
|
WTxMoe(M->E1_MOEDA) |
S |
| E1_ACRESC |
N |
16 |
2 |
Acrescimo |
@E 9,999,999,999,999.99 |
POSITIVO().AND. F040VLDSDAC() .AND.iiF(INCLUI,.T.,SE1->E1_SALDO>0) .AND. FINVLACDC('R') |
|
|
|
!(MVRECANT == M->E1_TIPO ) |
S |
| E1_SDACRES |
N |
16 |
2 |
Sld.Acresc. |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
| E1_DECRESC |
N |
16 |
2 |
Decrescimo |
@E 9,999,999,999,999.99 |
(M->E1_DECRESCE1_VALOR).AND.POSITIVO().AND.M->E1_ACRESC ==0.AND.iiF(INCLUI,.T.,SE1->E1_SALDO>0).OR.FINVLACDC('R') |
|
|
|
!(MVRECANT == M->E1_TIPO ) |
S |
| E1_SDDECRE |
N |
16 |
2 |
Sld.Decresc. |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
| E1_MULTNAT |
C |
1 |
0 |
Mult. Natur. |
|
pertence("12") .and. Fa040MultNat() |
|
|
1=Sim;2=Nao |
MV_MULNATR .AND. M->E1_DESDOBR == "2" |
S |
| E1_MSFIL |
C |
2 |
0 |
Filial Orig. |
|
|
|
|
|
|
S |
| E1_MSEMP |
C |
2 |
0 |
Empresa Orig |
@! |
|
|
|
|
|
S |
| E1_PROJPMS |
C |
1 |
0 |
Rateio Proj. |
|
|
|
|
1=Sim;2=Nao |
|
S |
| E1_DESDOBR |
C |
1 |
0 |
Desdobramen. |
@! |
IIF(M->E1_DESDOBR="1",F040DSDOBR(),.T.) |
|
|
1=Sim;2=Nao |
!lAltera |
S |
| E1_NRDOC |
C |
50 |
0 |
Nr.Documento |
@! |
|
|
|
|
|
S |
| E1_MODSPB |
C |
1 |
0 |
Mod. Recebto |
@! |
Pertence("123") .and. SPBTIPO("SE1") |
|
|
1=TED;2=CIP;3=COMP |
SpbInUse() |
S |
| E1_EMITCHQ |
C |
40 |
0 |
Emitente CHQ |
@! |
|
|
|
|
|
S |
| E1_IDCNAB |
C |
10 |
0 |
Id. Cnab |
@! |
|
|
|
|
|
S |
| E1_PLCOEMP |
C |
12 |
0 |
Contr Empres |
@! |
|
|
|
|
|
S |
| E1_PLTPCOE |
C |
1 |
0 |
Tp Cont Empr |
@! |
|
|
|
|
|
S |
| E1_CODCOR |
C |
6 |
0 |
Cod Corretor |
@! |
|
|
|
|
|
S |
| E1_PARCCSS |
C |
2 |
0 |
Parc.CSS |
@! |
|
|
|
|
|
S |
| E1_CODORCA |
C |
8 |
0 |
Cod. Orcam. |
|
|
|
|
|
|
S |
| E1_CODIMOV |
C |
12 |
0 |
Cod. Imovel |
|
|
N01 |
|
|
|
S |
| E1_FILDEB |
C |
2 |
0 |
Fil.Debito |
|
|
|
|
|
|
S |
| E1_NUMRA |
C |
15 |
0 |
Numero RA |
@! |
|
|
|
|
|
S |
| E1_NUMSOL |
C |
6 |
0 |
No. Solic. |
|
|
|
R |
|
|
S |
| E1_SERREC |
C |
3 |
0 |
Serie Recibo |
!!! |
|
RN |
|
|
|
S |
| E1_INSCRIC |
C |
10 |
0 |
Inscric.P.S. |
@! |
|
|
|
|
|
S |
| E1_DATAEDI |
D |
8 |
0 |
Data EDI |
|
|
|
R |
|
|
S |
| E1_CODBAR |
C |
44 |
0 |
Codig.Barras |
@! |
|
|
|
|
|
S |
| E1_CHQDEV |
C |
1 |
0 |
Chq Devolvid |
@! |
|
|
|
|
|
S |
| E1_CODDIG |
C |
48 |
0 |
Codig.Digita |
@! |
|
|
|
|
|
S |
| E1_VLBOLSA |
N |
15 |
2 |
Valor Bolsa |
@E 999,999,999,999.99 |
|
|
|
|
|
S |
| E1_LIDESCF |
D |
8 |
0 |
Lim Desc Fin |
|
M->E1_LIDESCF >= M->E1_VENCREA |
|
|
|
|
S |
| E1_NUMCRD |
C |
10 |
0 |
Contr Financ |
@! |
|
|
|
|
|
S |
| E1_VLFIES |
N |
15 |
2 |
Bolsa Fies |
@E 999,999,999,999.99 |
|
|
|
|
|
S |
| E1_DEBITO |
C |
20 |
0 |
Conta Deb. |
@! |
Vazio() .or. CTB105CTA() |
CT1 |
R |
|
|
S |
| E1_CCD |
C |
9 |
0 |
C.Custo Deb. |
@! |
Vazio() .or. CTB105CC() |
CTT |
R |
|
|
S |
| E1_ITEMD |
C |
9 |
0 |
Item Ctb.Deb |
@! |
Vazio() .or. CTB105ITEM() |
CTD |
R |
|
|
S |
| E1_CLVLDB |
C |
9 |
0 |
Cl.Vlr. Deb. |
@! |
Vazio() .or. CTB105CLVL() |
CTH |
R |
|
|
S |
| E1_CREDIT |
C |
20 |
0 |
Conta Cred. |
@! |
Vazio() .or. CTB105CTA() |
CT1 |
R |
|
|
S |
| E1_CCC |
C |
9 |
0 |
C.Custo Cred |
@! |
Vazio() .or. CTB105CC() |
CTT |
R |
|
|
S |
| E1_ITEMC |
C |
9 |
0 |
It.Ctb.Cred. |
@! |
Vazio() .or. CTB105ITEM() |
CTD |
R |
|
|
S |
| E1_CLVLCR |
C |
9 |
0 |
Cl.Vlr. Cred |
@! |
Vazio() .or. CTB105CLVL() |
CTH |
R |
|
|
S |
| E1_DESCON1 |
N |
15 |
2 |
Desconto |
@E 999,999,999,999.99 |
|
|
|
|
|
S |
| E1_DESCON2 |
N |
15 |
2 |
Desconto |
@E 999,999,999,999.99 |
|
|
|
|
|
S |
| E1_DTDESC3 |
D |
8 |
0 |
Dat.Desconto |
|
|
|
|
|
|
S |
| E1_DTDESC1 |
D |
8 |
0 |
Dat.Desconto |
|
|
|
|
|
|
S |
| E1_DTDESC2 |
D |
8 |
0 |
Dat.Desconto |
|
|
|
|
|
|
S |
| E1_VLMULTA |
N |
15 |
2 |
Valor Multa |
@E 999,999,999,999.99 |
|
|
|
|
|
S |
| E1_DESCON3 |
N |
15 |
2 |
Desconto |
@E 999,999,999,999.99 |
|
|
|
|
|
S |
| E1_MOTNEG |
C |
3 |
0 |
Motivo Negoc |
@! |
|
FU |
|
|
|
S |
| E1_SABTPIS |
N |
14 |
2 |
Saldo Ab.Pis |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
| E1_SABTCOF |
N |
14 |
2 |
Saldo Ab.COF |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
| E1_SABTCSL |
N |
14 |
2 |
Saldo Ab.CSL |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
| E1_FORNISS |
C |
6 |
0 |
Forn.ISS |
@! |
ExistCpo("SA2",M->E1_FORNISS+"00") |
SA2 |
|
|
|
S |
| E1_PARTOT |
C |
4 |
0 |
Parcela atua |
@R99/99 |
|
|
|
|
|
S |
| E1_SITFAT |
C |
1 |
0 |
Sit. Fatura |
|
|
|
|
1=Fatura nao impressa;2=Fatura impressa;3=Fatura cancelada |
|
S |
| E1_BASEPIS |
N |
14 |
2 |
Base Pis |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
| E1_BASECOF |
N |
14 |
2 |
Base Cof |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
| E1_BASECSL |
N |
14 |
2 |
Base Csll |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
| E1_VRETISS |
N |
14 |
2 |
Valor Rt.ISS |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
| E1_PARCIRF |
C |
2 |
0 |
Parcela IRRF |
@! |
|
|
R |
|
|
S |
| E1_SCORGP |
C |
1 |
0 |
PisCof OrgP. |
@! |
Pertence("12") |
|
|
1=Sim;2=Nao |
|
S |
| E1_FRETISS |
C |
1 |
0 |
Form Ret ISS |
@! |
|
|
R |
1=Cons. Vlr. Min;2=Sempre Retem |
|
S |
| E1_TXMDCOR |
N |
14 |
4 |
Tx Cor.Moeda |
@E 999,999,999.9999 |
|
|
|
|
|
S |
| E1_SATBIRF |
N |
14 |
2 |
Saldo Ab.irf |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
| E1_TIPREG |
C |
2 |
0 |
Tp. Registro |
@! |
|
|
|
|
|
S |
| E1_CONEMP |
C |
12 |
0 |
Contr. Empr. |
@! |
|
|
|
|
|
S |
| E1_VERCON |
C |
3 |
0 |
Versao Contr |
@! |
|
|
R |
|
|
S |
| E1_SUBCON |
C |
9 |
0 |
Sub-Contrato |
@! |
|
|
|
|
|
S |
| E1_VERSUB |
C |
3 |
0 |
Versao Sub |
@! |
|
|
|
|
|
S |
| E1_PLLOTE |
C |
10 |
0 |
Lote PLS |
@! |
|
|
|
|
|
S |
| E1_PLOPELT |
C |
4 |
0 |
Operadora Lt |
@! |
|
|
|
|
|
S |
| E1_CODRDA |
C |
6 |
0 |
Codigo RDA |
@! |
|
|
|
|
|
S |
| E1_FORMREC |
C |
2 |
0 |
Forma Pagto |
@! |
Vazio() .or. ExistCpo("BQL",M->BA3_TIPPAG,1) |
|
|
|
|
S |
| E1_BCOCLI |
C |
3 |
0 |
Banco Client |
@! |
|
|
|
|
|
S |
| E1_AGECLI |
C |
5 |
0 |
Agencia Cli. |
@! |
|
|
|
|
|
S |
| E1_CTACLI |
C |
10 |
0 |
Conta Cli. |
@! |
|
|
|
|
|
S |
| E1_PARCFET |
C |
2 |
0 |
Parc.FETHAB |
@! |
|
|
|
|
|
S |
| E1_FETHAB |
N |
14 |
2 |
Vlr.FETHAB |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
| E1_MDCRON |
C |
6 |
0 |
Num. Cronogr |
@! |
|
|
R |
|
|
S |
| E1_MDCONTR |
C |
15 |
0 |
Num. Contrat |
|
|
|
R |
|
|
S |
| E1_MEDNUME |
C |
6 |
0 |
Num. Medicao |
@! |
|
|
R |
|
|
S |
| E1_MDPLANI |
C |
6 |
0 |
Num. Planilh |
@! |
|
|
R |
|
|
S |
| E1_MDPARCE |
C |
2 |
0 |
Num. Parcela |
@! |
|
|
R |
|
|
S |
| E1_MDREVIS |
C |
3 |
0 |
Revisao |
@! |
|
|
R |
|
|
S |
| E1_NUMMOV |
C |
2 |
0 |
Movimento |
|
|
|
R |
|
|
S |
| E1_PREFORI |
C |
3 |
0 |
Pref Origem |
@! |
|
|
R |
|
|
S |
| E1_IDMOV |
C |
10 |
0 |
Id.Mov. |
@! |
|
|
R |
|
|
S |
| E1_NUMPRO |
C |
10 |
0 |
Proc. Refer. |
@! |
Vazio().Or.ExistCpo('CCF') |
CCF |
R |
|
|
S |
| E1_INDPRO |
C |
1 |
0 |
Tp. Processo |
@! |
Pertence(" 01239") |
|
R |
0=Sefaz;1=Justica Federal;2=Justica Estadual;3=Secex/SRF;9=Outros |
|
S |
| E1_RETCNTR |
N |
15 |
2 |
Retencao Ctr |
@E 999,999,999,999.99 |
|
|
R |
|
|
S |
| E1_MDDESC |
N |
15 |
2 |
Desconto Ctr |
@E 999,999,999,999.99 |
|
|
R |
|
|
S |
| E1_MDBONI |
N |
15 |
2 |
Bonific Ctr |
@E 999,999,999,999.99 |
|
|
R |
|
|
S |
| E1_MDMULT |
N |
15 |
2 |
Multa Ctr |
@E 999,999,999,999.99 |
|
|
R |
|
|
S |
| E1_MULTDIA |
N |
9 |
2 |
Multa ao Dia |
|
|
|
R |
|
|
S |
| E1_NODIA |
C |
10 |
0 |
Seq. Diario |
@! |
|
|
|
|
|
S |
| E1_RELATO |
C |
1 |
0 |
Env. Relato |
@! |
Pertence('12') |
|
R |
1=Sim;2=Nao |
|
S |
| E1_JURFAT |
C |
50 |
0 |
Num Fat Jur |
|
|
|
|
|
|
S |
| E1_BASEINS |
N |
16 |
2 |
Base INSS |
@E 9,999,999,999,999.99 |
positivo() .and. fa040natur() |
|
R |
|
If(FindFunction('F040BSIMP'),F040BSIMP(),.f.) |
S |
| E1_DOCTEF |
C |
20 |
0 |
Num. NSU |
@! |
|
|
R |
|
|
S |
| E1_PRINSS |
N |
14 |
2 |
Prov INSS |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
| E1_FABOV |
N |
14 |
2 |
Vlr.FABOV |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
| E1_FACS |
N |
14 |
2 |
Vlr.FACS |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
| E1_PARCFAB |
C |
2 |
0 |
Parc.FABOV |
@! |
|
|
|
|
|
S |
| E1_PARCFAC |
C |
2 |
0 |
Parc.FACS |
@! |
|
|
|
|
|
S |
| E1_PARTPDP |
C |
1 |
0 |
Par. TPDP |
@! |
|
|
|
|
|
S |
| E1_TPDESC |
C |
1 |
0 |
Desc. F100 |
@! |
Pertence("CI") |
|
|
|
|
S |
| E1_TPDP |
N |
14 |
2 |
Vlr. TPDP |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
| E1_VLMINIS |
C |
1 |
0 |
Vlr Min ISS |
@! |
Pertence(" 12") |
|
|
|
|
S |
| E1_TITPAI |
C |
50 |
0 |
Titulo Pai |
|
|
|
R |
|
|
S |
| E1_CCUSTO |
C |
9 |
0 |
C. de Custo |
@! |
Vazio() .or. CTB105CC() |
CTT |
R |
|
|
S |
| E1_DESCJUR |
N |
5 |
2 |
Desc.Juros |
@E 99.99 |
|
|
R |
|
|
S |
| E1_NFELETR |
C |
20 |
0 |
NF Eletr |
@! |
|
|
R |
|
|
S |
| E1_NUMCON |
C |
20 |
0 |
Nro.Contrato |
@! |
|
|
|
|
|
S |
| E1_SABTIRF |
N |
14 |
2 |
Sld Abt Irrf |
@E 99,999,999.99 |
|
|
|
|
|
S |
| E1_DIACTB |
C |
2 |
0 |
Cod. Diario |
@! |
VldCodSeq() |
CVL |
|
|
CtbWDia() |
S |
| E1_IDAPLIC |
N |
9 |
0 |
Matriz Aplic |
@E 999,999,999 |
|
|
R |
|
|
S |
| E1_SERVICO |
C |
10 |
0 |
Cod. Servico |
@! |
|
|
R |
|
|
S |
| E1_IDBOLET |
N |
9 |
0 |
Id.Boleto |
@E 999,999,999 |
|
|
R |
|
|
S |
| E1_PROCEL |
N |
15 |
0 |
Proc. Sel. |
@E 999,999,999,999,999 |
|
|
R |
|
|
S |
| E1_IDLAN |
N |
9 |
0 |
Nr. Lancto. |
@E 999,999,999 |
|
|
R |
|
|
S |
| E1_VLBOLP |
N |
9 |
2 |
Bolsa Pontu. |
@E 999,999.99 |
|
|
R |
|
|
S |
| E1_NUMINSC |
N |
15 |
0 |
Num. Inscr. |
@E 999,999,999,999,999 |
|
|
R |
|
|
S |
| E1_LTCXA |
C |
10 |
0 |
Lote Cxa |
@! |
|
|
R |
|
|
S |
| E1_NOPER |
N |
11 |
0 |
N. Trans |
@E 99,999,999,999 |
|
|
R |
|
|
S |
| E1_TURMA |
C |
20 |
0 |
Turma |
|
|
|
R |
|
|
S |
| E1_PRISS |
N |
14 |
2 |
Prov ISS |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
| E1_CODIRRF |
C |
4 |
0 |
Cod.Rec.IRRF |
@! |
|
|
R |
|
|
S |
| E1_NSUTEF |
C |
12 |
0 |
NSU SITEF |
@! |
|
|
R |
|
|
S |
| E1_BASEISS |
N |
16 |
2 |
Base ISS |
@E 9,999,999,999,999.99 |
positivo() .and. fa040natur() |
|
R |
|
If(FindFunction('F040BSIMP'),F040BSIMP(),.f.) |
S |
| E1_PERLET |
C |
4 |
0 |
Per. Letivo |
@! |
|
|
R |
|
|
S |
| E1_PRODUTO |
C |
15 |
0 |
Produto |
@! |
Vazio() .Or. ExistCpo('SB1') |
SB1 |
|
|
|
S |
| E1_CHAVENF |
C |
12 |
0 |
Chave NF |
@! |
|
|
R |
|
|
S |
| E1_SEQBX |
C |
2 |
0 |
Seq. Baixa |
@! |
|
|
R |
|
|
S |
| E1_VRETIRF |
N |
14 |
2 |
Vlr.Rt.Irf |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
| E1_APLVLMN |
C |
1 |
0 |
Aplica Vlr. |
@! |
pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
| E1_C_CODBA |
C |
44 |
0 |
Codigo Barra |
@! |
|
|
R |
|
|
S |
| E1_TPESOC |
C |
2 |
0 |
Tp servico |
@! |
|
DZ |
R |
|
|
S |
| E1_C_LINDI |
C |
54 |
0 |
Linha Digit |
@! |
|
|
R |
|
|
S |
| E1_CNO |
C |
6 |
0 |
Cod CNO |
@! |
Vazio() .Or. ExistCpo('SON') |
SON |
R |
|
|
S |
| E1_CODISS |
C |
6 |
0 |
Cod.Aliq.ISS |
@! |
ExistCpo( 'FIM', M->E1_CODISS ).AND.fa040natur().and.fa040valor() |
FIM |
R |
|
|
S |
| E1_CDRETCS |
C |
4 |
0 |
Cod. Ret. CS |
@! |
|
|
R |
|
|
S |
| E1_PARCFMP |
C |
1 |
0 |
Parc.FUMIPEQ |
@! |
|
|
R |
|
|
S |
| E1_FMPEQ |
N |
16 |
2 |
Vl.FUMIPEQ |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
| E1_PARCFAM |
C |
1 |
0 |
Parc.FAMAD |
@! |
|
|
R |
|
|
S |
| E1_CDRETIR |
C |
4 |
0 |
Cod. Ret. IR |
@! |
|
|
R |
|
|
S |
| E1_FAMAD |
N |
16 |
2 |
Vl.FAMAD |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
| E1_SDOCREC |
C |
3 |
0 |
Serie Recibo |
!!! |
|
|
R |
|
|
S |
| E1_SDOC |
C |
3 |
0 |
Serie Doc. |
!!! |
|
|
R |
|
|
S |
| E1_CTRBCO |
C |
50 |
0 |
Contr MCMV |
@! |
|
|
R |
|
|
S |
| E1_CODRET |
C |
4 |
0 |
Cod. Ret.PCC |
@! |
(Vazio().Or.ExistCpo('SX5','37'+M->E1_CODRET)).and.fa040natur().and.fa040valor() |
37 |
|
|
|
S |
| E1_CLVL |
C |
9 |
0 |
Classe Valor |
@! |
(Vazio().Or.Ctb105Clvl()) |
CTH |
R |
|
CtbInUse() |
S |
| E1_ITEMCTA |
C |
9 |
0 |
Item Contab. |
@! |
(Vazio().Or.Ctb105Item()) |
CTD |
R |
|
CtbInUse() |
S |
| E1_BOLETO |
C |
1 |
0 |
Gera boleto |
@! |
Vazio() .Or. Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
| E1_RATFIN |
C |
1 |
0 |
Rateio Fin |
@! |
pertence("12").And. If(M->E1_RATFIN="1",F641RatFin("FINA040"),.T.) |
|
R |
1=Sim;2=Nao |
|
S |
| E1_TCONHTL |
C |
1 |
0 |
Tipo Conta |
|
Pertence("1234") |
|
R |
1=Evento;2=Grupo;3=Individual;4=Avulsa |
|
S |
| E1_CONHTL |
C |
32 |
0 |
Conta Hotel |
@! |
|
|
R |
|
|
S |
| E1_CODSERV |
C |
9 |
0 |
Cod.Serv.ISS |
@9 |
ExistCpo("SX5","60"+AllTrim(M->E1_CODSERV)) .and. Fa040Natur() |
60 |
R |
|
|
S |
| E1_VRETBIS |
N |
14 |
2 |
Vlr. Ret ISB |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
| E1_BTRISS |
N |
14 |
2 |
ISS Bitribut |
@E 99,999,999,999.99 |
Positivo() .and. IIF(M->E1_TIPO="PR" .and. M->E1_ISSBTR > 0,.F.,.T.) |
|
R |
|
M->E1_MULTNAT != "1" |
S |
| E1_PARCIMA |
C |
2 |
0 |
Parc. IMA |
@! |
|
|
R |
|
|
S |
| E1_IMA |
N |
14 |
2 |
Valor IMA |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
