business logic query DebtorForSSMProf

Parameters

iiCompanyId	integer	Company id
iiMasterSharedSetId	integer
iiRedundantSharedSetId	integer

query condition

each Debtor where

Debtor.SharedSet_Id = iiRedundantSharedSetId

each ProfileLink1 (inner-join) where

ProfileLink1.ProfileLinkObject_ID = Debtor.Debtor_ID AND
ProfileLink1.SharedSet_ID = Debtor.SharedSet_ID

first Profile (inner-join) where

Profile.Profile_ID = ProfileLink1.Profile_ID AND

each ProfileLink2 (inner-join) where

ProfileLink2.Profile_ID = Profile.Profile_ID AND
ProfileLink2.SharedSet_ID = iiMasterSharedSetId

first Debtor2 (inner-join) where

Debtor2.Debtor_ID = ProfileLink2.ProfileLinkObject_ID AND
Debtor2.SharedSet_ID = ProfileLink2.SharedSet_ID AND
Debtor2.DebtorCode <> Debtor1.DebtorCode

query resultset tqDebtorForSSMProf

field name	data type	db field	description
tiDebtorMasterSharedSet_ID	integer	Debtor2.SharedSet_ID	Link to SharedSet
tcMasterDebtorCode	character	Debtor2.DebtorCode	A code (maximum eight characters) that identifies a customer. If the code you specify matches an existing supplier code, a warning message displays. You can choose to ignore the warning, and create the record. However, when a supplier and customer share the same code, they must reference the same business relation.
	api annotation:		If you leave the Customer Code field blank, the system automatically generates a number for the record based on the sequence defined in Customer Autonumber Create.
tiMasterSharedSet_ID	integer	ProfileLink2.SharedSet_ID	Link to SharedSet
tcProfileCode	character	Profile.ProfileCode	A code (maximum 20 characters) that identifies a profile.
tcRedundantDebtorCode	character	Debtor.DebtorCode	A code (maximum eight characters) that identifies a customer. If the code you specify matches an existing supplier code, a warning message displays. You can choose to ignore the warning, and create the record. However, when a supplier and customer share the same code, they must reference the same business relation.
	api annotation:		If you leave the Customer Code field blank, the system automatically generates a number for the record based on the sequence defined in Customer Autonumber Create.
tiRedundantSharedSet_ID	integer	Debtor.SharedSet_ID	Link to SharedSet

Internal usage

QadFinancials

method BSharedSetMerge.MergeValidateLoadProfDataDebtor