project QadFinancials > class BDebtorEndUser > business logic query DebtorEndUserByAddress

Parameters

iiCompanyId	integer	Company id
iiAddressID	integer
iiDebtorEndUserIDDifferentFro	integer

query condition

each DebtorEndUser where

DebtorEndUser.SharedSet_Id = vi_DEBTOR_sharedset(iiCompanyId) AND
DebtorEndUser.Address_ID = iiAddressID AND
DebtorEndUser.DebtorEndUser_ID <> iiDebtorEndUserIDDifferentFro

query resultset tqDebtorEndUserByAddress

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.

Internal usage

QadFinancials

method BBusinessRelation.ValidateComponentAddressDelete
method BBusinessRelation.ValidateComponentDelete
method BDebtorEndUser.Calculate
method BDebtorEndUser.ValidateComponent
method BDebtorEndUser.ValidateComponentUpdateAllSharedEndusers