project QadFinancials > class BCompanyGroup > business logic query CyGroupCompanyByGrpCy

Description

retrieve members from an entity groups


Parameters


iiCompanyIdintegerCompany id
iiGroupIDinteger
icGroupCodecharacter


query condition


  each CyGroup where
CyGroup.CyGroup_ID = iiGroupID AND
CyGroup.CyGroupCode = icGroupCode

      each CyGroupCompany (inner-join) where
CyGroupCompany.Company_Id = iiCompanyId AND
CyGroupCompany.CyGroup_ID = CyGroup.CyGroup_ID AND

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


query resultset tqCyGroupCompanyByGrpCy


field namedata typedb fielddescription
tiCompany_IDintegerCompany.Company_IDRecord ID
tcCompanyCodecharacterCompany.CompanyCodeEntity Code
tcCompanyDescriptioncharacterCompany.CompanyDescriptionEntity Description
tiCyGroup_IDintegerCyGroup.CyGroup_IDRecord ID
tcCyGroupCodecharacterCyGroup.CyGroupCodeCompany Group
tcCyGroupDescriptioncharacterCyGroup.CyGroupDescriptionDescription
tlCyGroupIsActivelogicalCyGroup.CyGroupIsActiveActive


Internal usage


QadFinancials
method BConCheck.GetCompaniesOfCompanyGroup
method BMultiCyProcessor.ProcessRequest
method BMultiCyProcessor.ProcessRequestAsyncInit
method BPeriod.MultiCompanyVerifications
method BRevaluation.MultiCompanyVerificationPost
method BRevaluation.MultiCompanyVerificationSimulate
method Session.GetEntityGroups