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