project QadFinancials > class BMfgSite > business logic query SiteForCompany
Parameters
| icSite | character | Site |
| icDomain | character | |
| iiCompanyId | integer | Company 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 name | data type | db field | description |
|---|
| tiCompany_ID | integer | Company.Company_ID | Record ID |
| tcCompanyCode | character | Company.CompanyCode | Entity Code |
| tcCompanyDomain | character | Company.CompanyDomain | Domain |
| tiDomain_ID | integer | Company.Domain_ID | Domain |
| tcsi_domain | character | si_mstr.si_domain | Domain |
| tcsi_site | character | si_mstr.si_site | Site |
Internal usage
QadFinancials