project QadFinancials > class BCompany > business logic query CompanyByCodeCurrActiveID
Description
Show company information based on code, ID, active flag and currency.
Parameters
| iiCompanyId | integer | Company id |
| icCompanyCode | character | CompanyCode: condition uses 'MATCHES' |
| ilCompanyIsActive | logical | Company Is Active |
| icCurrencyID | character | Currency ID |
query condition
each Company where
Company.Company_ID = iiCompanyId AND
Company.CompanyCode matches icCompanyCode AND
Company.CompanyIsActive = ilCompanyIsActive
each CompanyProperty (inner-join) where
CompanyProperty.Company_Id = iiCompanyId AND
CompanyProperty.Company_ID = Company.Company_ID AND
CompanyProperty.Currency_ID = icCurrencyID
first Currency (inner-join) where
Currency.Currency_ID = CompanyProperty.Currency_ID AND
first Domains (inner-join) where
Domains.Domain_ID = Company.Domain_ID AND
query sort order
Company.CompanyCode (ascending)
query resultset tqCompanyByCodeCurrActiveID
| field name | data type | db field | description |
|---|
| tcCompanyCode | character | Company.CompanyCode | Entity Code |
| tiCompany_ID | integer | Company.Company_ID | Record ID |
| tlCompanyIsActive | logical | Company.CompanyIsActive | Active |
| tcLocalisationCode | character | Company.LocalisationCode | When running any business component of the application, the framework will always lookup the localisation code of current company and if filled, will look for a localisation of that type for the business component, and if found will run that localisation in stead of the standard version of the business component. |
| tcCurrencyCode | character | Currency.CurrencyCode | Currency Code |
| tcDomainCode | character | Domains.DomainCode | Domain |
| tlDomainIsActive | logical | Domains.DomainIsActive | Active |
| tiDomain_ID | integer | Domains.Domain_ID | Record ID |
| tiLng_ID | integer | Domains.Lng_ID | Language |
| tiCompanyProperty_ID | integer | CompanyProperty.CompanyProperty_ID | Record ID |
| tiCurrency_ID | integer | CompanyProperty.Currency_ID | Base Currency |
Internal usage
QadFinancials