project QadFinancials > class BMfgPO > dataset BMfgPO

class dataset

object identification

primary key
po_domain
po_nbr

table tpo_mstr


field namedata typemnd.description
po_nbrcharacter(80)yesPurchase Order
po_vendcharacter(80)noSupplier
po_shipcharacter(80)noShip-To
po_ord_datedatenoOrder Date
po_rmkscharacter(80)noRemarks
po_cr_termscharacter(80)noCredit Terms
po_buyercharacter(80)noBuyer
po_shipviacharacter(30)noShip Via
po_fobcharacter(30)noFOB
po_billcharacter(80)noBill-To
po__qad04logicalno
po_partiallogicalnoPartial OK
po_revdecimal(10)noOrder Revision
po_statcharacter(30)noStatus
po_ap_acctcharacter(80)noAP Acct
po_ap_cccharacter(30)noCost Ctr
po_frtdecimal(10)noFreight
po_serv_chgdecimal(10)noService Charge
po_spec_chgdecimal(10)noSpecial Charge
po_disc_pctdecimal(10)noDisc %
po_prepaiddecimal(10)noAmount Prepaid
po_contactcharacter(30)noContact
po_confirmlogicalnoConfirming
po_cmtindxintegernoComment Index
po_printlogicalnoPrint PO
po_cls_datedatenoClose Date
po_taxablelogicalnoTaxable
po_user1character(80)noUfld1
po_user2character(80)noUfld2
po_currcharacter(30)noCurrency
po_ex_ratedecimal(10)noExch Rate
po_langcharacter(30)noLanguage
po_fst_idcharacter(30)noFST ID
po_pst_idcharacter(30)noPST ID
po_pstlogicalnoPST
po_duty_typecharacter(30)noDuty Type
po__qad05decimal(10)no
po__qad07character(80)no
po__qad08character(30)no
po_sitecharacter(80)noSite
po_blanketcharacter(80)noBlanket Order
po_rev_datedatenoOrder Revision Date
po__qad02integerno
po__qad03character(80)no
po_contractcharacter(30)noContract
po_del_tocharacter(30)noDeliver To
po_due_datedatenoDue Date
po_eff_strtdatenoStart Effective
po_eff_todatenoEnd Effective
po_est_valuedecimal(10)noEst Value
po__qad06logicalno
po_projectcharacter(80)noProject
po_rel_nbrintegernoRel
po_req_idcharacter(80)noReq By
po_typecharacter(30)noType
po_user_idcharacter(80)noEntered By
po__qad09decimal(10)no
po_releaselogicalnoRelease
po_recurrlogicalnoRecurr
po_cyclcharacter(30)noCycle Code
po__chr01character(80)no
po__chr02character(80)no
po__chr03character(80)no
po__chr04character(80)no
po__chr05character(80)no
po__chr06character(80)no
po__chr07character(80)no
po__chr08character(80)no
po__chr09character(80)no
po__chr10character(80)no
po__dte01dateno
po__dte02dateno
po__dec01decimal(10)no
po__dec02decimal(10)no
po__log01logicalno
po_inv_mthdcharacter(80)noInvoices Via
po_fix_ratelogicalnoFixed Rate
po_ent_exdecimal(10)noExch Rate
po_tax_datedatenoTax Date
po_fsm_typecharacter(80)noFSM Type
po_bankcharacter(30)noBank
po_pr_listcharacter(80)noDisc Tbl
po_tax_envcharacter(30)noTax Environment
po_schedlogicalnoScheduled
po_pr_list2character(80)noPrice Tbl
po_tax_usagecharacter(80)noTax Usage
po_fix_prlogicalnoFixed Price
po_sch_mthdcharacter(30)noSchedules Via
po_taxccharacter(30)noTax Class
po_priced_dtdatenoLast Price Dt
po_pricing_dtdatenoPricing Date
po_ers_optcharacter(30)noERS Option
po_pr_lst_tpintegernoERS Price List Option
po_consign_cost_pointcharacter(80)noPO Cost Point
po__qadc02character(80)noQAD Field
po__qadd01decimal(10)noQAD Field
po__qadd02decimal(10)noQAD Field
po_zero_schedintegernoZero Schedules
po__qadi02integernoQAD Field
po_so_nbrcharacter(80)noPrimary SO
po_is_btblogicalnoEMT PO
po_so_holdlogicalnoSecondary SO Cr Hold
po_xmitcharacter(30)noTransm
po_ex_rate2decimal(10)noExch Rate 2
po_ex_ratetypecharacter(80)noRate Type
po_exru_seqintegernoSequence
po_ap_subcharacter(80)noAP Sub-Acct
po_crt_intdecimal(10)noCredit Terms Int
po_consignmentlogicalnoConsignment
po_max_aging_daysintegernoMaximum Aging Days
po_app_ownercharacter(30)noOwner Application
po_tot_terms_codecharacter(80)noTerms of Trade
po_translt_daysdecimal(10)noTransport Days
po_domaincharacter(8)yesDomain
oid_po_mstrdecimal(10)no
po_trade_salelogicalnoTrade Sales Contract
po_trade_sale_socharacter(16)noTrade Sales SO
po_incl_isslogicalnoInclude Saturday/Sunday
po__qadc03character(24)no
po__qadi03integernoQAD Field
po__qadt01dateno
po_daybooksetcharacter(8)noDaybook Set
po_nrmcharacter(8)noSequence ID
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacternoempty string
tc_Statuscharacternoupdate status

