Tabela |
DW7 |
Proposta Comercial |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
DW7_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
R |
|
|
N |
DW7_FILORI |
C |
2 |
0 |
Fil.Origem |
|
TMSValidEmp(cEmpAnt+M->DW7_FILORI) |
DLB |
R |
|
TMSW10WHN('DW7_FILORI') |
N |
DW7_NUMPRO |
C |
6 |
0 |
Num.Proposta |
@! |
ExistChav('DW7',M->DW7_NUMPRO) |
|
R |
|
|
N |
DW7_DATA |
D |
8 |
0 |
Dt. Proposta |
@! |
TMSW10VLD() |
|
R |
|
|
N |
DW7_PRZVLD |
D |
8 |
0 |
Prazo Valid. |
@! |
|
|
R |
|
|
N |
DW7_TIPPRO |
C |
1 |
0 |
Tipo Propost |
@! |
Pertence('12') |
|
R |
1=Normal;2=Reajuste |
!lReajuste |
N |
DW7_CODNEG |
C |
2 |
0 |
Tipo Negoc. |
@! |
ExistCpo('DW5',M->DW7_CODNEG,1) .And. TMSW10VDW5() .And. TMSW10VLD() |
DW5 |
R |
|
TMSW10WHN('DW7_CODNEG') |
N |
DW7_DESNEG |
C |
30 |
0 |
Desc.Tp.Neg. |
@! |
|
|
V |
|
|
N |
DW7_NUMPRI |
C |
6 |
0 |
Num.Pro.Pri. |
@! |
TMSW10Vld() |
DW7 |
|
|
TMSW10WHN('DW7_NUMPRI') |
N |
DW7_TABFRE |
C |
4 |
0 |
Tab.Frete |
@! |
|
|
|
|
|
N |
DW7_TIPTAB |
C |
2 |
0 |
Tip.Tab.Fre. |
@! |
|
|
|
|
|
N |
DW7_TIPFRE |
C |
1 |
0 |
Tipo Frete |
@! |
Pertence('123') |
|
|
1=CIF;2=FOB;3=CIF/FOB |
|
N |
DW7_TIPTRA |
C |
1 |
0 |
Tipo Transp. |
@! |
TMSValField('M->DW7_TIPTRA',.T.,'DW7_DESTPT') |
DLC |
|
|
|
N |
DW7_DESTPT |
C |
30 |
0 |
Desc.Tp.Tran |
@! |
|
|
V |
|
|
N |
DW7_CODCLI |
C |
6 |
0 |
Cod.Cliente |
@! |
(Vazio() .Or. ExistCpo('SA1')) .And. TMSW10Vld() |
SA1 |
R |
|
TMSW10WHN('DW7_CODCLI') |
N |
DW7_LOJCLI |
C |
2 |
0 |
Loja Cli. |
@! |
(Vazio() .Or. ExistCpo('SA1',M->DW7_CODCLI+M->DW7_LOJCLI)) .And. TMSW10Vld() |
|
|
|
TMSW10WHN('DW7_LOJCLI') |
N |
DW7_NOMCLI |
C |
40 |
0 |
Nome Cli. |
@! |
|
|
V |
|
|
N |
DW7_SERVIC |
C |
3 |
0 |
Servico |
@! |
TMSW10VLD() |
DLJ |
|
|
TMSW10WHN('DW7_SERVIC') |
N |
DW7_DESSER |
C |
30 |
0 |
Desc.Servico |
@! |
|
|
V |
|
|
N |
DW7_CODVEN |
C |
6 |
0 |
Vendedor |
@! |
ExistCpo('SA3') |
SA3 |
|
|
|
N |
DW7_NOMVEN |
C |
30 |
0 |
Nome Vend. |
@! |
|
|
V |
|
|
N |
DW7_FATMED |
N |
14 |
2 |
Fat.Medio |
@E 99,999,999,999.99 |
Positivo() |
|
|
|
TMSW10WHN('DW7_FATMED') |
N |
DW7_VALMER |
N |
14 |
2 |
Vlr.R$/KG |
@E 99,999,999,999.99 |
Positivo() |
|
|
|
|
N |
DW7_COND |
C |
3 |
0 |
Cond.Pagto |
@! |
Vazio().Or.ExistCpo('SE4') |
SE4 |
|
|
TMSW10WHN('DW7_COND') |
N |
DW7_STATUS |
C |
1 |
0 |
Status |
@! |
TMSW10VLD() |
|
R |
1=Pendente;2=Em Aberto;3=Aprovado;4=Reprovado;9=Cancelado |
TMSW10WHN('DW7_STATUS') |
N |
DW7_CODPRO |
C |
15 |
0 |
Cod.Produto |
@! |
Vazio() .Or. ExistCpo('SB1',M->DW7_CODPRO,1) |
SB1 |
|
|
|
N |
DW7_DESPRO |
C |
30 |
0 |
Desc.Produto |
@! |
|
|
V |
|
|
N |
DW7_TAXEMB |
C |
1 |
0 |
Taxa Embutid |
@! |
Pertence('12') |
|
|
1=Sim;2=Nao |
TMSW10WHN('DW7_TAXEMB') |
N |
DW7_SEQUEN |
C |
2 |
0 |
Sequen.Alt. |
@! |
|
|
|
|
|
N |
DW7_CODPEN |
C |
6 |
0 |
Cod.Penden. |
@! |
|
|
|
|
|
N |
DW7_PENDEN |
M |
80 |
0 |
Pendencia |
@! |
|
|
V |
|
|
N |
DW7_CODREP |
C |
6 |
0 |
Cod.Reprov. |
@! |
|
|
|
|
|
N |
DW7_MOTREP |
M |
80 |
0 |
Mot. Reprov. |
@! |
|
|
V |
|
|
N |
DW7_CDRORI |
C |
6 |
0 |
Cod.Reg.Ori. |
@! |
Vazio() .Or. ExistCpo("DUY",,1) |
DUY |
|
|
|
N |
DW7_CDRDES |
C |
6 |
0 |
Cod.Reg.Des. |
@! |
Vazio() .Or. ExistCpo("DUY",,1) |
DUY |
|
|
|
N |
DW7_ESTADO |
C |
200 |
0 |
Estado |
@! |
|
|
|
|
|
N |
DW7_TIPPRC |
C |
1 |
0 |
Tp.Proposta |
@! |
|
|
|
|
|
N |
DW7_CODOBS |
C |
6 |
0 |
Cod. Observ. |
@! |
|
|
R |
|
|
N |
DW7_OBS |
M |
80 |
0 |
Observacao |
|
|
|
V |
|
|
N |
DW7_USERDG |
C |
6 |
0 |
Cod.Usu.Dig |
@! |
|
|
R |
|
|
N |
DW7_NUSRDG |
C |
30 |
0 |
Nome Usu.Dig |
@! |
|
|
V |
|
|
N |
DW7_USER |
C |
6 |
0 |
Cod.Usu.Lib. |
@! |
|
|
R |
|
|
N |
DW7_NOMUSR |
C |
30 |
0 |
Nome Usu.Lib |
@! |
|
|
V |
|
|
N |
DW7_PRODIG |
C |
1 |
0 |
Prp.Digitada |
@! |
Pertence('12') |
|
R |
1=Sim;2=Nao |
|
N |
DW7_FATCUB |
N |
5 |
0 |
Fat.Cubagem |
@E 99,999 |
Positivo() |
|
R |
|
TMSW10WHN('DW7_FATCUB') |
N |
DW7_CODCON |
C |
6 |
0 |
Contato |
@! |
TMSW10Vld() |
SU5 |
R |
|
|
N |
DW7_NOMCON |
C |
30 |
0 |
Nome Contato |
@! |
TMSW10Vld() |
|
R |
|
|
N |
DW7_NUMORI |
C |
6 |
0 |
Num.Pro.Ori. |
@! |
|
|
R |
|
|
N |
DW7_USERAP |
C |
6 |
0 |
Cod.Usu.Apr. |
@! |
|
|
R |
|
|
N |
DW7_NOMAPR |
C |
30 |
0 |
Nome Usu.Apr |
@! |
|
|
V |
|
|
N |
DW7_DATAPR |
D |
8 |
0 |
Dt.Apr.Prop. |
|
|
|
R |
|
|
N |
DW7_HORAPR |
C |
4 |
0 |
H.Apr.Prop. |
@R 99:99 |
|
|
R |
|
|
N |
DW7_CNEGCT |
C |
2 |
0 |
Cod Negociac |
@! |
Existcpo("DDB") |
DDB |
R |
|
TMSAW10Whe() |
S |
DW7_DNEGCT |
C |
30 |
0 |
Desc Neg Ctr |
@! |
|
|
V |
|
|
S |