| field name | data type | db field | description |
|---|
| tdoid_pl_mstr | decimal | pl_mstr.oid_pl_mstr | |
| tcpl_apvr_acct | character | pl_mstr.pl_apvr_acct | AP Rate Var Acct |
| tcpl_apvr_cc | character | pl_mstr.pl_apvr_cc | AP Rate Var Cost Ctr |
| tcpl_apvr_sub | character | pl_mstr.pl_apvr_sub | AP Rate Var Sub-Acct |
| tcpl_apvu_acct | character | pl_mstr.pl_apvu_acct | AP Usage Var Acct |
| tcpl_apvu_cc | character | pl_mstr.pl_apvu_cc | AP Usage Var Cost Ctr |
| tcpl_apvu_sub | character | pl_mstr.pl_apvu_sub | AP Usage Var Sub-Acct |
| tcpl_cbdn_acct | character | pl_mstr.pl_cbdn_acct | COGS Burden Acct |
| tcpl_cbdn_cc | character | pl_mstr.pl_cbdn_cc | COGS Burden CC |
| tcpl_cbdn_sub | character | pl_mstr.pl_cbdn_sub | COGS Burden Sub-Acct |
| tcpl_cchg_acct | character | pl_mstr.pl_cchg_acct | Cost Revalue Acct |
| tcpl_cchg_cc | character | pl_mstr.pl_cchg_cc | Cost Revalue Cost Ctr |
| tcpl_cchg_sub | character | pl_mstr.pl_cchg_sub | Cost Revalue Sub-Acct |
| tcpl_clbr_acct | character | pl_mstr.pl_clbr_acct | COGS Labor Acct |
| tcpl_clbr_cc | character | pl_mstr.pl_clbr_cc | COGS Labor CC |
| tcpl_clbr_sub | character | pl_mstr.pl_clbr_sub | COGS Labor Sub-Acct |
| tcpl_cmtl_acct | character | pl_mstr.pl_cmtl_acct | COGS Material Acct |
| tcpl_cmtl_cc | character | pl_mstr.pl_cmtl_cc | COGS Material CC |
| tcpl_cmtl_sub | character | pl_mstr.pl_cmtl_sub | COGS Mtl Sub-Acct |
| tcpl_cog_acct | character | pl_mstr.pl_cog_acct | Cost of Goods Acct |
| tcpl_cog_cc | character | pl_mstr.pl_cog_cc | COG Cost Ctr |
| tcpl_cog_sub | character | pl_mstr.pl_cog_sub | COGS Sub-Acct |
| tcpl_cop_acct | character | pl_mstr.pl_cop_acct | Cost of Production |
| tcpl_cop_cc | character | pl_mstr.pl_cop_cc | Cost of Prod CC |
| tcpl_cop_sub | character | pl_mstr.pl_cop_sub | COP Sub-Acct |
| tcpl_covh_acct | character | pl_mstr.pl_covh_acct | COGS Overhead Acct |
| tcpl_covh_cc | character | pl_mstr.pl_covh_cc | COGS Overhead CC |
| tcpl_covh_sub | character | pl_mstr.pl_covh_sub | COGS Overhead Sub |
| tcpl_csub_acct | character | pl_mstr.pl_csub_acct | COGS Subcontract Acct |
| tcpl_csub_cc | character | pl_mstr.pl_csub_cc | COGS Subcontract CC |
| tcpl_csub_sub | character | pl_mstr.pl_csub_sub | COGS Subcontract Sub |
| tcpl_desc | character | pl_mstr.pl_desc | Description |
| tcpl_division | character | pl_mstr.pl_division | |
| tcpl_domain | character | pl_mstr.pl_domain | Domain |
| tcpl_dsc_acct | character | pl_mstr.pl_dsc_acct | Sales Disc Acct |
| tcpl_dsc_cc | character | pl_mstr.pl_dsc_cc | Sales Disc Ctr |
| tcpl_dsc_sub | character | pl_mstr.pl_dsc_sub | Sales Disc Sub-Acct |
| tcpl_dscr_acct | character | pl_mstr.pl_dscr_acct | Inv Discrep Acct |
| tcpl_dscr_cc | character | pl_mstr.pl_dscr_cc | Inv Discrep Cost Ctr |
| tcpl_dscr_sub | character | pl_mstr.pl_dscr_sub | Inv Discrep Sub-Acct |
| tcpl_esls_acct | character | pl_mstr.pl_esls_acct | Exempt Sales Acct |
| tcpl_esls_cc | character | pl_mstr.pl_esls_cc | Exempt Sales Cost Ctr |
| tcpl_fiscal_class | character | pl_mstr.pl_fiscal_class | Fiscal Class |
| tcpl_flr_acct | character | pl_mstr.pl_flr_acct | Floor Stock Account |
| tcpl_flr_cc | character | pl_mstr.pl_flr_cc | Floor Stock CC |
| tcpl_flr_sub | character | pl_mstr.pl_flr_sub | Floor Stock Sub-Acct |
| tcpl_fsaccr_acct | character | pl_mstr.pl_fsaccr_acct | Accrued Revenue |
| tcpl_fsaccr_cc | character | pl_mstr.pl_fsaccr_cc | Accrued Revenue CC |
| tcpl_fsaccr_sub | character | pl_mstr.pl_fsaccr_sub | Accrued Revenue Sub-Acct |
| tcpl_fsbdn_acct | character | pl_mstr.pl_fsbdn_acct | Service Overhead |
| tcpl_fsbdn_cc | character | pl_mstr.pl_fsbdn_cc | Service Overhead CC |
| tcpl_fsbdn_sub | character | pl_mstr.pl_fsbdn_sub | Service Overhead Sub |
| tcpl_fscm_inv_acct | character | pl_mstr.pl_fscm_inv_acct | Customer Inventory |
| tcpl_fscm_inv_cc | character | pl_mstr.pl_fscm_inv_cc | Customer Inventory CC |
| tcpl_fscm_inv_sub | character | pl_mstr.pl_fscm_inv_sub | Customer Inv Sub-Acct |
| tcpl_fsdef_acct | character | pl_mstr.pl_fsdef_acct | Deferred Revenue |
| tcpl_fsdef_cc | character | pl_mstr.pl_fsdef_cc | Deferred Revenue CC |
| tcpl_fsdef_sub | character | pl_mstr.pl_fsdef_sub | Deferred Revenue Sub-Acct |
| tcpl_fsexd_acct | character | pl_mstr.pl_fsexd_acct | Expense Due Employee |
| tcpl_fsexd_cc | character | pl_mstr.pl_fsexd_cc | Expenses Due CC |
| tcpl_fsexd_sub | character | pl_mstr.pl_fsexd_sub | Exp Due Employee Sub |
| tcpl_fsexp_acct | character | pl_mstr.pl_fsexp_acct | Service Expense |
| tcpl_fsexp_cc | character | pl_mstr.pl_fsexp_cc | Service Expenses CC |
| tcpl_fsexp_sub | character | pl_mstr.pl_fsexp_sub | Service Exp Sub-Acct |
| tcpl_fslbr_acct | character | pl_mstr.pl_fslbr_acct | Service Labor |
| tcpl_fslbr_cc | character | pl_mstr.pl_fslbr_cc | Service Labor CC |
| tcpl_fslbr_sub | character | pl_mstr.pl_fslbr_sub | Service Labor Sub-Acct |
| tcpl_fsrc_inv_acct | character | pl_mstr.pl_fsrc_inv_acct | Repair Center Inv |
| tcpl_fsrc_inv_cc | character | pl_mstr.pl_fsrc_inv_cc | Repair Center CC |
| tcpl_fsrc_inv_sub | character | pl_mstr.pl_fsrc_inv_sub | Repair Cent Inv Sub |
| tcpl_group | character | pl_mstr.pl_group | Group |
| tcpl_inv_acct | character | pl_mstr.pl_inv_acct | Inventory Acct |
| tcpl_inv_cc | character | pl_mstr.pl_inv_cc | Inventory Cost Ctr |
| tcpl_inv_sub | character | pl_mstr.pl_inv_sub | Inventory Sub-Acct |
| ttpl_mod_date | date | pl_mstr.pl_mod_date | Modified Date |
| tcpl_mvar_acct | character | pl_mstr.pl_mvar_acct | Material Usage Var |
| tcpl_mvar_cc | character | pl_mstr.pl_mvar_cc | Material Usage Variance CC |
| tcpl_mvar_sub | character | pl_mstr.pl_mvar_sub | Mat Usage Var Sub |
| tcpl_mvrr_acct | character | pl_mstr.pl_mvrr_acct | Material Rate Var |
| tcpl_mvrr_cc | character | pl_mstr.pl_mvrr_cc | Material Rate Variance CC |
| tcpl_mvrr_sub | character | pl_mstr.pl_mvrr_sub | Mat Rate Var Sub |
| tcpl_ovh_acct | character | pl_mstr.pl_ovh_acct | Overhead Appl Acct |
| tcpl_ovh_cc | character | pl_mstr.pl_ovh_cc | Overhead Appl CC |
| tcpl_ovh_sub | character | pl_mstr.pl_ovh_sub | Overhead Appl Sub |
| tcpl_ppv_acct | character | pl_mstr.pl_ppv_acct | PO Price Var Acct |
| tcpl_ppv_cc | character | pl_mstr.pl_ppv_cc | PO Price Var Cost Ctr |
| tcpl_ppv_sub | character | pl_mstr.pl_ppv_sub | PO Price Var Sub |
| tcpl_prod_line | character | pl_mstr.pl_prod_line | Product Line |
| tlpl_pst | logical | pl_mstr.pl_pst | PST Taxed |
| tcpl_pur_acct | character | pl_mstr.pl_pur_acct | Purchases Acct |
| tcpl_pur_cc | character | pl_mstr.pl_pur_cc | Purchases Cost Ctr |
| tcpl_pur_sub | character | pl_mstr.pl_pur_sub | Purchases Sub-Acct |
| tcpl_rcpt_acct | character | pl_mstr.pl_rcpt_acct | PO Receipts Acct |
| tcpl_rcpt_cc | character | pl_mstr.pl_rcpt_cc | PO Receipts Cost Ctr |
| tcpl_rcpt_sub | character | pl_mstr.pl_rcpt_sub | PO Receipts Sub-Acct |
| tcpl_rmar_acct | character | pl_mstr.pl_rmar_acct | Service Returns |
| tcpl_rmar_cc | character | pl_mstr.pl_rmar_cc | RMA Return CC |
| tcpl_rmar_sub | character | pl_mstr.pl_rmar_sub | Service Returns Sub |
| tcpl_scrp_acct | character | pl_mstr.pl_scrp_acct | Scrap Acct |
| tcpl_scrp_cc | character | pl_mstr.pl_scrp_cc | Scrap Cost Ctr |
| tcpl_scrp_sub | character | pl_mstr.pl_scrp_sub | Scrap Sub-Acct |
| tcpl_sls_acct | character | pl_mstr.pl_sls_acct | Sales Acct |
| tcpl_sls_cc | character | pl_mstr.pl_sls_cc | Sales Cost Ctr |
| tcpl_sls_sub | character | pl_mstr.pl_sls_sub | Sales Sub-Acct |
| tcpl_svar_acct | character | pl_mstr.pl_svar_acct | Subcontract Usage Var |
| tcpl_svar_cc | character | pl_mstr.pl_svar_cc | Subcontract Usage Variance CC |
| tcpl_svar_sub | character | pl_mstr.pl_svar_sub | Sub Usage Var Sub-Acct |
| tcpl_svrr_acct | character | pl_mstr.pl_svrr_acct | Subcontract Rate Var |
| tcpl_svrr_cc | character | pl_mstr.pl_svrr_cc | Subcontract Rate Variance CC |
| tcpl_svrr_sub | character | pl_mstr.pl_svrr_sub | Sub Rate Var Sub-Acct |
| tlpl_taxable | logical | pl_mstr.pl_taxable | Taxable |
| tcpl_taxc | character | pl_mstr.pl_taxc | Tax Class |
| tcpl_wip_acct | character | pl_mstr.pl_wip_acct | Work in Process Acct |
| tcpl_wip_cc | character | pl_mstr.pl_wip_cc | WIP Cost Ctr |
| tcpl_wip_sub | character | pl_mstr.pl_wip_sub | WIP Sub-Acct |
| tcpl_wvar_acct | character | pl_mstr.pl_wvar_acct | Method Variance Acct |
| tcpl_wvar_cc | character | pl_mstr.pl_wvar_cc | Method Variance CC |
| tcpl_wvar_sub | character | pl_mstr.pl_wvar_sub | Method Var Sub-Acct |
| tcpl_xfer_acct | character | pl_mstr.pl_xfer_acct | Transfer Variance Account |
| tcpl_xfer_cc | character | pl_mstr.pl_xfer_cc | Transfer Variance CC |
| tcpl_xfer_sub | character | pl_mstr.pl_xfer_sub | Transfer Variance Sub |
| tcpl_xvar_acct | character | pl_mstr.pl_xvar_acct | Mix Var |
| tcpl_xvar_cc | character | pl_mstr.pl_xvar_cc | Mix Var CC |
| tcpl_xvar_sub | character | pl_mstr.pl_xvar_sub | Mix Var Sub-Acct |
each pl_mstr where