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