|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pckc_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pckc__qadc01
|
|
|
x(24)
|
|
|
|
pckc__qadc02
|
|
|
x(24)
|
|
|
|
pckc_desc
|
Description
|
|
x(24)
|
|
|
|
pckc_domain
|
Domain
|
|
x(8)
|
|
|
|
pckc_inv_part
|
Inventory Item
|
|
yes/no
|
|
|
|
pckc_label_format
|
Label Format
|
|
x(30)
|
|
|
|
pckc_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
pckc_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
pckc_pack_code
|
Pack Code
|
|
x(18)
|
|
|
|
pckc_part
|
Item
|
|
x(18)
|
|
|
|
pckc_returnable
|
Returnable
|
|
yes/no
|
|
|
|
pckc_serialized
|
Serialized
|
|
>9
|
|
|
|
pckc_ship_wt
|
Ship Weight
|
|
->>,>>9.99<<<<
|
10
|
|
|
pckc_ship_wt_um
|
Ship Weight UM
|
UM
|
x(2)
|
|
|
|
pckc_single_item
|
Single Item
|
|
yes/no
|
|
|
|
pckc_single_lot
|
Single Lot
|
|
yes/no
|
|
|
|
pckc_size
|
Volume
|
|
->>,>>9.99
|
10
|
|
|
pckc_size_um
|
Volume UM
|
UM
|
x(2)
|
|
|
|
pckc_um
|
UM
|
|
x(2)
|
|
|
|
pckc_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
pckc_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pckc_mstr
|
yes
|
oid_pckc_mstr
|
yes
|
no
|
|
∗
|
pckc_pack_code
|
yes
|
pckc_domain
|
yes
|
no
|
|
|
|
|
pckc_pack_code
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pcld_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pcld__qadc01
|
|
|
x(8)
|
|
|
|
pcld_copies
|
Copies
|
Cp
|
>>9
|
|
|
|
pcld_dev
|
Output
|
|
x(8)
|
|
|
|
pcld_domain
|
Domain
|
|
x(8)
|
|
|
|
pcld_expire
|
Expire Date
|
|
99/99/99
|
|
|
|
pcld_group
|
Group
|
|
x(8)
|
|
|
|
pcld_id
|
User Id
|
|
x(8)
|
|
|
|
pcld_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
pcld_user1
|
Ufld1
|
|
x(8)
|
|
|
|
pcld_user2
|
Ufld2
|
|
x(8)
|
|
|
|
pcld_userid
|
User ID
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pcld_det
|
yes
|
oid_pcld_det
|
yes
|
no
|
|
∗
|
pcld_groupid
|
yes
|
pcld_domain
|
yes
|
no
|
|
|
|
|
pcld_group
|
yes
|
no
|
|
|
|
|
pcld_id
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pcl_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pcl__qadc01
|
|
|
x(8)
|
|
|
|
pcl_bsn_unit
|
Business Unit
|
|
>>>>>>>>9
|
|
|
|
pcl_desc
|
Description
|
|
x(24)
|
|
|
|
pcl_domain
|
Domain
|
|
x(8)
|
|
|
|
pcl_group
|
Group
|
|
x(8)
|
|
|
|
pcl_index
|
|
|
>>>>>9
|
|
|
|
pcl_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
pcl_type
|
Type
|
T
|
x(2)
|
|
|
|
pcl_user1
|
Ufld1
|
|
x(8)
|
|
|
|
pcl_user2
|
Ufld2
|
|
x(8)
|
|
|
|
pcl_userid
|
User ID
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pcl_mstr
|
yes
|
oid_pcl_mstr
|
yes
|
no
|
|
∗
|
pcl_group
|
yes
|
pcl_domain
|
yes
|
no
|
|
|
|
|
pcl_group
|
yes
|
no
|
|
|
|
|
pcl_type
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pcsc_ctrl
|
Identifier for Periodic costing control file
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pcsc__qadc01
|
|
|
x(24)
|
|
|
|
pcsc__qadc02
|
|
|
x(24)
|
|
|
|
pcsc_calc_daybook
|
Transient Daybook
|
|
x(8)
|
|
|
|
pcsc_calc_wkctr_rate
|
Calculate Workcenter Rate
|
|
yes/no
|
|
|
|
pcsc_cs_mthd
|
Cost Method
|
|
x(4)
|
|
|
|
pcsc_cs_rvl_acct
|
Cost revalue Account
|
|
x(8)
|
|
|
|
pcsc_cs_rvl_cc
|
Cost revalue CC
|
|
x(8)
|
|
|
|
pcsc_cs_rvl_sub
|
Cost reval Sub acct
|
|
x(8)
|
|
|
|
pcsc_domain
|
Domain
|
Domain
|
x(8)
|
|
|
|
pcsc_enable
|
Periodic Cost Enable
|
|
yes/no
|
|
|
|
pcsc_final_daybook
|
Mgmt/Official Daybook
|
|
x(8)
|
|
|
|
pcsc_layer_code
|
Layer Code
|
|
x(20)
|
|
|
|
pcsc_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
pcsc_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
pcsc_sum_ll_to_mtl
|
Sum LL Costs Into Matl Cost COGS
|
|
yes/no
|
|
|
|
pcsc_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
pcsc_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
oid_pcsc_ctrl
|
yes
|
oid_pcsc_ctrl
|
yes
|
no
|
|
|
pcsc_domain
|
yes
|
pcsc_domain
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_cs_mstr
|
Identifier of Child cost set
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_parent
|
Identifier for Parent table
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_pctrop_det
|
Identifier for Side table for various tables
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pctrop__qadc01
|
|
|
x(24)
|
|
|
|
pctrop__qadc02
|
|
|
x(24)
|
|
|
|
pctrop_cst_ll
|
Cost Lower Level
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
pctrop_cst_tl
|
Cost This Level
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
pctrop_element
|
Cost Element
|
|
x(8)
|
|
|
|
pctrop_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
pctrop_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
pctrop_origin_cst_ll
|
Cost Lower Level
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
pctrop_origin_cst_tl
|
Cost This Level
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
pctrop_parent_table
|
Parent Table Name
|
|
x(16)
|
|
|
|
pctrop_remain_value
|
Remain Value
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
pctrop_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
pctrop_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
oid_pctrop_det
|
yes
|
oid_pctrop_det
|
yes
|
no
|
|
|
pctrop_par_cs_elem
|
yes
|
oid_parent
|
yes
|
no
|
|
|
|
|
oid_cs_mstr
|
yes
|
no
|
|
|
|
|
pctrop_element
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pct_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pct__qad01
|
ECR/ECN
|
|
yes/no
|
|
|
|
pct__qad02
|
|
|
99/99/99
|
|
|
|
pct__qad03
|
|
|
x(8)
|
|
|
|
pct__qad04
|
|
|
x(8)
|
|
|
|
pct__qad05
|
|
|
x(8)
|
|
|
|
pct_approval
|
Approval Code
|
Approval
|
x(8)
|
|
|
|
pct_dc_warn
|
Warning Type
|
|
>9
|
|
|
|
pct_desc
|
Description
|
|
x(24)
|
|
|
|
pct_distr
|
Distribution
|
Dstrbn
|
x(8)
|
|
|
|
pct_doc_type
|
Document Type
|
Doc Type
|
X(8)
|
|
|
|
pct_domain
|
Domain
|
|
x(8)
|
|
|
|
pct_dsgn_grp
|
Design Group
|
Dsgn Grp
|
x(8)
|
|
|
|
pct_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
pct_prefix
|
Prefix
|
Pre
|
x(3)
|
|
|
|
pct_secure_admn
|
Security Profile - Administration
|
Admn PFl
|
X(8)
|
|
|
|
pct_secure_item
|
Security Profile - Item
|
Item Pfl
|
X(8)
|
0
|
|
|
pct_secure_routing
|
Security Profile - Routing
|
Rtng Pfl
|
X(8)
|
|
|
|
pct_secure_stct
|
Security Profile - Structure
|
Stct Pfl
|
X(8)
|
|
|
|
pct_secure_text
|
Security Profile - Test
|
Text Pfl
|
X(8)
|
|
|
|
pct_seqrev_off
|
Rev Level Off
|
Off
|
yes/no
|
|
|
|
pct_type
|
Type
|
|
x(8)
|
|
|
|
pct_user1
|
Ufld1
|
|
x(8)
|
|
|
|
pct_user2
|
Ufld2
|
|
x(8)
|
|
|
|
pct_userid
|
User ID
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pct_mstr
|
yes
|
oid_pct_mstr
|
yes
|
no
|
|
∗
|
pct_type
|
yes
|
pct_domain
|
yes
|
no
|
|
|
|
|
pct_type
|
yes
|
no
|
|
|
|
|
pct_dsgn_grp
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pc_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pc__qadc01
|
|
|
x(8)
|
|
|
|
pc__qadd01
|
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
pc_amt[15]
|
Amount
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
pc_amt_type
|
Amount Type
|
T
|
x(1)
|
|
|
|
pc_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
pc_desc
|
Price List Desc
|
|
x(24)
|
|
|
|
pc_domain
|
Domain
|
|
x(8)
|
|
|
|
pc_expire
|
Expire
|
|
99/99/99
|
|
|
|
pc_list
|
Price List
|
List
|
x(8)
|
|
|
|
pc_list_classification
|
Price List Class
|
|
9
|
10
|
|
|
pc_max_price[10]
|
Maximum Price
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
pc_min_price
|
Minimum Price
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
pc_min_qty[15]
|
Min Qty
|
|
>>>>>>9
|
10
|
|
|
pc_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
pc_part
|
Item Number
|
|
x(18)
|
|
|
|
pc_prod_line
|
Product Line
|
Line
|
x(4)
|
|
|
|
pc_start
|
Start
|
|
99/99/99
|
|
|
|
pc_tax_in
|
Tax In
|
|
yes/no
|
|
|
|
pc_temp_pl
|
Temporary Price
|
|
yes/no
|
|
|
|
pc_um
|
UM
|
|
x(2)
|
|
|
|
pc_user1
|
Ufld1
|
|
x(8)
|
|
|
|
pc_user2
|
Ufld2
|
|
x(8)
|
|
|
|
pc_userid
|
User ID
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pc_mstr
|
yes
|
oid_pc_mstr
|
yes
|
no
|
|
∗
|
pc_list
|
yes
|
pc_domain
|
yes
|
no
|
|
|
|
|
pc_list_classification
|
yes
|
no
|
|
|
|
|
pc_list
|
yes
|
no
|
|
|
|
|
pc_curr
|
yes
|
no
|
|
|
|
|
pc_prod_line
|
yes
|
no
|
|
|
|
|
pc_part
|
yes
|
no
|
|
|
|
|
pc_um
|
yes
|
no
|
|
|
|
|
pc_start
|
yes
|
no
|
|
|
pc_part
|
no
|
pc_domain
|
yes
|
no
|
|
|
|
|
pc_part
|
yes
|
no
|
|
|
|
|
pc_um
|
yes
|
no
|
|
|
|
|
pc_list
|
yes
|
no
|
|
|
|
|
pc_curr
|
yes
|
no
|
|
|
|
|
pc_start
|
yes
|
no
|
|
|
pc_prod_line
|
no
|
pc_domain
|
yes
|
no
|
|
|
|
|
pc_prod_line
|
yes
|
no
|
|
|
|
|
pc_um
|
yes
|
no
|
|
|
|
|
pc_list
|
yes
|
no
|
|
|
|
|
pc_curr
|
yes
|
no
|
|
|
|
|
pc_start
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pdivd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pdivd__qadc01
|
|
|
x(24)
|
|
|
|
pdivd__qadc02
|
|
|
x(24)
|
|
|
|
pdivd__qadc03
|
|
|
x(8)
|
|
|
|
pdivd__qadd01
|
|
|
->>>>,>>>,>>9.9
|
10
|
|
|
pdivd__qadi01
|
|
|
->,>>>,>>9
|
|
|
|
pdivd__qadl01
|
|
|
yes/no
|
|
|
|
pdivd__qadt01
|
|
|
99/99/99
|
|
|
|
pdivd_accr_void
|
Accrual Void
|
|
yes/no
|
|
|
|
pdivd_acct
|
Sales Account
|
|
x(8)
|
|
|
|
pdivd_amt
|
Invoice Amount
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
pdivd_cc
|
Cost Center
|
|
x(4)
|
|
|
|
pdivd_cust
|
Sold-To
|
|
x(8)
|
|
|
|
pdivd_cust_part
|
Customer Item
|
|
x(30)
|
|
|
|
pdivd_desc
|
Description
|
|
x(50)
|
|
|
|
pdivd_diff_amt
|
Difference Amount
|
|
->>>,>>>,>>9.99<<<
|
2
|
|
|
pdivd_domain
|
Domain
|
|
x(8)
|
|
|
|
pdivd_force_match
|
Force Matched
|
Force Matched
|
yes/no
|
|
|
|
pdivd_force_match_date
|
Forced Match Date
|
Forced Match Date
|
99/99/99
|
|
|
|
pdivd_force_match_user
|
Forced Match User
|
Forced Match User
|
x(8)
|
|
|
|
pdivd_found
|
Found
|
|
yes/no
|
|
|
|
pdivd_line
|
Line
|
|
>>>>>9
|
|
|
|
pdivd_list_price
|
Customer List Price
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
pdivd_match_addr
|
Customer Matching Address
|
|
x(8)
|
|
|
|
pdivd_matched
|
Matched
|
|
yes/no
|
|
|
|
pdivd_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
pdivd_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
pdivd_nbr
|
Self-Billing Invoice
|
Self-Billing Inv
|
x(20)
|
|
|
|
pdivd_po
|
Purchase Order
|
|
x(22)
|
|
|
|
pdivd_post_blocked
|
Post Blocked
|
|
yes/no
|
|
|
|
pdivd_post_void
|
Posting Void
|
|
yes/no
|
|
|
|
pdivd_price
|
Invoice Price
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
pdivd_processed
|
Processed
|
|
yes/no
|
|
|
|
pdivd_project
|
Project
|
|
x(8)
|
|
|
|
pdivd_qty
|
Qty Invoiced
|
|
->,>>>,>>9.9<<<
|
10
|
|
|
pdivd_ran
|
RAN Number
|
|
x(13)
|
|
|
|
pdivd_shipto
|
Ship-To
|
|
x(8)
|
|
|
|
pdivd_shipto_date
|
Shipment Date
|
|
99/99/99
|
|
|
|
pdivd_shipto_ref
|
Shipment Ref
|
|
x(20)
|
|
|
|
pdivd_site
|
Site
|
|
x(8)
|
|
|
|
pdivd_sub
|
Sales Sub-account
|
|
x(8)
|
|
|
|
pdivd_tax_env
|
Tax Environment
|
|
x(16)
|
|
|
|
pdivd_tax_in
|
Tax In
|
|
yes/no
|
|
|
|
pdivd_tax_usage
|
Tax Usage
|
|
x(8)
|
|
|
|
pdivd_taxable
|
Taxable
|
|
yes/no
|
|
|
|
pdivd_taxc
|
Tax Class
|
|
x(3)
|
|
|
|
pdivd_type
|
Line Type
|
Type
|
x(2)
|
|
|
|
pdivd_um
|
UM
|
|
x(2)
|
|
|
|
pdivd_um_conv
|
Um Conversion
|
UM Conv
|
>>>>9.9999<<<<
|
10
|
|
|
pdivd_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
pdivd_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pdivd_det
|
yes
|
oid_pdivd_det
|
yes
|
no
|
|
∗
|
pdivd_cust
|
yes
|
pdivd_domain
|
yes
|
no
|
|
|
|
|
pdivd_cust
|
yes
|
no
|
|
|
|
|
pdivd_nbr
|
yes
|
no
|
|
|
|
|
pdivd_line
|
yes
|
no
|
|
|
|
|
pdivd_match_addr
|
yes
|
no
|
|
|
pdivd_matched
|
no
|
pdivd_domain
|
yes
|
no
|
|
|
|
|
pdivd_matched
|
yes
|
no
|
|
|
|
|
pdivd_site
|
yes
|
no
|
|
|
|
|
pdivd_shipto
|
yes
|
no
|
|
|
|
|
pdivd_shipto_ref
|
yes
|
no
|
|
|
|
|
pdivd_ran
|
yes
|
no
|
|
|
|
|
pdivd_cust_part
|
yes
|
no
|
|
|
|
|
pdivd_type
|
yes
|
no
|
|
|
pdivd_mtch_ran
|
no
|
pdivd_domain
|
yes
|
no
|
|
|
|
|
pdivd_site
|
yes
|
no
|
|
|
|
|
pdivd_match_addr
|
yes
|
no
|
|
|
|
|
pdivd_ran
|
yes
|
no
|
|
|
|
|
pdivd_cust_part
|
yes
|
no
|
|
|
pdivd_mtch_sh_ran
|
no
|
pdivd_domain
|
yes
|
no
|
|
|
|
|
pdivd_site
|
yes
|
no
|
|
|
|
|
pdivd_match_addr
|
yes
|
no
|
|
|
|
|
pdivd_shipto_ref
|
yes
|
no
|
|
|
|
|
pdivd_ran
|
yes
|
no
|
|
|
|
|
pdivd_cust_part
|
yes
|
no
|
|
|
pdivd_mtch_ship
|
no
|
pdivd_domain
|
yes
|
no
|
|
|
|
|
pdivd_site
|
yes
|
no
|
|
|
|
|
pdivd_match_addr
|
yes
|
no
|
|
|
|
|
pdivd_shipto_ref
|
yes
|
no
|
|
|
|
|
pdivd_cust_part
|
yes
|
no
|
|
|
pdivd_post_voided
|
no
|
pdivd_domain
|
yes
|
no
|
|
|
|
|
pdivd_post_void
|
yes
|
no
|
|
|
pdivd_processed
|
no
|
pdivd_domain
|
yes
|
no
|
|
|
|
|
pdivd_cust
|
yes
|
no
|
|
|
|
|
pdivd_nbr
|
yes
|
no
|
|
|
|
|
pdivd_processed
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pdiv_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pdiv__qadc01
|
|
|
x(24)
|
|
|
|
pdiv__qadc02
|
|
|
x(24)
|
|
|
|
pdiv__qadc03
|
|
|
x(8)
|
|
|
|
pdiv__qadd01
|
|
|
->>>>,>>>,>>9.9
|
10
|
|
|
pdiv__qadi01
|
|
|
->,>>>,>>9
|
|
|
|
pdiv__qadl01
|
|
|
yes/no
|
|
|
|
pdiv__qadt01
|
|
|
99/99/99
|
|
|
|
pdiv_ar_acct
|
AR Account
|
|
x(8)
|
|
|
|
pdiv_ar_cc
|
AR Cost Center
|
CC
|
x(4)
|
|
|
|
pdiv_ar_sub
|
AR Sub-account
|
|
x(8)
|
|
|
|
pdiv_bill
|
Bill To
|
|
x(8)
|
|
|
|
pdiv_cr_terms
|
Credit Terms
|
|
x(8)
|
|
|
|
pdiv_curr
|
Currency
|
Curr
|
x(3)
|
|
|
|
pdiv_cust
|
Sold-To
|
|
x(8)
|
|
|
|
pdiv_daybookset
|
Daybook Set
|
Dybk Set
|
x(8)
|
|
|
|
pdiv_disc_pct
|
Disc %
|
|
->9.99%
|
10
|
|
|
pdiv_domain
|
Domain
|
|
x(8)
|
|
|
|
pdiv_due_date
|
Due Date
|
Due
|
99/99/99
|
|
|
|
pdiv_ex_rate
|
Exchange Rate
|
|
>>,>>9.99999<<<<<
|
10
|
|
|
pdiv_ex_rate2
|
Exchange Rate 2
|
|
>>,>>9.99999<<<<<
|
10
|
|
|
pdiv_ex_ratetype
|
Rate Type
|
|
x(8)
|
|
|
|
pdiv_exru_seq
|
Sequence
|
|
>>>>>>>>9
|
|
|
|
pdiv_fix_rate
|
Fixed Rate
|
|
yes/no
|
|
|
|
pdiv_inv_date
|
Invoice Date
|
|
99/99/99
|
|
|
|
pdiv_inv_nbr
|
Customer Invoice
|
|
x(22)
|
|
|
|
pdiv_lang
|
Language
|
|
x(2)
|
|
|
|
pdiv_matched
|
Matched
|
|
yes/no
|
|
|
|
pdiv_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
pdiv_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
pdiv_nbr
|
Invoice Number
|
|
x(20)
|
|
|
|
pdiv_post_block
|
Post Blocked
|
|
yes/no
|
|
|
|
pdiv_posted
|
Posted
|
|
yes/no
|
|
|
|
pdiv_project
|
Project
|
|
x(8)
|
|
|
|
pdiv_rcp_date
|
Receipt Date
|
Rcpt
|
99/99/99
|
|
|
|
pdiv_rmks
|
Remarks
|
|
x(40)
|
|
|
|
pdiv_site
|
Site
|
|
x(8)
|
|
|
|
pdiv_tax_date
|
Tax Date
|
|
99/99/99
|
|
|
|
pdiv_tax_env
|
Tax Environment
|
|
x(16)
|
|
|
|
pdiv_tax_in
|
Tax Included
|
|
yes/no
|
|
|
|
pdiv_tax_usage
|
Tax Usage
|
|
x(8)
|
|
|
|
pdiv_taxable
|
Taxable
|
|
yes/no
|
|
|
|
pdiv_taxc
|
Tax Class
|
|
x(3)
|
|
|
|
pdiv_trl1_amt
|
Trailer 1 Amount
|
|
-zzzz,zzz,zz9.99
|
10
|
|
|
pdiv_trl1_cd
|
Trailer 1
|
|
x(2)
|
|
|
|
pdiv_trl2_amt
|
Trailer 2 Amount
|
|
-zzzz,zzz,zz9.99
|
10
|
|
|
pdiv_trl2_cd
|
Trailer 2
|
|
x(2)
|
|
|
|
pdiv_trl3_amt
|
Trailer 3 Amount
|
|
-zzzz,zzz,zz9.99
|
10
|
|
|
pdiv_trl3_cd
|
Trailer 3
|
|
x(2)
|
|
|
|
pdiv_type
|
Invoice Type
|
Inv Type
|
x(8)
|
|
|
|
pdiv_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
pdiv_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pdiv_mstr
|
yes
|
oid_pdiv_mstr
|
yes
|
no
|
|
∗
|
pdiv_cust
|
yes
|
pdiv_domain
|
yes
|
no
|
|
|
|
|
pdiv_cust
|
yes
|
no
|
|
|
|
|
pdiv_nbr
|
yes
|
no
|
|
|
pdiv_nbr
|
yes
|
pdiv_domain
|
yes
|
no
|
|
|
|
|
pdiv_nbr
|
yes
|
no
|
|
|
|
|
pdiv_cust
|
yes
|
no
|
|
|
pdiv_posted
|
no
|
pdiv_domain
|
yes
|
no
|
|
|
|
|
pdiv_posted
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CMask_ID
|
Link to CMask
|
|
-99999999999
|
|
|
|
Company_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
Period_ID
|
Record ID
|
|
-99999999999
|
|
|
|
PeriodClosingDate
|
Closing Date
|
|
99/99/9999
|
|
|
|
PeriodClosingPOC
|
Closing POC
|
|
->>9.99
|
2
|
|
|
PeriodComment
|
Comment
|
|
x(255)
|
|
|
|
PeriodEndDate
|
End Date
|
|
99/99/9999
|
|
|
|
PeriodIsPostingGLAllowed
|
GL
|
|
yes/no
|
|
|
|
PeriodIsPostingInvAllowed
|
Inventory
|
|
yes/no
|
|
|
|
PeriodIsPostingOtherAllow
|
Other
|
|
yes/no
|
|
|
|
PeriodIsPostingPCAllowed
|
Periodic Costing
|
|
yes/no
|
|
|
|
PeriodIsPostingPurchAllow
|
Purchases
|
AP
|
yes/no
|
|
|
|
PeriodIsPostingSalesAllow
|
Sales
|
|
yes/no
|
|
|
|
PeriodIsReportChecked
|
Checked/Reported
|
|
yes/no
|
|
|
|
PeriodMark_ID
|
Mark
|
|
-99999999999
|
|
|
|
PeriodPeriod
|
GL Period
|
GL Pd
|
99
|
|
|
|
PeriodReportingPeriod
|
Reporting GL Period
|
|
x(20)
|
|
|
|
PeriodStartDate
|
Start Date
|
|
99/99/9999
|
|
|
|
PeriodStatus
|
Status
|
|
x(20)
|
|
|
|
PeriodTypeCode
|
GL Period Type
|
|
x(20)
|
|
|
|
PeriodYear
|
GL Calendar Year
|
GL Cal Year
|
9999
|
|
|
|
PeriodYearPeriod
|
GL Calendar Year/GL Period
|
GL Year/GL Pd
|
999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
AccYear
|
no
|
PeriodYear
|
yes
|
no
|
|
|
CMaskIdx
|
no
|
CMask_ID
|
yes
|
no
|
|
|
Company
|
no
|
Company_ID
|
yes
|
no
|
|
|
CompanyAndYearPeriod
|
yes
|
Company_ID
|
yes
|
no
|
|
|
|
|
PeriodYearPeriod
|
yes
|
no
|
|
|
CompanyPeriodEndDate
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
PeriodEndDate
|
yes
|
no
|
|
|
EndDate
|
no
|
PeriodEndDate
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
|
Period
|
no
|
PeriodPeriod
|
yes
|
no
|
|
|
PeriodMark
|
no
|
PeriodMark_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
Period_ID
|
yes
|
no
|
|
|
StartDate
|
no
|
PeriodStartDate
|
yes
|
no
|
|
|
StatusClosing
|
no
|
PeriodStatus
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
Company_ID
|
yes
|
no
|
|
|
|
|
PeriodYear
|
yes
|
no
|
|
|
|
|
PeriodPeriod
|
yes
|
no
|
|
|
YearPeriod
|
no
|
PeriodYearPeriod
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Company_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
PeriodMark_ID
|
Record ID
|
|
-99999999999
|
|
|
|
PeriodMarkCode
|
Mark
|
|
x(40)
|
|
|
|
PeriodMarkDescription
|
Description
|
|
x(60)
|
|
|
|
PeriodMarkIsActive
|
Active
|
|
yes/no
|
|
|
|
PeriodMarkSequence
|
Sequence
|
Seq
|
->,>>>,>>9
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Company
|
no
|
Company_ID
|
yes
|
no
|
|
|
CompanyAndCode
|
yes
|
Company_ID
|
yes
|
no
|
|
|
|
|
PeriodMarkCode
|
yes
|
no
|
|
|
CompanyAndSequence
|
yes
|
Company_ID
|
yes
|
no
|
|
|
|
|
PeriodMarkSequence
|
yes
|
no
|
|
|
IsActive
|
no
|
PeriodMarkIsActive
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
PeriodMark_ID
|
yes
|
no
|
|
|
ViewIndex
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
PeriodMarkIsActive
|
yes
|
no
|
|
|
|
|
PeriodMarkCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pfc_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pfc__qadc01
|
|
|
x(8)
|
|
|
|
pfc_date
|
Date
|
Date
|
99/99/99
|
|
|
|
pfc_domain
|
Domain
|
|
x(8)
|
|
|
|
pfc_id_num
|
|
|
>>>>>>9
|
|
|
|
pfc_part
|
Item Number
|
|
x(18)
|
|
|
|
pfc_peg_part
|
Peg Item
|
Peg Item Number
|
x(18)
|
|
|
|
pfc_qty
|
Qty
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
pfc_site
|
Site
|
|
x(8)
|
|
|
|
pfc_user1
|
Ufld1
|
|
x(8)
|
|
|
|
pfc_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pfc_det
|
yes
|
oid_pfc_det
|
yes
|
no
|
|
|
pfc_id_num
|
no
|
pfc_domain
|
yes
|
no
|
|
|
|
|
pfc_id_num
|
yes
|
no
|
|
∗
|
pfc_part
|
yes
|
pfc_domain
|
yes
|
no
|
|
|
|
|
pfc_part
|
yes
|
no
|
|
|
|
|
pfc_site
|
yes
|
no
|
|
|
|
|
pfc_peg_part
|
yes
|
no
|
|
|
|
|
pfc_date
|
yes
|
no
|
|
|
pfc_peg_part
|
no
|
pfc_domain
|
yes
|
no
|
|
|
|
|
pfc_peg_part
|
yes
|
no
|
|
|
|
|
pfc_site
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pfd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pfd__chr01
|
Character Field 1
|
|
X(8)
|
|
|
|
pfd__chr02
|
Character Field 2
|
|
X(8)
|
|
|
|
pfd__dte01
|
Date Field 1
|
|
99/99/99
|
|
|
|
pfd__dte02
|
Date Field 2
|
|
99/99/99
|
|
|
|
pfd__int01
|
Integer Field 1
|
|
->,>>>,>>9
|
|
|
|
pfd__int02
|
Integer Field 2
|
|
->,>>>,>>9
|
|
|
|
pfd__log01
|
Logical Field 1
|
|
yes/no
|
|
|
|
pfd__log02
|
Logical Field 2
|
|
yes/no
|
|
|
|
pfd__qadc01
|
QAD Character Field 1
|
|
X(8)
|
|
|
|
pfd__qadc02
|
QAD Character Field 2
|
|
X(8)
|
|
|
|
pfd__qadd01
|
QAD Date Field 1
|
|
99/99/99
|
|
|
|
pfd__qadi01
|
QAD Integer Field 1
|
|
->,>>>,>>9
|
|
|
|
pfd__qadi02
|
QAD Integer Field 2
|
|
->,>>>,>>9
|
|
|
|
pfd__qadl01
|
QAD Logical Field 1
|
|
yes/no
|
|
|
|
pfd__qadl02
|
QAD Logical Field 2
|
|
yes/no
|
|
|
|
pfd_bench_lead
|
Repair Lead Time
|
Rp Tm
|
>>>9
|
|
|
|
pfd_cover
|
Subs Covered
|
|
yes/no
|
|
|
|
pfd_cus_install
|
Customer Installable
|
|
yes/no
|
|
|
|
pfd_domain
|
Domain
|
|
x(8)
|
|
|
|
pfd_field_lead
|
Field Repair Time
|
|
>,>>9.99<<
|
10
|
|
|
pfd_fru
|
FRU
|
|
yes/no
|
|
|
|
pfd_ins_bom
|
Installation BOM
|
|
X(18)
|
|
|
|
pfd_ins_route
|
Installation Routing
|
|
X(18)
|
|
|
|
pfd_inst_call
|
Install
|
|
yes/no
|
|
|
|
pfd_isb
|
Installed Base
|
Inst Base
|
yes/no
|
|
|
|
pfd_life_cycle
|
Life Cycle
|
|
x(8)
|
|
|
|
pfd_mfg_mtbf
|
MFG MTBF
|
|
->>,>>9.99
|
10
|
|
|
pfd_mfg_mttr
|
MFG MTTR
|
|
->>,>>9.99
|
10
|
|
|
pfd_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
pfd_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
pfd_mtbf
|
MTBF
|
|
>>,>>9.99
|
10
|
|
|
pfd_mttr
|
MTTR
|
|
>>,>>9.99
|
10
|
|
|
pfd_obs_date
|
Obsolete Date
|
|
99/99/99
|
|
|
|
pfd_origin
|
Country of Origin
|
|
x(12)
|
|
|
|
pfd_part
|
Item
|
|
x(18)
|
|
|
|
pfd_pm_mrp
|
Need PM MRP
|
|
yes/no
|
|
|
|
pfd_pvm_bom
|
PM BOM
|
|
x(18)
|
|
|
|
pfd_pvm_days
|
Days Between PM
|
PM Days
|
>>>>9
|
|
|
|
pfd_pvm_exceed
|
Replace if Limit Exceeded
|
|
yes/no
|
|
|
|
pfd_pvm_limit
|
PM Limit
|
|
>>>>,>>>,>>9.99<<
|
10
|
|
|
pfd_pvm_replace
|
Always Replace on PM
|
|
yes/no
|
|
|
|
pfd_pvm_route
|
PM Routing
|
|
x(18)
|
|
|
|
pfd_pvm_saftey
|
Saftey Limit
|
|
>>>>,>>>,>99.99<<<
|
10
|
|
|
pfd_pvm_um
|
UM
|
|
x(8)
|
0
|
|
|
pfd_repairable
|
Repairable
|
|
yes/no
|
|
|
|
pfd_rp_bom
|
Repair BOM
|
|
x(18)
|
|
|
|
pfd_rp_route
|
Repair Routing
|
|
x(18)
|
|
|
|
pfd_rp_site
|
Repair Site
|
|
x(8)
|
|
|
|
pfd_rp_vendor
|
Repair Supplier
|
Supplier
|
x(8)
|
|
|
|
pfd_site
|
Site
|
|
x(8)
|
|
|
|
pfd_sttr
|
STTR
|
|
->>,>>9.99
|
10
|
|
|
pfd_svc_group
|
Service Group
|
Svc Grp
|
x(8)
|
|
|
|
pfd_tariff
|
Tariff
|
|
x(8)
|
0
|
|
|
pfd_trace_active
|
Trace Active
|
|
yes/no
|
|
|
|
pfd_unit_isb
|
Isb Unit Quantity
|
|
yes/no
|
|
|
|
pfd_user1
|
Ufld1
|
|
x(8)
|
|
|
|
pfd_user2
|
Ufld2
|
|
x(8)
|
|
|
|
pfd_ven_warr
|
Supplier Warranty
|
Sup!Warr
|
yes/no
|
|
|
|
pfd_warr_cd
|
Warranty Code
|
Warr Cd
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pfd_det
|
yes
|
oid_pfd_det
|
yes
|
no
|
|
|
pfd_pm_mrp
|
no
|
pfd_domain
|
yes
|
no
|
|
|
|
|
pfd_pm_mrp
|
yes
|
no
|
|
|
|
|
pfd_part
|
yes
|
no
|
|
|
|
|
pfd_site
|
yes
|
no
|
|
∗
|
pfd_ptsite
|
yes
|
pfd_domain
|
yes
|
no
|
|
|
|
|
pfd_part
|
yes
|
no
|
|
|
|
|
pfd_site
|
yes
|
no
|
|
|
pfd_sitept
|
no
|
pfd_domain
|
yes
|
no
|
|
|
|
|
pfd_site
|
yes
|
no
|
|
|
|
|
pfd_part
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pgc_ctrl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pgc__qadc01
|
|
|
x(8)
|
|
|
|
pgc_addr
|
Pager Company
|
|
x(8)
|
|
|
|
pgc_append_ca
|
Append Call
|
|
yes/no
|
|
|
|
pgc_domain
|
Domain
|
|
x(8)
|
|
|
|
pgc_index
|
Index
|
|
>>9
|
|
|
|
pgc_paged_status
|
Paged Status
|
|
x(8)
|
|
|
|
pgc_phone
|
Pager Number
|
|
x(20)
|
|
|
|
pgc_port1
|
Program
|
|
x(32)
|
|
|
|
pgc_port2
|
Parameter
|
|
x(32)
|
|
|
|
pgc_port3
|
Port #3
|
|
x(32)
|
|
|
|
pgc_port4
|
Port #4
|
|
x(32)
|
|
|
|
pgc_post_control
|
After Phone Number
|
|
x(18)
|
|
|
|
pgc_pre_control
|
Before Phone Number
|
|
x(18)
|
|
|
|
pgc_program
|
Program
|
|
x(16)
|
|
|
|
pgc_user1
|
Ufld1
|
|
x(8)
|
|
|
|
pgc_user2
|
Ufld2
|
|
x(8)
|
|
|
|
pgc_wait_status
|
Waiting for Page Status
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pgc_ctrl
|
yes
|
oid_pgc_ctrl
|
yes
|
no
|
|
∗
|
pgc_index
|
yes
|
pgc_domain
|
yes
|
no
|
|
|
|
|
pgc_index
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pgh_hist
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pgh__chr01
|
User Character Field 1
|
|
X(8)
|
|
|
|
pgh__chr02
|
User Character Field 2
|
|
X(8)
|
|
|
|
pgh__dte01
|
User Date Field 1
|
|
99/99/99
|
|
|
|
pgh__log01
|
User Logical Field 1
|
|
yes/no
|
|
|
|
pgh__qadc01
|
QAD Character Field 1
|
|
X(8)
|
|
|
|
pgh__qadc02
|
QAD Character Field 2
|
|
X(8)
|
|
|
|
pgh__qadl01
|
QAD Logical Field 1
|
|
yes/no
|
|
|
|
pgh__qadt01
|
QAD Date Field 1
|
|
99/99/99
|
|
|
|
pgh_ca_nbr
|
Call Number
|
|
x(8)
|
|
|
|
pgh_date
|
Date
|
|
99/99/99
|
|
|
|
pgh_domain
|
Domain
|
|
x(8)
|
|
|
|
pgh_eng_code
|
Engineer
|
|
x(8)
|
|
|
|
pgh_phone
|
Phone
|
|
x(20)
|
|
|
|
pgh_status
|
Status
|
|
x(8)
|
|
|
|
pgh_time_init
|
Time
|
|
99:99
|
|
|
|
pgh_time_paged
|
Time Paged
|
|
99:99
|
|
|
|
pgh_trnbr
|
Transaction
|
|
>>>>>>>>>9
|
|
|
|
pgh_user1
|
Ufld1
|
|
x(8)
|
|
|
|
pgh_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pgh_hist
|
yes
|
oid_pgh_hist
|
yes
|
no
|
|
|
pgh_ca_nbr
|
no
|
pgh_domain
|
yes
|
no
|
|
|
|
|
pgh_ca_nbr
|
yes
|
no
|
|
|
|
|
pgh_date
|
yes
|
no
|
|
|
|
|
pgh_time_init
|
yes
|
no
|
|
|
pgh_eng_code
|
no
|
pgh_domain
|
yes
|
no
|
|
|
|
|
pgh_eng_code
|
yes
|
no
|
|
|
|
|
pgh_date
|
yes
|
no
|
|
|
|
|
pgh_time_init
|
yes
|
no
|
|
|
pgh_status
|
no
|
pgh_domain
|
yes
|
no
|
|
|
|
|
pgh_status
|
yes
|
no
|
|
∗
|
pgh_trnbr
|
yes
|
pgh_domain
|
yes
|
no
|
|
|
|
|
pgh_trnbr
|
no
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pgm_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pgm__qadc01
|
|
|
x(8)
|
|
|
|
pgm_cmmt[20]
|
Program Data
|
|
x(76)
|
|
|
|
pgm_desc
|
Description
|
|
x(24)
|
|
|
|
pgm_domain
|
Domain
|
|
x(8)
|
|
|
|
pgm_eq
|
Equation Name
|
Eq Name
|
x(8)
|
|
|
|
pgm_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
pgm_ref
|
Program Reference
|
|
x(40)
|
|
|
|
pgm_seq
|
Page
|
|
>9
|
|
|
|
pgm_type
|
Type
|
T
|
x(2)
|
|
|
|
pgm_user1
|
Ufld1
|
|
x(8)
|
|
|
|
pgm_user2
|
Ufld2
|
|
x(8)
|
|
|
|
pgm_userid
|
User ID
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pgm_det
|
yes
|
oid_pgm_det
|
yes
|
no
|
|
∗
|
pgm_ref_eq
|
yes
|
pgm_domain
|
yes
|
no
|
|
|
|
|
pgm_ref
|
yes
|
no
|
|
|
|
|
pgm_eq
|
yes
|
no
|
|
|
|
|
pgm_type
|
yes
|
no
|
|
|
|
|
pgm_seq
|
yes
|
no
|
|
|
pgm_type_eq
|
no
|
pgm_domain
|
yes
|
no
|
|
|
|
|
pgm_type
|
yes
|
no
|
|
|
|
|
pgm_eq
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pic_ctrl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pic__qadc01
|
|
|
x(8)
|
|
|
|
pic__qadi01
|
|
|
->>>>>>>9
|
|
|
|
pic_cust_regen
|
Customers
|
|
yes/no
|
|
|
|
pic_disc_comb
|
Discount Combination Type
|
|
x(24)
|
|
|
|
pic_domain
|
Domain
|
|
x(8)
|
|
|
|
pic_fs_date
|
FSM Default Pricing Date
|
|
x(24)
|
|
|
|
pic_fs_fact
|
Display FSM Discounts as
|
|
yes/no
|
|
|
|
pic_fs_linpri
|
Price Contracts by Line
|
|
yes/no
|
|
|
|
pic_fs_rfact
|
FSM Factor Rounding
|
|
>>9
|
|
|
|
pic_item_regen
|
Items
|
|
yes/no
|
|
|
|
pic_list_id
|
Next Price List ID
|
|
>>>>>>>9
|
|
|
|
pic_po_date
|
PO Default Price Date
|
|
x(24)
|
|
|
|
pic_po_fact
|
Display PO Discounts as
|
|
yes/no
|
|
|
|
pic_po_linpri
|
Price PO by Line
|
|
yes/no
|
|
|
|
pic_po_rfact
|
PO Factor Rounding
|
|
>>9
|
|
|
|
pic_promo_pre
|
Promotions Prefix
|
|
x(3)
|
|
|
|
pic_qo_date
|
QO Default Price Date
|
|
x(24)
|
|
|
|
pic_qo_fact
|
Display QO Discounts as
|
|
yes/no
|
|
|
|
pic_qo_linpri
|
Price QO by Line
|
|
yes/no
|
|
|
|
pic_qo_rfact
|
QO Factor Rounding
|
|
>>9
|
|
|
|
pic_so_date
|
SO Default Pricing Date
|
|
x(24)
|
|
|
|
pic_so_fact
|
Display SO Discounts as
|
|
yes/no
|
|
|
|
pic_so_linpri
|
Price SO by Line
|
|
yes/no
|
|
|
|
pic_so_rfact
|
SO Factor Rounding
|
|
>>9
|
|
|
|
pic_user1
|
Ufld1
|
|
x(8)
|
|
|
|
pic_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pic_ctrl
|
yes
|
oid_pic_ctrl
|
yes
|
no
|
|
∗
|
pic_index1
|
yes
|
pic_domain
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pid_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pid__qadc01
|
|
|
x(8)
|
|
|
|
pid__qadd01
|
|
|
->>>,>>>,>>9.9<<<
|
10
|
|
|
pid_amt
|
Amount
|
|
->>>,>>>,>>9.9<<<
|
10
|
|
|
pid_cr_terms
|
Credit Terms
|
Terms
|
x(8)
|
|
|
|
pid_domain
|
Domain
|
|
x(8)
|
|
|
|
pid_fr_list
|
Freight List
|
Frt List
|
x(8)
|
|
|
|
pid_fr_terms
|
Freight Terms
|
|
x(8)
|
|
|
|
pid_list_id
|
List Id
|
|
x(8)
|
|
|
|
pid_qty
|
Min Qty
|
|
->>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
pid_user1
|
Ufld1
|
|
x(8)
|
|
|
|
pid_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pid_det
|
yes
|
oid_pid_det
|
yes
|
no
|
|
∗
|
pid_list_id
|
yes
|
pid_domain
|
yes
|
no
|
|
|
|
|
pid_list_id
|
yes
|
no
|
|
|
|
|
pid_qty
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pigc_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pigc__qadc01
|
|
|
x(8)
|
|
|
|
pigc__qadc02
|
|
|
x(8)
|
|
|
|
pigc__qadc03
|
|
|
x(8)
|
|
|
|
pigc__qadd01
|
|
|
->>>>,>>>,>>9.9
|
10
|
|
|
pigc__qadd02
|
|
|
->>>>,>>>,>>9.9
|
10
|
|
|
pigc__qadi01
|
|
|
->,>>>,>>9
|
|
|
|
pigc__qadi02
|
|
|
->,>>>,>>9
|
|
|
|
pigc__qadl01
|
|
|
yes/no
|
|
|
|
pigc__qadl02
|
|
|
yes/no
|
|
|
|
pigc__qadt01
|
|
|
99/99/99
|
|
|
|
pigc__qadt02
|
|
|
99/99/99
|
|
|
|
pigc_amt_type
|
Amount Type
|
|
x(24)
|
|
|
|
pigc_code
|
Price List Group
|
|
x(8)
|
|
|
|
pigc_curr
|
Currency
|
Cur
|
X(3)
|
|
|
|
pigc_div
|
Division
|
|
x(8)
|
|
|
|
pigc_domain
|
Domain
|
|
x(8)
|
|
|
|
pigc_expire
|
Expire
|
|
99/99/99
|
|
|
|
pigc_include
|
Include
|
|
yes/no
|
|
|
|
pigc_mem_ref
|
Member Reference
|
|
x(8)
|
|
|
|
pigc_mem_type
|
Member Type
|
|
>>>9
|
|
|
|
pigc_srch_type
|
Search Type
|
|
>>9
|
|
|
|
pigc_start
|
Start
|
|
99/99/99
|
|
|
|
pigc_user1
|
Ufld1
|
|
x(8)
|
|
|
|
pigc_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pigc_det
|
yes
|
oid_pigc_det
|
yes
|
no
|
|
∗
|
pigc_code
|
yes
|
pigc_domain
|
yes
|
no
|
|
|
|
|
pigc_code
|
yes
|
no
|
|
|
|
|
pigc_mem_type
|
yes
|
no
|
|
|
|
|
pigc_mem_ref
|
yes
|
no
|
|
|
|
|
pigc_amt_type
|
yes
|
no
|
|
|
pigc_member
|
no
|
pigc_domain
|
yes
|
no
|
|
|
|
|
pigc_div
|
yes
|
no
|
|
|
|
|
pigc_mem_type
|
yes
|
no
|
|
|
|
|
pigc_mem_ref
|
yes
|
no
|
|
|
|
|
pigc_srch_type
|
yes
|
no
|
|
|
|
|
pigc_curr
|
yes
|
no
|
|
|
|
|
pigc_start
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pigp_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pigp__qadc01
|
|
|
x(8)
|
|
|
|
pigp__qadc02
|
|
|
x(8)
|
|
|
|
pigp__qadc03
|
|
|
x(8)
|
|
|
|
pigp__qadd01
|
|
|
->>>>,>>>,>>9.9
|
10
|
|
|
pigp__qadd02
|
|
|
->>>>,>>>,>>9.9
|
10
|
|
|
pigp__qadi01
|
|
|
->,>>>,>>9
|
|
|
|
pigp__qadi02
|
|
|
->,>>>,>>9
|
|
|
|
pigp__qadl01
|
|
|
yes/no
|
|
|
|
pigp__qadl02
|
|
|
yes/no
|
|
|
|
pigp__qadt01
|
|
|
99/99/99
|
|
|
|
pigp__qadt02
|
|
|
99/99/99
|
|
|
|
pigp_amt_type
|
Amount Type
|
|
X(24)
|
|
|
|
pigp_code
|
Price List Group
|
|
x(8)
|
|
|
|
pigp_curr
|
Currency
|
Cur
|
X(3)
|
|
|
|
pigp_div
|
Division
|
|
X(8)
|
|
|
|
pigp_domain
|
Domain
|
|
x(8)
|
|
|
|
pigp_expire
|
Expire
|
|
99/99/9999
|
|
|
|
pigp_include
|
Include
|
|
yes/no
|
|
|
|
pigp_list_id
|
List ID
|
|
x(8)
|
|
|
|
pigp_prod_ref
|
Item Reference
|
|
X(18)
|
|
|
|
pigp_prod_type
|
Item Type
|
|
9
|
|
|
|
pigp_srch_type
|
Search Type
|
|
>>9
|
|
|
|
pigp_start
|
Start
|
|
99/99/99
|
|
|
|
pigp_user1
|
Ufld1
|
|
x(8)
|
|
|
|
pigp_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pigp_det
|
yes
|
oid_pigp_det
|
yes
|
no
|
|
∗
|
pigp_code
|
yes
|
pigp_domain
|
yes
|
no
|
|
|
|
|
pigp_code
|
yes
|
no
|
|
|
|
|
pigp_prod_type
|
yes
|
no
|
|
|
|
|
pigp_prod_ref
|
yes
|
no
|
|
|
|
|
pigp_amt_type
|
yes
|
no
|
|
|
pigp_product
|
no
|
pigp_domain
|
yes
|
no
|
|
|
|
|
pigp_div
|
yes
|
no
|
|
|
|
|
pigp_prod_type
|
yes
|
no
|
|
|
|
|
pigp_prod_ref
|
yes
|
no
|
|
|
|
|
pigp_srch_type
|
yes
|
no
|
|
|
|
|
pigp_curr
|
yes
|
no
|
|
|
|
|
pigp_start
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pig_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pig__qadc01
|
|
|
x(8)
|
|
|
|
pig__qadc02
|
|
|
x(8)
|
|
|
|
pig__qadc03
|
|
|
x(8)
|
|
|
|
pig__qadd01
|
|
|
->>>>,>>>,>>9.9
|
10
|
|
|
pig__qadd02
|
|
|
->>>>,>>>,>>9.9
|
10
|
|
|
pig__qadi01
|
|
|
->,>>>,>>9
|
|
|
|
pig__qadi02
|
|
|
->,>>>,>>9
|
|
|
|
pig__qadl01
|
|
|
yes/no
|
|
|
|
pig__qadl02
|
|
|
yes/no
|
|
|
|
pig__qadt01
|
|
|
99/99/99
|
|
|
|
pig__qadt02
|
|
|
99/99/99
|
|
|
|
pig_all_custs
|
All Customers
|
|
yes/no
|
|
|
|
pig_all_items
|
All Items
|
|
yes/no
|
|
|
|
pig_amt_type
|
Amount Type
|
|
x(24)
|
|
|
|
pig_code
|
Price List Group
|
|
x(8)
|
|
|
|
pig_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
pig_desc
|
Description
|
|
x(24)
|
|
|
|
pig_div
|
Division
|
|
x(8)
|
|
|
|
pig_domain
|
Domain
|
|
x(8)
|
|
|
|
pig_expire
|
Expire
|
|
99/99/99
|
|
|
|
pig_list
|
Price List
|
|
x(8)
|
|
|
|
pig_list_id
|
List ID
|
|
x(8)
|
|
|
|
pig_priority
|
Priority
|
|
>9
|
|
|
|
pig_ref_code
|
Reference
|
|
x(16)
|
|
|
|
pig_ref_type
|
Reference Type
|
|
99
|
|
|
|
pig_srch_type
|
Search Type
|
|
>>9
|
|
|
|
pig_start
|
Start
|
|
99/99/99
|
|
|
|
pig_user1
|
Ufld1
|
|
x(8)
|
|
|
|
pig_user2
|
Ufld2
|
|
x(8)
|
|
|
|
pig_val_type
|
Value Type
|
|
x(24)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pig_mstr
|
yes
|
oid_pig_mstr
|
yes
|
no
|
|
|
pig_all_custs
|
no
|
pig_domain
|
yes
|
no
|
|
|
|
|
pig_div
|
yes
|
no
|
|
|
|
|
pig_all_custs
|
yes
|
no
|
|
|
|
|
pig_srch_type
|
yes
|
no
|
|
|
|
|
pig_curr
|
yes
|
no
|
|
|
|
|
pig_start
|
yes
|
no
|
|
|
pig_all_items
|
no
|
pig_domain
|
yes
|
no
|
|
|
|
|
pig_div
|
yes
|
no
|
|
|
|
|
pig_all_items
|
yes
|
no
|
|
|
|
|
pig_srch_type
|
yes
|
no
|
|
|
|
|
pig_curr
|
yes
|
no
|
|
|
|
|
pig_start
|
yes
|
no
|
|
∗
|
pig_code
|
yes
|
pig_domain
|
yes
|
no
|
|
|
|
|
pig_code
|
yes
|
no
|
|
|
|
|
pig_amt_type
|
yes
|
no
|
|
|
pig_div_code
|
yes
|
pig_domain
|
yes
|
no
|
|
|
|
|
pig_div
|
yes
|
no
|
|
|
|
|
pig_code
|
yes
|
no
|
|
|
|
|
pig_amt_type
|
yes
|
no
|
|
|
pig_ref
|
no
|
pig_domain
|
yes
|
no
|
|
|
|
|
pig_ref_type
|
yes
|
no
|
|
|
|
|
pig_ref_code
|
yes
|
no
|
|
|
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
|
|
|
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
|