project BLF > class BCompany > business logic query CompanySSByIds

Description

CompanySSByIds


Parameters


iiCompanyIdintegerCompany id
iiCompanySharedSetIdintegerCompanySharedSetId
iiSharedSetIdintegerSharedSetId


query condition


  each CompanySharedSet where
CompanySharedSet.Company_Id = iiCompanyId AND
CompanySharedSet.CompanySharedSet_ID = iiCompanySharedSetId AND
CompanySharedSet.SharedSet_ID = iiSharedSetId

      first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = CompanySharedSet.Company_ID AND

      first SharedSet (inner-join) where
SharedSet.SharedSet_ID = CompanySharedSet.SharedSet_ID AND


query resultset tqCompanySSByIds


field namedata typedb fielddescription
tiCompany_IDintegerCompanySharedSet.Company_IDEntity
tcCompanyCodecharacterCompany.CompanyCodeEntity Code
tiCompanySharedSet_IDintegerCompanySharedSet.CompanySharedSet_IDRecord ID
tiSharedSet_IDintegerCompanySharedSet.SharedSet_IDShared Set
tcSharedSetCodecharacterSharedSet.SharedSetCodeShared Set Code
tcSharedSetTypeCodecharacterSharedSet.SharedSetTypeCodeShared Set Type


Internal usage


QadFinancials
method BBankNumber.CalculateCompanySharedSet
method BCOAMask.ReadSetupForCompany
method BGL.ValBankNumberRef
method BGLReport.GetBusinessFields4