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