project BLF > class BCompany > business logic query CompanyByDomainActive
Parameters
iiCompanyId | integer | Company id |
iiDomainId | integer | |
ilCompanyIsActive | logical | |
query condition
each Company where
Company.Company_Id = iiCompanyId AND
Company.CompanyIsActive = ilCompanyIsActive AND
Company.Domain_ID = iiDomainId
first Domains (inner-join) where
Domains.Domain_ID = Company.Domain_ID AND
query resultset tqCompanyByDomainActive
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 | Company.Domain_ID | Domain |
tcDomainCode | character | Domains.DomainCode | Domain |
Internal usage
BLF
QadFinancials