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