project BLF > class BCompany > business logic query CompanyByCompanyCodeDomainCode
Parameters
| iiCompanyId | integer | Company id |
| icCompanyCode | character | |
| icDomainCode | character | |
| iiDomainId | integer | |
| ilCompanyIsActive | logical | |
query condition
each Company where
Company.Company_Id = iiCompanyId AND
Company.CompanyCode = icCompanyCode AND
Company.Domain_ID = iiDomainId AND
Company.CompanyIsActive = ilCompanyIsActive
first Domains (inner-join) where
Domains.Domain_ID = Company.Domain_ID AND
Domains.DomainCode = icDomainCode
query resultset tqCompanyByCompanyCodeDomainCode
| 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 |
| tlCompanyIsActive | logical | Company.CompanyIsActive | Active |
| 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