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