project QadFinancials > class BDebtor > business logic query DebtorForSharedSetMerge

Description

Get content of passed RedundantSharedSet and equivalent element by DebtorCode in passed MasterSharedSet.


Parameters


iiCompanyIdintegerCompany id
iiRedundantSharedSetIdinteger
iiMasterSharedSetIdinteger


query condition


  each Debtor where
Debtor.SharedSet_Id = iiRedundantSharedSetId

      first Debtor2 (inner-join) where
Debtor2.DebtorCode = Debtor.DebtorCode AND
Debtor2.SharedSet_ID = iiMasterSharedSetId


query resultset tqDebtorForSharedSetMerge


field namedata typedb fielddescription
tcDebtorCodecharacterDebtor.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.
tiMasterDebtor_IDintegerDebtor2.Debtor_IDRecord ID
tiMasterSharedSet_IDintegerDebtor2.SharedSet_IDLink to SharedSet
tiRedundantDebtor_IDintegerDebtor.Debtor_IDRecord ID
tiRedundantSharedSet_IDintegerDebtor.SharedSet_IDLink to SharedSet


Internal usage


QadFinancials
method BSharedSetMerge.MergeInitLoadSharedSetData