project QadFinancials > class BMfgProductLine > dataset BMfgProductLine

class dataset

object identification

primary key
pl_domain
pl_prod_line

table tpl_mstr


field namedata typemnd.description
pl_prod_linecharacter(30)yesProduct Line
pl_desccharacter(80)noDescription
pl_sls_acctcharacter(80)noSales Acct
pl_inv_acctcharacter(80)noInventory Acct
pl_wip_acctcharacter(80)noWork in Process Acct
pl_cog_acctcharacter(80)noCost of Goods Acct
pl_pur_acctcharacter(80)noPurchases Acct
pl_scrp_acctcharacter(80)noScrap Acct
pl_dscr_acctcharacter(80)noInv Discrep Acct
pl_sls_cccharacter(30)noSales Cost Ctr
pl_inv_cccharacter(30)noInventory Cost Ctr
pl_wip_cccharacter(30)noWIP Cost Ctr
pl_cog_cccharacter(30)noCOG Cost Ctr
pl_pur_cccharacter(30)noPurchases Cost Ctr
pl_scrp_cccharacter(30)noScrap Cost Ctr
pl_dscr_cccharacter(30)noInv Discrep Cost Ctr
pl_ppv_acctcharacter(80)noPO Price Var Acct
pl_ppv_cccharacter(30)noPO Price Var Cost Ctr
pl_rcpt_acctcharacter(80)noPO Receipts Acct
pl_rcpt_cccharacter(30)noPO Receipts Cost Ctr
pl_dsc_acctcharacter(80)noSales Disc Acct
pl_dsc_cccharacter(30)noSales Disc Ctr
pl_wvar_acctcharacter(80)noMethod Variance Acct
pl_wvar_cccharacter(30)noMethod Variance CC
pl_taxccharacter(30)noTax Class
pl_taxablelogicalnoTaxable
pl_user1character(80)noUfld1
pl_user2character(80)noUfld2
pl_pstlogicalnoPST Taxed
pl_esls_acctcharacter(80)noExempt Sales Acct
pl_esls_cccharacter(30)noExempt Sales Cost Ctr
pl__chr01character(80)no
pl__chr02character(80)no
pl__chr03character(80)no
pl__chr04character(80)no
pl__chr05character(80)no
pl__dte01dateno
pl__dte02dateno
pl__dec01decimal(10)no
pl__dec02decimal(10)no
pl__log01logicalno
pl_groupcharacter(80)noGroup
pl_divisioncharacter(80)no
pl_cchg_acctcharacter(80)noCost Revalue Acct
pl_cchg_cccharacter(30)noCost Revalue Cost Ctr
pl_cmtl_acctcharacter(80)noCOGS Material Acct
pl_cmtl_cccharacter(30)noCOGS Material CC
pl_clbr_acctcharacter(80)noCOGS Labor Acct
pl_clbr_cccharacter(30)noCOGS Labor CC
pl_cbdn_acctcharacter(80)noCOGS Burden Acct
pl_cbdn_cccharacter(30)noCOGS Burden CC
pl_covh_acctcharacter(80)noCOGS Overhead Acct
pl_covh_cccharacter(30)noCOGS Overhead CC
pl_csub_acctcharacter(80)noCOGS Subcontract Acct
pl_csub_cccharacter(30)noCOGS Subcontract CC
pl_apvr_acctcharacter(80)noAP Rate Var Acct
pl_apvr_cccharacter(30)noAP Rate Var Cost Ctr
pl_apvu_acctcharacter(80)noAP Usage Var Acct
pl_apvu_cccharacter(30)noAP Usage Var Cost Ctr
pl_ovh_acctcharacter(80)noOverhead Appl Acct
pl_ovh_cccharacter(30)noOverhead Appl CC
pl_mvar_acctcharacter(80)noMaterial Usage Var
pl_mvar_cccharacter(30)noMaterial Usage Variance CC
pl_mvrr_acctcharacter(80)noMaterial Rate Var
pl_mvrr_cccharacter(30)noMaterial Rate Variance CC
pl_svar_acctcharacter(80)noSubcontract Usage Var
pl_svar_cccharacter(30)noSubcontract Usage Variance CC
pl_svrr_acctcharacter(80)noSubcontract Rate Var
pl_svrr_cccharacter(30)noSubcontract Rate Variance CC
pl_cop_acctcharacter(80)noCost of Production
pl_cop_cccharacter(30)noCost of Prod CC
pl_flr_acctcharacter(80)noFloor Stock Account
pl_flr_cccharacter(30)noFloor Stock CC
pl_mod_datedatenoModified Date
pl_useridcharacter(80)noUser ID
pl__qadc08character(80)no
pl__qadc09character(80)no
pl__qadc14character(80)no
pl__qadc15character(80)no
pl_rmar_acctcharacter(80)noService Returns
pl_rmar_cccharacter(30)noRMA Return CC
pl__qadc12character(80)no
pl__qadc13character(80)no
pl__qadc06character(80)no
pl__qadc07character(80)no
pl_fiscal_classcharacter(30)noFiscal Class
pl_xvar_acctcharacter(80)noMix Var
pl_xvar_cccharacter(30)noMix Var CC
pl_fslbr_acctcharacter(80)noService Labor
pl_fsbdn_acctcharacter(80)noService Overhead
pl_fsexp_acctcharacter(80)noService Expense
pl_fsexd_acctcharacter(80)noExpense Due Employee
pl__qadc10character(80)no
pl_fslbr_cccharacter(30)noService Labor CC
pl_fsbdn_cccharacter(30)noService Overhead CC
pl__qadc11character(80)no
pl_fsexp_cccharacter(30)noService Expenses CC
pl_fsexd_cccharacter(30)noExpenses Due CC
pl_fsrc_inv_cccharacter(30)noRepair Center CC
pl_fscm_inv_acctcharacter(80)noCustomer Inventory
pl_fscm_inv_cccharacter(30)noCustomer Inventory CC
pl_fsrc_inv_acctcharacter(80)noRepair Center Inv
pl__qadc01character(80)noQAD Character Field 1
pl__qadc02character(80)noQAD Character Field 2
pl__qadc03character(80)noQAD Character Field 3
pl__qadc04character(80)noQAD Character Field 4
pl__qadc05character(80)noQAD Character Field 5
pl__qadl01logicalnoQAD Logical Field 1
pl__qadt01datenoQAD Date Field 1
pl__qadd01decimal(10)noQAD Decimal Field 1
pl_apvr_subcharacter(80)noAP Rate Var Sub-Acct
pl_apvu_subcharacter(80)noAP Usage Var Sub-Acct
pl_cbdn_subcharacter(80)noCOGS Burden Sub-Acct
pl_cchg_subcharacter(80)noCost Revalue Sub-Acct
pl_clbr_subcharacter(80)noCOGS Labor Sub-Acct
pl_cmtl_subcharacter(80)noCOGS Mtl Sub-Acct
pl_cog_subcharacter(80)noCOGS Sub-Acct
pl_cop_subcharacter(80)noCOP Sub-Acct
pl_covh_subcharacter(80)noCOGS Overhead Sub
pl_csub_subcharacter(80)noCOGS Subcontract Sub
pl_dscr_subcharacter(80)noInv Discrep Sub-Acct
pl_dsc_subcharacter(80)noSales Disc Sub-Acct
pl_flr_subcharacter(80)noFloor Stock Sub-Acct
pl_fsbdn_subcharacter(80)noService Overhead Sub
pl_fscm_inv_subcharacter(80)noCustomer Inv Sub-Acct
pl_fsexd_subcharacter(80)noExp Due Employee Sub
pl_fsexp_subcharacter(80)noService Exp Sub-Acct
pl_fslbr_subcharacter(80)noService Labor Sub-Acct
pl_fsrc_inv_subcharacter(80)noRepair Cent Inv Sub
pl_inv_subcharacter(80)noInventory Sub-Acct
pl_mvar_subcharacter(80)noMat Usage Var Sub
pl_mvrr_subcharacter(80)noMat Rate Var Sub
pl_ovh_subcharacter(80)noOverhead Appl Sub
pl_ppv_subcharacter(80)noPO Price Var Sub
pl_pur_subcharacter(80)noPurchases Sub-Acct
pl_rcpt_subcharacter(80)noPO Receipts Sub-Acct
pl_rmar_subcharacter(80)noService Returns Sub
pl_scrp_subcharacter(80)noScrap Sub-Acct
pl_sls_subcharacter(80)noSales Sub-Acct
pl_svar_subcharacter(80)noSub Usage Var Sub-Acct
pl_svrr_subcharacter(80)noSub Rate Var Sub-Acct
pl_wip_subcharacter(80)noWIP Sub-Acct
pl_wvar_subcharacter(80)noMethod Var Sub-Acct
pl_xvar_subcharacter(80)noMix Var Sub-Acct
pl_xfer_acctcharacter(80)noTransfer Variance Account
pl_xfer_subcharacter(80)noTransfer Variance Sub
pl_xfer_cccharacter(30)noTransfer Variance CC
pl_fsdef_acctcharacter(80)noDeferred Revenue
pl_fsdef_subcharacter(80)noDeferred Revenue Sub-Acct
pl_fsdef_cccharacter(30)noDeferred Revenue CC
pl_fsaccr_acctcharacter(80)noAccrued Revenue
pl_fsaccr_subcharacter(80)noAccrued Revenue Sub-Acct
pl_fsaccr_cccharacter(30)noAccrued Revenue CC
pl_domaincharacter(8)yesDomain
oid_pl_mstrdecimal(10)no
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacternoempty string
tc_Statuscharacternoupdate status

