About This Guide > pl_mstr
  
pl_mstr
Product Line Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_pl_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
pl__chr01
 
 
x(8)
 
 
pl__chr02
 
 
x(8)
 
 
pl__chr03
 
 
x(8)
 
 
pl__chr04
 
 
x(8)
 
 
pl__chr05
 
 
x(8)
 
 
pl__dec01
 
 
>>>,>>>,>>9.99
10
 
pl__dec02
 
 
>>>,>>>,>>9.99
10
 
pl__dte01
 
 
99/99/99
 
 
pl__dte02
 
 
99/99/99
 
 
pl__log01
 
 
yes/no
 
 
pl__qadc01
QAD Character Field 1
 
X(8)
 
 
pl__qadc02
QAD Character Field 2
 
X(8)
 
 
pl__qadc03
QAD Character Field 3
 
X(8)
 
 
pl__qadc04
QAD Character Field 4
 
X(8)
 
 
pl__qadc05
QAD Character Field 5
 
X(8)
 
 
pl__qadc06
 
 
x(8)
 
 
pl__qadc07
 
 
x(4)
 
 
pl__qadc08
 
 
x(8)
 
 
pl__qadc09
 
 
x(4)
 
 
pl__qadc10
 
 
x(8)
 
 
pl__qadc11
 
 
x(4)
 
 
pl__qadc12
 
 
x(8)
 
 
pl__qadc13
 
 
x(4)
 
 
pl__qadc14
 
 
x(8)
 
 
pl__qadc15
 
 
x(4)
 
 
pl__qadd01
QAD Decimal Field 1
 
->>,>>9.99
10
 
pl__qadl01
QAD Logical Field 1
 
yes/no
 
 
pl__qadt01
QAD Date Field 1
 
99/99/99
 
 
pl_apvr_acct
AP Rate Var Acct
AP Rate
x(8)
 
 
pl_apvr_cc
AP Rate Var Cost Ctr
CC
x(4)
 
 
pl_apvr_sub
AP Rate Var Sub-Acct
Sub-Acct
x(8)
 
 
pl_apvu_acct
AP Usage Var Acct
AP Usage
x(8)
 
 
pl_apvu_cc
AP Usage Var Cost Ctr
CC
x(4)
 
 
pl_apvu_sub
AP Usage Var Sub-Acct
Sub-Acct
x(8)
 
 
pl_cbdn_acct
COGS Burden Acct
COGS-Bdn
x(8)
 
 
pl_cbdn_cc
COGS Burden CC
CC
x(4)
 
 
pl_cbdn_sub
COGS Burden Sub-Acct
Sub-Acct
x(8)
 
 
pl_cchg_acct
Cost Revalue Acct
Revalue
x(8)
 
 
pl_cchg_cc
Cost Revalue Cost Ctr
CC
x(4)
 
 
pl_cchg_sub
Cost Revalue Sub-Acct
Sub-Acct
x(8)
 
 
pl_clbr_acct
COGS Labor Acct
COGS-Lbr
x(8)
 
 
pl_clbr_cc
COGS Labor CC
CC
x(4)
 
 
pl_clbr_sub
COGS Labor Sub-Acct
Sub-Acct
x(8)
 
 
pl_cmtl_acct
COGS Material Acct
COGS-Mtl
x(8)
 
 
pl_cmtl_cc
COGS Material CC
CC
x(4)
 
 
pl_cmtl_sub
COGS Mtl Sub-Acct
Sub-Acct
x(8)
 
 
pl_cog_acct
Cost of Goods Acct
COGS
x(8)
 
 
pl_cog_cc
COG Cost Ctr
CC
x(4)
 
 
pl_cog_sub
COGS Sub-Acct
Sub-Acct
x(8)
 
 
pl_cop_acct
Cost of Production
COP
x(8)
 
 
pl_cop_cc
Cost of Prod CC
CC
x(4)
 
 
pl_cop_sub
COP Sub-Acct
Sub-Acct
x(8)
 
 
pl_covh_acct
COGS Overhead Acct
COGS-Ovh
x(8)
 
 
pl_covh_cc
COGS Overhead CC
CC
x(4)
 
 
pl_covh_sub
COGS Overhead Sub
Sub-Acct
x(8)
 
 
pl_csub_acct
COGS Subcontract Acct
COGS-Sub
x(8)
 
 
pl_csub_cc
COGS Subcontract CC
CC
x(4)
 
 
pl_csub_sub
COGS Subcontract Sub
Sub-Acct
x(8)
 
 
pl_desc
Description
 
