project QadFinancials > class BDebtor > business logic query DebtorForSSMProf


Parameters


iiCompanyIdintegerCompany id
iiMasterSharedSetIdinteger
iiRedundantSharedSetIdinteger


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 namedata typedb fielddescription
tiDebtorMasterSharedSet_IDintegerDebtor2.SharedSet_IDLink to SharedSet
tcMasterDebtorCodecharacterDebtor2.DebtorCodeA 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_IDintegerProfileLink2.SharedSet_IDLink to SharedSet
tcProfileCodecharacterProfile.ProfileCodeA code (maximum 20 characters) that identifies a profile.
tcRedundantDebtorCodecharacterDebtor.DebtorCodeA 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_IDintegerDebtor.SharedSet_IDLink to SharedSet


Internal usage


QadFinancials
method BSharedSetMerge.MergeValidateLoadProfDataDebtor