|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_vp_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
vp__chr01
|
|
|
x(8)
|
|
|
|
vp__chr02
|
|
|
x(8)
|
|
|
|
vp__chr03
|
|
|
x(8)
|
|
|
|
vp__chr04
|
|
|
x(8)
|
|
|
|
vp__chr05
|
|
|
x(8)
|
|
|
|
vp__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
vp__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
vp__dte01
|
|
|
99/99/99
|
|
|
|
vp__dte02
|
|
|
99/99/99
|
|
|
|
vp__log01
|
|
|
yes/no
|
|
|
|
vp_appr_date
|
Approve Date
|
Approve
|
99/99/99
|
|
|
|
vp_bkage_amt
|
Brokerage Amt
|
|
->>,>>>,>>9.99
|
10
|
|
|
vp_comment
|
Comment
|
|
x(40)
|
|
|
|
vp_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
vp_domain
|
Domain
|
|
x(8)
|
|
|
|
vp_duty_amt
|
Duty Amt
|
|
->>,>>>,>>9.99
|
10
|
|
|
vp_duty_type
|
Duty Type
|
Dty
|
x(1)
|
|
|
|
vp_frt_amt
|
Freight Amt
|
|
->>,>>>,>>9.99
|
10
|
|
|
vp_ins_rqd
|
Inspect
|
Ins!Req
|
yes/no
|
|
|
|
vp_mfgr
|
Manufacturer
|
Mfg
|
x(8)
|
|
|
|
vp_mfgr_part
|
Manufacturer Item
|
|
x(18)
|
|
|
|
vp_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
vp_part
|
Item Number
|
|
x(18)
|
|
|
|
vp_pkg_code
|
Pkg Code
|
|
x(18)
|
|
|
|
vp_pr_list
|
Price List
|
List
|
x(8)
|
|
|
|
vp_q_date
|
Quote Date
|
Quote
|
99/99/99
|
|
|
|
vp_q_price
|
Quote Price
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
vp_q_qty
|
Quote Qty
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
vp_rcpt_stat
|
Receipt Status
|
Status
|
x(8)
|
|
|
|
vp_sch_pct
|
Schedule
|
Sch
|
>>9.99%
|
10
|
|
|
vp_tp_pct
|
SO Price Reduction
|
Ext %
|
>>9.99%
|
10
|
|
|
vp_tp_use_pct
|
Use SO Reduction Price
|
Use Trans Price
|
yes/no
|
|
|
|
vp_um
|
UM
|
|
x(2)
|
|
|
|
vp_user1
|
Ufld1
|
|
x(8)
|
|
|
|
vp_user2
|
Ufld2
|
|
x(8)
|
|
|
|
vp_userid
|
User ID
|
|
x(8)
|
|
|
|
vp_vend
|
Supplier
|
|
x(8)
|
|
|
|
vp_vend_lead
|
Supplier Lead Time
|
LT
|
>>9
|
|
|
|
vp_vend_part
|
Supplier Item
|
|
x(30)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_vp_mstr
|
yes
|
oid_vp_mstr
|
yes
|
no
|
|
∗
|
vp_partvend
|
yes
|
vp_domain
|
yes
|
no
|
|
|
|
|
vp_part
|
yes
|
no
|
|
|
|
|
vp_vend
|
yes
|
no
|
|
|
|
|
vp_vend_part
|
yes
|
no
|
|
|
vp_vend_part
|
no
|
vp_domain
|
yes
|
no
|
|
|
|
|
vp_vend
|
yes
|
no
|
|
|
|
|
vp_vend_part
|
yes
|
no
|