project QadFinancials > class BCompany > business logic query CompanyByCompanyCode
Description
CompanyByCompanyCode:
Simple query that only returns a few main fields of table company based upon the code
Parameters
| icCompanyCode | character | Entity Code |
| iiCompanyId | integer | Company id |
query condition
each Company where
Company.Company_Id = iiCompanyId AND
Company.CompanyCode can-do icCompanyCode
query resultset tqCompanyByCompanyCode
| 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 |
| tcCompanyDomain | character | Company.CompanyDomain | Domain |
| tiDomain_ID | integer | Company.Domain_ID | Domain |
Internal usage
QadFinancials