QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
pckc_mstr
Pack Codes Definition
 
 
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
pcld_det
Product Change Control Group Detail
 
 
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
pcl_mstr
Product Change Control Group Master
 
 
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
pcsc_ctrl
Control file to help setup parameters for Periodic Costing
 
 
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
pctrop_det
Periodic costing side table
 
 
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
pct_mstr
Product Change Control Type Master
 
 
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
pc_mstr
Price List Master
 
 
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
pdivd_det
Pending Invoices Detail
 
 
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
pdiv_mstr
Pending Invoices Master
 
 
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
Period
GL Period
 
 
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
PeriodMark
Period Mark
 
 
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
pfc_det
Production Forecast Detail
 
 
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
pfd_det
Service/Support Item-Site Detail
 
 
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
pgc_ctrl
Service/Support Paging Control
 
 
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
pgh_hist
Service/Support Paging History
 
 
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
pgm_det
Program Detail
 
 
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
pic_ctrl
Pricing Control
 
 
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
pid_det
Price List Detail
 
 
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
pigc_det
Price List Group Customer Detail
 
 
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
pigp_det
Price List Group Item Detail
 
 
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
pig_mstr
Price List Group Master
 
 
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
pih_hist
Pricing History
 
 
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
pi_mstr
Price List Master
 
 
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