x(24)
 
 
pl_division
 
 
x(8)
 
 
pl_domain
Domain
 
x(8)
 
 
pl_dsc_acct
Sales Disc Acct
Disc Acct
x(8)
 
 
pl_dsc_cc
Sales Disc Ctr
CC
x(4)
 
 
pl_dsc_sub
Sales Disc Sub-Acct
Sub-Acct
x(8)
 
 
pl_dscr_acct
Inv Discrep Acct
Discrep
x(8)
 
 
pl_dscr_cc
Inv Discrep Cost Ctr
CC
x(4)
 
 
pl_dscr_sub
Inv Discrep Sub-Acct
Sub-Acct
x(8)
 
 
pl_esls_acct
Exempt Sales Acct
 
x(8)
 
 
pl_esls_cc
Exempt Sales Cost Ctr
 
x(4)
 
 
pl_fiscal_class
Fiscal Class
 
x(18)
 
 
pl_flr_acct
Floor Stock Account
Flr Acct
x(8)
 
 
pl_flr_cc
Floor Stock CC
CC
x(4)
 
 
pl_flr_sub
Floor Stock Sub-Acct
Sub-Acct
x(8)
 
 
pl_fsaccr_acct
Accrued Revenue
Accrued
x(8)
 
 
pl_fsaccr_cc
Accrued Revenue CC
 
x(4)
 
 
pl_fsaccr_sub
Accrued Revenue Sub-Acct
 
x(8)
 
 
pl_fsbdn_acct
Service Overhead
Ovh
x(8)
 
 
pl_fsbdn_cc
Service Overhead CC
CC
x(4)
 
 
pl_fsbdn_sub
Service Overhead Sub
Sub-Acct
x(8)
 
 
pl_fscm_inv_acct
Customer Inventory
Cus Inv
x(8)
 
 
pl_fscm_inv_cc
Customer Inventory CC
CC
x(4)
 
 
pl_fscm_inv_sub
Customer Inv Sub-Acct
Sub-Acct
x(8)
 
 
pl_fsdef_acct
Deferred Revenue
Deferred
x(8)
 
 
pl_fsdef_cc
Deferred Revenue CC
 
x(4)
 
 
pl_fsdef_sub
Deferred Revenue Sub-Acct
 
x(8)
 
 
pl_fsexd_acct
Expense Due Employee
 
x(8)
 
 
pl_fsexd_cc
Expenses Due CC
CC
x(4)
 
 
pl_fsexd_sub
Exp Due Employee Sub
Sub-Acct
x(8)
 
 
pl_fsexp_acct
Service Expense
Sv Exp
x(8)
 
 
pl_fsexp_cc
Service Expenses CC
CC
x(4)
 
 
pl_fsexp_sub
Service Exp Sub-Acct
Sub-Acct
x(8)
 
 
pl_fslbr_acct
Service Labor
Svc Lbr
x(8)
 
 
pl_fslbr_cc
Service Labor CC
CC
x(4)
 
 
pl_fslbr_sub
Service Labor Sub-Acct
Sub-Acct
x(8)
 
 
pl_fsrc_inv_acct
Repair Center Inv
 
x(8)
 
 
pl_fsrc_inv_cc
Repair Center CC
CC
x(4)
 
 
pl_fsrc_inv_sub
Repair Cent Inv Sub
Sub-Acct
x(8)
 
 
pl_group
Group
 
