project QadFinancials > class BMfgSite > business logic query SiteForCompany


Parameters


icSitecharacterSite
icDomaincharacter
iiCompanyIdintegerCompany id


query condition


  each si_mstr where
si_mstr.si_domain = icDomain AND
si_mstr.si_site = icSite

      first en_mstr (inner-join) where
en_mstr.en_domain = si_mstr.si_domain AND
en_mstr.en_entity = si_mstr.si_entity AND

          first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.CompanyCode = en_mstr.en_entity AND


query resultset tqSiteForCompany


field namedata typedb fielddescription
tiCompany_IDintegerCompany.Company_IDRecord ID
tcCompanyCodecharacterCompany.CompanyCodeEntity Code
tcCompanyDomaincharacterCompany.CompanyDomainDomain
tiDomain_IDintegerCompany.Domain_IDDomain
tcsi_domaincharactersi_mstr.si_domainDomain
tcsi_sitecharactersi_mstr.si_siteSite


Internal usage


QadFinancials
method BAPMatchingReport.GetBusinessFields
method BAPMatchingReport.UnmatchedReceipt
method BCInvoiceAPMatching.ApiEDICInvoiceAPMatchingImport