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