
| 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 | |||