Tabela |
DG3 |
Produto Desenvolvido |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
DG3_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
R |
|
|
S |
DG3_CDACDV |
C |
15 |
0 |
Prod Desenv |
@! |
ExistChav("DG3",M->DG3_CDACDV) |
|
R |
|
INCLUI |
S |
DG3_DSACDV |
C |
60 |
0 |
Desc Desenv |
@! |
|
|
R |
|
|
S |
DG3_CDACDE |
C |
15 |
0 |
Prod Destino |
@! |
DPR_CDACDE( M->DG3_CDACDE, 1) |
CZ3001 |
R |
|
DPR_CDACDE( M->DG3_CDACDE, 2) |
S |
DG3_DSACDE |
C |
60 |
0 |
Desc Destino |
@! |
|
|
R |
|
!ExistCpo("CZ3", M->DG3_CDACDE) |
S |
DG3_CDUN |
C |
2 |
0 |
Unid Medida |
@! |
ExistCpo("CZ9", M->DG3_CDUN) |
CZ9001 |
R |
|
|
S |
DG3_DSUN |
C |
60 |
0 |
Desc Un Med |
@! |
|
|
V |
|
|
S |
DG3_CDGE |
C |
10 |
0 |
Gr.Estoque |
@! |
ExistCpo("CY7", M->DG3_CDGE) |
CY7001 |
R |
|
!ExistCpo("CZ3", M->DG3_CDACDE) |
S |
DG3_DSGE |
C |
60 |
0 |
Gr Est Desc |
@! |
|
|
V |
|
|
S |
DG3_CDFA |
C |
10 |
0 |
Familia |
@! |
ExistCpo("CY6", M->DG3_CDFA) |
CY6001 |
R |
|
!ExistCpo("CZ3", M->DG3_CDACDE) |
S |
DG3_DSFA |
C |
60 |
0 |
Desc Fam. |
@! |
|
|
V |
|
|
S |
DG3_CDFACM |
C |
10 |
0 |
Fam.Comercia |
@! |
|
|
R |
|
!ExistCpo("CZ3", M->DG3_CDACDE) |
S |
DG3_CDES |
C |
2 |
0 |
Filial Padra |
|
|
|
R |
|
!ExistCpo("CZ3", M->DG3_CDACDE) |
S |
DG3_CDUNNG |
C |
3 |
0 |
Unid Negocio |
@! |
|
|
R |
|
|
S |
DG3_CDACPY |
C |
15 |
0 |
Prototipo |
@! |
ExistCpo("CZ3", M->DG3_CDACPY) .And. DPR_CDACPY( M->DG3_CDACPY, M->DG3_CDACDE ) |
CZ3001 |
R |
|
|
S |
DG3_DSACPY |
C |
60 |
0 |
Desc Prototi |
@! |
|
|
V |
|
|
S |
DG3_TPST |
C |
1 |
0 |
Situacao |
9 |
|
|
R |
1=Ativo;2=Obsoleto Ordens Automaticas;3=Obsoleto Todas as Ordens;4=Total Obsoleto |
|
S |
DG3_CDGRAC |
C |
30 |
0 |
Colecao Prod |
@! |
|
|
R |
|
|
S |
DG3_TPEGDV |
C |
1 |
0 |
Estrategia |
9 |
|
|
R |
1=Ofensiva;2=Defensiva;3=Tradicional;4=Dependente |
|
S |
DG3_CDUNDE |
C |
2 |
0 |
Unid Med Des |
@! |
ExistCpo("CZ9", M->DG3_CDUNDE) |
CZ9001 |
R |
|
!ExistCpo("CZ3", M->DG3_CDACDE) |
S |
DG3_DSUNDE |
C |
60 |
0 |
Des Un Me De |
@! |
|
|
V |
|
|
S |
DG3_VLPNUN |
N |
11 |
4 |
Fator Conver |
@E 999,999.9999 |
|
|
R |
|
M->DG3_CDUN != M->DG3_CDUNDE .And. !Empty(M->DG3_CDUNDE) |
S |
DG3_VLPNRF |
N |
5 |
2 |
Fator Refugo |
@E 99.99 |
|
|
R |
|
|
S |
DG3_CDUN2 |
C |
2 |
0 |
Un Med Des 2 |
@! |
ExistCpo("CZ9", M->DG3_CDUN2) .Or. Vazio() |
CZ9001 |
R |
|
!ExistCpo("CZ3", M->DG3_CDACDE) |
S |
DG3_DSUN2 |
C |
60 |
0 |
Desc Un De 2 |
@! |
|
|
V |
|
|
S |
DG3_VLPN2 |
N |
6 |
2 |
Fator Conv 2 |
@E 999.99 |
|
|
R |
|
M->DG3_CDUNDE != M->DG3_CDUN2 .And. !Empty(M->DG3_CDUN2) |
S |
DG3_TPPNUN |
C |
1 |
0 |
Tipo Convers |
|
|
|
R |
1=Multiplicador;2=Divisor |
M->DG3_CDUNDE != M->DG3_CDUN2 .And. !Empty(M->DG3_CDUN2) |
S |
DG3_DTULEN |
D |
8 |
0 |
Data Ult Ent |
|
|
|
R |
|
|
S |
DG3_VLULEN |
N |
16 |
4 |
Preco Ult En |
@E 99,999,999,999.9999 |
|
|
R |
|
|
S |
DG3_DTULRO |
D |
8 |
0 |
Data Ult Rep |
|
|
|
R |
|
|
S |
DG3_VLPRRO |
N |
16 |
4 |
Preco Reposi |
@E 99,999,999,999.9999 |
|
|
R |
|
|
S |
DG3_CDDPPA |
C |
2 |
0 |
Deposito Pad |
@! |
ExistCpo("CZX", M->DG3_CDDPPA ) |
CZX001 |
R |
|
!ExistCpo("CZ3", M->DG3_CDACDE) |
S |
DG3_DSDPPA |
C |
60 |
0 |
Desc Deposit |
@! |
|
|
V |
|
|
S |
DG3_DSFOPJ |
M |
10 |
0 |
Formula Proj |
|
|
|
R |
|
|
S |
DG3_DSFOCS |
M |
10 |
0 |
Form. Custos |
|
|
|
R |
|
|
S |
DG3_DSFOUT |
M |
10 |
0 |
Form. Invest |
|
|
|
R |
|
|
S |
DG3_CDFATD |
C |
5 |
0 |
Fam Tecnica |
@! |
Vazio() .OR. ExistCpo('CZL',M->DG3_CDFATD) |
CZL001 |
R |
|
|
S |
DG3_DSFATD |
C |
50 |
0 |
Desc Fam Tec |
@! |
|
|
V |
|
|
S |
DG3_LGACVI |
C |
1 |
0 |
Fantasma |
9 |
Pertence("01") |
|
R |
0=Nao;1=Sim |
|
S |
DG3_IDNV |
C |
10 |
0 |
ID Narrativa |
9999999999 |
ExistCpo("DG6", M->DG3_IDNV) |
|
R |
|
|
S |