| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| BS6 | Tabelas de Materiais | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| BS6_FILIAL | C | 2 | 0 | Filial | S | ||||||
| BS6_CODINT | C | 4 | 0 | Operadora | @R !.!!! | PlsZero() .And. PLSVLDINT(M->BP8_CODINT) .And. PLS085Vld() | B89PLS | PLS085When() | S | ||
| BS6_CODTAB | C | 3 | 0 | Cod.Tab.Mat. | @! | PlsZero() .And. ExistCpo("BIS",M->BS6_CODINT+M->BS6_CODTAB,1) | BISPLS | PLS085When() | S | ||
| BS6_DESTAB | C | 40 | 0 | Desc. Tabela | @! | V | PLS085When() | S | |||
| BS6_MACODI | C | 6 | 0 | Cod.Material | @! | PLS085When() | S | ||||
| BS6_SEQMAT | C | 3 | 0 | Seq.Material | @! | S | |||||
| BS6_MADESC | C | 150 | 0 | Descr. Mat. | @! | PLS085When() | S | ||||
| BS6_MATIPO | C | 3 | 0 | Tp. Material | @! | ExistCpo("BIT",M->BS6_CODINT+M->BS6_MATIPO,1) | BITPLS | PLS085When() | S | ||
| BS6_DESTIP | C | 40 | 0 | Desc. Tipo | @! | V | S | ||||
| BS6_MAPREC | N | 13 | 2 | Preco Mat. | @E 99,999,999.99 | PLS085When() | S | ||||
| BS6_CODDOC | C | 3 | 0 | Un.Med.Valor | @! | ExistCpo("BD3",M->BS6_CODDOC,1) | B87PLS | PLS085When() | S | ||
| BS6_DESDOC | C | 30 | 0 | Desc.Un.Med. | @! | V | S | ||||
| BS6_VIGDE | D | 8 | 0 | Vigencia Ini | PLS085Vld() | PLS085When() | S | ||||
| BS6_VIGATE | D | 8 | 0 | Vigencia Fim | S | ||||||
| BS6_FLAG | C | 1 | 0 | Flag Uso | @! | S | |||||