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 |