project QadFinancials > class BMfgERSMaster > business logic query ERSMasterByVendSiteItem


Parameters


icDomaincharacter
icVendorcharacter
icSitecharacter
icItemcharacter


query condition


  each ers_mstr where
ers_mstr.ers_domain = icDomain AND
ers_mstr.ers_part = icItem AND
ers_mstr.ers_site = icSite AND
ers_mstr.ers_vend = icVendor


query resultset tqERSMasterByVendSiteItem


field namedata typedb fielddescription
tcers_domaincharacterers_mstr.ers_domainDomain
tiers_optintegerers_mstr.ers_optERS Option
tcers_partcharacterers_mstr.ers_partItem Number
tiers_pr_lst_tpintegerers_mstr.ers_pr_lst_tpERS Price List Option
tcers_sitecharacterers_mstr.ers_siteSite
tcers_vendcharacterers_mstr.ers_vendSupplier


Internal usage


QadFinancials
method BERSProcessor.GetERSPendingVouchersERSOpt
method BERSProcessor.StopAllQueries