Tabela |
SE5 |
Movimentacao Bancaria |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
E5_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
E5_DATA |
D |
8 |
0 |
DT Movimen |
|
fa100data() .and. fa100pre() |
|
|
|
|
S |
E5_TIPO |
C |
3 |
0 |
Tipo Titulo |
@! |
|
|
|
|
|
S |
E5_MOEDA |
C |
2 |
0 |
Numerario |
@! |
naovazio() .And. fA100Moeda() .and. fa100pre() |
06 |
|
|
|
S |
E5_VALOR |
N |
16 |
2 |
Vlr.Movim. |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
E5_NATUREZ |
C |
10 |
0 |
Natureza |
@! |
FinVldNat( .F., M->E5_NATUREZ, 3 ) |
SED |
|
|
|
S |
E5_BANCO |
C |
3 |
0 |
Banco |
@! |
ExistCpo("SA6",,,,,.F.) |
SA6 |
|
|
|
S |
E5_AGENCIA |
C |
5 |
0 |
Agencia |
@! |
|
|
|
|
|
S |
E5_CONTA |
C |
10 |
0 |
Conta Banco |
@! |
FA100CONTA() |
|
|
|
|
S |
E5_NUMCHEQ |
C |
15 |
0 |
Num Cheque |
@! |
fa100NumC() |
|
|
|
|
S |
E5_DOCUMEN |
C |
50 |
0 |
Documento |
@! |
|
|
|
|
|
S |
E5_VENCTO |
D |
8 |
0 |
Vencimento |
|
FA100VENC() .and. fa100pre() |
|
|
|
|
S |
E5_RECPAG |
C |
1 |
0 |
Rec/Pag |
@! |
|
|
|
|
|
S |
E5_BENEF |
C |
30 |
0 |
Beneficiario |
@! |
|
|
|
|
|
S |
E5_HISTOR |
C |
40 |
0 |
Historico |
@! |
|
|
|
|
|
S |
E5_TIPODOC |
C |
2 |
0 |
Tipo do Doc. |
@! |
|
|
|
|
|
S |
E5_VLMOED2 |
N |
14 |
2 |
Vlr.Moeda 2 |
@E 999,999,999,999.99 |
|
|
|
|
|
S |
E5_LA |
C |
2 |
0 |
Ident.L.A. |
@! |
|
|
|
|
|
S |
E5_SITUACA |
C |
1 |
0 |
Situacao |
|
|
|
|
|
|
S |
E5_LOTE |
C |
4 |
0 |
Lote |
@! |
|
|
|
|
|
S |
E5_PREFIXO |
C |
3 |
0 |
Prefixo |
@! |
|
|
|
|
|
S |
E5_NUMERO |
C |
9 |
0 |
Titulo |
@! |
|
|
|
|
|
S |
E5_PARCELA |
C |
2 |
0 |
Parcela |
@! |
|
|
|
|
|
S |
E5_CLIFOR |
C |
6 |
0 |
Cli/For |
@! |
fA100CliFor() |
CLIFOR |
|
|
|
S |
E5_LOJA |
C |
2 |
0 |
Loja |
@! |
|
|
|
|
|
S |
E5_DTDIGIT |
D |
8 |
0 |
Data Digit. |
|
|
|
|
|
|
S |
E5_TIPOLAN |
C |
1 |
0 |
Tipo Lanc. |
@! |
pertence("DCX") |
|
|
D=Debito;C=Credito;X=Partida Dobrada |
|
S |
E5_DEBITO |
C |
20 |
0 |
Cta Debito |
@! |
(vazio().or.CTB105CTA()) .and. fa100CtaIgual() |
CT1 |
|
|
|
S |
E5_CREDITO |
C |
20 |
0 |
Cta Credito |
@! |
(vazio().or.CTB105CTA()) .and. fa100CtaIgual() |
CT1 |
|
|
|
S |
E5_MOTBX |
C |
3 |
0 |
MOT BAIXA |
@! |
!EMPTY(M->E5_MOTBX) |
|
|
|
|
S |
E5_RATEIO |
C |
1 |
0 |
Rateio |
@! |
Fa100ValRat() |
|
|
S=Sim;N=Nao |
|
S |
E5_RECONC |
C |
1 |
0 |
Reconciliado |
|
|
|
|
|
|
S |
E5_SEQ |
C |
2 |
0 |
Sequencia |
@! |
|
|
|
|
|
S |
E5_DTDISPO |
D |
8 |
0 |
Data Dispon |
|
|
|
|
|
|
S |
E5_CCD |
C |
9 |
0 |
C.Custo Deb. |
@! |
vazio() .or. CTB105CC() |
CTT |
|
|
|
S |
E5_CCC |
C |
9 |
0 |
C.Custo Crd. |
@! |
vazio() .or. Ctb105CC() |
CTT |
|
|
|
S |
E5_OK |
C |
2 |
0 |
Iden.Selecao |
|
|
|
R |
|
|
S |
E5_ARQRAT |
C |
50 |
0 |
Arq Rateio |
|
|
|
|
|
|
S |
E5_IDENTEE |
C |
6 |
0 |
Ident Comp |
@! |
|
|
|
|
|
S |
E5_ORDREC |
C |
6 |
0 |
Rec/Ordem |
@! |
|
|
|
|
|
S |
E5_FILORIG |
C |
2 |
0 |
Filial Orig |
|
|
|
|
|
|
S |
E5_ARQCNAB |
C |
12 |
0 |
Arq CNAB |
@! |
|
|
|
|
|
S |
E5_VLJUROS |
N |
16 |
2 |
Valor juros |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
E5_VLMULTA |
N |
16 |
2 |
Valor Multa |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
E5_VLCORRE |
N |
16 |
2 |
Valor Correc |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
E5_VLDESCO |
N |
16 |
2 |
Valor Descto |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
E5_CNABOC |
C |
2 |
0 |
Ocorr CNAB |
|
|
|
|
|
|
S |
E5_SITUA |
C |
1 |
0 |
Situacao Frt |
|
|
|
|
|
|
S |
E5_ITEMD |
C |
9 |
0 |
Item Debito |
@! |
vazio() .or. CTB105ITEM() |
CTD |
|
|
|
S |
E5_ITEMC |
C |
9 |
0 |
Item Credito |
@! |
vazio() .or. CTB105ITEM() |
CTD |
|
|
|
S |
E5_CLVLDB |
C |
9 |
0 |
Cl Valor Deb |
@! |
vazio() .or. CTB105CLVL() |
CTH |
|
|
CtbInUse() |
S |
E5_CLVLCR |
C |
9 |
0 |
Cl Valor Crd |
@! |
vazio() .or. CTB105CLVL() |
CTH |
|
|
CtbInUse() |
S |
E5_PROJPMS |
C |
10 |
0 |
Projeto |
|
Vazio() .Or. ExistCpo("AF8") .And. PmsVldFase("AF8",AF8->AF8_PROJET,"87",E5_DATA) |
AF8 |
|
|
|
S |
E5_EDTPMS |
C |
12 |
0 |
EDT |
@! |
Vazio() .Or. F100VldPrj("AFC") |
AFC |
|
|
PmsSetF3("AFC",7) |
S |
E5_TASKPMS |
C |
12 |
0 |
Tarefa |
@! |
Vazio() .Or. F100VldPrj("AF9") |
AF9 |
|
|
PmsSetF3("AF9",7) |
S |
E5_MODSPB |
C |
1 |
0 |
Modalid. SPB |
@! |
Pertence("123") .and. SPBTIPO("SE5") |
|
|
1=TED;2=CIP;3=COMP |
SpbInUse() |
S |
E5_FATURA |
C |
9 |
0 |
Fatura |
@! |
|
|
|
|
|
S |
E5_TXMOEDA |
N |
11 |
4 |
Tx moeda tit |
@E 999999.9999 |
positivo() |
|
|
|
|
S |
E5_FATPREF |
C |
3 |
0 |
Pref. Fatura |
|
|
|
|
|
|
S |
E5_CODORCA |
C |
8 |
0 |
Cod. Orcam. |
|
|
N13 |
|
|
|
S |
E5_SITCOB |
C |
1 |
0 |
Sit.Cobranca |
|
|
|
|
|
|
S |
E5_FORNADT |
C |
6 |
0 |
Forn. Adto. |
@! |
|
|
|
|
|
S |
E5_LOJAADT |
C |
2 |
0 |
Loja Adto. |
@! |
|
|
|
|
|
S |
E5_CLIENTE |
C |
6 |
0 |
Cliente |
@! |
|
|
|
|
|
S |
E5_FORNECE |
C |
6 |
0 |
Fornecedor |
@! |
|
|
|
|
|
S |
E5_SERREC |
C |
3 |
0 |
Serie Recibo |
!!! |
|
RN |
|
|
|
S |
E5_OPERAD |
C |
6 |
0 |
Operador |
999999 |
|
|
R |
|
|
S |
E5_MOVCX |
C |
1 |
0 |
Mov.Caixinha |
@! |
|
|
|
|
|
S |
E5_KEY |
C |
50 |
0 |
Chave Titulo |
@! |
|
|
|
|
|
S |
E5_MULTNAT |
C |
1 |
0 |
Mult.Naturez |
|
|
|
|
|
|
S |
E5_AGLIMP |
C |
9 |
0 |
Agl.Impostos |
@! |
|
|
|
|
|
S |
E5_VLACRES |
N |
16 |
2 |
Valor Acresc |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
E5_VLDECRE |
N |
16 |
2 |
Valor Decres |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
E5_VRETPIS |
N |
14 |
2 |
Valor Rt PIS |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
E5_VRETCOF |
N |
14 |
2 |
Valor Rt COF |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
E5_VRETCSL |
N |
14 |
2 |
Valor Rt CSL |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
E5_PRETPIS |
C |
1 |
0 |
Pend.Rt.PIS |
|
|
|
|
|
|
S |
E5_PRETCOF |
C |
1 |
0 |
Pend.Rt.COF |
|
|
|
|
|
|
S |
E5_PRETCSL |
C |
1 |
0 |
Pend.Rt.CSL |
|
|
|
|
|
|
S |
E5_AUTBCO |
C |
25 |
0 |
Aut.Bancaria |
|
|
|
|
|
|
S |
E5_PRETIRF |
C |
1 |
0 |
Pend.Rt. IR |
|
|
|
|
|
|
S |
E5_VRETIRF |
N |
14 |
2 |
Valor Rt IR |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
E5_VRETISS |
N |
14 |
2 |
Valor Rt ISS |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
E5_NUMMOV |
C |
2 |
0 |
Movimento |
|
|
|
R |
|
|
S |
E5_PROCTRA |
C |
20 |
0 |
Proc. Transf |
|
|
|
R |
|
|
S |
E5_IDMOVI |
C |
10 |
0 |
Id.Movimento |
|
|
|
R |
|
|
S |
E5_BASEIRF |
N |
16 |
2 |
Base IRPF |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
E5_ORIGEM |
C |
8 |
0 |
Origem |
@! |
|
|
R |
|
|
S |
E5_DIACTB |
C |
2 |
0 |
Cod. Diario |
@! |
VldCodSeq() |
CVL |
|
|
CtbWDia() |
S |
E5_NODIA |
C |
10 |
0 |
Seq. Diario |
@! |
|
|
|
|
|
S |
E5_CCUSTO |
C |
9 |
0 |
C. de Custo |
@! |
Vazio() .or. CTB105CC() |
CTT |
R |
|
|
S |
E5_VRETINS |
N |
14 |
2 |
Vlr Ret INSS |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
E5_PRETINS |
C |
1 |
0 |
Pend.Rt.INSS |
|
|
|
|
|
|
S |
E5_FLDMED |
C |
1 |
0 |
St. DMED |
@! |
|
|
R |
|
|
S |
E5_TPDESC |
C |
1 |
0 |
Desc. F100 |
@! |
Pertence("CI") |
|
R |
C=Condicional;I=Incondicional |
|
S |
E5_PRINSS |
N |
14 |
2 |
Prov INSS |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
E5_CGC |
C |
14 |
0 |
ID contrib. |
@R 99.999.999/9999-99 |
CGC(M->E5_CGC) |
|
R |
|
|
S |
E5_FORMAPG |
C |
5 |
0 |
FORMA PAGTO |
@! |
|
|
R |
|
|
N |
E5_PRISS |
N |
14 |
2 |
Prov ISS |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
E5_SEQCON |
C |
10 |
0 |
Seq Conc |
|
|
|
R |
|
|
S |
E5_MOVFKS |
C |
1 |
0 |
Reg. Mig. |
@! |
|
|
R |
|
|
S |
E5_IDORIG |
C |
32 |
0 |
Id. Origem |
@! |
|
|
R |
|
|
S |
E5_TABORI |
C |
3 |
0 |
Tab. Orig. |
@! |
|
|
R |
|
|
S |
E5_SDOCREC |
C |
3 |
0 |
Serie Recibo |
!!! |
|
|
R |
|
|
S |
E5_DTCANBX |
D |
8 |
0 |
Dt cancel bx |
|
|
|
R |
|
|
S |