Tabela |
SYD |
Nomenclatura Comum do Mercosul |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
YD_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
YD_TEC |
C |
10 |
0 |
TEC |
@R 9999.99.99 |
NaoVazio() .AND. Entre("01000000","99999999") |
|
|
|
|
S |
YD_EX_NCM |
C |
3 |
0 |
Ex-NCM |
@! |
|
|
|
|
|
S |
YD_EX_NBM |
C |
3 |
0 |
Ex-NBM |
@! |
ExistChav("SYD",M->YD_TEC+M->YD_EX_NCM+M->YD_EX_NBM) |
|
|
|
|
S |
YD_DESTAQU |
C |
2 |
0 |
No. Destaque |
@R 999/999/999/999/999/999/999/999/999/999 |
|
|
|
|
|
S |
YD_DESC_P |
C |
40 |
0 |
Descricao |
@! |
|
|
|
|
|
S |
YD_TEXTO |
C |
6 |
0 |
Codigo Memo |
@! |
|
|
|
|
|
S |
YD_VM_TEXT |
M |
60 |
0 |
Texto |
@! |
|
|
V |
|
|
S |
YD_UNID |
C |
2 |
0 |
Unidade |
@! |
Vazio() .OR. ExistCpo("SAH",M->YD_UNID) |
SAH |
|
|
|
S |
YD_UNIDESC |
C |
60 |
0 |
Descr.Unidad |
@! |
|
|
V |
|
|
S |
YD_NALADI |
C |
7 |
0 |
Naladi NCCA |
@R 9999.99.9 |
vazio() .or. ExistCpo("SJ2",M->YD_NALADI) |
SJ2 |
|
|
|
S |
YD_NALDESC |
C |
60 |
0 |
Descr.Naladi |
@! |
|
|
V |
|
|
S |
YD_ALADI |
C |
3 |
0 |
Aladi |
999 |
Vazio().OR.ExistCpo("SJC",M->YD_ALADI) |
SJC |
|
|
|
S |
YD_AL_DESC |
C |
60 |
0 |
Descr.Aladi |
@! |
|
|
V |
|
|
S |
YD_NAL_SH |
C |
8 |
0 |
Naladi SH |
@R 9999.99.99 |
vazio() .or. ExistCpo("SJ1",M->YD_NAL_SH) |
SJ1 |
|
|
|
S |
YD_SH_DESC |
C |
60 |
0 |
Descr.Nal.SH |
@! |
|
|
V |
|
|
S |
YD_PER_II |
N |
6 |
2 |
% II |
@E 999.99 |
POSITIVO() .And. EICA130Valid(M->YD_PER_II) |
|
|
|
|
S |
YD_PER_IPI |
N |
6 |
2 |
% IPI |
@E 999.99 |
POSITIVO() .And. EICA130Valid(M->YD_PER_IPI) |
|
|
|
|
S |
YD_ICMS_RE |
N |
6 |
2 |
% ICMS |
@E 999.99 |
POSITIVO() .And. EICA130Valid(M->YD_ICMS_RE) |
|
|
|
|
S |
YD_DL_NALA |
C |
10 |
0 |
Decret.Aladi |
@! |
|
|
|
|
|
S |
YD_DL_GATT |
C |
10 |
0 |
Decr. OMC |
@! |
|
|
|
|
|
S |
YD_TIPI |
C |
2 |
0 |
Nota Com IPI |
99 |
|
|
|
|
|
S |
YD_NUM_EX |
N |
3 |
0 |
No. Excecoes |
|
|
|
|
|
|
S |
YD_SISTAB |
C |
1 |
0 |
Usa Sistab |
@! |
|
|
|
|
|
S |
YD_SISCEXP |
C |
2 |
0 |
Destaque Exp |
@! |
|
|
|
|
|
S |
YD_CATTEX |
C |
4 |
0 |
Categ.Textil |
@! |
|
|
|
|
|
S |
YD_ANUENTE |
C |
1 |
0 |
Anuente |
@! |
Pertence("12") |
|
|
1=Sim;2=Nao |
|
S |
YD_PER_PIS |
N |
6 |
2 |
% PIS |
@E 999.99 |
POSITIVO() .And. EICA130Valid(M->YD_PER_PIS) |
|
R |
|
|
S |
YD_VLU_PIS |
N |
9 |
4 |
Vlr Unid PIS |
@E 9,999.9999 |
POSITIVO() |
|
R |
|
|
S |
YD_RED_PIS |
N |
6 |
2 |
% Red PIS |
@e 999.99 |
POSITIVO() .And. EICA130Valid(M->YD_RED_PIS) |
|
R |
|
|
S |
YD_PER_COF |
N |
6 |
2 |
% COFINS |
@E 999.99 |
POSITIVO() .And. EICA130Valid(M->YD_PER_COF) |
|
R |
|
|
S |
YD_VLU_COF |
N |
9 |
4 |
V Uni.COFINS |
@e 9,999.9999 |
POSITIVO() |
|
R |
|
|
S |
YD_RED_COF |
N |
6 |
2 |
% R. COFINS |
@E 999.99 |
POSITIVO() .And. EICA130Valid(M->YD_RED_COF) |
|
R |
|
|
S |
YD_UM |
C |
2 |
0 |
Unid Vl Unit |
@! |
VAZIO() .OR. ExistCpo("SAH") |
SAH |
|
|
|
S |
YD_MOT_II |
C |
6 |
0 |
Motivo II |
@! |
|
|
R |
|
|
S |
YD_MOT_IPI |
C |
6 |
0 |
Motivo IPI |
@! |
|
|
R |
|
|
S |
YD_MOIPIVM |
M |
10 |
0 |
Motivo IPI |
|
|
|
V |
|
|
S |
YD_MOII_VM |
M |
10 |
0 |
Motivo II |
|
|
|
V |
|
|
S |
YD_GRVUSER |
C |
30 |
0 |
Usuario Alt |
@! |
|
|
R |
|
|
S |
YD_GRVDATA |
D |
8 |
0 |
Data Alt |
@D |
|
|
R |
|
|
S |
YD_GRVHORA |
C |
8 |
0 |
Hora Alt |
@! |
|
|
R |
|
|
S |
YD_CRDPRES |
N |
5 |
2 |
%Crd. Pres. |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
YD_ICMS_PC |
N |
6 |
2 |
%IcmsPIS/COF |
@E 999.99 |
POSITIVO() .And. EICA130Valid(M->YD_ICMS_PC) |
|
R |
|
|
N |
YD_PER_AC |
C |
1 |
0 |
Permite AC |
@! |
Pertence('12') |
|
|
1=Sim;2=Nao |
|
S |
YD_MAJ_COF |
N |
6 |
2 |
% M. COFINS |
@E 999.99 |
POSITIVO() .And. EICA130Valid(M->YD_MAJ_COF) |
|
R |
|
|
S |
YD_MAJ_PIS |
N |
6 |
2 |
% M. PIS |
@E 999.99 |
Positivo() .And. EICA130Valid(M->YD_MAJ_PIS) |
|
|
|
|
S |
YD_ALIQIMP |
N |
14 |
2 |
Aliq. de Imp |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
YD_ALIQIM2 |
N |
14 |
2 |
Aliq. Import |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
YD_PER_IE |
N |
6 |
2 |
% IE |
@E 999.99 |
POSITIVO() .And. EICA130Valid(M->YD_PER_IE) |
|
R |
|
|
S |
YD_DTINTE |
D |
8 |
0 |
Dt Integ |
|
|
|
R |
|
|
S |