Tabela |
SW3 |
Itens de Purchase Order |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
W3_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
N |
W3_CC |
C |
5 |
0 |
Unid.Requis. |
@! |
|
|
|
|
|
N |
W3_CC_NOME |
C |
20 |
0 |
Nome |
@! |
|
|
V |
|
|
N |
W3_SI_NUM |
C |
6 |
0 |
No. da S.I. |
@! |
|
|
|
|
|
N |
W3_COD_I |
C |
15 |
0 |
Codigo Item |
@! |
Po420Val('Prod') |
SB1 |
R |
|
EMPTY(Work->WKSI_NUM) |
N |
W3_PART_N |
C |
20 |
0 |
Part-Number |
@! |
|
|
R |
|
|
N |
W3_DESC_I |
C |
36 |
0 |
Descr.Ingles |
@! |
|
|
V |
|
|
N |
W3_FABR |
C |
6 |
0 |
Fabricante |
@! |
Po420Val('Fabr') |
AVI002 |
|
|
cProg#"PN" .AND. lWhen |
N |
W3_FABLOJ |
C |
2 |
0 |
Loja Fa. |
@! |
|
|
|
|
|
S |
W3_FAB_DES |
C |
20 |
0 |
Desc Fabric. |
|
|
|
V |
|
|
N |
W3_FLUXO |
C |
1 |
0 |
Anuencia |
@! |
Pertence("17") .AND. Po420Val('Anuente') |
|
|
1=Anuente;7=Nao-Anuente |
|
N |
W3_QTD_LI |
C |
15 |
0 |
Qtde. LI |
|
|
|
V |
|
|
N |
W3_REG_TRI |
C |
1 |
0 |
Cod. Regime |
@! |
ExistCpo("SJP",M->W3_REG_TRI) .AND. PO420VAL("REG_TRI") |
SJP |
|
|
|
N |
W3_REG_DES |
C |
25 |
0 |
Des. Reg Tri |
|
|
|
V |
|
|
N |
W3_GRUPORT |
C |
3 |
0 |
Grupo Reg Tr |
999 |
|
|
|
|
|
S |
W3_QTD_EMB |
N |
15 |
5 |
Embarcado |
@E 999,999,999.99999 |
|
|
V |
|
|
N |
W3_REG_MIN |
C |
10 |
0 |
Reg. Ministe |
@! |
|
|
V |
|
lGetReg_Min |
N |
W3_QTDE |
N |
13 |
3 |
Qtde Pedida |
@E 999,999,999.999 |
Po420Val('Saldo_Q') .AND. POATUALIZA() |
|
|
|
PO400WHEN("W3_QTDE") |
N |
W3_SALDO_Q |
N |
13 |
3 |
Saldo Qtde |
@E 999,999,999.999 |
|
|
|
|
cProg#"PN" .AND. .F. |
N |
W3_SEM_PED |
N |
15 |
5 |
Sem Pedido |
@E 999,999,999.99999 |
|
|
V |
|
|
N |
W3_UM |
C |
2 |
0 |
Unidade |
|
ExistCpo("SAH") |
SAH |
R |
|
|
S |
W3_PRECO |
N |
15 |
5 |
Preco Unit. |
@E 999,999,999.99999 |
Po420Val('VlUnit') .AND. (M->W3_CUSTO:=(M->W3_PRECO*M->W3_QTDE)) |
|
|
|
PO400WHEN('W3_PRECO') |
N |
W3_QTSEGUM |
N |
13 |
3 |
Qtd.Seg.UM |
@E 999,999,999.999 |
|
|
R |
|
|
S |
W3_DT_EMB |
D |
8 |
0 |
Dt Embarque |
|
Po420Val('DtEmbarque') |
|
|
|
|
N |
W3_SEGUM |
C |
2 |
0 |
Seg. Unid. |
|
ExistCpo("SAH") |
SAH |
R |
|
|
S |
W3_CUSTO |
N |
15 |
5 |
Vlr. Total |
@E 999,999,999.99999 |
|
|
V |
|
|
N |
W3_DT_ENTR |
D |
8 |
0 |
Dt Entrega |
|
PO420VAL('DtEntrega') |
|
|
|
lMostraMem |
N |
W3_PORTARI |
N |
2 |
0 |
Portaria No. |
99 |
|
|
|
|
|
N |
W3_TEC |
C |
10 |
0 |
Pos.IPI/NCM |
@R 9999.99.99 |
PO420VAL("TEC1") |
SYD |
|
|
|
N |
W3_EX_NCM |
C |
3 |
0 |
Ex-NCM |
@R 999 |
PO420VAL('TEC2') |
WD2 |
|
|
!EMPTY(M->W3_TEC) |
N |
W3_EX_NBM |
C |
3 |
0 |
Ex-NBM |
@! |
PO420VAL('TEC3') |
WD3 |
|
|
!EMPTY(M->W3_TEC) |
N |
W3_FABR_01 |
C |
6 |
0 |
Fabricante 1 |
@! |
PO420VAL('Fbr1') |
AVI002 |
|
|
cProg#"PN" |
N |
W3_FAB1LOJ |
C |
2 |
0 |
Loja Fa. |
@! |
|
|
|
|
|
S |
W3_FABR_02 |
C |
6 |
0 |
Fabricante 2 |
@! |
PO420VAL('Fbr2') |
AVI002 |
|
|
!EMPTY(M->W3_FABR_01).AND.cPROG#"PN" |
N |
W3_FAB2LOJ |
C |
2 |
0 |
Loja Fa. |
@! |
|
|
|
|
|
S |
W3_FABR_03 |
C |
6 |
0 |
Fabricante 3 |
@! |
PO420VAL('Fbr3') |
AVI002 |
|
|
!EMPTY(M->W3_FABR_02).AND.cPROG#"PN" |
N |
W3_FAB3LOJ |
C |
2 |
0 |
Loja Fa. |
@! |
|
|
|
|
|
S |
W3_FABR_04 |
C |
6 |
0 |
Fabricante 4 |
@! |
PO420VAL('Fbr4') |
AVI002 |
|
|
!EMPTY(M->W3_FABR_03).AND.cPROG#"PN" |
N |
W3_FAB4LOJ |
C |
2 |
0 |
Loja Fa. |
@! |
|
|
|
|
|
S |
W3_FABR_05 |
C |
6 |
0 |
Fabricante 5 |
@! |
PO420VAL('Fbr5') |
AVI002 |
|
|
!EMPTY(M->W3_FABR_04).AND.cPROG#"PN" |
N |
W3_FAB5LOJ |
C |
2 |
0 |
Loja Fa. |
@! |
|
|
|
|
|
S |
W3_POSICAO |
C |
4 |
0 |
Posicao |
9999 |
|
|
|
|
|
N |
W3_PO_NUM |
C |
15 |
0 |
No. do P.O. |
@! |
|
|
|
|
|
N |
W3_PGI_NUM |
C |
10 |
0 |
No. da PLI |
@! |
|
|
|
|
|
N |
W3_PRECOVE |
N |
15 |
5 |
Preco Venda |
@E 999,999,999.99999 |
|
|
|
|
|
N |
W3_SEQ |
N |
2 |
0 |
Sequencia |
99 |
|
|
|
|
|
N |
W3_REG |
N |
4 |
0 |
Parcela No. |
9999 |
|
|
|
|
|
N |
W3_NR_CONT |
N |
4 |
0 |
No. Controle |
9999 |
|
|
|
|
|
N |
W3_FORN |
C |
6 |
0 |
Fornecedor |
@! |
|
|
|
|
|
N |
W3_SLD_ELI |
N |
13 |
3 |
Sld. Elim. |
@E 999,999,999.999 |
|
|
|
|
|
N |
W3_FORLOJ |
C |
2 |
0 |
Loja Fo. |
@! |
|
|
|
|
|
S |
W3_SOFTWAR |
C |
1 |
0 |
Software |
9 |
|
|
R |
1=Sim;2=Nao |
|
N |
W3_PRAZO |
N |
5 |
0 |
Prazo |
99999 |
|
|
V |
|
|
N |
W3_FLAG |
C |
2 |
0 |
Flag |
|
|
|
V |
|
|
N |
W3_FORECAS |
C |
1 |
0 |
Forecast |
|
Pertence("12") |
|
|
1=Sim;2=Nao |
|
N |
W3_PO_DA |
C |
15 |
0 |
No. P.O. DA |
@! |
|
|
|
|
|
N |
W3_POSI_DA |
C |
4 |
0 |
Posicao DA |
9999 |
|
|
|
|
|
N |
W3_PGI_DA |
C |
10 |
0 |
No. PLI DA |
@! |
|
|
|
|
|
N |
W3_PESOL |
N |
13 |
6 |
Peso Liq Uni |
@E 999,999.999999 |
|
|
R |
|
|
N |
W3_CTCUSTO |
C |
9 |
0 |
Cent.Custo |
@! |
ExistCpo("CTT") |
CTT |
R |
|
|
N |
W3_CODOPE |
C |
2 |
0 |
Cod. Ope. Es |
@! |
ValidOpe('W3_CODOPE') |
EJ0 |
|
|
!INCLUI |
S |
W3_DESOPE |
C |
60 |
0 |
Desc. Op. Es |
@! |
|
|
V |
|
|
S |
W3_PESO_BR |
N |
13 |
6 |
Peso Bru Uni |
@E 999,999.999999 |
Positivo() |
|
R |
|
|
S |
W3_ALTANU |
C |
1 |
0 |
Alt.Anuencia |
@! |
|
|
|
1=Nao Alterado;2=Alterado |
|
N |
W3_FRETE |
N |
15 |
2 |
Frete |
@E 999,999,999,999.99 |
Positivo() |
|
R |
|
|
S |
W3_SEGURO |
N |
15 |
2 |
Seguro |
@E 999,999,999,999.99 |
Positivo() |
|
R |
|
|
S |
W3_INLAND |
N |
15 |
2 |
Inland |
@E 999,999,999,999.99 |
Positivo() |
|
R |
|
|
S |
W3_DESCONT |
N |
15 |
2 |
Desconto |
@E 999,999,999,999.99 |
Positivo() |
|
R |
|
|
S |
W3_PACKING |
N |
15 |
2 |
Packing |
@E 999,999,999,999.99 |
Positivo() |
|
R |
|
|
S |