business logic query DebtorEndUserByDebtorByAddress

Parameters

iiAddressID	integer
ilDebtorEndUserIsShipto	logical
ilDebtorEndUserIsDebtor	logical
icDebtorShipToCode	character
iiDebtorID	integer
iiCompanyId	integer	Company id

query condition

each DebtorEndUser where

DebtorEndUser.SharedSet_Id = vi_DEBTOR_sharedset(iiCompanyId) AND
DebtorEndUser.Debtor_ID = iiDebtorID AND
DebtorEndUser.Address_ID = iiAddressID AND
DebtorEndUser.DebtorEndUserIsDebtor = ilDebtorEndUserIsDebtor AND
DebtorEndUser.DebtorEndUserIsShipTo = ilDebtorEndUserIsShipto AND
DebtorEndUser.DebtorEndUserCode <> icDebtorShipToCode

query resultset tqDebtorEndUserByDebtorByAddress

field name	data type	db field	description
tiAddress_ID	integer	DebtorEndUser.Address_ID	City
tiDebtor_ID	integer	DebtorEndUser.Debtor_ID	Customer Code
tiDebtorEndUser_ID	integer	DebtorEndUser.DebtorEndUser_ID	Record ID
tcDebtorEndUserCode	character	DebtorEndUser.DebtorEndUserCode	End user code(maximum 8 characters).
	api annotation:		If you select Link to Customer or Link to Ship-To Address, the End User Code field is filled with the value you specify for the customer or ship-to address./ Otherwise the system automatically generates a number for the record based on the sequence defined in End User Autonumber Create.
tlDebtorEndUserIsDebtor	logical	DebtorEndUser.DebtorEndUserIsDebtor	Indicate whether you select Link to Customer.Select this field if you want to define the customer entered in the field "tcDebtorCode" as an end user.
	api annotation:		Value for this field defaults to false.
tlDebtorEndUserIsShipTo	logical	DebtorEndUser.DebtorEndUserIsShipTo	Indicate whether you select Link to Ship-to Address. Select this field if you want to enter a shipto associated with the customer and define the ship-to as an end user.
	api annotation:		Value for this field defaults to false.

Internal usage

QadFinancials

method BDomain.AdditionalUpdatesReplication
method BMfgEndUser.MaintainDataBusinessRelation