business logic query DebtorEndUserForDelete

Parameters

iiiDebtorEndUserID	integer	Company id
iiCompanyID	integer
iiiiAddressID	integer

query condition

each DebtorEndUser where

DebtorEndUser.SharedSet_Id = vi_DEBTOR_sharedset(iiCompanyId) AND
DebtorEndUser.Address_ID = iiiiAddressID AND
DebtorEndUser.DebtorEndUser_ID <> iiiDebtorEndUserID

first Address (inner-join) where

Address.Address_ID = DebtorEndUser.Address_ID AND

query resultset tqDebtorEndUserForDelete

field name	data type	db field	description
tiBusinessRelation_ID	integer	Address.BusinessRelation_ID	Link to BusinessRelation
tiAddress_ID	integer	DebtorEndUser.Address_ID	City
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.
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(DebtorEndUser),rowid(Address)

Internal usage

QadFinancials

method BDebtorEndUser.AdditionalUpdates