table tpld_det


field namedata typemnd.description
pld_prodlinecharacter(30)yesProduct Line
pld_sitecharacter(80)noSite
pld_loccharacter(80)noLocation
pld_inv_acctcharacter(80)noInventory Acct
pld_scrpacctcharacter(80)noScrap Acct
pld_dscracctcharacter(80)noInv Discrep Acct
pld_inv_cccharacter(30)noInventory Cost Ctr
pld_scrp_cccharacter(30)noScrap Cost Ctr
pld_dscr_cccharacter(30)noInv Discrep Cost Ctr
pld_user1character(80)noUfld1
pld_user2character(80)noUfld2
pld_useridcharacter(80)noUser ID
pld_mod_datedatenoModified Date
pld_cchg_acccharacter(80)noCost Revalue Acct
pld_cchg_cccharacter(30)noInv Cost Change Cost Ctr
pld__qadc01character(80)no
pld_cchg_subcharacter(80)noCost Revalue Sub-Acct
pld_dscr_subcharacter(80)noInv Discrep Sub-Acct
pld_inv_subcharacter(80)noInventory Sub-Acct
pld_scrp_subcharacter(80)noScrap Sub-Acct
pld_domaincharacter(8)yesDomain
oid_pld_detdecimal(10)no
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tpl_mstr.tc_Rowid
tc_Statuscharacternoupdate status

table tCustomTable0

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tCustomTable1

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tCustomTable2

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter