| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| SS7 | NATUREZA FINANCEIRA | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| S7_FILIAL | C | 2 | 0 | Filial | R | S | |||||
| S7_CODIGO | C | 10 | 0 | Codigo | @! | existchav("SED") .and. FreeForUse("SED",M->S7_CODIGO) | R | S | |||
| S7_DESCRIC | C | 30 | 0 | Descricao | @! | R | S | ||||
| S7_CALCIRF | C | 1 | 0 | Calcula IRRF | @! | FA010Callr() | R | S=Sim;N=Nao | S | ||
| S7_CALCISS | C | 1 | 0 | Calcula ISS | @! | pertence("SN") | R | S=Sim;N=Nao | S | ||
| S7_PERCIRF | N | 5 | 2 | Porc IRRF | @E 99.99 | FA010IRF() | R | S | |||
| S7_CALCINS | C | 1 | 0 | Calcula INSS | @! | pertence("SN") | R | S=Sim;N=Nao | S | ||
| S7_PERCINS | N | 5 | 2 | Porc INSS | @E 99.99 | R | S | ||||
| S7_CALCCSL | C | 1 | 0 | Calcula CSLL | @! | pertence("SN") | R | S=Sim;N=Nao | S | ||
| S7_CALCCOF | C | 1 | 0 | Calc. COFINS | @! | pertence("SN") | R | S=Sim;N=Nao | S | ||
| S7_CALCPIS | C | 1 | 0 | Calcula PIS | @! | pertence("SN") | R | S=Sim;N=Nao | S | ||
| S7_PERCCSL | N | 5 | 2 | Porc CSLL | @E 99.99 | R | S | ||||
| S7_PERCCOF | N | 5 | 2 | Porc COFINS | @E 99.99 | R | S | ||||
| S7_PERCPIS | N | 5 | 2 | Porc PIS | @E 99.99 | R | S | ||||
| S7_CONTA | C | 20 | 0 | Cta.Contabil | CTB105CTA() | CT1 | R | S | |||
| S7_DEDPIS | C | 1 | 0 | Ded.PIS | 9 | pertence("12") | R | 1=Sim;2=Nao | S | ||
| S7_DEDCOF | C | 1 | 0 | Ded Cofins | 9 | pertence("12") .And. FA010Vld() | R | 1=Sim;2=Nao | S | ||
| S7_BASEINS | N | 5 | 2 | Base INSS | @E 99.99 | R | S | ||||
| S7_CALCSES | C | 1 | 0 | Calc.SEST | @! | pertence("SN") | R | S=Sim;N=Nao | S | ||
| S7_BASESES | N | 5 | 2 | Base SEST | @E 99.99 | R | S | ||||
| S7_PERCSES | N | 5 | 2 | Port.SEST | @E 99.99 | R | S | ||||
| S7_IRRFCAR | C | 1 | 0 | IRRF Carret. | @! | pertence("SN") | R | S=Sim;N=Nao | M->S7_CALCIRF=="S" | S | |
| S7_BASEIRC | N | 5 | 2 | Base IR Car. | @E 99.99 | R | S=Sim;N=Nao | M->S7_IRRFCAR=="S" | S | ||
| S7_INSSCAR | C | 1 | 0 | INSS Carret. | @! | Pertence("SN") | R | S=Sim;N=Nao | m->S7_calcins=='S' | S | |
| S7_DEBITO | C | 20 | 0 | Cta Debito | @! | Vazio() .or. CTB105CTA() | CT1 | R | S | ||
| S7_CCD | C | 9 | 0 | C Custo Deb | @! | Vazio() .or. CTB105CC() | CTT | R | CtbMovSaldo("CTT") | S | |
| S7_ITEMD | C | 9 | 0 | Item Debito | @! | Vazio() .or. CTB105ITEM() | CTD | R | CtbMovSaldo("CTD") | S | |
| S7_CLVLDB | C | 9 | 0 | Cl Vlr Deb | @! | Vazio() .or. CTB105CLVL() | CTH | R | CtbMovSaldo("CTH") | S | |
| S7_CREDIT | C | 20 | 0 | Cta Credito | @! | Vazio() .or. CTB105CTA() | CT1 | R | S | ||
| S7_CCC | C | 9 | 0 | C Custo Crd | @! | Vazio() .or. CTB105CC() | CTT | R | CtbMovSaldo("CTT") | S | |
| S7_ITEMC | C | 9 | 0 | Item Credito | @! | Vazio() .or. CTB105ITEM() | CTD | R | CtbMovSaldo("CTD") | S | |
| S7_CLVLCR | C | 9 | 0 | Cl Vlr Cred | @! | Vazio() .or. CTB105CLVL() | CTH | R | CtbMovSaldo("CTH") | S | |
| S7_DEDINSS | C | 1 | 0 | Ded. INSS | Pertence("12") | R | 1=Sim;2=Nao | S | |||
| S7_BASEIRF | N | 5 | 2 | Base IRRF | @E 99.99 | R | 1=Sim;2=Nao | S | |||
| S7_CALCFET | C | 1 | 0 | Calc.FETHAB | @! | Pertence("12") | R | 1=Sim;2=Nao | S | ||
| S7_BASECOF | N | 5 | 2 | Base COFINS | @E 99.99 | R | Iif(cPaisloc="BRA",M->S7_DEDCOF=='1',.F.) | S | |||
| S7_BASEPIS | N | 5 | 2 | Base PIS | @E 99.99 | R | Iif(cPaisloc=="BRA",M->S7_DEDPIS=='1',.F.) | S | |||
| S7_APURPIS | C | 1 | 0 | Apur. PIS | @! | Pertence("CD") | R | C=Credito;D=Debito | S | ||
| S7_APURCOF | C | 1 | 0 | Apur.COFINS | @! | Pertence("CD") | R | C=Credito;D=Debito | S | ||
| S7_PCAPPIS | N | 5 | 2 | % Ap. PIS | @E 99.99 | R | S | ||||
| S7_PCAPCOF | N | 5 | 2 | % Ap.COFINS | @E 99.99 | R | S | ||||
| S7_CALCCID | C | 1 | 0 | Calc Cide | @! | R | S | ||||
| S7_BASECID | N | 5 | 2 | Base Cide | @E 99.99 | R | S | ||||
| S7_PERCCID | N | 5 | 2 | Porcen Cide | @E 99.99 | R | S | ||||
| S7_TIPO | C | 1 | 0 | Tipo Naturez | @! | Pertence("12") | R | 1=Sintetico;2=Analitico | S | ||
| S7_PAI | C | 10 | 0 | Codigo Pai | @! | Vazio() .or. FA010Pai(M->S7_PAI) | R | If(FindFunction('A010NatWhen'),A010NatWhen(),.F.) | S | ||
| S7_USO | C | 1 | 0 | Uso Natureza | @! | Pertence("0123") | R | 0=Livre; 1=Contas a receber; 2=Contas a pagar; 3=Mov. Bancario | S | ||
| S7_GRPNAT | C | 3 | 0 | Grp.Natur. | @! | R | 1=Despesa;2=Escritorio;3=Escritorio+Centro de Custo;4=Profissional;5=Tabela Rateio;6=Rateio Juridico;7=A Classificar | GetMv("MV_JURXFIN",,.F.) | S | ||
| S7_RATOBR | C | 1 | 0 | Rat.Juri.Obr | @! | R | 1=Sim;2=Nao | GetMv("MV_JURXFIN",,.F.) | S | ||
| S7_MSBLQL | C | 1 | 0 | Bloqueado | @! | NaoVazio() .and. Pertence("12") | R | 1=Sim;2=Nao | S | ||
| S7_COND | C | 1 | 0 | Cond Naturez | @! | Vazio() .Or. Pertence("RD") | R | R=Receita;D=Despesa | S | ||
| S7_REDPIS | N | 5 | 2 | % Red. PIS | @E 99.99 | R | S | ||||
| S7_REDCOF | N | 5 | 2 | % Red. COF | @E 99.99 | R | S | ||||
| S7_CSTPIS | C | 2 | 0 | CST PIS | @! | Vazio() .Or. ExistCpo('SX5','SX'+M->S7_CSTPIS) | SX | R | S | ||
| S7_CLASFIS | C | 2 | 0 | Oper.Finan. | @! | Vazio() .Or. ExistCpo('SX5','MZ'+M->S7_CLASFIS) | MZ | R | S | ||
| S7_INDCMLT | C | 1 | 0 | Ind.Cmulat. | @! | Vazio() .Or. If(FindFunction('Fa010VldCm'),Fa010VldCm(),.F.) .Or. Pertence('12') | R | 1=Cumulativa;2=Nao Cumulat. | S | ||
| S7_INDRET | C | 2 | 0 | Ind. Ret. | @! | Vazio() .Or. ExistCpo('FRO','001'+M->S7_INDRET) | FR0001 | R | S | ||
| S7_CSTCOF | C | 2 | 0 | CST COFINS | @! | Vazio() .Or. ExistCpo('SX5','SX'+M->S7_CSTCOF) | SX | R | S | ||
| S7_DTINCLU | D | 8 | 0 | Data Incl. | R | S | |||||
| S7_MOVBCO | C | 1 | 0 | Perm Mov Bco | @! | R | 1=Sim;2=Nao | S | |||
| S7_JURCAP | C | 1 | 0 | Juros Cap. | @! | Pertence('12') | R | 1=Sim;2=Nao | S | ||
| S7_PERCIOF | N | 5 | 2 | Perc IOF | @E 99.99 | R | S | ||||
| S7_IDHIST | C | 20 | 0 | ID Hist. | @! | R | S | ||||
| S7_TPREG | C | 1 | 0 | Tp Reg | @! | Pertence("12") | R | 1=Nao Cumulativo;2=Cumulativo | S | ||
| S7_PERCINP | N | 5 | 2 | Perc.INSS.Pt | @E 99.99 | Positivo() | R | S | |||
| S7_CALCINP | C | 1 | 0 | Calc.INSS.Pt | @! | Pertence(" 12") | R | S | |||