Tabela |
SED |
Naturezas |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
ED_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
ED_CODIGO |
C |
10 |
0 |
Codigo |
@! |
existchav("SED") .and. FreeForUse("SED",M->ED_CODIGO) |
|
|
|
|
S |
ED_DESCRIC |
C |
30 |
0 |
Descricao |
@! |
|
|
|
|
|
S |
ED_CALCIRF |
C |
1 |
0 |
Calcula IRRF |
@! |
|
|
|
S=Sim;N=Nao |
|
S |
ED_CALCISS |
C |
1 |
0 |
Calcula ISS |
@! |
pertence("SN") |
|
|
S=Sim;N=Nao |
|
S |
ED_PERCIRF |
N |
5 |
2 |
Porc IRRF |
@E 99.99 |
FA010IRF() .And. Iif(M->ED_CALCIRF='N' .AND. M->ED_PERCIRF<>0 .OR. M->ED_PERCIRF<0,.F.,.T.) |
|
|
|
|
S |
ED_CALCINS |
C |
1 |
0 |
Calcula INSS |
@! |
pertence("SN") |
|
|
S=Sim;N=Nao |
|
S |
ED_PERCINS |
N |
5 |
2 |
Porc INSS |
@E 99.99 |
Iif(M->ED_CALCINS='N' .AND. M->ED_PERCINS<>0 .OR. M->ED_PERCINS<0,.F.,.T.) |
|
|
|
|
S |
ED_CALCCSL |
C |
1 |
0 |
Calcula CSLL |
@! |
pertence("SN") .AND. Fin010Vldper() |
|
|
S=Sim;N=Nao |
|
S |
ED_CALCCOF |
C |
1 |
0 |
Calc. COFINS |
@! |
pertence("SN") .AND. Fin010Vldper() |
|
|
S=Sim;N=Nao |
|
S |
ED_CALCPIS |
C |
1 |
0 |
Calcula PIS |
@! |
pertence("SN") .AND. Fin010Vldper() |
|
|
S=Sim;N=Nao |
|
S |
ED_PERCCSL |
N |
5 |
2 |
Porc CSLL |
@E 99.99 |
Iif(M->ED_CALCCSL='N' .AND. M->ED_PERCCSL<>0 .OR. M->ED_PERCCSL<0,.F.,.T.) |
|
|
|
|
S |
ED_PERCCOF |
N |
5 |
2 |
Porc COFINS |
@E 99.99 |
Iif(M->ED_CALCCOF='N' .AND. M->ED_PERCCOF<>0 .OR. M->ED_PERCCOF<0,.F.,.T.) |
|
|
|
|
S |
ED_PERCPIS |
N |
5 |
2 |
Porc PIS |
@E 99.99 |
Iif(M->ED_CALCPIS='N' .AND. M->ED_PERCPIS<>0 .OR. M->ED_PERCPIS<0,.F.,.T.) |
|
|
|
|
S |
ED_CONTA |
C |
20 |
0 |
Cta.Contabil |
|
CTB105CTA() |
CT1 |
|
|
|
S |
ED_DEDPIS |
C |
1 |
0 |
Ded.PIS |
9 |
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
ED_DEDCOF |
C |
1 |
0 |
Ded Cofins |
9 |
Pertence("12") |
|
|
1=Sim;2=Nao |
|
S |
ED_BASEINS |
N |
5 |
2 |
Base INSS |
@E 99.99 |
|
|
|
|
|
S |
ED_CALCSES |
C |
1 |
0 |
Calc.SEST |
@! |
Pertence("SN") |
|
|
S=Sim;N=Nao |
|
S |
ED_BASESES |
N |
5 |
2 |
Base SEST |
@E 99.99 |
|
|
|
|
|
S |
ED_PERCSES |
N |
5 |
2 |
Porc.SEST |
@E 99.99 |
Iif(M->ED_CALCSES='N' .AND. M->ED_PERCSES<>0 .OR. M->ED_PERCSES<0,.F.,.T.) |
|
|
|
|
S |
ED_IRRFCAR |
C |
1 |
0 |
IRRF Carret. |
@! |
Pertence("SN") |
|
|
S=Sim;N=Nao |
M->ED_CALCIRF == "S" |
S |
ED_BASEIRC |
N |
5 |
2 |
Base IR Car. |
@E 99.99 |
|
|
|
|
M->ED_IRRFCAR == "S" |
S |
ED_INSSCAR |
C |
1 |
0 |
INSS Carret. |
@! |
Pertence("SN") |
|
|
S=Sim;N=Nao |
m->ed_calcins == 'S' |
S |
ED_DEBITO |
C |
20 |
0 |
Cta Debito |
@! |
Vazio() .or. CTB105CTA() |
CT1 |
R |
|
|
S |
ED_CCD |
C |
9 |
0 |
C Custo Deb |
@! |
Vazio() .or. CTB105CC() |
CTT |
R |
|
CtbMovSaldo("CTT") |
S |
ED_ITEMD |
C |
9 |
0 |
Item Debito |
@! |
Vazio() .or. CTB105ITEM() |
CTD |
R |
|
CtbMovSaldo("CTD") |
S |
ED_CLVLDB |
C |
9 |
0 |
Cl Vlr Deb |
@! |
Vazio() .or. CTB105CLVL() |
CTH |
R |
|
CtbMovSaldo("CTH") |
S |
ED_CREDIT |
C |
20 |
0 |
Cta Credito |
@! |
Vazio() .or. CTB105CTA() |
CT1 |
R |
|
|
S |
ED_CCC |
C |
9 |
0 |
C Custo Crd |
@! |
Vazio() .or. CTB105CC() |
CTT |
R |
|
CtbMovSaldo("CTT") |
S |
ED_ITEMC |
C |
9 |
0 |
Item Credito |
@! |
Vazio() .or. CTB105ITEM() |
CTD |
R |
|
CtbMovSaldo("CTD") |
S |
ED_CLVLCR |
C |
9 |
0 |
Cl Vlr Cred |
@! |
Vazio() .or. CTB105CLVL() |
CTH |
R |
|
CtbMovSaldo("CTH") |
S |
ED_DEDINSS |
C |
1 |
0 |
Ded. INSS |
|
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
ED_BASEIRF |
N |
5 |
2 |
Base IRRF |
@E 99.99 |
Iif(M->ED_BASEIRF<0,.F.,.T.) |
|
|
|
Iif(cPaisloc=="BRA",STRZERO(nModulo,2)$"06/02",.F.) |
S |
ED_CALCFET |
C |
1 |
0 |
Calc.FETHAB |
@! |
Pertence("12") |
|
|
1=Sim;2=Nao |
|
S |
ED_BASECOF |
N |
5 |
2 |
Base COFINS |
@E 99.99 |
Iif(M->ED_BASECOF<0,.F.,.T.) |
|
R |
|
Iif(cPaisloc="BRA",M->ED_DEDCOF=='1',.F.) |
S |
ED_BASEPIS |
N |
5 |
2 |
Base PIS |
@E 99.99 |
Iif(M->ED_BASEPIS<0,.F.,.T.) |
|
R |
|
Iif(cPaisloc=="BRA",M->ED_DEDPIS=='1',.F.) |
S |
ED_APURPIS |
C |
1 |
0 |
Apur. PIS |
@! |
Vazio() .Or. Pertence("CD") |
|
|
C=Credito;D=Debito |
|
S |
ED_APURCOF |
C |
1 |
0 |
Apur. COFINS |
@! |
Vazio() .Or. Pertence("CD") |
|
|
C=Credito;D=Debito |
|
S |
ED_PCAPPIS |
N |
5 |
2 |
% Ap. PIS |
@E 99.99 |
|
|
|
|
|
S |
ED_PCAPCOF |
N |
5 |
2 |
% Ap. COFINS |
@E 99.99 |
|
|
|
|
|
S |
ED_CALCCID |
C |
1 |
0 |
Calc Cide |
@! |
|
|
R |
S=Sim; N=Nao |
|
S |
ED_BASECID |
N |
5 |
2 |
Base Cide |
@E 99.99 |
|
|
|
|
|
S |
ED_PERCCID |
N |
5 |
2 |
Porcen Cide |
@E 99.99 |
|
|
|
|
|
S |
ED_TIPO |
C |
1 |
0 |
Tipo Naturez |
@! |
Pertence("12") |
|
R |
1=Sintetico; 2=Analitico |
F010NatWhen('2') |
S |
ED_PAI |
C |
10 |
0 |
Codigo Pai |
@! |
Vazio() .or. FA010Pai(M->ED_PAI) |
SEDS |
R |
|
F010NatWhen('2') |
S |
ED_USO |
C |
1 |
0 |
Uso Natureza |
@! |
Pertence("0123") |
|
R |
0=Livre; 1=Contas a receber; 2=Contas a pagar; 3=Mov. Bancario |
|
S |
ED_GRPNAT |
C |
3 |
0 |
Grp.Natur. |
@! |
|
|
|
1=Despesa Cliente;2=Escritorio;3=Escritorio+Centro de Custo;4=Profissional;5=Tabela Rateio;6=Rateio Juridico;7=A Classificar |
GetMv("MV_JURXFIN",,.F.) |
S |
ED_RATOBR |
C |
1 |
0 |
Rat.Juri.Obr |
@! |
|
|
|
1=Sim;2=Nao |
GetMv("MV_JURXFIN",,.F.) |
S |
ED_MSBLQL |
C |
1 |
0 |
Bloqueado |
@! |
NaoVazio() .and. Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
ED_COND |
C |
1 |
0 |
Cond Naturez |
@! |
Vazio() .Or. Pertence("RD") |
|
R |
R=Receita;D=Despesa |
|
S |
ED_REDPIS |
N |
5 |
2 |
% Red. PIS |
@E 99.99 |
|
|
R |
|
|
S |
ED_REDCOF |
N |
5 |
2 |
% Red. COF |
@E 99.99 |
|
|
R |
|
|
S |
ED_TABCCZ |
C |
4 |
0 |
Tabela |
@! |
|
CCZ |
R |
|
|
S |
ED_CODCCZ |
C |
3 |
0 |
Codigo |
@! |
|
|
R |
|
|
S |
ED_GRUCCZ |
C |
2 |
0 |
Grupo |
@! |
|
|
R |
|
|
S |
ED_DTINCLU |
D |
8 |
0 |
Data Incl. |
|
|
|
|
|
|
S |
ED_DTFCCZ |
D |
8 |
0 |
Data Final |
|
|
|
R |
|
|
S |
ED_INDRET |
C |
2 |
0 |
Ind. Ret. |
@! |
Vazio() .Or. ExistCpo('FR0','001'+M->ED_INDRET) |
FR0001 |
R |
|
|
S |
ED_CLASFIS |
C |
2 |
0 |
Oper. Finan. |
@! |
Vazio() .Or. ExistCpo('SX5','MZ'+M->ED_CLASFIS) |
MZ |
R |
|
|
S |
ED_NATMT |
C |
10 |
0 |
Nat. Multa |
@! |
Vazio() .Or. ExistCpo('SED') |
|
|
|
|
S |
ED_CDDEDA |
C |
8 |
0 |
Cod.Dd.At. |
@! |
ExistCpo("CGG", M->ED_CDDEDA, 1) |
CGG |
|
|
|
S |
ED_NATDC |
C |
10 |
0 |
Nat. Desc. |
@! |
Vazio() .Or. ExistCpo('SED') |
|
|
|
|
S |
ED_CDRECA |
C |
8 |
0 |
Cod.Rc.At. |
@! |
ExistCpo("CGE", M->ED_CDRECA, 1) |
CGE |
R |
|
|
S |
ED_CSTCOF |
C |
2 |
0 |
CST COFINS |
@! |
Vazio() .Or. ExistCpo('SX5','SX'+M->ED_CSTCOF) |
SX |
R |
|
|
S |
ED_CSTPIS |
C |
2 |
0 |
CST PIS |
@! |
Vazio() .Or. ExistCpo('SX5','SX'+M->ED_CSTPIS) |
SX |
R |
|
|
S |
ED_INDCMLT |
C |
1 |
0 |
Ind. Cmulat. |
@! |
Vazio() .Or. If(FindFunction('Fa010VldCm'),Fa010VldCm(),.F.) .Or. Pertence('12') |
|
R |
1=Cumulativa;2=Nao Cumulat. |
|
S |
ED_MOVBCO |
C |
1 |
0 |
Perm Mov Bco |
@! |
|
|
R |
1=Sim; 2=Nao |
|
S |
ED_TPAPOS |
C |
1 |
0 |
TP APOSENTAD |
|
Pertence("1234") |
|
R |
1=Normal;2=15 anos; 3=20 anos ;4=25 anos |
|
S |
ED_RECIRRF |
C |
1 |
0 |
Recolhe IRRF |
@! |
Pertence('123') |
|
R |
1=Sim;2=Nao;3=Cad.Cliente |
|
S |
ED_MSEXP |
C |
8 |
0 |
Ident.Export |
|
|
|
R |
|
|
S |
ED_TPREG |
C |
1 |
0 |
Tp Reg |
@! |
Pertence(' 12') |
|
R |
1=Nao Cumulativo;2=Cumulativo |
|
S |
ED_JURCAP |
C |
1 |
0 |
Juros Cap. |
@! |
Pertence(' 12') |
|
R |
1=Sim;2=Nao |
|
S |
ED_PERCIOF |
N |
5 |
2 |
Perc IOF |
@E 99.99 |
|
|
R |
|
|
S |
ED_ESCRIT |
C |
1 |
0 |
Escritorio |
@! |
Fin010VldEsc(M->ED_ESCRIT) |
|
R |
1=Sim;2=Nao |
GetMv("MV_JURXFIN",,.F.) |
S |
ED_GRPJUR |
C |
1 |
0 |
Grp.Juridico |
@! |
Pertence('12') |
|
R |
1=Sim;2=Nao |
GetMv("MV_JURXFIN",,.F.) .and. M->ED_ESCRIT = '1' |
S |
ED_RINSSPA |
C |
1 |
0 |
RT INSS PA |
@! |
Pertence(" 12") |
|
R |
1=Sim;2=Nao |
|
S |
ED_RECDAC |
C |
1 |
0 |
Tp Receitas |
@! |
|
|
R |
1=Mercado Interno Tributada;2=Mercado Interno Nao Tributada;3=Exportacao |
|
S |
ED_IDHIST |
C |
20 |
0 |
ID Hist. |
@! |
|
|
R |
|
|
S |
ED_CDRECSL |
C |
15 |
0 |
Cod.Rec.CSLL |
@! |
|
|
|
|
|
S |
ED_NATJR |
C |
10 |
0 |
Nat. Juros |
@! |
Vazio() .Or. ExistCpo('SED') |
|
|
|
|
S |
ED_CODRET |
C |
4 |
0 |
Cd. Retencao |
9999 |
Iif(!Empty(M->ED_CODRET),ExistCPO("SX5", "37" + M->ED_CODRET),.T.) |
37 |
R |
|
M->ED_RECIRRF $ "2|3" |
S |
ED_F100 |
C |
1 |
0 |
Gera F100 |
@! |
Pertence('12') |
|
R |
1=Sim;2=Nao |
|
S |
ED_RECFUN |
C |
1 |
0 |
Rec.Funrural |
@! |
Pertence('12') |
|
R |
1=Sim;2=Nao |
|
S |
ED_JURSPD |
C |
1 |
0 |
F100 Juros |
@! |
Pertence('12') |
|
|
1=Sim;2=Nao |
|
S |
ED_PERAPOS |
N |
5 |
2 |
% Aposent. |
@E 99.99 |
Iif(M->ED_TPAPOS $ '1 ' .AND. M->ED_PERAPOS<>0 .OR. M->ED_PERAPOS<0,.F.,.T.) |
|
R |
|
|
S |
ED_PCCINDV |
C |
1 |
0 |
PCC Indiv. |
@! |
|
|
|
1=Sim;2=Nao |
|
S |
ED_CMOEJUR |
C |
2 |
0 |
Cod Moeda |
|
Vazio().OR.JurValSED() |
JURCTO |
R |
|
GetMv("MV_JURXFIN",,.F.).And.JurWhenSED('ED_CMOEJUR') |
S |
ED_DMOEJUR |
C |
10 |
0 |
Simb Moeda |
|
|
|
V |
|
|
S |
ED_TPCOJR |
C |
1 |
0 |
Tipo Conta |
@! |
Vazio().Or.JurValSED() |
|
R |
#JurListCon() |
GetMv("MV_JURXFIN",,.F.).And.JurWhenSED('ED_TPCOJR') |
S |
ED_CFJUR |
C |
1 |
0 |
Cashflow? |
@! |
Pertence("12").And.JurValSED() |
|
R |
1=Sim;2=Nao |
GetMv("MV_JURXFIN",,.F.) |
S |
ED_CPJUR |
C |
1 |
0 |
Contas Pag? |
@! |
Pertence("12").And.JurValSED() |
|
R |
1=Sim;2=Nao |
GetMv("MV_JURXFIN",,.F.) |
S |
ED_CRJUR |
C |
1 |
0 |
Contas Rec? |
@! |
Pertence("12").And.JurValSED() |
|
R |
1=Sim;2=Nao |
GetMv("MV_JURXFIN",,.F.) |
S |
ED_BANCJUR |
C |
1 |
0 |
Banco? |
@! |
Pertence("12").And.JurValSED() |
|
R |
1=Sim;2=Nao |
GetMv("MV_JURXFIN",,.F.) .And.JurWhenSED('ED_BANCJUR') |
S |
ED_CBANCO |
C |
3 |
0 |
Cod Banco |
@! |
|
SA6JUR |
R |
|
JurWhenSED("ED_CBANCO") |
S |
ED_CAGENC |
C |
5 |
0 |
Cod Agencia |
@! |
|
|
R |
|
JurWhenSED("ED_CAGENC") |
S |
ED_CCONTA |
C |
10 |
0 |
Cod Conta |
@! |
Vazio().Or.ExistCPO( 'SA6',M->ED_CBANCO+M->ED_CAGENC+M->ED_CCONTA,1) |
|
R |
|
JurWhenSED("ED_CCONTA") |
S |
ED_DBANCO |
C |
40 |
0 |
Nome Banco |
|
|
|
V |
|
|
S |
ED_CCJURI |
C |
1 |
0 |
C. Custo Jur |
@! |
JurValSED() |
|
R |
#JurListCc() |
JurWhenSED("ED_CCJURI") |
S |
ED_RATJUR |
C |
10 |
0 |
Cod. Tab Rat |
@! |
VAZIO().OR.JURRAT() |
OH6SED |
R |
|
JurWhenSED("ED_RATJUR") |
S |
ED_PERCINP |
N |
5 |
2 |
Perc.INSS.Pt |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
ED_CALCINP |
C |
1 |
0 |
Calc.INSS.Pt |
@! |
Pertence(" 12") |
|
R |
1=Sim;2=Nao |
|
S |
ED_CALCFMP |
C |
1 |
0 |
Calc.Fumipeq |
@! |
Pertence(" 12") |
|
R |
1=Sim;2=Nao |
|
S |
ED_PERQFMP |
N |
5 |
2 |
Aliq.Fumipeq |
@E 99.99 |
|
|
|
|
|
S |
ED_ALUGUEL |
C |
1 |
0 |
Multa/Juros |
@! |
Pertence('12') |
|
R |
1=Sim;2=Nao |
|
S |
ED_LCDPR |
C |
1 |
0 |
Gera LCDPR ? |
@! |
Pertence("12 ") |
|
R |
1=Sim;2=Nao |
|
S |