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
| iiCompanyId | integer | Company id |
| iiBusinessRelationID | integer | |
| iiNotDomainID | integer | |
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 name | data type | db field | description |
|---|
| tiBusinessRelation_ID | integer | Debtor.BusinessRelation_ID | Business Relation |
| tiDebtor_ID | integer | Debtor.Debtor_ID | Record ID |
| tiDomain_ID | integer | DomainSharedSet.Domain_ID | Domain |
| tiDomainSharedSet_ID | integer | DomainSharedSet.DomainSharedSet_ID | Record ID |
| tiSharedSet_ID | integer | SharedSet.SharedSet_ID | Record ID |
Internal usage
QadFinancials