project QadFinancials > class BDomain > business logic query DomainForCompanyDomain
Description
Query on Domain and Company with filtering on ID and Code for both objects
Parameters
| iiDomainID | integer | |
| icDomainCode | character | |
| iiCompanyID | integer | |
| icCompanyCode | character | |
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
Company.CompanyCode = icCompanyCode
query resultset tqDomainForCompanyDomain
| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | Company.Company_ID | Record ID |
| tcCompanyCode | character | Company.CompanyCode | Entity Code |
| tlCompanyIsActive | logical | Company.CompanyIsActive | Active |
| tiDomain_ID | integer | Domains.Domain_ID | Record ID |
| tcDomainCode | character | Domains.DomainCode | Domain |
| tlDomainIsActive | logical | Domains.DomainIsActive | Active |
Internal usage
QadFinancials