project BLF > class BDomain > business logic query DomainsForCompanies
Description
get all companies of a domain
Parameters
| iiDomainId | integer | |
| icDomainCode | character | |
| iiCompanyId | integer | Company id |
query condition
each Domains where
Domains.Domain_ID = iiDomainId and
Domains.DomainCode = icDomainCode
each Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Domain_ID = Domains.Domain_ID AND
query resultset tqDomainsForCompanies
| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | Company.Company_ID | Record ID |
| tcCompanyCode | character | Company.CompanyCode | Entity Code |
| tcCompanyDescription | character | Company.CompanyDescription | Entity Description |
| tiDomain_ID | integer | Domains.Domain_ID | Record ID |
| tcDomainCode | character | Domains.DomainCode | Domain |
| tiPrimaryCompany_ID | integer | Domains.PrimaryCompany_ID | Primary Entity |
Internal usage
BLF
QadFinancials