Tabela |
SWT |
Detalhamento da Cotacao |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
WT_STATUS |
C |
1 |
0 |
Situacao |
|
Pertence('1234') |
|
R |
1=Em Cotacao;2=Em Avaliacao;3=Aprovada;4=Reprovada |
|
S |
WT_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
N |
WT_NR_CONC |
C |
6 |
0 |
Cotacao |
@! |
|
|
|
|
|
N |
WT_COD_I |
C |
15 |
0 |
Codigo Item |
@! |
|
SB1 |
|
|
|
N |
WT_FORN |
C |
6 |
0 |
Cod. Forn. |
@! |
QC210VAL('9') |
SA2A |
R |
|
|
N |
WT_FORLOJ |
C |
2 |
0 |
Loja Fo. |
@! |
If(!Empty(M->WT_FORLOJ),ExistCpo("SA2",M->WT_FORN+M->WT_FORLOJ),.T.) |
|
R |
|
|
S |
WT_FORNOME |
C |
20 |
0 |
Fornecedor |
|
|
|
V |
|
|
N |
WT_FABR |
C |
6 |
0 |
Cod. Fabr. |
@! |
QC210VAL('10') |
SA2A |
R |
|
|
N |
WT_FABLOJ |
C |
2 |
0 |
Loja Fa. |
@! |
If(!Empty(M->WT_FABLOJ),ExistCpo("SA2",M->WT_FABR+M->WT_FABLOJ),.T.) |
|
R |
|
|
S |
WT_FABRNOM |
C |
20 |
0 |
Fabricante |
|
|
|
V |
|
|
N |
WT_FOB_UNI |
N |
15 |
5 |
Fob Unitario |
@E 999,999,999.99999 |
Positivo().and.QC210VAL('12') |
|
|
|
|
N |
WT_FOB_TOT |
N |
15 |
5 |
Fob Total |
@E 999,999,999.99999 |
|
|
V |
|
|
N |
WT_ULT_FOB |
N |
15 |
2 |
Vl Ult Compr |
@E 999,999,999,999.99 |
|
|
V |
|
|
N |
WT_ULT_ENT |
D |
8 |
0 |
Dt Ult Compr |
@D |
|
|
V |
|
|
N |
WT_SI_NUM |
C |
6 |
0 |
No. S.I. |
@! |
|
SW0 |
R |
|
|
S |
WT__CC |
C |
5 |
0 |
Unid. Req. |
@! |
|
SY3 |
R |
|
|
S |
WT_REG |
N |
4 |
0 |
Parcela No |
9999 |
|
|
R |
|
|
S |
WT_UM |
C |
2 |
0 |
Unid.Forn. |
|
ExistCpo('SAH') |
SAH |
R |
|
|
S |
WT_QTDE |
N |
13 |
3 |
Quantidade |
@E 999,999,999.999 |
Positivo() |
|
R |
|
|
S |
WT_DT_FORN |
D |
8 |
0 |
Dt. Entrega |
|
ValDtEnt() |
|
|
|
|
N |
WT_ORIGEM |
C |
3 |
0 |
Origem |
@! |
QC210VAL('11') |
YR11 |
|
|
|
N |
WT_COD_PAG |
C |
5 |
0 |
Cond. Pagto |
@! |
QC210VAL('14') |
SY6 |
|
|
|
N |
WT_DIASPAG |
N |
3 |
0 |
Dias Pagto |
999 |
|
|
|
|
|
N |
WT_INCOTER |
C |
3 |
0 |
Incoterm |
@! |
ExistCpo('SYJ',M->WT_INCOTER) .And. QC210Val('24') |
SYJ |
R |
|
|
N |
WT_MOEDA |
C |
3 |
0 |
Moeda Fob |
@! |
QC210VAL('15') |
SYF |
|
|
|
N |
WT_VL_UNIT |
N |
15 |
5 |
Vl.Un.Cond.V |
@E 999,999,999.99999 |
Positivo() .And. QC210VAL('23') |
|
R |
|
|
N |
WT_TOTMVC |
N |
15 |
5 |
Vl.Tot.Cond. |
@E 999,999,999.99999 |
|
|
R |
|
|
S |
WT_ID |
C |
10 |
0 |
ID |
|
|
|
R |
|
|
S |
WT_DESPIN |
N |
15 |
2 |
Desp. Int. |
@E 999,999,999,999.99 |
Positivo() |
|
R |
|
|
S |
WT_MOE_FRE |
C |
3 |
0 |
Moeda Frete |
@! |
|
|
V |
|
|
N |
WT_FRE_KG |
N |
12 |
2 |
Frete Total |
@E 999,999,999.99 |
Positivo().AND.QC210VAL('13') |
|
|
|
|
N |
WT_SEGURO |
N |
12 |
2 |
Seguro |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
N |
WT_CIFRS |
N |
15 |
5 |
Vl.CIF R$ |
@E 999,999,999.99999 |
|
|
R |
|
|
S |
WT_DESPRS |
N |
15 |
2 |
Desp. Nac. |
@E 999,999,999,999.99 |
Positivo() |
|
R |
|
|
S |
WT_TOTRS |
N |
15 |
5 |
Cust.Total |
@E 999,999,999.99999 |
|
|
R |
|
|
S |
WT_TOTURS |
N |
15 |
5 |
Cust.Un.R$ |
@E 999,999,999.99999 |
Positivo() |
|
R |
|
|
S |
WT_NUMERP |
C |
6 |
0 |
Cotacao ERP |
999999 |
|
|
R |
|
|
S |
WT_DTNECES |
D |
8 |
0 |
Necessidade |
|
QC210VAL('5') |
|
R |
|
QC210VAL('6') |
S |