project QadFinancials > class BCorporateGroup > business logic query CorporateGroupPrim

Description

This query is used to convert the Corporate Group ID into the corresponding Corporate Group Code and vice-versa (Code is also a related-key-business-field in this query).

Parameters


iiCorporateGroup_IDintegerCorporate Group ID is a related key buisness field of the Corporate Group Code. It is used to identify the Corporate Group and is only used in the business logic code and never on the UI (which displays the corresponding Corporate Group Code instead).
icCorporateGroupCodecharacterCorporate Group Code is the Corporate Group Name. It is displayed on the UI as an identifier instead of the ID as it is more understandable to the end user.

query condition


  each CorporateGroup where
CorporateGroup.CorporateGroup_ID = iiCorporateGroup_ID AND
CorporateGroup.CorporateGroupCode = icCorporateGroupCode

query resultset tqCorporateGroupPrim


field namedata typedb fielddescription
tiCorporateGroup_IDintegerCorporateGroup.CorporateGroup_IDRecord ID
tcCorporateGroupCodecharacterCorporateGroup.CorporateGroupCodeGroup Name

Internal usage


QadFinancials
method BAccountingInterface.FillProDsEntity
method BBusinessRelation.ApiLoadBusinessRelation
method BBusinessRelation.ApiLoadBusinessRelationCalcCorporateGroupCode
method BCorporateGroup.DataLoadByInput
method BOpenItemAdjustment.OIAdjNewOpenItem
read related business field(s) on tBusinessRelation.CorporateGroup_ID
ApiGetAlternateKeyValues
validate related business field(s) on tBusinessRelation.CorporateGroup_ID