x(8)
 
 
pl_inv_acct
Inventory Acct
Inventory
x(8)
 
 
pl_inv_cc
Inventory Cost Ctr
CC
x(4)
 
 
pl_inv_sub
Inventory Sub-Acct
Sub-Acct
x(8)
 
 
pl_mod_date
Modified Date
Mod Date
99/99/99
 
 
pl_mvar_acct
Material Usage Var
Mtl Use
x(8)
 
 
pl_mvar_cc
Material Usage Variance CC
CC
x(4)
 
 
pl_mvar_sub
Mat Usage Var Sub
Sub-Acct
x(8)
 
 
pl_mvrr_acct
Material Rate Var
Mtl Rate
x(8)
 
 
pl_mvrr_cc
Material Rate Variance CC
CC
x(4)
 
 
pl_mvrr_sub
Mat Rate Var Sub
Sub-Acct
x(8)
 
 
pl_ovh_acct
Overhead Appl Acct
Overhead
x(8)
 
 
pl_ovh_cc
Overhead Appl CC
CC
x(4)
 
 
pl_ovh_sub
Overhead Appl Sub
Sub-Acct
x(8)
 
 
pl_ppv_acct
PO Price Var Acct
PO Var
x(8)
 
 
pl_ppv_cc
PO Price Var Cost Ctr
CC
x(4)
 
 
pl_ppv_sub
PO Price Var Sub
Sub-Acct
x(8)
 
 
pl_prod_line
Product Line
Line
x(4)
 
 
pl_pst
PST Taxed
 
yes/no
 
 
pl_pur_acct
Purchases Acct
Purchases
x(8)
 
 
pl_pur_cc
Purchases Cost Ctr
CC
x(4)
 
 
pl_pur_sub
Purchases Sub-Acct
Sub-Acct
x(8)
 
 
pl_rcpt_acct
PO Receipts Acct
PO Rct
x(8)
 
 
pl_rcpt_cc
PO Receipts Cost Ctr
CC
x(4)
 
 
pl_rcpt_sub
PO Receipts Sub-Acct
Sub-Acct
x(8)
 
 
pl_rmar_acct
Service Returns
 
x(8)
0
 
pl_rmar_cc
RMA Return CC
CC
x(4)
 
 
pl_rmar_sub
Service Returns Sub
Sub-Acct
x(8)
 
 
pl_scrp_acct
Scrap Acct
Scrap
x(8)
 
 
pl_scrp_cc
Scrap Cost Ctr
CC
x(4)
 
 
pl_scrp_sub
Scrap Sub-Acct
Sub-Acct
x(8)
 
 
pl_sls_acct
Sales Acct
Sales
x(8)
 
 
pl_sls_cc
Sales Cost Ctr
CC
x(4)
 
 
pl_sls_sub
Sales Sub-Acct
Sub-Acct
x(8)
 
 
pl_svar_acct
Subcontract Usage Var
Sub Use
x(8)
 
 
pl_svar_cc
Subcontract Usage Variance CC
CC
x(4)
 
 
pl_svar_sub
Sub Usage Var Sub-Acct
Sub-Acct
x(8)
 
 
pl_svrr_acct
Subcontract Rate Var
Sub Rate
x(8)
 
 
pl_svrr_cc
Subcontract Rate Variance CC
CC
x(4)
 
 
pl_svrr_sub
Sub Rate Var Sub-Acct
Sub-Acct
x(8)
 
 
pl_taxable
Taxable
Tax
yes/no
 
 
pl_taxc
Tax Class
TxC
x(3)
 
 
pl_user1
Ufld1
 
x(8)
 
 
pl_user2
Ufld2
 
x(8)
 
 
pl_userid
User ID
 
x(8)
 
 
pl_wip_acct
Work in Process Acct
WIP
x(8)
 
 
pl_wip_cc
WIP Cost Ctr
CC
x(4)
 
 
pl_wip_sub
WIP Sub-Acct
Sub-Acct
x(8)
 
 
pl_wvar_acct
Method Variance Acct
Mthd Var
x(8)
 
 
pl_wvar_cc
Method Variance CC
CC
x(4)
 
 
pl_wvar_sub
Method Var Sub-Acct
Sub-Acct
x(8)
 
 
pl_xfer_acct
Transfer Variance Account
Account
x(8)
 
 
pl_xfer_cc
Transfer Variance CC
CC
x(4)
 
 
pl_xfer_sub
Transfer Variance Sub
Sub-Acct
x(8)
 
 
pl_xvar_acct
Mix Var
Mix
x(8)
 
 
pl_xvar_cc
Mix Var CC
CC
x(4)
 
 
pl_xvar_sub
Mix Var Sub-Acct
Sub-Acct
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_pl_mstr
yes
oid_pl_mstr
yes
no
 
pl_desc
yes
pl_domain
yes
no
 
 
 
pl_desc
yes
no
 
 
 
pl_prod_line
yes
no
pl_prod_line
yes
pl_domain
yes
no
 
 
 
pl_prod_line
yes
no