|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pi_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pi__chr01
|
|
|
x(8)
|
|
|
|
pi__chr02
|
|
|
x(8)
|
|
|
|
pi__chr03
|
|
|
x(8)
|
|
|
|
pi__chr04
|
|
|
x(8)
|
|
|
|
pi__chr05
|
|
|
x(8)
|
|
|
|
pi__chr06
|
|
|
x(8)
|
|
|
|
pi__chr07
|
|
|
x(8)
|
|
|
|
pi__chr08
|
|
|
x(8)
|
|
|
|
pi__chr09
|
|
|
x(8)
|
|
|
|
pi__chr10
|
|
|
x(8)
|
|
|
|
pi__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
pi__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
pi__dte01
|
|
|
99/99/99
|
|
|
|
pi__dte02
|
|
|
99/99/99
|
|
|
|
pi__log01
|
|
|
yes/no
|
|
|
|
pi__qadc01
|
|
|
x(8)
|
|
|
|
pi__qadd01
|
|
|
->>>,>>>,>>9.9<<<
|
10
|
|
|
pi_accr_acct
|
Accrual Acct
|
|
x(8)
|
|
|
|
pi_accr_cc
|
Accrual CC
|
CC
|
x(8)
|
|
|
|
pi_accr_proj
|
Accrual Proj
|
|
x(8)
|
|
|
|
pi_accr_sub
|
Accrual Sub
|
Sub-Acct
|
x(8)
|
|
|
|
pi_amt_type
|
Amount Type
|
|
x(24)
|
|
|
|
pi_break_cat
|
Break Cat
|
|
x(18)
|
|
|
|
pi_cmtindx
|
Comments
|
|
>>>>>>>9
|
|
|
|
pi_comb_type
|
Comb Type
|
|
x(24)
|
|
|
|
pi_confg_disc
|
Config Disc
|
Config
|
yes/no
|
|
|
|
pi_cost_set
|
Cost Set
|
|
x(8)
|
|
|
|
pi_cs_code
|
Cust/Supplier Cat
|
|
x(18)
|
|
|
|
pi_cs_type
|
Cust/Supplier Type
|
C/S Type
|
x(24)
|
|
|
|
pi_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
pi_desc
|
Description
|
|
x(24)
|
|
|
|
pi_disc_acct
|
Disc Acct
|
|
x(8)
|
|
|
|
pi_disc_cc
|
Cost Ctr
|
CC
|
x(8)
|
|
|
|
pi_disc_proj
|
Project
|
|
x(8)
|
|
|
|
pi_disc_seq
|
Disc Sequence
|
|
>>>,>>9.9<<<<<
|
10
|
|
|
pi_disc_sub
|
Sub Acct
|
Sub-Acct
|
x(8)
|
|
|
|
pi_domain
|
Domain
|
|
x(8)
|
|
|
|
pi_expire
|
Expire
|
|
99/99/99
|
|
|
|
pi_extrec
|
External Entry
|
Ext
|
yes/no
|
|
|
|
pi_list
|
Price List
|
List
|
x(8)
|
|
|
|
pi_list_id
|
List Id
|
|
x(8)
|
|
|
|
pi_list_price
|
List Price
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
pi_manual
|
Manual
|
|
yes/no
|
|
|
|
pi_max_ord
|
Max Orders
|
|
>>>9
|
|
|
|
pi_max_price
|
Max Price
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
pi_max_qty
|
Max Qty
|
|
->>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
pi_min_net
|
Min Net Ord
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
pi_min_price
|
Min Price
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
pi_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
pi_part_code
|
Item Cat
|
|
x(18)
|
|
|
|
pi_part_type
|
Type
|
|
x(24)
|
|
|
|
pi_pig_code
|
Price List Group
|
|
x(8)
|
|
|
|
pi_print
|
Print
|
|
yes/no
|
|
|
|
pi_promo1
|
Promotion Code
|
|
x(8)
|
|
|
|
pi_promo2
|
Promotion Type
|
|
x(8)
|
|
|
|
pi_promo3
|
APM Code 3
|
|
x(8)
|
|
|
|
pi_promo4
|
APM Code 4
|
|
x(8)
|
|
|
|
pi_qty_type
|
Qty Type
|
|
x(24)
|
|
|
|
pi_srch_type
|
Search Type
|
|
>>9
|
|
|
|
pi_start
|
Start
|
|
99/99/99
|
|
|
|
pi_terms
|
Terms
|
|
x(8)
|
|
|
|
pi_um
|
UM
|
|
x(2)
|
|
|
|
pi_user1
|
Ufld1
|
|
x(8)
|
|
|
|
pi_user2
|
Ufld2
|
|
x(8)
|
|
|
|
pi_userid
|
User ID
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pi_mstr
|
yes
|
oid_pi_mstr
|
yes
|
no
|
|
|
pi_cs_code
|
no
|
pi_domain
|
yes
|
no
|
|
|
|
|
pi_cs_type
|
yes
|
no
|
|
|
|
|
pi_cs_code
|
yes
|
no
|
|
|
|
|
pi_part_type
|
yes
|
no
|
|
|
|
|
pi_part_code
|
yes
|
no
|
|
|
|
|
pi_srch_type
|
yes
|
no
|
|
|
|
|
pi_curr
|
yes
|
no
|
|
|
|
|
pi_um
|
yes
|
no
|
|
|
|
|
pi_start
|
yes
|
no
|
|
∗
|
pi_list
|
yes
|
pi_domain
|
yes
|
no
|
|
|
|
|
pi_list
|
yes
|
no
|
|
|
|
|
pi_cs_type
|
yes
|
no
|
|
|
|
|
pi_cs_code
|
yes
|
no
|
|
|
|
|
pi_part_type
|
yes
|
no
|
|
|
|
|
pi_part_code
|
yes
|
no
|
|
|
|
|
pi_curr
|
yes
|
no
|
|
|
|
|
pi_um
|
yes
|
no
|
|
|
|
|
pi_start
|
yes
|
no
|
|
|
pi_list_id
|
yes
|
pi_domain
|
yes
|
no
|
|
|
|
|
pi_list_id
|
yes
|
no
|
|
|
pi_part_code
|
no
|
pi_domain
|
yes
|
no
|
|
|
|
|
pi_part_type
|
yes
|
no
|
|
|
|
|
pi_part_code
|
yes
|
no
|
|
|
|
|
pi_cs_type
|
yes
|
no
|
|
|
|
|
pi_cs_code
|
yes
|
no
|
|
|
|
|
pi_srch_type
|
yes
|
no
|
|
|
|
|
pi_curr
|
yes
|
no
|
|
|
|
|
pi_um
|
yes
|
no
|
|
|
|
|
pi_start
|
yes
|
no
|