project BLF > class BCompany > business logic query CompanyByCodeActiveID

Description

CompanyByCodeActiveID; query with parameters on Code, ID and Active


Parameters


iiCompanyIdintegerid
icCompanyCodecharacterCompanyCode: condition uses 'MATCHES'
ilCompanyIsActivelogicalActive


query condition


  each Company where
Company.Company_ID = iiCompanyId AND
Company.CompanyCode matches icCompanyCode AND
Company.CompanyIsActive = ilCompanyIsActive

      first Domains (inner-join) where
Domains.Domain_ID = Company.Domain_ID AND

          first Lng (inner-join) where
Lng.Lng_ID = Domains.Lng_ID AND


query sort order


Company.CompanyCode (ascending)


query resultset tqCompanyByCodeActiveID


field namedata typedb fielddescription
tiDomain_IDintegerDomains.Domain_IDRecord ID
tcDomainCodecharacterDomains.DomainCodeDomain
tlDomainIsActivelogicalDomains.DomainIsActiveActive
tcDomainTimeZonecharacterDomains.DomainTimeZoneTime Zone
tiLng_IDintegerDomains.Lng_IDLanguage
tcLngCodecharacterLng.LngCodeLanguage Code
tlLngIsInstalledlogicalLng.LngIsInstalledSet to true when the translation resource file for this language is loaded.
tcLocalisationCodecharacterCompany.LocalisationCodeWhen 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.
tcCompanyCodecharacterCompany.CompanyCodeEntity Code
tlCompanyIsActivelogicalCompany.CompanyIsActiveActive
tiCompany_IDintegerCompany.Company_IDRecord ID


Internal usage


BLF
method BScanDaemonQueue.CreateScanDaemonQueue
method Session.CheckLogin
method Session.SwitchCompany

QadFinancials
method BVATExportListing.ExportFormatting723
method BVATExportListing.ExportFormatting725
method BVATReport.VATYearlyListingBE