project QadFinancials > class BMfgPurchaseVoucherHist > dataset BMfgPurchaseVoucherHist

class dataset

object identification

primary key
vph_domain
vph_ref
vph_pvo_id
vph_pvod_id_line
alternate key
oid_vph_hist

table tvph_hist


field namedata typemnd.description
vph_refcharacter(80)noVoucher
vph__qadc02character(80)no
vph__qadi01integerno
vph_nbrcharacter(80)noPO Nbr
vph_curr_amtdecimal(10)noCurrency Amount
vph_inv_costdecimal(10)noInvoice Cost
vph_inv_qtydecimal(10)noInvoice Qty
vph_inv_datedatenoInvoice Date
vph_user1character(80)noUfld1
vph_user2character(80)noUfld2
vph_avg_postcharacter(30)noPost To
vph_acctcharacter(80)noAccount
vph_cccharacter(30)noCost Ctr
vph_amtdecimal(10)noAmount
vph_elementcharacter(80)noCost Element
vph__qadc01character(80)no
vph_projectcharacter(80)noProject
vph_costadj_acctcharacter(80)noCost Adj Acct
vph_costadj_subcharacter(80)noCost Adj Sub
vph_costadj_cccharacter(30)noCost Adj CC
vph_dscr_acctcharacter(80)noInventory Dscr Acct
vph_dscr_subcharacter(80)noInventory Dscr Sub-Acct
vph_dscr_cccharacter(30)noInventory Dscr CC
vph_subcharacter(80)noSub-Account
vph_adj_invlogicalnoInventory/Variance
vph_adj_wiplogicalnoWIP/Variance
vph_adj_amtdecimal(10)noCost Adjustment
vph_dscr_amtdecimal(10)noCost Discrepancy
vph_cf_adj_amtdecimal(10)noConfirmed Adjustment
vph_cf_dscr_amtdecimal(10)noConfirmed Discrepancy
vph_adj_prv_cstdecimal(10)noPrevious Cost
vph_qoh_at_adjdecimal(10)noQOH at adjustment
vph_pvo_idintegernoPending Voucher ID
vph_pvod_id_lineintegeryesLine
vph_domaincharacter(8)yesDomain
oid_vph_histdecimal(10)no
vph_cinvoice_idintegernoInvoice ID
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