Tabela |
SF7 |
Grupo de Tributacao |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
F7_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
F7_GRTRIB |
C |
6 |
0 |
Grupo Trib. |
@! |
ExistCpo("SX5","21"+M->F7_GRTRIB) .And. x540Vld() |
21 |
|
|
|
S |
F7_SEQUEN |
C |
3 |
0 |
Sequencia |
@! |
|
|
|
|
|
S |
F7_EST |
C |
2 |
0 |
Estado |
@! |
M->F7_EST$"**" .OR. ExistCpo("SX5","12"+M->F7_EST) |
12 |
|
|
|
S |
F7_TIPOCLI |
C |
1 |
0 |
Tipo |
@! |
Pertence("FLRSX*") |
|
|
*=Todos;F=Cons.Final;L=Prod.Rural;R=Revend.;S=Solidario;X=Importacao |
|
S |
F7_ALIQINT |
N |
5 |
2 |
Aliq.Interna |
@E 99.99 |
|
|
|
|
|
S |
F7_ALIQEXT |
N |
5 |
2 |
Aliq.Externa |
@E 99.99 |
|
|
|
|
|
S |
F7_MARGEM |
N |
6 |
2 |
Margem Lucro |
@E 999.99 |
|
|
|
|
|
S |
F7_ALIQDST |
N |
5 |
2 |
Al.ICMS Dest |
@E 99.99 |
|
|
|
|
|
S |
F7_GRPCLI |
C |
3 |
0 |
Grp.Cli./For |
@! |
|
|
|
|
|
S |
F7_ISS |
C |
1 |
0 |
ISS |
@! |
Pertence("SN") |
|
|
S=Sim;N=Nao |
|
S |
F7_VLR_ICM |
N |
9 |
2 |
ICMS Pauta |
@e 999,999.99 |
Positivo() |
|
|
|
|
S |
F7_VLR_IPI |
N |
9 |
2 |
IPI Pauta |
@e 999,999.99 |
Positivo() |
|
|
|
|
S |
F7_VLR_PIS |
N |
11 |
4 |
PIS Pauta |
@E 999,999.9999 |
Positivo() |
|
|
|
|
S |
F7_VLR_COF |
N |
11 |
4 |
COFINS Pauta |
@E 999,999.9999 |
Positivo() |
|
|
|
|
S |
F7_VLRICMP |
N |
12 |
2 |
ICMSPautaPro |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
S |
F7_ALIQIPI |
N |
5 |
2 |
Aliq. IPI |
@E 99.99 |
Positivo() |
|
|
|
|
S |
F7_ALIQPIS |
N |
5 |
2 |
Aliq.PIS |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
F7_ALIQCOF |
N |
5 |
2 |
Aliq.Cof. |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
F7_BASEICM |
N |
5 |
2 |
%Red.do ICMS |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
F7_BASEIPI |
N |
5 |
2 |
%Red.do IPI |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
F7_REDPIS |
N |
5 |
2 |
Red.PIS |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
F7_REDCOF |
N |
5 |
2 |
Red.Cofins |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
F7_ICMPAUT |
C |
1 |
0 |
Pauta Prod. |
@! |
Pertence('12') |
|
R |
1=Sim;2=Nao |
|
S |
F7_IMPOSTO |
C |
1 |
0 |
Imp. Refer. |
@! |
Pertence("12") |
|
R |
|
|
S |
F7_UFBUSCA |
C |
1 |
0 |
Uf Busca |
@! |
Pertence("12") |
|
R |
1=Destino;2=Origem |
|
S |
F7_TNATREC |
C |
4 |
0 |
Tab.Nat.Rec. |
@! |
Vazio() .OR. ExistCpo('CCZ') |
CCZ |
R |
|
|
S |
F7_CNATREC |
C |
3 |
0 |
Cod.Nat.Rec. |
@! |
ExistCpo("CCZ",GDFieldGet("F7_TNATREC")+M->F7_CNATREC) |
|
R |
|
|
S |
F7_GRUPONC |
C |
2 |
0 |
Grp.Nat.Rec. |
@! |
ExistCpo("CCZ",GDFieldGet("F7_TNATREC")+GDFieldGet("F7_CNATREC")+M->F7_GRUPONC,1) |
|
R |
|
|
S |
F7_DTFIMNT |
D |
8 |
0 |
Dt.Fim N. R. |
|
|
|
R |
|
|
S |
F7_IDHIST |
C |
20 |
0 |
ID. Hist. |
@! |
|
|
R |
|
|
S |
F7_DTINCLU |
D |
8 |
0 |
Dt Inclu |
|
|
|
|
|
|
S |
F7_ORIGEM |
C |
1 |
0 |
Origem |
@! |
Vazio() .or. ExistCpo("SX5","S0"+M->F7_ORIGEM) |
S0 |
R |
|
|
S |
F7_SITTRIB |
C |
2 |
0 |
Sit. Trib. |
@! |
Vazio() .or. ExistCpo("SX5","S2"+M->F7_SITTRIB) |
S2 |
R |
|
|
S |
F7_BSICMST |
N |
6 |
2 |
%Red.ICMS ST |
@E 999.99 |
Positivo() .And. M->F7_BSICMST <= 100.00 |
|
R |
|
|
S |
F7_PRCUNIC |
N |
14 |
2 |
Vl.Uni.Cig |
@E 99,999,999,999.99 |
Positivo() |
|
R |
|
|
S |
F7_PAUTFOB |
N |
9 |
2 |
Pauta FOB |
@E 999,999.99 |
|
|
|
|
|
S |
F7_BASCMP |
N |
5 |
2 |
%Red. Difal |
@E 99.99 |
Positivo() |
|
R |
|
|
S |