Tabela |
SDF |
Itens Sugestao de Compras |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
DF_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
DF_CODIGO |
C |
6 |
0 |
Codigo |
@! |
|
|
|
|
|
S |
DF_PRODUTO |
C |
15 |
0 |
Produto |
@! |
|
SB1 |
|
|
|
S |
DF_DESC |
C |
30 |
0 |
Descricao |
@! |
|
|
V |
|
|
S |
DF_PE |
N |
5 |
0 |
Prazo Entreg |
@E 99999 |
|
|
V |
|
|
S |
DF_QTDSUG |
N |
12 |
2 |
Qtd Sugerida |
@E 999999999.99 |
|
|
|
|
|
S |
DF_QTDINF |
N |
12 |
2 |
Qtd Infor. |
@E 999999999.99 |
|
|
|
|
|
S |
DF_VLRTOT |
N |
14 |
2 |
Valor Total |
@E 999,999,999.99 |
|
|
|
|
|
S |
DF_M12 |
N |
12 |
2 |
Media 12 Me. |
@E 999999999.99 |
|
|
|
|
|
S |
DF_QTDEST |
N |
12 |
2 |
Disponivel |
@E 999999999.99 |
|
|
|
|
|
S |
DF_QTDPC |
N |
12 |
2 |
Pendente |
@E 999999999.99 |
|
|
|
|
|
S |
DF_M03 |
N |
12 |
2 |
Media 03 Me. |
@E 999999999.99 |
|
|
|
|
|
S |
DF_QTDSUGM |
N |
12 |
2 |
Media Calc. |
@E 999999999.99 |
|
|
|
|
|
S |
DF_QE |
N |
3 |
0 |
Embalagem |
999 |
|
|
|
|
|
S |
DF_D01 |
N |
12 |
2 |
D. Mes 01 |
@E 999999999.99 |
|
|
|
|
|
S |
DF_D02 |
N |
12 |
2 |
D. Mes 02 |
@E 999999999.99 |
|
|
|
|
|
S |
DF_D03 |
N |
12 |
2 |
D. Mes 03 |
@E 999999999.99 |
|
|
|
|
|
S |
DF_D04 |
N |
12 |
2 |
D. Mes 04 |
@E 999999999.99 |
|
|
|
|
|
S |
DF_D05 |
N |
12 |
2 |
D. Mes 05 |
@E 999999999.99 |
|
|
|
|
|
S |
DF_D06 |
N |
12 |
2 |
D. Mes 06 |
@E 999999999.99 |
|
|
|
|
|
S |
DF_D07 |
N |
12 |
2 |
D. Mes 07 |
@E 999999999.99 |
|
|
|
|
|
S |
DF_D08 |
N |
12 |
2 |
D. Mes 08 |
@E 999999999.99 |
|
|
|
|
|
S |
DF_D09 |
N |
12 |
2 |
D. Mes 09 |
@E 999999999.99 |
|
|
|
|
|
S |
DF_D10 |
N |
12 |
2 |
D. Mes 10 |
@E 999999999.99 |
|
|
|
|
|
S |
DF_D11 |
N |
12 |
2 |
D. Mes 11 |
@E 999999999.99 |
|
|
|
|
|
S |
DF_D12 |
N |
12 |
2 |
D. Mes 12 |
@E 999999999.99 |
|
|
|
|
|
S |
DF_FLAG |
C |
1 |
0 |
Status da Su |
! |
|
|
|
|
|
S |
DF_CODGRP |
C |
4 |
0 |
Grupo |
@!!!! |
VldAuxCod1("DF_CODGRP","DF_CODITE") |
SBM |
V |
|
|
S |
DF_CODITE |
C |
27 |
0 |
Cod. Produto |
|
VldAuxCod2("DF_PRODUTO","DF_CODGRP") |
B00 |
V |
|
|
S |