table tpod_det


field namedata typemnd.description
pod_nbrcharacter(80)yesPurchase Order
pod_due_datedatenoDue Date
pod_lineintegernoLine
pod_partcharacter(30)noItem Number
pod_qty_orddecimal(10)noQty Ordered
pod_qty_rcvddecimal(10)noQty Received
pod_pur_costdecimal(10)noPurchase Cost
pod_std_costdecimal(10)noStd Cost
pod_so_jobcharacter(80)noSales/Job
pod_qty_chgdecimal(10)noReceipt Qty
pod_cost_chgdecimal(10)noReceipt Cost
pod_bo_chgdecimal(10)noQty B/O
pod_acctcharacter(80)noPur Acct
pod_per_datedatenoPerform Date
pod_typecharacter(30)noType
pod_insp_rqdlogicalnoInspect Req
pod_wo_lotcharacter(80)noWork Order ID
pod_vpartcharacter(80)noSupplier Item
pod_needdatenoNeed Date
pod_taxablelogicalnoTaxable
pod_desccharacter(80)noDescription
pod_cccharacter(30)noCost Ctr
pod_umcharacter(30)noUM
pod_disc_pctdecimal(10)noDisc%
pod_req_nbrcharacter(80)noReq
pod__qad10character(80)no
pod_um_convdecimal(10)noUM Conversion
pod_loccharacter(80)noLocation
pod_serialcharacter(50)noLot/Serial
pod_opintegernoOperation
pod_contractcharacter(80)noContract
pod_statuscharacter(30)noStatus
pod_revcharacter(30)noItem Revision
pod_cmtindxintegernoComment Index
pod_req_lineintegernoReq Line
pod_projectcharacter(80)noProject
pod_ps_chgdecimal(10)noPacking Slip Qty
pod_cst_uplogicalnoUpdate Current Cost
pod_rumcharacter(30)noUM
pod_user1character(80)noUfld1
pod_user2character(80)noUfld2
pod_vatlogicalnoVAT
pod__qad16character(80)no
pod__qad06character(30)no
pod_pstlogicalnoPST
pod__qad13logicalno
pod__qad07character(30)no
pod_pay_umcharacter(30)noPay UM
pod_pum_convdecimal(10)noPay UM Conv
pod__qad15logicalno
pod_sitecharacter(80)noSite
pod_rum_convdecimal(10)noUM Conversion
pod_qty_rtnddecimal(10)noQty Returned
pod_blanketcharacter(80)noBlanket
pod_blnkt_lnintegernoBlanket Line
pod_item_rev_datedatenoItem Revision Date
pod__qad02integerno
pod__qad03character(80)no
pod__qad05logicalno
pod__qad08dateno
pod__qad09integerno
pod__qad11character(80)no
pod__qad12logicalno
pod__qad14dateno
pod_rel_nbrintegernoRel
pod_rel_qtydecimal(10)noQty Released
pod_reasoncharacter(80)noReason
pod_requestcharacter(80)noRequested By
pod_approvecharacter(80)noApproved By
pod__chr01character(80)no
pod__chr02character(80)no
pod__chr03character(80)no
pod__chr04character(80)no
pod__chr05character(80)no
pod__chr06character(80)no
pod__chr07character(80)no
pod__chr08character(80)no
pod__chr09character(80)no
pod__chr10character(80)no
pod__dte01dateno
pod__dte02dateno
pod__dec01decimal(10)no
pod__dec02decimal(10)no
pod__log01logicalno
pod_rma_typecharacter(30)noRMA Type
pod_tax_maxdecimal(10)noMax Taxable Amount
pod_contr_idcharacter(80)noContract ID
pod_apr_codecharacter(80)noApproval Code
pod_taxccharacter(30)noTax Class
pod_po_sitecharacter(80)noPO Site
pod_po_dbcharacter(80)noPO Database
pod_firm_weeksintegernoFirm Weeks
pod_mrp_pctdecimal(10)noSupply Percent
pod_raw_weeksintegernoRaw Auth Weeks
pod_fab_weeksintegernoFab Auth Weeks
pod_plan_weeksintegernoPlan Sched Weeks
pod_schedlogicalnoScheduled
pod_ord_multdecimal(0)noStd Pack Qty
pod_pkg_codecharacter(30)noPkg Code
pod_sch_mrplogicalnoSched MRP Req
pod_sch_datacharacter(80)noSchedule Data
pod_rlse_nbrintegernoNext Release ID
pod_ship_weeksintegernoShip Sched Weeks
pod_translt_daysdecimal(10)noTransport Days
pod_fsm_typecharacter(80)noFSM Type
pod_sd_patcharacter(30)noShip/Dlvy Pattern
pod_sd_timecharacter(30)noShip/Dlvy Time
pod_plan_daysintegernoPlan Sched Days
pod_plan_mthsintegernoPlan Sched Months
pod_firm_daysintegernoFirm Days
pod_raw_daysintegernoRaw Auth Days
pod_fab_daysintegernoFab Auth Days
pod_tax_usagecharacter(80)noTax Usage
pod_tax_inlogicalnoTax In
pod_sched_chgdlogicalnoScheduled
pod_pr_listcharacter(80)noPrice List
pod_dockcharacter(80)noDock
pod_pastduecharacter(30)noPast Due Logic
pod_drp_refcharacter(80)noDRP Ref
pod_tax_envcharacter(30)noTax Environment
pod_crt_intdecimal(10)noCredit Terms Int
pod_translt_hrsdecimal(10)noTransport Hours
pod_sftylt_daysdecimal(10)noSafety Days
pod_sftylt_hrsdecimal(10)noSafety Hours
pod_fix_prlogicalnoFixed Price
pod_fr_listcharacter(80)noFreight List
pod_lot_nextcharacter(30)noNext Lot/Serial
pod_lot_rcptlogicalnoSingle Lot
pod_gradecharacter(30)noGrade
pod_expiredatenoExpire Date
pod_rctstatcharacter(80)noReceipt Status
pod_assaydecimal(10)noAssay %
pod_rctstat_activelogicalnoActive
pod_pricing_dtdatenoPricing Date
pod_pr_lst_tpintegernoERS Price List Option
pod_ers_optintegernoERS Option
pod_zero_sched_countdecimal(10)noZero Schedule Counter
pod__qadd02decimal(10)noQAD Field
pod__qadd03decimal(10)noQAD Field
pod_sod_lineintegernoPrimary SO Line
pod_so_statuscharacter(30)noSecondary SO Status
pod_sub_ship_datedatenoSubcontract Ship
pod_sub_typecharacter(80)noSubcontract Type
pod_subcharacter(80)noPur Sub-Acct
pod_wip_lotsercharacter(30)noLot/Serial
pod_pjs_lineintegernoProject Line
pod_consignmentlogicalnoConsignment
pod_max_aging_daysintegernoMaximum Aging Days
pod_multi_due_dateslogicalnoMulti Due Dates
pod_domaincharacter(8)yesDomain
oid_pod_detdecimal(10)no
pod__qadd04decimal(10)noQAD Field
pod__qadt01dateno
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tpo_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