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