project QadFinancials > class BMfgERSMaster > business logic query ERSMasterByVendSiteItem
Parameters
icDomain | character | |
icVendor | character | |
icSite | character | |
icItem | character | |
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 name | data type | db field | description |
tcers_domain | character | ers_mstr.ers_domain | Domain |
tiers_opt | integer | ers_mstr.ers_opt | ERS Option |
tcers_part | character | ers_mstr.ers_part | Item Number |
tiers_pr_lst_tp | integer | ers_mstr.ers_pr_lst_tp | ERS Price List Option |
tcers_site | character | ers_mstr.ers_site | Site |
tcers_vend | character | ers_mstr.ers_vend | Supplier |
Internal usage
QadFinancials