|
|
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
|