|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pih_hist
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pih__chr01
|
|
|
x(8)
|
|
|
|
pih__chr02
|
|
|
x(8)
|
|
|
|
pih__chr03
|
|
|
x(8)
|
|
|
|
pih__chr04
|
|
|
x(8)
|
|
|
|
pih__chr05
|
|
|
x(8)
|
|
|
|
pih__chr06
|
|
|
x(8)
|
|
|
|
pih__chr07
|
|
|
x(8)
|
|
|
|
pih__chr08
|
|
|
x(8)
|
|
|
|
pih__chr09
|
|
|
x(8)
|
|
|
|
pih__chr10
|
|
|
x(8)
|
|
|
|
pih__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
pih__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
pih__dte01
|
|
|
99/99/99
|
|
|
|
pih__dte02
|
|
|
99/99/99
|
|
|
|
pih__log01
|
|
|
yes/no
|
|
|
|
pih__qadc01
|
|
|
x(8)
|
|
|
|
pih__qadd01
|
|
|
->>>,>>>,>>9.9<<<
|
10
|
|
|
pih_accr_acct
|
Accrual Acct
|
|
x(8)
|
|
|
|
pih_accr_cc
|
Accrual CC
|
CC
|
x(8)
|
|
|
|
pih_accr_proj
|
Accrual Proj
|
|
x(8)
|
|
|
|
pih_accr_sub
|
Accrual Sub
|
Sub-Acct
|
x(8)
|
|
|
|
pih_amt
|
Amount
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
pih_amt_type
|
Amt Type
|
|
x(8)
|
|
|
|
pih_bonus_line
|
Triggering Line Number
|
|
>>9
|
|
|
|
pih_break_cat
|
Break Cat
|
|
x(18)
|
|
|
|
pih_comb_type
|
Comb Type
|
|
x(24)
|
|
|
|
pih_confg_disc
|
Config Disc
|
Config
|
yes/no
|
|
|
|
pih_cr_terms
|
Credit Terms
|
Terms
|
x(8)
|
|
|
|
pih_disc_acct
|
Disc Acct
|
|
x(8)
|
|
|
|
pih_disc_amt
|
Disc Amt
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
pih_disc_cc
|
Cost Ctr
|
CC
|
x(4)
|
|
|
|
pih_disc_proj
|
Project
|
|
x(8)
|
|
|
|
pih_disc_seq
|
Disc Sequence
|
|
>>,>>9.<<<<<
|
10
|
|
|
pih_disc_sub
|
Sub Acct
|
Sub-Acct
|
x(8)
|
|
|
|
pih_doc_type
|
Doc Type
|
|
>>9
|
|
|
|
pih_domain
|
Domain
|
|
x(8)
|
|
|
|
pih_feature
|
Feature
|
|
x(12)
|
|
|
|
pih_fr_list
|
Freight List
|
Frt List
|
x(8)
|
|
|
|
pih_fr_terms
|
Freight Terms
|
|
x(8)
|
|
|
|
pih_line
|
Line
|
|
>>9
|
|
|
|
pih_list
|
Price List
|
List
|
x(8)
|
|
|
|
pih_list_id
|
List Id
|
|
x(8)
|
|
|
|
pih_min_net
|
Min Net Ord
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
pih_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
pih_nbr
|
Order
|
|
x(8)
|
|
|
|
pih_option
|
Item Number
|
|
x(18)
|
|
|
|
pih_parent
|
Parent Item
|
|
x(18)
|
|
|
|
pih_pid_qty
|
Break Qty
|
|
->>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
pih_pig_code
|
Price List Group
|
|
x(8)
|
|
|
|
pih_print
|
Print
|
|
yes/no
|
|
|
|
pih_promo1
|
Promotion Code
|
|
x(8)
|
|
|
|
pih_promo2
|
Promotion Type
|
|
x(8)
|
|
|
|
pih_promo3
|
APM Code 3
|
|
x(8)
|
|
|
|
pih_promo4
|
APM Code 4
|
|
x(8)
|
|
|
|
pih_qty
|
Qty
|
|
->>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
pih_qty_type
|
Qty Type
|
|
x(24)
|
|
|
|
pih_source
|
Source
|
|
x(8)
|
|
|
|
pih_time
|
Time
|
|
>>,>>>,>>9
|
|
|
|
pih_um
|
UM
|
|
x(2)
|
|
|
|
pih_user1
|
Ufld1
|
|
x(8)
|
|
|
|
pih_user2
|
Ufld2
|
|
x(8)
|
|
|
|
pih_userid
|
User ID
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pih_hist
|
yes
|
oid_pih_hist
|
yes
|
no
|
|
|
pih_comp
|
no
|
pih_domain
|
yes
|
no
|
|
|
|
|
pih_doc_type
|
yes
|
no
|
|
|
|
|
pih_nbr
|
yes
|
no
|
|
|
|
|
pih_line
|
yes
|
no
|
|
|
|
|
pih_parent
|
yes
|
no
|
|
|
|
|
pih_feature
|
yes
|
no
|
|
|
|
|
pih_option
|
yes
|
no
|
|
|
pih_list
|
no
|
pih_domain
|
yes
|
no
|
|
|
|
|
pih_list
|
yes
|
no
|
|
|
|
|
pih_doc_type
|
yes
|
no
|
|
|
|
|
pih_nbr
|
yes
|
no
|
|
|
|
|
pih_line
|
yes
|
no
|
|
|
pih_list_id
|
no
|
pih_domain
|
yes
|
no
|
|
|
|
|
pih_list_id
|
yes
|
no
|
|
∗
|
pih_nbr
|
yes
|
pih_domain
|
yes
|
no
|
|
|
|
|
pih_doc_type
|
yes
|
no
|
|
|
|
|
pih_nbr
|
yes
|
no
|
|
|
|
|
pih_line
|
yes
|
no
|
|
|
|
|
pih_confg_disc
|
yes
|
no
|
|
|
|
|
pih_source
|
yes
|
no
|
|
|
|
|
pih_list_id
|
yes
|
no
|
|
|
|
|
pih_amt_type
|
yes
|
no
|
|
|
|
|
pih_parent
|
yes
|
no
|
|
|
|
|
pih_feature
|
yes
|
no
|
|
|
|
|
pih_option
|
yes
|
no
|