project QadFinancials > class BDebtorEndUser > business logic query DebtorEndUserByAddress


Parameters


iiCompanyIdintegerCompany id
iiAddressIDinteger
iiDebtorEndUserIDDifferentFrointeger


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 namedata typedb fielddescription
tiAddress_IDintegerDebtorEndUser.Address_IDCity
tiDebtor_IDintegerDebtorEndUser.Debtor_IDCustomer Code
tiDebtorEndUser_IDintegerDebtorEndUser.DebtorEndUser_IDRecord ID
tcDebtorEndUserCodecharacterDebtorEndUser.DebtorEndUserCodeEnd 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