project QadFinancials > class BCompanyGroup > business logic query CyGroupCompanyByGrpCy
Description
retrieve members from an entity groups
Parameters
| iiCompanyId | integer | Company id |
| iiGroupID | integer | |
| icGroupCode | character | |
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 name | data type | db field | description |
|---|
| tiCompany_ID | integer | Company.Company_ID | Record ID |
| tcCompanyCode | character | Company.CompanyCode | Entity Code |
| tcCompanyDescription | character | Company.CompanyDescription | Entity Description |
| tiCyGroup_ID | integer | CyGroup.CyGroup_ID | Record ID |
| tcCyGroupCode | character | CyGroup.CyGroupCode | Company Group |
| tcCyGroupDescription | character | CyGroup.CyGroupDescription | Description |
| tlCyGroupIsActive | logical | CyGroup.CyGroupIsActive | Active |
Internal usage
QadFinancials