project QadFinancials > class BMfgItem > dataset BMfgItem

class dataset

object identification

primary key
pt_domain
pt_part

table tpt_mstr


field namedata typemnd.description
pt_partcharacter(30)yesItem Number
pt_desc1character(80)noDescription
pt_desc2character(80)noDescription
pt_umcharacter(30)noUM
pt__qad13character(30)noIncorp Rev
pt__qad12decimal(10)no
pt_drawcharacter(30)noDrawing
pt_prod_linecharacter(30)noProd Line
pt_groupcharacter(80)noGroup
pt_part_typecharacter(80)noItem Type
pt_statuscharacter(80)noStatus
pt_abccharacter(30)noABC Class
pt_iss_pollogicalnoIssue Policy
pt_phantomlogicalnoPhantom
pt_loccharacter(80)noLocation
pt__qad01decimal(10)no
pt__qad02decimal(10)no
pt_abc_amtdecimal(10)noABC Value
pt__qad03decimal(10)no
pt__qad04decimal(10)no
pt_avg_intintegernoAvg Int
pt__qad05dateno
pt_cyc_intintegernoCyc Cnt Int
pt__qad06dateno
pt__qad07dateno
pt__qad08dateno
pt_mslogicalnoMaster Sched
pt_plan_ordlogicalnoPlan Orders
pt_mrplogicalnoMRP Required
pt_ord_polcharacter(30)noOrder Policy
pt_ord_qtydecimal(10)noOrder Qty
pt_ord_perintegernoOrder Period
pt_sfty_stkdecimal(0)noSafety Stk
pt_sfty_timedecimal(0)noSafety Time
pt_ropdecimal(0)noReorder Point
pt_buyercharacter(80)noBuyer/Planner
pt_vendcharacter(80)noSupplier
pt__qad09decimal(10)no
pt_pm_codecharacter(30)noPur/Mfg
pt_mfg_leaddecimal(0)noMfg LT
pt_pur_leadintegernoPur LT
pt_insp_rqdlogicalnoInspect
pt_insp_leadintegernoIns LT
pt_cum_leadintegernoCum LT
pt_ord_mindecimal(0)noMin Ord
pt_ord_maxdecimal(0)noMax Ord
pt_ord_multdecimal(0)noOrd Mult
pt_yield_pctdecimal(10)noYield%
pt__qad16decimal(0)no
pt_setupdecimal(10)noSetup Time
pt_setup_lldecimal(10)noSetup LL
pt_run_lldecimal(10)noRun LL
pt_rundecimal(10)noRun Time
pt_pricedecimal(10)noPrice
pt_xmtl_tldecimal(10)noCur Matl TL
pt_xlbr_tldecimal(10)noCur Labor TL
pt_xbdn_tldecimal(10)noCur Burden TL
pt_xsub_tldecimal(10)noCur Sub TL
pt_xmtl_lldecimal(10)noCur Matl LL
pt_xlbr_lldecimal(10)noCur Labor LL
pt_xbdn_lldecimal(10)noCur Burden LL
pt_xsub_lldecimal(10)noCur Sub LL
pt_xtot_curdecimal(10)noTotal TL & LL
pt_cur_datedatenoCur Cost Update
pt_xmtl_stdtldecimal(10)noStd Matl TL
pt_xlbr_stdtldecimal(10)noStd Labor TL
pt_xbdn_stdtldecimal(10)noStd Burden TL
pt_xsub_stdtldecimal(10)noStd Sub TL
pt_xtot_stddecimal(10)noStd Total
pt_std_datedatenoStd Cost Update
pt_ll_codeintegernoLow Level
pt_abc_qtydecimal(10)noABC Quantity
pt__qad10decimal(10)no
pt__qad11decimal(10)no
pt_routingcharacter(30)noRouting Code
pt_lot_sercharacter(30)noLot/Serial Control
pt_timefenceintegernoTime Fence
pt_xmtl_stdlldecimal(10)noStd Mtl LL
pt_xlbr_stdlldecimal(10)noStd Lbr LL
pt_xbdn_stdlldecimal(10)noStd Burden LL
pt_xsub_stdlldecimal(10)noStd Sub LL
pt_revcharacter(30)noRev
pt_last_ecodatenoLast ECO
pt__qad15logicalno
pt__qad17logicalno
pt_qc_leadintegernoQC LT
pt_auto_lotlogicalnoAuto Lot Numbers
pt_assaydecimal(10)noAssay %
pt_batchdecimal(10)noBatch Qty
pt__qad14dateno
pt_user3character(80)noUser3
pt_user1character(80)noUfld1
pt_user2character(80)noUfld2
pt_net_wtdecimal(10)noNet Weight
pt_net_wt_umcharacter(30)noNet Weight UM
pt_sizedecimal(10)noSize
pt_size_umcharacter(30)noSize UM
pt_taxablelogicalnoTax
pt_taxccharacter(30)noTax Class
pt_rolluplogicalnoRollup Reqd
pt_xovh_lldecimal(10)noCur Ovhead LL
pt_xovh_tldecimal(10)noCur Ovhead TL
pt_xovh_stdlldecimal(10)noStd Ovhead LL
pt_xovh_stdtldecimal(10)noStd Ovhead TL
pt_sitecharacter(80)noSite
pt_shelflifeintegernoShelf Life
pt_criticallogicalnoKey Item
pt_sngl_lotlogicalnoAllocate Single Lot
pt_upccharacter(30)noUPC
pt_hazardcharacter(80)noHazard
pt_addeddatenoAdded
pt__chr01character(80)no
pt__chr02character(80)no
pt__chr03character(80)no
pt__chr04character(80)no
pt__chr05character(80)no
pt__chr06character(80)no
pt__chr07character(80)no
pt__chr08character(80)no
pt__chr09character(80)no
pt__chr10character(80)no
pt__dte01dateno
pt__dte02dateno
pt__dec01decimal(10)no
pt__dec02decimal(10)no
pt__log01logicalno
pt__log02logicalno
pt__qad18decimal(10)no
pt__qad21decimal(10)no
pt__qad19decimal(10)no
pt__qad20decimal(10)no
pt_lengthdecimal(10)noLength
pt_heightdecimal(10)noHeight
pt_widthdecimal(10)noWidth
pt_dim_umcharacter(30)noDimensns UM
pt_pkg_codecharacter(30)noPkg Code
pt_networkcharacter(30)noNetwork Code
pt_ll_drpintegernoDRP Low Level
pt_fr_classcharacter(80)noFreight Class
pt_spec_hdlgcharacter(80)noSpecial Handling Code
pt_bom_codecharacter(30)noBOM/Formula
pt_loc_typecharacter(80)noLocation Type
pt_transtypecharacter(80)noTransport Type
pt_covercharacter(30)noCoverage
pt_unit_isblogicalnoIsb Unit Quantity
pt_articlecharacter(30)noArticle Number
pt_po_sitecharacter(80)noPO Site
pt_ship_wtdecimal(10)noShip Weight
pt_ship_wt_umcharacter(30)noShip Weight UM
pt_formulalogicalnoFormula
pt_dealogicalnoDEA Controlled
pt__qad26logicalno
pt__qad22logicalno
pt__qad25integerno
pt__qad24integerno
pt__qad23integerno
pt_comm_codecharacter(80)noCommodity Code
pt_inst_calllogicalnoInstall
pt_sys_typecharacter(30)noSystem Type
pt_tariffcharacter(80)noTariff
pt_origincharacter(30)noCountry of Origin
pt_sttrdecimal(10)noSTTR
pt_mfg_mtbfdecimal(10)noMFG MTBF
pt_mfg_mttrdecimal(10)noMFG MTTR
pt_frulogicalnoFRU
pt_ven_warrlogicalnoSupplier Warranty
pt_svc_groupcharacter(80)noService Group
pt_svc_typecharacter(30)noService Type
pt_mtbfdecimal(10)noMTBF
pt_mttrdecimal(10)noMTTR
pt_isblogicalnoInstalled Base
pt_pvm_daysintegernoDays Between PM
pt_warr_cdcharacter(80)noWarranty Code
pt_mod_datedatenoModified Date
pt_useridcharacter(80)noUser ID
pt_obs_datedatenoObsolete Date
pt_pvm_bomcharacter(30)noPM BOM
pt_pvm_routecharacter(30)noPM Routing
pt_pvm_umcharacter(30)noUM
pt_rp_bomcharacter(30)noRepair BOM
pt_rp_routecharacter(30)noRepair Routing
pt_rp_vendorcharacter(80)noRepair Supplier
pt_rctpo_statuscharacter(80)noPO Rcpt Status
pt_rollup_idcharacter(80)noRollup ID
pt_spec_gravdecimal(10)noSpecific Gravity
pt_joint_typecharacter(30)noCo/By Type
pt_mfg_pctdecimal(10)noManufactured
pt_pur_pctdecimal(10)noPurchased
pt_drp_pctdecimal(10)noDRP
pt_pou_codecharacter(30)noPoint of Use Code
pt_wks_avgdecimal(10)noAverage Weeks of Coverage
pt_wks_maxdecimal(10)noMaximum Weeks of Coverage
pt_wks_mindecimal(10)noMinimum Weeks of Coverage
pt_pick_logicintegernoPick Logic
pt_fiscal_classcharacter(30)noFiscal Class
pt_dsgn_grpcharacter(80)noDesign Group
pt_drwg_loccharacter(80)noDrawing Loc
pt_ecn_revcharacter(30)noECN Rev
pt_drwg_sizecharacter(30)noDrwg Size
pt_modelcharacter(30)noModel
pt_repairablelogicalnoRepairable
pt_rctwo_statuscharacter(80)noWO Rcpt Status
pt_lot_grpcharacter(80)noLot Group
pt_rctpo_activelogicalnoActive
pt_rctwo_activelogicalnoActive
pt_break_catcharacter(30)noPrice Break Cat
pt_fsc_codecharacter(80)noService Category
pt_trace_activelogicalnoTrace Active
pt_trace_detaillogicalnoTrace Detail
pt_pm_mrplogicalnoNeed PM MRP
pt_ins_call_typecharacter(80)noInstallation Call Type
pt_ins_bomcharacter(30)noInstallation BOM
pt_ins_routecharacter(30)noInstallation Routing
pt_promocharacter(80)noPromotion Group
pt_meter_intervaldecimal(10)noMeter Interval
pt_meter_umcharacter(30)noMeter UM
pt_whlogicalnoWarehoused Item
pt_btb_typecharacter(30)noEMT Type
pt_cfg_typecharacter(30)noConfiguration
pt_app_ownercharacter(30)noOwner Application
pt_op_yieldlogicalnoOp Based Yield
pt_run_seq1character(80)noRun Seq 1
pt_run_seq2character(80)no2
pt_atp_enforcementcharacter(30)noATP Enforcement
pt_atp_familylogicalnoFamily ATP
pt_domaincharacter(8)yesDomain
oid_pt_mstrdecimal(10)no
pt_classificationcharacter(12)noClassification
pt_memo_typecharacter(1)noMemo Order Type
pt_um_groupcharacter(16)noUM Group
pt_opc_thresholddecimal(10)noOPC Threshold
pt_pop_codecharacter(16)noPopularity
pt_whse_part_typecharacter(16)noWarehouse Item Type
pt_issue_methodcharacter(16)noIssue Method
pt_rep_typecharacter(16)noReplenishment Type
pt_crit_daysintegernoCritical Days
pt_shelf_offsetintegernoShelf Life Offset
pt_single_translogicalnoSingle Put-Away Transactions
pt_print_idlogicalnoPrint ID
pt_id_qtyintegernoID Quantity
pt_insp_reqlogicalnoInspection Required
pt_sample_qtyintegernoSample Quantity
pt_sample_pctintegernoSample %
pt_insp_freqintegernoInsp Frequency
pt_destructivelogicalnoDestructive
pt_insp_daysintegernoInsp Frequency (Days)
pt_barcode1character(80)noBarcode 1
pt_barcode2character(80)noBarcode 2
pt_insp_reflogicalnoRef
pt_random_insp_pctdecimal(10)noRandom Inspection %
pt_atp_horizonintegernoATP Horizon
pt_gcfg_typecharacter(8)noConfiguration Type
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacternoempty string
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