project QadFinancials > class BDebtor > business logic query DebtorForBusinessRelationCheck

Description

Check if the debtor is used in a different domain then the one we pass with the parameter. Make sure to keep iiCompanyID = 0.


Parameters


iiCompanyIdintegerCompany id
iiBusinessRelationIDinteger
iiNotDomainIDinteger


query condition


  each Debtor where
Debtor.SharedSet_Id = vi_DEBTOR_sharedset(iiCompanyId) AND
Debtor.BusinessRelation_ID = iiBusinessRelationID

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

          each DomainSharedSet (inner-join) where
DomainSharedSet.SharedSet_ID = SharedSet.SharedSet_ID AND
DomainSharedSet.Domain_ID <> iiNotDomainID


query resultset tqDebtorForBusinessRelationCheck


field namedata typedb fielddescription
tiBusinessRelation_IDintegerDebtor.BusinessRelation_IDBusiness Relation
tiDebtor_IDintegerDebtor.Debtor_IDRecord ID
tiDomain_IDintegerDomainSharedSet.Domain_IDDomain
tiDomainSharedSet_IDintegerDomainSharedSet.DomainSharedSet_IDRecord ID
tiSharedSet_IDintegerSharedSet.SharedSet_IDRecord ID


Internal usage


QadFinancials
method BBusinessRelation.ValidateComponentSystemOrDomain